SUMMARY

• Overall 9+ years of experience as an Oracle HRMS/HCM consultant and proven hands on experience design and development of Oracle cloud HCM reports, fast formulas, interfaces, front end UI changes and configuration and customization of HCM security
• Worked as a HCM solution architect and collaborating with various stakeholders to determine HCM customization and integration process requirements
• Worked as liaison between business and system integrators and customized and implemented various custom objects across Oracle HCM modules
• Creating high - level product specifications and design documents for integration between HCM Payroll and Benefits with Payroll partners
• Develop high-level product specifications with attention to system integration and feasibility across OIC, OTBI, BIP and HCM Extracts
• Extensively worked on design and development of OTBI/BIP reports, which includes work with users and document BI report requirements, evaluate the reporting tool across OTBI, BIP and HCM Extracts, BIP Extracts and build the reports and custom security based on the user profiles and roles
• For last 4 years extensively working on Oracle cloud HCM migration projects and responsible design and development of data conversions of Core HR and Payroll using HDL and other third-party middleware tools and development of RICE objects using OTBI/BIP, HCM Extracts and Fast Formulas
• Extensive experience as an Oracle Fusion HCM consultant including implementation, development and support of Oracle Fusion HCM core HRMS, Talent, Global Payroll, Fusion Benefits and Oracle EBS and cloud HCM co-existence and related integrations
• Successfully integrated Kronos WFD/WFC with Oracle Cloud HCM using REST APIs and OIC
• Hands on experience in design and development of Oracle Cloud HCM integrations using OIC, HDL, HCM Extracts and BIP Extracts and Fast Formulas
• Worked with Payroll and Benefits administrators and gathered requirements for reports, interfaces with ADP and heath care providers and build reports and interfaces using OTBI, BIP, HCM extracts,
• Experienced in development of Oracle cloud integration with Kronos and other health care tools using OIC, HDL, PBL, HCM Extracts and Oracle cloud web services (SOAP/REST)
• Well versed with HCM underlaying base tables and developed HCM custom dashboards and reports using OTBI, BIP and HCM Extracts
• Worked with Payroll and Benefits team and build Payroll reconciliation reports by cost center and benefits open enrollment reports across benefits activity
• Proven hands on experience in design, development customization of OTBI/BIP reports, creation new subject areas, adding additional reporting columns as per user requirements using DFF’s, HCM extracts, Fast formulas, Fusion sandbox UI changes and well versed with Fusion HCM underlaying base tables
• Hands on experience in Oracle Taleo recruit/onboarding integration with Oracle Fusion using web services
• Proven hands on experience in Oracle Fusion Administrations including Oracle Fusion security, Oracle Identity management, managing fusion roles including creation of new custom data roles, job roles, functional roles and role hierarchy
• Proven hand on experience in development of SQL, PLSQL, Forms, reports, interfaces, HRMS APIS and XML Publisher reports
• Excellent experience in data loading into Fusion HCM using HCM Data Loaders (FBL, HDL, PBL and SSL)
• Proven hands on experience in writing fusion fast formulas including payroll and benefits, well versed with fusion formula database items, static items, Database functions, input and return variable in the formulas
• Had an opportunity to work on Fusion Financials, as part of production support of Oracle Fusion HCM and Financials
• Proven hands on experience in Oracle EBS HRMS development including design and development of fast formulas, interfaces, configuration of ETI/SIT, PLSQL interfaces, development of brand-new XML/BIP reports and well versed with Oracle EBS HRMS underlaying base tables
• Day to day interaction with Oracle Fusion Support SR, as part of testing of monthly payroll patching, fusion customizations and other payroll reporting issues
• Worked on EBS HRMS/Payroll and OAB and developed various fast formulas as part of Payroll earnings, dedications and Payroll accruals

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12/11i - HCM/Financials

Operating Systems: MS-DOS, UNIX, Sun Solaris 2.6, LINUX and Windows

Languages / Tools: Java, .Net, SQL, PL/SQL, Toad and SQL Developer

