Element Insurance AG is the leading white-label product factory for insurance and a leader in insurance digitalization. I am a part of Data team is working in the following domain.- Identified and resolved data inconsistencies within the Data Warehouse (DWH), enhancing data accuracy and reliability for BI reporting.- Defined and implemented new data standardization rules to enrich the data flow within the DWH, supporting more robust BI analysis.- Building ad-hoc ETL pipelines for… Show more Element Insurance AG is the leading white-label product factory for insurance and a leader in insurance digitalization. I am a part of Data team is working in the following domain.- Identified and resolved data inconsistencies within the Data Warehouse (DWH), enhancing data accuracy and reliability for BI reporting.- Defined and implemented new data standardization rules to enrich the data flow within the DWH, supporting more robust BI analysis.- Building ad-hoc ETL pipelines for managing data accuracy.- Managing ETL data pipelines via CI/CD code pipeline using GIT.- Facilitating stakeholder’s ad-hoc requests for new data marts/ maintenance- Migration from AWS RDS (PostgreSQL) to Google Big Query.- Implementation of DBT for data transformation to make it version controlled. Show less

Aga Khan University Hospital is a healthcare institute that offers all medical services under one roof. I was working as a BI Specialist with the following primary responsibilities.- In charge of developing, deploying, and maintaining all BI interfaces includes data source, data warehouse and reporting (SSRS / Power BI) of the hospital- Led Proof-of-Concept projects for data warehouse enhancements- Collaborated with sponsors to transform healthcare information into actionable… Show more Aga Khan University Hospital is a healthcare institute that offers all medical services under one roof. I was working as a BI Specialist with the following primary responsibilities.- In charge of developing, deploying, and maintaining all BI interfaces includes data source, data warehouse and reporting (SSRS / Power BI) of the hospital- Led Proof-of-Concept projects for data warehouse enhancements- Collaborated with sponsors to transform healthcare information into actionable projects- Translated requirements into specifications to be used for system design- Identified, redesigned existing processes and systems for scalable and sustainable future for the organization following healthcare standards- Provided guidance and assistance to accomplish ad hoc user requests- Trained the team members to lead by delegating authority on projects, and keeping open communication Show less

Afiniti is a US based company. The company is focused on developing artificial intelligence for use in customer call centres.I was working with the following responsibilities.- Transform business requirements of our stakeholder into a solution and a continuously evolving data warehouse with various source systems integration.- Provide a unified database solution, the Afiniti Enterprise Data Warehouse, based on the record of truth or single source from various platforms and systems… Show more Afiniti is a US based company. The company is focused on developing artificial intelligence for use in customer call centres.I was working with the following responsibilities.- Transform business requirements of our stakeholder into a solution and a continuously evolving data warehouse with various source systems integration.- Provide a unified database solution, the Afiniti Enterprise Data Warehouse, based on the record of truth or single source from various platforms and systems within Afiniti.- Technical lead for custom data warehouse implementation, integrate various modules for reporting.- Automation of all incoming data feeds along with audit & trail, to ensure smooth data processing.- EDW solution based on Python, SQL server, JSON (KeyPair) object processing.- Manage & lead the EDW team. Design prioritize and assign work packages to the team and ensure the team deliverables. Show less

Qor-data is a US based company. The company is focused on providing consultancy to the clients for Data related products.Primary responsibilities for the aforementioned position were as below.- Designed and architected comprehensive Data Warehouse solutions, ensuring robust and scalable infrastructure.- Developed and optimized ETL processes to load data into the Kalido Dynamic Information Warehouse (DIW) using SQL feeds, ensuring accuracy and efficiency.- Created and managed… Show more Qor-data is a US based company. The company is focused on providing consultancy to the clients for Data related products.Primary responsibilities for the aforementioned position were as below.- Designed and architected comprehensive Data Warehouse solutions, ensuring robust and scalable infrastructure.- Developed and optimized ETL processes to load data into the Kalido Dynamic Information Warehouse (DIW) using SQL feeds, ensuring accuracy and efficiency.- Created and managed Query Definitions, Result Sets, and Windows Automation batch scripts for seamless data loading and processing.- Coordinated daily with customers, facilitated User Acceptance Testing (UAT), and successfully led Data Marts to Go-Live.- Conducted thorough requirements gathering sessions, collaborating with IT and business stakeholders to define project scope and deliverables.- Developed and modified data models within the existing Data Warehouse to align with evolving business needs. Show less

