PROFILE SUMMARY:

Highly motivated and results-oriented Senior PeopleSoft Techno Functional Consultant with around 11 years of experience in Analysis, Solution Design, Implementation, Development, Customization, Maintenance, Data Conversion, Upgrade, Testing and support of various applications.

Strong working knowledge on People Tools – Application Designer, Application Engine, People Code, Process Scheduler, PS Query, File Layout, XL to CI, Component Interface (CI), Application Package, SQL, Data Mover, XML Publisher and SQR.

Led teams for PeopleSoft’s STAT application implementation, designing and developing workflows.

Team member for PeopleSoft HRMS Upgrade/Data Conversion from v8.9 to v9.1. This upgrade effected 300,000+ employees

Interfaces – worked extensively on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using Application Engine, File Layout, Component Interface (CI) and SQR

Experienced in various stages of testing e.g. Smoke Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Load and Performance Testing

Documentation – Involved in analysis, creation and updating the Functional Design Document (FDD), Technical Design Document (TDD), Unit Test Plan Document (UTP), Migration Check List, Minutes of Meeting (MOM), Weekly Status Reports, Coding Standards Document, End User Training Documents, Data Mapping & Conversion Strategy Documents

Experienced in On-shore/Off-shore team management

Experienced in setting up and configuring PeopleSoft HRMS Modules – Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), North American Payroll, and Talent Acquisition Management (TAM)

Worked on various databases such as DB2, SQL Server and Oracle

Possesses Strong Business analytical and Techno-Functional knowledge of HCM/ HRMS.

Developed Data Mover Scripts for Importing & Exporting Data between environments

Worked closely with End users, Infrastructure, Functional and QA teams

Experienced in translating business needs into technical solutions

Experienced in anticipating system and business process problems and making recommendations to upper management for immediate resolution

Excellent problem solving, technical and interpersonal skills

Self-Motivated, team player and ability to meet tight deadlines

SKILLS:

PeopleSoft

PeopleSoft HRMS 9.1/8.51, 9.0/8.49, 8.9/8.47, 8.8/8.42 and 8.0/8.

People Tools (8.54)

Component Interface, Application Engine, Application Designer, Process Schedule, Security, Process monitor, File Layout and Data Mover, Integration Broker, Application Packages, Integration Broker, XML Publisher

Reporting

SQR, PS/Query, Report Manager.

Languages

PL/SQL, SQR, PeopleCode, PeopleTools, C++, HTML, javascript, vbscript, Active Server Pages (ASP)

Databases

Oracle 9.x, Oracle 10.x, Oracle 11.x, MS SQL Server, DB2

Version Control tool

STAT 5.4, PHIRE

Training

Workday v20 HCM

WORK EXPERIENCE

Orasys LLC - Westborough, MA, USA

Sr Programmer/Analyst - Oct’13- Present

Client

Nationwide Insurance, Columbus, OH Mar 2014 to Mar 2017

Project: PeopleSoft HR Support NA Payroll & Core HR

Application/Tools/Database: PeopleSoft 9.1 HCM / PeopleTools 8.54 / Oracle

Nationwide, based in Columbus, Ohio, is one of the largest and strongest diversified insurance and financial services organizations in the U.S. The Nationwide People soft HCM is a maintenance project that supports the HR application of the company and develops new in house functionalities. This application is used by all the employees in the institution. Modules implemented are Core HR, NA Payroll, Benefits, Absence Management, MSS, ESS and custom modules.

Responsibilities:

Working as application developer supporting all major modules.

Team lead for Ethics (Nationwide Compliance system) & United Way project (Nationwide Insurance Donation system).

Modified SQR/Application Engine and Component Interface programs as a part of vendor change for United Way project.

Created Application engine and Component Interface to load data coming from new vendor through a flat file.

Responsible for documenting all the process changes and preparing technical specifications.

Responsible for preparing the Technical specifications and unit testing cases

Supporting mainly on Core HR like Workforce Administration, Workforce Development, ESS /MSS modules.

Worked closely with Business users, Requirement analyst and architects to develop solutions for new projects.

Create functional and technical document from business requirement and write build test cases.

Work on production defect and service request.

Modified several existing SQR’s and created new SQR’s as required.

Experience in using change management tools PHIRE

Working on CA workstation for batch scheduling.

Complete Unit testing and migration activities along with creating training user manual.

Facilitate, document, prepare presentations with possible solutions on Production Support issues

Part of rapid response team giving analyzing and solutions for production failures

Mentoring and Review Code for junior developers

Created Adhoc PS Query reports for Pre & Post Data Analysis, Data Comparisons, and Data Validations for Business users

Created various interfaces for files sending to and receiving files from vendors.

Working in run team supporting all delivered and bolt on modules with resolving defects, new enhancements from small to big efforts.

Monitor and track progress of support tickets and ensure on time delivery

Orasys Offshore support Oct 2013 – Feb 2014

Responsibilities:

Responsible for resolving production support issues related to Payroll, ESS, MSS, ePerformance and Core HR

Identify Performance bottlenecks in System and come up with Original and technically scalable solutions

Coach and train other personal as required in Support

Created Adhoc PS Query reports for Pre & Post Data Analysis, Data Comparisons, and Data Validations for Business users Review prospective.