GUI Tools: 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/REST and XSL

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

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle Cloud HCM Techno Functional Consultant

Responsibilities:

• Worked with users to provide solutions on day-to-day HCM operational issues, which includes HCM inbound integrations, HDL data files, HCM extracts and security and HCM patching
• Designed and developed various HCM brand new integrations using HCM Extracts, BIP Extracts and HDL
• Supported users running Payroll weekly/Bi-weekly) and analyzed and fixed Payroll processing issues and post payroll integrations
• Created various absence fast formulas as per the business requirements
• Designed and developed brand new Kronos and HCM integration to share new hires and load hours from Kronos to Payroll element entry’s
• Explored HCM web services and build API based HCM integrations using OIC and HCM web services

Confidential, Los Angeles, CA

Oracle Cloud HCM Techno Functional Consultant

Responsibilities:

• Worked as a liaison between Marriott HR Central team and Accenture team (Offshore/onsite) and delivered various custom reports, integrations, security and responsible for troubleshooting and fixing day to day HCM operations challenges
• Direct interaction with Payroll/HR users and documented reporting requirements and developed reports using OTBI, BIP and HCM Extracts
• Reviewed and fixed open tickets across reports including performance issues and worked with Oracle support to resolve complex reporting issues
• Part of HRIS team and supported users on day-to-day HCM operations including integrations and reports and payroll processing
• Designed and developed various custom reports and extracts including HCM Extracts, OTBI/BIP report as per HR/Payroll needs
• Providing the development team with architectural blueprints to follow and evaluate the process and tool to customize the HCM application including security, custom reports, integrations and functional process including Hire to Retire process
• Explored different options to replace file-based integrations with Web Services and OIC and extending HCM applications to external applications
• Worked with users and reviewed existing legacy HCM reports, documented the reporting requirements and developed reports across HCM using OTBI, BIP and HCM extracts
• Reviewed existing PeopleSoft reports and worked with users to document the reporting requirements and developed the reports in Oracle Cloud HCM environments

Confidential, Los Angeles, CA

Oracle Cloud HCM Techno Functional Consultant

Responsibilities:

• Part of migration to Oracle Cloud HCM (core HR, Payroll) and responsible for data conversions from legacy HR application to Oracle Cloud HCM, work with users and prepare UIT/SIT test cases
• Worked as Oracle cloud security analyst and analyze enterprise security requirements, created custom roles including custom job roles, profiles, data roles and sand box UI personalization’s
• Extensively used Oracle OIC as part of development of real time data integrations across core HR, payroll and integration with third part downstream applications
• Worked with users and reviewed existing legacy HCM reports, documented the reporting requirements and developed reports across HCM and Financials using OTBI, BIP and HCM extracts
• Reviewed existing PeopleSoft reports and worked with users to document the reporting requirements and developed the reports in Oracle Cloud HCM environments
• Worked on Kronos and Oracle HCM integration and used REST apis from Kronos and using OIC
• Worked as an Oracle HCM security analyst and customized roles for reports
• Worked with users and gathered reporting requirements and designed and developed HCM reports using OTBI/BIP and developed HCM dashboards
• Worked with Oracle Support and explored REST api’s and developed Oracle HCM integrations using OIC and Oracle HCM public REST API’s
• Designed and developed fast formulas across Payroll, Benefits, Talent Management
• Performed data mapping for integrations and used different options of Oracle cloud HCM integrations (HDL, PBL, HCM Extracts and web services)
• Developed Payroll costing reports for each HR organization and Payroll costing dashboard for line managers
• Build OTBI/BIP reports across Grant and projects modules including design and develop dashboard reporting using seeded Oracle OTBI subject areas

Confidential, Nashville, TN

Oracle ERP Cloud Fin/HCM Techno Functional Consultant

Responsibilities:

• Worked with users across Payroll, core HR, Benefits and Talent management and documented the reporting requirements and developed reports and interfaces using OTBI, BIP, HDL, HCM Extracts and Web Services
• Prepared user manuals and training material for users to build OTBI reports
• Prepared documents for reporting security which includes creation of roles, customization of roles for specific to Oracle HCM reports
• Part of CRP, UAT and SIT and prepared UAT/SIT test cases and worked with users to test interfaces, reports and year end reporting

