Experienced application developer of Windows Forms, Services and MVC applications, API integrations and extract-transform-load applications using C#, VB.Net, JavaScript, HTML, Windows Server, IIS and SQL Server to meet customer and corporate requirements.
Application Support from first to third-line. Problem resolution through code refactoring, reconfiguration and optimisation of physical and virtual server hosts and components.
Managing requirements in context with stakeholders, having worked in all organisational departments; IT, operations, Sales and Marketing, HR and finance and possessing an MBA in Human Resources, Operations and Finance.
Designed and wrote own application: Runs SQL and R scripts through SQL Server and parsing results to multiple output options: integrated Excel compatible spreadsheet, SQL Stored Procedures and C# and VB.Net code. Parsing SQL selected queries, generating MVC code for CRUD and custom stored procedures, models, interfaces, repos and controllers.
Developed Object Relational Mapping tool in C# to facilitate EDI creation. Mapping UBL, XML, XML, CSV, SAP Documents and SQL Server tables. Integrated EDI tool into Sales and Purchasing applications for direct and off-line importation.
Created Service Desk application importing call information from Exchange Server into SAP, file system and database using C# and SQL Server. Managing all customer contact, knowledge bases entries and searches, SQL reports on total service call completion time, total customer lifetime cost and operator performance.
Created CRM and Service application and database structure, multi-site replication and sharding in VB and SQL Server. Providing complete history of PC build, service and upgrades, reported on total lifetime cost, service and defects costs.
Wrote delivery scheduling and routing software for Windows Forms and ASP.net to organise daily deliveries of white goods and furniture saving £250,000 annually on routes and administration.
Supported 80 customers; SQL Server 2005 to 2012, Windows Servers 2003 to 2012 and Windows XP to 8.1. Developed single and cross-database queries, map-reduce processes. Optimising performance for up to a million rows added daily for 300GB database installations.
Design and write systems integrations using Windows Services, Winforms, MVC, NodeJs;
live accounting and sales information with high availability and business continuity;
customisations and reports for Echo modelled on council and corporate business processes.
Designed and wrote own application: Runs SQL and R scripts through SQL Server and parsing results to multiple output options: integrated Excel compatible spreadsheet, SQL Stored Procedures and C# and VB.Net code.
Parsing SQL selected queries, generating MVC code for CRUD and custom stored procedures, models, interfaces, repos and controllers.
Identify and document processes to be handled by first or second line support. Manage software installations and upgrades.
Reconfigure applications for high-availability. Windows, SQL and VM support.
Development Languages: C#, VB.Net, T-SQL, HTML, CSS, IIS, JavaScript, jQuery
Applications: Windows Forms and ASP.Net GUIs, EDI, API, data integration, monitoring server performance, report publishing.
Support Customers' software installations: SQL and Windows Servers, IIS, Citrix
Applications: SSIS, SSRS, SAP Business One ERP, Valogix demand planning, Accellos WMS, EDI, APIs and reporting tools, Server and workstation performance
Gather requirements and provide resolutions; using standard functionality, configuration or developing bespoke applications. Training and documentation.Manage customer software development projects through full life-cycle from inception to documenting and training support consultants on functionality.
Provide third-line support and advice to consultants on server performance and configuration. Diagnosing issues recommending and implementing fixes.
Goods receipt, order checking, replenishment, stock taking
Design and write stock control systems and route management to manage the change to storing multiple branches’ stock from single branch in local distribution hubs and improve warehouse’s scheduling and performance.
Management of operations and warehouse - stock receipt, storage, distribution to shops, customers’ homes for furniture, white goods and FMCG stock, recycling. Change and project management, systems design and implementation. Development and performance management, staff system and process training.
Designed and installed LAN, PCs and servers. Office automation and training
Wrote ETL software to transfer pension data to new administration company
Responsibility for managing IT, operations and projects.
Designed and wrote desktop and server products with operations and user summary and detail scorecard reports; Project and Change Management
BUSINESS OPERATIONS, MANAGING HUMAN RESOURCES, FINANCIAL STRATEGY, STRATEGY
NVQ 5 STRATEGIC AND OPERATIONAL MANAGEMENT
Managing Projects, Development and Change, Understanding/Improving Performance
NVQ 4 STRATEGIC AND OPERATIONAL MANAGEMENT