Sumary
Jignesh Kirti Nagda
I’m a Business Intelligence professional with hands-on experience in Power BI, SQL, and DAX, building dashboards and data models that transform raw data into actionable insights. At TFI, Inc. and prior roles, I’ve automated reporting, streamlined workflows, and enabled faster decision-making across child welfare, medical research, and SaaS industries. Certified as a Microsoft Power BI Data Analyst, I enjoy the fact that data work is never truly finished—there’s always a new problem to solve and a better way to deliver value.
- (812) 778-5895
- jigsshah.97@gmail.com
Education
Master of Science - Computer Science
2022 - 2024
Click here to view the Degree
Indiana University Bloomington, Bloomington, IN, USA
GPA: 3.8/4
Relevant Couresework: Elements of AI, Applied Machine Learning, Data Mining, Applied Database Technologies, Computer Vision, Data Visualization
Bachelor of Technology - Information Technology
2017 - 2021
Click here to view the Degree
University of Mumbai, Mumbai, MH, India
CGPA: 8.5/10.0
Relevant Couresework: Applied Mathematics, Data Structures & Algorithms, Object Oriented Software Engineering, Advanced Databases, E-Commerce & E-Business, Business Analytics, Big Data Analytics, Cloud Computing, Software Project Management, Software Testing & Quality Assurance
Professional Experience
Business Intelligence Analyst
September 2024 - Present
TFI Family Services, Topeka, KS, USA
- Crafted financial and operational Power BI dashboards with Paylocity and casework data, integrating ETL workflows to uncover $75K in cost leakages and reduce caseworker overload by 18%, driving workforce efficiency and financial transparency.
- Automated organizational KPIs with DAX measures and Azure Data Factory pipelines, boosting metric visibility by 70% and raising stakeholder NPS by 18 points through timely, data-driven decisions.
- Engineered cross-platform ETL pipelines within Azure, integrating Data Lake Storage, SQL Server, and Data Factory, cutting refresh latency from 60 to 10 minutes, reducing storage costs by $20K annually, and achieving 99.5% SLA reliability.
- Led migration of BI reporting to Azure DevOps CI/CD pipelines, reducing release cycle time from 5 days to 2 days and improving adoption across 200+ monthly active users (MAUs).
- Strengthened data governance with Power BI RLS and Azure Purview, reducing unauthorized access incidents by 100% and cutting null values from 8% to 2% per million rows, improving trust in reporting.
Research Data Analyst
January 2024 - September 2024
Indiana University, Bloomington, IN, USA
- Developed automated ETL pipelines in Python, Airflow, and SSIS to consolidate ADNI and CDC datasets into SQL Server, saving 15 hours/week of manual effort, improving data accessibility by 45%, and enabling faster reporting for Alzheimer’s and COPD studies.
- Implemented SQL ingestion and validation frameworks in SSIS, reducing reporting defects to fewer than 5 per million rows and cutting preprocessing time by 35%, ensuring delivery of accurate, analysis-ready datasets for cross-departmental research teams.
- Created analytical data models and SSRS reports to monitor health metrics and study outcomes, improving query performance by 50% and reducing report load times from 25s to 10s, enabling faster insights and data-driven decision-making for research stakeholders.
Data Analyst
June 2021 - July 2022
Laundriz Development India Pvt Ltd, Mumbai, MH, India
- Analyzed historical customer data with SQL and Snowflake, leveraging Power BI, identifying purchase patterns that boosted retention by 20% and generated 3,500 new customers, increasing revenue by $15K.
- Built inventory utilization reports in Power BI with advanced DAX measures and dbt-transformed data models, identifying inefficiencies that reduced stock shortages by 18% and increased order fulfillment rates.
- Developed KPI dashboards in Power BI connected to Snowflake, monitoring fulfillment, satisfaction, and turnaround metrics, improving leadership visibility of key metrics, and increasing MAU adoption from 45 to 120 users.
- Performed A/B campaign analysis using SQL, dbt pipelines, and BI dashboards, optimizing marketing spend and improving customer conversion rates by 15%, generating an additional $30K in campaign ROI.
- Established a self-service BI environment with Snowflake and Power BI, reducing ad-hoc query requests by 40% and saving the analytics team 10 hours/week in manual reporting.
Data Analyst Intern
August 2020 - January 2021
Ticekt On Go, Mumbai, MH, India
- Designed and automated Power BI and Tableau dashboards connected to SQL Server and AWS datasets, providing executives with real-time metrics on app performance and customer retention, which drove a 15% increase in active users.
- Conducted predictive ROI analysis using BI workflows, helping marketing allocate budgets more effectively and improving ROI by 14%, adding $27K in incremental revenue.
- Performed ad-hoc analysis on app usage and customer retention trends, delivering insights that helped product teams improve user experience and reduce churn.
Software Engineer Intern
January 2020 - July 2020
KJ Somaiya College of Engineering, Mumbai, MH, India
- Engineered and implemented a database schema in PostgreSQL for an EdTech project, optimizing data handling for 1M+ records.
- Crafted backend in Django, processing 2000+ grade submissions per hour and enhancing overall system responsiveness.
- Reinforced data security measures by implementing 2FA and secure access protocol, safeguarding sensitive data for over 1,000+
faculty members with zero security breaches during the internship.
- Led testing for software modules, identifying and fixing 20+ vulnerabilities, ensuring a reliable and secure grading process.