SUMMARY:

• Around 7+ Years of Experience in Oracle HCM and HR Information Systems and implementation of Oracle EBS HRMS and Cloud HCM Fusion applications.
• 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.
• Experience in Creating custom reports and analytics using OBIEE.
• Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology.
• Good experience coordinating with Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in HRMS of Oracle Applications including Oracle HR, Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• Expertise in Configurations, Personalization, and fusion role based Security, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
• Expertise in working with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and integration.
• Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre - Tax elements, Employer Liabilities, etc.
• Extensively worked on API's, Alerts, and RICE, Workflow, XML Publisher Reports, SQL Loader utility scripts and PL/SQL in writing stored procedures, functions, reports, fast formulas.
• Full Life Cycle implementations of Global HR and Talent Modules and support experience for Benefits and Payroll modules.
• 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.
• Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade/Patch updates, Cloud Testing, Support & Maintenance.
• Excellent skills in Back-end testing using SQL Queries. Experience interacting with Business Analyst/Leads/Developers to analyse 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, analyse and format data into useable reports.
• Experienced in configuring Workflow routing rules for all Manager Self-services and Employee Self-services.
• Experience in developing HCM interfaces within the modules of HR, Payroll and Benefits.
• 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.
• Experience in Data loading into Oracle HCM Cloud using SQL Loader, FBL, HCM Data Loader (HDL) and PBL.

PROFESSIONAL EXPERIENCE:

Oracle Cloud HCM Consultant

Confidential, Houston, TX

Responsibilities:

• Involved in client meetings during implementation process and gather the requirements.
• Worked on Enterprise level designs and configurations. Mapped and solved the conversion issues related to the business units, salary basis and workforce structures.
• Involved in extracting data from EBS data mapping transformation and data migration through oracle cloud.
• Involved in writing interfaces using HCM extract and BI publisher to move data between oracle cloud and external systems like ADP.
• Created eligibility profile, alerts, dynamic calculations, cross references while setting up the compensation plan.
• Setup approvals, Individual compensation plans, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, performance ratings, Workforce compensation approvals and Total Compensation Statements.
• Closely worked with oracle support by raising HR and followed up configuration issues and supported bug fixing.
• Ensured that the application meets the business requirements and system goals fulfil end user requirements, and identify and resolve system issues.
• Reported to higher Management on progress and status for all business-related work products and deliverable.
• Responsible for establishing and adhering to the projects communication plan and complying with all reporting requirements.
• Setting up application for Fusion Benefits - Open Enrolment which includes Creating of New Benefit plans, new plan Rates, Eligibility profiles, Fast formulas, running batch processes etc.
• Train the users on core HR, compensation and talent management.
• Provided end user guides and trained user on core HR, compensation and talent management.
• Use Oracle Fusion Functional Setup manager (FSM) to implement Global HR, Payroll, Benefits and Compensation Management.
• Process Analysis & Requirement gathering, Configuring, Testing, Go-Live and Production Support.
• Serves as the compensation workbench analyst for support organization.
• Expertise with Human Capital Management, Benefits, Compensation Workbench applications.
• Consults with customers to determine functional business need, expected outcomes and solutions to deliver expectations.
• Collaborates with oracle development in case of application defects and assist in the creation and delivery of code fixes.
• Maintains personal knowledge of legislative policy applicable to application functionality specifically the affordable care act.
• Communicates with assigned customers to ensure service satisfaction and professional understanding.
• Data Loading/Conversion using HDL/FBL which includes the workforce structure data, worker data, work relationship data, salary info etc.
• Configuring custom workflow routine rules for all manager self-service and employee self-service with help of area responsibilities.
• Ensure that the application meets the business requirements and system goals to fulfil end user requirements, identify and resolve system issues.
• Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Reported to higher Management on progress and status for all business-related work products and deliverable.
• Involved on production support of various HRMS modules including HR and Payroll.

Oracle HCM Payroll Analyst

Confidential, NYC, NY

Responsibilities:

