SRAVYA VANGALA

ETL DEVELOPER

MOBILE: +1-678-***-****

E-MAIL: ad0w1f@r.postjobfree.com

Executive Summary

9+ years of experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, managing indexes, Transact-SQL (DDL/DML) queries and locks, troubleshooting deadlocks.

Work with domain experts, engineers, and other data scientists to develop, implement, and improve existing systems.

Understanding of SnowFlake cloud technology.

Used DBT to mitigate SnowFlake queries into multiple models and macros that can be tested separately.

Used DBT to test the data such as Schema tests, referential integrity tests, custom tests and ensure data quality.

Good knowledge of Relational Database Management Systems like SQL Server and ORACLE.

Expert in implementing SSIS and SSRS using Microsoft Business Intelligent development studio (MSBI), SQL Server data tools (SSDT) and power BI.

Strong knowledge on Power BI to import data from various sources such as SQL Server, MS Excel etc.

Experience in writing complex SQL queries involving multiple tables, inner/outer joins, creating packages, Jobs and Sending Alerts using SQL Mail.

Well versed in SSIS development and warehouse environments.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Experience with various tasks such as Execute SQL task, for each loop container, Data Flow task, File System and transformations such as Aggregate, Lookup, Merge Join, multicast, conditional split, derived column.

Implemented checkpoints at package level.

Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.

Expert in creating, configuring and fine-tuning ETL workflows designed in MS SQL Server Integration Services.

Experience in designing and developing large number of enterprise reports (SSRS) using the data from ETL loads, various heterogeneous data sources.

Experience in Drill-down, Drill-through And Cascading reports using SSRS.

Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS (2008R2/2008/2005).

Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView and designed and developed data models and backend queries for presenting data.

Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.

Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.

Experience in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts.

Can do Attitude and ability in effectively communicating with all levels of the organization such as Management, technical and customers.

Quick learner, exceptional problem solving and troubleshooting capabilities.

Excellent analytical, problem solving and interpersonal skills. A good team player with excellent technical, communication and interpersonal skills and capable of taking up responsibilities independently and collaboratively in teams

Motivated and determined to deliver productive high quality, complete deliverables within deadlines with minimal supervision.

Technical Skills

Database Tools

SSDT 2012/2008 R2/2008/2005, Management Studio, Visual Studio,

Informatica 9.6, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, Upgrade Wizard, Replication.

Programming languages

SQL, T-SQL, PL/SQL, VB.NET, C#, HTML, CSS, Java Script, C

Environments:

Scripting

Snowflake cloud Data warehouse, DBT(data build tool), python

PHP, JavaScript, CSS, VBScript, HTML and XML.

Operating systems

Windows NT/2000/XP/2003/Vista/Windows 7/8 and Unix.

Reporting Tools

SSRS, Report Builder, Power BI.

Other

Microsoft Office, Visio, Dream viewer, Team Foundation Server (TFS).

Education:

Bachelor of Technology from Jawaharlal Nehru Technological University (Hyderabad)

Professional Experience

Organization: Trellance

Mar 2020 to till date

Role: Data Engineer

Description:

At Trellance, As a Data Engineer I involved in building data warehouse with DBT (data build tool) and migration of SSIS to Snowflake to DBT and support that for different credit unions.

Responsibilities:

Hands-on experience with Snowflake utilities, Snowflake SQL, DBT etc.

I generated Synthetic data for different models for a client demo by using Fake, Pandas, numpy libraries etc.

I did participate in migrating SSIS to Python to improve performance in XML files ingestion.

I was worked with Data scientist team to add their Data preparation scripts into DBT.

I did work with clients directly to enhance the connector based on their requirements.

I worked creating Batch scripts as part of automating the connector.

Developed power BI reports and dashboards from multiple data sources using blending.

Experienced in optimization of database code designing batch processing and query tuning

Analyzed applications and proposals for issues with data integrity

Provided application production support

Designed implemented and maintained physical and business data mapping

Created accurate and efficient solutions for data warehousing

Troubleshooting issued related to SQL server

Designed SSIS for data warehousing environment and automation of batch cycle

PricewaterhouseCoopers LLP (Tampa, FL) May 2016 to Dec 2018

Role: Report Analyst

Description:

At PWC, I worked as PL/SQL developer in PeopleSoft to develop complex queries for reporting and as ETL developer participate in data warehouse project. We built warehouse with PeopleSoft data through Informatica.

Responsibilities:

Involved in the requirements definition and analysis in support of Data Warehousing efforts.

Expert in performing T-SQL DDL/DML/DCL commands using SSMS.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views

Handled errors using exception handling extensively for the ease of debugging and displaying error messages.

Maintained the table performance by handling the tuning tips like normalization, creating clustered and non-clustered indexes

Involved in writing complex SQL scripts which includes Transact statements, database object validation and exception handling.

Used cursors and cursors with dynamic sql for fetching and processing it

Developed custom reports and deployed them on server using Power BI.

Generated ad-hoc reports excel power pivot and shared them using Power BI to decision makers for strategic planning.

Utilized power query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data messaging.

Perform development of ETL application, including ensuring that system and integration test plans are developed and executed

Develop and manage processes, tools and workflows involving data moving

Provide technical consultation and support in the development of ETL applications and programs for data warehousing class of system

Experience in creating Ad-hoc reports, data driven subscription reports

