Andy Q. Email & Phone Number

Rosemère, Qc, Ca

Montreal, Quebec, Canada

Technical environment: Tableau Desktop/Server/Prep, GCP, Google BigqueryCollecting, cleaning, and transforming data from multiple sources, applying statistical analysis, and creating insightful visualizations and dashboards to drive data-driven decision-making. Gather and align data from various sources to meet business and analytical objectives. Perform data cleaning and preprocessing to resolve missing values, duplicates, and inconsistencies, ensuring high-quality datasets. Structure raw data using SQL, Tableau Prep, and data wrangling techniques, integrate multiple platforms for unified analysis. Design and develop Tableau dashboards and reports to visualize KPI, benchmarking, enhance decision-making across departments. Work with the data delivery team to ensure high quality data pipelines for Tableau Server/Cloud, optimizing performance. Engage with product, sales, client teams to research and develop analytics for innovative product offerings, boosting client satisfaction. Manage end-to-end data analysis projects, from research to production-ready visualizations, ensuring quality deliverables. Assist and train other Tableau creators, providing technical support to non-technical audiences to enhance their use of Tableau.

Montreal, Canada Area

Technical environment: Tableau Desktop/Server/Prep, MS SQL, Python, SSISPrepare analytical databases, design interactive and responsive dashboards, and deliver deep insights to drive business improvements and cost reductions. Analyze requests and design multi-level internal and external reporting structures, including conceptual logic frameworks. Conduct fast iterative testing to ensure data modeling accuracy and effective storytelling. Develop automated data monitoring systems for debugging, testing, cleansing, and quality control. Build databases using SSIS in MS SQL Server or publish workflows to Tableau Server with Tableau Prep, ensuring optimal performance for analytical operations. Create pre-coded data frameworks to anticipate future requests or changes efficiently. Design official dashboards and stories covering various domains such as sales, customers, finance, operations, campaigns, supply chain, dealers, and sales representatives, addressing key questions: "What," "Why," and "How." Implement multi-level dashboard permissions, enabling users at different levels to access relevant information securely. Document standards, reporting workflows, field formulas, training materials, and user manuals to ensure consistency and knowledge sharing. Enhance dashboard usability by developing dynamic and intuitive interactive features. Manage Tableau Server, including group and user setup, role assignments, task scheduling, subscriptions, and permission configurations.

Montreal

Technical environment: Tableau Desktop/Online/Prep, Tableau Prep, MySQLDeveloping comprehensive analytical dashboards covering all aspects of the company, including customer insights, call center performance, sales analysis, customer churn, cost management, employee performance, agent monitoring, product analysis, and website evaluation. The goal is to drive sales growth and minimize losses. Analyze sales funnels from various sources to identify opportunities for improving conversion rates.Map customer journeys and identify factors influencing churn and loyalty. Evaluate retention outcomes to develop strategies for maximizing customer retention. Build models to analyze the relationship between user behavior and registration success rates. Examine data to optimize the close rate for the website and call center. Develop models to identify optimal product combinations and improve employee efficiency. Utilize web data connectors to gather and analyze Facebook data for social media insights. Report metrics such as views, registrations, and purchases using Google Analytics and Tableau. Streamline commission calculations, reducing processing time from 40 hours to 4 hours while increasing accuracy. Optimize website usability by leveraging UX metrics, including expert performance, customer experiments, and A/B testing, to enhance user experience. Manage Tableau Online, including group and user setup, roles, tasks, schedules, subscriptions, and permissions.

Montreal, Canada Area

Technical environment: Tableau, MSBI, SPSS, AMOSProvided services to over 10 different types of e-business clients. Analyzed customers' potential purchasing intentions, enhanced the shopping experience, and developed personalized marketing strategies. Create Tableau dashboards in an agile development environment. Conduct statistical modeling using SPSS, including Correlation, Linear Regression, Logistic Regression, Factor Analysis, Multidimensional Scaling, Clustering, Conjoint Analysis, Time Series Analysis, and more. Refine latent variables and develop Structural Equation Models using AMOS. Integrate and process information from multiple sources, resolve conflicts, and transition between high-level concepts and detailed analyses to provide clear insights. Manage research projects such as brand recognition, customer insights, campaign impact evaluation, consumer segmentation, in-depth customer analysis, business trend forecasting, and sales fluctuation analysis. Develop innovative data processing methods for food delivery GIS systems using Excel macros, reducing processing time from 40 hours to 4 hours. Conduct usability evaluations, A/B testing, prototype design, and data analysis with tools such as Google Analytics.

Hangzhou, Zhejiang, China

Technical environment: SPSS, AMOS, Self-BI Reporting ToolsDeveloping data processing methods tailored to the needs of different internal departments. Creating data analysis tools for both online and offline purposes. Conducting emotional data collection and research to explore new business opportunities.

Beijing, China

Technical environment: SPSS, AMOSCollaborated with various government departments to collect data across multiple dimensions, integrate it, and build a new shared database. Developed public service policies based on data analysis results.

Beijing, China

Technical environment: SPSS, HLMServed over 30 diverse retail clients, leading a variety of retail commercial projects, including shopping malls, department stores, supermarkets, restaurants, highway service areas, and convenience stores. Conducted in-depth studies of their customers, potential customers, and competitors to develop reliable business models that maximize profits.

Certificate, Business Intelligence

Master’S Degree Of Sociology, Major: Statistical Analysis

Master'S Degree Of Transcultural Research, Major: Adaptability Research