ROFESSIONAL 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

Senior Systems Analyst

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.

Independent Developer/Senior Systems 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.

Confidential

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.
• 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.
• 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.
• Developed balancing sequels in Toad to check the converted files for validity.
• Ran DedCalc for the entire population for the Payroll Interface process.
• 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.

• PeopleSoft Benefits HRMS 7.59 support team. Responsibilities include monitoring Benefits Administration runs, trouble shooting, application enhancements, and running of Payroll Interface for BI-Weekly, and Monthly payrolls.
• Wrote sqr for nightly processing of New Hires setting up their benefit flags on the job table.
• Wrote sqr for Open Enrollment that recalculated employee's Benefit Eligibility Compensation BEC for the next year processing. Wrote sqr for BEC Recalc, to adjust the employee's BEC from a data feed provided by Payroll and adjusting the Life Insurance settings based on the new BEC Amount.
• Work with the Functional Users to insure that all events are processed and that the elections are applied. Write queries, SQL, and SQR programs to accomplish various tasks including issues resolutions.
• Work with vendors to create feeds and arrange file delivery. Open enrollment processing including setting up new plan year programs and modifications.
• Work with DBA's and SA's to coordinate environment issues. Set up Autosys jobs, and modified Micro Focus Cobol for the BenAdmin processing.
• Part of the conversion and implementation team setting up all the rules, program and plan tables, and converting data from a mainframe DB2 system to the PeopleSoft HRMS7.51/Oracle tables as well as running Snapshot processing.
• Also responsible for PeopleCode modifications, Panel changes, Cobol modifications, Vendor interfaces, reports, UNIX shells scripting as well as data gathering and various modification specifications. System was up and running within eight months of the initiation of the project.
• Project manager for the Blue Print System Employee Stock Option Plan running on the mainframe. In charge of 5 people setting schedules, code reviews, task assignments, and performance appraisals.
• Wrote the main update program using Cobol/2 for a new system Stock Option Plan , for clients outside of Merrill Lynch. The program was written to handle multiple clients setting up there initial records and posting there stock options, program was approximately 6,000 lines of code and produced about 20 output files.
• Wrote reports in Cobol and Easytrieve, set up MVS/JCL to execute the above programs.
• Rewrote numerous reports for the Accounts Receivable System. Reports written in Cobol/2 and Easytrieve.
• Wrote new On/Line application for Direct Cash in the Accounts Receivable systems using CICS.
• Rewrote a major portion of their On/Line system for Manpower Control Conductor Tracking using CICS.
• Converted CICS 1.6 to 1.7 changing the FCT tables for shared pools and including the dataset names for dynamic allocation when starting CICS.
• Wrote Tracking reports for conductors and Trainman in Cobol and Easytrieve.
• Involved in full support for a Mutual Fund System, Online CICS and batch Cobol/2 programs. All reports written in Easytrieve.
• Installed a Transfer Agency Mutual Funds package. My role was helping in the On/Line, and batch programs to install the package. The software package was COBOL and CICS.
• Developed JCL to the company's standards.
• Wrote new programs and modified existing programs for user requests.
• Involved in dividend processing for daily and periodic processing.
• Wrote sub system for bulk-transfer from one account to another. All database files where VSAM . Involved in day to day production support.
• Account Manager in charge of eight people for a medical claims system. My role involved writing Cobol programs in CICS, testing using CEDF and INTERTEST.
• Created and modified test data through interest and VSAM utilities.
• Directed plans for unit testing, system testing, quality control, standardization and implementation of the system, both in bath and On-Line. Distributed and monitored work to my staff of consultants.
• Developed, designed, coded and implemented an Explanation of Medicare Benefits to government specification for a closed bid contract . All work was done in Cobol/2 using VSAM file structure.
• Headed dental check system. Made major system modifications for improving a free form dental check and statement for an insurance company. The system consisted of modification of about fifteen programs and adding six new programs.
• Set up all new OS/JCL documentation and run book procedures. Worked closely with outside vendor in designing the new check and statement.