PROFILE:

• Completed PeopleSoft 9.2 upgrade, Experience of seven successful project implementations & production support. Have over 16 years experience in PeopleSoft Finance, HCM, SCM, ELMS. Experience in E - commerce, Java / Client Server Apps. SAP Hana
• Extensive experience in Installation of Software, Upgrade, Development, Conversion & Integration, Implementation of
• Workforce Management, HCM Payroll & Benefit, T&L, Supply Chain and supplier Relation Management. ELMS, Fin modules.
• Have worked with Reporting Tools, (nVision, Query/Crystal, SQR report, XML/BI Publisher.) Tree Manager, PeopleToolsPeopleCode, Data Mover, Application Engine, Application reviewer / Debugger, Import Manager and Change Assistant.
• Extensive experience General Ledger, Accounts Payable, AR/Billing, Budget, Asset Management
• Experience in SQL Server, Oracle, DB2 and PL/SQL. Web Client, Configuration of BEA/Tuxedo / JOLT server
• Experience in creating Summary Ledger, Summary Tree & Winter Tree and PUM(PeopleSoft Update Manager).
• Reporting experience in using OLTP / OLAP Slicing/Dicing Tools Power Play, Cognos and Essbase, SQA Robot.
• Experienced as Techno-Functional Consultant in ProgrammingBudgeting, Financial Control, Production & Quality Assurance. Committed & proven track record of excellence & hard work.
• Working on Oracle 12c Certification. Have worked with TOGAF & DODFA using SDLC, Release Management & Automation

TECHNICAL SKILLS:

• PeopleSoft 9.2, 9.1
• PeopleSoft 9.0
• PeopleSoft 8.9
• PeopleSoft 8.44
• PeopleTools 8.55
• PeopleSoft 7.5
• PeopleSoft 7
• PeopleSoft 6
• Workforce Management, HCM Payroll & Benefit, T&L, Supply Chain and supplier Relation Management
• PeopleTools, PeopleCode, App. Engine, Data Mover, Web Client, Configuration & Administration.
• General Ledger, AR/Billing, Inventory Control, Accounts Payable, Project Costing, Asset ManagementBudget, nVision, Query/Crystal, SQR Reports Power Play, XML Publisher, Essbase, Import Manager, SQA
• Robot.
• Applied People Tools upgrade.
• MS Office, Crystal Report Professional, AutoCAD, Lotus 1-2-3 and SAS.
• ASP, Java Script, VB Script, Websphere, Visualage, JSP, Servlets, J2EE, Java, EJB, Bean, HTML, JFC Swing
• (GUI), JNDI.
• UNIX, Linux, HP-UX, Windows NT Server, Windows 7 and 8
• C, C++, COBOL, Visual Basic, Power Builder, Visual C++, SQL, PRO*C, PeopleCode
• WAP - WML
• Oracle 7, 8,9i,10g and 11g, 12c Sybase, MS Access, FoxPro, DB2, SQL Server 7.0 to SQLServer 2012
• HTML Access Terminology, Jolt, Application Server, Web Server, SQL/SQR, PeopleTools, PeopleCodeSQR, Crystal Reports, PS/Query, nVision (layouts), Business Process Designer, Workflow(AWE), Convoy
• Conversion Tool, EDI, Winframe, PL/SQL, SQL* Forms 3.x, SQL* PlusHardware
• PC Confidential Compatible, DEC Alpha, SUN-SPARC, HP, Confidential RISC 6000, AS/400, Citrix

PROJECT EXPERIENCE

PeopleSoft Senior Consultant

Confidential, Dallas, TX

Responsibilities:

• Provided Support HCM (Administration, Payroll, Benefits, Time & Labor, Plan succession) and Table setup.
• Created App. Engine to take 2 existing Query for Terminated and Retired Employees and produce CSV file
• Modified 2 Benefit Custom SQR to create CSV file to be uploaded for other Financial modules.
• Modified Application Engine Code to read flat file for Processing into Financial and Benefit Modules.
• Working with ORACLE for Leave Accrual Process Discrepancies on PeopleSoft delivered Pages.
• Providing Training to other team member for BI Publisher and complicated Process and Critical issues.

PeopleSoft Senior Consultant and SAP Hana Data Modler

Confidential, Oak Ridge, TN

Responsibilities:

