Data Engineer

• Oct 2021 - Present

• Involved in end-to-end ETL process of multiple dashboard development in one of the largest banks in Pakistan. • Involved with Business Team closely for the transformation of Data according to Business Requirements. • Data Modeling and Data warehousing of huge data sets extracted from data lake and different data sources. • Constructed Data pipelines which automate the data ingestions of multiple raw sources into the data lake and data lake to presentation layer with email enabled monitoring • Development of Power BI Dashboard through Direct Query and Import. • Automation of data sourcing for various projects including Digital Customer Experience (DCE) and ADC Operations – Card Processing Dashboard (CPU) • Developed datasets for the analytics team to achieve the multiple analytics use case i.e. customer life time value, customer segmentation etc • Worked on Data Lake which is Cloudera for ingestion of Raw Data. • Worked SQL Server for Presentation layer data storage. • Cross Validation of data, matching values

Senior Executive Officer

• Feb 2021 - Oct 2021

• Implementation of Oracle Webadi for Data Migrations. • Maintains and modifies existing applications on their own as well as under direction from IT Manager • Implementation of compliance HR admin projects • Work in oracle HR Payroll (Fast Formula’s). • understanding of Business and Technical Process of Management & Non-Management HR, Payroll, Time Management and Gate Management Process • Development and Testing of Recruitment Module (Phase I). • To ensure timely management of required modifications & enhancements in application. • Modification of Compliance Payroll working for non-Management • Develop disciplinary cases recording through system for non-Management • Learning & Development Module (Development & Testing) • Customized Reports Development using Oracle Reports Developer and XML Publisher and Integration with Oracle Applications.

Senior Associate Consultant

• Sep 2018 - Dec 2020

Associate Consultant

• Sep 2017 - Sep 2018

Responsible for Client Management which includes meeting with Senior IT Management to align the client’s objectives with Project, for Project Planning and proposing the best practices with respect to ITInfrastructure, Controls, System Architecture, Business Continuity and Disaster Recovery.Oracle EBS r12 Apps database administration which includes Patch deployment, Server monitoring and Cloning.Day to day technical support and development.Provision of Post-implementation technical support.Development of customized workflow approval notification process.Development of Oracle Forms/Reports and concurrent programs.API's,alerts,workflows

Oracle Developer

• Sep 2016 - Sep 2017

Worked as an Oracle Developer/Dba in Phoenix Armour Pvt Ltd. Designs / Codes applications following specifications using Oracle Development tools. Maintains and modifies existing applications on their own as well as under direction from IT Manager. Performs maintenance of programming for existing version. Performs custom programming at customer request. Create Table Structure, Queries, Function, Procedure and Packages as per client requirement. QA & Testing for newly deployed programs. Sql Tuning and Optimization to reduce response Time of Query and Resource to user end. Requirements Gathering, Analysis and Understanding of the Business Requirements as per their needs Implement Online Printing of Different Cheques of Banks and Dynamic Generated Reports. Providing /Suggesting solutions based on the requirements. Other duties as assigned by IT Manager. Perform Datapump Backups. Perform Sql Script to find invalid procedures,functions,triggers