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
Remote
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
Remote
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)
Montgomery
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
Remote
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)
Montgomery
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
Hyderabad
07.2012 - 04.2015
Support Associate
Amazon
Hyderabad
08.2011 - 01.2012
Education
Bachelor of Science - Information Technology
Jawaharlal Nehru Technological University
Hyderabad, IND08.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