SUMMARY:

• Around 7 years of strong techno - functional experience in Oracle application with hands on experience in Requirement Analysis, Fit/Gap Analysis, Customization, Upgrade, Testing and Maintenance of Oracle HCM applications for full life cycle implementations.
• Expertise on the following Oracle HRMS modules. Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources(HR), Oracle Payroll, Oracle Absence Management, Oracle Advanced Benefits(OAB), Oracle Time and Labor(OTL), Oracle iRecruitment, Oracle Learning Management, Oracle Self Service Human Resources(SSHR), Workforce Deployment and Workforce Development (Goal Management, Performance Management, Talent Review and Succession).
• Experience and proficiency in the Identity Management with hands on experience in implementation and management of Oracle Identity Manager (OIM), Oracle Access Manager (OAM), and Oracle Internet Directory (OID).
• Experience in developing functional and technical design and documentation for Oracle HCM Cloud using data conversions, interfaces, custom reporting.
• Involved in end to end implementation, customization, conversion, interface, extension, development, production support and testing in Oracle E-Business Suite (EBS) 11i and R12.
• Expertise in business Analyst role to understand the HR business needs, requirements and convert them into Oracle HCM product solution and liaison between technical solution team and Business team.
• Expertise in designing of payroll inbound and outbound interfaces which is related to non-Oracle Payroll entrainments like ADP, Integral as well and Oracle Payroll base environment.
• Hands on experience in Oracle Fusion Core HR, Absences, Performance Management, compensation management and Oracle Finance modules: Accounts Payables, Accounts Receivables, General Ledger, Fixed Assets and Cash Management.
• Strong experience in Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance. Good experience in engaging Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
• Excellent experience in Data loading into Oracle HCM Cloud using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Experience in Requirement Analysis, JAD sessions, Requirements Interviews, Brainstorming, Running Scrum Meetings, Sprint review, Business and Systems reviews and working sessions to communicate with the team and to ensure the understanding of the requirements and system design.
• Strong experience in Oracle Fusion HCM - Functional Setup Manager, Enterprise structure configuration, Employment model, Workforce structures, Personalization’s and OTBI reports.
• Expertise on HRMS API's like Employee, Assignment, Address, EIT, Termination, Phone API's.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
• Experienced in HRMS/Payroll functionalities such as Employee W­2, SSHR after gap/fit analysis, Enhanced Retro pay, etc.
• Exclusive experience with Fusion HCM - Workforce lifecycle, Talent management - End to end Goal management and Performance Management life cycle and Fusion Benefits.
• Extensive experience in holding the primary accountability of supporting the design, planning, development, testing, documentation and maintenance of best-in-class Business Intelligence capabilities, including data architecture/warehousing, ETL, data governance, advanced analytics, and reporting.
• Strong Experience with Workflows, Web ADI, Discoverer & XML Reports and Oracle Business Intelligence (OBIEE).
• Extensive experience in Oracle Fusion HCM cloud implementation project and actively collaborated with Oracle cloud product team to provide feedbacks and enhancements recommendations.
• Extensive experience in OBIEE Administration including Migration, Debugging, Optimizing, Performance Tuning and Production Support.
• Expertise in using PL/SQL API's, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter.
• Trained the client's business users on using the application, conducted conference room pilot testing (CRP), system integration testing (SIT), user acceptance testing (UAT), design validations and setups of the distributed ERP applications.
• Extensive experience in Performing Gap Analysis, Conducting CRPs, Coordinating Business User Interaction, implementation approaches and developing support plan.
• Extensive experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.

TECHNICAL SKILLS:

ERP: Oracle EBS (R12 - 12.1.3)   /11i (11.5.8, 11.5.9, 11.510.2) /11.0.3 and Oracle Identity Management Oracle Identity Manager 9.0.1 - 11.1.1.5

Domain Expertise: Oracle HCM, Oracle HRMS, Oracle Human Resources(HR), Oracle Payroll, Oracle Absence Management, Oracle Advanced Benefits(OAB), Oracle Time and Labor(OTL), Oracle iRecruitment, Oracle Learning Management, Oracle Self Service Human Resources(SSHR), Workforce Deployment and Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Business intelligence, OBIEE.

Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data Loader, BI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000, Forms 6i/10g, Reports 6i/10g

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder

Operating Systems: Windows 98/2000/NT/XP/7/8, Unix (Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, Illinois

Sr. Oracle Fusion Consultant

Responsibilities:

• Involved in annual performance review and Career/succession planning for Business Units using Oracle HRMS.
• Responsible for the implementation and integration of the Oracle Cloud HCM and Legacy EBS R12 financials regarding Costing and mapping the COA. 
• Involved the functional implementation of Oracle Core HCM, Benefits, Compensation, Absence Management, Payroll, Performance Management and Goals, for an HCM implementation. 
• Performed Oracle E-Business Suite (EBS or Apps) integration with Oracle Identity Manager (OIM) for User Provisioning and Reconciliation.
• Involved in Developing and managing the integration of various ERP systems with Oracle EBS. 
• Created Oracle BI Analytics Financial Reports focusing on homes at risk of foreclosure. 
• Used Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Payroll.
• Managed reporting migration from massive third-party partner payment processor, and manage readiness / change management ecosystem for an adoption of new BI (Business intelligence) strategy and tactical solution.
• Analyzed client-reported Oracle HCM Cloud issues, and resolve them in a timely and professional manner.
• Reviewed the results of the RetroPay Enhanced process by checking the Assignment or the Payroll Process Results window for the process completion status.
• Customized Self Service Time Expenses responsibilities using the Time and Expense Self Service Menu with menu exclusions, Mass Timecard Approval using the OTL Self Service Approval Menu and Worklist Timecard Approval using the OTL Worklist Timecard Approval menu.
• Worked with various levels of business and technical resources to deliver end-to-end solutions from Taleo to internal HCM custom .Net onboarding user interface and ultimately to Oracle HCM. 
• Implemented Workforce Compensation in Oracle Cloud for a global company.
• Configured the Oracle Applications/HCM Cloud application to meet client requirements and document observed issues, troubleshoot and diagnose, and communicate solutions to the client.
• Leveraged the functionalities of OIM to provision accounts to EBS or reconcile users from EBS to OIM.
• Responsible in defining recurring periods, Alternate names, Flex field Mapping, element sets, Approval periods, Approval rules, Preferences, Eligibility criteria, Timecard Layouts, Time Entry rules and transferring timecards from OTL self-service to BEE.
• Involved in Designing applications extensions for custom retro pay process based on time skip in OTL and payroll interface.
• Setup and configured Fusion HCM Workforce deployment - Core HR and workforce development modules like Performance, Goal management and Benefits.
• Assisted process improvements in Oracle HR for upcoming implementation of Oracle Payroll.
• Prepared CRP test plans and worked with end users to test module configurations and custom objects in the Oracle EBS R12 instance.
• Involved in configuration of AWE/Workflow for self Service transaction. Customized delivered code to achieve business requirements.
• Performed Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Demonstrated ownership of Payroll configuration for running an Oracle-based Payroll (Payroll Process, pre-payments, payroll archive, check writer, NACHA, Third Party Check Writer, Costing, transfer to SLA, Create Accounting).
• Involved in the Implementation of Retro-Billing Process which helped in changing the amounts on already invoiced orders on customer request.
• Enabled HIRE date field on the payroll portal, to allow clients to update the HIRE/Re-Hire date of an employee, so that it updates all other dependent functionalities (Personal Information changes, Assignments, Element Entries, Etc.).
• Conducted requirement-gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD) using Rational Requisite Pro.
• Prepared reusable test scripts for Fusion - Benefits, Goal, and Performance and Core HR modules.
• Managed Enterprise HCM Information. Verified existing PL/SQL packages and develop new ones as required by the HRIS team.
• Maintained user access and privileges within Oracle Agile PLM application, creating documents and associated components as required and adjustments to existing objects, lists, searches, and workflows at user request. 
• Involved in Design & Implementation of Oracle Identity & Access Management suite.
• Facilitated smooth testing during SIT and UAT for Core HR and Self-Service HR and played a vital role in tracking/resolving all issues.
• Responsible in developing System Extracts to Export data from Oracle Advanced Benefits to Third party vendors.
• Built Custom Security to HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Performed End to End Regression testing on Fusion Core HR, Employee Self Service (ESS), Manager Self Service (MSS), Talent management module such as Goal management and Performance management, Fusion Benefits modules on every patch bundle application and new Releases.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. 
• Designed and led the development of integration between third party learning system and Oracle HR.
• Conducted informal training for the business owners and stakeholders to introduce them to other functionality offered by Oracle HRMS Suite, and provided concise responses to their precise inquiries and questions, in a timely manner.
• Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, Payroll Interface and Fusion Benefits.
• Developed in Service Contracts customization using Oracle PL/SQL and Standard APIs.
• Conducted daily scrum meetings to coach and mentor the self-organized, cross-functional Agile Project team on key principles of Scaled Agile (SAFe) competencies & practices including team ownership, commitment, effective user stories, agile estimation, and transparency.
• Performed End to End Regression testing on Fusion Core HR, Talent management module such as Goal management and Performance management and Fusion Benefits modules on every patch bundle application and new Releases.

Confidential, Columbus, OH

Oracle functional Consultant

Responsibilities:

