Glenn Byan Vandyka Email & Phone Number

Indonesia

Jakarta, Indonesia

Jakarta, Indonesia

• Evaluating the effectiveness of customer limit increase initiatives to measure impact on user behavior by calculating key metrics to assess program performance and risk
• Back-tested historical experiments to identify successful strategies, while also refining, adjusting, and enhancing customer’s eligibility logic to improve initiatives outcomes
• Analyzed loan disbursement growth driven by sales agent activity, while developing and maintaining sales operations reports to track individual performance.
• Utilized SQL with Google BigQuery for data extraction and manipulation, and performed calculations, summarizations, and visualizations using Microsoft Excel, Google Sheets, and Metabase

Jakarta, Indonesia

• Analyzed and reported on 20+ marketing projects (pre/post-campaign), focusing on partnership collaborations with Bibit and Stockbit, delivering insights, projections, and strategy alignment with OKRs.
• Identifying and evaluating eligible winners of more than 10+ acquisition campaigns, including analyzing user behavior and assessing campaign effectiveness months after the campaigns from perspectives of inflow-outflow.
• Demonstrated problem-solving skills by proactively improving data quality by rectified discrepancies and ensuring alignment with the real objectives, enhancing data accuracy and usability.
• Utilized Google BigQuery SQL, Looker, and Spreadsheets (Google Sheets & Ms. Excel) for data analysis and visualization in most of the projects.

Jakarta, Indonesia

• Conducted a comprehensive ecommerce analysis using RFM Analysis for customer segmentation and in-depth mobile app funnel analysis, resulting in a projected 6.5% increase in conversion rate, a 24% surge in transaction.
• Devised an effective cross-selling strategy through Market Basket Analysis, projecting an overall 30.19% increase in GMV.
• Created an operational dashboard with actionable metrics for the Product Management Team in EcommerceU.
• Performed comprehensive analysis of 3 years' worth of US Superstore sales data, applying RFM Analysis and Market Basket Analysis to provide data-driven campaign recommendations, resulting in a targeted strategy to.
• Collaborated with data analytics teams to ensure effective communication and project delivery and demonstrated strong time management and organizational skills, ensuring timely and accurate completion of tasks.

• Learn about Pivot Operation, Visualization, and Validation in Microsoft Excel
• Learn about RDBMS, Data Analysis with SQL Code including Joining Table, Uses of CTE, Metadata, Blending in Microsoft Access
• Worked on a project that based on Data Forcasting, Visualizing, and Business Reporting

Bachelor Of Science - Bs, Physics

• Learned classical physics and modern physics from real-world physics into physical models using mathematics and computational tools. •.

Full Stack Data Analytics

• Committed over 13 weeks of intensive data analytics training with instructors and mentors from leading tech industries such as.