Aldo Juliandra Email & Phone Number

Jakarta, Indonesia

- Working with Prudential Indonesia as part of a consulting project focused on developing data entity splits for IFRS 17- Develop AI projects using Python and the Django framework, utilizing both traditional models and large language models (LLMs) to develop an IFRS17 Chatbot AI- Collaborated with cross-functional teams, such as data scientists and analysts, to develop data-driven- Conducted data profiling and data quality checks to ensure data accuracy and consistency- Familiar with big data technologies such as Azure Data Factory, Azure SQL Server, Azure Data Lake Storage/Blob Storage, SSIS, Bitbucket, Git, Spark- Knowledgeable in data modeling and data Warehouse architecture best practices- Responsible for maintaining the Data Warehouse Development, SIT, UAT- Build data used method ETL (Extract, Transform & Load) with Azure SQL query & Azure Data Factory- Build data used method ELT data (Extract, Load & Transform) with Azure SQL query & Azure Data Factory

Head Office, Kino Tower

- Collaborated with cross-functional teams, such as data scientists and analysts, to develop data-driven solutions & dashboard. - Conducted data profiling and data quality checks to ensure data accuracy and consistency- Capable of designing and implementing real-time data processing systems- Familiar with big data technologies such as Azure Data Factory, SSAS, SQL Server database- Knowledgeable in data modeling and data Warehouse architecture best practices.- Build Data Pipeline that clean, & Aggregate Data from source SFA (Sales Force Automation), DMS (Distribution Managament System), ERP, SAP, Excel, etc to Data Warehouse Kino-Responsible for maintaining the Data Warehouse so that it can be utilized by all divisions of the company, including Sales, Supply Chain Management, and Finance, as it serves as the single source.- Build ETL Data (Extract, Transform & Load) with ADF, Blob, SQL query- Build ELT Data (Extract, Load & Transform) with ADF, Blob, SQL query- Familiar with Data Visualization Power BI & Tableau Automation- Develop any Dashboard for business needs and used as a company decision (Quick Count omset Sales Real Order by daily & MTD, on Power BI)

Head Office, Kino Tower

- Handle Distribution Project Application SFA (Sales Force Automation) & IDS (Integrated Distribution System) Principle to All Distribution PT Kino Indonesia Tbk - Handle Bridging System Principle to All System Distributor (API, FTP, etc) - System Analyst for Application Development CR (Change Request) and Analyzing System Bugs (Frontend and Backend) - Data Analyst for Dashboard Sales Purposes

Head Office, Kino Tower

- Develop Program Application (Fullstack) : 1. Services Level Monitoring System (SLM) - Website Platform - Fullstack (Fronted, backend & DB), 2. Monitoring Omset System Distributor - Website Platform - Fullstack (Fronted, backend & DB)3. System Ticketing - Website Platform - Fullstack (Fronted, backend & DB)- Implementation of the DMS (Distribution Management System) onsite at : 1. PT Trihavian Sejahtera, Pontianak city, June 2021, 2. PT Sumber Abadi Sentratama, Pontianak city, June 2021, 3. PT Anugerah Perkasa, Pontianak city, June 2021, 4. PT Gembira Jaya Raya, Jambi city, May 2021, 5. PT Gembira Jaya Raya, Muara Bungo city, May 2021

Indonesia

- IT Implementor SystemVendor PT Kino Indonesia to implementation DMS (SFA & IDS) System- Experienced in implementing and maintaining various systems in the FMCG industry, including sales force automation (SFA), and integrated distribution systems (IDS)- Implementation of the DMS (Distribution Management System onsite at : PT Bintang Suryasindo, Palembang city, November 2020 - March 2021- Worked with cross-functional teams to ensure successful system implementation and adoption

Palembang, South Sumatra, Indonesia

- PHBD (Program Hibah Bina Desa ) - Kemenristekdikti 2019 (Level National)Develop "Aplikasi Layanan Administrasi Kelurahan Berbasis Android ", No HAKI : EC00201982450

Palembang, Sumatera Selatan, Indonesia

IT & Telecommunication Department Asian Games 2018 Palembang