ELOISE SWANEPOEL
LINDEN,GP
Summary
Dedicated individual with a strong background in mathematics,statistics and financial modelling. Experienced in developing and implementing sophisticated quantitative models to analyze and mitigate financial risk in accordance with regulatory standards. Skilled in various programming languages with a proven track record of leveraging data driven insights to inform strategic decision making. Possessing excellent communication and problem solving abilities, adept at collaborating with cross functional teams to drive innovative and optimize performance in dynamic market environments.
Overview
10
10
years of professional experience
Work History
Modelling Data and Implementation Scientists
ABSA
Johannesburg - CBD
08.2020 - Current
- Provide guidance to Model Risk and Development in the capacity as model implementation and/or modeling data specialist
- Review and design mathematical and statistical modeling data preparation processes and model implementation processes to assess risk and calculate expected credit losses in accordance with regulatory requirements
- Integrate validated models into the institution's existing risk Management framework and operational processes (i.e developing software or tools to facilitate the calculation and reporting of expected credit losses and other risk metrics)
- Ensure model selection rules are up to date with the latest approved and implemented applications scoped
Modelling Data and Implementation Analyst
ABSA
Johannesburg - CBD
06.2019 - 07.2020
- Analyse, understand, interpret, enhance, develop and document modelling data as well as implementation processes and code aligned to policies and standards ensuring sustainable and stable solutions
- Transform, manage and prepare data for modelling purposes
- Investigate different methods and approaches to use during modelling data preparation
- Create model implementation and control documentation (specifically implementation sign-off document and post implementation review document)
- Clearly communicate progress, results of investigations and other tasks to line manager and/or initiative lead.
Data Engineer
IQbusiness
Rivonia
06.2016 - 05.2019
- IQbusiness is an independent managing consulting firm that focuses on a wide variety of industries such as Financial, Retail and even Health Care
- I am part of the Data Engineering team within this organization where I go out to different clients to understand their needs and requirements in order to find a way of showing clients how to use IT more efficiently to reach objectives and targets
Data Analyst (Consulting)
ABSA (Chief Security Office)
Johannesburg - CBD
01.2019 - 05.2019
- The project involved implementing authentication controls to prevent unauthorized devices connecting to the global Barclays network through wired LAN ports
- Responsibilities involved analysis of all devices that are currently connected to the ABSA network, identify all ABSA owned devices by locating the owners of each device
- Worked with internal teams to understand business needs and changing strategies.
- Utilized data analysis to monitor process efficiencies and identify data integrity exceptions.
- Created reports to summarize findings of data analysis projects.
Business Analyst (Consulting)
Johannesburg Stock Exchange (Surveillance IT)
Sandown
06.2018 - 11.2018
- I was involved in the ITAC project where all the Derivatives and Bond markets were migrated to a new trading platform and all the markets were migrated to a new clearing platform
- The roles and responsibilities included Analysis on the newly created platform together with writing user stories explaining the findings to each developer in order to fix the loop holes picked up to prevent illegal trading
- Analyzed and documented customer requirements, process flows, and business rules.
- Provided functional expertise in the areas of system analysis, design, development and implementation of software applications.
- Developed test plans to ensure quality assurance for projects.
- Conducted user acceptance testing with clients to ensure proper functioning of systems.
- Performed gap analysis between existing legacy systems and proposed solutions.
SQL Developer (Consulting)
ABSA Retail Banking
Johannesburg - CBD
01.2018 - 06.2018
- The project involves the extraction and transformation of raw data from various systems across various African countries
- This allows management to make strategic decisions based on insights gathered from visualizing the transformed data
- Extracting data from Teradata into SQL using ETL processes
- Developed stored procedures, functions and triggers to support application requirements.
- Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Active participation in the development and creation of the Data warehouse
- Developed database dictionaries and schemas.
- Prepared documentation for database applications
SQL Developer (Consulting)
Standard Bank Corporate Investment Banking
Rosebank
07.2017 - 12.2017
- Migration of SBSA’s CIB legacy system (Market Risk Reporting) to a new Virtual Machine platform and updating the database as well as the reporting services versions to allow for easier future maintenance and migration
- Migrated the Database, the SSRS the legacy system used as well as the Web Apps.
- Migrated all the File Structures
- Configured the Web Apps for use on the new App server, ensured all Web Apps work on latest Windows version and with the new .NET version
- Setup Control-M for new MRR
- Point Source systems to New MRR Production environment
- Decommission the old App server and drop the old MRR Production Databases
SQL Developer (Consulting)
Experian Credit Bureau
Bryanston
02.2017 - 07.2017
- Creation of a specific trigger solution to enable the monitoring of clients in terms of changes in affordability
- Collaborated with business analysts to understand project requirements, customer expectations and timelines.
- Creation of the Entity Relationship diagram
- Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
- Collaborated with software developers on designing efficient database structures that meet application requirements.
- Participated in code reviews with other developers to ensure quality assurance standards are met.
- Developed database dictionaries and schemas.
- Interaction with stakeholders to obtain clarity on reporting requirements
- Prepared charts and diagrams to illustrate system operation results to staff in other departments.
SAP BI Data Analyst (Consulting)
Life Health Care
Illovo
09.2016 - 01.2017
- Defined and implemented a BI solution to be, in support of the migration onto the SAP platform
- Set up STTM to ensure data trace-ability to the BI environment
- Created or reviewed technical design documentation to drive accuracy of reporting solutions.
- Validated that data was extracted correctly from SAP through to reports (included UAT testing)
- Collaborated with stakeholders to to obtain clarity on the report requirements.
- Conducted data analysis, profiling and quality assessment to maintain integrity of business data.
SQL Developer (Consulting)
IQbusiness - MVP Initiative
Rivonia
07.2016 - 08.2016
- Automating Business processes to determine the amount of inventory to order and avoid the wastage of stock to maximise the profit in the retail section
- Automated Business processes in the retail sector determining the amount of Inventory to be ordered using SQL
- After all calculations were automated, a 9 box representation summary was configured to summarise all results in order to improve each retail sector in question
Business Analyst
Aviation Project Management
OR Thambo International
05.2016 - 06.2016
- Assisted with the designing and specification documentation that was communicated to the development team to build a new website
- Defined client tenders
- Analysed Data in order to provide feedback using SQL to manipulate the data and SQL Report Builder (SSRS) to provide clear feedback on the performance of the data
- Documented new Business opportunities that could be presented to clients using Microsoft Word
Junior Business Analyst
Signature Business Solution
Sandton
04.2015 - 05.2016
- Provide clients with solutions to help improve their data accuracy and business processes
- Automated business processes used by the company
- Business process made use of SQL and a program called ICompare to enhance their business processes and SSRS to display the results
- Applied accounting principles in order to implement the new process enabling Discovery Insure to reconcile all the payments.
- Delivered timely support by tracking issues and communicating resolutions to end users.
Managing Prezzy and Refuel Card Program
Tutuka / DrawCard a Division of Paycorp Holdings
Sandton
01.2014 - 04.2015
- Controlled all invoice requests received from incoming clients,
- Registered all new clients on the Debtors system and loaded all card requests when the payments reflected with the requested amount daily.
- Dispatched cards relating to payments to every client nationally
- Month-end reports for clients were done using excel, as well as to Bidvest.
- Followed up on debtors with outstanding fees
- Set up different reports that went to the executive members and the CEO
- Analyzed several card programs in order to provide feedback to Manco
- Created macros to automate different processes used for setting up month end reports
Education
SAS 9.4 Advanced Programming - Performance Based Exam -
SAS
01.2021
SAS Certified Specialist: Base Programming Using 9.4 -
SAS
01.2020
Microsoft Certified Solutions Associate: SQL 2016 Database Development -
Microsoft
01.2018
Microsoft Certified Professional: Querying Data with Transact SQL -
Microsoft
01.2018
Kanban -
IQbusiness
01.2017
Google Cloud Platform Machine Learning -
Microsoft
01.2017
Machine Learning -
Coursera
01.2017
Advanced Excel: Pivot Tables and Pivot Charts -
ICP Training
Johannesburg, Gauteng01.2017
Power BI -
ICP Training
01.2017
Fundamentals of Banking and Risk Management -
Unisa
11.2016
Certificate in Agility with scrum framework -
IQbusiness
01.2016
Certificate in Airside Induction Training -
Airside Induction Professional Training Centre
01.2016
Microsoft Technology Associate, Data Modelling/ Warehousing and Database Administration -
Microsoft
01.2015
Excel Level 1 -
ISolve
01.2015
Excel Level 2
ISolve
01-2015
Excel Level 3
ISolve
01-2015
Certificate of Completion in Ultimate Trading course 2 -
Academy of Financial Trading
01.2014
Certificate of Completion in First level Trading -
Academy of Financial Trading
01.2013
BSc Financial Matchematics -
University of Johannesburg
12.2012
Matric -
Hoërskool Generaal Hertzog
12.2007
Skills
- Agile
- Kanban
- Business Analysis
- Data Analysis
- Business Interaction
- Report Testing
- Microsoft Excel
- Strategy and Solution Design
- Transact SQL
- Power BI
- SSRS
- SSIS
- SPSS
- Matlab
- R
- SAS
- Results Analysis
- Powershell
- C
- Data Interpretation
Personal Information
- Title: DATA SPECIALIST
- Date of Birth: 09/28/89
- Nationality: South African
- Driving License: Yes
Languages
- Afrikaans
- English
Extracurricular Activities
Woman Chapter Empowerment, IQbusiness, Rivonia, 10/2018, 06/2019, How woman is being perceived within the corporate environment, the reasons behind there are so little female CEO's within corporate sectors around the world and how we as females can start making a difference.
Languages
Afrikaans
First Language
English
Proficient (C2)
C2
Accomplishments
- Received a Top achievers award during 3rd year of studies in Financial Mathematics
Timeline
Modelling Data and Implementation Scientists
ABSA
08.2020 - Current
Modelling Data and Implementation Analyst
ABSA
06.2019 - 07.2020
Data Analyst (Consulting)
ABSA (Chief Security Office)
01.2019 - 05.2019
Business Analyst (Consulting)
Johannesburg Stock Exchange (Surveillance IT)
06.2018 - 11.2018
SQL Developer (Consulting)
ABSA Retail Banking
01.2018 - 06.2018
SQL Developer (Consulting)
Standard Bank Corporate Investment Banking
07.2017 - 12.2017
SQL Developer (Consulting)
Experian Credit Bureau
02.2017 - 07.2017
SAP BI Data Analyst (Consulting)
Life Health Care
09.2016 - 01.2017
SQL Developer (Consulting)
IQbusiness - MVP Initiative
07.2016 - 08.2016
Data Engineer
IQbusiness
06.2016 - 05.2019
Business Analyst
Aviation Project Management
05.2016 - 06.2016
Junior Business Analyst
Signature Business Solution
04.2015 - 05.2016
Managing Prezzy and Refuel Card Program
Tutuka / DrawCard a Division of Paycorp Holdings
01.2014 - 04.2015
SAS 9.4 Advanced Programming - Performance Based Exam -
SAS
SAS Certified Specialist: Base Programming Using 9.4 -
SAS
Microsoft Certified Solutions Associate: SQL 2016 Database Development -
Microsoft
Microsoft Certified Professional: Querying Data with Transact SQL -
Microsoft
Kanban -
IQbusiness
Google Cloud Platform Machine Learning -
Microsoft
Machine Learning -
Coursera
Advanced Excel: Pivot Tables and Pivot Charts -
ICP Training
Power BI -
ICP Training
Fundamentals of Banking and Risk Management -
Unisa
Certificate in Agility with scrum framework -
IQbusiness
Certificate in Airside Induction Training -
Airside Induction Professional Training Centre
Microsoft Technology Associate, Data Modelling/ Warehousing and Database Administration -
Microsoft
Excel Level 1 -
ISolve
Excel Level 2
ISolve
Excel Level 3
ISolve
Certificate of Completion in Ultimate Trading course 2 -
Academy of Financial Trading
Certificate of Completion in First level Trading -
Academy of Financial Trading
BSc Financial Matchematics -
University of Johannesburg
Matric -
Hoërskool Generaal Hertzog
Similar Profiles
Charity MokwenaCharity Mokwena
Graduate Risk Analyst -Group ESG Risk at ABSAGraduate Risk Analyst -Group ESG Risk at ABSA
Ofentse Tisetso MekwaOfentse Tisetso Mekwa
Commercial Property Finance Analyst at AbsaCommercial Property Finance Analyst at Absa
Bokang Vitalis LelokaBokang Vitalis Leloka
CSHM (Specialist Customer Service & Host Manager) at AbsaCSHM (Specialist Customer Service & Host Manager) at Absa