SUMMARY

• MS Business Intelligence Developer and Data Engineer with more than 9+ years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments, visualization tools such as Power BI and Tableau. Having work experience in different industries such as healthcare, service, leasing and insurance.
• Strong Experience in Confidential (MSBI) Business Intelligence, ETL Data Warehouse, OLTP & OLAP usingSQLServer Integration Services (SSIS), Reporting & Analysis Services (SSRS & SSAS) and MS SQLServer (2008,2012,2014,2016,2017,2019).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Clustering, T - SQL, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors and variousSQLserver objects like schemas, tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures.
• Developed physical data models, created DDL (Data Definition Language) scripts and DML (Data Manipulation language) scripts to manipulate theSQLDatabase.
• Good understanding ofNormalization /De-normalizationand database design methodology.
• Experience in data analysis SQL server database development and maintenance, data modeling that support day to day business operations and auditing of database for user transactions, login and database action and removing orphan users.
• Experience in data migration (using tools like Bulk Insert, DTEXEC, and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Involved in the development of scripts for loading the data into the tables in Enterprise Data Warehouse EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multi Load.
• Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Extensive Experience in ETL Data Warehouse Ralph Kimball Methodologies for supporting Data Extraction, Transformation and Loading processing using MSSQL Server Integration Services (SSIS) and Loaded process from Heterogeneous / Homogeneous Data Sources, performed Data Verification, Data Cleansing, Data Integration, Data Import & Export.
• Expert in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing the data loaded into OLTP and OLAP databases using SSIS.
• Applied various Transformations such as Lookup, Fuzzy Lookup, Merge, Merge Join, Conditional split, Multicast, Derived column, Cache, Slowly Changing Dimension (SCD Type1, Type2, and Type3).
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema.
• Experience in creating Report models for Ad-hoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, Ad-hoc and Crystal Reports using SSRS 2017/2016/2014/2012.
• Created subscriptions to provide a daily basis report.
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection
• Creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Import data from different data source to create Power BI reports and dashboards.
• Created reports using visualization options such as single and multi-row cards, waterfalls, column/pie/doughnut/scattered/bubble/clustered bar charts/ tabular and etc. to perform trend progress insights over time/to show distribution & compositions of different categories/insights in understanding the business patterns and seasonality.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Experience pushing and pulling data from Azure blob. Experience in developing and deploying back end services to Azure clouds.
• Migrated on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.
• Experience in defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services. SSAS (Tabular and multidimensional modes).
• Having huge experience to use C# for script tasks and script components with variables in SSIS.
• Having a good experience using Git, GitHub, TFS for version control and source control.
• Having experience developing and implementing ETL solutions using Big Query.
• Experience with Azure Data Factory to migrate from on premises into cloud
• Excellent communication, analytical, interpersonal, presentation, project management skills and ability to work with minimum supervision in large and small teams.
• Azure Data Factory (ADF), Integration Run Time (IR), File System Data Ingestion, Relational Data Ingestion
• Migration of on-premise data to Azure Data Lake Store using Azure Data Factory V2.
• Migrated SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
• Experienced in Developing Spark applications using Spark - SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
• Extracted Transformed and Loaded data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.

PROFESSIONAL EXPERIENCE

Senior BI Developer / Power BI Developer (SQL / Power BI)

Confidential

Responsibilities:

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with T-SQL, Power BI 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 to understand the business needs.
• Performed complex BI project tasks which included Solution Design, SQL script development, Report writings, Performance Tuning and Troubleshooting, Issue Resolution.
• Wrote new SQL queries, creating views and stored procedures for better performance and optimized existing scripts to use in Power BI reports.
• Created several complex reports using Power BI Desktop getting data from multiple sources and deployed to Power BI Service to share with end users via Workspace and Apps which implemented Row Level Security and User Group management.
• Created both clustered and non-clustered Indexes to retrieve faster the data from the databases. Modified slowly running queries by replacing row by row operations with set-based approaches which implement correct joins, CTEs, Temporary Tables and Window / Ranking Functions.
• Automated monthly and weekly deployment status monitoring by creating a self-serving Power BI report that replaced weekly manual reports. The new report allowed engineering team to check the status of deployment in real time, quickly identify failures and errors and fix the issues in a timely manner.
• Created complex measures and calculated columns using DAX queries, applied various data transformations with Power Query in Power BI desktop.
• Created and published documentations for all existing and new reports and dashboards.
• Created Pull Requests in ADO and deployed codes to upper environments (CI CD pipelines).
• Responsible for maintaining reports by closely monitoring auto refresh failures in Power BI Service and data issues in source data systems.
• Migrate on premise data into cloud data warehouses using ADF pipelines
• Configured Azure platform for data pipelines, ADF, Azure blob storage and built workflows to automate data flow using ADF

Senior BI Developer (SQL/SSIS/ADF/Power BI/Azure)

Confidential, Bethesda, MD

Responsibilities:

• Written complex SQL queries using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Worked with subject matter experts to prepare source to target mapping document for the migration project.
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction of source data.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application. Making changes to existing ETLs and building some new ETL processes.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create log file using like providers like XML, text file, SQL server.
• Experience work with cloud systems (Azure): pushing and pulling data from azure blob.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed/Deployed SSIS packages through package installation wizard, Bids Deployment, Management Studio Import to further automate data processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Proficient in developing parameterized reports, chart, graphs, linked reports, drill-down reports using PowerBI.
• Developed filters, reports, dashboards and created chart types, visualizations and complex calculations to manipulate the data in Power BI.
• Used various formatting techniques like interactive sorting, grouping to create user friendly reports.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Azure Data Factory (ADF), Integration Run Time (IR), File System Data Ingestion, Relational Data Ingestion
• Migration of on-premise data (SQL Server) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V2).
• Combined structured, unstructured and semi-structured data (log files, and media) using Azure Data Factory to Azure Blob Storage.
• Build operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data using Power BI together with Azure Analysis Services.
• Used Azure Data Factory pipelines to pull data from variety of semi-structured data sources, both on-premises and in the cloud. Ingested data from file-based locations containing CSV or JSON files.
• Used Power BI to implement a semantic model to simplify the analysis of business data and relationships by loading relevant data from Azure Synapse data warehouse.
• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

