Ahmad Mehran Khan
Dhaka
Summary
Proven Data Analytics Consultant with a track record of enhancing data integration and analytics efficiency. Expert in ETL development, big data processing, data warehousing and project management, delivering high-quality outcomes within tight deadlines. Skilled in Business Intelligence for fostering data-driven decision-making with impactful data visualization and presentations.
Overview
2
2
years of professional experience
Work History
Data Analytics Consultant
Ascension Logistics
06.2023 - 03.2024
- Developed and implemented data archiving and storage strategy that met the company's business requirements. Worked with IT team to ensure the smooth migration of data from SQL Server to Snowflake.
- Implemented agile methodologies to streamline project workflows, enhance collaboration, and deliver high-quality outcomes within tight deadlines.
- Implemented ETL pipelines using Azure Data Factory and Talend for seamless data extraction, transformation, andloading into Snowflake from MS SQL Server, ADLS enhancing data integration and analytics efficiency.
- Designed and implemented efficient data modeling in Snowflake, emphasizing schema design and normalization for enhanced analytics efficiency and reliable business processes.
- Implemented SnowSQL and Snowpipe for real-time data ingestion and querying, optimizing data loading processes and enabling timely analytics insights in Snowflake.
- Developed and implemented data governance framework to ensure compliance and optimize data quality across Snowflake and SQL Server databases, fostering data-driven decision-making.
- Orchestrated the development and maintenance of detailed documentation and reports to support data quality initiatives, ensuring transparency across all data management processes.
- Proficient in Microsoft Power BI for data visualization and analysis, creating interactive dashboards and reports to drive informed decision-making.
Data Engineer
Johnson & Johnson
08.2022 - 04.2023
- Designed and implemented high-performance Azure Synapse data warehouse, leveraging data partitioning strategies, query optimization, and performance tuning techniques to achieve exceptional efficiency for large-scale data sets.
- Implemented Azure Data Factory's Data Flow feature to design and develop complex ETL workflows for handling large- scale data transformations and processing.
- Developed complex SQL queries, including subqueries, joins, and aggregations, to extract and manipulate data from multiple database tables. Optimized query performance through the use of caching, query tuning, efficient schema design, resulting in faster data retrieval and improved overall system efficiency.
- Developed a high-performance data processing pipeline using PySpark and SparkSQL on Azure Databricks to efficiently handle large-scale data ingestion, transformation, and analysis. Also migrated legacy MapReduce jobs to Spark on Azure Databricks, which significantly improved performance and reduced processing times.
- Designed and implemented data governance frameworks to ensure data security, compliance, and accessibility, adhering to data privacy regulations and organizational policies.
- Implemented Spark streaming for real-time data processing, enhancing efficiency and decision-making capabilities.
- Automated Jira reporting for efficient project tracking and performance monitoring. Developed custom reporting workflows to extract and present key performance indicators, enhancing real-time visibility into project progress for stakeholders.
- Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
Data Engineer (Internship)
Visiting Nursing Association of Texas
01.2022 - 06.2022
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Worked on query optimization, creating efficient stored procedures to perform data transformation and loading.
- Implemented data pipelines for data extraction, transformation, and loading using AWS Glue and Airflow, ensuring data quality and consistency across multiple sources. Migrated data from legacy on-prem MS SQL Server to Snowflake.
- Utilized Apache Spark (PySpark & SparkSQL) in AWS EMR for processing and analyzing datasets, capitalizing on its distributed computing capabilities for complex data transformations.
- Designed and developed interactive dashboards using Tableau, providing a comprehensive overview of the findings and predictions for the hospice facility's operations and management costs.
Education
Master of Science - Business Analytics
Southern Methodist University
Dallas, Texas, United States Of America08.2022
Bachelor of Arts - Information Technology
York University
Toronto, ON, Canada12.2020
Skills
Power BI Proficiency
ETL development
SQL Programming
Python Coding
Predictive modeling
Data Warehousing
Big Data Processing
Business Intelligence
Spark Framework
Data Visualization and Presentations
Project Management
Tableau
Data Analysis
Report Preparation
Timeline
Data Analytics Consultant
Ascension Logistics
06.2023 - 03.2024
Data Engineer
Johnson & Johnson
08.2022 - 04.2023
Data Engineer (Internship)
Visiting Nursing Association of Texas
01.2022 - 06.2022
Master of Science - Business Analytics
Southern Methodist University
Bachelor of Arts - Information Technology
York University
Similar Profiles
Brooke FergusonBrooke Ferguson
Supervisor of Respiratory Care/Acting Manager at Ascension Seton Smithville, Ascension Seton BastropSupervisor of Respiratory Care/Acting Manager at Ascension Seton Smithville, Ascension Seton Bastrop
Isaac TaylorIsaac Taylor
Operations Coordinator at Ascension -St. Thomas Hospital (St. Thomas) MidtownOperations Coordinator at Ascension -St. Thomas Hospital (St. Thomas) Midtown
Quiana FennellQuiana Fennell
Remote Patient Scheduling Coordinator at AscensionRemote Patient Scheduling Coordinator at Ascension