SUMMARY

• PeopleSoft and Oracle Certified Professional with 10+ years of extensive consulting experience in PeopleSoft HCM and payroll modules and has thorough knowledge in PeopleSoft application development, customization, enhancement, upgrade, and maintenance.
• 10 years of functional lead experience in full life cycle including requirement gathering, analysis, design, Configuration, Testing, implementation and maintenance.
• 10+ years of expertise in the implementation and upgrade of Peoplesoft HCM modules and strong functional knowledge in Core HCM modules (ESS and MSS,Position Management,ePerformance, NA Payroll, Compensation,Benefits, TAM, Candidate Gateway,).
• Strong Core HR Functional knowledge and extensive hands on experience in Setup,configuration,Customisation,Critical support for Benefits,Compensation,ePerformance,NA Payroll modules.
• Excellent working knowledge of Position Management,Org Structure,Workforce Administration and Payroll (NA & Global).
• 10+ years of expertise in PeopleTools technologies such as PeopleCode,Application Engine,PS Query,Component Interface, File layout, SQR, and Workflow and in Oracle applications. Strong Reporting skills via SQL, SQR, PS Query tools, Integration tools and File layouts.
• Experience of working on HP Automation tools like Quality Center
• An organized, hard working, and highly motivated professional, with strong communication and interpersonal skills, and the ability to perform individually or as a dedicated team member.

TECHNICAL SKILLS

RDBMS: Oracle 8.x, 9.x, 10g, MS SQL Server 7.0, MS - ACCESS, IBM-DB2.

ERP: PeopleSoft 8.x,9.x - HCM 8.8, 8.9, 9.0,9.1 (Workforce Administration,Position Management,ESS, MSS),PeopleSoft 8.9,9.0,9.1 - HCM,Base Benefits, Benefits Administration,Time and Labor,ePerformance,ESS,MSS,PeopleSoft Security Administration 8.x, PeopleTools 8.49,8.51,SQR,People code,AE, PSQUERY.

People Tools: Peoplesoft Query, AE, Process Scheduler and People code Security, Workflow, PS Admin.

OS: MVS, TSO/ISPF, Windows XP/ NT/2000/2003, UNIX

Reporting tools: PS-Query, Structured Query Report (SQR).

Utilities: SQL Developer, DB2 Command Center, Toad, TSO / ISPF, SPUFI, Changeman XML, ASPPL-SQL, FILEAID

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior Business Analyst / Project Lead

Responsibilities:

