Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bhavana Mettu

Summary

Over 6+ years of seasoned experience as a consultant working in MS SQL BI development and production environments with various BI tools including T-SQL, SSIS, SSAS, SSRS, Power BI, and Tableau. Designed and developed OLTPs, OLAPs as well as detailed reports within various industries such as technology, healthcare, insurance, and banking. Facilitated communication between technical teams and business stakeholders, ensuring clear understanding of financial data requirements and solutions. Conducted thorough domain analysis to understand new financial models and align data solutions with business needs. Explained complex financial data and SQL-driven insights to non-technical stakeholders, supporting informed decision-making. Pioneered the development of stored procedures, triggers, user-defined functions, and views for handling different business logic in T-SQL. Proficient in writing dynamic SQL scripts to perform bulk operations in the OLTP environment. Experience in Extracting, Transforming, and Loading (ETL) using tools like export/import data and SQL Server Integration Services (SSIS). Spearheaded a project to optimize database performance by implementing efficient table partitions, reducing query response time for large datasets.

Overview

7
7
years of professional experience

Work History

ETL Developer

United Health Care
09.2023 - Current
  • Driving and managing data integration activities to ensure that data is received, compete, accurate and available for users
  • Performing files transfers, data warehouse imports, and updates using SSIS
  • Building ETL processes using SSIS and SQL server stored procedures
  • Working on column store data warehouse system Google BigQuery, preparing PowerBI datasets
  • Creating new data warehouse solutions
  • Development of data models for Data Marts
  • Documenting data flows, data dictionaries and findings of the data analysis
  • Preparing and executing test case scenarios
  • Reviewing release instructions

Business Intelligence Developer

Amex
10.2019 - 09.2023
  • Using SSIS to migrate databases and old server environment
  • Creating ETL flows using SSIS, developing and building SSRS reports and dashboard, SQL queries implementing and modifying including stored procedures, views and functions, designing and developing stored procedures, queries and views necessary to support SSRS reports
  • Creating ad-hoc reports, deploying changes in internal web application (HTML)
  • Updating and publishing content on the company’s internal website, data conversion and configuration using Microsoft database technology (SQL Server 2014)
  • Building test plans and follow through, work on test environment, work on international projects with internal and external suppliers
  • Participating in roll-outs of projects and training events

Software Engineer

Tech Mahindra Pvt. Ltd.
Hyderabad, India
06.2017 - 09.2021
  • Company Overview: Hyderabad, India
  • Modifying the database in line with new requirements involved in production deployment activities
  • Developed simple and complex Stored Procedures, Packages and Views as per business requirement
  • Created SSIS Packages to Load the Data from source to target
  • Written few dynamic SQL queries to dynamically pass the values to the query based on the environment it runs
  • Written several queries using linked servers
  • Used the script tasks and script components in the SSIS packages
  • Created SSIS packages to load data from XML source to database
  • Modifying the SSIS packages to carry out the successful execution of new changes
  • Created SSIS packages to upload the Excel source file data into SQL Server database
  • Involved in monitoring incidents daily
  • Assigned and resolved the incidents within the SLA time
  • Hyderabad, India

Education

Bachelor of Science - Information Technology

JNTU Hyderabad
Hyderabad
06-2016

Skills

  • MS-SQL Server 2016
  • MS-SQL Server 2012
  • MS-SQL Server 2008 R2
  • MS-SQL Server 2008
  • T-SQL Programming
  • Dynamic SQL
  • ER-win
  • MS Visio
  • Power BI
  • Power Pivot
  • Tableau
  • SSIS
  • Apache NIFI
  • SSAS
  • OLAP Cubes
  • SSRS
  • Report Builder
  • BIDS
  • SSDT
  • SSMS
  • Snowflake
  • Team Foundation Server (TFS)
  • GIT
  • SharePoint 2013
  • SharePoint 2010
  • PerformancePoint Services

Timeline

ETL Developer

United Health Care
09.2023 - Current

Business Intelligence Developer

Amex
10.2019 - 09.2023

Software Engineer

Tech Mahindra Pvt. Ltd.
06.2017 - 09.2021

Bachelor of Science - Information Technology

JNTU Hyderabad
Bhavana Mettu