Muzammil Hashmi

Muzammil Hashmi

Data Analyst
United States of America

About Me

4+ years of expertise in BI and Data Analytics you've been searching for. Armed with SQL, Power BI, and Python, I don't just analyze data; I craft compelling narratives that reshape the sales landscape. A proven virtuoso…

Experience

Data Analyst (Intern)

Design Ocean
May 2023 - Present · 3 years 2 months

• Automated extraction and analysis of large-scale healthcare data with Python, enhancing data-driven insights by 15%.
• Designed interactive Tableau and Power BI dashboards, accelerating decision-making by 30%.
• Conducted ETL Unit and development tests, taking corrective action as needed.
• Led SQL analysis on complex datasets, improving query output time.
• Develop presto and spark SQL queries for optimized data pulls from AWS cloud for multi-dimensional datasets.
• Identify data sources and build ETL pipelines using AWS Glue to aggregate the data for high-level reporting.
• Use statistical analysis to identify trends, detect anomalies and extract data-driven insights to increase revenues.
• Enhance business understanding through interactions with different stakeholders and incorporate the business needs in day-to-day analytics.

DATA ANALYST(Intern)

Design Ocean, St. Petersburg, United States

Automated extraction and analysis of large-scale healthcare data with Python, enhancing data-driven insights by 15%.
Designed interactive Tableau and Power BI dashboards, accelerating decision-making by 30%.
Conducted ETL Unit and development tests, taking corrective action as needed.
Led SQL analysis on complex datasets, improving query output time.
Developed Presto and Spark SQL queries for optimized data pulls from AWS cloud for multi-dimensional datasets.
Identified data sources and built ETL pipelines using AWS Glue to aggregate the data for high-level reporting.
Used statistical analysis to identify trends, detect anomalies and extract data-driven insights to increase revenues.
Enhanced business understanding through interactions with different stakeholders and incorporated the business needs in day-to-day analytics.

SR. System Analyst

Centegy Technologies, Karachi, Pakistan

Worked closely with client and technical support teams.
Prepared functional or technical documentation for data warehouses.
Provided support to all large data volumes and assisted in data processing.
Optimized supply chain processes with comprehensive shipping trend reports.
Produced SSRS and SSAS reports through SQL, optimizing reporting processes.
Achieved infrastructure, resolved conflicts, and implemented new business systems.
Handled data collection, staging, movement monitoring, quality, and archiving strategies.
Transformed product data into 50 impactful BI dashboards, monitoring key business KPIs.
Utilized predictive modeling to forecast shipping volumes and identify potential bottlenecks.
Managed large-scale databases, ensuring a 20% reduction in shipping documentation errors.
Conducted root cause analysis on sales and website data, streamlining operational workflows.
Led central processing of reports SSIS using SQL, developing insightful reports with Power BI.
Established a Hadoop environment for Spark and Hive, enhancing data processing capabilities.
Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Spearheaded Cube Development with Pentaho Mondrian in Schema Workbench for improved data management.
Executed cost-benefit analysis on market trends, implementing optimal pricing strategies for a 20% cost reduction.
Introduced Time Series Forecasting in Tableau for strategic sales planning, resulting in a 30% increase in operational efficiency.
Monitored and verified ETL jobs and data, coordinating with the team for deployment and maintaining awareness of production activities.
Significantly contributed to Android application development, showcasing a strong foundation in coding, testing, and debugging processes.

App Developer & Support

Abudawood Trading Co., Karachi, Pakistan

Efficiently accomplished various ERP tools, including "Snd_Pro" and "Sales Force One SFO" with SAP integration.
Successfully oversaw the development of an internal web portal for the company, leveraging Asp.Net and SQL.
Developed Force One SFO portal using Asp.Net and SQL.

Intern as UI/UX Designer

Abudawood Trading Company, Karachi, Pakistan

Actively performed tasks as a UI/UX designer during the internship.
Designed front end of inhouse web portal.

Skills

ETL Data Integration and Transformation (ETL) SQL Database T SQL Dashboards Data Cleansing ETL Process Management PL/SQL Power BI Python SQL Java C# T-SQL DAX MDX MS SQL Tableau MySQL PostgreSQL MS Excel QlikView SSRS SSIS AWS SDLC Agile Waterfall Predictive Analysis Prescriptive Analysis Data Modeling Data Cleaning Snowflake Data Warehousing Data Wrangling Data Integrity Data Manipulation Data Quality Presentation Skills Problem-Solving Ad hoc analysis Reporting Workflow Data Visualization Spark SQL Presto AWS Glue Statistical Analysis Hadoop Spark Hive Pentaho Mondrian Schema Workbench Time Series Forecasting SSAS SAP
Report this Profile?