PROFESSIONAL SUMMARY:

• More than 7 years’ experience and expertise in Database Design, ETL, Data Warehousing (DWH), and Reporting Development using MS SQL Server /2008R2, Power BI, and Tableau.
• Worked with all phases of Software Development Life Cycle (SDLC).
• Collaborated and worked with business users and development staff like business analysts, data architects, back end solutions developers, testers, DBA and application developers to understand/determine requirements for on time delivering and with scalability.
• Worked extensively with T - SQL and building OLTP/OLAP databases at conceptual, logical and physical design levels, normalizing and de-normalizing database tables for efficient relationships operation and analytic through ER diagrams and Erwin.
• Strong RDBMS concepts and experience in creating and maintaining database objects, views, stored procedures, triggers, functions, indexes, and constraints.
• Experience and understanding of architecting, designing data and analytics solutions on Snowflake Cloud Data Warehouse.
• Experience in extracting data from S3 to snowflake using snow pipe and copy in to.
• Experience in using snapshots and using streams for data loading.
• Created tasks for automation in snowsql.
• Wide experience in building static, dynamic and interactive reports; dashboards and story, report templates and formatting using BIDS and Report Builder.
• Expert in data cleansing, accuracy and completeness validation, analysis, modeling relationship and drew trend of business.
• Experienced with full development cycle of a DWH, including requirements gathering design, implementing, and maintenance.
• Experienced in ETL solutions that extract data from heterogeneous sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
• Developed configured, deployed and monitored SSIS packages for development, testing and production with parameter and environment variables and scheduled job in SQL Server Agent.
• Experienced in designing Enterprise Star-Schema, Snowflakes, and OLAP cubes.
• Experienced in migrating data from one SQL Server version to another and also working on other providers like DB2 and oracle.
• Experienced in database server performance tuning and optimization of Complex SQL queries.
• An excellent team player and technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project and diligence helping business on unleashing technological power for decision making.
• Flexible and versatile to adapt new environment, team player, flexible and work on any project.

TECHNICAL SKILLS:

RDBMS: SQL Server 2008/2008R 2/ 2012/2014/2016 , DB2,snowflake,

Database/ETL Tools: SSIS/IBM Data Stage, SSAS, SSRS,BIDS,Visual Studio data tools

Reporting: SQL Server Reporting Services (SSRS), Report Builder, Power BI, Tableau, Cognos

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

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2008, 2008R2, 2012/2014,Linux

PROFESSIONAL EXPERIENCE:

Confidential, CHICAGO, IL

SQL/BI Developer

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business.
• Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Extracted data from various sources like SQL Server, Flat files, XML and Web services from Client servers and through FTP.
• Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T-SQL and performance tuning of SQL Queries.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Created Visual Basic for Applications Tools to analyze data and interface with SQL Server to retrieve data to meet immediate and long-term financial reporting needs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on Inputs, scheduling the SSIS packages using SQL Server Agent Services.
• Used snowflake to create different objects and snowsql for automation.
• Used PowerShell for deployment to snowflake environment
• Created stored procedures using JavaScript in snowflake and created different tasks to schedule jobs.
• Worked with OLTP, OLAP, Data Warehouse application, star schema dimensions.
• Extract dataset from different data source including SQL Server, excel and flat file and prepare datasets for Power BI.
• Designed, developed and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.
• Experience in migrating SQL Server 2008 to SQL Server 2012/2014 from using linked servers and integration services.
• Designed and Developed Reports using Report Builder to easily generate reports by the user.
• Set up ETL Jobs using SSIS to run on a daily basis in SQL Server Agent.
• Configuring SSIS packages using package configuration wizard to allow Packages run on different environments.
• Created PL/SQL stored procedures, functions and packages for moving data from staging area to data mart.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created SSRS Parameterized, Drill Down, Drill Through, Sub, Chart, Dashboard and Scheduled Reports, with expressions to Calculate, Group and Filter data; some with XML data sources and custom VB.NET code.
• Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model (OLAP).

Environment: MS SQL Server 2016/2014,2012,2008 Microsoft Visual Studio 2015,2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2008.

Confidential, CLAVELAND, OH

MS SQL/ETL Developer

Responsibilities:

• Worked closely with SME’ Confidential end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer.
• Extracted data from heterogeneous sources and transformed, processed the data using SSIS.
• Scheduled jobs for SSIS packages to run monthly/weekly/daily feeds.
• 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 and various transformations
• Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column etc.
• Used TFS for source code management of developed codes/version control.
• Migrated SSIS 2012 version to 2014 and used custom created DLL for transfer files using SFTP connection.
• Debug through C# .NET code to troubleshoot production issues and created unit test methods for validation of codes developed.
• Created Alerts/log entries for successfully completed and failed jobs.
• Collaborated with network operators, application developers, engineering and DBAs to address production issues and enhance end user experience.

Environment: SQL Server 2008/ R2/2012/2014, BIDS, Visual Studio 2010/2013, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, Windows Server 2008R2

Confidential, West Chester, PA

MS SQL/BI Developer

Responsibilities:

• Worked with business users and stakeholders to gather or refine requirements.
• Deployed database objects from development/testing environment to production environment.
• Supported end users to resolve issues and assisted users on existing database applications.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly and quarterly reports.
• Checked the SQL Server is online and that still have connectivity with the front-end applications and functionality, making sure a 24/7 availability. Collaborated with multiple application owners addressing various issues.
• Monitored growth of database objects for capacity planning.
• Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012 which includes in-place, side-by-side and standalone migration.
• Successfully migrated databases from SQL Server R2/2012, SSIS packages, SSRS reports, multiple database along all database objects like stored procedures, logins (orphaned users and after migration worked with application owner to redirect\point their application to the new migrated server).
• Enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server 2012.

Environment: SQL Server 2008/ R2/2012 , BIDS, Visual Studio 2005/2008/2010 , T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, SSMS, Report Builder 2.0/3.0