Professional Summary

• 15 years of IT industry experience of which 11 years as a PeopleSoft HRMS Techno-functional Consultant.

Experienced in different roles as Project Lead, Technical lead, Business Analyst, Systems Analyst and Developer. PeopleSoft 8.x/9.x HCMS experience in the modules of HR, Payroll, Benefits, Ben Admin, Pension Admin, Position Management, Absence Management, ELM, Time &Labor, self-service (ESS, MSS) & collaborative apps (eRecruit, ePay, eBenefits, eProfile, ePerformance),

• Hands-on experience in scope study, requirements gathering, Functional Requirements, Fit-Gap Analysis, Design, Configuration, Change Management, Risk Assessment, End-User Acceptance Testing, Product Development, Quality Assurance and developing Functional and Tech. Specs.
• Expertise in People Tools, Application Designer, Workflow, Component Interface, Application Engine, Integration Broker, Application Messaging, Data Mover, Tree Manager, People Code, SQR, PS Query and Security Admin.
• Delivered end to end process/systems including business and user requirement analysis, process studies and constant improvement of the systems, functional documentations, managing consistency in quality and improvement in the process, production database updates, testing and validation.
• Mentored IT teams by orienting, training, assigning, scheduling, and coaching individuals for peak performance.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.

Experienced in various stages of project development life cycle - Project Planning, Estimation, Requirement gathering, estimation, Analysis, Design, Implementation, Unit Testing, SIT, Acceptance Testing, preparing FDD/TDD, Training, Data Migration, Production Cutover, Incident & Problem Management, Transition Management and Configuration/Quality Management. Excellent communication, analytical, presentation, interpersonal, interaction and organizational skills, vibrant Team player/leader who loves taking additional individual responsibilities

• Has 7 years onsite experience in customer facing, relationship development, proactive demand generation and account mining roles
• Extensive experience in leading and managing teams in both onsite/offshore models.
• Knowledge in Business Process Manager.

Skills Summary

PeopleSoft HRMS Modules: PeopleSoft HCM (HRMS) v 9.x/8.9/8.8/8.3/8.0/7.5
Core HR, North American Payroll, Payroll Interfaces, Compensation, Base Benefits, Benefits Administration, Time & Labor, Employee Self Service, Manager Self Service, Absence Management, Talent Acquisition Manager, Candidate Gateway, ePerformance, eCompensation, eBenefits, ePay, eProfile and ELMS.

People Tools/ Utilities: PeopleTools 8.1x, 8.2x, 8.4x, 8.5x, Peoplecode, Application Designer, Application Engine, AWE - Approval workflow engine, Component Interface, File Layout, Application Messaging, Integration Broker, Process Scheduler, PS Query, Data Mover, Import Manager, Workflow, Excel to CI, STAT and Security.
Reporting Tools: SQR, Pro*C, Oracle Forms, nVision, XML Publisher and Crystal Reports

Operating Systems: Windows NT/XP/95, MS DOS and UNIX
Languages: C, C++, HTML, XML, COBOL, SQL, and PL/SQL
RDBMS: Oracle 7.x/8.x/9i/10g/11g, SQL Server, DB2

Project details

Project: Confidential,
Duration: April 2012 to till date
Project Role: PeopleSoft Analyst

Roles & Responsibilities:

• Analyze the application.
• Applying maintenance packs and bundles.
• Managing the project.
• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• AWE customization.
• Troubleshoot high priority issues during development.
• Modified processes and corresponding Linux scripts based on the requirements.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement tickets.
• Customer interaction and understand the business requirement, analyzing and preparing Functional/Technical Design documents, giving the estimation and working on client deliverables.
• Oversaw and coordinated efforts of the functional team, technical team, testing team, application security and Responsible for successful delivery of technical development with quality.

Environment: Peoplesoft SCM 9.1 (Procurement and Purchasing)
People Tools 8.50.21, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, AWE, Linux scripting.

Project: Confidential,
Duration: Nov 2011 to Dec 2011
Project Role: Senior PeopleSoft Consultant

