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.
• Experience in applications development, design, requirement gathering, testing, support of (FMW), SOA Suite, OSB,OracleERP,OracleFusionMiddleware,OracleIntegrationCloud(OIC) services, andOracleService Bus (OSB) OracleSOAcloudenvironments.
• Experience in Business Intelligence reporting tool likeOracleCloudOTBI,OBIEE, BI Publisher andFinancialReporting Center Tool (Smart View).
• 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 in CustomizingCloudHCMSecuritycomponents like Data Role, Job Role, Duty Role,SecurityProfiles, Abstract roles and well versed with aggregate privileges and assigning duty roles.
• 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.
• 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

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr Oracle HCM Cloud Consultant

Responsibilities:

• Responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
• Designed complex custom algorithms and Integrations between EBS andOTM. These algorithms would derive the type and number of cartons to be used while packing the Items, which will help business in avoiding charges by Govt and other private customers.
• 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.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites
• Designing Reporting requirements for OTBI, BI andFinancialreporting Studio.
• Performed systems analysis, design, installation, maintenance, and enhancement for mission critical applications within the FusionSCMmodules.
• Designing and developing integrations in OIC toOracleERPCloudincludingDesign and develop customizations using Visual Builder and Process Builder in OIC toOracleERPCloud
• WorkedSecurityConsole toOracleHCMCloudwhich includes Create/Modify Data roles and itsSecurityProfiles, Job Roles, Application Roles and Duty Roles.
• Developed OTBI reports for HR users to view and validate employee data using existing subject areas.
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Developed custom reports using Business Objects in Oracle-Taleo for leadership, human resources, and talent acquisition teams.
• Created OTBI, and Simple BIP reports using Data Models, Subject Areas, and Analysis inOracleCloudSCMmodules (R13) Version.
• ProvidingSCMmodules "Procurement, Cost management, and OM" training to freshers and Business Users.
• Design and develop integrations in OIC toOracleERPCloudincluding extractingOracleERPClouddata using BI-Publisher reports, analysis and OTBI Reports.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Configured eligibility profile/rules in OAB, developed test cases and executed specific test scenarios, wrote test scripts and guided users through testing cycles.
• Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.

Environment: OracleApps R12, PL/SQL, TOAD, SQL, SQL*LOADER, Reports10g, Forms10g,Oracle11g, BI Publisher (XML Publisher),OracleWorkflow Builder 2.6.

Confidential, CA

Oracle cloud consultant

Responsibilities:

• Performed various individual balance adjustment for scenario such as, Bonus Overpayment, Vacation Payout, and employee getting paid even after termination, recording off cycle payments in Oracle.
• Developed and performed conversion reconciliation between Legacy and ORACLE/ADP.
• Developed, configured and implemented solution in accordance with the client's business requirement within Oracle HCM Cloud.
• Worked on designing and developing integrations in OIC toOracleERPCloudincluding making REST and SOAP calls, extractingOracleERPClouddata usingBI-Publisher reports, analysis and OTBI Reports.
• Developed Delivery Order Integration in OICS to export the EBS Delivery toOracleOTMCloud
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Provide hands-on technical and development support for implemented customizations using Visual Builder and Process Builder in OIC toOracleERPCloud
• Created reports usingFinancialReporting Studio (FRS), Smart View, andOracleTransactional Business Intelligence (OTBI).
• Worked on providing hands-on technical and development support for implementedOracleERPCloudmodules
• Designed and developed third-party integrations. Provided solution and implemented setup for state level costing.
• Payroll Conversions, including calculation cards of Tax Withholding for Pension and AnnuityPayments.
• Developed and implemented custom and standard OTBI reports to support HR management and staff.
• Created multiple Questions and Questionnaire templates for Disqualification,Prescreening, Interview feedback template and Candidate Interview ScheduleTemplates
• Prepared configuration workbooks for FusionHCM, entering the data, and doing transaction testing for the same in the application
• Documented detailed test cases for HR Core module by incorporating both positive and negative condition in test plan tab
• ImplementedHCMcloudinbound integrations usingHCMData Loader (HDL),HCMspread sheet loader (HSDL), ADFDI.
• Responsible for maintaining Issue log, bug fixes for system issues and finding resolution for the same during the Configuration, UAT and production phase.
• Work with consulting partners on the Conversion tasks, Integration tasks,Securitytasks, and Reporting tasks.
• Developed training programs for users (e.g., recruiters, hiring managers, HR) to ensure efficient use of the systemSet up new users, conducting end user training, creatingOracleSR’s
• Gathered business requirements using standard questionnaire and performed fit-gap analysis by taking feedback from the business users iteratively

