Data Analyst Power Bi

TEJESH VARMA MADDANA

Data Analyst

******************@*****.*** 330-***-**** USA LinkedIn

PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience delivering strategic data solutions, optimizing operations, and enabling executive decision-making through impactful reporting and collaboration. Proficient in SQL, Power BI, Tableau, Python, and R to generate actionable insights, automate reporting, and drive data-backed decisions. Adept at collaborating with stakeholders to develop high-performance dashboards, streamline ETL pipelines. Proven track record of improving reporting efficiency, boosting data accuracy, and delivering insights that reduce costs and increase productivity.

PROFESSIONAL EXPERIENCE

Data Analyst, Cardinal Health 02/2024 – Present USA

•Built and deployed interactive supply chain dashboards using Power BI and Tableau to monitor real-time KPIs, reducing manual reporting time by 0% and enabling faster, data-driven decisions across logistics and procurement teams.

•Extracted, cleaned, and transformed high-volume datasets from SQL Server, MySQL, and PostgreSQL using advanced SQL queries and Python (Pandas, NumPy), improving overall operational efficiency by 32%.

•Collaborated with business stakeholders to convert functional requirements into scalable data models and dynamic reports, reducing reporting inconsistencies by 28% and supporting executive visibility.

•Reengineered ETL pipelines using Python and SQL, embedding automated validation rules and increasing data refresh rates, which significantly minimized downstream data errors.

•Streamlined recurring performance and financial reporting using Python automation and Power Query, cutting manual effort by 50% and enabling near real-time insight distribution to leadership. Business Data Analyst, Deloitte India 03/2019 – 06/2023 India

•Analyzed cross-functional workflows across finance and operations, conducted detailed process mapping, and identified bottlenecks, resulting in a 20% increase in team productivity and reduced delays in decision-making.

•Delivered executive-level dashboards using Power BI and Tableau to visualize financial and operational KPIs in real time, reducing reporting turnaround by 50% and significantly improving leadership insight.

•Conducted gap analyses to assess discrepancies between current and target-state processes, designing scalable solutions that increased departmental throughput by 25% and supported transformation initiatives.

•Built and maintained robust BI infrastructure using Snowflake, SQL Server, and custom-built ETL pipelines, which enhanced data accessibility, consistency, and reduced manual reporting effort by 60%.

•Automated 30+ recurring reports by leveraging SQL, Excel macros, and Power Query, saving the team over 100 hours per month and ensuring timely, error-free report delivery.

•Facilitated 10+ Agile sprint planning and review sessions using JIRA and Confluence, fostering cross-functional alignment and delivering data initiatives ahead of schedule with full stakeholder visibility.

•Developed predictive models and dynamic financial forecasts using Python (Pandas, Scikit-learn) and Excel, uncovering insights that directly informed cost-reduction strategies and long-term planning. EDUCATION

Master of Science in Business Analytics, Kent State University, OH OH Bachelor of Technology in Civil Engineering,

V.R. Siddhartha Engineering College, India

India

TECHNICAL SKILLS

Programming & Query Languages — SQL, Python, R, DAX, VBA Database & Data Management — SQL Server, MySQL, PostgreSQL, Oracle, Data Warehousing Concepts, Star Schema, Snowflake, Relational and Non- Relational Databases, Data Governance, Data Validation, Data Lineage, MDM, Cloud Data Services (AWS, Azure), Industry- Specific Standards (GDPR for data compliance) Project & Agile Management — Jira, Confluence, Scrum, Agile, Waterfall BI Tools & Reporting — Power BI, Tableau, Excel (Power Query and macros), Python/SQL Reporting Automation Data Analysis & Visualization — EDA, Time Series Analysis, Regression, Classification, A/B Testing, Data Wrangling, Data Cleansing, Data Transformation, Root Cause Analysis ETL & Data Engineering Tools — SQL-based ETL, Python-based ETL, Informatica, Alteryx, Power Query, Apache Airflow Machine Learning & Predictive Modeling — Supervised & Unsupervised Learning, Clustering, Forecasting, Scikit- learn, TensorFlow (basic), LSTM, SVM, KNN, Feature Engineering, Model Evaluation (R2, MAE, RMSE), Cross- validation

PROJECT EXPERIENCE

K-Nearest Neighbors Classification for Personal Loan Uptake - Universal, Bank, Technologies: R, caret, class, Data Cleaning, Predictive Modeling, Confusion Matrix

12/2024

•Developed a K-Nearest Neighbors (K-NN) model in R to predict personal loan uptake from 5,000+ customer records, achieving a 9% improvement in classification accuracy.

•Applied data normalization and dummy encoding to enhance model reliability and interpretability.

•Evaluated performance using confusion matrices to inform targeted marketing strategies. Advanced Cluster Analysis in the Pharmaceutical Sector, Technologies: R, dplyr, ggplot2, cluster, factoextra, Data Normalization, Clustering Algorithms

•Performed cluster analysis using K-Means and kernel-based methods across data from 21 pharmaceutical companies to identify strategic market segments.

•Determined optimal cluster counts using Elbow and Silhouette methods, improving segmentation accuracy.

•Visualized operational patterns and relationships using ggplot2 and ggcorrplot, supporting executive decision- making.

Amazon Stock Price Prediction Using ML Models, Technologies: Python, Scikit-learn, Pandas, LSTM, SVM, Linear Regression, Data Engineering

•Designed and evaluated Linear Regression, SVM, and LSTM models in Python to forecast Amazon stock prices using 3,500+ data rows and 36 features.

•Achieved R2 of 0.98+ with the Linear Regression model through advanced preprocessing and feature engineering.

•Delivered actionable investment insights through stakeholder-facing reports comparing model performance. CERTIFICATIONS

Deloitte Data Analytics Job Simulation – — Forage (Jul 2025) IBM Data Analysis with Python - PWC Digital Intelligence Job — Coursera (Apr 2025) PWC Digital Intelligence Job Simulation - Forage — (Mar 2025) AWS Data Analytics - LinkedIn — Simulation - Forage Learning (Mar 2025) Microsoft Certified: Power BI Data Analyst Associate - — (Feb 2025) Tableau 2024.1 Essential Training – — LinkedIn Learning (Feb 2025) Google Analytics Certification – — Google (Feb 2025) Data Visualization – — Forage (Feb 2025)

15 Days of SQL – — Udemy (Jan 2025)

Intermediate & Intro SQL – — Udemy (Dec 2023)

Contact this candidate