Professional Summary

• PeopleSoft and Oracle Certified Professional with 11 years of extensive consulting experience in PeopleSoft HCM and payroll modules and has thorough knowledge in PeopleSoft application development, customization, enhancement, upgrade, and maintenance.
• 7 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,eRecruit,NAPayroll,Compensation,Benefits,TAM,Candidate Gateway, .
• Strong functional knowledge of Core HR setup,configuration and implementation experience in TAM,eRecruit,Compensation,Candidate Gateway,Benefits,NA Payroll and T L modules.
• Excellent working knowledge of Position Management,Org Structure,Workforce Administration,Compensation 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.
• 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,Compensation
• ,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, Integration Broker,Component Interface,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, ASP,
• PL-SQL, FILEAID

Professional Experience:

Confidential

Peoplesoft HCM Functional Lead

Responsibilities

• Led a team of five for the Peopletools upgrade project globallyfor 42 countries multi lingual within CBRE.
• Was involved and leading all stages of a project life cycle including design, development, conversion, testing, training and post-production support.
• Provide CBRE functional PeopleSoft guidance to the functional and technical team. Work with the Program Managers,Training and Communication Leadsto facilitate the solution of issues to leadership.
• Ensuring the new features and resolutions were communicated across APAC and EMEA regions of CBRE. Oversee the HCM domain project deliverables and day-to-day management of the functional area.
• Expertise in handling Acquisition projects that involved Compensation planning and merit increases,Performance documents handling,org setup and Configuration.
• Led the implementation of Mobility for MSS AWE approvals as part of the Feature pack upgrade.
• Extensive experience in leading minimum budgeted projects that included enhancements to the Recruitment and Performance management modules which brought great value to the organization in terms of time consumption and resource management.
• Lead cutover activties,UAT and performance Testing across all regions APAC,EMEA and NA .
• Key contributor to the overall integration strategy and data management between the global teams and designed processes to effectively process and utilize employee data.
• Reviews project deliverables for quality and completeness,manage communication and issues related to the CBRE project ,anticipate roadblocks and work to reduce and/or avoid them.
• Organize functional team workload, e.g., Business Process Documentation, Configuration, Issue Resolution, Support, and Training materials development. Participate in system and integration testing prioritize test scripts, execute scripts, and logs defects .
• Closely interacted with HR and business leadership teams to illustrate the Human capital Management and industry trends, indicate opportunities and drive initiatives to deploy better business processes.

Confidential

Peoplesoft HCM Project Lead

Responsibilities/Jobs Performed

• 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.
• Performed fit/gap analysis, and presented recommendations incorporating industry best practices and client's business practices 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.
• Helped the project manager in putting together the project plan by sharing the CG project methodology, provided the list of tasks, time estimates, resource needs, integration points, potential risks, and identified pre-reqs / contingencies.
• Facilitated workshops and demos to get the client team up to speed with the TAM/Candidate Gateway features / business processes.Separate sessions were created for various audiences including HR Directors, Managers, Business Users and IT team.
• Set up and configured the development, testing, training, and production environments for TAM/ Gateway 9.1 implementation and documentation of these configurations.
• 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.
• Perform UAT and unit level testing and thereby approve sign off on all HR modules before go-live.
• Shared and implemented the best methods for migrating the setup/configuration data from one environment to another.
• Created testing strategy, test scenarios and test scripts for unit, system/integration, and user acceptance testing.
• .Also designed and provided the proper security access for employees, managers, and administrators.
• Designed functional specifications / setup / configured the system for Candidate Gateway 9.1
• 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.
• Implemented automation of screening process using a new Application Engine process.
• 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.
• 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.
• Extensively handled production issues along with Offshore in promoting and scheduling critical jobs and batch processes.
• Working with business analysts and users constantly to understand new customer requirements and offering valuable insight in to the existing functionality of the application.
• Performing fit-gap analysis and assisting clients during requirement gathering phases. Ensuring estimates are met between time and resource allocations.
• Provide functional support for system integration and user acceptance testing.
• Involved on the future state system in conversion of PeopleSoft HR system into Oracle R12 system.
• 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

Senior Peoplesoft Product Analyst / Project Lead

• Standard Chartered Bank, UK, is a leading Bank offering a wide range of value-added and complex services from Banking Operations to supporting global HR processes, Payroll, Finance and Accounting services,
• Software Development and maintenance. SCB has over 75000 employees and services more than 70 countries globally.

Confidential

Senior Product Analyst / Team Lead

• As a Senior Peoplesoft functional consultant, lead a cross-functional team of 8 members.
• Analysis of Project Requirements to provide Estimates. Applying PeopleSoft Tax Updates
• Open Enrollment Processing 4 Months Project: September through December .
• Preparing and running Special Payroll Processing Schedules for holidays.
• Administered the PeopleSoft projects and performed migrations .
• Set up and configured the development, testing, training, and production environments for the Talent Acquisition Manager/ Candidate Gateway implementation and documentation of these configurations.
• Provided demo and training to the business users.
• Prepared Business Process, High-level, and Technical Design documents.
• Responsible for gathering requirements, analysis, and estimation of the project timeline.
• Batch Support Jobs scheduling in UNIX and fixing Sev 1/Sev 2 Production Issues.
• Responsibility in terms of project planning and resource allocation for Peoplesoft 9.0 Implementation.
• 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

Senior System Analyst

Responsibilities/Jobs Performed:

• 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

Senior System Analyst

Responsibilities/Jobs Performed:

• 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

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 incorporate 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