Sql Server Power Bi

Professional Summary:

*+ years of strong experience in data analysis, design, and development of Business Intelligence solutions. Extensive experience in Finance, Insurance and Healthcare domains. Self-motivated, detail oriented and team player to deliver enterprise data solutions. Experienced in working Agile project Methodology throughout the Software Development Life Cycle (SDLC).

Expert in developing and administrating of Microsoft SSIS package to extract transform and load data between databases and different external sources and targets. Extensive experience of writing complex T-SQL and performance tuning of slow running queries. Proficient in Power BI data visualization, data modeling, DAX (Data analysis Expressions).

Business Skills

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

ETL: 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.

Education

Bachelors’ Degree, St. Marry University College

Professional Experience:

Trinity Health December 2022– Present

Role: ETL Developer

Worked with infrastructure team to determine data storage capacity planning and requirement gathering.

Developed large scale SSIS packages that extract data from multiple sources like RDBMS, XML, CSV

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.

Involving in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to

Creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (Used CTE, temporary tables, user defined table types in codes developed)

Performing T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor

Scheduling SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

Designing and developing ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations

Creating and maintaining technical documentation using defined technical documentation templates.

Contributing to the creation of solid coding techniques and recommended and reviewed coding standards.

Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.

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

Estes Express Lines, VA

SQL/Business Intelligence -Developer January 2019 – November 2022

Managed Power BI dataflows to ensure 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 work 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.

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

Excellent report creation skills using Microsoft SQL Server 2019/2016 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.

Worked on performance point server to create dashboard and scorecards for business intelligence.

Developed Complex Stored Procedures, Views, and Temporary Tables as per the requirement.

Created complex reports which involve a greater number of groupings and multi-value parameters and reports with drop down menu option having complex groupings within the report.

Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging, and working with package configure files.

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.

Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.

Tools & Technologies: Microsoft Power BI, SharePoint MOSS, MS SSMS 2017/2014, Query Analyzer, SQL Profiler, Index Tuning Wizard, 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

Created stored procedures, functions, views, and other database objects.

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

Worked with business users and stakeholders to gather and refine requirements.

Deployed database objects from development/testing environment to production environment.

Supported end users to resolve issues and assisted users on existing database applications.

Successfully created schema change scripts to existing objects to synchronize with changing business rules.

Wrote complex stored procedures to process prospective customer information and balanced the processing load between frontend and backend.

Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.

Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.

Developed SSIS package to load data into dimensions and fact tables using slowly changing dimensions.

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly, and quarterly reports.

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, Report Builder.

GAVS May 2016 – May 2017

MS SQL Server SSIS/SSRS Developer

Created ETL SSIS packages both design and code to process data to target databases.

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

Debugging and troubleshooting the technical issues while implementing the applications.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created packages in SSIS with error handling and worked with different methods of logging in SSIS.

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

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

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.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

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.

Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

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.

Documented all the work and all the process of integration and reporting services for further references.

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

Contact this candidate