With a Master's degree in Business Analytics from Northeastern University and a Bachelor's degree in Computer Science and Technology from Shanghai Dianji University, I have honed my analytical and problem-solving skills to deliver data-driven insights. My most recent role as a Management Consultant Intern at Accenture involved managing a substantial SQL database and leading a team to enhance user satisfaction with PowerBI dashboards, underpinning my competence in data analysis.The organization benefited from my capacity to synthesize complex industry data into actionable intelligence, a skill I demonstrated while delivering key business decisions at Shanghai Focus Investment. We embraced diverse perspectives, aligning with the company's culture and contributing to our collective success. My motivation is to continue leveraging analytical excellence to empower teams and drive strategic outcomes.
Vigi Corp
-
Financial Planning AnalystVigi Corp Oct 2022 - Present Managed month-end closing, revenue forecasting, and annual budgeting reports for Photography Company by conducting variance and trend analysis using Excel (VLOOKUP, pivot tables). Automation and standardization of financial reporting process in Marco. Utilized SAP for journal entries and month-end result reviews, preparing adjusting entries as needed. Managed using SAP HANA, improving reporting management accuracy by 15%. Collaborated with sales & marketing teams to identify $500K inefficiencies in cost savings by analyzing actual and predicted revenue and cost data. Performed financial metrics analysis, incorporated assumptions into forecasting models, renegotiated shooting contracts, reduced 10% in material costs. Implemented customizable Tableau dashboards to report on key inventory KPIs (including net margins, gross profit, and current ratios) across all product lines. Leveraged advanced analytics to visualize client retention rate and sales growth rate, helping leadership make future decision. Conducted comprehensive ad-hoc analysis on profitable shooting portfolios and created monthly reporting packages for stakeholders. Delivered in-depth financial analysis, including product performance against targets and strategic recommendations, resulting in a 15% improvement in overall product profitability.
-
Management Consultant InternAccenture Jun 2019 - Sep 2019Dublin 2, Ie1. Conducted a comprehensive industry analysis on Turkey's electric power sector and synthesized findings into detailed reports.2. Managed a relational SQL database with over 100GB of industrial data.3. Led a team of 7+ interns in analyzing financial data and performance metrics, resulting in a 20% increase in user satisfaction through effective dashboard presentations in PowerBI. -
Research AnalystShanghai Focus Investment Jan 2019 - Apr 20191. Researched Xiaomi's venture into AI home appliances and extracted over 8k rows of financial data using Python and HTML.2. Conducted SWOT analysis and developed Tableau dashboards to visualize Xiaomi's market potential.3. Delivered 7 actionable business decisions that were adopted by the firm.
Yilun Luo Education Details
-
Northeastern UniversityBusiness Analytics -
Shanghai Dianji UniversityComputer Science And Technology
Frequently Asked Questions about Yilun Luo
What company does Yilun Luo work for?
Yilun Luo works for Vigi Corp
What is Yilun Luo's role at the current company?
Yilun Luo's current role is Master of Science in Business Analytics, Northeastern University, D'Amore-McKin School of Business | B.S in Computer Science and Technology.
What schools did Yilun Luo attend?
Yilun Luo attended Northeastern University, Shanghai Dianji University.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial