PROFESSIONAL SUMMARY:

• Overall 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.
• 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. 
• 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. 
• Experience in Creating Reports and Analytic using Fusion HCM BI. 
• 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.
• Extensively worked on API's, Alerts, and RICE, Workflow, XML Publisher Reports, SQL Loader utility scripts, JAVA and PL/SQL in writing stored procedures, functions, reports, fast formulas.
• Extensive experience in EXCEL & VBA scripting, used for Oracle data validation.
• Experience of end-to-end HRMS implementations and post-production support and SOX compliance.  
• 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. 
• 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:

Oracle HCM Cloud Consultant

Confidential, Cleveland, Ohio

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 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).
• Developed functional designs in support of global system implementations. Recently completed Oracle HR implementation for Singapore.
• Application SME for R12 technical upgrade (from 11i to R12.2.3).
• 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. 
• 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. 
• Determined all Cloud Global HR and Absence Management requirements for an ERP implementation project where a Mass Global Transfer was to occur. 

Oracle Cloud Payroll Analyst

Confidential, San Francisco, CA

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. 
• 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 
• Analysed 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. 
• 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. 
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports

Oracle HCM Payroll Analyst

Confidential, Buffalo, NY

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. 
• 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. 
• 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, technical specifications and/or product knowledge.

Oracle functional Analyst

Confidential, Purchase, NY

Responsibilities:

• Responsible for the expansion of the Oracle footprint to include the Oracle R12 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 
• 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.)
• 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.