Fusion Hcm Techno Functional Consultant

Siva Prasad Chandrakantham

Oracle HCM Techno functional Consultant

Cell : +1-669-***-****

Email: ****.**********@*****.***

Professional Summary

18+ years of IT experience in enterprise-wide EBS and Oracle Coud applications design, development, system analysis, testing and deployment

Expertise in Implementations, Production Support for Core HR, SSHR, Payroll, Benefits, Absence, OTL and ORC modules

Implemented Fusion HCM by leveraging HCM Extracts, HDL, HSDL for data migration.

Developed custom BI, OTBI reports for data extraction and validation.

Experience in building Interfaces for integration, Customizations, Extensions and Workflow objects as per the business requirements

Expertise in extract and identifying the data according to the source to target mapping and determine the transformational logic needs to occur.

Well-acquainted in working with complex SQL queries and having knowledge of OIC tool.

Extensive experience with all phases of the Software Development Life Cycle including analysis, planning, code development, testing, implementing and maintenance.

Proficient in Alerts, Workflow transaction console setup for managing Approval Authorities and Business Flow.

Highly motivated, excellent team player, enthusiastic and quick learner of new technologies.

Educational Qualification

Education: Bachelors in Electronics and Communications

Completed: B.Tech in April, 2004

Skillset:

Application

Oracle Fusion Cloud HCM, Oracle EBS, Core HR, Benefits, Payroll, OTL, Absence, ORC

Languages

SQL, PLSQL, Java, Unix Shell Scripts

Reporting Tools

Discoverer, Forms, Reports, SplashBI, OTBI, XML/BI Publisher, Fusion HCM Extracts

Utilities

TOAD, OIC, SFTP, WinSCP, WEB ADI, Workflow, Page Personalization, Fast Formulas, HDL, HSDL, SQL Loader

PROJECTS PROFILE:

Employer: Delta Dental of California

Dates of Employment: 12/09/2019 – Till date

Project Name

Delta Dental Cloud HCM Implementation, Enhancement and Support

Role

HRIS Techno functional Analyst

Environment

Oracle EBS, Oracle HCM Cloud, Core HR, Benefits, Payroll, ORC, OTL, Absence, Fast Formula, HDL, HSDL, HCM Extract, OTBI, BI Reports, Transaction Console

Project Description:

Delta Dental is the leading provider of dental insurance organization. Through the national network of Delta Dental legal entities offers coverage across the country, providing groups and individuals with quality, cost-effective dental insurance and superior customer service. Have implemented Fusion HCM migrating from EBS to Cloud modules for leveraging latest tools and technology of the system

Responsibilities:

Liaise with business stakeholders in understanding & analysis of requirements for coding, configuration, testing and roll out.

Partner with several cross functional streams to uncover, evaluate and resolve data problems, identifying root cause and making recommendations for long-term solutions in fusion HCM

Conduct regular system audits to maintain data integrity for avoiding downstream impacts

Perform responsibilities supporting both project work and run the business activities

Techno-functional expertise for ongoing production environment support, work on enhancements and troubleshoot the break/fix issues

Coordinating with TA team for completing ORC related activities

Monitor cloud to EBS payroll interface and assist with troubleshooting for resolving the system and interface fallouts.

Developing custom interfaces, reports using BIP, OTBI, and SQL/PLSQL queries for data extraction and validation.

Exposure in Fusion BPM, OIC, managing workflow configurations in transaction console work area.

Process mass updates using HDL, HSDL loader for various objects.

Participate in quarterly upgrade release tasks, regression, integration testing, redwood migration and impact analysis

Research, analyze Oracle SRs and resolving Help Desk service requests and performing miscellaneous duties as assigned

Employer: Zillion Technologies Inc.

Dates of Employment: 10/18/2017 – 11/30/2019

Project Name

Delta Dental Fusion Cloud Implementation

Location

Oakland, CA

Role

HRIS Techno functional Analyst

Environment

PL/SQL, Oracle EBS, Fusion HCM, Core HR, SSHR, Payroll, OAB, Fast Formula, HDL, PBL, HCM Extract, OTBI, BI Reports

Project Description:

