Functional Specialist
ADCB Bank
Total years of experience :5 years, 4 Months
mandates provisioning a 360-degree view of Payroll data from different subsidiary units of Etisalat, GTS has been commissioned for building Custom Payroll Solution for PTE Staff for the recently implemented Oracle Fusion HCM and Creation and management of Data Lake as centralized data store for Etisalat core Payroll data for PTE Staff. It involved building data pipelines from different sources of Oracle Cloud HCM and Oracle PAAS and Transforming Data and Saving in Parquet format before analysis and building of Machine Learning Models by the Etisalat Data Science Team
•Delivered Tableau dashboard with Visualizations of high performance queries for extracting monthly salary for subsidiaries.
•Developed data pipeline for Oracle Integrated Cloud as ELT tool for querying PAAS Database for all Salary Payments made on the day and Batch saving in CSV format on S3 Data Lake using DB and REST API adaptors
•Built data pipeline and save in Parquet format on S3 Data Lake
•Worked on building data models with classification for regular and incentive payments supporting the business requirement
•Worked on collaborative notebooks for data exploration development of SPARK SQL Scripts and UDF Functions for data processing and transformation.
Studied Requirement, negotiated scope, developed project schedule, executed and closed following projects within budget and timelines using agile methodology and oracle applications framework technology
•Retirement management, Adhoc benefits management and Business card management modules
•Enhancement project for merging employee objective and learning
•Deployed Oracle Hyperion for workforce operational compensation planning with extensive support on building data model for staff and contractor compensation forecast.
detailed business requirement, negotiated and confirmed requirements from user, development and closure of Project in Oracle Applications 12.2.6 HRMS and Payroll Enhancements
•Developed with Extract Transform and Load capability, Development of views for HRMS Payroll dashboards, Key Performance Indicator scorecards
•Designed Solution for Automation of Insurance Benefits Administration (Enrollment/Payment / Deenrollment/Recovery of Insurance Premium) with Electronic Data Interchange files to Providers
•Managed team of one resource
•Change Management using Jira.
courses: Analyst Nanodegree •Udacity Inc
Oracle HCM Fusion Cloud ( HCM Core HR, Payroll Functional
Certified Apache Spark Developer •Self-Study
courses: BPEL – SOA, Oracle Integration Cloud Service •Oracle Dubai