Data Analyst - SQL, Python, BI, Cloud Data Solutions

Bhanu Kolla Data Analyst

*****@**************.*** 334-***-**** USA LinkedIn GitHub

Summary

Results-driven Data Analyst with over 3+ years of experience transforming complex data into actionable insights to support business decision-making. Skilled in data analysis, statistical modeling, and building automated dashboards using tools like SQL, Python, R, Power BI, and Tableau. Proficient in working with large datasets, performing advanced analytics, and ensuring data accuracy across cloud platforms. Strong collaborator with experience in cross-functional teams, delivering high-impact solutions through data storytelling, reporting automation, and continuous process improvement. Technical Skills

• Programming & Scripting: Python (Pandas, NumPy, SciPy, Statsmodels), R (Survival Analysis), SQL (Window Functions, CTEs), Bash

• Analytical Techniques: Time Series Analysis, Cohort Analysis, Anomaly Detection, Statistical Modeling, Predictive Analytics, Descriptive Analytics, Exploratory Data Analysis (EDA), Correlation & Regression, Root Cause Analysis

• Data Preparation & Processing: AWS Glue, AWS Lambda, Azure Data Factory, Data Transformation, Data Validation, Data Cleansing, Workflow Automation, CSV & API Data Integration

• Business Intelligence & Visualization: Power BI (DAX, Drill-through, Conditional Formatting), Tableau (LOD Calculations, Dynamic Filters), Excel (Pivot Tables, Dashboards), Automated Reporting

• Databases & Cloud Platforms: AWS Athena, Azure Synapse Analytics, Relational Databases, Cloud-based Querying, Data Warehousing, SQL-based Data Modeling

• Tools & Platforms: GitHub, Jupyter Notebook, Microsoft Excel, Microsoft Office Suite, Agile (Scrum), Jira

• Data Quality & Management: Data Integrity Monitoring, Metadata Handling, Data Profiling, Data Governance, Documentation of Data Processes

• Professional Skills: Stakeholder Communication, Requirements Gathering, Cross-functional Team Collaboration, Business Requirement Translation, Agile Workflow Participation, Data-driven Decision Support Professional Experience

Data Analyst, The Carlyle Group 10/2024 – Present Remote, USA

• Worked on Portfolio Performance Analytics & Reporting Enhancement project by collaborating with Investment, Finance, and IT teams and led agile requirement gathering sessions to build an automated dashboard delivering real-time insights on portfolio KPIs which improved decision speed by 30%.

• Optimized AWS Athena queries using advanced SQL (window functions, CTEs) and managed ETL pipelines ingesting financial CSVs and operational metrics, boosting data processing efficiency by 40%.

• Performed in-depth time series and cohort analyses on portfolio financial metrics, including IRR, MOIC, and EBITDA, to identify performance trends and growth opportunities. This analysis uncovered an average growth potential of 15% and enabled early detection of underperforming assets, driving strategic decision-making and portfolio optimization.

• Applied Python with NumPy, Pandas, SciPy, and Statsmodels to perform statistical analysis and anomaly detection on financial data improving revenue growth forecasting accuracy by 25%.

• Performed data validation and cleansing using AWS Glue and Lambda within ETL workflows ensuring high data integrity and reducing reporting errors by 20% across datasets of more than 10 portfolio companies.

• Developed Power BI dashboards with drill-through filters, conditional formatting, real-time refresh, and complex DAX measures for rolling IRR and growth metrics, boosting portfolio manager productivity by 35%. Data Analyst, Bajaj Finserv 07/2021 – 07/2023 Chennai, India

• Directed data collection and aggregation for the Loan Portfolio Performance & Trend Analysis project and collaborated with Risk, Product, and IT teams in agile sprints to gather requirements and define KPIs for analyzing personal, home, and SME loan portfolios.

• Developed and optimized complex SQL queries on Azure Synapse Analytics to extract multi-year loan data and implemented ETL pipelines using Azure Data Factory for seamless data ingestion from transactional databases and external financial feeds.

• Conducted time series and cohort analysis to identify seasonality, trends, and customer repayment behavior and uncovered a 15% seasonal dip in repayments during Q3 each year that affected portfolio risk.

• Utilized Python libraries like Pandas and NumPy for data cleaning, transformation, and analysis, automating monthly reports that cut manual work by 40% and accelerated insights on loan growth and delinquency

• Applied R programming with survival analysis to predict loan default probabilities over time which improved early warning detection accuracy by 18% and allowed proactive risk mitigation and enhanced collection strategies.

• Ensured data quality through validation scripts and automated ETL workflows on Azure Data Factory and maintained data integrity across systems which reduced data errors by 25% and supported reliable portfolio performance monitoring.

• Designed interactive Tableau dashboards with dynamic filters and drill-downs, using Level of Detail (LOD) calculations to deliver detailed insights on loan recovery by region and segment, boosting user engagement by 30%. Jr. Analyst, Bajaj Finserv 06/2020 – 06/2021 Chennai, India

• Assisted in data collection and cleaning from multiple sources for the Customer Acquisition project, ensuring accuracy and consistency to support marketing teams in analyzing campaign performance and customer segmentation.

• Generated routine reports using SQL and Excel, tracking daily loan applications and approvals, helping teams monitor progress and identify bottlenecks in the loan processing workflow.

• Created simple dashboards in Power BI to visualize customer engagement metrics, enabling marketing teams to quickly assess campaign effectiveness and optimize future outreach efforts. Education

Master of Science in Information Systems 01/2024 – 05/2025 Auburn university at Montgomery, USA

Bachelor of Technology in Mechanical Engineering 06/2019 – 04/2022 Hindustan Institute of Technology and Science, Chennai, India Projects

Customer Churn Prediction for E-commerce Platform

• Built a predictive model using Python (scikit-learn, Pandas) to identify high-risk churn customers, increasing retention strategy effectiveness by 20% and enabling timely engagement through targeted marketing campaigns and loyalty programs.

• Conducted cohort analysis and used logistic regression to evaluate behavior patterns over time, identifying key churn triggers such as order frequency drops and cart abandonment, leading to strategic changes in email outreach frequency and personalization. Environmental Data Analysis for Air Quality Monitoring

• Analyzed large datasets from air quality sensors using time series analysis and anomaly detection techniques in Python to identify pollution spikes and seasonal trends, helping policymakers implement timely environmental regulations.

• Built interactive Tableau dashboards displaying pollutant levels by region and time, enabling public awareness campaigns and supporting research efforts on the impact of air quality on community health. Certifications

Microsoft Certified: Power BI Data Analyst Associate Machine Learning with Python

PowerBI Job Simulation

Java: Data Structures

Learn HTML and CSS

CSS Complete course for Beginners

Learn Javascript Basics

Python for beginners – Learn all basics of python

Learn to code in Python 3: Programming beginner to advanced Fullstack Java Developer Course

Java Object-Oriented Programming

Contact this candidate