Data Analyst Business Intelligence

Vidya Kulkarni Data Analyst

+1-984-***-**** *****************@*****.*** Dallas, TX LinkedIn SUMMARY

Data Analyst with 4+ years of experience in data modeling, statistical analysis, and business intelligence. Proficient in SQL, Python (Pandas, NumPy), and data visualization tools like Tableau and Power BI. Skilled in building ETL pipelines, conducting exploratory data analysis (EDA), and optimizing reporting workflows to improve operational efficiency. Experienced in handling large datasets, identifying key performance trends, and automating data-driven processes to support strategic decision-making. Leveraging data to enhance business performance and drive actionable insights. SKILLS

Programming & Scripting: SQL, Python (Pandas, NumPy, Scikit-learn), R, DAX, Bash/Shell Scripting Data Analysis & Visualization: Excel (Pivot Tables, Macros, VLOOKUP), Tableau, Power BI, QuickSight, Looker Databases & System Administration: Oracle SQL, PL/SQL, MySQL, PostgreSQL, User Role Management, Workflow Customization, System Troubleshooting

Version Control & DevOps: Git, GitHub, Docker, Kubernetes, CI/CD (Jenkins, GitHub Actions) Big Data & Data Warehousing: Snowflake, AWS (Athena, Redshift, S3), Apache Spark, Hive ETL & Data Processing: SQL*Loader, Alteryx, Informatica, Airflow, Apache Spark Statistical Analysis: Regression Analysis, Predictive Modeling, A/B Testing BI & Reporting: KPI Dashboards, Report Automation, Data Storytelling, Business Strategy Alignment Project Management: Jira, Asana, Confluence

Soft Skills: Problem-Solving, Business Impact Analysis, Written and Verbal Communication, Attention to Details, Best Practices, Troubleshooting, Continuous Learning & Continuous Improvement EXPERIENCE

Data analyst, Humana 07/2024 – Present TX

• Optimized patient claims processing pipelines, reducing data retrieval time by 30% through the implementation of SQL-based indexing and query optimization, leading to faster insurance approvals.

• Developed and maintained 10+ interactive dashboards in Tableau and Power BI, enabling real-time tracking of key healthcare metrics such as patient readmission rates, claim processing times, and provider performance.

• Conducted in-depth statistical analysis on 1M+ patient records, identifying trends in chronic disease management that contributed to a 15% increase in early intervention strategies for at-risk patients.

• Automated SQL-based data validation workflows, reducing manual data entry errors by 95% and ensuring compliance with regulatory reporting standards for Medicare and Medicaid services.

• Collaborated with cross-functional teams, including clinicians, business analysts, and IT specialists, to refine business intelligence strategies, leading to a 20% improvement in operational efficiency.

• Designed ETL workflows to integrate multiple healthcare data sources (EHR, claims, and provider data), ensuring seamless data consolidation and improving reporting accuracy.

• Improved fraud detection models by analyzing historical claim patterns, identifying anomalies that helped reduce fraudulent claims by $500K annually.

• Led process automation initiatives for regulatory compliance reporting, reducing report preparation time from 10 hours to 2 hours per report, enhancing efficiency for the finance and compliance teams. Data Analyst, Cybage Software 08/2021 – 12/2022 India

• Designed and implemented SQL-based customer segmentation models, enhancing targeted healthcare outreach programs that increased patient engagement rates by 25%.

• Developed interactive self-service BI dashboards for stakeholders, reducing reliance on manual report requests and enabling real-time access to KPIs related to financial performance and operational efficiency.

• Optimized healthcare data storage strategies using Snowflake and AWS Athena, improving query performance by 60%, reducing report generation time by 50%, and cutting storage costs.

• Engineered and optimized ETL pipelines for an agriculture client, handling 500K+ data points daily, enabling real- time yield forecasting that helped reduce supply chain inefficiencies by 30%.

• Designed a fraud detection framework that helped healthcare clients identify anomalies in billing patterns, preventing

$1M+ in fraudulent claims annually.

• Managed the data migration of 5TB+ patient records for a Fortune healthcare provider, ensuring zero downtime and seamless integration with existing electronic health record (EHR) systems.

• Automated data pipeline workflows with Apache Airflow, improving batch data processing efficiency by 40%, reducing the frequency of ETL failures.

Data analyst, Citius Tech 08/2019 – 07/2021 India

• Built predictive analytics models for agriculture supply chain forecasting, reducing supply chain delays by 20% and improving distribution efficiency by 25% through advanced time-series analysis.

• Analyzed crop production data from 10K+ farms, leveraging SQL and Python (Pandas, NumPy) to identify weather- based yield patterns, improving harvest accuracy by 15%.

• Developed and deployed SQL-based ETL workflows processing 100K+ records daily, improving real-time farm monitoring and reporting accuracy.

• Designed a pricing optimization model for agricultural commodities, allowing stakeholders to make data-driven pricing decisions that increased profit margins by 12%.

• Implemented an automated KPI tracking system for agricultural operations, cutting manual reporting workload from 10 hours to 2 hours per week, improving productivity.

• Spearheaded the integration of IoT sensor data with cloud-based analytics platforms, enabling farm owners to monitor soil quality, irrigation levels, and crop health in real time.

• Improved the accuracy of yield prediction models by leveraging satellite imagery data, resulting in 10% better harvest forecasting and reducing inventory wastage. EDUCATION

Masters in Information Systems and Technology 01/2023 – 06/2024 University of North Texas, TX

Masters in Farm Machinery and Power Engineering (Gold Medalist) 08/2017 – 07/2019 University of Agricultural Sciences, India

Bachelors in Agricultural Engineering 08/2013 – 07/2017 University of Agricultural Sciences Raichur, India CERTIFICATION

Microsoft Certified Power BI Data Analyst Associate (PL300)

Contact this candidate