CAREER SUMMARY

A highly motivated and resourceful team leader and player with progressive information technology experience. Strong analytical approach, identifying solutions to the problem, develop execution plan and achieving results. Proven high performer with solid organization skills, team and project management. Ability to learn new systems and processes very quickly with the ability to transfer that knowledge to others.

Total Experience: 12 years. (PeopleSoft 10 yrs)
Role played: Programmer Analyst, Technical/Functional Lead.

Technical Expertise

Hardware: IBM Mainframe, PC
Operating System: AIX, SUN SOLARIS, IBM ES 9000, Window NT
Languages: JCL, Micro-Focus COBOL, SQR, PL/SQL, C, C++, Perl, Korn Shell Scripting, XML
Databases: DB2, Oracle, SQL Server 2000, MS Access, Sybase
Software: Application Engine, Integration Broker, Component Interface, SQR, File Layout,
Messages, XML publisher, PeopleCode, Crystal Reports, Work flow, PS/Query, Application Packages

PeopleSoft HCM 6.0/7.0/7.5/8.0/8.3/8.8/8.9,9.0
Payroll (NA), HR, Benefits, T&L, Performance Management
eSS, mSS, eBenefits.
PeopleSoft Financials 7.5/8.0
General Ledger, Accounts Receivable
Talent Acquisition Management, eRewards.
Enterprise Learning Management PeopleSoft V9.0

WORK EXPERIENCE

Confidential
Title: Consultant Feb 09
Westland, MI

As a consultant , conducted workshops for students in Peoplesoft HCM module ( HR, Benefits and Payroll).
Prepared and Conducted technical workshop in SQR, Application Engine.

Environment: PeopleSoft HRMS 8.8 PeopleTools 8.48.08, Application Designer,Process Scheduler, SQR, Oracle 9i, Oracle 10g, PL/SQL, Application Engine, PeopleCode

Confidential, Jul 08 to Oct 08

• As a consultant worked with business client to design, test and implement Peoplesoft HCM and ELM reports. A total of six reports were created through sqr.
• Analysis of HCM and ELM rejects, and recommend solution to fix the data, configuration table, and the business process based on priority.
• Worked with business customer and created specification/document for external interfaces and designed the same through Component Interfaces.
• Worked with testing team to create test case scripts for HCM and ELM integration, interfaces, reports and queries. Coordinated with test team to ensure all the test cases passed successfully.
• Created documents/PowerPoint for user acceptance testing.

Environment: PeopleSoft HRMS 9.0, PeopleSoft ELM 9.0, PeopleTools 8.48.08, Application Designer, AIX, Process Scheduler, SQR, Oracle 9i, Oracle 10g, PL/SQL, Application Engine, Integration Broker, PeopleCode.

Confidential, Nov 06 to Apr 08
Title: Consultant
GM, Detroit, MI

As a consultant for EDS, worked with business client to analyze, design, test and implement PeopleSoftHCM (HR, PAYROLL, T&L, BENEFITS) and ELM application.

• Worked with General Motors architecture team, EDS data architecture team to develop a common conversion strategy to move Global HCM data into ELM.
• Assessed current requirement with Saba LMS, identified the gap during design and analysis phase.
• Mapped HCM data (V 8.8) to PeopleSoft ELM (V 9.0) for work force and personal data conversion and using integration broker.
• Worked with business and architecture team for design of ELM custom reports required by GM. 12 custom reports were created.
• Created specification and customization on Registration and completions summary and detail report layout, program status reports.
• Done performance tuning Workforce full sync and Person full sync app engine.
• Participated in numerous elm small projects, including creating learner groups, interfaces to Docent and other General Motors system, course launching , tuning and data maintenance
• Coordinated off-shore development activities to ensure technical design and construction builds meet business requirements and helped to rollout the elm phase 1.
• Created and designed proposal for managing external learners (contractors, vendors), internal learners in elm.
• Worked with global testing team to create scripts for component, unit and system testing.
• Upgrade to 8.9 from 8.3(Oracle green book) using Component Interface and Application Engine. Personal, Job, identification, payroll, 401 k loaded using Component Interface etc.
• Worked as project architect to help facilitate and ensure overall system development and architecture meets the clients’ methodologies.
• Maintained defect logs and participated in all levels of testing.
• Worked in Payroll data conversion from ADP
• Data conversion of benefits data from Fidelity investments using Component Interface.
• Designed and created numerous reports to check validity of payroll, T&L and benefits data during conversion.
• Tested the custom Labor Distribution process, validate results and implemented modifications.
• Designed specification to override earning data, T&L data on employee level.
• Designed and implemented on position management, jobcode and department structure.
• Created and maintained defect log and cutover document for the project.
• Participated in Component, Unit and System testing.
• Used SDLC methodology to manage and create project deliverables

