Summary

• Twenty Four years of consulting and end-user company experience with Manufacturing, Engineering, Utilities, Paper, Banking, Insurance, Aircraft, Reseller and Services industries in systems development and package implementation services in USA and India. Wide variety of experience in areas such as systems analysis, systems design, construction, data conversion, system testing, performance testing, training, implementation, project management, strategic information systems planning, software package evaluation, data warehousing, database administration and system administration. Also, experienced in change integration and business process transformation.
• 4 Years of experience in SAP ECC 6.0 EHP 5 HCM Personnel Administration, Personnel Development, Organization Management, Time Management, Payroll, Benefits, Payroll to FI/3PR Integration, ADP Interface
• 12 1/2 years of experience in PeopleSoft HRMS HR, Payroll, Benefits, BenAdmn. Modules package implementations as a technical consultant/project lead/development team lead and knowledgeable in PeopleSoft Financial modules.
• 12 years of experience in PeopleSoft PeopleTools Application Designer, PeopleCode, Components, Component Interfaces, Application Engine, Application Messaging, SQR, Crystal Reports, Workflow etc
• 16 Years of Oracle Database technologies/tools experience.
• 11 Years of DB2/MVS/JCL experience.
• 14 Years of Project Leadership / Application Development Manager experience.
• 5 Years of web development experience.
• Knowledge of SOX Sarbanes-Oxley regulations as applies to IT.

SKILLS

PROFESSIONAL EXPERIENCE

• Worked as a HR Subject Matter Expert representing National Grid business for USFP SAP Release 3 Enhancements.
• Guided both on-site and off-shore teams various IS Partners in implementing best of breed solutions
• Lead on-site testing teams in performing Integration, Regression and User Acceptance Testing of USFP SAP Release 3
• Manage day-to-day defects and change requests starting from initiation to implementation
• Expert knowledge in HR SAP Batch Processes
• Expert Knowledge in SAP to ADP HR Interface
• Strong business process / functional knowledge in Human Resources, Time, Payroll, Compensation, Org. Management and Benefits

Responsibilities/Accomplishments Included:

LIPA Transition Project

• Reviewed 60 RICEFW Functional Specs for LIPA transition project and made sure that each FS reflects needed changes.
• Participated in the business/functional and technical sessions and contributed to the completion of functional and technical design deliverables.
• Reviewed data conversion functional specs and provided the feedback to the development team
• Worked as a HR Subject Matter Expert representing National Grid business
• Closely worked with several IS Vendor Partners
• Experienced in working with Off-shore and On-site delivery model
• Provided testing strategy expertise to NG HR Team Lead
• Reviewed Integration Testing Results to ensure that testing was done as per the test scripts
• Received National Grid IS Star Award in the month of August 2013

Confidential

• Received IBM Excellence Award for contributions towards post go-live support and W2 generation.
• Developed several data extracts from legacy NG and Keyspan PeopleSoft environments to support W2 data validation/reconciliation effort executed by Deloitte
• Viewed as a key legacy HR person who has expertise in both data extractions, conversions, interfaces, etc
• Resolved complex payroll related issues such as no net pay, short pay, over payment.
• Validated ACH, Positive Pay and ADP Files for weekly, monthly and off-cycle payrolls.
• Created a template for ADP File Validation so that both net pay, bank files matches ADP Files
• Viewed as a subject matter expert for ADP Payroll Interface
• Closely worked with several IS Vendor Partners
• Experienced in working with Off-shore and On-site delivery model

Confidential

• Participated in the collaboration hub design sessions for data conversion, configuration sessions, RICEFW Objects
• Worked as a key legacy subject matter expert for HR related work
• Worked with 15 External Vendors to establish the file transfers. HR work stream was the only work stream with highest no. of interfaces and no. of external vendors
• Experienced in working with Off-shore and On-site delivery model
• Worked with 25 legacy interfaces NERC/CIP, SEAL, DOT, Safety IMS, etc partners to ensure that USFP impacted changes are completed
• Worked with Legacy Interface Partners in testing the legacy interfaces changes
• Worked as a Subject Matter Expert for Interfaces on USFP Integration Testing and fulfilled Interfaces Integration Testing duties
• Worked with NG US Batch Scheduling team and Application Development team to schedule several batch jobs including critical interfaces like CIP004
• Achieved USFP Star Award

