PROFESSIONAL SUMMARY

• Oracle Apps Techno Functional Consultant with 13 + years of proven hands - on experience in design, development and customization of Oracle EBS/Cloud HCM/HRMS modules. Significant customer-facing experience in delivering custom fast formulas, integrations, OIC REST web services, reports (OTBI/BIP), HCM Extracts across core HR, Payroll, and OAB and worked fortune clients including Confidential, Koch Industries and LinkedIn, Confidential, Qualcomm, Motorola Solutions and AlmacOracle Techno Functional Consultant
• Proven hands-on experience in design and development of Oracle EBS/cloud custom reports and integrations, which gather reporting requirements, prepare functional design technical design, evaluate reporting tool across OTBI, BIP, and Extracts and develop reports across core HR, Payroll and OAB
• Worked in HCM environment with more 100,000 employees and experienced with performance issues of OTBI/BIP and Payroll extracts, provided quick fixes by reviewing SQL, logs, sessions logs and values sets and SQL functions
• Written fast formulas as part of Payroll Extracts, Benefits extracts, Payroll transformation and payroll calculations, customizing existing seeded and worked on troubleshooting performance issues across OTIB, BIP and Payroll Extracts
• Part of end-to-end implementation of Oracle Cloud HCM and developed inbound data integrations suing HDL, PBL and out bound BIP and Payroll Extracts
• Explored OIC and automated inbound and outbound file transfers and file transformations and consuming REST api’s
• Sound functional knowledge of Oracle Payroll process flow, Payroll costing, core HR transactions and well versed with underlaying base tables
• Worked on customizing Oracle cloud HCM security, provisioning roles for contingent workers and FTE’s and worked with HR admins, Payroll admis and created a custom HCM roles
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management, team building and adopting new technologies. Very flexible and perform tasks are ad-hoc basis
• Experience of Development and Customization Oracle Apps Reports/Forms and BI/XML Publisher using report builder6i/10g/11g.
• Expertise in preparing Packages, Procedures, Functions, Triggers and Cursors.

TECHNICAL SKILLS

OS/Environment: Windows, Linux and UNIX.

RDBMS (Database): Oracle 9i, 10g, 11g & 12c.

Oracle E-Biz Suite (EBS): EBS HRMS, Payroll, Benefits and Talent

Oracle Cloud HCM: Cloud HCM suite (Payroll, Core HR, Benefits and Talent)

Financials: Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CM), Fixed Assets (FA), General Ledger (GL) .

Languages, Scripts & Frameworks: SQL, PL/SQL, SQL*LOADER, Data Loader, JAVA, OAF, ADF, SOA, HTML, XML, XSD, XSLT, XPath, WSDL, Oracle APEX, Shell Script, Java.

Middleware: Oracle Fusion 11g (ADF, SOA, BPEL, OSB)

Front-end Tools (GUI): Forms 6i, 9i,10g,11g. Reports 6i, 9i, 10g& 11g, Jdeveloper10g, Work Flow Builder.

Business Intelligence (BI): Oracle Discoverer 10g, XML Publisher and Bi Publisher

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, WinSCP, Putty, FTP, JIRA, Lotus Notes, HP PPM, FileZilla.

PROFESSIONAL EXPERIENCE

Confidential

Oracle HCM Techno Functional Consultant

Responsibilities:

• Worked with implementation team and users and documented Oracle HCM integrations and reporting requirements
• Explored and provided automation solutions and replaced HDL file-based interfaces using OIC and REST web services between OKTA, Kronos, Health care providers across core HR, Payroll and OAB
• Explore and evaluate reporting tool based on user reporting requirements and develop reports using OTBI/ BIP and HCM/Payroll Extracts
• Write past formulas and formula based HCM extracts and trouble shoot and fix performance issues across OIC applications, OTBI/BIP and HCM extracts
• Work with users and support to write test cases as part of UAT/SIT and production cut over planning
• Primary responsibility to work on reports including trouble shooting and fixing reports, which includes security related issues, performance issues, report output template that missing data in teh output, fixing custom BIP SQL, and building report outputs
• Worked with users in different countries and gather reporting requirements and design functional document, design technical flow and develop reports across Core HR, Payroll and Benefits
• Part of open enrollment and developed reports for benefits activity reports using BIP builder
• Worked with Absence management and employee with multi assignment and build reports using BIP and Extracts
• Developed value sets, fast formulas as part of Payroll report using Payroll Extracts/UE’s
• Used OIC to transform Payroll extracts into different formats

