Power Bi Sql Server

Ramya Bandireddy

Phone: +1-678-***-****

Email:*****************@*****.*** linkedin.com/in/ramya

Over 5 + years of extensive experience in database design, development with MS SQL Server versions 2022 / 2019 / 2017

/ 2016 / 2014 / 2012using SSIS ETL.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.

Hands on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.

Conversant with all phases of the Software Development Life Cycle (SDLC) especially involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.

Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.

Performed time series analysis using DAX expressions in Power BI, skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI.

Experienced in creating data-driven reports using stored procedures, SSIS packages, and OLAP/Tabular cubes. Skilled in automating ETL processes to streamline data migration and enhance reporting accuracy.

Proficient in T-SQL for developing complex queries, stored procedures, functions, views, and triggers. Experienced in performance tuning using indexing, execution plan analysis, and I/O optimization for scalable database solutions.

Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, reporting tools etc.

Possess a solid understanding of database and data warehousing concepts, including both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems. Experienced in designing and optimizing OLTP databases for efficient transactional performance, as well as developing OLAP data models to support complex analytical queries, reporting, and business intelligence solutions.

Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Writing stored procedures and developing reports using SSRS, Crystal reports.

Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.

Highly knowledgeable in Designing, Developing, and deploying various kinds of reports using SSRS using relational data.

Developed and optimized Data Analysis Expressions (DAX) to retrieve, manipulate, and analyze data directly from tabular models in SQL Server Analysis Services (SSAS). This included creating calculated columns, measures, and KPIs to support business intelligence reporting and analytics.

Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

