Summary

• Extremely motivated and results-driven programmer/analyst with exceptional leadership skills and an extensive background in the following competencies:
• Software Development, Database Management and Application Enhancements
• 10 year or more of PowerBuilder Versions 5-10, PL/SQL Oracle 7 11, Clipper all versions
• Java, ColdFusion, PHP, MySQL, XML, Appeon, .NET 2005-2010 , SharePoint, SQL Server Reporting Services, Remedy, Fortify, Dreamweaver, Ajax T-SQL for 2005 database all less than 1 yr
• Many years using Crystal Reports and SQL tools like SQL Navigator, Erwin and Toad

Career High points

• Award for Excellence from the Vice President of the East Coast Division of EG G
• Commendation from Deputy Director of Information Resource Management at the Nuclear Regulatory Commission for exemplary efforts in evaluating calendar systems for 5,000 users
• Recognition from the project manager of the CBSI contract with EPA for saving his contract twice

Skills

• Analysis Re-engineering, Requirements Analysis, System Analysis, Application Design, Documentation, Test plans
• Quality Assurance Unit testing, Writing Test plans, Integration Testing, Data Quality Assurance
• Helpdesk Services Provides information and assistance resource that troubleshoots problems with software, OS and network

Experience

CONFIDENTIAL

Senior Oracle Developer

The project: FTC uses 13 three-tier Oracle Forms application running on a Unix platform. The applications organized both the data, and the flow of both processes and finances of the FTC. Several applications manipulated Excel Spreadsheets in cleaver ways. There were 4 Change Management environments: Development, User Acceptance, QA and Production.

Analysis:

Write requirements for application modifications

Programming three tier applications

Maintain multiple applications written in Oracle forms and Web Tools on a Unix application server Maintain multiple applications written in Oracle forms and Web Tools on a Unix application server

Helpdesk Services:

• Support users by resolving software issues
• Help maintain Remedy tickets and an internal task management system

Quality Assurance:

• Responsible for unit testing and integration testing of data applications
• Analyzed PL/SQL and Java code with Fortify software by Hewlett Packard for web vulnerabilities
• Write test plans and test modifications made to applications
• Write documentation for the Change Management process

CONFIDENTIAL

Developer

The project: EPA Office of the Chief Financial Officer OCFO uses a client server application Scorpios to create bills for superfund sites. The bill could encompass work taking over a decade to complete and could amount to hundreds of millions of dollars. The bill is written in HTML, XML and used images of scanned receipts, and other documents as well as reports in PDF format. A large bill could take 4 hrs to write to a hard disk and contained more than 100,000 images and a similar number of pdfs. Because the reports were so numerous and varied greatly, the reports were built on the fly with an AI report generator. The report generator was probably about 1,000,000 lines of code using about 100,000 lines for any given report. The bill would be written to a CD or a DVD if a CD was too small. The bill contained many layers of menus a user could drill down to find a particular report of receipt. Scorpios was the main tool used by the EPA to find information about any superfund site and was used by more than 100 persons throughout the US.Modified an existing application, Scorpios, written in PowerBuilder 9 and Oracle 11 PL/SQL so it would work with Windows 7 and responsible for the installation for over 100 users in 8 regional offices throughout the Confidential. Modified installation batch files to work with Windows 7. Scorpios produces bills for superfund projects on a CD or DVD by mining data from multiple databases.

Programming client/server applications:

Modified PowerBuilder and PL/SQL code for the Windows 7 project and bug fixes for the production version.

Helpdesk Services:

Support users resolving issues ranging from user error to repairing database problems or modifying PowerBuilder code.

Quality Assurance:

• Performed unit testing and integration testing of data applications.
• Write test plans

CONFIDENTIAL

Senior PowerBuilder Programmer/Analyst

The project:

Converted 11 PowerBuilder applications into Web Applications using Appeon. Five of the applications are somewhat large PFC based applications. The largest, had about 150 data windows excluding the reports. It had several large tabbed sheets. The largest application was about 15 tabs wide and up to 4 tabs deep. That sheet had over 30 linked data windows. The conversion process had a 90 day window. These applications use Microsoft SQL Server as the database. After the Appeon conversion, maintained the Appeon applications and helped with converting these same applications to .net as an analyst and developed VS 2008 reports, inserting them into VS 2010 web pages, later doing add/edit/delete modules.

Analysis:

Quickly analyze what the application does and how it was designed for both the .NET conversion and the Appeon conversion. Appeon converted best when the applications were built using PowerBuilder guidelines. Gathered user requirements for modifications to the PowerBuilder/Appeon applications.

Programming client/server applications:

Quickly modify code in both the program and to the PFC so that the code is supported by Appeon. In several applications many rewrites were required.

Programming in T-SQL

Created some and modified many procedures built tables, indexes and constraints.

CONFIDENTIAL

Senior PowerBuilder Programmer/Analyst

• The TRIS database had over 250 tables and was accessed by 40 megabytes of PowerBuilder code. The code used business rules and 4 layers of inheritance PFC, PFE and 2 business layers .
• The back end was an Oracle 10G database. Object Cycle was used for version control and some of the reports were written with Crystal Reports.

Programming client/server applications:

Maintained several complex client/server applications written in PowerBuilder. The data entry module handled 27 different form versions. 2 modules reviewed newer and older data highlighting in red the differences.

Programming in PL/SQL:

Developed a few and debugged many PL/SQL packages up to 7500 lines long. Wrote many functions, stored procedures and triggers some triggers were used in audit functionality others set 'flags' preparing the data for an automatic process. Created and SQL tuned many views and queries. Built database objects such as tables, indexes, constraints, views and sequences.

Analysis:

Using Spiral Analysis methodology, interviewed the clients to ascertain their business procedures and to formulate software functional requirements and produce the required documentation.

Helpdesk Services:

Provided direct support to users of data applications and assisted the web support hotline with higher level technical issues.

Quality Assurance:

• Responsible for unit testing and integration testing of data applications and data product testing.
• Found a critical error after taking on additional data product testing when I had learned a marginal programmer had altered our data product module after most of our testers had been laid off reducing the level of both the testing and data product QA. The error was missed by both the program testers and the data quality testers. This was at the end of the contract and the error would have cost us the contract. In addition to the usual contractors checking the quality, a competitor was contracted to review our data.

Re-engineering:

Reengineered the TRIS from a Clipper system to a Client Server system.

Management and Staff Competency:

• Managed a programming team as the lead programmer. Experience with multi-tasking and complex, multi-faceted, time-sensitive assignments.
• Saved the contract by temporarily taking over the equipment inventory process and creating new inventory software. We had failed an inventory audit twice and would have lost the contract had we failed the last audit.

CONFIDENTIAL

Senior Programmer/Analyst

Worked in several similar positions as a Senior Clipper Programmer analyst. It was customary for Clipper programmer staff to serve as PC support, manage the network and administer any groupware.

Programmer in Clipper:

Wrote the more technically challenging functions and created and maintained the larger applications within a team of 25 programmers.

Business Analyst:

Interviewed the office teams, analyzed business processes, and created Clipper applications to maximize efficiency and performance through automated systems.

PC Technician:

Serviced PCs and Macs. Administered Novell LANs and email systems such as Outlook, cc:Mail and GroupWise.

Management and Staff Competency:

Managed Clipper programming teams as the lead programmer. Trained programmers to perform PC Tech tasks.