SUMMARY:

• Around 8 years of extensive experience in Database Design, Development and Implementation of Client - Server Applications & Database systems using MSBI 2012/2008/2005 in different environments.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using different transformations.
• Expertise in using different transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for 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) ( 2012/2008/2005 ).
• Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports and Charts using SSRS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Generated reports using Global Variables, Expressions and Functions using SSRS 2012/2008, also creating reports in SSRS and Crystal reports.
• Strong knowledge in Strand Snow-flake schemas and OLAP modeling which involved in creating data source views with added measures, dimensions in SSAS
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS) and Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Worked on creation and deployment of cubes on SSAS for data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Test & Deploy code across various SDLC Environments like TEST,UA/UT/Production

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning, Dynamic Management Views and Functions

RDBMS: MS SQL Server 2005/2008/2012 , MS Access

Productivity Applications: MS Word, MS Excel, MS Access, MS Project

ETL: SQL Server Integration services

Programming Languages: C, C++, C#, .NET, SQL, TSQL, PL/SQL

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Windows 8

DBA Tools: Import/Export, SQL Loader, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, Service Broker

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. MSBI Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in the DTS to SSIS Migration Project
• Created the Proof of Concept for the Migration Project
• Design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Performed ETL Auditing to maintain Loads report
• Used complex transactions and Validations to make sure the data is correctly loaded into the warehouse
• Used Configuration files to deploy and install a package from one environment to another.
• Used log providers to log error into the table and send the reports to the concerned department.
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Made the SSIS packages dynamic by passing the input from configuration files.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Suggested best practices in migrating DTS to SSIS
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Wrote Stored Procedures / Transact-SQL scripts as per the business need.
• Involved in monitoring database maintenance plans for checking database integrity, data optimization, Rebuilding indexes and updating statistics.
• Created and modified complex TSQL batches / stored procedures.
• Involved in creating new Stored Procedures and Optimizing existing queries and Stored Procedures.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2012 in Business Intelligence Development Studio (BIDS)
• Involved in development, enhancement, testing and performance tuning of the application.

Environment: MS SQL Server 2012/2014, Integration Services (SSIS), Reporting Services (SSRS), MS Visual Studio 2012, SQL Server Management Studio, MS Excel and Windows 7.

Confidential, New York city, NY

Sr. MSBI Developer (SSIS/SSRS)

Responsibilities:

• Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Installed SQL Server 2008/2012 on development and production servers setting up databases, users, roles and permissions.
• Integrated Database Maintenance jobs to perform Full, Differential and transaction log Backups and scheduled them with SQL Server agent job scheduler.
• Upgraded all SQL Server 2008 to SQL Server 2012 without any service interruption.
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, Views, Indexes, User Defined Functions, Stored Procedures in SQL Server 2012/2008.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012/2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor
• Used sever Transformations in the SSIS packages for the data transformation from the OLTP to OLAP.
• Explicitly used Execute SQL Task, Script task, Derived Columns, Condition split, aggregate, lookup, Merge join etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drilldown and drill through reports from multi-dimensional objects like star schema and snowflake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database.

Environment: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Juno Beach, FL

MSBI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Experience in SSIS package design, development and deployment..
• Expertise in using different transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
• Configure SSIS Package for run time Parameters and Configuration file.
• Developed some scripts and used in ETL Process that works as transformation
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Created packages in SSIS with error handling.
• Scheduled tasks to run every day to update changes in the base tables
• Writing complex stored procedures to meet the business requirements.
• Created new database objects like Stored Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment on SQL Server 2008.
• Created matrix and tabular reports with drilldown, drill through and dropdown menu option using SSRS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Designed and developed various types of reports using SSRS
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008
• Excellent ability in writing specification and gathering from the user to developed crystal report as per the client and maintained documentation of the reports.
• Created custom formulas to display RGB colors in crystal reports.
• Experience in developing ASP.Net web application with Crystal reports using C#.
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Experience in working with data warehouses and Microsoft OLAP Analytics Services.
• Created automatically drill down report from summary data which is managed by the OLAP server to data warehouse relational database.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Scheduled .dtsx packages execution to load data into Fact Tables using SQL Server Agent
• Created complex Stored Procedures, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Rebuilding indexes on various tables.

Environment: SQL Server 2005/2008/2008 R2/2012, Visual Studio 2010/2013, MS Office 2010.

Confidential, Hartford, CT

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2005.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Windows 2008 Advance Server, MS Excel, and MS Office.

Confidential, Albany, NY

SQL Developer (SSIS/SSRS)

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions for various Batch and reporting purposes
• Helped the front end application developers with their queries.
• Creating SSIS packages for Extraction, Transformation and Loading operations.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems like Oracle, Flat files, Excel into databases for Dashboard Reporting on a daily basis
• Experience in SSIS package design, development and deployment.
• Expertise in using different transformations provided by SSIS such as script component, LookUP, Data Conversion many more to transform the data before loading into the destination.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Populated Data Warehouse using SSIS Packages and implemented Kimball methodology. Implemented Type I, II, III changes in Slowing Changing Dimension (SCD) Tables.
• Involved in usage of various SSIS components like For loop, Foreachloop, Fuzzy Lookup, Variables, Error Handling etc
• Experience in Writing Complex SSIS Process across heterogeneous sources like Oracle, SQL, DB2,FlatFile, Excel
• Used C# in SSIS for Script Component.
• Created Several Dash Boards using Performance Point Server
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Created complex Stored Procedures, cursors, tables, views and other SQL joins and statements for applications by using T-SQL

Environment: SQL Server 20 (2003, 64-bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, T-SQL, MS-Access, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, ERWIN.

Confidential, Pittsburgh, PA

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Writing code for database Access, Modifications, and Constructions including schemas, SSIS and stored procedures
• Responsible for developing, maintaining and supporting SQL applications and supporting Java and .NET developers
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Gathers and analyzes requirements and Programs all or selected components of SQL applications.
• Documents components and applications.
• Researches, Evaluates and Recommends new tools and applications for use in assigned responsibilities
• Independently writes and reviews design specifications, code, and unit tests
• Troubleshoots and resolves medium to high complexity application defects and Solves a range of problems
• Analyzes possible solutions using standard procedures
• Receives a moderate level of guidance and direction
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Made the SSIS packages dynamic by passing the input from configuration files.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Suggested best practices in migrating DTS to SSIS.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Wrote Stored Procedures / Transact-SQL scripts as per the business need.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008

Environment: MS SQL Server 2017/2016/2014/2012/2008 R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), JIRA, MS-Excel, Windows 7