Roles & Responsibilities:

• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• Troubleshoot high priority issues during development.
• Modifications to Benefits enrollment form changes.
• PeopleSoft AWE customization.
• Modified processes and corresponding Linux scripts based on the requirements.
• Accept and resolve tickets from clients for ESS and MSS modules.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement tickets.
• Customer interaction and understand the business requirement, analyzing and preparing Functional/Technical Design documents, giving the estimation and working on client deliverables.
• Oversaw and coordinated efforts of the functional team, technical team, testing team, application security and Responsible for successful delivery of technical development with quality.

Environment: PS HRMS 8.9 (HR, Payroll, Benefits, Time and Attendance, GL and AP)
People Tools 8.49.30, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, Workflow, Linux scripting.

Confidential,PeopleSoft HCM Application Support and Enhancements
Duration: Aug 2009 – Jul 2011

Roles & Responsibilities:
Role: Team lead

Responsibilities:

• Facilitated meetings with HRMS team members to identify business requirements.
• Customer interaction and understand the business requirement, analyzing the FDD, preparing Technical Design, giving the estimation and working on client deliverables.
• Lead for all infrastructure related items with People Soft.
• Manage daily, weekly review of the team.
• Oversaw and coordinated efforts of the technical team, testing team, application security and
• Responsible for successful delivery of technical development from offshore, with quality.
• Deliverables meeting the business requirements, on time and on budget. Managed day to day activities project team members
• PeopleSoft HCM Application Security.
• Managing the customer & Vendor relationship.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation. Provided production support and functionality enhancements to improve HR and Payroll efficiencies.
• Created and managed Project Charter, Project Plan, Risk log, Issues log, Status reports, project team meetings and other project related project office activities and strategy documents in collaboration with the HCM Program manager
• Responsible for Design, development, implementation, testing and support of assigned software Projects and applications from offshore.
• Manage the New change request or development in the existing system.
• Managing Resource Allocation, Effort Estimation & project planning.
• Involved in Gathering and Analyzing requirements for HR Initiatives project to Outsource Health & Welfare Benefits to ACS.
• Prepared Functional Specification for Interfaces from ACS to Dana to bring in General Deduction Data.
• AWE customization.
• Worked on the Customizations of Recruitment/TAM Module.
• Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
• Performed system study of current Base Benefits and Benefits Administration setup as part of Application support transition project.
• Providing Production Support, User Support and Enhancements in Payroll (8000 Hourly employee, 3000 Salaried Employee), Ben Admin, and Base Benefits modules.
• Monitored project deliverables and execution(Change Management, Implementation, production Support and Security) to meet Sarbanes-Oxley requirements
• Participated in External vendor management, including gathering 3rd party vendor requirements and communicating the same to the business, providing IT solutions to business as per need. Prepared functional technical design documents for respective PeopleSoft solutions
• Developed solutions based on specifications including application customizations, custom reports, and interfaces.(Using SQR, People Code, Application Engine, Component Interfaces , File layouts etc.)

Environment: PS HRMS 9.1 (HR, Payroll, Benefits, Pension Admin, Time and Attendance,
Absence Management, GL and AP)
People Tools 8.50, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, Peoplecode, Workflow,
Unix.

Confidential,Support/Enhancement project
Duration: Aug 2008 – Jul 2009

Roles & Responsibilities:
Role: PeopleSoft Tech lead.

Responsibilities:

• Design, development and enforcement of the Quality Standards, document templates, test database creation, test plans and the document control procedures, Application Security Strategy, design, configuration, maintenance and troubleshooting.
• Quality Assurance of PeopleSoft objects including Components, Pages, Menus, Records, Peoplecode, Application Engine, Component Interfaces and Security.
• Testing the full functionality of new /existing reports using SQL and PeopleSoft Queries.
• Onsite- offshore co-ordination, requirements gathering, estimation, designing and planning.
  Ensure SLA compliance, customer satisfaction; provide weekly & monthly reports, trainings and mentoring.
• Production support for trouble shooting and bug fixing.
• Quality Assurance, reviews and system/integration testing.

