ahmad efrian

Started and operate a small souvenir apparel shop in a tourist rest area in July 2022. In early 2026, I developed a Streamlit (Python) analytics application to monitor sales, product mix, profitability, and inventory performance.
Analysed 238 transactions with 439 items sold, generating IDR 21.7M in revenue and IDR 10.8M in profit across 5 product lines over 4 months.

Leveraged Power BI to create dashboards analysing 3,313 transactions that generated IDR 388.7M in revenue over six months, uncovering that 69.84% of daily sales occurred during peak hours (17:00–21:00). This insight informed strategic staffing and restocking decisions.

Analysed long-form 1–2 hour lecture videos and transformed them into concise 3–5 minute content pieces. Managed the end-to-end remote content production workflow independently across three years.
Produced and processed 1,700+ hours of video content.
Manually transcribed lecture audio and prepared subtitles for published content.
Edited and assembled raw footage into engaging video content

Created company publications, graphic assets, and daily social media content. Developed visually engaging designs for digital platforms, enhancing user experience and brand identity.
Utilized Adobe tools including Photoshop and Illustrator to create high-quality graphics and marketing materials.

Grade: GPA 3.49

Activities and societies: Relevant coursework: Data Analysis & Visualization, Data Mining, Data Warehouse, DSS, R, MySQL, Data Science.

Earned a 3.49 GPA with coursework spanning Database Systems, Data Warehousing, Data Mining, SQL, R Programming, Data Science, and Data Visualization & Analytics, alongside Software Engineering, Data Structures, Information Systems Security, and Server Administration.

Completed substantial coursework including Computer Networks, Algorithms, Operating Systems, Software Engineering, Programming, Probability and Statistics. Completed 3 years of coursework; transferred to pursue stronger academic and career fit in Information Systems.