• Provided technical direction and support during planning of new data driven initiatives through business requirement reviews and solution design • Elaborated the database architecture roadmap • Designed and developed PostgreSQL and MS SQL databases and data warehouses in highly available production environment • Created 1 databases to ensure smooth day-to-day operations as well as OLAP databases to support business decisions • Developed complex views, functions and triggers on PostgreSQL utilising PL/pgSQL language, and T-SQL language on MS SQL • Created and optimised queries, indices, as well as carried out database input / output performance tuning • Utilised equivalent to Business Intelligence Development Studio (BIDS) products to generate reports • Wrote ETL procedures to propagate data to fact tables • Partnered with project teams and interacted with customers to find solutions for projects and operational issues for existing and proposed databases • Developed database backup and restore strategies, monitored database functionality to ensure stable environment • Provided guidelines to assist in database administration • Identified and provided resolutions to concerns regarding database server equipment • Developed database applications to provide access to databases

• Analysed business workflows • Designed and developed 1 databases on Microsoft SQL Server to support business operations • Developed views, functions, stored procedures and triggers utilising T-SQL language • Utilised Business Intelligence Development Studio (BIDS) to create and run SSIS packages and in generating models for reports with SSRS • Created DTS packages with embedded ActiveX Script • Developed data warehouses for data mining and generating reports • Utilised ETL processes to provide existing OLAP database with necessary data from various file formats

• Designed and managed MS SQL databases • Created T-SQL views, functions, procedures • Utilised Microsoft Access and VBA to provide access to databases • Developed OLAP databases to generate reports • Established backup and recovery procedures • Assisted in implementing and maintaining database security

• Created and implemented available database technologies to support bank operation • Generated reports • Created various document forms using Microsoft Access and VBA

Vocational Secondary Education