Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

ARUN KANAGALA

Wetumpka,AL

Summary

Experienced technical business analyst with a strong skill set in Healthcare domain, databases, data migration, and deployment support. Proficient in agile methodologies, excelling in stakeholder management and leading cross-functional teams.

Overview

13
13
years of professional experience

Work History

Systems Analyst

Elevance Health
02.2023 - 07.2024
  • Worked with Elevance's government business division focused on CalAIM (California Advancing and Innovating Medi-Cal)
  • Collaborated with various stakeholders to implement Enhanced Care Management (ECM), Homelessness, Community Support population data ingestion into 4 new data warehouses
  • Applied SQL skills to aggregate data and analyzed data flow from various sources to destinations
  • Created and maintained detailed documentation of requirements, design and testing documents throughout the deployment process
  • Developed and executed 200 plus test plans to ensure solutions meet defined requirements and functions as expected
  • Worked with data migration teams to move data from PostgreSQL server to Microsoft SQL Server, ensuring data integrity and accuracy
  • Analyzed ETL pipeline to streamline data ingestion and processing for analysis, resulting in a 30% reduction in processing time
  • Wrote technical documentation to illustrate data specifications and data lineage from various data sources

Technical Analyst

Everge Group
02.2022 - 02.2023
  • Generated project discovery artifacts and produced technical specifications to enable ingest, conform, and deliver data from 10 new sources
  • Implemented Pipelines for data ingestion and data transformation into BigQuery
  • Created specifications supporting multiple assemble and serve layer processes to fulfill defined business cases and deliver data for use by Tableau and other tools
  • Defined SQL joins to select desired rows and columns in support of dashboards and reports
  • Leveraged established patterns to complete datasets containing up to 150+ source tables
  • Collaborated with GCP architecture team on processes and templates for new patterns and completing high-level design for connections into vendor views and proprietary database structures

Senior Business Analyst

Alabama Department Of Public Health(ADPH)
12.2020 - 01.2022
  • Led small team size of 5 in building COVID-19 Vaccine ordering tool for clinicians of Alabama state.
  • Created HL7 technical documentation for EHR Vendors
  • Worked with various environments such as Test, Pre-production and Production for HL7 Onboarding with AL state
  • Conducted testing with EHR Vendors to comply with CDC's guidelines on sending Immunization data to ImmPRINT
  • Supported various stakeholders with Knowledge Base (KB) for ImmPRINT and data transmission to Immunization Registry

Support Team Lead

ShopVOX
01.2019 - 12.2020
  • Created various quick guides for support team to easily understand and help customers
  • Led support team size of 10
  • Configured Intercom, delighted, Pipedrive, Zapier for support team.
  • Monitored support team and customer interactions to assess quality of service by using Intercom reports and Delighted tool scores
  • Reduced response times for client inquiries by optimizing team workflows and communication channels.
  • Closely collaborated with Founder and Co-founder to identify and quickly address production issues
  • Contributed and managed shopVOX knowledge base for customers on various features of application
  • Worked with web developers in providing business requirements and performed UAT testing
  • Worked with customers on mapping and syncing data with their shopVOX accounts with various accounting software's such as Quickbooks, Xero and MyOB

Business Analyst

Alabama Department Of Public Health(ADPH)
06.2016 - 12.2018
  • Business Analyst for Alabama's IIS (Immunization Information System) known as ImmPRINT
  • Mapped current business and operational processes and offered recommendations for improvement
  • Prepared Business and functional requirements documents with collaboration from various stakeholders
  • Drafted technical specifications for Data Migration, Web services connection
  • Worked closely with developers to clarify functionality to resolve issues and provided feedback for enhancement of web applications
  • Conducted User Acceptance Testing (UAT) with stakeholders and conducted meetings among stakeholders to provide insight on Immunization Data transmission, data monitoring and Data quality
  • Worked with various environments such as Test, Pre-production and Production for HL7 Onboarding of providers and various EHR Vendors
  • Assisted Providers and EHR Vendors to achieve data exchange systems functionality and with Immunization registry as per CDC's guidelines
  • Worked effectively with cross-functional design teams to create software solutions that elevated client side experience and significantly improved overall functionality and performance

Support Engineer

ShopVOX
07.2012 - 04.2015

Support Associate

Amazon
08.2011 - 01.2012

Education

Bachelor of Science - Information Technology

Jawaharlal Nehru Technological University
Hyderabad, IND
08.2011

Skills

  • Database Design
  • Requirements Gathering
  • User Acceptance Testing
  • Data Modeling
  • Clinical Data Management
  • Healthcare Analytics
  • SQL
  • Claims Data Analysis
  • Healthcare Domain Knowledge
  • Big Query

Accomplishments

  • Enhanced data processing efficiency, Improved data processing time by 30% by optimizing data pipelines using SQL.
  • Streamlined reporting process, reduced time from data ingestion to reporting by 25% using new frameworks.
  • Led team to build COVID-19 Vaccine Ordering Tool for 200+ clinicians.

Timeline

Systems Analyst

Elevance Health
02.2023 - 07.2024

Technical Analyst

Everge Group
02.2022 - 02.2023

Senior Business Analyst

Alabama Department Of Public Health(ADPH)
12.2020 - 01.2022

Support Team Lead

ShopVOX
01.2019 - 12.2020

Business Analyst

Alabama Department Of Public Health(ADPH)
06.2016 - 12.2018

Support Engineer

ShopVOX
07.2012 - 04.2015

Support Associate

Amazon
08.2011 - 01.2012

Bachelor of Science - Information Technology

Jawaharlal Nehru Technological University
ARUN KANAGALA