Project/Client Name/Location – FNZ (Formerly known as SILICA)/Correspondence UT/ South Africa12/2010 to till dateFNZ is a leading business process outsourcing / third party administration (Registrar and transfer agency) company specializing in investment (Asset management, Finance domain) product administration. It services some 1.3 million active investor accounts and employs more than 400 people in South Africa. FNZ’s technology and outsourcing services are used by some of the largest investment managers in Sub-Saharan Africa and their rich experience in the South African investment industry help drive continuous innovation to the benefit of clients and their investors.We have developed a unified correspondence solution for all 20 vendors of FNZ(Silica), this solution generates data for investor’s correspondence. The key features of the solution are fully configurable, 100% reusable for other vendors, and able to handle a high volume of data for correspondence.Role: Lead Database DeveloperContribution / Highlights 1. Designed the correspondence solution for FNZ for 91FM(formerly known as Investec Asset Management) initially but later the solution has been re-used for FNZ’s 20 clients(e.g. Stanlib, Sanlam, Prudential, PSG, 91FM, etc.). The solution provides more configurability.2. Design and developed the complete framework for the solution to provide 100% reusability and configurability3. Optimize the SQLs and procedures for better performance.4. Developed multi-threaded batch for parallel data generation for Correspondence.5. Unique Excel reporting solution using Apache POI jars in the Oracle database.6. Developed Excel report with password protection generation directly from Oracle database using Apache POI.7. Developed/upgraded automated release process through Azure DevOps.8. Developed automated regression test process through Azure DevOps.9. Python process to extract attachments from emails.

Project / Client Name / Location – FNZ (Formerly known as SILICA) / Correspondence UT / South AfricaFNZ is a leading business process outsourcing / third party administration (Registrar and transfer agency) company specializing in investment (Asset management, Finance domain) product administration. It services some 1.3 million active investor accounts and employs more than 400 people in South Africa. FNZ’s technology and outsourcing services are used by some of the largest investment managers in Sub-Saharan Africa and their rich experience in the South African investment industry help drive continuous innovation to the benefit of clients and their investors.We have developed a unified correspondence solution for all 20 vendors of FNZ(Silica), this solution generates data for investor’s correspondence. The key features of the solution are fully configurable, 100% reusable for other vendors, and able to handle a high volume of data for correspondence.Role: Lead Database DeveloperContribution / Highlights  Designed the correspondence solution for FNZ for 91FM(formerly known as Investec Asset Management) initially but later the solution has been re-used for FNZ’s 20 clients(e.g. Stanlib, Sanlam, Prudential, PSG, 91FM, etc.). The solution provides more configurability. Design and developed the complete framework for the solution to provide 100% reusability and configurability I have created multiple procedures, functions, and packages for the correspondence solution. Optimize the SQLs and procedures for better performance. Developed/upgraded automated release process through Jenkins. Developed automated regression test process through Jenkins.

Project / Client Name / Location – FNZ (Formerly known as SILICA) / Correspondence UT / South AfricaFNZ is a leading business process outsourcing / third party administration (Registrar and transfer agency) company specializing in investment (Asset management, Finance domain) product administration. It services some 1.3 million active investor accounts and employs more than 400 people in South Africa. FNZ’s technology and outsourcing services are used by some of the largest investment managers in Sub-Saharan Africa and their rich experience in the South African investment industry help drive continuous innovation to the benefit of clients and their investors.We have developed a unified correspondence solution for all 20 vendors of FNZ(Silica), this solution generates data for investor’s correspondence. The key features of the solution are fully configurable, 100% reusable for other vendors, and able to handle a high volume of data for correspondence.Role: Lead Database DeveloperContribution / Highlights  Designed the correspondence solution for FNZ for 91FM(formerly known as Investec Asset Management) initially but later the solution has been re-used for FNZ’s 20 clients(e.g. Stanlib, Sanlam, Prudential, PSG, 91FM, etc.). The solution provides more configurability. Design and developed the complete framework for the solution to provide 100% reusability and configurability I have created multiple procedures, functions, and packages for the correspondence solution. Optimize the SQLs and procedures for better performance. Developed/upgraded automated release process through the Batch process. Developed automated regression test process through the Batch process.

Project / Client Name / Location – BND Rewrite / STRATE / South Africa02/2009 to 12/2010Project Profile: Strate is the authorized Central Securities Depository (CSD) for the electronic settlement of all financial instruments in South Africa. Strate is a trusted provider of products and services that deliver value to stakeholders and enhance South Africa’s position as an attractive investment option. Strate is the authorized Central Securities Depository (CSD) for the electronic settlement of all financial instruments in South Africa. Strate handles the settlement of equities, warrants, and bonds for JSE Ltd and the Bond Exchange of South Africa. Strate provides the following benefits to the market•Electronic Custody of Securities•Ability to settle all Financial Instruments •Electronic Settlement of Transactions•Rolling Settlement •Contractual Settlement•Simultaneous Final Irrevocable Delivery Vs Payment•Accuracy of shareholders’ register•Beneficiary Download•Electronic execution of Corporate ActionsRole: Database DeveloperContribution / Highlights As a team member I am actively involved in the below phases of the project: -1. Analysis of requirements for new project and impact analysis.2. Took Backup and Restored Database.3. Creating primary database objects (tables, views, indexes, sequences) for BND4. Extensively used SQL/ PL (Stored procedures and function), db2cc, Toad, RazorSql, Load client, Index advisor for different BND tables (like Safe custody account, Register account, Beneficiaries account, Validation Error Report, Reconciliation Error Report, Issuer Report, Transfer Secretary Report etc.)5. Improve Database Performance by using Index Advisor or finding Indexes and re-building, and also used Runstats on the tables for optimization.6. Planning and implementing various SQL statements, cursors, stored procedures, and functions.7. Set up different databases for QA and Development.