Power Bi Data Analyst

KIRAN SANKEPALLY

**** ***** **** *****, *******, IL 312-***-**** ****************@*****.*** www.linkedin.com/in/kiransankepally

SUMMARY

Insight-driven Business Intelligence Developer and Business/Data Analyst with 14+ years of experience transforming data into strategic insights across finance, operations, and enterprise functions. Adept at building interactive Power BI dashboards, conducting data modeling using SQL, and gathering business requirements for scalable analytics solutions. Proven ability to bridge technical and non-technical teams, drive data governance, and support data-informed decision-making. Skilled in BI tools, ETL, and automation to streamline reporting and improve visibility across departments.

CORE COMPETENCIES

Power BI Dashboard Design & Data Storytelling

SQL-Based Data Modeling (Star Schema, DAX)

Business Requirements Gathering & Stakeholder Alignment

KPI Definition & Executive Reporting

Data Integration (Matillion, SSIS, Azure)

Data Cleaning, Validation & Root Cause Analysis

Agile Project Delivery (DevOps, Jira)

Financial, Sales & Operational Reporting

Public Sector & Regulated Data Handling

Documentation & Functional Specs

Cross-Functional Communication & Stakeholder Alignment

TECHNICAL SKILLS

BI Tools: Power BI, Tableau, Excel (Advanced), Power Query, DAX

Databases: SQL Server, Azure SQL, PostgreSQL

ETL & Integration: Matillion, SSIS, Azure Data Factory

Scripting: Python (Pandas), R (basic)

Platforms: Azure, JD Edwards (basic), Azure DevOps, Jira

Automation & AI: Microsoft Copilot (familiar), GPT-based tools

PROFESSIONAL EXPERIENCE

Labelmaster DePaul University – Chicago, IL

Lead Business Analyst (BI Developer) – Capstone Project April 2025 - June 2025

Delivered Power BI dashboards uncovering $9.4M in whitespace revenue.

Collaborated with stakeholders to define KPIs and translate business questions into analytics use cases.

Built SQL-based models and DAX logic to track sales segmentation and performance.

Automated customer segmentation using AI tools (GPT integration) for enhanced insights.

Authored functional documentation and supported user onboarding.

JB INFRA GROUP

Data Analytics Manager / BI Consultant November 2018 - August 2023

Designed enterprise dashboards for financial planning, operational performance, and risk mitigation.

Built integrated data pipelines and improved refresh reliability and data accuracy.

Led workshops with business stakeholders to prioritize analytics requirements and define metrics.

Troubleshot and resolved BI platform issues, increasing stability and reliability by 80%.

Resolved Power BI model and visual errors, improving report usability and speed by 80%.

DELOITTE

Analytics Consultant – BI Developer July 2018 - October 2018

Developed Power BI reports supporting audit readiness and compliance reporting.

Gathered and translated business requirements into technical BI solutions

Delivered training and documentation to empower users and improve adoption.

ADP

BI Analyst September 2015 - July 2018

Created dashboards to monitor operational KPIs, forecast revenue, and support cash flow analysis.

Migrated legacy reports to Azure and developed reusable datasets for internal teams.

Worked with cross-functional teams (finance, sales, IT) to gather needs and deliver solutions.

ADP

Financial Data Analyst / Reporting Lead Mar 2008 - August 2015

Developed reporting for cost center management, budget tracking, and variance analysis.

Conducted trend and anomaly analysis using DAX and Excel, improving financial insight delivery.

Provided documentation and training support during BI tool implementation and upgrades.

KEY PROJECTS & IMPACT

Power BI Optimization: Reduced refresh failures by 80% via optimized data models and queries.

Sales & Logistics Analytics: Integrated pipeline across Matillion and Azure for real-time reporting.

Self-Service BI Enablement: Empowered 50+ users through Power BI training and centralized datasets.

Data-Driven Performance Tracking: Built visualizations to monitor KPIs and identify operational gaps.

EDUCATION

DEPAUL UNIVERSITY, KELLSTADT GRADUATE SCHOOL OF BUSINESS Chicago, IL

Master of Science, Business Analytics June 2025

GPA: 3.97 Dean's Award for Scholastic Excellence

OSMANIA UNIVERSITY Hyderabad, India

Master of Business Administration, Finance

OSMANIA UNIVERSITY Hyderabad, India

Bachelor of Commerce, Cost Accounting and Management Accounting

CERTIFICATION & TOOLS

Microsoft Power BI Data Analyst Associate (In Progress)

Familiar with Microsoft Copilot

Lean Six Sigma (Workshop), Certified BPO Quality Analyst

Tools: Power BI, Snowflake, Matillion, JD Edwards, DevOps, SQL Server, Python, R, Excel, Azure, Jira

Contact this candidate