DATABASE DEVELOPMENT

We are developing your solution following the best practices

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.

Quality Environment

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.

Production Environment

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.

Development

All the database objects including: views, triggers, stored procedures, data schema, database models, linked servers, auditing codes and permissions.
Extract, Transform, Load data from different data sources, including Oracle, MS SQL, Flat Files, Big Data, APIs, Websites and legacy applications for data integration.
Data warehouse development following Kimball methodology including all the dimensions and fact tables. Data stage and ETL in SSIS for better visualisation and maintenance.
R and Python are the best combination for development, delivering friendly and fast performance.Tableau and Power BI are excellent solutions for data visualisation.

Development Stages

Without a perfect plan, calculating the strengths and weaknesses of the project, development of software is meaningless. Planning kicks off a project smoothly while improving progress.
This step is about analysing the performance of the software at various stages and making notes on additional requirements. Analysis is very important to proceed further to the next step.
Once the analysis is complete designing takes over, this is when the project's architecture is built. This step helps remove possible flaws by setting a standard.
The actual task of developing the software starts here with background data recording. Once the software is developed, implementation begins where the product goes through a pilot study to see if it’s functioning properly.
The testing stage assesses the software for errors and bugs.
Once the software passes through all the stages without issues, the maintenance phases can begin. Wherein software will be maintained and upgraded to adapt to changes.

The most Recent Developments

Projects (in Progress)

# Name Technology Description
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)

# Name Technology Description
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.