·   Design, develop and enhance SQL scripts for data transformation

·   Design and develop ETL packages (file to table, table to table data load)

·   Collaborate with co-consultants and clients/users regarding project details and resolution.

·   Perform end-to-end SIT (ETL – SSIS packages, Report – Microstrategy Dashboard)

·   Support UAT; analyse issues, fix bugs/defects, resolution verification, provide status report

·   Involve in rotational weekly rooster for providing daily batch job status and log OSS tickets

·   Create and enhance Talend jobs

·   Design, develop and enhance SQL scripts for data transformation for CCRIS

·   Design and develop ETL packages (file to table, table to table data load) for CCRIS

·   Support CCRIS’ monthly submission to Bank Negara Malaysia

·   Exercise critical thinking to resolve several errors encountered in data submission of CCRIS

·   Exercise critical thinking to resolve several errors encountered during UAT for CCRIS enhancement program

·   Evaluated and implemented resolution needed to address user requests (enhancements, major/minor issues) needs issues

·   Collaborated closely with upper management to drive strategy through development and implementation of new processes

·   Improved CCRIS submission by enhancing and automating process

·   Assessed business needs and problem areas to create focused solutions like automation of manual processes

·   Create Functional Design, Technical Design, and Field Mapping Documents.

·   Formulate and optimize SQL scripts imbedded into SSRS or SSIS for better performance.

·   Participate in team project discussions. Create reusable presentations, facilitate knowledge transfer and system roll-out to team members.

·   Create component test plan and perform component test execution.

·   Create pre-deployment and deployment checklist. Support pre-deployment, UAT, deployment and stabilization activities.

·   Monitor batch jobs via Control-M and report generation thru SSRT.

·   Participate in post mortem sessions to discuss the highlights of the project.

·   Create Functional Design, Technical Design, and Field Mapping as well as guideline documents to be used by team in future initiatives or projects as reference.

·   Create and design ETL interfaces with MSBI – SSIS.

·   Formulate easy to complex SQL scripts for ETL interfaces.

·   Coordinated with multiple support teams to evaluate and improve issues related to delayed execution of reports, deployment of components into Staging and Production.

·   Contributed ideas and suggestions in team meetings with the team and delivered updates on deadlines, designs and enhancements

·   Mentor junior engineers and new hires to better improve competency and efficiency of all staff

·   Develop useful and reusable interfaces in transforming data needed by stakeholders for report and analysis

·   Monitor job executions via WCC and report generation thru SSRT subscriptions.

·   Perform Component Test Execution.

 Design and develop SSIS ETL packages to process, transform, and deliver data as required.

 Provide support for SIT, UAT, DRH and Prod deployment.

 Collaborate with co-consultants and BAs regarding project details and requirements.