Summary
Overview
Work History
Education
Certification
Skillset
Summary Professional
Timeline
Generic

Rohan Reddy K

Mount Juliet,TN

Summary

Results-oriented Business/Data Analyst specializing in Power BI and SQL, refined at Deloitte Consulting Inc. Demonstrated success in creating interactive dashboards and automating data processes, significantly enhancing decision-making capabilities. Exceptional analytical skills paired with robust stakeholder collaboration, providing actionable insights that elevated operational performance and compliance within healthcare programs.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Business/Data Analyst

Deloitte Consulting Inc
Santa Fe, USA
02.2023 - Current
  • Collaborated with HSD to enhance eligibility systems and policy frameworks for Medicaid, SNAP, LIHEAP, and TANF benefits.
  • Designed multi-layered Power BI dashboards featuring advanced DAX calculations for real-time healthcare insights.
  • Analyzed CMS guidelines and state Medicaid policies to generate data-driven designs for eligibility workflows.
  • Produced patient-level datasets using SQL joins across EMR and billing systems for quality reporting.
  • Integrated external data sources into RDBMS environments through ETL processes, ensuring data consistency.
  • Generated ad hoc SQL reports, delivering timely insights to stakeholders under tight deadlines.
  • Developed Python scripts for data mining, facilitating real-time analysis from various APIs and file formats.
  • Delivered presentations that translated complex technical concepts into actionable business insights.

Business/Data Analyst

Credit Acceptance
01.2019 - 06.2021
  • Developed interactive dashboards in Power BI, incorporating Row Level Security and DAX features.
  • Created detailed SSRS reports addressing specific financial data requirements and compliance standards.
  • Executed precise SQL queries for validating data migration from Teradata, ensuring integrity and accuracy.
  • Automated data validation processes with Python, enhancing report quality delivered to management.
  • Utilized Pandas and NumPy for data wrangling on datasets exceeding 1M records.
  • Designed Salesforce workflows, reducing operational inefficiencies and minimizing manual entry errors.
  • Collaborated with cross-functional teams to gather requirements and develop aligned database solutions.
  • Conducted training sessions for end-users to enhance adoption of Tableau dashboards.

SQL BI Developer

Natco Pharma Limited
05.2017 - 12.2018
  • Developed reusable SQL stored procedures, triggers, and user-defined functions for automating complex data processing tasks.
  • Integrated data from SQL databases, Excel spreadsheets, and cloud platforms into Power BI for streamlined reporting.
  • Built company-wide sales analytics dashboard in Power BI, consolidating regional data for real-time revenue insights.
  • Designed scalable ETL workflows to integrate data from cloud platforms, APIs, and on-premises systems into centralized warehouses.
  • Created custom reports and dashboards in Salesforce and BI tools to support sales, marketing, and customer success initiatives.
  • Collaborated with stakeholders during new analytics tool implementation, providing training to ensure seamless adoption.
  • Utilized Python and SQL for advanced data exploration and statistical analysis to identify trends influencing business decisions.
  • Delivered SQL-based ETL processes that automated data transformation, minimizing manual errors and enhancing efficiency.

Education

Master of Science - Computer Science

Northwest Missouri State University
Maryville, MO
12.2022

Bachelor of Science - Computer Science Engineering

Jawaharlal Nehru Technological University
Hyderabad
05.2017

Certification

Microsoft Certified: Power BI Data Analyst Associate, 09/16/24, 09/15/25, 87188107D79A3B7E

Skillset

Snowflake, MSSQL Server, Oracle, MYSQL, Azure Data Warehouse, Data Bricks, SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Informatica Power Center, Snowflake, Power BI, Snowflake, SQL Server Reporting services (SSRS), Tableau, Power BI, Python, C, C++, Shell, Power shell, Jira, Confluence, ServiceNow, Power BI, Tableau, Alteryx, Power Apps

Summary Professional

  • Microsoft-certified Power BI Data Analyst Associate with 5+ years of experience in data analytics, database management, and business intelligence tools such as Power BI, Tableau, and SSRS.
  • Expertise in designing and optimizing SQL queries, stored procedures, and ETL workflows using tools like SSIS, Azure Data Factory, and Snowflake to ensure efficient data integration and warehousing.
  • Hands-on experience with advanced Power BI features such as Row Level Security (RLS), DAX calculations, and AI-driven analytics to deliver secure and insightful business solutions.
  • Strong collaboration and communication skills, demonstrated by partnering with stakeholders to gather requirements, deliver presentations, and create user-friendly dashboards aligned with business goals.
  • Experienced in utilizing Python for advanced data mining, automation, and integration with visualization tools like Power BI and Tableau to enhance the representation and analysis of complex datasets.
  • Skilled in creating predictive analytics and machine learning models to identify trends, forecast outcomes, and support proactive decision-making in business and financial contexts.
  • Adept at leveraging cloud platforms like AWS and Azure to build scalable data pipelines, integrate diverse data sources, and enable real-time analytics for cross-functional teams.
  • Proficient in Agile methodologies, collaborating with cross-functional teams, attending scrum meetings, and delivering iterative solutions to align analytics initiatives with organizational objectives and KPIs.

Timeline

Business/Data Analyst

Deloitte Consulting Inc
02.2023 - Current

Business/Data Analyst

Credit Acceptance
01.2019 - 06.2021

SQL BI Developer

Natco Pharma Limited
05.2017 - 12.2018

Master of Science - Computer Science

Northwest Missouri State University

Bachelor of Science - Computer Science Engineering

Jawaharlal Nehru Technological University
Rohan Reddy K