Ramakrishna
Power BI DEVELOPER BUSINESS INTELLIGENCE EXPERT
Crafting Business Intelligence Solutions, Excelling in data visualization, analytics, and ETL processes. Skilled in SQL Server, Power BI, and Azure, adept at designing normalized databases, optimizing performance, and delivering actionable insights.
QUALIFICATIONS PROFILE
Overall 10 years leading end-to-end Power BI implementations, transforming raw data into actionable insights for healthcare, insurance, and manufacturing sectors.
Designed interactive dashboards with DAX, custom visuals (Sankey, Deneb), and drill-through functionality for KPIs like patient outcomes, revenue leakage, and inventory turnover.
Spearheaded migrations from legacy systems (SSRS, Oracle, DB2) to Power BI and SQL Server Data Marts, improving query performance.
Built scalable SSIS packages and Alteryx workflows to consolidate data from SAP, SharePoint, Excel, and APIs into centralized models.
Tuned SSAS Tabular models, DAX measures, and SQL queries (via Execution Plans/Query Store), reducing refresh times by 40% and latency by 50%.
Empowered users with self-service analytics through Power BI Service, templates (PBIT), and training—cutting ad-hoc requests by 30%.
Implemented RLS, data sensitivity labels, and HIPAA/GDPR-compliant security in Power BI and SQL Server.
Automated data refreshes using Azure Data Link (ADL) and Power BI Deployment Pipelines, enabling near-real-time reporting.
Worked in Agile scrums to align deliverables with business priorities, resolving 90% of production issues within SLA.
Integrated heterogeneous sources (SAP, Oracle, DB2) via ABAP, SAPGETDATA, and optimized SSAS live connections.
Proficient in T-SQL, Power Query, paginated reports (Power BI Report Builder), and star-schema modeling for 10M+ row datasets.
Served as Power BI SME, guiding stakeholders on data modeling best practices and leading enterprise-wide analytics adoption.
AREA OF EXPERTISE
Business Intelligence (BI) Development: Extensive experience in designing, developing, and implementing BI solutions using Microsoft BI stack (SSAS, SSRS, SSIS) and Power BI.
Database Management: Proficiency in managing and optimizing databases, including SQL Server, MySQL, MS Access, and Azure SQL, with skills in database design, normalization, and performance tuning.
ETL (Extract, Transform, Load) Processes: Expertise in developing ETL processes using tools like SSIS to extract data from various sources, transform it, and load it into data warehouses and data marts.
Data Visualization and Reporting: Strong skills in creating interactive reports, dashboards, and visualizations using tools such as Power BI, SSRS, and Tableau, enabling effective data analysis and decision-making.
Technical Problem Solving: Demonstrated ability to troubleshoot complex technical issues, and optimize SQL queries and processes for performance improvement, showcasing strong problem-solving and analytical skills.
Education:
Bachelor’s degree in computer science
TECHNICAL ACUMEN
Business Intelligence & visualization
Dax, Power Query (M), Row-Level Security (RLS), Performance Optimizer, Deployment Pipelines, Paginated Reports
Visualization
Custom Visuals (Deneb, Charticulator), Drill-Through, Bookmarks, Tooltips, Mobile Reports
SSRS/SSAS
Tabular Models, Multidimensional Cubes, MDX, Report Builder
SQL server
SSIS, T-SQL (Stored Procedures, Functions, Triggers), Query Optimization, Execution Plans
Tools
Alteryx, Azure Data Factory (ADF), Sap Data Services
Data Warehousing
Star Schema, Snowflake Schema, Slowly Changing Dimensions (SCD), Data Marts
Databases
SQL Server, Oracle, Db2, Sap Hana
Cloud
Azure Synapse, Azure Data Lake (ADL), Power Bi Service, Azure Data Gateway
Big data
Handling Datasets (10m+ Rows), Partitioning, Incremental Refresh
Languages
SQL, Dax, M (Power Query), Basic Python (Pandas, Numpy)
sap integration
ABAP, Sapgetdata, Bex Queries
SQL tuning
Indexing Strategies, Query Store, SQL Profiler, Extended Events
security
Row-Level Security (RLS), Object-Level Security, Data Sensitivity Labels
Methodologies & tools
Agile, Scrum, Sprint Planning, Jira
Version control
Azure DevOps, Git
Documentation
ER Diagrams, Data Flow Diagrams (DFD), Use Case Modeling
WORK EXPERIENCE
SQL ETL/Power BI Developer Community Health Options, ME (Remote) July 2024 – Present
Project Summary: Power BI Analytics & Data Migration
Lead the design and implementation of enterprise Power BI solutions to transform healthcare data into actionable insights. Modernized reporting by migrating legacy systems to interactive dashboards with DAX-driven analytics and Azure data integration.
Designed interactive dashboards using custom visuals (e.g., Sankey charts, drill-through maps) to track KPIs like patient outcomes and claims processing.
Developed advanced DAX measures (time intelligence, dynamic filtering) to enable self-service analytics for business teams.
Automated data refreshes via Power BI Service and Azure Data Link (ADL), ensuring near-real-time reporting.
Created paginated reports using Power BI Report Builder for regulatory compliance documentation.
Built SSIS packages to consolidate data from SharePoint, Excel, and SQL Server into a centralized analytics model.
Optimized SSAS Tabular cubes as a data source for Power BI live connections, improving query performance by 35%.
Migrated legacy reports to Power BI using Deployment Pipelines, reducing maintenance overhead by 40%.
Served as Power BI SME, guiding stakeholders on best practices for data modeling and visualization.
Implemented row-level security (RLS) and data sensitivity labels to meet HIPAA compliance requirements.
Participated in daily Agile scrums to align deliverables with business priorities.
Power BI Developer Optum, MN Jan 2024 – June 2024
Project Summary: Enterprise Power BI & Data Mart Implementation
Led the implementation of a modern Power BI-driven analytics platform, replacing legacy systems with a scalable SQL Server Data Mart. Enabled real-time decision-making by integrating heterogeneous data sources (Oracle, DB2, Excel) and deploying SSAS cubes with Power BI live connections.
Designed interactive Power BI reports with live connections to SSAS cubes, ensuring sub-second response times for executive dashboards.
Developed DAX measures for KPIs (e.g., operational efficiency, revenue leakage) and implemented dynamic security roles.
Automated data refreshes to sync Power BI with the centralized Data Mart, reducing latency by 50%.
Spearheaded migration from legacy Oracle/DB2 to a SQL Server 2014 Data Mart, improving query performance by 40%.
Built optimized SSIS packages to extract/transform data from SAP, XML, and flat files, with robust error handling and logging.
Developed 50+ complex stored procedures for data aggregation and ETL workflows, reducing manual processes by 30%.
Replaced legacy reporting with Cognos BI and Power BI, enabling self-service analytics for 100+ users.
Created Alteryx workflows to blend SQL Server, SAP, and Excel data for Power BI consumption.
Collaborated with SAP teams to optimize ABAP queries feeding into Power BI datasets.
Translated business requirements into Power BI data models using star schema best practices.
Trained business users on Power BI Service and mobile app adoption.
Resolved 90% of production issues within SLA for Power BI reports.
Power BI Developer
Bridgestone India March 2019 – July 2022
Project Summary: Enterprise Power BI & Analytics Modernization
Spearheaded enterprise-grade Power BI solutions, delivering secure, scalable analytics with SAP and SQL Server integration. Enhanced decision-making through embedded analytics, advanced data modeling, and self-service capabilities.
Designed 30+ interactive Power BI dashboards with drill-through, bookmarks, and dynamic DAX measures, serving 100+ business users.
Developed custom Power BI templates (PBIT) and embedded solutions, reducing report development time by 35%.
Implemented Row-Level Security (RLS) and object-level security to ensure GDPR/compliance adherence.
Built SAP ABAP reports (RICEF objects) and integrated SAP data into Power BI using SAPGETDATA and Formula-Optimized Data Sources.
Created SSAS Tabular models with optimized DAX for enterprise-wide KPIs (YoY growth, inventory turnover).
Automated data pipelines via SSIS and PL/SQL triggers for real-time SAP-to-Power BI sync.
Optimized DAX calculations and query performance, improving report refresh speeds by 40%.
Designed star-schema data models in Power Query for efficient data transformation.
Configured incremental refreshes to handle 10M+ rows of transactional data.
Translated business requirements into technical specs using data flow diagrams and use case modeling.
Trained 50+ users on Power BI Service, enabling self-service analytics and reducing IT dependency.
MS SQL/Power BI Developer
Win Soft - India Dec 2016 to Feb 2019
Migration of 50+ legacy SSRS reports to Power BI, transforming static reporting into interactive, self-service analytics. Designed scalable star schema data models, optimized ETL processes, and deployed enterprise-grade dashboards—reducing manual reporting efforts by 30% and improving query performance by 40%. Enabled data-driven decision-making for 200+ users through secure, role-based access and user training.
Responsibilities:
Designed and developed complex T-SQL stored procedures, functions, and triggers to automate data extraction, transformation, and loading (ETL) from multiple source systems.
Optimized SQL queries using SQL Profiler, Execution Plans, and Query Store, reducing report execution time by 40% and improving database performance.
Built and maintained star schema data models with fact and dimension tables, ensuring optimal data structure for reporting and analytics.
Implemented indexing strategies and partitioning to enhance query performance on large datasets (10M+ rows).
Migrated 50+ legacy SSRS reports to Power BI, improving accessibility, interactivity, and reducing dependency on IT for report generation.
Developed interactive dashboards with drill-down capabilities, bookmarks, and custom visuals (e.g., Deneb, Charticulator) to enable deeper data exploration.
Implemented Row-Level Security (RLS) to restrict data access based on user roles, ensuring compliance with data governance policies.
Configured scheduled data refreshes and incremental loading to optimize Power BI dataset performance.
Designed Power BI data models with DAX measures (e.g., YTD comparisons, dynamic KPIs) to support business decision-making.
Enabled self-service analytics by creating user-friendly datasets in Power BI Service, allowing business teams to build their own reports.
Conducted training sessions for end-users on Power BI best practices, reducing ad-hoc report requests by 30%.
Monitored and tuned slow-running queries using SQL Server Profiler, Extended Events, and DMVs.
Resolved data discrepancies by debugging SSIS packages and optimizing data flow transformations.
Automated report delivery via Power BI subscriptions and Power Automate, improving efficiency in report distribution.
Environment:
SQL Server, SSIS, Power BI (Desktop & Service), T-SQL, DAX, SQL Profiler, Power Query, Azure Data Gateway
MATRIX, India June 2013 – Nov 2016
SQL DEVELOPER
Project Title: Database Development and Optimization
Roles & Responsibilities:
Initiated IT career as a SQL Server Developer, focusing on crafting SQL Scripts, stored procedures, and essential tables and views.
Transitioned adeptly to BI Stack comprising SSIS and SSRS, proficiently creating ETL packages and SSRS reports aligned with project requirements.
Cultivated a deep understanding of business requirements through collaboration with project managers and business analysts.
Undertook comprehensive project analysis from inception, encompassing project analytics and SQL development.
Gained exposure to data warehousing concepts at Veritas, specializing in data consolidation, cleansing, and integration.
Demonstrated proficiency in T-SQL queries (DDL and DML), constructing complex queries involving multiple tables to create and maintain database objects such as Stored Procedures, User Defined Functions, Triggers, Views, and Indexes.
Led the design and normalization of database tables, optimizing data structure for improved performance and scalability.
Prepared Data Flow Diagrams (DFDs), Entity Relationship Diagrams (ERDs), and Table Structure documentation, facilitating clear understanding and communication of database architecture and relationships.
Conducted performance tuning of Stored Procedures, removing unnecessary Cursors and Temporary Tables to enhance query performance and database efficiency.
Collaborated within an agile environment, actively participating in iterative testing methodologies to ensure the delivery of high-quality database solutions aligned with project requirements and timelines.
Tech Stack: SQL Server 2008 R2/2008, 2005, SharePoint 2007, T-SQL, MS Excel