SUMMARY:

• 7+ years of IT industry experience in ORACLE FUSION HCM including Taleo techno - functional and providing the Architect solution experience in various modules of Oracle.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
• Experienced in moving data between HCM to in-house or third-party vendors using tools such as HCM Extracts.
• Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, Paas, Saas, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Benefits and payroll modules.
• Experienced in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent Management, Performance Management, Goal Management) and Compensation Management (Compensation and Benefits) in version R8 to R11.
• Experienced in loading data into HCM using FBL/HDL and spreadsheet integration.
• Experienced using technical tools and utilities such as SQL, XML, fast-formulas, UDTs
• Extensively worked on inbound and outbound integration tools like HDL, HCM Extracts and BIP for Oracle Cloud HCM.
• Expertise in systems configuration, understanding all steps in the Taleo process, end user test, upgrades, and implementations.
• Expertise in providing the Human Resources department with functional/technical leadership on the more advanced aspects of Taleo.
• 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.
• Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
• Extensive experience in working with business management, end users, SMEs throughout PMLC (Project Management Life Cycle) on requirements, testing and other project related activities.
• Experienced in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent Management, Performance Management, Goal Management) and Compensation Management (Compensation and Benefits) in version R8 to R11.
• Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
• Experience in Creating Reports and Analytic using Oracle HCM Cloud BI.
• Experience in Creating HCM Extracts and Delivery Options for Extracts.
• Experienced in developing HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Experience as Oracle Fusion HCM R12 (Human Capital Management) and Oracle EBS HRMS R12 (E-Business Services) consultant.
• Experienced in developing HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Trained the super users and users on the application and conducting Pilot testing, integrated testing, design validations, setups of the Distributed ERP applications and coordination of UAT.
• Developed functional test plans, coordinates user acceptance testing and guides business users in testing.
• Expertise in writing and modification of Fast formulas used in Oracle Payroll.
• Expertise in Configurations, Personalization, and fusion role based Security, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Pass, Saas, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.

TECHNICAL SKILLS:

Databases: Oracle, DB2 and MS SQL Server.

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder

Languages: SQL, PL/SQL JAVA, HTML, XML

Developer Tools: OBIEE, BI Publisher, OTBI, Toad, Oracle Workflow Builder, SQL Navigator, Forms, Reports, AME.

Oracle Applications: Oracle Fusion HCM 11g, R9, Saas, Paas, R10 and R11 (HR, Oracle Time labor, Payroll, Absence Management), Oracle EBS 11i, R12 (Core HR, Self Service Human Resource, Payroll, OAB, OTL).

Oracle Application Tools: Oracle Application Framework (OAF) 11i, R12, XML Publisher, Web ADI, Fast Formulas, Oracle Cloud version 9, Oracle Approvals Management (AME), Application Object Library (AOL)

Operating Systems: Windows, Linux, UNIX and Mac.

WORK EXPERIENCE:

Confidential, Boston, MA

Oracle HCM Cloud Consultant

Responsibilities:

• Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
• Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
• Designed high level designs and To-Be process flows, identifying integrations with HR and 3rd party applications for Taleo Recruitment Application to Hire covering following areas - Requisition, Candidate - External, Internal and Campus Hire, Candidate Matching and recruitment flow to Hire, Onboarding, Campus Recruitment and Contingent workers.
• Lead and solution architect for Organization Wide Procure to Pay projects; iSupplier, Multi-Sourcing, Global Sourcing
• Provide tailored strategies for process improvement for Cloud client base.
• Oracle Taleo Recruiting Cloud Service training and implementation experience and manage user models across Drive-stream Taleo (TEE) clients.
• Collaborated with the Global Technical Specialist to facilitate SIT and UAT for preparation for Global Taleo upgrade from Taleo 14A to 15A.5.4.
• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• Develop architecture diagram for Taleo Integrations with downstream systems.
• Integration Lead. Conducts POCs, Requirement workshops, requirement sessions for Inbound and Outbound Integrations using HCM Extract and BI Solutions.
• Develop technical design and documentation for Oracle HCM Cloud dependent data conversions, interfaces, custom reporting, and custom applications.
• Responsible for Taleo Recruiting, Taleo Onboarding, Taleo Learn, Taleo Performance, Taleo Connect Client ( TCC ), Business object /OBI reporting.
• Hands on Functional knowledge of Taleo including online configurations, with technical understand of the Taleo architecture.
• Install and build Cisco/Juniper network devices for each build for supporting cloud SaaS, PaaS products.
• Developed HCM Data Extracts in Oracle Fusion Cloud OTBI and Oracle EBS R12.
• Technical expertise in data conversion tools like HDL HCM data loader, PBL Payroll Batch Loader, FBL file based loader, Spreadsheet loader & data loader and developed Integrations/reports using HCM Extracts, BIP.
• Designed HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• Developed process, procedures and training materials for the Oracle Cloud Hosted Operations team, this information was shared out to other Organizations and was housed at a central repository to be used for reference.
• Involved in Paas designing & building HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• 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.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc.
• Implemented Fusion HCM Module and effectively used HCM Extracts, Paas module Fusion BI Reporting Tool and FBL/HDL Loads for Data Migration from apps to fusion and data validation.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Developed HCM Data Extracts in Oracle Fusion Cloud OTBI and Oracle EBS R12.
• Coordinated between Offshore Staff, Developers and Business Units for any updates/fixes needed on Cloud Application Servers and provided support for bi-monthly build release of Cloud Service Offerings.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
• Experienced in moving data between HCM to in-house or third-party vendors using tools such as HCM Extracts.
• Project management activities surround Cloud system development in accordance with Cloud Business Process and Policy.