• Created roadmap document as well as migration guide for Absence and Time and Labor module .
• Designed Functional specifications for extensions and customizations for irecruitment, Payroll, OAB and Performance Management
• Involved in Design, Development, Testing, Customer Support for Oracle E-Business Suite APIs (PL/SQL, SQL, Package Codes), Forms, Reports & Batch Processes.
• Configured Absence Management according to business requirements in test and production environments
• Analyzed current Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Analyzed and Resolved production support issues in Workday HCM, custom/vanilla modules and interfaces, solved integration issues between HCM cloud and external/legacy systems to help deliver a seamless product
• Working on HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Implemented Workday HCM Core HR, Talent Module, On boarding & Recruiting modules testing. Review, test, and implemented system upgrades or patches.
• Captured requirements and provided recommendations to the design of Fusion Absence Management.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management, Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor and Technical lead for Oracle support for Oracle HR, Payroll and OTL Time and labor.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Worked on Fusion R10 and R9 configuration (workflows, DFF, EFF, KFF, Business unit, LE, Compensation elements, rules, notifications, workforce management
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and Organized the testing process and Bug Reporting using ALM.
• Workday with Recruiting and On boarding.
• Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
• Done program to import Orders and Customers to Oracle through Oracle API Order & Customer Import.
• Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Provided development, testing and Production support of Oracle E-Business suite (EBS) modules HR, Payroll, Self Service, Labor Distribution, GL, AR, AP and other AOL modules.
• Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
• Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance,
• Customized existing Oracle Reports in Inventory Module (INV), Pricing using Reports 10g.
• Worked on Oracle Reports & Discoverer reports to support based on user requirement.
• Utilized the Application Object Library to register SQL Loader programs, shell scripts, PL/SQL procedures and RDF Reports.
• Possess in-depth understanding of Data Warehouse Concepts, ETL Tools, Reporting Tools, Job Scheduling Tools and Operating Systems.
• Involved in the Designing of interfaces and integrations between modules in Oracle EBS.
• Worked on conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.

Oracle HCM Payroll Analyst

Confidential - Arlington, VA

Responsibilities:

• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• 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.
• Managed the global HCM employee record database.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality. Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM).
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of paycheck distribution
• Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Created roadmap document as well as migration guide for Absence and Time and Labor module to current environment.
• Captured requirements and provided recommendations to the design of Fusion Absence Management.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Configured Absence Management according to business requirements in test and production environments
• Worked on Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Analysed and Resolved production support issues in PeopleSoft HCM, custom/vanilla modules and interfaces, solved integration issues between HCM cloud and external/legacy systems to help deliver a seamless product
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management, Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor.
• Technical lead for Oracle support for Oracle HR, Payroll and OTL Time and labor.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Worked on Fusion R10 and R9 configuration (workflows, DFF, EFF, KFF, Business unit, LE, Compensation elements, rules, notifications, workforce management).
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and Organized the testing process and Bug Reporting using ALM.
• Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.

Oracle HCM Analyst

Confidential -Austin, TX

Responsibilities:

• Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing.
• Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
• Created an support project by selecting the offerings, options and features to implement together to manage the project as a unit throughout the implementation life cycle.
• Designed new interfaces and maintained existing inbound and outbound interfaces to third party vendors. It included benefits and payroll among others .
• Assisted the HRIS department in timely and accurate processing of employee data and related HRIS information.
• Wrote customized fast formula for PAYROLL deduction elements.
• Identifying and addressing client needs: building solid relationships with client and awareness of Firm services.
• Provided Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Ceridian PAYROLL Created an implementation project to maintain the setup of specific business processes and activities for Fusion HCM, Global HR.
• Configured Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA) in Taleo Recruiting.
• Configured Source Tracking, Evaluation Management, Recruiting Center (welcome center, Theme& Logo, Communications Channel) in Taleo Recruiting.
• Create a mapping document and documented the decision on mapping data.
• Make configuration changes for data mapping. Analyze the impact of these changes on interfaces.
• Deliver application design, offering configuration/setup, User acceptance testing, and End-User training.
• Worked on training plans, course outlines and materials, and manages the delivery of training courses.
• Reported to higher Management on progress and status for all Business related Work Products and Deliverables .
• Conducted CRP, Integrated Testing & User's Acceptance Testing, self-service (ESS and MSS) •
• Prepared baseline, business requirements, fit/gap analysis and application setup using AIM methodology •
• Set up BR100 for Learning Management, Compensation Workbench, attendance, deductions, position management, referral rules.
• Trained client staff in setup configuration and module use, Taleo (TCC and TSS ), referral rules, referral pages, integration and XML, OAB, OLM.
• Delivered CRPs, Unit/Integration and UAT tests, data extraction, support and configuration .