SUMMARY:

• MS BI Developer wif 7+ years of experience in Database Design and Development, ETL Implementation and Data Warehouse Solutions. Strong knowledge of BI applications such as SSMS, SSIS, SSAS, visualization and reporting tools such as SSRS, Power BI, Tableau as well as Azure Cloud Services. A solution - oriented, well-organized, effective team player wif a great analytical mind.
• Hands on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting
• Services (SSRS) wif good knowledge on SQL Server Analysis Services (SSAS) & Power BI.
• Designed SSIS packages, projects to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Profound Knowledge and Experience in dealing wif Relational Database Management
• Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys,
• Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams.·
• Hands-on experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans. ·
• Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes. Experience in developing teh applications using T-SQL Programming (DDL, DML, and DCL). Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, Joins and Common Table Expression (CTE).
• Experience in both on-prem and cloud solutions. Extensive experience wif Microsoft Azure ecosystem such as. Power BI Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, AKV Management. Also, good understanding and experience wif Snowflake and AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift
• Excellent 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.
• Experience in report writing using SQL Server Reporting Services (SSRS) / Power BI and creating various types of reports and dashboards like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, slice and dice, bookmark, ad-hoc and sub reports features and Sub Reports.
• High-level experience in writing DAX in Power BI and Expert in fine tuning teh reports.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SQL Server, MySQL, Oracle, flat file, AWS, Azure, ERP systems, etc.) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Hands-on experience wif Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, Azure analysis services, Azure Synapse Analytics.
• Hands on experience in Creating Star Schema and Snowflake Schemas. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and team lead experience.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. BI Developer

Responsibilities:

• Attended daily scrum meetings, discussed new requested features/user-stories/tasks wif Business Analysts and updated teh status of tasks assigned on Agile Platform.
• Interacted wif teh DBA's, technical manager and business managers to know about teh
• Business requirements and understand teh workflow of information and meet their needs.·
• Strong experience wif SQL Server and T-SQL in implementing, maintaining and developing
• Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking teh database consistency by executing DBCC commands.·
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into teh database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.·
• Developed various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.·
• Created data mart in Azure SQL Data Warehouse (Dimension tables, fact tables, Stored Procs, UDFs).·
• Migrated on-premises SQL Server schemas to teh cloud on Azure SQL Server DB and Azure
• VM, developed and maintained databases across both on-premises and cloud deployments.·
• Extracted data from old on-premises databases (SQL Server and Oracle) into Azure SQL Data Warehouse using Azure Data Factory and SSIS.
• Involved in configuring Azure platform for data pipelines, ADF, Azure Blob Storage and
• Data Lakes and building workflows to automate data flow using ADF.·
• Imported data into Synapse using different mechanisms like SSIS, Polybase, Azure Data Factory and stored teh imported data in a columnar format to enable distributed querying capabilities to improve performance of OLAP workloads.·
• Developed analytics solutions by defining and translating business requirements into dashboard & reporting solutions and implementing them wifin Microsoft Power BI
• Desktop and visualizations.·
• Created interactive, accurate, insightful, and well-organized Power BI reports/dashboards to support businesses in their data driven strategic planning.·
• Used various formatting techniques and features like interactive sorting, grouping, slicer, bookmarks, RLS, PLS and many others to create user friendly reports.·
• Developed filters, reports, dashboards, chart types, visualizations and complex calculations to manipulate teh data in Power BI.·
• Accurate Data Models; adding teh calculated DAX measures on top of teh datasets wherever required.

Confidential, New York, NY

BI Developer

Responsibilities:

• Actively participated in meetings wif different Departments, Managers and End users to capture and document system requirements.
• Designed, developed and maintained BI infrastructure comprised of large data (couple of Billions) using T-SQL, SSIS, SSAS, Relational Database, Tabular Modeling and Reporting tools.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes and other T-SQL code and SQL joins for SSIS packages and SSRS reports. Created constraints, defaults, rules, and triggers to maintain teh referential integrity of teh database
• Created complex analytic queries on huge data sets. developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required.
• Migrated on-premises SQL server schemas to teh cloud on Azure SQL Server and maintained databases across both on-premises and cloud deployments.
• Developed various SSIS packages (ETL) by using all Visual studio components for
• Integration services for example Control flow and various tasks like Data Flow/Execute
• SQL/Expression/File System Tasks and For Loop Container, Foreach Loop Container,
• Sequence Container
• Staged data from various sources in designing and building warehouse Dims and Facts wif
• Full & Incremental Loads and populated data in teh appropriate destination tables
• Applied various data cleansing and data transformations like Slowly Changing Dimension (SCD), Derived column, Aggregate, Sort, Multicast, Conditional Split, Union All.
• Staged data from various sources in designing and building warehouse Dims and Facts wif
• Full & Incremental Loads and populated data in teh appropriate destination tables
• Applied various data cleansing and data transformations like Slowly Changing Dimension (SCD), Derived column, Aggregate, Sort, Multicast, Conditional Split, Union All. Implemented Event Handlers, Error Handling, Logging and package configuration for deployment to test and production environment.
• Integrated data from multiple sources mainly from legacy systems (SQL table, flat files) into teh staging area.
• Played main leading role of offshore team by giving them tasks to migrate reports from SSRS which were sourcing from SQL Server and SSAS Multidimensional Cubes into Power BI.
• Designed and developed Power BI Dashboards and Reports wif complex DAX query measures/columns, drill down/drill through/hyperlink options, dynamic slicing/dicing features.
• Involved in applying Row-Level-Securities in all Power BI Reports, scheduled and monitored data source refreshes accordingly.
• Provided support and guidance to other members of teh BI team on separate projects.

Confidential - Brewster, NY

SQL Developer

Responsibilities:

• Created complex analytic queries on huge data sets. developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Lookups, and Derived Columns wif Multiple Data Flow tasks
• Build XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.
• Worked wif re-directing outputs into different formats including XML Files and various other data sources.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Developed and designed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler and third-party tools.
• Created packages wif error handling and worked wif different methods of logging in SSIS.
• Deployed SSIS packages through teh package Bids Deployment, installation wizard,
• Management Studio Import for automatization of data processes
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Worked on creating ETL solutions for integrating data from multiple sources like Flat Files
• (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into teh data warehouse
• Transferred data, analyzed results using statistical techniques and provided ongoing SSRS and Power BI reports.
• Generated SSRS and Power BI reports getting source from SSAS's Multidimensional OLAP and Tabular model cubes wif DAX and MDX.
• Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables.
• Developed and implemented data collection systems and other strategies which optimize statistical efficiency and data quality
• Build Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Updated old ETL packages to teh new version (did optimization by applying more stored procedures instead of using control flow tasks).

Confidential, New York NY

SQL Developer

Responsibilities:

• Updated old ETL packages to teh new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Gatheird functional requirements and Business requirements and written teh technical specifications for building teh Enterprise Integrated Data warehouse.
• Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis.
• Work wif Business analysts to create data dictionary for end-user.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Worked closely wif developers, end users in designing and creating teh Enterprise Integrated Data warehouse.
• Used SQL Server Agent for scheduling jobs and alerts.
• Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Automated manual process using Advanced ETL such as auto extract data from Smartsheet and load it into SQL server using Script task and merge statement.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Involved in Technical decisions for Business requirement, Interaction wif Business Analysts, Client team, Development team, Capacity planning.
• Provided scripts to DBA for production implementation of data warehouse and several other database objects.