Mohammad Usman Khan Email & Phone Number

Karāchi, Sindh, Pakistan

Project: CRM Data Quality Pipeline• Analyzed CRM system requirements for data quality issues.• Developed algorithms for data quality checks (e.g., null, unique, outlier analysis) and integrated them into the pipeline for automated issue identification.• Conducted comprehensive CRM data analyses to detect patterns, anomalies, and other quality issues.• Worked closely with stakeholders to ensure the CSV files provided the necessary information for addressing data quality issues… Show more Project: CRM Data Quality Pipeline• Analyzed CRM system requirements for data quality issues.• Developed algorithms for data quality checks (e.g., null, unique, outlier analysis) and integrated them into the pipeline for automated issue identification.• Conducted comprehensive CRM data analyses to detect patterns, anomalies, and other quality issues.• Worked closely with stakeholders to ensure the CSV files provided the necessary information for addressing data quality issues effectively.Project: Bank Operational Reports• Delivered the highest number of SQL queries within the team, completing 22 queries within a tight 30-day deadline for a Bank.• Provided valuable assistance to colleagues in developing logical solutions, enhancing the efficiency andeffectiveness of the team's deliverables.• Consistently exceeded expectations by delivering an average of 3 queries per day, surpassing the team's average of 2 queries.• Ensured the timely completion of over 22 queries and used SQL best practices to develop these queries.Project: UAE Regulatory Reporting• Led a team of 2 individuals in the development of a product focused on regulatory reports for the UAE• Collaborate closely with the business to identify the specific regulatory reports needed, meticulously filtering and selecting 176 reports from a pool of over 600 reports.• Worked closely with the business stakeholders to identify and map the reports in the Temenos Data Hub, compiling the mappings in Excel and tagging each report to facilitate the development process for the team.Project: Banks Social Media Market Analysis• Extracted data from Facebook and Twitter (around 50,000+ rows for 5 banks) using data scraping tools and store them in a database• Used sentiment analysis to identify customers’ key problems at each bank and highlighted them in a report• Identified the posts per day and peak interaction time in a day for each bank and recommended the most engagement time for each bank Show less

Karāchi, Sindh, Pakistan

Project: Customer and Complaint Analytics• Successfully built and managed over 10+ dashboards, incorporating more than 30+ key performance indicators(KPIs), to analyze customer support activity and provide valuable insights for timely complaintresolution and performance tracking• Effectively handled a vast amount of data, consisting of over 5.5 million rows, to ensure accurate andcomprehensive reporting• Implemented the Customer Analytics dashboard, enabling the… Show more Project: Customer and Complaint Analytics• Successfully built and managed over 10+ dashboards, incorporating more than 30+ key performance indicators(KPIs), to analyze customer support activity and provide valuable insights for timely complaintresolution and performance tracking• Effectively handled a vast amount of data, consisting of over 5.5 million rows, to ensure accurate andcomprehensive reporting• Implemented the Customer Analytics dashboard, enabling the identification of customer information and offering an overall view of customers, contributing to an improved understanding of customer demographics and preference• Developed the Customer 360 dashboard, consolidating crucial customer information into a single view, facilitating comprehensive analysis and enhancing the efficiency of customer service operations.Project: Port CRM Data Quality Analysis• Identified and reported more than 25 data quality issues within the CRM system of a port, impacting 2.7 million rows.• Developed comprehensive roadmaps to address the top 20% of the identified issues, focusing on the ones that would result in resolving 80% of the irregularities and presented findings to the client• Implemented dashboards to track and monitor the inconsistencies, enabling efficient tracking of data quality improvements and facilitating prompt action to rectify the identified issues.• Played a significant role in enhancing data integrity and quality assurance, ultimately contributing to improved decision-making processes and the overall operational efficiency of port Show less

Karāchi, Sindh, Pakistan

