Summary
Overview
Work History
Education
Skills
Timeline
Generic

Uma Rama Bhagya Kalidindi

Bridgewater,NJ

Summary

Experienced professional with 11+ years in Software Development Life Cycle (SDLC), specializing in Application and Data Analysis. Proficient in Design, Development, Analysis, Support, and Testing for various data projects. Recent expertise in data loads using Databricks, Snowflake, IntelliJ, and GitHub. Recognized for quick learning, adapting to new tools/languages, and consistently meeting deadlines.

Overview

16
16
years of professional experience

Work History

Data Engineer

UHG, United Health Group
08.2022 - Current
  • As a Remote Data Engineer at UHG, I have been instrumental in designing and developing robust ETL pipelines using Databricks, which facilitate efficient data extraction, transformation, and loading for critical business operations.
  • Conducted comprehensive data analysis and business analysis to support healthcare initiatives.
  • Deep understanding of Healthcare Claims and Electronic Health Records (EHR) data, ensuring compliance with industry standards and regulations.
  • Designed and developed ETL pipelines using Databricks to ensure efficient data extraction, transformation, and loading processes.
  • Utilized Snowflake for advanced data analysis, optimizing query performance across extensive datasets.
  • Experience in writing and optimized SQL queries to generate end-user reports and extract data from source systems.
  • Also worked on QA validation for the project to ensure that the data loaded into the target tables was free of anomalies.
  • Guided analytic team members on their implementation to fulfill management requirements.
  • Worked in Agile settings, focusing on iterative development and collaboration. Created concise user stories and requirements to streamline development processes.
  • Managed production support activities, including incident resolution and maintaining seamless application functionality.
  • Created and monitored Apache Airflow (DAGs) for scheduling and timely data loading to optimize workflow efficiency.
  • Executed complex end-to-end development processes, analyzing source data and creating sophisticated datasets for downstream requirements.
  • Conducted impact analysis for table structure expansions or modifications, ensuring data integrity and optimal performance.
  • Led and contributed to project migrations from on-premises to cloud database servers, ensuring seamless transitions, optimized performance, and minimal downtime.
  • Monitored and communicated AkHQ Kafka topics to ensure accurate data transmission, proactively identifying errors and escalating issues for resolution.
  • Troubleshot scheduled DAG failures, identifying root causes and implementing solutions for seamless workflow execution.
  • Experience in reading XML and JSON files in Databricks, applying transformations using SQL and PySpark for data validation, and creating pipelines to load data into target tables.
  • Proven track record in managing project timelines, ensuring timely completion in alignment with management expectations.
  • Leveraged GitHub for CI/CD pipeline implementations, automating deployments, and enhancing development efficiency.
  • Developed an automated workflow to detect anomalies in data processes, ensuring proactive alerts are sent to designated team members. This facilitates timely analysis, enabling effective communication and corrective actions prior to file delivery, ensuring data integrity and seamless downstream operations.
  • Technical Environment: Snowflake, Databricks, AKHQ Kafka, SQL, GitHub, CI/CD pipelines, DAG creation and monitoring, QA testing, CSV/TXT data loading, Airflow, Scala, Jenkins, IntelliJ, Apache Airflow, scala, Python.

Data Analyst

OPTUM(UHG)
06.2021 - 07.2022
  • Responsible for writing and maintaining the STT on Domains specific to Market.
  • Responsible for creating and maintaining views for customer requested data sets.
  • Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
  • Extracted, compiled, and tracked data, and analyzed data to generate reports.
  • Performed daily data queries to check the flow of data is consistent and accurate.
  • Participate in knowledge transfer to ensure a better grasp of the process for new data analysts to participate in daily analysis processes.
  • Experience with data mapping, querying the source and target tables in the database using SQL for testing purposes.
  • Had experience in creating and maintaining reference tables with documentation.
  • Experience working in collaborative cross-functional teams including offshore teams.
  • Performed select queries and table joins using SQL and exported data to excel for formatting and report generation.
  • Had Hands on experience in working on Azure snowflake for creating views for customer specific data sets.
  • Experience in importing data to database from flat files (Excel, Csv) using SSIS packages or SSMS task manager.
  • Worked closely with developers in creating SQL queries and store procedures for extracting data for business needs.
  • Follow Agile standards and methodologies to manage work via Rally.
  • Environment: SQL, OLAP, ETL Data Warehousing, Informatica, Snowflake, Databricks, SSIS, Excel, SSMS, ETL Datawarehouse, Data Queries, Rally, Python, Scala.

Data Analyst

