Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Asep Yudi Yurdany

Lead Data Engineer

Home Experiences Education Skills
Download my PDF resume
Asep Yudi Yurdany
40 years old
Driving License
Jakarta (11540) Indonesia
Contact me
Professional Status
Employed
Available
About Me
Experienced Analytics Manager with a demonstrated history of working in the internet and telco industry more than 10+ years national and multinational company. Skilled in various Databases, Data Warehousing, Data Analytics, Data engineering,Data Quality, Automation and ETL. Strong track record in Data related role, experienced implementation critical project with creation big impact for company. Strong support professional with a Bachelor's degree focused in Information Technology
Resume created on DoYouBuzz
Experiences
  • Build scalable and reliable data pipelines utilizing the Azure platform, including Synapse Database, Databricks, and Azure Data Factory)
  • Manage data pipelines from various verticals of the analytics team, ensuring smooth operations and compliance with SLAs
  • Develop and manage a centralized Grab Data Warehouse, participating in all aspects of its development. Liaise with stakeholders from Product, Business, Design, and Engineering throughout the process
  • To ensure that the data we deliver always maintains a very high standard of quality, we initiate and implement data quality solutions for business metrics
  • Established dashboard monitoring and integrated it with alerting tools using Power BI for data visualization and Pagerduty for alerting. This increased visibility and awareness of our system by providing dashboards for:
    -Data Pipeline Monitoring
    -Data Quality Monitoring
    -Query Monitoring
    -Database Health Monitoring
    -SLA Monitoring
  • Lead Self Service Analytics Team, with goals is to democratize data access and analysis, empowering business users to become more self-reliant in exploring and interpreting data, thereby fostering a culture of data-driven decision-making within organizations.
  • Working closely with internal stakeholders (Marketing, Finance, Analytics) to gather business requirements
  • Creating and overseeing solutions that empower end-users to become self-reliant
  • Design & Build Data warehouse & Data Pipeline using GCP Environment ( Data flow, Cloud Function, BigQuery, Airflow / Composer, Data Fusion) for end to end process , currently we maintaining and developing four Data Warehouse for several entity company (Logistics, Remittance, Payment, E-money).
  • Build data quality solutions to ensure accuracy and availability of our Dataset
  • Initiate automation process to improve our team productivity
  • Work closely with our users from all Department so that we can always meet their expectations
  • Leading & Developing Data Engineering team, that support very wide organization with high standard.
  • Design, build and scale our data warehouse, the backbone of Grab’s Analytics, we are using Azure platform for end to end solution.
  • Participate in all aspects of developing a data warehouse. Design, develop, test, deploy and support scalable and exible data warehouse system that can integrate with multiple LOBs
  • Design and implement scripts, ETL jobs, data models, etc.Liaison with Product, Business, Design and Engineering stakeholders to dene and review technical specifications
  • Identify system and application metrics for quality assurance, develop dashboards and setup alerts for metrics and thresholds
  • Implement RLS (Row level security) to our Data Warehouse  to can increase the security of the table , RLS will ensure that someone has to access only those data rows that are pertinent / relevant.
Learn more
  • Developing strategies for effective data analysis and reporting
  • Develops and maintain an overall data architecture / Data mart that supports the information needs of the business in a flexible but secure environment
  • Selecting, configuring and implementing analytics solutions
  • Leading and developing a team of Data Analysts and Business Intelligence, totaling 8 peoples
  • Build data quality solutions in the Data Analytics team that can ensure data integrity and data quality is always at the highest level
  • Initiate several Automation projects which can significantly increase team productivity
Learn more
  • Provide quality rich solutions, insights to help business grow gmv and customer
  • Build Data mart for CLM (Customer Lifecycle Management) based on business needs.
  • Build Data mart Customer behavior, Customer Profile, and Customer Segmentation.
  • Establish dashboard for campaign effectiveness monitoring using Tableau.
  • Implement Leanplum (Campaign Management & Analytics ) .
  • Work closely with marketing and product team to monitored all their campaign and provided pre and post campaign analysis.
  • Develop metrics and prototypes that can be used to drive business decisions. Identify trends and opportunities for future growth.
  • Build churn propensity model to detect at risk customers
  • Build Customer Lifecycle Framework
  • Data Integration from other sources (Leanplum,Appsflyer,Transactions) for Analytics Purpose
  • Designs and implements ETL Job (Extract, Transform and Load)
  • Write complex queries on the data, making sure it is easily accessible and works smoothly
  • Develop and maintain Datamart For CLM (Customer Lifecycle Management)
  • Develop and maintain data warehouses from scratch that can be used for reporting or analysis by Data Analyst
  • Maintain Database and create ETL job for data ingestion to campaign tools (IBM Watson Campaign Automation)
  • Assist business user with reporting and analysis
  • Build Data warehouse from Scratch using Postgre SQL Database
