SQL/Power BI BI Developer with ETL Expertise
Resume:
Upendra Gowd Yaragalla
SQL/Power BI Developer
*******.***@*****.***
www.linkedin.com/in/upendra
Summary
Over 5+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI, Power BI and Azure services.
Expertise in SQL Server 2019/2016/2014/ Reporting Services (SSRS), SQL Server 2019/2014 Integration Services (SSIS) and in SQL Server 2019/2014 Analysis Services (SSAS) in Business Intelligence (BI).
Experience in OLTP/OLAP environment and Data Warehouse.
Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI
Expert in creating multiple type of reports using tools like Power BI and SSRS.
Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
Experienced in cloud-based data integration and analytics using Azure Data Factory (ADF) for orchestrating data pipelines, Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage (Gen2) for scalable data storage and transformation.
Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
Worked as MS SQL Server Developer on enterprise and performance critical applications.
Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
Involved in migration of legacy data by creating various SSIS packages
Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
Education
Masters in Computer Science from University of Central Missouri.
Technical Skills
Databases/Data warehouse: SQL Server 2019/2017/2016/2014/2012
Programming Languages: T-SQL, SQL, PL/SQL
BI Tools: MSBI Stack (SSIS, SSRS, SSAS), Microsoft Visio, SQL Server Management Studio
Database Modelling: Star-Schema, Snowflake Schema, FACT and Dimension Tables, Erwin
Internet Technologies and Microsoft tools: HTML, XML, MS Office toolset (Word, Excel, Visio, Power point)
Scheduling tools/ETL: SQL Server Agent, Visual Studio, SSDT
Reporting tools: Tableau, Power BI, SSRS
Source Control: GitHub and Microsoft Azure DevOps (TFS)
Languages: SQL, T - SQL, HTML
ETL Tools: SQL Server Integration Services (SSIS).
Work Experience
Client: Johns Hopkins Medicine, MD Date: Jan 2025 to Current
Role: SQL/Power BI Developer
Collaborated with stakeholders to gather and analyse reporting requirements, recommending appropriate delivery formats using Power BI or SSRS based on business needs.
Installed, configured, and utilized Power BI Desktop for data modelling, visualization, and report creation.
Designed and developed interactive Power BI dashboards using a wide variety of visuals such as bar charts, clustered column charts, waterfall charts, gauges, pie charts, tree maps, and more.
Published Power BI reports to the Power BI Service, configured gateways, and scheduled data refreshes and report subscriptions.
Developed robust SSIS packages in Visual Studio 2019 for ETL workflows, including data extraction, transformation, and loading between Excel, flat files, Salesforce, Intacct, and SQL Server 2016/2019.
Migrated existing SSIS packages from SQL Server 2014 to 2019, ensuring compatibility and performance optimization.
Wrote complex T-SQL scripts, including stored procedures, functions, triggers, views, cursors, and optimized them using execution plans, DMVs, and SQL Profiler.
Employed temporary tables and table variables to improve performance in complex queries and reduce data processing times in reporting.
Created and deployed SSRS 2019 reports, including drill-down, drill-through, tabular, matrix, and parameterized reports, based on stored procedures and shared datasets.
Scheduled and managed report snapshots, data-driven subscriptions, and report caching for performance tuning in SSRS.
Installed and configured SQL Server Reporting Services (SSRS) 2019 on production environments and supported deployment processes.
Participated in normalization and denormalization of database schemas to optimize query performance and support analytical workloads.
Performed database backups, restores, and deployment activities as part of regular release cycles.
Documented ETL processes, data flow designs, and staging logic for long-term maintainability and onboarding support.
Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT); addressed defects and implemented enhancements based on feedback.
Modified and optimized existing IBM DataStage Jobs to improve data pipeline performance and align with new business requirements.
Environment: MS SQL Server 2019/2016, SSIS, SSRS, SSAS, Power BI Desktop, Power BI Service, On-premises Data Gateway, Salesforce, Intacct, T-SQL, DAX, SQL Profiler, XMLA, MS Excel, MS Access, Windows 8
Client: Advantum Health, Remote Date: May 2022 to Aug 2023
Role: BI/SSIS Developer
Defined system architecture, created detailed screen specifications, and designed logical and physical data models using Erwin Data Modeler.
Gathered and analysed reporting requirements; determined the best delivery medium using Power BI or SSRS, based on complexity and user needs.
Installed, configured, and maintained Power BI Desktop and Power BI Report Server for on-premises deployment and collaboration.
Designed and published interactive, responsive Power BI dashboards and reports using data from SQL Server, Excel, Flat Files, and SAP BW/BI.
Created rich visualizations such as bar charts, clustered columns, waterfall, gauges, pie charts, and tree maps to support KPIs and business metrics.
Created role-level security and implemented data locking and access restrictions on Power BI reports for sensitive datasets.
Built and deployed SSIS packages (.dtsx) in Visual Studio to facilitate ETL operations, including data loading from flat files, Excel, OLEDB sources, and SAP BW/BI into SQL Server databases.
Migrated SSIS packages from SQL Server 2014 to 2016, ensuring compatibility, improved performance, and updated best practices.
Used BCP and Bulk Insert utilities for high-performance data loading from multiple data sources into SQL Server environments.
Developed complex T-SQL scripts, stored procedures, triggers, views, cursors, and UDFs to implement core business logic and automate operations.
Utilized temporary tables and common table expressions (CTEs) to improve query efficiency, especially for reports that aggregate or join large datasets.
Designed and delivered a variety of SSRS reports, including drill-down, drill-through, tabular, matrix, and cross-tab reports, using stored procedures and shared datasets.
Conducted performance tuning using SQL Profiler, execution plans, DMVs, and query optimization techniques to address slow-running queries.
Configured and tested scheduled jobs, automated routine maintenance tasks (e.g., reindexing, stats updates), and implemented monitoring scripts to proactively manage performance.
Managed database-level security by creating and altering users, assigning system/database roles, and controlling access to objects.
Performed routine database backup, recovery, and deployment tasks for pre-production and production environments.
Documented ETL workflows, staging logic, report definitions, and architectural components for auditability and future maintenance.
Participated in integration testing (SIT), user acceptance testing (UAT), and defect resolution, ensuring solutions met functional and performance expectations.
Environment: SQL Server 2019/2017/2016, SSIS, SSRS, Power BI Desktop, Power BI Report Server, T-SQL, Visual Studio, Erwin, Excel, Python, R, Hadoop, Hive, Spark, SQL Profiler, SAP BW/BI
Client: Dew Software, Remote Date: Nov 2019 to May 2022
Role: SQL/ETL Developer
Designed and developed SSIS packages to extract data from SQL Server and export it to flat files; implemented control flow components such as Execute SQL Task, Data Flow Task, and event handlers for robust ETL processes.
Participated in the design, development, and testing of ETL strategies to load insurance data from various source systems using SSIS with strong focus on data transformation and cleansing.
Created and maintained database objects such as tables, views, stored procedures, triggers, functions, and packages to support business applications.
Performed database performance tuning and optimization using SQL Profiler, execution plans, indexing strategies, and partitioning to improve query execution and resource usage.
Developed complex T-SQL scripts to validate and automate business rules, and implemented triggers to ensure data integrity on INSERT, UPDATE, and DELETE operations.
Utilized views and indexed views to simplify application development and improve performance across multiple data access layers.
Implemented index and table partitioning strategies to enhance performance and improve database manageability for large datasets.
Built SSRS reports including bar charts, visual dashboards, filters, and parameterized reports, incorporating forecasting and trend analysis for executive-level insights.
Published SSRS reports for business stakeholders with interactive features like drill-down, filters, and actions, enabling user-driven customization and analysis.
Used Erwin Data Modeler for reverse engineering existing databases and aligning them with business requirements through updated conceptual and physical models.
Developed monitoring and integrity reports, implemented process logging, and built custom data validation and mapping tools for improved ETL oversight.
Scheduled and configured SQL Server Agent Jobs for recurring tasks such as database backups, index maintenance, and automated recovery procedures.
Conducted in-depth unit testing and debugging of stored procedures and triggers to ensure reliable data flow and error handling in the database environment.
Collaborated with cross-functional teams to ensure smooth deployments and adherence to data governance policies.
Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, Oracle 11g, Visual Studio 2008, VSS 2005, Erwin Data Modeler 7.3, Windows NT/2003, .NET Framework 3.5, C#, ASP.NET, XML
Contact this candidate