Case studies

Custom Tool for Personalized Products Manufacturer
Jim Hayslip
Data Warehouse Specialist, Manufacturing Company
Project summary

Business Logic coded two projects for a promotional equipment manufacturer. Using C Sharp and SQL Server, they created a data reporting system and a data management tool.

Project category:
Custom Software Development
Project length:
Feb. 2015 - Feb. 2018
The review

We make promotional equipment for small businesses, such as pens and keychains. Businesses can put their logo on our products for publicity and marketing purposes. I manage our data warehouse and business intelligence team.

Opportunity / Challenge

We market to businesses in over 20 countries and needed to improve our visibility. We wanted to extract all our Google Analytics information and build a data warehouse for at-a-glance reporting.

What was the scope of their involvement?

We presented the requirements from our e-commerce and business logic teams. They learned about the Google Analytics API and pulled the data they needed to reproduce those reports in our internal system. Our application is a C Sharp program that culls our accounts and passes data through stored procedures to our SQL Server platform. Once they finished it, they trained us on how to use it. They still occasionally help us troubleshoot bugs or make modifications.

The second project we worked on together was our campaign management tool (CMT). We needed a way to streamline our marketing campaigns with our list processing and forecasting departments. It uses similar technologies and programming language to the first project, with a plug-in that triggers based on the URL. It helps the marketing department build mailing campaigns and compile affiliated data by gathering results and creating reports. We’ve finished testing it and it’s now live. They’re gradually transferring control over to us as we handle some of the remaining issues.

What is the team composition?

We always work with Martin (Partner, Business Logic), who appoints a developer to work with us.

How did you come to work with Business Logic?

Martin worked with our company for a while and I was always impressed with his work. We wanted to stay engaged with him when he started his new company.

What is the status of this engagement?

We started working on the first project in February 2015. We had a quick turnaround and finished in April or May 2015. After that, we started the second project. They delivered that in February 2018.

Results and feedback
What evidence can you share that demonstrates the impact of the engagement?

The Google Analytics extract saves our team over 50 hours of work each week, thanks to the automatic reporting. The CMT has also increased production exponentially. I estimate that 15 marketers each save three hours per day.

How did Business Logic perform from a project management standpoint?

They do their homework upfront, gather the necessary requirements, and optimize the architecture to fit your needs. Their response times are great, even when they’re processing a lot of data. We communicate through email, WhatsApp and messenger. We’re in the same time zone and Martin’s English is excellent.

What did you find most impressive about them?

The quality of the code is very good. Everything is logical, well-documented and efficient. Their deliverables are always clean, professional, and optimized. The quality of their work really impresses me.

Are there any areas they could improve?

There are always things to fix when they first hand over the code, but that’s normal.

Do you have any advice for potential customers?

Know your requirements ahead of time and be specific at the beginning. We missed a few variables for the CMT application and our list of requirements was incomplete. They had to rebuild some of the architecture after preliminary testing because we weren’t thorough enough.

Kontaktujte nás

Vaše dotazy nás posouvají dále. Neváhejte se na nás obrátit s jakýmkoliv požadavkem.

Vědeckotechnický park ICT
Nad Stráněmi 5656, 760 05 Zlín
Česká republika
phone+420 576 013 706
Opletalova 4
110 00 Praha 1
Česká republika
phone+420 576 013 706
Dolní náměstí 309/1
755 01 Vsetín
Česká republika
phone+420 734 698 472
Nový Jičín
Palackého 23
741 01 Nový Jičín
Česká republika
phone+420 603 299 687

Nebo nás sledujte na sociálních sítích

innovation by software