Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Bharath Ballipongala

Atlanta

Summary

Dynamic Lead Data Engineer at Evicore by Evernorth, adept at implementing data governance frameworks and achieving a 40% reduction in data breaches. Skilled in Microsoft Purview and data classification, I excel in enhancing data security while fostering collaboration across teams to drive compliance and efficiency. Managing large data teams and leading complex data projects. Skilled in designing and implementing data infrastructures, creating ETL pipelines, managing big data platforms, collecting and sorting data in government finance and non-government clients, such as the automobile, airline, travel and vacation, and e-commerce industries. Having deep knowledge in multiple cloud services (Azure, AWS, GCP), T-SQL, SQL, PL/SQL, relational databases, database design, data modeling, performance tuning, and designing and implementing SSIS packages, SSRS reports, and the designer and development lifecycle and practices. Proven ability to deliver high-quality solutions on time and within budget. Passionate about using data to drive business decisions, and improve customer experiences.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

Evicore by Evernorth
Atlanta , GA
04.2020 - Current
  • Spearheaded the implementation of Data Loss Prevention (DLP) policies, successfully reducing data breaches by 40%.
  • Led the Microsoft Purview deployment to conduct large-scale data discovery across enterprise datasets, enhancing data oversight and security.
  • Utilized Microsoft Purview to design, implement, and monitor data classification policies, improving data management efficiency.
  • Applied Microsoft Purview labeling strategies to ensure seamless integration of data security measures.
  • Established Information Rights Management (IRM) protocols, safeguarding intellectual property, and sensitive organizational assets.
  • Leveraged Microsoft Purview to develop a data cataloging system, streamlining data utilization across departments.
  • Enforced data governance frameworks with Microsoft Purview capabilities to align with evolving industry standards and regulations.
  • Conducted risk assessments for data privacy, using Microsoft Purview analytics to identify compliance gaps, and ensure regulatory alignment.

Senior Data Engineer

Genuine Parts Co
Atlanta, GA
08.2019 - 04.2020
  • Followed industry innovations and emerging trends through scientific articles, conference papers or self-directed research.
  • Performed advanced analytics on structured and unstructured data using SQL, Python, R.
  • Created ETL scripts to move and transform data from various sources into a centralized repository.
  • Implemented new database technologies such as NoSQL databases for efficient storage of large volumes of data.
  • Created graphs and charts detailing data analysis results.
  • Designed and developed ETL pipelines for ingesting and processing large volumes of data from multiple sources.
  • Built data warehouses and data marts to support business intelligence and analytics initiatives.
  • Conducted data modeling and schema design to ensure data quality and consistency.
  • Developed and maintained data integration solutions using APIs and web services.
  • Worked closely with data analysts and data scientists to provide data insights, and support data-driven decision-making.
  • Conducted code reviews, and implemented best practices for code quality and maintainability.
  • Approached customers and engaged in conversation through use of effective interpersonal and people skills.

Data Engineer

Delta Air Lines, Inc
Atlanta, GA
03.2019 - 08.2019
  • Developed ETL pipelines and data processing workflows using Python, SQL, and other tools.
  • Designed and implemented data solutions for various business units, including sales, marketing, and finance.
  • Conducted data profiling and data cleansing to ensure data quality and accuracy.
  • Built data visualization dashboards using Tableau and other BI tools.
  • Assisted with data migration and system integration projects.
  • Served as the primary expert for Azure based solutions to Implementation and Sales teams.
  • Understood customer’s difficulties and business objectives. Extrapolated mission-critical applications to their technical needs.
  • Produced a complete implementation plan for all parts of the solution which I’m responsible for, identified which departments or employees are needed for tasks and assisted in completing their tasks.
  • Produced documentation that allows other staff members to understand the deployment and maintain and troubleshoot it.
  • Acted as a liaison between departments to ensure all tasks are understood and completed properly.
  • Implementing compute, storage, and network services on AWS/Azure cloud platforms.
  • Worked on JavaScript and frameworks like jQuery, AngularJS
  • Implemented and optimized big data storage solutions, including Hadoop and NoSQL databases, to improve data accessibility and efficiency.
  • Established and enforced data governance policies and procedures to comply with regulatory requirements and ensure data privacy.
  • Implemented Cassandra on AWS/Private cloud for multiple applications.
  • Service-oriented platform development using .NET, WAP, Azure Stack, AWS, and OpenStack Cloud.
  • Represent The Atlantic at Industry events related to programmatic and new ad tech
  • Ramp-up fast on relevant technologies as dictated by ongoing project and engineering priorities, including (but not limited to) other Microsoft products and services such as Azure SQL Database, SQL DW, Document DB as well as Open Source Big Data products such as Elastic Search, Mongo Db and Cassandra.

Senior SQL Developer

