Deon Pretorius Email & Phone Number

Cape Town Area, South Africa

Now, after the whole environment is up and running, the migration started. Me, I was given the task of migrating the whole Production environment from UNIX to LINUX. In total, many scheduled jobs, Xoom transfers in and out of the old of the old environment had to be replicated on the linux Production environment. Yes, copy and paste.... you will be taking like my project manager. Yes, building a plan of everything running Xoom transfers, and ensuring sources are replicated into the new simple… Show more Now, after the whole environment is up and running, the migration started. Me, I was given the task of migrating the whole Production environment from UNIX to LINUX. In total, many scheduled jobs, Xoom transfers in and out of the old of the old environment had to be replicated on the linux Production environment. Yes, copy and paste.... you will be taking like my project manager. Yes, building a plan of everything running Xoom transfers, and ensuring sources are replicated into the new simple, but simulator structure in production. Then migrating all the SAS jobs (Eg code, base code and SAS DI Studio jobs) into a standard and making it Gridified. That is where I built the Development Framework where by you “plug in” the old code and it run as Gridified code making use of all resources as intended by the Grid setup(available hosts, etc) and notifications via email to ensure tracking of status. This wS done and implemented on UAT first then migrated to Production and scheduled through WADE. In total a number of 650 jobs running some daily, weekly and monthly. This excludes the bank applications like IFRS9 which was to deliver on WD 2. Making use of queues to ensure deliver dates are met and required by business owners. This was and is an awesome journey that will take me forward........ Show less

Cape Town Area, South Africa