Preparing Functional and Technical specifications.
Design and review the test plans.
Developed Outbound Interface programs to process Employees Demographic Information, Basic Demographic Information, Payroll Data, Health, Medical and Dental Eligibility information from PeopleSoft System to 3rd party system.
Designed and developed an online Enhancement to assign the Emplids with in the delivered PeopleSoft application and developed a custom program to identify which Emplids have been used and unused.
Performed Code reviews to ensure that code meets best practices and functionality.
Customized the Employee Self Service and Manager Self Service personal info summary pages.
Developed a process to create interface between Benefits and Time & Labor which compares Employee\'s leaves recorded in Time & Labor against the allowed leaves.
Customized the delivered SQR process BAS005 to generate Benefits confirmation statement that meets business requirement.
Also Working on other Integration Tools for Integrating PeopleSoft Data with other Applications.
Developing interfaces and reports.
Working on customizations for self-services, core HR and Benefit HRMS modules.
Modifications of SQR’s, people code, creating new process for uploading data using CI and application engines.
Developing new interfaces for different vendors MetLife, BUCK, MetLaw etc.
Environment: Oracle 9i,SQL, PL-SQL, Windows, PeopleSoft HCM 8.8 Core HR, ESS&MSS Benefits, Payroll interface, Compensation, PeopleTools 8.45 and SQR.

Confidential,Support and Customizations of PeopleSoft HCM 8.8
Duration: Nov 2007 – Jul 2008

Roles & Responsibilities:
PeopleSoft Techno functional consultant

This project involves the Production support and enhancements to the existing PeopleSoft system. My role involves following.

• Worked on OE in e-benefits so that employees have the option to fill their open enrolment in e-benefits and worked on print summary function in e-benefits.
• Calculate benefit costs and coverage amount in benefit administration. Preparing for open enrollment and event maintenance process. Building pay calendars and running the base audits.
• Scheduling the BenAdmin process. Worked on running the Ben Admin process to populate the Snap Table. Setup the FSA Claim Processing and customize the claim processing
• Running the base benefit audits and fixing it. Setting up the snapshot ids. Running the Ben admin open enrollment, event maintenance and snapshot process. Setup and configured the business rules for event rules and eligibility Criteria rules workflow in ben admin.Setting up the PeopleSoft Payroll interface for import/Export data from ADP.
• Setting up security for users, permission list and roles for user to access specific page in PeopleSoft. Worked on benefit Admin process to get the employees enrolled.
• Working on production support and development and enhancements

Preparing Technical specifications. Developed Outbound Interface programs to process Employees Demographic Information, Basic Demographic Information, Payroll Data, Health, Medical and Dental Eligibility information from PeopleSoft System to 3rd party system.
Created custom reports on Base Benefits on Deduction Rate change and HI Enrollment.
Calculate benefit costs and coverage amount in benefit administration.
Preparing for open enrollment and event maintenance process.
Scheduling the BenAdmin process. Worked on running the Ben Admin process to populate the Snap Table.
Developing interfaces and reports. Also Involved in the development and customization of on-line panels and menus
Working on customizations for self-services, core HR and Benefit HRMS modules.
Providing Production Support for released work.
Modifications of SQR’s, people code, creating new process for uploading data using CI and application engines.
Major developments:

• Developed application engine process to upload JOBCODE’s using CI. Developed application engine process to upload JOB data changes and
• Upload employee salaries using CI. Developed different interfaces for Softscape, Worforce logic and HRSMART.
• Developed Hire process for both Workforce logic and HRSMART using application engine and CI which includes auto creation of user profiles.
• Open enrollment changes. Developed department sync between PeopleSoft finance and HRMS using IB.

Environment: Oracle 9i, SQL, PL/SQL, Windows, PeopleSoft 8.8 Core HR, ESS&MSS, Base Benefits, Benefits administration, Payroll Interface, PeopleTools 8.45 and SQR.

Confidential,Implementation of PeopleSoft HCM 8.8
Duration: Jan 2005 – Aug 2007

