Thank you!

Your submission has been received! Keep an eye on your phone or email because we will contact you soon.

My Role
- As the Finance Data Manager, my role involved developing and implementing the NPMCN Sales Dashboard using Power BI & Looker Studio. I was responsible for sourcing and processing raw data from J&T & FLASH, creating the dashboard, and ensuring data accuracy.

Tools Used
- I used Power BI & Looker Studio for dashboard creation and data visualization. The raw data was sourced from J&T & FLASH, and I leveraged Microsoft Excel & Google Sheets for data processing.

Results
- The NPMCN Sales Dashboard provided comprehensive insights into sales performance, enhancing the decision-making process. This led to improved sales tracking, identification of key sales trends, and ultimately, better financial performance for the company.

My Role
- As an attendee, my role involved developing the Executed Sales Report dashboard for Adventure Works. I participated in a webinar hosted by DICT and DSA, where I utilized the provided dataset to create the dashboard.

 Tools Used
- I used Power BI for developing the dashboard and visualizing the sales data. The dataset was provided by the host of the webinar, ensuring standardized data for all participants.

 Results
- The Executed Sales Report dashboard provided detailed insights into sales performance, enabling better tracking and analysis. This contributed to a more effective understanding of sales metrics and informed decision-making processes.

My Role
- As an OJT in NPMCN Digital Marketing Services, my role involved developing a pivot table to track our jewelry sales. I designed the pivot table to provide a clear view of daily and monthly sales data, enhancing our sales tracking efficiency.

Tools Used
- I used Google Spreadsheets to create and manage the pivot table, leveraging its functionalities for data organization and analysis.

Results
- The pivot table provided a streamlined method for tracking jewelry sales, offering detailed insights into daily and monthly performance. This tool improved our ability to monitor sales trends and make data-driven decisions to boost sales operations.

My Role
- As the Finance Data Manager, my role involved developing a table to track daily and monthly sales of our general merchandise items. I also created an inventory system connected to another spreadsheet to ensure seamless inventory management.

Tools Used
- I used Google Spreadsheets for creating and managing both the sales tracking table and the inventory system, utilizing its functionalities for effective data organization and real-time updates.

Results
- The sales tracking table and connected inventory system provided comprehensive insights into daily and monthly sales, as well as up-to-date inventory status. This enhanced our ability to manage stock levels, identify sales trends, and make informed business decisions.

My Role
- As the Finance Data Manager, my role involved developing an automation system for tracking employee break attendance through Discord. The system was designed to automatically record attendance data in a spreadsheet.

Tools Used
- We used Zapier to create the automation workflow and Python for additional scripting and integration tasks. The data was captured and managed in Google Spreadsheets.

Results
- The automation system streamlined the process of tracking employee break attendance, reducing manual input and ensuring accurate record-keeping. This improved the efficiency of attendance monitoring and allowed for better management of employee breaks.

1. RTS (Return to Sender) Computation System
I also developed an RTS computation system to process raw data from J&T. Using Google Spreadsheets, I created a system that generated necessary RTS details upon input of raw data, streamlining the return data processing and improving our ability to manage returns efficiently.

2. Spreadsheet Table Connected to Pivot Table
I developed a spreadsheet table connected to a pivot table, creating a mini daily sales dashboard in Google Spreadsheets. This dashboard provided immediate visibility into CSR inputs, enhancing the efficiency of sales tracking and enabling quick monitoring of daily sales data.

During my OJT at NPMCN Digital Marketing Services, I gained experience not only as an accounting clerk but also as an editor. I edited pictures and videos using Adobe Photoshop, Illustrator, Capcut, and Canva, enhancing the digital marketing efforts with visually appealing content.

While working as an editor in the Ecom industry, I gained experience in editing using Webcake and became familiar with the Pancake process. This role enhanced my skills in web content management and editing for e-commerce platforms.

My Role
- As the Finance Data Manager, my role involved creating a CSR KPI tracker in Google Sheets to monitor CSR performance. I designed and implemented the tracker using Apps Script to automate data integration from Pancake POS.

Tools Used
- I utilized Google Sheets and Apps Script to develop the tracker, enabling automated data fetching and real-time performance tracking.

Results
- The CSR KPI tracker provided immediate visibility into CSR productivity metrics, streamlining the evaluation of individual and team performance and enhancing our ability to make data-driven management decisions.