Sql Server Etl Developer

Sri Sunkara

Sr. SQL Server/ETL Developer

**********@*****.***

Professional Experience

Databases & Technologies:

SQL Server (2000-2019), Oracle (10g/11g), PostgreSQL (14.0), MySQL and Sybase IQ.

Query Optimization:

Expertise in query optimization, understanding E-plan, statistics IO, table fragmentation, and indexes. Proficient in identifying slow-running queries using SQL Profiler, DMV & DMF. Strong knowledge of SQL Server Internals (Relational Engine, Storage Engine, Buffer Pool).

Programming & Development:

Advanced skills in Transact-SQL, Stored Procedures, Functions, Views, CTEs, Triggers, SQL Window Functions and Dynamic SQL.

Data Migration Projects:

oMigrated data across platforms: SQL Server to Salesforce, Oracle to SQL Server, and SQL Server to Snowflake.

oMigrated data from PostgreSQL to SQL Server and Snowflake using tools such as DBAmp, DBT, and Fivetran.

oMigrated data from CSV files to Snowflake using Snowpipe.

oConverted SSIS ETL packages to Snowflake procedures and functions.

ETL & SSIS Development:

Extensive experience in designing, developing, testing, and deploying SSIS packages. Proficient in data movement from sources like CSV, XML and JSON into ODS database.

Data Warehousing & Data Modeling:

Designed Data Marts using Star & Snowflake schemas. Developed conceptual, logical, and physical data models, and managed data loads through SSIS packages and stored procedures.

Data Analysis & Cleansing:

Hands-on experience in Data Analysis, Modeling, Mapping, Cleansing, and Transformation. Skilled in creating DFDs, flowcharts, and maintaining thorough documentation.

Master Data Management (MDM):

Experience in installation, configuration, and maintenance of SQL Server 2016/2019 MDM solutions.

Cloud & Modern Data Platforms:

oCompleted POC for converting SSIS packages to Azure Data Factory.

oSnowflake SNOWPRO Certified Professional with hands-on experience in Snowflake Editions, Security Model, Virtual Warehouses, and data import/export.

oProficient in Snowflake cloud platform, including Snowpipe for data ingestion.

oPython (Numpy, Pandas), PySpark, Azure Data Factory (ADF) and Databricks.

Software Development Lifecycle (SDLC) & Methodologies:

Experienced in SDLC, Agile methodologies, and tools such as JIRA, TFS, DevOps (Repos, GitHub), and ServiceNow (SNOW).

Education:

Master of Computer Application (MCA)

Certifications:

Snowflake SNOWPRO Certification

Microsoft Certified Technology Specialist (MCTS)

Professional Experience:

Nutrisystem, Fort Washington, PA

Sr. Database Developer July 2023 – March 2025

Nutrisystem is a weight loss company that provides meal delivery services for people looking to lose weight and manage their health. Below are some of the main tasks I worked on.

Maintained and optimized SSIS ETL packages for data extraction and transfer between PostgreSQL and SQL Server, processing new customers, online and call-center orders, payments, and other transactional data.

Developed SQL queries, stored procedures and views to support application requirements. Enhanced database performance through indexing, partitioning, and query optimization techniques.

Monitored and troubleshoot daily order processing to ensure efficiency and accuracy.

Participated in ETL migration from SQL Server to Snowflake. Converted the SSIS Fact Order package using stored procedures, functions, CTEs, and temporary tables in Snowflake.

Designed and developed ETL processes to extract data from the MAS 500 database and generate Warehouse Shipment Order (EDI 940), Shipment Confirmation (EDI 945), Warehouse Stock Transfer Shipment Advice (EDI 943), and additional documents (e.g., 855, 860, 204) in CSV format for SEEBURGER integration.

Developed reports using SSRS, including: Inventory Valuation List, EZPay, Five9 call center data, Hourly Sales (orders placed by customers), OMS Dashboard

Technologies: SQL Server, PostgreSQL, SEEBURGER, Sage MAS 500, Epicor, Snowflake, Amazon S3, Microsoft Power Automate, SSRS, Oracle Integration Cloud (OIC), Python, Jupyter.

