SUMMARY

• IT professional with 8 years of experience in Data Warehousing and Business Intelligence applications design, using MS SQL Servers 2017, 2016,2014, 2012, 2008r2.
• Solid expertise in Database Design, Administration, Implementation and Application Development.
• Solid hands - on skills in migration/upgrading of SQL Server 2008R2 to 2012.
• Extensive experience in Data Modelling, Design, Development, Implementation & Administration of Database systems using MSSQL 2008R 2/2012/2014/2017 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).
• Experience in database design and development using Microsoft SQL Azure.
• Extensive knowledge using PowerShell for different tasks.
• Experience in Dimensional Modelling, ER Modelling, Star Schema / Snowflake Schema.
• Monitored and tuned SQL Server performance using System Monitor, SQL Profiler, Query Execution Plans and checking the consistency of database using DBCC Utilities.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL.
• Excellent knowledge working with TFS and to track the user stories, features and Epics in TFS.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2014/2016/2017

ETL Tools: SQL Server Integration Service (SSIS), VS 2013, 2015,2017

Visualization Tools: SSRS. Power BI

Programming: T-SQL, VB.Net, HTML, CSS, C#

Source Control Tools: Team Foundation Server (TFS)

Data Modelling Tools: Erwin Data Modeler ER/Studio. Oracle SQL developer’s data modeler, MS Visio

Software Project Management Tools: Jira

Other Tools: MS Office Suite (Word, Excel, Power Point) MS Outlook, applications and file management systems

PROFESSIONAL EXPERIENCE

SQL/SSIS/SSRS/T-SQL Developer

Confidential - Philadelphia, PA

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working knowledge with DMExpress ETL tool to filter data based on end requirements.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2018.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.
• Also, went through query execution plans, sql profilers and did query optimization.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2008/2012/2014 , TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

SQL/SSIS/SSRS Developer

Confidential - Detroit, MI

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 as SSIS Project Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Worked in the entire phase from requirements gathering to post-deployment support in an agile environment.
• Participate in Scrum of Scrums to ensure cross team collaboration, Coordinate and manage code releases.
• Engage with other Scrum Masters to increase the effectiveness of the Scrum in the organization
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Followed the Agile methodology and maintained the backlog.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Handled Tableau admin activities granting access, managing extracts and Installations
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases extensively
• Worked on Database Compression for different databases to save space across different environments.
• Used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Environment: Windows 2008 Advanced Server, ODBC, MS SQL Server 2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008/2010, SharePoint 2007/2010, Lotus Notes, Oracle, SSRS, SSIS, Erwin, Agile.

SQL Server BI Developer

Confidential - New York, NY

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2012/2014
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created adhoc reports using Import and Export Wizard.
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Pulled the data from multiple database sources such as UDB/DB2/Teradata/Sybase and flat file sources that includes CSV, Excel, and Mainframe (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer Representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS)
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs and chart.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008/2012, SSIS/SSRS 2008/2012/2014 T-SQL, Visual Studio 2008/2010, .NET Framework, SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

SQL/SSIS Developer 

Confidential - Merrimack, NH

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• 2Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Worked on T-SQL Queries, Stored procedures to fetch complex data from different tables.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created logical and physical database design, data structures and maintained it by writing user defined functions, views, T-SQL scripts.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Worked with DBA team on Database Compression for different databases to save space across different environments.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2008/2012 Enterprise Edition, ODBC, BIDS, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.