• Involved in designing employee date tracked report with payroll balance, new hire report, employee work history report, organization wise payroll summary report which match expanse accounts and prorate regular earnings, over time earnings report for payroll, sick leave report to show payroll deduction history, regular hours worked and earning using PL/SQL, Oracle Concurrent
• Collaborated extensively with development team on development and customization of Oracle RICE (Reports, Interfaces, Conversions and Extensions) components as per business requirements. 
• Conducted User Acceptance Testing (UAT) and collaborated with the client stakeholders and QA team to develop the test plans, use cases and test data to be used in testing.
• Worked with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
• Responsible for managing Fusion HCM Consulting, Support and maintenance of the project and Leading the team.
• Involved in Setup and configuration of Fusion HCM Workforce deployment - Core HR and workforce development modules like Performance, Goal management and Benefits.
• Ran payroll, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import payroll transactions from HRMS. 
• Designed Spec. for month-end Benefit Balance validate and update to Oracle payroll, developed programs to upload time from contingent worker time system to OTL which includes time and project attributes for OTL module.
• Implemented OSP (Occupational Sick Pay) and Retro Payroll Process and worked on various Retro-Pay Related Issues.
• Participated in the Oracle upgrade from version 11i to R12.1.2, including designing executing test scripts for Unit Testing, as well as User Acceptance Testing.
• Utilized OIM’s pre-built connectors to provision accounts or reconcile users with LDAP Servers, Databases, Operating Systems and Business Applications including Oracle E-Business Suite.
• Created basic HRMS user in EBS and link record in HRMS with record in FND USER by utilizing the User Management with HR Foundation connector of OIM.
• Worked with Management, business users and third-party vendors to understand the requirements and guide the team on designing and mapping the requirements to Fusion HCM system.
• Involved in the implementation of core HRMS functionality for multi-currency and multi legislations (Global) and integration with financial and manufacturing modules.
• Configured and maintained the following servers: Oracle BI Analytics Server, Oracle BI Analytics Web Server, and Oracle BI Analytics Scheduler. 
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio, MS Word and MS Excel.
• Involved in troubleshooting problems encountered in the integration and up-gradation processes of Oracle Identity Management suite components.
• Setup Fusion Talent management sections like Goal plans, Questionnaire, Performance scale, Appraisal template and performance document.
• Modified the seeded HR workflow processes as per their needs for Oracle Self Service and Payroll.
• Worked in the environment involving Agile PLM (Product lifecycle management) Administration and configuration and customization, this includes the discussion and understanding the customer issues and defining the Agile Users/ Workflows/ Roles and Privileges.
• Identified customizations and integration points that are impacted due to Split of CS and HCM, and documented new designs for technical team on new customizations and new integrations.
• Coordinated daily team activities (SCRUM) to ensure project schedule remained on target.
• Performed data mapping between Oracle EBS R12 and legacy systems.
• Worked on the Data migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc.).

Confidential, San Mateo County, CA

Oracle functional Consultant

Responsibilities:

• Involved in the Development of the functional plan for the R12 EBS implementation. Provided weekly status reports to the Project Manager and managed the functional team. 
• Streamlined Change management & Business process mapping for HRMS administration activities between Legacy system and Oracle HRMS modules. 
• Defined and managed compensation and benefits packages in Oracle HCM. 
• Worked on XML / BI publisher reports like Overtime, Higher skills in HR/Payroll. 
• Worked with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
• Implemented Fusion shared modules Financials (GL/Primary ledger, AP and AR) for payroll configurations. Gaines added knowledge on Finance sales and order management flows.
• Worked with the Integration of Oracle Time and Labor (OTL) and Human Capital Management(HCM).
• Involved in sorting out and fixing the Payroll related issues related to Time and labor (OTL) and iRecruitment.
• Advised client on integration of OAB with Oracle Payroll and assisted on design/implementation of Retro functionality.
• Involved in HCM-Payroll QA and integration testing after splitting into two instances.
• Attended business unit project meetings to identify and capture the support needs of the business unit from the dedicated OTS DBA team. 
• Worked on multiple user hooks in HRMS and Payroll modules to execute custom functionality.
• Conducted Unit testing, Integration/ Regression testing and UAT.
• Worked with the complete SDLC, elicit, analyze and define requirements. Executed Agile SDLC project using offshore and onshore managed service model.
• Developed HCM Extracts for Global HR, Payroll Interface and Fusion Benefits
• Configured Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self-service web pages.
• Captured functional and technical requirements. Mapped requirements to the standard Oracle R12 functionality and identified the gaps. Provided solutions to the identified gaps. 
• Involved in data conversion from Legacy to Oracle HRMS.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Assisted in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, Object Oriented Design (OOD).
• Studied the requirements for HCM modules and Analyze business requirements and converted into technical requirements.
• Worked on form personalization on Payroll run results form to restrict user to modify details.
• Involved in Designing and developing Fields, Record Definitions, Pages, Sub Pages and Components based on the business requirements.
• Configuring the set ups for raising Batch invoices and Batch Payments Configured the set us for prepayments and adjustments for payments to suppliers.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Documented Business process flow as per the UML standards using Use Case Diagram, Activity Diagram and Sequence Diagram in MS Visio.
• Evaluated the work effort to complete requirements and UAT testing to provide project estimates, project plans, business impact analysis and project charters.
• Coordinated all onboarding efforts including pre­-employment drug screening, background checks, and entry to payroll.
• Assisted in setting up the environment for Fusion HCM Global HR entities. 
• Assisted in creating Business Requirement Document (BRD) and Functional Document based on Business Requirements Document. 
• Documented business requirements for all reporting (Processing schedulers, SQR) create to meet customer's information needs.