Programmer Analyst Resume
Richmond, VA
SUMMARY:
- I have used my expertise in programming in Centura Team Developer and in application analysis in many projects. I have taken a large role in application and screen design, class implementation, maintenance and reuse, application programming, unit and system testing and other duties as a Senior Programmer Analyst.
- I have used my skills in SQL programming of Oracle, Sybase and SQLBase databases and data modeling to create databases, tables and indices for various systems including accounting, budget and billing systems.
PROFESSIONAL EXPERIENCE:
Confidential, Richmond, VA
Programmer Analyst
Responsibilities:
- Production support. Analyze production problems and resolve these issues.
Confidential, Orlando, FL
Contract Programmer Analyst
Responsibilities:
- Scrum Master for agile development team using Centura Team Developer, Oracle Stored Procedures and calls to Web Services.
- Team performed development for stories to make enhancements for screens / coding and to fix production defects.
- Attend and contribute to release planning meetings
- Attend sprint planning meetings and accept stories for next sprint from backlog.
- Hold daily scrum meetings with team members to facilitate removal of obstacles.
- Update documentation and metrics for team.
- Attend and contribute to sprint review meetings.
- Attend and contribute to release review meetings
Confidential, Pittsburgh, PA
Contract Programmer Analyst
Responsibilities:
- Created Detailed Technical Designs for various projects to use Centura/Gupta Team Developer 2.1 and Oracle Stored Procedures and SQL scripts. Performed programming to make bug fixes and / or enhancements for existing screens and stored procedures. Performed programming and unit testing of new Centura screens and Oracle Stored Procedures and SQL scripts.
- Created detailed technical design documents for rewrite / optimization of Accounts Receivable modules of the Accounting system, all affected Oracle PL/Sql packages and stored procedures and of the associated tables of the Accounting database in Oracle. Received signoffs from all user departments, associated BA’s, project leads and managers.
- Using SQL Developer, designed new tables and indices for rewrite / optimization of Accounts Receivable modules of the Accounting system. Created these tables and indices.
- Wrote Oracle package to read existing 2 plus million rows of data, transform as required and insert into new tables.
- Updated all affected Oracle PL/Sql packages and stored procedures to use new tables.
- Updated front end modules written in Centura Team Developer 2.1. Modified existing screens and classes and added new Centura screens. Performed unit testing of all changes.
- Assisted in system testing by QA team. Assisted in User Acceptance testing. Assisted in Month End processing for 2 months to verify accuracy of the rewrite / optimization of Accounts Receivable.
Confidential, Springfield, MA
Programmer/Analyst
Responsibilities:
- Created Detailed Technical Designs for various projects to use Centura/Gupta Team Developer 2.1 / 4.2 and Sybase Stored Procedures and SQL scripts. Performed programming to make bug fixes and / or enhancements for existing screens and stored procedures. Performed programming and unit testing of new Centura screens and Sybase Stored Procedures and SQL scripts. Performed Code Reviews for other projects for coding standards and best practices.
Confidential, Deerfield, IL
Programmer/Analyst
Responsibilities:
- Created Detailed Technical Designs for various projects using Centura Team Developer 1.5.1. Performed programming and unit testing to make bug fixes and / or enhancements for existing Centura screens. Performed programming and unit testing of new Centura screens. Performed Code Reviews for coding standards and best practices.
Confidential, Woodland, WA
Senior Programmer Analyst
Responsibilities:
- Analyzed and documented requirements, translated business requirements into technical specifications, performed programming, unit / system testing and database design for an integrated set of clinical documentation and financial decision support program which includes clinical modules, patient tracking, scheduling and administrative utilities. The environment was Centura Builder 1.1 / 1.5 and an Oracle 7 database on Windows NT 4.0.
Confidential, Duluth, GA
Programmer/Analyst
Responsibilities:
- Created Detailed Technical Designs for DCARS project. Performed SQLWindows and SQL programming and unit testing for DCARS project. The environment was SQLWindows 5.0 and an Oracle database on Windows NT 4.0 and Windows 95. I also performed maintenance on Microfocus COBOL and SQR programs running on Sequent.
Confidential, Conyers, GA
Programmer/Analyst
Responsibilities:
- Performed requirements definition, analyzed and documented requirements, translated business requirements into technical specifications, performed programming and unit / system testing to convert MS Access production reports to a SQLWindows application and .qrp report templates. The environment was SQLWindows 5.01 / 5.03 and a SQLBase database.
Confidential, Atlanta, GA
Programmer/Analyst
Responsibilities:
- Created Detailed Technical Design for Lead and Asbestos Accreditation / project and performed programming and unit / systems testing of new SQLWindows screens and SQL scripts for Lead and Asbestos Accreditation / project for the State of Georgia for SQLWindows 5.03 and an Oracle database.
Confidential, Birmingham, AL / Atlanta, GA
Programmer
Responsibilities:
- Performed programming to make bug fixes and / or enhancements for existing screens and stored procedures and performed programming of new Centura screens and SQL scripts for in - house applications using SQLWindows 5.01, Building Blocks classes, classes developed in-house and an Oracle database. I worked on all portions of these programs from design, design specs, screen layout and class implementation.
Confidential, Atlanta, GA
Programmer Analyst
Responsibilities:
- Created business and technical documents for new Budget and new Billing systems for Windows.
- Did all database work for these two projects. Performed programming and unit / systems testing of new systems.
- Maintained and was responsible for the mainframe Load Information System for over five years.
- Gathered business requirements from users and created business design documents for new Budget system incorporating desired features of existing mainframe system.
- Created ER diagrams for new Budget database for Oracle using Erwin. Created Sql scripts and ran them to create database, tables, indices and triggers.
- Extracted existing Budget data from VSAM datasets on mainframe and imported data to new Budget database on Oracle.
- Created technical design documents for new Budget system written in SQLWindows to run against the new Budget database.
- Performed programming in SQLWindows and unit / systems testing for new Budget system.
- Assisted in user acceptance testing of new Budget system.
- Gathered business requirements from users and created business design documents for new Billing system incorporating desired features of existing mainframe system.
- Created ER diagrams for new Billing database for Oracle using Erwin. Created Sql scripts and ran them to create database, tables, indices and triggers.
- Extracted existing Billing data from VSAM datasets on mainframe and imported data to new Billing database on Oracle.
- Created technical design documents for new Billing system written in SQLWindows to run against the new Billing database.
- Performed programming in SQLWindows and unit / systems testing for new Billing system.
- Assisted in user acceptance testing of new Billing system.
Confidential, Alpharetta, GA
Instructor / Programmer
Responsibilities:
- Performed programming and testing for in-house projects and was instructor of classes in Assembler, COBOL and Cross System Product for IBM mainframe computers.