08/26/2024 updated
100 % available
SQL, datawarehouse, javascript
Bekasi, Indonesia
Worldwide
Bachelor InformaticsHTMLJava (Programming Language)JavaScriptPHPApache AirflowAmazon Elastic Compute CloudAmazon S3Google App EnginesArduinoAtlassian ConfluenceAtlassian JiraBusiness IntelligenceGoogle BigQueryCascading Style Sheets (CSS)Cloud Computing
- Data transformation: SQL, Python, Airflow, Dbt, Debezium, Kafka, Hevo
- Database: Postgre, MySQL, Mongodb
- Robotic Process Automation (RPA): UiPath, Kofax
- Containerization: Docker, Terraform
- BI Tool: Domo, Holistic, Metabase, Jasper
- CI/CD: Github action, Vetiver, Jenkins, Teamcity
- Infrastructure on Cloud: AWS EC2, ECS, Redshift, DMS, RDS, S3, ASG, ELB, VPC, Lambda, Cloudwatch, GCP Firebase, App Engine, BigQuery, GDS
- Internet of Things (IoT): Arduino
- Programming: Javascript, Node.js, React, PHP, HTML, JSON, CSS, Java, Shell script, Slack bot, Telegram bot, REST API, Webhook service
- Collaboration tool: Jira, Confluence, Trello
Experience
Professional experience10+ years
Freelancer since2009
Languages
EnglishGood
Project history
- Build DWH and Datalake from zero to hero in Redshift and S3
- Guarantee backward-forward compatibility on structured and semi-structured data
- Build monitoring and historical alert for all data flow metric
- SME (Subject Matter Expert) for datawarehouse and datamart fundamental
- Build data pipeline from multiple sources to Redshift
- SME for ELT automation and query optimization
- 24/7 responsible and accountable for RDS Postgre and Redshift
- Mentoring datawarehouse and datamart fundamental
- Hands on data availability, mapping data flow and UAT for GoAML
- Facilitate between user AML (Anti Money Laundering), vendor, PMO, IT architecture,
infrastructure, risk, SAM and deployment for each AML project - Build robot to automate closing PEP (Politically Exposed Person) alert