SUMMARY

• Expert in identifying business requirements and map them to the Oracle Fusion functionality
• Experience in Creating HCM Extracts and Delivery Options for Extracts.
• Experience in Creating Reports and Analytic using Fusion HCM BI.
• Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology.
• Expertise in working with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and integration.
• Expertise in identifying functionality gaps and builds extensions.
• Experience in developing functional and technical design and documentation for Oracle Applications using data conversions, interfaces, custom reporting.
• Experience in functional and technical consulting services by acting as subject matter expert and leading clients through the entire cloud application services implementation lifecycle for Oracle Fusion projects
• Excellent skills in Back - end testing using SQL Queries. Experience interacting with Business Analyst/Leads/Developers to analyze the user requirements, functional specifications and also for missing Functionality.
• Excellent analytical skills, documentation skills, communication skills, presentation skills, strong problem solving skills and a very good team player in both independent and large team environments.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Experience in managing HR data requests and Assemble, analyze and format data into useable reports.
• Experienced in configuring Workflow routing rules for all Manager self-services and Employee Self-services.
• Exporting all work structures, employees, External Candidates and users from Global HR to Taleo recruiting.
• Export candidates (ready to hire) from Taleo recruiting to Cloud (Fusion) HCM using Import Oracle Taleo recruiting Cloud Service Data Process.
• Experience in Preparing the documentation for Business Requirements, Functional specifications and Test case documents and get sign-offs from the business users and Management.
• Good leadership and commination skills, on time deliveries, multi-tasking and assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, training to diversified users, rollout, post-implementation support of Oracle Fusion HCM cloud solutions at various customer sites, POC's and CRP.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, Salary info and Talent Management Data.
• Experience in managing & creating Flex Fields like Key Flex Fields, Descriptive Flex Fields, and Values Sets.
• Experienced in configuring Workflow routing rules for all Manager Self-services (MSS) and Employee Self-services (ESS).
• Hands on experience in development of both HCM data Loader & Outbound interfaces using HCM Extract, BI publisher & Data Modelling.
• Experience on Fusion HCM and ability to configure HR, Absence Management, Talent Management, Goal Management, Performance Management, assigning duties to users, adding new approvals on transactions and integrating with Oracle HCM Cloud, HDL loaders for HCM components.
• Experience on Excel in interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions and be able to lead discussions during business requirement meetings.
• Performed Feasibility Analysis and Developed Project plan, Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test Scripts etc
• Experience on Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc,
• Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
• Experience on implementation project by selecting the offerings, options and features to implement together to manage the project as a unit throughout the implementation life cycle.
• Experience on FusionWorkforce Deployment (Global HR) and Workforce Development (Talent Management).
• Experience on Setting up application for Fusion Benefits - Open Enrollment which includes Creating of New Benefit plans, new plan Rates, Eligibility profiles, Fast formulas, running batch processes. And etc.
• Experience on Business Requirement Documentation for Compensation STIP plan, Benefits, Goal Management and Performance Management.
• Experience in End to End configuration of Goal management and Performance management.
• Functionality testing of application for various scenarios and ensure that it meets functional specifications for transactions pertaining to Global HR, Benefits, Talent Management, Compensation STIP plan after the Patch/ Upgrades.
• Providing solutions for ad hoc queries on HR, Benefits, Talent Management and Compensation plan.
• Experience on Preparation of process documentations, training materials & user trainings like BR100, MD50, etc. using Application Implementation Methodology (AIM).
• Experience on Business process analysis, requirement analysis, gap analysis, system mapping, CRP testing, system configuration, data conversions, master data loading and production go-live support.
• Good communication and written skills with the ability to interface at all levels.
• Excellent troubleshooting and problem solving skills and Quality assurance
• Coordinate closely with technical team in extension and personalization
• A team player who also can work well independently.
• Coordinating and working with Oracle Support / SR.

TECHNICAL SKILLS

Databases: Oracle Database Version 11g/10g/9i/8i

Tools: Oracle Enterprise Manager, WEBADI, TOAD, SQL NAVIGATOR, Developer 2000/6i/9i, Discoverer 4i/9i/10G

Languages: SQL, PL/ SQL.

Other Tools: MS Word, MS Office, MS Excel, MS Power Point

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle Cloud HCM Functional Test Lead Consultant

Responsibilities:

