Summary

• PeopleSoft Certified Consultant worked on various Implementations, Upgrade Maintenance projects on PeopleSoft ERP for 8 years.
• Worked on Core HRMS, NA Payroll, Global Payroll, Base Benefits, Epay, Eprofile, Compensation HCM Modules of PeopleSoft HCM
• Worked on General Ledger, Accounts Receivable, Account Payables, Asset Management Modules of PeopleSoft Finance
• Worked on Activity Based Management ABM Module of PeopeSoft EPM.
• Worked as PeopleSoft Application Developer on Application Designer, Application Engines, PeopleCode, XML Publisher, Online Page designing, Component, Excel To CI, PS Query, Component Interface, SQR, Data Mover
• Worked on tools like STAT CSR Migration , PACT Production Access Control Toolkit , SRS Application for Ticket/Issue tracking Resolution, Autosys, SVN, JIRA, Service Now, Hermes Portal
• Worked on Data warehouse ETL using Talend, development of Business Objects BO Reports Universe
• Conducted training on nVision, XML Publisher Reporting, SP debugger, PVCS Upload/Version Control Tool
• Good exposure to Quality Management Tools including RPM Rational Portfolio Manager Quality Testing Tools like Quality Centre to ensure all the necessary processes are in place to meet project goals.
• Worked on Data conversion coordinating with onsite counterpart for data conversion
• Worked on PeopleSoft Security Roles Permission Security, Data Security AXA Bolt on Specific Security

Technical Skills

• ERP PeopleSoft HCM 9.1, 9.0,8.9,8.3, PeopleSoft FIN 9.0, 8.9, 8.8, 7.5 PeopleTools 8.48,
• 8.49,8.50 Application Engine, SQR, PS Query, Component Interface CI , File Layout,
• Excel to CI, PeopleSoft Internet Architecture, Workflow, Data Mover
• Languages PeopleCode, C, C ,SQL, PL/SQL
• DBMS Oracle 9i/10g,11g, MS SQL Server, DB2
• Packages Microsoft Office

Work Summary

Confidential

Role : EPM/ABM PeopleSoft Consultant

Responsibilities:

EPM/ABM PeopleSoft Consultant

• Responsible for Setup and Configuration of Models, Resources, Activities and several ABM Components.
• Design, Modeling and Conversion of PeopleSoft ABM Model to SAS ABM model
• Developed Monthly and Historical ABM Models in PeopleSoft for different businesses in Citigroup Capital Markets
• Data modeling for series of Layers of Allocation like R to A Resource to Activity , A to C Activity to Cost object , C to R Cost Object to Revenue Layer , Cost Object to Front Office FO layer.
• Requirement Gathering/Analysis, Development, Testing, Peer/Quality Review
• Day to Day Coordination with Various teams like IRIS, PMA business , BO team Reporting , ETL team, Offshore India Singapore Teams for the monthly and historical ABM model execution.

Confidential

Data Analysis BO Reporting

• Developing ETL Jobs using Talend Tool, Data analysis, Performing Validation Checks
• Setting up Pre-ETL Framework for new feeds onboarding DQ Framework for validations checks on feeds. Dealing with issues related to it coordinating with various teams
• Worked on development of Independent Generic Tool Toolkit for performing Allocations using ETL, Stored Procedures and UI Interface.
• Worked with Business to define different methodologies to allocate Expenses to Front Office Desks based on trade volumes, Fixed percentages etc
• Used various tools like JIRA, Service Now, Autosys Jobs and its automation tools like CA Workload, SVN, Hermes developer Portal
• Instrumental in development of Generic Data Extraction Loading GDEL utility to have one Generic ETL based on configuration across different streams.
• SAP BO Development of Universe and Custom Reports. Worked with business to create canned reports for validations.
• Supporting Map Measure Activities It is a Java based tool which facilitates Operation's business owners to certify which activities are being worked by employees in the operations line of business across different asset classes like Cash Securities, Money Markets etc. It has workflow automated email flow mechanism. My responsibility was to debug issues faced by user, analyze them and provide fixes. The fix mostly involved modifying or building new Packages/Stored Procedures behind the UI interface or data fix.

Tools Used Application Designer, Application Engine, Component Interface, SQR, PeopleCode, Unix, Talend 4.1.3 to 5.2.1, Oracle 11g, PL/SQL Stored Procedures, SQL Developer 3.0.04, Microsoft SQL Server 10.50, SVN, Autosys, CA Workload, Service Now, Hermes Portal

Environment : PeopleSoft 9.0, PeopleTools 8.50, Oracle

Confidential

Role : Technical Lead Analyst

Responsibilities :

