• Collaborating with software and data engineers to develop and implement data migration strategies and plans• Designing ETL processes to transfer data from MS SQL Server and other data sources to a MySQL database

• Optimised data warehouse performance, and consolidated data from multiple sources• Created real-time product monitoring using Docker, PHP, and MySQL.• Integrated data into Power BI and DOMO BI Platform for dashboard creation.• Utilised ETL tools and SQL for ad-hoc report creation and large dataset manipulation.• Worked closely with stakeholders and various departments to ensure alignment of efforts and outcomes met business and user requirements to gather insights for data-driven decisions.• Ensured data compliance with the Data Privacy Officer.• Resolved high-priority database issues and minimised operational losses.ACHIEVEMENTS• Improved data extraction speed by around 30% through ETL process development.• Cleansed and migrated data for over 20 million KYC customers.• Led a team in developing a real-time streaming pipeline for reporting and analytics.• Enhanced data warehouse performance by 20% via indexing and optimisation of SQL queries.• Reduced database production server load by creating MySQL replication servers for reporting purposes.• Designed a monitoring system to send alerts for data anomaly detection using shell script.

• Analysed large datasets to identify trends and visualised KPIs with Power BI dashboards.• Automated tasks using shell and python scripts.• Created stored procedures for report automation in MS SQL Server and MySQL.• Developed Cash Management and HR Systems using COBOL, Node.JS, and MySQL.ACHIEVEMENTS• Managed a large-scale ETL pipeline migration for a Financial System and HR & Payroll System.• Implemented a high-availability web application handling 1000+ concurrent users.• Redesigned data warehouse for efficient querying of complex datasets.• Developed a KYC System used by 1000+ users with Java and MySQL.• Designed user interface for Cash Management, HR, & Payroll Systems with HTML, CSS, Bootstrap, jQuery, and JavaScript.

• Developed web-based sales and inventory ledgers and HR administrative modules using C# and MS SQL Server.• Integrated third-party APIs for payment processing and user authentication.• Optimised financial and HR systems and created reports using C# and MS SQL Server.• Developed a Windows Forms application for a raffle system using C# and MS Access DB.ACHIEVEMENTS• Successfully resolved and reconciled an imbalanced General Ledger System with thousands of accounts without interrupting operations by creating an SQL script to recompute and correct balances• Developed a foreign exchange system used by over 800 stores by leveraging C# and MS SQL Server