PROFESSIONAL SUMMARY

• Successful project manager, project leader, technical lead, and systems analyst with strong experience leading and participating in commended, collaborative, and cross-functional HRMS teams.
• Highly experienced with PeopleSoft HR, Benefits Administration, Payroll Interface, and full development life cycle Rel. 8.8., 9.1
• Fully involved in conversion from Mainframe to PeopleSoft Client Server using Mainframe and PeopleSoft products.
• Demonstrated skills and increasingly responsible roles in project management, application management, system configuration and infrastructure, business systems analysis, specification development, interface design and development, change and version control.
• Successful project manager consisting of a team of 5 for Employee Stock Option Plan. Designed, coded, tested and implemented HRMS from legacy mainframe to client server PeopleSoft.
• Committed to excellence and building productive professional relationships.

PROFESSIONAL EXPERIENCE

Confidential

I am a member of the technical NYCAPS team that is involved in production support, and enhancements to PeopleSoft production system making changes in SQR programs, and online PeopleSoft Peoplecode programs.

Confidential

I am a member of a team that is updating SQR programs for conversion for HR, Payroll, and Financials producing current data that will be sent to the corporate division for a centralized system. Also using Query Analyzer extracting data using complex selects to retrieve the data. Modifying Application Engine program also to extract data from their PeopleSoft system for conversion.

Writing numerous SQR programs to extract data and building XLS flat files for input into a Data Warehouse System.

I was a member of an upgrade team for People soft Financials 8.8 to 9.1 and People Tools 8.52. I was involved in retrofitting 100 sqr programs inserting new fields into tables that were upgraded to the new release. While testing wrote numerous PS Query's checking for valid data cross tables, reporting the resulting. I was involved in coding for an enhancement for Refund Approval using People code Workflow technology.

As a member of the pre conversion team working on People Tools 8.50, Oracle 11g, and PeopleSoft 9.1 executing and testing HCM, Financials, and Payroll conversion programs for 26 health ministry's producing error reports and PS Query Reports for reporting all of the data that was built on the tables, and worked with the ministries to clean up the data in error. I wrote numerous sequel statement using SQL Developer and PS Query reports for reporting errors to the health ministry. Changed conversion programs that were in error and retested my changes, gave the conversion team the changes made for them to incorporate my changes in their conversion programs..

I worked on People Tools 8.50, Oracle 10g, and PeopleSoft 9.0, Demo's for the V.A. adding custom pages and secondary pages with people code. Developed and created custom audit tables. Wrote inbound and outbound interface programs using SQR's.

Working with People Tools 8.50, Oracle 11g, and PeopleSoft 9.0, in HCM/HR performed data mapping for Job, and Bio Demo data for conversion of the legacy systems to PeopleSoft. Performed the functional and technical design for a duplicate checking program for data that has the same employees working across multiple agencies. Performed the functional and technical design for converting the Job data for multiple agencies. Wrote both conversion programs using SQR language. The Job conversion program had about 10,000 lines of code converting about 400,000 history records and 45,000 active employees, building about 15 Peoplesoft core tables. The duplicate checking program assigned new employee ids for all agency employees flagging the employees that were in multiple agencies as duplicates for special processing in the Job load program.

Working with People Tools 8.50, Oracle 11g, and PeopleSoft 9.0, in HCM/HR performed maintenance on Application Engine Conversion programs for ELM modules. I Executed the Application Engine programs for the HCM/HR conversion programs from legacy system data for Bio Data and Job Data to convert the data into PeopleSoft table doing all edits for all fields on all tables.

Working with People Tools 840, Oracle 10g, and PeopleSoft 8.8, in HCM/HR built PeopleSoft Pages for Additional Seniority Credits for the Department of Education in NYC. Working in a role as Developer including SQR S, People Code using Application Designer. Worked on enchantments to HRMS system

as per the client's request.

• Working with People Tools 8.40, Oracle 10g, and PeopleSoft 8.8, in HCM/HR built Audit tables for License and Certification Audit. Converted data to populate tables for testing. Wrote numerous Report programs using SQR for License and Certification Audit.
• Working with People Tools 8.40, Oracle 10g, and PeopleSoft 8.8, in HCM/HR On a conversion team to convert Performance Management that was on the mainframe. In People Soft wrote SQR conversion programs to convert the data along with Application Engine People Tools. Tested and documented all phases of the conversion.
• Working with People Tools 8.40, Oracle 10g, and PeopleSoft 8.8, in HCM/HR On a conversion team to convert the Law Department into People Soft Training Administration from an Access Data base. Wrote the majority of the conversion programs building staging tables, and then programs to update the PeopleSoft Tables, all programs written in SQR language. Wrote numerous reports that were in the State forms using SQR programming.
• On a build team writing On/Line People Code, working on SIR's fixing problems, and enchantments using SQR's and People code.
• On a team to upgrade the release of PeopleSoft to 8.8. Performed a large portion of retro fits that had custom code in People Code, Application Engine, and SQR's. Changed all of the Cobol program that was modified for Ben Administration.
• On a build team writing On/Line PeopleCode programs from detail design specs.
• On a production support team fixing On/Line programs, SQL's, and SQR's from SIR's created by the client.
• Working with a team of people to handle production support problems after the conversion process went live. Fixes included sqr's and online PeopleCode changes. Built tables, projects, pages and components using PeopleTools.
• Working with a patch instance to ensure that all programs and objects are current when moving forward to a new release. Retro Fit PeopleCode in the patch for the online that was out of sync in the development environment.
• PeopleSoft Benefits HRMS 8.8 conversion team. Responsibilities include developing sqr programs to build tax data from the legacy mainframe system to build Federal, State and Local Tax Tables for about 10,000 employees.
• Wrote conversion programs to build Dependent/Beneficiary Tables.
• Built all shell scripts on Unix platform for execution of all conversion programs.
• Built run books to run the entire conversion process.
• Responsible for the running of all of the conversion programs converting data from the legacy data to populate all of the Oracle PeopleSoft Tables on a UNIX platform.
• Ran Snapshot to convert all of the population to a valid Benefit Program.
• Ran DedCalc for the entire population for the Payroll Interface process.
• Developed balancing sequels in Toad to check the converted files for validity.

• PeopleSoft Benefits HRMS 8.8 testing team. Responsibilities include developing test conditions and test scripts for HRMS Base Benefits. Worked with the user when implementing the test scripts.
• Wrote sql searches to check out that the database in conversion instance is in sync with development instance after changes.
• Developed test conditions and test scripts for HRMS 8.8 Self Service. Worked with users to implement the test
• scripts as they executed the scripts.