Data Analyst Power Bi

Summary

Vaishnavi Makkena

+1-940-***-**** *********@*****.*** LinkedIn

Data Analyst with 3+ years of experience delivering end-to-end business intelligence solutions. Skilled in creating advanced Power BI dashboards, transforming complex data into actionable insights, and driving data-driven decision-making. Expertise in data modeling, DAX, SQL, ETL automation, and Azure-based analytics workflows. Proficient in migrating legacy systems to Power BI, optimizing performance, and increasing adoption rates. Certified in PL-300 and AWS Cloud Practitioner, with a strong track record of collaborating with stakeholders to deliver tailored BI solutions. Adept at enabling faster, more accurate insights through database optimization and integration of diverse data sources. Certifications

• AWS Cloud Practitioner

• PL-300: Microsoft Power BI Data Analyst

Work Experience

Theatro (Richardson, TX)

Power BI Data Analyst May 2023 - Present

• Developed advanced data models using DAX and integrated data from diverse sources, including Azure Synapse Analytics, SQL Server, and Azure Data Lake, enhancing reporting accuracy by 40% and ensuring seamless dataflow

• Used Microsoft Fabric to streamline data workflows across Lakehouse and Power BI, improving pipeline efficiency by 30%

• Utilized Power Query to efficiently connect and transform data from various sources, reducing data preparation time by 30% and improving data accuracy

• Designed and optimized interactive Power BI dashboards to visualize KPIs, aligning business objectives and improving stakeholder engagement by 30% through impactful reporting methods

• Implemented Agile project delivery for Power BI dashboards and Power Automate workflows, ensuring iterative improvements and faster releases.

• Implemented Azure Databricks and PySpark for big data processing, reducing data retrieval time by 50%, and automated workflows using Power Automate, saving over 10 hours per week while boosting operational efficiency

• Implemented custom Python scripts tailored for data extraction, transformation, and loading (ETL) processes, reduced labor-intensive manual operations by 20%

• Leveraged Excel Pivot Tables to analyze multi-source data, improving sales forecast accuracy by 25%

• Migrated and rebuilt Power BI dashboards with optimized datasets, reducing loading time by 20% and improving overall performance and user experience, resulting in increased adoption across business teams

• Optimized Power BI performance using Star Schema, enhancing query efficiency and report responsiveness by 35%

• Performed in-depth performance tuning on Power BI reports, cutting development time by 20% and delivering dashboards that met rigorous security and compliance requirements

Hewlett Packard Enterprise (Bangalore, India)

Jr Data Analyst July 2021 - July 2022

• Built efficient SQL to analyze customer behavior trends, implementing insights that optimized workflow processes and increased efficiency by 30%

• Standardized reporting framework, resulting in improved visibility of key performance metrics and enabling data-driven decision- making at all levels of the organization.

• Automated complex data cleaning processes using Pandas and NumPy, streamlining weekly data preparation tasks and saving over 15 hr/week

• Engineered advanced data validation techniques using Python, SQL, and Power Query to ensure data accuracy and reliability for business reporting

• Designed Power BI dashboards that provided real-time customer service data, leading to a 35% reduction in reported customer issues by improving response strategies

• Created and maintained interactive Power BI reports, enhancing real-time access to critical business insights for diverse internal and external stakeholders

• Utilization of AWS technologies enabled real-time data analytics solutions, delivering near-instantaneous insights and reducing decision-making time by 30%

• Migrated 30+ Tableau dashboards to Power BI, streamlining data models and redesigning visuals to enhance performance by 30% and ensure scalability for departmental use

Skills

Business Intelligence: Power BI (advanced reporting, data modeling, dashboard design), Strong Excel Skills, Data Warehousing, ETL development, Machine Learning Techniques, SSRS, Power Automate, SharePoint. Databases: SQL Server, MySQL, Azure Synapse Analytics, Azure Data Lake, Snowflake Data Analytics: Advanced DAX, Power Query, T-SQL,PySpark, Data Visualization, Data Transformation, Adobe Analytics, KPI- driven analysis.

Programming Languages: Python, R, Git

Cloud Technologies: Azure (Synapse Analytics, Data Lake, Databricks), AWS. Automation & Reporting: Power Automate (workflow automation), ETL pipelines Soft Skills: Strong interpersonal skills, Proactive and self-motivated, Exceptional organizational skills Publication

Air Writing Recognition Using Media pipe and OpenCV [ICUIS 2022] Education

University of North Texas, Denton Aug 2022 – May 2024 Master of Science in Computer Science, GPA - 3.7/4.0 Amrita School of Engineering, Bangalore July 2018 – July 2022 Bachelor of Engineering in Computer Science, GPA - 8.2/10.0

Contact this candidate