• Worked on Transition form SAP to PeopleSoft for 2 different facilities of Department of Energy, US Govt.
• Trained Employees to write SQR and develop PeopleSoft Application and Support function.
• Modified 4 Benefit Custom SQR to upload Employees Benefit Data to Fidelity Benefit Programs.
• Provided Production support for PeopleSoft Payroll and Benefits modules.
• Learned SAP Hana Data Modeling and SQLScript. Worked on ePerformance and Career Planning.
• In Process of Installing SAP Hana on single Machine with Hana Studio and Client Programs
• Provided technical and functional support for PeopleSoft 9.2 and 9.1 HCM Payroll and Benefit Applications.
• · Worked on Data conversion.
• Evaluated Rsync(file), Rainfinity(Network-based file), DMM(data migration manager), HDS(Hitachi Data System)

PeopleSoft Practice Senior Consultant

Confidential, Dallas, TX

Responsibilities:

• Provided Support HCM (Administration, Payroll, Benefits, Time & Labor, Plan succession)
• Provided Solution to Critical Issues.(GL, AP, e-Procurement Project costing Asset Mgmt.)
• Created HCM 9.2 Functional Setup documents to run North America payroll and ELM support
• Created FSCM 9.2 Functional Setup documents with fluid Page.
• Installed FSPUM 8.53 VM with People Tools 8.53 and configured the optimal setting
• Installed HCM 9.2.4 VM with People Tools 8.53 and configured the optimal setting.
• Installed FSCM 9.2.2 VM with People Tools 8.53 and configured the optimal setting.
• Installed HCM 9.2.013 VM with People Tools 8.54. Configured ELM Setup Table.
• Installed Fusion 12.1.3.0 on Windows environment. Configured ELM node and IB.
• Refresher Courses for Oracle 12c Database (Container and Pluggable DBs). Used ODI.
• Worked on different integration technology such as SOAP, REST and Component Interface

PeopleSoft Senior Consultant

Confidential, Alpharetta, GA

Responsibilities:

• Supported and provided Solution to Critical Issues. Client had many outstanding issues affecting performance. Provide solution for GL, AP, e-Procurement modules. Modified nVision reports
• Wrote many SQL Script for cleanup of Data(PO HDR, RECV HDR, Vendor and voucher)
• Provided solution to AP MATCHING Process for missing Receipts match with Voucher.
• Provided solution to PO CHANGE issue for re-setting or restarting the Process by cleaning up tables.
• Provided solution for copying Journals from ADJUSTMENT Ledger to ACTUALAS (SOX Audit)
• Configured Hyperian 11.1.2.3 and SmartView setups. Debugged Expense implementation issues and Process.
• Installed and Configured Oracle Fusion Middle ware 12.1.3.0.0 on single machine.

PeopleSoft Senior Consultant

Confidential, Dallas, TX

Responsibilities:

• Supported and provided Solution to Critical Issues.
• Client had many outstanding cases logged that were affecting the system.
• Provide solution for HCM & Finance
• Helped customer with expense set up and reports.
• Travel authorization and Time Report. Worked on App Engine and SQR modification for loading Essbase.
• Production support as HCM Admin, Payroll, Benefit Admin and Time and Labor.
• Supported data conversion for payroll North America(ADP). Worked on nVision Reports.
• Worked in Security administration, Modified users Roles, Permission lists and Object Security.
• Worked on enhancement using Application Designer, PeopleCode, App Engine, upgrade AssistantComponent Interface, Process Scheduler, Workflow(AWE) Application Messaging, Data Mover.
• Participated in FIT/GAP Analysis, Prepared Technical Upgrade Plan Sessions and Analyzed
• Upgrade/Compare Reports. Populated FDI field for vender setup in e-Procurement.
• Worked on Time & Labor, Self Service, PeopleSoft Portal, Modified SQR for Asset management.
• Worked on Informatica, Essbase EPM and Change Assistant with PUM(PeopleSoft Update Manger)
• Setup Big Data Lab with 10 IBM/HP Servers.
• Worked on PUM, Oracle VirtualBox, PeopleSoft Project Discovery & Endeca Information Discovery.
• Provided support for Oracle 10g, 11g backup & recovery at client site. Monitoring, Job scheduler.
• Worked on the upgrade Project from PeopleSoft 8.9 to 9.2. Did the fit gap analysis.
• Worked on connected query to build some XML Publisher Reports. Configured ELM node and IB. created new Security Roles to fit the business requirements. Configured ELM Setup Table

Information Specialist Senior

Confidential, Plano, TX

Responsibilities:

