Contracted development business

Sales management system development and maintenance (using AWS)

Development and maintenance of a new sales management system for a major wholesale company

customer request
Data linkage with mission-critical systems and other systems, and various master management
We would like to see the development of a function to manage receiving, order, and sales information and to output various forms.

Contents of response
1. our experienced system development team members regularly visit the customer's work site to understand the work flow.
2. propose and develop the implementation of various input assistance functions on the terminal.
3. By proposing the use of AWS cloud services, the system went live in a short period of time.
4. establish an environment for AWS cloud services and formulate operational procedures.

functional configuration
Product/client/employee management
Receiving schedule / Ordering / Inventory control / Auction floor sales / Expense management
Sales/purchase management and sales analysis/purchase analysis/inventory analysis/loss analysis

scope of work
Development system: Survey analysis / requirement definition / basic design / development and testing / production release / operation and maintenance
Infrastructure: AWS environment construction/operation and maintenance

Effects after system introduction
1. a wealth of input assistance functions have been implemented to significantly improve the work efficiency of sales operations.
2. AWS cloud services eliminated the need to purchase servers and other hardware in-house, reducing initial costs and maintenance and management costs.
3. AWS backup functions were utilized to ensure data integrity in the event of a disaster.
4. daily overtime hours per person in sales-related departments were reduced by 2 hours.　(Significant cost reductions were achieved.)
5. performance and profit/loss analysis for each sales representative and each trading company is now possible.
6. electronic data conversion of forms and documents related to transactions has reduced paper and mailing costs and greatly reduced data entry and other tasks.
This contributed to cost savings for the company.

Migration WEB system from Excel and VBA

Business DX　Migration of Excel and VBA-dependent operations to a web-based system on AWS without changing specifications

AWS utilization enables web system construction with quick turnaround time!
Excel data is converted to DB and used for management analysis!

customer request
I have been using Excel and VBA for 30 years for order, sales, and customer management,
Management with Excel data is reaching its limits.
Business specifications are not known because the person in charge has been transferred or otherwise disappeared.
We do not want to change the existing work flow and familiar input/output.
We would like the system to be built to the same specifications as the existing Excel system.

Contents of response
1. our experienced system development team members regularly visit the customer's work site to understand the work flow.
2. our VBA experts will investigate existing EXCEL macros and VBA, and provide a detailed description of the existing VBA and EXCEL macros,
From there, we reverse engineer the specifications and confirm them with the client.
3. By proposing the use of AWS cloud services, we were able to get the system up and running in a short period of time.

scope of work
Development system: Survey analysis / requirement definition / basic design / development and testing / production release / operation and maintenance
Infrastructure: AWS environment construction/operation and maintenance

Effects after system introduction
1. a large number of Excel files have been organized and can now be managed centrally.
2. preventing the use of Excel for management tasks, and avoiding the risk of maintenance failure due to retirement or other transfers.
3. daily data accumulation is now managed in a database instead of an Excel file, making it easier to integrate multiple data sets and to use them for management decision analysis.
4. the system's cloud computing enabled data entry work outside of the office, reducing work on holidays and overtime work on weekdays.

Handy Terminal Linkage System Development (Android)

Business DX The data linkage function greatly improves the work efficiency of sales operations!

customer request
Change to the latest handy terminal model and add data linkage function with electronic scales and download master information,
I would like to see the development of sales operations, printing of forms, and uploading of sales information.

support
1. selection of a handheld terminal model to meet customer requirements
2. investigate the interface of the handheld terminal, design and implement the specifications for the linked operations.
3. additional auxiliary functions to streamline sales operations

scope of work
Development system: Survey analysis / requirement definition / basic design / development and testing / production release / operation and maintenance
Infrastructure: AWS environment construction/operation and maintenance
Hardware: Handy Terminal Model Selection

Effects after system introduction
1. abundant input assistance functions and data linkage functions have improved the work efficiency of sales operations.
2. the switchover from an out-of-maintenance handheld terminal to the latest model was completed, significantly improving work efficiency.

 Contact us

If you have any questions about our contracted development services, please contact us from the Contact Us page.