HARICHANDANA GONUGUNTLA

Location

Salt Lake City, UT
Education
    University of Utah
    January 2023 - April 2024
    degree
    Master's
    major
    Business Analytics
    G.Narayanamma Institute of technology and science
Work Experience
    University of Utah Health
    Data Analyst
    Salt Lake City, UT, US
    May 2023 - December 2023
    company
    University of Utah Health
    title
    Data Analyst
    overview
    - Compiled and cleaned data (around 3million records) from disparate sources using moderate to complex SQL - Cleaned and validated health data and built a model using Mode imputation to impute the Health Small Areas using - R and reduced missing data by 79%.Good understanding of Medicare reimbursement systems like DRG, APC etc - Developed and automated a Python script to generate cumulative patient visit data information on a monthly basis
    Deloitte Consulting USI
    Data Analyst
    Hyderabad, IN-TG, IN
    May 2020 - December 2022
    Deloitte Consulting USI
    Business Analyst
    Hyderabad, IN-TG, IN
    November 2018 - May 2020
Skills
A/B TestingAdvanced Business Application Programming (ABAP)Agile MethodologyAirflowAmazon Web ServicesApache HadoopApache HiveApache KafkaApache SparkAssembly and InstallationAutomationBig DataBigQueryBusiness AnalysisBusiness RequirementsCascading Style Sheets (CSS)Cloud ComputingConceptual ModelsConsultingConsumer BehaviourCredit RisksDashboardsData AnalysisDatabasesDatabricksData Manipulation LanguagesData MiningData ModelingData TransformationData VisualizationDecision TreesDomoElectronicsExtract Transform Load (ETL)Feature EngineeringFinancial ConsolidationForecasting SkillsGitGithubHealth CareHTMLKnowledge of EngineeringKnowledge of FinanceKnowledge of Purchasing ProcessesKnowledge of StatisticsLogistic RegressionLooker AnalyticsMachine LearningMacrosMarketingMatplotlibMedicareMicrosoft AzureMicrosoft ExcelMicrosoft OfficeMicrosoft OutlookMicrosoft PowerPointMicrosoft SQL ServerMicrosoft WordMongoDBMySQLNoSQLNumPyOracle ApplicationsPandasPerformance ImprovementPerformance TuningPivot TablesPostgreSQLPower BIPredictive ModellingProgramming LanguagesPysparkPython (Programming Language)Query PerformanceRetention RateRisk AnalysisSAP ABAPSAP ApplicationsSAP NetWeaverScikit LearnScriptingSnowflakeSQL DatabasesSQL Server Integration ServicesSQL Server Reporting ServicesSQL Stored ProceduresStrategic ThinkingStreamlineTableau (Software)TelematicsVba Programming LanguageVisualizationXgboost