Provided Services:

• Software architecture and development
• Data model analysis and implementation
• Database Tuning
• Database and web server High-Availability
• Redesign and develop from ASP.NET Web-Forms to ASP.NET MVC
• Redesign and develop from ASP.NET MVC to ASP.NET Core

Project Scale:

• Classified advertisements website with over 9k concurrent online visitors
• Over 5k concurrent queries on the database
• More than 30GB data growth per day

Main Technologies:

• Microsoft SQL Server
• Microsoft .NET Framework
• Microsoft .NET Core
• Redis

Summary:

In this project, our client had a mission-critical database and many performance and security issues with their servers. So, we designed a distributed architecture to limit the traffic of each region (Province) to appropriate server and High-Availability between regions. This architecture solved performance issues on heavy workloads and brought flexibility to the client’s topology.

Provided Services:

• Data architecture redesign
• Database Replication
• Database Server High-Availability
• Server and Database hardening
• Database design enhancement
• Database Tuning

Project Scale:

• 45 Database Servers distributed in 23 provinces
• 15GB daily data growth
• 24x7 mission-critical databases

Main Technologies:

• Microsoft SQL Server
• Custom monitoring and orchestration application developed in .NET Framework

Summary:

One of our main expertise is database development, administration, and tuning. We provided these services to many clients, including PSPs, Retails, and Manufactures with large databases and significant concurrent requests. Usually, these clients have 24x7 services, and we should design our improvement plans according to this situation and without downtime.

Our main services provided to PSPs

• Data architecture audit
• Database server security audit and hardening
• Database Server High-Availability
• Database Tuning (Architecture, Queries, Infrastructure)
• Professional database server design and config

Main Technologies:

• Microsoft SQL Server
• Oracle Database

Provided Services:

• Data Cleaning for distributed train ticket selling platforms
• Data Visualization and Demonstrating important points to the marketing team
• Using Association Rule to identifying impressive factors
• Classifying customers in different manners

Achievements:

• 30% revenue growth in 6 months
• Customer satisfaction improvement by 24%
• 15% saving in advertising costs

Main Technologies:

• Microsoft SQL Server
• Tableau
• R

Provided Services:

• Developing ETL for gathering data from different sources
• Data Visualization
• Identifying between costs, services, customer gain, and revenue

Main Technologies:

• PostgreSQL
• Python
• Seaborn
• Scikit learn

Provided Services:

• Data Cleaning for deals database
• ETL for making integrated clean database of deals
• Data Visualization for demonstrating price changes and trends
• Developing custom web app for managing entries
• Developing models for estimating
• Developing price estimation and recommended price services (REST)

Achievements:

• Estimating accurate prices (RMSLE=0.1745)
• Increasing successful deals by 23%
• Decreasing cost of ad moderation by 20%

Main Technologies:

• Microsoft SQL Server
• Python
• Scikit Learn, NumPy, Pandas
• Flask-RESTful