Summary
Overview
Work History
Education
Skills
Certification
Technicalskillset
Technicalskillsummary
Timeline
Generic

Varsha Annangi

Farmers Branch,TX

Summary

An analyst with more than 8+ years of experience in supporting and delivering the analytic needs of clients by applying education, creativity, knowledge, and positive attitude, versatile Team player eager to contribute analytic skills to a progressive organization providing opportunities for growth in exchange for superior performance. Strong background in designing, developing, and publishing visually rich and intuitive dashboards for data-driven decision making. Strong data acquisition skills from various data sources and developing data systems that support analytics and reporting. Excellent knowledge of data management policies, procedures, and various tools. Accomplished communicator skilled in building cross-functional relationships to drive desired business outcomes.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr. SQL BI Developer

DTCC
01.2023 - Current
  • Worked on Snowflake Database, Schema, and Table Structure
  • Built data visualization Dashboards and Reports using Microsoft Power BI
  • Used Power Query to clean, Shape, transform, and model data to meet business requirements for reporting
  • Maintained existing database and BI Systems
  • Created paginated reports using Power BI Report Builder for on-premises and cloud data sources
  • Create reports for client management using Microsoft SQL Server Reporting Services (SSRS), deployed them to internal portals, and migrated reports from Crystal Reports to Power BI
  • Worked on migrating the database from legacy data source to Snowflake and developed Snowflake procedures for executing branching and looping
  • Highly skilled at configuring OBIEE metadata objects including repository variables interactive dashboards and reports
  • Performed GAP analysis between existing and TO-BE business process modules to understand additional functionalities required for FHIR, EDI, EMR, EHR standards
  • Utilize Power BI features such as Power Pivot/View to design scorecards, dashboards, and data visualization for different departments and upper-level management
  • Hands-on Experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps Portal and Common Data Services
  • Excellent T-SQL Development skills to write complex queries involving multiple tables, Stored Procedures, Triggers
  • Worked on the building, and deploying of the service fabric applications
  • Worked as a Power BI Administrator as administrator configured usage metrics, audit logs, Tenant settings, Dashboard settings, Power Apps, and Premium capacity settings
  • Developed the database triggers and stored procedure using T-SQL
  • Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, CloudWatch, SNS, SES, SQS, Lambda, EMR and other services of the AWS family
  • Worked on migrating the data using ETL process in AWS Glue from external sources like S3, andParquet files into AWS RedShift
  • Expertise in Data Extraction, Transforming, and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS)
  • Working on a quality Center for creating and documenting Test Plans and Test Cases and registering the expected results
  • Used HL7 V2 for data exchange,EHR and FHIR with XML Language and customer information
  • Experience assessing testing process, creating and implanting testing strategies in UAT phase
  • Ingested data from disparate data sources using a combination of SQL Google Analytics API, and Salesforce API using Python to create data views to be used in BI tools like Tableau
  • Worked on Informatica Power Center tools designer , repository manager, workflow manager, and workflow monitor
  • Experience with event-driven and scheduled AWS Custom Lambda (Python) functions to trigger various AWS resources
  • Data Extraction, aggregation and consolidation of data with AWS Glue using Pyspark
  • Responsible for developing support and maintenance for the ETL (Extract, Transform and Load) process using Informatica Power Center
  • Implemented a CI/CD pipelines with Docker, Jenkins, Team foundation server and GitHub automatically attempts to build a new Docker container from it
  • Involved In Writing the Python Scripts for extracting the data from JSON and XML Files
  • Utilize Power Query in Power BI for data cleansing and implement DAX functions for efficient data visualization
  • Work on advanced performance tuning, optimizing SQL queries, and building indexes
  • Experienced in Power BI Workspace roles and access
  • Publishing reports via apps and report-sharing methodologies
  • Created Row-level security (RLS) and integrated with thePower BI service portal
  • Implement Power BI gateway for different sources and model for Power Pivot and Power View
  • Create and manage schema objects such as tables, views, indexes, stored procedures, and triggers, and maintain referential integrity.

Sr. SQL BI Developer

