Data Engineer

SAMBIT PANIGRAHI

ORACLE HCM CLOUD SENIOR CONSULTANT

PROFILE

Sambit is a HR transformation Senior Consultant with over 9 years of experience in Oracle HCM Cloud and Peoplesoft. He is experienced in requirement gathering, design & development, implementation, upgrade, extensive analysis, Customizations, Maintenance and Production Support.

Demonstrated ability to leverage strategic planning to foster new improvements that maximize productivity and efficiency.

He has strong analytical, problem solving and debugging skills.

He holds a valid Stamped H1B Visa.

SKILLS AND KNOWLEDGE

Technical & Analytical Skills

Working as an Offshore Lead in Deloitte Consulting.

Understanding legacy HR system (i.e. Peoplesoft, EBS, SAP) and transform HR Process and data into Oracle Cloud and has been involved in full life cycle of 6+ implementation projects

Involved in requirement analysis, solution design and mapping, fit-gap analysis

Functional knowledge in Oracle HCM Cloud Core HR, Payroll, Talent, Absence and Compensation modules

Collaborated with Client and functional Product Owners to understand the business requirement and translate it into meaningful technical requirement in Oracle HCM Cloud

Handled major project milestones like SIT, UAT, Sign Off, Deployment Planning and Go Live

Prepared Data Conversion and Integration strategy, technical design documents, Production Cutover plan and user guides

TOOLS USED

HCM Extract

HCM Data Loader (HDL) & Payroll Batch Loader (PBL)

Reporting using BI Publisher & OTBI

Fast formula

SQL, PL/SQL, XML

Microsoft Excel, Word, PowerPoint

WORK EXPERIENCE

Deloitte

Nov 2020 - Present Senior Consultant

Waste Management

Working as Offshore Tech lead in the project and Product owner for Integration and Reporting object

Completed the Phase Zero analysis and design session with the client for the Integration object & finalized the scope

Working with the client to finalize the environment strategy, project & sprint plan for technical objects

Created strategies for Integration of Oracle HCM Cloud with existing Data warehouse of client (i.e. Informatica & Matillion)

April 2018 – Oct 2020 Senior Consultant

Liberty Mutual Insurance

Started as HCM Conversion lead with the data loads using Conversion tool by generating the HDL and PBL files for Work Structure, Core HR, Talent and Payroll modules

Transitioned to the client's offshore HCM technical lead from Sept 2018 and set up strategy for integration and reports

Learnt the nuances of the agile methodology in due course of the engagement and got involved in building and maintaining product backlog via PI planning and coordinating with other product owners

Created strategies & implemented HR Integration Hub/Data Mart architecture to reduce point to point integrations from HCM cloud

Developed Outbound Integrations using HCM Extract, BIP, HDL to send/receive Data to/from Legacy systems and third-party vendors Planned and managed a team of 10 members to develop more than 90 integrations and 50 reports

Travelled to Client Offices in India & Malaysia for requirement gathering and conducted design sessions

Developed complex HR & Payroll Integration using HCM Extract and BI Publisher

Prepared test case, technical design documents, cut over/Deployment planning document

Provided necessary post-production support to the client and involved in defect fixes for the technical objects

Configured HR and Demographic objects, look ups, DFF, UDT, Value Sets, Fast Formula as part of the HR and Payroll implementation

May 2016 – April 2018 Consultant

Prudential Financial

Led the HCM Data Conversion track with a team of 2 resources for converting data using HDL

Prepared the conversion strategy plan and presented to the business

Presented the conversion mapping templates with the business

Completed the data loads using Conversion tool by generating the HDL files for Work Structure, Core HR and Compensation module for multiple cycles

Supported on core HR Configurations and used REST API to update Users details and assignment records in HCM

Worked on the route cause and error Analysis and reconciliation of the converted data and shared the reports with the business

Created the post conversion validation BI Publisher and OTBI reports for HR module

March 2015 – April 2016 Consultant

Wells Fargo

Pre-validated the csv conversion files for mandatory fields and other data type issues to minimize cloud load errors as a preventive action.

Completed the HCM data loads using Conversion tool by generating the FBL files for Work Structure, Core HR module

Worked on the error Analysis and reconciliation of the converted data and shared the reports with the business

Created the post conversion validation BI Publisher and OTBI reports for HR module

Developed Compensation reports as part of the project

Worked directly with the client to gather reporting requirement

Prepared test case, technical design documents

Supported on core HR Configurations and provided support to the client during the testing cycle

Provided necessary postproduction support to the client after successful implementation of the project

April 2014 – March 2015 Business Analyst

United Airlines (Peoplesoft)

Designed and developed essential HR and payroll conversion Programs designed to convert and load the data from legacy system to United Peoplesoft payroll system in order to facilitate payroll consolidation between the two entities

Designed and retrofitted new payroll interfaces for Payroll Consolidation

Developed various custom Application engine programs for bonus enhancements on Wage Progression

Created custom View only and run control pages

Developed payroll reports for the client using XML publishers

Created technical specifications documents and developed test scripts and key contributor in SIT cycle for defect fix

Provided post production hyper care support after the project go-live

Wipro Technologies

Jan 2013 – Mar 2014 Project Engineer

Hitachi Automotive System (Peoplesoft)

Developed various custom application engine programs for building custom employee effort tracking system

Implemented application package program for newly created ESS page data validation, calculation and processing

Created audit report to capture employee data changes

Developed custom HR, Absence and Payroll reports using SQR and XML publishers

Customized existing record, page, peoplecode & component to support client’s change request

Created new arrays, formulas to implement the Absence management data processing logic

Got functional exposure to Core HR, absence and security modules in Peoplesoft while supporting the project for the client

Nov 2011 – Dec 2012 Project Engineer

Michelin Manufacturing Company (Peoplesoft)

Developed Taleo outbound application engine interface to share PeopleSoft master data with Taleo

Customized SQR for printing Advice and check to include logo

Configured new basic HR structures data like company, pay group, location, establishment id, department and cost center as part of ongoing production support

Created a new page to allow user to update data in custom record

Used trace options to capture the errors and debug them

Developed technical specifications for new enhancements and provided knowledge transformation to the client once new enhancement is migrated to production

Got exposure to Core HR, Security, Payroll modules of Peoplesoft while supporting the project for the client

Employment History

Deloitte Consulting India Pvt Limited-

April 2014 - Present

Wipro Technologies, India-

Nov 2011 – March 2014

ACHIEVEMENTS

Recognized with Applause Award for outstanding contribution to client from Deloitte Consulting

Recognized with Innovation Award'2016 for building Set up Extractor Tool from Deloitte Consulting, India

Recognized with Best Rookie Award'2012 in Peoplesoft practice from Wipro Technologies, India

Contact this candidate