Abhilash Chandrasekharan

acvy48@r.postjobfree.com, 703-***-****

Summary:

End-to-end re-implementation of PeopleSoft

Worked on multiple upgrade projects.

Have worked on multiple HCM modules including Recruiting, HR, Benefits, NA Payroll, ESS,Pension, E Performance.

Expert in People Tools including Application Designer, Component Interface, Approval Workflow Engine, Workflow, integration broker, application messaging and Application Engine.

Expert in SQR reporting and data processing.

Experience in PUM (PeopleSoft upgrade manager).

Oracle PeopleSoft People Tools 1 and 2 certified expert.

Sound knowledge of test management tool HP Quality Centre.

Oracle PeopleSoft Enterprise 9 Human Resources Consultant certified expert.

Extensively used third party tools like Toad, SQL developer, Ultraedit, Notepad ++, PHIRE, DM Hummingbird etc..

Worked on Tax Updates.

Good experience in SDLC phases of the project i.e. Planning, Analysis, Design, Coding, Testing, Implementation and Maintenance with Strong Testing skills

Good understanding of PeopleSoft Fluid Interface.

Expertise in preparation of Business Requirements document, Technical Design document and Test plans to meet project-specific standards

Experience managing SAAS applications like SuccessFactors, Taleo, SumTotal Learning Management System and VEMO.

Successfully upgraded TCC from 12C to 15A single handedly.

Technical Expertise:

PeopleSoft Applications HCM 8.X, 9.X

Modules Recruiting, HR, Benefits, NA Payroll, ESS.

Tools People Tools 8.5X

Reporting Tools: SQR and PS-Query

RDBMS: Oracle 11C, 12G

Operating Systems: Windows, UNIX

Professional Experience:

Title Inter-American Development Bank

PeopleSoft to SAP External Interfaces Conversion and PeopleSoft Support/ Development, Washington DC, USA August 2015 - till Date

Programme Inter-American Development Bank PeopleSoft to SAP External Interfaces Conversion cover the following topics

Project: Inter-American Development Bank works for the growth and development of Latin American Countries. There were major inbound and out bound interfaces exchanging data between IADB and external vendors. The bank recently took two major decisions. One was to move their ERP services to SAP from PeopleSoft, second is to identify Hewitt AON as their Pension Administration Services provider going forward and the third was to create a new company by name Inter-American Investment Corporation with fair aim of investment banking.

.

Managed creation of interfaces between Inter-American Development Bank and external vendors which includes, Taleo, Ultramar, P&A, Duestche Bank and CIGNA.

Analyzed the use of PeopleSoft Upgrade Manager (PUM) for as a part of POC.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Single handedly upgraded Taleo Connect Client from version 12C to 12A.

Created field mapping documents for SAP and BIZTALK team.

Responsible for conducting meetings with business to explain future process.

Responsible for conducting meetings with the vendor as part of testing.

Responsible for system integration testing and created test cases and reported issues in JIRA.

Modified batch scripts for scheduling in Taleo Connect Client.

Created conversion SQR to generate flat files containing retiree information.

Worked on multiple modules like Recruiting, HR, Benefits, NA Payroll, ESS.

Created SFTP shell scripts to SFTP generated conversion files to AON Hewitt.

Used the functionalities of BIZTALK to send files securely to AON system.

Created PeopleSoft pages to run the processes ad-hoc.

Scheduled outbound process monthly to send data to AON.

Understood the concepts of CyberArc for Password management. Implemented the same in the SFTP script.

Created SQR programs to generate contract letters for newly created company named IIC.

Made changes to existing PeopleCode in the Recruitment module to accommodate changes for the newly formed company IIC.

Created Remedy tickets and worked on STAT to move projects successfully to production.

Environment: Application-PeopleSoft HCM 8.3; Tools -PeopleTools 8.20; Operating System-Windows 7, Windows 2012 Server; Database- Oracle 12G

Title Ascension Health- Symphony Payroll Automation

NA Payroll Consultant/ Support/ Upgrade, Ascension Health St. Louis, Missouri, USA September 2014 – August 2015

Programme Ascension Health- Symphony Payroll Automation covers the following topics

Project : Ascension health is a non-profit organization with many hospitals coming under it. The organization decided to upgrade PeopleSoft HCM to 9.2 and automate payroll.

Created a region table to define regions based on which payroll would be run.

Analyzed the mapping sheet and retrofitted SQR’s, and other PeopleTools objects.

Performed fit-gap analysis.

Produced multiple compare reports for upgrade.

Used the PeopleSoft Upgrade manager (PUM).

Defined a global variable to contain the production database name, which would be used to separate actions that need to be performed in production from other instances.

Improved the performance of Employee PaySheet page by aggregating the Payline data.

Added/ Ran test cases to HP quality center.

Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.

Worked with the support team to fix issues coming in as a part of production support.

Supported any issues that may come up in other modules like Recruiting, HR, Benefits, NA Payroll, ESS.

Assist with maintenance and troubleshooting of scheduled processes.

Created the technical design document based on the functional design.

Performed unit testing and created the unit test case document.

