Camilo Forero V. Email & Phone Number

Sydney, Nsw, Au

Sydney, Australia

Responsible for using data analysis and machine learning (ML) models to drive informed decision-making dashboards, reduction of membership-related costs, and improvement of members’ experience. The role focused on leveraging CHOICE’s data warehouse to uncover actionable in-depth insights that supported the organization’s strategic goals and advocacy work* Developed a churn propensity model by using TensorFlow and Keras. Built the model’s data pipelines (from data feature processing to prediction) in AWS Sagemaker. Deployed the inference job within the ETL process in Matillion.* Implemented a segmentation model based on members’ browsing behaviour and financial history, trained on AWS Sagemaker k-means++ algorithm. Developed the ELT to bring data from Google Analytics (GA)’s BigQuery backend and CRM into AWS, and to send model’s inferences back into GA for audience targeting* Developed a serverless app (AWS SAM & ECR, lambda in python) to automatically extract company’s data from GA’s backend API into the data warehouse. The app retrieved 5+ years’ worth of data across various GA properties before shutting down.* Designed a ML model to calculate customer’s lifetime value (LTV), replacing the ballpark once-a-month calculation. Integrated a fully automated LTV based on 9M+ memberships into the ELT. Integrated near real-time ML LTV model into Tableau (using TabPy), becoming a decision tool for allocating ad spending* Built a ML model to forecast the customer base circulation, using a SARIMAX time series modelling in python. Implemented individual models for acquisitions, renewals and cancellations, combined them into one single model and used Monte Carlo simulation to produce predictions and confidence intervals

Sydney, Australia

Responsible for leveraging data visualization and analytics to support the marketing team’s decision making. The role focused on bringing together company’s data, designing CHOICE’s data warehouse (DWH), and building a self-serve reporting solution* Led the development of CHOICE’s first DWH in 4 months. It included requirements gathering, technology selection, and data modelling (reverse engineering on data sources due to lack of documentation). The DWH integrated customer’s membership history, email interaction and website browsing behaviour* Pioneered the migration of CHOICE’s reporting solution to the cloud (Tableau on AWS), deploying it by using AWS CloudFormation. Developed data pipelines in shell/ python scripts, to automate data ingestion, decreasing backend management effort* Collaborated in the migration of the on-premise DWH to AWS Redshift, completed in 3 months. Contributed to the redesign of existing data models to Redshift’s guidelines. Jointly, translated ETL logic into Matillion. Automated DWH maintenance tasks by using AWS lambda* Developed interactive dashboards and reports in Tableau server. Maintained associated Tableau data pipelines to ensure seamless data feed into reports. Optimized SQL queries to improve loading performance. Dashboards included members acquisition, retention, digital channel and content attribution

Sydney, Australia

Responsible for utilizing data analytics and statistical modelling to drive data-driven decisions for website operations. The role focused on conducting in-depth analysis of user behaviour, monitoring website metrics and marketing performance to optimize website’s customer experience* Designed and implemented a holistic reporting solution in Tableau by combining data from PostgreSQL and AWS Redshift, using SQL stored procedures. Dashboards included Sales vs. Forecast, Revenue Contribution Analysis, and User Cohort Analysis. Provided training on use and interpretation of dashboards* Developed a recommendation algorithm (using python and SQL stored procedures) to select campaigns to be included in users’ emails based on user’s profile and purchase history. Worked closely with Product and IT teams to deploy it. Used A/B testing to verify hypotheses on email interaction based on campaigns’ order

Sydney, Australia

* Designed, implemented and maintained the reporting solution in Tableau for all agency’s clients (11 clients, including Suncorp, AusPost, Aussie HL, Apple). Implemented ETL processes (using VBA and SQL) to bring clients’ data into agency centralized SQL Server. The reporting solution was used by other agencies

Sydney, Australia

Master of Technology Management

Helped to organise the leadership and team-building activities during the 3-day residential camp, being the experiential component of the 7-day flagship Business Leadership Program offered by ASB

Masters, Technology Management

Activities and Societies: GSA ASB UNSW

Industrial Engineer, Industrial Engineering

Bachelor, Computer Systems Engineering

Bachelor, Industrial Engineering