Data Analysis Power Bi

Venkata Ramasita Balusu

St Augustine, FL ****.*********@*****.***

LinkedIn Portfolio Tableau Git Blogs

Profile

A versatile individual with experience collecting, transforming, and organizing data for analysis to help make informed decisions. Excellent understanding and proficiency in platforms for effective data analysis, including SQL, spreadsheets, Tableau, Power BI, and Python. Strong communication, organizational, and analytical skills. Proven ability to lead and guide the breakdown of complex data requirements, developing actionable insights and solutions on time. Proactively collaborate with teams and deliver top performance in time-sensitive situations, equally comfortable working independently, leading teams, and coordinating with cross-functional teams to achieve data-driven goals. Key Skills

• PostgreSQL: Expertise in ETL processes, database management, and complex query development for efficient data retrieval and analysis.

• Tableau: Skilled in creating interactive dashboards and LOD expressions to convey complex data stories to non- technical audiences.

• Power BI: Expert in data modeling, DAX, and Power Query for cleaning and connecting data from multiple sources to create dynamic, insightful reports.

• Microsoft Excel: Expert in advanced data analysis, including complex functions, Visual Basic code data validation, pivot tables, and dynamic visualizations to turn raw data into actionable insights.

• Python: Experienced in scripting for EDA, data cleaning, handling null values, and visualization with Matplotlib and Seaborn.

• Agile Methodology: Experienced in iterative development with tools like Trello and Jira, ensuring timely delivery of data solutions in fast-paced environments.

• Snowflake – Experience ingesting large data sets for historical data analysis.

• Microsoft Azure: Knowledgeable in data storage and Azure Data Factory, with experience integrating and managing large datasets for scalable storage, processing, and historical data analysis.

• Data Pipeline Management – Built data pipeline using SQL and Power BI to ingest large data. Professional Work Experience

Numpy Ninja, USA April 2022 – Present

Role: Data Analyst

• Analyzed big data of 1.5 million rows using Tableau and Python to determine the incidence of Sepsis.

• Performed exploratory data analysis, data cleaning, and missing data analysis using Python for the data containing over 50% missing values.

• Presented business insights from the Data using Tableau to 100+ audiences, including stakeholders.

• Obtained Key performance metrics for Patients admitted to ICU using Tableau calculated field, Level of Detail, filters, parameters, and sets which would help improve ICU operational efficiency by 30%

• Identified the patients transitioning to the SIRS (Systemic Inflammatory Response Syndrome) stage of Sepsis, also enabling the option of sending e-mail alerts to Doctors for timely intervention.

• Analyzed the impact of diabetes on cognitive function in elderly patients using MRI and lab data and created visualizations in Power BI to interpret the findings.

• Analyzed and meticulously documented key aspects of a vast dataset comprising 630 million rows of Intensive Care data.

• Focused on a subset of 120 million rows related to mortality, skillfully mined, segmented, and cleaned the data for subsequent machine learning modules.

• Successfully reduced the final database to a streamlined 350,000 rows through rigorous cleaning procedures.

• Data was extracted, staged, and transformed using PostgreSQL statements. Transformed data was then modeled and analyzed in Power BI.

• Collaborated with a team of 5 to organize the SQL Hackathon for 112 participants.

• Mentored and coached over 4+ teams of 4 people each, by coordinating the overall project process, ensuring smooth workflows and timely completion of the same. AP Transco, India 08/2019 - 11/2020

Role: Assistant Executive Engineer

• Gathered data from different sources and analyzed and made reports for renewable generators utilizing advanced Excel functions and formulas which Improved grid stability and reliability.

• Automated data processes by writing VBA code which improved efficiency and saved 20% of time. AP Transco, India 07/2010 - 09/2014

Role: Assistant Executive Engineer

• Collected hourly power data, prepared power station performance reports, and entered data into the ERP

(Enterprise resource planning) system.

• Directed 10 subordinates in the power station.

Education

Masters in Technology - Indian Institute of Technology B.E. – Electrical and Electronics Engineering, Andhra University Certification

• Certificate in Conflicts of Interest (CITI Program, HIPPA)

• Certificate in Human Research (CITI Program, HIPPA)

• Tableau Desktop Specialist

Awards

• Awarded Best Organizer for SQL Hackathon.

• Datathon Leadership Excellence Award.

Language

English, Telugu, Hindi, and Spanish

Contact this candidate