Integraconnect, West Palm Beach, FL

Sr. Software Engineer Sep 2021 – June 2023

Integra Connect is “A value-based precision medicine company”. With advanced predictive analytics, Integra Connect can help providers identify at-risk patients, understand opportunities to optimize quality and cost performance, and drive better treatment decisions for better outcomes.

Part of a development team. Daily work involves implementing a new functionality or upgrading existing functionality. These new changes involves either to create a new stored procedure or modify the existing procedure, add/modify/delete objects in Tabular Model or changes in Power Bi Dashboard.

Part of Data Migration Team: We are in a process of moving data from Azure database to Snowflake. The reason for this to improve the stored procedure run time. We are in a process of converting stored procedure code into DBT (Data Build Tool).

Technologies: SQL Server Azure DB, SSAS (tabular), Power Bi, Snowflake, DBT, JSON, PYTHON.

Toll Brothers, Horsham, PA

Sr. Database Engineer Aug 2015 – Aug 2021

Toll Brothers is a FORTUNE 500 company and nation’s leading builder of luxury homes. This company is listed in NYSE and has operations in 24 states across the country.

●Using SSIS and stored procedures Transform data from various source systems like Product Catalogue, PIVOTAL, BuildPro and Kronos and load into Operational Data Source (ODS).

●Migrated marketing data from SQL Server (PIVOTAL) to Salesforce CRM (Lead, Opportunity, Contact etc.) using DBAmp tool. The task includes installing and configuring DBAmp and SQL Server (set up Salesforce Linked Server). Some of the procedures and SQL statement used for DML operations are SF_BulkOps, SF_ReplicateAll, SF_Replicate and OPENQUERY.

Technologies: SQL Server 2012/2016/2019, Transact-SQL, SSIS, SSRS, Azure Data Factory, Databricks, MDM, XML, JSON, PYTHON, Red-Gate Tools, Pragmatic Works, Task Factory, CozyRoc, Salesforce, Oracle Enterprise One, TFS, SNOW, DevOps, GitHub, Kronos, PIVOTAL, BuildPro, MS-VISIO and ERD.

State Street, Princeton, NJ

Sr. SQL Server/SSIS/SSAS/ Consultant April 2015 – Aug 2015

Worked as a contractor Working in Straight through processing business intelligent (STPBI) Reporting Tool, which is designed in Microsoft SQL Server Analysis Services. I am involved in design, process and weekly maintenance of FSCO & STPBI cubes.

Technologies: SQL Server 2008R2, Transact-SQL, SSIS, SSAS, MS-VISIO, Win 2008 Server.

Bank of America, Pennington NJ

Sr. SQL/SSIS Developer Aug 2013 – Feb 2015

I was involved in two major tasks: 1. Data Migration 2. Understanding and improve the performance of Award Choice Financial Report/Option Navigator (ACFR/ON) application.

Technologies used: SQL Server 2008R2, SSIS, MSDTC, MSMQ, T-SQL, MS-VISIO, Win 2008 Server.

International SOS, Trevose, PA.

Sr. SQL/BI Developer May 2011 – Aug 2013

International SOS is a global medical and security services company that provides assistance and support to organizations and individuals traveling or operating abroad. Their services focus on helping clients manage health and security risks while traveling, particularly in remote or high-risk areas.

Technologies used: SQL Server 2008 R2, Transact-SQL, Stored Producers, Functions, Triggers, SSIS and SSRS, MSDTC, MSMQ, MSMS-Visio, Erwin7.2, ERD, JIRA, Win 2008 Server.

Claritas, Arlington, VA

Software Engineer-II Jun 2007 – April 2011

Claritas uses advanced analytics to break down a customer base into specific segments based on various factors like demographics, purchasing behavior, location, and lifestyle.

Technologies used: SQL Server 2000/2005, Oracle, Sybase IQ, MySQL, Transact-SQL, Stored Producers, Functions, Triggers, .Net, Java Script, MS-Visio, ERD.

Contact this candidate