Delta Dental is the leading provider of dental insurance and a not-for-profit organization. Through the national network of Delta Dental companies, it offers coverage across the country, providing groups and individuals with quality, cost-effective dental insurance and superior customer service. Company has taken HCM co-existence route in order to avoid the complete reimplementation of existing system and also to integrate with the EBS system.

Responsibilities:

Development of technical components and supporting the application as per the business requirement.

Work structures setup based on the PADE form submitted by the business users.

Serve as a primary partner to finance and business leaders in managing enterprise position control.

Development of data extraction code to migrate various entities from EBS to Cloud, and also involved in data mapping activities, development of custom integration code for the data synchronization.

Development of various BI Publisher and OTBI reports as per the business need.

Running the pre and post comparison in order to reconcile the data between source and target systems.

Coordinating with Business users to analyze the issue or requirement and come up with the resolution.

Creation of SRs through Oracle Support, search Oracle’s knowledge base, interact in support communities and take advantage of proactive capabilities to resolve the issues identified in the system.

Project Name

Loudoun County R12 Implementation and Support

Location

Leesburg, VA

Role

Techno Functional Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, Core HR, Payroll, OAB, OTL, XML Reports, Fast Formula

Project Description:

Loudoun County has been implemented with Benefits, Time and Labor, iRecruitment, Payroll and Learning Management. Project management support has been provided for Human Resources initiatives, including technical support for the implementation of the County’s new Oracle Enterprise Resource System.

Responsibilities:

Development of technical components (RICEW) as per the business requirement.

Development of user defined functions to be used in the customization and creation of new fast formulas as per the requirement outlined in the functional document.

Preparation of TDD and FDD and ensure that all the aspects of the requirement have been taken care of in the documents.

Investigating the tickets in HRMS that are logged by users through LanDesk to provide the appropriate fix.

Coordinating with Business Systems Analysts to identify and research the functionality required to meet business user’s needs.

Creation of SR’s through Oracle Support, search Oracle’s knowledge base, interact in support communities and take advantage of proactive capabilities to resolve the issues identified in the system.

Employer: Vigilant Technologies LLC

Dates of Employment: 02/11/2016 – 10/17/2017

Project Name

Cummins Western Canada ADP to R12 Conversion

Location

Columbus, IN

Role

Techno Functional Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, HCM, ADP

Project Description:

Cummins, Inc. is an American fortune corporation that designs, manufactures, and distributes engines, filtration, and power generation products. As part of the CWC data conversion project, Western Canada Distributors data (i.e. employee, assignment, salary, elements etc..) need to be loaded into the Cummins Oracle HR system.

Responsibilities:

Development of technical components as per the business requirement.

Developed control files for SQL* Loader and PL/SQL code for Data Extraction, Transformation and loading data into custom tables (Staging area) from ADP system( WFNow ) and API validation for data load into the Oracle HCM application.

Peer review after components build and preparing the Unit Test case Documents.

Interacted with users and business analysts to resolve the issues identified during the development and data load in CRP, UAT in both Technical and Functional aspects.

Co-ordinate with the Business Analysts and developers and do the Impact analysis.

Project Name

American Airlines R12 Support and Enhancement

Location

Phoenix, AZ

Role

Techno Functional Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, Core HR, Payroll, SSHR, CWB, XML Reports

Project Description:

American Airlines Group, Inc. is an American publicly traded airline holding company headquartered in Fort Worth, Texas. It was formed in the merger of AMR Corporation, the parent company of American Airlines, and US Airways Group, the parent company of US Airways. US Airways was implemented with R12 HRMS and the raised issues need to be addressed as part of production support.

Responsibilities:

Working with Business Systems Analyst to identify and research the functionality required to meet business user’s needs.

Developing Outbound interfaces using PL/SQL which generate the required files and data for the external systems.

Scheduled and executed the design, implementation and unit test of new development, enhancements, bug fixes and production updates.

Creation of an RFC to schedule the deployment in Production.

Suggest alternatives and work-around to problems being faced by the user and see thru to resolution.

Developed shell scripts to send out automatic notifications in case of errors in order to reduce manual monitoring.

Monitoring the scheduled UNIX shell scripts run and take necessary action in case of glitches.

Employer: Tech Mahindra

Dates of Employment: 07/27/2012 – 07/06/2015

Project Name

ARM (African Rainbow Minerals) R12 Implementation

Client

ARM, South Africa

Role

Techno Functional Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, Core HR, SSHR, OAB, Payroll, Reports 10g, OAF, XML Reports, WEBADI, Fast Formula

Project Description:

African Rainbow Minerals (ARM) is a company incorporated in the Republic of South Africa to supply raw material to the world's steel mills and alloy plants. ARM has implemented Oracle E-Business Suite for automating the HR and Payroll functionality for their operations viz. Khumani(Ironore mine), Beeshoek(Chrome mine), Black Rock(Manganese mine) and Lubambe (Copper mine). Although each division operates independently, together they strive to achieve optimum efficiencies.

Responsibilities:

Design, Develop, Test and Migration of Custom HR Web ADI for Contingent Worker Mass Upload.

Development of new custom Reports, Alerts, Interfaces and Conversions and data migration into system as per the client requirement.

Worked on conversion of Jobs, Positions, Competences, Competence Requirements, Address, Supplier and Site, Eligibility Profiles, Objective Library, Special Information Types, Extra Information Types, Personal Payment Methods, Elements etc. using Oracle seeded API’s.

Defined Forms Personalization on different screens as per client requirement.

Responsible for preparing the functional and technical specifications for the RICEW components.

Designed Contingent Worker hiring and termination process, Absence overlap User hook, Position profile report, Job profile report, Costing Details Report, Contingent Worker Termination Details Report.

Configured and documented HRMS security setups including Responsibilities, Request Groups, Custom Forms, Task flows, Menus, Functions and Security Profiles.

Involved in the development and implementation work for an Absence and Enhanced Retropay to turn the business requirements into a configuration solution. This work included configuring Enhanced Retropay including Retro Elements, Element Links, Event Groups and Table Event Updates.

Project Name

The Farrer Park Group R12 Implementation

Client

TFPG, Singapore.

Role

Technical Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, Core HR, Payroll, OTL, GL

Reports 10g, XML Publisher, AME, Fast Formula

Project Description:

The Farrer Park Company, a group of private medical and hospitality specialists, has chosen BT to be its IT partner for Connexion at Farrer Park, Singapore’s first integrated healthcare and hospitality complex. BT will design, build, and support the entire facility’s technology and applications architecture, bringing together multiple business applications such as the finance and human resources systems, customer relationship management, hospitality management and healthcare information systems.

Responsibilities:

Preparation of TDD and FDD and ensure that all the aspects of the requirement have been taken care of in the documents.

Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.

Participated in detailed Payroll requirement information gathering needed for Reports Customization

Maintenance of Employee Information through Oracle Apps including Personal Details, Educational Qualifications, Skill Profile, Work Experience and Joining Data.

Worked on Conversions for Employees, Competences, Competence Requirements, Extra Information Types, Personal Payment Methods and Elements.

Development of XML Reports like Journal Voucher Report, Absenteeism Analysis Report etc. and Interfaces like GL interface, AP Invoice interface, Timekeeper entry interface etc.

Created custom time entry rules to validate the time card, Approvals to send the time card for approval and various notifications to notify the managers and employees about the timesheet.

Person, Address, Phones, EIT, Contacts, Assignment, Salary, Elements, SIT, Benefits, Taxes and Direct Deposit data is loaded in a single stretch using the Web ADI loader.

Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.

Employer: Capgemini India

Dates of Employment: 10/04/2010 – 07/02/2012

Project Name

McKinsey & Company R12 Implementation

Client

McKinsey & Company, US.

Role

Technical Consultant

Environment

Linux, PL/SQL, Oracle Applications R12, GL, PA, Core HR, Payroll, AP, Reports 10g, Workflow

Project Description:

McKinsey & Company, Inc. is a global management consulting firm that focuses on solving issues of concern to senior management. McKinsey serves as an adviser to many businesses, governments, and institutions. It is recognized as one of the most prestigious firms in the consulting industry. Earlier they were on EBS 11.0.3 and to meet organizational requirement EBS R12 has been implemented.