This is the start of my new chapter at ABSA, that started 5 years ago..... and what an awesome journey indeed......1. Investigating, planning and facilitating the way forward to implement SAS Grid for SAS 9.4 and on Linux - RH.What a journey it's been....... Had the opportunity to work with the team in UK, Barclays. From the hardware right through to the software component landed on various layers: Core, Open and Solution, including Visual Analytics. Through into the mix… Show more This is the start of my new chapter at ABSA, that started 5 years ago..... and what an awesome journey indeed......1. Investigating, planning and facilitating the way forward to implement SAS Grid for SAS 9.4 and on Linux - RH.What a journey it's been....... Had the opportunity to work with the team in UK, Barclays. From the hardware right through to the software component landed on various layers: Core, Open and Solution, including Visual Analytics. Through into the mix clustered storage from Veritas - new to ABSA - and none grid enabled Solution, and Grid enabled Core. Absolutely awesome. Development, UAT and Production are in place and stable. We have put down the binaries, will do the vanilla configuration. Have do some major customization to utilize the security model which runs across UAT and Production. From sawing what the user should see to ensuring the secured access to production data and shared IAP (Inter Active Production. All on the same layer - OS Level and Metadata Level. Expanding that security to the Hadoop layer where users process and storage information and data. Very exciting ......but then the user migration of the users from ASAP - old SAS Platform - to the new grid. We have migrations team managing that function. Almost done, migrated over 400 users.... awesome work done. I did the whole Production migration. Aeschylus and very job, DI Studio, Base, Users written code including Application like IFRS9, Regulatory Reporting and Customer Leads system. And then to add a twist change scheduling tool from CA to Wade. Yes we are there and growing minute by minute and day by day. Just challenges no issues...... Then to make sure all are not lost documentation are kept in Confluence. I am a stickler to ensure that is kept up to date 👍To continue shortly with more detail..... Enjoy with me the journey.... Show less

Cape Town Area, South Africa

Create stable SAS Environment (Dev.UAT and Prd) whereby the business functions can fullfill their daily tasks reporting ti their stakeholders. Managing this environment using a variaty of skill sets:S-SAS Skils, OS(Win,UNIX)A-Architecture (Software, Hardware infrastructure)S-Security model (Dev, UAT and Prd)A-Analysis (System monitoring, backups, uptime etc)D-Documentation of whole environmentM-Maintenance SAS SoftwareI-Installation of softwareN-Non SAS… Show more Create stable SAS Environment (Dev.UAT and Prd) whereby the business functions can fullfill their daily tasks reporting ti their stakeholders. Managing this environment using a variaty of skill sets:S-SAS Skils, OS(Win,UNIX)A-Architecture (Software, Hardware infrastructure)S-Security model (Dev, UAT and Prd)A-Analysis (System monitoring, backups, uptime etc)D-Documentation of whole environmentM-Maintenance SAS SoftwareI-Installation of softwareN-Non SAS Software(WebShpere) Show less

Johannesburg Cbd

Managing the ASAP – ABSA SAS Analytical Platform- environment which consists of a four major environments (ProtoType, Development, UAT and Production) and in addition a current open environment called Production two – consisting of two separate environments. Specific duties:1. Ensuring all SAS environments are managed (Uptime, backup, restores, reporting on system (availiablity, space usage, access by users)). Reporting on user access granted to the system (movers, leavers and… Show more Managing the ASAP – ABSA SAS Analytical Platform- environment which consists of a four major environments (ProtoType, Development, UAT and Production) and in addition a current open environment called Production two – consisting of two separate environments. Specific duties:1. Ensuring all SAS environments are managed (Uptime, backup, restores, reporting on system (availiablity, space usage, access by users)). Reporting on user access granted to the system (movers, leavers and joiners).2. Implementing a security model across all servers in ASAP (nine instances of SAS 9.2 installations(Prototype, Development, UAT and Production)), including the shared hardware storage – GPFS, common data source across all business areas.3. User access management: Accessing the GPFS, groups, permissions on UNIX. Metadata access and user repositories. 4. Development life cycle of models being designed in DI Studio – full ETL in development, promotion to UAT – including UAT testing, and scheduling in LSF, and promotion to production. Training team members – DI Developer – regarding development standards: Naming conventions, comments, logical flow of ETL process.5. Managing promotion from Development,UAT to Productiuon.6. Managing the Monthend run to completion.7. Building a document factory of all processes, and functional task.8. Using Management Console to setup all Metadata: Libraries, EDW – Enterprise Data Warehouse – metadata surfacing. 9. Support to over a 200 users using Base SAS, Enterprise Guide 4.2.10. Consolidation of Monthend downloads,views on Production. 11. GIS Support: MI. (Intranet, MA Metadata access, General access to Bleater, Server maintenance to Bleater, Leads System)12. Audit trail for ASAP users.13. Training, assistance and support to SASCOE team members. 14. Report on ASAP Environment(SAS System status, Monthend run, Business users Audit, SAS System Utilisation) Show less

Standard Bank: Installing\configuration\setup of SAS 9.2 EIP on various platforms - Development, UAT and Production. Data Flux 8.2 Architect (Profiling data and analysis) using SAS DIS. At Standard Bank - did the SAS DIS installation on AIX 5.3. guided the business user(s) with customer profiling, and leading the user(s) with guided actual data on how DataFlux profiling work. Using all aspects of profiling: Data - Cleansing, - profiling, - enrichment and monitoring data quality life cycle… Show more Standard Bank: Installing\configuration\setup of SAS 9.2 EIP on various platforms - Development, UAT and Production. Data Flux 8.2 Architect (Profiling data and analysis) using SAS DIS. At Standard Bank - did the SAS DIS installation on AIX 5.3. guided the business user(s) with customer profiling, and leading the user(s) with guided actual data on how DataFlux profiling work. Using all aspects of profiling: Data - Cleansing, - profiling, - enrichment and monitoring data quality life cycle. Training the user(s) in using the full DFPower Studio toolset. ABSA: Being the second line support to the SAS Administartor to ABSA. Assist in managing the newly designed ASAP environment (ABSA Analytical Platform): testing installed SAS production, checking installation documentation, make recommendations to standards and processes for the environment to be used optimally by twenty five business units (including over 500 users) spreading from EXCO members to day to day business analysts. Show less

Created elt jobs using DI Studio 9.1.3 to exploit sources from oracle into Oprisk Monitor 3.4. Using data loaders to “push” processed csv files into Monitor as for reporting to the bank on : Loss Data, Risk Assessment and Key Risk indicators.

Using SAS 9.1.3 EIP Platform to incorporating data from across the country (seven regions). Managing twenty four servers (HP-UX), data management, server performance management, change control management and security management. The sources of the DW were extensively the direct feeds housed in Oracle 9i and 10g. Overall Data Warehouse administration tasks (Monthly production, Change Control, Document Factory, Training of ESKOM Staff). Migrating old Warehouse to new environment HP-UX… Show more Using SAS 9.1.3 EIP Platform to incorporating data from across the country (seven regions). Managing twenty four servers (HP-UX), data management, server performance management, change control management and security management. The sources of the DW were extensively the direct feeds housed in Oracle 9i and 10g. Overall Data Warehouse administration tasks (Monthly production, Change Control, Document Factory, Training of ESKOM Staff). Migrating old Warehouse to new environment HP-UX Environment. Managing the full migration process – installing\configuring full SAS EIP suite. Migrating the current Production environment (1600 coded jobs and 5 currently developed projects) to the new development environment, exposing developers/user to the new environment. Managing the QA/Change Control/testing of the new environment. Managing staff standby time/schedules. Show less

Using SAS 9.1.3 EIP Platform to develop the CAMS Credit Card ETL process from source: DB2, to EDW which is built in SAS. Part and parcel of being the developer was to sit with the business analist, completing the business requirements documents, and completing the design mapping document from source to target, including all business rules incorporated. Assisting with the development of the consolidation of all banking products: Saving, CAMS Credit Card, Investments, Homeloans, Asset Based… Show more Using SAS 9.1.3 EIP Platform to develop the CAMS Credit Card ETL process from source: DB2, to EDW which is built in SAS. Part and parcel of being the developer was to sit with the business analist, completing the business requirements documents, and completing the design mapping document from source to target, including all business rules incorporated. Assisting with the development of the consolidation of all banking products: Saving, CAMS Credit Card, Investments, Homeloans, Asset Based Finance, Cheque, into the various facts and dimensions in the EDW. Show less

Managing a team of 10 developers, managing, developing and enhancing the RDW – Retail Data Warehouse. Incorporating all Nedbank Retail products (Saving, Credit Card, Investments, Homeloans, Current Accounts, ABF – Assest Based Finance). The sources of the RDW was extensively the ICS – Information Center of Nedbank. Old Mutual data migrated into Nedbank RDW for purpose of cross selling products. Focus group of users were specifically Retail EXCO. Development happened of a detailed specification… Show more Managing a team of 10 developers, managing, developing and enhancing the RDW – Retail Data Warehouse. Incorporating all Nedbank Retail products (Saving, Credit Card, Investments, Homeloans, Current Accounts, ABF – Assest Based Finance). The sources of the RDW was extensively the ICS – Information Center of Nedbank. Old Mutual data migrated into Nedbank RDW for purpose of cross selling products. Focus group of users were specifically Retail EXCO. Development happened of a detailed specification document drawn up by EDW Business Analysts. SAS full toolset incorporated. Delivery of monthly reports etc. Managing staff: Supervisory- and Mentors functions. Show less

Part of team programming HR Remuneration System – REMAX. Used Visual Basic and SQL.

Further Traing In Mathematics, Science And Computer Science, Mathematics And Computer Science

4 Years, Maths, Science, Biology, Computer Science

Activities and Societies: First year Leader. Looking after the interests of first years in my group. Played basket ball, chess and water.

Std10, Maths, Science, Biology, Computer Science

Activities and Societies: Was a leader in standard 10. Played tennis, rugby for the school.