Data Analyst Power Bi

Amith Gundluri Data Analyst

*************@*****.*** +1-616-***-**** Michigan, USA

Profile

Data Analyst with 4+ years of experience in creating impactful dashboards and reports using Power BI, MySQL, and Snowflake. Skilled in automating data workflows, optimizing ETL processes, and using Python for data transformation. Experienced in Agile environments, with expertise in JIRA, Selenium, and TestNG for automation testing. Looking to apply my technical and analytical skills to deliver data-driven solutions in a dynamic organization.

Professional Experience

Data Analyst

Nexxoft Infotel April 2022 to July 2023

Projects: R.J. Reynolds (R.J. Reynolds, USA) and Highmark Healthcare (Highmark Healthcare, USA)

Gathered business requirements and created Power BI reports using MySQL, integrating visuals such as Bar Charts, Line Charts, and Matrix.

Developed calculated columns and measures using DAX, applying functions such as Date & Time, Filter Logical, and Text functions.

Rendered reports in PDF, CSV, and Excel formats, ensuring they met stakeholder requirements.

Utilized MS SQL Server to write queries for data extraction and ensured data accuracy in Power BI reports.

Automated ETL processes using Snowflake and optimized data pipelines, reducing retrieval latency by 35%.

Monitored Key Performance Indicators (KPIs) to track performance and provide insights into business operations, contributing to strategic decision-making.

Designed and implemented KPI dashboards in Power BI, enabling stakeholders to track business goals and operational efficiencies.

Performed exploratory data analysis (EDA) on datasets to identify trends, improving forecasting accuracy by 20%.

Automated report refresh and delivery using Power BI workspaces and gateways, ensuring continuous data updates.

Enhanced ETL processes using Apache Airflow, reducing manual intervention by 50%.

Utilized DevOps practices to streamline development, deployment, and operational processes, ensuring efficient and reliable delivery of the insight’s platform.

Leveraged Python libraries (Pandas, NumPy) for advanced data cleaning, preprocessing, and transformation, handling over 1 million records for detailed analysis and predictive modeling.

Extensive knowledge in Project Quality Assurance, SSAS storage, partitions, and aggregations.

Business Analyst

CareTech, an HTC Global Company November 2020 to March 2022

Client: Disney

Worked closely with the Disney team to analyze and improve program performance.

Developed business reports and visualizations in Power BI to track and report key performance indicators (KPIs).

Gathered and translated business requirements into data models for process improvement.

Utilized Power BI and Power Query to clean, transform, and analyze data for accurate reporting.

Created calculated columns and measures using DAX in Power BI for enhanced business insights.

Connected to MySQL databases for querying data and ensuring data accuracy in reports.

Developed automated dashboards and reports in Power BI, enabling stakeholders to make informed decisions.

Designed and optimized ETL processes, ensuring seamless data flow between systems and accurate data reporting.

Conducted performance analysis and optimization of reports, ensuring they met the evolving needs of the business

Test Analyst

Quess Corp July 2019 to October 2020

Client: Quess Corp

Created and executed test scripts to ensure the quality of software solutions.

Generated reports based on test executions, identifying issues and tracking test results.

Managed test data and provided detailed analysis of test outcomes to stakeholders.

Utilized TestNG for test case management and execution, ensuring thorough testing coverage.

Worked within Agile methodologies, participating in sprints and stand-ups to enhance collaboration and test efficiency.

Used JIRA for defect tracking and project management, ensuring clear communication of testing progress and bug resolution.

Conducted performance testing using JMeter, ensuring system reliability under load.

Employed Selenium for automated testing and Mantis for bug tracking and reporting.

Skills

Programming Languages: Python (Pandas, NumPy, SciPy, Matplotlib), R, SQL, Core Java

Database & Big Data Technologies: MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Hadoop, Spark, Snowflake.

Tools & Technology: Power BI, Tableau, MS Excel, Google Analytics, TensorFlow, Git, GitHub, Agile

Other Skills: Selenium, Functional Testing, Hypothesis Testing, Regression Models, ANOVA, Statistical Analysis, Critical Thinking, Quantitative Analysis, Developing KPIs

Education

Central Michigan University, Mount Pleasant, MI

Master's in Information Systems Aug 2023 Present

Coursework: Business Data Analytics, Information Technology, DBMS, Application Development, System Analysis, Project Management, Agile Methodologies

Jawaharlal Technological University, Andhra Pradesh, India

Bachelor's in Electronics & Communication Engineering July 2016 May 2019

Coursework: Electronic Devices, Analog and Digital Communication, Digital Image Processing, Computer Networks, DBMS, JAVA Programming.

Certifications & Awards

Rising Star – Business & Technical - Celonis October 2023

-Applied foundations of Process Mining, focusing on identifying and tracking business value.

Tosca Automation Specialist Level 1 - Tricentis (August 2021)

Contact this candidate