Educational Qualifications:

Madras University, Chennai, India

Master of Computer Applications

Certifications

Oracle certified Peopletools expert

Solutions-focused technical analyst professional with around 17 years of experience participating on large-scale implementation projects to deliver and support PeopleSoft ERP applications including PeopleSoft HRMS and CRM across corporate enterprises. Ability to assess and scope projects, resource appropriately and manage to expectations for deliverables. Highly effective in building and leading technical teams to design, develop, and deliver cutting-edge PeopleSoft solutions supporting all phases of the systems development lifecycle. Experienced in PeopleSoft Security Administration and involved in upgrade of PeopleTools 8.48 to 8.55. Exceptional ability to work at any level from designing, coding, testing and implementing using PeopleSoft’s technical tools to include PeopleCode, Application Engine, SQR Programming, Integration Broker, Application Package and Workflow. My extensive functional and analytical skills make me an ideal candidate within a variety of roles in the delivery and support of PeopleSoft ERP solutions.

Core Competencies / Technology Tools

Ability to leverage best-practices in the support and delivery of ERP Solutions.

Highly skilled technically and functionally with extensive leadership skills in the delivery and support of ERP applications

Technical Project Management

Exceptional interpersonal and communication skills.

Applications & Systems Integrations

Workflow System Management

Team Leadership & Collaboration

Security Administration

System Development Lifecycle

Customizations & Enhancements

PeopleSoft HCM 9.2: NA Payroll, Time & Labor, Core HR, Pension, Absence Management, Tax Administration, Benefits Administration, ESS and MSS

Technologies to include: Windows XP, Apple OSX, UNIX Tools: PeopleTools 8.48, 8.50, 8.52, 8.54 and 8.55 Portal Administration, Security Administration, PeopleCode, Application Engine, Integration Broker, Application Package, SQR, Crystal Reports, Component Interfaces, Workflow, Web Services, UPK, PeopleTools, PeopleSoft Security, Oracle 10g, Oracle SQL Plus, SQL Server, Ultra Edit, Toad, MS Office, PHIRE and STAT.

Professional Experience

Metropolitan Transportation Authority – New York, NY

Apr 2019 – Till Date

PeopleSoft Technical Consultant – PeopleSoft HCM

Provided technical support in developing and enhancing the programs to fit the peoplesoft system that includes Pension Administration, NA Payroll and Time & Labor. Building the bolt-on Pension Loan module to replace the MTA’s Sub System which handles the Loans of MTA’s agencies. Partnered with employees and key stakeholders in managing, developing and testing new system initiatives. Developed functional, technical, and detail test plans to facilitate new PeopleSoft system implementations. I was a member of the Pension (Conversion and Development) team at IBM (who is the Implementation partner for NYC Metro Transportation Authority). I was heavily involved in Conversion of Pension Data from third party GEAC/Infor system into Peoplesoft HCM 9.2 system. I was also involved the development of custom bolt-on Loan module in MTA’s Peoplesoft system by replacing the existing sub system in Mainframe system.

Selected Highlights:

Coordinated with business stakeholders, functional leads and business analysts while gathering the requirements

Analyzed and designed the technical architecture diagrams for the existing and new interfaces

Interacted with the business users to prepare the technical specifications for the Conversion of MaBSTOA retiree payroll information from GEAC/Infor system to Peoplesoft 9.2 system

Provided business expertise and inputs for the design and improvement of the Peoplesoft Pension Administration system

Developed various conversion application engine programs and used component interfaces to migrate the retiree data from the MTA sub system to PeopleSoft Pension module

Developed various Application Engine processes to convert the Legacy Loan Information (like EE Basic Information, Loan Information, Repayment Schedule Information, Contributions and Buyback Information, Payroll Deduction Information and Loan Eligibility Tracking Information) into Peoplesoft System based on provided Functional specifications

Involved in implementation of custom Bolt-On Pension Loan system using Application Designer to track the Loan applications from the creation of Loan to closing of Loan for various MTA Agency employees

Developed a new Application Engine to bring the Pension and Loan Deductions from Payroll into the new Pension Module

Analyzed and Developed the new interface using Application Engine to send the General Deduction changes to Payroll from the new Pension Module

Developed a new comparison SQR report to verify the Current, YTD and LTD balances

Involved during the system and integration testing and user acceptance testing phases

Supported the Salary Cap Application Engine process after the go-live for hourly and salaried employees

Heavily involved in preparing the presentations, demos, proof of concepts and quick user guides by coordinating with business users

International Monetary Fund – Washington, DC

Jan 2019 – Apr 2019

