Data Analyst Power Bi

Deepak Kumar Kunda

FL, US +1-386-***-**** *****************@*****.***

SUMMARY

Data Analyst with 3+ years of experience transforming raw data into actionable insights across finance, healthcare, and retail. Demon- strated expertise in developing design solutions, crafting test scenarios, and refining requirements to ensure seamless integration into applications. Skilled in PL/SQL, data visualization, and agile methodologies, consistently driving accurate, data-driven decisions and efficient work estimation.

EDUCATION

University of Central Florida Aug 2023 - May 2025

Masters, Data Analytics

RGUKT - Srikakulam, India Jul 2018 - May 2022

Bachelor of Technology, Computer Science and Engineering PROFESSIONAL EXPERIENCE

Capital One Financial Jan 2025 - Present

Data Analyst US

• Developed design solutions and integrated robust Power BI dashboards using DAX and Power Query to track acquisition cost, reducing campaign performance reporting time by 45% across 12 U.S. markets.

• Automated weekly compliance reporting by constructing test scenarios through Python, Airflow, and SQL, reducing manual input by 60% while ensuring zero SLA breaches over 30+ cycles.

• Engineered data integration processes by processing 10M+ transactions using dbt and PySpark from Snowflake, enhancing credit product analytics and reducing fraud detection latency by 18%.

• Conducted A/B testing as a proof of concept in Python and R, supporting mobile redesign decisions that improved new user conversion by 14% and reduced first-session churn.

• Built dbt models for campaign pipelines in Redshift, enabling team work estimation improvements by enhancing query performance by 30% and reducing downstream ad hoc processing time. Accenture Oct 2021 - Aug 2023

Associate Analyst India

• Developed design solutions by building Power BI dashboards for hospital clients, leading to an 11% reduction in 30-day readmission rates through identifying care gaps and optimizing discharge follow-ups.

• Crafted Python scripts using Regex and Pandas to refine test scenarios for detecting billing inconsistencies, recovering $1.2M in overpaid claims and supporting finance audit trails.

• Revamped Talend-based ETL pipelines to BigQuery, contributing to effective story refinement and work estimation by increasing pipeline success rate by 37% and reducing manual error interventions during critical nightly loads.

• Automated actuarial model forecasts in Excel using Python and VBA, validating test scenarios and saving over 20 hours monthly while enhancing version control for actuarial projections. Proost Healthcare Solutions Apr 2021 - Sep 2021

Analyst Intern India

• Engineered design solutions with Alteryx to enhance patient data quality for seamless integration into Clinical Decision Support Systems, resulting in a 20% increase in personalized treatment plan accuracy.

• Leveraged SQL, Python, and Tableau to analyze patient data and support story refinement for targeted marketing strategies, boosting referral services and elevating user engagement on a healthcare portal.

• Identified key relationships using Python heatmaps, discovering a strong positive correlation between patient age and re-admission rates, and presented insights through 6+ Tableau reports to support integrated decision-making. PROJECTS

MLOPS Ecosystem

• Engineered a robust MLOps ecosystem using Python SDK on Azure ML, reducing deployment times by 30%.

• Orchestrated the development of an advanced analytics aggregation system within a Jupyter Notebook environment, utilizing an MLFlow dashboard to enhance the accuracy of time series forecasting model by 15%.

• Implemented semantic kernel to enrich context aggregation across inference calls, improving model accuracy by LLM. Health Insurance Premium Prediction

• Performed exploratory data analysis using Pandas and NumPy, identifying crucial premium cost influencers.

• Achieved 94% accuracy by optimizing models through extensive cross-validation and hyperparameter tuning.

• Executed predictive modelling on insurance data, which informed the enhancement of premium pricing strategies. Supply Chain Optimization

• Developed a machine learning model to forecast demand, resulting in a 25% reduction in overall inventory costs.

• Boosted inventory turnover by 40%, ensuring timely replenishment and effectively minimizing holding costs. Skin Cancer Detection Using CNN

• Achieved 85% accuracy in melanoma classification using a CNN model, significantly improving speed and consistency.

• Enhanced model robustness through data augmentation on 220 dermoscopy images, ensuring reliable performance. TECHNICALSKILLS

• Programming & Scripting: Python (Pandas, NumPy, Regex, JSON), SQL (T-SQL, PL/SQL), R (dplyr, ggplot2), Excel VBA

• Data Visualization: Power BI (DAX, Power Query), Tableau, Looker, Matplotlib, Seaborn, Plotly

• Databases: PostgreSQL, MySQL, MS SQL Server, Oracle, Oracle Exadata, MongoDB, Google BigQuery

• ETL & Workflow Tools: Apache Airflow, dbt, Talend, AWS Glue, Azure Data Factory, SSIS

• Cloud & Data Warehousing: Snowflake, Amazon Redshift, Google BigQuery, Azure Synapse, AWS S3, GCP Cloud Storage

• Analytics & Statistics: Descriptive and Inferential Statistics, Hypothesis Testing, A/B Testing, Regression Analysis, Time Series

• Business Intelligence: Power BI, Tableau, Excel (Pivot Tables, Power Query, VLOOKUP, Macros), Looker, Microsoft Office Suite

• Machine Learning: Scikit-learn (Linear/Logistic Regression, Clustering), Time Series Forecasting

• APIs & Web Scraping: RESTAPIs, Postman, Python Requests, BeautifulSoup

• Data Engineering Basics: PySpark, Spark SQL, Parquet, CSV, JSON formats

• Data Privacy & Governance: Data Quality Checks, Data Masking, HIPAA/GDPR Compliance

• Version Control: Git, GitHub, GitLab

• Methodologies: Agile/Scrum

Contact this candidate