Confidential

Responsibilities/Accomplishments Included

• Contributed to the development of Business Process Design BPD , Requirement Traceability Matrix RTM , Business Process Mapping List BPML documents for HR Workstream.
• Developed Reviewed 54 Functional Specs for interfaces outbound from SAP and Inbound to SAP , Enhancements.
• Worked on the Detail Design aspects of several custom OM Object Types such as Line of Business, Sub Line of Business, Function and Sub Functions
• Contributed to the configuration of Employee Groups, Employee Subgroups, Personnel Area and Personnel Subareas
• Provided PeopleSoft expertise when developing detail design solutions e.g., Union Gain Sharing, inbound outbound interfaces using SAP PI in SAP.
• Contributed to the Data Mapping of PeopleSoft HR/Payroll/Benefits Tables to SAP HR Info Types. Architected the Data Conversion approach for Personnel Number, OM objects Org. Units, Jobs, Job Family, Positions, etc number generation from legacy PeopleSoft systems.
• Reviewed data conversion functional specs and provided the feedback to consulting partner teams.
• Carried out SAP ABAP Code reviews.
• Contributed to the creation of Business Test Scenarios, Test Cases and Test Conditions development to carry out Assembly Testing, Product Testing.
• Attended SAP HR, Master Data Configuration, Organization Management, SAP NetWeaver, SAP ABAP Training.

Confidential

• Lead Analyst for the implementation of 401k interfaces with Vanguard. The interfaces include outbound demographic data and 401k contributions file and inbound contribution percentages and loan data file.
• Lead Analyst for the implementation of AFLAC interfaces with AFLAC Insurance. These interfaces include inbound and outbound.
• Lead Analyst for the implementation of Administer Training using BusinessObjects Reporting and Health Safety Modules of the system.
• Lead Analyst for Variable Compensation Pay custom implementation which processed bonus payouts for 9000 employees
• Lead a team of 3 team members for a custom Salary Planning / Compensation Planning application. Developed custom SQR programs to calculate variable pay and produce variable compensation statements.
• Worked as a Project Manager to implement .NET application for Compensation Department and internal Recruiting Services Department.
• Talent Management System Project -- Created an Application Engine Program to extract data from PeopleSoft HRMS 8.9 tables and publish XML messages to MQ Series and then submitted to SAP HR. Also created custom tables to store SAP Position Numbers for all eligible employees. 4 new SQR reports are also created to support the associated business processes.
• Worked as a Project Manager / Lead for a Data Conversion Project with a team of 3 People to convert data from Oracle HRMS/Payroll to PeoplesSoft HRMS/Payroll. This conversion includes Core Employee Data, Payroll Data, Tax Data, Benefits and History HR and Payroll .

Production Support:

