Muhammad Hamza Bhatti

Experience

• 

  Amal Academy

  Jun 2019 - Sept 2019

  Career Prep-Fellowship

  Education startup funded by Stanford University that teaches professional skills to students and corporationsCareer-Prep Fellow: January 2015 – Present – Communication: Completed a competitive written application and interview process to be selected from over 600 applicants for intensive 3-month Fellowship funded by Stanford University– Skills development: Investing 150 hours in order to develop business skills (e.g., communication, leadership, problem solving, teamwork, etc.) that will help me make a deeper impact on the job Show less

• 

  Haidri Beverages Pvt. Ltd. PepsiCola International Franchise

  Jun 2021 - Aug 2021

  Finance Intern
• 

  Confiz

  Aug 2021 - Jul 2023

  • Led the design and implementation of data integration processes using PowerBI and SQL Server.• Optimized ETL jobs and transformations, resulting in improved data loading efficiency and accuracy.• Deployed a comprehensive ETL solution on a SQL Server, ensuring seamless integration with other systems.• Implemented data streaming solution from multiple sources to improve the speed and reliability of data transfer.• Built data dashboards to analyze and monitor the performance of AI models using PowerBI.• Developed custom filters in PowerBI to enhance data visualization and analysis.• Created a robust ETL pipeline, including data extraction from various sources, data cleaning, validation, and error handling, using SQL Server.• Utilized Meta Data Injection to improve data management and accuracy.• Implemented scheduling of ETL jobs using SQL Server Agent and Windows Job Scheduler, streamlining processes and increasing efficiency.• Automated the process of downloading PowerBI workbook files with data extracts from the SQL Server, changing its credentials according to client and upload it to SharePoint. Show less

  • BI Consultant

    Jul 2022 - Jul 2023

  • Associate BI Consultant

    Nov 2021 - Jun 2022

  • Trainee Data Science

    Aug 2021 - Oct 2021
• 

  Calrom

  Jul 2023 - now

  Data Engineer

  As a Data Engineer at Calrom, I specialized in architecting intricate data synchronization solutions. I spearheaded the extraction of D365 CRM data, utilizing SSIS to orchestrate its transformation and seamless integration into diverse website backend databases. Employed RabbitMQ queues to optimize JSON data transmission, ensuring swift and efficient processing.Technical expertise:- Devised and executed robust data pipelines guaranteeing seamless compatibility between disparate data sources and our warehouse infrastructure.- Engineered and fine-tuned SQL Stored Procedures, enabling precise data updates and facilitating comprehensive comparisons for maintaining data integrity.- Implemented triggers to automate and simultaneously broadcast identical data across multiple destinations, enhancing system synchronization and reliability.My tenure at Calrom enriched my expertise in SSIS, SQL, and intricate data integration methodologies. I'm poised to apply these technical proficiencies to drive impactful data engineering initiatives in new environments." Show less