SUMMARY:

• 7+ years of IT 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.
• 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 HCM Extracts and Delivery Options for Extracts and good in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI.
• 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.
• 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.
• 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.
• 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.
• Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre-Tax elements, Employer Liabilities, etc.
• 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 and diverse work experience on Unit Testing, Functionality, Integration, GUI, System, Regression compatibility and UAT Testing.
• 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).

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle HCM Cloud Consultant

Responsibilities:

• Oracle Fusion HCM Cloud responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
• Worked with the business and users to understand the existing Talent management system and translates the requirements to be implemented to the Taleo system
• Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12. 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 (11i and R12).
• Application SME for R12 technical upgrade (from 11i to R12.2.3) and 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 R12 - 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.
• 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.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Worked in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
• Worked on Data migration includes from SQL Server to SQL Server, SharePoint document library to SQL Server, and Excel to SQL Server.

Confidential, San Francisco, CA

Oracle Cloud Payroll Analyst

Responsibilities:

• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• 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.
• 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
• 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
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management, Compensation STIP plan.
• Responsible for implementation of HCM Cloud 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).
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
• Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations with SME's and to understand thoroughly the business process and the interface requirements, which need to be incorporated in the application. Created and executed various the Test Cases Wrote Test Scripts, Did UAT and a part of Manual Testing.

Confidential, Buffalo, NY

Oracle HCM Payroll Analyst

Responsibilities: -

• Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Prepared functional designs for Core HR, Payroll and SSHR and Prepared test cases for Payroll, Core HR and SSHR and tested XML for core HR and Payroll.
• 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 and 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 and worked in Oracle Payroll compensation management, Salary review, and designing of especial earning rules using Fast formulas.
• Managed Enterprise HCM Information and Legal Entity HCM Information and configure new HR and Payroll whenever there's new benefits (i.e. new CBA benefits) including writing fast formulas.
• Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
• Provide Analysis in identify SQL code logic to trouble shoot application errors at different intervals.
• 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 knowledge.

Confidential, Richfield, Minnesota

Oracle Functional Analyst

Responsibilities:

• Responsible for the expansion of the Oracle footprint to include the Oracle R10 HCM modules throughout the business.
• Gathered technical requirements, drafting tech documents for development team and managing team through to delivery.
• Demonstrated the integrated solution offered by Oracle Talent Management modules and created Impact Analysis documentation to address issues with moving to new HCM platform
• Consistently delivered projects on time and under budget, Oracle Payroll production support
• Develop and implemented plans for formal testing events (Conference Room Pilots, User Acceptance Testing, etc.)
• Developed SQL scripts for identifying the test population while assisting data enterers with test data input.
• Worked on Queries related to database size, space related queries and database version
• Created Database objects like views, columns and tables as per requirement
• Developed functions, Stored Procedure and Triggers for Validation
• Developed relevant queries to get ad hoc data required by various Oracle users such as payroll, operations, tax and compliance in a techno-functional support role for both Oracle Payroll and OTL.
• Created SQL scripts to automate the manual process
• Troubleshoot issues on various applications, database and report server errors
• Created Database Users, Roles and manage Security issues
• Review Manual Test Strategy document for entire application.
• Developed Test cases based on requirements gathered from Functional Specifications and Design documents.
• Worked on Software Development Life Cycle (SDLC), Agile and Waterfall Methodology.