ThyssenKrupp Aerospace (formerly Apollo Metals) May 10 – Current
Challenge: The company had an existing database that used Lotus Approach, the company had an out-dated version, and the IT department did not wish to upgrade, preferring to standardise the software used across the business.
Solution: A “lookalike” database was constructed in Access, with every effort made to retain the style and functionality of the Approach database in order to ensure a seamless transition for the users. A simple script was written to import the data into the new database, so minimal downtime was required. The company also wished to utilise the database at another site, so a mirror database was created and data is synchronised between the two.
Challenge: The company wished to standardise the process of procuring materials from the mill.
Solution: A two tier database system was constructed, one for the sales teams to request material and monitor progress of their requests, and a second for the purchasing team to collate these requests into an RFQ to be sent to one or more suppliers in a standardised spreadsheet format.
Challenge: The Customer Enquiry database that I had built previously was based on a single site at the company, where the majority of users were based. Users based at other sites, or offsite altogether and connecting via VPN found the system unacceptably slow.
Solution (in progress): A second version of the database is to be placed on another server that remote users can access via remote desktop. This solution has already been tested and found to offer acceptable speeds to offsite users. Data will then be integrated into the “live” database.
Digipos Store Solutions Dec 09 – May 10
Challenge: The company required an application to integrate stock data from multiple systems and provide query functionality for centralised stock control and purchasing.
Solution: Built middleware integration database to batch update and consolidate data from diverse global operating systems. Built front end client/server application “Product Finder” which identified stock for redistribution and replenishment. The tool also provided graphical KPIs for supply chain management. The solution used an Access front end on an SQL server database and used VBA, SQL and graphs to deliver the clients requirement.
ThyssenKrupp Aerospace (formerly Apollo Metals) May 09 – Dec 09
Challenge: Further enhance databases developed while at the company to add improved functionality to suit the changing needs of the business
Solution: Updated each piece of software in line with both the company’s requirements and my improved capabilities.
Challenge: The company required a standardised procedure for responding to customer enquiries for material procurement.
Solution: An Access database was created and was integrated with Excel, Word and Outlook to form a complete solution from customer enquiry to response. The database included a variety of reports to compare enquiry/quotation/sales values. Following its successful implementation, the database was tailored to suit the needs of the export department.
Challenge: To produce a method capable of calculating the cost of material based on supplier algorithms.
Solution: An Access database was created capable of calculating material costs based on “staged” algorithms – each part of the calculation process is held in the database as a separate phase and a final cost is calculated and displayed along with a breakdown of the calculation. The database was also capable of producing a standalone version of itself for customer use.
Full time Employment
Red Kite 2008:
• January 2008 – December 2008 – Access Developer
o Helped develop ERP max, a database designed to reduce costs by streamlining inventory based on sales history and material forecasting
o Helped develop an S&OP database covering the complete Materials Planning cycle including buildrates, forecasting methods and capacity planning
Apollo Metals 2002-2007:
• January 2002 – August 2002 – Sales Support
o Entering and progressing customer orders
• August 2002 – June 2004 – Contract Controller
o Progressing contracted orders in order to ensure that they were completed within acceptable timescales
• June 2004 – July 2005 – Production Scheduler
o Ensuring orders have had material allocated and are released into the warehouse allowing sufficient manufacturing time before the jobs had to be delivered
• July 2005 – December 2007 – Inventory Planner
o Designing and procuring the appropriate materials to best satisfy our customer requirements
o Arrange regular meetings with Contract Managers to discuss future stock requirements
o Liaising with Purchasing Department to prioritise/progress relevant Purchase Orders
o Liaising with Sales/Contract teams to ensure that, in the event of stock shortages, orders were completed to the customer’s satisfaction
o Developed database to help regulate Inventory and Sales departments usage of current stock
o Further developed an existing database to process SAP part number requests through several departments
o Developed database to help identify redundant stock items
o Took training in basic ABAP query building