Peoplesoft Technology Consultant Resume
SUMMARY:
Saravana has more than 14 years of progressive experience in the information systems industry. He has strong technical and functional skills in Workday HCM Service utilizing Custom report, Calculated Fields, EIB, Core Connector and PeopleSoft utilizing SQL, SQR, PeopleCode and PeopleTools, App Engine, Crystal Reports. He has extensively worked in PeopleSoft Installation (Installing Software), Upgrade, development, conversion, integration, and implementation of HCM, Payroll, Financials, CRM and Distribution systems. He possesses solid interpersonal and communication skills, which lead to productive user relationships and timely of project deliverables.
TECHNICAL SKILLS:
Cloud: Workday Integration Core - Workday HCM Service utilizing Custom report, Calculated Fields, EIB, Core Connector, XSLT, XML
ERP: PeopleSoft Ver 9x - HCM, Payroll, Financials, Purchasing, Inventory, Billing, Project, eRecruit, ePay, Time&Labor, eBenefits, Portal, CRM Portal.
Internet Application: CommerceOne, I2 Technologies -RightWorks, SABA.
Internet Product: Websphere, Visualage, JSP, Servlets, J2EE, Java, JavaScript, EJB, Bean, HTML, JFC Swing(GUI),JNDI.
Operating Systems: SCO UNIX, HP-UX, Windows Advance Server 2000, ILINK,windows NT 4.0 server, Windows NT service pack 3 and 6a, NT 4.0 Option Pack. - Clint 2.0.4.0, Oracle 8i on windows and Unix.
Languages: SQL, PRO*C
RDBMS: Oracle 8x, Sybase, SQL Server 7.0
Tools: HTML Access Terminology, Jolt, Application Server, Web Server, JMAC,PeopleTools, SQL/SQR, PeopleTools, Integration Tools, PeopleCode, SQR, Crystal Reports, PS/Query, nVision (layouts), Business Process Designer, Workflow, Convoy Conversion Tool, EDI, Winframe, PL/SQL, SQL* Forms 3.x. SQL* Plus, SQL Report 1.x.
PROJECT EXPERIENCE:
Confidential
Peoplesoft Technology ConsultantEnvironment: HCM, Peopletools 8.5, Services, Oracle
Responsibilities:
- Member of an implementation and support team that is involved in rolling out Peoplesoft HCM, to Confidential .
- This phase of the project consisted of maintaining peoplesoft HCM, application 9.1 and PeopleTools configuring PeopleSoft for n-Tier WAN based architecture.
- Implemented and worked on Employee Self Service functionality to Confidential HR system.
- Worked/Implemented on Time Tracking system and Confidential Time line system (TAM) where employees can enter their time on wkly basis and make sure both the system sync with HR.
- Supported the development of customized reports and queries. Some of these reports are currently in maintenance phase and often call for trouble shooting and problem identifying skills.
- Wrote numerous interfaces SQR’s which will convert, Validate data and insert in to peoplesoft tables and create flat files.
- Managed daily production support issues list for HR/Payroll system and provided mentoring for functional/Technical staff.
- Created multiple batch process to run AE,Peoplecode, SQR, COBOL process from the Server.
Platform: Oracle on Advance server, PeopleTools v8.5, Application v9.1.
Confidential, Dallas
Peoplesoft Technology ConsultantEnvironment: HCM, CRM, Peopletools 8.49, Services. Oracle
Responsibilities:
- Member of an implementation and support team that is involved in rolling out Peoplesoft HCM, CRM Field Services to Confidential, Dallas.
- This phase of the project consisted of maintaining peoplesoft HCM, CRM application 9.0 and PeopleTools 8.49.24 configuring PeopleSoft for n-Tier WAN based architecture.
- Supported the development of customized reports and queries. Some of these reports are currently in maintenance phase and often call for trouble shooting and problem identifying skills.
- Worked on the CRM month end process where the entire Project account and SO activity in sync with FSM.
- Worked on the CISCO B2B process which brings all the IP/Agreement changes from CISCO to keep Psoft system up to date by transfer data from CISCO to PSOFT on daily basis.
- Worked on the Agreement (Contract), Install Product, Service Order and Projects.
- Managed daily production support issues list for HRMS/CRM and provided mentoring for functional/Technical staff.
Platform: Oracle on Advance server, PeopleTools v8.5, Application v9.1.
Confidential
Environment: HCM, Payroll 9.0, Peopletools 8.4.9, Manufacturing, Oracle
Application Lead Technical & functional
Responsibilities:
- Responsibilities include leading the Configuration, data mapping and conversion process, interfaces and reports for all of the Technical teams, assisting with modification specifications regarding multiple components of pay as well as variable compensation and creating and managing Technical task lists with metrics that relate back to the overall project plan.
- Developed all conversion design strategies/Technical design, code as well as oversaw all development efforts as well as design, test case scenarios and ultimate production configurations and sent to offshore.
- Lead the project team through a database conversion from Tress (Legacy systems) to Peoplesoft. Co-ordinate the fit/gap analysis to implement HCM, Payroll for AM2 and Global Payroll.
- Worked on developing the Conversion, Interface and reports code, Testing (SIT, QA, Parallel and go live) as well.
- Prepared Materials and Conducting all daily/weekly Status Meetings.
- Reporting the status of the project to Senior Management on timely basis.
- Prepared integrated project plan for all Phases of this Project.
Platform: Oracle on Advance server, PeopleTools v8.4.9, Application v9.0.
Confidential, Houston
Environment: HCM, Payroll 9.0, Peopletools 8.4.9, Manufacturing, Oracle
Technical & functional member of an implementation and support team
Responsibilities:
- My team was responsible in ensuring that the front-end enhancements, interfaces and modifications done to the system were brought forward.
- Participated in the initial start up of a Human Resource, Payroll and Benefits PeopleSoft implementation. to the new version. The work compromised of enrolling high level executives from Confidential into Position Management and converting their data into Peoplesoft tables.
- Created new interface process for HPEDS to ADP to ensure that for each new company that files sent to ADP will pick up each new company.
- Created new interface process for HPEDS to Wells Fargo to setup new Wells Fargo accounts for 6 new legal entities to include outbound direct deposit files and check recons.
- Modified the online PeopleCode to allow the Final Check Program to handle refunding specific Benefit deductions as well as the reimbursement of outstanding leave time for employees that either transferred to other companies or moved from Full Time to Part Time status.
Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v9.0.
Confidential, Dallas
Environment: HCM, Payroll 9.0, Peopletools 8.4.9, Retailer, Oracle
Technical/Functional member
Responsibilities:
- Worked on Confidential Company HR Succession planning for home office and store associates. That involves AE, Peoplecode and online customization.
- Worked on the Service s process to communicate to the associates, JCP management and HR on milestone anniversaries for associates.
- Worked on Confidential new recruiting system for Home Office and Field Management recruiting. This project requests for additional functionality within eRecruit, enhanced reporting, the collection of additional survey data, and enhancements to the Careers page.
- Worked on HR/Payroll/ Benefits Administration SQR/COBOL Year-End Processing
- Worked on the Equity Grant Tracking (EGT) System to use for supporting the Compensation Department to administer the equity process.
Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v9.0.
Confidential, Dallas
Environment: WFA, Payroll, Peopletools 8.4.7, Health Care, Oracle
Application Technical
Responsibilities:
- Responsibilities include leading the Configuration, data mapping and conversion process, history data conversion for all of the Technical teams, assisting with modification specifications regarding multiple components of pay as well as variable compensation and creating and managing Technical task lists with metrics that relate back to the overall project plan.
- Developed all conversion design strategies/Technical design as well as oversaw all development efforts as well as design, test case scenarios and ultimate production configurations.
- Lead the project team through a database conversion from ADP to Peoplesoft, starting with PeopleSoft’s Payroll Version 8.9. Co-ordinate the fit/gap analysis to implement Payroll.
- Developed and Maintained Project Plan and Scope Documents.
- Evaluated Project Risk and Establishing Project Assumptions.
- Prepared Materials and Conducting all daily/weekly Status Meetings and Monthly Steering Committee Meetings.
- Evaluated Functional and Technical Skill Sets of Leads and Staff
- Identified Goals and Objectives as well as Project Scope
- Reporting the status of the project to Senior Management on timely basis.
- Prepared integrated project plan for all Phases of this Project.
- Managed issues list and payroll project plans and provided mentoring for functional/Technical staff.
- Prepared formal project plan and resource requirements for the Configuration, Conversion for the Payroll implementation phases of the project.
- Identifying Business Process areas for improvement.
Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v8.9.
Confidential, Dallas
Environment: Financials 8.9 - GL, AP, AR, Expense, CM, eProc, TE, Peopletools 8.4.7,Health Care, SQL Server
Technical member
Responsibilities:
- Worked and configured punch-out standard process for implementing Procurement System to Supplier Website Integration.
- Making sure that the batch process was modified to account for the change in the table structure with the new version.
- Installed, upgraded and maintenance pack 2 for FSCM application 8.9.
- Worked on App Server, process scheduler and web server configuration.
- Worked on Import Bank Statement, Reconciliation application engine process to load data from external bank to the staging table and then to peoplesoft tables.
- Configured eprocurement in FSCM 8.9 to create requisition, receive and approval process
- Worked on change assistance template manual and automated process and did complete upgrade from 8.4 to 8.9 (This include more that five iterations).
- Reporting the status of the project to Senior Management on timely basis.
Platform: SQL server on Advance server, PeopleTools v8.4.6, Application v8.9.
Confidential
Environment: CRM 8.9 - Field Services and Support, Peopletools 8.4.6,Insurance and Inspection Company, SQL Server
Integration Technical Lead
Responsibilities:
- Created AppEngine, CI and Peoplecode batch process which transfers data from WMS system and Lotus Notes homegrown systems to create service order in PeopleSoft CRM database and back to WMS and Lotus Notes database on real time daily basis.
- Reporting the status of the project to Senior Management on timely basis.
- Created error maintenance pages process which display data from the staging table with error code after each daily process.
- Created AppEngine, CI and Peoplecode batch process for Company, Site and contact data - LPS load which convert data from LPS system to peoplesoft.
- Created relationship between Company/Site, Site/Contact and Company/Contact in BO REL table in Peoplesoft CRM application by using AppEngine, Peoplecode.
- Identifying Business Process areas for improvement.
- Worked on the initial data load of Company, Site and contact from legacy system to peoplesoft after creating the relationship to create service order.
- Created process, pages, peoplecode, component and functionality for Dash board, End of Day, Trunk work.
- Data conversion and testing.
- Identifying options, as well as making recommendations based on the client requirements.
- Creating multi-level documentation for both executives as well as Business Analysts.
Platform: SQL server on Advance server, PeopleTools v8.4.6, Application v8.9.
Confidential
Environment: Peopletools 8.4.3, Retail Industry, Financials / SCM (AM, PC, GL, AP,AR, PO, INV, Order Management), Oracle 9i
Responsibilities:
- Worked on FTP process, which run SQR on the Batch mode to transfer files to several other servers.
- Designing and writing the GL, AR interface from Lawson homegrown legacy system to Peoplesoft system.
- Actively worked on preparing Application Engine Programs from data migration for he tables like PS ITEM, PS ITEM TOTAL, PS ASSET, PS DEPRECIATION, PS LEDGER, Journal Line, BI LINE, BI HDR from legacy to development environment and then to production.
- Extensively worked on nVision report layouts(Matrix and Tabular) .
Platform: Oracle 9i on 2000 Advance server, PeopleTools v8.4.3, Application v8.8.
Confidential, Dallas
Environment: Peopletools 8.4.3. Dotcom Industry, CRM Portal 8.8 - Order Capture, Oracle, Unix
Technical member
Responsibilities:
- Worked on designing, writing Free Basic Hot Link interface from Peoplesoft CRM (Vision) to a homegrown legacy system (Infohub system - both for the vision and Infohub population).
- Worked on bulk load interface process, which load data from flat file from customer on wkly basis to Peoplesoft vision tables.
- Developed Fullservice process, which include credit card validation with Cyber Source server for Self Service Administration on Confidential .
- Modified CRM Portal Home Page by adding several Sponsor Link, Business Profile and Categories. Also customized, maintained CRM portal page as required on day-to-day basis.
- Working on bug fix on daily basis, Business project, Daily App engine processes and SP1 upgrade on both application and tools.
Platform: Oracle 8x on 2000 Advance server, PeopleTools v8.4.3, Application v8.8
Confidential, Kansas
Environment: Peopletools 8.4.1, Communication Industry, Project, Financials, SCM, DB2, Unix
Member of an Implementation team
Responsibilities:
- Responsible for maintenance, development during implementation phase, instruct & handing of the application to client’s developers and creating documentation
- Designing and writing the Billing interface from the Peoplesoft Billing and Project system to a homegrown legacy system.
- Supported the development of customized reports and queries. Some of these reports are currently in maintenance phase and often call for trouble shooting and problem identifying skill
- Leading the bug fixing team and assigning bugs to the developers to get it done in appropriate time frame.
- Maintain affiliations and security: developed custom components, pages from scratch to maintain trade allys, customer offerings, territory, regions, service center, storage locations, worked on security using log on peoplecode, dynamic view, search record and edit table, prompt tables based on user and his roles on all the components.