Sql Server Power Bi

Professional Summary:

Results-driven and detail-oriented ETL Developer with over 8 years of extensive experience in data analysis, design, and development of Business Intelligence (BI) solutions across Finance, Insurance, and Healthcare domains. Proven expertise in delivering enterprise-level data solutions through Agile project methodologies and Software Development Life Cycle (SDLC). Adept at developing and administering Microsoft SSIS packages for seamless data extraction, transformation, and loading (ETL) between databases and external sources. Skilled in writing complex T-SQL queries, optimizing query performance, and creating interactive data visualizations using Power BI, DAX (Data Analysis Expressions), and other reporting tools. A collaborative team player with strong problem-solving skills and a commitment to delivering high-quality, scalable data solutions.

Technical Skills:

Databases Tools: SSMS, SQL Server Data Tools, SQL Profiler

ETL Tools: SQL Server Integration Service (SSIS), Visual Studio 2015/2017, OLAP & OLTP.

Reporting Tools: Report Builder, SQL Server Reporting Services (2019,2017,2014), MS Power BI, Tableau, MS Excel, Power Query, Power Pivot.

Database: MS SQL Server 2019/2017/2014/2012, MS Access.

Data Modeling: Erwin, MS Visio.

Programming: Transact-SQL, XML, HTML, Python

Cloud Computing: Azure Data Factory (ADF), DevOps, Power BI

version control system: Git, GitHub, TFS, TFS DevOps.

Other Tools: MS Office Suite, Share Point, Confluence Page.

Professional Experience:

Trinity Health December 2022– Present

Role: ETL Developer

Collaborated with the infrastructure team to plan data storage capacity and gather requirements.

Designed and developed scalable SSIS packages to extract data from diverse sources (RDBMS, XML, CSV) and load it into target systems.

Working closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solutions to implement or support production issues.

Managed data sources and converted the raw data into meaningful visual insights using interactive reports and dashboards.

Developed and optimized complex T-SQL objects, including Stored Procedures, Functions, Indexes, and Views, leveraging CTEs and temporary tables.

Enhanced query performance using SQL Profiler and Database Engine Tuning Advisor

Scheduled and automated SSIS packages for monthly and weekly data feeds.

Designed ETL solutions to transform data from transactional systems into dimensional databases

Maintained technical documentation and adhered to coding standards.

Performed database maintenance tasks, including tuning, backups, restorations, and disaster recovery.

- Designs, develops, tests, and supports client server applications using C# and ASP.NET

- Experience in working with .NET Web Services, WCF framework and Web API using WSDL, SOAP and UDDI.

- Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases and the accuracy of reporting data.

- Leads and participates in special projects as needed and assigned.

Tools & Technologies: MS SQL server, SSMS 2017/2014, SSIS, SSRS, DWH, SQL Profiler and T-SQL, Visual Studio 2019/2017, GitHub, Git, Microsoft Offices, Index Tuning Wizard.

Estes Express Lines, VA

SQL/Business Intelligence -Developer January 2019 – November 2022

Managed Power BI dataflows for efficient data processing and integration.

Integrate Power BI with other various systems and applications.

Developed complex DAX formulas to create calculated columns and measure.

Prepared and provided data and performance metrics for official reporting deliverables.

Worked in troubleshooting and support of Power BI workspaces whenever there is an issue.

Generating Tableau dashboard reports, creating business intelligence reports and visualizations, and working with developers.

Migrated data from heterogeneous data sources (Data Mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Designed and deployed SSRS reports with advanced features like multi-value parameters and drill-down capabilities.

Collaborated with cross-functional teams to address performance issues and deliver solutions.

Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.

Tools & Technologies: Microsoft Power BI, SharePoint MOSS, MS SSMS 2017/2014, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), DWH, Teradata, TFS DevOps, Microsoft Visual Source Safe, XML, Oracle, and Windows

PNC Bank

Texas, Dalas June 2017 – December 2019

SQL/MSBI Developer

Developed and optimized T-SQL objects, including Stored Procedures, Functions, and Views.

Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Tuned SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Collaborated with stakeholders to gather requirements and implement data warehouse solutions.

Designed and deployed SSIS packages for data extraction, transformation, and loading.

Created SSRS reports for daily, weekly, monthly, and quarterly business needs

Supported database synchronization and schema changes to align with evolving business rules. Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using Cross-checked the SQL Server is online and that still have connectivity with the front-end applications and functionality, making sure a 24/7 availability. Collaborated with multiple application owners addressing various issues.

Tools & Technologies: SQL Server 2014/2012, BIDS, Visual Studio 2017/2015, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, and Report Builder.

GAVS May 2016 – May 2017

MS SQL Server SSIS/SSRS Developer

Designed and developed ETL packages using SSIS for data integration and transformation.

Identify and resolve problems encountered during both development and release of the SSIS code.

Debugging and troubleshooting technical issues while implementing the applications.

Designed and developed ETL packages using SSIS for data integration and transformation.

Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and updating and maintaining Visual Source Safe.

Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

Tools & Technologies: MS SQL Server 2014/2012/2008R2, SSRS, SSIS, SQL profiler, Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, NET, Visual Studio 2005/2010, MS Access.

Education:

*Bachelor’s Degree, St. Mary University College

Key Achievements:

Successfully reduced ETL processing time through query optimization and performance tuning.

Delivered scalable BI solutions that improved decision-making and operational efficiency.

Played a key role in migrating and integrating data from legacy systems to modern data warehouses.

Consistently recognized for delivering high-quality solutions within tight deadlines.

Contact this candidate