Summary

• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, and ability and willingness to communicate when help is needed.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
• Extensive experience in tuning processes, analyzing and determining necessary steps to improve timing and performance.
• Worked with management to implement Best Practices around the system and SOX controls.
• Over 18 years of experience in the field of information technology, implementing information systems utilizing ERP solutions, Mainframe and Client Server technologies.
• Over 14 years of experience in software design, development, implementation, upgrade and support of PeopleSoft 7.5,8.1,8.4,8.9,9.0,9.1 , HCM CoreHR,Benefits,Payroll,Self Service, eRecruit,eBenefits,ePay,Payroll Interface Fin GL, BI, AR, AP, AM , SCM OM,PO, Inventory and Manufacturing PP,PM
• Worked as Senior PeopleSoft Consultant with full life-cycle implementation, including gathering business requirements, performing fit gap analysis, designing new or modified business process maps, application configuration, enhancements and conversion specifications, system testing, UAT, production move and production support.
• Strong Team Player with strong communication skills and the ability to independently solve problems.
• Have been the lead and developer for multiple on-line/batch customizations of PeopleSoft applications as well as conversions, interfaces and reports
• Proficient in SDLC, High level Designs, Fit Gap analysis, Customizations, Data conversions, Migrations, Report writing, up-gradation methodologies and standards of PeopleSoft applications using People Tools , People code, App. Engines, Component Interface, Integration Broker, Data Mover, PS Query Manager, Object based People code, App Packages, SQL,SQR and Crystal.
• Having strong knowledge on Agile and Waterfall software methodologies.
• Extensive experience in Data Conversions, Interfaces, Customizations, implementations, Reporting and upgrades of PeopleSoft Applications.
• Experience with end user training and preparation of training material and user documentation.
• Having strong experience in Tax Updates, Bundles, MPs, applying patches and fixes periodically to PeopleSoft applications to make them current
• Direct Interaction with customers. Clear written and oral presentation of ideas, proposals and concepts. Strong listening, interpersonal analytical skills.
• Extensive experience in IBM Mainframes, client server and web technologies using COBOL,DB2,JCL,IMS, Endevor, VB,Java Script, ASP,XML,HTML,Web Servers

SKILL SET

• PeopleSoft 7.5x, 8.4x, 8.9,9.0,9.1 PeopleTools - Application designer, PeopleCode, PS-Query, SQR, Crystal Reports, Application Engine, Component Interface, PS Query, Tree Manager, nVision, Workflow, Upgrade Assistant, Change Assistant, XML Publisher, Data Mover, Process Scheduler, App-Messaging etc.
• Application Area - HCM/Financials/SCM/Manufacturing CoreHR,Benefits,Payroll,Self Service, eRecruit,eBenefits,ePay,Payroll Interface, PO, Inventory, OM, AP, PC, AM, AR, GL, Billing,PM,PP,Kanban Systems
• Languages - SQL, PL/SQL, C, COBOL, UNIX Shell Scripts etc.
• Mainframes - MVS, TSO/ISPF, COBOL, JCL, DB2, CICS, IMS etc.
• Client Server/Web - VB, ASP, XML, HTML ,Java Script etc.
• Data Bases - Oracle,DB2,IMS,SQL Server etc
• Operating Systems - MVS, UNIX, Windows XP/2000/2003/2007, MS-DOS etc.

PROFESSIONAL EXPERIENCE

Confidential

Senior PeopleSoft HCM/Financials Techno functional Consultant