BI Developer (SQL/SSIS/SSRS/Power BI/Azure)

Confidential, Chicago, IL

Responsibilities:

• Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
• Developed complex T-SQLcode such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Temporary tables, table variables in Stored procedures to simply complex queries.
• Optimized queries by analyzing different query options and indexing strategies.
• Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
• Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validated incoming Data and performs notifications when jobs complete.
• Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
• Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
• Created packages in SSIS with error handling using Event handlers.
• Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files and scheduled SSIS packages using SQL Server Agent, Jams.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Converted more than 80 Tableau Maintenance, Finance, Lease reports to SSRS to support business user requirements.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Experienced in Cloud implementation for BI platforms using Azure SQL PAAS/SAAS/IAAS, Azure Synapse and Azure Data factory.
• Managed to migrate SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and responsible for the development and maintenance of databases both on-premise and cloud deployments.
• Experience in data discovery to data provisioning to Azure ADW and leveraging SSIS to create facts and dims, leveraging ADF to automate and provision data inbound to DW.

BI Developer (SQL/SSIS/SSRS)

Confidential, Houston, TX

Responsibilities:

• Run SQL Server SSIS packages to load and transform to the SQL Server data warehouse.
• Created and maintained SSIS packages for various migration project and provide step-by-step instructions for vendors how to run in and generated files from their Database
• Create Access DB templates to search data files for customers as needed, create SQL scripts to load users into an Oracle DB by querying the data warehouse for data.
• Multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• 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.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS.
• Implemented Error Handling and Event Handlers and also configured.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Created SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Worked with building the complex Ad Hoc, Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Involved in creating, structuring, formatting using Report Designer and Report Builder.
• Developed member trouble shoot reports from different application database by using SSRS reporting tool.

SQL Database Developer (T-SQL/SSIS)

Confidential, San Francisco, CA

Responsibilities:

• Involved in database development and creating SQL scripts. Also experience writing complex T-SQL queries to support needs from business.
• Worked closely with customers and IT management and staff to provide application development and production support.
• Defined High Level Data Architecture for ETL & BI Solutions & Framework Design, Prototyping, ETL Loading Strategy Definition, Data stage, Data Governance & RDBMS standards definition and enforcement, Definition of Data Stage Best Practices & Coding Standards.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Analyzing SQL data, identifying issues, and modifying the SQL scripts to fix the issues.
• Tuned and Optimized SQL Queries using execution plan and profiler.
• Used T-SQL to run daily tasks and provide daily report to business and IT at the end of each day.
• Experience in business process analysis, data modeling and ability to proactively identify, manage, and correct data quality issues.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Participated in design discussions with Database architects and Application architects.
• Worked on implementation of SQL Server Master Data Services 2012 to achieve reliable, centralized data for Accounting that can be analyzed, resulting in better business decisions.
• High Experienced in generating SSIS Packages/projects from various sources to specific destination by using Visual Studio 2012, building and scheduling jobs for ETL process.
• Developed SSIS packages to pull out, modify and load data from Oracle/SAP and SQL Server databases into Data Warehouse.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Created packages using the various control flow task such as data flow task, execute SQL task.
• Good knowledge on the dimension, fact tables and designing the Data-Mart using Star schema.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

SQL Database Developer

Confidential | Chicago, IL

Responsibilities:

• Wrote and Developed complex T-SQL stored procedures/ User Defined functions/expressions, CTEs, indexed views, stage tables to process the data and populate them in the appropriate destination tables.
• Created and scheduled various SQL jobs, using SQL Server Agent to perform various administrative tasks.
• Implemented reverse engineering to examine a database or script file in T-SQL
• Created complex ETL packages to load data from OLTP to Datawarehouse with incremental load using SQL Server Integration Services.
• Loaded data from various sources, such as flat file, CSV, Excel, SQL Server, Oracle Database into Datawarehouse using SSIS.
• Used Script Task to load data from multiple flat files into SQL Server.
• Developed SSIS packages for File Transfer from legacy systems to upgraded application backend systems, Data flow task, File system task, Execute SQL task, and FTP task and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Designed and developed MS SQL server stored procedures using T-SQL statements from scratch. Developed triggers on views to populate tables. Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Created and used different Database constraints, such as Primary Key, Foreign Key, Unique Key, Check, NULL to provide referential integrity as well as apply business logic into tables in SQL server.
• Designed ad hoc SSRS reports in the test environment for data validation utilized SQL Server 2012.
• Repaired SSIS packages with checkpoints, breakpoints, and data viewers.
• Created SSIS packages utilizing different transformations in SSIS toolbox such as aggregate, Merge, and Merge join.