Data Analyst Power Bi

Yaswanth Kumar Chaganti

+1-737-***-**** *********************@*****.*** LinkedIn

SUMMARY

Data Analyst with over 3 years of experience specializing in data analytics and visualization. Proficient in Power BI, SQL, Python, and Tableau for delivering data-driven insights and supporting strategic decision-making. Proven ability in devising and optimizing data models, forecasting sales trends, and automating data processes to enhance operational efficiency. Strong analytical thinker with excellent problem-solving abilities and a collaborative approach, capable of translating complex data into actionable business strategies. Effective communicator with experience in cross-functional teamwork and delivering impactful visualizations and reports. EDUCATION

Texas Tech University Lubbock, TX

Master of Science in Computer Science 2022 – 2023

Vel Tech Rangarajan Dr. Sagunthala R&D Institute of Science and Technology Chennai, India Bachelor of Technology, Computer Science and Engineering 2016 - 2020 SKILLS

• Power BI

• Tableau

• SQL

• Power Query

• Microsoft Excel

WORK EXPERIENCE

•

Python

• DAX

• Hadoop

• Hive

• Data Modeling

• Statistical Analysis

• Salesforce

• Grafana

• Linux

Progress Solutions Plano, TX

Data Analyst Apr 2024 - Present

• Engineered dynamic Power BI dashboards to visualize key performance indicators (KPIs), enhancing data-driven decision-making and increasing stakeholder engagement by 25%.

• Designed interactive data visualizations that effectively communicated complex insights, enabling quick and informed decisions across various business units.

• Automated data transformation by building Python scripts and leveraging Power BI’s dataflow automation, reducing manual reporting by 20% and improving data accuracy for strategic insights.

• Developed custom visual analytics and reports tailored to business needs, ensuring alignment with organizational goals and enhancing reporting efficiency.

• Collaborated with cross-functional teams to streamline reporting, leading to improved decision-making and 10% faster report delivery.

Texas Tech University Lubbock, TX

Student Assistant Sep 2022 – Dec 2023

• Developed a Power BI dashboard for hospitality management, focusing on KPIs such as occupancy rates, ADR, and guest satisfaction scores, which increased operational efficiency by 15%.

• Built data models to analyze trends in guest behavior and market performance, providing actionable insights that influenced operational improvements.

• Conducted regular data quality checks to ensure report accuracy, helping management make data-driven decisions.

• Prepared ad-hoc reports and visualizations for university leadership, supporting long-term strategic planning in the hospitality sector.

Accenture Solutions Pvt Ltd Pune, India

Application Development Associate Aug 2020 - Dec 2021

• Automated data extraction using SQL and Power Query, reducing manual preparation time by 60%.

• Implemented robust data cleaning techniques that improved data consistency and accuracy, minimizing errors.

• Devised custom Power BI dashboards and visualizations, increasing engagement among stakeholders by 20%.

• Collaborated with cross-functional teams to align data analysis with business objectives, driving actionable insights and contributing to business growth.

• Designed visualizations and analytical models to identify KPIs and trends, enabling data-driven decision-making across the organization.

Grepthor Software Solutions Hyderabad, India

Data Analyst Intern Dec 2019 – May 2020

• Developed and implemented sales forecasting models using ARIMA and SARIMA to predict future sales trends, improving accuracy in business planning and inventory management.

• Conducted data analysis using Python and SQL to identify patterns in historical sales data, leading to optimized revenue strategies and more successful product launches.

• Created interactive dashboards and visualizations in Power BI to present forecasting results and insights to stakeholders, enhancing decision-making processes.

PROJECTS

Hospitality Performance Analytics Dashboard

• Developed and implemented a Power BI dashboard customized for the hospitality industry, focusing on occupancy rates, ADR, and guest satisfaction scores.

• Utilized advanced data visualization techniques to enhance interpretation of key performance indicators.

• Implemented forecasting models that led to a 15% increase in operational efficiency. Time Series Sales Forecasting

• Implemented ARIMA and SARIMA models to forecast sales, ensuring predictions based on historical data trends.

• Applied advanced analytical techniques to optimize revenue strategies and inform product launch decisions.

• Developed and executed a sales prediction project, demonstrating proficiency in data analysis and forecasting methodologies. Library Data Optimization and Reporting

• Conducted data analysis using SQL and Python to optimize book inventory management and support strategic decision-making for library services.

• Developed data models and quality checks to ensure accurate and reliable reporting of library usage patterns.

• Created visualizations and tailored reports for various departments, enhancing resource allocation and operational efficiency.

Contact this candidate