Data Analyst Power Bi

Uma Maheswara Rao Seelam

Alpharetta, GA, **********@*****.*** 678-***-****

SUMMARY

Experienced Data Analyst with 4+ years of strong data extraction, transformation, and visualization using Python, SQL, Power BI, Tableau, Excel, and SSRS with expertise in data manipulation, statistical modeling, and predictive analytics using Pandas, NumPy. Proven expertise in data mining and delivering business intelligence reporting to drive operational improvements and informed decision making. Skilled in analyzing business functions and processes, documenting findings, and recommending enhancements to optimize performance. Experienced in creating interactive dashboards and reports using SQL, PowerBi, Excel, and SSRS. Adept at workflow automation and process optimization through Python scripting, with a strong background in SQL databases (MySQL, NoSQL, SQL Server) ensuring accurate data retrieval and comprehensive analysis.

EXPERIENCE

Data Analyst

Discovery Analytics Inc August-2022 to Till Date

•Designed and developed interactive dashboards and reports, enabling business users to gain actionable insights from complex data.

•Applied advanced data visualization techniques to uncover valuable trends and patterns within large datasets.

•Collaborated with both internal and external teams to create tailored custom reports that met specific business needs.

•Enhanced database performance by writing and optimizing SQL queries for improved operations.

•Monitored customer behavior and engagement using cutting-edge business intelligence tools.

•Generated comprehensive reports summarizing insights from stakeholder meetings and engagements.

•Engineered ETL pipelines to efficiently extract data from NoSQL databases.

•Conducted in-depth analysis of consumer trends and behaviors, identifying new customer segments and growth opportunities.

Data Analyst

Bajaj Health Care LTD. Jul—2020 to Feb-2022

•Strong background in advanced Power BI development, with expertise in creating detailed dashboards and KPIs.

•Experience in data extraction and manipulation possess SQL and Excel for analysis.

•Designed and implemented Power BI solutions that improved data accessibility and business decision making.

•Analyzed large data sets using advanced Excel functions, reducing the data entry process, resulting in a 25% reduction in the time spent on monthly reporting cycles for the analytics team.

•Focused on optimizing Power BI reports for performance and scalability.

•Led initiatives to automate and simplify data reporting processes, improving operational efficiency.

PROJECT

Logistics Data Analysis & Route Optimization

•Analyzed 10,000+ delivery records to identify patterns in delays and fuel costs across regional logistics operations.

•Visualized delivery route efficiency using maps and suggested rerouting strategies, reducing average delivery delays by 20%.

•Built a Power BI dashboard to monitor delivery KPIs including delay rates, fuel usage, and cost per delivery.

Health Care Reporting and Visualization Optimization

•Collaborated with cross-functional teams to gather business requirements and design Power BI dashboards aligned with clinical and operational KPIs.

•Integrated data from Excel, SQL Server, and APIs to develop comprehensive reports, including advanced DAX calculations for tracking key metrics.

•Enhanced decision-making capabilities by implementing drill-through and drill-down features and optimizing dashboard performance.

•Collaborated with cross-functional teams to gather business requirements and design Power BI dashboards aligned with clinical and operational KPIs.

•Integrated data from Excel, SQL Server, and APIs to develop comprehensive reports, including advanced DAX calculations for tracking key metrics.

•Enhanced decision-making capabilities by implementing drill-through and drill-down features and optimizing dashboard performance.

EDUCATION

Bachelor’s in computer science

Andhra Loyola Collage, Vijayawada • Vijayawada, Andhra Pradesh 520008 INDIA • AUGUST 2017 — JUNE 2020

Master’s in Computer & Information Systems

Rivier University • Nashua, NH 03060 USA • JUNE 2022 — MAY 2024

SKILLS

Programming Languages & Tools

Python, SQL, R

Data Analysis & Visualization Tools

Power BI,Tableau, SSRS,Excel, Matplotlib

Preprocessing & Cleaning

Pandas, NumPy

Databases

MySQL, SQL Server, MangoDB

Tools & Technologies

Jupiter Notebook, Microsoft Azure

Statistical Analysis

Regression, Hypothesis Testing, Descriptive & Inferential Statistics

Soft Skills

Problem-solving, Analytical thinking

Contact this candidate