• Gathered functional business requirements for issues and new enhancements. Translated functional requirements into Technical Spec. Created Tables, Pages, Components and Menus.
• Developed & tested Projects. Unit tested and regression tested with users and migrated to production.
• Modified SQR and SQC to accommodate the change of Social Security Number with GMIN to meet the egulatory requirements. Did vendor setup in e-Procurement for catalog/ hosted clients.
• Participated in GCOM Knowledge Transfer from Wipro Technology to Confidential Team.
• Configured STAT (Quest Migration Tool) for ELMS module with Quest Engineer. Modified Workflow configuration Security Administration Roles and Permission List.
• Supported and provide Solution to Critical Issues. Debugged SQR, App Eng. Worked with Integration Broker.
• Used Informatica ETL for Data Extraction
• Did setup of Installation, Processing & Default rules in Primary Permission List, Business Unit & TableSet
• Control Tables. Established HR foundation tables in sequence of table setup, default value
• Reviewed effective Dates and Actions.
• Extensively worked in Setup HRMS for Set ID, Business Unit, Company, Location, Job Codes, Department, Pay Group, Job Attrib. & Compensation rules.
• Utilized Import manager & Data mover for data migration. Created the data mover script to load mass data in
• PS Tables. Developed new AE/PeopleCode program to read data from legacy systems.
• Used file Layout to map data for PeopleSoft Tables (Personal Data, Education, Employess Review)
• Used Component Interfaces to validate and insert data into respective PS Tables

PeopleSoft Consultant

Confidential, Dallas,TX

Responsibilities:

