Data Analyst Power Bi

EDEN PRAIRIE, MN • ******.***@*****.*** • +1-217-***-****

SRAVAN KUMAR TUMU

BI Data Analyst

PROFESSIONAL SUMMARY

Over 4 years of experience in Data Analysis, Business Intelligence, and Reporting using tools like Power BI, SSRS, and SQL Server to deliver scalable and efficient data-driven solutions. Proficient in SQL query tuning, developing stored procedures, building views, and creating optimized data models for flexible and standardized reporting. Expertise in designing interactive Power BI dashboards and reports with advanced DAX calculations to present actionable insights and support decision-making. CORE COMPETENCIES

Visualization Tools: Power Apps, SharePoint Power Automate, Excel, Power BI, Tableau Desktop, Tableau Server Data Modeling Tools: MS SQL Server Management Studio, MS SQL Server Reporting Services, SSRS, Alteryx Languages: SQL, PL/SQL, Python, HTML, CSS

SDLC Methods: Agile, Scrum, Waterfall

Testing tools: UAT, Automated Testing, Manual Testing, Black Box, White Box EMPLOYMENT HISTORY

BI DATA ANALYST Nov 2023 - Present

Optum Insight Inc. Eden Prairie, MN

As a Data Analyst at Optum Insight, I contributed to a project focused on optimizing healthcare operations and enabling data-driven decision-making. My responsibilities included analyzing large datasets using tools such as SQL, Power BI, and Tableau to create interactive dashboards and reports. These visualizations highlighted key performance indicators (KPIs), operational metrics, and patient trends, providing actionable insights for stakeholders. By identifying data patterns and opportunities for process improvement, I played a key role in streamlining workflows, enhancing service delivery, and driving strategic healthcare initiatives. This effort resulted in an 80% reduction in the workload for process owners and significantly improved monitoring capabilities.

• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Sybase systems.

• Designed and implemented complex AWS architectures that meet business requirements.

• Configured AWS DMS for data migration between different database platforms.

• Clean data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SciPy, and Matplotlib.

• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design.

• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

• Monitor, Triage, Track, and resolve issues with the Excel Power BI reports.

• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis, and tuning.

• Developed the required data warehouse model using Star schema for the generalized model.

• Extracted data from the databases (Sybase and SQL Server, FLAT FILES) using Informatica to load it into a single data warehouse repository.

• Define and document ETL process and data flow and scheduling capabilities.

• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.

• Worked in importing and cleansing of data from various sources like Teradata, SQL Server with high volume data.

• Responsible to design, develop, and test the software to maintain the data marts (Load data, analyzed using OLAP tools).

• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

• Handled importing of data from various data sources, performed transformations using Hive. (External tables, partitioning).

• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.

• Utilized SQL to develop new and debug existing Ad-Hoc reports DATA ANALYST/BI DEVELOPER Oct 2018 - Dec 2021

Hitachi Energy Chennai, India

As a Data Analyst at Hitachi Energy, I am part of the Pricing and Strategic Marketing team within the global Business Unit

(BU) High. My current project involves analyzing sales and market data to develop actionable insights that support strategic decision-making. By utilizing tools like Power BI, SQL, and DAX, I create dynamic reports and dashboards that visualize sales KPIs, pricing trends, and market opportunities. This helps the team optimize pricing strategies, improve profitability, and identify growth opportunities globally, contributing to the overall success of the business unit.

• Extracted, cleaned, and analyzed large datasets from various sources, including SQL Server, Salesforce, and Sales BI, to generate actionable insights for decision-making.

• Developed and maintained dynamic dashboards and reports using Power BI, employing advanced DAX formulas to create measures, calculated columns, and KPIs tailored to business needs.

• Created custom reports and scorecards using SQL Server Reporting Services (SSRS), ensuring data accuracy and presenting findings to stakeholders across multiple departments.

• Collaborated with cross-functional teams, including data scientists and pricing specialists, to implement competitive pricing strategies, leveraging data insights for trend analysis and optimization.

• Defined and visualized key performance indicators (KPIs) such as sales target achievement, price performance, order trends, and pipeline development, using Power BI for real-time monitoring.

• Conducted root cause analysis on data quality issues, ensuring data integrity across platforms and contributing to continuous process improvements in data governance.

• Supported the design and implementation of pricing management systems, enhancing pricing accuracy and aligning strategies across production units.

• Provided user training and technical support on Power BI and SSRS, boosting the analytical capabilities of sales and marketing teams globally.

• Collaborated with energy and utility sector stakeholders to create tailored reporting solutions, leveraging SQL for data extraction and Power BI for advanced data visualization.

• Documented business processes and maintained guidelines to ensure efficient data management and compliance with organizational standards.

• Enhanced reporting deliverables by using data-driven storytelling techniques and incorporating visually compelling layouts with Power BI.

• Continuously optimized SQL queries and views to improve the performance and scalability of reporting solutions for energy efficiency programs.

EDUCATION

MASTERS IN COMPUTER AND INFORMATION SCIENCES Feb 2022 - May 2023 New England College Henniker, NH

BACHELORS IN COMPUTER SCIENCE AND ENGINEERING Aug 2014 - May 2018 KL University Guntur, India

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate - May 2024 IBM Data Analyst Professional Certificate - Dec 2024

Contact this candidate