job simulation – nug ian

PwC Switzerland: Workforce Gender Diversity Analysis

As part of the PwC job simulation on The Forage platform, a hypothetical telecommunications company approached us seeking insights to address gender imbalance within their workforce. They provided a dataset containing employee demographics, job levels, performance ratings, tenure, and promotions, among others. Using Power BI, I visualized and analyzed the dataset, uncovering the following key insights:

PwC Switzerland: Telco Customer Retention Analysis

As part of the PwC job simulation on The Forage platform, I worked on a case study involving a hypothetical telecommunications company seeking recommendations to address customer retention challenges. The company provided customer data, including details about those who had discontinued their services.

KPMG Australia: Bike Store Customers Prioritization

This project was completed as part of the KPMG Australia job simulation on The Forage platform. A fictional bike and cycling accessories store sought assistance in optimizing their marketing strategy by identifying which new customers should be prioritized for outreach. To achieve this, I worked with datasets containing demographic and transaction history for existing customers, as well as demographic data for new customers.

Accenture: Social Media Views Analysis

This project was completed as part of the Accenture job simulation on The Forage platform. A fictional social media platform sought assistance in gaining insights from their content data. The provided dataset included details such as content categories, content types, and user sentiments. I conducted the analysis using Python, along with libraries like Pandas, Seaborn, and Matplotlib.

BCG: Telco Customer Retention Analysis

During the Boston Consulting Group (BCG) job simulation on The Forage platform, I worked on a project for a fictional energy services provider seeking recommendations to improve customer retention. To support their efforts, I analyzed customer data and built predictive models using the provided information. The dataset included historical energy pricing and customer subscription details.

Deloitte Australia: Machinery Status Monitor

As part of the Deloitte Australia job simulation on The Forage platform, I worked with a fictional heavy machinery manufacturer who needed a data dashboard to monitor the health status of their machines across global factories. I created a dashboard using Google Looker Studio to visualize the live-streaming telemetry data from the machines.

Goldman Sachs: Cupcake Shop Financial Modeling

This project was completed as part of the Goldman Sachs job simulation on The Forage platform. In this case, I was tasked with assisting a client, a fictional cupcake shop, in financial modeling. I created Excel reports including forecast assumptions, a Profit and Loss (P&L) forecast, a cash flow forecast, along with visualizations of the projections. Throughout this task, I utilized various Excel functions to perform the necessary calculations.

The Excel file can be accessed at Microsoft One Drive or Google Drive, and the certificate of completion for this project is available here.

Cover photo by Julias Torten und Törtchen

JP Morgan Chase: Loan Default Prediction

This project was completed as part of the JP Morgan Chase job simulation on The Forage platform. In this case, a bank client tasked me with building a model to predict the probability of loan defaults based on customer characteristics such as income, loan amount, and years of employment. I conducted a thorough analysis of the provided customer dataset and then developed a predictive model.

JP Morgan Chase: Natural Gas Price Forecast

This project was completed as part of the JP Morgan Chase job simulation on The Forage platform. A fictional commodities trading company approached us seeking to capitalize on natural gas price fluctuations to maximize profits. I was tasked with developing a price forecasting model using four years of historical data.