Swipe Down for More..
Telkom University, 2015-2019
Bachelor of Engineering, Industrial Engineering
GPA: 3.37 / 4.00
Thesis: “Corporate Strategy Based on DER, ROA, EPS, Inflation, and Exchange Rate Analysis Toward Return of Shares in the Food & Beverage Subsector of IDX (2012–2017)”
Transcripts
RevoU, 2025
Full-stack Data Analytics
End-to-end skills in data cleaning, SQL, Python, business analytics, data visualization (Tableau, Power BI)
Certificate Of Achievement
Business Development Officer at COKU, 2022 - 2024
a Small Food and Beverages Business, selling a soft cookie and Chocolate Ball Online with pre-order system.
Creating tools to order product, and fullify customer needs using odoo.com
Analytics Google Trends, Creating Google Business on Google Maps, Copywriting Article, SEO, and SEM.
Leadership
Team Coordination: Managing the division of tasks and ensuring smooth cross-departmental communication. Decision-Making: Making data-driven decisions and considering risks to support company operations. Problem Solving: Detecting team obstacles early and providing strategic solutions to ensure targets are achieved. Motivational Leadership: Building team spirit by providing positive feedback and individual development. Accountability: Being responsible for team results and measuring achievements against agreed-upon KPIs.
Data Analytics
Data Cleaning & Preparation: Using Python (Pandas, NumPy) or Excel to prepare accurate datasets. SQL Querying: Extracting and combining data from multiple sources for in-depth analysis. Statistical Analysis: Testing correlations, trends, and data distributions to identify causal factors and opportunities for improvement. Data Visualization: Creating interactive dashboards in Tableau or Power BI to convey insights to non-technical stakeholders. Business Storytelling: Transforming analysis results into clear, practical, and easy-to-understand business recommendations.
Vendor Management
Supplier Evaluation & Selection: Analyze vendor performance based on quality, delivery time, and price. Contract Negotiation: Negotiate contract terms and conditions to benefit both parties. Risk Management: Identify supply risks and create mitigation plans to prevent delays or cost overruns. Performance Monitoring: Use KPIs and ERP systems (SAP/Odoo) to monitor vendor reliability. Strategic Procurement: Develop data-driven purchasing strategies to reduce costs without compromising quality.
Python
Used Pandas & NumPy to process, clean, and analyze quantitative data. Performed correlation tests, statistical summaries, and outlier detection to uncover the root cause of business problems. Created exploratory visualizations with Matplotlib/Seaborn to support data presentation. Automated repetitive analysis processes and efficiently combined multiple datasets.
SQL
Create JOINs, GROUP BYs, and CTEs (Common Table Expressions) for cross-table analysis (e.g., combining transaction data with customer data). Perform aggregation and filtering to calculate KPIs such as conversion rate, retention rate, and customer segmentation. Write efficient queries to support reports and visualizations in Tableau/Power BI.
Tableu
Design KPI dashboards (e.g., Customer Satisfaction Score, Conversion Rate, Engagement Rate). Use Calculated Fields and Level of Detail (LOD) Expressions for complex calculations. Apply filters, rankings, and parameter controls to create dynamic and user-friendly dashboards. Develop storytelling dashboards to present business analysis results to management.
SAP
Monitor material orders, inventory, and deliveries to ensure they align with production plans. Use SAP Logon to track vendor performance, lead times, and procurement costs. Create KPI-based SCM (Supply Chain Management) reports to evaluate team performance.
Google Worksheet
Google BigQuery: Used to analyze large-scale transactional and operational data using SQL to generate business and performance insights. Google Sheets: Used for data cleaning, KPI calculations, pivot tables, and real-time operational monitoring and reporting. Google Slides: Used to present data insights and business recommendations clearly to stakeholders. Google Docs: Used to document analysis results, methodologies, and business reports collaboratively.
Microsoft Office
Excel: Data cleaning, Pivot Tables, analytical formulas (VLOOKUP, INDEX-MATCH, IF, SUMIFS), and creating simple KPI dashboards. Word: Writing analytical reports and project documentation in a professional format. PowerPoint: Designing analytical presentations with visual storytelling to communicate results to stakeholders.
Sephora Customer Satisfaction Analytics, 2025
Background & Objective:
Analyzed 600K+ Sephora product reviews to identify key factors affecting customer satisfaction (CSS 4.34 vs 4.5 target) and evaluate the impact of price and promotion on ratings.
Tools & Methodology:
Used Python (Pandas, NumPy, Seaborn) for data cleaning and correlation tests, and Tableau for visualization of CSS, conversion rate, and engagement metrics.
Insights & Recommendations:
Found weak correlation between price and rating (r = 0.33) and no effect from promotions, recommending focus on product quality, packaging improvement, and loyalty engagement to raise CSS ≥ 4.5.
Glow&Harmony Customer Segmentation Analytics, 2025
Background & Objective:
Analyzed 1K+ Glow&Harmony product on amazon e-commerce to identify customer segmentation and make insight and recommendation for marketing strategy.
Tools & Methodology:
Used Python (Pandas, NumPy, Seaborn) for data cleaning and correlation tests, and Tableau for visualization, conversion rate, and engagement metrics, K-Means and RFM Clustering Method.
Insights & Recommendations:
Luxury & Budget-Conscious Shoppers are the most promising segments to quickly convert into loyal customers. Segment Trend Followers are the segment most at risk of losing customers, despite their high spending (requiring immediate reactivation).
QuickU Demand Planning Analytics,2025
Objective:
Analyzed historical demand and shipment data to identify demand patterns, evaluate variability, and support more accurate demand planning and inventory decisions.
Tools & Methodology:
Used Google Sheets and Excel for data cleaning, demand aggregation, moving average and trend analysis, and created visual summaries in Google Slides.
Insights & Recommendations:
Identified demand fluctuations across categories and hubs, recommended data-driven demand forecasting and safety stock adjustments to reduce stockout risk and improve supply reliability.
Loan Portofolio Analysis,2025
Objective:
Analyzed loan portfolio performance to assess loan quality, repayment behavior, and overall portfolio risk exposure.
Tools & Methodology:
Used SQL (BigQuery) for data preparation and KPI calculations, and Google Slides to visualize loan status distribution, outstanding amounts, and portfolio performance metrics.
Insights & Recommendations:
Found that the majority of loans were in healthy status while a smaller portion contributed disproportionately to risk, leading to recommendations on tighter risk monitoring, portfolio segmentation, and improved credit strategy.
Unified Channel Performance Dashboard (Virtual Internship RevoUxTelkom Indonesia) ,2025
Objective:
Monitored multi-channel messaging performance (WhatsApp, SMS, Email, Voice) and analyzed user behavior to support data-driven commercial and retention strategies.
User Behaviour & User Segmentation Analytics (Virtual Internship RevoUxTelkom Indonesia) ,2025
Tools & Methodology:
Built reporting dashboards using Looker Studio and performed RFM-based user segmentation using Python (Pandas, NumPy) in Google Colab.
Insights & Recommendations:
Identified high-value user segments driving revenue and recommended channel optimization and targeted engagement strategies to improve retention and reduce churn.
Songwriter, Composer, and Artist as BE.MIM, 2021 -Now
Since Covid started in 2019, I took the courage to write a song and publish my first song in 2021. The first song is entitled "Galaxy Of Dreams" tells about a person's journey to pursue their dreams.
Streams on Spotify
For further discussion or collaboration, feel free to reach me at faizanggana11@gmail.com
© 2025, Created on Framer.