Business Analyst

Scott Zhu

Analysis Professional

213-***-**** **********@*****.*** LinkedIn ScottZhu

Core Competencies

A results-driven Business Analysis Professional with expertise in data analytics, cross-functional collaboration, and strategic problem-solving, effectively leveraging insights to enhance customer retention, operational efficiency, and market growth across diverse industries

Skilled in Power BI, Tableau, Azure-based cloud solutions, and advanced data tools like Python, RStudio, and Excel, leveraging AWS Cloud and Azure Gen AI to execute data transformations and visualizations that improved reporting accuracy, streamlined response time and provided actionable insights for strategic decision-making Relevant Experience

Capgemini Chicago, IL

Consultant Aug 2023 – Nov 2024

● Data Analysis: Conducted cohort analysis for a healthcare service, finding that a 1-week follow-up increased retention by 25%, leading to a 15% boost in overall customer retention within 3 months

● Cross-Functional Collaboration: Led Azure cloud integration across Finance, Operations, and IT, coordinating 15+ stakeholders to enhance protection, streamline management, and save 10% cost

● Business Intelligence Tools: Transformed financial reporting by digitizing records and centralizing data on SharePoint, cutting turnaround time by 35% with Power BI dashboards

● Project Management: Delivered a finance system revamp on time and within budget, reducing processing time by 30% and user queries by 80% after gathering input from 2,200 employees

● Stakeholder Engagement: Facilitated workshops and maintained consistent communication with stakeholders, incorporating feedback to streamline the expense management process and boost satisfaction University of Michigan Recreational Sports Ann Arbor, MI Membership Service Coordinator - Intern Sep 2022 – Apr 2023

● Effective Communication: Aligned the department on strategic renewal actions by presenting insights on member engagement decline, driving targeted renewal strategies

● Data Visualization: Used Power BI to create dashboards visualizing 55K membership records, revealing a 2% decline in senior memberships after a $4 fee increase, aiding swift leadership action

● Time Management: Prioritized tasks using Agile methodologies, meeting sprint deadlines and maintaining team cohesion while adapting to project demands

● Self-Motivation & Adaptability: Adapted in a fast-paced Agile environment, proactively setting daily goals and adjusting tasks to align with evolving team requirements, ensuring steady progress and on-track delivery Capgemini Chicago, IL

Management Consulting Summer Intern Jul 2022 – Aug 2022

● Presentation: Coordinated 35 projects, evaluated quotations, and created Power BI/Tableau presentations with 15 strategic recommendations, optimizing decision-making for 6 partners and executives

● Teamwork: Supported research on purchasing patterns across four FDS entities for a Fortune 500 food company, coordinating data analysis to identify growth opportunities, resulting in a 15% market share increase Alliance Consulting Group (Concentration: Cross-board E-commercial) Ann Arbor, MI Strategy Case Assistant – Project Jun 2022 – Oct 2022

● Problem-Solving: Implemented multi-language matching systems, boosting response rate by 70% and reducing churn by 80%, enhancing customer retention and engagement

● Creative Thinking & Curiosity: Analyzed cross-border e-commerce data, identifying regional buying patterns and implementing multi-language support and localized bundles, boosting international sales by 15% in the first quarter

● Programming: Applied advanced Excel and Python to benchmark e-commerce platforms, analyzing 200+ rows and 43 e-commerce suppliers, streamlining client processing and creating a novel industry strategy Education

University of Michigan Ann Arbor, MI

Bachelor of Economics and Biopsychology, Cognition, Neuroscience (BCN) May 2023

Contact this candidate