Curriculum Vitae
Yusuf Ananta Tirtodjojo
A Mathematics graduate from Universitas Negeri Malang with strong analytical and problem-solving skills. Experienced in managing and analyzing large datasets to support decision-making. Proficient in various data analysis and visualization tools, including Excel, SQL, Python, R, Google BigQuery, Looker Studio, Tableau, and Power BI. demonstrated through multiple data analysis projects and interactive dashboards. Equipped with leadership, teamwork, adaptability, and a high sense of responsibility. Highly motivated to apply analytical thinking and data-driven approaches to contribute effectively to decision-making processes in a professional environment.
Juni 2025
Universitas Negeri Malang
S1 • Matematika • IPK 3.55
September 2025
Big Data Analytics
PT Kimia Farma Tbk • Magang
• Analyzed over 1.5 million rows of data using SQL and BigQuery to identify key business trends.
• Created 4 integrated SQL queries to combine multiple data tables for KPI analysis.
• Developed 1 interactive dashboard in Looker Studio to visualize sales and operational performance.
• Delivered 7 business insights and 5 KPI reports to support data-driven decision-making.
Media
Mei 2025
Panitia Penyelanggara Ibadah Haji
UPT Asrama Haji Eembarkasi Surabaya • Contract Base
• Served more than 35,000 Hajj pilgrims, including regular pilgrims, elderly pilgrims, KBIHU officers, and regional officers
• Assigned room allocations for all pilgrims using Microsoft Excel and a web-based database of East Java pilgrims provided by the Surabaya Hajj Dormitory
• Distributed printed room numbers to all pilgrims based on the completed room assignments
• Coordinated with other departments related to accommodation to ensure a smooth departure process for all pilgrims
Media
Agustus 2024
Data Entry
Badan Pusat Statistik Kabupaten Lamongan • Magang
• Performed data entry for :
1. Data of the 2023 Manufacturing Industry Company Commodity Survey (including cleaning data)
2. Results of the 2023 Agricultural Census Enumeration (including layout editing using Adobe InDesign)
3. Data of the Micro Small Industry Survey
4. Data of the 2023 Annual Plantation Company Survey
• Developed a prototype of the PUSAKA website which contains a collection of various sites, applications, and activities owned by BPS Kab. Lamongan
• Contributed to the layout design and editing of two official publications:
1. Kecamatan Deket in Figures 2024
2. Social Welfare Statistics of Kab. Lamongan 2024
• Created Instagram content for BPS Kab. Lamongan, and was trusted to produce the statistical march video for an inter-BPS competition throughout East Java
Media
Mei 2023
Panitia Penyelanggara Ibadah Haji
UPT Asrama Haji Embarkasi Surabaya • Contract Base
• Served more than 35,000 Hajj pilgrims, including regular pilgrims, elderly pilgrims, KBIHU officers, and regional officers
• Assigned room allocations for all pilgrims using Microsoft Excel and a web-based database of East Java pilgrims provided by the Surabaya Hajj Dormitory
• Distributed printed room numbers to all pilgrims based on the completed room assignments
• Coordinated with other departments related to accommodation to ensure a smooth departure process for all pilgrims
Media
Januari 2023
Sekretaris Umum
Ikatan Mahasiswa Muhammadiyah • Organisasi
• Managed and archived over 200 incoming and outgoing letters, ensuring documents were well-organized and easily accessible
• Created and maintained the organization’s administrative database using Microsoft Excel and Google Drive
• Coordinated with 9 internal divisions to ensure smooth information flow and administrative procedures
• Scheduled monthly meetings and activities, and represented the chairperson in official forums when unavailable
Media
Januari 2023
Ketua Bidang Musik
Arek Seni Warga MIPA UM • Organisasi
• Managed and analyzed data on equipment needs, rehearsal schedules, and member attendance to ensure smooth execution of work programs.
• Developed activity plans based on data evaluation from previous periods to improve event efficiency.
• Coordinated more than 20 members with task allocation measured by individual capacity and performance.
• Utilized spreadsheets to track rehearsal progress and identify areas for improvement.
Media
Oktober 2025
MICROSOFT EXCEL BASIC TO ADVANCED : FULLSTACK INTENSIVE BOOTCAMP
MySkill • MS-12/10/2025-DOMA3o94LMHLCCMA9vjU
• Proficient in fundamental Microsoft Excel skills, including basic formulas, data management, and cell formatting for efficient data processing.
• Skilled in advanced functions such as VLOOKUP, HLOOKUP, INDEX-MATCH, and complex logic for accurate data analysis.
• Able to create data visualizations using charts, Pivot Tables, and interactive dashboards to present information clearly.
• Experienced in applying efficiency features such as data validation, conditional formatting, and basic Macro VBA introduction to automate repetitive tasks.
• Led a team of three members in completing a final project and successfully earned an Honorable Mention in the final presentation.
Media
September 2025
Data Analysis
MySkill • MS-24/9/2025-CzjqOFtrKJAJhZRCzZ81
Media
September 2025
Foundations of Data Science
Coursera • 27H8KZ92ECX9
Media
September 2025
Data Analysis with R Programming
Coursera • M7TLJRSNUER6
Media
Agustus 2025
Foundations: Data, Data, Everywhere
Coursera • 5M0K4QV59PUX
Media
Juli 2025
English Proficiency Test Score Record
Language Center Universitas Negeri Malang • 17.7.2/UN32.33/KM/2025
Media
Juni 2024
Data Analyst & Software Development with AI
RevoU • 7678243
• Managed and analyzed over 30,000 rows of data for case studies
• Performed data cleaning and exploratory data analysis (EDA) using Pivot Table and SQL in BigQuery, and created data visualizations using Looker Studio
• Designed a website to display the analytical dashboard using HTML, CSS, and JavaScript
• Achievements :
1. Served as group leader of a 12-member team
2. Won 2nd place in the final presentation of the Data Analyst and Software Development project
Media
Februari 2019
Juara 1 Lomba Tenis Meja Putra
Ajang Kompetisi Seni dan Olahraga Madrasah (AKSIOMA) • 08/KKM-MA-KNG/2019