Read our Case Studies, Portfolio and Expertise | Simetra

Case Studies

Our clients are small and medium size businesses and are in many industries including legal, health care, and manufacturing.

An Entertainment Company

June 2018

An entertainment company, tasked Simetra with a way to save time in producing complex royalty calculations based on Television industry data. The calculation required the amalgamation of millions of rows of TV program air time data in both the US and various international countries. Simetra developed a SQL Data warehouse that consumes data from two sources:

  • Daily feeds in the form of zip files from a TV program air time service via ftp.
  • Rate and producer information from an internal application written in Microsoft Access.

Simetra used SQL Server 2016 to build the database and tables for the system. SQL Server Integration Service packages were developed for the ETL process that talks to the subscription ftp server and downloads the daily feed. The data is aggregated and mapped to specific data from the internal application. Our client has access to this data for analysis via Excel Power Pivot.

Morgan Picks LLC

January 2018

Morgan Picks is a real estate investment firm specializing in distressed properties. They were using Microsoft Excel to manage their Purchase, Eviction, and Rehab to Sale processes. After 2 years of growth, with 85 active properties and 400 properties in their portfolio, the Company outgrew the spreadsheet solution. Only one person could update any of the 6 spreadsheets at any one time. This became a major road block. In addition, the data in this format could not provide metrics reporting.

Simetra developed a SQL database and Microsoft Access Solution to manage their Purchase, Eviction, Rehab, Listing, Escrow, and Sale processes. Simetra used SQL Server 2014 to build the database and tables for the system. The data was imported from the spreadsheet system at final installation. The new system enables multiple users to access and query the portfolio at any point in time during the process and have the data delivered to them via Excel for analysis.

In addition, Simetra also used the Quickbooks SDK to link QuickBooks data with the Access database, allowing them to update each property's Financial data directly.

American Hydrotech, Inc.

November 2016

American Hydrotech, Inc. is a recognized leader in the development, production, and distribution of premium waterproofing and roofing products. Our Access experts helped American Hydrotech optimize their Microsoft Access database by converting from a 2003 to 2013 version. One of their goals was to increase performance speeds. We accomplished this goal by adding Referential Integrity and Primary Keys along with cleaning up their data. The expansion of the main form to fit on a 1280 x 1024 resolution improved their design layout. Additional functionalities such as: new fields, modified drop down data, sorted drop down results, and maintenance forms for administration were added to enhance their database.

Kayne Anderson Capital Advisors, L.P.

July 2015

Kayne Anderson Capital Advisors, L.P. is a leading alternative investment management firm focused on niche investing. Our .NET expert developers created a custom customer relationship management (CRM) system to track contacts, hot keys, and export reports to Microsoft Excel. Our team of expert developers customized their Search by adding Google Maps and plotting capabilities to their results. This software’s interface is web-based and was developed using and Microsoft SQL Server 2012.

East Bay Asian Local Development Corporation

March 2016

East Bay Asian Local Development Corporation is a non-profit community development organization. Our expert .Net developers created web-based interface for their low-income housing application process. The system allows Applicants to apply via an online application and has an internal Management and Administration module for monitoring and processing submitted applications. The system we developed includes a robust filtering engine for applications based on a multitude of rules and eligibility requirements, such as household size, median income, number of occupants, or whether they applied previously. The results for each session vary based on their business logic. A report module was built for management to send corresponding reports to their applicants. The software’s interface is developed using and Microsoft SQL Server 2012.

Solvay Chemicals, Inc.

July 2015

Solvay Chemicals, Inc. is a global company driven by proud and committed chemists. Our SQL Server experts created a custom intranet Management System for their mine workers to utilize underground. Our developers used their existing Microsoft Access database as a prototype for the main input form; we re-designed the backend database to streamline their processes for management, crew, and employees. This management system tracked Production, Audit Trails, and provided quick entry screens, statistic reports on production and miners. The intranet interface was written in PHP and Microsoft SQL Server 2008 R2.

Global Cardio Care, Inc.

December 2013

Global Cardio Care is a physician management company. A company specializing in an alternative heart bypass solution with EECP (Enhanced External Counterpulsation) and the Sara Soulati Health for Life Program.

Simetra was retained to develop a web-based solution using ASP.Net and Microsoft SQL Server 2008 R2. The web-based interface includes a Call Log System that tracks all calls, patient visits and tests performed. A robust patient tracking module was also created that captures information on each patient visit, such as health care providers, coverage, and tests performed. Simetra has provided on-going enhancements and modifications to include robust reporting solutions, automatic reminders, and test result analysis.

Bruker Daltonics

December 2013

Simetra .Net programmers created an entirely web-based Purchase Request System to track purchase requests, approvals and denials for requests. Our web-based solution has eliminated creating purchase requests manually by hand. The software’s interface is web-based and was developed using and Microsoft SQL Server 2008 R2.

Greater Los Angeles Auto Show

November 2012

The Greater Los Angeles Auto Show is an annual auto show that has taken place at the Los Angeles Convention Center in Los Angeles, California since 1907. It is only the second International Auto Show in the United States to be officially recognized by OICA. The Los Angeles Auto Show hired our .Net programmers to create a custom web-based application to streamline their internal process of over-the-phone media registrations. Attendees were able to request and submit their credentials online for Press Days. This software’s interface was developed using ASP.Net and Microsoft SQL Server 2008 R2.

Get a Free Consultation Now

Retype the CAPTCHA code from the image
Change the CAPTCHA codeSpeak the CAPTCHA code