Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rahul Kancherla

Decatur,IL

Summary

· Experienced Data & Business Intelligence Analyst with 9 years of experience across CMMS systems, enterprise data warehousing, business analysis, and BI development.

· Proven ability to lead end-to-end reporting lifecycle, develop scalable ETL processes, and deliver actionable insights via interactive dashboards.

· Comfortable bridge gaps between technical teams and business stakeholders.

· Experience developing BI solutions using Power BI, DAX, Power Query, and SQL

· Created over 100+ visually compelling dashboards and reports tailored to business KPIs and metrics

· Identified root causes for routine data discrepancies and implemented repeatable fixes.

· Built efficient data models with star/snowflake schema, improving report performance and usability

· Connected and transformed data from SQL Server, Azure, Excel, and other structured sources

· Developed advanced DAX measures, calculated columns, and time intelligence calculations

· Designed interactive drill-through, slicer-driven, and bookmark-based reports for self-service analytics

· Automated report refreshes, dataflow, and scheduled datasets in Power BI Service

. Developed real-time project tracking dashboards combining Smartsheet and other enterprise data sources.

· Implemented Row-Level Security (RLS) for controlled access and secure data sharing

· Collaborated with business users to gather requirements and deliver intuitive reporting solutions

· Managed Power BI workspaces, gateways, and deployment workflows across dev/test/prod environments

· Assisted in designing solutions for complex data transformations or reporting issues under the direction of senior team members

· Built and maintained SQL queries, Data extracts, and scheduled reports used for operational and executive reporting.

· Performed validation checks on datasets and reports to ensure accuracy before delivery.

· Quickly pick up new tools, Reporting frameworks, and domain knowledge by taking on hands-on project work.

Overview

9
9
years of professional experience

Work History

ADM — Asset Manager / CMMS Analyst /Power BI Developer

ADM
08.2023 - Current
  • Built Snowflake-based ETL pipelines for clean, structured data used in Power BI reporting.
  • Developed dashboards with Power BI and DAX to track asset lifecycle and maintenance KPIs.
  • Automated workflows with Power Apps and Power Automate for improved operational tracking.
  • Automated weekly performance reporting by connecting Smartsheet to Power BI, reducing manual reporting by 40%.
  • Integrated Smartsheet data into Power BI using API/Data Connector to develop automated executive dashboards.
  • Delivered executive reports supporting maintenance, reliability, and compliance objectives.
  • Translated complex analytical findings into clear, executive-ready dashboards and presentations for non-technical stakeholders.
  • Developed interactive Power BI dashboards for state agency stakeholders to track program performance, funding utilization, and compliance metrics.
  • Supported businesses staff by delivering training and end-user guidance for the Oracle Analytics tool, improving adoption and effective use of BI solutions.
  • Conducted data analysis of business and user needs and authored Business Requirements Documents to guide migration from Oracle Portals, Business Areas, and Discoverer Workbooks to the Oracle analytical reporting platform.
  • Collaborated with data modelers, ETL developers, programmers, and business owners to refine reporting requirements, clarify business rules, prioritize development, and secure stakeholder sign off.
  • Integrated CMMS with enterprise data warehouse systems to support broader analytics
  • Communicated and validated business reporting requirements and policy changes, ensuring alignment for the development of new operational reports and analytics.

Business Intelligence Analyst

Apple
06.2021 - 07.2023
  • Delivered end-to-end BI reporting solutions using Power BI: modeling, cleansing, visualization.
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Created business documentation including BRDs, use cases, swim lanes, and process flows capturing Business Intelligence reporting requirements for reports, dashboards, and ad hoc tools.
  • Partnered with Data Warehouse, BI teams, and business owners to translate requirements into logical and physical dimensional data models, ensuring clarity and accuracy for development.
  • Utilized advanced Excel functions (Pivot Tables, Power Query, VLOOKUP/XLOOKUP, INDEX-MATCH, macros) to consolidate and analyze large datasets from multiple sources.
  • Designed automated Excel reporting templates that reduced manual processing time and improved data accuracy.
  • Conducted data profiling and built S2T mappings for structured warehouse development.
  • Designed and executed test scripts, test scenarios, and test plans across DEV, QA, and PROD environments to validate reporting accuracy and business requirements.
  • Produced business dashboards for internal teams, enabling faster, data-driven decisions.
  • Documented ETL pipelines, KPIs, and data dictionaries for internal BI infrastructure
  • Used Python scripts in Power BI for advanced data cleaning, transformation, and modeling beyond Power Query's native capabilities.
  • Developed reporting logic using SQL and experience with platforms such as SAS, Teradata.

Power BI Developer

USAA
05.2020 - 05.2021
  • Created dimensional models and deployed Power BI dashboards with advanced DAX logic.
  • Optimized SQL queries in collaboration with DBAs for accurate and efficient data feeds.
  • Automated reporting with SSIS and SSRS, reducing delivery cycles and human errors.
  • Supported end-user teams in defining reporting specs and training on BI tools.
  • Developed centralized reporting solutions enabling leadership to track KPIs and make data-driven decisions.
  • Built automated workflows using Power Automate to trigger notifications, approvals, and data synchronization across systems.
  • Worked closely with business users to understand their needs and create clear, user-friendly reporting tools.
  • Managed Power BI workspaces, gateways, and deployment workflows across dev/test/prod environments.

Power BI Developer

Vanguard
09.2019 - 04.2020
  • Built secure, performance-optimized SSIS data pipelines for OLTP to OLAP migration.
  • Developed access-controlled views to enforce data security and governance - Executed large-scale data migrations using DTS and tuned SQL Server environments.
  • Delivered backend architecture improvements for BI performance
  • Designed and maintained star schema models to support BI dashboards and data marts
  • Developed interactive dashboards with Power BI and Pentaho for executive use
  • Handled ad hoc BI/reporting needs across departments and leadership teams .
  • Led data profiling and S2T documentation efforts to support reliable transformation logic .
  • Collaborated with stakeholders to gather reporting requirements and ensure delivery quality

Power BI Developer

Blue Cross Blue Shield of Texas, Richardson
11.2016 - 08.2017
  • Design, develop, and maintain interactive Power BI dashboards and reports
  • Connect to various data sources like SQL Server, Excel, and cloud databases to extract and transform data
  • Create efficient data models using Power BI Desktop with proper relationships and hierarchies
  • Write complex DAX formulas for calculated columns, measures, and key performance indicators (KPIs)
  • Optimize report performance to ensure fast loading and smooth user experience
  • Performed root cause analysis to determine drivers behind performance discrepancies.
  • Developed crosswalks between datasets and policy frameworks to improve data alignment and reporting accuracy.
  • Translated multi-source analytical findings into strategic recommendations that informed program and policy improvements.
  • Implement data refresh schedules and manage data gateways in Power BI Service
  • Apply row-level security (RLS) to control data access based on user roles
  • Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions

Education

Master of Science - Computer Information Systems

Campbellsville University
Campbellsville, KY
08-2016

Skills

  • Portfolio management
  • Market forecasting
  • Risk mitigation
  • Maintenance planning

Timeline

ADM — Asset Manager / CMMS Analyst /Power BI Developer

ADM
08.2023 - Current

Business Intelligence Analyst

Apple
06.2021 - 07.2023

Power BI Developer

USAA
05.2020 - 05.2021

Power BI Developer

Vanguard
09.2019 - 04.2020

Power BI Developer

Blue Cross Blue Shield of Texas, Richardson
11.2016 - 08.2017

Master of Science - Computer Information Systems

Campbellsville University
Rahul Kancherla