Maricris Resma

Customer Satisfaction Analysis
for Maple Digital Map

Perform customer segmentation to identify advocates, promoters and detractors for future LTV potential. Monitored KPIs such as total users, DAU, CSAT and customer sentiment. Unveiled insights on strategies for better customer retention and increased customer reach.

#Python #PowerBI

• View Project

COVID-19 2024 Analysis

Used SQL to extract data from COVID dataset. Created Dashboard in Power Bi to connect to MS SQL Server and summarize data showing Global Stats of Total Covid Cases and related Deaths.

#SQL #PowerBI #DAX #PowerQuery

• View Project

Product Inventory Management Database

Created a database for managing product orders and inventory for the bakery business in MongoDB. Developed local web application with UI to handle various HTTP request methods. Backend development used Django framework and pymongo to perform CRUD on the database.

#MongoDB #NoSQL #Python #Pymongo #Django

• View Project

ECOMMERCE SALES ANALYSIS

Ecommerce sales analysis dashboard providing a comprehensive view of our business performance, focusing on year-over-year (YoY) growth. The dashboard features intuitive visualizations, including combo charts and bar graphs, that display sales trends over time. These visualizations are interactive, allowing users to drill down into specific time periods or product categories for deeper insights.

#Excel #DAX

• View Project

customer SENTIMENT ANALYSIS

Used NLP on customer reviews to identify common themes and issues that lead to customer dissatisfaction. Built a predictive model to predict customer sentiment based on feedback.

#Python #PowerBI

• View Project

Fraud Prediction Model
for Enhanced Risk Management

Built a model with a recall score of 95% that can predict likelihood of a credit card transaction to be fraudulent using Decision Trees, Random Forest and XGBoost and successfully deployed in GCP. Gained insights to focus on rule-based system on transactions from high-risk locations to prevent potential fraud.

#Python #GoogleCloudPlatform

• View Project

Adventure Works Sales Analysis

Built a Excel dashboard to identify sales seasonal fluctuations, high-performing products, and potential areas of decline by creating a report that can track profit trends over time, including revenue, units sold, and COGS.