Experience

Sep **** - Data Analyst Illinois Tutoring Initiative

May 2023

• Developed a student engagement program, resulting in a 25% grade and a 35% reduction in no-show sessions.

• Extracted and segmented student data, performed data analytics to inform insights & data-driven decisions by 90% data summarizing

• Assisted in written and verbal communication for reports, feedback, and client presentations on new programs and improvements. Environment•Microsoft Excel [Lookup’s Conditional Formatting Pivot tables ]• Documentation•SharePoint•Google Docs•Outlook May 2022 - Research Assistant - Data Engineer Northern Illinois University Aug 2022

• Orchestrated a robust CI/CD data pipeline for seamless data flow and transformation of 10+ JSON files containing confidential data

• Performed cataloging and querying to raw data for ETL Process

• Developed user defined function to trigger data for data wrangling

• Applied data migration strategy to store transformed data in S3 Environment•AWS [S3, Lambda, Glue, Athena, QuickSight, IAM] • Cloud Adminstrator• Linux• ETL Pipeline• Data Cleaning Dec 2020 - Marketing Analyst The Forage

Jul 2021

• Engaged in client communication, gathering business require- ments, and delivering data insights to support business strategies

• Collaborated with cross functional teams to integrate flat files, en- hance testing and quality assurance resulted in 98% data accuracy

• Developed calculated fields, interactive dashboard including met- rics, trends, KPIs, insights for to client produced a 10% retention Environment:Microsoft Visual Studio•MSSQL•SSIS•SSRS•.NET Framework• Flat Files•Tableau•StoryTelling•Windows•ETL/ELT Projects

12/22 - 01/23 Data Engineer Qescapades Pvt Ltd

• Constructed and implemented data pipeline to model the data, in- gested through webscrapping using Python, GCP, and Mage Environment: Cloud Storage•Database• Compute Engine• Cloud Shell•BigQuery• SSH• BeautifulSoup• Pandas•NumPy• ERD•RDBMS•Jupyter Notebook•Looker•Requests•Data Mining 08/22 – 12/22 Project Lead Iowa Liquor Sales Analysis

• Directed a team of 4 using Agile Scrum for building predictive mod- els to forecast sales using machine learning algorithms Environment:Logistic Regression•Linear Regression•Tableau• MySQL•Scikit-learn•Quantitative Analysis•Statistical Analysis 01/22 – 03/22 Data Analyst Google Play Store Analytics

• Created PySpark Databricks cluster for data manipulation, Analysis Environment:PySpark•DataBricks•SparkQL•Data Processing 08/21 – 12/21 Data Analyst Census Income Data Analytics

• Conducted Exploratory data analytics to address the unclear data

• Built ML models to identify trends, metrics, and patterns in salaries Environment: DAX•SAS•NLP•PowerBI•Power Query•Decision Tree•Problem-solving•Random Forest•Ad hoc Report•R-Studio Education

2021 - 2023 Northern Illinois University Dekalb, IL Master’s in Management Information Systems GPA: 3.6/4.0 Asmathullah Shaik

Data Engineer Data Analyst

+1-779-***-****

ad0sdj@r.postjobfree.com

/in/asmathullah-shaik/

Skills

Data

Engineering

Data

Modeling

Data

Integration

Analytical

Skill

Data Pipeline Data

Visualization

Cloud

ETL Tools

0 LOC 5000 LOC

AWS• GCP • Snowflake

Data WareHouse• SQL•ETL•Snowflake

Jira• SDLC [Agile Kanban]• Waterfall

SAP [•FI•CO•WHM•LE•MM•SD]

Hadoop• Spark•Beam• Airflow•Mage

GCP• AWS • Docker• Kuberenetes

SSIS•SSRS•Microsoft Dynamics

Schema[Star, Snowflake]•Normalization

MongoDB• MySQL• Sqoop •HBase

PowerBI•Tableau •Looker•LucidCharts

Certifications

Google Data Analytics

SAS Data Analytics

Google Cloud Professional Data Engineer

Lean Six Sigma

Cisco Data Analytics and Science

Contact this candidate