- Managed the B2B product Retail Deposits Optimizer and SQL databases for five banking clients, ensuring the platform
- Worked closely with clients to understand their specific business needs, leading data cleaning, preprocessing, and validation to ensure the accuracy of the analysis and modeling
- Developed and customized SQL functions, views, and stored procedures tailored to clients' specific business needs
- Developed complex SQL scripts for auto-ingestion of ongoing data across client databases, optimizing data
- Integrated client data into Tableau-interface modules and predictive models, collaborating with client success to support client with product and pricing decisions and portfolio performance analysis
- Managed the timeline for a major installation project, using Agile principles to coordinate cross-functional teams
S
Sanctuary Ventures
Product Growth Analyst
New York, NY, US
August 2021 - March 2022
I
Impact Capital Forum
Digital Marketing Analytics Intern
New York, NY, US
June 2021 - August 2021
R
Re Build a Digital Identity for Animal Sanctuary
Team Lead/UIUX Designer
New York, NY, US
August 2020 - June 2021
H
Hotel Cancellation Forecast
April 2020 - April 2020
Skills
Languages
ChineseEnglishJapanese
Skills
A/B TestingAgile MethodologyAlgorithmsAnimal ProductionBanking ServicesBrand ManagementBrazing of MetalsBusiness AnalysisBusiness RequirementsBusiness StrategiesBusiness to Business CommerceCascading Style Sheets (CSS)Competition AnalysisComputer ProgrammingConfluenceCreativityCultural ActivitiesCustomer Data ManagementDashboardsData AnalysisData CleansingData ManagementData ScienceDeposit AccountsDigital IdentityDigital MarketingDigital MediaForecasting SkillsGoogle AnalyticsHTMLHuman-Computer InteractionInformation TechnologyJava (Programming Language)JavaScript (Programming Language)JIRAKey Performance IndicatorsKnowledge of AdvertisingKnowledge of CampaignsKnowledge of EngineeringKnowledge of StatisticsMachine LearningMarketingMarketing AnalyticsMarket ResearchMatplotlibMetricsMicrosoft ExcelMicrosoft SQL ServerMySQLPerformance ManagementPredictive Data AnalysisPredictive ModellingProject ManagementPsychologyPush TechnologyPython (Programming Language)Retail CommerceScikit LearnScrum MethodologySocial MediaSQL DatabasesSQL Stored ProceduresStrategies of PricingSurveysTableau (Software)Usability TestingUser ExperienceVba Programming LanguageWeb Traffics