SUMMARY:

• Confidential has 13 years of experience in Oracle Applications which includes 6 years in Oracle Fusion HCM application starting from version Release1 - early adapter program and 7 Years in Oracle E-Business suite.
• He is certified Oracle Fusion HCM consultant, worked as Technical lead role in two full life cycle Oracle Fusion HCM Cloud end-to-end implementation projects and totally worked on 6 Fusion HCM Implementation projects.
• Worked in Techno-Functional and Technical Lead role in Oracle Fusion HCM Implementation and support projects, currently handling technical lead in CoreHR/Benefits/Payroll Fusion HCM cloud Implementation project.
• As a conversion lead, his primary responsibility is to collect conversion requirement, do mapping exercise and data load using HDL tool for Core-HR and Payroll module.
• Strong Implementation experience and specialized skills in oracle fusion HCM cloud on core HR, workforce compensation, Benefits and Payroll modules.
• Confidential ’s Oracle fusion HCM experience starts with version R1 in on-demand, worked on R7 in On-Premise, R9/10 in Cloud and R11 in Cloud.
• Technical expertise in data conversion tools like HDL HCM data loader, PBL Payroll Batch Loader, FBL file based loader, Spreadsheet loader & data loader and developed Integrations/reports using HCM Extracts, BIP.
• Developed complex HCM Integration with payroll system like Hewitt, ADP, PWC, Antar, Wells Forgo and Benef Confidential like Confidential, Cigna, Cobra, Davis Vision, Delta dental, Liberty Mutual, Vanguard and WOTC.
• Worked as techno functional consultant in Oracle EBS Core HR, P2P modules.
• He involved in implementation, upgrade and production support projects in Insurance, manufacturing, retail, healthcare and transportation industries.

TECHNICAL SKILLS:

Application/Technical Knowledge Areas: Fusion HCM Core HR, Benefits, US Payroll, Compensation, Talent Goal Management, Profile Management, Talent Review & Performance Management Fusion ERP - Purchasing and Accounts Payable

Oracle EBusiness Suite Applications: Core HR, P2P modules

Fusion Apps Technology: HCM Data Loader HDL, PBL Payroll Batch Loader, File Based Loader FBL, Data Loader (R1) & Spreadsheet Loader. HCM Extracts, BIP BI-Publisher, OBIA & OTBI.

Oracle EBIZ Technology: SQL/PL-SQL, Oracle Reports 6i/10g, XML publisher. Oracle Workflow, Alerts, Oracle Forms Customization/Personalization

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Tools: BIP BI Publisher, OBIEE, OTBI and HCM Extracts

Techno-Functional Consultant

Responsibilities:

• Primary responsibility to deliver payroll reporting solutions for Payroll team, Payroll-Tax calculation team, Payroll-Retro Team and Payment team.
• Responsible to build functional design and develop reports for various Payroll reporting requirement, its include Payroll tax calculation reports, Retro customization reports, online pay slip, Payment Register customization report, ADP Reconciliation Report, Garnishment reports etc.,
• Developed Payroll reports using BI-Publisher, OTBI, OBIEE, OBIA and HCM-Extracts
• Co-ordinate with offshore team, on offshore developed deliverables.
• Working in client location along with OCS, Accenture and business team, for the assigned deliverable.

Confidential

Tools: HDL HCM Data Loader, BIP BI Publisher, Fast Formulae

Technical Lead - Absence Management Implementation

Responsibilities:

• Primary responsibility to convert Absence History and Absence balances from legacy to Oracle Fusion using HDL.
• Develop Fast Formulas to implement custom solution for Absence accrual calculation.

Confidential

Tools: HDL HCM Data Loader, PBL Payroll Batch Loader, HCM Extracts, BIP BI Publisher, Fast Formulae

Responsibilities:

• Technical Lead - Core HR, Benefits and Payroll Implementation
• Primary responsibility to convert Core HR and Payroll data from Lawson IBM mainframe system to Oracle Fusion HCM Cloud. Involved in data conversion requirement gathering, mapping the Lawson core HR & payroll data with Fusion HDL/PBL format and load the data using HDL/PBL tools.
• Successfully loaded WorkStructure, Worker, contacts, Salary, Payroll relationship, TaxReporting Unit -TRU, W4 - Federal, W4- State ( Indiana, Pennsylvania), W4 - Ohio city for School district, Element Entry, Direct Deposit - External Bank Accounts and Personal payment method, EFF to load historic data.
• Responsible for design and development of Core HR, Benefits and Payroll Integrations using BI Publisher and HCM Extracts.
• Developed fast formulas for Benefit and Payroll requirement.
• Developed custom templates for check writer.
• Involved in Payroll Balance conversion and Benefits rolling balance conversion.
• Resolved issues raised by users and vendors during multiple payroll run testing and Integration testing.

Confidential

Tools: BI Publisher

Integration Developer

Responsibilities:

• Technical Lead in Phase 1 & 2 Core HR, Talent Implementation
• Business Analyst in Phase 3 Compensation Implementation
• Involved in requirement gathering workshops, design, Integration/report development, data migration activities during Core HR, Talent and Compensation phase
• Responsible for migrating Core-HR data using FBL and spreadsheet loader for location, department, job, grade, grade value details in work structure, grade rate & salary basis for base pay-setup, person, assignment, payroll relationship & salary for employment details.
• Responsible for migrating Talent data into Fusion using FBL and Spreadsheet loader for Goals, Performance rating and Profile data.
• Designed and Implemented secure SFTP file transfer model considering archive and success/failure notifications strategies between Oracle Fusion SFTP server and external/internal payroll systems to transfer output Integration files
• Developed Integration and reports using HCM Extract and BI Publisher reporting tools.
• Worked closely with the team on complex HCM Extract Integration with payroll system like Hewitt, ADP, PWC and Antar system
• Sound knowledge in workforce compensation plan with multiple complex Incentive plans and salary plan including merit and promotions.
• In Non-Prod environments, involved in configuring eligibility profiles, elements, user-defined tables, value sets & values, flexfields, global settings and compensation history
• Sound knowledge on complex Fast Formulae used in compensation and talent.
• Build BI Publisher custom report for compensation as per client requirement. Build security to restrict access to the plans.

Confidential

Tools: File Based Loader, PL-SQL & Fast Formulae

Responsibilities:

• As a Fusion Technical Lead, I involved in designing data conversion strategy for Next Gen Fusion Comp project to migrate data from GHRDW/PSFT/Career Navigator system to Oracle Fusion HCM application using FBL tool.
• Responsible for data conversion design and development on following LBO - Location, Department, Job, Position, Business Unit, Grade, Person and Element .
• Designed and configured File Based loader setups in on premise environment like FTP Adapter, BODS configuration, creating directory structure and “Manage HCM Configurations for CO-Existence”
• Responsible for FBL web service testing for all the VO’s in work structure, person and assignment.
• Responsible for Cross file configuration and generation in On-Premise environment.
• Involved in conversion functional design and data mapping activities.
• Expertise in Fast Formulas.
• Strong work experience in Workforce Compensation Plan Configurations in test pods.

Confidential

Tools: Conversion Tool -Spreadsheet Loader and Data Loader, PL-SQL & ODI, BIP Reports

Responsibilities:

• Handled offshore technical lead role in HCM-Core HR implementation phase, Involved in design and development for data conversion programs to migrate workforce structures, person and employment information using the Oracle Spread Sheet Loader (OSSL) & ODI tool.
• Designed and built complex code for employee assignment conversion and Interface using the web services and Data loader.
• In finance & SCM implementation phase, designed and developed “supplier invoice to fusion payables interface” and “BPA Price Update Interface” in P2P modules. Developed few BI publisher reports
• Coordinated the defect tracking process from development side and was the single point of contact for the QA team in HCM Phase 2.

Confidential, Dallas

Tools: SQL developer, PL-SQL and Autosys

Responsibilities:

• As a Technical lead, Involved in functional & technical design and implementation of Oracle EBS R12 to LMS Integration project
• Involved in development activities in location and employee Integration.
• Direct interaction with business user and quality team to coordinate in SIT and UAT phases.
• Involved in other production support activities like resolving the issues in AP 1099 file and AP trial balance report.

Confidential, Pittsburgh

Tools: SQL developer, PL-SQL, ISG-Integrated SOA Gateway, Workflow Builder

Responsibilities:

• As a Technical Consultant, Involved in data conversion and ISG Integration activities.
• Responsible for resolving ISG Integration defects in SIT phase
• Involved in Item Conversion activities in lower end system and resolved defects in INV/PO transaction migration.
• Developed reports in Inventory/Purchasing module to support Item Conversion validations
• Involved in monitoring and troubleshooting issues in OA-SM ISG Integration

Confidential

Tools: Kintana migration tool

Responsibilities:

• Responsible for migrating Kintana custom objects from 11i to R12, Responsible to test Kintana custom objects with all workflow cycles.

Confidential

Tools: PLSQL, Oracle Forms, Oracle Reports, BI Publisher

Responsibilities:

• As an onsite - technical consultant, Involved in production support activities in oracle financial module AP, AR, GL, and I-Expense. Resolved 630+ tickets and developed 10+ enhancements. Handled all finance interface task individually for one year. Responsible for financial period closing and SAP migration activities.
• AR Daily Report parallel run with SAP - Interface:
• Firmenich Migrated Oracle Finance Application into SAP. Sales collection team wants to run “AR Daily report” both in Oracle and SAP. This interface will transfer Oracle AR data to SAP (Inbound) and receive AR data from SAP (Outbound).
• New Paid by employee AMEX credit card Process for Singapore org:

Confidential

Tools: PLSQL, Oracle Forms, Oracle Reports, BI Publisher

Responsibilities:

• As a Technical Consultant and Involved in preparing MD70 technical documents and developed all below technical report and workflow customization.
• Report Customization in 10g- developed below listed reports in HRMS module
• Payroll Reports - Payroll Summary report, Payroll Detail Report, Airfare Accrual report, Consolidated Salary Statement
• HRMS Reports - HR-Management Finance Planning Report, Staff Status Change Report
• Designed and developed custom workflow in SSHR using AME-Approval Management.
• Job Requisition Approval Workflow, Leave Approval Workflow Customization and Expense Claim Approval Workflow Customization in Special Information Type

Confidential

Tools: PL/SQL - Data Migration, Workflow Customization

Technical consultant

Responsibilities:

• Designed and developed new custom workflow for Discrete PPC (Product price calculator) simulator using AME in oracle discrete & process manufacturing module
• Interface - Price list API for both discrete and OPM Items
• Designed and configured Approval Management Setup for workflow customization
• Migrated Item Master data in Inventory module and Project Cost Budget, Project Revenue Budget in Project accounting module.

Confidential

Tools: PLSQL, Oracle reports6i, XML Publisher reports, Data migration

Responsibilities:

• As an onsite - technical consultant, Involved in technical design and development for the data conversion activities like supplier master data, customer master data and Item master data.

Confidential

Tools: SQL, Oracle reports6i, Oracle Alerts, Oracle AIM methodologist

Responsibilities:

• As a technical consultant, Responsible for Oracle 6i reports development in SCM module.
• Configured oracle alerts in sales order transactions, Inventory transaction and Purchase Order transactions.
• Developed Item Inventory Usage Report, Expenses Distribution Report, Inventory Aging Report - INV, RFQ, PO Output for Communication and Sales Invoice Report

Confidential

Tools: SQL, PL/SQL, Oracle Reports 10g, Oracle Workflow builder, Oracle Alerts, Data Migration

Responsibilities:

• As an Onsite - Technical consultant, responsible for resolving of all technical issues raised by Oracle E-Biz users.
• Developed many enhancement components like Rearranging Requisition Approval Hierarchy - Workflow Customization, Custom ABC Analysis Report for Physical Inventory Stock, Custom Purchased Order Approved Alert
• Involved in production support activities for Finance and SCM modules

Confidential, Seattle

Tools: SQL, PL/SQL, Oracle forms6i, Oracle Report6i.

Responsibilities:

• Resolving technical tickets raised by user and closing them which includes month end closing, Interface issues in legacy system.