Confidential, Colorado Springs, CO

Oracle HCM Techno - Functional Consultant

Responsibilities:

• Reduced costs for Oracle HCM implementations/stabilization projects by eliminating the need for third-party implementers/consultants
• Lead the data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM.
• Integration along with ADF, BIP and UCM for necessary information and handling documents for the client.
• Prepared workbooks/configuration templates for Taleo Recruitment and Transitions modules.
• Involved in upgrading of Oracle HCM from 11i to R12 and then implementing Oracle Projects module and Integrating said Projects module with Oracle Financials and Oracle Time and Labor modules.
• Implemented Payroll related setups (Payroll definition, Object groups, Org payment methods, Payment types, Fast formula, third party payment methods, Run Types, Balance Def, element classification, HCM Extract, Payroll work areas etc).
• Undergone Taleo System Administrator training in Taleo Recruiting, Reporting and Learn.
• Manage the network of Taleo users which include; End-user support of Recruiters, Recruiting Coordinators, Hiring Managers, Executives and stakeholders.
• Implemented Oracle Financials R12, AR, AP, GL, Paas, FA, CM for USA in a Multiple-Org, Multi-Reporting, Global Accounting environment.
• Configuration and detailed design review for Taleo Recruitment and On-boarding modules. Reviewed the configuration templates as per requirements.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Manage and support operation on Oracle Apps, Business Intelligence and other reporting tools.
• Worked on the Integration of Oracle Fusion HCM with other modules like Taleo Recruitment and Onboarding.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE's) relationships.
• 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.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Oversee enhancements, troubleshooting and administration for Taleo Recruiting, Onboarding (Transitions) and Onboarding (Legacy) modules.
• Hand on Functional knowledge of Taleo Recruiting and Taleo Learn including online configurations, with technical understand of the Taleo architecture and integrations.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
• Develop HCM Extracts/OBI Reports for Global HR and Debug and enhance workflows, reports/modules/alerts.

Confidential, Greenwood, IN

Oracle HCM Consultant

Responsibilities:

• Generating analyses using OTBI for Global HR, Goal and Performance Management subject areas.
• Developed Traction T2 reports using Business Objects Web Intelligence Reporting tool.
• Scheduling/monitoring ESS jobs and managing Employees, User accounts, User Roles in HCM and OIM.
• Interface between multiple cross-functional teams that includes IT, HR business, InfoSec, Taleo consultants and purchasing.
• Assists with incident submittal & management with Taleo Customer Support and served as an internal knowledge resource for other members of the Taleo organization.
• Work closely with the solutions team and the development team to map client requirements to Taleo standard products.
• Designed HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• Involved in customization of Oracle HR/Payroll (ADP), OAB, SSHR, CWB, OTL, IRC, Performance Management, OLM modules.
• Customized OTBI reports, Payroll Extracts, HCM Extracts to feed the information to third party systems and downstream systems.
• Worked on RICE (Reports, Interfaces, Conversions and Extensions) objects to as per the custom business process within Oracle HRMS implementation.
• Create BIP Publisher data model and reports (BIP) for warehouse management system
• Worked on one of the complex Invoice Report from scratch and built layout using BIP.
• Post production support of Core HR, Self-service applications HR (ESS and MSS), payroll in R12.
• Worked as Oracle functional consultant as part of Oracle Fusion implementation for Core HR Performance and Compensation Modules.
• Worked on Fusion HCM core HR setup and Performance management setup.
• Participated in the testing of data in the PeopleSoft integration and co-existence with Oracle HCM Cloud applications.

Confidential, Santa Monica, CA

Oracle HCM Analyst

Responsibilities:

• Involved in Functional Testing and preparing Test Scenarios, Test Cases and Test Data for Regression and Functional test cycles
• Conducted data mapping and gathered requirements for the custom extensions required to the HRMS applications. Provided requirements for the 'In bound' and 'Out bound' interfaces between HRMS and third-party applications
• Responsible for working with various union groups of the client, understanding their regulations and providing business requirement documentation to the technical team for implementation of corresponding 'person types', 'paygroups', payroll categories', 'salary basis' in Oracle HRMS
• Liaison between several teams to get the business requirements for non-oracle legacy systems and advise on either mapping them to Oracle HRMS or establishing custom extensions to the implementation.
• Creating BIP reports using different data sources. Creating BIP reports using system basic templates as well RTF formatting.
• Assist the testing team to define acceptance criterion & data elements.
• Involved in Performance tuning and optimization of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created Requirement documents like BRD, FRD, etc. depicting business flows & rules, processing-sequences, use-cases & inter-dependencies using UML.