SUMMARY

• 12 + years of experience as an Oracle EBS HRMS Consultant, who has been working in Oracle cloud HCM for last 4 + years, which includes migration from legacy HRMS to Oracle cloud HCM, explore, design, development of HCM reporting and integration solutions using OTIB/BIP, HCM extracts, HDL, PBL and HCM cloud web services
• 12+ years of professional experience in Oracle HCM and EBS with modules such as havey HCM (Core HR, Payroll, OAB, Time Entry, Absence Management, Onboarding, Talent management) and Oracle Taleo
• Designed and development of HCM integrations including HCM integrations with Kronos, Taleo, UHG, Cigna and 401k Financials institutions, which includes gather technical requirements, write HCM extracts/ BIP extracts, fast formulas, value sets and real time data integration’s using web services
• Worked as an Oracle cloud security analyst for multiple Oracle cloud HCM implementations and work closely with HR managers, payroll admins and created custom roles as per use access requirements
• Extensively worked on cloud security reporting, which includes reviewing existing roles, users, create and generate audit reports using OTBI subject areas and customize by creating a custom job role and assign to seeded duty role
• Customizing Security for Custom Business Objects including creation of new security polices
• Worked with business steak holders (HR Manager, Line Mangers, Payroll Admins, AP/AR Leads), document user polices and security options, created brand new roles (duty, job and abstract roles) using security Console by copied the seeded Oracle roles
• Create custom security roles for contingent work force as per payroll/OAB access levels
• Proven hands on experience in design and development of Oracle Cloud security options, reports and integration solutions across HCM modules
• Extensively used SQL/PLSQL, Oracle forms, reports, fast formulas as part of EBS HRMS integration’s and reports
• Designed and development of fast formulas both in EBS and HCM and extensively worked on supporting Payroll users
• Created payroll security profiles to be used in the newly defined data roles.
• Identified the gap in AOR based security data roles and changed the configuration per client's needs.
• Loading Payroll Data Using transformation formula including payroll element entries
• Review and audit end user accounts, permissions, and access rights. Align segregation of duties and security profiles
• Working experience on Oracle Cloud Security GRC (Governance, Risk and Compliance) and customized security roles and polices as per SOX Compliance polices.
• Design and development of Oracle Cloud ERP integrations across HCM and Financials modules
• Well Versed with HCM, Payroll, OAB and security around it with even enabling location - based security options
• Customized oracle cloud security, which includes creation of new roles across Financials, HCM (Payroll/Absence) management
• Experience in Interfaces using HCM Extracts and its Delivery Options includes some below-
• Part of Complex 401K Payroll interface with Financials Organizations.
• Created Kronos extract interface to pick data from Fusion HCM and send to Kronos.
• Built Extract interface between Fusion & Concur (Travel expense vendor).
• Unemployment Claims Interface with ADP
• Extract Interface between Fusion HR and EBS Finance.
• Exporting all work structures, employees, contingent workers and users from Global HR to Taleo Recruiting.
• Import candidates (ready to hire) from Taleo to Fusion Cloud HCM using the Import Oracle Taleo Recruiting Cloud Service Data process.
• Experience in Creating BIP/OTBI Reports and Analytic using Fusion HCM BI
• Prepared 401k Census report which helped organizations to pass 401k Non-discrimination test.
• Built benefits, EOI & eligibility BI reports for benefits vendors.
• Built Data models/BI Reports related to Payroll modules.
• Proficient in preparing E-Text template &RTF file formats for Payroll, Benefits, and Core-HR &Compensation modules.
• Prepared Taleo BI reports & agents for daily & weekly reports.
• Prepared several OTBI reports including customized reports for most HCM modules.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12/11i and Oracle Cloud HCM/Financials Security

Oracle ERP Tech Stack: OTBI, BIP, PLSQL, HCM Extracts, Fast Formulas, Payroll transmission HDL

Languages / Tools: Java, Java Spring MVC, Java Script, .Net, SQL, PL/SQL, SQL*Plus 9.0, SQL*Loader, C, C++, Toad

GUI Tools: Oracle Apex, Reports 6i/9i/10g/11g, Forms 6i/9i/10g/11g, XML/BI Publisher, Workflow Builder, Discoverer 4i/9i/10g

Fusion Middleware: JDeveloper and WebLogic server 10.3.2

XML/Web services: XML, XSD, XSLT, SOAP and XSL

Performance Tuning: SQL, PLSQL, Forms, Reports, concurrent programs, workflows and OAF pages

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Oracle Cloud HCM Techno Functional Consultant

Responsibilities:

• Extensively worked on design and development of HCM integration’s and reports using OTBI/BIP including BIP reports templates, HCM Extracts and BIP extracts
• Explored different subject areas, worked with Oracle support to add new columns to the OTBI subject areas, designed new BIP data models as needed and developed reports and configured security across OTBI/BIP
• Worked on design and development time card integration’s loading payroll element entries using Payroll transformation formulas, which includes creation of fast formulas, values setups and customizing data file in UCM
• Explored HCM web services and implemented HCM web services with internal legacy third party applications
• Played different roles (Oracle Cloud Security admin, report writer and integration developer) and extensively worked on customizing Oracle cloud security and design and development of integration with third party Identity management (IM)
• Reviewed roles, access across reports, custom objects and customized as per the line manger requirements
• Worked on security privileges for custom data roles, and created AOR based roles for different HR groups
• Good understanding of role inheritance and creation of custom job roles with additional duty roles.
• Created payroll security profiles to be used in the newly defined data roles.
• Defined user group in OTBI administration to restrict the security/access of dashboard to only specific users.
• Developed reports to get the job roles and the users assigned, per client’s requirements.
• Worked on production issues of roles, and compared duty roles to add privileges for HR specialists per need
• Worked with third party Identity management team and build access level by developing REST enable report of Oracle HCM roles
• Build a custom integration for contingent temp workers with IM access level

Confidential, Kansas City, MO

Oracle Cloud HCM Consultant

Responsibilities:

• Worked with Payroll and Benefits admins and developed reports as per the user requirements using OTBI/BIP and HCM dashboards
• Work with Oracle support as needed and customized user security as per GRC, SOX and Financials regulations
• Created user profile and assign to the duty roles to secure by role and location
• Enabled and configured Oracle cloud security as per GRC rules and created audit rules and events
• Worked on with Oracle SR on performance issues across Oracle provided reports (OTBI/BIP)
• Design and built security for the PDFs generated out of BI Publisher by implementing tamper proof signature on document
• Worked with Payroll/HR/Financials managers and document user roles, security and access levels and work with Oracle configure new roles including copy existing Oracle provided role and modify it and creation brand new roles (create duty, job, or abstract roles)
• Understand existing legacy ERP roles including reporting and read only roles and define the similar roles in the Oracle cloud
• Understand and coordinated with Oracle support on Payroll security profiles, payroll objects and customizing security profiles with seed jobs and assign to users
• Worked with security manager and gathered information on audit reports and build one using BIP reports and published Oracle provided OTBI report
• Worked on development of reports using BIP, OTBI and HCM Extracts
• Worked on building HCM Extracts, fast formulas and BIP reports as part of inbound and outbound interfaces
• Worked on building AP check printing template using BIP and build for each operating unit
• Responsible for month end closing of GL and Sub Ledgers
• Worked with various banks and build integrations to load bank statements

Confidential, Kansas City. MO

Oracle HCM Consultant

Responsibilities:

• Responsible for data conversions from EBS to Oracle cloud HCM using HDL/ PBL loaders, worked with Oracle Support and successfully converted person, assignment’s, payroll balances, security options, lookups and designed and development of reports using OTBI/BIP
• Worked on design and development of fast formulas across Payroll and Benefits
• Worked on design and development of reports using OTBI/BIP including reviewing Oracle provided reports with users and customize, build new reports including new data models and adding new columns to OTBI subject areas, publishing OTBI reports using dashboard reporting
• Review existing user security, profile options and customize Oracle cloud security as per the custom requirements
• Build interfaces using web services for AP/AR and GL interfaces
• Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walk through.

Confidential, Indianapolis, IN

Oracle HCM Techno Functional Consultant

Responsibilities:

• Worked with implementation partners business stakeholders and prepared business requirement documents, data conversion planning, testing of data conversions from EBS HRMS, Payroll, OTL, OAB to HCM Core HR, Payroll, OTL using HDL, FDL, PBL and HCM Extracts for outbound interfaces
• Worked with users and prepared a plan to migration EBS HRMS reports and Oracle HCM, which includes development of similar reports in the HCM cloud using OTBI/BIP
• Worked on development of fusion cloud integrations between homegrown legacy applications and cloud Fusion financials using FBDI, Web Services and OTBI/XML reporting
• Involved in configuration of setups as part of pre-conversion setup dependencies, chart of accounts, ledger specific reporting including BIP/OTBI, end user training to build reports and user prisonization using sand box

Confidential, Miami, FL

Oracle Cloud Fusion HCM Techno Functional Consultant

Responsibilities:

• Worked on configuration of setups for new operating units added to the cloud Financials and HCM HR originations and related security including creation of custom roles, functional security polices, data security polices and role hierarchy
• The project involved in day to day production support of Fusion HCM Payroll, Absence Management, Talent Management, development of OTBI/BIP reports, HCM Extracts, integrations with HCM loaders and web services
• Primary point of contact for Financials users and supported day to day operations including period closing, post period closing reconciliation, adding new companies to the existing GL COA and configurations of related setups including LE’s, intercompany setups and bank accounts
• Extensively Involved in production support of Financials including both technical and functional and provided solutions for various transactional issues including create accounting, invoice validation performance issues, Vertex tax issues, Invoice holds, SLA changes, workflow notification issues and period closing of sub ledgers and GL
• Part of R12 implementation team and developed data conversions across P2P/O2C and Project accounting modules, migrated custom forms, reports to R12 from 11i, developed various brand-new XML reports and templates which includes PO PDF printing, AP check templates, remittance advice, positive and various P2P reports including PO receipt accrual process, receipt reconciliation
• Part of production support team and supported users across various ledgers and operating units which includes day to day interface issues, API break fixes, performance issues across forms, reports, workflows and custom APIS
• Extensively worked on AR support and enhancement project and developed AR auto invoice interface, customization of dunning letters printing XML templates, auto lockbox interface program and various XML reports
• Extensively involved in implementation of Oracle iExpenses and developed various extensions including AMEX interface, audit reports, AME setup for expense report approval workflow, configuration of project expense report template, OAF extensions and various XML reports for auditors
• Configured new companies and related setups such as bank accounts, SLA, AGIS, legal entity setups as part of adding new companies to the existing chart of accounts BSV values

Confidential, Denver, CO

Oracle EBS HRMS Techno Functional Consultant

Responsibilities:

• Day to day support of across HRMS, Payroll, OTL, Absence Management and OAB and supported users interface, performance issues and development of new RICE objects
• Worked on development of data conversions across HRMS, Payroll, OTL, Absence Management and OAB
• Involved in month end closing support and coordinated with Oracle SR for data fixed for un-accounted and partially accounted invoice transactions
• Build a custom Project expenditure interfaces to load labor cost from third party applications
• Responsible for day to day interfaces, data loading from suppliers and other internal applications

Confidential, Dallas, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked with Kronos team and developed inbound interfaces using HRMS api’s and PLSQL extracts for outbound interfaces between Kronos and HRMS
• Created setups for core hr, Self Service and personalization's in test instance as well as in production.
• Providing help desk support & preparing manual.
• Participated in the analysis, design and testing.
• Developed and implemented test plans and scripts
• Defined Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Lookup types and defining Value sets.
• Setup all organizations, locations, Security Profiles, Setup HR related Descriptive Flex Fields, Key Flex Fields, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Managed data conversion development team and successfully completed master data (Suppliers/Customers) and transactional (Orders, Shipping lines, OPM Interfaces, AP/AR Invoices/Journals) data conversions as part of acquisitions
• Developed Inventory interfaces for item import as part of integrations with acquired companies
• Build and customized various XML/BI/RDF reports across SCM modules as needed by users

Confidential, Denver, CO

Oracle Applications HRMS Techno Functional Consultant

Responsibilities:

• Developed around 15 custom Oracle forms as part of building new custom modules and integration of Oracle EBS modules
• Extensively worked on building SOA web services using Oracle SOA suite, XML/XSLT and PLSQL as part of portal integration with Oracle EBS and other java applications developed using Java
• Involved in requirement gathering for Financials, HRMS conversions including Suppliers, Customer, employee, assignments, grade, HR organizations, Payroll incofmraiton and other employee additional fields
• Developed a custom form in HRMS for contract workers to enter time card on weekly basis and interface to oracle Payroll
• Developed an interface between ADP and Confidential HRMS systems which load files back and forth on bi- weekly basis
• Involved in end to end implementation of HRMS/Payroll and developed various RICE objects including functional configurations such as setting up of security profiles, DFF, EIT and SIT’s, elements and fast formulas.

Confidential

Oracle EBS HRM Consultant

Responsibilities:

• Coordination with onsite consultant and gathering detailed technical requirements about the development objects includes Oracle forms, reports, workflows, Alerts and interfaces across Core HR, Payroll, OTL and OAB
• Following up on production tickets and performed root cause analysis, documentation, user testing, approvals and migration to production
• Developed fast formulas for Payroll accruals and bonus calculations
• Involved in implementation of HRMS and related data conversions from legacy applications
• Coordination with onsite DBA’s as part of development and production support projects
• On call support