• As a senior Business Analyst and lead,held the key responsibility in designing functional specs for critical vendor related interfaces.
• Actively involved in spear heading team meetings across IT and Business to walk through requirements,review design,track deliverables and track statuses on a daily and weekly basis.
• Communicated with client on a daily basis to discuss project status, upcoming deliverables and tasks and to resolve outstanding issues.
• Managed weekly updates to project plan, facilitated periodic project status calls with the client and various management and updated budget reports and verified that all work performed was well documented before migrating to client production environment.
• Preparation of Functional User Acceptance testing scripts and plans for critical Benefits interfaces,Mass Update processes,Rebadging as part of Merger related activities.
• Extensivley involved in setting up Organisational tables to group and re-org the population in Production environment.
• Subject matter expert with regards to implementing major organizational changes to employee's HR data during transfers, promotion/pay review cycles,performance reviews, bonus changes, benefits and other related changes required as part of merging two legacy systems.
• Set up and configured the development, testing, training, and production environments for ePerformance 9.1 implementation and documentation of these configurations.
• Facilitated workshops and demos to get the client team up to speed with the ePerformance features / business processes.Separate sessions were created for various audiences including HR Directors, Managers, Business Users and IT team.
• Helped the project manager in putting together the project plan by sharing the ePerformance project methodology, provided the list of tasks, time estimates, resource needs, integration points, potential risks, and identified pre-reqs / contingencies.
• Performed fit/gap analysis, and presented recommendations incorporating industry best practices and client’s business practices for employee performance management and job / person profile management.
• Designed functional specifications / setup / configured the system for ePerformance.Also designed and provided the proper security access for employees, managers, and administrators.
• Created testing strategy, test scenarios and test scripts for unit, system/integration, and user acceptance testing.
• Shared and implemented the best methods for migrating the setup/configuration data from one environment to another.
• Perform UAT and unit level testing and thereby approve sign off on all HR modules before go-live.
• Involved solely in pre-production setup by preparing test plans,simulating data,execute QA scripts to ensure a smooth cut over for a population of 14k associates
• Developed complex sql scripts to extract data from Legacy PeopleSoft system and developed different methodology to load the same in the new Oracle R12 system. .
• Responsible for understanding and writing business requirements for UK Benefits and translate them into implemental solutions for the technical team. Responsible for end-to-end SDLC life cycle for implementing the UK Benefits successfully.
• Designing/Modifying the various inbound/outbound interfaces (About 350 SQRs) for various internal and other 3rd party HR related applications and support the applications post go-live.
• Worked as a liaison between the current system as well as future state system by understanding them and map the two systems, derive the extraction logic, write conversion extracts, test the conversion extract and troubleshoot any issues that arise.
• Involved on the future state system in conversion of PeopleSoft HR system into Oracle R12 system.
• Provide functional support for system integration and user acceptance testing.
• Performing fit-gap analysis and assisting clients during requirement gathering phases. Ensuring estimates are met between time and resource allocations.
• Working with business analysts and users constantly to understand new customer requirements and offering valuable insight in to the existing functionality of the application.
• Extensively handled production issues (along with Offshore) in promoting and scheduling critical jobs and batch processes.
• Design, develop, test and implement the Compensation harmonization project to upload the associate’s annual promotion, grade change and compensation changes. Done extensive testing and reconciliation of the Compensation update process.
• Conducted major changes to the Bonus Accrual process to implement a country based leave rules to suite different regional regulations concerning country leave rules.
• Designing the various inbound/outbound payroll interfaces (UK, Canada & Mexico) for various internal and other 3rd party HR related applications and support the applications post go-live.
• Prepared monthly reports for General Ledger entry, vacation accrual, payroll accrual, labor costs, payroll taxes and garnishments, etc.
• Recorded, tracked and reviewed PTO taken / accruals; compute PTO for terminated employees and make necessary adjustments to final paycheck.
• Coordinated implementation of employee benefit programs with related payroll reporting requirements.
• Assisted users with payroll related functional queries and discrepancies.
• Took full responsibility in production support before and during go-live by scheduling critical jobs and processes,monitoring,applying fixes & patches,status tracking and reporting on a sequence.
• Responsible for reconciliation of various HR reports as a result of Go-live,submit headcount reports to cross functional teams like Finance/HR directors using SQL,PSQuery.
• Creating and maintaining Issue logs to drive the open issues to prompt resolutions on a periodic basis.
• Support organizations reporting and data analysis needs by creating and supporting complex queries.
• Working on PeopleSoft query tools, access database, excel tool, and/or other reporting compare tools for in-depth data analysis.
• Conducted various workshops and training session to understand the new Oracle R12 system and mapping the functionality back to the Legacy systems.

Environment: HRMS 8.9.9.0,9.1 Benefit Administration, Workforce Administration,TAM,Candidate Gateway,ePerformance,PeopleTools8.49, 8.46, Oracle 10g,PSQUERY,SQR.

Confidential, NY

Senior Product Analyst / Project Lead

Responsibilities:

