Professional Experience
Junior Business Analyst
Sep.2023 - Current
• BI Reporting: Designed and maintained robust models to forecast and analyze KPIs across multiple business lines, providing actionable insights and strategic recommendations to senior management.
• Variance Analysis: Conducted variance analysis for revenue reports, providing actionable insights to senior management to align financial performance with company objectives.
• Process Optimization: Led the redesign of a complex KPI reporting process, collaborating with IT to implement a new SQL Server Reporting Services (SSRS) solution, significantly reducing human errors and enhancing reporting quality.
• System Migration: Played a key role in the migration of the invoicing system from ViewPoint to SAP S/4HANA, ensuring seamless data consolidation and integration with financial systems.
• Automation: Automated Excel reporting with Macro/VBA and Power BI, improving efficiency and reducing manual intervention
Skills: Excel with VBA, Power BI, SAP S/4HANA, SQL.
Specialist, Rapid Application Developer
Feb.2023 - Aug. 2023
• App Development: Developed web application for audit purpose using low code platform (Outsystems).
• Data Analytics: Leveraged SQL to optimize data queries within OutSystems, enhancing application performance and ensuring efficient data processing for improved scalability and responsiveness.
• Dashboard Development: Collaborated with stakeholders to gather requirements and deliver data-driven insights through custom dashboards and reports.
• Communication: Collaborated with product and RPA and product teams to understand business needs and ensure successful project execution.
Skills: Outsystems, SQL, JavaScript, CSS, HTML, Business communication, agile working methodologies, DevOps.
Intern, FP&A Business Analyst
Jan. 2022 - June. 2022
• P&L Management: Assisted in compiling and categorizing expense reports for the Operating Expenses (Opex) section of the P&L statement, directly impacting net profit calculations.
• Variance Analysis and Cost Control: Conducted detailed analysis of actual expenses versus forecasted and budgeted figures to identify cost-saving opportunities, enhancing organizational efficiency and driving financial performance improvements.
• Reporting Enhancement: Led the transition of financial reporting from Excel to Power BI, improving data visualization and accessibility for stakeholders.
Consultancy Volunteering
May. 2021 - Sep. 2021
• Conducted SWOT and Porter’s 5 Forces to understand where our client company is positioned, the challenge and room for improvement within process mining industry.
• Developed a marketing and lead generation map for our client company.
Graduate Teaching Assistant
Aug. 2018 - Dec. 2020
• Served as a primary instructor for Principle of Macroeconomics (ECO 202). Conducted training for an online class of 21 students in summer 2020.
• Led weekly recitation sessions for ECO 602 Macroeconomic Theory (PhD class) to help first-year PhD students solving problems
• Aided professors in developing lesson plans, grading, and responding students’ emails for a variety of undergraduate courses including International Trade, Industrial Organization, and Business Statistics.
Econometrics Teaching Assistant
Jan. 2018 - May. 2018
• Graded students’ assignments and provided feedback to course instructors.
• Instructed Stata and R evening lab sessions and was responsible for Q&A for a group of 40 students.
Summer Internship
July. 2016 - Sep. 2016
• Responsible for collecting start-ups information in Czech to prepare for upcoming innovation week 2017.
• Collected survey data and prepared information database of ~100 companies using excel.
Project Experience
In addition to the listed professional experience above, Zishen also has several project experience working with various data technique and software. Please click below or refer to the GitHub repository for more details.