Yingxia Mao

Location

Atlanta, GA
Shanghai, People's Republic of China
Education
    Washington University in St Louis
    September 2021 - December 2022
    degree
    Master's
    major
    Statistics
    SHANGHAI UNIVERSITY
Work Experience
    NTG
    Analyst
    Atlanta, GA, US
    February 2023 - March 2024
    company
    NTG
    title
    Analyst
    overview
    - BI and data insights - Implemented and optimized over 80 strategic PowerBI dashboards and SSRS reports task in Jira board using connection with Snowflake, AWS, Oracle and Salesforce database, bringing 20% lift in loads booked, 36% increase in new TMS deployment rate and accurate AR and AP accounting reporting - Built a test analytics dashboard to monitor feature change of online A/B test on TMS user interface, troubleshooting analytical issue and ensuring the alignment of the business goal - Created a churn customer alert system and identify key factors of churn to increase 8% brokerage retention by using time series k - Built ETL data pipelines for a newly acquired company using sqlalchemy, urllib, pysftp, pyodbc, pathlib Python packages and scripting to extract data from one drive excel, reprocess data and load into SQL server, reducing manual workload by 90% and improving
    Spreetail eCommerce Wholesale Company
    Data Analyst Intern Cross Border Business Development Team
    July 2022 - August 2022
    Emerson
    Data Analyst Student Consultant
    St. Louis, MO, US
    May 2022 - August 2022
    MEDTRONIC
    Data Analyst Channel and Business Operation Department
    Shanghai, CN
    January 2021 - June 2021
Skills
AccountingAlteryxAmazon RedshiftAmazon S3Amazon Web ServicesAnalytical ThinkingApache HiveAutomationBig DataBrokerageBusiness AnalysisBusiness DevelopmentCatering ActivitiesCloud ComputingCustomer RetentionDashboardsData AnalysisDatabase DesignDatabasesData PipelinesData ProcessingData TransformationData VisualizationDecision Making SkillsDeep LearningE-CommerceEmployee RetentionExcel Pivot TablesExtract Transform Load (ETL)Feature SelectionForecasting SkillsHadoop Distributed File SystemHealth CareHuman-Computer InteractionInformation EngineeringInventory Management SoftwareJIRAKnowledge of FinanceKnowledge of ImmunizationKnowledge of Purchasing ProcessesLogistics OperationsMaintenanceManagement of ChangesMatplotlibMetricsMicrosoft ExcelMicrosoft PowerPointMicrosoft SQL ServerMySQLNoSQLNumPyOracle ApplicationsPandasPerformance ManagementPower BIProblem SolvingProgramming LanguagesPysparkPython (Programming Language)Random ForestRegional DevelopmentReliabilityRetention RateSalesSalesforce.ComScikit LearnScriptingSelf MotivationSnowflakeSQLAlchemySQL DatabasesSQL Server Reporting ServicesStakeholder ManagementStreamlineTableau (Software)TensorflowTime SeriesUser GuideVba Programming LanguageWeb AnalyticsWholesaling