My Projects
A showcase highlighting some of the professional and personal projects I've worked on.
Building
www.askavendor.com
From development of business idea to building the website and creating marketing content, Askavendor.com is my personal project which is a complete end-to-end solution for businesses to connect to other businesses and users. It is designed to be scalable for the internaltional market and allows easy add-on of more functions in the form of plug-ins. In addition to HTML and CSS, the 2 main languages I used are PHP and Javascript, and SQL for the database is managed via phpMyAdmin. The data is stored on AWS. Youtube and other social pages has also been set up.
Though the site is Live, it has not yet been marketed and is inactive. Feel free to browse the site using the below credentials.
Username: democorp@aav.com | Password: Password1
SKILLS USED
Strategy Planning & Implementation
Database Management with SQL
Web Design with HTML & CSS
Programming with PHP & Javascript
Setting Up Team
Work Flows
A minimiature version of an order management tool I created to support a new business department in my company which did not have enterprise solutions to do so yet. This particular version is created using Google Sheets, but I have itulized other software such as Excel and PowerBI to manage and study data as well.
This miniature version includes:
● Order entry and management page
● PDF Delivery Order generation tool
● Product master list
● Dashboard summarising sales data including forecasts
Full version consists of more features including:
● Finance interface for invoice generation and monitoring P&L
● Purchase Order generation and management tools
● Warehouse stock management tool
● More complete dashboard
SKILLS USED
Analyse systems & requirements
Spreadsheets Data
Scripts & VBA for Macros
Planning & Forecasting
Reporting &
Data Visualisation
Below is a Dashboard which I created to share with clients as a replacement for frequently generated Cadence Reports. It helped improve team efficiency and client satisfaction. Some dashboards were created using PowerBI, but this particular one shared here uses Google's Looker Studio due to software license/sharing limitations.
SKILLS USED
Identifying and setting up Data Models
Softwares PowerBI and Looker Studio
Establishing
communication matrices
Practical Live Visual Dashboards
Process Automations
Extracting data and listing thousands of products is inefficient if done manually. To help the team (and company) with this, I programmed the process using Python. Ikea was one of the brands handled by my company and they had thousands of products and was in high demand. So one of the first targets for the automation tool was Ikea website. This automation helped improve work efficiency and business results tremendously.
from bs4 import BeautifulSoup
import requests
import re
import xlsxwriter
import wget
workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()
f=open('samplelist.txt')
text=f.readlines()
# print(text)
# f.close()
a=[]
[a.append(line.rstrip("\n"))for line in text]
# print(a)
row = 0
col = 0
rowtotalvol = 0
SKILLS USED
Programming with Python
Extraction & Data Wrangling
Improving work efficiency
Understanding Team Pain Points
Marketing
Saamaanu.com
Planned and executed entire marketing strategy from start for an new e-commerce business. In addition to setting up and managing the marketing tools on multiple platforms, I also personally prepared a number of creative content for the business.
Created multiple design assets including online Ads, print media. Also helped get sponsorships and organised roadshows.
Created video Ads which were included on multiple platforms including Youtube & even TV. Also launched a successful rewards program.