PeopleSoft TechnoFunctional Consultant – PeopleSoft HCM

Provided technical support in developing and enhancing the programs to fit the PeopleSoft system that includes Pension Administration, NA Payroll and workforce administration. Assisted with technical guidance for day to day PeopleSoft production issues which are time sensitive. Guided the business users with alternate solutions with the interest of IMF to provide response on a timely manner.

Selected Highlights:

Provided business expertise and input to the design and improvement of the NA Payroll system and IMF specific Pension system

Enhanced the Active Pension System reports as per the current business requirement

Interacted with various business users to understand the requirement and providing the better technical solutions

Involved in design, development and testing Retirement Participant system process to send the direct deposit details

Supported the issues with resolution for the on-cycle payroll runs

Provided various data reports to compare the payroll data among various paygroups

Resolved the issues by Debugging the Peoplecode from the trace

Analyzed the SQR’s and provided the solution to the defects raised by the business user

Participated in various business meetings to gather the requirement to change the interface data to assist the new fund wide emergency alert system

Involved in unit and integration testing

Metropolitan Transportation Authority – – New York, NY

Oct 2014 – Dec 2018

PeopleSoft TechnoFunctional Consultant – PeopleSoft HCM

Provided technical support in developing and enhancing the programs to fit the peoplesoft system that includes NA Payroll, Benefit Administration and Time & Labor. Retro Wage Adjustment project was planned to customize the process of paying various MTA agencies Retro Wages for a defined period where the delivered Retro Pay program was never used and the entire process was recreated by MTA. Partnered with employees and key stakeholders in managing, developing and testing new system initiatives. Developed functional, technical, and detail test plans to facilitate new PeopleSoft system implementations.

Selected Highlights:

Provided business expertise and input to the design and improvement of the NA Payroll system

Developed Time and Labor Rules in Application Engine for Health Welfare Medical deduction for MTA Agencies

Trouble shooting payable time issues which are originated from Time & Labor Rules

Involved in development and testing of Retro Wages Adjustment (RWA) SQR process based on various Union Contracts

Developed Payroll Compare reports using SQL’s and PS Queries for both Implementation and Upgrade of PeopleSoft system for all agencies. Prepared job aides for third party vendors, and functional users

Enhanced the compensation rate combo functionality by writing the Peoplecode in the appropriate Peoplecode event

Customized PAYGL02 SQR process to default certain chart fields for specific accounts

Enhanced PAYGL02 SQR process to map the correct chart fields for retro payments

Enhanced Time and Labor Rules by writing the effective SQL’s in application engine program to impact only full-time employees

Developed a new salary cap application engine process to control the employees over time

Developed a SQR process to populate the RWA amounts per quarter, for each eligible employee and enhanced the Pension Forecast Report by including the quarterly RWA amounts

Parameterized the hardcoded values to retrieve from configuration pages in various SQR programs

Developed a new MNR 152 rate calculation SQR process, which will be used to confirm the vacation RWA amount

Involved in migrating the setup parameters using SQL Scripts for various agencies, test environments and to confirm that the Setup page is ready for Payroll run

Provided Production support for NA Payroll system after the upgrade

Streamlined the Custom Payroll processes, and automated the transfer of files between client and third party vendors

Created a new Union Dues application engine program to collect dues based on the union eligibility list

Developed and tested PS Queries for the users to retrieve the data for various reconciliations and reports

Created a custom application engine program to ignore the HR changes after paysheets are created

Created new post confirm components to avoid submitting the duplicate requests. These components are developed using Peoplecode and application designer objects

Involved in Loading One Time Earnings and Deduction files for processing the Payroll using PSHUP application engine process

Involved in the validation of the RWA output file for various agencies and confirming the RWA amount calculation for employees, for various periods

Customized and tested W2 printing process as per client’s requirement

Created various SQLs for extracting day to day reports required at MTA BSC Payroll Department for reviews and discussions

Involved in fine tuning of the performance of SQR programs by re-writing the long running SQLs using hints for optimization

Validated the deferred comp election file with the source data by creating the SQL Scripts

Involved in unit and integration testing

Inter-American Development Bank – Washington, DC

Apr 2014 – Sep 2014

PeopleSoft Technical Consultant – PeopleSoft HCM

Provided technical support in developing the programs to translate the LAWSON data to fit the peoplesoft system that includes NA Payroll, Benefit Administration, Absence Management and Self Service. Partnered with employees and key stakeholders in managing, developing and testing new system initiatives. Developed functional, technical, and detail test plans to facilitate new PeopleSoft system implementations.

