Experience

AEON Credit Service (M) Berhad

• Malaysia
• Financial Services
• 100 - 200 Employee

• Business Intelligence Manager

  • Aug 2019 - Present

  • Assist Head of Business Intelligence Department in performing duties.• Responsible in end-to-end development, testing and integration of data warehouse with company's New Core System Project. Phase 1 of 2 completed.• Resolve data issues that arise from new business processes.• Ensure project timeline and deliverables are met.• Support and optimise current BAU operations in a timely and efficient manner.

• Business Analyst Manager

  • Aug 2017 - Aug 2019

  Responsibilities:• Oversees a team of Business Analysts and involves in requirements study and writing functional specifications documents.• Manages all application system change requests which involves AS/400, LOS, AEON Web, BI and acts as a communication bridge between IT technical staffs and business unit owners.• Analyses existing business processes and workflows with the objective of finding out how they can be improved or automated.• Revised the Workflow Management System flow for application change requests to add checklist of documents and pre-requisites, incorporate user approval matrix based on roles and grades and reporting features. Invalid and incomplete tickets have now reduced by 30% with more efficient ticket escalation process.

• Business Intelligence Assistant Manager

  • Jun 2015 - Aug 2017

  Responsibilities:• Lead the BI team in design, development and deployment of data warehouse (DW) and business intelligence (BI) projects, cube analytics, reporting, ETL applications, data marts and query and server migration.• Evaluate new technology, roadmap and techniques and best practices to implement, maintain and continuously improve the DW and BI systems.• Ensure timely delivery and support of daily reporting and analytical solutions for key business users.• Developed and automated SSIS packages to send BI reports to multiple folders accordingly in Document Management System to be accessed by company wide users from multiple departments and regions such as Credit Assessment, Processing, Credit Management, Fraud Authorization, Finance, Customer Service and Call Center, Sales & Marketing in a timely manner on daily basis.• Lead the team in migrating the DW and BI systems to new servers with higher specifications, storage capacity and upgraded versions of Windows Server, Microsoft SQL Server with zero downtime.Tools:• Microsoft SQL Server 2014, SSIS, SSAS, T-SQL, IBM Cognos BI 10.1 (Framework, Transformer, Report Studio, Administration)

• Business Intelligence Analyst

  • Apr 2013 - Jun 2015

  Responsibilities:• Design and develop SSIS packages, stored procedures, configuration files, tables, views, functions and implement best practices to maintain optimal performance.• Train team members on SSIS, SQL and data warehouse development best practices.• Provide on-call support to production system to resolve any issues.• Automate and delivered more than 50 BI reports to replace legacy, manual and routine reports to business users from Credit Assessment and Fraud Authorization departments in supporting key operational processes.• Developed and customized email notifications on server health checks, scheduled job errors/delays, missing source files, data issues and data driven alerts.Tools:• Microsoft SQL Server 2008/2012, SSIS, SSAS, SSRS, T-SQL, IBM Cognos BI 10.1 (Framework, Transformer, Report Studio, Administration)



AMD Global Services (M) Sdn. Bhd.

• Data Warehouse Analyst

  • Mar 2011 - Apr 2013

  Responsibilities:• Involved in requirements gathering, designing data marts, reports for modules such as Billings, Revenue, Backlog, Sales as well as enhance the existing data warehouse and reporting system to incorporate new business requirements.• Supported the legacy Unix system used for tracking shipped products and resolve production issues.• Co-ordinated with offshore DBA, hardware and storage teams based in the U.S./India and contributed in smooth transition during migration of data warehouse servers to another data center.• Develop and automate ETL processes that involve error handling, refresh and upload Excel reports to Microsoft SharePoint, utilizing Microsoft SQL Server Integration Services (SSIS) and Informatica PowerCenter Client.Tools:• Microsoft SQL Server 2005, SSIS, T-SQL, SSRS, Informatice PowerCenter Client (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Microsoft SharePoint, Control-M, Unix, VBScript



Silverlake System Sdn Bhd

• IT Services and IT Consulting
• 100 - 200 Employee

• Programmer

  • Jun 2007 - Mar 2011

  Responsibilities:• Responsible in end-to-end designing, building, and supporting the components of data warehouse system such as ETL processes, databases, reports and OLAP cube.• Develop and automate multiple Excel reports using VBA macros according to user requirements and specifications for modules such as Withdrawal, Enforcement, Legal and Contribution for KWSP (Employees Provident Fund) project.• Enhanced and supported the data warehouse system for offshore Maybank projects in Labuan and Vietnam.• Prepare comprehensive technical specification documents.Tools:• Microsoft SQL Server 2000/2005, DTS, SSIS, SSAS, Excel VBA