• Developed Training course catalog and training course data extracts to feed it to 3rd party web applications.
• Provided bi-weekly payroll production support on 24/7 basis.
• Provided .NET applications production support as needed.
• Resolved 8.9 Upgrade related issues. Developed a new custom page to track employee performance evaluation ratings. Debugged / Analyzed Upgrade 8.9 Application Engine Programs.
• Provided technical support for PeopleSoft HRMS 8.9 implementation.
• Worked on new customizations as well as trouble shooting existing SQR interface programs.
• Used Application Designer and PeopleTools to create new objects in PS Version 8.0/ 8.9 such as projects, menus, portal structure content, components and pages for the various custom and customized objects.
• Conduct user meetings and maintain / manage system change requests.
• Working as a backup security administrator for PeopleSoft V8 HRMS application.
• Performed infrastructure analysis for PeopleTools Upgrade.
• Work with users to develop new programs and modify existing programs.
• Performed Hardware and Software Requirements Analysis for PeopleTools Upgrade.
• Developed custom in-house solution to generate Total Compensation Statements from PeopleSoft tables.
• Worked as a team member for Integral HRMS Data Conversion into PeopleSoft HRMS. Participated in the data mapping to convert Integral Data into PeopleSoft HRMS
• Implemented HR WorkforceSync and Person data sync messages from HR to Accounts Payables. Configured messages and message channels in HR.
• Trained Co-team members on how to code SQR programs.
• Fixed HR Application engine program bugs and trained users on PS/Query Tool.
• Implemented PeopleSoft Health Safety Module including OSHA300 functionality.
• Technical Environment: IBM DB2 8.1, Oracle 10g, OS/390, JCL, QMF, PeopleSoft HRMS 8.9 / 8.0 / 7.5 / 7.02, PeopleTools 8.47.03 / 8.21.06, Components, Component Interfaces, PeopleCode, Application Engine, Workflow, Application Messaging, Integration Broker, Import Manager, Data Mover, SQR, Crystal Reports 8.0 / 9.0 / 10.0 , etc., PL/SQL Developer, TOAD, STAT, ASP.NET, Data Services, XML Web Services, VB.NET 2005, ADO.NET 2.0, SAP HCM Personnel Administration, Personnel Development, Organizational Management, Time Management, Payroll, Benefits and Payroll to FI/3PR Integration

PricewaterhouseCoopers PeopleSoft HRMS Implementation project - PeopleSoft HR/Payroll/Benefits Modules

• Project Orbit is an effort to implement PeopleSoft HRMS 7.5.1 for PWC with an employee population of 50,000 . This engagement involves customization and implementation of PeopleSoft HR/Payroll/Benefits modules for all US employees.
• Development/Customization team lead responsible for developing/customizing on-line objects fields, records, panels, panel groups, menus, process definitions, peoplecode, etc , reports crystal and SQR and batch update programs SQR .
• Developed project plans for design and build phases of the project related to PeopleSoft customizations.
• Developed technical design documents for On-line panels, reports and batch processes.
• Technical lead for interface team of 11 people for 5 months.
• Lead a team of 7 people during the design and construction of on-line objects fields, records, panels, panel groups, menus, process definitions, peoplecode, etc. reports and batch programs change requests.
• Managed a team fixing test problem reports TPRs related to on-line, reports and batch update programs.
• Participated in the minor upgrade of PeopleSoft HRMS 7.50 to 7.51.
• Identified which PeopleSoft tax updates and patches to apply to all environments i.e, system testing, conversion, parallel testing and production.
• Performed customisation impact analysis from time to time with the help of PeopleSoft compare reports to apply PeopleSoft Tax Updates and Patches.
• Assisted global reporting team who was implementing a custom data warehousing solution to facilitate the data mapping of various PeopleSoft code table values from local at country level to global level.
• Played a key role in analyzing the TKPROF output, identification of indexes and re-writing of some critical SQL statements. Actively involved in the identification of rule based vs cost based optimizer selection for certain key SQR interface programs for 3 months.
• Heavily involved in performance tuning of several SQR reports, batch programs and interfaces.
• Provided production and implementation support for all on-line objects, reports and batch processes.
• Technical Environment: PeopleSoft HRMS 7.51, PeopleTools 7.54.1.0, SQR, Crystal Reports, PVCS, Oracle 8.0.5, Citrix and Sun Solaris OS.
• B2B eBusiness to Business OrderManager Implementation Project for major Aircraft Engine Co.,, Computers Monitors reselling Company, Chemicals Mfg. Co., Database Administrator/Database Integrator,
• Worked as a Oracle 8I DBA /Database Integrator for a leading provider of B2B business-to-business Order Management solutions for Global 2000 and e-marketplace clients.
• Lead database person for 4 implementations of this OrderManagement software product.
• Analyzed, designed, developed and customized PL/SQL modules to migrate the data from the backend system to the Order Management application.
• Developed / customized Unix Shell scripts to enable smooth backend integration.
• Gathered, analyzed and documented requirements to migrate data from client's back-end system for each implementation by conducting client interviews.
• Experience in integrating Oracle with existing backend enterprise systems, ranging from legacy architectures to the state-of-the-art ERP systems.
• Technical Environment: Oracle 8i, PL/SQL, Java, HTML, Sun Solaris OS, HP-UX, ClearCase, HP 9000 Series.

