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.
Grant RicahrdsGrant Ricahrds
Director of Sales at Maitri MedicinalDirector of Sales at Maitri Medicinal
Madeleine (Maddie) Campbell-JonesMadeleine (Maddie) Campbell-Jones
Behavior Support Specialist (BSS) at Maitri Mental HealthBehavior Support Specialist (BSS) at Maitri Mental Health
Anna Levina, NP-BCAnna Levina, NP-BC
Emergency Department RN at Multiple AgenciesEmergency Department RN at Multiple Agencies
EDDY GRAFFEEDDY GRAFFE
Digital Strategy Consultant & Marketing Project Lead at Antena Tres Directo (A3D)Digital Strategy Consultant & Marketing Project Lead at Antena Tres Directo (A3D)