Meski engkau terus duduk dikursi empuk yang sama disepanjang kariermu, tetap saja engkau harus banyak memiliki keahlian baru.

Project Description: Data Lakehouse Implementation on GCP (Google Cloud Platform).
Tools: GCS, STS, VM Instances, Cloud Dataform, Cloud Composer (Airflow), Cloud Data Fusion, BigQuery, Python, ShellScript.
Client: Bank Danamon Indonesia (BDI), Jakarta.

As a Data Mart Lead, my primary tasks involve designing, building, and managing data marts to support specific business unit needs, ensuring data quality, and facilitating efficient data analysis and reporting.

• Data Mart Design and Planning
• Collaborate with stakeholders to understand their specific analytical requirements and identify the data sources needed for the data mart. Determine the boundaries of the data mart, including the specific business functions or departments it will serve. Identify and assess the relevant data sources, ensuring data quality and consistency. Determine the specific data subset that will be included in the data mart, considering the needs of the target users. Design the logical and physical structure of the data mart, including schema, tables, and relationships. Plan the Extract, Load, and Transform (ELT) process for moving data into the data mart, including data cleaning, transformation, and loading.

Project Description: VM HA Centris. Infosphere DataStage HA Implementation.
Tools: IBM Infosphere DataStage on Linux server.
Client: Bank Tabungan Pensiunan Nasional (BTPN), Jakarta.

• Role in this project: Technical Consultant Responsibilities/Contribution & Accomplishment:
• Installation and Configuration Infosphere DataStage. Setup driver for SQL, DB2, MySQL, and perform a connection test. Deployment, testing Job (compile and running). Ensure datastage service runs according to scenario. Provide guidance and direction to the IT Ops team.

Project Description: Antasena Regulatory Reporting Implementation.
Tools: PostgreSQL DB, ETL Tools Pentaho Data Integration on Linux Server.
Client: Bank Artha Graha Internasional (BAGI), Jakarta.

• Role in this project: Senior Data Engineer Responsibilities/Contribution & Accomplishment:
• Perform database server and application installation. Perform mapping with business users. Create queries for financial report forms for balance sheets, administrative accounts, financing credits, counterparty data. Create job with Pentaho ETL Tools. Create shellscript to automate job and schedule with crontab. Create development documentation and operational guides for IT teams. Conduct SIT and UAT with application users and IT teams.

Project Description: Implementation data Warehouse and Business Intelligence with IBM product.
Tools: IBM DB2 BLU & Cognos BI, ETL Tools Pentaho Data Integration on Linux Server.
Client: Card SME Bank, Inc. Philippines.

• Role in this project: DWH BI Team Lead Responsibilities/Contribution & Accomplishment:
• Development internal report: Summary of Savings Per Product, Dormant Accounts Run- Up, Accounts Below Maintaining Balance, Operations Update Summary, Savings Run Up, Risk Classification, Cashiers Blotter (Cash Transaction), Teller's Blotter, Transaction Summary Per Branch, CASA Report, GL ENTRIES, Subsidiary Ledger, Inactive Savings Account Run-Up, Account Credit Interest Posted & Accrued, Deposit Liabilities by Size of Accounts. Create data modelling with Framework Manager to import metadata from one or more data sources and transform it into a business-orinted model. Prepare a model for reporting, create and publish package, export & import content store, deploy to production environment. Compare data between cognos report output and DB2 BLU SQL output.

Project Description: Implementation data Warehouse and Business Intelligence with IBM product.
Tools: IBM DB2 BLU & Cognos BI, ETL Tools Pentaho Data Integration on Linux Server.
Client: CARD Bank, Inc. Philippines.

