IMPANA GANAPATHI SHETTY
Summary
Data and Business Analytics professional with a background in SQL, Power BI, and ETL automation across healthcare, finance, and operations. Builds centralized dashboards, streamlines reporting workflows, and turns complex data into reliable KPI visibility that supports faster decision-making and reduces manual effort.
Overview
6
6
years of professional experience
Work History
Operations Data Analyst
New Jersey Institute of Technology
Newark, NJ
09.2024 - 05.2026
- Implemented an automated ETL pipeline ingesting daily campus event logs and operational records into a structured, analytics ready dataset, delivering real-time KPI visibility to department heads and eliminating 5+ hours per week of manual data consolidation; utilized Claude Code (AI-assisted development) to accelerate pipeline scripting and testing cycles.
- Designed, developed, and maintained a centralized operations dashboard consolidating real-time data across 50+ campus events per semester, enabling leadership to monitor event status, resource utilization, and attendance KPIs with zero manual reporting overhead; implemented and integrated Claude AI (Anthropic) as a core development accelerator for automated script generation, data workflow automation, and rapid iteration cycles.
- Built and managed a financial operations dashboard to track client payment status, outstanding invoices, and revenue collection across all campus events; automated aging report alerts and payment status notifications, reducing outstanding payment resolution time by 30% and improving accounts receivable visibility for finance stakeholders.
- Monitored client pay sheet and financial settlement records, developed exception-reporting views to flag unpaid invoices, billing discrepancies, and overdue accounts; partnered with finance and operations teams to streamline collections workflows and reduce resolution cycle time.
Business Intelligence analyst
PlanSource Operations Pvt Ltd
05.2023 - 08.2024
- Led the design and implementation of an enterprise healthcare analytics platform using Azure ADLS Gen2, Databricks, Snowflake, integrating enrollment, claims, eligibility, and utilization data from SQL Server, REST APIs, and major insurance carriers across 100+ employer clients.
- Automated ingestion pipelines using Azure Data Factory and Databricks and optimized SQL, DAX, and Snowflake workloads, reducing manual effort by 6+ hours/week, dashboard load time by 30%, reporting latency to near real-time, and data quality issues by 35%.
- Defined ETL transformation logic for data cleansing, deduplication, and standardization; validated data using SQL across staging, warehouse, reporting layers to ensure data integrity.
- Designed dimensional data models using star schema principles for claims, enrollment, members, providers, employers, plans; developed 15+ HIPAA-compliant Power BI dashboards with dynamic RLS, enabling standardized reporting of 40+ KPIs.
- Gathered business and functional requirements, creating BRDs, FRDs, user stories, acceptance criteria, RTMs, Source-to-Target Mapping documents to align technical specifications with business needs.
Associate Business Data Analyst
Cognizant
10.2022 - 05.2023
- Developed a demand forecasting model in Python (pandas, scikit-learn) using 3 years of historical data, improving forecast accuracy by 22% and enabling procurement teams to reduce overstock costs and improve inventory planning.
- Designed and deployed 8 SSIS ETL pipelines to integrate 5 source systems into centralized SQL Server data warehouse; performed UAT and data validation, improving data freshness from daily to hourly and reducing reporting errors by 35%.
- Developed sales performance intelligence platform in Power BI, integrating SQL Server, Salesforce CRM, and logistics APIs; conducted UAT testing with business stakeholders to validate KPIs and dashboard functionality, enhancing reporting accuracy for regional sales teams.
Business Analyst Intern
Cognizant
10.2021 - 10.2022
- Performed exploratory data analysis (EDA) on transactional and operational datasets using Python (pandas, NumPy) to identify trends, outliers, and data quality issues, directly supporting data-driven decision-making for business stakeholders.
- Optimized SQL queries to extract, clean, and validate data from relational databases, producing weekly business performance reports and ad-hoc analysis that informed senior analysts' decision-making.
- Built interactive Power BI dashboards to visualize KPIs, including order volume, inventory turnover, and revenue trends, facilitating timely operational insights for management teams.
Machine Learning Intern
Technofly Solutions
08.2020 - 04.2021
- Developed and evaluated machine learning models using Python, Pandas, and Scikit-learn, conducting data cleaning, preprocessing, feature engineering, and exploratory analysis to enhance dataset structure and increase prediction accuracy.
- Compared multiple machine learning algorithms through performance metrics like accuracy, precision, recall, and F1-score, documenting results for technical and business stakeholders to inform decision-making.
- Developed machine learning models for Technofly Solutions data workflows
- Prepared datasets from Technofly Solutions sources for training and testing
- Reviewed model outputs and flagged errors for team correction
Education
Master of Science - Information Systems
New Jersey Institute of Technology
Newark, NJ05-2026
Bachelor of Engineering - Information Science
PES College of Engineering
India03-2022
Skills
- Business intelligence tools
- Data visualization
- Advanced Excel and Power BI
- SQL and Python proficiency
- Data pipeline orchestration
- Data cleaning
- Data pipeline optimization
- Databases and data platforms
- Operational performance analysis
- Statistics and analytics expertise
Timeline
Operations Data Analyst
New Jersey Institute of Technology
09.2024 - 05.2026
Business Intelligence analyst
PlanSource Operations Pvt Ltd
05.2023 - 08.2024
Associate Business Data Analyst
Cognizant
10.2022 - 05.2023
Business Analyst Intern
Cognizant
10.2021 - 10.2022
Machine Learning Intern
Technofly Solutions
08.2020 - 04.2021
Master of Science - Information Systems
New Jersey Institute of Technology
Bachelor of Engineering - Information Science
PES College of Engineering