● Cash Management: Analyzed cash position using Liquidity Ratios in Excel to forecast future cash flows, and conducted daily cash summary by leveraging Excel, including VBA and Macro to streamline reporting, enhancing reporting efficiency by 10%● Credit Analysis: Analyzed credit availability via Debt-to-Equity Ratios in Excel, assessed remaining balance to sustain business growth and balance long-term needs with day-to-day transactions● Investment Analysis: Calculated the ROI and VaR of company’s investment projects in Excel to quantify and mitigate potential risk, conducted SWOT, 3C, and 4P analysis to assess both internal and external factors that might affect the company● Dashboard Development: Developed interactive financial dashboards and reports by linking external data to Excel and incorporating filters and features in PowerBI to allow for customization, providing insights into cash flow and investment return situations, and identifying opportunities for optimization and minimizing potential risks

-Analyzed population centers in North Carolina to generate key insights to guide resource allocation -Developed correlation analysis by building regression models in R to provide marketing advice. -Conducted marketing analysis by gathering over 10,000 rows of raw data to analyze county attributes in North Carolina, applied various functions in Excel to perform exploratory data analysis and a reproducible Market Opportunity Model.

● Financial Analysis: Analyzed target companies’ financial performance through Liquidity Ratio, Debt-to-Equity Ratio, Gross Profit Margin, and Operating Income from income statement and balance sheet to assess financial health and evaluate performance● Risk Management: Examined and verified the integrity of target companies by conducting Cash Flow Analysis and Risk assessment including market risks, industry risks, and operational risks to identify potential risks and opportunities ● Planning: Engaged in company’ planning cycle based on historical data by meticulously updating pertinent data into the ERP system● Predictive Model: Implemented predictive models for Bond trading in Excel, utilized historical market data and financial indicators to forecast bond price movements, enhancing financial projects and yielding a 5% improvement in anticipated returns● Operation Optimization: Streamlined due diligence activities, including preparation of bond financing documents and monitoring Key Performance Indicators (KPIs), and ensured accuracy and timeliness in information management, reducing processing time by 25% and increasing operational efficiency by 10%, while maintaining 100% compliance with regulatory standards