SUMMARY:

• MS BI Developer with 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 with a great analytical mind.
• Hands on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting
• Services (SSRS) with 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 the 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 with 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 the 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 with 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 with 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 the 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 with 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 with Business Analysts and updated the status of tasks assigned on Agile Platform.
• Interacted with the DBA's, technical manager and business managers to know about the
• Business requirements and understand the workflow of information and meet their needs.·
• Strong experience with 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 the 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 the 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 the 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 the 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 within 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 the data in Power BI.·
• Accurate Data Models; adding the calculated DAX measures on top of the datasets wherever required.

Confidential, New York, NY

BI Developer

Responsibilities:

• Actively participated in meetings with 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 the referential integrity of the 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 the 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 with
• Full & Incremental Loads and populated data in the 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 with
• Full & Incremental Loads and populated data in the 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 the 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 with 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 the 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 with Multiple Data Flow tasks
• Build XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.
• Worked with 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 with error handling and worked with different methods of logging in SSIS.
• Deployed SSIS packages through the 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 the 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 with 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 with incremental load.
• Updated old ETL packages to the 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 the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Gathered functional requirements and Business requirements and written the technical specifications for building the 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 with Business analysts to create data dictionary for end-user.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Worked closely with developers, end users in designing and creating the 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 with 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 with Business Analysts, Client team, Development team, Capacity planning.
• Provided scripts to DBA for production implementation of data warehouse and several other database objects.