Starbank's bespoke ERP system
01/11/12
- 01/02/18
Design, development and maintenance of Star bank's bespoke ERP system. The systems functionality included was provided using SQL 2008 with an upgrade to 2012, the front end was developed using C#'s Win Forms. The application functionality included the following
CRM
Quote and order calculations
Sales ordering
Purchase ordering
Production scheduling
Goods received
Stock control
Delivery scheduling
Invoicing
Integration with manufacturing machinery
Integration with SAGE 50 and SAGE 200
Carrington Fleet - Bolton
01/07/10
- 01/09/11
IT Consultant role: Providing support and maintenance and consolidation of the company's database systems. The company predominantly ran SQL Server 2008 R using MS Access and Excel to provide front end interfaces whileSSRS Report Builder and BIDS were used to provide an integrated report service from a number of SQL Server instances. Skills used were database design and reporting using SSRS and Visual Studio. T-SQL stored procedures were written to provide business functionality. Other duties involved migrating ms access back-end mdb's to the SQL server database using SSIS packages to cleanse and provide consistent data using the ETL function in SISS