Saqib Shakoor

Experience

• 

  Jubilee Life Insurance Company Ltd.

  Jan 2015 - Jan 2022

  • Automated standard report processes to reduce execution time by 40%, increased data accuracy by 20%, and generated more timely and actionable insights leading to improved decision making.• Procured and tapped into structured and unstructured data sources to create dashboards and facilitate advanced analytics.• Collaborated closely with business analysts as well as users to gain a comprehensive comprehension of their needs, such as the desired layouts and appearance of the schema and the public objects to be deployed on the BI Platform.• Validated data at various levels of the BI Database Schema across various phases and layers of BI Data Warehouse.• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.• Created interactive data visualization in Power BI, using relational and aggregate data sources.• Successfully managed multiple BI and Extract, Transform, and Load (ETL) projects simultaneously to ensure efficient and effective project implementation.• Created multiple Stored Procedures, Packages, Views, Triggers to perform specific post process user exit tasks. Daha az göster • Developed ETL process for data migration of Individual Life Takaful System.• Performed data integrity checks to prevent data corruption and ensure reliability.• Conducted data retention test to verify the data storage in accordance with the specified requirements.• Established a method for Email Automation of Client Servicing Letters to Customers/Agents/dedicated Branches, which reduced time spent on manual processing by 23%, leading to 40% reduction in overall operational costs.• Designed MIS Reports and Letters in SQL Server Reporting Services (SSRS) for Persistency users in accordance with their business requirements.• Migrated existing QlikView reports to Microsoft Power BI reports.• Performed data cleansing and preparation to ensure quality and accuracy of data sets used for KPI dashboards.• Architected and developed interactive Persistency Dashboards utilizing Microsoft Power BI for enhanced data representation and analysis.• Involved in finalization of scope for core system i-e ISF for Enterprise Data Warehouse development.• Developed ETL process for New Business module. Daha az göster • Developed MIS Reports and Letters for New Business, Banca Agency and Claims, modules from scratch.• Developed MIS Reports and Letters for Servicing users in accordance with their business requirements.• Debugged and solved ad-hoc issues on daily basis through Request Management System.• User Creation and User Access Modification.• Business Product Setups in both Systems Conventional & Takaful.• Developed ETL process for data migration of Individual Life Conventional System.• Performed data reconciliation by applying Data Quality Matrix.• Created report specification and development document. Daha az göster

  • Senior Data Analyst

    Jan 2022 - Jan 2022

  • Data Analyst

    Jan 2019 - Jan 2021

  • Junior Data Analyst

    Jan 2015 - Mar 2019
• 

  Pakistan Single Window (PSW)

  Jan 2022 - Jan 2024

  Senior Data Engineer

  • 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).• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures.• Develop packages for the ODI objects and scheduled them as scenarios.• Support in full legacy to ODI data conversion and Integration task.• Translated business requirements into technical specifications to build the Enterprise Data Warehouse.• Development of Mappings via Integrated Knowledge Modules from Persistent Staging Area (PSA) to Operational Data Source (ODS).• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.• Responsible for Data Modeling. Created Logical and Physical models for staging, transition, and Production Warehouses.• Installation and Configuration of Oracle Data Integrator (ODI)• Responsible for creating complex mappings according to business requirements, which can be scheduled through ODI Scheduler.• Responsible for configuration of Master and Work Repository on Oracle• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces, and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.• Created ODI Packages, Jobs of various complexities and automated process data flow.• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.• Data Reconciliation by applying Data Quality Matrix.• User Security Matrix in ODI 12c. Daha az göster

• 

  Qordata Inc.

  Jan 2024 - now

  Senior Data Engineer