Experience Summary
25 Years programming experience. Resume follows: Bill First
bill@billfirst.net
EDUCATION
Webster University, St. Louis, MO - B. A., Computer Studies, 1984 4.0/4.0
Washington University, St. Louis, MO - Masters coursework in Computer Science Engineering. 1991-2
University of Missouri, St. Louis, MO - Chancellor’s Certificate on the Microcomputer, 1997
SUMMARY
• Microsoft Certification for .Net Web Applications, .Net Windows Applications.
• Ten years of Client/Server application development using SQL-Server, Visual Basic, and MS/Access.
• 3 years web development in the Microsoft .NET Framework, using Visual Studio
• & SQL Server
• Five years of web application development (using SQL-Server, ASP and IIS).
• Microsoft Certification for MS/Access. Brainbench Certifications for ASP & Access.
• Fifteen years of developing Windows/GUI applications using Visual Basic.
• Experienced in Healthcare, Distribution/Warehousing, Government, Banking, and Insurance industries.
• Proven skills in developing solutions for new development, production support and enhancements.
• Strong analytical and technical abilities, with over twenty-five years of PC consulting experience.
• Well-versed in project development life cycle and responsive to the needs of the user community.
VB6/VBA 6.0/VB Script MS / Access Oracle SQL Developer
SQL Navigator Oracle 11g ASP Net, , VB.Net, C#
MS/Office Visual Studio WinForms
SQL Server 2000, 2008 ASP HTML
Active Reports Reporting Services
EXPERIENCE
Consultant at Center for Effective Philanthropy – Cambridge, MA 5/11 – 9/11
• Functioned as Database Administrator for CEP while regular DBA was on maternity leave.
• Developed a database system for school/student surveys.
• Upgraded existing foundation/grantee survey system.
• Created illustrated user manual for DBA’s and other users of the foundation/grantee system.
• Programmed C# program upgrades for the running of statistical analyses for foundation/grantee survey system.
• Worked closely with all levels of management to develop user friendly products.
• Technologies used: SQL Server 2005 - 2008, .Net 3.0, SPSS, MS Access
Consultant at Massachusetts General Hospital / Partners – Boston, MA 3/10 – 3/11
• Completed the development of two systems for the IT department involving Medical Records systems.
• Developer of a database system for the Practice Improvement Division.
• Designed, coded, tested, documented, installed and trained user base.
• Analyzed, design, diagram and present to staff in meetings and presentations.
• Resolve problems and come up with a final design with consensus . Also working with SQL-Server and Access linked tables. Developed – Queries, tables, constraints, normalized database bringing in linked tables from various databases and creating new database/tables to resolve all data relational issues.
• Programmed GUI solutions for Practice Improvement – design meetings with stakeholders.
• Developed Windows application in VBA, Access and SQL-Server for Practice Improvement projects, data entry, tracking and reporting.
Consultant at Massachusetts Registry of Motor Vehicles – Boston, MA 4/08 – 7/09
• On call software programmer. Support and maintenance programming. Work with full range of technologies from Fox and VB5 to web development in .Net/Visual Studio 2008. SQL-Server, Oracle 11g and MS Access.
• Ability to quickly analyze problems and come up with solutions to respond to registry problems. Also working familiarity with Quest Navigator, SQL-Developer – Queries, triggers, constraints, Crystal Reports.
• Programmed solutions for Logi, Crash Systems, KTA, VISITS, Sweepers, Application Security, CJIS, Operating under the Influence System(OUI), USD, etc., etc. Virtually all of the PC based systems at the RMV
• Developed .Net Windows application in VS2005 for on-call database UI, rewrote for web.
Consultant at Boston Medical Center HealthNet Plan, Inc. – Boston, MA 1/08 – 3/08
• .Net 2.0 Conversion of HR Timesheet system to C#.Net / SQL Server 2000 on company Intranet. Conversion of legacy system written in classic ASP, with JScript, JavaScript and VB Script. The conversion used as many of the existing stored procedures as possible, but writing 12-15 new ones. Familiarity with Facets and Abra HMRS systems, as well.
• Technologies: SQL-Server 2000, Classic ASP, C#.Net (Visual Studio 2005), ASP. Net.
Consultant Systems Service Education, Inc. (SSE) – St. Louis, MO 1/06 – 12/07
• Windows forms VB.Net development project. Conversion of MS Access/Excel system to VB.Net / SQL Server 2005.
• Technologies: SQL-Server 2005, Visual Basic .Net (Visual Studio 2005), MS access.
• Consultant at Emerson Process Management division of Emerson Electric – St. Louis,
• Filling in on the Help Desk / Network Admin. Position for a sick individual. Maintained servers, built laptops, trouble shot printers, etc., etc. Gained familiarity with Active Directory. Technologies: Windows servers, Dell Laptops, HP printers.
• Consultant at Winco Window, Inc. – St. Louis, MO
Very large, year-long project, converting 200 tables and 25,000 lines of code for largest Aluminum Window manufacturer in US. Primary consultant of the team. This involved through knowledge of FoxBASE DBF structures and conversion to SQL Server 2005.
Technologies: SQL-Server 2005, Visual Basic, FoxBASE, MSAccess, VB6/VB.Net. .
• Consultant at Alpha Packaging, Inc. – St. Louis, MO
• Consultant at Client Services Incorporated – St. Louis, MO
Rewrote large portion of the LoanTrax lead tracking system. Added many enhancements to this system. Created tables to remove all hard-coded data from the code. Put in place the beginnings of a .Net 2.0 web version of the system.
Created QuickPost telephone calling program. Coded the program to read data from Excel spreadsheets and load into SQL tables, and finally, to export the results to an Excel spreadsheet with totals by state.
Created WinBack telephone system for agents to make calls to mortgage brokers to win back business from former customers. Coded the program to read data from Excel spreadsheets and export the results to Excel.
• Created Settlement Offer program to read tab delimited text files plug this data into Word documents. Used the faxing capabilities of Outlook on a remote server, to fax the letters to recipients. Unsuccessful faxes were noted in a SQL table, and generated emails to notify users of fax results.
• Created a Windows SharePoint Services team site, using capabilities of Windows Server 2003.
• Functioned as a third tier support person for the Help Desk for Visual Basic applications, where the Help Desk and the first and second tier people needed technical assistance.
• Created a testing system for the Collections Department to quiz the some 500 collectors in the Fair Debt Collection Practices Act requirements.
• Technologies: SQL-Server 2000, Visual Studio 2005, Visual Basic 6, VB.NET, ActiveReports, ADO, Excel and Word VBA, SQL Server DTS packages.
Levi, Ray & Shoup, Inc. – St. Louis, MO 10/04 – 1/06
Senior Consultant – Portal Group
Performed a variety of application design and development activities as an information technology consultant for various company clients.
Premiere Global Systems – Kansas City, MO
Developed forms in InfoPath in a SharePoint Portal environment.
Shook, Hardy & Bacon – Kansas City, MO
Performed installation and implementation of Microsoft SharePoint Portal Server system. Created content and structure of Windows SharePoint Services sites within the portal system.
Phelps County Regional Medical Center – Rolla, MO
Performed installation and implementation of Microsoft SharePoint Portal Server system. Created content and structure of Windows SharePoint Services sites within the portal system. Developed Reporting Services reports.
Nooter Corporation – St. Louis, MO
Performed installation and implementation of Microsoft SharePoint Portal Server system. Technologies: SQL-Server 2000, Visual Studio 2005, VB6, C#.NET
Reporting Services(SSRS), SharePoint, InfoPath
Jack Henry & Associates Application Developer 8/03 to 10/04
• Developed in MS Dot Net environment, producing web and desktop applications for one of Missouri’s largest financial software houses. Provided management with efficient means to distribute tasks throughout the enterprise with Service Requester application.
• Produced web application to schedule, track, and report on all internal class room and computer aided classes for employees, saving many hours of effort on the part of the Corporate Learning Solutions department, including automated e-mails and faxing.
• Developed application to provide management with customer surveys via browser base.
• Developed Communication Charges tracking system on Intranet, saving 5-10 hours/week of entry and lookup time for Telecommunications department personnel.
• Technologies: SQL-Server 2000, ASP.NET, Visual Studio 2003, VB.NET, dot Net Framework 1.1, ActiveReports, SQL Server DTS packages.
Independent Consultant 7/01 to 8/03
• Personal Care Products, Inc. and Quality Health Care Products, Inc.
Developed inventory and Purchase Order systems for SQL-Server database.
Technologies: Access 2000, SQL-Server 2000
• Home Delivery Incontinent Supply, Inc.
Developed direct mail marketing system for large database – List Query tool pulls lists of names and addresses for promotional campaigns based on multilevel criteria selected in user screens
Technologies: VB 6.0, Access 2000, Oracle database with ODBC
• Volt Services Group/ Computer Sciences Corporation
Developed enhancements to and completion of Technician Problem Ticket system and Asset Management system on Intranet.
Trained existing staff in development methodologies for SQL-Server based web application.
Technologies: Visual Basic 6.0, Access 2000, SQL-Server database with ODBC, ASP, and COM objects. SQL triggers and stored procedures. Database design.
Lambert Saint Louis International Airport, Expansion Project 6/99 to 7/01
Senior Programmer/Analyst Consultant
• Developed Utility Demolition System for engineering team charged with the demolition and utility disconnections of purchased parcels in the additional runway land area.
• Developed Contract Change Order System for handling all phases of Contract modification involving contractors and contracts negotiated by City of St. Louis. This included web component.
• Developed web application for Subcontracting database.
• Technical consultant and developer for the City of Saint Louis Board of Public Service web site.
Technologies: VBA 6.0 in MS/Access 97, ASP, SQL-Server 7.0, ADO, IIS.
Independent Consulting 2/98 to 6/99
MBR Management, Inc., 6/98 to 6/01
Loy-Lange Box Company, 6/98 to 1/02
Bodine Aluminum Corporation, 5/98 to 6/99
DCM Management Corp., 8/98 to 9/99
• Integrated a system to schedule manufacturing.
• Consulted with AS/400 programmers to assist in downloading.
• Maintained and modified various Visual Basic programs.
• Altered Excel programs allowing the users to link spreadsheets.
• Created systems to track bad checks, produce collection letters, and provide weekly sales analysis reporting for Domino’s Pizza chain.
• Designed and implemented accounting modules that integrate with other existing systems.
• Developed a job costing, invoicing, and payroll system for a building maintenance organization.
• Produced shipping tickets and box costing estimator for corrugated box manufacturers.
Technologies: VBA 6.0 in MS/Access 97, MS/Access 2000, SQL-Server 7.0, ADO, Visual Basic.
Crown Packaging Corporation 4/95 to 2/03
• Designed Database system for Sales force including downloads of VAX data, Queries, Screens, Reports.
• Trained existing staff in use of VBA and features for design, and prototyping.
• System distributed on over 180 laptops in the field.
Technologies: Visual Basic 5.0/6.0 components that interface with Access Jet Engine 2.0-4.0.
Independent Project 2/94 to 7/03
• Produced a system for recruiting agencies.
• Implemented a contact manager/search system using skills list boxes to populate tables.
• Three installations presently in use at agency offices.
Technologies: Access 2000 Database, VBA, HTML and ASP.
Federal Reserve Bank of Saint Louis 10/96 to 2/98
Senior Programmer/Analyst
• Designed and implemented an application for tracking employee training, including budgetary and management functions
• Senior technical person in Signature Card Imaging application. Provided documentation, testing, support, installations, development of add-on applications and analysis.
• Functioned as a coach and technical advisor in Visual Basic and MSAccess development teams.
• HMDA/CRA Team. This software package is developed and updated each year by the
St. Louis Federal Reserve Bank development team and distributed to member banks via CD or tWeb. Functioned as a developer in this, coding, testing, and meeting with the Federal Reserve Board to develop specifications and refinements
• Created and maintained Web Server and produced applications using server-side scripting for
database access on intranet web pages.
Technologies: VBA 6.0 in MS/Access 97, ASP, SQL-Server 7.0, ADO, IIS, Visual Basic 4.0.
Consultant (Self-employed) 1984 through 1996
• Designed, developed, and installed systems for clients in the insurance, manufacturing, heavy equipment, medical, education, publishing, and environmental industries, in various developing technologies.