SUMMARY

• Business Intelligence professional with more than 10+ years of experience in the full data delivery pipeline, which includes database design, database maintenance, data collection, ETL processing, data validation, data cleansing, report delivery, and data analysis.
• Excellent skills in writing T - SQL queries, stored procedures, user defined functions, window functions, derived tables and views and SQL performance tuning.
• Proven success in leadership, operational excellence and organizational development with keen understanding of elements of different areas such as aviation, transportation, healthcare and sales.
• Steps into new areas with adaptable approach.
• Hands on experience with Microsoft BI (T-SQL, SSIS, SSAS), Azure (SQL Server, ADF, IaaS/SaaS/PaaS, Blob, SQL DW, ADLS2, AKV, Synapse, Databricks and etc.), AWS (EC2, RDS SQL Server, Amazon Redshift, S3 and etc.) and reporting (SSRS, Power BI, Tableau) tools;
• Excellent skills in creating and managing Databases, and various database objects like Tables, Views, Indexed Views, Complex Parametrized Stored Procedures, DDL/DML Triggers, Cursors, User Defined Data Types, User Defined Functions and Indexes (clustered, non-clustered, filtered, covering, with included columns, column stored) using T-SQL;
• Expert in Performance Tuning of Complex T-SQL codes, SSIS packages, Power BI/SSRS/Tableau reports;
• Expertise in Extracting, Transformation and Loading (ETL) using various tools like export/import data and SQL Server Integration services. Created, Developed, Tested and Deployed Packages into production servers by creating package configurations;
• Excellent at all stages of SSRS/Power BI/Tableau Reporting Life Cycle and hands on experience in creating various types of dashboards and reports;
• Highly skilled in Analyses Service, particularly in building both Tabular and Multidimensional models on top of DW/DM/DB and writing complex DAX and MDX queries against the models.

PROFESSIONAL EXPERIENCE

Senior BI Developer

Confidential, New Jersey, NJ

Responsibilities:

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with T-SQL, SSIS, ADF2, SSAS, Power BI, Tableau and Azure tools;
• Daily scrum meetings with Project Managers, Business Analysts and end users/clients to gather, analyze and document the business requirements and business rules; discuss the project specs in order to understand the business needs;
• Assisted and supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members;
• Implemented performance tuning on complex stored procedures, views, user defined functions and queries by creating proper indexes and optimizing the existing ones;
• Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands;
• Migrated on-premise SQL server schemas to the cloud on Azure SQL Server and maintained databases across both on-premise and cloud deployments;
• Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes; Build workflows to automate data flow using Python and ADF2;
• Performed incremental data loading in order to synchronize data changes between OLTP and OLAP databases using SSIS packages, execute SQL task and merge;
• Send email notifications about ETL issues reports to development team by using Send Mail Task/Script Task/Execute SQL Task along with system stored procedure to send emails;
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script;
• Involved in building Power BI and Tableau reports/dashboards for different domains such as Finance, Accounting, Management, and other client teams;
• Performed code review for junior SQL developers to validate their code both performance wise and result wise.

Senior SQL/BI Developer / Team Lead

Confidential

Responsibilities:

• Lead the BI Team to define data extraction, data ingestion, modelling and analytics. Lead the technical planning and requirements gathering phases including architecting, designing development, testing and delivering complex project;
• Created logic and indexed tables/views/stored procedures based on the business requirements and rules; Involved in writing heavy T-SQL queries, complex joins, Merge, Except commands and etc.;
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database;
• Wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance;
• Worked in Amazon Web Services (EC2, S3), installed MS SQL Server and other tools in Virtual Machine, deployed databases, cubes, packages;
• Sourced data from SQL Azure database, SQL Azure Data warehouse, AWS RDS solutions such as MySQL, Aurora and Redshift for Power BI reports;
• Migrated dashboards/reports from Tableau into Power BI which were sourcing from different sources like Excel, SharePoint List, SQL Server, Galaxy System DB2, SSAS Multidimensional Cubes;
• Involved in designing, developing, maintaining, and delivering new Power BI reports (Scorecard, Summary, E2E, KTLO and so on) with complex DAX query measures, columns, drill down, drill through, hyperlink options, dynamic slicing and dicing features, custom tooltips and KPIs by using different visualization like charts, histograms, pie charts, matrices, doughnut charts, tabular and etc. Applied RLS and PLS to reports;
• While migration, in order to standardize and keep the data consistent in all layers of the organization, sourcing strategies of Power BI reports were standardized to Tabular models which were built on top of SQL server Data warehouse and data Marts using SQL Server Analysis Services (SSAS);