OBJECTIVES
  • Translate data into knowledge
  • Transform knowledge into revenue and profit
  • Deliver high-quality data products for customers' needs
　
HIGHLIGHTS OF QUALIFICATIONS
  • Passion for leveraging data as an innovation driver
  • Challenge-seeking, results-oriented analytics leader
  • Proficiency in Business Intelligence Solutions
  • Proficiency in Data Warehousing and Data Modeling
  • Proficiency in Predictive Modeling and Machine Learning
  • Excellent problem-solving skills associated with Big Data
　 　
CERTIFICATIONS
  • Microsoft Certified Solutions Associate (MCSA): BI Reporting
  • Microsoft Certified: Azure Data Scientist Associate
  • Microsoft Certified: Azure Fundamentals
  • Tableau Certified Desktop Specialist
  • CompTIA Project+ Certification (in Project Management)
  • SAS Certified Predictive Modeler Using SAS Enterprise Miner
  • SAS Certified Statistical Business Analyst: Regression and Modeling
  • SAS Certified Advanced Programmer
  • SAS Certified Base Programmer
MCSA: BI Reporting Microsoft Certified: Azure Data Scientist Associate Microsoft Certified: Azure Fundamentals Tableau Certified Desktop Specialist CompTIA Project+ Certification (in Project Management) SAS Certified Predictive Modeler Using SAS Enterprise Miner SAS Certified Statistical Business Analyst: Regression and Modeling SAS Certified Advanced Programmer SAS Certified Base Programmer
　 　
TECHNICAL SKILLS
  • BI Reporting Tools: Tableau, IBM Cognos, MS Power BI, MS SSRS/SSIS, SAP Crystal Reports
  • Data Analysis: SAS (Base/EG/EM), Python, R, SPSS, Minitab
  • Network Analysis: Gephi
  • Database Management: MS SQL Server, Oracle, DB2, MySQL, PostgreSQL, DbVisualizer, Aginity
  • Data Warehousing: MS SSAS/SSIS, Netezza (for Cognos FM/Transformer)
  • Database Programming: SQL, T-SQL, NZPLSQL, Stored Procedure, ETL/ELT, Batch
  • Web Design: HTML, CSS, XML, MS FrontPage, Dreamweaver MX, MS Expression, MS SharePoint, JavaScript, jQuery
  • Operation Systems: Windows, Linux, Unix (SunOS)
  • Programming Languages: C, C++, Java, VBA, Pascal
  • Mainframe Environment: OS/390, z/OS, JCL, IMS DB/DC, TSO/ISPF
  • MS Office Suite: Word, Excel, PowerPoint, Access, Outlook
  • Project Management: JIRA, MS Project, To Do's List
  • Diagramming: Rational Rose, MS Visio, yEd
  • SSH: Tectia, PuTTY, WinSCP
  • GIS: ArcGIS, QGIS
　 　
EDUCATION
    M.Sc. in Mathematics (Probability and Statistics) 2008 - 2010
    School of Mathematics and Statistics
    Carleton University, Ottawa, Ontario
  • Relevant Courses: Time Series and Forecasting, Reliability and Survival Analysis, Multivariate Analysis, Linear Models, Analysis of Categorical Data, Survey Sampling, Mathematical Statistics, Elements of Probability Theory
    M.A.Sc. in Technology Innovation Management Eng. 2006 - 2008
    Department of Systems and Computer Engineering　
    Carleton University, Ottawa, Ontario
　 　
