SQL DEVELOPER

Bhargavi Sarvasiddy

Phone: +1-858-***-****

Email: ********.**********@*****.***

SUMMARY

Around 7 Years of experience in ETL Development, Lead activities.

Good Knowledge on Requirements Analysis, Identifying Scenarios, Test plan & design, data identification & preparation, test execution, preparation of test execution summary reports.

Good knowledge of Agile SDLC methodology, Waterfall methodology and have successfully tested application during the Waterfall to Agile transition for 1 year without any issues.

Excellent learning skills, to the fact that I have learnt all the required technologies that I have knowledge on up on the demand from the project.

Collaborated with Technical Team and Business Users to perform analysis of Business requirements and transformed them into technical requirements for ETL and Reporting tools.

Have in - depth knowledge in Data analysis, Data warehousing and ETL (Extract Transform and Load) techniques

SKILLS

Operating Systems

Windows, Linux

Languages/Technology

SQL, PL/pgSQL, T-SQL

Database

PostgreSQL, SQL Server

Development Tools

PgAdmin, DBeaver, Azure Data Studio, SSMS

Cloud

Microsoft Azure

Reporting Tool

Tableau Desktop, Power BI, SSRS

ETL Tool

SSIS, Azure Data Factory

Other:

Microsoft Office word, excel, power point, outlook

EDUCATIONAL QUALIFICATION

Completed post-graduate programme from 2008- 2011 with Specialization master’s in computer applications (MCA) In Andhra university India with 3.5

Completed Master’s in Computer Science from 2019-2020 in Southern University, Louisiana

with 3.6

WORK EXPERIENCE

Designation (Role)

Client

From

To

Location

SQL Developer / Power BI

Redbox

Jul 2020

Till Date

Oakbrook, IL

Description:

Redbox is America’s leading destination for affordable new-release movies and entertainment with more ways to watch than any other home entertainment provider. The company delivers value and convenience through unparalleled choice across content, platforms, and rental and purchase options.

Responsibilities:

As a SQL BI Developer my role is:

Worked in developing of B2B artifacts like Data flow, Mapping, Scripts and Data integration between different applications.

Providing the TRD document to the other developers.

Assisted in designing and management of SQL Server database

Schemas

Tables.

Experience in SQL, T-SQL, including stored procedures, functions, triggers, and views.

Experience with SSIS to do ETL process for extracting, cleaning, transforming and loading data into target tables.

Experience in using SSIS transformations such as

Derived Column,

Data Conversion,

Row Count

and Send Email Task etc.

Creating indexes, Constraint on the tables based on the specific conditions

Involved in design and development of multiple Power BI Dashboards and reports.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Involved in designing and creating the New Database Schema and creating the database objects like Stored Procedures and Views.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse

Policies are created using the CREATE POLICY command, altered using the ALTER POLICY command, and dropped using the DROP POLICY command.

Import and export data with many file formats such as CSV, HTML, XML, JSON, XLS, and XLSX.

Writing SQL queries such as Insert, Update, Delete, Alter, and Joins to fetch the required data from different databases to create the adhoc reports for end users.

Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Developed Complex Calculated measures using Data Analysis Expression Language (DAX).

Designation (Role)

Client

From

To

Location

SQL BI Developer/Azure

SMBC

Sumitomo Mitsui Banking Corporation

(Softmind Informatics Pvt Ltd)

Jan 2015

Jun 2018

(New York, NY)

Hyd, India

Description:

Sumitomo Mitsui Financial Group, Inc. (SMFG) is the holding company of SMBC Group, which is one of the three largest banking groups in Japan.

Responsibilities:

As a SQL Developer my role is:

Understanding the existing design using mapping documentation or through the existing code in source system that is to be migrated and to strategize the validation that is to be performed.

Understanding the level of work, analyzing the requirements and identifying the scenarios.

Using Azure Data Factory Components which compose steps to move and transform data such as

Pipelines

Activities

Datasets

Linked services

Data Flows

Integration Runtimes.

Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Created ETL/SSIS jobs both design and code to process data to target databases

Used DBeaver which is a cross platform GUI tool for testing system with the data

Developed Coding complex SQL queries.

Experience in extracting and transforming data using DTS, Import and Export Data wizard

Understanding the Architecture of PostgreSQL in Microsoft Azure and three available Deployment Model such as

Single Server

Flexible Server

Hyperscale

Created an Azure Database for PostgreSQL server in Azure portal.

Involved in migrating process from on-premise databases to Azure.

Created and schedule data-driven workflows (called pipelines) Using Azure Data Factory that can ingest data from disparate data stores.

Created a Data Factory pipeline that copies data from Azure Blob Storage to Azure Database for PostgreSQL.

Designation (Role)

Client

From

To

Location

PostgreSQL Developer

Railinc Corp.

(Softmind Informatics Pvt Ltd)

Jan 2014

Dec 2014

(Cary, NC)

Hyd, India

Description:

Freight railroads are the backbone of industry and commerce in North America. Everyday items from food and clothes to industrial materials and chemicals they travel by rail across our great land.

Responsibilities:

As a Developer my role is:

As an individual contributor I am responsible for Analyzing the production issues.

Analyzing the requirements and identifying the scenarios.

Involved in System testing and Regression testing.

Excellent knowledge of Data warehousing concepts, theories and best practices

Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

Experience with message queuing, full text indexing, and other high-performance data concepts.

Development and manage a Postgres Database using PL/pgSQL

Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements

Good knowledge of scripting on Linux

Writing ad-hoc SQL queries and Execute arbitrary SQL commands in Pgadmin

Used to debug PL/pgSQL functions in PostgreSQL

Creating a Job in pgAgent and scheduling in Dev and Test

Connected with Azure Data Studio to query, and manage Postgres databases

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.

Designed and implemented table partitioning for handling very large tables.

Involved in creating data visualizations like

Bar charts

cross tab

Tree Maps

Line charts

Scatter plot

Mapping Visualization etc. with Tableau desktop 10.3

Designation (Role)

Client

From

To

Location

SQL Developer/SQL Server

Navayuga InfoTech

Jun 2011

Dec 2013

Hyderabad, India

Description:

Navayuga Infotech is a full-service IT and Spatial technology company. It is to ensure that the clients receive the multiple benefits of world-class infrastructure, deep domain knowledge and streamlined processes combined with speed of design and implementation at the best cost.

Responsibilities:

As a Developer my role was:

Analyzing the requirements and identifying the scenarios.

Documentation of challenges and risks after every release for future reference.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Worked on formatting SSRS reports using the Global variables and expressions.

Having good expertise in data modeling a metadata service.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Understanding logical modeling and physical modeling of application

Develop ETL mappings for various Sources

.TXT

.CSV

.XML and load the data from these sources into relational tables.

Generated tableau dashboards with combination worksheets for clear understanding

Contact this candidate