Data Analyst Power Bi

Kavya Gudikandula

Data Analyst

Email ID: ******************@*****.*** Ph No: 765-***-**** LinkedIn: linkedin.com/in/kavya-g-51b31118b PROFESSIONAL SUMMARY

Results-driven and analytical Data Analyst with 3 years of professional experience and an advanced Master's degree in Computer and Information Sciences. Expertise in transforming complex datasets into actionable insights to drive strategic decision-making and operational efficiency.

Proficient in the full data analytics lifecycle, including data extraction (ETL), cleaning, validation, statistical analysis, visualization, and generating reports for diverse stakeholders.

Developed and deployed automated data pipelines, reducing manual data processing time by 25% and improving data accuracy for key business metrics.

Expertise in writing complex SQL queries for data extraction, manipulation, and aggregation from large-scale relational databases.

Skilled in using Python (Pandas, NumPy, Scikit-learn) for advanced data analysis, statistical modeling, and automating repetitive data tasks.

Created interactive and insightful dashboards and reports in Power BI and Tableau to visualize trends, track KPIs, and communicate findings to technical and non-technical audiences.

Experience in performing root cause analysis to identify data discrepancies and implement corrective measures, ensuring high data integrity and reliability.

Collaborated with cross-functional teams, including business stakeholders and engineers, to define data requirements and deliver analytics solutions aligned with business goals.

Strong foundation in statistical concepts, hypothesis testing, and data mining techniques to uncover patterns and correlations within data.

Familiar with cloud platforms (AWS) and big data concepts, with a keen interest in continuous learning and applying new technologies to solve business problems.

Excellent communication and presentation skills, with a proven ability to translate complex technical findings into clear, actionable business recommendations.

TECHNICAL SKILLS

• Programming Languages: Python (Pandas, NumPy, Scikit-learn), SQL, R, Java, Scala

• Databases & Data Warehousing: MySQL, PostgreSQL, SQL Server, Oracle, SSIS, ETL Processes

• Data Visualization & BI Tools: Tableau, Power BI, SSRS, Excel (PivotTables, VLOOKUP, Charts)

• Big Data & Cloud Tools: AWS (S3, Redshift, EC2), Apache Spark, Hadoop (HDFS)

• Development Tools: Git, Jira, Confluence, Excel, Jupyter Notebook

• Concepts & Methodologies: Statistical Analysis, Data Modeling, Data Mining, Predictive Modeling, Machine Learning, Agile/Scrum

PROFESSIONAL EXPERIENCE

McKesson Data Analyst Irving, TX Apr 2024 – Present Domain: Healthcare

Responsibilities:

Spearheaded a data quality initiative for the inventory management system, writing SQL scripts to identify and rectify discrepancies, which improved data accuracy for reporting by 20%.

Executed an end-to-end analysis project on shipping carrier performance; developed a Python script to analyze on-time delivery rates, identifying a 15% performance gap with a key carrier.

Engineered an automated ETL pipeline using Python and AWS Glue to migrate and transform legacy sales data into a new Redshift data warehouse, reducing data preparation time for the sales team by 8 hours per week.

Developed a predictive model in Python using Scikit-learn to forecast regional demand for high-volume pharmaceuticals, contributing to a 10% reduction in stockouts in the pilot region.

Designed and published a suite of interactive Power BI dashboards to monitor real-time supply chain KPIs, enabling management to track order status, inventory turnover, and supplier performance on a single platform.

Collaborated on a cross-functional project to define new data points required for a vendor scorecard system; built the SQL queries to aggregate the data and populate the initial scorecard reports.

Performed a deep-dive analysis into root causes of shipping delays, utilizing SQL for data extraction and Python for statistical analysis, resulting in a process change that reduced delays by 18%. Environment: SQL, Python (Pandas, NumPy, Scikit-learn), Power BI, AWS Redshift, AWS Glue, SSIS, Excel, Jira DXC Technology Data Analyst India Dec 2021 – Aug 2023 Domain: Technology Consulting & IT Services

Responsibilities:

Managed a project to consolidate customer data from three separate legacy systems for a major client; developed complex SQL queries for ETL, ensuring a seamless and accurate migration.

Initiated and completed a data validation project for a new client onboarding process, creating automated validation scripts in SQL that reduced data errors by 95% in the first month.

Built a comprehensive Tableau dashboard from scratch to track customer support ticket metrics, including average resolution time and ticket volume by category, which helped the client identify a 25% increase in a specific software issue.

Contributed to a client retention project by performing analysis on customer usage data; identified key behavioral patterns associated with churn and provided a list of at-risk accounts to the client's management team.

Developed standardized SQL-based reporting templates for recurring client deliverables, automating what was previously a manual process and saving approximately 10 hours of effort per reporting cycle.

Supported a data architecture project by reverse-engineering existing Oracle databases to document table relationships and data lineages, creating critical documentation for future development.

Utilized SSRS to generate and automate pixel-perfect operational reports for client leadership, ensuring timely delivery of critical business information.

Environment: SQL, Oracle, Tableau, SSRS, Excel, Java, Windows Server EDUCATION

• Master of Science in Computer and Information Sciences, Saint Louis University, St. Louis, MO.

• Bachelor of Technology in Computer Science & Engineering, SR Engineering College, India.

Contact this candidate