• Responsible for managing Fusion HCMConsulting, Support and maintenance of the project and Leading the team.
• Interaction with the client for requirement gathering and creating Design Document.
• Setup and configuration of Fusion HCMWorkforce deployment - Core HR and workforce development modules like Performance, Goal management and Benefits
• Configured Fusion Applications for the End-to End Performance Cycle
• Involved in Configuration of roles, role mapping rules, user accounts through OIM and APM
• Manage approvals for Core HR, performance and Goal Management through BPM
• Preparation of reusable test scripts for Fusion - Benefits, Goal, and Performance and Core HR modules.
• Payroll Support: costing configuration/mapping, maintained element entries, balance adjustments, processed quick-pays and monitored impact of payroll on benefits module and interfaces, identified and resolved fallouts in parallel testing.
• Perform 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.
• Self Service/OTL: wrote MD.50 for system to automatically add or remove responsibilities (ESS, MSS, Time View, Timecard Supervisor) for employees based on existence of direct reports and employee type (i.e. hourly/salary) and guided client through testing cycles.
• Raising SRs and follow up with Oracleon Product Bugs and Configuration issues and support bug fixing.
• Responding to User queries with respect to application management.
• Perform manual Benefits reconciliation which includes identifying the differences in deductions of the Employees from various third party vendor reports and benefit providers with Fusion application
• Registering BI Publisher Reports and OTBI Reports to Oracle Fusion Environment (Schedule Process) Bursting Reports and Alerts, Defining LOV.
• Oracle Transactional Business Intelligence (OTBI) puts reporting in the hands of business users.
• Perform BI Report testing which includes creating new report/analysis, testing existing and saved reports.
• Prepare Release wise UI and functionality differences documents and educate the user with new functionalities.
• Provide End User Guides for Core HR, Goal and Performance modules
• Impart trainings to the team on Core HR, Goal & Performance management
• Conduct and participate in Daily/weekly calls with client.

Confidential, CA

Oracle Cloud HCM Functional Test Consultant

Responsibilities:

• Analyzed the business processes, requirements, mapped with Oracle features, conducted Gap Analysis.
• Identified Core HR, Absence Management requirements configured necessary solutions and conducted knowledge transfer sessions with client to support ongoing maintenance.
• Worked on Fusion Workforce Deployment (Global HR) and Workforce Development (Talent Management).
• Train the end users on GHR, Talent Management, Compensation Management, and Security Administration.
• Worked on Fusion Workforce Deployment (Global HR) and Workforce Development (Talent Management).
• Supported other teams, Payroll, OTL, and Benefits to provide continuity between all teams on all modules.
• Delivered UPK Documentation on HR/Payroll/ Benefits processes for user training purposes
• Responsible for Oracle Fusion HCM configuration for global OAB, Payroll, HR/performance/Goals/Talent Review - hands-on full life cycle project delivery and go-live experience.
• 55+ Legal Entities spanning over 30 different countries.
• Complex approval rule definitions and routing.
• Configured Vacation, Sick Time, Personal Day, Employee Designated Absence Plan and Type as per business requirement.
• Wrote Fast Formula and also configured approval process for Absence transactions.
• Maintained the regular interaction with the client, end-users, technical team, and participated in meetings on regular basis and followed up the progress of work.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new reports and customizing the existing ones.
• Coordinated set up activities in UAT and production environment of all the modules.
• Supported the Subject Matter Expert (SME) in Core HRMS modules and business process.
• Post production support (L2/L3), creating tickets with oracle support, issue monitoring, log monitoring, etc.

Environment: Oracle Fusion Global Human Resources Cloud Service (R10) - Fusion Core HR, Absence Management, OTBI Report, Workforce Compensation.

Confidential

Oracle Cloud HCM Functional Consultant

Responsibilities:

• Functional lead responsible for implementation of HCM Cloud Time and Labor
• Configured time cards to utilize costing segments for maintaining project and task information
• Time card fields and layouts defined to integrate seamlessly with absence management and Fusion Payroll
• Custom approval rules defined so admin can enter time on behalf of executives without requiring approval
• Custom time entry rules and time calculation rules configured to comply with specific legal/organizational requirements (i.e. FLSA and overtime)
• Identified functional requirements for custom reports essential for data validation and ongoing analysis
• Configured eight absence plans for managing accrual balances in Fusion self service
• Implementing Workforce Deployment, Compensation management, Talent Management (Goal management, Performance management, talent Review and Succession) and Security.
• Manage business stakeholders, plan and manage steering committee meeting
• Prepare project estimations, project budgeting, project schedules and resource allocations and execute projects successfully within budget and estimated timeframe
• Work 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.
• Prepare the documentation for Business Requirements, Functional specifications, Business Requirements, Functional Requirements and Test case documents and get sign-offs from the business users and Management
• Involved in the Functional approval discussion, which involves not only the impact of functionality on the product, but also the various alterations associated with it. These sessions also include the various areas which has to be changed to cater to these 'functionality' changes.
• Prepared the functional specifications for the custom Fast Formulas, reports and extracts needed for the client.
• Configured the high-level Benefits in the system, Life Events, Programs, Plan Types, Options, Plans, Eligibility Profiles, Collapsing Rules and etc.
• Project Planning, Monitoring, Control and Solution reviews
• Review and monitoring Projects Status, handling escalations, issues, risks, manage customer relationship (Sr. Executives level)
• Configured custom workflow routing rules for all Manager Self Service and Employee Self Service with the help of area responsibilities
• Setup Fusion Talent management sections like Goal plans, Questionnaire, Performance scale, Appraisal template and performance document
• Setup geographies, action reasons, content types, enhanced fusion flex fields, jobs and departments etc.
• Setup Fusion Compensation plans, budget pools, worksheet and Total Compensation Statement
• Customized Budget pool and Worksheets as per the client requirement.
• Conducted mock open enrollment.
• Setup Self-service enrollment display of Benefits plans

