Jiaqi He

Location

Chicago, IL
Education
    University of Chicago
    September 2024 - December 2026
    expected degree
    Bachelor's
    major
    Statistics
    minor
    Computer Science
    University of Illinois
Work Experience
    Wells Lamont
    Business Intelligence Analyst Intern
    Skokie, IL, US
    June 2024 - August 2024
    company
    Wells Lamont
    title
    Business Intelligence Analyst Intern
    overview
    - Automated file handling process by developing EDI file processing python script, eliminating manual intervention and improving efficiency, reducing workflow times by 75 - Designed performance dashboards for over five clients using PowerBI, enhancing data-driven decision-making - Leveraged SQL to extract and validate data from ERP systems, ensuring dashboard accuracy and reliability - Collaborated with cross-functional teams to centralize outsourced data, developing and implementing an ETL process into a MySQL database, improving data accessibility and streamlining reporting - Parallelized the end-to-end script using multiprocessing to decrease computation time by 60
    PricewaterhouseCoopers
    Core Assurance Intern
    Shanghai, CN
    July 2023 - August 2023
Skills
Languages
ChineseEnglish
Skills
AccountingAmazon Web ServicesAnalysis of Variance (ANOVA)Application Programming Interfaces (APIs)AutomationBackup DevicesBadmintonBusiness IntelligenceBusiness StrategiesCommand-Line InterfaceCommunication SkillsCompetition AnalysisComputer ProgrammingC++ (Programming Language)Customer ExperienceDashboardsData AnalysisData CleansingData QualityData ScienceData StructuresDecision Making SkillsEnterprise Resource PlanningExtract Transform Load (ETL)Feature EngineeringFile SystemsFood PreparationGenerative AIGitHuman-Computer InteractionInformation TechnologyJava (Programming Language)Knowledge of FinanceKnowledge of StatisticsLinear AlgebraLinuxLinux CommandsMachine LearningMarket ResearchMatplotlibMentoringMicrosoft ExcelMultiprocessingMySQLNumPyNutrition and DieteticsPandasPower BIPredictive ModellingProbability and StatisticsPython (Programming Language)PytorchRandom ForestRecords ManagementRegression AnalysisReliabilityResource AllocationScikit LearnSoftware Version ControlSQL DatabasesStochastic ProcessStrategic ThinkingStreamlineTeam WorkingTensorflowTime SeriesUnix ShellUser ExperienceVisual PerceptionWorkflowsXgboost