• Production fixes Production release works.
• Test scenario creation for fixes in Development, Quality Assurance and User Acceptance testing environments.
• Creating a Technical Design document and getting a Functional designer sign-off on them.
• Post production release activities.
• Maintaining security.
• Monitor day to day batch jobs.
• On call support.
• Performance tuning on existing processes.
• Reapplying customization after applying Maintenance Pack on existing PeopleSoft system.
• Peer review for the Technical Deliverables like design and code
• Various Tools being used in the projects are STAT CSR Migration , PACT Production Access Control Toolkit , SRS Application for Ticket/Issue tracking Resolution, Autosys, Unix, FTP file, Application Designer, Application Engines, PeopleCode, Page Designing, Excel To CI, PS Query, Data mover, AquaData, SQL Plus, Component Interface, Winscp, PACT tool and SQR
• Enhancement activities Building New Interfaces , Online Customization, Reports for new region implementation.

Environment : PeopleSoft HRMS 9.0, 8.8, 7.5 PeopleTools 8.49, Oracle

Confidential

Role :Technical Lead / Onsite-Coordinator Client site

Responsibilities:

• Gathering requirement from Client Business Team, Preparing the Technical Design documents after analyzing the functional requirements Issue and gap analysis of the problem Design, Construction and Testing.
• Creating Analyzing the Upgrade Compare report and indentifying the amount of customization to be brought forward.
• JOB related components de-customization in 9.1
• Unit testing : Prepared test plans and test data
• Worked on upgrading complex custom SQRs interfaces/ batches to be upgraded. SQRs related to external system interfaces, Customized payroll related SQRs as per customer needs, modified delivered XML publisher template and built new templates for paycheck oncycle / offcyle and manual checks as per customer requirements.
• Project Migration - Raising Migration request , creating the OMR forms and verifying migrated projects.
• Worked as PeopleSoft Application Developer on Application Designer, Application Engines, PeopleCode, XML Publisher, Page Designing, Excel To CI, PS Query, Data mover, Component Interface and SQR.
• PVCS tool to upload SQRs and Version Control
• Data Conversion Post upgrade Scripts
• Analyzing the Upgrade Compare Report and help in decision making for Retaining or De-customizing.
• Implementing Online customizations post upgrade to bring in the Client specific customization from 8.8 to 9.1
• Peer Review of the work assigned to offshore members before delivering to client/functional users.
• Onsite Coordination with Client Team and with offshore team.
• Assisted in PeopleSoft HR Application Upgrade from 8.8 to 9.1. Database Oracle upgrade to 11G
• Delivery and Upgrade of Client Bolt-on Modules like Job Action Manager JAM , Total Compensation Planner TCP , Applicant Tracking, Archival , Attendance Tracking
• Re-implemented customized client specific payroll sqrs paycheck and advices to include client customization and new 9.1 XML Publisher.
• Designing customized XML publisher template from Employee Self Service Paycheck epay Module to work for Offcycle Manual and Oncycle Paychecks.
• Retro-pay implementing using Application Engine and CI.
• Involved in full cycle of System Integration Testing
• Coordinated migration of changed objects between various database instances.
• Conducted Knowledge Transfer sessions for the Client Team.
• Involved on PeopleSoft Security Roles Permission Security, Data Security Client Bolt-on Module Specific Security
• Designing Security for specific client modules and integrating single sign-on to use only 1 UserId going forward in 9.1. Client used to have more than 1 Userid to access different Bolt-on modules in 8.8.

Environment : PeopleSoft HRMS 9.1, 8.8 PeopleTools 8.49, 8.51, Oracle

Confidential

Role : Functional Testing Team Member Client site

Responsibilities:

• Responsible for writing executing Test Scripts for User Acceptance Testing for the GL module and capture the test defects and log into QC.
• Writing User Requirement Documents using Use Cases, System Design Documents and Test Scripts for each use case.
• Coordination between development, functional and business teams in the process of testing and when issues occurred.
• Validating end to end configuration for Core banking of china implementation for GL module and update the issue log in QC tools if any .
• Close coordination with Client Representatives

Environment : PeopleSoft HRMS 9.1, 8.8 PeopleTools 8.49, 8.51, Oracle

Confidential

Role : PeopleSoft Application Developer

Responsibilities :

