Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

Harshitha Nalla

Louisville,KY

Summary

Adept Data Analyst with a proven track record at Elevance Health, enhancing data integration speed by 50% and boosting database performance. Expert in Power BI, SQL, and cross-functional collaboration, I excel in strategic database management and advanced analytics, significantly improving decision-making processes. Demonstrates strong problem-solving abilities and technical proficiency.

Overview

4
4
years of professional experience

Work History

Data Analyst

Elevance Health
North Carolina
08.2023 - Current
  • Developed and maintained reports, KPI scorecards, and dashboards based on user specifications using Power BI, ensuring effective data visualization and analysis for informed decision-making
  • Developed and implemented comprehensive database management strategies across multiple platforms, including MS SQL, Oracle, and PostgreSQL, to optimize performance, ensure data integrity, and facilitate seamless data processing and analysis
  • Worked with pages and page visualizations in Power BI Desktop
  • Collaborated with developers to integrate database functionality into applications
  • Developed complex SQL queries, stored procedures, and functions to meet business needs
  • Conducted query optimization and performance tuning for improved database efficiency
  • Implemented ETL processes that improved data integration speed by 50%, reducing processing time and enhancing data consistency across platforms
  • Collaborated with cross-functional teams to identify data sources and streamline data collection, resulting in a 25% reduction in report development time
  • Integrated R and Python scripts for advanced analytics and custom visualizations
  • Created various dashboard reports, user parameters, slicers, and other visualizations
  • Shared the reports with business users using content packs
  • Optimized SQL queries and database structures, resulting in a 35% increase in database performance and reducing report generation time by 25%
  • Created new SQL objects like tables, views, functions, stored procedures, and server scripts

Student Worker, Front Desk (Data Management & Analysis Focus)

University of Central Missouri
lee summit, Missouri
08.2022 - 03.2023
  • Streamlined inquiry handling processes by implementing efficient data tracking and reporting systems
  • This led to improved workflow efficiency and enhanced the overall student experience
  • Generated and presented reports on student inquiries and trends to university administration, providing insights that informed decision-making and improved service delivery
  • Assisted the administration in making data-driven decisions by providing accurate and timely analysis of student interaction data
  • Leveraged strong communication and technical skills to support students and staff, ensuring accurate data entry and efficient resolution of inquiries

Data Analyst (Claims)

Legato Healthcare
Hyderabad, India
10.2020 - 10.2021
  • Analyzed claims-related data to identify trends, patterns, and irregularities, leading to a 25% increase in productivity and a reduction in errors from 5% to 0%
  • Utilized data visualization tools to present findings and insights, aiding in decision-making processes
  • Processed and monitored insurance claims using SQL and claims processing software, improving data accuracy and integrity
  • Collaborated across departments, including customer service, accounts payable, and legal, to ensure accurate claim processing and reporting
  • Demonstrated strong analytical and problem-solving skills, with proficiency in data analytics tools

Education

Master’s - Technology

University of Central Missouri
USA
08.2023

Bachelors - Business Administration

Villa Marie Degree College for Women
India
08.2020

Skills

  • Production Planning and Scheduling
  • Supply Chain Management
  • Inventory control
  • Lean Manufacturing Principles
  • Problem-Solving & Process Improvement
  • Database: MS SQL Server
  • Database: Oracle
  • Database: PostgreSQL
  • Database: Snowflake
  • Database: Denodo
  • Programming Languages: T-SQL
  • Programming Languages: PL/SQL
  • Programming Languages: C#
  • Programming Languages: XML
  • Programming Languages: Python
  • Programming Languages: R
  • Programming Languages: PowerShell
  • Programming Languages: Visual Basic
  • Programming Languages: M Language
  • ETL Tools: SQL Server Integration Services (SSIS)
  • ETL Tools: Informatica
  • ETL Tools: Data Transformation Services
  • Reporting Tools: Power BI
  • Reporting Tools: Tableau
  • Reporting Tools: SQL Server Reporting Services (SSRS)
  • Reporting Tools: Crystal Reports
  • Other Tools: SQL Server Management Studio (SSMS)
  • Other tools: Visual Studio
  • Other Tools: Team Foundation Server (TFS)
  • Other tools: Git
  • Other tools: SVN
  • Other tools: VSS
  • Cloud: Microsoft Azure
  • Cloud: Google Cloud
  • Cloud: AWS
  • Operating Systems: Windows
  • Operating Systems: Linux
  • Operating Systems: UNIX

Projects

Healthcare Business Analyst - FACETS - Claims Application, Worked as a Facets Healthcare Business Analyst, managing ITS and non-ITS claims, training newcomers, and assisting IT in automating medical procedure codes and system processes.

Timeline

Data Analyst

Elevance Health
08.2023 - Current

Student Worker, Front Desk (Data Management & Analysis Focus)

University of Central Missouri
08.2022 - 03.2023

Data Analyst (Claims)

Legato Healthcare
10.2020 - 10.2021

Master’s - Technology

University of Central Missouri

Bachelors - Business Administration

Villa Marie Degree College for Women
Harshitha Nalla