Business Intelligence Analyst

• Jun 2022 - Present

Advanced Business Intelligence Training

• Feb 2022 - Jun 2022

• Identified business requirements in sales, built Star-Schema (Conceptual -> Logical -> Physical Model), laid out Business Matrix, and created Power BI report for storytelling and analysis Skills: Excel, Power BI, Dimensional Modelling, DAX, Time Intelligence, Role-Playing Dimensions • Identified business requirements in sales, built Star-Schema (Conceptual -> Logical -> Physical Model), laid out Business Matrix, and created Power BI report for storytelling and analysis Skills: Excel, Power BI, Dimensional Modelling, DAX, Time Intelligence, Role-Playing Dimensions

Business Intelligence Trainee

• Oct 2021 - Feb 2022

Topics: SQL, Power BI, Data Warehouse Concepts, Extract, Transform, Load (ETL), Agile Methodology • Identified and analyzed user needs, user persona, and user journey; developed Entity Relationship Diagrams and wireframes • Designed the ETL process and implemented SQL data warehouse with SSIS, SSMS, and Microsoft Visual Studio • Created Power BI dashboards from SQL server data and presented them in storytelling manners Topics: SQL, Power BI, Data Warehouse Concepts, Extract, Transform, Load (ETL), Agile Methodology • Identified and analyzed user needs, user persona, and user journey; developed Entity Relationship Diagrams and wireframes • Designed the ETL process and implemented SQL data warehouse with SSIS, SSMS, and Microsoft Visual Studio • Created Power BI dashboards from SQL server data and presented them in storytelling manners

Finance BI Intern

• Jul 2020 - Jan 2021

Focus area: Finance and Sales BI Reporting and Automation (Power BI), Financial Reporting and Analysis (Advanced Excel) • Gathered and analyzed business requirements from key stakeholders and designed Dimensional Data Models with Star-Schema • Streamlined and automated Power BI ETL processes, developed dashboards and told compelling data stories in presentations • Assured quality and accuracy of deliverables by thorough stakeholder coordination to understand and refine requirements • Empowered frequent business monitoring by increasing task efficiency by 95%+, and trained Power BI users for analytic needs Show less

Financial Modeling Project

• Apr 2019 - May 2019

• Assigned tasks to 4 teammates, provided feedbacks and advice on their work and ensured high quality of the model by checking every step and detail • Selected 10 stocks from 4 countries based on returns and covariances and calculated the optimal portfolio weights by maximizing Reward-to-Risk Ratio using Excel Solver • Analyzed the cash flows of 4 properties, tracked the portfolio value over time, and mentored 2 teammates in creating a dashboard including Combo Box and Macros • Ranked No. 1 among 10 teams by managers and the professor and received a job offer of Teaching Assistant for the Financial Modeling Course Show less

Supply Chain Financial Modeling Project

• Jan 2019 - May 2019

• Addressed the challenge of unforeseen fluctuating monthly income by constructing a flexible Excel model capable of computing future income based on index predictions • Enhanced profit visibility by breaking down monthly income into contract income and product income and increased application range to all 4 review-period mechanisms and over 200 products • Utilized strong public speaking skills to present the model to the headquarters management team • Helped managers to strategically plan and optimize budgets, enabled the procurement team to negotiate longer-term contracts, and reduced negotiation time by approximately 30% Show less

Procurement Project

• Nov 2018 - Dec 2018

• Coordinated corporate interactions, group meetings, and deadlines to ensure the quality of RFP • Collaborated with 4 teammates to develop selection criteria, identified 5 appropriate Ethernet Switch suppliers across the world, and conducted supplier evaluation using AHP Method in Excel • Coordinated corporate interactions, group meetings, and deadlines to ensure the quality of RFP • Collaborated with 4 teammates to develop selection criteria, identified 5 appropriate Ethernet Switch suppliers across the world, and conducted supplier evaluation using AHP Method in Excel

Marketing Video Buyer

• Dec 2017 - Jan 2018

• Inquired the management’s needs, collected information of 7 video production companies, and evaluated potential suppliers based on needs • Initiated meetings with potential suppliers and communicated marketing video purposes— attracting more customers and increasing loyalty • Negotiated prices and selected the supplier, lowering 25% of the contract price, and managed video production schedules and post-production editing to satisfy the management’s demands • Inquired the management’s needs, collected information of 7 video production companies, and evaluated potential suppliers based on needs • Initiated meetings with potential suppliers and communicated marketing video purposes— attracting more customers and increasing loyalty • Negotiated prices and selected the supplier, lowering 25% of the contract price, and managed video production schedules and post-production editing to satisfy the management’s demands

Entrepreneurial Consulting Project

• Jul 2016 - Aug 2016

• Communicated with the management, analyzed the capital shortage challenge, discussed solutions with 4 teammates, and drafted business strategy together • Gathered information of more than 20 investment funds, sifted out the suitable fund, and recommended it to the management • Researched policies of state and local governments, constructed the optimal tax plan, and assisted in transferring grants • Communicated with the management, analyzed the capital shortage challenge, discussed solutions with 4 teammates, and drafted business strategy together • Gathered information of more than 20 investment funds, sifted out the suitable fund, and recommended it to the management • Researched policies of state and local governments, constructed the optimal tax plan, and assisted in transferring grants