Miranda Li Email & Phone Number

Stamford, Ct, Us

Port Washington, New York, Us

Garden City, Ny, Us

• Analyzed daily shipping and energy related data from global markets and wrote the analysis summary; Built demand and supply models for the market forecasting projects by using Excel to support service of Global Office • Conducted ad-hoc research and data analysis to generate analytical reports in Excel for clients including ExxonMobile, Shell, and BP; Collected complex petroleum markets data for 150+ global employees and clients by using Excel to provide timely data updates to improve the efficiency of service• Cleaned the data from EI, IEA, and GTIS, and updated maritime database of company using Advanced Excel and SQL; optimized procedures to clean and process AIS data for further data analysis by coding SQL statement to support service group• Summarized industry news chosen from Reuters, Fairplay, etc. for the past of week to compose a weekly report; collaborated to support analysis and forecast work of projects by Excel to improve the effectiveness for service group

Mineola, New York, Us

• Collected updated data for clients’ loan properties from lending department and built new spreadsheets to recalculate tax, insurance, deposit by using Excel; Updated clients’ database in JH banking system to optimize clients’ loan files including Mortgage, Loan Statement, etc. and improve the effectiveness of loan servicing for lending department • Advised to use SQL to get effective information from clients’ database with enhancing 20% of effectiveness for loan department; Built fallout reports as the database by tracking clients’ renewal insurance policy from agency and integrating data for property inspection from DOB website data pool• Filled the Booking Form for closed residential and commercial loans by reading loan documentations and estimated monthly escrow amount and initial deposit based on prior calculations of interest, escrow, premium, and tax by using Excel to upper management; Supervised and examined the completed Booking Forms from other interns• Verified loan reports that outline financial activity and spreadsheets that summarized for monthly, quarterly and yearly financial reports, tax returns by using Pivot table and Vlookup in Excel for loan department

Shenzhen, Guangdong, Cn

• Promoted financial products to clients by creating marketing campaign that yielded sales by 10% -15% over five months; Provided financial advice to meet the clients’ individual requirements based on analysis of clients’ individual needs • Forecasted the value of clients’ financial securities according to gathered client’s financial reports and education clients on reporting metrics by using Excel for finance manager, and interpreted analysis to clients to meet their requirementsReviewed clients’ credit reports to build new spreadsheets with calculation and analysis about clients’ assets, deposit, mortgage, etc. by using Excel for loan department and finance department

New York, New York, Us

• Led 5 members team collaboratively to investigated residents and workers to identify high-income groups, business requirements, and customer preferences in certain potential areas to determine a location for new branch office• Conducted analysis by using the branches' relevant data for past 5 years from 10-K reports to predict the risk with returns on common equity analysis, project budget calculation, and SWOT analysis by using Excel and PowerPoint• Achieved the goal set by the new branch and presented to project manager; Awarded to assist in project management

Master Of Business Administration (Mba), Business Analytics

Master Of Business Administration (Mba), Finance