AT&T
01.2021 - 12.2023
  • Exhibited expertise in data warehousing and business intelligence using SSIS, Azure Data Factory, T-SQL, Spark SQL, U-SQL, Azure Data Lake, Azure Storage, Azure SQL, Azure DW, and Power BI
  • Demonstrated strong experience in advanced performance tuning, optimizing SQL queries, building indexes, and complex SSIS packages
  • Displayed proficiency in data visualization and dashboard design, utilizing best practices and tools such as KPIs, Power BI, Tableau, and SSRS
  • We have implemented OCI infra setup tenancy creation, provisioned OAC and cloud migration from OBIEE to OAC
  • Developed SSIS packages using various transformations and migrated a few packages in Azure data factory
  • Extract transforms and loads from source system to azure data storage services using a combination of azure data factory T-SQL, Spark SQL, and U-SQL azure data lake analytics
  • Data ingestion to one or more azure services – (Azure data lake, Azure storage, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks
  • Developed JSON scripts for deploying the pipelines in Azure data factory that process the data using SQL Activity
  • Worked as a Power BI Administrator and maintaining security level access for various departments
  • Set up Azure Repo and pipelines for CI/CD deployments of objects
  • Knowledge on Extract transform and load(ETL) automation tools like DVO and Query Surge
  • Developed data capture and navigate desktop and mobile apps in Microsoft Power apps that connect to distribution center solution design analytics in Power BI
  • Worked on migrating the data from SAP Data warehouse to Snowflake and SAP Hana to Azure SQL Server
  • Used AWS data Pipeline for Data Extraction, Transformation and Loading from homogeneous or heterogeneous data sources
  • Designed Star Schema in Big Query
  • Developed data warehouse model in snowflake by migrating the data from SAP into snowflake
  • Redesigned the view in snowflake to increase the performance and use in Talend for loading Dimensions and facts
  • Process and load bound and Unbound Data from Google Pub/Sub Topic to Big Query using cloud Dataflow with Python and built various graphs for business decision-making using Python matplot library
  • Developed Data Pipelines using Python for medical image pre-processing, Training and Testing
  • Created various types of reports, visualizations, and analytics dashboards using Power BI, SSRS, and Tableau
  • Ensured optimum data cleansing and massaging using Power Query, DAX functions, and MDX queries
  • Familiar with pulling data from various sources and implementing Power BI gateway for modeling and analysis
  • Presented strong experience in writing parameterized queries, formatting report layouts, and using expressions, functions, and global variables in SSRS.

Sr. SQL BI Developer

Indiana University Health
03.2020 - 12.2022
  • Involved in creation/review of functional requirement specifications and supporting documents for business, experience in database design process and data modeling process
  • Experience in SDLC and Agile methodologies such as SCRUM
  • Developed reports, dashboards using power bi, deployed into power bi service using various data sources and maintaining row level security to those reports
  • Using query editor in power bi performed certain operation like fetching data from different file
  • Involving in Functional Testing & Regression testing and Test case execution and Ad hoc testing
  • Re-written the data source in SSRS and Power BI reports and re-written the stored procedures, views, functions etc., using new tables in EDW
  • Developed Dashboards in Tableau & Power BI reports and migrated the reports from Tableau to Power BI Premium
  • Involved in T-SQL troubleshooting and performance tuning, created SQL jobs, and monitored failed jobs
  • Involving in writing complex SQL queries to verify data from Source to Target
  • Strong knowledge on HL7 standards, HIPAA standards, Medicare, and Medicaid Services
  • Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions
  • Upgraded data from SQL Server 2012 and 2014 to SQL Server 2016, developed complex mappings for data transformation and loading from various sources such as SQL Server 2014, Oracle ERP, Excel, and flat files
  • Developed T-SQL scripts including stored procedures, triggers, views, functions, cursors, indexes, derived tables, and CTEs to facilitate efficient data manipulation and consistency
  • Used PMCMD Command to automate the Power Center sessions and workflow through UNIX
  • Developed dashboards using Power BI and Tableau, with advanced calculations using DAX and Power Query to meet organizational goals
  • Created reports with SSRS, including tabular, matrix, drill-down, and parametrized reports for pricing and forecasting, with data-driven subscriptions and complex data sets.

Sr. SQL BI/ ETL Developer

Speedway
01.2018 - 02.2020
  • Worked in Agile methodology, participated in Sync meetings, and developed mappings in Informatica to load data from various sources into the Data Warehouse, using various transformations such as Source Qualifier, Lookup, Aggregate, Update Strategy, and Joiner
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements and distributed them using techniques like Packaged Workbooks, and PDF
  • Worked on Upgrading Data from SQL Server 2012 and SQL Server 2014 to SQL Server 2016 and developed complex mappings utilizing SSIS to transform and load data from various sources such as SQL Server2014, Oracle, Excel, and Flat files into the SQL 2016 Server target staging database
  • Proficient in SQL Server Analysis Services (SSAS) to design and develop OLAP Cubes, MDX Queries, and Dimensional modeling (Star Schema) of the Data warehouse
  • Experience in writing parameterized queries for generating stylish tabular reports, formatting report layout, and sub-reports, using Global Variables, Expressions, and functions, sorting the data, defining data sources and subtotals for the reports using SSRS
  • Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly, and quarterly reports including current status
  • Migrated On-Premise databases to Azure Cloud Database and was involved in the migration process of SQL server management studio (SSMS) 2012 to 2017 and Visual Studio 2012 to 2015 along with SQL Server Data tools
  • Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, and data validation checks during Staging, before loading the data into the Data warehouse
  • Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, and CSV using SQL Server 2012 Reporting Services (SSRS) and developed dashboard reports using Reporting services, Report model, and ad-hoc reporting using Report builder.

SQL BI/ETL Developer

Lendingkart
02.2015 - 11.2015
  • Migrated data from various sources such as flat files, and Excel to SQL Server databases using SQL Server Integration Services (SSIS)
  • Expert in creating packages like extract, transform, and load data to data warehouse by SSIS, from various sources such as flat files, OLEDB sources
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, and XML files into UL Database and DB2 Billing Systems
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions
  • Created logging, custom logging, and error-handling packages
  • High-Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
  • Creating and modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies
  • Designed SSAS Cubes, Named Calculations for Dimensions
  • Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, and Charts
  • Implemented Event Handlers and Error Handling in SSIS packages
  • Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)
  • Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS
  • Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements
  • Used different T-SQL queries such as views, triggers, user-defined functions, andstored procedures to retrieve data from various tables, andload data.