• Responsible for new enhancements and production support activities in 9.1 HCM and 9.0
• Financials system
• Worked closely with business users for requirements analysis, created design solutions to meet business requirements and involved in test plan and UAT.
• Involved in all upgrade activities in upgrading PeopleSoft HCM HR, Payroll, Benefits,
• Benefits Administration, ESS, MSS, E-Recruiting system from 8.8 to 9.1
• Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the People soft functionality.
• Designed and Developed SQRs to create medical extract interface files to Aetna,
• CIGNA,BCBS etc.
• Responsible for applying tax updates, patches, fixes, bundles, yearend updates to both
• HR and Financials system. Responsible for PS Project migrations, and working with PeopleSoft Oracle Support on issue resolutions.
• Worked closely with project architect and data base team to resolve issues and performance issues for various PeopleSoft modules.
• Involved in developing personal data, GL data interfaces from HR to Financials using
• Integration broker messaging technology.
• Involved in creating several PS queries in HR and Financials and nVision reports for GL
• reporting.
• Developed application engine programs to load data from HR and financials systems to
• CHI Systems.
• Troubleshoot any problems that might arise in the payroll calc/confirm process, pay sheets
• update for employees time and salary information, salary increments etc.,
• Modified HR/Payroll systems SQR reports per user requirements Involved in database tuning to improve run time performance.
• Developed integration broker messages between HR and Financials to exchange data
• Provided assistance in identifying, evaluating and developing systems and procedures in the PeopleSoft Financials environment and Responsible for Batch scheduling and monitoring PS Jobs and providing application support for job failures and emergency fix
• Designed and Developed different reports for HCM and Financials using XML Publisher.
• Involved in User security Roles, Permission lists and row level security using tree Manager
• Tuned the application engine programs, data mover and SQL scripts to improve Data
• conversion performance for 9.1 Upgrade.
• Monitor Integration Broker gateway activities for any message subscription/publication
• errors and resolve the issues.
• Analyze the tax updates, fixes and bundles release notes and estimate its impact to the
• Payroll system and apply tax updates using Change Assistant to DEMO, development and
• Production databases.
• Migrate code projects between Development, test and Production databases. Run
• compare reports and analyze the changes thoroughly before production migration
• Ensures best practices are being followed and guides resources to complete tasks according to plan and develops test cases and configuration against technical specifications
• Responsible for assignment of technical tasks to other team members and working closely with management team specialists to ensure that the final system meets or exceeds all current service levels and reporting requirements
• Designed and developed solutions for user requests including customized billing invoices, PO dispatch reports, AP and Receive functionality reports and many customizations
• Extensively used Process Scheduler to set-up process and jobs to run. Modified process definition security based on user group profiles and updated process defn components for various processes to run from different sources
• Translates users requirements into technical specifications and configures application to meet requirements and primary point of contact for project team on technical task requests

Environment: PeopleSoft 9.1/9.0 HCM, People Tools 8.51/8.49,SQR/SQL, PS Query, Component interface, Application, Engine, People Code, XML Publisher, Workflow , Integration Broker, Messaging, Tree Manager ,crystal reports and nVision Toyota Motor Manufacturing, Erlanger, KY Jan'11 Mar'14

PeopleSoft Financials/SCM Applications Lead Consultant

• Involved in the Toyota's SCM and Financials Support of OM, PO, INV, MFG, AP, AR/BI and GL. Worked extensively on Customizations and Production support for SCM and Financials modules.
• Working as Applications Project Lead APL on day-to-day production problems and major responsibilities include design and development of People soft customizations, interfaces and troubleshooting production issues for Financial applications
• Worked closely with business users for requirements analysis, created design solutions to meet business requirements and involved in test plan and UAT.
• Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the People soft functionality.
• Worked closely with project architect and data base team to resolve issues and performance issues for various PeopleSoft modules.
• Provided assistance in identifying, evaluating and developing systems and procedures in the PeopleSoft Financials environment and Responsible for Batch scheduling and monitoring PS Jobs and providing application support for job failures and emergency fix
• Ensures best practices are being followed and guides resources to complete tasks according to plan and develops test cases and configuration against technical specifications
• Responsible for assignment of technical tasks to other team members and working closely with management team specialists to ensure that the final system meets or exceeds all current service levels and reporting requirements
• Responsible to work closely with Finance/Accounting/SCM user personnel, technical support personnel of other groups and other business unit personnel to troubleshoot and resolve system issues related to PeopleSoft Financials/SCM applications
• Working extensively with object oriented People Code, application engine, file layout objects, component interfaces, PS Query, Crystal Reports and SQR processes
• Involved in design and customization of INV replenishment and Toyota Interunit transfers.
• Designed and developed solutions for user requests including customized billing invoices, PO dispatch reports, AP and Receive functionality reports and many customizations
• Extensively used Process Scheduler to set-up process and jobs to run. Modified process definition security based on user group profiles and updated process defn components for various processes to run from different sources
• Translates users requirements into technical specifications and configures application to meet requirements and primary point of contact for project team on technical task requests
• Performed set up of PO Email and multiple UOM by Item, worked on EDI tech requirements, solved issues in security, invoicing voucher process , matching and payments
• Involved in creating new SQL views to provide data on search pages and customized tables and pages by adding new objects according to client specifications
• Modified custom EDI Map definitions using EDI Manager as the EDI table structures have changed.

Environment: PeopleSoft FSCM8.4, PeopleTools 8.46, SQR, App Engine, PS Query, Integration Broker, Component Interfaces, Crystal Report, EDI Manager, Connect Direct, Oracle. Convergys Corporation, Cincinnati, OH Feb'09 Jan'11 PeopleSoft HCM/SCM/Financial Functional Consultant -PO, AP, AR/BI and GL