Environment: OracleApps R12, PL/SQL, TOAD, SQL, Reports 10g, Forms 10g,Oracle10g,OracleWorkflow Builder 2.6

Confidential, Irving, TX

Oracle consultant

Responsibilities:

• UsedOracleFusion Functional Setup Manager (FSM) to implement Global HR andTalent
• Involved in the creation of Implementation Users, identifying data roles, Load/Manage Geographies
• Provided system functionality demos to clients, stakeholders and teammates
• Exposure in the areas of Business Analysis,ERPSystem Design, Implementation,Testing and Support
• Involved in data conversion and validation activities for employees (Active, Terminated and Retirees) across different countries.
• ImplementedHCMcloudoutbound integrations usingHCMExtracts, BI Publisher(BIP) reports and Oracle Transactional Business intelligence (OTBI) and web services (API’s).
• Developed Fast Formulas forHCMExtracts.
• ImplementedOracleTime and Labor 12.1.3 (OTL) andOracleTime Management 12.1.3 (OTM) for US Business Group.
• Data Loading/Conversions/Integrations usingFinancialBased Data Import (FBDI) which includes the payables data, Supplier data, Customer relationships data,
• Work with third-party systems and vendors that require integration withOracleFusionCloud. I have been provided the Training to END Users and Configurations and Setups inOracleCloudSCMmodules (INV, PO & OM):
• Responsible for HR System maintenance includingsecurity, tax updates and patches, setup and configuration of PeopleSoft
• Research and review all existing OTBI/BIP reports and compile a comprehensive inventory of all reports for several departments and perform Fit Gap Analysis.
• Extensively involved in converting, loading, and validating Enterprise structures, Workforce structures and Worker data.
• Handled post load data reconciliation activities comparing legacy system andHCMcloud.
• Worked with business users over post error and data reconciliation issues to identify root cause and fix issues for next conversion cycle.
• Repeated data conversion activities over several cycles to ensure 100% data quality.
• Worked onHCMobjects related to Core HR, Payroll, Employee Self-Service (SSHR), Manager Self-Service, Goals and Performance management
• Worked on Payroll objects (Element entries, Calculation cards, Personal payment methods, external bank accounts, Banks and Branches).
• Performed new hires, terminations, salary changes, promotions, deductions and bonus pay outs.
• Supported required periodic reconciliations of all payroll tax liabilities paid by the employer and third-party payroll tax administrator, employer and employee

Environment: OracleApps, PL/SQL, TOAD, SQL, Reports 10g, Forms 10g,Oracle10g

Confidential, Tempe, AR

Business analyst

Responsibilities:

• Involved in end-to-end test cycles and prepared the test scripts and scenarios required to test various business cases.
• Involved in Regression testing of multiple offerings.
• Tested all the tasks and business process flows related Payroll, Global HR and Talent Management.
• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Work with consulting partners on the Conversion tasks, Integration tasks, Security tasks, and Reporting tasks.
• UseOracleFusion Functional Setup Manager (FSM) to implement Global HR.
• Worked on several reports usingOracleReports and XML Publisher report acrossHR, BEN and Pay to meet business requirement.
• Created various Database triggers using PL/SQL.
• Worked on Inbound interfaces based on the client requirement.

Environment: OracleApps 11i, TOAD,Oracle10g, SQL*Plus, PL/SQL, Reports 6i, XMLPublisher.