Shawnee Swandale
Cape Town
Summary
Dynamic leader with extensive experience at UmbrellaNET, excelling in data governance and predictive modeling. Proven track record in delivering actionable insights through Power BI and advanced analytics. Adept at cross-functional collaboration and team leadership, driving strategic initiatives that enhance business performance and optimize processes.
Overview
15
15
years of professional experience
Work History
Head of TAC and Business Intelligence
UmbrellaNET
Remote
08.2024 - Current
- Develop and implement data strategies that align with organizational goals.
- Establish and enforce data governance standards to ensure data integrity and security.
- Oversee the creation of actionable business intelligence reports and dashboards that provide insights into key performance indicators (KPIs).
- Utilize statistical analysis and predictive modeling techniques to forecast trends and inform strategic planning.
- Collaborate with cross-functional teams to identify business needs and translate them into analytical solutions.
- Present findings and recommendations to senior leadership and other stakeholders.
- Lead analytics projects from inception to completion, ensuring timely delivery and alignment with business objectives.
- Manage budgets and resources for analytics initiatives.
- Evaluate and implement advanced analytics and BI tools to enhance capabilities.
- Stay current with industry trends and best practices in data analytics and business intelligence.
- Manage a team of experienced individuals
- Assisted with customer requests and answered questions to improve satisfaction.
- Managed time effectively to ensure tasks were completed on schedule and deadlines were met.
- Utilized various software and tools to streamline processes and optimize performance.
- Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
- Worked with cross-functional teams to achieve goals.
BI Lead
Inhance Supply Chain Solutions
Remote
07.2023 - 06.2024
- Forward plan and balance capacity of BI resources.
- Technically support and guide a team of business intelligence analysts and developers.
- Provide consulting services to clients in the areas of business intelligence, data warehousing, and analytics.
- Lead and oversee the design, development, and implementation of business intelligence solutions using Power BI, SQL.
- Analyze complex data sets and provide insights to clients.
- Provide training to clients on the use of business intelligence tools.
- Manage project timelines and budgets, ensuring timely delivery of high-quality solutions.
- Stay up-to-date with emerging trends in business intelligence, data warehousing, and analytics.
- Align and work effectively with Data Science and Data Engineering Manager and Project Manager.
- Collaborate with other departments to ensure seamless integration of business intelligence solutions.
- Develop and maintain relationships with clients, ensuring their satisfaction with the services provided.
- Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
- Managed time effectively to ensure tasks were completed on schedule and deadlines were met.
Data Analyst
PBT South Africa
09.2022 - 06.2023
- Company Overview: Capitec Bank
- Design, compile and research the data used and provide analysis as well as the concise and user-friendly display of said data using various tools and methodologies.
- Assist in making strategic data-related decisions by analysing, manipulating, tracking, internally managing, and reporting on data for Capitec’s Marketing division which controls the banks income.
- Create and implement strategies to optimize the data systems and technology in use as well as guide colleagues in best practice.
- Evaluate, process, design and create technology forward and detailed reports.
- Manage stakeholder expectations and do project management on all my assigned reports and deliverables, reporting back to key stakeholders and management.
- Capitec Bank
BI Analyst and Designer
SwitchX
08.2020 - 08.2022
- Overseeing daily activities across our reporting infrastructure and report generation as needed, reporting to the CEO of SwitchX.
- Accountable for the monitoring, maintenance, and creation of SwitchX analytical systems and report products on both sides of the marketplace, i.e. the mortgage originator side and the lender (banking) side.
- Collaborating closely with our partners, vendors, and other teams, creating bespoke, operational, and strategic business intelligence platforms and report products using data analytics, data visualization and data modelling techniques and technologies.
- Create products that can identify trends that can help other departments, managers and executives make business decisions to modernize and improve processes in the organization.
Business Information Analyst Developer
Ooba Homeloans
01.2019 - 09.2020
- Assist in analysing business requirements and offer action driven story telling reports to assist the overall business in monitoring staff, driving performance and tracking sales and target metrics.
- Generate ad hoc SQL extracts to assist in strategic business decision making.
- Create bespoke story telling Power BI Dashboards and Reports across different business units and outside stakeholders.
- Display data in easy to understand visual formats suitable for the end user.
- Create custom report templates on BI Publisher per business unit according to specifications to assist in delivering the information required.
- Liaise with Business Analysts, internal and external company stakeholders to achieve Business Requirements.
- Performance Optimisation.
- Continuous improvement of practices and methodologies.
- Reason for wanting to leave: Retrenchment due to Covid
Senior Business Intelligence Officer
Warwick Financial Maturity
07.2016 - 12.2018
- Generate summary and specified dashboard reports which represent operational data in a brief and intelligible format, suitable for the target audience.
- Creating custom report templates and complex databases using excel, Power BI and SQL server Management Studio.
- Carry out quality assessment of data and data reports.
- Create bespoke story telling Power BI reports and Dashboards across company divisions centred on managerial level presentations and reports as well as assisting sales division in achieving targets and monitoring performance.
- Assist in the Implementation of Power BI Dashboard reports across company divisions.
- Custom development of company CRM system.
- Data transformation and manipulation.
- Creation of Moodle training tests in line with company processes and/or requirements.
- System administration of Xplan CRM, Moodle LMS and Word Press CMS.
- Report on Company turnaround times for various metrics.
- Produce management reports for EXCO and MANCO.
- Compile report packs for MANCO, EXCO and Board meetings on a Monthly, Bi-Annual and Annual basis.
- Document company processes and update subsequent training material.
- Provide support to staff on queries relating to company CRM.
- System and process mapping as needed.
- Reason for wanting to leave: Career growth and personal development
Business Intelligence Officer
Warwick Financial Maturity
10.2014 - 07.2016
- Dashboard reports sent out daily within required timeframe.
- Email marketing.
- System administration of Xplan CRM, Moodle LMS and Word Press CMS.
- Report on Company turnaround times for various metrics.
- Produce management reports for EXCO and MANCO.
- Create custom Xplan tasks and threads (workflows) according to mapped out company requirements and Scope.
- All company processes and training material updated within the agreed timelines.
- Assist on Xplan support queries.
- Reason for leaving position: Promoted
Project manager/Systems administrator
Kineo South Africa
11.2013 - 10.2014
- General administration office duties, Systems support for Content management system and Learning Management System.
- Proof reading of documents.
- Quality Assurance process of all content, development process, creating learning and training content.
- Desktop support.
- Corresponding with clients telephonically, via email and face to face.
- Attending scoping workshops, requirements workshops and capturing clients’ organisational business practises and mapping this to online training systems.
- Training of staff and clients on the LMS (Learning Management System) and CRM (Client Relationship Manager) systems and development.
- Training on Totara and Moodle training systems.
- Maintaining an up to date knowledge and know-how of highly important frameworks.
- Drafting proposals and time schedules.
- Advising development team on best practises and bench marking strategies.
- Strict time tracking.
- Attend progress meetings.
- Creating and updating project plans using Microsoft Project professional.
- Sales consultancy and frequent travelling to meet client requirements.
- Reason for Leaving: To pursue a career in Business Intelligence with a focus on Data management and Report writing
Junior Night duty manager
Colona Castle Boutique Hotel
01.2013 - 05.2013
- Organising transfers for guests, checking in of guests and making reservations for the hotel.
- Serving meals and drinks to guests when needed and supervising subordinate staff in their duties of room preparation.
Head waitress
Cafe du Metro
05.2012 - 03.2013
- Managing restaurant floor, dealing with customers, handling customer complaints and queries.
- Taking orders, training as well as managing staff.
- Stock control administrator and maintaining great customer-staff relationships.
Store manager
Mr Video
02.2010 - 10.2010
- Ran the branch, stock control, daily customer facing/ sales.
Education
Data Engineering Foundations -
01.2021
Jupyter Notebooks training -
01.2021
Python Certificate -
01.2021
Advanced SQL for Data Scientists -
Linked In Learning
01.2019
Power BI Essential Training -
Linked In Learning
01.2019
Senior Certificate (Matric/ National Certificate & NCV Hospitality Level 4) -
False Bay College, Technicon
01.2013
Skills
- Power BI Templates & Dashboard reports
- Power BI Datasets
- Strong Analytical skills
- Advanced Excel
- Advanced DAX formulas
- XML
- HTML
- CSS
- Report Writing
- SQL Query writing
- Process Mapping
- System Design & Process Simplification
- Defining, analysing and documenting company requirements
- Data analysis
- Predictive modeling
- Data visualization
- Business intelligence
- SQL development
- Data governance
- Statistical analysis
- Project management
- Stakeholder management
- Cross-functional collaboration
- Team leadership
- Budget management
- Report generation
- Process optimization
- Effective communication
- Data entry
Personal Information
- Date of Birth: 03/18/92
- Gender: Female
- Nationality: South African
Languages
- English
- Afrikaans
Previous Experience Part Time
- Colona Castle Boutique Hotel, 01/01/13 - 05/31/13, Junior Night duty manager, Organising transfers for guests, checking in of guests and making reservations for the hotel., Serving meals and drinks to guests when needed.
- Cafe du Metro, 05/01/12 - 03/31/13, Head waitress, Managing restaurant floor, dealing with customers, handling customer complaints and queries., Taking orders, training as well as managing staff.
- Mr Video, 02/01/10 - 10/31/10, Store manager, Ran the branch, stock control, daily customer facing/ sales.
System Application Knowledge
- Microsoft Office 365 (incl. Outlook, Excel, Word, Visio and more)
- Toad for Oracle
- MySQL Workbench
- Heidi SQL
- SQL Server Management Studio
- Power BI
- Xplan (CRM)
- Moodle & Totara (Learning Management Systems)
- Word Press (Client Management Systems)
- Oracle SQL Developer
- Oracle BI Publisher
- Visual Studio
- Amazon Redshift
Languages
English
First Language
Afrikaans
Intermediate
B1
Timeline
Head of TAC and Business Intelligence
UmbrellaNET
08.2024 - Current
BI Lead
Inhance Supply Chain Solutions
07.2023 - 06.2024
Data Analyst
PBT South Africa
09.2022 - 06.2023
BI Analyst and Designer
SwitchX
08.2020 - 08.2022
Business Information Analyst Developer
Ooba Homeloans
01.2019 - 09.2020
Senior Business Intelligence Officer
Warwick Financial Maturity
07.2016 - 12.2018
Business Intelligence Officer
Warwick Financial Maturity
10.2014 - 07.2016
Project manager/Systems administrator
Kineo South Africa
11.2013 - 10.2014
Junior Night duty manager
Colona Castle Boutique Hotel
01.2013 - 05.2013
Head waitress
Cafe du Metro
05.2012 - 03.2013
Store manager
Mr Video
02.2010 - 10.2010
Data Engineering Foundations -
Jupyter Notebooks training -
Python Certificate -
Advanced SQL for Data Scientists -
Linked In Learning
Power BI Essential Training -
Linked In Learning
Senior Certificate (Matric/ National Certificate & NCV Hospitality Level 4) -
False Bay College, Technicon