Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shravani Tirupati

Tampa

Summary

Seasoned Power BI Developer and SQL BI Developer with 10+ years of experience in Business Intelligence (BI), Data Analysis, and Database Development across Manufacturing and Healthcare domains. Expertise in BI applications using SQL Server, Power BI, Tableau, SSIS, SSRS, and SSAS. Strong background in database design, data modeling, ETL processes, and reporting, with hands-on experience in T-SQL, query optimization, and performance tuning. Proficient in Data Warehousing concepts, including Star and Snowflake Schemas, dimensional modeling, and OLAP solutions. Well-versed in Agile methodologies (Scrum, Kanban) and Software Development Life Cycle (SDLC), with a keen ability to translate business needs into effective data-driven solutions. Skilled in Azure, AWS RDS, and cloud-based BI solutions, with expertise in Azure Data Factory and scalable architectures. Adept at financial modeling, KPI development, and interactive dashboards, utilizing DAX and MDX for advanced analytics. Proven ability to manage ETL pipelines, data migrations, and integration projects, ensuring data accuracy and performance optimization. Strong communicator with a proactive, analytical approach to problem-solving, ensuring seamless collaboration across teams.

Overview

11
11
years of professional experience

Work History

Sr Power BI Developer/Sr SQL BI Developer

Honda America
09.2024 - Current
  • Company Overview: Honda America Power BI Data Analytics Project focuses on developing, optimizing, and maintaining business intelligence solutions to enhance data-driven decision-making
  • Developed and optimized Power BI dashboards and reports for business insights
  • Performed data cleansing and transformation using Power Query
  • Created DAX expressions for complex calculations and business logic
  • Designed data models and implemented relationships and hierarchies
  • Connected Power BI to various data sources (SQL Server, Excel, Azure, SharePoint)
  • Scheduled automatic refreshes and optimized data models for performance
  • Applied Row-Level Security (RLS) to restrict access based on roles
  • Configured on-premises Power BI gateways for real-time data updates
  • Wrote complex SQL queries and optimized T-SQL procedures for efficient reporting
  • Designed interactive visualizations including charts, KPIs, and dashboards
  • Managed Power BI Pro deployment, security configurations, and access privileges
  • Integrated Power BI with SSRS, SQL Server, and cloud platforms for end-to-end BI solutions
  • Installed, upgraded, and maintained Power BI Desktop and Service environments
  • Honda America Power BI Data Analytics Project focuses on developing, optimizing, and maintaining business intelligence solutions to enhance data-driven decision-making

Sr Power BI Developer/Sr SQL BI Developer

Surgery Partners
07.2022 - 08.2024
  • Company Overview: Surgery Partners is a leading healthcare services company with an integrated delivery model
  • Operates multiple types of healthcare services dedicated to improving the quality of care in a convenient and cost-effective manner
  • Developed Power BI reports and dashboards by connecting to multiple data sources, including Azure DevOps, SQL Server, and cloud-based databases
  • Designed interactive reports with DAX functions, KPIs, and scorecards to enhance business insights
  • Implemented row-level security (RLS) and managed report sharing and publishing across the organization
  • Developed financial data models for budgeting, cost analysis, and revenue forecasting
  • Optimized SQL queries, created stored procedures, and improved ETL performance using SSIS
  • Utilized Power Query for data transformation, cleansing, and massaging
  • Troubleshot reporting issues, ETL job failures, and performance bottlenecks
  • Integrated Power BI Gateway for real-time updates from on-premise databases
  • Engaged with SMEs and business users to gather and refine technical requirements
  • Created drill-down and drill-through reports for enhanced data exploration
  • Led stand-up meetings and facilitated cross-team communication
  • Surgery Partners is a leading healthcare services company with an integrated delivery model
  • Operates multiple types of healthcare services dedicated to improving the quality of care in a convenient and cost-effective manner
  • Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, ThoughtSpot, Microsoft Office, Outlook, Microsoft Teams, SQL Server 2017, SSIS, SSAS 2019, MS Excel, Windows 10

SQL BI Developer / Power BI Developer

