Dicky Andrean Email & Phone Number

Palembang, Id

Federal Territory Of Kuala Lumpur, Malaysia

1) Performing data cleansing and maintaining in-house database to generate effective systems for HR colleagues. (SQL Server)2) Outsource to provide IT service to clients such as IT Support as contract staff.Experience:> MUREX Project - Alliance Bank as IT Support in Hedge accounting, MUREX reports using MX.3 under MUREX team to generate report, enhance existing code, CRs, Support necessary system when required using SQL Developer to enhance SQL.> Datawarehousing Project -… Show more 1) Performing data cleansing and maintaining in-house database to generate effective systems for HR colleagues. (SQL Server)2) Outsource to provide IT service to clients such as IT Support as contract staff.Experience:> MUREX Project - Alliance Bank as IT Support in Hedge accounting, MUREX reports using MX.3 under MUREX team to generate report, enhance existing code, CRs, Support necessary system when required using SQL Developer to enhance SQL.> Datawarehousing Project - Alliance Bank IT Support in datawarehouse team. Assisting in User Access Matrix to validate all users among many departments, Change Requests, enhance existing code, deployment in MS SQL Server.- Talent Acquisition Specialist / BDM> Working as HR recruiter to source profiles through multiple job portals such as JobStreet, Monsters, LinkedIn> Arrange/Attend interview for potential candidate to meet client requirements> IT skills understanding for source quality IT profiles> Converting documents to clients based on the requirements> Communicate with connections to perform seminars for Job opportunities such as universities and provide advice for career path Show less

Federal Territory Of Kuala Lumpur, Malaysia

>ETL/BI consultant mainly working as Vendor to provide BI/ETL services using SQL programming language. Previous working with clients such as CIMB Bank, Alliance Bank, Averis, KWSP (Gov project), PERKESO (Gov project), IDSMed, and etc.>Dealing with multiple projects such as reporting, data cleansing, data migration, ETL with multiple tools depending on the project's. Tools engagement such as SSIS, SSRS, DataStage, Netezza, DB2, Oracle, etc also hands on some operation system for… Show more >ETL/BI consultant mainly working as Vendor to provide BI/ETL services using SQL programming language. Previous working with clients such as CIMB Bank, Alliance Bank, Averis, KWSP (Gov project), PERKESO (Gov project), IDSMed, and etc.>Dealing with multiple projects such as reporting, data cleansing, data migration, ETL with multiple tools depending on the project's. Tools engagement such as SSIS, SSRS, DataStage, Netezza, DB2, Oracle, etc also hands on some operation system for server for the development in Windows, Linux.> Project highlights:a) IDS Medical Systems (MR_PACK) projectExperiences:• Create reports using MSSQL SSRS for finance departments including reports consolidation for regionals offices• Maintained and developed financial reports using SSRS. • Developed DI using SSIS• Develop financial reports such as Profit and Loss, Balance Sheet, Cash Flow, Provisions.• Communicate with Finance users for reports developed to meet their expectations.b) Pertumbuhan Keselamatan Sosial (PERKESO) Project Experiences: • Data migration and cleansing based on requirements• Configure connection for Oracle, Netezza, and DB2 through Datastage components, ensures all these connection able to connect to the existing database to do migration and cleansing• Designing query using SSMS, Oracle SQL Developer, Aginity Workbench for PureData System for Analytics, and DB2 (using DBeaver) • ETL through Datastage designer also data extraction to do migration and data cleansing.• Hands on Linux command to do connection configuration for datastage engine in RHEL Redhat 7 C) Bank CIMB CRS Project Experiences: Projects scope includes for 3 countries which are Singapore, Malaysia, and London. Developing data integration for Common Reporting Standard, FATCA, and Bank of England(BOE) Reporting. Perform extraction from multiple source systems, matching and exclusion report from source flat files. Convert the target table into XML for bank to submit to IRAS. Show less

Malaysia

During 4 months working as Marketing Analytics, task as following below:-- Preparing software demo to do digital market through YouTube, Social Media.- Evaluation of data- Use case preparations- Converting business requirement to technical requirement- Understanding of end-to-end marketing analytics framework.

Bachelor (Hons) Of Information Systems, Information Systems

Joint partnership with Lancaster University

Bachelor Of Science In Information Systems, Information Technology

Joint partnership with Sunway University