Tim Afflerbach - Clients
A sample listing of just a few clients from over the last 24 years...
Buckeye Partners, L.P. https://www.buckeye.com
Buckeye Partners, L.P. (NYSE: BPL) is a publicly traded master limited partnership which owns and operates a diversified global network of integrated assets providing midstream logistic solutions, primarily consisting of the transportation, storage, processing and marketing of liquid petroleum products.
Multiple data integration projects, from transforming 900 Excel workbooks, spanning hundreds of folders, into 1 recordset to be imported into SQL Server, to converting an existing spreadsheet (Dig List) that was shared and edited by many project managers to a multi-user, single app that uses SQL Server as a back-end for all stakeholders to modify and see data changes in real time.
PPL Electric Utilities
For 6 years, I committed all my resources to developing applications and creating highly functional and integrated Excel/Access/SharePoint applications for many departments in the PPL infrastructure. From an application to manage all the Vegetation contractors to the Storm Resource Tracking Database, these applications were hybrids between MS Access, SharePoint, and Oracle to deliver highly functional, mission critical applications that helped keep the power on for over 6 million customers.
Air Products and Chemicals, Inc.
Utilize VBA skills to convert product usage from plants in Asia into specific invoice line items individualized per contract mathematics (price tiering).
Lehigh Valley Health Network
Designed and built MS Access applications for the IS Security department. Applications range from a user programmable automated data transfer program to a corporate wide systems audit application. Monitor automated systems and handle errors. Handle 2nd level security authentication support calls for network and over 150 applications.
"Production Management Control System" for FSI Products Inc.
Design and implement MS ACCESS database/application to handle all phases of product manufacturing including quotes, ad hoc queries, and reporting. Recommend and administer a client/server solution to upgrade from a peer to peer network by setting up and implementing an MS NT 4.0 network, utilizing MS Small Business Server.
The Accounting department needed a way to get more done in less time. Since much time was spent formatting, merging, and adjusting Excel spreadsheets, a solution was needed to increase productivity. Several VBA macros were created to do the work of “many hours” that take now literally 20 seconds to run!
“BMC Quoter” for Bracalente Manufacturing Inc.
Redesign legacy quoting system for ease of use using MS ACCESS that can interface with ERP system. Import/convert old legacy data, improve performance, redesign new front end utilizing MS ACCESS, SQL Server, and VBA.
“Auto Web” for Pennmark Autogroup Inc.
Mercedes/Porsche Dealer needed to automatically convert dissimilar E-mail based lead information to an MS Access sales database. Using MS ACCESS and VBA, a solution was created to automatically parse and import the sales lead information from MS Outlook and save the data into an MS ACCESS sales database.
"T-Time" Reservation System for 'Olde Homestead Golf Club'
MS ACCESS application manages reservations and times for golf club. From reservation taking, golfer data and tracking reservation history, to special reports, this application organizes the critical schedule of this busy club.
Hoffmann La-Roche Pharmaceuticals NJ
Design and roll out new MS ACCESS/VBA applications for the Quality Management/Assurance department. Upgrade, enhance, and address performance and Y2k issues with earlier versions of MS ACCESS databases. Design and implement Y2k protocols for FDA approval. Implement strict security protocols utilizing MS ACCESS security features.
Reed Technology and Information Systems (Legal/publishing industry)
Design applications to format text for magazine directory layouts using MS ACCESS/VBA/SQL, adding HTML tags, and interacting as a client liaison.
“I can't thank you enough for doing this program for me. It works wonderfully, and it saves me so much time.”