Created new SQR to populate staging record with JOB, PERSONAL_DATA, EMPLOYEMENT, PAY_CHECK, PAY_EARNS and PAY_OTH_EARNS records and generate bi-weekly feed to third party.

Designed several extract SQRs to provide for third party systems data through files using SQCs, UNIX and SQR.

Created new Component Interfaces and Application Engine

Responsible for Design and Develop Customization as per technical requirements.

HSBC - Buffalo, NY, USA Sep 2010- Sep 2013

HSBC is one of the world's largest banks headquartered in London. HSBC has around 7,200 offices in 85 countries and territories across Africa, Asia, Europe, North America and South America, and around 89 million customers and employs around 300,000 people

Sr Software Engineer (Development, Support/Implementation and upgrade v8.9 to v9.1 & Release Management Team)

Core team member responsible for Upgrade of existing PeopleSoft HRMS applications from v8.9 to v9.1

Involved in data conversion task in upgrade between v8.9 to v9.1

Test modules before Go-Live in order to prevent outage for about 300,000+ users

As an SME for ESS/MSS, People Admin, ePerformance, responsible for all issues after upgrade release

Business interaction to understand the business requirements for various upgrade testing tasks, involving delivered and customized functionalities, reports and interfaces.

Update security, queries, batch programs and reports to meet existing requirements

Facilitate, document, prepare presentations and summarize release reports for upper management

Monitored Human Capital Management (HCM), Enterprise Performance Management (EPM), Help Desk (CRM), Enterprise Portal (Portal) environments and provided resolutions to issues pertaining to job runs and server outages

Review, analyze and test code before promoting it to production

Responsible for handling Post upgrade issues

Involved in testing STAT tools for migration between new databases.

Created Adhoc PS Query reports for Pre & Post Data Analysis, Data Comparisons, and Data Validations for Business users Review prospective.

Created new reports using XML publisher for ePerformance and eRecruit modules.

Scheduled and modified SQR reports using SDLC process

Build new Component Interfaces and Application Engine for ePerformance implementation.

Used Advanced SQR techniques Arrays, Dynamic SQLs, On-Break, and Load lookups for creating the complex Multiple Reports.

Experience in summarizing reports, Configuration Management and written Process, Procedure and Technical documentation

Modified Data Scrambling procedures for new requirements

Creating script files for all the records those are migrating to production for DBA team.

Preparing monthly and weekly reports which show all the details of projects which gets migrated to different environments.

HSBC - Hyderabad, India Dec 2007-Sep 2010

Sr Software Engineer (e-Performance, TAM, Release Management, Absence Management and Code HR)

Application/Tools/Database: PeopleSoft 9.1 HCM / PeopleTools 8.54 / DB2

Team Leader for end to end STAT tool implementation(Change Management Tool) user training, creating user manuals.

Team member for implementation of ePerformance module.

Implemented Data scrambling routines for testing environments after refresh from production refresh

Designed workflows, approval process, templates and email notification flow in STAT tool for the release structure

Responsible for system recycles and health checks in order to maintain a stable environment for various teams

Maintain and support TAM & ePerformance, ESS and MSS for Absence Management and Core HR module

Responsible for fixing configuration and integration issues with Absence management system

Created absence takes and absence entitlements

Worked with business users to gather requirements and convert them to technical specifications.

Used XLM publisher for building reports

Used Integration broker

Performed customizations on existing People code, application engine, psquery & SQR

Created outbound and Inbound Interfaces for sending/receiving files from vendors.

Designed several extract SQRs to provide for third party systems data through files using SQCs, UNIX and SQR.

Worked on custom Auto process that removes access to Supervisors for ePerformance review page after cut-off date

Created custom workflow for ePerformace

Responsible for applying Tax Updates into the system by coordinating with NA Payroll team,

Customized existing People soft objects, people code, application engine and SQR

Prepared test cases and end user training documentation

Designed Delegation and Lock-down functionality for ePerformance application

Forbes Marshall - Pune, India Nov 2005 – Nov 2007

Forbes Marshall is a global company that manufacturers and markets several products in field of steam engineering and control instruments

Software Engineer – (Support and Implementation)

Application/Tools/Database: PeopleSoft 8.8 HCM / PeopleTools 8.44 / Oracle

As core member of the team for mid-year review implementation to Annual review process, short hours interface and Training needs system

Implementation of time management system

Implementation of several inbound/outbound processes for payroll.

Worked as Peoplesoft Admin for maintaining user profiles with appropriate security, role and permission list

Gather functional requirements and convert them to technical specs

Created components, pages, records, fields and People Code for the projects

Developed short hour interface and training reminder email alerts using Application engine & component Interface

Developed reports using SQRs

Created unit test scripts

Conducted training and developed user manuals for the three projects

Dolphin Digital - Pune, India Jan 2005 – Nov 2005

Sr. Web Developer -

Responsible for development, implementation and support for web sites developed.

Support management in recruitment process

Train and support junior developers

Shardul Infotech - Pune, India Oct 2003 – Apr 2004

Web Developer -

Develop/Review Code for Bug fixes.

Support testing teams for code testing

Support in maintenance of web applications

EDUCATION QUALIFICATIONS:

Masters in Computer Application from Sikkim Manipal University, Gangtok, India

Bachelors in Information Technology from Manipal Academy for Higher Education, Manipal, India

Contact this candidate