Learn more
  • Running a customer campaign process in SQL environment.
  • Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources to support ad hoc reporting.
  • Reports and Dashboard creation
  • Extract and prepare data for analysis (transforming raw transactional data into customer level data for analysis)
  • importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes Analytics
  • Presenting data in charts, graphs, tables and analyzing data, and developed various Shell script in Linux OS for provide some of different campaign result to support Business team
  • Developed Complex Database SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Develop all dynamic report and auto report using Jaspersoft technology from scratch to support Business Team and Product Manager.
  • Responsible to create Insight Analysis
  • Maintained RBT (RIng Back Tone) Service for Hutchinson Provider ,included Hardware, Software and Reporting and also make sure all service is running well
  • Responsible to monitoring trend about Revenue and Subscriber and make Analysis to Optimize the product performance
  • Working Closely with Managing DIrector and Product Manager
  • Migration data and report from various legacy systems from different databases into a single Postgres database
  • Creating Dashboard using Jasper Report, for monitoring selling performance and Analysis.
  • Creating allFinance and Marketing Report Using Jasper Reports.
  • Provide All Reporting Request(Adhoc Or Regular), From Philippine and Indonesia
  • Direct report to CTO
  • Supporting Campaign and Analytics team for Data Preparation and Presentation
  • Assist business user with day to day daily reporting and analysis
  • Support to Create Datamart for Customer based profile (Prepaid and Postpaid)
  • Involved in developing shell scripts for data collection and integration from another source (Oracle DB,log,text file) to a single source Teradata database for Analysis (structure and unstructured data)
  • Provide Insight to Business User base on request
  • Support daily operation of data warehouse for analytical purpose using Teradata and Oracle Appliance, processing very large data (around 3,5 TB/day)
  • Monitoring day to day Teradata ETL(extract,transform,and loading) Process.
  • Configure Conversion,Collection,Filtering and Loading script (ETL)in Teradata
  • Create and modified shell script to extracting data from Teradata and Oracle for Reporting and Analysis
  • Monitoring Collection and Loading MSC CDR (Call Detail Record) to Oracle Database
  • Provide Regular Report and Adhoc Report for Business User
  • Organize and managed spaces ORACLE 10g Database for loading preparation
  • Monitoring day to day Collection and Loading 3G(MSS) data and Loading to Oracle 10g Database and make sure we haven't issue during the process running
  • Setup and Maintain Software and Hardware
  • Setup and Monitoring Network
  • Manage All IT infrastructure (System Installation, implementation, and configuring system )
  • Monitoring and maintenance ERP Aplication.
  • Training User regarding ERP Application
Education

Bachelor's Degree Information Technology

Esa Unggul University

2004 to 2009
GPA: 3.13 (Scale 4.00)
Skills

Technical Skills

  • Data Warehouse
  • ETL
    Pentaho, Databricks
  • Big Data
    Azure, AWS
  • Data Visualisation
  • SQL
  • Data Quality
  • Data Analysis
  • Automation
  • Power BI
  • Azure
  • Python
  • GCP
  • Big Query
  • Databricks

Personal Skills

  • Leadership
  • Communication
  • Self Motivation
  • Decision Making
Certifications

Building Advanced Codeless Pipelines on Cloud Data Fusion

Sept 2021
(View certification)

Building Batch Data Pipelines on GCP

Sept 2021
(View certification)

Google Cloud Big Data and Machine Learning Fundamentals

Sept 2021
(View certification)

Modernizing Data Lakes and Data Warehouses with GCP

Sept 2021
(View certification)

Serverless Data Processing with Dataflow: Develop Pipelines

Sept 2021
(View certification)

Serverless Data Processing with Dataflow: Foundations

Sept 2021
(View certification)

The Complete Hands-On Introduction to Apache Airflow

Aug 2022
(View certification)
Resume created on DoYouBuzz