For over fifteen years, Buda Consulting has supported the Product Information, Health and Safety, and Environmental and Regulatory groups of a multi-national specialty chemical manufacturer.
We employed multiple technologies including the Oracle database, the Oracle developer suite, Crystal Reports, Perl, and Visual Basic.
- Annual TRI and TIERII Regulatory compliance reporting. – the system that we designed and implemented has reduced the annual reporting effort from three months to less than two weeks per year.
Material Safety Data Sheet creation and distribution
- Interfaces to SAP ERP systems in US.
- Interfaces to MSDGEN Compliance system inEurope
- Interfaces to ERP systems in South America andAsia.
Working with HSE Systems, an environmental and regulatory software provider (their software is called MSDGEN), we created interfaces between legacy applications, MSDGEN, and SAP for a major chemical producer.
Working with Oracle technologies, we designed and implemented a system that supports the insertion and management of up to 800M records per day for a major telecommunications firm. The system tracks firewall events across the entire corporate network and analyzes the data looking for correlations between events in order to identify attacks. We developed a sophisticated automated partitioning scheme that has enabled the system to support these extreme volumes and to run with virtually no maintenance for more than three years.
Using a similar partitioning approach, we enabled another major telecom provider handle multi-terabyte tables holding voip call records.
We built a totally custom data collection and cleansing system for an eco-friendly business that encourages recycling by allocating points to participants. We developed the system using PHP and MySQL.
Our client collects data from hundreds of recycling haulers that use various technologies to collect and report their data. We developed a system that replaces large amounts of manual data cleansing and reformatting of data with an automated process that operates in a fraction of the time. This system creates a standard data stream for the enterprise data management system and ensures valid data in a standard format together with error tracking and reporting.
This system eliminates the need for additional hires for each new area that is served by our client.
Our in-depth database security assessment helped a large multi-national bank identify and eliminate hundreds of vulnerabilities in their mission-critical Oracle and SQL Server database systems. Our ongoing security monitoring service ensures that these vulnerabilities do not return.
Our application assessment team identified significant security vulnerabilities and best-practices violations in online banking applications for another financial services provider.
Our database architecture and design services have helped county governments manage voter registration, court records, and other critical county data. In addition to database design and development services, we have also provided system architecture services, helping to save hardware cost by consolidating dozens of servers to three servers while achieving greater reliability, security, and performance.
We provide expert application best practices and database security assessment services to city agencies and other large institutions.
Our database and reporting services helped a third party health insurance processor significantly improve claim and reimbursement management and reporting. Using SQL Server, Crystal Reports, and Sql Server Reporting Services, we made significant improvements that resulted in greater accuracy, reduced manual intervention, and reduced processing time.