Lead Programmer Analyst Resume
PROFESSIONAL SUMMARY:
- Project Leader, Lead Developer and database designer. Has spent over 20 years designing and developing GUI interfaces for applications in the Oil, Gas, Health and Financial industries.
- Experience on both desktop and browser based applications using ASP, ASP.NET, VB, VB.Net, Java and C# using Oracle, SQL server and Access as backends.
- Past President of the Houston Dot Net Users Group.
- Executive Director of the Confidential
TECHNICAL SKILLS:
Programming Languages/Development Tools: VB.NET, C#, ASP.NET, ASP, Visual Basic, VBScript, Java, JavaScript, SQL, C, XML, PHP,GUI
Databases: Oracle, SQL Server, Access, SSIS, SSRS
Networking/Operating Systems: NT, Windows 2000, Windows 2003, XP, Vista, Win 7
Additional Specialties: MS Office, EMC eRoom, ADO, COM/DCOM, Confidential, SourceSafe, Crystal Reports, Microsoft Transaction Server, Essential Unified Process, Agile Methodology
EXPERIENCE:
Confidential
Lead Programmer Analyst
Responsibilities:
- Designed and developed Ms Voyager application in Vb.Net to interface with Voyager Mass Spec. using VBA, web services and Adobe distiller.
- Working with multiple applications and projects using Microsoft technologies
- Including ASP.Net, Visual Basic.Net and SQL Server.
- Writing Queries and stored procedures for SQL server
- Wrote multiple applications using Access (97, 2003 and 2007) as a front end for SQL server as well as some stand - alone applications.
- Created multiple reports using SSRS for management use
- Project Manager - Waste Transfer project - Coordinated a team in St. Louis and Mass. Made up of inside staff and outside developers to rewrite software to schedule pickup and track movement and disposition of hazardous materials. New system written in VB.net 2005 using an Oracle backend.
- Project Manager - Sanger WSC project to implement new B2B process for a major customer in the UK. Team includes people in the US, UK and France.
- Administrator for corporate wide eRoom system.
- Team lead of team including myself and three others for local development and maintenance.
- Part of company wide team trained to implement new development methodology based on Essential Unified Process
Confidential
Executive Director
Responsibilities:
- Founder and Director of annual technical conference. The 7 th Confidential was held in Sept. 2013 at Reliant Center and had almost 1,000 developers and managers in attendance.
Confidential
Senior Systems Developer
Responsibilities:
- Designed and developed several systems in VB.net to extract live data from a SQL server Database and send it to the client site in real time. The program would check at scheduled intervals and pickup confirmation or reject messages and adjust the status of the orders in the database.
- Designed and developed a system in VB.Net to extract weather data from a government web site and insert it into a SQL server database after validating it.
- Maintaining server farm used by clients to remote into and run applications.
- Troubleshooting and performance monitoring for large SQL Server database including performing DBA activities on production and test databases,
- Extensive use of SQL Server stored procedures and functions.
- Maintained and modified multi-tiered VB6 system using MSMQ 3.0, SQL server and stored procedures.
- Mentoring Junior developers in .Net technology
Confidential
Programmer Analyst
Responsibilities:
- Maintained and modified web site for the Houston Metropolitan Medical Response System.
- Written in ASP.NET and C# the web site is a portal for disaster and homeland security information.
- Also serves as a repository where hospitals in the metropolitan area enter information on bed and drug availability that can be accessed quickly in the event of an emergency.
- The backend database is Oracle 9i. The web site uses Web focus for reporting and the Iway data transformation engine for batch input of data.
- Developed a front-end system to track clients, holdings and offerings of fixed income securities for a Houston securities firm.
- The package uses Outlook, SQL Server 2000, Visual Basic 6.0 and Crystal Reports 9.0.
- Duties included the entire VB code, SQL stored procedures, Triggers, DTS and Crystal Reports.
- Also responsible for the database design and normalization. The program enables the user to query an SQL server database and interact with Bloomberg and Yieldbook services to get detailed information about various securities.
Confidential
Senior Consultant
Responsibilities:
- Directed the work of another developer and a tech writer.
- Responsible for the design and coding of Guardian 4.0. A Visual Basic 6.0 program designed to run with an Oracle database.
- Also responsible for the design of the database that was a star schema, writing stored procedures and Triggers and performing other DBA functions.
- The program catalogs different media items associated with the Oil and Gas industry.
- In addition to cataloging, it allows rapid scanning of existing cataloged items and provides the ability to check out and check in items from a central desk and keep track of where the items are. It also allows the users to attach Post-it notes and external files like PDF files or pictures to any given record.
- The program displays an icon for external files and will run them using the appropriate program when clicked on.
- Guardian has the ability to import s and display records from external databases; specifically Openworks. The program uses the third party controls Active Reports, and Janus’s Grid EX and Buttonbar.
Confidential
Senior Consultant
Responsibilities:
- Designed a standalone program to take XML files with drilling information, parse the information and reformat it into files in the DIMS import format.
- Designed and developed a system using Visual Basic 6 to support calculating the maximum possible loan for a Variable Annuity Participant and provide repayment modeling. The application consisted of a Visual Basic GUI and ActiveX DLLs designed to run under MTS. We created two versions of the application, one used DCOM as the transport protocol and the other used HTTP to pass information to the client from ASP pages in XML format. Database information was contained in an Oracle database, which was accessed by a middle tier Active-X DLL that I wrote. I directed the work of another developer and participated in design and code review meetings as part of this project.
- Enabled the construction of information to be passed from the application to the AWD task processing system.
- Over 400 personnel in the call center and back office will use this system.
- Participated in a re-write of a client server application written in Powerbuilder to run on the Internet, for a major gas pipeline company. The Internet application was written using Microsoft Visual Basic COM components and Microsoft Interdev.
- Evaluated screens and logic from an existing PowerBuilder application.
- Wrote code that runs on the server and browser using ASP, VBScript and JavaScript.
- Tested resulting system on both Netscape and Microsoft browsers.
Confidential
Senior Consultant
Responsibilities:
- Developed an Internet portal for an energy company.
- The Portal is being developed using Epicentric’s Java and JavaScript-based tools, and uses Java Server Pages extensively.
- Developed standalone system for validating counter parties, for a large energy company.
- System is written in Visual Basic and used middle tier COM objects.
- Architect and prototyped the SORO Bonus application.
- The application, which included a web-enabled interface, had a data-driven rules module, and data feeds to and from legacy data repositories.
- The primary development tools were ASP script and Visual Basic 6.0, which was used to access data in an Oracle data warehouse with the results being presented via the web.
Confidential
Project Leader
Responsibilities:
- Responsible for a team of 3 working on the Shell Measures tool, a graphic application used for comparing production and non-production data from the corporate database.
- Client and middle tier ActiveX servers were written in Visual Basic, database access was through ActiveX servers (COM/DCOM objects) to Oracle and SQL Server via RDO.
Confidential
Senior Programmer
Responsibilities:
- In charge of the development ADF Manager’s Workbench written in Visual Basic. This system tracked the time and expenses of consultants involved in various outsourcing projects. It also tracked the creation and development of the projects themselves using Crystal Reports.
- Coordinated work for a staff of three, processing change requests from the client.
- Testing and scheduling of releases, used Confidential and SourceSafe for version control.
- Designed and developed a system in Visual Basic to coordinate the automatic production of CD’s on 3 machines. The CD’s contained monthly bills and analysis tools for large customers of the phone company Nynex.
- Part of the assessment and remediation team concerned with Y2K issues for Telecom companies.
- In charge of data acquisition and coordination for a large project at Sprint in Kansas City starting with MS Access and moving to SQL Server. Designed databases using Erwin and other tools to assist the data migration.
