Test Cases Data
Resume:
Saurabh Singh
****************@*****.***
Summary:
** ***** ** *********** ** Experience which includes experience in Implementation, Customization, Upgrade and Maintenance of Oracle HCM Fusion cloud and Oracle HCM Applications. Experience with analysis, design, development, customizations, data migration and implementation of PeopleSoft application.
Around 2+ years of experience in Oracle Fusion HCM Cloud with implementation projects.
Part of two implementation project on Oracle Cloud HCM.
Oracle Global Human Resources Cloud 2016 Certified Implementation Specialist.
Understanding of technical architecture of Oracle HCM fusion - how to build interfaces, reports, extensions.
Experience in HCM Cloud in engagements involving Core HR and other modules.
Experience in full cycle implementations of HCM Cloud.
Worked IT / software projects for Telecom, Banking and E&U industry and Public Sector Projects.
Good communication, interpersonal, analytical and problem solving skills. Willingness and ability to quickly adapt to new environment.
Development and modification of Outbound and Inbound interfaces.
Involved in documentation of technical specifications and developing test cases.
Effective Team Player and an individual contributor with steep learning curve.
Experience in HRMS modules (Core HR/ NA and Global Payroll/ Time & Labor/Absence Management).
Worked individually, as well as in team environment, to achieve project goals.
Working Experiences in Databases like Oracle, SQL Server.
Experience in Project life cycle to include design, configuration, development, integration, testing, and operational deployment.
Worked as consultant on Oracle Technologies which includes HCM Fusion and several version of Oracle HCM modules like Core HR, PS Security, ESS-MSS, Time and Labor, Base Benefit and Payroll.
Standardization of Oracle HCM Cloud deliverables.
Strong Experience in data conversion and data migration from Peoplesoft to Oracle HCM.
Part of product innovation group to work on cloud HCM development for Oracle fusion projects.
Experience in developing fast formulas, creating data model,writing Oracle SQL/PLSQL code, BI Publisher, OTBI, XML Publisher, HDL.
Good understanding of Oracle Unified methodology for Cloud Application Services.
HDL Data Migration experience in migrating data pertaining to employee, payroll data using PBL from legacy applications such as PeopleSoft.
Good Understanding of the data mapping, data modelling and data conversion between Peoplesoft and HCM fusion.;
Experience in building custom OBIEE reports for HCM Cloud.
Experience in building HCM Extracts.
Highlights:
2+ Years of Oracle Fusion Cloud Consultant. Have worked in Core HR, Absence Management, Payroll.
Functional/ Domain understanding of Human Capital Management.
Strong experience Core-HR/ Recruitment /ePerformance/NA Payroll/ Benefits/ Time and Labor and Compensation.
Completed comprehensive Oracle Fusion HCM training on Core HR, Payroll.
Skills:
ERP
Orcale HCM Cloud (Core HR and Payroll)
Fusion Development Tool
HCM Data Loader, Payroll batch Loader and Spreadsheet Loader,fast formula,HCM extract,OTBI REPORT, Sandbox,Approval Framework, HCM FUSION Integration, Security
Fusion HCM Modules
Oracle Core HR, Payroll
Programming Languages
: People Code and SQL
Operating Systems
: Windows 2000/NT/XP/98/2007
Database Environments
: Oracle 8.0/ 8.1/9.0/9i/11,11g, MS-SQL Server.
Reporting Tools
: SQR, PS Query,OTBI reports,BI Publisher
Certifications:
Oracle Global Human Resources Cloud 2016 Implementation Essentials – 1Z0 329
PeopleSoft Application Developer I: People Tools & PeopleCode 1Z0-241
PeopleSoft Application Developer II: Application Engine & Integration 1Z0-242
PeopleSoft Enterprise 9 Human Capital Management, Human Resources Consultant Certified Expert
Education:
Bachelor’s in Electronics and Communications, UP Technical University, India,
Master’s of Business Administration, IMT, India
Professional Experience:
Client: Goldman Sach, Jersey City, NJ October 2017 – Till date
Description: Goldman Sach was using PeopleSoft HCM legacy system for Core HR which was providing the required data to the downstream system. They are implementing Core HR in Oracle Fusion HCM Applications and would integrate the downstream application to fusion application.
Role: Oracle HCM Fusion Functional Consultant / Peoplesoft Global Payroll Upgrade
RESPONSIBILITIES:
Working closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions, integration and conversions for Oracle HCM Cloud.
Lead role for Onshore and Offshore developers and manage assignment and schedule delivery of enhancement and break fixes on time.
Involved in preparing configuration workbooks for Fusion HCM, entering data and transaction testing for the same in the application.
Develop technical design and documentation for Oracle HCM Cloud dependent data conversions, data migration, interfaces, custom reporting, and custom applications.
Open, manage, and resolve Oracle Service Requests with Oracle Support.
Design, Document and Perform Unit Testing to validate product functionality.
Investigate and resolve complex problems through research and technical analysis.
Participate in testing efforts to identify and resolve conversion and/or interface issues.
Working on HCM extract.
Participated in fit gap analysis.
Worked closely with User and functional, attended multiple CRP session to gathering the requirement.
Document and configure the solution design.
Maintain and/or grow expertise in multiple functional business area.
Working on the data loading from the PeopleSoft legacy system to Core HR in HCM fusion using HDL tool.
Involved in key field data mapping to upload the data from Peoplesoft Core HR to fusion.
Analysis of Legacy of Core HR system in HR workways and fit gap analysis for the business process requirement in HCM fusion.
Working on the defect and issues of Global Payroll downstream application.
Handling production support and enhancement request for Payroll issues.
Preparing Test plan, Test Cases. Modifying existing test cases as UAT test cases.
Helping / Suggesting Team in understanding PeopleSoft business processes
Environment: Oracle HCM Cloud R12, HCM fusion implementation, Peoplesoft tool.
Client: MetLife, Columbia, SC June 2017 – September 2017
Description: Oracle HCM Fusion support project
Role: Oracle HCM cloud Functional
RESPONSIBILITIES:
Interaction with client to get the requirement and resolving the issues.
Customization using EFF and DFF.
Responsible for successful testing of developed solution including User Acceptance Testing and work with the users to validate the solution.
Worked on payroll tickets.
Performed project activities related to requirements gathering and fit/gap analysis, system design, core table setup, testing in support of HCM core HR module.
Created OTBI reports with multiple subject areas.
Did configuration and mapping of the business unit and reference data sets.
Created the data model and hcm extract based on the same.
Working with technical team members for data migrations, customizations and enhancements.
Assist in managing concurrent processing (including custom programs, interfaces and processes).
Global Transfer of employees from one legal entity to other legal entity using HDL data. Load script.
Creating the multiple data model for the HCM extract / BI reports.
Involved in gathering the application specifications from Business Analyst and developed test cases and managed test plans for new and existing product versions
Leading the team of onshore / Offshore developers.
Worked on configuration of approval rules.
Experience of pre and post update and upgrade activities.
Environment: Oracle HCM Cloud R12, HCM fusion implementation, Peoplesoft Technical
Client: University of South Carolina, Columbia, SC Oct 2016 – May 2017
Description: USC was using PeopleSoft HCM version 9.2 applications for managing HCM data operations. They were implementing Oracle Fusion HCM Applications on cloud.
Role: Oracle HCM cloud Functional
RESPONSIBILITIES:
Involved in functionality discussions with customers and helped them in finalizing their requirements explaining them how certain specifications can be fusion HCM
Part of the implementation team for Core HR.
Document business requirements and procedures, Support the implementation of the technical and functional work stream.
Resolved many issues across core HR module used by the customer in a timely manner so that customers are at ease using the system
Worked on Data load HDL from functional standpoint and helping to get the mapping related issues resolved.
Worked on creating element and managing element entries.
Involved in SIT of HR core interfaces and reports.
Worked on BI reports.
Worked on the integration issues.
Good experience in impact and fit / gap analysis.
Worked in data conversion using application engine and component interface.
Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.
Day to day client facing for requirement gathering and clarifications required.
Provide the UAT support for the enhancements.
Writing negative and positive test scenarios
Conducting defect review meetings with the developers and Business analyst
Attending design walk through and discussion meetings with Business Analysts and development teams and transferring the knowledge to the offshore teams.
Integrating the Peoplesoft with the supporting application with the help of integration broker.
Environment: Oracle HCM Cloud R12, HCM fusion, Peoplesoft HCM /FIN Techno functional Technical
State of Ohio, Baton Rouge, LA Feb 2015 – Sep 2016
Role: PeopleSoft HCM Technical Consultant / Oracle HCM fusion
Project: PeopleSoft Techno functional HCM 9.2/ Oracle HCM fusion techno functional
Description: The Ohio Bureau of Workers' Compensation (OBWC or BWC) has provided medical and compensation benefits for work-related injuries, diseases and deaths.
Responsibilities:
Support services on PeopleSoft HRMS modules and Web Stream (Core HR, NA Payroll, Benefits, Talent Acquisition Manager (TAM), MSS, ESS, Compensation, Time and Labor).
Involve resolving production support tickets on daily basis. Managing the team on daily support activities.
Business requirements gathering and clarification sessions with the clients
Identifying Testing scope for Tax updates, PeopleSoft Patches /Bundles
Involved in PeopleSoft Online business process, Batch, Reports and Workflow testing.
Preparing Test plan, reviewing test cases written by the off shore team.
Gathering requirements & Presenting Scenarios, Creating Test data/ reviewing test data
Conducting defect review meetings with the clients
Communicating and coordinating with the management and development teams for quick resolution of critical issues.
Running payroll for different populations in test environment and analyze pay roll messages
Designed the ACA (Affordable care Act) for open enrollment Interface successfully using Application Engine and Component Interface.
Created customized Application Engine programs based on user requirements.
Got the Client Appreciation for successfully implementing within the required time frame.
Did the customization for the Tuition Reimbursement module Enhancements.
Coordinated with my team developers to get the assigned worked delivered on time.
Wrote People Code to customize the delivered objects for HR records.
Worked on Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments.
Involved in Resolving production tickets in HR.
Performed Production Support, enhancements and customizations of PeopleSoft HRMS 9.2.
Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
Customized Pages, Components, Records and Views to implement the functionality of Tuition Reimbursement in Manager Self Service.
Part of the fusion technical team handling data uploads.
Worked on OTBI reports for employee demographic data.
Worked on change only HCM EXTRACT to pull the employee details for benefit and Payroll process.
Did data conversion using the application engine.
Environment: PeopleSoft 9.1, People Tools 8.54, Oracle HCM fusion and Oracle 11g
Pentair, Minneapolis, MN Sep 2014 – January 2015
Role: PeopleSoft HCM Consultant
Project: PeopleSoft HCM 9.2(Core HR, NA Payroll, MSS, ESS, eRecruit, ePay, Time and Labor) Reimplementation
Description: Pentair plc (PNR) is a multinational diversified industrial company incorporated in Ireland with tax residency in UK, with its main U.S. office located in Minneapolis, Minnesota
Responsibilities:
Involved in coding App Engine Programs that which uses Component interfaces in order validate the components like Employee General Deductions, Additional Pay, and Direct Deposit.
Worked on Integration broker setup in creating Nodes, messages, services, service Operations and generating the WSDL from Provide Web service component.
Fixed the People Code issue regarding the Screening Question’s on the Job Posting Page which differentiates screening questions between Internal and External Applicants.
Developed an App Engine which uses File Layouts to FTP the files to Bank for Positive Pay and Bank Reconciliation.
Attending design walk through and discussion meetings with Business Analysts and development teams and transferring the knowledge to the offshore teams.
As a technical developer, provided production support and maintenance for various PeopleSoft applications.
Day to day client facing for requirement gathering and clarifications required.
Provide the UAT support for the Global payroll based tickets.
Worked on the related content reference issue.
Created new and customized existing Record definitions, Pages, Components for the client specific functionality.
Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
Worked on security for all the custom components and pages.
Environment: PeopleSoft 9.2, People Tools 8.53, PeopleCode, SQR, File Layout, Application Engine, Component Interface, Integration Broker, Data Mover, Oracle 11g
KVB Bank, India Jan 2014 – Aug 2014
Role: PeopleSoft HCM Techno/Functional Consultant
Project: Peoplesoft HRMS Implementation (Core HR, NA Payroll, MSS, ESS, eRecruit, ePay, Time and Labor, Repo)
Description: The bank primarily operates in treasury,corporate/wholesale banking and retail banking segments. KVB provides services such as personal, corporate, agricultural banking and services to NRIs and MSME.
Responsibilities:
Project modules includes Core HR, Compensation, Employee self-service and E-recruitment.
Wrote the Functional documents based on the business requirements.
Created Run control pages, components, attached them to required menus through Application Designer and made them available to various operators, the reports and processes run under process scheduler.
Modified SQR’s to Application Engine programs according to client requirements.
Worked on Absence Management (LOA and RFL interface to Payroll).
Wrote PeopleCode to validate and accomplish the business tasks.
Worked on Split functions for inbound and outbound interfaces development and testing.
Worked on AWE (Approval Workflow Engine) for self service.
Reviewed design documentation and managed testing activities. Preparing test plans and test cases that ensure the product adheres to the application requirements.
Developed the Increment Process for the concerned Bank using Application Engine, People code and Component Interface.
Provide the UAT support for the interfaces developed.
Day to day client facing for requirement gathering and clarifications required.
Prepare the unit test cases for the modules worked on.
Implemented the bolt-on interface for Overtime Allowance using people code, Application Designer and Global payroll elements.
Provide the UAT support for Loan modules bolt-on interfaces.
Did the customization for Global payroll pay slip using SQR for reflecting earning and deduction in the required format
Worked People-soft Approval Workflow Engine for the Loan modules customized.
Developed Recruitment report using XML Publisher.
Developed the PS query for reports using more than 20 tables.
Created new Application Engine & Component Interface program for new Pay Rate increase.
Data migration of data from the legacy system to Peoplesoft.
Environment: PeopleSoft 9.1, People Tools 8.53, Integration Broker, PeopleCode, SQR, File Layout, Application Engine, Component Interface, Data Mover.
Schawk, Chicago, Illinois, USA Jan 2013 – Dec 2013
Project: PeopleSoft implementations and Production Support.
Role: Senior PeopleSoft Techno functional Consultant
Description: trusted advisors in production, premedia, print services and workflows – helping to protect brands across media channels by producing superior quality assets while improving supply chain efficiencies to improve bottom lines. Schawk is part of SGK, a division of Matthews International Corporation.
Responsibilities:
Prepare the functional design document based on the business requirement.
Handling enhancement requests including Requirements study, Analysis, Discussions, Documentation and review under HRMS modules based on severity.
Worked on the custom timesheet.
Resolve HCM incident as part of the IBM AMS support considering the severity.
Provide support for Automize file transfer tool for inbound and outbound vendor’s files.
Work on the Monthly change request specific to People soft HRMS.
Attend the Business Partner call and provide the status update on HRMS front.
Participate in the requirement gathering and functional specification calls for interface enhancement and implementation.
Worked on incident based on People code, SQR, Application and Integration broker.
Covered functional modules Time and Labor, Payroll, Employee (ESS) & Manager Self Service (MSS) and Core HR.
Implementation, Configuration and unit testing for all enhancement requests from business under HCM.
Reporting and working with solution center for fixing new issues related to citrix and desktop.
Prepare the technical design document and Unit test plan and results for the monthly change request scheduled for month release.
Weekly status meeting of the effort for tickets/enhancements.
Served 8 months of Onsite Production and enhancement support at client site Chicago, US.
Used STAT for migration for all of your PeopleSoft objects.
Environment: PeopleSoft (Enterprise Resource Planning), People tool version is 8.51 and PeopleSoft HRMS Application version is 9.1.
Williams, Tulsa, Oklahoma April 2011 – Dec 2011
Project: Peoplesoft HRMS Production support and Job Monitoring.
Role: PeopleSoft HCM Techno functional .
Responsibilities:
Functional and Technical Support for PeopleSoft Applications for HRMS modules of Payroll, Compensation, Benefits, Time & Labour and all other integrated modules.
Baseline and document the business processes used by the client.
Understand day-to-day technical problems in PeopleSoft HRMS which are faced and logged by the users for resolutions.
Handling enhancement requests including Requirements study, Analysis, Discussions, Documentation and review under HRMS modules based on severity.
Implementation, Configuration and unit testing for all enhancement requests from business under HCM.
Resolving day-to-day bugs and fixes and enhancement based on priority.
Reporting and working with solution center for fixing new issues related to citrix and desktop.
Preparation of Test Plans and Test scripts for testing of all enhancements and Bug Fixes and co-ordination of User testing.
Preparation of Functional Specification and AID Documents which outline the interfaces specifications and functionalities.
Weekly status meeting of the effort for tickets/enhancements.
Served 6 months of Onsite implementation and support at client site Tulsa, Oklahoma.
Used Process Scheduler to schedule various SQR’s programs.
Environment: PeopleSoft HCM 8.9, People Tools 8.48
Client: American Express November 2010 – March 2011
Project: PeopleSoft (Enterprise Resource Planning), People tool version is 8.51 and PeopleSoft HRMS Application version is 9.1
Role: PeopleSoft Techno functional
Responsibilities:
Coordinate and communicate tasks to Team members.
Ensure that development is performed as per requirements
Work as per the test plan to create test scripts and scenarios for enhancements and customizations.
Communicate activities/progress to project managers, onsite coordinators.
Documentation of the technical understanding document.
Involved in the unit testing of the interface development.
Worked on the various interfaces based on the Application Engine, SQR.
Worked on the File Layout and the component interface for the inbound interfaces
Preparation of Test Plans and Test scripts for testing of all enhancements and Bug Fixes and co-ordination of User testing.
Resolving day-to-day bugs and fixes based on priority.
Configuring the systems for HR, Benefits and Payroll, Administering Data Permission Security, Building and executing test scripts, supporting users in live environment and building the documentation for maintaining and executing variousbusiness process activities per client requirements.
Environment: People tool version 8.49 and PeopleSoft HRMS Application version is 9.1
Orange, Bangalore Jan 2010 – Oct 2010
Project: PeopleSoft 8.9 Development and Support project
Role: PeopleSoft Developer
Responsibilities:
Perform plan, design and code reviews.
Coordination with team members.
Identify the issues in the application and resolving the issues.
Involved with complete task life cycle starting from gathering requirements,analysis, design, development, unit testing, and support for user testing.
Adherence to coding standards and review guidelines during coding and testing.
Technical design for the functional description according to the client requirement.
Handle enhancement request based on different modules of HCM.
Directly interacted with client and HRMS users for requirements gathering,proposing solutions, and enhancement activities.
Modified existing Reports using SQR and Crystal.
Helped end-users in User Acceptance Testing.
Constantly communicating with HRMS users for requirements gathering,enhancements, customizations and UAT support activities.
Coordinated with Client teams for approval & migrations - Conversion Releasenotes, STAT CSRs, Change Requests (CHGs), Requests (REQs), Incidents (INCs),Security etc.
Environment: People tool version 8.45 and PeopleSoft HRMS Application version 8.8.
ATT, Bangalore Dec 2008– Dec 2009
Project: ATT Evergreen.
Role: Senior PeopleSoft Developer
Responsibilities:
Involve in the KT program from the beginning of the project.
Develop and modify the program code, testing and provide documentation for the PeopleSoft System.
Make test material/plan to validate development and modification of code.
Document all changes and enhancements.
Review test results.
Carry out the unit testing according to the test standards and procedures.
Examine application issues, problems, improvements and provide resolution.
Prepare daily status report.
Extensively worked on enhancements for PeopleSoft Benefits Modules.
Created/Modified FDDs, TDDs and Test Scripts for the new requirements/changes.
Extensively worked on enhancements for Performance Management Module.
Find out problems with programs or applications and determine the correct action to solve problem.
Analyze the Application Engine program and the People code and modifying it as per the requirement.
Involve in various PeopleSoft Technical Trainings.
Developed multiple third party interfaces (both inbound and outbound) from scratch.
Environment: People tool version 8.48/8.49 and PeopleSoft HRMS Application version 8.8
Macquarie Australia, Bangalore April 2007– Nov 2008
Project: Project Quoin, PeopleSoft 8.8 Production Support Project on HCM modules.
Role: PeopleSoft Developer
Responsibilities:
Handle change request tickets based PeopleSoft HRMS modules
Prepare the test cases, test plans, KS documents for HRMS modules
Log the defects and get clarifications from Development team and End users directly.
Communicate with the end users for any change request clarification or updates.
Handling enhancement requests including Requirements study, Analysis, Discussions, Documentation and review under HRMS modules based on severity.
Work on PS query, pay group setups and the department setups.
Work on the PeopleSoft security setups as well as on one of the client tool that requires the analysis of an SQR.
Work on the Interfaces based on SQR and Application Engine.
Responsible for PeopleSoft HRMS enhancements, maintenance and support for the project.
Worked extensively on PeopleTools and PeopleCode to provide the required support and resolve numerous tickets.
Environment: People tool version 8.48 and PeopleSoft HRMS Application version 8.8.
Certifications:
PeopleSoft Application Developer I: People Tools & PeopleCode 1Z0-241
PeopleSoft Application Developer II: Application Engine & Integration 1Z0-242
PeopleSoft Enterprise 9 Human Capital Management, Human Resources Consultant Certified Expert
Oracle Global Human Resources Cloud 2016 Implementation Essentials – 1Z0 329
Education:
Bachelor’s in Electronics and Communications, UP Technical University, India,
Master’s of Business Administration, IMT, India
Contact this candidate