• Involved in the Convergys HCM,SCM and Financials support and implementation of PeopleSoft9.1 on ,Core HR, Payroll, Benefits, Self Service, eModules, PO, AP, AR/BI, and GL.
• Involved in Fit - Gap sessions with business users on Payroll, Benefits, PO, AP, and GL Modules, Design Business Processes, Functional Specs for Data Conversion, Enhancements and Interfaces.
• Served as Lead developer for HR, Benefits, Benefits Admin, Payroll, Recruiting, Self
• Service system
• Worked on the issues in various integration interfaces, conversions, Application Engine programs and creating new reports.
• Supported interface programs for to get and send data from other systems like Java and XML developed XMS to the PeopleSoft System.
• Worked with the Convergys management team for necessary enhancements, testing and migration.
• Designed and Developed SQRs to create medical extract files to Cigna, United, BCBS etc
• Developed App Engine/Component Interface process to load Department changes,
• employee status changes from an external application to Peoplesoft HCM database
• Worked extensively on the Core HR, Payroll, Benefits,PO,AP,AR/BI and GL modules to resolve issues as part of production support.
• Developed System testing, Integration test Scripts with different test scenarios for testing by the testing team, Coordinate with System testing for fixing the issues as per users.
• Assisted Super users with System testing and UAT for functionality of system setup changes, review the entire setup changes with them
• Responsible for Pay Cycles process customization AP APY2015 to meet business requirements
• Worked with different SQRs/Application Engine batch processes for HR, Payroll, Benefits AP,PO,GL and AR/BI

Environment: PeopleSoft 9.1, People Tools 8.51, SQR, Crystal Reports, App Engine, XMS, Control-M, PS/nVision, Oracle, Unix.

Confidential

PeopleSoft SCM Functional Consultant

• Involved in the implementation of INV and PO modules with their integration with AP and GL on people soft 9.0.
• Involved in Fit - Gap Analysis on INV and PO Modules, Gathering requirements, Design Business Processes, Functional Specs for Data Conversion, Enhancements and Interfaces.
• Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the People soft functionality.
• Worked with Deloitte team for necessary enhancements, testing and migrating from Development environment to testing environment.
• Extensively involved in implementing RICE objects.
• Involved in writing Functional specs for custom reports for INV and PO modules.
• Involved in customization of Item Setup, Item copy and loading items from GHX.
• Involved in conversion scripts from legacy systems to people soft.
• Involved in Setup, Configuration on INV and PO Modules.
• Involved in developing business process documents for users.
• Involved in design and customization of INV replenishment, Interunit transfers, Order Fulfillment for Kaiser Needs.
• Involved in writing functional specs for interfaces/App Messaging with Kaiser and Vendors
• Involved in custom design and development of Item Loader App Engine program
• Involved in developing functional specs for customizations and meeting with business users.
• Involved in preparing functional test scripts and functional testing for INV and PO modules.
• Involved in setup functional test environment with Deloitte.

Environment: PeopleSoft FSCM9.0, PeopleTools 8.49, SQR, SQL, PS Query, Component Interface, App Engine, Oracle, XML Publisher, EDI Manager ,UPK and UNIX

Confidential

PeopleSoft Financials/SCM/HCM PeopleSoft Consultant

• Involved in the Toyota's SCM and Financials upgrade of MFG, OM, PO, INV, AP, AR/BI and GL. Worked extensively on Production support for SCM , Financials and HCM modules.
• Involved in Fit - Gap sessions on PM,PP, OM, PO, AP,AR/BI and GL Modules, Gathering requirements, Design Business Processes, Functional Specs for Data Conversion, Enhancements and Interfaces.
• Did Setup, Configuration and Prepare CRP for PO, Inventory and AR/BI, Present CRP for the Client approval.
• Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the Peoplesoft functionality.
• Developed Conversion scripts for Data conversion from Legacy systems to the PeopleSoft System.
• Developed a new peoplesoft interface to incorporate a Bank change for ACH direct
• deposit files from Bank One to Chase Manhattan Bank
• Involved in enhancement/maintenance and production support of the PeopleSoft modules
• in HR, Payroll, Benefits and Pension Systems, which includes off hours support
• Worked with team for necessary enhancements, testing and migrating from Development environment to testing environment, tested and got approved as per client needs.
• Involved in Open Enrollment/Ben Admin process and Modified HR/Payroll systems SQR reports per user requirements
• Involved in database tuning to improve run time performance and developed a process upload general deduction information for united way
• Immensely Involved in Implementation of complex interface programs to move data from
• the legacy system to the PeopleSoft using SQR as primary tool.
• Developed System testing and Integration test Scripts with different test scenarios for testing and coordinated for fixing the issues as per client satisfaction.
• Assist Super users with System testing and UAT for functionality of system setup changes, review the entire setup changes required as per client needs
• Gather report needs from the client, developed reporting specifications for the reporting team to develop the reports as required
• Involved in design of Integration Broker to send data from Financials to HRMS and Vice Versa.
• Developed Configuration Document as per Set up done and developed training document and end user procedures
• Worked with customizations of different SQRs and Application Engines processes.
• Wrote complex SQL Queries using joins, unions and nested sub-queries.
• Worked with users to troubleshoot issues in production and test various test Scenarios in designated test domains.