Intel
12.2020 - 04.2021
  • Responsible for maintaining the integrity of the SQL database on new projects and reporting any issues to the database architect.
  • Experienced in writing SQL scripts to Validate data loads from source (Flat files, CSVs, tables) to target (Flat, CSV, tables) based on requirements specified in the mapping documents.
  • Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.
  • Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
  • Extracted, compiled, and tracked data, and analyzed data to generate reports.
  • Performed daily data queries and prepared reports on daily, weekly, and monthly basis.
  • Extracted data from primary and secondary source and loaded the data to the staging tables to maintain main and history tables for reporting and validation purpose for the business needs.
  • Participate in knowledge transfer to ensure better grasp of the process for new support Engineers to participate in daily analysis processes.
  • Experience with data mapping, querying the source and target tables in the database using SQL for testing purposes.
  • Experience using pivot tables and VLOOKUP function for analyzing and generating reports.
  • Experience working in collaborative cross-functional teams including offshore teams.
  • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Worked with OLAP tools such as ETL, Data warehousing and Modeling, Using SSIS to extract, transform & load data from Hadoop to SQL server.
  • Performed select queries and table joins using SQL and exported data to excel for formatting and report generation.
  • Worked on HUE actions like HIVE.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Participated in developing SSIS for loading data into SQL server DB.
  • Experience in importing data to database from flat files (Excel, Csv) using SSIS packages or SSMS task manager.
  • Verified, extract, transform, append and standardized data from disparate datatypes and source system to meet system/business requirements.
  • Worked closely with developers in creating SQL queries and store procedures for extracting of data for business needs.
  • Follow Agile standards and methodologies to manage work via Rally.
  • Environment: SQL, OLAP, ETL Data Warehousing, SSIS, Hadoop, HIVE, SSIS, Excel, SSMS, HUE, VLOOKUP, ETL Datawarehouse, Data Queries, Power BI.

Data Analyst (Support Engineer)

Medicare
08.2015 - 11.2018
  • Prioritize workload, providing timely and accurate resolutions, performing Production support activities, with on call rotation. Analysis and resolution within the specified SLAs.
  • Used information schema tables and system tables to analyze different objects in databases.
  • Participate in knowledge transfer to ensure a better grasp of the process for new support Engineers to participate in on call rotation.
  • Created procedures, Functions and views and analyzed complex business logic.
  • Extracting data from various sources across the organization, validating the data and transforming and loading the data to target tables using Informatica tool and doing visualization with BI tool (Informatica 9 power center).
  • Analyzed Production bugs, reproduce and escalate to on call DEV team for resolution setting SLAs, prioritizing the impact.
  • Providing Time updates to business and technical leads to ensure issues are resolved in a timely manner.
  • Worked on UML Modeling Process to analyze Application flow diagrams to verify Existing system needs to meet business standards.
  • Re-verifying the Data loads after the bug fixes, to ensure the new code can be deployed to PROD systems, addressing the issue.
  • Responsible for maintaining the integrity of the SQL database on new projects and reporting any issues to the database architect.
  • Experience writing SQL queries with JOINS, CTEs and analyzing complex business logic as per the requirement.
  • Experience validating data loads with Informatica, SSIS tools and reporting tools Tabulae.
  • Familiar validating all types of reports and verifying the dashboards with the data in databases.
  • Interpreted data from primary and secondary sources using statistical techniques and provide ongoing reports.
  • Compile and validate data; reinforce and maintain compliance with corporate standards.
  • Developed SQL queries to obtain complex data from tables in remote databases.
  • Using SQL queries to pull data relevant for customers marketing campaigns.
  • Involved in writing code using SQL and Validate data from source tables.
  • Obtained detailed understanding of data sources, Flat files & Complex Data Schemas to write the best test scripts.
  • Took regular database backup, test databases, and perform bug fixes.
  • Developed best practices for database design and development activities.
  • Fix any issues related to database performance and provide corrective measures.
  • Created different functional reports using SSRS and tested them with automation scripts using Asp.net C# web app.
  • Involved in ETL testing, to validate data from source and target systems in Oracle and SQL server database.
  • Managed dashboards reflecting various graphs supporting business needs.
  • Knowledge about partitioning in database which is done for performance and manageability of the table.
  • Environment: ETL testing, Data loads, SSRS, SSIS, SSAS Oracle 10g, (exposure Oracle 11g, 12g, 18c). C#, Data schemas, Tableau, SL, Informatica 9, power center, DDL, SQL queries, Power Shell, Star Schema, Snowflake.

Data Analyst