Selected Highlights:

Involved in analyzing the people vendor information from LAWSON and also involved in mapping this information with peoplesoft system.

Involved in the development of conversion programs of Optima project from peoplesoft end

Developed few audit reports for Finance department which contains sensitive data

Developed Self Service Bank Information system in peoplesoft for Staff and contractuals

Defined Absence Types and Reasons

Defined Absence Entitlement Elements

Defined Absence Take Elements

Setting up Absence Accumulators

Defined Holiday Schedules

Setting up Absence Calendars

Integrated Absence Management and the Payroll System

Involved in the development of outbound GL file transfer Interfaces

Involved in unit and integration testing

Involved in creating functional and technical specification documents

International Monetary Fund – Washington, DC

Jan 2009– Apr 2014

PeopleSoft Techno Functional Consultant – PeopleSoft HCM, TRACES & Financials

Provided leadership for various technical projects supporting production systems using a wide range of PeopleSoft technologies that includes NA Payroll, Pension, Tax, Benefit Administration, Personnel Actions, PATS(Bolt-On) and TRACES(Bolt-On). Partnered with employees, vendors, and key stakeholders in managing, developing, and testing new system initiatives. Developed functional, technical, and detail test plans to facilitate new PeopleSoft system implementations. Led troubleshooting and resolution of PeopleSoft reported issues. Responsible for all facets of the analysis, planning, design and development effort for implementation, upgrade and production support related to PeopleSoft HCM and Financials.

Selected Highlights:

Generated significant costs savings by transforming a highly complex manual system into a state-of-the-art web-based workflow system.

Tracked and managed all phases of the system development lifecycle to report project status and key priorities to stakeholders critical to completing projects within established timelines and budgets

Developed and implemented numerous logging, monitoring, and email modules to track messaging and flow of transactions between HR, PATS(Bolt-On), TRACES(Bolt-On) and Financial Systems key to minimizing errors and business disruptions.

Led design, development, testing, and execution of Leave Self Service successful implementation.

Managed a project to upgrade PeopleTools from version 8.48 to 8.50 that included reapplying numerous customizations and reengineering non-functional components to streamline business processes

Lead a team responsible for:

oVarious customization of bolt on modules in Peoplesoft HR

oIntegrating PeopleSoft HR and Web Applications

oDeveloping Interfaces using Data Stage with PATS(Bolt-On) and other Web applications

oLeave Self Service integration with existing DARTS module.

oEnhancing the TRACES(Bolt-On) application

oDeveloping new functionality in Overseas Staff Administration module

Delivering on a variety of security control changes that required tight coordination with developers, deployers and technology service providers.

Detailed Projects:

Name: HCM Support

Role: Techno Functional Consultant

Environment: PeopleSoft 8.9 HCM, PeopleTools 8.52 including WorkFlow, Application Engine, Component Interface, Integration Broker, PeopleCode, SQR, PS Query, Oracle 10g,Crystal Reports

Duration: Jun 2011 to Apr 2014

Description: PeopleSoft HCM is a widely implemented project that consists of enhancing and supporting HCM production system in IMF. It consists of supporting the key HCM modules like Payroll, Pension, Taxes, Benefit Administration, Overseas Staff Administration, Awards & Recognition, Dirxml Integration, PATS & TRACES. It involved developing various bolt on features to meet the business needs of IMF and integrating with various PeopleSoft subsystems and Peoplesoft Finance. It also includes developing various interfaces with various external systems using data stage and STREAMs techniques

Responsibility:

Working both as a technical and functional consultant for core human resource system that includes NA Payroll, Pension, Tax, Benefit Administration, Personnel Actions, PATS(Bolt-On) and TRACES(Bolt-On)

Responsible for day to day production support issues and responsible for enhancements of the modules

Involved in Business Unit consolidation - Set ups, table set control changes, Interface testing

Integrated various interfaces from external systems which generate a flat file and developed customized Application Engine process to ensure the standard deductions are created

Involved in Support and maintenance of Payroll, Pension and Tax modules

Worked on the concepts of Leave Period opening and closing and its dependency on the PeopleSoft subsystem validations

Integrated ImageNow in PATS for Applicants and Sponsors to attach the documents instead of manual hard copy submission

Involved in EP and TRACES integration in automating the roles assignment

Expertise in developing interfaces to create Bank information by getting the data from secure site

Involved in Year End Activities for Tax Reporting and enhanced the SQR program on need basis

Monitoring daily scheduled jobs in Tidal and acting if there is any failure by debugging the errored program

Assisting Staff in completing their Time Sheets in TRACES(Bolt-On) on time

