Power Bi Data Analyst

Yashwanth Kumar Musthayala

Hyderabad, Telangana *00055 +91-917******* ****************@*****.*** LinkedIn: linkedin.com/in/yashwanth-kumar-25916a177

PROFESSIONAL SUMMARY

Aspiring Data Analyst with 4+ years of experience in IT Operations, bringing a strong foundation in system monitoring, batch job management (BMC Control-M), and mainframe environments. Proactively transitioned into data analytics by acquiring hands-on skills in SQL, Power BI, Excel, and statistical modeling (including time series regression). Proven ability to bridge operational knowledge with data insights to solve real-world business problems and drive data-driven decisions.

Technical Skills

Languages: SQL Database, Python, NumPy, Pandas,

Tools: - Power BI, Excel (Advanced), VBA, Macros, SQL, BMC Control-M, Mainframes, Batch Job Monitoring,

Data Visualization: Interactive Dashboards, KPI Reports, Data Modeling, Data Pipeline design

Problem Solving: Root Cause Analysis, Workflow Automation, Performance Optimization, Time Series Analysis, statistical analysis, co-relation analysis., Azure SQL, PostgreSQL, Datamart Design

Certifications and Awards

Power BI, & Advanced Excel – Top Mentor Institution

Microsoft Excel and PowerPoint – Geeni Solutions

Workshop: Two days hands-on Power BI workshop with merit certification

PROFESSIONAL EXPERIENCE

Operations Analyst Colruyt Group-Hyderabad 07/21 – Present

Monitored and managed enterprise-level batch job workflows using BMC Control-M in a 24/7 production environment.

Collaborated with cross-functional teams to identify and deliver data analytics solutions supporting operational risk and control in a financial services environment.

Developed data pipelines and analytical workflows using Alteryx to automate data cleansing, transformation, and enrichment processes for key operational metrics.

Designed and maintained interactive Tableau dashboards to visualize complex datasets and deliver insights on SLA breaches, job failure trends, and system performance KPIs.

Conducted in-depth data analysis and root cause investigations using SQL to uncover performance patterns, anomalies, and improvement areas in operational workflows.

Partnered with the Ops Risk Data & Metrics team to document metric definitions, streamline reporting logic, and deliver timely metric-related asks for internal stakeholders.

Performed data mining, modeling, and statistical analysis (e.g., trend analysis, correlation) to support business decisions and risk assessments.

Presented key findings and trends to stakeholders, translating technical insights into clear business language to drive actions.

Actively identified and implemented process improvements through workflow automation and data visualization, enhancing decision support and operational transparency.

Remained up to date with best practices in data analytics, visualization, and industry standards to continually optimize reporting deliverables.

SELECTED PROJECTS

Banking Analytics Dashboard – Self-Initiated Real-Time Project

Domain: Banking Tools: SQL, Power BI, Excel, Power Query Apr 2025 – Jun 2025

Developed an end-to-end analytics solution for a simulated bank loan dataset using SQL, Excel, Power BI, and Power Query.

Extracted and prepared data from a relational SQL database and performed data transformation using Power Query for accurate model creation.

Modeled relationships between loan, customer, and branch data to enable cohesive, drill-down reporting.

Built custom DAX measures to track key performance metrics including:

Total loan disbursed, approval vs rejection rates, delinquency (NPL) ratio, and average interest rate & tenure.

Designed an interactive Power BI dashboard with dynamic slicers for loan type, branch, and time-based filtering.

Delivered actionable insights:

Identified high-risk borrower segments and underperforming branches.

Uncovered monthly/seasonal trends in disbursement and defaults.

Impact: Enabled data-driven decisions for risk mitigation, loan policy optimization, and seasonal campaign planning.

EDUCATION

Bachelor of Technology in Electronics & Communication Engineering

Gokaraju Rangaraju Institute of Engineering and Technology Hyderabad Aug 2020

Contact this candidate