Rico Prawira

at PT Bank Sinarmas Tbk
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Jakarta Metropolitan Area, ID

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Indonesia
    • Banking
    • 700 & Above Employee
      • Feb 2020 - Present

      My EDM Team focused on data, from collecting and storing data to Big Data and Data Warehouse, massaging the data to be in the required format for Regulatory Reporting and Internal Business Reporting (including IFRS 9 (PSAK71), Antasena, SLIK, GoAML, APOLO, OBOX, LPS, LCR/NSFR, BMPK, IRRBB among others), to reporting automation and delivering ad-hoc regulatory or internal data requests, and also analytics.Other than data related, my EDM team also running projects and/or supporting daily Production activities related with Fraud Application, customer screening services to watch list and PEP PPATK, and Enterprise General Ledger.Applications under EDM Team are as follows:- Enterprise Data Warehouse + ETL (ODI, Pentaho, Talend)- BigData Cloudera (Hive, HBase, Apache Phoenix)- Realtime Data Streaming Pipeline (Qlik Replicate CDC, Confluent Kafka Data Streaming)- Regulatory Reporting Applications (for Antasena, SLIK, LLD, LCR/NSFR, IRRBB, BMPK/BMPD)- GoAML Reporting and Customer Screening (including watch list)- Internal reporting application (Web EDM, Web RRS)- Fraud Detection System- Enterprise General Ledger- Tableau- PSAK71 Show less

      • Feb 2020 - Oct 2021

      My Enterprise Data Management Team focused on data, from collecting and storing data to Big Data and Data Warehouse, massaging the data to be in the required format for Regulatory Reporting and Internal Business Reporting (including IFRS 9 (PSAK71), Antasena, SLIK, APOLO, OBOX, LPS, others), to reporting automation and delivering ad-hoc regulatory or internal data requests. My Enterprise Data Governance Team focused on building Data Management practice across the Bank, in areas like Data Governance, Data Quality, Metadata Management, and Data Lifecycle (data security). We aim to build Data Management Framework which includes the standards and methodologies as the foundation for data management practice. Show less

    • Indonesia
    • Banking
    • 700 & Above Employee
      • Apr 2019 - Feb 2020

      • Mar 2018 - Mar 2019

    • Indonesia
    • Banking
    • 700 & Above Employee
    • AVP, Enterprise Application Architect
      • Feb 2016 - Mar 2018

    • Indonesia
    • Banking
    • 700 & Above Employee
      • Jul 2015 - Feb 2016

      • Oct 2013 - Jun 2015

      • Jan 2012 - Aug 2014

      Responsibility:o Analyze systems and applications. Provide design and/or technical recommendations and impact analysis for each enhancement or developmento Supervise employees by prioritizing and assigning work and deliverables according to specified timeframeso Negotiate and plan with stakeholders (Project Manager, Business Analyst, System Analyst, Test Analyst) along project phases (analysis, design, development, testing)o Oversee the completion of deliverable including quality control/sign off for area of accountabilityo Provide management and leadership of team and complete associated taskso Ensure quality standards are adhered to the teamSystems managed:o Data Warehouseo GL Systemo Regulatory Reportingo PSAK 50/55o Internal Reporting platforms: Business Objects and OBIEE.Team Member:o 2 senior developers o 6 developers Show less

      • Jul 2011 - Dec 2011

      As a Datawarehouse Analyst, I am responsible on data analysis and creating source to target mapping to load data requirements into the Datawarehouse System. Creating source to target mapping requires ability to do data quality check on source system's data, understanding on the normalized data model, and skill on SQL syntax in order to get the data, transform the data within certain rules and load them into a physical table. I am also responsible on helping the Data Architect on doing the data modeling and creating the documentations such as Logical Data Model document, Physical Data Model document, and DDL document. Show less

    • Australia
    • Financial Services
    • 700 & Above Employee
    • Design Analyst
      • Jul 2010 - Jun 2011

      As a Design Analyst, I am responsible on data analysis and creating source to target mapping to load data requirements into CBA GDW (Group Data Warehouse) Analytics. Creating source to target mapping requires ability to do data quality check on source system’s data, understanding on the normalized data model, and skill on SQL syntax in order to get the data, transform the data within certain rules and load them into a physical table. As a Design Analyst, I am responsible on data analysis and creating source to target mapping to load data requirements into CBA GDW (Group Data Warehouse) Analytics. Creating source to target mapping requires ability to do data quality check on source system’s data, understanding on the normalized data model, and skill on SQL syntax in order to get the data, transform the data within certain rules and load them into a physical table.

    • Indonesia
    • Banking
    • 700 & Above Employee
      • Jan 2009 - May 2010

      As a CommNet System Account, I am responsible on all aspects of CommNet, making sure that CommNet is available to be used, backup monitoring, server performance and all the development on CommNet. I am also responsible to maintain non core banking applications such as CommWealth, CommReferral, CommBlack, and CommVoice.Other than systems and applications accountability, I am also in charge of resource / developer allocation in projects and resource monitoring, to make sure that every resources can work properly and development process run on schedule. Show less

      • Jan 2008 - Dec 2009

      As a member of developer on IT Business Support Application Development and Maintenance, I am responsible for:• Developing projects (Leave Applications, AML (Anti Money Laundry))• Maintain non core banking applications (CommNet, CommWealth, CommReferral, CommBlack, CommVoice, MPN – Tax Payment System, etc)• Supporting CBA – Vietnam on: o Running daily data warehouse upload and backup o Produce internal VN report (BO Report) o Checking daily Transfer Desk and Sun GL – Sunsystems Backup o Creating automatic daily FPT report generation• Creating backup schedule for all core banking applications mentioned above Show less

Education

  • Universitas Gadjah Mada (UGM)
    Master of Business Administration (M.B.A.), Strategic Management
    2009 - 2012
  • Sekolah Tinggi Teknik Surabaya
    Bachelor of Computing (S.Kom), Information Technology. E-Commerce
    2002 - 2007

Community

You need to have a working account to view this content. Click here to join now