Debugged chartfields issue originated from PAYGL02 SQR Process

Providing permanent fixes to the reoccurring issues by identifying and fixing the Peoplecode

Expertise in resolving the integration issues between various applications

Requirement analysis and clarification for new business and functional requirements.

Analyze programs and do proper impact analysis.

Get involved in architecture design of these projects.

Identification of classes, attributes and methods for major components under development

To design the database and high level application flow

Worked on performance tuning of applications

Quality Assurance of Code and other deliverables using Mercury Quality Center.

Resolved incidents and take care of Service Requests for HCM applications

Making changes to the code for fixing bugs in the HCM applications including TRACES, PATS and Payroll and Pension

Developing software tools for Automation of tasks which require a lot of manual intervention and hence error prone, simplification of tasks which are to be performed regularly.

Detailed Projects:

Name: Leave Self Service

Role: Techno Functional Consultant

Environment: PeopleSoft 8.9 HCM, PeopleTools 8.48 Component Interface, Application Engine, PeopleCode, SQR, Oracle 10g

Duration: Jan 2011 to May 2011

Description: Prior to this project, Fund staff and contractuals are submitting their leaves in a paper form. In order to avoid the manual work, developed a Leave Self Service web application which allows staff and contractuals submit their leaves online. Based on the defined rules the submitted leave will route to their supervisor for approval. In each stage we have implemented the email notification to alert the respective party. Leave administrators has provision to submit the leave on behalf of the staff. All the approved leaves will be loaded to DARTS by a nightly process where the actual leave balances are maintained

Responsibility:

Developed the LSS application as per the business requirement using Application Designer, Integration Broker, Application Engine

Integrated LSS Web application with PeopleSoft DARTS(Bolt-On) application by writing the Peoplecode in Application Engine

End to end testing performed from the point staff submits the leave and it deducts from their Leave balance

Involved in study and analysis of the setup and business processes of the client (AS-IS Study) and created new set ups for defining new LSS leave codes

Analyzed the tasks based on the service request including various enhancements mostly on automation

Implemented the system and tested the end to end transactions

Analysis of issues/tickets from the functional point of view

Faced the customers in their functional queries and Development of KT-Plans.

Automating the Bi-Weekly Leave rollover application engine process

Developed various reminder processes to alert the Leave Administrators and Office Managers

Detailed Projects:

Name: PeopleSoft HCM

Role: Techno Functional Consultant

Environment: PeopleSoft 8.9 HRMS, PeopleTools 8.48 including WorkFlow, App Engine, Component Interface, Integration Broker, PeopleCode, SQR, PS Query, Oracle 10g,Crystal Reports

Duration: Jan 2010 to Dec 2010

Description: PeopleSoft HRMS support is a support and maintenance project that consists of enhancing and supporting HR production system in IMF. It consists of enhancing the key HR modules like core HR and Benefit Administration. It involved developing various bolt on features to meet the business needs of IMF and integrating with various interfaces with various external systems using data staging techniques. The Fund uses Success Factors and Taleo, which are SaaS Tools, for effective tracking of Annual Performance, half yearly appraisals, Promotions and Positions. Integrated Home Leave & Education Allowance web applications with Peoplesoft HCM.

Responsibility:

Developed various pages and panels for storing Expert Information and their contracts with Fund in PeopleSoft HR 8.9

Developed Workflow to route the contracts for various approval levels within the department

Developed Workflow to route these contracts to HR management for their approval which will trigger the job record and personal data creation process

Integrated the customized contract system with PeopleSoft HR – Personal Data and Job Data and Payroll information

Involved in Development of a complete ESS system in SharePoint/.Net and Integrating it with PeopleSoft via component interfaces and My SQL Procedures

Developed ability for the senior personnel management including advisors/division chief to run the reports for detailed information of these experts and their research

Identification of any gaps or required customizations on the required business processes

Implementation sequence and roll out to users of HR Web modules. Set up and configure the business processes

Worked with business and development team to understand and redefine the needs

Upgrade process and the issues in the change process

Involving in various set up changes to incorporate the business needs

Developed automated process for processing the education allowance applications submitted by the staff

Implemented auto approval of EA applications as per the business requirement

Involved in implementing the auto risk score calculation of Home Leave and Education allowance certification

Developed various reports as per the business needs

Detailed Projects:

Name: Travel Information Management System – Travel Portal

Role: Technical Consultant

Environment: PeopleSoft 8.9 Finance, PeopleSoft HR 8.9, PeopleTools 8.48 including WorkFlow, App Engine, Component Interface, Integration Broker, PeopleCode, SQR, PS Query, Oracle 10g,Crystal Reports