Education

M.S. - Computer Science

San Francisco Bay University

Bachelor of Engineering - Computer Science

JNTUH – Hyderabad, India

Skills

  • Report Design
  • Advanced SQL Queries
  • Power BI Proficiency
  • Python Programming
  • Data Visualization
  • SQL and C# Programming
  • Data Analytics
  • ETL tools( ADF, SSIS, Informatica)
  • Data modeling

Certification

  • Azure Data Engineer Associate
  • Google Cloud Professional Data Engineer

Technicalskillset

SQL Server, Azure SQL, MS Access, Teradata, Oracle RDBMS, DB2, PostgreSQL, MySQL, Snowflake, Vertica, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica, Power BI, Tableau, GITLab, AzureDevops, JIRA, SQL, T-SQL, PL/SQL, Dynamic SQL, HTML, C#, MDX, Python

Technicalskillsummary

Conducted workshops, interviewed SMEs and Stakeholders to understand client business processes, authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and isolating interface and business process specifications. Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective. Skilled in SQL (DDL, DML, DCL), creating, developing new database objects by like tables, views, indexes, complex stored procedures, function, cursors, and triggers, locking issues, common table expressions (CTEs), and Backups. Strong knowledge in developing Power BI Reports and Dashboards from multiple data sources using Data Blending. Experience with Teradata utilities like Fast load, Fast Export, Multi Load. Analyzing X12/EDI pre-adjudicated data including 835, 277, and 837 transitions can provide valuable insights into healthcare revenue cycle management By using tools like Power BI to visualize and analyze this data. Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment, Normalization and De-normalization, Cleansing, Performance Optimization along with the CDC (Change Data Capture). Good Experience in UNIX Shell scripting& Windows Batch Scripting for Parsing Files & automation of batch ETL jobs. Strong Experience on EHR,FGIR, HL7 standards, HIPAA standards, Medicare, and Medicaid Services. Educated 15 people on QC fundamentals which increased the number of existing bugs fixed per week by 70%.

Timeline

Sr. SQL BI Developer

DTCC
01.2023 - Current

Sr. SQL BI Developer

AT&T
01.2021 - 12.2023

Sr. SQL BI Developer

Indiana University Health
03.2020 - 12.2022

Sr. SQL BI/ ETL Developer

Speedway
01.2018 - 02.2020

SQL BI/ETL Developer

Lendingkart
02.2015 - 11.2015

M.S. - Computer Science

San Francisco Bay University

Bachelor of Engineering - Computer Science

JNTUH – Hyderabad, India

Similar Profiles

CREATE PROFILE
Varsha Annangi