Summary
Work History
Education
Skills
Websites
Projects
Technical Skills
Timeline
Generic

Tanuj Rathi

Chicago,USA

Summary

Business Analytics professional with expertise in dashboard creation, dataset analysis, and facilitating data-driven decisions for operational and strategic projects. Proficient in SQL, Python, Power BI, Tableau, and Excel, with proven experience in data quality validation and reporting automation. Strong knowledge of data governance, ETL processes, and system integrations, capable of converting business needs into actionable insights and scalable reporting solutions.

Work History

Data Analyst Intern (Academic Project)

Trust Clarity Inc
Chicago, USA
05.2024 - 08.2024
  • Generated weekly and monthly performance reports using Excel and SQL, supporting departmental KPIs and operational decision-making.
  • Conducted data validation by comparing values across systems, identifying inconsistencies, and performing routine data audits.
  • Participated in stakeholder meetings to gather reporting requirements and translate business needs into structured report templates.
  • Shadowed senior analysts through the report development lifecycle, gaining exposure to testing, deployment, and documentation.
  • Created data flow diagrams, report logic documentation, and workflow guides to improve transparency and cross-team communication.
  • Assisted in building visual summaries and lightweight dashboards using Excel, Power BI, and Access.
  • Monitored SFTP data interfaces and automated data feeds to ensure continuous and accurate data exchange.
  • Supported quality improvement initiatives by organizing datasets, updating tracking sheets, and ensuring compliance with reporting standards.
  • Environment: Excel, SQL Server, Power BI, Tableau (basic), Microsoft Access, Microsoft Teams, SharePoint, Crystal Reports, SSRS, Epic Systems (read-only), SFTP tools, ServiceNow, Agile/Scrum, Internal Data Warehouse

Education

Master of Science - Business Analytics

Trine University
Detroit, MI
12.2025

Bachelor of Commerce (Honours) -

St. Joseph’s Degree & PG College
Hyderabad, India
05.2023

Skills

  • Scikit-learn
  • SQL
  • Statistical Analysis
  • Feature Engineering
  • Data Profiling
  • Power BI
  • Tableau
  • Excel
  • SSRS
  • Crystal Reports
  • Data warehousing concepts
  • JIRA
  • Data validation frameworks
  • Data privacy
  • Data classification
  • Microsoft Teams
  • SharePoint
  • Microsoft Access
  • Windows
  • Agile/Scrum methodologies

Websites

Projects

Customer Segmentation & Revenue Optimization Analysis, SQL, Excel, Power BI, Performed customer segmentation based on spending patterns, purchase frequency, and tenure using SQL and Excel. Identified high-value and at-risk customer groups and translated insights into actionable retention and revenue optimization recommendations via interactive dashboards. Supply Chain Cost Management & Supplier Performance Analytics, SQL, Excel, Power BI, Analyzed supplier cost, volume, and lead-time data to identify inefficiencies and cost-reduction opportunities. Developed supplier performance scorecards and cost variance dashboards in Power BI to support data-driven sourcing and procurement decisions.

Technical Skills

Python (pandas, NumPy, scikit-learn), SQL, Statistical Analysis, Feature Engineering, Data Profiling, Power BI, Tableau, Excel (advanced), SSRS, Crystal Reports, ETL pipelines, Apache Kafka, data warehousing concepts, SFTP monitoring, Selenium automation, JIRA, data validation frameworks, audit checks, GDPR, HIPAA, data privacy, data classification, retention policies, Microsoft Teams, SharePoint, ServiceNow, Microsoft Access, Windows, Linux, Agile/Scrum methodologies

Timeline

Data Analyst Intern (Academic Project)

Trust Clarity Inc
05.2024 - 08.2024

Master of Science - Business Analytics

Trine University

Bachelor of Commerce (Honours) -

St. Joseph’s Degree & PG College
Tanuj Rathi