WORK EXPERIENCE
    Senior Data Analyst 2023 - Present
    Bayshore HealthCare Ltd., Toronto, Ontario
    Associate (for MS Power BI projects) 2022 - 2023
    Cognizant Technology Solutions Corporation, Toronto, Ontario
    Research Data Architect 2020 - 2022
    Research Data Analyst 2018 - 2020
    York University, Toronto, Ontario
  • Architect and develop next generation end-to-end BI solutions based on Microsoft Power BI and/or Tableau
  • Build 360o view dashboards (faculty-based via RLS) in an Azure cloud environment while leading solution delivery according to project management practices and agile principles
  • Set up a Tableau BI platform in an on-premise server environment including software/hardware, deployment, testing, and maintenance for faculty-based dashboards
  • Conduct a hands-on comparison on MS Power BI vs Tableau to investigate their functionality, similarities/differences, pros/cons, and pricing
  • Design an evolving path for the BI platform to present input/output/impact indicators and KPIs down to the level of individual researchers
  • Visualize cyclic and ad-hoc reports to track performance and enable users to gain data-driven insights more effectively and efficiently using Tableau, MS Power BI, Python, SAS EG, etc.
  • Restore a web-based management information system (MIS) using the trial-and-error method and parameterized SQL (Stored Procedures) to streamline the data validation process
  • Integrate datasets in various formats from internal and external sources into a single reportable repository based on Oracle, MySQL, and PostgreSQL databases
  • Use SAS and R to conduct statistical analysis for identifying trends, anomalies, patterns, opportunities, and developments
  • Lead a team of analysts to translate business needs/metrics into data collection requirements and generate statistics for benchmarking individual performance against group performance
    Senior Analyst, Business Intelligence 2016 - 2018
    Canadian Imperial Bank of Commerce, Toronto, Ontario
  • Develop, maintain, and update performance dashboards/reports for products and client experience to drive growth
  • Deliver key performance metrics with a 360o view to integrate insights, analyses, and reporting
  • Provide end-to-end BI solutions covering data collection, data warehousing, analytics, data visualization, data mining, and metadata management
  • Convert source code from one programming language (e.g. SAS code including macros) to another (e.g. SQL/NZPLSQL) in order to speed up processes and improve efficiency
  • Organize high-dimensional data for client acquisition/retention, profitability, channels, competitors, and campaign development
  • Evaluate qualitative data, e.g. Client Profile, Product Dimension, and Timing, to identify triggers/opportunities associated with various segments
  • Consolidate high-volume datasets from various data sources and follow/support the data strategy to ensure data integrity
  • Provide enhancements to reporting/analyzing process, performance measurement, and evaluation framework
  • Prepare technical documents and translate them into an easy-to-understand manner for end users
  • Incorporate best practices with technologies, e.g. SAS (Base/EG/EM), Tableau, SQL/NZPLSQL, Oracle, Unix/Linux, Netezza, Cognos, Aginity, and MS Office, into data modeling and BI reporting
    Business Analyst & Data Analyst 2012 - 2015
    Canadian Tire Corporation, Toronto, Ontario
  • Analyze demographic, economic, performance, and other data to evaluate the overall effectiveness of customer experience initiatives and identify the predictors or contributors to retail sales
  • Conduct comparison analysis on store operational performance to find non-performers and identify root causes for variances
  • Conduct pre-post analysis with Control Group vs. Test Group to evaluate the effect of an intervention
  • Manage and deliver standardized reporting in the form of dashboards, scorecards, performance trackers, and Excel based ad-hoc reports
  • Work with Enterprise Data Warehouses (EDWs) and use IBM Cognos to create advanced reports with complex layout, conditional formatting, ratio/KPI calculations, charts, and user interactions
  • Convert existing manual processes and ad-hoc reporting into automated solutions using specialized query and database tools, e.g. SQL, MS Access, MS Excel, VBA, JavaScript, jQuery, SAS, and IBM Cognos
  • Work with mainframe (e.g. TSO/JCL), Unix, DB2, Oracle, and Netezza to compile data into appropriate formats
  • Use SAS (Base/EG) to streamline the analysis processes and extrapolate insights from data
  • Use R to visualize distributions, normalize data, detect outliers (with boxplots), and build regression-based models
  • Develop a Data Entry & Reporting mini system using MS Access, MS Excel, and VBA programming to achieve coordination and consistency in retail by prioritizing activities/initiatives to stores
  • Work collaboratively with stakeholders including front-line managers to identify the drivers of business performance and deliver actionable insights
    Reporting Analyst 2011 - 2012
    Public Services Health & Safety Association, Toronto, Ontario
  • Use IBM Cognos BI tools to extract large datasets from a Data Warehouse and automate KPI calculations
  • Compile data from a variety of internal/external data sources into appropriate formats via MS Excel, MS Access, or MS SQL Server, and conduct statistical analyses for delivering demographics reports
  • Use MS SSIS ETL processes to consolidate data from the Data Warehouse and export data into predefined relational databases
  • Analyze data records in the millions and automate reporting output via SAP Crystal Reports and MS SQL Server Reporting Services
  • Use SQL queries to create/link tables and manipulate datasets via MS SQL Server and MS Access
  • Use MS Excel (including its advanced applications) and R to assist with the delivery of ad-hoc analytics and regular reporting
  • Produce monthly, quarterly, and annual reports by highlighting trends and patterns in various forms, e.g. charts, graphs, and profiles, to provide historical and current views for business areas
  • Collect feedback from internal customers for improving reporting processes
  • Respond to internal customer requests or questions by providing standardized written feedback
  • Develop an information management application via MS Access to set priorities and manage multiple projects or tasks
    Teaching Assistant 2006 - 2010
    Carleton University, Ottawa, Ontario
  • Assist professors in helping students better understand course materials: Business Statistics, Calculus, Linear Algebra, Differential Equations and Infinite Series, Software Product Management, and Interactive Multimedia & Design (IMD) Senior Project
  • Prepare and organize lab sessions to help students use statistical software, e.g. SAS and Minitab, with Linux Gnome or MS Windows desktops
  • Lecture at tutorial sessions to help students analyze and solve math problems step by step
  • Grade assignments/exams and provide written feedback to let students know how to improve their problem-solving skills
  • Answer students’ questions at office hours or by Email to help students with mathematical/statistical concepts, techniques, and methods
  • Help students with the critical path in their IMD project development, including timelines, phases, and milestones
  • Use the Web Course Tools to input and update students’ marks into Carleton’s Learning Management System to assist with grade management
    TFSA Client Service Administrator 2008 - 2009
    MD Funds Management Inc., Ottawa, Ontario
  • Input client information into operational databases in a mainframe environment and open Tax Free Savings Accounts (TFSAs)
  • Verify new opened TFSA details and contact the external bank by Email to correct or update account information
  • Provide follow-up and problem resolution under the guidance of TFSA business policies and procedures to support financial transactions
  • Work closely with team lead to effectively implement solutions
    Research Assistant 2006 - 2008
    Carleton University, Ottawa, Ontario
  • Use a web-based content/data mining method via Google Search Engine to identify the patterns of the innovation projects based on Open Source Software (OSS) that could attract investment from Venture Capital (VC) funds
  • Conduct a quantitative research with sample selection, questionnaire design, web-based data collection, and Factor Analysis to classify 61 VC backed OSS startups
  • Design and create Excel spreadsheets to collect data from the websites of 61 OSS startups for making an existing data source
  • Use SPSS software to import the data sets from Excel, transform and analyze the data, and generate the reports including tables and plots
  • Utilize the statistical theories and application techniques of Factor Analysis to investigate the variables of interest in order to detect and delineate factors
  • Interpret the significant factors emerged from Factor Analysis to contribute new insights about the generic products or services
  • Cluster the companies in the sample using the codes derived from Factor Analysis to show the competitiveness of their market offers
  • Provide evidence that VC funded OSS startups sought to concurrently add value to their customers as well as the external communities
  • Indicate that web analytics on wikis, blogs and forums could help companies identify trends in the activities of users, customers, and developers
　
VOLUNTEER EXPERIENCE
    Webmaster and Data Entry 2007 - 2008
    Easter Seal Society, Ottawa, Ontario
  • Input data into Excel to collect information
  • Use HTML and CSS via File Transfer Protocol (FTP) to create and update the website of Ottawa Charity Ball 2007
　
 

Make a free website with Yola