SUMMARY

• An Oracle HCM Consultant with 9+ year of experience as Consultant / Business Analyst and over 5+ years of experience as Oracle HCM Cloud Consultant and specialized in Fusion HCM, ability to configure HR, Oracle Advanced Benefits, Compensation Workbench, Talent and have done Integration with Oracle HCM Cloud, File/Worksheets based loaders for HCM components.
• Proficient in all phases of Oracle Applications implementation with major focus in HRMS of Oracle Applications including Oracle HR, Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• Strong expertise in oracle HCM modules like Core HR, SSHR, Payroll, Oracle advance benefits (OAB), Oracle time and labor (OTL), Compensation workbench (CWB), performance management system (PMS), I - recruitment and Oracle learning management (OLM) Modules.
• Good expertise in HCM Cloud offerings: Global HR, Talent management, HCM Data Loader (HDL), HCM Extracts, BI Publisher and OTBI reports.
• Responsible for integration between Talent Acquisition (Taleo), HR (Oracle), Timekeeping (Kronos), Payroll (Oracle) and Performance (Cornerstone) systems and Learning Management System (Meridian) and oversee delivery of HR-IT projects.
• Oracle Learning Management (OLM), Oracle Advance Benefits (OAB), Oracle Performance Management (OPM).
• Experience in managing HR data requests and Assemble, analyze and format data into usable reports.
• 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.
• Experience in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI.
• 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.
• Implementation and support of Oracle EBS HRMS and Oracle Cloud HCM Talent management.
• Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, PeopleSoft Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.
• Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre-Tax elements, Employer Liabilities, etc.
• Experience of end-to-end HRMS implementations and post-production support and SOX compliance.
• Possess strong knowledge of Quality Assurance and worked closely with QA team on development of test plan, test cases and executing User Acceptance Testing (UAT).
• Expertise in functional areas of Workday HCM Payroll / PeopleSoft Core HR, Base Benefits and Compensation.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of its various methodologies like Waterfall, Agile, Rational Unified Process (RUP) etc.
• Coordinated with Scrum Master for Project Progress and Release Management. Managed Product and Sprint Backlog to achieve the Sprint objectives in Agile methodology.
• Expertise in Workday Functional HCM with responsibilities not limited to Supervisory Organizations, Staffing Models, Job and Positions, Compensation, Defining Business Processes and Security Groups, Customized Report Generation.
• Extensive testing experience on different modules of Oracle Fusion Cloud HCM Applications (Core HR, Benefits, Payroll, Compensation and Talent).
• Experience in developing Reports in Workday Compensation, Benefits and Core HR.
• Experience in developing Custom Reports, Advanced Reports and Calculated fields.
• Proficient in developing Wireframes, Use Cases, Data Flow Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams, Class Diagrams, Entity Relationship Diagrams and Business Process Diagrams.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases to ensure complete and adequate testing as well as coordinating and conducting User Acceptance Testing (UAT).
• Hands on Manual Testing experience on End-to-End testing of different modules of Workday application (HCM, Benefits, Compensation, Time Tracking, and Payroll)
• Expertise in performing Functional, Integration, Regression, System and User Acceptance testing.
• Proficient in HP Quality center for Test Planning, Test Execution and Defect Tracking.
• Proficient in developing test strategy by creating test plans and executing them through various testing cycles.
• Hands on manual testing experience on different modules of PeopleSoft application (Core HR, Base benefits, Compensation, Time and Labor, Payroll).
• Knowledge on Taleo Recruiting & Onboarding modules.
• Excellent communication and presentation skills with ability to effectively communicate to diverse technical and non-technical audience.

TECHNICAL SKILLS

• Benefits
• Payroll
• Compensation Management
• Absence and Time Off
• Time Tracking and Recruiting/Talent Management migration of PeopleSoft HRMS
• EIB Inbound/Outbound integrations
• Workday Studio
• Report Writer and Calculated Fields
• Oracle
• SQL server
• Workday implementations
• Workday business process configurations
• Workday security
• Workday Time Reporting
• Workday HR and payroll domain
• Client and Vendor management
• BIRT Reports
• HDL
• PBL.

PROFESSIONAL EXPERIENCE

Confidential

Lead Business Analyst(Oracle HCM)

Responsibilities:

• Worked with Customer to understand their system requirements. Maps process models, designs technical solutions to satisfy requirements, and completes formal system testing.
• Organized and followed - up weekly meetings of key stakeholders: customers, internal staff and outside providers (scheduling, leading, minutes)
• Identifying resources and scaling up offshore teams, transferring knowledge and mentoring new team members to bring them up to speed.
• 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.
• Collaborating and coordinating with on-site teams, client counter parts to manage project and lead offshore team. Conducting daily team meeting, monitoring shift hand-over process and facilitate weekly project progress meetings with stakeholders.
• Participated in HCM Process Validation Sessions and Design Sessions conducted by the Implementation Partner.
• Involved in End-to-End testing of Global HR, Benefits, Payroll, Compensation and Talent Management.
• Ensured that the application meets the business requirements and system goals fulfil end user requirements, and identify and resolve system issues.
• Worked closely with Business while UAT Testing and involved in preparation of Test scenarios and Test scripts.
• Analyzed City Business Process and identified the Test Scenarios for HCM Modules.
• Mapped the Test Scenarios with existing Oracle Test Scripts.
• Involved in building Payroll ADP extract to pick employee data from HCM and pass it to ADP vendor for payroll processing.
• Prepared Test Scripts Document for all HCM Modules and reviewed with the Customer.
• Involved in Data Migration of the Legacy System and validated the Views developed for Reporting purpose as per the requirements.
• Coordinating with the offshore team on the HCM Functional/Automation QA activities.
• 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.

Confidential

Oracle HCM Consultant

Responsibilities:

• Configure, Validate, Manage and Administer Workforce Compensation plans Performed gap analysis FEDERAL CREDIT UNION PHOENIX, AZ between business requirementsandFusion.
• 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.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR Develop HCM Extracts/OBIEE Reports/OTBI Analytics for Global HR, OTL & Benefits modules.
• 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.
• Prepared functional designs for Core HR, Payroll and SSHR and prepared test cases for Payroll, Core HR and SSHR.
• Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates
• Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info...etc.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows etc.
• Develop End user training material to helping them understand the functionality of the tool and Managed Delivery and Deployment of Oracle Benefits and Compensation Workbench FastFormulas.
• Configure custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.
• Developed Manager Dashboard with OTBI report for WF compensation budget management and promotion disqualifications.
• Involved in Design, Document and Perform Unit Testing to validate product functionality and Proficient in managing Sandbox for personalization and Interpreted various geographies, action reasons, content types, context, flex fields, jobs and department setups.
• Computed datasets for prior years was retrieved using a complex feature of BIP and compared against current year.
• Driving and documenting business requirements and procedures, obtain sign off to ensure Client alignment of proposed solution and Worked on Oracle HCM modules Core HR, SSHR, Performance Management, iRecruitment and Compensation Workbench.
• Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance and Experience in Creating BI Reports, Analytic & Dashboards using Fusion HCM OBIEE.
• Involved in following HCM Modules implemented: Core HR, OAB, Payroll, OTL, OIC and Employee Self Service. implementation of Core HR, Self Service HR, iRecruitment and Daily Business Intelligence for a prominent technology company.
• Prepared and delivered demos and documentation on Oracle’s HCM Applications to current and prospective clients with audiences including executive management, human resources, and IT staff.
• Created custom BI-reports and OTBI Analysis as per the businesspeople requirements on benefits, payroll, Core-HR and Implemented Manager Self Service, Employee Directory and enhanced Employee Self Service
• Created Good Knowledge on the Subject Areas and Tables in Core HR, Payroll, Compensation and Worked on Payroll and Core HR Data migration from People Soft.
• Experience in Inbound Integration procedures using HDL - HCM Data Loader, & PBL.
• Uploading Payroll data using HDL and PBL.
• Excellent experience in Data loading into Oracle HCM Cloud using SQL Loader, FBL, HCM Data Loader which includes the major worker data business objects and PBL.

Confidential - Rochester, New York

Oracle HCM Analyst

Responsibilities:

• Oracle Fusion HCM Cloud responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
• Complete understanding of Oracle Apps Implementation and Upgrade Projects. Performed several end - to-end implementations, upgrades as well as conducting conference room pilot (CRP), providing post production support, end user training and documentation.
• Conducted CRP1 sessions to demo the out of box functionality on Oracle EBS Core-HR, Payroll and Performance Management modules.
• Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, PeopleSoft Payroll Interface and Fusion Benefits.
• Implemented Core HR-HCM, Performance, profile, Goal, Time and Labor & Benefits module and Taleo Recruit related all the transaction like Transfer, Termination, Promotion etc.
• Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them to Oracle HCM Cloud functionality.
• Involved in the Integration & support to ADP applications used by client (e-TIME and Payforce) with Oracle.
• Developed functional designs in support of global system implementations. Recently completed Oracle HR implementation for Singapore.
• Configurations related to Absence Management and Talent Management.
• Identified business requirements for Core HCM, Absence, compensation, Performance and map them to Oracle HCM Cloud Application functionality.
• Conversant with Oracle e-Business Suite - Core HR, Payroll and HR Self-Service, Oracle HCM cloud - Core HR modules with expertise in providing functional solutions for Oracle Applications and technology-based solutions for enhancing functional efficiency of the organization & achieving business excellence.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
• Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement enhancements.
• Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at APM, OIM and Security Console.
• Developed OTBI reports for HR users to view and validate employee data using existing subject areas.
• Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
• Expertise in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Payslip, W2 and government reports for Oracle Payroll.
• Expertise in writing and modification of Fast formulas used in Oracle Payroll.
• Experience in configuring and set up of OBIEE Security configuring object level and database level security.
• Managed configurations, process mapping, and issue remediation for Core HR, Employee/Manager Self Service, and Absence Management in an implementation and Provided functional design for all Absence Management Fast Formulas.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Performed maintenance on existing HCM configurations and worked with the users and define standards on using Descriptive Flex fields from reporting and integration perspective.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.

Confidential - Minnetonka, Minnesota

Oracle HCM Analyst

Responsibilities:

• Transition of benefits administration from Oracle Advanced Benefits to third party administration in time for Open Enrollment.
• Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB and OAB.
• Worked with development to design data extracts for data conversion and daily FTP data feed to TPA, modifying HR ADP views to prevent element entries from transferring to payroll system.
• As primary HCM resource identified business requirements and performed tasks required for configuring Oracle HR.
• 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.
• Configure new HR and Payroll whenever there's new benefits
• Set up payroll elements, element links and grades required for salary entry; created Extra Information types and elements to accommodate various allowances and data points.
• Coordinated user testing; worked with DBA's and Developers to facilitate transition of interfaces for Payroll and benefits to pristine environment.
• Working with ADP resources to upgrade payroll software from PCPW to Payforce and provided support for Payforce, ETime and ADP Connection.
• Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.
• Worked with user's team to resolve pain points with the HRMS application.
• Worked on Log Service Requests (SR/TAR) and implemented solutions by Oracle support.
• 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 with TOAD, writing SQL queries to drill down for issues.
• Expertise in Oracle Payroll compensation management, Salary review, and designing of especial earning rules using Fast formulas.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
• Manage Enterprise HCM Information and Legal Entity HCM Information.
• 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 cartridge, JavaScript, 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.
• 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.
• Use Oracle Functional Setup manager (FSM) to implement Global HR, Payroll, Benefits and Compensation Management.
• Serves as the compensation workbench analyst for support organization
• Expertise with Human Capital Management, Benefits, Compensation Workbench applications.
• 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.

Confidential - Chicago, Illinois

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro
• Successfully coordinated to design and document Business Requirement Documents, Functional Specifications and Technical maps for Asset Management stream.
• Documented "As - is" and "To-be" process maps as part of Gap Analysis for new functionality requirements, and thereafter prioritized them in order to align them with the project requirement.
• Developed and circulated Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Planned and managed counterparty credit risk technology and process improvement Tracked and monitored credit risk position, reporting exposure to management, quarterly.
• 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.
• Supported other business analysts in conducting Feasibility and Complexity Analysis to recognize technically functionalities of the project, and determine the level of effort (LOE) needed to attain them.
• 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.
• Collaborated with product owners to write up and prioritize customer centric documents like User Stories for Product Backlogs.
• Arranged to document Sprint Backlogs to identify and monitor the activities performed in the time boxes.
• Created User Interface document (UID), Wireframes, and Prototypes to help developing user interfaces.
• Formed Burn - Down Charts to track the completion of work within the sprint.
• Participated in daily stand-up meeting and worked closely with the team in resolving issues that could potentially cause delays in the sprint completion.
• Provided walkthrough to both developers and testers to develop Test Case scenario from user stories.
• Sound knowledge in workforce compensation plan with multiple complex Incentive plans and salary plan including merit and promotions.
• In Non-Prod environments, involved in configuring eligibility profiles, elements, user-defined tables, value sets & values, flexfields, global settings and compensation history
• Sound knowledge on complex Fast Formulae used in compensation and talent.