Developed and optimized complex T-SQL scripts to extract, manipulate, and analyze data, meeting specific business requirements across various teams.Utilized SSRS to design, deploy, and manage paginated reports, ensuring accurate and timely delivery of critical business insights.Created and maintained Power BI dashboards, showcasing key organizational KPIs to executive management, RM and RBM aiding in data-driven decision-making.Optimized stored procedures, significantly improving report performance and ensuring efficient data flow across systems.Monitored and troubleshooted ETL pipelines, ensuring smooth data retrieval from T24 (Core Banking System) to BI servers and promptly addressing any issues.Developed Shell scripts to automate routine tasks, enhancing operational efficiency and reliability of scheduled processes.Responded to ad-hoc data requests from various departments, delivering customized data packets in clear, understandable formats.Collaborated with diverse stakeholders, both internal and external, technical and non-technical, to deliver comprehensive business insights and support data-driven strategies.

Determined optimal approaches for extracting data from various platforms and successfully moved it to data warehouses.Conducted in-depth data analysis to ensure data quality and consistency, monitoring production data.Implemented data modeling techniques for target structures, including star schemas, snowflake schemas, and highly normalized data models.Adapted ETL processes to accommodate source system changes and meet new business user requirements.Skilled in conducting Expected Credit Loss (ECL) analysis, generating insightful reports on IFRS9 Opening & Closing. Produced various analyses for the Risk & Finance Department using IBM Cognos.Led initiatives in Deposit Incentive and Loan Incentive projects, driving success in incentive programs.Pioneered the creation of a Non-Performing Loan (NPL) data pipeline for CRU Portal, streamlining processes.Successfully directed the smooth acquisition of Human Capital Management (HCM) and Identity Management (IDM) data from two distinct systems, integrating them into the implemented Enterprise Data Warehouse (EDWH).

At Khushhali Microfinance Bank Limited, Highly organized and detail-oriented professional with a proven track record of successfully preparing and delivering over 60+ monthly end reports to DRU on a consistent basis. Expertise in compiling and analyzing comprehensive data for accurate insights.Developed eCIB datamart in Vertica DataWarehouse for SBP, designing and implementing data architecture for efficient extraction, transformation, and loading processes. Automated extraction jobs through script automation, optimizing data retrieval, and enhancing operational efficiency.Implemented a comprehensive system of 240+ checks to identify and rectify inaccurately inputted data, ensuring data accuracy and integrity within the data mart.Developed and implemented 6 distinct datasets for the IFRS9 project, serving as a data inputter for the Credit Scoring Model. Played a key role in gathering, organizing, and structuring data to meet the requirements of the project. Successfully implemented automated extraction of 40+ daily reports for approximately 260 branches, organizing them into respective folders. Achieved a notable 40% improvement in data processing time through the automation of these extraction jobs. Demonstrated strong project management skills in streamlining data retrieval processes, resulting in enhanced operational efficiency and timely availability of reports.Proficient in Agile methodologies, specifically using the SCRUM framework, driving collaborative efficiency, and consistently delivering results within tight deadlines.My ability to craft and execute Ad hoc queries upon request for data has made me a valuable asset to the organization. I've developed List, Cross tab, and Charts and created Drill through & Master Detail Reports, perform email bursting, and scheduled Reporting via emailPerformed daily submission of General Ledger (GL) to the EBS system and Bank Daily Monitoring File for submission to SBP.

Proficiently managed Excel documents to collect and present metrics data, facilitating optimal resource allocation and providing insights to stakeholders.Deployed predictive analytics models to forecast future trends, enabling proactive decision-making.Designed Power BI Dashboards and Key Performance Indicators (KPIs) to effectively communicate actionable business performance metrics.Created a comprehensive performance report focusing on evaluating and measuring CCTs (Customer Care Teams) for daily, weekly, and monthly company recovery metrics.Delivered actionable insights to stakeholders to support informed decision making processes.Developed bonus incentive programs for all teams based on their recovery performance.