Analytics & BI Specialist with ETL Expertise

ANIKET PRAMOD SINGH

Chicago, IL (Open to relocate) +1-312-***-**** *******************@*****.*** LinkedIn Portfolio Github

SUMMARY

Data Analyst / BI Analyst with around 4 years of experience across analytics engineering, dashboard development, and ETL pipeline design. Skilled in transforming raw data into actionable insights using SQL, Python, Power BI, and Snowflake, and optimizing reporting workflows through automation, data modeling, and data governance practices. Proven ability to support cross-functional teams by delivering scalable solutions using Azure Fabric, dbt, and cloud-based ETL frameworks. Strong foundation in data warehousing, compliance tracking, and executive KPI delivery.

TECHNICAL SKILLS

●Programming & Analytics: SQL, Python (Pandas, NumPy), R, Bash, PyMongo, dbt, GitHub, A/B Testing, Data Wrangling, Statistical Modeling

●ETL & Data Engineering: ETL Pipelines, Data Cleansing, Data Migration, Snowflake, SQL Server, MongoDB, MySQL, PostgreSQL, Oracle

●Data Governance & Compliance: Role-Based Access, Referencing Rules, Lineage Tracking, Data Modeling, Metadata Management, Data Lineage

●Cloud & Infrastructure: Azure (Data Factory, Fabric), AWS (S3, Lambda), GCP, Snowflake Architecture

●Reporting: KPI Dashboards, Report Automation, Executive Dashboards, Audit Readiness, SLA Definitions, Validation Rules

●BI & Visualization: Power BI, Tableau, Looker Studio, IBM Cognos, Google Data Studio, Excel (Pivot Tables, Macros, Power Query),

●Project & Agile Tools: JIRA, Confluence, Agile Methodologies, Sprint Planning, UAT, BRD/FSD Documentation, Stakeholder Communication

PROFESSIONAL EXPERIENCE

HYPHENOVA NETWORK AUG 2024 – DEC 2024

Database Developer Intern USA

●Automated HTML and SQL reporting scripts to reduce monthly manual effort, accelerating sprint report delivery by 30%.

●Engineered automated ETL workflows using Python and Snowflake to enable scalable ingestion and transformation of API performance logs.

●Developed KPI-based Power BI and tableau dashboards to monitor daily site operations and project milestones, improving decision speed for PMO teams.

●Diagnosed and resolved backend slowness by auditing query plans and usage stats, increasing KPI reporting accuracy by 25%.

●Led end-to-end data migration of historical customer usage logs into Snowflake, applying data cleaning logic and schema harmonization.

●Developed column-level data lineage documentation using dbt and Azure Data Catalog to support governance and traceability.

●Built validation layers in SQL to enforce referential integrity and detect anomalies across critical tables powering executive dashboards.

ADANI JAN 2023 – JUL 2023

Data Analyst India

●Built automated SQL data pipelines to support regional procurement and logistics dashboards, reducing manual reporting time by 12 hours/week.

●Developed KPI-based Power BI and Tableau dashboards to monitor daily site operations and project milestones, improving decision speed for PMO teams.

●Applied data validation frameworks to cleanse supplier records and site material data, increasing reporting accuracy by 25%.

●Integrated Oracle ERP data into centralized SQL Server staging environment for unified access to spend, asset, and vendor data.

●Conducted cost-performance analysis on equipment utilization trends, contributing to $500K optimization decisions.

●Built Excel VBA automation tools to standardize field-level reporting submissions across 6 remote locations.

●Designed and maintained ETL pipelines using Python and SQL to extract, clean, and load operational data into Power BI-ready models.

BOMBAY PETROLEUM JAN 2022 – DEC 2022

Data Analyst / BI Analyst India

●Designed and maintained automated Power BI and Tableau dashboards to track compliance metrics, risk scores, and workflow KPIs across departments.

