Laetitia Zietsman
Ottawa,ON
Summary
Seasoned Business Intelligence Analyst with background in converting complex data into actionable insights to drive decision-making processes. Skilled in analyzing trends, crafting detailed reports, and enhancing business operations through technology solutions.
Overview
17
17
years of professional experience
Work History
Marketing Analytics Analyst
Canada Post
Ottawa, Ontario
09.2019 - Current
- Evaluated business performance by monitoring KPIs and tracking progress over time, and presented findings from business intelligence analyses during executive meetings.
- Evaluated financial data concerning revenue performance of individual companies and marketing campaign outcomes.
- Engineered dashboards and reports for comprehensive data analysis using MS SQL, SAS, Tableau, and Power BI.
- Analyzed business requirements into technical requirements for reporting and visualizations, data models, and databases. Performed in-depth source analysis, data mappings, and transformations to facilitate development and implementation.
- Performed data analysis and quality assessments to uphold business data integrity, and verified the accuracy of information in databases to maintain data reliability.
- Maintained library of model documents, templates or other reusable knowledge assets.
- Provided training and guidance to less experienced analysts on BI tools and techniques
Senior Analytics Specialist
Adecco Staffing / Canada Post
Ottawa, Ontario
04.2018 - 08.2020
- Spearheaded the creation of dynamic Tableau reports and dashboards, including comprehensive customer profiling and segmentation, and distribution analysis.
- Engineered dashboards and reports for comprehensive data analysis using MS SQL, SAS, and Tableau.
- Generated targeted marketing lists to enhance campaign effectiveness.
- Conducted AS-IS/TO-BE case studies alongside short-term forecasting methodologies to inform strategic initiatives and propel organizational growth.
- Analyzed business requirements into technical requirements for reporting and visualizations, data models, and databases. Performed in-depth source analysis, data mappings, and transformations to facilitate development and implementation.
- Performed data analysis and quality assessments to uphold business data integrity, and verified the accuracy of information in databases to maintain data reliability.
- Maintained library of model documents, templates or other reusable knowledge assets.
Senior Analyst
Barclays Africa Group Limited | Absa Bank
Johannesburg, South Africa
01.2016 - 11.2017
- Directed conceptualization, design, and development of comprehensive business intelligence solutions to enhance strategic decision-making within the insurance and investment management sector.
- Executed formulation of customer-level income statements and balance sheets, integrating banking and investment product data to deliver comprehensive financial insights.
- Managed projects focused on hybrid data mart integration, facilitating creation of automated and efficient reporting framework to boost operational agility.
- Engineered dashboards and reports for comprehensive data analysis using MS SQL and QlikView.
- Utilized SAS and MS SQL for comprehensive data exploration, encompassing source-to-target investigations, and data mapping.
- Performed data analysis and quality assessments to uphold business data integrity, and verified the accuracy of information in databases to maintain data reliability.
- Maintained library of model documents, templates or other reusable knowledge assets.
Information Analyst
Barclays Africa Group Limited | Absa Bank
Johannesburg, South Africa
01.2011 - 12.2016
- Generated national sales performance reports for management using MS Excel and Access.
- Managed performance measures including pipeline management, sales tracking, and income statement analysis.
- Evaluated individual and team business performance and identified opportunities for improvement.
- Collaborated with management on developing strategic plans for achieving business goals
- Conducted data exploration with SAS and MS SQL, performing source-to-target investigations and data mapping.
- Delivered actionable insights via impact assessments and scenario planning using AS-IS / TO-BE case studies.
Sales Management Consultant
Barclays Africa Group Limited | Absa Bank
Johannesburg, South Africa
01.2009 - 12.2010
- Generated regional sales performance reports for management using MS Excel and Access.
- Managed performance measures including pipeline management, sales tracking, and income statement analysis.
- Evaluated individual and team business performance and identified opportunities for improvement.
- Collaborated with management on developing strategic plans for achieving business goals.
Intern for Sales Management Consultant
Barclays Africa Group Limited | Absa Bank
Johannesburg, South Africa
01.2008 - 11.2009
- Acquired in-depth knowledge of private banking sector through immersive training and operational engagement.
- Generated monthly sales performance reports for management using MS Excel and Access.
- Conducted performance measurements including pipeline management, sales tracking, and income statement analysis.
Education
Bachelor of Commerce - Economics
University of Pretoria
South Africa12-2007
Skills
- Analytical thinking
- Business intelligence
- Data visualization
- Data warehousing
- Data analysis
- MS SQL programming
- SAS
- QlikView development
- Tableau development
- Power BI development
Timeline
Marketing Analytics Analyst
Canada Post
09.2019 - Current
Senior Analytics Specialist
Adecco Staffing / Canada Post
04.2018 - 08.2020
Senior Analyst
Barclays Africa Group Limited | Absa Bank
01.2016 - 11.2017
Information Analyst
Barclays Africa Group Limited | Absa Bank
01.2011 - 12.2016
Sales Management Consultant
Barclays Africa Group Limited | Absa Bank
01.2009 - 12.2010
Intern for Sales Management Consultant
Barclays Africa Group Limited | Absa Bank
01.2008 - 11.2009
Bachelor of Commerce - Economics
University of Pretoria
Similar Profiles
Daniel Marsillo-GriecoDaniel Marsillo-Grieco
Interim Superintendent at Canada PostInterim Superintendent at Canada Post
Carson SmithCarson Smith
Letter Carrier at Canada PostLetter Carrier at Canada Post
Shannon SteverShannon Stever
Postal Sorter at Canada PostPostal Sorter at Canada Post
Heather KostermanHeather Kosterman
City Letter Carrier at Canada PostCity Letter Carrier at Canada Post
TANUSHRI WARRIERTANUSHRI WARRIER
Child and Youth Worker at Mary Homes IncChild and Youth Worker at Mary Homes Inc