Meet Shah
Chicago,IL
Work Preference
Work Type
Full TimeLocation Preference
RemoteSummary
- Experienced Data Analyst with 3+ years of expertise, proficient in SQL, Python, R, Tableau, and advanced Excel, with strong knowledge of statistical modeling, forecasting, and dynamic visual reporting.
- Experienced in building automated ETL pipelines, improving data integrity, and reducing processing time and errors.
- Skilled in Salesforce reporting, Oracle databases, and emerging tools like Alteryx for data transformation and automation.
- Proven ability to design, develop, and deliver performance metrics and dashboards in fast-paced, customer-focused environments.
- Adept at handling complex ad hoc requests, optimizing reporting workflows, and implementing process improvements to ensure data accuracy, security, and consistency.
- Recognized for collaborative communication, strong organizational skills, and a results-driven approach that supports strategic decision-making.
- Designed and managed big data workflows using AWS, Azure, and Hadoop (YARN, Hive), ensuring scalable data storage, processing, and retrieval for analytics and reporting.
- Developed and optimized data pipelines leveraging Apache Spark, Flink, Kafka, and Airflow to enable real-time streaming, orchestration, and efficient data processing across distributed systems.
Overview
5
5
years of professional experience
Work History
Data Analyst
Maitri Diamonds
IL
09.2022 - Current
- Analyzed sales, inventory, and customer data using SQL and Excel to identify trends, optimize stock levels, and support data-driven decision-making for business growth.
- Built automated SQL, Python, and Alteryx workflows for data cleaning, transformation, and blending from multiple sources (SQL, Excel, CSV); reduced manual processing time by up to 50% and enhanced data quality through validation routines.
- Designed and optimized data pipelines using Apache Airflow, Apache Kafka, and Spark, enabling real-time and batch processing of large datasets across cloud and on-premise environments.
- Built and deployed ETL workflows on AWS (Glue, EMR, Lambda, S3, Redshift, DynamoDB) and Snowflake, improving scalability, performance, and cost efficiency of data solutions.
- Developed data models and transformations with dbt, SQL, and BigQuery, ensuring reproducibility, high data quality, and integration with BI tools such as Tableau, Power BI, and Looker.
- Implemented machine learning workflows and statistical analysis using Python, R, PySpark, NumPy, and Seaborn, delivering actionable insights to support business strategy.
- Designed data models and transformations in SQL and dbt, improving reporting accuracy and reproducibility.
- Created statistical models and forecasting techniques in Python and R to support sales and marketing strategies.
- Implemented validation routines to ensure high-quality data reporting and accuracy across departments.
- Automated data ingestion and transformation using a Python script, streamlining message retrieval from SQS and secure storage in PostgreSQL.
Data Analyst
AV DEVS Solutions
India
08.2021 - 07.2022
- Company Overview: AV DEVS Solutions is a data analytics company focused on providing innovative solutions for business intelligence and data management.
- Performed credit risk analytics using R and statistical modeling, improving risk profiling accuracy and reducing loan default rates by 20%.
- Developed fraud monitoring dashboards and complex SQL queries, enabling early fraud detection and avoiding $2M in potential losses.
- Created dynamic Tableau dashboards to track financial KPIs and customer behavior, improving investment decision-making and resource allocation.
- Built an AWS data lake ingesting TB from 10+ sources (DMS, ECS, EMR, Databricks) and a Snowflake warehouse.
- Applied Scrum and Waterfall methodologies to manage data analytics projects, balancing iterative sprints for rapid insights with structured, phase-based approaches for large-scale reporting and data pipeline initiatives.
- Built dynamic Tableau dashboards to track financial KPIs and customer trends for management.
- Applied SQL and Python to analyze large financial datasets, uncovering insights that increased revenue by 15%.
- Created reports and dashboards in Power BI for executive decision-making and KPI monitoring.
- Standardized reporting processes using advanced Excel and Power Query, reducing manual processing by 30%.
- Designed and implemented data warehouse solutions in Snowflake/Redshift/BigQuery, consolidating data from 10+ sources.
- Used Power Query (M language) and advanced Excel (VLOOKUP) for large dataset transformations, reducing manual processing by 30%.
- Conducted advanced analytics in SQL and Python (Pandas, NumPy) to uncover insights that increased revenue by 15%.
- Designed Tableau and Salesforce dashboards to provide executives with real-time insights into customer trends and product performance.
- AV DEVS Solutions is a data analytics company focused on providing innovative solutions for business intelligence and data management.
Data Analyst Intern
AV DEVS Solutions
India
01.2021 - 07.2021
- Company Overview: AV DEVS Solutions is a data analytics company focused on providing innovative solutions for business intelligence and data management.
- Developed Python- and SQL based fraud detection models, reducing fraudulent payouts by 18% and saving $1M annually.
- Designed and developed interactive dashboards using Tableau, Power BI, Advanced Excel, and Python libraries (Matplotlib, Seaborn, Plotly) to visualize KPIs, trends, and business insights for decision-making.
- Built interactive Tableau dashboards visualizing policy trends, claims data, and demographics, enabling high-risk region identification and optimizing policy offerings.
- Automated ETL workflows in Python for claims processing and reporting, improving data quality and saving 15+ hours per week.
- Implemented Beaker Build in a greenfield ML environment, ensuring scalable and reproducible experiment tracking.
- Created time intelligence calculations in DAX (YTD, MTD, Rolling Averages) for advanced performance analytics.
- Automated data ingestion from APIs, databases, and flat files into data warehouses, reducing latency and increasing availability.
- Extracted and analyzed data from S/4HANA (FI, MM, SD) modules to support finance, procurement, and supply chain reporting.
- Developed scalable ETL workflows with dbt and SQL on Snowflake to transform Airbnb datasets into analytics-ready tables, leveraging Snowflake features like virtual warehouses, schema design, and incremental models for optimized performance.
- Managed raw data ingestion via AWS S3, while ensuring high standards of data quality, reproducibility, and documentation to support reporting and BI integration.
- Partnered with business units to analyze contracts and claims, driving quality improvements and loss mitigation.
- AV DEVS Solutions is a data analytics company focused on providing innovative solutions for business intelligence and data management.
Education
Master of Science - Computer Science
05.2024
Bachelor of Engineering - Computer Engineering
05.2022
Skills
- Project Management Approaches Agile
- Project Management Approaches Scrum
- Project Management Approaches Waterfall
- Data Visualization Tableau
- Data Visualization Power BI
- Data Visualization Advanced Excel
- Data Visualization Matplotlib
- Data Visualization Seaborn
- Data Visualization Plotly
- Data Processing & Analytics NumPy
- Data Processing & Analytics Pandas
- Data Processing & Analytics PySpark
- Data Processing & Analytics DBT
- Data Processing & Analytics Data Pipelines
- Databases & Data Warehousing MySQL
- Databases & Data Warehousing Oracle
- Databases & Data Warehousing Microsoft SQL Server
- Databases & Data Warehousing SSMS
- Databases & Data Warehousing PostgreSQL
- Databases & Data Warehousing MongoDB
- Databases & Data Warehousing Snowflake
- Databases & Data Warehousing Teradata
- Databases & Data Warehousing Elasticsearch
- Databases & Data Warehousing Hive
- Programming Languages SQL
- Programming Languages Python
- Programming Languages R
- Big Data & Cloud Tools AWS
- Big Data & Cloud Tools Azure
- Big Data & Cloud Tools Hadoop
- Big Data & Cloud Tools Apache Spark
- Big Data & Cloud Tools Apache Flink
- Big Data & Cloud Tools Apache Kafka
- Big Data & Cloud Tools Apache Airflow
- Infrastructure as Code & DevOps Terraform
- Infrastructure as Code & DevOps Git
- Infrastructure as Code & DevOps GitHub
- Infrastructure as Code & DevOps GitLab
- Operating Systems Windows
- Operating Systems Linux
- Software & Collaboration Tools Jupyter Notebook
- Software & Collaboration Tools Microsoft Office Suite
- Software & Collaboration Tools Zendesk
Personal Information
- Title: Data Analyst
- Visa Status: STEM OPT
- Work Permit: STEM OPT
Languages
English
Bilingual or Proficient (C2)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Interests
Data Analyst
Timeline
Data Analyst - Maitri Diamonds
09.2022 - Current
Data Analyst - AV DEVS Solutions
08.2021 - 07.2022
Data Analyst Intern - AV DEVS Solutions
01.2021 - 07.2021
Governors State University - Master of Science, Computer Science
Gujarat Technological University - Bachelor of Engineering, Computer Engineering
Similar Profiles
Apurva PatelApurva Patel
Marketing & Sales Executive at Maitri Diamonds Inc.Marketing & Sales Executive at Maitri Diamonds Inc.
Bharatkumar PatelBharatkumar Patel
Electrician Supervisor at Maitri Lab Grown DiamondsElectrician Supervisor at Maitri Lab Grown Diamonds
Grant RicahrdsGrant Ricahrds
Director of Sales at Maitri MedicinalDirector of Sales at Maitri Medicinal
Jonathan TorsuJonathan Torsu
Accountant at Volkswagen Financial Services - UKAccountant at Volkswagen Financial Services - UK
Kimberly WoodKimberly Wood
Caretaker at Self EmployedCaretaker at Self Employed