HIGHLIGHTS:

• Over 18 years of Computer Systems Analysis and Applications Experience
• Experience utilizing UNISYS 1100/2200 mainframe, UNIX systems and Corporate Data Warehousing.
• Experience utilizing SQL developer, PL/SQL, COBOL, PC Microframe, DMS, RDMS, DPS, TIP, DPS, ECL IQU, VBA and, Microsoft Word using Mail Merge, Access, Excel, Power Point, SAP Business Objects InfoView, Web Intelligence Reports

EXPERIENCE:

Confidential

Senior Systems Analyst

Member of the NAVSEA ERP Business Office NEBO Business Intelligence BI Team responsible for enterprise report development. Specifically, created Year End Close reports for expiring/cancelling sales orders. These reports were well received by the user community and are also being utilized for Month End Close. Responsible for the development and weekly publishing of data integrity reports. Responds to NAVSEA ad-hoc report and data call requests, as required. Participated as a team member in analyzing batch jobs and providing record counts for data files. Publishes month-end metrics, providing graphs in a PowerPoint presentation. Responsible for analyzing and validating tables in a Business Objects universe environment that is deployed across the NAVSEA enterprise. Confers with subject matter experts on solutions to complex problems. Utilizes SQL developer and PL/SQL utilities to provide reports. Utilizes SAP Business Objects InfoView and Web Intelligence reports to analyze and validate tables in the universe environment.

Confidential

Senior Programmer Analyst

• Responsible for receiving requests from Defense Industrial Financial Management System DIFMS users for data extracts from their database and reports. Receives requests from Navy Enterprise Resource Planning Navy ERP conversion team for data extracts from the WCF databases and reports. Responsible for the transcription of data extracts into MS Excel worksheets as requested. Receives requests from DIFMS users for data remediation on their databases. Confers with subject matter experts on solutions to complex problems.
• Utilizes UNIX and Oracle SQL utilities to implement changes to the database. Develops and executes processes to retrieve and present data used to assess the progress of the Navy DIFMS Users, in meeting their data cleansing goals as defined by the Financial Improvement Program and the Navy-ERP Conversion effort. Develops and maintains documentation for all programs and processes created or modified. Instructs new team members in the processes and procedures that are utilized to provide customer service.

Confidential

System Development Manager

• Provided support to NAVSEA sites that utilize DIFMS. Followed established procedures for the analysis, development, maintenance and modification of complex financial and inventory management programs. Utilized structured coding techniques to develop application programs in COBOL on UNIX and MicroFocus COBOL environment. Extracted data from UNIX and reports to perform required analysis to balance subsidiary ledger to corresponding general ledger accounts. Determined the root cause for out-of-balance conditions between subsidiary ledger and corresponding general ledger accounts. Developed UNIX web based screen scripts to apply bulk transaction processing using DIFMS application web screens. Developed a modular process to identify and close funding documents. In doing this, refined the process to identify and eliminate bottlenecks in both procedures and programs.
• Supported the user community by interpreting user requirements into data extraction methods using structured queries or programs as required. Formulated test plans, created test data and executed test plans to ensure software compliance with specifications and that existing capabilities were not compromised. Developed and maintained documentation for all programs and processes created or modified. Followed process procedures which required knowledge and understanding of operating systems, compilers, utilities, multi-programming and telecommunications systems. Performed functional and technical analysis and updated ADP technical and functional documentation to include user and computer operations manuals. Provided instruction to new programmers as to the use and capabilities of the software tools used on the NAVSEA project. Adhered to and provided guidance on established project configuration management policies and procedures for analysis, software development, peer review, testing and quality assurance.

Confidential

Senior Program Analyst

• Provided support to NAVSEA sites that utilize DIFMS. Followed established procedures for the analysis, development, maintenance and modification of complex financial and inventory management programs. Utilized structured coding techniques to develop application programs in COBOL on UNIX and MicroFocus COBOL environment. Gathered data from database and reports to perform required analysis to balance subsidiary ledger to corresponding general ledger accounts. Determined the root cause for out-of-balance conditions between subsidiary ledger and corresponding general ledger accounts. Developed UNIX web based screen scripts to apply bulk transaction processing using DIFMS application web screens. Developed a modular process to identify and close funding documents and refined the process to identify and eliminate bottlenecks in both procedures and programs.
• Supported the user community by interpreting user requirements into data extraction methods using structured queries or programs as required. Formulated test plans, created test data and executed the test plan to ensure software compliance with specifications and that existing capabilities were not compromised. Developed and maintained documentation for all programs and processes created or modified. Followed process procedures, which required knowledge and understanding of operating systems, compilers, utilities, multi-programming and telecommunications systems. Performed functional and technical analysis and updated ADP technical and functional documentation to include user and computer operations manuals. Provided instruction to new programmers as to the use and capabilities of the software tools used on the NAVSEA project. Adhered to and provided guidance on established project configuration management policies and procedures for analysis, software development, peer review, testing and quality assurance.

Confidential

Senior Programmer/Analyst

• Supported the conversion and implementation of the Navy and Air Force sites for converting their legacy financial system data to DIFMS. Managed 5 programmers, ensuring they followed established procedures for the analysis, development, maintenance and modification of complex financial and inventory management programs. As Senior Programmer/Analyst, utilized structured coding techniques to develop application programs in COBOL on the UNISYS mainframe and MicroFocus COBOL environment. Responsible for the analysis of data requirements and the development of conversion programs to migrate material data to DIFMS. Formulated test plans, created test data and executed the test plan to ensure software compliance with specifications and that existing capabilities were not compromised. Developed and maintained documentation for all programs and processes created or modified. Followed conversion process procedures which required knowledge and understanding of operating systems, compilers, utilities, multi-programming and telecommunications systems. Followed predetermined load schedule and executed the conversion and loading of the legacy data into the DIFMS database for test loads and actual implementation. Performed functional and technical analysis and updated ADP technical and functional documentation to include user and computer operations manuals.
• Provided on-site support for the conversion and implementation of DIFMS while developing strong technical and analytical skills. Provided instruction to new programmers explaining the use and capabilities of the software tools used on the conversion project. Adhered to and provided guidance on established conversion project configuration management policies and procedures for data mapping analysis, software development, peer review, testing and quality assurance.