Wayland Zeng
Toronto,Ontario
Summary
Veteran Analytics Engineer skilled at managing both databases and technical personnel. Ready to serve as leader and subject matter expert in all areas touching data retention, processing, and management. Trusted provider of humanistic management policies expanding data analytics performance.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr. IT BSA - Data & BI Analytics
Canada Life
02.2022 - Current
- Served as a leader, overseeing the development of reports for the finance and audit department.
- Utilized SSRS and PowerBI to transform excel reports into paginated reports and dashboards.
- Utilized Jira to efficiently monitor ticket progress and management.
- Led efforts to review and resolve orphan issues by coordinating with cross-functional teams
- Initiated cross-functional conversations to meet customer's special needs regarding point-of-time data modeling across multiple teams
- Worked closely with a team of data engineers to meet regulatory requirements and ensure effective data modeling and transformation
- Identified and addressed various logic errors resulting in data inconsistencies
- Managed and maintained PowerBI Datasets for effective PSHCP reporting.
- Employed query folding and incremental refreshing techniques to achieve refreshing time reduction of over 50%
- Streamlined code management, file version control, and report deployments through the creation of detailed guidelines. Leveraged Gitlab, DevOps, and SharePoint to optimize processes.
- Facilitated the growth of team members by offering support in both technical and customer-oriented areas.
- Consistently liaises with both project management and other team leaders, providing valuable suggestions and actionable plans for removing barriers.
- Collaboratively defined KPIs and developed actionable insights from extensive data sets in partnership with cross-functional teams.
- Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
- Resolved staff member conflicts, actively listening to concerns and finding appropriate middle ground.
Sr. Data Specialist (Acting Team Lead)
Munich Re Canada
11.2016 - 02.2022
- Proactively involved in a pioneering digitalization initiative within the industry from inception to completion
- Utilized knowledge of element mapping, data modeling, workflow development, training, and project management to contribute effectively to multiple projects. Demonstrated proficiency in SQL data engine development and conducted comprehensive testing for quality assurance.
- Developed and supervised a support team, setting objectives, analyzing gaps, establishing deliverables and timelines to enhance overall efficiency.
- Conducted performance reviews and established achievable goals for team members, motivating them to step out of their comfort zones
- Took charge of enhancing data quality in diverse unstructured and structured datasets.
- Streamlined payment processes by modifying multiple store procedures resulting in more than 95% decrease in human interventions and a reduced turnaround time of less than three days on average
- Introduced and operationalized an innovative data management framework, leading to an impressive 80% reduction in human errors
- Coordinated with IT, Database Administration team, and vendors to oversee development and product release during testing sprints
- Detected and resolved a fatal error in the financial data orchestration engine, significantly improving performance
- Delivered expedited reports on critical matters to senior management, offering a range of immediate or sustained actions for consideration.
- Collaborated with IT team and vendors to swiftly resolve an issue, averting a potential million-dollar loss within a week.
- Facilitated effective decision-making processes by providing valuable recommendations for organizational action.
- Established solid relationships with partners and stakeholders, guaranteeing that our deliverables are in line with present and future business demands.
- Optimized business rule logic to enhance data application efficiency, raising the apply rate from 27% to 78%
- Facilitated comprehensive training programs for junior analysts in SQL and the company's agile ETL development process, skillfully allocating workloads based on their unique proficiencies and abilities.
- Consistently met deadlines and delivered high-quality work, demonstrating a strong commitment to excellence in data management.
Junior Policy Analyst
Ontario Ministry of Education
05.2015 - 12.2015
- Design and implement an optimization tool solving long term accommodation issues between two million students and five thousand schools which helped the branch transferred from experience-based analysis to evidence-based analysis
- Introduce a Logistic Model to predict the school board's probability of exceeding the spending limit with R
- Create an interactive user interface for the tool with VBA, Java script, and Google maps APIs for visualization which presents key information in one place
- Ensure the quality of the tool by cleaning, validating incoming data from multiple sources
- Discover the true need of the branch by communicating with the policy analysts and executed an end-to-end project together with the ultimate user of the tool being developed.
Education
Master of Arts - Economics (Co-op) -
University of Waterloo
01.2016
Bachelor of Arts - Economics (Honours) -
University of Waterloo
01.2014
Microsoft
01.2022
University of Toronto
01.2020
Skills
- Python
- R
- VBA
- PLSQL
- SSMS
- DataBricks
- Apache Spark
- Azure DevOps
- SharePoint
- Jira
- Confluence
- Git
- Power BI Tools
- Business Intelligence
- Python Programming
- Advanced analytics
- Machine Learning
- ETL development
- Data Quality Assurance
- Data Modeling
- Data and Analytics
- Statistical modeling
Certification
- Certified Data Scientist Associate, Microsoft - 2022
Timeline
Sr. IT BSA - Data & BI Analytics
Canada Life
02.2022 - Current
Sr. Data Specialist (Acting Team Lead)
Munich Re Canada
11.2016 - 02.2022
Junior Policy Analyst
Ontario Ministry of Education
05.2015 - 12.2015
Master of Arts - Economics (Co-op) -
University of Waterloo
Bachelor of Arts - Economics (Honours) -
University of Waterloo
Microsoft
University of Toronto
Similar Profiles
Riya KoiriRiya Koiri
Process Trainer at Canada lifeProcess Trainer at Canada life
Nicole LaplanteNicole Laplante
Customer Service Supervisor at Canada LifeCustomer Service Supervisor at Canada Life
ELIZABETH SCHULTZELIZABETH SCHULTZ
Director of Operations at Canada LifeDirector of Operations at Canada Life