Pujitha | Data Analyst Portfolio

Professional Summary

Data Analyst with 3+ years of experience translating raw data into actionable business insights, KPI dashboards, and optimization strategies. Skilled in SQL, Excel, Power BI, Python, and statistical analysis to identify trends, improve operational efficiency, and support decision-making across marketing, sales, and customer experience functions. Strong track record of building automated reporting solutions, enhancing data quality, and delivering measurable business impact.

Core Competencies

SQL & Data Querying Advanced

Business Intelligence & Dashboards Advanced

Excel & Data Modeling Advanced

Python for Data Analysis Proficient

Data Cleaning & Validation Advanced

Stakeholder Communication Advanced

Key Projects

Sales Performance Dashboard

Built an executive dashboard using Power BI and SQL to track revenue, region-wise performance, lead conversion, and product demand trends for a consumer sales team.

Reduced reporting time from 5 days to 1 day through automated refreshes and KPI tracking.
Identified underperforming segments, resulting in a 18% improvement in conversion strategy efficiency.
Improved decision visibility for management with 12+ executive-ready reports.

Customer Churn Analysis

Analyzed churn drivers across customer segments using Python, Excel, and SQL to uncover retention risks and recommend intervention strategies.

Detected critical churn patterns and prioritized high-risk accounts, contributing to a 12% reduction in churn.
Developed customer health scoring model used by marketing and support teams.
Created a reusable analysis framework that shortened churn review cycles by 30%.

Operations Reporting Automation

Designed and automated daily and weekly operational reporting for an internal business unit using Excel and Power Query.

Eliminated manual report preparation effort by 80% and removed recurring data-entry errors.
Improved SLA monitoring and issue resolution by tracking 15+ operational metrics in one dashboard.
Enabled faster turnaround for leadership reviews and team performance tracking.

Technical Skills Matrix

Area	Tools	Proficiency
Data Analysis	SQL, Excel, Python, R	Advanced
Business Intelligence	Power BI, Tableau	Advanced
Data Visualization	Power BI, Excel Charts, Matplotlib	Advanced
Data Cleaning	Power Query, Pandas, Excel	Advanced
Reporting	Power BI, Excel, Google Sheets	Advanced
Statistical Analysis	Python, Excel, hypothesis testing	Proficient

Certifications & Training

Google Data Analytics Certificate
SQL for Data Analytics – Intermediate Certification
Power BI Data Analyst Training
Advanced Excel for Reporting & Dashboarding
Python for Data Analysis Fundamentals

Tools & Technologies

SQL Power BI Excel Python Pandas Tableau Power Query Google Sheets Jupyter Git

Career Highlights

Delivered KPI dashboards and weekly performance reports to leadership, improving decision-making speed.
Improved data accuracy by implementing validation checks and cleaning workflows across business datasets.
Partnered with cross-functional teams including sales, marketing, and operations to align metrics with business goals.
Converted manual reporting processes into automated dashboards, saving 20+ hours per month.
Supported strategic planning with actionable insights that influenced campaign prioritization and resource allocation.