Data Analyst Power Bi

Chaitanya Kumar Balivada

Hartford, CT *******************@*****.*** 959-***-**** linkedin.com/in/chaitanya-kumar-balivada Education

University of Connecticut

Masters, Business Analytics and Project Management January 2023- May 2024

CGPA:3.83/4.0

National Institute of Technology, Rourkela

Bachelors, Mining Engineering

August 2015-May 2019

Skills

Languages:

Data Engineering Tools:

Microsoft Excel, Python, R, SQL

Kubernetes, Kafka, Airflow, Dagster

Visualization:

Data Management:

Excel, Matplotlib, Power BI, Seaborn, Tableau

Microsoft SQL Server, ETL

Analytical: Data cleaning, Data Mining, Data Modeling, Time Series Forecasting Machine Learning: Linear Regression, Logistic Regression, SVM, K-Means, Random Forest, KNN, Boosting, CNN, RNN, LSTM, Deep Neural Networks, Ensemble Learning, XG-Boost, GAN, Predictive modeling Project Management: Agile, Scrum, Jira, Confluence, SDLC Experience

Graduate Data Analyst - CT transit January 2024- April 2024

• Collaborated with stakeholders to assess operational challenges through data analysis, resulting in a 15% reduction in travel times and a 20% increase in operational efficiency over four months.

• Analyzed data from customer feedback, transportation logs, and route optimization algorithms using Power BI and SQL Server; identified inefficiencies and bottlenecks, leading to a 25% improvement in delivery times and customer satisfaction.

• Monitored solution effectiveness through KPI dashboards in Power BI, tracking metrics such as on-time delivery rates

(98%), fuel efficiency (15% improvement), and customer satisfaction scores (increased by 10%). Sr Data Analyst – Technogrid IT Systems May 2019- December 2022

• Utilized SQL queries (JOIN, GROUP BY, WHERE) and Python (pandas, numpy) along with Power BI for data visualization, reducing claim processing time by 25% and increasing operational efficiency by 30%.

• Spearheaded predictive analytics projects using Python (scikit-learn for predictive models) and SQL (data extraction), resulting in a 15% increase in retention rates and a 10% reduction in fraudulent claims.

• Extracted and refined customer and policy data using SQL (SELECT, UPDATE) and Excel (VLOOKUP, PivotTables) to enhance data quality and integrity, achieving a 15% reduction in data-related errors and a 30% improvement in access speeds.

• Designed and developed interactive dashboards in Power BI and Tableau, using DAX functions for data modeling, providing stakeholders with real-time data for informed decision-making.

• Conducted in-depth claims analysis and fraud detection using SQL (CASE statements, subqueries) and Python (data analysis with pandas), identifying fraudulent claim patterns and improving fraud detection capabilities by 20%.

• Executed customer segmentation based on demographics and behavior using Python (clustering models with scikit- learn) and SQL, boosting campaign effectiveness by 25% through targeted marketing strategies.

• Developed predictive models using Python (logistic regression, decision trees) to identify at-risk customers, enhancing policy renewals by 10%.

• Spearheaded market research initiatives, utilizing SQL (JOIN, SELECT) and Excel (PivotTables, VLOOKUP) to identify new business opportunities and emerging trends, increasing market share by 15% through strategic insights and competitive analysis.

• Cultivated and maintained key client relationships, leveraging Excel (customer data analysis) and CRM software to enhance client retention and satisfaction by 20%.

• Implemented effective feedback mechanisms using Excel (survey data analysis) and Python (data visualization with matplotlib) to improve service delivery by 10%.

• Formulated and executed sales strategies, driving a 25% increase in annual sales through data-driven decision-making and targeted marketing.

• Coordinated efforts with marketing, product development, and operations teams to ensure seamless execution of business initiatives, enhancing process efficiency by 15% through effective interdepartmental communication.

• Generated insightful reports on business development activities using SQL (report generation) and Excel (data analysis), highlighting key achievements and contributing to a 20% overall performance improvement. Data Analyst – Life Insurance Corporation of India May 2017- April 2019

Contact this candidate