Document and analyze root cause of current Payroll HR application failures Production support mode

Confidential

Consultant

• Lead resource for Peoplesoft conversion to Workday. Collaborated with vendor to define business requirements prior to conversion. Provided data extracts using SQL scripts and mapped them to the corresponding Workday fields. Created test cases scenarios for QA testing. Documentation of test results as well as conversion procedures.
• Lead technical analyst/developer in the benefits processes enhancements which involved requirements gathering, business flow diagramming using Visio, QA system testing created test scenarios and documentation of new process
• Coordinated with Silkroads vendor the development and implementation of the Open Hire system using Visio, RAD methodology,SQR and XML. Initial requirements gathering and data analysis was involved. Created test cases which were tested and verified on both ends. Documentation of new process
• Managed the design, development, user system testing and implementation of the conversion process from EDS to ACS for the Flex benefits systems. This conversion entailed vendor/user requirements gathering, fit-gap analysis, business flow diagramming using Visio, and creation/documentation of test cases.
• Responsible for the Peoplesoft integration and support to the following applications: Payroll CIPS , Time-capture, iRideshare, Identity Management IDM , Time and Attendance System TAAS , Expense Management Concur . Created test cases and documentation in all these integrations.
• Provided production support as well as necessary enhancements and developments new reports, panels, processes to PS HRMS and Employee Contract Module ECM , in-house developed contract system.
• Developed Peoplesoft interfaces and enhancements for the planned SAP globalization project.
• Responsible for the Peoplesoft HRMS enhancements that added a new Sony Pictures Animation SPA union as well as the required business rules. Requirements gathering and engaged in a significant amount of user interface to assure correct functionality of the added union. This project was done and tested in coordination with the Payroll Mainframe and Vacation Tracking Powerbuilder systems.
• Also, re-wrote the profit sharing SQR program to fix existing bugs and include new business processes.
• Develop SQRs and SQLs to eliminate manual processes of HRIS.
• Involved with the task team resolving current performance tuning issues of the HR application

• Involved with the Financial Peoplesoft AP balancing project. Responsibilities include analysis and testing of the process flow of the different AP transaction types, reconciliation of these transactions with Production Cost and GL, develop procedural controls and SQR reports that will be used to track discrepancies between AP Peoplesoft and GL Mainframe , run daily batch cycles, enhance existing Crystal reports, and fix existing peoplecode and application engine bugs. Tools used are Peopletools, SQR, and SQL

Confidential

Consultant

• Responsible for the analysis, re-design, and development of the Open Enrollment process, in which VIACOM sends employees' benefit election to be validated and loaded into Peoplesoft system. This new process was conceptualized to be able to run daily, on request, or anually depending on various criterias for each mode. Performed requirements gathering, significant amount of user interface, creation and documentation of test cases scenarios . This was developed using SQR, Peopletools 8.17 , App designer, Peoplecode, and SQL
• Revised and created test cases for the benefits interfaces to include year-end requirements of VIACOM and third party vendors. It also included the new 401k Catch-up contribution changes from Dreyfus. Re-analyzed, revised, and documented business requirements as well as the technical process of all interfaces. Worked with users in developing a standard test plan for these interfaces.
• Provided production support for HR and Benefits interfaces.

Confidential

Consultant

• Provided production support, development, and requirements analysis of a list of user requests for the HR system, specifically the custom Executive Contract Module. Created an online mass update process for union employees. Enhanced the salary budget planning system for a more accurate projections of future salaries and allowances. This function involved user interface in requirements gathering as well as drawing up all possible test cases. Tools used were SQR, Peopletools , Application designer, Peoplcode, and SQL

Confidential

Consultant

• Retrofit and baseline custom SQRs PS v7.0 for Peoplesoft v8.0 SP1 upgrade. Involved with the initial re-engineering process of validating and documenting account information in PS v7.0 to PS v8.0.
• Designed, developed and implemented Benefits interfaces to/from Peoplesoft with different providers Dreyfus, Prudential, GLTC using SQR. Created panels, panel groups, process scheduler, as well as enhanced menus for these interfaces. Documented business requirements as well as the full development process .
• Provide analysis, development and production support for HR and Payroll projects i.e. open enrollment, data repository from Peoplesoft to VIACOM, online audit to HR/PR records, vacation accruals, annual merit increase/bonuses, 401K match fix and other government required files and reports .
• Redesigned and developed existing employee contract system using Peoplecode, SQR and Crystal Reports.
• Responsible for the conversion of the current and historical data of SEGI employees from ULTIPRO, a PC based application, to Peoplesoft HR v7.0 . This process involved identifying data requirements, data mapping, design and development of report/update programs using Peopletools, SQR, and SQL.

Confidential

Consultant

• Responsible for the production support, enhancements, upgrades, and development of new requirements for the Peoplesoft HR v7.5 system. These include interfaces to other legacy systems.
• Major participant in the successful implementation of Peoplesoft HR v7.5 system
• Developed and implemented the interfaces between HR Peoplesoft and Payroll Host . Responsibilities included defining project scope, analyzing data requirements, data mapping, benchmarking system performance, documenting requirements and technical specifications, and designing and developing both batch and online programs using SQR, SQL, Cobol II, CICS command level, Datacom database, Dataquery, SQL Advantage, and a functional knowledge of Peoplesoft HR. It also required a comprehensive analysis and revision of the current Payroll online system.

Provided consulting services ranging from business analysis, design, development, implementation, conversion, and support to the following major companies:

Confidential

Senior Programmer/Analyst

Confidential

Sr. Business Analyst

TECHNICAL SKILLS: