SUMMARY

• Oracle Applications/Fusion Cloud Technical consultant with 16+ years of experience in Reports, Interfaces, Conversions, Extensions and Techno Functional Analysis
• Worked as Oracle Fusion HCM Cloud (Human Capital Management) and Oracle EBS HRMS R12 (E - Business Services) consultant.
• Experience in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Management (Absence Management, OTL) and Fusion Security.
• Hands on experience on customizing the security, by creating data roles, security profiles and effectively using job roles and duty roles.
• Experience in creating Table type value sets for fast formulas.
• Experience in HCM Extracts, HSDL, HDL and mass data updates/uploads.
• Knowledge on configuring Transaction Approvals, also customize the approval flow based on Locations, Employee Job, New Person creation and many more.
• Knowledge on various types of fast formulas including Payroll Calculations, Accrual Plans, Validation of Element Inputs or User Tables, Absence Duration, Extract Rule
• Conducted CRP for requirement gathering application demo and gap analysis.
• Experience in creating and publishing sandboxes for page personalization
• Built Complex inbound and outbound interfaces for HR and Payroll.
• Experience in working on Calculation cards for involuntary deductions.
• Strong Knowledge in end-to-end payroll cycle starting from payroll pre-processing to costing and transfer to GL.
• Helped with payroll processing and post payroll activities such as costing, transfer to GL and data analysis using oracle provided seeded reports.
• Pro skills and handled projects with a combination of technologies - Oracle PLSQL, AME, Reports, Oracle workflow, Oracle transactional Business Intelligence (OTBI) and BI reporting.
• Total of 17+ yrs. experience in managing major enhancements deliveries. During this phase handled a team of 25+ members covering all phases of the SDLC cycle.
• Experience in Oracle EBS R12 HR modules like HR, Payroll, OTL & Oracle Advance Benefits,.
• Proficient in business process study (As Is & To Be), gap analysis, cost benefit analysis, business process modelling, process flow & interface design to suit business requirements
• Adept in pre-project studies, project effort estimations, and customer demos.
• Skilled in managing and negotiating with stakeholders having diverse cultural environments with the accountability of informing them on current and future scenarios, by acquiring feedback on critical issues and taking suitable actions to ensure positive experience and increase in user adoption.
• Expertise in building teams and developing skillsets across technologies, domains and functions in accordance to the business development strategy and sales pipeline / forecast.
• Strong experience of leading & implementing all phases of Software Development Life Cycle using waterfall / agile/devops methodologies.
• Proficient at HRMS User Hooks, fast formula, Conversions, Interfaces, Data migration API and Alerts.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Focused & committed team player having an Entrepreneurial bend of mind, with an interest in innovative ideas which can turn into excellent projects.
• Appreciated for cordial relationship maintained with customers and ensuring customer satisfaction without comprising on the any quality parameters.
• Expertise in Interface and Conversions and ERP-BI Integration
• Expert Trainer on various Oracle related Technologies including Performance Tuning, Advance PL\SQL and Interfaces & Conversions

TECHNICAL SKILLS

Technologies: Oracle Fusion HCM Cloud: Global HR, Payroll, Absence Management, Time and Labour, OTBI Reports, Fast Formulae Oracle EBS R12, 11i: HRMS, Payroll, OTL, GL & AR, Fast Formulae

Tools: BI Publisher, Reports 10g, TOAD, Workflow Builder, HCM Desktop Integrator, SQL Developer, MS Excel, Oracle Discoverer

Languages: SQL, PL/SQL

Database: Oracle 12c/11g, MS Access

PROFESSIONAL EXPERIENCE

Oracle Fusion Cloud HCM Technical Consultant

Confidential

Responsibilities:

• Identify business requirements and align them to Oracle Cloud/Fusion HCM functionality
• Data migration using HDL - HCM Data Loaders.
• Tested Core HR, Interfaces and Reports for Release upgrade.
• Worked on Core HR, Time & Labor and Payroll modules.
• Written transformation formula to load the Element Entries using HSDL.
• Developed HCM Extracts, Fast Formulas, Descriptive Flexfields, HDL to extract/imports the data from Oracle Cloud systems
• Developed BI publisher (BIP) reports in Core HR and Payroll area and developed HCM extracts.
• Experience in creating Table type value sets for fast formulae.
• Built Complex inbound and outbound interfaces like BIP reports/OTBI for HR, Payroll, T&L modules.
• Written Accrual fast formulas to support the vacation and sick absence plans.
• Configured HR and Payroll modules.
• Coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Fusion with Workforce Deployment (Global HR).
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.

Environment: Oracle Cloud HCM (Core HR, Payroll, OTBI, BI Publisher, Fast Formula).

Oracle Fusion Cloud HCM Technical Consultant

Confidential

Responsibilities:

• Data migration using HDL - HCM data loaders.
• Developed OTBI/BIP Reports, HCM Extract, Fast Formula, Descriptive Flexfields for Global HR, Payroll Interfaces
• Tested Core HR, Interfaces and Reports for Release upgrade.
• Designed custom reporting and interfaces to meet client and audit requirements
• Extensively used BIP/OTBI Reports & HSDL for Create, update, and delete data for supported objects
• Built complex layouts using e-text and rtf templates.
• Wrote custom PL/SQL code for data conversions for work structures, person, assignment and payroll information from legacy EBS to Oracle HCM Cloud.
• Ensured that the application meets the business requirements and system goals fulfil end user requirements, and to identify and resolve system issues