• Provided support for GL / AP and AR module. Debugged GLS9002.sqr (Import text file and FSPGJEN
• Debugged APPSTVCH.AE (Voucher Posting) Program.
• Supported and provided Solution to Critical Issues. Solved outstanding cases logged that were affecting the system.
• Debugged and recoded SQR, PeopleCode and APP. Eng programs.
• Monitored Batch Jobs and other critical processing. Provided PeopleSoft Administration Support.
• Worked in PeopleSoft 8.3 to 8.9 Upgrade, Development, Enhancement and Testing of HR, NA Payroll and
• Benefits Administration modulus. Participated in PeopleTools upgrade
• Used PS Upgrade Assistant Tool to load the upgrade template for various task, Prepared upgrade scripts and reviewed compare reports.
• Worked on Migration Data from ADP to PS.
• Worked on Security Administration, Modified users Roles, Permission lists and Object Security.
• Worked on enhancement using Application Designer, PeopleCode, Application Engine, Component InterfaceWorkflow, Application Messaging, Data Mover, Upgrade Assistant.
• Modified SQR Reports/Process. Used Process Scheduler, Security Administrator. Worked on Grants.
• Participated in FIT/GAP Analysis, Prepared Technical Upgrade Plan Session and Analyzed
• Upgrade/Compare reports to determine which PeopleSoft objects to upgrade
• Provided on site solution for Transportation issue for Transportation company.
• Analyzed HR, Base Benefit. NA Payroll Data in Legacy System (ADP PC-Payroll) and evolved strategy to migrate the employee’s data from legacy to PS System.
• Had access of ADP PC-Payroll and its Data-Extracting Tool (Report Smith) to pull employee data in excel sheets.
• Mapped data fields in ADP Tables and loaded ADP Data in PeopleSoft Tables.

PeopleSoft Consultant

Confidential, Dallas, TX

Responsibilities:

• Was a Member of the Critical Issues Solutions Team. Client had many outstanding cases logged that were affecting the system. Debugged and provided solutions to outstanding issues.
• Created Batch Job monitoring projects & integrated it with portal registry.
• Did security administration work, Modified users Roles, Permission lists and object security.
• Debugged application messaging PeopleCode (Integration broker and LDAP)
• Worked on specialized retirement savings and investment products and services. Implemented
• HR, Benefits Administration, NA Payroll modules of PeopleSoft HCM 8.3.
• Configured and setup Personal data, Job data, Salary Plan and Employment Data for new hire.
• Involved in set up of core foundation tables for recruitment Work Force & plan successions with HR
• Worked in Payroll process to Create Pay sheet (earnings), Payline, Online check.
• Debugged HR FASTVIEW, G HR FASTVW & G HR PER501 (salary update) App. Engine.
• Worked as a member of support/upgrade team responsible for the delivery of the projects.
• Wrote Audit SQR report, Functionality enhancement on Grievance & Discipline panels in HRMS
• Worked with STAT Tool and Migration Process
• Involved in modifying & testing the SQR and App. Eng. process to retrofit the changes.
• Developed/Customized/Modified PeopleCode Programs, Pages, Components, record definitions.

PeopleSoft Consultant

Confidential, Dallas, TX

Responsibilities:

• Provided Fit/Gap Analysis to Issues/Solutions. Provided solutions to outstanding cases / issues.
• Modified and tested the Auto Compare of General Ledger to Trust Ledger, Benefits Billing Payment, Finance
• FTE Report, Salary Accrual, Labor Distribution detail, Payroll/Benefit Invoice, GL report, Hyatt Legal deduction and Morgan Stanley Deduction Payroll reports.
• Modified AP APGLOPEN Application Engine program to meet the criteria for populating AP OPEN LIAB table, Client opted to apply the patch that takes care of this problem.
• Modified AP PSTVCHR App. Engine for the voucher posting.
• Recreated nVision Drill Downs, and tuned nVision queries for Crystal reports.
• Created two VB Macro Budget Upload programs and two Excel input sheet for Budget data entry
• Modified some SQC to cater for the customized programs. Modified Asset management reports.
• Installed and configured PeopleSoft on Oracle database.
• Setup the new Payroll system for New Page corporation enrolling about 500 employees in Benefit Plans and migration of Data from ADP.

PeopleSoft Consultant

Confidential, Dallas, TX

Responsibilities:

• Worked as a Member of the implementation team involved in the upgrade to 8.17 from PeopleTools 7.59 and Application 7.51. The first phase of the project involved the following:-
• Recreated nVision Drill Downs, Tuned nVision queries and recreated indexes on
• Installing software (Demo), configuring App. Server, Webserver & Process Scheduler server.
• Created table spaces, run statistics, monitoring database for both demo and system.
• Worked on SQR interface which extract data from the legacy system and insert in to the
• PeopleSoft database after validation.
• Involved in fit gap analysis with the functional teams to ensure the teams reach the clients
• Business process requirements.
• Worked on consolidation process in General Ledger, Modified SQR for Asset Management.
• Modified Voucher process by adding BR approver id and Br sal use tax, fields to ECIN001.sqr and Voucher Build and Voucher Edit Application Engine Program.
• Created Payouts Module (10 Tables, 10 Panels and 5 SQR to process vendor Payments monthly)
• Provided support to HRMS, Payroll and Benefit administration.
• Debugged SQR & Modified Unix scripts for change of Data center from Tulsa, OK to Eagan
• MN. Wrote new SQR Report that showed the over/under payment to the employees benefit
• Created component interface and designed business interlink for future enhancements.
• Used Application Messaging system with existing process.

PeopleSoft Consultant

Confidential, New York

Responsibilities:

• Provided Production support to end-users on AR/Billing, AP/GL & Payroll/Benefits Worldwide.
• Modified interface SQR, wrote store procedures and triggers, Modified Crystal report for Currency conversion.
• Involved in the design and development of new reports and panels in Inventory module. Wrote SQR program for new inventory count sheet and inventory reconciliation reports.
• Analyzed, created report and panel for the client’s warehouse shipping label and packing slip from the current
• VB(RSA)
• As a PeopleSoft Technical consultant provided support to PeopleSoft HRMS and Payroll Group. Analyzed the
• Payroll Problems and providing solutions to the users.
• Built tables, Panels & modified SQR for the new online system and Tax Rate.
• Coded new SQR, Modified existing SQR to support combing reports into a Job Data update Form to be used as a daily turnaround document for the position management system.
• Worked on panels for training administration, temporary hires and specialized development document systems.

PeopleSoft Consultant

Confidential, Kansas City, Kansas

Responsibilities:

• Created Flat Rate VW for Basic Life & Supplement Life Benefit prog & designed the panel for data entry.Created 21 Crystal Reports and 2 SQR report(HRMS & Benefits) Wrote spec for united health care panel mod.
• Implemented the infrastructure set up for BEA/Tuxedo / JOLT Server & Web client functionality.
• Designed Security module for Budget. Created Tables, Views, Tree Run control & data entry panels.
• Analyzed future needs of the client, made recommendations about various needs of applications.
• Worked with the end users closely to gather the requirements and created Tech. / Functional Spec.
• Creating Test scripts, executed Test scripts, analyzed the results with the technical team.
• Provided Production support for Workforce Management, HCM Payroll and Benefitsl.