Senior Business & IT Analyst

• Mar 2022 - Present

Business & IT Analyst

• Jun 2020 - Feb 2022

• Performed data extraction, transformation, and analytics from multiple data sources including Salesforce, SQL Server. Made 30+ automate reports accessible on Tableau. Improved reports automation by 20%.• Enabled data visualization and identified potentials to yield higher profit margin by managing the overstock inventory & sales analysis by product. Proposed 3 promotions to help increase sales amount and clear overstock inventory and support management decisions.• Supported programmers to develop and maintain an enterprise-class custom web-based information system as part of a highly driven team that supports over 1500 companies and 8000 users worldwide. Helped create & go live 5 new functions on the website to make business process more logical and efficient. Help improve the ecosystem of deployment, test, and user experience.• Designed customer facing reports. Managed over 10k customers’ profile on Salesforce. Build up dashboards and reports to improve sales team performance. Show less

Supply Chain Analyst

• Aug 2019 - Dec 2019

Engaged in a 4-month Experiential Learning Program with Jabil Manufacturing. Worked with Jabil management and a student team to create outsource solutions and cost management. • Developed a Master Schedule that generated an MRP (Manufacturing Requirements Plan) that incorporated various factors like changes in daily demand, package size, and shipping logistics to determine needed materials from suppliers. Master Schedule improved overall supply chain flexibility and enabled analysis of the effect of different changes in the supply chain. • Analyzed the cost of storing raw materials in-house verses utilizing a 3PL (3rd Party Logistics). Concluded that Jabil would save $120k using 3PL. • Sorted over 5000 rows of data to schedule daily production shipments of 300+ individual parts. • Presented solutions at the conclusion of the internship to Jabil’s CEO and other key leadership. Leadership was pleased with our analysis and indicated they would use quotation data in future negotiations with suppliers. Show less

Business Development Analyst

• Jul 2019 - Aug 2019

China Telecom is one of the 3 leading telecom operators in China, delivering high-quality data and voice solutions and services between the Americas and China to businesses and carriers. committed to providing unparalleled service and support. • Worked directly with regional managers in developing CTA’s mobile business on 7 FL local campuses. Built strategic relationship with influential communities in target customer group, such as GatorPool, and CSA. • Analyzed 6 years of sales data across the US colleges to set sustainable development goals for UF, sold over 1000+ items • Directed promotional events on and off campus, to increase brand awareness. • Improved sales rate by 20% compared to Summer 2019. Earned Top Performance Certification. Show less

Conference Assistant

• May 2019 - Aug 2019

UF Conference Services team at the Department of Housing and Residence Education helps provide on-campus housing, facilities and planning for conferences, summer camps, internships and guests of the University of Florida. - Consulted with customers to determine objectives and requirements for events, such as meetings, conferences, and conventions. - Managed inventory and maintained records of event aspects, including financial details, through Sharepoint. - Planed and developed programs, agendas, budgets, and services according to customer requirements. - Met with sponsors and organizing committees to plan scope and format of events, to establish and monitor budgets, or to review administrative procedures and event progress. Show less

Marketing Analyst

• Jun 2018 - Jul 2018

Kailuan Co. is a boutique import/export firm specializing in wine, beef, and luggage. Clients include a major restaurant chain with operations in China nationwide, as well as suppliers in Australia and Russia. - - Responsible for projects in supply chain optimization, market research, documentation, and finance. - Researched popularity and profitability of different wine and beef varieties, reporting findings to marketing manager; analysis informed leadership decisions about which products to buy in ~$65K order. - Identified 20% shrinkage of wine orders shipped by sea. Coordinated with financial manager to project consequences and possible solutions, ultimately recommending transition to shipping by air. Leadership followed recommendation, eliminating shrinkage. - Prepared financial statements and projections to support finance department in loan negotiation with Hong Kong bank; based on financials, bank approved loan amount increase of $125K. Show less

Customer Relationship Intern

• Feb 2017 - Aug 2017

Aspire Lifestyles is a leader in B2B Benefit Solutions and Concierge, providing custom-built services. Responsible for developing promotions worldwide and providing best customer services. - Evaluated modern youths’ lifestyles and consumption patterns, correspondingly established cooperative relationship with relevant merchants - Developed 90 promotion events between Visa & UnionPay with overseas firms, such as the United States, Singapore, Thailand. - Followed up subsequent cooperation matters, such as service training. Received 45% more of “WOWs” from the premium customer. - Collected and analyzed usage amount data, and sorted into usage report - Supported marketing group to hold Aspire Club that gathered ~1000 people including the CEO of Banyan Tree. Show less