Got experience in writing Unix commands.

Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.

Created SSIS packages with T-SQL and PL/SQL Procedures/Functions to build business rules to load data.

Created and ran various tasks like Sessions, command, Email & Workflows to load the data into the Data warehouse components.

Developed and documented data Mappings/Transformations and Sessions.

Environment: Informatica - Power Center9.5/9.1, Oracle 9i, AbInitio, MS SQL Server, SQL, PL/SQL, UNIX Shell Script, SQL*Loader, Qlik, Windows 2000.

Ditech Financial, LLC (Minneapolis, MS) Oct 2015-April 2016

Role: SQL ETL Developer

Description:

Ditech is an American financial organization. As a SQL ETL developer, I am working on multiple interfaces that flows data from different servers and apply transformation in between according to business rules.

Responsibilities:

Creating multiple interfaces that flows data through different servers

Involved in Deploying projects in SSIS catalog and creating jobs with deployed projects

Gathering requirements from clients and prepared design document by using Visio based on requirements

Working with different types of sources like Oracle,Db2 and Flat file in remote location

Developed mappings that perform Extraction, Transformations and load of source data into various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored procedures, SQL, Normalizer and update strategy to meet business requirement.

Reusable transformations and Mapplets are built wherever redundancy is needed.

Working with different types of transformations like Merge, merge-Join, for-each loop container.

working on one time load and incremental loads

Used SSIS as ETL tool for Extract, Transform and Load operations.

Designed SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Worked with different methods of logging is SSIS.

Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.

Involved in Performance tuning of ETL transformations, data validations and stored procedures.

Involved in designing front-end pages using C# code.

Involved in requirement gathering, analysis, design, development, change management, deployment and user training.

Optimized query performance by creating indexes. Optimized stored procedures for performance tuning.

Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2012.

Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.

Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures.

Provided support to the application developers on the application databases.

Configured and deployed different reports in the Servers using SQL Server 2008 Reporting Services.

Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Creating Stored Procedures for reports generation.

Responsible for log backups and restoration.

Environment: MS SQL Server 2012, Windows 7, Enterprise Manager, Informatica power center9.5/9.1,orale 9i, UNIX shell script, Management Studio(SSMS), Integration Services, BIDS, SSRS, OLAP, Data Modeling, T-SQL, C#.Net, Windows 7, Tuning Advisor, ETL, SQL Profiler, SQL Server Agent, Data ware Housing, BCP, and Visual Basic 6.0, Crystal Report9.0, MS Access.

Client: Microsoft (Hyderabad, INDIA) May 2013 – March2015

Role: SQL Server Developer.

Description:

MSL is an application that Microsoft uses to track large volumes of sales to both end customers and re-sellers. It is design primarily for use in the Volume Licensing space. The primary product sold through MSL is not a physical box set with DVD’s and Manual’s – it is a license, is simply the right to use a piece of software on one computer. MSL allows two types of users ROC and CP.ROC super user who can perform any action on Agreements or PO or POLI or SOLI. CP on the other hand can process the PO and POLI and he cannot submit the order.

Roles/Responsibilities:-

Gathered functional, business, and technical requirements and prepared the requirement documents.

Wrote Stored Procedures and SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures.

Involved in NQR10, FQR 10, MQR10, NQR11 and MQR11 Releases – QuoteToOrder.

Responsible for Bug Fixing in the area of Identification Rule and Order processing.

Used Team Foundation Server 2008 for Source Code Control, project sharing and team collaboration.

Involved in the migration of databases from Sql server 2008 R2 to 2012.

Developed database stored procedures, functions, views and merge statement

Responsible for data validation.

Involved in Daily status call to update the progress.

Involved in Development and testing of the application in all the phases.

Worked in .Net for front-end applications.

Worked in C# for Script task

Responsible for DB Automation process.

Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, PDF and CSV files.

Analyzed the existing application programs and tuned SQL queries using Execution planned SQL Profiler.

Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning

Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.

Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.

Designed and implemented stored procedures and triggers for automating tasks.

Tested applications for performance, data integrity and validation issues.

Environment: SQL server-2008, T-SQL,SSIS, SQL Jobs, SSMS,SSIS XML, Windows 7, C#.Net, ASP.NET,.

Client: IMedX Medical Transcription (Hyderabad, INDIA) Dec 2010–Dec2012

MS SQL Server Developer

Description:

IMedX is a medical transcription company, which receives number of transcriptions from different doctors, hospitals. IMedX needed complex reports from the data received.

Responsibilities:

Installed and Configured SQL Server 2008R2.

Transformed data from various data sources such as Excel and text files.

Developed Stored Procedures, views, indexes, objects and Functions.

Developed queries and macros for reporting purposes.

Developed modules to export the data to excel for creating Charts and Graphs.

Expert in all aspects of MS Access (tables, queries, forms, reports, modules, macros, security) including database design, developing, testing and documentation.

Strong reporting experience using Excel, Access.

Optimized long running stored procedures and queries for effective data retrieval.

Managed the security of the servers, as a part of Junior DBA administration duties.

Experienced in evaluating and modifying tables, queries, and reports as per requirement.

Extensive experience in analyzing data of relational database designs.

Optimized queries by creating indexes.

Environment: SQL Server 8.0/2008R2, C#.Net, ASP.NET, MS Access, MS EXCEL, T-SQL, Windows 2008 server.

Contact this candidate