SUMMARY

• Over 7+years of Professional experience as an Oracle Cloud HCM/ Oracle Application Core HR Oracle Fusion Cloud HCM Cloud (Global HR, Payroll, Absence Management, and Talent Management), Compensation Management (benefits, Incentive and Total Compensation).
• Oracle HCM Benefits - Configuring Life Events, Configuring Plan Types, Plans, and Eligibility Profiles & Leave of Absences. Open Enrollment setups & issues, worked on defining Rates and Configuring Dependents for Health, Life & Disability plans. Creating Benefit groups and Processing Life events, addressing life events issues, creating fast formulas with person selection rule etc.
• Oracle HCM Global Human Resources - Workforce directory (Employee Self-service & Manager Self Service), Workforce Administration, Grades, Bargaining Units, Collective Agreements, Workflows, Workforce Life cycle & Profile Management Oracle HCM Talent Management - Goal Management, Performance Management, Talent Review & Succession Planning.
• HR Management:
• Effectively developed direct reports in HR Solution Center which provided payroll, benefits, employee relations, labor relations, compensation, talent management, and HRIS assistance to all employees.
• Drove HR initiatives to align with business strategy and deliver superior service to our field organization.
• Facilitated integration of new HCM system through testing, process improvement and change management Benefits:
• Created and distributed communication materials (annual enrollment guide, employee handbook, benefit policies, internal company newsletters)
• Coached field and corporate HR on benefit guidelines and practices to ensure company compliance.
• Led benefits trainings to prepare for open enrollment and integration of new HCM system.
• Configured Absence Management according to business requirements in test and production environments
• Implemented Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows & approvals, Reports & Analytics, Email Alerts/Notifications, Application Customization and Data Migration, etc.
• Involved in building Payroll ADP extract to pick employee data from HCM and pass it to ADP vendor for payroll processing.
• Interacted with clients during the implementation process, involved in requirement gathering, preparing AIM and OUM documentation, business requirement documents, understanding current business process and mapping with Oracle cloud and EBS Applications.
• 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.
• Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance.
• Experience in Creating BI Reports, Analytic & Dashboards using Fusion HCM OBIEE.
• Strong experience in Fusion HCM Cloud Implementation, HCM Cloud Upgrade, and Patch updates, Cloud, Support & Maintenance.
• Expert in identifying obstacles and issues, troubleshooting and working with team members to derive viable solutions.
• Experience on Fusion HCM Cloud and ability to configure Global HR, Oracle Advanced Benefits, Compensation Workbench, and Talent, assigning duties to users, adding new approvals on transactions and Integrating with Oracle HCM Cloud, File/Worksheets based loaders for HCM components.
• Import candidates (ready to hire) from Taleo recruiting to Cloud (Fusion) HCM using Import Oracle Taleo recruiting Cloud Service Data Process.
• Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Benefits and payroll modules.
• Good Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc.
• Manage vendor relations for Canadian payroll processing to insure accurate global payroll processing.
• Have worked on implementation, production support, ongoing support (trouble shooting) and enhancement activities on oracle e-business suite applications (r12.1.1, r12.1.3, r12.2.4).
• Expertise in Oracle Payroll configuration with Oracle Time and Labor and Oracle Benefit modules in Multi-Org environments.
• Experience in managing HR data requests and Assemble, analyze and format data into useable reports.

TECHNICAL SKILLS

• Oracle HR 12g recruitment (Oracle) recruit (TAM) 8.9
• Human Resources
• Payroll
• Benefits
• Performance Management/Compensation
• Recruiting
• Onboarding

PROFESSIONAL EXPERIENCE

Oracle HCM Payroll Analyst

Confidential - Broomfield CO

Responsibilities:

• Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Expertise in Oracle Payroll compensation management, Salary review, and designing of especial earning rules using Fast formulas.
• Configuring and providing functional support for various modules of the Oracle Applications Core-HRMS, Payroll, Self-Service, Goals and Performance Management and Talent Management.
• Implemented Workforce Deployment, Compensation, Talent Management, Goal Management, Performance Management, talent Review and Succession and Security
• Excellent working Knowledge in development of OBIEE including Oracle BI Answers, Oracle BI Delivers, Oracle BI Interactive dashboards.
• Set up Time Reporting codes, Time Reporting programs, Workgroups, Rule programs in Oracle Time and Labor.
• Highly Skilled on Designing Interactive Executive Dashboards using Cognos BI and Tableau. Designed over 200 + Dashboards during my Analytic Journey so far.
• Worked with business process framework, well verged with multiple configuration options in staffing, compensation, Recruiting, Benefit events, time off/leave events, Talent Management Events.
• Staffing Movements: An employee changes in position, inbound process and outbound process for recruitment.
• Termination Process: Initiate termination process, review termination process, to do tasks as a part of recruitment.
• Event Management: Finding the event, Task Reassignment and Requesting the reassignment, manage delegation settings, Editing the tenant setups- Business Process and Notifications of recruitment.
• Conducted new hire orientation, informing employees about benefits, filling out timesheets, punching the time clocks, mandatory forms, and the New York Notice and Acknowledgement of Pay Rate and Pay Date.
• Planned implemented and configured Oracle Payroll Tax tables that included State Tax tables, Garnishments, Deductions.
• Created Dashboards, Work centers for various Payroll requirements. Extensively used Fluid to create Payroll specific tiles.

  Managed all verification and validation activities for all production modifications including projects, releases and changes.

• Involved in testing Time and Labor scenarios such as Time reporting, Adjustments and Time interface to external database.
• Troubleshoot Payroll issues as part of daily production support and supporting N/A payroll for Semi-Monthly, Bi-Weekly and LTIP payrolls in order to confirm the checks in the timely manner.
• Redesigned most of the Time and Labor rules and written most complex rules to stabilize the environment and tested all the rules by compiling and running the time and Admin process.
• Performed initial analysis on System requirements and evaluated the existing Payroll & Time entry system to come up with impact analysis, necessary customizations which would be required once the move to Oracle Time and Labor would be accomplished.
• Working on different ODI concepts like repositories, topology, and knowledge module customizations. Facts and dimensions creation and usage for data modelling in ODI. Keen knowledge of data modelling concepts like star schema and snowflake schema.
• Performed end user training, which included Rule Development, Rule Migration best practices, Self Service for Time and Labor employees.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Created roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Good experience in creating custom Application Roles and providing Data Access for users in OTBI.
• Worked on Payroll Parallel testing which is unique to payroll implementation. In payroll it is very essential to match dollar by dollar salary of each EE in Payroll cloud with the Legacy Payroll software.
• Consult with benefits department, as needed; to coordinate changes to benefits as a result of employee's leaved.
• Supporting Payroll activities like SIF Creation, Invoice Creation in AP to Nine Business Groups for smooth closure in Oracle HRMS (EBS R12).
• Prepared functional designs for Core HR, Payroll and SSHR and prepared test cases for Payroll, Core HR and SSHR.
• Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.
• Designed and developed Oracle HRMS solutions such as customized reports, forms.
• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Identified Core HR, Absence Management requirements configured necessary solutions and conducted knowledge transfer sessions with client to support ongoing maintenance.
• Develop HCM Extracts/OBI Reports for Global HR and Debug and enhance workflows, reports/modules/alerts.
• Proficient writing SQL queries to drill down for issues.
• Experienced in Developing, customization and personalization OAF pages. Design Develop and extending standard and custom Oracle Application Framework (OAF objects such as View Objects, Controller, Application Module (AM) and Entity objects.
• Worked on OAF personalization’s on Supplier form and listed suppliers based on location.
• Extend iProcurement approval email notification to have additional columns like Account string, Requestor Cost Center etc., using OAF extension
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
• Configure new HR and Payroll whenever there's new benefits (i.e. new CBA benefits) including writing fast formulas.
• Bridged gap between AS-IS and TO-BE business process flows, integration of process flow diagrams to show end-to-end business model, and process mapping exercise by including swim lanes to distinguish roles and responsibilities.
• Design, develop and maintain browser based reporting and various applications using PL/SQL, HTML, ORACLE.
• Created functional design for interfacing check and direct deposit output files to a third-party printing service.
• Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
• HR Organization Leadership: Directing 4 HR professionals in staffing, recruitment, benefits, training, leadership development, succession planning, HRIS, and regulatory compliance.
• Created and implemented new recruitment, staffing, and workforce development programs to meet advancements in product operations, technology, and management.
• Configure custom Workflow routing rules for all Manager self-services and Employee Self-services with help of Area Responsibilities.
• Proficient in defining users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent Programs, Lookup types and defining Value sets.
• 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.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), recruitment 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.
• Involved in preparation of Test Cases, Test Scripts for the Global HR, Benefits, Talent and Global Compensation.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Analyzed 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.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management, and Compensation STIP plan.
• 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 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

