SUMMARY

• Overall 9 years of IT professional experience in ETL, BI (SSIS, SSRS) projects in the Financial Services, Energy Services and Healthcare domain.
• Expertise in Database Design, Analysis and Development in MS SQLBI Server 2014/2012/2008 R2, providing ETL/Business Intelligence solutions for Data warehousing Applications and creating complex reports using Microsoft BI Stack.
• Good hands - on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), OLTP, OLAP, Data Marts, Operational Data Store (ODS), Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools.
• Experience in Performance Tuning, Query Optimization of SQL queries, Performance improvement of SSIS Packages and SSRS Reports
• Experience in data migrations, transfers using Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert utilities.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expert in Transact-SQL (T-SQL). Strong technical knowledge in creating SQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, views, function, and variables.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Expertise in report generation using SQL Server Reporting Services (SSRS) from both Relational Databases and OLAP cubes.
• Experienced in creating different types of Tabular, Matrix, Drill Down, Drill Through, Parameterized, Cascaded Parameterized, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in SQL Server Development Studio (SSDT)/Business Intelligence Development Studio (BIDS).
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Strong SQL Server, VB.Net and Windows environment skills but also significant general system administration skills on UNIX, Linux and. Proficient writing VB.Net/C# scripts as well as knowledge in general systems administration tasks.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases:SQL Server,DB2
• Experience in Data Warehouse such as Relational, Dimensional, Multidimensional Modeling, Star and Snowflake schemas, Data marts, Fact and Dimension tables identification, and OLAP/OLTP.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Good Knowledge in design, development, and implementation of SQL Server Analysis Services (SSAS) reports/ cubes.
• Good Knowledge in creating new cubes and modifying existing cubes using SSAS to make data available for the decision makers.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

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

Databases: Microsoft SQL Server 2005/2008R 2/2008/2012/2014

Database Tools: SQL Server Management Studio, SQL Profiler, SQL Server Business Intelligence Development Studio (BIDS), MS Access

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS)

Automation Tools: Control-M

Others: MS Excel, Word and PowerPoint

Version Control Tools: PVCS, TFS

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Sr BI Developer/Technology Lead

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and deployed reports with Drill Down, Drill Through and Drop Down menu option and parameterized and Linked reports.
• Used multiple transformations in SSIS to meet the business requirements by extracting Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Extensively worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/ server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE's for complex queries involving multiple tables from different databases.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using SSIS 2014.
• Deployed SSIS packages and Scheduled Jobs.
• Involved in Analyzing and integrating the data.
• Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
• Writing VB.Net scripts for Script Tasks to implement the code functionality.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Ensured data integrity with good process and detected errors and misuses of data.
• Developed Incremental Load using Lookup in SSDT visual studio.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Create Parameterized SSRS Reports and ETL packages using SSiS.
• Developed various operational, drill-through and drill-down reports using SSRS 2014.
• Created Developer's Documentation and User's Manual.

Environment: Business Intelligence Development Studio, Microsoft Office Excel, C#/VB.net,.Net Framework3.0, ASP.NET,XML, MS SQL Server 2014/2012, SSIS, SSRS, Query Analyzer, SQL Profiler, Windows Server 2008 Standard,TFS and PVCS.

Confidential, Atlanta, GA

Sr. BI Developer

Responsibilities:

• Lead the team in Requirements gathering, analysis, design, coding and testing.
• Preparing BRD, FRD and TDD documents.
• Responsible for ETL operations within the Engineering groups including client feeds and Data ware house systems.
• Developed SSIS packages to extract, transform and load from various data sources to data mart and generated flat files to be sent to vendors.
• Created batch files that execute the ETL scripts which invokes SSIS packages. Scheduled and monitored batch jobs in Control M.
• Used SSIS features like Event handlers, property expressions, and package configurations, checkpoints and protection levels in the packages.
• Used various SSIS components like control flow items like for each loop, Execute SQL, Sequence Container, Data Flow transformations like OLEDB Command, conditional split, multicast, derived column, lookup, fuzzy lookup, sort, union all etc. and performed Error handling while moving the data.
• Writing SQL queries, views, triggers and other database objects as per the Design on the technical design document.
• Optimized the performance of various SQL scripts by using embedded UDFs, CTEs and System SPs.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL code.
• Developed Custom Reports, Sub Reports, Drill-down, Drill-through reports and created Standard and Data driven Subscriptions and scheduled them to be generated on predetermined time using SSRS.
• Writing C# scripts as per the design on the technical design document.
• Understand the requirements and creating Design document, Worked on change request and peer reviews, Involved in support activities & Project management activities.
• Been the SPOC for handling technical, co-ordination activities and direct discussions with clients.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of packages.
• Performed the role of ETL developer working on MS BI SSIS.
• Developed complex stored procedure with Dynamic SQL queries to fetch the data dynamically from the database.
• Creating SSIS reports using embedded OLEDB Source by calling the stored procedures from SQL server.
• Involved in production deployments and raising the change records in remedy.
• Designed and developed packages for loading from source to staging tables and from staging tables to the main tables applying different transformations.
• Writing C# scripts for Script Tasks to implement the code functionality.
• Designed the SSIS packages using several transformations to perform Data Cleansing and Data Transformations.
• Build efficient SSIS packages for processing staging and main tables with complex transforms type 1 change.
• Developed the SSIS packages by incorporating Logging.
• Interacted closely with project managers/users for the applications on a periodic basis to assess whether their expectations are being met in a satisfactory manner and address if any concerns.

