Andika Pandanu Putra
@andikapandanuputra
I build commercial analytics and automated BI pipelines for FMCG sales operations.
IndonesiaWhat I'm looking for
At PT Nojorono Tobacco International, I analyze Route-to-Market strategy and commercial execution across West Java while automating regional sales-data pipelines with BigQuery SQL and Python.
I build self-service analytics in Looker Studio, QlikView, and Tableau, and developed Survey Selling Out, an AppSheet mobile application for real-time market data collection. I work directly with sales supervisors to turn complex data models into actions that improve market coverage and execution.
Previously at PT Kino Indonesia Tbk, I accelerated reporting efficiency by 40%, improved sales-incentive calculation accuracy by 15%, and eliminated more than 20 hours per month of manual data preparation. I bring a financial-management foundation and hands-on FMCG experience connecting sales operations, commercial strategy, and scalable BI.
Experience
Work history, roles, and key accomplishments
- Drive Route-to-Market (RTM) Strategy: Analyze sales distribution, outlet penetration, and commercial execution across West Java (Bandung, Cirebon, Garut, Sukabumi, Tasikmalaya, and Cianjur) to identify growth opportunities and resolve territory-level performance gaps.
- Architect Modern Data Pipelines: Automate the extraction and transformation of millions of rows of regional sales data using Ad
- Spearheaded end-to-end commercial analytics for Sales & Operations, evaluating Route-to-Market (RTM) metrics, outlet penetration, and salesforce effectiveness across General Trade (GT) and Modern Trade (MT) channels.
- Architected and optimized complex sales incentive calculation models, aligning payout structures with corporate growth targets and ensuring operational fairness.
- Engineered auto
- Provided foundational commercial data support for the Sales & Marketing division, establishing rigorous monitoring of daily, weekly, and monthly performance.
- Tracked core execution metrics including sell-out volume, active transactions (AT), effective calls (EC), and outlet coverage across GT and MT channels.
- Streamlined salesforce incentive processing and collaborated with the IT department
- Managed sales item database, ensuring accuracy and consistency across outlets.
- Conducted monthly inventory checks to support stock accuracy and operational efficiency.
- Coordinated circulation of supplier program information, ensuring implementation at outlet level.
- Performed analysis and validation of prospective customer data to ensure authenticity.
- Verified photo ID data against customer identity to support compliance and onboarding.
- Generated verification reports and provided recommendations for approval/rejection decisions.
- Entered and maintained accurate data in company systems, supporting operational efficiency.
- Ensured data quality through basic validation and clerical checks.
Education
Degrees, certifications, and relevant coursework
University of Muhammadiyah Jakarta (UMJ)
Bachelor's degree, Financial Management
2016 - 2020
University of Muhammadiyah Jakarta
Bachelor's degree, Financial Management
2016 - 2020
Pursued a Bachelor's degree in Financial Management, gaining a strong foundation in finance and data analysis.
SMAN 1 SALEM
Senior High School, Mathematics & Natural Science
2013 - 2016
Tech stack
Software and tools used professionally
Availability
Location
IndonesiaAuthorized to work in
Job categories
Skills
Interested in hiring Andika?
You can contact Andika and 90k+ other talented remote workers on Himalayas.
Message AndikaGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
