SUMMARY

• Around 8+ 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.
• CreatedOTBI, BIP reports for employee hire and employee transfer reports.
• Good experience coordinating with Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
• 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.
• 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).
• Experience inSupplyChainManagement, e - Commerce, Management Consulting and Information Technology.
• 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.
• Experience in all phases ofERPlifecycle Implementation, Conversion, Upgrades, Interfaces, Production support and troubleshooting.
• 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 and fast formulas.
• Full Life Cycle implementations of Global HR and Talent modules and support experience for Benefits and Payroll modules.
• Debug and fixed Oracle FAST FORMULAS used to facilitate to calculate the employee PTO accruals.
• Expertise in identifying functionality gaps and builds extensions.
• Participated in implementation ofERPsystem and integrated with different Systems like Oracle HRMS and Oracle Payroll.
• 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.

TECHNICAL SKILLS

• PL/SQL
• Java
• Oracle Forms 4.5 6.i 9i
• Oracle Reports 3.0 6i 9i
• Oracle Portal 3.0
• UNIX
• Shell Script
• Peoplesoft
• Oracle Cloud R11
• Oracle Identity Manager
• Oracle HCM
• WSDL
• SOAP
• UDDI
• Oracle BI Publisher
• Oracle Fusion HCM
• Oracle HCM Data Loader
• Oracle 10.2.0.2 R12 11i (Financial)
• Oracle EBS - R12
• Oracle Workflow 2.6.3.5 DBA Studio
• RMAN
• SQL* PLUS
• Developer 2000
• Erwin
• TOAD
• Testing (UAT/Unit)
• SQL Navigator
• Reflection for Unix
• Tarantella
• Data Loader 5.4.1.0
• PL SQL based extensions (RICE objects).
• ERWIN7
• SaaS
• PaaS

PROFESSIONAL EXPERIENCE

Oracle HCM Cloud Consultant

Responsibilities:

• Designed Functional specifications for extensions and customizations for I recruitment, Payroll, OAB and Performance Management.
• Use the REST API for Oracle Integration to automate business processes, integrate applications, and publish raw business events to an Integration Insight server.
• Developed Oracle FusionBIReports,OTBIand HCM Extracts, custom reports and Benefits interfaces using integrated oracle Business IntelligencePublisher(BIP) and HCM Extracts.
• 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.
• Worked onsupplychainmodules such as Procurement, Order Management and Inventory during Conversion and Configuration Migration for Client projects
• Developed complex reports usingOTBIandBIPublisherfor Global HR, Payroll, and Benefits.
• 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.
• Developed newBIreports to extract the absence details and related other reports.
• 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.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management and Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor and 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.
• Coordinate with the Director ofSupplyChainon forecasts and inventories, planning and implementing logistical strategies, ensuring targets are met, overseeing product storage, handling
• Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
• 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.
• Involved in extensive Data validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• 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.
• 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.

Confidential, Austin, TX

Oracle Cloud Payroll Analyst

Responsibilities:

• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Created roadmap document as well as migration guide for Absence and Time and Labor module.
• 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 writing interfaces using HCM extract and BI publisher to move data between oracle cloud and external systems like ADP.
• Worked on Converting Crystal toBIPublisherreports.
• Setup approvals, Individual compensation plans, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, performance ratings, Workforce compensation approvals and Total Compensation Statements.
• Ensured that the application meets the business requirements and system goals fulfill end user requirements, and identify and resolve system issues.
• Implemented Core HR, SSHR, Payroll, Benefits, Compensation, Talent Management and Taleo Learn in a SAAS on - premise and Cloud environments.
• 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.
• 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.
• Expertise with Human Capital Management, Benefits, Compensation Workbench applications.
• Experience in Customizing Cloud HCM Security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract roles and well versed with aggregate privileges and assigning duty roles.
• Extensively involved in Enterprise level design sessions and helped in HR and Payroll one-time setups and Involved in third party integration to and from Cloud HCM.
• 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 fulfill 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.

Confidential, Costa Mesa, CA

Oracle Business 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), I Recruitment and Performance Management (PMS) modules to map the business requirements into Product functionality.
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of paycheck distribution
• 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.
• 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.
• Analyzed and Resolved production support issues in PeopleSoft, 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 and Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor.
• Worked on Oracle support for Oracle HR, Payroll and OTL Time and labor.
• 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.