Willie Harvey

  • Ellicott City MD

Work History

Work History
Nov 2013 - Present

Sr. It Analyst-Pas

Advantage Resourcing
Sr. IT Analyst-PAS Data Conversion Project Performed Data Conversion of the Maryland Automobile Insurance Agency(MAIF) MIPS, OPUS and IBS systems for data extraction, data migration and data validation for migrating legacy system data into the STG Policy Admin System(PAS) and STG Billing System for Personal Auto Policies. Attended Mapping Sessions with the vendor to identify data tables and data elements required for data migration Performed Data mapping— created Oracle staging tables, default data values and data attributes Created and modified MICRO FOCUS COBOL programs to extract data from the legacy Oracle data base Created SQL scripts and PL/SQL procedures for data analysis and data extraction Created Shell scripts to load staging tables and automate the data load process Created PL/SQL procedures and reports to validate the data load process Created flat files to transmit legacy data loads to the vendor Modified PL/SQL data extract procedures to resolved data load defects and errors
2010 - Present

Programmer

DSPO Systems Integration Organization
Sr. Consultant- Served as the senior functional analyst for the Decennial Applicant Personnel and Payroll System(DAPPS)— a PeopleSoft application supporting personnel and payroll administration for temporary, intermittent Census employees participating in the 2010 Decennial Census. Also provided Independent Verification and Validation(IV&V) in support of various DSPO/SIO applications. Implemented business rules and requirements for the PeopleSoft HR, Recruitment and Payroll modules Created functional specification documents for required PeopleSoft customizations for interfaces and reports Performed requirements gatherings and documentation of customized objects Made modifications to delivered PeopleSoft Pages, Components and Menus for the HR and Recruitment modules Developed Application Engine program to create security interface file with all terminated employees information for transmittal to the security department Developed PL/SQL packages, procedures and functions for extracting and updating test data Maintained and created PL/SQL procedure for loading test tables Created test conditions-developed test conditions and test cases to verify that Census Bureau business/software requirements were met Provided requirements gathering, programming and testing of the Inventory Management System(IMS) Provide IV&V support for the Computer-Assisted Clerical Coding(CACC) Software to include requirements verification, test case development, testing, reports generation and status reporting Provide IV&V support for the 2010 Census Coverage Measurement(CCM) creation of the E-Sample and P-Sample person data files Creation software to include test case development, testing, reports generation and status. Requirements management via Quality Center— loading requirements, mapping requirements to test cases, executing test cases, linking QC defects to test cases, generating QC test execution reports.
May 2013 - Oct 2013

Sr Developer

Systems Integration & Development, Inc.
Sr Developer-WHD XML File Development Project Provided application development support for a web hosting application for the Department of Labor. The website provides the public with access to both Service Contract Act(SCA) and Davis-Bacon and Related Acts(DBRA) Wage Determinations(WDs). Created PL/SQL procedure for extracting and formatting wage data onto flat files Maintained and updated PL/SQL triggers for generating wage history data Tested PL/SQL functions and procedure utilized for generating project test data Created the WHD XML File Development PL/SQL test scenarios
Mar 2008 - Apr 2013

Sr. Consultant

Census Bureau
SAIC Sr. Consultant-DSPO Systems Integration Organization
Aug 2000 - Feb 2008

Consultant-System

Accenture(Treasury Department)
Consultant-System To Administration Retirees(STARS) PeopleSoft HR, Payroll and Pension implementation for Policemen, Fire Fighters, Teachers, and Judges for the District of Columbia. Implemented Legal Plan Rules configuration for POLFF, TEACH and JUDGE Pension Plans Collected requirements, designed procedures and implemented customization to delivered COBOL programs for Service, Final Average Earnings, Optional Forms and payroll Designed and developed Application Engine program to compute Leave Without Pay for applicants Performed Fit/Gap analysis, designed gap strategies and recommended business process changes to take advantage of delivered functionality and eliminate obsolete customizations Modified SQR to implemented COLA calculation for the POLFF and TEACH Pension Plans Created PL/SQL procedures to generate test data and perform data analysis Analyzed legal plan rules/functional requirements and created technical specifications Analyzed Compare Reports and Customizations for the upgrades from v8.0 to v8. 3&v8.3 to v8.9. Mapped requirements to test conditions; Created test plans, test scripts and expected test results Performed System and User Acceptance testing for the different releases
Mar 1998 - Jul 2000

SAP

Amtrak
Team Lead-SAP Implementation Human Resources, Benefits, Time & Labor and Payroll Implementation— led the Time & Labor and Interface conversion for the implementation. Developed the Time & Labor and Interface Conversion Implementation Plans Developed the Legacy System Data Conversion Test Plan Established the ADP/ASG and Vanguard interfaces to transmit HR, Benefit and 401K data to the SAP system Ran SAP payroll process Developed ABAP reports for Labor Pricing and Labor Collection systems Performed“ As-Is”/“ To-Be” analysis on existing interfaces.
Apr 1997 - Feb 1998

Senior Consultant

Amtrak
Senior Consultant(Production Support) Provided production support and maintenance for Labor Pricing, Labor Collection and Labor Management applications. Performed Gap/Requirement analysis for re-designs of Labor applications Coded/Modified COBOL/CICS applications, IBM Execs, REXX, JCL and VB applications Developed Ad hoc and Headcount reports for the Pass Bureau system Led requirements gathering for the redesign of the Pass Bureau system.
Jun 1992 - Mar 1997

Sr. Consultant

Department of Justice
Sr. Consultant DB2 Systems
Feb 1991 - May 1992

Sr Db2 Dba

Internal Revenue Service
Sr DB2 DBA Performed logical and physical database design for the Automated Collection System. Performed requirements gathering for the ACS application Developed the DB2 to CICS interface Created all DB2 related objects— storage groups, tablespaces, tables, views, indices Supported application development for performance tuning Created database backup and recovery procedures Installed the DB2 subsystem at IRS Service Centers Converted DOS/VSE JCL and procedures to IBM 3090 MVS/XA JCL and procedures.

Education

Education

B.Sc