Dewald Fourie

• Migration of SAS from SAS Grid to SAS Cloud.
• Utilize SAS to develop and implement innovative solutions facilitating team efficiency and effectiveness
• Provide operational support as needed, ensuring seamless functioning of key processes.
• Create insightful reports using SAS, communicating information in a clear and easily understandable manner

Automated Basel Regulatory Reporting

• Dynamically handled the entire process, from new data sources to loading data into the Database Model.
• Team lead for Credit Risk operational and development processes.
• Gather business requirements for Basel Regulatory Reports.
• Data analysis on new data sources, as well as existing datasets.
• Developed Oracle ETL Jobs to load data from the staging area into the Database Model.
• Improvement and maintenance on SAS Credit Risk calculator extracting data from Oracle and writing results back to Oracle.
• Using PL/SQL to apply specified business rules and generate Regulatory returns submitted to the South African Reserve Bank.
• Creating automated extracts aligning with prescribed business rules and criteria.
• Proactively address audit issues stemming from submitted Regulatory returns.
• Crafting on-the-fly SQL/SAS queries to support both operational and informational requirements.
• Engineered reports crucial for the monthly submission process.(Month-on-Month variances reports, reconciliation reports, DQ Reports, Data Cubes for analysis)
• Contributed to internal activities for overall process improvements, efficiencies and innovation.

Automated Basel Regulatory Reporting

• Dynamically handled the entire process, from new data sources to loading data into the Database Model.
• Team lead for Credit Risk operational and development processes.
• Gather business requirements for Basel Regulatory Reports.
• Data analysis on new data sources, as well as existing datasets.
• Developed Oracle ETL Jobs to load data from the staging area into the Database Model.
• Improvement and maintenance on SAS Credit Risk calculator extracting data from Oracle and writing results back to Oracle.
• Using PL/SQL to apply specified business rules and generate Regulatory returns submitted to the South African Reserve Bank.
• Creating automated extracts aligning with prescribed business rules and criteria.
• Proactively address audit issues stemming from submitted Regulatory returns.
• Crafting on-the-fly SQL/SAS queries to support both operational and informational requirements.
• Engineered reports crucial for the monthly submission process.(Month-on-Month variances reports, reconciliation reports, DQ Reports, Data Cubes for analysis)
• Contributed to internal activities for overall process improvements, efficiencies and innovation.

Automated Basel Regulatory Reporting

• Dynamically handled the entire process, from raw data to loading data into the Database Model.
• Gather business requirements for Basel Regulatory Reports.
• Data analysis on raw data sources, as well as existing datasets.
• Developed SAS jobs in DI Studio to stage data from flat files into an Oracle staging area.
• Developed Oracle ETL Jobs to load data from the staging area into the Database Model.
• Using PL/SQL to apply specified business rules and generate Regulatory returns submitted to the South African Reserve Bank.
• Created automated extracts aligning with prescribed business rules and criteria.
• Proactively addressed issues stemming from submitted Regulatory returns, ensuring a seamless compliance process.
• Responded to real-time business needs by crafting on-the-fly SQL/SAS queries to support both operational and informational requirements.
• Engineered reports crucial for the monthly submission process. Extracted month-on-month variances on returns, reconciled interrelated returns, and meticulously validated specified rules prior to South African Reserve Bank submission, facilitating a streamlined and error-free process.

• Requirement gathering from Business User.
• Designed intuitive graphical user interfaces to improve user experience.
• Built and updated applications crucial for Company use.
• Identified and fixed issues and kept programs running smoothly.
• Developed and managed databases supporting application functions.