Environment: SQL Server Data Tools, Microsoft Office Excel, C#/VB.net,ASP.Net 3.0, Ado.Net 3.0, C#.Net, XML, MS SQL Server 2012/2008 R2, SSIS, SSRS, Query Analyzer, SQL Profiler, DB2 10.1, Windows Server 2008 Standard,TFS and Control-M.

Confidential, Woonsocket, RI

Sr. MSBI Developer

Responsibilities:

• Lead the team in Requirement gathering, analysis, design, coding, testing and implementation.
• Preparing BRD,FRD and TDD documents
• Involved in loading the partner flat files into the SQL Server database.
• Also, developed T-SQL stored procedures/user defined functions/views to process these data inside the packages and populate them in the appropriate destination tables.
• Developed SSIS packages to extract, transform and load from various data sources to data mart and generated flat files to be sent to vendors like BCD Travel, JP Morgan, ADP etc
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Defined report layouts for formatting the report design as per the need.
• Developed effective stored procedures for the datasets, developed the RDLs, Built and deployed the report onto the Report Server.
• Writing UNIX scripts to perform encryption / decryption functionalities and SFTP set up and writing VB.Net scripts for Script Tasks to implement the code functionality.
• Support and Enhancements of all SQL Server applications.

Environment: Business Intelligence Development Studio, Microsoft Office Excel, C#/VB.net, XML, MS SQL Server 2008 R2/2005, SSIS, SSRS, Query Analyzer, SQL Profiler, DB2 9.7, Windows Server 2008 Standard,TFS and Control-M.

Confidential, Woonsocket, RI

MSBI Developer

Responsibilities:

• Used multiple transformations in SSIS to meet the business requirements by extracting Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Extensively worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/ server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE's for complex queries involving multiple tables from different databases.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using SSIS 2008.
• Deployed SSIS packages and Scheduled Jobs.
• Involved in Analyzing and integrating the data.
• Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Ensured data integrity with good process and detected errors and misuses of data.
• Developed Incremental Load using Lookup in SSDT visual studio.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Writing VB.Net scripts for Script Tasks to implement the code functionality.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and deployed reports with Drill Down, Drill Through and Drop Down menu option and parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Create Parameterized SSRS Reports and ETL packages using SSiS.
• Developed various operational, drill-through and drill-down reports using SSRS 2008.
• Created Developer's Documentation and User's Manual.

Environment: Business Intelligence Development Studio, Microsoft Office Excel, C#/VB.net,.Net Framework3.0, ASP.NET,XML, MS SQL Server 2008 R2/2005, SSIS, SSRS, Query Analyzer, SQL Profiler, Windows Server 2008 Standard,TFS and PVCS.

Confidential, Groton, CT

BI Application Analyst

Responsibilities:

• Incident handling, managing the support and operations team, resolving application outages and Performance/Infrastructure related issues.
• Co-ordination with the development team and business community for application deployment, bug fixes and enhancements, running and monitoring jobs.
• Performing backups, interaction with the customer, identifying application bugs and enhancement suggestions to the development team.
• Environment setups/upgrades, quality assurance by audits of tickets and mentoring the offshore support team.
• Provide support even in out of office hours and involved in prod deployments during the weekend as a SPOC from packaging end and fixed issues on the spot.
• Received appreciations from client managers for the continuous and dedicated support.

Environment: HP Quality Centre, Microsoft Office Excel, C#/VB.net, XML, MS SQL Server 2008 R2/2005, SSIS, SSRS, Query Analyzer, SQL Profiler, Windows Server 2008 Standard,TFS and PVCS.