Alwyn McAlpine
Centurion
Summary
Detail and results-orientated Feature Analyst with sound knowledge and experience in finance, business, and data analysis within the South African monetary and banking sector. Analytical and forward-thinking professional with a thorough understanding of current domestic and international financial regulations, standards and best practices in an ever-changing regulatory environment. Extensive academic experience including lecturing, module and assessment development, and tutoring.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Feature Analyst
Standard Bank South Africa
07.2022 - Current
- Senior Feature analyst and scrum master within the Group Finance Technology space, responsible for the gathering and clarification of business requirements through continuous collaboration with business stakeholders, project managers and IT teams within an Agile environment to ensure effective end-to-end delivery with specific focus on the Bank’s sub-ledger automation journey as well as regulatory automation processes (Group Tax and Regulatory Reporting segments)
- Collaborating with cross-functional teams comprising of product owners and control, technology, business, integration, and other subject matter experts to gather and analyse functional needs and user story requirements
- Documenting associated user stories and acceptance criteria on JIRA and constructing process documentation on Confluence
- Facilitating PI planning sessions, daily stand-ups as well as retrospectives within an Agile environment
- Collaborating with the Feature team to ensure that stories are delivered effectively and timeously, and that quality standards are adhered to
- Constructing and presenting monthly team reports to CIO and other Heads.
- Also technically involved in data sourcing, cleansing, standardisation, and transformation processes as per predefined requisites (Eximbills and SCF+ systems).
- Construction and implementation of source-to-target mappings, ETLs and automated reconciliations to ensure data accuracy and integrity across systems (MS SQL Server/Oracle SQL and SSIS).
Senior Manager
Monocle Solutions
01.2021 - 06.2022
- Consultant and team lead as part of Rand Merchant Bank’s digital platform project, mainly responsible for the successful migration of deal and loan level data from current platforms to the newly implemented version of ACBS
- Liaising with project management, transaction managers (London, S.A and Mauritius) and external vendors for defined requirements, project scoping, issue resolution (data and system related) and runbook orchestration
- Data sourcing, cleansing, standardisation, and transformation in accordance with predefined requisites (loan level qualitative as well as static and reference data sets)
- Construction and implementation of source-to-target mappings, ETLs and automated reconciliations to ensure data accuracy and integrity across systems (MS SQL Server/Oracle SQL)
- Leverage off ACBS APIs to migrate standardised data sets to the newly implemented version
- End-to-end solution testing to ensure events received by downstream users (finance, credit, treasury) are accurate and acceptable based on specified conditions and requirements
- Facilitating and training transaction managers in deal booking processes where automation is not in scope (e.g
- Migration from non-ACBS systems to ACBS)
- Establishing and maintaining upstanding relationships with all stakeholders and vendors throughout the project to ensure expectations are aligned, working as a team takes place and that the overall objectives are met in a timeous manner.
Manager
Monocle Solutions
07.2019 - 12.2020
- Consultant and team lead as part of the FirstRand Group’s Treasury, Asset and Liability Management Analytics team
- The team’s main objective is to source clean and accurate data in a timely manner from all FirstRand entities, achieved through the establishment of a minimum data requirements set for which each entity is ultimately responsible
- Given this set of minimum data requirements, a process of data filtration, standardisation, and transformation takes place with the underlying aim of being BCBS 239 compliant
- The transformed data is ultimately pushed through a predetermined risk engine that provides essential metrics for analytical, reporting, and regulatory purposes (LCR and NSFR, for instance)
- Team-lead of seven ensuring the successful build and implementation of Treasury’s Asset and Liability Management Analytics model
- Requirements gathering and documentation of a full end-to-end solution
- Data sourcing, cleansing, standardization, and transformation in accordance with the ALMA model’s prerequisites as well as BCBS239 guidelines
- Construction of necessary ETL processes to move data between various stages of the process model, including usage by the Kamakura Risk Management (KRM) engine
- Such processes involved an array of both qualitative and quantitative transformations
- Construction of a bespoke market data solution that satisfies the data model’s requirements
- The successful implementation of this model will warrant its subsequent usage by all other areas within Treasury
- Constructing an extensive data quality process applicable to all facets of the model
- This included specific rule sets applied to source and transformed data, including control data processes.
Manager
Monocle Solutions
09.2017 - 06.2019
- Consulting on the sourcing, standardisation, enrichment and provisioning of various banking products and trading desks in the Global Markets area of Standard Bank SA in order to build a single view of all banking and trade data across the spectrum of systems
- Involved in a dynamic team that is in part responsible for the staging, transformation and standardisation of real-time and batch source data from all Global Markets source systems (including Africa Regions) into the data provisioning architecture for consumption by various downstream users including Global Markets Analytics, Treasury and Capital Management, Asset and Liability Management and Regulatory Reporting (e.g
- Financial Markets Act)
- Sound understanding of banking and trading products including Loans, Deposits, Fixed Income, Foreign Exchange, Equities, Credit and Financial Derivatives
- Established clear vision for operations reporting and analytics, identifying key needs for reporting and analytic deliverables while driving development and continuous improvement of periodic reporting and analytics processes.
Senior Consultant
Monocle Solutions
01.2016 - 08.2017
- Part of a broader team mandated to implement a Unified Finance Architecture for Standard Bank SA through the on-boarding of banking and trading source system data to an automated sub-ledger across the entire spectrum of banking and trading desks
- Collaborated with internal stakeholders, identifying, and gathering analytical requirements for project's needs
- Rationalisation of requirements from multiple downstream areas (Finance, Risk and Asset & Liability Management) into a single master requirement
- Processing of source transaction and balances into automated sub-ledger with compatible accounting events using the SQL based rules engine.
Education
Master of Commerce - Economics
University of Pretoria
Pretoria, GP01.2015
Bachelor of Commerce (Honours) - Economics
University of Pretoria
Pretoria, GP01.2013
Advanced Certificate - Emerging Markets and Country Risk Analysis
Fordham University
Bronx County, NY01.2012
Bachelor of Commerce - Economics
University of Pretoria
Pretoria, GP01.2011
Skills
- Business Analysis
- Data Analysis (Mining, Analysis, Mapping and Visualisation)
- AGILE (Lean and Scrum proficient)
- Database Development and Architecture
- Stakeholder management
- Documentation and presentation
- Project management
- Problem solving and critical thinking
- Advanced Microsoft Office
- Microsoft SQL Server & SSIS
- Microsoft PowerBI
- Microsoft Azure
- SAS
- EViews
- STATA
- SPLUNK
Certification
- Financial Risk and Regulation - Global Association for Risk Professionals (GARP)
- Microsoft SQL Server
- Microsoft Azure Fundamentals
- Microsoft Azure Data Fundamentals
Languages
English
Bilingual or Proficient (C2)
German
Advanced (C1)
Afrikaans
Bilingual or Proficient (C2)
References
- Ishmael Masemola, Senior Manager: Group Finance Technology, Standard Bank of South Africa, +27 72 946 0704
- Rodney van der Laan, Senior Executive (Former), Monocle Solutions, +27 76 394 3083
- Eleonora HoltzHausen, Senior Data Analyst: Global Markets, Standard Bank of South Africa, +27 82 877 9244
- Janie Steyn, National Head of Programme: Faculty of Commerce Eduvos (formerly Pearson Institute for Higher Education), +27 83 297 7050
- Prof. Temitope Leshoro, Associate Professor: Department of Economics, University of Pretoria, 012 433 462
Timeline
Senior Feature Analyst
Standard Bank South Africa
07.2022 - Current
Senior Manager
Monocle Solutions
01.2021 - 06.2022
Manager
Monocle Solutions
07.2019 - 12.2020
Manager
Monocle Solutions
09.2017 - 06.2019
Senior Consultant
Monocle Solutions
01.2016 - 08.2017
Master of Commerce - Economics
University of Pretoria
Bachelor of Commerce (Honours) - Economics
University of Pretoria
Advanced Certificate - Emerging Markets and Country Risk Analysis
Fordham University
Bachelor of Commerce - Economics
University of Pretoria
Similar Profiles
Zohra IsmailZohra Ismail
UX Designer at Standard Bank South AfricaUX Designer at Standard Bank South Africa
Nandipha MakhubuNandipha Makhubu
Solutions SME at Standard Bank South AfricaSolutions SME at Standard Bank South Africa
Lorato MothudiLorato Mothudi
Private Banker at Standard Bank South AfricaPrivate Banker at Standard Bank South Africa