We are specialised in SQL development for Business Intelligence and online transaction process solutions. All the codes are optimised to have the best performance, from concept to production.
All the development is documented and approved by stakeholders according to functional requirements. Roadmaps and presentations are developed to find the right track. we are using data diagrams and dictionary for better understanding and visualisation. The quality environment validates all the development for approval.
Data changes are fully audited and traced, following all the tests and deployment processes. Performance tests are required, monitoring and code validation are carefully checked. All the tests are completed before any code goes to production.
The most Recent Developments
Projects (in Progress)
|1||V8 Monitoring Project||.Net, SQL, Azure, PowerBI||Vehicle OBDII Data reading for data analysis and science.|
|2||Sales Tracking||SSIS ETL, SQL, Tableau, SSRS and Report Mobile||Sales data analysis and visualisation for comission payment.|
|3||Demand||R, MS Machine Learning, SQL, Tableau||Identify the market demanding for sales according to linear data regretion analysis.|
The most Recent Developments (completed)
|1||NZTA data loading||SSIS, SQL, Python||Dynamic spread sheet data loading from NZTA for visual analysis.|
|2||SQL Monitoring||C#, SQL CLR, Json, API, Power BI||SQL server performance data analysis in real-time for desktop and mobile applications.|
|3||Website with Elastic Search (concept)||Elastic Search basead in synonymous, SQL CLR, C#, JQuery||Comparison between SQL Full-text and Elastic search for website solutions.|
|4||Pure cloud Callcentre||SSIS, SQL, Python||Dynamic spread sheet data loading from callcentre for visual analysis.|
|5||Data warehouse - Performance||SSIS, SQL, Delta Loading||SQL Performance improvements, code rebuilding (80% performance improved).|
|6||Generator||MySQL, MS SQL||Data conversion from MySQL to MSSQL from a legacy application.|