Oracle Techno Functional Consultant
Confidential
Total des années d'expérience :12 years, 11 Mois
Project documentation Aim Methodology & CRP;
Various HRMS business processes (Leaves, Hiring, retirement, employment data maintenance, )
Business Analysis
Implementation Configuration
Test Management - Key User Training & Post Implementation Support
Daily support ticket resolve and issues trouble shoot on HR and Self-Service modules
Oracle AME and workflow configuration
Oracle Forms and HTML screens Personalization
OA Framework (OAF) components development, debugging, maintenance and configuration
Analysis and Implement new business
(HRMS/Payroll) for R12.2.3 with R12c Database.
* Reports Development using Oracle Reports, XML
http://www.dicetek.net/
Clients: JAFZA (EZW): Economic Zones World (EZW) is the global developer and operator of economic zones, technology,
logistics and industrial parks under the Dubai World Group.
Roles & responsibilities:
R12 Reports Migration Reports (HRMS/Payroll) Discoverer Reports to XML
Al Reyami Interiors is the flagship company of the Al Reyami Group which consists of 27
companies having more than 7000 employees. Today it has emerged as a multinational worked on implementation of Oracle
Applications 11i as a member in the Onsite Development team.
BUSINESS DOCUMENT This document is intended for business use and should be distributed to intended recipients only.
Roles & Responsibilities:
* Reports Development and Customization in AR, AP SCM,
BUSINESS DOCUMENT This document is intended for business use and should be distributed to intended recipients only.
1. Emirates Airlines:
Clients: Emirates Group. Emirates is an airline based in Dubai, United Arab Emirates. The airline is a subsidiary of The Emirates
Group, which is wholly owned by the government of Dubai's Investment Corporation of Dubai
Roles & responsibilities:
* User Incident’s handling for HR and Payroll.
* HR Web service Interface Developments, Data Patch support and enhancements.
* HR/Payroll Reports Development using BI Publisher.
* Performing UAT for HR/OLM/AME/Web Services.
* Unix Scripting for server placements of objects.
* API’s for integrations.
* OAF enhancements and Oracle Forms changes related to leave module.
* OTA Support and enhancements.
* Alerts and email creation for HR related updates.
* AME Configurations and support.
* Involved in ETL /TIBCO process for application Support.
* GIT Update for code changes.
Projects:
* Web service creation to interface HR data to other applications.
* Interface and consume web service development for Medical benefits system (3rd
Party).
* Data Patch for OLM related big fixes.
* Interface for HR related/Payroll related element/Policy changes.
* Reports related bug fixes - (Scheduled date with incremental date parameter, convert contract change letter to BI
Publisher report).
* Interface for payroll element allowance changes- Logic change in element pay Value calculation as per grade.
* EOS Report development to send to fnd users and the payroll users - Send Email using Concurrent request Delivery
Options.
* Alerts creation for Dependents related document update - Send email using SMTP
* API development for 3rd party tool integration for
Employee creation, terminations, search and lookups responses
* Workflow changes for leave module
* API for contingent worker update and access related changes.
* Oracle fusion (Performance Management) Related updates.
* Sprint and JIRA item creation for Enhancement and big fixes.
* User support for leave/OLM/HR related incidents
2. Dubai Airports:
Clients: Dubai Airports. One of the biggest airports in the world. Worked closely with HR department and with various
technologies.
Roles & responsibilities:
* Oracle fusion Extract/data load.
* Reports Development using BI Publisher.
* Test and Consolidate test and BD document.
* Schedule plan for technical and functional downtime/Development/Iterations.
* Interface for shift and absence Management.
* Scripting (UNIX) For Deployment of Objects in various Instance.
* Tableau Report Development
* SQL Tuning for ADF and Oracle Database.
* Involved in ETL Process for data staging.
BUSINESS DOCUMENT This document is intended for business use and should be distributed to intended recipients only.
Projects: -
Oracle Fusion Payroll Implementation. Reports development:
* Extract And Upload
Create the e-text report for Upload of Employee Details for Payroll Implementation.
* Package to automate absence interface and shift interface from KRONOS (Third Party SQL Server) to Fusion.
Interface program to transfer absence and shift details of employee from a third party system to fusion.
Creation of TAR files for the objects to be deployed with documentation using UNIX System.
* Consolidating the Legacy and Migrated Data using HCM UPLOAD Features.
* Tested and modified Fast Formulas and consolidate the initial setups for payroll implementation.
* BI Publisher report-Payroll related E-text and BI Publisher Reports.
o Pension Report
o Payroll Summary Report
o Third Party Report Etc...
* Tableau Report:
o Created Data Source and Reports for demographic report related to employee salary, Absence, Recruiters
scores and performance.
* SQL Tuning:
o Have created the SQL Tuning set by monitoring in Enterprise Console.
o Have taken backup of database and have set SGA size as recommended.
o Created plan table and compared the high load SQL set and tuned the query.
