• Responsible for designing, developing, and testing of the ELT strategy to populate the data from Landing Zone (LZONE) to Persistent Staging Area (PZONE) using Oracle Data Integrator (ODI).• Responsible for formulating technical specifications based on the business requirement to build the Enterprise Data Warehouse.• Responsible for designing logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Responsible for looking after of all the development and support of ERP.Writing ETL & data extraction to meet the business user requirements.Propose ideas to business user for development of better end user product.As part of team of data migration to SAP S4/HANA I am responsible for data extraction from current ERP and also working as a bridge between SAP specialist team at Head Office (SICPA Switzerland) and local BKUs.Provides training to user.Managing ERP releases and rollouts.Designed a Power BI report to depict different KPIs.

• Designed, documented and developed a facility to record supplier comparative statement for supply chain department.• Revamped Production Module. - Developed a mechanism to track production process. - Developed a mechanism to calculate production timings. - Developed a facility to monitor utilization of production machines. - Developed a dashboard screen to view production, and machines involved in production process.• Documented and developed Module to calculate Landed Cost for Imported material.• Documented and developed Gate Pass Module.• Documented and developed Maintenance Request Module.• Developed Work Order Module for making payment based on progress of work.• Working on Customize ERP Application. - Developing Forms and Reports of Inventory Modules. - Troubleshooting of whole ERP.

Part of team developing Group Health Claim System.Involved in analysis process of new Insurance System AETINS that is to be implemented, and also development of reports based on new data structure.Developed and modified the reports for existing Core Insurance Systerm i.e CLAS.

• Developed General Data Uploading Module, which is implemented on various clients as per their needs. State Life Insurance Corporation of Pakistan.• Develop Procedure to Upload Claim Data for State Life Insurance Corporation of Pakistan.• Analyzed and developed data migration process for Lebanon Insurance Audi Group.• Developed Procedure of Overriding Commission for a Policy, and it is a generalized procedure used for all clients.• Development of MIS reports for various Clients as per there business requirements.Application Support• Group Life Assurance Application support to Adamjee Insurance.• Group Life Assurance Application support to State Life Insurance Corporation of Pakistan.• Group Life Assurance Application support to National General Insurance Dubai.• Group Life Assurance Application support to Alinma Tokio Marine Insurance Kingdom of Saudi Arabia.

•Support the Hubs / Branches in the matters relating to Banking Software “Unibank”, it also includes Linux and oracle administration to cater issues which hurdles, proper processing of the system.•Support the branches all over the Pakistan for DPP (Digital Pen Paper), Centralized Account Opening System.•Managing and Support of BCP project (Business Continuity Plan).•Analysis of Day End Process of Unibank, and making the decisions/suggestions to overcome the problems which are creating hurdles in Day End Process.•Working with Symbol (Core Banking Software) migration team to migrate data from Unibank to Symbol.