• As a Senior Peoplesoft functional consultant, lead a cross-functional team of 8 members.
• Responsibility in terms of project planning and resource allocation for Peoplesoft 9.0 Implementation.
• Batch Support (Jobs scheduling in UNIX) and fixing Sev 1/Sev 2 Production Issues.
• Responsible for gathering requirements, analysis, and estimation of the project timeline.
• Prepared Business Process, High-level, and Technical Design documents.
• Provided demo and training to the business users.
• Set up and configured the development, testing, training, and production environments for the Talent Acquisition Manager/ Candidate Gateway implementation and documentation of these configurations.
• Administered the PeopleSoft projects and performed migrations .
• Redesigned routing functionality to send out a mail to the Hiring Managers along with the resume attachment or the applications in the PDF format using Workflow.
• Implemented automation of screening process using a new Application Engine process.
• Worked on customization and redesign the security features in the Candidate Gateway, and look and feel of the Candidate Gateway module for better candidate experience.
• Preparing and running Special Payroll Processing Schedules for holidays.
• Open Enrollment Processing (4 Months Project: September through December).
• Analysis of Project Requirements to provide Estimates. Applying PeopleSoft Tax Updates
• Conducting Weekly Meetings: Project Status Updates / Technical Meetings / Year End Meetings / Quarter End Meetings
• Working/Coordinating with off shore team in India for execution/Testing the functional requirements.
• Development of Records, Pages, Components, Peoplecode and AE as per change requests.
• Fully responsible to maintain a cent percent SLA seamlessly by coordinating and guiding the team. Extensively involved in generating the metrics report that clearly shows the SLAs met on a weekly and monthly basis. These reports have very high visibility with the clients and to project the company’s performance.
• Responsible for coordinating with the business users while User Acceptance testing (UAT). Developed Functionality and Performance testing for all the customizations done throughout the implementation.
• Scheduling and Monitoring the Ongoing interfaces using Process Scheduler, along with creating and generating notification reports on a daily basis for the same.
• Development of SQRS, SQL scripts (Total of 130 conversion scripts) to achieve the successful data conversion on the base tables like Job Data, Department, Location, etc, done after the application upgrade.
• Develop test plans, test scenarios anduser story test cases using HPQuality Center
• Performed unit testing of my modules and reviewed test cases, test documents.