●Built and optimized SQL-based ETL pipelines to extract, clean, and load data from finance and legal systems into unified reporting layers.

●Integrated Excel macros with SQL to automate reconciliation, reducing month-end close effort by over 15%.

●Created data models and DAX measures in Power BI for drilldowns, custom KPIs, and dynamic filters tailored for compliance use.

●Analyzed 3+ years of records to identify escalation patterns, resolution lags, and audit risks; shared insights with risk leads.

●Standardized source files using Power Query and lookup logic, improving data refresh speed and report consistency.

KPMG JAN 2021 – DEC 2021

Data Analyst India

●Designed and automated Power BI and Tableau dashboards to visualize KPIs and executive reports, refine decisions for operations and marketing.

●Built and maintained ETL pipelines for multi-source data ingestion using SQL, Python (Pandas), and dbt, improving data accuracy.

●Deployed data validation frameworks in Snowflake and SQL Server, ensuring audit-readiness and SLA compliance for workflows.

●Collaborated with cross-functional teams via JIRA and Confluence to manage user stories, sprint planning, and Agile deliverables.

●Implemented access controls and metadata documentation in cloud platforms (AWS, Azure, GCP) to enhance data security and lineage.

●Authored BRDs/FSDs and supported UAT for a Snowflake migration, ensuring smooth transition and stakeholder alignment.

LARSEN & TOUBRO MAY 2019 – JUN 2019

Data Analyst Intern India

●Developed ETL pipeline using SQL and Excel macros to automate reconciliation of financial records.

●Built compliance dashboards in Power BI and Tableau to visualize submission cycles, risk metrics, and legal escalations.

●Reduced month-end close cycle by 2 business days through structured automation.

●Analyzed 3 years of legal case data for frequency and resolution rates by business unit.

●Created dynamic reports for senior legal and compliance executives using Power BI bookmarks.

●Implemented lookup normalization logic for disparate data inputs, improving retrieval speed by 20%.

●Drafted documentation templates for recurring report specs and legal review tracking sheets.

PROJECTS

USA Car Accident Model RStudio

●Conducted exploratory data analysis and statistical testing on 7.7M+ accident records using R (tidyverse, caret) to identify key predictors; built a regression model with 85 accuracy for forecasting accident risk levels.

●Validated model performance using ANOVA and chi-square tests and integrated findings into a reproducible framework, supporting decision-making for traffic safety and insurance risk profiling.

Sugar-Saver Platform SQL, Java, HTML

●Designed a relational database schema to capture real-time blood glucose patterns and implemented SQL triggers for anomaly detection, generating alerts for clinical staff and patients.

●Integrated a Java-based UI to visualize trends and enable threshold-based notifications, reducing response times by 12 hours and improving health intervention speed.

Chicago Crime Dashboard Python, Power BI

●Aggregated and processed real-time crime logs using Python (Pandas, Seaborn) and visualized patterns through Power BI dashboards, enabling analysis by zone, time, and category.

●Applied query optimization techniques to reduce dashboard query load by 40, enhancing live data refresh performance and supporting public safety initiatives.

LinkedIn Data Mart SQL, Power BI, Snowflake

●Built automated ETL pipelines with SQL and dbt to clean, transform, and integrate LinkedIn engagement data into Snowflake data marts for reporting.

●Designed Power BI dashboards with real-time KPIs across 10+ metrics, improving data availability and report generation speed by 35, enabling faster stakeholder decisions.

EDUCATION

Master’s in Information Technology and Management Aug 2023 – May 2025

Illinois Institute of Technology

Minor: Data Analytics & Business Intelligence GPA: 3.9/4.0

Bachelor of Engineering in Computer Science Engineering Jun 2017 – Jun 2020

University of Mumbai GPA: 3.9/4.0

CERTIFICATION

●IBM Data Analyst Professional Certificate, demonstrating expertise in data manipulation, visualization and analysis.

Contact this candidate