Rico Prawira
at PT Bank Sinarmas Tbk- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
PT Bank Sinarmas Tbk
-
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
-
-
-
Commonwealth Bank Indonesia
-
Indonesia
-
Banking
-
700 & Above Employee
-
-
Apr 2019 - Feb 2020
-
-
-
Mar 2018 - Mar 2019
-
-
-
CIMB Niaga
-
Indonesia
-
Banking
-
700 & Above Employee
-
AVP, Enterprise Application Architect
-
Feb 2016 - Mar 2018
-
-
-
Commonwealth Bank Indonesia
-
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
-
-
-
Commonwealth Bank
-
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.
-
-
-
Commonwealth Bank Indonesia
-
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 -
Sekolah Tinggi Teknik Surabaya
Bachelor of Computing (S.Kom), Information Technology. E-Commerce