ALDI Supermarket
01.2020 - 06.2022
  • Company Overview: This project contains a detailed report and dashboard of supermarket sales for the supermarket branches; we answer some questions about branch sales to get data insights
  • Developed and managed data marts and OLAP cubes using Microsoft SSAS
  • Designed and implemented Multidimensional and Tabular cube models for reporting and analytics
  • Performed dimensional modeling, semantic layer definition, and BI metadata management
  • Implemented row-level security (RLS) in Power BI and SSAS for controlled data access
  • Created interactive dashboards, reports, and analytical cubes using Power BI, ThoughtSpot, and SSRS
  • Published and shared Power BI reports across the company cloud platform
  • Assisted in data architecture, design standards, and documentation
  • Wrote complex DAX queries for calculated measures and advanced analytics
  • Developed SSIS packages for ETL processes and monitored cube refresh cycles
  • Built financial data models for budgeting, cash flow, and forecasting using Cubes, Excel, and VBA
  • Designed and maintained ETL pipelines, SQL jobs, and automated alerts for performance monitoring
  • Created and optimized SQL stored procedures for improved query performance
  • Integrated Power BI with Tabular cubes for real-time reporting and data visualization
  • Collaborated with cross-functional teams to gather requirements and support BI initiatives
  • This project contains a detailed report and dashboard of supermarket sales for the supermarket branches; we answer some questions about branch sales to get data insights
  • Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, ThoughtSpot, SharePoint, Microsoft Office, VBA, Outlook, Microsoft Teams, SQL Server 2017, SSIS, SSAS 2019, DAX, MS Excel, Windows 10

SQL BI Developer

American College of Healthcare Executives
05.2018 - 12.2019
  • Company Overview: ACHE Health Plans, provides managed care services exclusively for government sponsored health care programs, focusing on Medicaid and Medicare
  • Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP
  • Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally
  • Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process
  • Created Data-driven Packages in SSIS 2012 as part of automating the process for the Referral Process
  • Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users
  • Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality
  • Worked on SSIS (DTS, DTSX) packages for Data Integration Services
  • Used SSIS to produce a Data Mart for reporting
  • Extensively used System variables and created User-Defined variables for SSIS packages
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies
  • Developed custom reports and developed them on server using SQL Server Reporting Services (SSRS)
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
  • Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX
  • Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS)
  • Worked with Report Builder 2.0, Report Models and Ad Hoc reports and worked with Tableau desktop, Tableau server and Tableau reader in various versions of Tableau
  • Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
  • ACHE Health Plans, provides managed care services exclusively for government sponsored health care programs, focusing on Medicaid and Medicare
  • Environment: SQL Server 2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS
  • SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8

Data Base Developer

Void main Technologies
03.2014 - 04.2018
  • Company Overview: Voidmain Technologies is a software and technology company that specializes in providing solutions for the subscription billing, customer management, and revenue management needs of businesses across various industries
  • Developed and optimized database objects such as Procedures, Functions, Packages, Triggers, Indexes, and Views using T-SQL in Development and Production environments
  • Created and optimized SQL scripts for tuning, scheduling, and automation
  • Performed data conversions from flat files into a normalized database structure
  • Managed users, roles, and database security to ensure data integrity
  • Implemented triggers and constraints to enforce referential integrity and business rules
  • Collaborated with developers, end-users, and administrators to design and optimize databases
  • Designed and maintained Snapshot Replication for development and testing databases
  • Scheduled and monitored SQL jobs and alerts for system automation
  • Conducted performance tuning using SQL Profiler, Index Tuning Wizard, and indexing strategies
  • Developed dynamic T-SQL scripts for DML automation based on user inputs
  • Assisted in system integration, testing, and documentation reviews
  • Conducted regression testing and optimized connection pooling issues for improved system response times
  • Voidmain Technologies is a software and technology company that specializes in providing solutions for the subscription billing, customer management, and revenue management needs of businesses across various industries
  • Environment: SQL Server 2008, T-SQL, PL/SQL, TOAD, Forms 6i, Reports 6i

Education

Master of Technology - Software Engineering

JNTU

Skills

  • Windows
  • Linux
  • Unix
  • C
  • C
  • Java
  • Python
  • PL/SQL
  • SQL Server Business Intelligence Studio
  • SSIS
  • SSRS
  • SSAS
  • DTS
  • Power BI
  • MS SQL Server 2012
  • MS SQL Server 2008
  • Oracle 10g
  • Oracle 9i
  • Oracle 8i
  • MYSQL
  • Snowflake
  • MongoDB
  • SharePoint
  • SSRS 2012
  • SSRS 2008
  • Crystal Reports XI
  • Crystal Reports X
  • Crystal Reports 9
  • Crystal Reports 8
  • Excel
  • Tableau
  • SOAP
  • REST
  • HTML
  • XML
  • JavaScript
  • Angular JS
  • PHP
  • Shell Scripting
  • JQuery
  • Agile
  • Waterfall
  • Scrum
  • AWS
  • Azure
  • Google Cloud

Timeline

Sr Power BI Developer/Sr SQL BI Developer

Honda America
09.2024 - Current

Sr Power BI Developer/Sr SQL BI Developer

Surgery Partners
07.2022 - 08.2024

SQL BI Developer / Power BI Developer

ALDI Supermarket
01.2020 - 06.2022

SQL BI Developer

American College of Healthcare Executives
05.2018 - 12.2019

Data Base Developer

Void main Technologies
03.2014 - 04.2018

Master of Technology - Software Engineering

JNTU

Similar Profiles

CREATE PROFILE
Shravani Tirupati