Duration: Jan 2009 to Dec 2009

Description: TIMS – Travel Portal is purely bolt on feature that was developed to track Fund travel to various countries. It tracks the travel of various economists, experts, dependent travel across different departments in the Fund. It includes planning of missions to actual trip through travel agency and finally paying the expenses incurred during the trip. It involved integrating with General Ledger, Account Payables, Project Costing, Travel and Expenses and Commitment Control. It involved developing various bolt on features to meet the business needs of IMF and integrating with various PeopleSoft subsystems and HRMS.

Responsibility:

Enhanced the Fund customized application – TIMS – Travel Information Management system to track the Fund Staff Missions and Trip details

Developed new functionalities using PeopleTools 8.48 and PeopleSoft Finance 8.9

Resolved all the Integration issues between TIMS(Bolt-On) and Travel Authorizations

Developed various solutions using Aapplication Designer to improve the performance of the application

Developed multiple reports using SQR and Crystal Reports for tracking the expenses incurred for various departments in the Fund

Developed Data Mover Scripts to transfer the data from source to target

Involved in Interaction with business owners and stake holders and document the existing business processes

Developed Test Scripts using SDLC procedures in QC and tested various applications using Load Runner to conduct stress testing

Apple, US

Sep 2004 - Dec 2008

PeopleSoft Technical Developer

Provided technical expertise in designing and implementing PeopleSoft CRM. Served as technical implementation analyst and developer for rolling out a PeopleSoft CRM Module including Sales, Retail and Support modules. Prepared training manuals and “how to” guides to assist users and technical staff in using and maintaining delivered systems. Crafted project plans to forecast the future direction for launching a new Distribution Module. Recommended strategies to senior management for planning and implementing PeopleSoft Retail and Support modules. This project involves providing new functionalities / enhancements to the client in the existing system of Global Customer Relationship Management (PeopleSoft). These new enhancements have to be planned on quarterly basis and after performing the feasibility analysis, these are designed and delivered to client by going through development cycle. As part of Apple global expansion drive, it extended the online market to Malaysia, Philippines, Indonesia, Vietnam & Thailand. Apple has launched 5 new online apple stores for the said countries. To support this GCRM system, we have customized iCust framework to adopt with the new system, customized interfaces and component interfaces. As a part of enhancements, implemented new sales orgs to each country to handle service activities

Projects Involved:

Apple Global Customer Relationship Management Enhancements

Korean & New Zealand Apple Store

ASCS Tool Box

PeopleSoft GCRM 8.8 Channel Partners for EMEA & Product Hierarchy Changes

SEA X-Border Project

Selected Highlights

Established numerous customized bolt-on applications that interfaced with PeopleSoft’s Service and Sales Modules to support the management of purchase orders through support calls

Designed an innovative external application that interfaced with PeopleSoft via SQR programs to facilitate the processing of offline commercial orders.

Formulated and spearheaded a configuration management strategy to build and maximize performance across PeopleSoft CRM

Successfully evaluated upgrade alternatives and production cutover strategies for transitioning existing PeopleSoft Tools 8.46 to 8.48

Developed several web services using Integration Broker to bring the data from external systems

Developed various Component Interfaces and Application messages using PeopleTools 8.46 to support web integration

Enhanced the price feed Application Engine which will load prices for Canada, Latin America, Taiwan and Korea

Resolved all major Component Interface Sync Issues between SFA and GCRM by debugging the Peoplecode

Designed and delivered Data Archiving Tool using Application Engine

Developed various Pipeline reports for different regions using SQR

Chase Mellon, US Jul 2002 – Aug 2004

PeopleSoft Technical Developer

Develop and maintain the Human Resources Management (HRMS) System of Chase Mellon which is a Peoplesoft HCM implementation. The project involved in maintenance of various PeopleSoft HRMS releases and test the functionality of PeopleSoft HRMS.

Selected Highlights

Implementation of PeopleSoft HRMS

Developed SQR and PS Query reports as per business requirement.

Customized various pages, components and menus.

Unit testing and Regression testing of PeopleSoft HRMS module.

Enhancement work for incorporating the business change.

Responsible for day-to-day production support and enhancements for Core HRMS module.

Developed various Component Interfaces and Application messages using PeopleTools 8.44 to support web integration

Established numerous customized bolt-on applications that interfaced with PeopleSoft’s HCM Modules to support the Personnel actions

Satish Appala

Mobile : 267-***-****

Email : adb03e@r.postjobfree.com

Contact this candidate