Environment: PeopleSoft HRMS 8.8, PeopleSoft ELM 9.0, PeopleTools 8.48.08, Application Designer, AIX, Process Scheduler, SQR, Oracle 9i, Oracle 10g, PL/SQL, Application Engine, Integration Broker, PeopleCode

Confidential, Aug 05 - Nov 06
Senior System Analyst, performed as PeopleSoft Application Specialist.

Confidential, Englewood Cliffs, NJ

• Created specification for total rewards for Unilever global employees.
• Designed and created interface for Unilever Global Learning Management System to Accenture Learning management system.
• Designed the interface for converting LMS required HR information (user, work, manager) to Accenture on daily basis.
• Designed reports for Line Managers – Standard Learner Reports (Current activities, completed activities, Cancelled activities, Calendar view, Upcoming activities, Training History Report, Required and Recommended report, Evaluations pending report)
• Created conversion specifications on PeopleSoft foundation table for Vurv
• Designed and created interface between PeopleSoft Talent Acquisition Manager and Vurv.
• Involved in Fit gap of Position Management and Employee exit process.
• Designed and converted Unilever help desk data to Accenture help desk.
• Created specification for allowing negative amount in TL detail table as per HRIS memo.
• Created specification for process to load time and attendance data into paysheets multiple times without affecting the business process.
• Reviewed T&L interfaces, reports and requirements to determine changes based on the recommendation of Unilever HRIS team.

Confidential, Southfield, MI

• Installed Payroll Tax updates/patches, PeopleSoft bundles.
• Provided Payroll/Benefits support for Canada/USA
• Modified paycheck programs (both advice and check) layouts to accommodate employees Dow’s earnings, multi state taxes and general information
• Worked with Xerox to reinstall Dow logo on the printer and modified the payroll program to print the same.
• Modified payroll and benefit programs per Dow’s requirement.
• Created custom payroll programs to send payroll 401k deduction to Hewitt, benefits deduction to United Healthcare
• Designed and implemented ESPP business process (include modification in pages, payroll, programs and payroll reports)
• Created unix batch scripts to run Peoplesoft batch process as well as transmit and receive data.
• Designed and implemented Global Pay Planning, performance management.
• Participated in numerous projects including ESPP, T&L erncd changes, modified T&L detail flat file to accommodate business need (source indicator, paygroup etc for US and Canada), Benefits interface, Benefits eligibility interface, Open enrollment, EEO, W2, Year End Processing …

Environment: PeopleSoft 8.3 HRMS (Payroll, Base Benefits, T&L, Ben Admin, HR, Compensation), eRecruit, eRewards, LMS, Oracle 8/9i, DB2, Sun-Unix, Peopletools

Confidential, USA
System Analyst, involved in PeopleSoft Benefits implementation, PeopleSoft process engineering

Confidential, Detroit, MI Nov 02 - Aug 05

• Helped to rollout the retiree benefits
• Involved in end-to-end implementation of PeopleSoft retiree payroll/benefit process. ROI of this project --- $2 million annually.
• Involved and set the data in PeopleSoft foundation for Payroll / Base Benefits/ Admin for Active and retiredemployees
• Redesigned and implemented Retiree Benefits Premium Collection Process using Ford Motor Company Accounts Receivable team. The process eliminated Unicare; a third party accounts receivable vendor and manual reconciliation work. The process made Benefits system to adhere SOX compliance. Project realized expected savings of $1 million.

• Analyzed and estimated efforts for in sourcing Cobra and Cash Pay from Unicare
• Implemented Dental Contribution for the retiree. -- Work includes from setting up the PS Foundation table to end user reports. ROI of this project --- $600,000 annually.
• Conducted Fit-gap analysis between HR Portal and PeopleSoft e-products suite which jump started the implementation of employee self-service.
• Identified and lead dui diligence investigation of run-away base benefits / benefits administration project which was strategically planned for a separate instance away from the implemented Workforce module.
• Customized PeopleSoft components for Active and Retiree Population (Dependent Custodial, Medicare, Retro, Recon)
• Designed and implemented Derived Benefits Component based on Ford Motor Company Derived Benefit Plans and its various business groups.
• Worked on end-to-end Payroll/Benefit implementation for active and retired employees.
• Designed and created bimonthly payroll feed to AR, Comerica and Unicare.
• Implemented Dental Contribution for the retiree. -- Work includes from setting up the PS environment to Payroll feed to Comerica.
• Designed and created initial conversion program to load dental contribution from Legacy to PS
• Customized PeopleSoft components for Active and Retiree Population (Dependent Custodial, Medicare, Retro, Recon)
• Designed and implemented Derived Benefits Component based on Ford Motor Company Derived Benefit Plans and its various business groups.
• Worked in setting of Benefit Program, Plans, rates and vendor information for the financial year.

