Data Analyst Power Bi

KAJAL KHETAM

***********@*****.*** • 612-***-****

*** ****** *** ****, *******, Texas 78641

No sponsorship required now or in future

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 8+ years of progressive experience in data interpretation, statistical analysis, and business intelligence. Proven expertise in SQL, Python, and PostgreSQL with demonstrated success in reducing reporting time by 20% and increasing data reliability by 15%. Specialized in ETL processing, data visualization, and predictive analytics using Tableau and Power BI. Seeking to leverage advanced analytical skills and automation expertise to drive data-driven decision making and optimize business processes.

CORE COMPETENCIES

Programming & Databases

• SQL (Advanced) • Python (Pandas, NumPy, Scikit-

learn)

• PostgreSQL • MySQL • Java • BigQuery

• GCP • AWS

• Data Mining • ETL Processing

Technical Tools

• Jupyter Notebooks • Google Sheets

• Business Intelligence (BI) • KPI Development

• Data Cleaning • Process Automation

Analytics & Visualization

• Tableau (Advanced) • Power BI

• Microsoft Excel (Advanced) • Statistical Analysis

• Predictive Modeling • Data Visualization

Business Skills

• Requirements Analysis • Stakeholder

Management

• Cross-functional Collaboration • Project

Management

• Data Governance • Performance Optimization

PROFESSIONAL EXPERIENCE

Senior Data Analyst April 2022 - July 2023

Upstream Services, Minneapolis, MN

Technologies: Python, SQL, Tableau, Power BI, PostgreSQL Data Analyst May 2013 - August 2019

Liberty Oil Mills, Mumbai, India

Technologies: Python, SQL, PostgreSQL, Microsoft Excel, Power BI EDUCATION

Bachelor of Science in Computer Science

Mumbai University, Mumbai, India

2011

CERTIFICATIONS & PROFESSIONAL DEVELOPMENT

Reduced reporting time by 20% through development and maintenance of automated dashboards in Tableau and Power BI, serving 50+ stakeholders across 3 departments

•

Increased forecasting accuracy by 25% by conducting advanced statistical analysis and implementing predictive modeling to identify market trends and optimize business processes

•

Improved executive decision-making efficiency by 30% through collaboration with cross-functional teams to define KPIs and deliver actionable insights for strategic planning

•

Automated data collection processes using Python, reducing manual work by 30 hours weekly and minimizing human error by 40%

•

Designed and implemented complex SQL queries to extract data from multiple sources, supporting analytics for 5+ business units with 1M+ records monthly

•

Increased marketing ROI by 18% through comprehensive analysis of campaign performance and customer segmentation using advanced statistical methods

•

Enhanced data reliability by 15% by streamlining data validation and error-checking workflows, reducing data quality issues by 60%

•

Improved stakeholder engagement by 35% through preparation of compelling presentations and visual reports for non-technical audiences

•

Developed automated ETL processes that reduced data processing time from 8 hours to 2 hours daily, improving operational efficiency

•

• Google Data Analytics Professional Certificate (In Progress - Expected 2025)

• Microsoft Excel Specialist - Advanced Data Analysis & Visualization

• Python for Data Science - Pandas, NumPy, Scikit-learn Specialization

• SQL Database Administration - PostgreSQL & MySQL Optimization

• Tableau Desktop Specialist - Advanced Data Visualization KEY PROJECTS & ACHIEVEMENTS

SQL to PostgreSQL Migration & Optimization Upstream Services 2022 Technologies: PostgreSQL, Python, SQL, ETL, Data Validation Marketing Campaign Analytics & Customer Segmentation Liberty Oil Mills 2018-2019 Technologies: Python, SQL, Tableau, Statistical Analysis, Machine Learning Automated Financial Reporting System Upstream Services 2022-2023 Technologies: Python, SQL, Power BI, Excel VBA, Task Scheduler Predictive Inventory Optimization Model Liberty Oil Mills 2017-2018 Technologies: Python, Scikit-learn, SQL, Time Series Analysis, Tableau Architected and executed migration of 500GB+ legacy data from multiple SQL Server instances to PostgreSQL, ensuring zero data loss and maintaining 99.9% uptime during transition

•

Developed custom Python ETL scripts with pandas and psycopg2 to automate data transformation, reducing manual migration time from 200+ hours to 48 hours

•

Implemented advanced indexing strategies and query optimization, resulting in 40% faster query performance and 25% reduction in storage costs

•

Built comprehensive customer segmentation model using Python (sklearn, pandas) analyzing 1M+ customer records across demographics, purchase behavior, and geographic data

•

Designed RFM analysis framework (Recency, Frequency, Monetary) that identified 5 distinct customer segments, enabling targeted marketing strategies that increased conversion rates by 22%

•

Created interactive Tableau dashboards for marketing team with drill-down capabilities, tracking campaign performance across 12+ channels

•

Developed end-to-end automated reporting pipeline using Python scheduling and SQL stored procedures, eliminating 30+ hours of manual work weekly across finance and operations teams

•

Built dynamic Power BI executive dashboards with real-time KPI tracking for revenue, costs, and profitability metrics, serving C-level executives and 15+ department heads

•

Implemented data quality monitoring using Python logging and email alerts, achieving 99.5% data accuracy and reducing reporting errors by 85%

•

Developed machine learning forecasting model using Python (sklearn, numpy) incorporating seasonal trends, economic indicators, and historical sales data to predict demand for 200+ product SKUs

•

Implemented time series analysis using ARIMA and exponential smoothing techniques, improving demand prediction accuracy by 25% compared to traditional methods

•

Created optimization algorithm that balanced inventory carrying costs with stockout risks, resulting in $2.1M reduction in excess inventory and 15% improvement in service levels

•

Contact this candidate