Melody Ho Email & Phone Number

Calgary, Alberta, Canada

Greater Minneapolis-St. Paul Area

• Extracted weekly around 2 million records of voting history and demographic data from multiple sources. Cleaned and transformed the data using SQL, including handling missing values and outliers. Designed and.
• Engineered over 80 features each week as inputs for model training, utilizing SQL & Python in Databricks.
• Constructed over 800 machine learning models using SAS Enterprise Miner to classify voter data into categories, using techniques such as Neural Networks and Linear Regression. Features used in the models included.
• Analyzed machine learning predictions with Python and Power BI to evaluate fundraising project outcomes. Identified four key factors that impact fundraising performance and proposed targeted actions like suppression or.

Minneapolis, MN

• Managed compensation and fee structure data for over 50 rapidly growing service lines using Excel and SQL. Independently created more than 300 clinician compensation models within two weeks.
• Performed variance analysis for earnings and expenses forecasts by analyzing trends in financial data from the past five years. Visualized patterns using Excel PivotTables and Charts, and leveraged insights to optimize.
• Created a Power BI dashboard for Profit and Loss analysis, using service provider bill and weekly consumption reports as data sources. Consolidated and processed over 3,000 service provider reports using Excel within.

Rochester

• Provided advisory services to more than five clients on the potential market value of their products, estimating a combined value of over $600M. Created a revenue forecast model based on regression analysis in Excel.
• Secured $750K in funding by identifying potential investors and providing personalized investment advice while serving as a liaison between Project Planning & Capital Planning teams.
• Strengthened the management team's understanding of the IND process rollout by tracking milestones and identifying potential roadblocks using Excel spreadsheets. Presented findings in weekly review meetings to inform.

Rochester, New York

• Developed a comprehensive valuation model and investment pitch for Target (TGT), BlackRock (BLK), and VF Corporation (VFC), resulting in informed investment decisions for clients.
• Conducted Monte Carlo simulations to evaluate portfolio exposure and established bottom-line portfolio construction criteria for three different asset classes, ensuring optimal risk management and portfolio performance.

Shanghai

• Conducted a thorough financial analysis of the client's assets, validated cash balances, and reviewed expense and non-operating income items. Discovered incorrect entries and proposed potential remediation plans to.
• Assessed the client's financial health by evaluating solvency and liquidity metrics, computed interest coverage and debt-to-equity ratios from projected balance sheet and cash flow statement using key indicators in.
• Designed and recommended cross-collaboration and optimization strategies worth $25M for the Industrial Bank Department to facilitate the bank's integration with its supply chain.

Beijing

• Mitigated investment risk by conducting a thorough analysis of the individual structures and asset situations of 15 subordinate companies in a CMBS project, resulting in informed investment decisions for clients.
• Projected cash flow from asset pools by utilizing market trends and changes in the commercial rent market to forecast future earnings for a $200M loan, ensuring optimal returns for investors.

Beijing

• Conducted advanced analysis of profit and loss by updating the net value of 26 quantitative fund products daily, resulting in accurate tracking of investment performance for clients.
• Ensured financial control effectiveness by monitoring return volatility against benchmarks, resulting in improved risk management and performance evaluation.
• Generated comprehensive back-testing reports for hypothetical transaction strategies and fund products, providing valuable insights for investment decision-making and risk management.

Master'S Degree, Master Of Finance

Bachelor'S Degree, Finance, General