Royal Caribbean International
Miami, FL
01.2019 - 03.2019
  • Converted complex algorithms into stored procedures using T-SQL as per the business needs for the purpose of application needs.
  • Migrated the legacy Shore Pre-Cruise Planning system into a relational database system for better maintenance and easier processing of payments.
  • Used temp tables and table variables to avoid cursors in the database.
  • Worked on query optimization to improve the performance of queries.
  • Involved in weekly compliance meetings and discussed with other team leads and managers how new processes affect the environment from a performance and compliance perspective.
  • Building UAT and test environments using production backups for proactive testing of patches and hot fixes.
  • Created SSIS packages to migrate the data from the database to flat files, Excel files, and XML files.
  • Wrote an SSIS package to create a text file from the survey data and push it to SFTP/FTP servers.
  • Developed 60+ reports for the business with the help of tables, sub-reports, and charts using SSRS.
  • Generated reports using SSRS with different criteria to fulfill the client requirements.
  • Deployed and generated reports on the server using the Reporting Services Report Manager.
  • Experience in unit testing, functional testing, system integration testing, reviewing test cases, and test results.
  • Understanding and implementing the process followed by Microsoft.
  • Resolve database access and performance issues.
  • Setting up an alerting system by using performance counters for monitoring system performance.
  • Creating and scheduling SQL Agent jobs for application-specific data maintenance tasks and data purging strategies.
  • Preparing scripts and scheduling maintenance tasks.
  • Collaborated with the planning and implementation team for SQL clustering and standby servers to minimize system downtime.
  • Constantly updating the tickets that are assigned to me in JIRA.

Senior SQL Server Developer

Florida Department of Highway Safety and Motor Vehicles
Tallahassee, FL
01.2017 - 12.2018
  • Provided technical assistance to junior DBA's in day-to-day tasks including writing T-SQL scripts for various purposes.
  • Provided technical support and training to end-users on database querying and reporting tools.
  • Collaborated with IT security to audit database access and implement necessary compliance measures.
  • Performed root cause analysis to identify system issues.
  • Involved in trouble shooting replication issues related to synchronization conflicts or latency issues between publisher and subscriber servers.
  • Designed a database and implemented multiple systems using MS SQL Server.
  • Responsible for MS SQL Server configuration, tuning, and providing 24x7 dedicated support to all production, development, and clustered servers.
  • ● Designed and implemented a multi-billion-dollar project called 'Crash Application.' The Crash Application was built and maintained to include all car crash-related information. Responsible for developing and administering crash applications 24/7, 365 days.
  • Involved in ensuring data recovery, maintenance, data integrity, and space requirements for the physical database. Creating and modifying tables, stored procedures, views, indexes, user-defined functions, and triggers, etc. As a requirement on SQL Server environments.
  • Assisted users, provided database access, and granted roles for users.
  • Involved in troubleshooting various database server issues to free up log space, update statistics, configure the number of locks, create databases, and match their data log patterns with contingency.
  • Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, and monitoring the rollback segments and temporary space usage.
  • Improved performance, reliability, security, and scalability, improving internal processes and making recommendations on new storage hardware.
  • Controlled and monitored user access to the database, backed up and recovered the database, maintained system security, and monitored/optimized database performance for data warehouse and OLTP applications.
  • Used Erwin for data modeling, designing, and building relational databases.
  • Developed a Java application with FOP (Formatting Objects Processor) for converting XML data into PDF with the help of XSLT and loaded it into the database.
  • Managed 70 Oracle database instances on a two-node cluster. With performance tuning and troubleshooting, application performance.

SQL Server Database Administrator

Federal Aviation Administration, FAA
Oklahoma City, OK
01.2013 - 12.2016
  • Implemented replication between multiple servers to ensure high availability of the system.
  • Developed data models and database designs to plan projects.
  • Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
  • Developed scripts to automate routine administrative tasks.
  • Deployed patches and upgrades according to established change management policies.
  • Optimized storage and archiving practices to manage database size and performance.
  • Conducted regular database capacity planning to accommodate business growth.
  • Successfully migrated T-SQL source code from SQL Server 2000 to SQL Server 2005, to SQL Server 2012, to SQL Server 2014, and to SQL Server 2016 in the Development, Testing, and Production environments.
  • Implemented a business solution to support the application running on .NET. Monitoring scheduled jobs and alerts.
  • Implementing a data warehouse and creating data marts.
  • Implemented an SSIS package for data extraction, transformation, and loading (ETL) to supply data for frontend applications.
  • ● Used the SQL COMPARE/TFS tool to compare the structures between databases in order to sync them.
  • Used SQL Monitor and LogRhythm tools to spot trends and issues occurring in SQL servers, and resolve them before they become a problem.
  • Responsible for enhancing database objects, including tables, indexes, stored procedures, and SQL jobs.
  • Working with the development team to optimize application-specific database operations and implement security restrictions.
  • Wrote complex stored procedures and helped developers in writing stored procedures and using the latest enhancements. Available in SQL Server 2016, 2014, and 2012 is an offering.
  • ● Designed and implemented scheduled database maintenance plans and backup procedures to enhance overall database performance and disaster recovery.
  • Implemented database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
  • Involved in creating schemas, logins, tables, clustered and non-clustered indexes, views, functions, and stored procedures.

