SUMMARY

• Over 7 years of experience in reporting solution development, ETL development, business intelligence solutions and enterprise data warehouses development involving multiple industries
• Expert Knowledge in building and managing relational databases and tables normalization/denormalization using SQL Server Management Studio (SSMS)
• Expert with producing highly efficient and project - oriented T-SQL query statements
• Goal-oriented usage of features such as Dynamic SQLs, Cursors, Views, Stored Procedures, User-Defined Functions (UDFs), Triggers, Indexes, Temp Table in SSMS to provide convenience for front-end applications or reporting purposes
• Proficient in tuning performance of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor
• Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, PowerBI, MS SQL Server Reporting Service (SSRS) and Excel
• Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis
• Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, Star/Snowflake Schemas using Landing and Staging stages
• Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.)
• Substantial experience in usage of Event Handlers, Loggings, Checkpoints, Breakpoints and Debugging in SSIS
• Proficient in using skills like Slow Changing (Type 0/1/2/3) and Change Data Capture to load and transform data dynamically
• Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC)
• Effective problem solver with thorough analytics added to credible and concise presentations

TECHNICAL SKILLS

RDBMS: MS SQL Server 2016/2012/2008 R2/2008/2005, MySQL, Oracle

Reporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 10/9/8, Power BI

Languages: T-SQL, PL/SQL, C++, C#

ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, Talend

Data Warehouse/OLAP: SQL Server Analysis Services (SSAS)

Development Platforms: Visual Studio 2015/2010/2008, SharePoint 2013/2010, Atom, Jupyter, PyCharm

Project Management: JIRA, Slack, TFS, Microsoft Project, Microsoft Visio

PROFESSIONAL EXPERIENCE

SQL/MSBI Developer

Confidential, Minnesota

Responsibilities:

• Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources
• Designed, developed and maintained a data warehouse
• Creating Tabular reports with SQL Server Reporting Services (SSRS).
• Generating parameterized reports, drill down drill through reports
• Used pages, cascading parameters, expressions and other features to create drill-down reports, drill-through reports, nested reports as operational reports in SSRS.
• Interacted with the Data Science team, developed risk management reports using Tableau for advanced visualizations
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Created complex queries for reporting and ETL processes using subqueries, common table expressions (CTE), temp tables, views, triggers, user defined functions, joins, and unions.
• Developed and Deployed complex ETL packages
• Troubleshooting and correcting production ETL issues.
• Performed database tuning, index optimization, defragging (rebuilding or reorganizing) fragmented indexes based on the degree of fragmentation
• Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL workflows to populate fact and dimension tables, and developed Cubes and reports for analysis.
• Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
• Optimizing stored procedures, T-SQL, views, and functions for the best performance.
• Refining and automates regular SQL processes, track issues, and document changes.

Business Intelligence Developer

Confidential

Responsibilities:

• Gathered and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications, and transformed them into deliverable solutions
• Participated in the data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them.
• Responsible for extracting data from EHR, EMR, some pharmacies and other external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions (UDFs) and Views
• Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor
• Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data marts based on Star Schema
• Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails
• Developed reporting solutions for different stakeholders from mock-up demos till deployment to analyze different dimensions as claims, transactions, appointments, supply, assets, and properties both in SSRS and Tableau
• Developed reporting solutions including tabular reports, matrix reports, using cascading parameters to achieve Drill-down Reports, Drill-through Reports, as well as Linked Reports for security concerns in SSRS 2008/2012 for the front-end application usage
• Worked with QA team, clarified and solved the issues, delivered to the project manager for approval and feedbacks
• Optimized SSRS report performance by snapshots and indexes while writing query statements
• Optimized report performance by refining queries in T-SQL, removing redundancies, retrieving only essential data and using SQL methods efficiently
• Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL workflows to populate fact and dimension tables, and developed Cubes and reports for analysis.
• Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
• Troubleshooting and correcting production ETL issues.
• Optimizing stored procedures, T-SQL, views, and functions for the best performance.
• Refining and automates regular SQL processes, track issues, and document changes.
• Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.
• Developed complex database objects like complex stored procedures and complex UDFs
• Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
• Developed script for data manipulation and ensuring data integrity.
• Designed, developed, and maintained a data warehouse
• Creating Tabular reports with SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2012/2016, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 8/10, Agile/Scrum, JIRA, Microsoft Visio