Environment: PeopleSoft FSCM8.4, PeopleTools 8.46, SQR, App Engine, PS Query, Integration Broker, Component Interfaces, Crystal Reports, VB, ASP, Mainframes, EDI Manager, Oracle. United Parcel Service, Louisville, KY Feb'01 - Mar'04 PeopleSoft HRMS HR, Payroll, Benefits Techno Functional Consultant

• Gathering requirements and create business process models based on client requirements.
• Coordinate multiple testing iterations to confirm client's business requirements have been met
• Involved in Open Enrollment/Ben Admin process.
• Modified HR/Payroll systems SQR reports per user requirements
• Involved in database tuning to improve run time performance.
• Involved in Implementation of interface programs to move data from the legacy system to the PeopleSoft using SQR.
• Used People Tools like Data Mover, Import Manager, and PS-Query to load the data from
• test database to production database and to develop queries for Business users to validate
• Trouble shooting and issue resolutions for post production support
• Worked with go live issues and post production Support issues by optimizing performance, streamlining processes, providing timely follow-up on issues.
• Completed full life-cycle with Fit Gap analysis, Business Processes reengineering, Designing, Developing, Testing and Post Production Support
• Worked with enhancements, participate in structured functional walkthroughs and reviews.
• Test the functionality of fixes following the appropriate migration path from Development to UAT and then to Production by preparing Migration Documents and necessary approvals.
• Work with super users, technical analysts, Database Administrators to identify production issues, trouble shooting to resolve the issues.
• Finalize functional specifications with super users for customizations and enhancements in the processes.
• Responsible for submission and tracking issues/cases logged with users and follow up with support team to resolve the issue and record the fix.
• Developed Queries for customer information reports to generate for the client and migrated to Production after approvals.

Environment: PeopleSoft Financials 8.1, People Tools 8.15, SQR, PS/nVision, App Engine, Oracle8i, Crystal Reports and UNIX.

Confidential

• NCBS Non-Metered is one of the subsystems of New Commercial Billing System NCBS and provides a means to invoice large and mid-size customers for a wide variety of services. NCBS supports location level billing functionality. NCBS supports Alliance, Business Markets and Local customers.
• NCBS Non-Metered System
• Accept feeds related to non-metered events from other systems and put the information received into formats suitable for invoice processing.
• Distribute non-metered events to external systems.
• Services support by NCBS includes audio conferencing, cellular, CPE, DAL, directline MCI, frame relay, local, paging, private line, and remote access.
• Primarily involved in system development using COBOL, JCL, DB2, IMS, CICS and VSAM.
• Responsible for analysis and design and coding of programs for new scope items.
• Responsible for system testing and production support.
• The project involves enhancements on the previous release.
• Served as point of contact for production issues.

Environment: OS/390, VS COBOL II, JCL, TELON, DB2, SPUFI, QMF, CHANGE MAN, IMS, CICS, SDF, FILE AID, XPEDITER and VSAM

Confidential

• CABS requires biannual release as per the OBF. In each release there are so many changes to the TAD system. These changes to TAD will enable MCI to process billing data that is received from the Telcos in different formats of the CABS BOS. In each release we get requirements from the users and we implement those requests in our system. The Billing information provided by the TAD system enables MCI to receive, pay and audit Telco bills in an automated fashion the changes brought about by each release will give the Local Exchange Carriers additional billing capabilities of which MCI must process for payment and audit.
• Primarily involved in design and system development using COBOL, JCL, TELON and DB2
• Responsible for analysis and design and coding of programs for enhancement requests.
• Responsible for system testing and production support.
• The project involves enhancements on the previous release.

Environment: OS/390, VS COBOL II, JCL, TELON, DB2, SPUFI, QMF, IMS, VSAM, CHANGE MAN, CICS and XPEDITER

Confidential

• Analyzed the requirements and prepared the technical plan.
• Coding, testing and implementation of the modules.
• Conversion project, which is a development and enhancement project.
• Enhanced, maintained, and tested on-line and batch production programs.
• Involved in testing using QAHIPERSTATION.

Environment: MVS/ESA, COBOL-II, VSAM, DB2, JCL, QMF, SPUFI, CICS, IMS-DB/DC, XPEDITER