Roles & Responsibilities:
PeopleSoft Technical consultant

Developed Functional and Technical design documents for complex processes, customizations, enhancements, reports, interfaces and conversion programs.
Gathered requirements, analyzed, designed and developed Interfaces and processes to integrate Legacy and 3rd party systems with the PeopleSoft HCM system.
Designing Test plans by comparing the inputs and desired output
Designed and developed Data Conversion programs to convert Employee data from a legacy mainframe HR/Payroll System to PeopleSoft HR/Payroll System using Component Interface and Application Engine.
Developed Application Engine batch process to determine the Employee’s full vacation entitlement.
Involved in analysis of COBRA Interface and writing Technical Specifications. Writing interface programs based on technical specs to send changes occurring in benefits.
Developed an Inbound Interface program which processes the 401k contribution amount and loan deduction amount from 3rd party system to PeopleSoft HCM system.
Developed reports to present the Benefit information, Job Anniversary, Retired Employees, Terminated Employees information.
Also Involved in the development and customization of on-line panels and menus
Timesheets Customization. Comptime, Shift Differential, Overtime, holiday rules developed.
Trouble shooting HR/Payroll/ Time & Labor issues.
Working on customizations for self-services, core HR and Benefit and Time & labor modules. Providing Production Support for released work.
Worked on the Customizations of Recruitment/TAM Module.
Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
Developed, customized and modified existing records, pages, components, menus, Sub-records using Application Designer to meet the Business requirements of the client.
Customization of Application engine Programs to accommodate the requirements of the Client and to perform background SQL processing.
Involved in applying Maintenance Packs, Tax Updates, Patches, Bundles and Objects migration
Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information in to PeopleSoft Tables.
Created Data mover Scripts to move Roles, Users, and User Preferences with other security setup to be migrated from one instance to other.
Involved in creating Technical documents, development and enhancement of PeopleSoft HR, Base Benefits and Payroll. Unit Testing of the Customizations.

Environment: Oracle 9i, SQL, PL/SQL, PeopleSoft 8.8 Core HR, ESS&MSS, Contract admin, Compensation, Time and Labor, Position Management, NA Payroll, Candidate Gateway,ELM, PeopleTools 8.45, SQR

Confidential,Support and Customization of PeopleSoft HRMS 8.x
Duration: Jun 2003 – Jan 2005

The project maintains the Employee Information using the HRMS. The project included implementation, customization of interfaces and enhancements to the existing system.

Roles& Responsibilities:

Involved in KAP phase for 2 months in BOSTON, US at client place and prepared SMTD and EPD after the KAP.
Prepared Technical specifications.
Managing Team of 4 Resources
Working on PeopleSoft version 8.3, PeopleTools 8.18
Designing Test plans by comparing the inputs and desired output
Designing the Technical Design Document for the reports
Coding for application Engine programs making File layouts etc for importing data from Flat files to PeopleSoft Database.
Also Working on other Integration Tools for Integrating PeopleSoft Data with other Applications.
Developing reports using the PeopleSoft Query, SQR.
Also Involved in the development and customization of on-line panels and menus
Providing Production Support.
Created Object modification and Unit Test Plan documents for each change performed on all objects using quest stat.
Tested and executed these UTPs to prepare System test and Implementation.
Also Monitoring and providing user support, production support and enhancements for Vacation Accrual, Interfaces, Yearend process etc.
Responsible for debugging and troubleshooting the payroll issues.

Environment:
Peoplesoft HRMS v8.18 Core HR, Benefits, Applicant tracking/Recruit Workforce Payroll interfaces, Recruiting, People Tools v8.3, SQR, MS Access, Oracle v8.1.7, Win NT

Confidential,Upgrade of PeopleSoft from ver.7.5 to 8.3.
Duration: Oct 2002 – May 2003