Environment: Oracle Fusion Global Human Resources Cloud Service (R9) - Fusion Core HR, Absence Management, Time and Labor, Benefits, Workforce Compensation, Learn, Recruit/Onboard, Talent (Phase II: Payroll)

Confidential

Oracle Functional Consultant

Responsibilities:

• Gathering of User Requirements, Business Rules and Processes, Mapping and Performance of Gap Analysis and suggest Customizations, obtaining signoffs and developing prototype are my present responsibilities.
• Prepared various AIM documents like BR100 and MD50.
• Developed and maintained configurations (Orgs, Jobs, Grades, Responsibilities, Flexfields, costing for payroll, etc.) in multiple instances to support CRPs, SIT, UAT, Parallel Payrolls, and Production.
• Tested configurations and functionality, wrote test scripts and guided users through testing cycles.
• Performed Post Conversion activities to fix records as needed.
• Monitored issues, involved in resolutions, Technical/Interface Support.
• Supported the development of interfaces to/from Oracle starting CRP3 through Go Live.
• Communicated with benefits providers and appropriate vendors to define inbound and outbound interface requirements, formatting, and scheduling.
• Produced MD.50 functional documents necessary for technical developments.
• Maintained all technical documents and approvals.
• Tested 20+ benefits interfaces, developed test scenarios and guided users through testing cycles.
• Maintained FTP directories and process for transferring files between client and vendor.
• Supported other teams, Payroll, Self Service, OTL, and Benefits to provide continuity between all teams on all modules.
• Payroll Support: costing configuration/mapping, maintained element entries, balance adjustments, processed quick-pays and monitored impact of payroll on benefits module and interfaces, identified and resolved fallouts in parallel testing, etc..
• Developed and maintained configurations (Orgs, Jobs, Grades, Responsibilities, Flex fields, costing for payroll, etc.) in multiple instances to support CRPs, SIT, UAT, Parallel Payrolls, and Production
• Self Service/OTL: wrote MD.50 for system to automatically add or remove responsibilities (ESS, MSS, Time View, Timecard Supervisor) for employees based on existence of direct reports and employee type (i.e. hourly/salary) and guided client through testing cycles.
• Benefits Support: configured eligibility profile/rules in OAB, developed test cases and executed specific test scenarios, wrote test scripts and guided users through testing cycles.
• Involved in creating Users Responsibilities and the document sequence and categories for all the modules.
• Involved in troubleshooting with the issues in financial modules while supporting Finance team, troubleshooting various issues relating to performing the Month and quarter close.
• Coordinated with End-User for closing procedures

Environment: Oracle Financial Applications R12, HRMS, Payroll, Advanced Benefits, AP, AR, GL, FA, CM, OM, PO, iExpense and iProcurement.

Confidential

Oracle Apps Support Consultant

Responsibilities:

• Worked as an Asst. Functional Analyst for Oracle management, Receivables, Inventory.
• Assisted in configuration and implementation of Financial Modules.
• Studied and evaluated functionalities of various modules.
• Prepared Setup documents (BR100) for OM & Accounts Receivable.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Registering BI Publisher Reports and OTBI Reports to Oracle Fusion Environment (Schedule Process) Bursting Reports and Alerts, Defining LOV.
• Preparation of Test Cases, Assigning work to all resources, check into VSS and code Review.
• As per the requirement, Preparing DS140 Technical Documents.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Handled post go-live user support

Environment: Oracle Applications 11i - (GL, AP, AR, CM, INV, Purchasing), Oracle 10g, SQL, TOAD.