SUMMARY

Around 6 years of professional experience as a PeopleSoft Technical consultant with expertise in Application Development, Customization, Upgrade and Production support of PeopleSoft HCM projects PeopleSoft 8.9, 9.0, 9.1 9.2 .

Oracle Certifications:

PeopleTools 8 Application Developer Certified Expert.

Expertise in PeopleSoft applications design, development and maintenance activities with excellent knowledge in People Tools Application designer, PeopleCode, Application Engine, Application Package, File Layout, ExcelToCI, Component Interface, Workflow, Data mover and reporting using SQRs.

• Possess considerable knowledge in Active Analytic Framework and Event Handler framework.
• Worked closely with business users and the functional team to capture requirements.
• Expertise in the customization and implementation of HCM modules such as HR, Payroll, Base Benefits, Benefits Administration, MSS, ESS, Compensation and CRM - Helpdesk, ESS modules.
• Proficiency in performing fit gap analysis, impact analysis, applying Oracle patches and applying system Tax Updates.
• Extensive experience in gathering and analyzing functional requirements, providing estimates, creating design specifications, development, testing, migrations and user training.
• Experience in managing onsite and offshore model.
• Trained in Oracle Fusion HCM Compensation and Workforce management modules.
• Well versed on various software development methodologies and quality process..
• Keen and quick learner with good interpersonal skills and willingness to take new responsibilities.

TECHNICAL SKILLS / TOOLS

PROJECTS

Confidential

Application: Peoplesoft HCM 9.0, 9.2, People Tools 8.49, 8.53, Oracle 11g

Programming Language: Peoplecode, SQR, SQL, Cobol

ROLES AND RESPONSIBILITIES IN THE PROJECT

• Responsible for requirements analysis through interactions with client users and IT personnel.
• Technical support and maintenance for the HCM 9.0 application. Technical support consists of troubleshooting production problems, design/development of customizations and enhancements.
• Handled all necessary customizations and enhancements for year-end Open enrollment OE to suit business needs for OE'15.
• Design/Development of SQR's and AE's to generate reports/files for various Benefits vendors.
• Applying system tax updates 14D, 14E, 14F 15A and retrofitting customizations after each update.
• Applying ADP patches and retrofitting SQRs that send quaterly reports to ADP during the ADP upgrade.
• Designed/developed a custom event handler framework for MSS transfer that updates the Job component, Tax tables and to send notifications.
• Designed/Developed SQR to track and report the employee health care costs accurately on W2 form 12DD box.
• Involved in generating compare reports, fit-gap analysis, impact analysis and identifying/retro-fitting customizations during Peoplesoft 9.2 upgrade.
• Unit testing and migration of peoplesoft objects and flat files using STAT.

Confidential

Application: Peoplesoft HCM 9.1, People Tools 8.49, IBM DB2

Programming Language: Peoplecode, SQR, SQL

ROLES AND RESPONSIBILITIES IN THE PROJECT

• Mentoring junior members in the team and providing necessary technical assistance.
• Involved in the effort estimation.
• Involved in requirement gathering discussions with the Business and transforming those into technical specifications.
• Design and development of custom bolt-on modules - Supplmentary Unemployment benefits SUB , Overpayments, PILV Pay in Lieu Vacation etc. This involved creation of custom transaction pages, configuration pages and a series of AE processes to achieve the end-to-end payroll functionality.
• SQR's were developed to run post confirmation of on-cycle/off-cycle payroll for layoff accruals, determing eligibility based on rules, counter updates processes etc.
• Complex data validation calculation rules were developed to support the business needs for North America and Canada regions.
• Integration of custom bolt-on's with the existing NA payroll functionality.
• Design and development of a custom batch button page to trigger the hourly on-cycle payroll. Each push button on the page initiates a stream of payroll processes that can be executed in a specific order.
• Understanding the exisitng Chrysler PIE payroll interface engine framework used for validation before loading into paysheets.
• Developing change requests CR's . Unit tesing and migrations.
• Performing code reviews.
• Fixing productions issues.

Confidential

Application: Peoplesoft HCM 9.1, CRM 9.1 People Tools 8.49, Oracle 10g/11g

Programming Language: Peoplecode, SQL

ROLES AND RESPONSIBILITIES IN THE PROJECT

• Understanding the requirement documents and prepared technical specification, test plans and test cases.
• Providing effort estimates for design, development and bug fixing.
• Technical design walk through's and design discussions with client.
• Development and unit testing.
• Mentoring junior folks and performing code reviews.
• Applying oracle delivered bundles to the system.
• Played a techno-functional role and solely handled all the HR Helpdesk deliverables CRM .
• Involved in performance tuning of various application engines and view based interfaces.
• Performed migration related activities like preparing import/export scripts , checklists, migration docs etc.
• Knowledge transfer sessions to the client.
• Sloving production tickets.

Confidential

Application: Peoplesoft HCM 8.9, People Tools 8.49, Microsoft SQL

Programming Language: Peoplecode, SQL

ROLES AND RESPONSIBILITIES IN THE PROJECT

• To co-ordinate with onsite team on daily basis and capture requirements.
• To analyze the gaps in the previous data convresion roll-outs.
• To modify/enhance the code to fit new requirement.
• To validate the employee data received from legacy system and load them into Peoplesoft.
• Collate setup data and load them into Peoplesoft tables using ExcelToCI.
• Verify loaded data and to report discrepensies.
• Performing data correction activities.