Environment: PeopleSoft 8.3 HRMS (Payroll, Base Benefits, AR) Oracle 8/9i, Sun-Unix, Peopletools, PVCS, autosys

Confidential
Confidential, NY Apr 02 - Aug 02

• Designed and implemented eligibility criteria for the participants to enroll benefit program through Open Enrollment.
• Designed rules and definition for removing of Non-Qualified Medical and Dental from the Benefit plans.
• Designed rules and definition for removing Beneficiaries from 1x plans.
• Created user manual and documents for the process.
• Worked in customization of eBenefits and eSS module.
• Customized eBenefits page through Peoplecode.
• Customized employee Self Service, including eBenefits workflow activity guides.
• Customized eBenefits Open enrollment workflow activity guide, Marriage workflow activity guide.
• Customized vanilla text.

Environment: PeopleSoft 8.3 (eBenefits/Ben Admin, ePay, Workflow), SQL SERVER 2000, Query Analyzer. NT, Datamover

Confidential, Hartford, CT Mar 01 - Mar 02

• Designed and implemented many interfaces, and reports in HR and Payroll
• Designed and implemented non ERP data into PeopleSoft
• Modified existing PeopleSoft Payroll COBOL Check print program to accommodate truncation error due to 10 millionth positions.
• Performed numerous adhoc reports using PS/Query and SQL
• Involved in upgrade of PeopleSoft HR/PAYROLL from 7.5 to 8.1 (Includes SQR changes,
• Application Designer upgrade, Customized local Peoplecode change to fit into 8.i)
• Worked on DataMover Scripts.
• Supported issues escalated from the Payroll team leads.
• Recommended eligibility standard for Hartford companies to participate in educational reimbursement plans.
• Involved in Open enrollment of benefits for 30000 active employees.

Environment: PeopleSoft HR 7.5/8.0 (HR, PAYROLL, BEN Admin) HP-Unix, Oracle 8i, SQR, People Tools, SQL*Plus, Crystal Reports, JCL, COBOL II, OS390, Import Manager, SQL Loader, Top Session for SQL tuning

Confidential, San Bernardino CA Nov 00 - Feb 01

Interface of FILE Net Panagon Document Services System with PeopleSoft Environment

• The FileNET system manages millions of documents, including images word processing

documents, spreadsheets, and engineering drawings. The system, designed to support thousands of users and provides a more secure and controlled environment, with centralized data storage.

• Designed the Interface module through the PeopleSoft System and made use of PeopleSoft

Security Administration. Created the Entity relationship between various objects used in the Interface module. A C dll was used to create connectivity between the Oracle database and the MTS Server. A view key was return from the MTS server that is used in conjunction with Active Server Page to get the data from the FileNet server and it will be launched through Internet Explorer.

• Entire Project was done through extensive use of Peoplecode.
• Created Specs for Filenet integration so as to make use of PeopleSoft security structure.

Environment: PeopleSoft HR PUBLIC SECTOR 7.5/8.0, Oracle, NT, MTS Server and Peoplecode

Confidential, LakeWood, NJ Sep 00 - Nov 00

Worked as a programmer/Analyst in PeopleSoft 7.5 HR and Benefits modules.

• Designed and development of Interfaces for their Benefits.
• Created SQR for their benefit enrollments and customized their HIPPA reports as per their business need.
• Used PeopleTools to establish operator and object security for the newly created panels and panel groups. Worked with query security.
• Created Payrule with Kronos.
• Created Specs for HIPPA to use asofdate rather than action date.

Environment: PeopleSoft HR Benefits 7.5, Oracle. People tools, SQR, SQL * plus, crystal reports

Confidential, New York NY Jul 00 – Sep 00