• Role in this project: DWH BI Team Lead Responsibilities/Contribution & Accomplishment:
• Development internal report: Summary of Savings Per Product, Dormant Accounts Run- Up, Accounts Below Maintaining Balance, Operations Update Summary, Savings Run Up, Risk Classification, Cashiers Blotter (Cash Transaction), Teller's Blotter, Transaction Summary Per Branch, CASA Report, GL ENTRIES, Subsidiary Ledger, Inactive Savings Account Run-Up, Account Credit Interest Posted & Accrued, Deposit Liabilities by Size of Accounts. Create data modelling with Framework Manager to import metadata from one or more data sources and transform it into a business-orinted model. Prepare a model for reporting, create and publish package, export & import content store, deploy to production environment. Compare data between cognos report output and DB2 BLU SQL output.

Project Description: Teradata Report, Implementation Cognos Business Intelligence and to simplify their existing reporting processes.
Tools: Teradata, Cognos BI on Linux Server.
Client: PT Bank International Indonesia Tbk. Jakarta

• Role in this project: Cognos Developer and Administrator Responsibilities/Contribution & Accomplishment:
• Development Conventional and syariah funding, loan, transaction, ledger, Reporting Branch Channel, Consumer Risk, Consumer Sales, Consumer Secured, Consumer Unsecured, Corporate, Finance, Risk Management, SME, Wealth Management. Create data modelling with Framework Manager to import metadata from one or more data sources and transform it into a business-orinted model. Prepare a model for reporting, create and publish package, export & import content store, deploy to production environment. Compare data between cognos report output and Teradata SQL output.

Project Description: Developing Natrindo Telepon Seluler ’s Enterprise Data Warehouse that provides data and process Sales, Marketing, Data Service , IT and Management Report.
Tools: IBM DB2, DataStage, Cognos BI on AIX Server.
Client: PT Natrindo Telepon Selular (NTS) / AXIS. Jakarta

• Role in this project: BI Report Developer Responsibilities/Contribution & Accomplishmen:
• Resposible to back end process include ETL (Extract Transform Load) process for equipping data. Responsible to control the flow process and data validity.

Project Description: The application is a system to process XL CDR national roaming data into reports.
Tools: IBM DB2, DataStage, Cognos BI on AIX Server.
Client: PT Natrindo Telepon Selular (NTS) / AXIS. Jakarta

• Role in this project: BI Report Developer Responsibilities/Contribution & Accomplishmen:
• Create data modelling with Framework Manager to import metadata from one or more data sources and transform it into a business-orinted model. Prepare a model for reporting, create and publish package, export & import content store. Create dashboard analysis with Analysis Studio and Report studio.

Project Description: The project provides NTS operational and management report before implementing Enterprise Data Warehouse and Business Intelligence and to simplify their existing reporting processes.
Tools: IBM DB2, DataStage, Cognos BI on AIX Server.
Client: PT Natrindo Telepon Selular (NTS) / AXIS. Jakarta

• Role in this project: BI Report Developer Responsibilities/Contribution & Accomplishmen:
• Cognos Administrator, Installation & Configuration Cognos BI & Metric Server.

Project Description: Annual Technical Support MySQL
Client: PT Telkomsel, Jakarta.

• Role in this project: Technical Consultant Responsibilities/Contribution & Accomplishment:
• Saving all data from 40 MySQL servers related to database statistic, status, processlist, privileges and variable. Enhancement of log, log-bin and max_binlog_size at configuration file. Implementation Upgrade version of MySQL server. Implementation MySQL Replication & MySQL Cluster. Create script procedure to check total space database MySQL. Maintained and reported statistic database from all MySQL servers.

Project Description: Customer Management System
Tools: SQL Developer, Toad, Oracle DB on Windows Server.
Client: PT PLN Distribusi Jawa Timur, Surabaya & Pasuruan.

• Role in this project: System Engineer
  Responsibilities/Contribution & Accomplishment:
• Implemented, Maintenance and Monitoring CMS application Server (Customer Management System) for PT. PLN Distribusi Jawa Timur. Analyzed, designed, developed and implemented, application using Web technology (PHP+Oracle). Developed and implemented website PT. PLN APJ Pasuruan, Unit Pelayanan Pasuruan Kota and internal website for CMS pasuruan community.