Grand Slam Software, LLC (January 2009 - Present)
Owner / iPhone Developer
Developed Baseball TryoutTracker and Baseball HittingTracker currently available on the iPhone App Store. The applications were both developed using the Apple iPhone SDK. The TryoutTracker uses a local SQLite database to store information and allows users to track players skills and sort the players based on their rankings. The HittingTracker uses a local SQLite database to store information and allows users to track very detailed hitting statistics. Currently working on more Baseball applications for the iPhone which utilize SQLite and web services.
Casa Mechanical Services (August 2006 - Present)
Senior Analyst / Developer / IT Lead
Job responsibilities include communication with department managers and owners to determine ways to improve productivity and efficiency through integration of disparate systems, new technology and software development. The internal applications are developed in C# .NET Web Services, C# .NET Windows Mobile and Microsoft Access using a Microsoft SQL Server database.
Systems Implemented
Created ID badges for everyone in the company for use with our custom developed touchscreen time clock kiosk and for checking out materials in the warehouse. Developed integration between custom company software and Microsoft Great Plains to transfer invoices, receipts and customers between the two systems using Great Plains integration manager and Microsoft SQL Server stored procedures. Developed integration with custom company software, Google and Ublip GPS navigation devices using .NET web services and Microsoft Access to display drive summary information and maps using company software. Developed integration with FuelMaster RFID system to import exported fuel usage data into a Microsoft SQL Server database using C# .NET services. Developed web application designed to be used by mobile phones for the Service Department employees on call after hours to query company data when answering customer questions using ASP .NET and C# .NET web services. Developed reverse auctioning system in Adobe Flex. The application uses web services to communicate with the company database and allows vendors to submit quotes on items we are looking to purchase. Once the vendors submit their online quotes the purchasing administrator uses internally developed software to review the quotes and pick the winner. A purchase order is created and the inventory system is updated with the new pricing and source vendor information.
.NET Development
Identified a need to have an automated inventory system in the warehouse for counts and checking out materials. Developed a handheld inventory application using C# .NET for Windows Mobile using Symbol MC9090-G scan gun devices. The application allows the warehouse to checkout materials to workers by scanning their badge bar code, the bar code on their printed work order and the bar code for the inventory item. Some items are checked out using the scan guns and some items are checked out at fixed workstations using a C# client application. The workstation client application mimics the interface of the application written for the mobile scan guns. Both applications access the same web services in order to retrieve and update the company database. The inventory application also allows the warehouse to return items. Counts are performed with the scan guns using lists created by the company software.
RFD and Associates, Inc. (March 1997 - August 2006)
.NET Development
Developed web based remote file management tool. The ASP. NET, C#.NET application allows users to create remote file storage areas used to store files uploaded from their local hard drive. The file storage areas have security settings allowing users to make their storage areas public, private or only viewable by specific security groups.
Developed electronic forms application that allows administrators to create data driven forms that are downloaded to a tablet PC. The C#.NET Windows application allows users to answer the questions and upload the completed forms to a C#.NET web service to update the master database.
Developed customer support system plug-in in C#.NET to access web services to manage issues across multiple projects. The plug-in allows customers to enter issues that are automatically transferred to internal development based on status changes within the issue. In addition to accessing web services the plug-in accesses MS SQL Server database stored procedures.
Inventory and Fixed Asset Mobile/Wireless Development
Designer and developer of commercial handheld inventory and fixed asset software. Technologies used include XML, Pocket PC 2002, MSMQ, Microsoft SQL CE, embedded Visual Basic and Visual Studio .net. The first version communicated via MSMQ to an application server API to transfer data to and from the handheld device. The second version written in .net communicates via HTTP to transfer data.
Purchasing, Inventory and Fixed Asset Web Development
Developed thin client web-based version of an existing commercial client/server application over several years. JBuilder was used to develop Java servlets that run on a Tomcat web server. The Java servlets serve as the communication layer between the web browser client and the business logic application server. The application server is developed in PowerBuilder and consists of a load balancer, job scheduler and business logic server. The Java servlets communicate directly with the load balancer to determine which application server is available and will automatically load a new server if needed. All reports generated by the application server are converted to PDF files for viewing in a web browser.
Client/Server Software Development
Technical lead for design and development of a commercial procurement system written in PowerBuilder 5.0, 6.5, 7.0 using PFC. Used PowerDesigner for data modeling requirements and Database Script Generation. Developed using PFC (PowerBuilder Foundation Classes), PFE extensions and a RFD Framework Extension Layer. The application consists of 70 PBLs for a total of 45 mb of source.
The following advanced features in PowerBuilder have been used within the product: non-visual objects were created for business class objects, query mode was used for reports and dynamic tree view list generation, drag and drop was used to link documents to one another, tab objects were used to logically group data on multiple windows, dynamic datawindow creation was used to create a spreadsheet style datawindow with a variable number of columns and PSRs were used to allow custom report modifications in InfoMaker and the ability to merge data from different databases.
Provided PowerBuilder Design and Development for the MAXX system at American Cancer Society. This system tracks donor contributions and information that is replicated from regional Sybase servers to a DB2 platform at ACS headquarters on a nightly schedule. Lead developer for delayed reporting system used in MAXX. Architectural lead for the development of MAXX and MAXX Reports using the PowerBuilder Foundation Classes (PFC). Responsible for diagramming and maintaining the Object Hierarchy for MAXX and MAXX Reports. This involved identifying improper use of inheritance, duplicate objects, duplicate functionality and improvements in inheritance that could be made through function overloading. Installed and maintained version control system using ObjectCycle.
Texas Association of School Boards (TASB)
Fixed numerous bugs in an existing Active Server Pages application. Once the bugs were fixed many new features were added using VBScript, Javascript and HTML. Added a purchasing module to allow users to create Requisitions, have them approved, and create the Purchase order that is either e-mailed, faxed or EDIed to the vendor. Added maintenance screens to maintain a new hierarchical security structure, approval routes and code tables.
Education Service Center Region 20
Developed an online time accounting system in Active Server Pages using VBScript, Javascript, HTML and DHTML. The system supports both Internet Explorer and Netscape and is used by both the PC and Macintosh systems. The system utilizes the ASP framework I developed to support multiple database platforms. Hundreds of users use the system regularly so the system caches information on both the client and server to enhance performance.
Other RFD Development
Developed RFD Active Server Pages framework for use with Windows NT and Internet Information Server. The framework is data driven, which makes it very customizable and maximizes code reuse by using multiple include files. There are currently two different applications being developed using the framework. The framework handles security and is written to improve performance for high volume web applications.
Developed PowerBuilder applications for the internet using Web.PB. Developed Requisition input prototype for BuySpeed on the web. The prototype involved creating a PowerBuilder framework for placing applications on the internet. The framework supports displaying and entering data using forms on the web and saving the data to an MS SQL Server 6.5, Sybase Adaptive Server and Sybase SQL Anywhere database. This framework was then used on a second Web.PB project that utilized frames, JavaScript and forms to enter data maintaining more than 20 database tables. Used Data Architect for data modeling requirements and Database Script Generation.
Developed RFD website and BuySpeed product website. Both websites incorporate JavaScript. Additionally, The BuySpeed website utilizes frames. Created all background and menu graphics using Paint Shop Pro. Both websites are maintained with FrontPage 98 and HomeSite.
Networking
Installed and maintained multiple NT Servers running MS SQL Server 6.5, Sybase Adaptive Server and Sybase SQL Anywhere. Documented installation and maintenance procedures to assist other consultants when installing or maintaining NT and database servers.
Cactus Ranch Elementary (July 2004 - August 2004)
Consultant / Volunteer
Donated time to develop a Point of Sale system for the Cactus Ranch Elementary PTA. The POS was developed in PowerBuilder 9 and was written to work without a database storing all data in local PSR files using uniquely generated IDs for filenames. The files are then later merged to create a consolidated list of all receipts. The application has handled over $20,000 in sales over the past year for the PTA. The system had to be developed to allow someone with zero training time to begin entering sales using order forms generated by the system.
Reliant Energy (August 1999 - October 2000)
Consultant
Migrated a FoxPro DOS based application to manage substation cable lists into PowerBuilder 6.5. Sole designer and developer of the new application based on the previous FoxPro application. One person remained to assist in understanding the purpose of the application. The application was broken down into its primary parts based on the existing source code and rebuilt into a more powerful and user friendly application while still providing the same level of functionality and reporting capabilities.
Sterling Information Group (April 1994 - February 1997)
PowerBuilder Development
Worked as the lead PowerBuilder developer for a statewide purchasing system for a Texas state agency. The system is being developed utilizing MS/SQL Server 6.0 running under Windows NT 3.51. The system consists of 136 tables and 13 megabytes of PowerBuilder code.
Developed a PowerBuilder prototype for a semiconductor manufacturing planning and forecasting system. The prototype successfully demonstrated Sterling's PowerBuilder expertise, convincing them to hire Sterling over other consulting firms.
Provided ongoing PowerBuilder consulting support to numerous clients in the areas of application design, PowerBuilder standards and coding techniques, and technical support.
Responsible for the continued development of and enhancements to an internal PowerBuilder object library for use across all Sterling consulting engagements.
Performed PowerBuilder/Oracle enhancements on the Sales Incentive Accounting System (SALINAS) for a major computer manufacturer. Produced PowerBuilder reports (hard copy and queries) from a complex Oracle database.
Networking
Installed a functioning Microsoft network utilizing NT Server 3.5, Back Office, and Windows for Workgroups 3.11 for a local trade show.
Other Development Tools
Developed prototypes using Visual Basic to demonstrate the features of a system before developing it in PowerBuilder.
Performed the analysis and design of a Paradox-based insurance policy and renewal notice system for a state agency.
O-M-N-I Software (December 1994 - August 1996)
Internet Development
Lead developer of the O-M-N-I Internet Server. The O-M-N-I Internet Server is a commercial product currently composed of a very flexible and configurable World Wide Web server. Co-developer of the O-M-N-I BBS software for Windows. O-M-N-I BBS is a commercial product that enables system operators to develop a multimedia on-line system. The O-M-N-I Internet Server and O-M-N-I BBS work together to allow system operators to offer users multiple ways of accessing their system. Both products involved developing in Microsoft Visual Basic and Borland Delphi.
Strategic Database Systems, Austin, Texas (January 1994 - March 1994)
Database Designer and Programmer
Developed a company-wide database management system in FoxPro 2.5 for Windows, consolidating many different systems developed in dBase III for the Construction Industry Institute. The job involved working directly with the client on a daily basis and managing the growth, direction, billing rate and billing estimates of the project. The project was managed through an entire software cycle of design, development, testing, refinement, and demonstration.
Developed a multi-user accounting system in FoxPro 2.5 for Windows. The system tracked invoices, checks, clients, companies, and a chart of accounts.
Kaufman Associates (August 1993 - January 1994)
Systems Analyst
Developed applications using PowerBuilder, SQL Server and C. The PowerBuilder system developed was a multi-user, data entry environment. The system consisted of 106 tables and three megabytes of PowerBuilder code. The job involved working directly with the client on a daily basis and managing the growth and direction of the project.
Louis Robichaux (October 1992 - February 1993)
Database Designer and Programmer
Developed database management software to maintain records and print reports for a family-owned business. Work consisted primarily of programming in FoxPro 2.0 for MS-DOS.
Houston Lighting and Power (Summers 1989 - 1992)
Database Designer and Programmer
Developed a division-wide CAD management system. The job involved controlling the project through an entire software cycle of design, development, testing, refinement, and demonstration. Programming work consisted of developing Windows applications in FoxPro, C and C .