Habib Bank Limited is the leading Bank in Pakistan.- Led a team in the end-to-end design and implementation of dimensional modeling, including data modeling, extraction, loading, and dashboard development, ensuring alignment with key performance indicators (KPIs).- Managed data integration with the Misys core banking system, ensuring accurate and seamless data flow to support critical KPIs.- Conducted data analysis using Hive and Impala, providing ad-hoc reports and insights to… Show more Habib Bank Limited is the leading Bank in Pakistan.- Led a team in the end-to-end design and implementation of dimensional modeling, including data modeling, extraction, loading, and dashboard development, ensuring alignment with key performance indicators (KPIs).- Managed data integration with the Misys core banking system, ensuring accurate and seamless data flow to support critical KPIs.- Conducted data analysis using Hive and Impala, providing ad-hoc reports and insights to stakeholders that directly informed KPI-based decision-making.- Played multiple roles in project leadership, including Business Analyst, technical and functional lead, and tester, with a focus on ensuring that all project outcomes met or exceeded KPI targets.Technical & functional key personal and tester. Show less

Afiniti is a US based company. The company is focused on developing artificial intelligence for use in customer call centres.Following were the responsibilities for my role.- Developed and managed data warehouse mainly for providing data to artificial intelligence teams for some of the largest multi-million-dollar clients.- This included holding discussions with Artificial Intelligence and Business Analytics team to analyze and find out patterns and issues in data so that the AI… Show more Afiniti is a US based company. The company is focused on developing artificial intelligence for use in customer call centres.Following were the responsibilities for my role.- Developed and managed data warehouse mainly for providing data to artificial intelligence teams for some of the largest multi-million-dollar clients.- This included holding discussions with Artificial Intelligence and Business Analytics team to analyze and find out patterns and issues in data so that the AI models are created using the best dataset.- Provide data integration support using Talend Data Integration ETL tool. This included meetings with business leaders, handling priorities and planning deployment timelines.- Optimizing and standardizing SQL codes and ETL pipelines so that the processes can run smoothly in the minimal time possible. Led a project which reduced deployment time required by ETL team on new clients by 66%. Show less

JS Bank is one of the leading banks of Pakistan with advanced infrastructure of all alternative delivery channels. I was working on Anti Money Laundering system implementation from SAS. Following were the responsibilities for my role.- Led the implementation of the SAS Anti-Money Laundering (AML) system for Branchless Banking, ensuring robust compliance with regulatory standards.- Managed the implementation and ongoing maintenance of the SAS AML system, optimizing its performance and… Show more JS Bank is one of the leading banks of Pakistan with advanced infrastructure of all alternative delivery channels. I was working on Anti Money Laundering system implementation from SAS. Following were the responsibilities for my role.- Led the implementation of the SAS Anti-Money Laundering (AML) system for Branchless Banking, ensuring robust compliance with regulatory standards.- Managed the implementation and ongoing maintenance of the SAS AML system, optimizing its performance and reliability.- Troubleshot and resolved issues in the Alert Generation Process to maintain system efficiency and accuracy.- Produced ad-hoc data reports using Oracle and SQL Server to meet the specific needs of stakeholders.- Automated data reporting processes for stakeholders using SQL Server Reporting Services (SSRS), enhancing reporting efficiency.- Customized AML scenarios to align with evolving business requirements, ensuring the system's adaptability and effectiveness. Show less

York Business Solutions was a consulting company providing implementation and support for SAS Anti-money laundering product. Following were the responsibilities for my role.- SAS Installation, Configuration and Assembly on Servers and End User systems- Extraction, Transformation and Loading (ETL) of Data using SAS Data Integration Studio- Report Designing and Analysis on Map Studio, Web Reports and OLAP cube- Data Mapping, Data Analysis and Data Cleansing

Data Check is a credit bureau providing services to the backs for individual’s credit scoring. Following were the responsibilities for my role.- Responsible for bulk data collection, data transformation and data- Performed rigorous data-driven analysis of business processes for- improving the efficiency, accuracy & effectiveness.- Provisioned monthly and Ad hoc MIS reports to management over- the data reporting status and issues and its resolution- Periodically performed… Show more Data Check is a credit bureau providing services to the backs for individual’s credit scoring. Following were the responsibilities for my role.- Responsible for bulk data collection, data transformation and data- Performed rigorous data-driven analysis of business processes for- improving the efficiency, accuracy & effectiveness.- Provisioned monthly and Ad hoc MIS reports to management over- the data reporting status and issues and its resolution- Periodically performed data purging activity to cleanup redundant- data sources to optimize storage and performance. Show less