Shawnee Swandale

Shawnee Swandale MOST RECENT JOB ROLE August 2024 - Current Head of TAC and Business Intelligence UmbrellaNET | Remote Cape Town, South Africa--m 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 crossfunctional collaboration and team leadership, driving strategic initiatives that enhance business performance and optimize processes. 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 • 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. July 2023 - June 2024 BI Lead Inhance Supply Chain Solutions | Remote • 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. • • • • • • • • • • • • • • • • 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 • 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. September 2022 - June 2023 Data Analyst PBT South Africa • 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 August 2020 - August 2022 BI Analyst and Designer SwitchX • 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. January 2019 - September 2020 Business Information Analyst Developer Ooba Homeloans • 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 July 2016 - December 2018 Senior Business Intelligence Officer Warwick Financial Maturity • 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 October 2014 - July 2016 Business Intelligence Officer Warwick Financial Maturity • 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 November 2013 - October 2014 Project manager/Systems administrator Kineo South Africa • 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 January 2013 - May 2013 Junior Night duty manager Colona Castle Boutique Hotel • 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. May 2012 - March 2013 Head waitress Cafe du Metro • 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. February 2010 - October 2010 Store manager Mr Video • Ran the branch, stock control, daily customer facing/ sales. EDUCATION January 2021 Data Engineering Foundations January 2021 Jupyter Notebooks training January 2021 Python Certificate January 2019 Advanced SQL for Data Scientists Linked In Learning January 2019 Power BI Essential Training Linked In Learning January 2013 Senior Certificate (Matric/ National Certificate & NCV Hospitality Level 4) False Bay College, Technicon Planning to obtain a Microsoft Certified Solution Developer (MCSD) certificate in future 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