Hands on experience on designing the new interfaces.

There was integration data coming in from PeopleSoft Time and Labor which had to be analyzed.

Functionally analyzed and tested the interfaces.

Assisted in creation of custom Approval Workflow Engine (AWE).

Environment: Application-PeopleSoft HCM 9.2; Tools -PeopleTools 8.54; Operating System-Windows 7, Windows 2012 Server; Database- Oracle 12G

Developer/Project Lead, International Monetary Fund (IMF)

Washington DC/ Kochi India March 2010 – September 2014

International Monetary Fund (IMF) – PeopleSoft Support/ Upgrade/ Development. SAAS Support.

Project: International Monetary Fund uses PeopleSoft for its HRMS activities. There were multiple SAAS applications interfaced with PeopleSoft.

Responsibilities

First level support of SAAS applications like Taleo, SuccessFactors, VEMO and SumTotal.

Developed and supported SQR interfaces between PeopleSoft and SAAS Applications.

Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Performed unit testing and added/ ran test cases to HP quality center.

End to end Implementation of custom Hierarchy and Workflow process in PeopleSoft.

Created custom workflows.

Created / supported multiple application engine programs.

Created multiple PeopleSoft custom pages with complex functionalities written using PeopleCode.

Created multiple SQRs.

Part of Implementation team for the proposed Pension Portal Design.

Closely worked with the .NET team who were building the front end pages for pension portal.

Worked on Integration Broker, Application Messaging, created WSDL for PeopleSoft pages and exposed them to be consumed by the .NET front end.

Automated the pension calculation process of transferred employees.

End to end Implementation Voluntary Savings Plan (VSP).

Simplified transfer of savings from the previous company to IMF.

Created several SQR processes to transfer data between IMF and WELLS FARGO (401K vendor).

End to end Implementation of Medicare Part B which is an ideal part of medical insurance in IMF.

End to end Implementation of custom Request For Personal Action system.

Worked on to set up Organizational Set Up.

Made self service easy for 18 transactions.

Worked on to understand the PS Org charts.

Created multiple reusable components.

Configured the HRMS set up tables.

Participated in upgrade of PeopleSoft HCM from version 9.1 to 9.2.

Coordinated and applied number Bundles & Patches to keep the system to latest patch.

Migrated PeopleSoft projects on PHIRE.

Environment: Application-PeopleSoft HCM 9.2; Tools -PeopleTools 8.52; Operating System-Windows XP, Windows 2012 Server; Database- Oracle 11C; Migration Tool- PHIRE.

Senior Software Developer, Client : Air Canada Nov 2009 to March 2010

Title : Air Canada PeopleSoft Support

Project : Air Canada has PeopleSoft systems which are maintained by Hexaware. Daily batch runs and issues relating to PeopleSoft applications would be raised as tickets which were handled.

Involved in requirement gathering sessions with the HR Managers.

Provided support to issues reported in PeopleSoft E-performance module.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Working on enhancements rose as tickets in the maestro tool.

Involved in Batch monitoring using IBMs ECS WEB.

Created new SQRs and added them to the batch server.

Mapping the in and out dependencies for a process in the batch server.

Provided 24/ 7 support with utmost responsibility.

Dealt with major customization like tax updates for Canada.

Bringing in new logic to the program based the requirements filed in ticket.

Worked on Online Customizations using Application Designer

Development and Customization of reports using SQR

Environment: Application-PeopleSoft HCM 9.0; Operating System-Windows XP, Database- Oracle 10G; Special Software- Maestro.

Senior Software Developer, Client : RBS April 2009 to November 2009

Title : Globalization Project – RBS- ABN Amro Integration/ PeopleSoft Upgrade

Project :Royal Bank of Scotland had acquired ABN Amro and was trying to integrate the PeopleSoft system.

Worked on Approval Workflow Engine. Customized AWE for Full Time/ Part Time Authorizations and Promotions.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Created/ Modified a PeopleSoft pages.

Part of the upgrade team for PeopleSoft upgrade from version 8.8 to 8.9.

Assist with maintenance and troubleshooting of scheduled processes.

Environment: Application-PeopleSoft HCM 8.9; Operating System-Windows XP, Database- Oracle 9G; Special Software- Maestro.

Senior Software Developer, Client : Air Canada Dec 2008 to Apr 2009

Title : Air Canada PeopleSoft Support/ PeopleSoft Upgrade

Project : Air Canada has PeopleSoft systems which are maintained by Hexaware. Daily batch runs and issues relating to PeopleSoft applications would be raised as tickets which were handled.

Involved in requirement gathering sessions with the HR Managers.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Working on enhancements rose as tickets in the maestro tool.

Involved in Batch monitoring using IBMs ECS WEB.

Created new SQRs and added them to the batch server.

Mapping the in and out dependencies for a process in the batch server.

Participated in upgrade of PeopleSoft application (HCM) from version 8.3 to 8.9

Dealt with major customization like tax updates for Canada.

Maintain current PeopleSoft HRMS menus, pages, components, records, tables, & modifications and support upgrades as needed

Understand the Customer requirements from Onsite team and delivery of assigned work units

Involved in Design, Build & Unit Testing stages

Development of Custom SQR to onboard the employees as non-Agilent workers.

Environment : Hardware-IBM PC Pentium IV; Operating System-Windows XP, Windows 2003 Server; Languages- People code,SQR, Application Engine Special Software- Ultraedit

Sr Software Developer, Client:CIBC (Canadian Imperial Bank of Commerce) Oct’ 08 to Dec’ 08

Title : CIBC PeopleSoft upgrade

Project :Canadian Imperial Bank of Commerce (CIBC) is the biggest bank in Canada. They wanted their PeopleSoft system to be upgraded to HCM application version 9.0.

PeopleSoft HCM application upgrade from 8.3 to 8.9 to 9.0

Modified existing SQRs as per the customization request

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Conducted the ‘Development Quality Testing’ for the retrofitted SQRs and Online Pages.

Develop conversion and/or load programs to support software upgrades, re-defined business processes and Integration of new businesses where necessary.

Primary task involved designing, effort estimation, building and testing of data migration programs

Playing a Role in developing the Data Migration Strategy

Helping team members resolve technical issues and training new team members

Worked on Online Customizations using Application Designer

Development of outbound interfaces using SQRs and automating SFTP to transfer output files onto target server

Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs

Senior Software Developer, Client : Scope International, Dec 2007 to Oct 2008

Title: Scope International PeopleSoft Reimplementation (Upgrade).

Project Scope International does the back office works of Standard Chartered Bank. The existing version of PeopleSoft 8.8 was upgraded to 8.9 and the functionalities were re implemented.

Modified existing SQRs. as per the customization request

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Enhancements in SQR’s, New SQR programs for interface and reports.

Modified existing PS Queries based on customers request.

Developing and maintaining 45 interfaces (Bulk Load Processes – AE & CI) used during the migrations

Building and maintaining Department Security Trees at the start of a data load cycle

Development of outbound interfaces using SQRs and automating SFTP to transfer output files onto target server

Maintaining Data Migration related Quality Documents, best practices and lessons learnt

Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs

Environment : Hardware-IBM PC Pentium IV; Operating System-Windows XP, Windows 2003 Server; Languages- People code,SQR, Application Engine Special Software- Ultraedit

PeopleSoft Technical Analyst, Client : Recall Incorporated, Mar 2007 to Nov 2007

Title : Recall Incorporated PeopleSoft development/support/upgrade.

Project The project involved activities like daily running of batch process to send the route details to PDA. Customization of existing functionalities based on requests was carried out. New page/ component requests were also handled.

Involved in preparation of Keep drop Analysis documents

Participated in upgrade from PeopleSoft HCM Application version 8.3 to 8.9.

Preparation & review of Upgrade documents related to the work product.

Running the CIS nightly batch run on a daily basis

Generation of Database Compare reports & queries.

Taking hot and cold backups of data base.

Involved in activities such as mapping the People Wise implementations into existing PeopleSoft modules.

Performing database refresh.

Implementation and proposal of Change Requests.

Migrating projects to different environments.

Involved in Batch monitoring as a part of Support work.

Worked directly with Human Resources end users to provide 24x7 HR support

Lead and successfully implemented various bundles and patches on PS 8.9

Able to do performance tuning and knows how to troubleshoot and quickly resolve issues on pre-production support

Environment : Hardware-IBM PC Pentium IV; Operating System-Windows XP, Windows 2003 Server; Languages- People code,SQR, Application Engine Special Software- Ultraedit

Systems Developer, Client : ACS, Apr 2006 to Mar 2007

Title : ACS PeopleSoft development/support.

Project ACS PeopleSoft support.Had to attend daily status calls with the client to understand new requirements too.

Implementation and proposal of Change Requests.

Created architecture diagrams, functional design documents, technical design documents, impact analysis documents and production review check lists.

Generation of Database Compare reports & queries.

Performing database refresh.

Migrating projects to different environments.

Involved in Batch monitoring as a part of Support work.

Developed understanding of Employees base benefits

Conducted Code Review for the Fit Gap done by the team members.

Proactively identifies risks and ways to mitigate

Performed unit testing.

Environment : Hardware-IBM PC Pentium IV; Operating System-Windows XP, Windows 2003 Server; Languages- People code,SQR, Application Engine Special Software- Ultraedit

Support Engineer, Client : Megellan, Jul 2005 to Apr 2006

Title Magellan Support.

Project Slash support provided support to Megallan who is a top manufacturer of GPS systems.

Megellan support included basic trouble shooting of issues related to their GPS devices.

Created the technical design document based on the functional design.

Performed unit testing and created the unit test case document.

Support was provided for Ad-Hoc map update.

Provide all technical support during the implementation of new features and modules as needed.

Conducted Code Review for the Fit Gap done by the team members.

Proactively identifies risks and ways to mitigate

Environment : Hardware-IBM PC Pentium IV; Operating System-Windows XP, Windows 2003 Server

Education:

B.E Computer Science and Engineering, 2005 From Anna University Chennai

Contact this candidate