Confidential, Cleveland, OH

Oracle ERP Cloud Fin/HCM Techno Functional Consultant

Responsibilities:

• Responsible for data conversions from legacy sources to Oracle Cloud HCM, which includes analyze pre-conversion setups, data mapping and develop HDL data templates and load to Oracle cloud HCM
• Developed HCM dashboards for Open enrollment activity reports for benefits team
• Extensively worked on HCM reports including Payroll costing dashboards, Payroll balances and Payroll tax reporting dashboards for each agency
• Worked on OIC agent connection with third party on-premises third party databases
• The project involved production support of EBS HCM and Financials and migration from EBS to cloud
• Worked on data migration to Oracle Cloud using FBDI loaders, EBS PLSQL extracts.
• Excessively worked on Oracle cloud Security including research and setting up security setups, creation of rules, understand Oracle provided roles, profile options and setup as per security setups
• Design and development of reporting and integration solutions using OTBI/BIP and OIC (SOAP/REST) web services
• Explored and developed different options of Oracle HCM integrations to replace file based legacy integrations with OIC and REST apis
• Primary point of contact for users across HCM (core HR, Payroll) and responsible troubleshooting and fixing of day to day interface, reports, UI prisonizations and customization, workflow/alerts and coordination with Oracle support to resolve month end closing issues, data fixes

Confidential, Baraboo, WI

Oracle Cloud Fin/HCM Techno Functional Consultant

Responsibilities:

• Reviewed the existing day to day user reports across core HR, Payroll, Time entry and Benefits and re-developed reports in Oracle cloud HCM environment using OTBI/BIP and HCM extracts and Dashboards
• Worked on Oracle cloud integrations using ICS, FBDI, UCM and Web Services, including BIP extracts and data file generation
• Worked on building new dashboard reporting using HCM OTBI subject areas

Confidential, Minneapolis, MN

Oracle HCM Consultant

Responsibilities:

• Work closely with payroll, HR and benefits users to identify the 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.
• Worked with Oracle Support and installed OIC first time in the GM environment and replaced file based integrations with REST API and integrated Payroll and Core HR with downstream applications
• 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 the Workforce structure data, Worker data, Work relationships data, Salary, Jobs, Locations...etc.
• Translate business and functional requirements into technical approach.
• Drive the 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, Chicago, IL

Oracle Apps Financials and HCM Techno Functional Consultant

Responsibilities:

• 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, subject areas, adding new columns to the 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 the 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.
• Involved in day to day support of HCM modules and supporting payroll process and reporting

Confidential, RTP, NC

Oracle Apps HRMS Techno Functional Consultant

Responsibilities:

• Involved in r12 re-implementation and developed wide variety of development objects across EBS HRMS and Projects including data conversions from 11i and re-engineering of 11i RICEW objects based on r12 functionality
• Developed data conversions from 11i HRMS to R12 HRMS (Employees, assignments, payroll records and balances)
• Developed fast formulas across core HR, Payroll and Benefits

Confidential

Oracle Apps HRMS Techno Functional Consultant

Responsibilities:

• Re-written the new HRMS interface from ATS application using PLSLQ, Java, Web services, Oracle Apps API’s
• Day to day support of Oracle HRMS, Payroll and Benefits modules and worked both functional and technical support and created Sev1 Sr with Oracle support for year end Payroll reports
• Developed interfaces and reports as part of Oracle EBS Payroll integration with third party time entry application

Confidential

Oracle Apps HRMS Techno Functional Consultant

Responsibilities:

• Adding new operating units into existing R12 instance and performed data conversions, design, development of customizations across core HR, Payroll and Benefits
• Responsible for day to day support of Oracle EBS HRMS modules including time card loading, new hire interfaces, troubleshooting and fixing inbound and outbound interfaces across core HR, Payroll and Benefits