PROJECTS

Storage Report

Online Interface to track Client Storage usage over a period of time

Tech: Python, SQL

    • Python program extracts csv from a watch folder weekly & performs data cleaning
    • Loads data into SQL data & use SQL ‘view’ for further cleaning
    • Use SQL Server Reporting Services (SSRS) to enable users to analyse data 

 

Fuzzy Matching App

Python Application for Data matching

Tech: Python

    • An exe when run prompts users to enter filename
    • Browses local drive for file name (only searches for .csv)
    • Opens csv, performs data cleaning & fuzzy matching
      •  Data cleaning: remove special characters, leading & trailing spaces and standardise words (lowercase) 
      • Using a python algorithm used to compare data in columns.
      • Columns examples: First/Middle/Last Names,Initials, Address, Company, Phone Number, Age
      • Score generated for match accuracy
      • Generates output of matches with various excel formatting applied

 

Sales Analysis

Online Interface to analyse Sales & Product Performance

Tech: Python

    • Import sales & CRM data from flat file to SQL using ETL process
    • Create interactive website using Django where users can query sales & CRM data 
    • Analysis examples:
      •  Product analysis to find out high selling product for a chosen period
      • Product analysis to find out product with high return/repair rate
      • Territory analysis to find out sales to a territory for a chosen period