Environment: Oracle Cloud HCM (Core HR, Payroll, OTBI, BI Publisher, Fast Formula)

Confidential

Responsibilities:

• Onsite Technical Architect for 5 years and Lead from Offshore for prior 2 years responsible for Requirements Analysis, Design Conceptualization and Quality Audit of offshore CEMLI deliverables.
• Travelled to the client site to gather the project requirements and to initiate the offshore onsite model.
• Developed interfaces to sync data into Oracle from third party systems.
• Performed troubleshooting of bugs raised by the client.
• Developed BIP reports, OTL Benefits and Payroll fast formulas.
• Requirement gathering and Solution designing for HR and Payroll/Costing Modules
• Requirement gathering and Solution designing and implementation for OTL assumed time process covering time for 30000 employees conversing multiple departments and Unions.
• Performance Improvement and process improvement of the application and project.
• Managed Hosted Environments and Actively Participated in Production Sizing and other Infrastructure related requirements.
• Managed & Designed the Versioning System and Versioning Process for the project.
• Designed Functional Requirement documentation for Conversion and Interfaces.

Environment: Oracle eBusiness Suite 12.2.4 (12.2.9) (Core HR, Payroll OTL and Advanced Benefits modules), Oracle PeopleSoft (Pension), Oracle Business Intelligence.

Confidential

Responsibilities:

• Onsite Developer for developing a custom solution for vendor commissions for Confidential ’s vendors.
• Designed and Developer Vehicle Management custom solution for Confidential Employees.
• Developed BI Publisher reports in Receivables, Payables and Other Supply Chain modules.
• Performed troubleshooting of bugs raised by the client.
• Developed BIP reports and Interfaces.
• Designed Functional Requirement documentation.

Environment: Oracle eBusiness Suite 12.1.3 (Finance and SCM)

Confidential

Responsibilities:

• Lead from Offshore responsible for Requirements Analysis, Design Conceptualization and Quality Audit of offshore report deliverables.
• Developed interfaces to sync data into Oracle from third party systems.
• Performed troubleshooting of bugs raised by the client.
• Developed Discoverer reports, OTL and Payroll fast formulas.

Environment: Oracle eBusiness Suite 12.1.3 (OTL, Payroll, Financials and Purchasing modules)

Confidential

Responsibilities:

• Lead from Offshore responsible for Requirements Analysis, Design Conceptualization and Quality Audit of offshore report deliverables.
• Developed conversions to load data into Oracle from third party systems reducing human effort.
• Performed troubleshooting of bugs raised by the client.

Environment: Oracle eBusiness Suite 12.1.3 (Project Accounting, Financials, Inventory and Purchasing modules)

Confidential

Responsibilities:

• Developed a more than 30 XML Publisher reports
• Developed Oracle BI Publisher Enterprise Edition reports
• Developed and Tested Custom Conversions.
• Worked in developing outbound interfaces
• Designed the technical and testing specifications
• Developed re-usable code for the entire project team

Environment: & Tools: Oracle eBusiness Suite 12.1.3, Oracle BI Publisher Enterprise Edition, XML Publisher, PL/SQL

Confidential

Responsibilities:

• Developed more than 20 Discoverer reports
• Developed and Tested Conversions and Interface
• Performance Tuning of Discoverer Reports
• Design and Development of Invoice Print Report and Email Bursting using XML Publisher
• Designed the technical and testing specifications
• Developed re-usable code for the entire project team

Environment: & Tools: Oracle eBusiness Suite 12.1.3, Oracle Discoverer, XML Publisher, PL/SQL

Confidential

Responsibilities:

• Designed and developed the HRMS Migrations
• Co-ordination with onsite functional team and monitoring the project execution
• Developed SCM migrations and tested them
• Post Go-live support for HRMS Migrations

Environment: & Tools: Oracle eBusiness Suite 12.1.1, PL/SQL

Confidential

Responsibilities:

• Data Conversions in HRMS, Project Accounting and cMRO modules
• Point of Contact for the Global Site team
• Technical Lead for interfaces, Designed and Tested interfaces
• Status monitoring and Weekly calls
• Workflow customization
• Post Go-live support

Environment: & Tools: Oracle eBusiness Suite 12.1.1, PL/SQL, Workflow

Confidential

Responsibilities:

• Developed Electronic Funds Transfer extract using the eText extract functionality of Oracle eBusiness R12.1.1
• Developed and Tested SCM & OPM Quality interfaces
• Tested custom OPM forms
• Developed Bank Statement loader and interface mapping

Environment: & Tools: Oracle eBusiness Suite 12.1.1, PL/SQL, XML Publisher

Confidential

Responsibilities:

• Onsite techno-functional consultant.
• Gathered user requirements for CRM data migrations for Leads, Opportunities and Service Requests.
• Designed and Developed License and Registration
• Conducted Fit/Gap session with the user group for the requirement gathering for different custom data conversions
• Created Function and Testing Documents for the CRM data migrations.

Environment: & Tools: Oracle eBusiness Suite 11.5.10, PL/SQL

Confidential

Responsibilities:

• Worked as a technical consultant to provide interfaces to the SOA based portal
• Created customer registration and Contract Creation interfaces to register customer and connection data in Oracle eBusiness Suite
• Designed and developed several custom views to be used in the portal solution
• Tested the interfaces using BPEL Interfaces
• Supported the system post go-live

Environment: & Tools: Oracle eBusiness Suite 11.5.10, PL/SQL