• Translate functional requirements into Design specifications and building the application through coding in AE Application Engine , PeopleCode ,Online Pages ,nVision Reports PS-Query.
• Providing solutions to the customer by utilizing full knowledge of technical experience in PeopleSoft. Worked mainly on General Ledger and Account Receivables on People Soft Financial Supply Chain Management.
• Resolving the UAT Production Issues
• I am involved in the end to end development, testing and implementation of GL Journal Approval and Year End Close Enhancement activities.
• Preparing Service-Request response documents to following up SR Delivery processes, including Estimation analysis, Technical/Functional Design Specifications documentation.
• Preparing the Technical Design documents after analyzing the functional requirements Issue and gap analysis of the problem Design, Construction and Testing.
• Responsible for effective communication issues, queries between the project team and the client.

Environment : PeopleSoft Finance 8.9 , PeopleTools 8.49, DB2

Confidential

Role : PeopleSoft Application Developer

Responsibilities

• Translate functional requirements into Design specifications and building the application through coding in AE Application Engine , Conversion, Interfaces ,PeopleCode ,Online Pages, SQR, GL nVision, Crystal Reports XML Publisher Reporting.
• End to End PeopleSoft Financial Supply Chain Management from PeopleSoft 7.5 and 8.4 to 9.0 implementation.
• Issue and gap analysis of the problem Design, Construction and Testing
• Development and testing of Data Conversion Programs for GL History Data and AR Customer Conversion via CI from PS 7.5 to 9.0
• Data Conversion for GL Current Balance Conversion from PS 7.5 to PS 9.0
• Development and testing of GL Data conversion Monetary Transactions from external Opera system to PS 9.0
• Defects resolution during the various testing phases
• Worked on Reporting Tools PS-query, nVision and XML-publisher to develop and generate the required business reports as per the client business requirements.
• Preparing Executing Data Mover Scripts for data importing, exporting, updation deletion from various database records tables
• Coordinated migration of new /changed objects between various database instances
• Prepared the test plans, test scripts, conducted unit testing and system testing
• nVision Reporting for General Ledger Module mainly comprising of Reconciliation , Trial Balance , Income Statement , Balance Sheet, Ledger , Summary Ledger etc.
• Crystal Reporting to customize the delivered Account Receivables reports as per the clients requirement.
• SQR Structured Query Report to customize Account Receivables AR delivered reports as per Business requirements.
• Customizing the Approval Deny delivered Workflow as per the client requirement
• Responsible for effective communication issues, queries between the project team and the client.

Environment : PeopleSoft Finance 7.5, 8.3 to 9.0, PeopleTools 8.49, 8.50, Oracle

Confidential

Role : PeopleSoft Application Developer

Responsibilities :

• Preparing the Technical Design documents after analyzing the functional requirements Issue and gap analysis of the problem Design, Construction and Testing.
• Requirement Analysis.
• Designing Technical Specifications.
• Online customizations as required for implementation.
• Worked as PeopleSoft Application Developer on Application Designer, Application Engines, PeopleCode, XML Publisher, Page Designing, Excel To CI, File Layout, PS Query, Component Interface and SQR.
• Design and Construction of XML Reports through Application Engine and PS Query
• Worked on the implementation of Compensation module of HRMS
• Unit testing : Prepared test plans and test data
• Involved in full cycle of System Integration Testing and 1 cycle of User Acceptance Testing.
• Coordinated migration of changed objects between various database instances.
• Conducted Knowledge Transfer sessions for the Client Team.

Environment : PeopleSoft HRMS 7.5, 8.3 to 9.0, PeopleTools 8.48, 8.50, Oracle

Confidential

Role : PeopleSoft Application Developer

Responsibilities:

• Worked as PeopleSoft Technical Consultant to customize PeopleSoft to the company needs which included: analyzing requirements, developing and testing new customizations developing concepts to enhance business processes and supporting the team members to design and build the processes/customizations.
• Worked as PeopleSoft Application Developer on Reporting Tools PS-query and nVision to develop and generate the required business reports as per the client business requirements.
• nVision Reporting for General Ledger Module mainly comprising of Reconciliation , Trial Balance ,Consolidation ,Income Statement , Balance Sheet, Ledger , Summary Ledger etc.
• Preparing the Technical Design documents after analyzing the functional requirements Issue and gap analysis of the problem Design, Construction and Testing.
• Developed new online customizations as per business requirements.
• Providing solutions to the customer by utilizing full knowledge of functional and technical experience in PeopleSoft during the Post Production support phase of XL- Capital PeopleSoft 8.9 Upgrade Implementation.
• Setting calls with users/client to discuss and resolve the issues.
• Involved in the Unit testing and support User Acceptance Testing.
• Resolving Tickets raised by users replicating the incident in the specified database Finding the cause of error preparing a fix for the incident.
• Effective use of Rational Portfolio Manager for maintaining record and distribution of hours clocked

Environment : PeopleSoft FSCM 8.9, PeopleTools 8.48, Oracle