My expertise includes developing tools, systems and applications (using MS Access, MS SQL Server, MS Excel, VBA, Macros, Pivot Tables), building customized dashnoards, financial models and reports, and connecting to other MS Office Applications, databases, and data feeds etc.
Examples of completed projects include the following:
> AmerisourceBergen Corporation needed a sales compensation management system for nearly 500 persons receiving incentive compensation payments. In response, I developed a Compensation Management System in MS Access that helped analysts and accountants maintain detailed employee records and related compensation plan data including performance metrics for each employee in each role over a three year period. System included modeling capability which allowed senior executives to determine the annual costs/savings of various changes to compensation plan metrics.
> Johnson & Johnson needed a system to manage suppliers. In response, I developed a customized Supplier Management System (MS Access front-end, MS SQL Server back-end) enabling company buyers to track suppliers, contacts and raw material items purchased from suppliers. Result: Johnson & Johnson buyers can quickly access supplier historical data and track changes in supplier name and supplier contacts.
> Johnson & Johnson needed to trace the origin of manufacture for raw material items purchased from Suppliers. In response, I developed a small application (MS Access front-end, MS SQL Server back-end) that uploaded raw material items data received from Suppliers on MS Excel spreadsheets into MS Access. The inputs received from Suppliers were harmonized and validated through numerous tools and reports created. Result: Users can determine the country of origin for the raw material items.
> I developed for JPMorgan Chase an application (MS Access front-end, MS SQL Server back-end) that generated a series of customized reports. Reports are based on data gathered from a backend SQL Server database via ODBC queries via stored procedures and complex SQL queries. Reports are exported to MS Excel workbooks. Additional reports are generated within Excel by extracting data from front-end Access database via ODBC queries and SQL statements.
Let's discuss.
Sincerely,
artichoke
Andrew Stanhope