Power Bi Data Analyst

PROFESSIONAL SUMMARY

Over *+ years of diversified experience in Business Analysis/Data Analysis in Power BI with strong domain knowledge and work experience in Supply Chain Management and E-commerce industries.

• Proficient in extracting, transforming, and analyzing data from multiple sources to generate actionable insights and support business decisions.

• Strong experience in SQL for data querying, optimization, and data manipulation.

• Skilled in creating interactive and insightful Power BI dashboards and reports, providing data-driven insights to stakeholders.

• Expertise in data visualization techniques and storytelling through data to enhance business understanding.

• Experience in automating repetitive reporting tasks using SQL and Power BI, improving reporting efficiency and data accuracy.

• Proficient in performing data cleansing, validation, and ensuring data integrity to maintain high-quality datasets for analysis.

• Extensive use of statistical analysis tools for identifying trends, forecasting, and deriving predictive insights from large datasets.

• Knowledgeable in data modeling, OLAP analysis, and aggregating large datasets using advanced Excel and SQL functions.

• Assisted in the development and execution of data-related testing scenarios to validate the functionality of data- driven applications.

• Collaborated with cross-functional teams to identify key performance indicators (KPIs) and build custom reports and dashboards for various departments.

• Experienced in creating data pipelines, transforming data from raw formats into meaningful insights for operational teams.

EDUCATION

M.S (Master of Science in Computer Science), USA

B.E in Computer Science from Visveswaraya Technological University, INDIA CERTIFICATION

Microsoft Power BI Data Analyst (PL 300) 2023

TECHNICAL COGNIZANCE

Operating Systems : Windows, Mac, UNIX

Methodology : Agile (Scrum), RUP

Project Management Tools : JIRA, MS Office Suite

Designing Tools : MS Visio, ED Draw

Reporting Tools : Power BI

Application Server : WebLogic

Database : Oracle SQL, MySQL, Microsoft SQL Server

Utility Tools : MS Office Suite, Adobe

Front End : HTML CSS, JavaScript

Backend : .NET, PHP

Cloud Hosting : Azure Cloud, AWS Cloud

PROFESSIONAL EXPERIENCE

Project: Financial Data Optimization and Reporting Enhancement Feb 2024 – Present Client : LPL Financial, Remote

Role : Business Data Analyst

YAMINI SREE TALURI E-mail: ***********@*****.***

BUSINESS DATA ANALYST

Contact: +1-832-***-****

Summary: The Financial Reporting Portal is designed to streamline financial data analysis and reporting for financial managers and leadership. It automates the generation of key financial reports and dashboards, providing real-time insights into budgeting, forecasting, and performance tracking. The portal helps users make data-driven decisions, improve operational efficiency, and reduce manual reporting efforts. Responsibilities:

• Coordinated with financial managers to extract critical financial data, supporting budgeting, forecasting, and analysis, ensuring timely and accurate reporting for senior leadership.

• Delivered customized reports with actionable insights for senior management and operations, creating BRD, FRD, and MOM for team alignment.

• Standardized processes, technical specs, and data workflows, ensuring replicability through SRS and key project documentation.

• Performed complex data extraction and analysis using SQL, streamlining query performance by 30% to enable quicker insights into large datasets for key business decisions.

• Designed and developed Power BI dashboards and reports to present financial performance, trends, and forecasts to business stakeholders, enabling data-driven decisions for a key financial project and improving reporting efficiency by 30%.

• Created and managed database objects (tables, views) using DDL scripts, ensuring structured and efficient data storage for reporting and analysis purposes.

• Utilized SQL Joins and subqueries to consolidate data from various sources, delivering comprehensive reports that supported high-priority business initiatives.

• Conducted extensive data validation and verification to ensure data integrity and alignment with business requirements, significantly reducing errors in final reports.

• Applied OLAP functions (SUM, COUNT) in SQL queries to aggregate and analyze large datasets, enhancing reporting accuracy and decision-making speed.

• Optimized staging and temporary tables for large data loads, enabling seamless data transformation and faster query execution for critical business analysis.

• Built financial dashboards and visualizations in Excel using pivot tables, providing actionable insights into business performance for non-technical stakeholders.

