SUMMARY

• 12 years of IT Experience in Microsoft APS, Database Design, Development and business intelligence for versions 2016/ 2014/2012/2008 R2/2005/2000 and Visual Studio 2017/2015/2013 in Development, Test and Production Environments.
• Expertise in design and development of teh Enterprise Data Warehouse EDW, writing ETL code to migrate data from various sources to MicroSoft Parallel DataWarehouse (PDW) and Azure DataWarehouse (ADW)
• Plan, design, and implement application to migrate data from different sources like Sql server, IBM DB2, Flatfiles etc.. into Azure Blob Store or Azure Data Lake Storage.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings to extract teh data from multiple source systems dat comprise databases like IBM DB2, SQL Server 7.2, flat files to teh Staging area, EDW and tan to teh Data Marts.
• Experience with running SSIS packages from teh and viewing teh SSRS reports from MVC.
• Experience developing MVC model for SSIS, SSRS ans SSAS projects run dynamically.
• Expertise in writing T - SQL Queries using joins, Sub queries,StoredProcedures in MS SQL Server 2014/2012/2008 R 2/2005/2000.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Thorough experience developing SSIS packages involving complex transformations for data transfer between various source and targets.
• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome teh transformation constraints.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for MS SQL Server.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through .
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

SQL Server Tools: MS Business Intelligence Visual Studio 2017,2015,2013,SQL Server Management Studio 2016,2012,2008 r2, SQL Developer, SQL Plus

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)

Databases: Microsoft AzureDataWarehouse 2016,Parallel DataWarehouse 2015,2013,SQL Server 2014,2012, 2008/2005/2000 , MS Access 97/2000

Languages: T-SQL, C#, VB.NET

Operating Systems: Windows server 2010,Windows server 2003, Windows 2000 advanced server Windows 7, Redhat Linux, UNIX Windows95/98/NT/4.0/2000, XP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr MSBI Lead & ETL Support

Responsibilities:

• Plan, design, and implement application database code objects to migrate data into MS Parallel DataWarehouse and Azure DataWarehouse.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.
• Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/Datamart tables.
• Plan, design, and implement application to migrate data from different sources like Sql server, IBM DB2 etc into Azure Blob Store or Azure Data Lake Storage.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh Datawarehouse cubes.
• Experience with running SSIS packages from teh and viewing teh SSRS reports from MVC.
• Experience developing MVC model for SSIS, SSRS ans SSAS projects run dynamically.
• Build and maintain teh external tables in Azure DataLake Storage/Azure Blob Storage to migrate data from PolyBase supported delimited text files into Azure Data Warehouse internal tables.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed Views dat are frequently required for teh application.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL .
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes and Views.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Wrote and modified stored procedures to implement teh complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Expert in developing T-SQL (DDL, DML, DCL) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues used DBCC (Database Consistency Checks) Utilities to check teh physical and logical consistency of teh database.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Performing Report testing, Performance Optimization and Verification as per internal reporting system requirements.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security and documentation.

Environment: Microsoft Visual Studio 2017,2015,2013; SSMS 2016,2014,2012,2008, SSIS, SSRS, SQL Server, XML, MS Access

Confidential, NC

Sr MSBI Lead & ETL Support

Responsibilities:

• Plan, design, and implement application database code objects to migrate data into MS Parallel DataWarehouse and Azure DataWarehouse.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.
• Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/Datamart tables.
• Plan, design, and implement application to migrate data from different sources like Sql server, IBM DB2 etc into Azure Blob Store or Azure Data Lake Storage.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh Datawarehouse cubes.
• Experience with running SSIS packages from teh and viewing teh SSRS reports from MVC.
• Experience developing MVC model for SSIS, SSRS ans SSAS projects run dynamically.
• Build and maintain teh external tables in Azure DataLake Storage/Azure Blob Storage to migrate data from PolyBase supported delimited text files into Azure Data Warehouse internal tables.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed Views dat are frequently required for teh application.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL .
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes and Views.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Wrote and modified stored procedures to implement teh complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Expert in developing T-SQL (DDL, DML, DCL) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues used DBCC (Database Consistency Checks) Utilities to check teh physical and logical consistency of teh database.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Performing Report testing, Performance Optimization and Verification as per internal reporting system requirements.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security and documentation.

Environment: Microsoft Visual Studio 2017,2015,2013; SSMS 2016,2014,2012,2008, SSIS, SSRS, SQL Server, XML, MS Access

Confidential, NY

SQL Server BI Developer & ETL Support

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experienced in using tools like BulkCopyProgram (BCP), BulkInsert, Data Transformation Services (DTS) and SSIS with MS SQL Server.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and have experience in incremental data loading.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spread sheet, and flat files into SQL server for further Data
• Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Derived Column, Conditional Split, Bulk Insert, Merge and Union all.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created sub reports, bar charts and matrix reports.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Performing Report testing, Performance Optimization and Verification as per internal reporting system requirements.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Worked with fine tuned SQL Queries for maximum efficiency and performance.
• Developed and executed several optimized queries in SQL.

Environment: SQL Server 2008 r2/2008, VBScript, XHTML, XML, Windows XP.

Confidential, VA

SQL Server BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Developed table reports, chart reports, line reports, parameterized reports, sub reports using SQL Server Reporting Services 2008.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Created sub reports, bar charts and matrix reports.
• Converted data types using Derived Column, Data Conversion Transformation in SSIS.
• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Fine-tuning with SQL Server Tuning Advisor and optimization of SQL queries and Stored Procedures using SQL Profiler.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Enhanced teh functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
• Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.

Environment: SQL Server 2008 R2/2008, VBScript, XHTML, XML, Windows7/XP, IIS5.0, 6.0, 7.0., Teradata Client 13.10, Business Intelligence Development Studio (BIDS)

Confidential

Jr. SQL Server Developer

Responsibilities:

• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements. Extracting teh data from teh different sources (CSV files, oracle, and MS SQL 2000) and stored teh data into teh intermediate Staging Created Dimensions with teh cube wizard and also individually.
• Refreshing teh cube to get teh latest information updated.
• Worked with Data Transformation Services (DTS).
• Generation of reports from teh cubes by connecting to Analysis server from SSRS.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for MS SQL Server 2005.
• Performing Report testing, Performance Optimization and Verification as per internal reporting system requirements.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Operations and perform teh Different required transformation in teh Staging Database and make teh data ready to load in teh Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Optimized lot of SQL blocks by analyzing teh execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Involved in creating Named calculations and named queries.
• Created Dimensions with teh cube wizard and also individually.

Environment: SQL Server 2005, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Erwin, MDX, ProClarity, MS Excel