Dhanusree Avula


Location

Dallas, TX
Denton, TX
Education
    University of North Texas
    January 2023 - May 2024
    degree
    Master's
    major
    Computer Information Systems
Work Experience
    DataSense IT
    Data Analyst
    May 2024 - present
    company
    DataSense IT
    title
    Data Analyst
    overview
    - Analyzed and classified contact data for over 3 million accounts using SQL and Python, enhancing data - Managed data extraction processes across SQL Server, Snowflake, and Oracle databases, ensuring data - Utilized SAP BEx Analyzer and Query Designer to develop, modify, and execute queries for reporting and analysis, improving data retrieval efficiency by 25 - Enhanced ETL pipelines to integrate data from SQL databases and Excel, reducing data processing time by - 30 - Developed automated data workflows using Power Query, improving the efficiency of supply chain - Utilized Power Query in Power BI to merge and transform employee data into a consolidated dataset for comprehensive supply chain analysis - Created and maintained dynamic Power BI dashboards to visualize key metrics and performance indicators for supply chain operations, delivering critical insights to leadership for investor relations and business - Led reporting initiatives by building dynamic dashboards in Power BI and Qlik, improving data-driven - Integrated data from multiple sources into Qlik to create cohesive visualizations, enhancing the accessibility of complex datasets - Employed advanced data cleansing techniques to ensure data integrity and accuracy across multiple data - Used machine learning models in Python to forecast sales trends, achieving a 25% improvement in forecast - Collaborated on Salesforce integration to support investor relations and improve data accuracy in reporting - Managed data entry and integration into CRM systems for better data flow and reporting - Developed custom reports to support investor relations, improving stakeholder communication through - Developed predictive models using Python to forecast future trends and support strategic decision-making in supply chain management - Collaborated with cross-functional teams to improve data architecture, aligning data structures with business strategy - Promoted a data-driven approach to risk management and decision-making by providing actionable insights and recommendations based on thorough data analysis - Integrated data from various platforms via APIs, enabling real-time updates to data dashboards - Utilized DAX functions in Power BI for complex measures and KPIs, driving deeper business insights from dashboards - Ensured proper coding of data and seamless information uploads into CRM systems, including Salesforce
    UNT
    Graduate Research Assistant
    Dallas, TX, US
    August 2023 - May 2024
    Sri Balaji Foods
    Data Analyst
    Bangalore, IN-KA, IN
    August 2021 - December 2022
Skills
Languages
EnglishPolish
Skills
A/B TestingAdministrative OperationsAdvertising CampaignsAlteryxAmazon Web ServicesAnalytical ThinkingApache HadoopApache HiveApache SparkApplication Programming Interfaces (APIs)ArchitectureAutomationBig DataBusiness EfficiencyBusiness IntelligenceBusiness ModelBusiness PlanningBusiness RequirementsBusiness StrategiesCachingCarrying out AssessmentsClinical Data RepositoryClinical PracticesClinical ResearchClinical WorksCloud ComputingCommunication SkillsComputer ProgrammingConfluenceConsultingConsumer BehaviourContent DistributionCredit RisksCustomer Loyalty ProgramsCustomer Relationship ManagementCustomer RetentionCustom ReportsDashboardsData AnalysisData ArchitectureDatabase AdministrationDatabase QueriesDatabasesDatabricksData CleansingData Entry SkillsData IntegrityData ManagementData MiningData ModelingData PipelinesData ProcessingData QualityData RetrievalData StreamingData StructuresData VisualizationData WarehousingDecision Making SkillsDefect TrackingDemand ForecastingDemographicsDisease PreventionDistributed SystemsEmployee RetentionExtract Transform Load (ETL)Forecasting SkillsFraud Prevention and DetectionFriendlinessGeographic Information SystemsGitGithubGoogle ApplicationsHadoop Distributed File SystemHealth CareHealthcare SystemsInformation EngineeringInformation SystemsInventory Management SoftwareJIRAKnowledge of FinanceKnowledge of StatisticsLeadershipLinear RegressionLinuxLogistic RegressionLooker AnalyticsLookup TableMachine LearningMacrosManagement of Investor RelationsManagement of StressManual Data EntryMarketingMedical RecordsMetricsMicrosoft ExcelMicrosoft OfficeMicrosoft PowerPointMicrosoft SQL ServerMicrosoft WindowsMicrosoft WordMySQLOncologyOperating ExpensesOperational SystemsOracle ApplicationsOracle DatabasesOutliersPerformance ManagementPersonalizationPersonalized MedicinePharmaceutical DevelopmentPivot TablesPower BIPredictive Data AnalysisPredictive ModellingPresentationsProblem SolvingProcess AutomationProcurement ManagementProduct PlanningProject ManagementPython (Programming Language)QlikviewQuery PerformanceRaw DataReal Time DataRecommender SystemsRelational DatabasesResearch SkillsResource AllocationRisk AnalysisRisk ManagementRoot Cause AnalysisSafety PrinciplesSalesSalesforce.ComSales PlanningSales StrategySales TrendsSAP ApplicationsScalabilitySensorsSnowflakeSocial MediaSoftware QualitySoftware Version ControlSQL DatabasesSqoopStakeholder ManagementStock ControlStrategic ManagementStrategic ThinkingStreamlineSupply Chain ManagementTableau (Software)Teradata SQLText FilesTransaction DataUnstructured DataUser ExperienceVba Programming LanguageVisualizationWeb ScrapingWorkflowsXgboost