Project: Banking Analytics Platform• Developed an ATM Cash Optimization program using Machine Learning algorithms to forecast the amount of withdrawal from the ATM in the next 10 days with 82% Accuracy bringing a minimum estimated revenue of Rs.15.9 million per year at a 6% interest rate.• Ingested more 1200+ bank branches (with POI) data from Google trends, OSM & Google maps for GIS analysis to identify potential areas for new branch openings by reviewing the historically successful… Show more Project: Banking Analytics Platform• Developed an ATM Cash Optimization program using Machine Learning algorithms to forecast the amount of withdrawal from the ATM in the next 10 days with 82% Accuracy bringing a minimum estimated revenue of Rs.15.9 million per year at a 6% interest rate.• Ingested more 1200+ bank branches (with POI) data from Google trends, OSM & Google maps for GIS analysis to identify potential areas for new branch openings by reviewing the historically successful branches• Improved the existing deposit mobilization systems by introducing customer 360, social media sentiment analysis, RFM analysis, and 80/20 analysis by ingesting data from different sources to provide relationship manager with insights to act upon in his 9-5 jobProject: Premium Data Analysis• Conducted a comprehensive premium data analysis for an insurance company, enabling the identification and evaluation of factors contributing to high claim amounts of up to 3x• Identified specific bands with claim amounts exceeding a certain threshold 1x, providing valuable insights into the patterns and characteristics of high claims cars• Developed evaluation rules based on the identified factors, aiding in the assessment and categorization of insurance rates for high claim bands, ultimately contributing to maximizing profitability for the insurance company• Provided rate recommendations for future luxury car models based on historical data analysis, facilitating informed decision-making and ensuring appropriate insurance rates are set for high-claims cars Show less

Karāchi, Sindh, Pakistan

Project: Comparative Analysis for a Bank• Developed a script to extract and analyze revenue and cost data from annual reports of 25 banks• Conducted a comparative analysis of the banks, categorizing them into specific tiers based on their revenue, and identified outliers within each tier• Discovered that certain tier 2 banks were allocating higher expenses than tier 1 banks in areas such as software licensing, hardware purchasing, and information security• The analysis enabled… Show more Project: Comparative Analysis for a Bank• Developed a script to extract and analyze revenue and cost data from annual reports of 25 banks• Conducted a comparative analysis of the banks, categorizing them into specific tiers based on their revenue, and identified outliers within each tier• Discovered that certain tier 2 banks were allocating higher expenses than tier 1 banks in areas such as software licensing, hardware purchasing, and information security• The analysis enabled informed decision-making for banks, leading to potential cost optimization strategies and improved resource allocation practices, ultimately impacting the banks' financial performance and enhancing operational efficiency Show less

Karāchi, Sindh, Pakistan

Summarized & Analyzed sales data in tables, charts, and graphsDraft reports and presentations with simple data interpretation (category overview as well as issue-based)Reviewed data for errors and inconsistencies, and perform data extraction using internal tools and data sourcesClient Analytics and Supporting in delivering on revenue target/growth & Assessed information, identifying solutions and making fact-based recommendations

Karachi Division, Pakistan

Karāchi, Sindh, Pakistan

Dashboarding of covid-19 Worldwide/PakistanExplored Machine Learning algorithms and their implementation on different datasets

Karachi

Trained a voice recognition model for Pakistani accents using CNN provided by Deep SpeechPreprocessed dataset of Pakistani accents, removing anomalies & normalizing the dataCollected dataset of 250+ people

Karachi, Pakistan

Converted monthly cumulative sales data to per day sales and formatted it in a way that could produce dashboards in Qlikview.Assisted in allocating new company codes to vendor master data which aided in transactions and reports.Aided in implementation of emailing purchase order to vendor in SAP, which improved communication between IMC and its dealers.Executed database for Online Notification Form using SQL server management, benefiting the front-end developer.Segregated data of… Show more Converted monthly cumulative sales data to per day sales and formatted it in a way that could produce dashboards in Qlikview.Assisted in allocating new company codes to vendor master data which aided in transactions and reports.Aided in implementation of emailing purchase order to vendor in SAP, which improved communication between IMC and its dealers.Executed database for Online Notification Form using SQL server management, benefiting the front-end developer.Segregated data of Production Department, Quality Assurance and Quality Control to fill second level Authorization matrix for Material Management Show less

Karachi,Pakistan

Cater people suffering from Muscle and Bone Diseases. Provide them with braces and educate them with their health insurance coverage for these braces.

Karachi,Pakistan

Alumni Development Programme is an on-field teaching initiative started in 2015. It is designed to help TCF alumni secure admission in the best universities in Pakistan and abroad.As a University student I volunteered, conduct classes and prepare 50+ TCF alumni for more stringent scholastic requirements.

Master'S Degree, Data Science

The MS (Data Science) program by FCS, IBA prepares students to extract valuable insights from data. The program is designed for students.

Bachelor Of Science - Bs, Computer Science

Important coursework: Design Analysis of Algorithms & Data Structures, Computer Architecture,Database Systems, Intro to Artificial.

A Levels, Pre-Engineering, A, B, B

Activities and Societies: Part of mathematics club. Participate in Kangaroo mathematics competition. Participate in Inter School Cricket.