top of page

Employment History

FreeLancing.JPG

  • Created SQL Server database triggers, views, ETL stored procedures, user-defined functions, and Powershell scripts

  • Created SSRS reports based on OLAP Cubes and OLTP database objects (MS SQL Server Views and User Defined Functions)

  • Created Excel Services reports (based on OLAP Cubes and OLTP databases objects) and deployed to Sharepoint 365

  • Created MS Access databases with SQL server back end and VBA scripts

  • Building Power BI dashboards and deployed to Sharepoint 365

  • Web-enabling existing legacy MS Access applications using Citrix -> Azure farm and Sybelesoft->Thinfinity VirtualUI

  • Reading live XML file to the SQL Server database by combining consumed and unconsumed XML data.

  • Created a set of VBA utilities which leverages on Powershell, Word, HTML, SMTP, Script Control, libraries

upwork.com, guru.com, freelancer.com.au

 

Jul 2019 to Current

-

Coates Hire

 

Sep 2016 to Jul 2019

 

  • Establish detailed program specifications to meet requirements

  • Effectively manage various development work streams

  • Accurately anticipate possible problems and devise solutions

  • Deliver the development of items within estimated times; ensure quality and accuracy

  • Analyse and diagnose system / data related issues and appropriately resolve them

  • Source to Target Data Mapping

  • Ensure documentation of all solutions is kept up to date

  • Design and development of ETL, data transformations and data management processes

upwork.com, guru.com, freelancer.com.au

 

Nov 2014 to Sep 2016

  • Creating SSRS reports based on OLAP Cubes and MS SQL Server Views and User Defined Functions

  • Creating database triggers, views, stored procedures, user defined functions and SQL Server Command Line scripts

  • Modifying/Tuning/Re-factoring report queries (Oracle and SQL Server)

  • Perl scripting

  • PHP scripting

  • Creating MS Access databases, VBA scripting

  • Creating MySQL databases, scripting

  • Powershell scripting

 

Tribal Group 

​

Aug2014 to Oct 2014

  • Modifying existing SSRS reports. Data source is Oracle 11g database.

  • Modifying/Tuning/Re-factoring report queries

Curriculum and Learning Innovation Centre (CLIC) – Part of the Department of Education and Communities NSW

 

Nov 2010 to Aug 2013

  • Designing, developing and implementing a corporate Business Intelligence solution using SSAS, SSIS and SSRS.

  • Developing a corporate Dashboard using Sharepoint 2010, Performance Point.

  • Creating KPI reports based on various data sources (Oracle, SQL Server, Sharepoint, MS Access, XML, MySQL) as well as MS SSRS, MS Excel 2010 and Power Pivot.

  • Creating custom MDX queries for SSRS and Excel reports.

  • Developing REST and SOAP WEB Services in PHP for loosely coupled system integration.

  • Developing Teamsite content entry forms and templates integrated with JQuery and .Net pages. Creating MS Access Project applications using MS Access (front-end) and SQL Server (back-end).

  • Data modelling and creating ERD for SQL Server applications

Centre for Learning Innovation (CLI) –

Part of the Department of Education and Training NSW

 

Jan 2004 to Nov 2010

  • Developing corporate Dashboard using Sharepoint 2010, Performance Point.

  • Creating custom MDX queries for SSRS and Excel reports.

  • Creating KPI corporate reports based on various data sources (Oracle, SQL Server, Sharepoint, MS Access, XML, M

  • Creating a corporate Business Intelligence solution using SSAS in MS SQL Server 2008 R2.

  • ySQL) using MS SSRS, MS Excel 2010 and MS Power Pivot. Managing PHP Open Source project (Curls).

  • Designing and developing CLI core Internet and Intranet application in Teamsite.

  • Integrating .NET applications and web-services, Verity Enterprised Search (for Teaching and Learning Exchange – TaLe 2.0, Learncast, WeCreate, Online resources catalogue, Government Schools, CLAS Schools, CLAS TAFE) with Teamsite generated systems.

  • Creating MS Access Project (Timetracking, Asset management and Information management) applications using MS Access (front-end) and SQL Server (back-end).

  • Data modelling and creating ERD for SQL Server OLTP applications as well as designing OLAP CUBEs for Dashboard application.

Open Training and Education Network (OTEN) –

Part of the Department of Education and Training NSW

 

Jan 1996 to Jan 2004

 

  • Designing, coding, testing new programs, and enhancing of existing programs of Student Administration and Management system (SAM), a core corporate application created in the following environment: Oracle Enterprise 9i, Designer/2000, Oracle Developer/2000 Form Builder, Oracle Developer/2000 Report Builder, Oracle Discoverer 2000, Oracle WEB Application Server, SQL*Plus, Toad, HTML, XML, Javascript, and R&R 6.0 Report Writer.

  • Developing of various packages, triggers, procedures and functions for SAM. Creating customized packages, libraries and utilities depending on SAM requirements.

  • Converting Dbf and MS Access tables into Oracle using SQL*Loader.

  • Creating several unique corporate client server and intranet applications using MS Access, Development Toolkit, VBA, Visual Basic, ASP, SQL Server 2000, MS Project 2000.

  • Reengineering an MS Access & MS Project application into an SQL Server & MS Access application.

  • Creating user guides and technical documents.

  • Data modelling and creating ERD for MS Access and SQL Server applications

Melamed Vision

bottom of page