Knowledge Lens
02.2013 - 07.2015
  • Validated data Loaded from primary and secondary sources using SQL queries and variety reports in place.
  • Worked on UML Modeling Process to analyze Application flow diagrams to verify Existing system needs to meet business standards.
  • Validate OLTP data loads into OLAP databases (Data Warehouse) following the Datawarehouse concepts as per industry standards.
  • Collaborated cross-functionally with business analysts, developers, and testers to explain new process transformations clarifications as needed.
  • Used system tables to verify columns in different tables and schemas.
  • Followed Agile standards and methodologies to manage work via TFS story boarding.
  • Manually mapping or indexing data structures from existing business application databases.
  • Participated in story refinement and backlog prioritization meetings to make the stories ready to be picked to be worked on.
  • Used SQL queries to develop reports to pull data relevant for customers’ marketing campaigns.
  • Experienced in writing SQL scripts to Validate data loads from source (Flat files, CSVs, tables) to target (Flat, CSV, tables) based on requirements specified in the mapping documents.
  • Worked directly with Business to clarify on GAPS identified in requirements specified in Mapping documents while validating the data.
  • Schema and structure validation of Source and Target tables.
  • Participated in developing SSIS for loading data into SQL server DB.
  • Gathered requirements for Report Development Specifications (RDS) and SOWs for creating reports.
  • Developed reports with parameters (parameterized) based on business needs or requirements.
  • Developed different queries to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS.
  • Environment: SQL queries, Oracle 11g/12g, and 18c OLAP, OLTP, Flat, CSV, tables, SSIS, SSAS, SSRS, Excel, Power BI, Tabular Reports, Power Shell, Star Schema, Snowflake.

Data Analyst /Business Analyst

Globalfas
11.2010 - 12.2011
  • Worked in a team development environment as well as working independently and efficiently to meet deadlines.
  • Exposure to client interactions and possess strong communication skills.
  • Designed, created and test reports using SSRS.
  • Worked with customers to develop new report or data extract requirements, make changes to existing reports or data extracts, and identify any errors in data output.
  • Create and deploy various types of reporting services reports, such as Drilldown reports and Matrix reports.
  • Worked on UML Modeling Process to analyze Application flow diagrams to verify Existing system needs to meet business standards.
  • Read and write advanced and complex T-SQL queries.
  • Provided input to and interpret business requirements.
  • Performed technical writing to design and deliver end-user training and training materials as needed.
  • Excellent interpersonal, verbal, and written communication skills.
  • Ability to alter communication styles to accommodate diverse personalities with varied levels of technical understanding.
  • Involved to work more as an SSRS developer to create reports for analysis, SSAS developer to build facts and dimension tables for efficient analysis and reporting and as a DBA to monitor client's databases on production server.
  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Environment: SSRS, / SSAS, OLAP, OLTP, SSIS, TFS story board, SQL script (Flat files, CSVs, tables), RDS, Tabular, Oracle 11g, 12g, 18c), DDL, SharePoint, UML.

Report Analyst

eiqNetworks, India
03.2009 - 05.2010
  • Worked closely with the Treasure team to follow bank issues which impact daily sales audit.
  • Assisted supervisor on annual sales audit report.
  • Assisted to the monthly and quarterly statistics reports for two legal entities.
  • Assisted supervisor to prepare sales report.
  • Worked with Tax team to calculate VAT surcharge and related journal entries.
  • Assisted with preparation of various reports provided to investors periodically.
  • Acting as Business Analyst for system enhancements and coordinating, executing testing.
  • Support the business in terms of interpreting complex datasets, analyzing results using statistical techniques and providing key business reports.
  • Extracting and manipulating data from various reporting environments and producing regular reports in agreed format.
  • Environment: Excel, SQL.

Education

Business Administration - Tech System Management And Finance

Dr. N. S. Kolla School of Business
09-2002

Bachelor of Commerce -

Dr.Lankapalli Bullayya College
Vishakapatnam
01.1999

Skills

  • ETL pipelines
  • Databricks
  • Snowflake
  • Airflow
  • Data Integration
  • Kafka
  • SQL
  • CI/CD Pipelines
  • Agile
  • Waterfall
  • Data Modeling
  • Troubleshooting
  • Analytical Skills
  • PL/SQL
  • C#
  • Informatica
  • Toad
  • SQL Server
  • Hadoop
  • HIVE
  • Excel
  • SSMS
  • HUE
  • Power BI
  • Tableau

Timeline

Data Engineer

UHG, United Health Group
08.2022 - Current

Data Analyst

OPTUM(UHG)
06.2021 - 07.2022

Data Analyst

Intel
12.2020 - 04.2021

Data Analyst (Support Engineer)

Medicare
08.2015 - 11.2018

Data Analyst

Knowledge Lens
02.2013 - 07.2015

Data Analyst /Business Analyst

Globalfas
11.2010 - 12.2011

Report Analyst

eiqNetworks, India
03.2009 - 05.2010

Business Administration - Tech System Management And Finance

Dr. N. S. Kolla School of Business

Bachelor of Commerce -

Dr.Lankapalli Bullayya College

Similar Profiles

CREATE PROFILE
Uma Rama Bhagya Kalidindi