Salmat Work & Projects

Swan Tafe - Survey Application

around 100 unstructured (Word) documents with 150 questions and answers, answers being of various types.

• ETL to a new Database

• Data processing module: Imports and data entry forms

• Data reporting module: Saved queries for advanced users and Reports

BankWest – Large customer data consolidation project

Large customer data consolidation project.

Source data – around 80 files, structured or semi-structured containing 1.3 mil records.

• ETL into a new database and data enhancement

• Customer segmentation, flagging and aggregation

• Parameterized queries for easy extractions of desired data subsets for advanced users

Data Migration/Application re-design project

Input data: Paradox 2 database
Target system: line printer

Work done:

• Analysed source system and learned business rules
• Created new MS Access database
• ETL into MS access database and data enhancement and categorisation
• Created output format suitable for printing on the line printer

Database Application Development – full SDLC

Job allocation and time scheduling application for internal use. It was also aimed to collect knowledge for better resource allocation planning and customer quotes:

• New database with jobs entry form and real time scheduling

• Analysis, Aggregations and Reporting including trend analysis, productivity, efficiency, KPIs

• Archiving