SUMMARY

• Over 9+ years of IT experience as a Data Ware housing and ETL/ELT Developer in various Industry verticals like Retail, Logistics and Aviation.
• Experience in working on data ware house with MPP architecture.
• Experienced in loading data and performing ETL in Cloud data warehouse like Snowflake and AWS Redshift.
• Experience in Microsoft APS (data warehouse) to load huge data and performing ETLs using Stored Procedure.
• Experience in developing the applications using T - SQL Programming (DDL and DML).
• Expertise in distributing the table data in various nodes using replicated or distributed key
• Experience in performance tuning, query optimization and maintaining and optimizing a data warehouse
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Extensive experience in MS SQL Server 2016/2014/2012/2008 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Comfortable interacting with senior management, project teams, business users and product vendors.
• Comfortable working Agile method of development and SDLC (waterfall) method of development.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, PDW, Excel and MS Access CSV, Oracle, flat file.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Strong Knowledge on TFS version control.
• Comfortable interacting with senior management, project teams, business users and product vendors.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor
• Expertise in database optimization on fine tuning the stored procedures and SQL queries
• Expert in scheduling and managing jobs using Control-M tool.

TECHNICAL SKILLS

Programming Languages: T-SQL, PostgreSQL

Microsoft Technologies: MS APS, MS Sql server, SSIS, SSRS databases: SQL Server 2016/2014/2012/2008 , mysql, MS Access

Dash boarding / Analytics: SSRS, Power BI

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Other Tools: MS Office 2007/2010, MS Visual Studio 2012/2015

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. SQL Server/ETL Developer

Responsibilities:

• Working on Microsoft Parallel Data Warehouse/MPP (APS 2015), Business Intelligence, Data Warehousing, ETL/ELT, Data Migration, Production support.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS 2015/2014/2013 ).
• Expert in scheduling and managing jobs using Control-M tool. Handling 1200 plus production jobs and set up automated notification and logging.
• Develop SSIS package templates to efficiently load big data files of billion rows.
• Exceptional skills in Agile Development and Test-Driven Development.
• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
• Proficient in Selecting the distribution columns, determine indexing, partitioning strategies, performance tuning.
• Managing source code in Microsoft Team Foundation Server (TFS), loading data using Dwloader, BCP and SSIS.
• Production Automation: Designed ETL/ELT process for periodic automated loads (Loading files into APS tables), including FTP/SFTP file transfer to/from SQL Server to Unix.
• Created various database objects such as tables, indexes and views based on the requirements.
• Developed SSIS packages with monitoring features and custom logging, loading audit information and execution results into audit tables.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Analyzing the requirements and creating technical design documents.
• Analyzing different interfaces, metadata, data dictionary and architecture.
• Created multiple master packages to handle the ETL flow with different check points.
• Load data from different sources like flat files, SQL server, CSV and Excel.

Environment: SQL Server Management Studio, SQL Server 2014/2016, MS APS 2014/2016, SQL Server Integration Services (SSIS), Control M 7/9, TFS, Windows 10

Confidential, Louisville, KT

ETL/BI developer

Responsibilities:

• Created and modified SSIS package for integration of new data source in existing application.
• Interacted with customer and analyzed requirement, created design and implemented.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS 2012).
• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data load and transformations.
• Worked on Indexing of columns for faster loads.
• Managing source code in Microsoft Team Foundation Server (TFS).
• Created various database objects such as tables, indexes and views based on the requirements.
• Created new SSRS report as enhancement for reporting dashboard.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Analyzing the requirements and creating technical design documents.
• Scheduled new jobs in Sql server agent and supported production jobs.

Environment: SQL Server Management Studio, SSIS 2012, SSRS 2012, TFS.

Confidential, Oldsmar, FL

ETL/Sql Server developer

Responsibilities:

• Interacted with client during requirement gathering phase and created a high-level design document based on that.
• Worked on database design including determining key relationships and necessary constraints.
• Developed SSIS packages to load files from various sources such flat files, sql server and ms excel. deploying the SSIS Packages from development server to production server.
• Wrote store procedures, functions, triggers and views as per requirements.
• Created jobs in sql server agent for daily load of files.
• Provided production support during initial post deployment period and worked with production support team for handover.

Environment: SQL Server Management Studio, SSIS 2012, SSRS 2012, SVN Tortoise.

Confidential

ETL/Sql Server developer

Responsibilities:

• Worked on second phase of the application which required adding additional workflow.
• Modified high level design and database design to accommodate the new requirements.
• Created new tables and views, additional ASP.NET pages with C#.
• Created a Data ware house with dimensional model.
• Created SSIS packages to load dimensions and facts tables using concepts of slowly changing dimension -1 and slowly changing dimension 2.
• Was responsible for deployment, testing and documentation of SSIS packages and data ware house.

Environment: SQL Server Management Studio, BIDS 2008, SQL server 2008, IIS, ASP.NET, C#.