SQL Server Developer

Hersheys International
Hershey, PA
05.2012 - 12.2012
  • Implemented complex queries to retrieve data from SQL Server database by joining multiple tables with different conditions.
  • Evaluated and integrated new database technologies and tools to enhance development efficiency and system capabilities.
  • Implemented data security measures, including access controls and encryption, to protect sensitive information.
  • Reviewed project specifications, identifying and remedying potential issues that could result in development delays.
  • Designed, developed and implemented firmware to support embedded system product concepts.
  • Created SSIS packages to extract, transform and load data between heterogeneous sources like Oracle, MS Access and flat files into the SQL Server database.
  • Coordinated installation of software systems and collaborated with user experience team on design and implementation of new features.
  • Assisted in designing new database structures based on requirements provided by stakeholders.
  • Perform business analysis, technical analysis, systems design, and application software programming.
  • Prepared DFDs and Entity Relationship (ER) diagrams.
  • Restructuring the stored procedure, designing, coding, and developing it using T-SQL programming.
  • Transferring the data (ETL) to the data warehouse (Informatica) by SSIS.
  • Extensively worked on Dynamic Management Views in SQL Server 2012.
  • Installed, authored, and managed reports using SQL Server 2012 Reporting Services.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2012.
  • Monitoring SQL Server performance using SQL Profiler to find performance issues and deadlocks.
  • Developed, deployed, and monitored SSIS packages, including upgrading DTS to SSIS.
  • Performed daily tasks, including backup and restore, by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Extensively worked on data partitioning and snapshot isolation in SQL Server 2012.
  • Re-engineering Customer Cognos and PeopleSoft modules into SQL Server 2012 Integration Services.
  • Prepared the project management and technical documentation.
  • Unit test the SSIS packages with respect to their flow and performance issues.
  • Solving the bugs reflected by the testing team.
  • Rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified performance using execution plans and index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on DBCC commands and Dynamic Management Objects.
  • ● Export or import data from other data sources, like flat files, using Import/Export through DTS and SSIS.
  • To analyze long-running, slow queries and tune them to optimize application and system performance.

Education

Master of Science - Computer Science

University of Bridgerpot
Bridgeport, CT
05-2012

Skills

  • Microsoft Purview
  • Data Catalog
  • Data Map
  • Data Insights
  • Data classification
  • Data governance
  • Azure Synapse
  • Azure Data Lake Gen2
  • Azure Data Factory
  • Azure Database Migration Services
  • Azure Functions
  • AWS EC2
  • AWS RDS
  • AWS Lambda
  • Data discovery
  • ETL development
  • Hadoop Platform
  • Data quality assurance
  • Data Loss Prevention
  • Data modeling
  • Data analysis
  • Database management
  • Data security
  • Information Barriers
  • Insider Risk Management
  • Privileged Access Management
  • Role-Based Access Control (RBAC)
  • Compliance Manager
  • T-SQL
  • SSIS (SQL Server Integration Services)
  • SSRS (SQL Server Reporting Services)
  • DataMart
  • DataFlux - SAS Data
  • FHIR (Fast Healthcare Interoperability Resources)
  • HI7 (Health Level Seven International)
  • X12 (healthcare data interchange)
  • HIPAA Compliance

Certification

  • Microsoft Azure for Data Engineering [Credential ID: E5WRVBJY7SHB ]
  • Building a HIPAA Compliance Program
  • The Data Science of Healthcare, Medicine, and Public Health
  • Agile Project Management with Jira Cloud: 1 Projects, Boards, and Issues

Timeline

Lead Data Engineer

Evicore by Evernorth
04.2020 - Current

Senior Data Engineer

Genuine Parts Co
08.2019 - 04.2020

Data Engineer

Delta Air Lines, Inc
03.2019 - 08.2019

Senior SQL Developer

Royal Caribbean International
01.2019 - 03.2019

Senior SQL Server Developer

Florida Department of Highway Safety and Motor Vehicles
01.2017 - 12.2018

SQL Server Database Administrator

Federal Aviation Administration, FAA
01.2013 - 12.2016

SQL Server Developer

Hersheys International
05.2012 - 12.2012

Master of Science - Computer Science

University of Bridgerpot

Similar Profiles

CREATE PROFILE
Bharath Ballipongala