Grace Chen
Vancouver,BC
Summary
Motivated, teamwork-oriented, and responsible Data and System Analyst with experience in comprehensive SEM and MRS data metrics reporting. Highly educated, possessing a bachelor's, a master’s and professional certification in Statistics and Data Analytics.
Overview
10
10
years of professional experience
Work History
Security Analyst
BC Hydro
Burnaby, BC
05.2023 - Current
- Design HydroShare site by segment functionalities, form design in InfoPath, Implement SharePoint workflows by collaborating with HydroShare Tier 3 and SNOW.
- Gather, aggregate and report metrics in scorecard of PIQs, project triages and security compliance-related investigations.
- Maintain user access and permission to HydroShare PMO site and Tableau reporting sites (PROD and DEV) by establish business rules and procedure manual.
- Communicate with Tableau-DL on improvements of dashboard performance, and data extract maintenance for efficient publishing.
- Create and sustain SEM Business Calendar by Outlook group mailbox data gathering, stakeholder communication in RACI, reporting design approval, go-live maintenance and permission control.
- Engage with other groups in SEM to facilitate data collection and report preparation, includes CIP Compliance and Physical Security by accessing protected business related data sources in SAP. In Charge of project triages part in departmental monthly metrics reports.
- Monitor adherence to new and revised processes and procedures, including the preparation of process maps, charts and workflows for new and current processes.
- Identify opportunities for continuous improvement of reporting infrastructure and process to management.
- Onboard from PPM, Business Application, Leadership Training teams of new project and technology related knowledge.
IT Reporting Data Analyst
BC Hydro
Burnaby, BC
09.2021 - 03.2023
- Analyze BI needs, interpret user requirements, data gathering, data entry and cleaning in SharePoint and Excel, design and create Tableau visualization for projects.
- Design and User Acceptance Testing on designing sites and libraries, cleaning up the documentation library, and archiving files to save workspace in SharePoint Maintain Tableau reports by daily extract refresh and schedule server refresh schedules on tracking incidents and mitigation plans.
- Implement data source joins, relationships, LOD calculated fields in SQL- -based query and parameters and manage Tableau Production and Testing environment permission levels for stakeholders.
- Build metrics and reports in dashboard and story formats in Tableau by using stack bars, text tables, packed bubbles, line graphs, calendar view, Gantt Charts, Heat Map, etc.
- In charge of MRS Applicability Tool project technical support on VBA codes and version control with the third-party vendor Coordinate BCSI Storage-RC SharePoint Access Management Annual Review project, including communication with stakeholders, submit Service Now revocation tickets, document evidence and business reasons.
- Implement Quality Assurance Testing to ensure documentation meets no-penalty criteria from WECC.
- Corporate with Server Admin deploy the new version of Tableau Server on regression testing, follow the best practices on optimization for Tableau Server Performance Integrate Tableau reports into SharePoint.
- Document on job aids, process maps, and training manuals of products and projects.
Information System Business Analyst
Top Consulting Group
Vancouver, BC
06.2018 - 01.2020
- Monitored project milestones and provided administrative support
- Data Analysis experience with SQL Server and Excel, ability to do manipulation on cell-formatting, shortcuts, sort and filter, commonly used functions including statistics, financial and database functions, subtotal and pivot table, charts, scenario summary, goal seeker, data analysis toolpak and recording procedure in Marcos
- Developed dashboard reports in PowerBI with power query in excel, integrating different source data, and getting dynamic results on KPIs and grouped statistics general reports
- Experience with Tableau desktop and Prep on reporting
- Assisted IT on technically transferred client needs and err on side of caution and warn management of the possibility of problems
- Generated documentation on business process improvement in SDLC, client requirements, develop DFDs in Visio, training manuals, and all necessary documentation
- Familiar with both traditional workflow in Waterfall and Agile sprint
- Facilitated with IT development HR system in SDLC, from planning with SWOT analysis, feasibility investigation, requirement modeling, UI design, and data registration until go-live testing, which allowed internal clients to self-serve their needs, manage and check agenda, access payroll, and changing personal information.
Customer Service Representative
Bank of Communications Tianjin
05.2016 - 09.2016
- Served as liaison between customers, various store departments, and management
- Educated customers in products and service offerings
- Offered exceptional customer service and promoted company brand
- Answered customer telephone calls promptly to avoid on-hold wait times.
Tutor
University of Victoria, Math Help Centre
Victoria, BC
05.2014 - 08.2014
- Assessed learners with math anxiety disorders and provided appropriate solutions with exercises
- Established high-level of proficiency in Calculus, Algebra and Proof concepts
- Collaborated with students to complete homework assignments, identify lagging skills, and correct weaknesses.
Education
Master of Science - Applied Data Analytics
Boston University
12.2023
Diploma - Applied Data Analytics
BCIT Vancouver
04.2023
Bachelor of Science - Statistics And Mathematics
University of Victoria
05.2018
Skills
- MS Excel and VBA
- MS Visio
- MS Power BI
- Tableau Desktop and Server
- R
- SQL
- Dashboard Reporting
- Data Analytics
- SharePoint
Timeline
Security Analyst
BC Hydro
05.2023 - Current
IT Reporting Data Analyst
BC Hydro
09.2021 - 03.2023
Information System Business Analyst
Top Consulting Group
06.2018 - 01.2020
Customer Service Representative
Bank of Communications Tianjin
05.2016 - 09.2016
Tutor
University of Victoria, Math Help Centre
05.2014 - 08.2014
Master of Science - Applied Data Analytics
Boston University
Diploma - Applied Data Analytics
BCIT Vancouver
Bachelor of Science - Statistics And Mathematics
University of Victoria
Similar Profiles
Laura DempseyLaura Dempsey
Field Services Administrator at BC Hydro-Mica Creek, BCField Services Administrator at BC Hydro-Mica Creek, BC
Nirmal QamarNirmal Qamar
Recruitment Assistant at BC HydroRecruitment Assistant at BC Hydro
Cole SchneiderCole Schneider
Mechanical Engineering Intern at BC HydroMechanical Engineering Intern at BC Hydro
Ryan SidenRyan Siden
Field Service Representative at BC HydroField Service Representative at BC Hydro
MARIANA ACEVEZMARIANA ACEVEZ
Research Assistant at UBC Bioproducts InstituteResearch Assistant at UBC Bioproducts Institute