Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sumana Sangapu

Irving,TX

Summary

Skilled IT professional with over 18 years of experience in leadership roles, enterprise/solution architecture & tech strategy, reference architecture, software delivery and implementations. Have extensive experience in stakeholder management including interacting with the c-level executives, client and account management. Hands on experience with Data Modeling, Datawarehouse and Data analytics Extensive experience in SQL development in healthcare and mortgage industry with strong understanding of data and analytics Experienced in creating tables, stored procedures, views, indexes, user defined functions, relational database models and data integrity Broad experience in query optimization and performance tuning A well-organized, goal oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting and problem solving skill

Overview

23
23
years of professional experience

Work History

Lead MS SQL Server/BI Developer

Whitespace Health
Irving, TX
05.2017 - 03.2023
  • Manage a team of 10+ developers , provide technical direction, schedule and delegate work, evaluate performance, advise on best practices, develop and implement an analytics product, review code, mentor engineers
  • Hands on with the TSQL queries, ETL processes and job loads and query optimization
  • Designed and developed SSIS Packages to successfully handle the integration of disparate source systems into a unified system and drive process standardization to ensure greater consistency across the product
  • Involved in daily batch loads (full and incremental) into staging and data warehouse areas, troubleshooting processes and issues
  • Hands on with database design using dimensional modelling by identifying the fact and dimension tables based on stakeholder requirements
  • Designed and implemented dashboards and scorecards with business KPIs into Whitespace analytics platform
  • Work closely with Product Owner and Business Analysts, for understanding the systems' functional and non-functional requirements and establish realistic estimates for timelines while ensuring that projects remain on target to meet deadlines
  • Analyze requirements and provide time estimates: consume non-technical functional requirements documentation, translating into technical documentation, provide feasibility assessment and estimate level of effort to implement
  • Have been greatly involved in the design of the application and database in order to evolve as a unified product code base
  • Responsible for review and creation of datasets using TSQL and stored procedures, functions and triggers

Lead Database Developer/ SQL Server Architect

XenatiX, Metrocare Services
06.2015 - 05.2017
  • Architected the initial database schema for the product confirming to HIPAA regulations
  • Core member of the product's overall architecture, design and implementation team
  • Designed and lead Data Migration effort from legacy systems using SSIS packages and implemented SSIS packages for integration with billing and other third-party systems
  • Designed and developed multiple stored procedures and views for various features of application
  • Designed and implemented partitions in the database to enhance the data load time and query processing time
  • Lead performance tuning and query optimization tasks
  • Designed and implemented the automation of Drug import process from FDA
  • Lead and supported the initial rollout of the product
  • Worked with SQL Server on Microsoft Azure.

Lead Data Warehouse/SQL Server Architect/Developer

Nationstar Mortgage
08.2010 - 01.2014

SQL Server Developer

Verizon
08.2006 - 08.2010
  • Worked on the Workflow and Service Order models
  • Wrote optimized T-SQL queries to reach the performance standards
  • Extensively involved in performance tuning of the queries in the stored procedures to increase the performance of the reports to load within 30 seconds which otherwise took as long as 9 minutes to load
  • This was done efficiently by introducing indexes, de-normalizing the tables and restructuring the joins involved in the queries
  • Use SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons
  • Enhanced the product catalog functions by redesigning the existing ones

SQL Server Developer

Otis Elevators
12.2004 - 07.2006
  • Wrote optimized T-SQL queries to reach the performance standards
  • Data modeling including ER diagrams, database design using Case Studio 2
  • Data migration from MS Access to MS SQL Server using Data Transformation Service
  • Data migration scripts involved complicated calculations and complex queries joining more than 10 tables in each of the scripts
  • Around 50 such scripts were written to populate data into tables
  • All the scripts were scheduled to run as a job in the backend
  • At the end of every year, data archival process takes place thru stored procedures run as a backend scheduled job
  • Wrote and validated functional specification, Prototypes, Design Documents
  • Set up database coding standards for the entire project team and guide the team in solving complex queries.

SQL Server Developer

Wipro Technologies
06.2000 - 11.2004
  • Analysis and Feasibility study of the requirements received from the clients
  • Participated in the design of the database for the entire application
  • Writing stored procedures and triggers using TSQL commands and functions
  • Writing TSQL Queries to generate reports
  • Responsible for performance tuning and optimization of the database
  • Use of DTS package to import data from the legacy systems into the current database.

Lead SSIS architect/developer

  • Developed multiple SSIS packages to consolidated and migrate data from heterogeneous data sources and legacy system (DB2, Access, Excel) to SQL Server databases
  • Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimensions, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations
  • Implementation of reusable SSIS packages by maintaining centralized package configurations
  • Lead SSRS architect/developer, developed multiple drill down/drill thru reports
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Developed various operational Drill-through and Drill-down reports using SSRS
  • Performance tuning, enhancements of legacy SSIS/SSRS packages/reports and stored procedures (SP)

Education

Masters - Computer Science

Skills

  • Leadership (Technical & People)
  • Tech Strategy Definition and Implementation
  • Go-To-Market Launch Plans (Implementation)
  • Client Relations & Account Management
  • Revenue Cycle Management
  • Data Modeling
  • Data Analytics
  • Data Warehouse
  • TSQL & BI
  • SSIS (ETL)

Timeline

Lead MS SQL Server/BI Developer

Whitespace Health
05.2017 - 03.2023

Lead Database Developer/ SQL Server Architect

XenatiX, Metrocare Services
06.2015 - 05.2017

Lead Data Warehouse/SQL Server Architect/Developer

Nationstar Mortgage
08.2010 - 01.2014

SQL Server Developer

Verizon
08.2006 - 08.2010

SQL Server Developer

Otis Elevators
12.2004 - 07.2006

SQL Server Developer

Wipro Technologies
06.2000 - 11.2004

Lead SSIS architect/developer

Masters - Computer Science

Similar Profiles

CREATE PROFILE
Sumana Sangapu