PROGRAMMER ANALYST

• Expert in information systems with a track record of more than 15 years of resourceful department and program management. Comprehensive skills in deployment and maintenance of IT systems and processes, including systems integration, change management, and database administration. Demonstrated analytical ability to build innovative, efficient systems and processes and navigate system changes in infrastructure and technology transition. Efficient in effectively creating innovative solutions based on strategic needs analysis. Proven strength in proactive knowledge sharing, ensuring appropriate quality assurance and documentation for long-term efficiency. Adept at quickly mastering new skills.
• Process Engineering Quality Assurance Government Contracting Data Analysis
• Continuous Improvement Change Management Technology Audits System/Database Migration
• Program Design Code Reviews Knowledge Transfer Troubleshooting Conduct Training
• Documentation Specification Definition Systems Administration Staff Mentorship/Coaching

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer Analyst

Worked at client site Ashcroft Instruments , analyzing data structure and data. Wrote COBOL and created JCL to convert data for manufacturing purposes. Analyzed system needs, evaluating potential programming solutions, and defined appropriate solution architecture to facilitate effective processes. Wrote ad hoc programs and documented all systems and testing. Modified extraction programs to run efficiently and held final authority converting data from legacy systems to new Vantage Manufacturing System. Collaborated with project manager to enlist the support of a team, and oversaw conversion programs and processes as the default subject matter expert. All work performed on IBM mainframe running TSO, VSAM, CICS and IDMS DB/DC under zOS system.

• Reduced window of execution time by 6 hours, while comprehensively documenting the process.
• Created new high complexity batch conversion programs in COBOL based on verbally conveyed guidelines and database design.
• Improved accuracy of data conversion by analyzing IDMS database for efficient data extraction and analyzing data for conversion to Vantage ERP system.

Confidential

Legacy Programmer Analyst Contract

Worked on client site BAE Ground Systems developing new programs to convert data on CAS manufacturing system to new Oracle Manufacturing System. Wrote complex COBOL code to extract data and create down load files for Oracle system. Created JCL to run programs, and documented all programs and processes. Managed daily system testing and quality assurance to ensure proper fit with processing window. Acted as subject matter expert for mainframe database IDMS and VSAM file structure, and mentored team members including staff and new contractors. Performed maintenance on legacy system during the migration. Created the final run script to execute production conversion. All work performed on under zOS running TSO, CICS, DB2, and IDMS DB/DC.

• Executed a validation process 2 days in advance of schedule by creating processes that fully validated comprehensive data with a zero-error tolerance, running 4.5 days from start to finish.
• Produced a remarkably smooth, complication-free migration of the system, supporting all processes with complete documentation and quality assurance.

Confidential

Systems Analyst / Assistant Project Leader Contract

Led a team to prepare CAS manufacturing system for a 3-version Oracle upgrade. Set testing scenarios and documented all processes and actions in PowerPoint. Supported AP system and all interfaces to CAS and Oracle systems, addressing all critical interfaces. Analyzed CAS interfaces to all other systems. Improved VSAM file structures by analyzing JCL working within the CICS, DB2, and IDMS DB/DC areas. Provided continuous information flow to project lead.

• Devised the lookup database using PowerPoint by researching and documenting over 200 interfaces to and from the CAS system.

• Eased the complications of maintaining interfaces and related programs by documenting previously undocumented interfaces in an easily accessible format.

Confidential

Analyst, Production Support Contract

Verified all night batch runs, identifying errors and inefficiencies. Investigated and diagnosed user problems and change requests in batch and online systems. Developed innovative solutions and applied solution architecture to existing programs using DB2 and IDMS databases using COBOL, ADSO, ROSCOE, JCL, CICS, and VSAM. Analyzed databases and programs for potential issues and took proactive action.

• Reduced the backlog of user requests and documented problems with the databases.
• Maintained the billing/customer information system and helped maintain the AP system.

Confidential

Staff Sergeant

Supervised a team of 11 Aviation Maintenance soldiers servicing Army aircraft. Provided technical guidance to support utility helicopter and subsystem maintenance. Trained personnel to work on aircraft and monitored performance and compliance with directives. Maintained equipment records and supervised set-up of tool and parts inventory area.

• Designed user-friendly Access database to track tools and parts in the inventory, ensuring accurate stock levels and optimizing inventory.
• Created a systematic tool receipt and issue protocol to eliminate errors in tracking equipment and use/recovery.
• Received Army Commendation Medal for exceptional performance in leadership role.

Confidential

Contract Programmer Analyst

Contracted services to firms consulting Fortune 500 companies. Supported legacy systems in roles of programmer/analyst, troubleshooter, team leader, maintenance and enhanced programmer, conversion programmer, and mentor/coach to junior employees. Provided expertise to both maintenance and development teams in critical operations with major corporations.

• Supported mainframe legacy systems in banking and manufacturing American Security, CBT, Pratt Whitney, GE, Otis Elevator, Sikorsky , as well as:
• Insurance Travelers, Aetna .

• Publishing and Utilities Dow Jones, Providence Journal, Providence Gas .
• Converted databases from one system to another IDMS, IMS, SQL Server, Oracle, etc. and converted batch/online systems from one language to another Assembly, FORTRAN, COBOL using TSO, CICS and/or IDMS DB/DC.

TECHNICAL SKILLS

Environments: IBM Mainframe and Microsoft compatible PC

Programming Languages: COBOL, FORTRAN, PL1, Assembly, Basic, C.

Databases: DB2, IMS, IDMS ADS/O, MAPC, IDDM, OLQM, DMLO .

Software: Software International GE General Ledger, MSA Payroll, ISI Payroll, Vantage: Universal Life Batch System, Vantage Annuity System Batch, CA-CAS Manufacturing, MACPAC, Telon, as well as a host of proprietary banking, insurance, health, utilities, billing, and accounting systems.