Confidential

Development Manager

• This engagement involves installation and customization of PwC's leveraged Software product called WCIS.
• Heavily involved in providing on-site support for post live implementation and performing enhancements to the existing system.
• Worked as a development manager for a team of 10 people including client staff.
• Developed technical design documents for new enhancements.
• Responsible for managing change requests and test issues through completion tracking actual hours against budgeted hours for each task.
• Managed delivery of new enhancements to the system and developed several new Oracle Forms, SQR Reports, batch programs and PL/SQL stored procedures and functions.
• Technical Environment: Oracle 7.3, Oracle Forms, PL/SQL for Stored Packages, HP-UX, SQR, PVCS, etc.

Confidential

• Collected systems requirements with heavy interaction with the client staff.
• Developed detailed design documents for new enhancements.
• Designed and construction of Oracle Forms, Oracle Stored Procedures/Packages and SQR Batch Programs/Reports related to policy underwriting module.
• Acted as a development manager for construction phase of this project. The team consists of 13 developers 10 from PwC, 3 from client .
• Team leader for fixing test problem reports of this project. Enhancements were approximately 10,000 hours, to be completed in 4 monthly intervals.
• Technical Environment: Oracle 7.3, Oracle Forms, PL/SQL for Stored Packages and Triggers, HP-UX, SQR, PVCS, etc.

Confidential

• This engagement entailed installation and conversion of a claim and policy-processing application supplied by an Australian vendor called Heathcal. The project work includes design and development of major software modifications, stress testing, and capacity planning, training, and organization of a new production operations unit.
• Conducted analysis, design, construction, and implementation of routines to convert claim and policy information from the client's existing VSAM and ADABAS legacy application files to the new claim and policy application and the interfacing legacy applications remaining in or carried over from the IBM environment.
• Worked on policy underwriting and endorsements modules by designing and constructing forms and reports using SQL Forms and SQR Reports. Managed a 2 resources team in this project.
• Technical Environment: RUMBA for VAX, HP9000/80, HP-UX, Novell Netware 3.12, Oracle 7.0 Database, Oracle Developer/2000, SQR, Pro C

• Worked on the design and construction areas of Custodian System in accounting and correspondence modules.
• Provided Oracle technical support to the team members and delivered some lectures on Oracle RDBMS.
• Acted as a team lead for 3 people.
• Technical Environment: HP9000/F20, UNIX SVR 5.4, Novell Netware 3.11, Oracle 7.0, SQL Forms 3.0, Pro C, SQL Report Writer

Confidential

To implement SAP, the client decided to build an as-is business model with the objective of restructuring some of its business processes. The assignment initiated with the identification of areas for business process re-engineering, which included identification of business processes for further improvement, process validation, preparation of SIPCO diagrams, identification of NVA and elimination of NVA from the business process es . Played a key role by collecting and framing the information from various finance departments across client locations throughout India.

Confidential

Evaluated different RDBMS packages as part of PwC Technical team and recommended to the Bank.

Confidential

Prepared identification of target applications document. Developed an information systems strategy. Prepared implementation plan.

Confidential

Conducted analysis, design, construction and implementation of Cash/Bank, Accounts Receivables, Site Accounting, Investment Accounting and Tax Modules. The applications were developed using Oracle RDBMS and its tools.

Confidential

Lead a team of 3 resources, involved in the analysis, design, construction and implementation of financial accounting and billing system. The applications were developed using Oracle 6.0, SQL Forms 3.0, SQL RPT/RPF and Pro C.

Computerization Project - Project Management support

Worked as an Ingres Database Administrator DBA as well as Unix System Administrator in this project.

Involved in study, analysis, and design of an integrated production management system and cost estimation system for PVC and XLPE cables. Sole individual selected to work from ACE Software and Management Consultants, worked on this engagement.