Data Analyst with 8+ years of experience interpreting and analysing data to drive successful business solutions. Proficient knowledge of statistical analysis, software engineering and database administration. Built strategies, of which for example saved my company R30 million annually. Experience includes call centre Risk Operations, where the goals include optimising the time most efficiently of my colleagues in customer contact strategies; marketing where the goal was to increase sales and the customer base; and academics or science and technology where I built and populated databases and provided researchers with insightful analytics for their research papers; and developing software to control and investigate devices such as the electronics of radio telescopes and retrieve data from them to research and present findings; and designed, populated and maintained databases. Automated customer list extracts and and built visualisations and dashboards on a variety of portals, computer software based to website hosted. I have also built progressive web apps, which function as a website on pc and native app on the cellphone, such as my online e-commerce store 'matisa_lite' (https://matisa.pythonanywhere.com/matisa_lite), to leverage and apply my database administration and analytics skills, and benefit from machine learning inferences such as from Google Analytics 4 and Google Data Studio.Took a sabbatical in August 2018, which has since ended, to upgrade my skills in database analytics and database administration, web development, server administration and server security, and build my own cellphone app and website based online store.
-
Data AnalystPep Africa Oct 2023 - Present -
Business Data AnalystRegent Business School Sep 2022 - Nov 2023Cape Town, Western Cape, South AfricaReport development and automationReport on and identify measures to improve data qualityDatawarehouse development and population and implementation of measures to improve server securityApi developmentDevelop and share IT architecture to identify areas of business improvementDevelop measures such as for example web portal interfaces to improve business processes -
Database Administrator / Analyst: CrestStellenbosch University Dec 2014 - Jul 2018Stellenbosch UniversityAid centre's function by providing database administration and analytic support. Database administration comprises parsing data feeds including xml, database design and population, user database interface design and implementation, web site and server creation and development, and the maintenance of these services. The tools used in this capacity included PostgreSQL, Python 2 and 3, bash scripting, Web2py, Javascript, CSS, JQuery and D3JS. -
Software DeveloperMira Networks Apr 2014 - Nov 2014Somerset WestCarry out billing and reporting duties and produce extracts for adhoc requests. Tools used in this capacity included Python and MySQL. -
Staff MemberSka (Square Kilometre Array) Organisation Apr 2013 - Mar 2014PinelandsProgram radio telescope circuitry to provide data and control feedback and carry out motor control requests. Created a software simulator with accompanying documentation to facilitate testing of the circuitry during development process. Created software documentation and accompanying manual for programming code and simulator. Investigate and research radio telescope's operation, characteristics and feedback data. Created software to remotely control radio telescope and implement strategies to track and scan celestial objects. Tools used in this capacity included Python, SKA’s inhouse KatCP and Katpoint python libraries, C and VHDL on devices such as Motorola controllers and Arduinos for prototype building. -
Collections AnalystWoolworths Financial Services Jun 2008 - Aug 2012Cape TownReviewed, reported and automated reporting of the Woolworths debtors book, and provided recommendations to in-house and external debt collections agencies on future strategy considering their performance on keeping delinquency in the debtors book within desired levels. Forecast delinquency levels and devised campaigns to manage delinquency. Built statistical models to forecast delinquency profiles of in-order customers and introduced delinquency combating call centre execution strategies against them - earmarked as potential best practise by Barclaycard. Provided the annual selection of accounts earmarked for sales to external companies for revenue collection because further in house collections actions were calculated to be fruitless. Introduced graphical automated daily portfolio reporting including projections which aided understanding of and interpretation of trends to stakeholders and guided resource planning. Reported on portfolio performance and identifed trends. Reviewed how business operations and strategy execution tracked against policy requirements. Provided operations team with insights on operational efficiency. Set call centre collections targets based on projections of customer payment behaviour. Planned strategic call centre call and sms execution. Expanded in scope and redesigned to simplify usability a tool call centre agents used to offer customers an individualised and richer set of repayment scheduling plan options. Introduced automated extract list generation which optimised company processes. Presented to and prepared staff on strategies, their business impact and implementation, trained staff in use of tools and mentored junior analysts in reporting and presentations. Tools used in these capacities of Data Mining Analyst and Collections Analyst at Woolworths Financial Services included SAS, MS Office, Excel and VBA. -
Data Mining AnalystWoolworths Financial Services Jun 2007 - May 2008Profiling and selecting customers for advertising campaigns using SMS and mailing channels;including the seasonal WFS prospecting campaigns. Periodically updated entire data warehouse customer information.
Shaun Smith Education Details
-
Management Development -
Industrial Mathematics -
Mathematics -
Heathfield High SchoolHigh School
Frequently Asked Questions about Shaun Smith
What company does Shaun Smith work for?
Shaun Smith works for Pep Africa
What is Shaun Smith's role at the current company?
Shaun Smith's current role is Data Analyst and Software Engineer.
What schools did Shaun Smith attend?
Shaun Smith attended Milpark Education - School Of Financial Planning And Insurance, University Of Cape Town, University Of Cape Town, Heathfield High School, Abrsm.
Not the Shaun Smith you were looking for?
-
-
Shaun Smith
Information Security Manager Lead At Ntt Data (C-Ciso | Cism | Iso 27001 Prac)Cape Town -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial