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.

MAC Cosmetics

December 2016

MAC Cosmetics, stylized as M·A·C, part of Estée Lauder Companies, tasked Simetra with modifying their existing Microsoft Access 2010 database that tracks their make-up artist’s certifications. Our Access experts modified their Skill Certification reports across all 10 regional databases. Several revisions were made to their main form to revamp layout formats, and report parameters to calculate correct dates for their make-up artists Certifications.

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 fir 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.

Woodwork Institute

September 2016

Woodwork Institude was established as a not-for-profit trade organization dedicated to the preservation of the use of wood as a building material. Our expert developers revamped their Microsoft Access 2013 Inspection Program database on a 10-inch Microsoft Surface tablet. Our developers optimized the forms to be tablet friendly and provide a user-friendly touchscreen experience. Enhancements such as including pictures, auto-fill and clear findings, and frequency of use were among some of the capabilities that streamlined the current process for their inspectors. Along with database structure changes, reports were streamlined by being sent directly to PDF, adding pictures, and design layout changes.

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 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 a web-based interface for their applicants, management, and administration to monitor and process submitted applications. The system we developed filters applicants based on a multitude of rules and eligibility results 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 was 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 miners to utilize underground. Our developers used their existing Microsoft Access database as a prototype for the Miner’s 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's software interface is completely web based and was developed using ASP.Net and Microsoft SQL Server 2008 R2. Simetra developers created an entirely web-based application that includes a Call Log System that tracks all calls, patient visits and tests performed. A patient tracking module was also created that tracks information related to patient visits, health care providers, coverage, tests performed, among other data.

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. Only the 2nd 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