Talent and Absence Management Consultant

Confidential - Brentwood, TN

Responsibilities:

• Expertise in Talent Management and Learning functions including: annual reviews, quarterly check-ins, compliance training, and continuous learning.
• Configured Time clocks to interface with the Peoplesoft Time and Labor system.
• Configured Time Reporting codes, Time Reporting Programs, Workgroups, Rule Programs, Value Lists in Peoplesoft Time and Labor.
• Created various data models, report and bursting in BI Publisher and Knowledge of creating RTF template for report which can be used in BI Publisher.
• Worked on BI Publisher and OBIEE integration using web services.
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables.
• Creates functional requirements based on business needs and translates to technical resources for delivery.
• Serves as the primary point of contact to consult on technology solutions for future initiatives and projects.
• Created talent review process, including assessments to identify high potential talent for career growth/movement and annual functional talent planning across organization.
• Developed resources/tools and training for each phase of annual talent cycle for end user navigation and HR Business Partner administrative activities.
• Maintained talent data/profiles and created talent pools for key positions, conducted quarterly cross-functional talent planning sessions with HR and functional leaders to fill open positions, created bench plans, and prepared annual talent review plan for executive leadership team and board members.
• Participating in the development of strategies, roadmaps and business cases for Analytics and BI solutions.
• Working as a Senior Consultant BI & Analytics, providing all technical solutions on BI platform.
• Partnered with HRIS, IT, and vendor SumTotal to complete process development, configuration, UAT, and implementation of first automated talent system, including performance, 360, and succession modules, developed resources/tools and training to support the end users and HR administers.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Scheduled weekly demos with higher management, business partners and project managers related to the projects to review the changes and get approvals using WebEx.
• Worked and discussed the changes with change management to get approvals for the scheduled release.
• Used PL/SQL queries for data validation, involved in UAT, executing test cases, evaluating test results and preparing test summary reports.
• Created roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Developed and implemented proactive leave administration processes, programs and communications to improve the management and compliance.
• Administered leave of absences process; coordinated, managed and tracked FMLA, short- term disability, long term disability and company's leaves.
• Coordinate, track and manage all company leaves of absences - including FMLA, state and municipal leaves, company provided leaves, military leave, jury duty, etc.
• Develop and implement proactive leave administration processes, programs and communications to improve the management and compliance.
• Serve as the primary point of contact for all absence inquiries, informing management of the leave process and related policies and procedures.
• Intake of leave requests through HRIS/payroll systems-including sending required notices, forms and letters and determining leave eligibility and leave approvals/denials and re-certifications.
• 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.
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.

Oracle HCM Consultant

Confidential - Westlake, TX

Responsibilities:

• Worked as Oracle EBS consultant for implementing and supporting Oracle R12 Core HR, Payroll, Compensation Work Bench, Absence Management, ESS, and MSS
• Configure new HR and Payroll whenever there's new benefits (i.e. new CBA benefits) including writing fast formulas.

  Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.

• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Develop HCM Extracts/OBIEE Reports/OTBI Analytics for Global HR, OTL & Benefits modules.
• Identified Core HR, Absence Management requirements configured necessary solutions and conducted knowledge transfer sessions with client to support ongoing maintenance.
• Develop HCM Extracts/OBI Reports for Global HR and Debug and enhance workflows, reports/modules/alerts.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Manage Enterprise HCM Information and Legal Entity HCM Information.
• Bridged gap between AS-IS and TO-BE business process flows, integration of process flow diagrams to show end-to-end business model, and process mapping exercise by including swim lanes to distinguish roles and responsibilities.
• Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application by creating functional design for interfacing check and direct deposit output files to a third-party printing service.
• As ADF Developer responsible to create Screens and upgrade Existing as per new requirements.
• Create all required classes that provide the business rules and Create classes in Model layer.
• Implements Control layer to as per design documents which create task flows in ADF.
• Responsible to Fix bugs raised by testing team in ADF.
• Create BPM APIs to add in ADF project.
• Guiding client in change management execution and keeping all the internal stakeholders informed.
• Worked with change request management on new enhancement requests and assigned it to the group responsible.
• Wrote more than 1000 PL/SQL stored procedures, functions and complex views and converted or re-wrote 200 T-SQL stored procedures, functions, triggers and views to PL/SQL.
• Configure custom Workflow routing rules for all Manager self-services and Employee Self-services with help of Area.
• Proficient in defining users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent Programs, Lookup types and defining Value sets.
• 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.
• Re-wrote an inefficient SQL stored procedure that was taking 20 minutes to load a user task list on a web page. This involved creating intermediate tables and the breakdown of the process into very fast and smaller steps; final procedure returned data in 2 seconds.
• Assisted in architect / develop / build and test Enterprise Performance Management (EPM) tools, managing post financial close analytic data.
• Rescued a failing project to build Corporate Services Portal. Normalized database and coded 75 SQL triggers, stored procedures, functions and views to encapsulate data intensive processes. Designed data warehouse for Micro Strategy reporting and used materialized views in the nightly update process.
• Investigating & managing employee FMLA absence & disability claims. Determine eligibility for benefits based on legal regulations (Federal/State) & client policies while meeting timelines.
• Effectively developed direct reports in HR Solution Center which provided payroll, benefits, employee relations, labor relations, compensation, talent management, and HRIS assistance to all employees.
• Drove HR initiatives to align with business strategy and deliver superior service to our field organization.

Business Analyst

Confidential - Seattle, WA

Responsibilities:

• Developed policies, procedures, and standards to supporting and lending to enhancement of business processes and in support of change management.
• Partnered with key stakeholders across the organization to evaluate and document changes in business processes that significantly impacted the end to end process of core applications using Case wise Suite and Microsoft Visio.
• Provided consultation on the use of re-engineering techniques to improve process performance for various teams, target defects to remove waste, and set specifications for automation solutions.
• Created action filters, parameters and calculated fields that combined multiple worksheets into dashboards that handle views more efficiently using Tableau Desktop and Server.
• Define New Users, Responsibilities, Menus, Request groups, Security Profiles.
• Defining the Work Structures (Job, Position and Grade, Location, Business Group. Organization, Organization Hierarchy).
• Reviewed the gathered information and defined the requirements (RD20).
• Mapped the requirements with the standard Oracle HRMS functionality to identify the gaps.
• Prepared the Functional Specifications for the identified gaps.
• Created Elements processing (Various types recurring and non-recurring).
• Define Payroll, Configured Payment Methods, Consolidation sets, and its process, Define Elements, Element Links, and Salary Basis, Salary Administration, Quick Pay and Prepayments Process.
• Creating required setups for Employee Self Service and Manager Self Service Responsibilities.
• Prepare User Manual and End User Training for HRMS, Payroll module.
• Worked on Hiring Applicants and Terminating Employees and Maintaining Salaries.
• Understanding Fusion middleware components such as BPM, BI Publisher.
• Experiencing in Functional Analyzing, Designing, Developing and Implementing Oracle HCM Application.