Bianca Broodryk (Gaertner) Email & Phone Number

City Of Cape Town, Western Cape, South Africa

Cape Town, Western Cape, South Africa

Cape Town Area, South Africa

Duties and Responsibilities:• Developing Relational Databases for Retail Scan data• Developing ETL Solutions primarily with SSIS• Developing production reports using SSRS which enable the operations teams for data analysis• Provide SQL support to the operations team for data troubleshooting• Investigate Data inconsistencies, recommend solutions and implement adjustments to ETL• Primary Developer assigned to SQL Server Upgrade (from 2008R2 to 2017). This includes designing, testing and implementing a migration plan.• Documenting projects and learning for knowledge transfer• Working closely with DBA and Software developer to brief, test and implement new business operational solutions

Cape Town Area, South Africa

• Client Management• Data Analysis and Data Mining• Understanding and finding solutions to client needs• Monthly data processing management• Creating and delivering client deliverables timeously and accurately• Client presentation development and management• Training on internal Software and advanced reporting solutions (PowerPivot)• Planning and development of new report innovations (as part of the Solutions and Innovations team)• Client Management• Mentoring junior team membersAccounts Worked on:Lancewood, Philip Morris South Africa, KWV, Rhodes Food Group, Lindt &Sprüngli, Unilever and Johnson and JohnsonTraining and Development:Presentation Skills (1&2), CEO of my Career, Manger Essentials, Business Etiquette, Advanced Excel (PowerPivot and VBA)Achievements:IRI Lead the way award – internationally awarded to people who demonstrate excellence in client delivery, growth, innovation and people leadership.2 Spot Bonuses – people who are seen as going above and beyond

Cape Town Area, South Africa

Job Specifications:- Data Analysis and Data Mining- Managing process of receiving data from retailers to the creation of customised databases for clients to the delivery of these- Ensuring client receive their monthly deliverables timeously- Build presentation for clients with indepth analysis allowing for meaningful decisions to be made on their brands- Client/ Retailer Facilitations - Build dynamic reports to enable our clients to make meaningful decisions with the data (using Excel, Power Pivot as well as in-house software)- Training new employees- Mentoring new employees- Provide internal support on Excel and Power Pivot to other Client Service Team Pods

Kenilworth, Cape Town, South Africa

The Junior Account Executive works closely with the client service team in the execution of the data management process and is involved in the report generation and analysis and presentation for clients under the guidance of the senior team members as required. Key areas of responsibility include:-Data management- Data Analysis and Data Mining-Involvement in the presentation development-Championing new set- ups-Client Service delivery

10 Anson Street Observatory Cape Town

• Managed the business' finances and administration• Managed Business' online presence• Growing client base to full capacity• Instructed Zumba and Dance Fitness classes 3 times a week• Organised year end showcases for students

Gadens, Cape Town

Clients I worked with:Bramon Wine Estate & RestaurantHog Hollow Country LodgeHillsNek SafarisPalmiet Valley EstateMadame Zingara GroupZanzi ResortSea Five Boutique Hotel GocheGanas

Gardens, Cape Town

Assist Marketing Manager in various marketing related strategies, activities and research.Responsible for Social Media, website design and development and advertisement.M&M Travel Solutions is a Destination Management Company situated in Cape Town. We focus on FITs, Group Travel, Events, Incentive travel, Promotions, Product Launches and Productions. We are specialised to assist the German market with anything that is Southern African related. Travel and experience Africa with us. We know what you need.

Play and teach sports to children of disadvantaged schools every Monday from 2pm-5pm.

University Of Cape Town

Currently conducting marketing research within the organization.Currently working on devising a new marketing strategy for 2012.

Cape Town Area, South Africa

Intern in the SAB- Carling Black Label Account.- assisted in issuing creative briefs- sat in on 'kickstarts', status reviews- attended a photo shoot- met with various department heads to gain better understanding of their functions and the systems of the organization- helped in research for consumer insight in different brands

Uct

Liaison between the third year marketing lecturers and the students.

B.Com, Management Studies Major In Marketing

Activities and Societies: Golden Key Honour Society, UCT Wine Society, Shawco Sport Stars

Education record

Went to America (New York, Washington DC and California) with a large group of young adults from all around the world where we learnt.

Education record

Activities and Societies: Matric Valedictory Committee 2007 Matric Dance Entertainment Committee 2006 Girls Soccer team 2002-2004

Certificate Of Completion: Excel Dashboards In An Hour, Excel, Completion

Learnt how to create interactive Excel Dashboards in one hour. 11 Lectures, 1 hour duration. Excel Dashboards are a powerful tool.

Certificate Of Attendance, 1 Day Powerpivot Course, Completion

Certificate Of Attendance, Vba Excel, Completion

Certificate Of Complettion: Power Bi Masterclass, Powerbi, Completion

Completed a 6.5 hour course of Power BI Masterclass- beginners to advanced Instructor: Daniel We

Certificate Of Completion, Sql-Beyond Basics, Completed

In this course I learnt to create temporary tables, declare and use variables, sub queries, the CASE statement, numbering and ranking..