Rani Amelia Putri

Statistics graduate with 1+ year of professional experience in data analysis, statistical modeling, and policy evaluation. Experienced in handling large-scale datasets, performing data validation and transformation, and developing analytical reports using Excel, RStudio, and Python. Proven ability to apply statistical methods to support business operations and evidence-based decision-making. Strong analytical mindset, detail-oriented, and highly adaptable in collaborative environments.

Client Analyst at Traders Family (2025-04 – Present)

• Performed incoming data validation using CRM systems and Microsoft Excel to ensure accuracy, completeness, and consistency before further processing.
• Processed and transformed daily incoming data into structured datasets for internal reporting and operational use.
• Utilized Excel features such as data lookup, data cleaning, and Pivot Tables to analyze and summarize data effectively.
• Conducted data tracking and monitoring using RStudio, including data manipulation, trend analysis, and basic visualization to support performance evaluation and reporting accuracy.
• Prepared and generated daily and monthly reports to support operational monitoring, management decision-making, and performance evaluation.

Data Processing and Policy Analysis at BSKAP Kemendikbudristek (MSIB 7) (2024-09 – 2024-12)

• Successfully matched and integrated complex datasets, enhancing overall data accuracy for policy-making purposes.
• Cleaned and prepared large-scale survey datasets, including IKM, SMK-PK, PSP, and ZI-WBK, ensuring data quality and consistency.
• Designed dashboards interactive and data visualizations using Python, Excel, and Looker Studio to effectively communicate complex findings.
• Created pivot tables and used VLOOKUP to merge, match, and validate extensive datasets across various education levels and programs.
• Calculated scores and analyzed survey indicators for teachers and school principals across multiple education levels (SD, SMP, SMA, SLB, and equivalency education).
• Contributed to policy briefs by interpreting and presenting processed data in actionable formats.

Data Analyst and Information at Dinas Pemberdayaan Perempuan, Perlindungan Anak dan Keluarga Berencana Provinsi Jawa Barat (2024-07 – 2024-08)

• Successfully Reduced forecasting time by 80% with advanced models, enabling faster and accurate decision-making.
• Provided data interpretations that guided the management team in setting new strategies.
• Compiled a data-driven report on gender and children, utilized as a key policy reference.
• Created clear and data visualizations to communicate insights effectively and support decision-making

Practicum Assistant at Statistics Laboratory Unisba (2023-09 – 2025-03)

• Assisted lecturer in delivering material on merging and splitting data frames, date data, text data, data aggregation, and reshaping using R Studio to 17++ students.
• Assisted lecturer in delivering material on assumption tests, partial tests, simultaneous tests, correlation tests, and outlier data using SPSS and Minitab to 20++ students.
• Assisted lecturer in delivering material on NumPy, pandas, and Matplotlib using Python software to 18++ students.
• Managed attendance records for all practicum sessions.
• Assisted students in resolving 90% of syntax errors.
• Corrected 70++ assignments, ensuring timely feedback and improvement.

Consultant Analyst & Head of Education Coordination Team at Badan Pusat Statistik Provinsi Jawa Barat (2024-02 – 2024-06)

• Provided statistical consultations, increasing client satisfaction by 30%.
• Published monthly infographics and videographics on Pojok Statistik Virtual, increasing website traffic by 15%.
• Organized statistical education events with over 70 participants, improving overall engagement by 30%.
• Developed and conducted training sessions on statistical methods and data analysis tools.

Final Year Student in Statistics – Bandung Islamic University (2021 – 2025)