• Roles & Responsibility
• As a PeopleSoft developer involved in following activates.
• Designed and developed various interface programs to move data from Legacy Systems to Peoplesoft database by using SQR, Application Engine.
• Worked with development team during the upgrade of PeopleSoft from version 7.5 to version 8.3.
• Retrofitted the batch programs SQR’s and SQL’s scripts for PS8 upgrade based on the analysis that was made.
• Analyzing the impact of new fields in custom programs developed.
• Identifying the batch programs SQR\'s and SQC\'s that needs to be retrofitted for PS8.
• Data validations, Setting default values, dynamically deriving the field values, implementing business rules etc. using People Code. Debugging the People Code using Debugger.
• Reviewed and modified Application Engine programs that are used to convert application data.
• Validated and modified People code changes.
• Responsible for unit and integration testing of the customized/modified applications and PeopleSoft delivered fixes and patches.
• Developed interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interface
• Developed new SQR programs to pull the data from PeopleSoft Database and it generate a Flat File, CSV file according to Technical specification.

Environment:
HRMS v7.5 and 8.3, People Tools v8.16, SQR, MS Access, Oracle v8.1.6, Win NT and unix

Confidential,USA -- Confidential,
Duration: Oct ’00 - Oct ‘02
Roles& Responsibilities:

• Involved in Knowledge acquisition phase for around 2 months in Virginia, US, at client place.
• Prepared SMTD and EPD after the KAP.
• Involved in the technical detail designs, Troubleshooting panels. Fixed errors and bugs and tested the application.
• Tested and executed these UTPs to prepare System test and Implementation.
• Used Data Mover to move data from one environment to another for unit and integration testing.
• Created/modified Pro*C programs for processing and reporting purpose for various clients.
• Prepared Test cases and involved in the testing of different modules.
• Creation of database objects like tables, views, procedures and packages.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN and HINTS

Environment: Window 2000/Win NT, MS Access, Oracle, SQL, PL/SQL and Pro*C

Confidential,India -- Mutual Funds
Duration: OCT ‘1998 – Oct 2000

Roles & Responsibilities

• As a development Team Member, was involved in design, Development, Testing and implementation of applications for batch processing and reports generation using Pro*C. Discussing with Project manager and Client.
• Prepared Specifications, technical documentation and test cases.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Involved in the Analysis of the Systems.
• Creation of database objects like tables, views, procedures and packages.
• Created and modified data entry screens.
• Created/modified various reports useful for management.
• Testing of screens and reports.
• Creation of database objects like tables, views, procedures and packages.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Involved in the designing of databases and developed the ER Diagrams with ERWIN.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN and HINTS

Environment: Unix, Oracle, Oracle-Forms, SQL, PL/SQL and Pro*C

Software Piracy Control System (SPCS)
Duration: Aug ’98 – Oct ‘98
Roles & Responsibilities:

• Developer. As a development Team Member, was involved in design, Development,
• Testing and implementation of applications
• Some of the activities performed were :
• Involved in the Analysis of the Systems.
• Preparing Specification.
• Testing of the Application
• Prepared Test Cases

Platform: Turbo C, Windows

Confidential,Duration: Jan ’98 – Jul ‘ 98
Roles & Responsibilities:

• Developer. As a development Team Member, was involved in design, Development,
• Testing and implementation of applications
• Some of the activities performed were :
• Involved in the Analysis of the Systems.
• Data entry Screens designed
• Preparing Specification.
• Prepared Test Cases
• Testing of the Application

Platform: Windows 95, Power Builder 4.0, MS Access

Confidential,
Dration: Oct ’96 – Dec ‘97
Roles & Responsibilities:

• As a development Team Member, was involved in design, Development,
• Testing and implementation of applications for batch processing and reports generation using Pro*C. Discussing with Project manager and Client.

Employment History:

Aug 07

Till date

Confidential,

• Senior Systems Analyst

Oct-02

Aug - 07

Confidential,

• Associate Consultant

Oct – 00

Oct - 02

Confidential,

• Senior Software Engineer (Technical Consultant)

Oct – 98

Oct - 00

Confidential,

• Systems Analyst

Oct – 96

Oct – 98

Confidential,

• Programmer

Education, Training & Certifications

• MCA (Master of Computer Applications)
• B.Sc.(Bachelor of Science)