Environment: Environment: PeopleSoft 9.0 (HRMS, Candidate Gateway, Talent Acquisition Manager,ePerformance,ESS,MSS, DB2, PeopleTools 8,SQR, Oracle9i,Unix.

Confidential, Chicago

Senior System Analyst

Responsibilities:

• Extensively involved in Life Cycle including requirement gathering, analysis, design, development, testing,implementing and maintenance for Data warehousing using Peoplesoft EPM 8.9 Implementation.
• Development of AE programs to validate the data integrity against multiple General ledger Account tables and report the results to corresponding users.
• Responsible for data modeling, creating metadata and Peoplesoft migration across different environment.
• Creating and Maintaining Engine Metadata, Record Metadata, Filters, and Constraints for the allocation rules.
• Testing of existing AE programs to ensure a seamless and smooth cutover in UAT.
• Responsible for all kinds of panel customizations and related Peoplecode changes.
• Assisting users to help them understand the functionality behind each developed page and thereby easing the process to get them signed off and approved.
• Created unit test plans and performed unit testing of my modules.
• Serving as security administrator and a single point contact to grant access and privileges based on role and profile across different test, development and production environments.
• Creating Test Strategy document to define specific QA testing strategies, approaches and processes for different Partner Launch.
• Developed, implemented and executed test methodologies, plans to ensure software product quality.

Environment: PeopleTools 8.48, Oracle 9i, SQR, Application Engine, Peoplesoft EPM 8.9

Confidential, NJ

Senior System Analyst

Responsibilities:

• Converted all existing SQRs written in DB2/COBOL to Oracle and Re-wrote for performance testing.
• Fully responsible for critical mass change upload SQRs which involved receiving files/data from third party vendors and loading PS tables for scheduled and one-time Adhoc runs.
• Actively contributed for all unit and System integration testing which involved rigorous compares of modules, reports and processes between the existing DB2/Cobol processes and the current Oracle/SQR processes.
• Diligently maintained design and testing documents for each and every process that was developed and tested throughout the entire scheme of the project.
• Extensively involved in creating recurrence and job definitions and scheduling all the payroll, HR, Mass change and AE processes.
• Fully responsible for scheduling and running all critical processes via PS during go-live.
• Developed several Ad-hoc reports using PS Query for department salaries, salary plans, and deduction, participants in Benefit Programs, salary change Report, salary Mass Updates.
• Played an imperative role in PeopleSoft Base Portal setup for navigation to custom menu items.
• Involved in writing Employee refresh Application Engine to refresh the Employee table by reading Effdated information from the Job, Compensation, Names, Person, Pay group, Salary Plan, Address and Personal Data Effdt tables
• Updated several critical Public Queries for table and field changes due to newer requirements from clients/Customizations in the current process.
• Performance tuning of various SQR and search views and private queries.
• Actively involved in Migrating the projects &objects from development environment to test and production environment.

Environment: Oracle 9i, PeopleTools 8.48, SQR, Application Engine, PeopleSoft HRMS 8.8,Base Benefits.

Confidential

Team Lead

Responsibilities:

• Analyzed System Requirements to gain better understanding of the application and helped the QA Team in preparing a detailed master test plan that provides a detailed list of conditions under which the system will be tested.
• Involved in Performance testing, Regression testing and User Acceptance Testing.
• Created User Defined functions to enhance the maintainability of test scripts.
• Since this application contains sensitive information of customers, performed Security Testing to ensure that security was maintained throughout the application.
• Re-engineering of their current Security Process.
• Verified changes and closed bugs during regression testing.
• Functional assistance in PS Benefits and HRMS 8.4.
• Involved in executing service request related to Functional Queries, security and interface development, Build Automation Tools.
• Supporting & training the end users on the new functionality enhancements /customizations.
• Provide functional clarifications & also involved in the testing of new enhancement customizations.
• Performed Data Integrity testing by executing SQL and PL/SQL Statements.

Environment: Oracle 9i, PeopleTools 8.46, SQR, Application Engine, PeopleSoft 8.8, NA Payroll, Base Benefits 8.8.

Confidential, Woodlands TX

Senior Software Engineer

Responsibilities:

• Cross checking the daily batch run reports with Client server reports in Production.
• Created ad-hoc Reports in PS 7.x/PS 8.x HR, Payroll, Benefits, Compensation and EDM for analysis.
• Created Standard and Ad-hoc Reports using PS-Query, Oracle SQL Plus and MS-Access.
• Developed the HR & Payroll Reports for Executives and Top management as per the requirements.
• Developed new SQR reports like Employee earnings history report by from/thru dates range.
• Created lot of reports using PS-Query for users to run on their own.
• Fine-tuned and debugged SQL Queries efficiently to meet the Client’s requirements.
• Involved in the conversion of SQR to PS-Query.
• Involved in the creation of complex SQL queries for year end processing
• Used Security Administrator in order to in corporate security within the system.

Environment: Oracle 9i, Peoplesoft 7.x/8.x HRMS 8.3, People Tools 8.4, PS-Query, SQR, MS-Access.

Confidential

Software Engineer

Responsibilities:

• Understanding the business requirements and documenting the same with constant coordination with the Business Analysts.
• Performing impact analysis and making code changes in the case of client-customized programs.
• Creating new programs to generate reports and/or files as per the clients’ business logic.
• Understanding the functional impact of PeopleSoft Tax Update releases by coordinating with the Business Analysts. Technically analyzing the code changes required for the Tax Update and modifying the client customized programs accordingly.
• Involved in analyzing and coding for ARC projects like PSI, Oracle, CSP, Restricted Stock Dividends, Restricted Stock Release and Security Audit Reporting.
• Nominated as the MMS (Metrics Management System) coordinator and RFS (Request for Service) ID coordinator for the team in Aug’04 to May‘05.

Environment: Peoplesoft 7.x/8.x HRMS 8.3, NA Payroll, PeopleTools, PS-Query, SQR, Mainframe OS390, DB2