Experience | Big Heart Pet
Big Heart Pet logo

Big Heart Pet Brands

Del Monte Center
375 N Shore Drive
Pittsburgh, PA 15212

Operations Analyst

10/6/2014 – 2/18/2015

Big Heart Pet is a new company spawned out of a divestiture with Del Monte Food, Inc. The separation of the two companies required a re-working of hundreds of custom-developed web applications to accomodate the individual needs of each entity.

I was contracted to assist in the evaluation, analysis and resolution of the tasks involved in adapting, configuring and deploying a variety of Visual Basic.NET applications and related SQL Server data resources.

Projects I participated in included identifying and extracting information from the enterprise-level HR database to separate the data and application into discrete repositories. I wrote SQL quries to manipulate the database and analyzed and modified the source code of the application to accomplish legal specifications regarding the separation of the two newly-formed business units.

I wrote applications to extract binary data from a database (BLOBs) into individual files separated by business unit. The application included dynamic generation of an Excel spreadsheet with information about the files and with pointers linking to the server location where the files were stored. I used the Microsoft Interop assemblies to create and populate the spreadsheet as the data was retrieved and written to disk.

I developed an application to implement archiving customer-created files into an enterprise archiving utility (Mobius). The application involved picking up a file or files from a network drop location and building summary and batch files appropriate to each file. This application was built to create audit-compliant backups of all current and future BHP customers.