• Involved in conversion from the existing Legacy system (Tesseract) to PeopleSoft 7.5 environment.
• Involved in writing new Interfaces for Benefits and Payroll as per the client requirement.
• Worked extensively on Payroll and Benefits, created inbound and outbound interface.
• Created run control tables for process scheduler purpose.
• Involved in debugging SQR’s that failed in System Testing.
• Involved in Design, development, and testing of t Wrote numerous conversion Program
• Creation of Operators and Operator Classes and Customized Menus

Environment: PeopleSoft HR Benefits 7.5, Oracle, People tools, SQR, SQL * plus, crystal reports

Confidential, Singapore Jan 00- Jun 00

• Responsibilities include designing, coding, testing and documentation of reports in GL/AP modules.
• Made extensive use of SQR and Crystal Reports in this context.
• Created Interfaces that would validate any break in their sub ledger staging table. GL data was from both the People Soft table and Perl Programs that reside in POETS Financial Module written in Perl. Created Separate SQR for finding unmatched source in the sub ledger Staging tables. Created programs to find the manual and spreadsheet entries. Wrote new Budget reports (SQR) for GL module. Performed adhoc reports using PS/Query. Customized Chart fields. Created run control tables for process scheduler purpose.

Environment: PeopleSoft Financials 7.5 (GL, AP) Unix, Sybase, SQR, People Tools, ISQL, and PERL

Confidential, Rutland, VT Jan 98 - Aug 99

Responsibilities include analysis of the business process and developed and implemented various existing reports using SQR.

• Involved in design of new Reports and developed Interfaces. Customized existing panels and created new panels according to requirements.
• Extensively used People Code and People Tools such as Data Designer, Menu Designer, Panel Designer and Operator Security.
• Heavy interaction with the end-users to understand the process and implemented the changes accordingly.
• Documentation and unit testing set up Reports in the Process Scheduler.

Environment: PeopleSoft HRMS, DB2 v4.1/6.1, SPUFI, QMF, Peopletools 7.5, OS390, JCL, ISPF.

Responsibilities included Implementation, Generating Reports.

• Worked extensively on GL, AR, ASSET MANAGEMENT & PURCHASE Modules. Updated the regularized master tables.
• Involved in determining payable requirements of the end user set up payable tables, Process vouchers and payments, general reports and inquiries.
• Created interface from payables to the general ledger.
• Created business units, ledgers, and running journal generator to generate the lines of information on header and body.

Environment: PeopleSoft Financial 6/GEAC GL. VSAM

• LASER at Fannie Mac is a Mainframe application developed in COBOL, IDMS ADSO & Easytrieve. Several front-end applications that reside within the Client-Server cluster interact with the IBM Mainframe. LASER captures loan level information at the beginning of its Fannie Mac life cycle and continues its loan lever activity reported by Lenders, Validates and Updates through delivery, Payment, application and finally liquidation. Responsible for the entire Systems Test environment, handling the scheduling of jobs. Involved in setting up of Parallel Systems Test environment for the LASER system. Developed a new stream to re-add a loan from archives after liquidation. Developed new modules to enhance LASER application services and provided production support for nightly batch

Environment: IBM ES 9000, MVS/ESA, and COBOL

Confidential, JAN 96 – APR 95
Prowin-Image Editor

Software Engineer

• Developed Prowin image editor. The image editor included features for creating new picture files. Loading files with variable size Prowin has a color palette with 48 colors. It had a clipboard as well as supporting various editing options such as cut, copy, paste and undo.
• The Project: Hypermedia Concept of interactive multimedia has backed used extensively in this work. The objective of this work is Hypertexting and Hyperimaging. Hypermedia facilitates navigation from one topic to any media element picture, sound, video. Hotspots are provided on both text and image. It checked at hotspots, details of the topic concerned would be displayed at the hotspots. A Hotspots editor through which the user can alter the hotspot positions on, the picture according to the requirement is also provided. Animation is used to visually comprehend the different control loop actions of process plant. Each loop has been customized with voice describing the loop action and the individual components.

Environment: MSVC++ 2.0, WINDOWS 95, WINDWOS SDK

EDUCATION

M.S., Computer Engineering
B.S., Electrical Engineering

Formal PeopleSoft Training:

Introduction to Benefits, Payroll interface, Payroll, Payroll, Introduction to GL, Introduction to Payables, Competency Management, Recruiting Solutions (ERecruit), Introduction to Time and Labor, PeopleTools I, PeopleTools II, PeopleCode I, PeopleCode II, PeopleTools Delta 7.5 to 8.3, Integration tools, Introduction to Workflow, Application Engine, Application Messaging, SQL/SQR, Query/Crystal Reporting, nvision