Responsibilities:

Development of RICEW objects as per the received MD50 requirement.

Creation of event based and periodic alerts using Alert Manager.

Preparing the Technical Design Documents and Test Checklists.

Analysis and implementation of new business requirement and Quality adherence as per Client and Capgemini standards.

Defined Form Personalization on different screens as per client requirement.

Worked on conversions like Employee, Event, Project, Expenditure Items etc. and interfaces like Auto creation of Employee as Vendor, Bill Rate interface, WIP Interest, PA Labor Billing and Costing extensions.

Assisted functional team and end user for Payroll Pre-processing, Payroll Processing, Process Payroll Using subsets, Elements creation, Payroll Post processing, Costing, Year End Process, NACHA, Deposit Advices, Direct Deposit, Adjust Balances, Check writer, Quick pay, Rollbacks, Retries, Reversals, Run various reports.

Designed technical specifications for out of box technical components such as a) alerts b) AME c) OA Personalization d) Reports (PL/SQL, Discoverer & XML Publisher) e) Workflow

Assisted end users with documenting new business procedures and test scripts for CRP & UAT

Employer: Logica Pvt Ltd

Dates of Employment: 05/05/2008 – 10/01/2010

Project Name

BAA Oracle Applications Support and Enhancement

Client

BAA (British Airport Authority), UK.

Role

Technical Consultant

Environment

Linux, PL/SQL, Oracle Applications 11i, Core HR, Payroll, PO, Reports 6i

Discoverer, OAF, Workflow, Fast Formula, PVCS Tracker, Version Manager, HPOpen View

Project Description:

BAA Airports Ltd. is the owner and operator of six British airports and the operator of several other airports worldwide, making the company one of the largest transport companies in the world. http://en.wikipedia.org/wiki/BAA_LimitedClient has implemented Oracle Applications 11i and as part of Support and Multi Org implementation for segregation of Gatwick data because of Gatwick Airport sale extensive customizations and development of new conversions, discoverer reports etc. has been carried out to suit their business needs.

Responsibilities:

Involved in creation of Packages, Procedures, Triggers, Reports, Workflow Customization and enhancement of existing objects as per the Design Specification given by the Business Analyst.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Understanding and fixing the components within the SLA agreed with the client.

Writing user defined functions to be used in the customization of Fast Formulas and creating new Fast Formulas as per the requirement outlined in the functional document.

Developed Inbound and Outbound interfaces and worked on Conversions based on Client requirements.

Used BEE (Batch Element Entry) to upload the bulk element entries.

Investigating the Bug/Problems in Oracle HR, Payroll and Discoverer logged by users through HP Open View and provide them problem fixing or Data fixing Solutions.

Created New Business Areas with the database folders as per the Business specification under new EUL as part of Multi-Org Work and creation of Discoverer Reports.

Interacted with Functional consultants to resolve any issues during the production, development and enhancement phases in both Technical and Functional aspects.

Employer: Nexxoft Infotel Ltd

Dates of Employment: 01/19/2006 – 04/25/2008

Project Name

Employee Payroll Generation Implementation and Support

Client

Precitech Industries, India

Role

Software Engineer

Environment

Linux, Oracle 9i, PL/SQL, Developer 6i

Project Description:

This project is for total computerization of Pay-System of the company. It simplifies the process of work by keeping track of the employee data and recording transactions of attendance, leaves and work hours for each day. It also calculates the salaries considering allowances and deductions depending on employee’s grade. This system also incorporated with the loan module, in which each employee loan details, installment amounts and balances are maintained.

Responsibilities:

Involved in understanding& analysis of business requirements. The scope includes business process study, requirement analysis and mapping application setup, coding & testing.

Rich experience in writing SQL queries, creation of reports and forms, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.

Loading the Data into tables using SQL loader and using PLSQL Package UTL_FILE.

Experience in query optimization, performance tuning using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Collect.

Actively involved in Data Mapping of tables from Source system to Target system, including preparation of Entity Relationship Diagram.

Preparing Technical and Testing evidence Documentation.

Contact this candidate