Experience in Reporting services, Power BI (Dashboards Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.

Experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP. EDUCATION:

Masters in computer science at KENNESAW STATE UNIVERSITY 2023 – 2024 PROFESSIONAL SUMMARY:

TECHNICAL SKILLS:

Databases SQL Server 2022 / 2019 / 2017 / 2016 / 2014 / 2012, RDBMS, OLTP & OLAP, Data Warehousing

SQL & Scripting T-SQL, SQL, PL/SQL, Complex Queries, Stored Procedures, Views, Functions, Triggers, Shell Scripting

ETL & Data Integration SSIS, DTS, Data Migration, Data Transformation, Automation of ETL Workflows BI & Reporting SSRS, Power BI, Crystal Reports, Interactive Dashboards, KPI Reporting Performance Tuning Query Optimization, Execution Plans, Indexing Strategies, SQL Profiler, Database Engine Tuning

Data Modeling & Design

Erwin Data Modeler, Star & Snowflake Schema, UML, Logical & Physical Design, Data Normalization

Architecture Relational DBMS, Client-Server Architecture, OLAP, OLTP, Star & Snowflake schema PROFESSIONAL EXPERIENCE:

ROLE: BI DEVELOPER

HUMANA HEALTHCARE, LOUISVILLE, KY NOV 2024 -TILL DATE Responsibilities:

Collaborated with cross-functional stakeholders to gather and analyse business requirements, converting them into scalable BI solutions for reporting and analysis.

Executed dashboard configurations and data manipulation using DAX, and deployed SSIS packages to automate CSV file generation through scheduled SQL Server Agent jobs.

Developed interactive dashboards and reports in Power BI, and created business-specific applications using Power Apps to streamline operations.

Designed and implemented SSIS-based ETL pipelines, pulling data from SQL Server and applying DAX-based transformations for analytical reports.

Built calculated columns and measures in Power BI using DAX, tailoring them to align with complex reporting needs and user-driven insights.

Created dynamic visualizations and reports across various formats in Power BI and SSRS, utilizing standard and data- driven subscriptions for automated delivery.

Published and managed Power BI reports and dashboards, making them accessible through web clients and mobile platforms across business units.

Developed OLAP cubes using SSAS for multidimensional analysis and reporting, and created triggers and stored procedures for OLTP-to-OLAP data capture.

Implemented dynamic row-level security in Power BI, enabling secure access to data through role-based integration with the Power BI Service portal.

Designed visually rich dashboards in Power BI by translating business requirements into wireframes and mock-ups, then building interactive visual solutions.

Designed and configured SSAS OLAP cubes (Star and Snowflake schema) and built DTS/SSIS packages for data extraction from OLTP systems.

Developed SSRS reports including sub-reports, drilldowns, and parameterized reports, targeted at various regional stakeholders for monthly and quarterly metrics.

Performed comprehensive unit and system testing on BI reports and ETL packages to ensure accuracy, consistency, and data quality compliance.

Developed and scheduled SSIS, SSRS, and T-SQL jobs using SQL Server Agent to monitor, automate, and manage ETL and reporting processes.

Wrote and optimized complex T-SQL queries, stored procedures, and SSIS packages for high-performance data warehousing operations.

Implemented robust error handling and event-driven alerts in SSIS, notifying stakeholders of ETL results and handling data anomalies gracefully.

Created and managed tabular reports in Power BI, allowing users to explore insights through filters, slicers, and interactive drill-down functionality.

Involved in full SSIS development lifecycle, including design, build, deployment, and execution of ETL solutions in both Dev and Prod environments.

Built high-performance ETL packages in SSIS to extract, cleanse, and migrate data from MS Excel and SQL Server into enterprise data stores.

Performed ETL operations on data from flat files, Excel, and Oracle, transforming and loading it into SQL Server to power BI and analytics systems.

Used advanced SQL Joins and Sub-Queries to simplify and modularize complex business logic for reporting and data preparation.

Designed and implemented OLAP cubes in SSAS to support data warehouse architecture, and migrated diverse OLTP data into SQL Server for analysis.

Environment: Power BI, SQL 2022 / 2019 / 2017, SSIS, SSRS, DAX, T-SQL, SharePoint, Visual Studio (SSDT), Azure DevOps, PerformancePoint, Agile Methodology

ROLE: SQL SERVER DEVELOPER

KEY BANK, CLEVELAND, OHIO MARCH 2024 – OCT 2024

Responsibilities:

Managed SQL Server Agent components such as operators, alerts, job steps, and schedules; monitored connections, locks, and performance to ensure system stability.

Maintained physical databases by monitoring query performance, ensuring data consistency, and using SQL Profiler to optimize SQL queries for better execution times.

Created SSRS reports by extracting data from OLTP and OLAP sources and deployed them to the report server for business consumption.

Designed and implemented efficient data load procedures using MS SQL Server to streamline ETL workflows. Automated data extraction, transformation, and loading into staging and production environments.

Built OLAP cubes using SSAS for multidimensional analysis, enabling fast data retrieval and slicing/dicing across healthcare data.

Improved table performance through database normalization, indexing strategies, and regular updates to table statistics.

Utilized DAX functions to create calculated columns and measures that enhanced data modelling and analytical capabilities in Power BI.

Developed complex DAX queries in Power BI Desktop to create dynamic calculations, time intelligence metrics, and custom measures. Enabled advanced analytics and interactive reporting tailored to business needs.

Created KPIs, partitions, perspectives, and role-based security in Power BI and SSAS, using DAX for calculated measures and role filters.

Automated stored procedures and scheduled them using SQL Server Agent to streamline data loads into staging and production environments.

Designed custom and ad-hoc reports in SSRS, including multi-dimensional reports, by integrating OLAP data and MDX queries.

Built relational and dimensional database models in MS SQL Server, including creation of schema objects for robust data structures.

Developed parameterized and cascading reports in SSRS to allow dynamic user-driven report filtering and display.

Scheduled report subscriptions in SSRS to automate daily, weekly, and monthly report distribution based on business needs.

Applied in-depth knowledge of RDBMS and data modelling, using normalization for OLTP and dimensional modelling techniques for OLAP environments.

Automated SSIS packages with SQL Server Agent jobs, and created parameterized, sub, drill-down, and drill-through reports in SSRS using MDX.

Designed ETL architecture to efficiently move and transform data from OLTP systems to OLAP structures using SSIS.

Managed end-to-end BI lifecycle, from gathering requirements and data modelling to developing cubes, ETL workflows, and dashboards in SSIS, SSAS, and SSRS.

Optimized complex SQL queries and tuned long-running operations using SQL Profiler and Database Engine Tuning Advisor.

Developed reports using BIDS, SSRS, and SQL Server 2022, integrating OLTP and OLAP data using stored procedures and SSIS workflows.

Refined and automated SQL processes, documented changes, and monitored issues to ensure reliable and repeatable database operations.

Used SSIS Control Flow and Data Flow tasks to build ETL pipelines with transformations for cleansing, merging, and migrating data.

Created SSIS master-child packages using variables and the Execute Package Task to build modular, reusable, and maintainable ETL solutions. Enabled dynamic package execution and improved workflow manageability across environments.

Built complex Power BI reports by joining multiple tables across databases using advanced SQL queries to extract and visualize insights.

Automated Excel-based monthly reports by converting them into Tableau workbooks and dashboards, improving delivery speed and visualization quality.

Environment: SQL Server 2022, T-SQL, VB, DTS, SQL Profiler, Microsoft Business Intelligence Development Studio

(BIDS) Visual Source Safe, DTS/SSIS 2008, Import and Export Wizard, BCP, Windows Server 2003, UNIX. ROLE: SQL DEVELOPER

WIPRO, HYDERABAD, INDIA JUNE 2019- JULY 2023

Responsibilities:

Developed custom visual reports, interactive dashboards, and KPI scorecards using Power BI Desktop to track business performance and deliver data-driven insights to stakeholders.

Connected to data sources (SQL Data warehouse, flat file), importing data, and transforming data for Business Intelligence.

Implemented row level security on data and have a good understanding of application security layer models in Power BI.

Created queries using DAX functions in Power BI desktop Expertise in using advanced level calculations on the data set.

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Demonstrated strong ability in writing efficient SQL queries to extract, filter, and manipulate data from SQL Server databases for reporting and analysis.

Developed reusable stored procedures, functions, and PL/SQL scripts to support business logic and streamline common data processing tasks.

Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.

Implemented DR by creating NON-RAC and RAC Standby Data Guard for RAC Physical database and maintenance of DR databases, troubleshooting of various DG issues.

Excellent experience in installing and managing RAC (Real Application Clusters) Oracle 10g/11g on Linux, AIX.

Analyzed & Modified existing SSRS reports & SSIS packages.

Created basic SSIS packages using excel or text files as source and Insert/Update records into SQL Server table Dealt with SSRS Reports which we are getting from SSAS cubes.

Refactored poorly written SQL and PL/SQL statements by optimizing queries, indexing, and restructuring logic to significantly improve database performance.

Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.

Develop an understanding of OLAP processing to modify and manage multidimensional data warehousing, optimize dimensions and hierarchies, and incorporate aggregations into OLAP Cubes.

Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.

Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

Created & supported production SQL Server jobs. Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Developed reports with Charts, Grouping, Sorting and Multiple Datasets using Reporting Services (SSRS).

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.

Develop reports in BIDS, SSRS, SQL-Server 2022 / 2019 / 2017, stored procedures and perform ETL from various OLTP and OLAP databases.

Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Created reports using SSRS from OLTP and OLAP data sources and deployed them on report server. Environment: SQL Server, Business Intelligence Studio, T SQL, Erwin, MDX, Oracle 10g, ERWIN, MS Excel.

Contact this candidate