mohfikri.aulyanor@gmail.com
Fikri Aulyanor
nairkivm
Data Engineer with expertise in PostgreSQL, Python (Pandas), AWS services, Metabase, and bash scripting. Skilled in transforming spreadsheet-based database into efficient PostgreSQL systems and building data pipelines. Collaborative team player with a strong focus on aligning technical solutions with business needs.
Technical Skills:
Education
Institut Teknologi Bandung - Bandung, Indonesia (Jul 2017–Jul 2021)
Bachelor Degree in Astronomy | 3.55/4.00
- LAPAN Internship (Research Program) participant (Jul-Aug 2020)
- B.Sc. Thesis : The Study of Orbital Dynamics of Minimoon 2020 CD3 (2021)
Work Experience
Data Engineer @ UENA (PT Ujirasa Eka Nagari) - Jakarta, Indonesia (Feb 2023-Present)
- Designing a data structures for the company’s data warehouse in a relational database system (PostgreSQL) from previously multiple spreadsheet files or third-party platform migrations
- Building an ETL data pipeline in Python: extracting data from various data source using APIs, transforming the data using Pandas module, and loading into the database using Python-SQL integrator
- Setting up the automation for the data pipeline using Docker container, scheduling it regularly using AWS ECS, monitoring it via AWS CloudWatch, and creating alert notification via messaging apps (WABA, Slack)
- Creating automatic reports and dashboard systems built in Python and Google Apps Script to minimize manual-repetitive tasks for all teams
- Creating automatic CRM system for unsatisfied customer (broadcast for every long delivery time transactions)
Data Analyst @ UENA (PT Ujirasa Eka Nagari) - Jakarta, Indonesia (Jul 2022-Feb 2023)
- Compiling data from multiple sources (Airtable, Google Sheets, GA4, etc.) into a central data warehouse in spreadsheets and AWS RDS
- Transforming raw data into some insightful metrics of sales, operational, transaction details, and user framework, then visualizing them into dashboards in spreadsheets and Metabase
- Proposing user targets for CRM (Customer Relationship Management) with Growth & Marketing team to increase repeat transactions
- Working with Tech team to discover some frauds/promo-abuse or bugs from thorough data analysis
- Providing Operational team with data related to crew’s productivity, responsibilities, and achievements to ensure data-driven decision and accountability
- Designing some inventory movement dashboards to provide visibility of the company’s goods and movements
Trainings & Sertifications
- Online Course “Neural Networks and Deep Learning” (deeplearning.ai) by Coursera (2020).
- International Virtual Course on Astrostatistic and Machine Learning 2021 by ITB dan NARIT (Thailand) (2021)
- Introduction to Data Analytics by RevoU (2022)
- LinkedIn Skill Badge for Microsoft Excels (2022)
- Sekolah Engineering - Trial Course | Pacmann.ai (2023)
- Free Course - Sekolah Data | Pacmann.ai (2023)