• Participated in Agile Scrum methodology, actively engaging in sprint cycles to prioritize data tasks, ensure timely delivery of key reports, and refine data processes for improved operational efficiency.

• Focused primarily on the analysis phase, translating business requirements into data solutions that optimized reporting accuracy and supported business strategy development. Environment: Dotnet, My SQL, Azure Cloud hosting, WebLogic, Jira, Click Up, ED draw, MS Visio, Power BI, MS office, Agile Scrum Methodology

Project: Patient Portal Development Nov 2022 – Jan 2024 Client : Cardinal Health (Sonexus Health), Houston, TX Role : Senior Business Analyst

Summary:

The Patient Portal designed to streamline patient enrollment for the Patient Assistance Program (PAP), facilitate prescription refills, track medication shipments, and provide real-time alerts and updates. The system integrated advanced data analytics, automated workflows, and reporting tools to enhance operational efficiency and improve patient experience.

Responsibilities:

• Conducted requirement analysis and impact analysis using Rational Requisite Pro, reducing requirement ambiguity by 30% and accelerating project timelines.

• Led JAD sessions to define architectural solutions, resolve open issues, and manage change requests, improving cross-team collaboration by 40% and reducing rework by 20%.

• Monitored client expectations through continuous engagement, leading to improved stakeholder satisfaction and better requirement adherence.

• Developed Business Process Models using a top-down, levelled technique, improving process efficiency by 25% and reducing operational redundancies.

• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, State Chart Diagrams, and Collaboration Diagrams to enhance system documentation and requirement traceability.

• Designed data mapping and logical data models, including class diagrams and ER diagrams, optimizing query performance by 50% and reducing data retrieval time.

• Identified and documented data sources and transformation rules for data warehouse management, reducing ETL processing errors by 40% and improving data integrity.

• Validated technical designs created by developers against functional specifications, ensuring 95% alignment with business needs.

• Evaluated security features such as web security, encryption, authentication, and SSO, improving system security compliance by 50%.

• Defined and executed functional test cases in the Facets system, increasing test coverage and reducing production defects by 30%.

• Performed manual front-end testing to validate functionalities across application modules, identifying and resolving 80% of critical defects before UAT.

• Utilized MS Access and Excel for data cleansing, assembly, and report development, enhancing data accuracy and efficiency.

• Assessed and implemented process improvement recommendations, improving application response time by 40% and reducing downtime incidents.

• Applied RUP SDLC methodology to streamline software development, leading to a 20% reduction in project delivery time.

Environment: Dotnet, My SQL, Azure Cloud hosting, Jira, WebLogic, Click Up, ED draw, MS Visio, Power BI, MS office, Agile Scrum Methodology

Project: Kotak Mahindra Digital Banking July 2019 – July 2022 Client : Kotak Mahindra, Bangalore, Karnataka

Role : Jr. Business Analyst

Summary: The Digital Banking Platform for Kotak Mahindra Bank aimed to enhance customer experience by streamlining online banking services, including account management, loan applications, and transaction processing. Key features included automated KYC verification, real-time transaction tracking, personalized financial insights, and secure fund transfers.

Responsibilities:

• Documented user stories, acceptance criteria, and use cases, reducing defects in core banking features by 30%.

• Drafted and finalized the BRD, outlining key functionalities like account management, loan processing, and fraud detection.

• Facilitated meetings, documented MOM, and tracked action items, improving stakeholder alignment and decision-making speed by 40%.

• Collaborated with the Sr. BA and Manager to define banking platform requirements, improving operational efficiency by 20%.

• Mapped out user interactions across banking services, reducing system complexity and lowering customer support queries by 15%.

• Created visual workflows for fund transfers, loan applications, and digital payments, reducing transaction errors and improving efficiency by 25%.

• Participated in sprint planning, reviews, and retrospectives, enhancing project adaptability and reducing time-to- market.

• Provided progress updates and risk mitigation strategies, improving risk visibility and proactively resolving compliance issues.

Environment: JavaScript, Angular-JS, PHP, WebLogic, Postgres SQL, Aws Cloud Hosting, MS Visio, RUP Methodology, MS Office Suite

Contact this candidate