Confidential

Oracle HCM Techno Functional Consultant

Responsibilities:

• Worked with HR users, payroll/benefits administrator and responsible for day to HR/Payroll reports development
• Worked on building HCM integrations with various third-party applications including Oracle Taleo and health care companies
• Worked on development of OTIB/BIP reports including create of new BIP templets, adding new columns to teh reports by enabling DFF’s and bran new BIP report with new templates
• Customized user reports like earning report for employee, payroll activity report, statutory unit report
• Work closely with payroll, HR and benefits users to identify teh requirements, preparation of functional documents, preparation of QA planning, test coverage, requirement traceability matrix, test data, coordination with internal QA team and production cut over planning
• Developed HCM/Payroll integrations using OIC, REST api’s and HDL loaders
• Involve in requirement gathering, analysis, design, Implementation & support.

Confidential

Oracle HCM Techno Functional Consultant

Responsibilities:

• Work closely with payroll, HR and benefits users to identify teh requirements, preparation of functional documents, preparation of QA planning, test coverage, requirement traceability matrix, test data, coordination with internal QA team and production cut over planning
• Involve in requirement gathering, analysis, design, Implementation & support.
• Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, Payroll, Taleo, Benefits & Performance modules.
• Continue interaction with Oracle Support SR as part of resolving security and payroll issues
• Developed brand new fusion fast formulas as part of payroll deductions and linked to elements
• Proficient with Subject areas in preparing Adhoc report with OTBI for Core-HR, Payroll, & Benefits modules.
• Data Loading/Conversions using HCM Data loader (HDL)which includes teh Workforce structure data, Worker data, Work relationships data, Salary, Jobs, Locations...etc.
• Translate business and functional requirements into technical approach.
• Drive teh resolution & troubleshooting of issues during development and post production support.
• Use Oracle Fusion Functional Setup Manager (FSM) to implementation.
• Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at OIM.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Part of production support of Oracle EBS HRMS, Payroll and OAB and I am responsible for developing quick Payroll reconcile reports for Payroll users
• Developed fast formulas across Payroll and Benefits calculations
• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per teh requirements.
• Analysis of Function Design Document and preparing Technical Design Document.
• Involved in AR Setups like Auto Accounting Rules.
• Worked on CUSTOM.pll to make all forms read only which are accessed from Inquiry responsibility.
• Created Materialized View for GL Account Analysis Report.
• Development of Inbound/Outbound Interfaces using oracle API’s to extract and send teh new hire, transfers and payroll information’s between benefits providers and EBS core HR and Payroll
• Involved in preparation of test cases for RICEW components related HR requisition’s to onboarding employee
• Good Exposure on process flow of Intercompany Transactions.
• Test cases uploading using Quality Center.
• Involved in test cases Review (Audit).
• This Project includes both Support and Enhancements (Incident and Problem Management Activities).

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per teh requirements.
• Involved in AR setups such as Transaction Source, Transaction Types, Receipt Classes, Auto Accounting Rules, Receipt Sources, Payment Methods, Customer Profile, Payment Terms, Auto Invoice. Successfully created all kinds of Transactions and transferred transaction to GL.
• Preparation of migration and shell scripts.
• Developed HRMS and Payroll reports using Oracle reports builder reports, RDF, XML BI and developed custom templates usinf RTF and XML Bursting
• Testing - Unit testing & Documentation.
• Developed Cost of Sales GL report.
• Developed Generate AR Billing Detail package.
• Developed Multiselect Parameter form.
• Developed custom program to interface all custom data to AR Interface table.
• Developed Item Conversion to import item details from legacy system to Oracle System.
• Gathering business requirements.
• Developing teh RDF files with teh requirements suggested by teh user.
• Developing teh RTF template for teh XML report.
• Development of Lydall US Sales Order Acknowledgment report.

Confidential

Oracle Technical Consultant

Responsibilities:

• Responsible for Development and Customization of Reports and Interfaces between legacy system and Oracle Apps.
• Preparation of SQL Loader scripts.
• Developing of Interfaces as per client requirement.
• Defining Concurrent Programs, Executables.
• Worked on Open Notifications report.
• Developed Manual Approvals Details Report.
• Developed Matching Information Report for Purchase order.
• Developed PO conversion to upload teh Purchase Orders from Legacy system to Oracle apps system.
• Developed AP Vendor Extract Interface to extract supplier details from Oracle apps to Legacy system.