Robert Iles Email & Phone Number

Blackburn, United Kingdom

Manchester / Birmingham / London / Newcastle / Stirling

Jan 2013 – May 2013, Fusion / Mobile E-Forms:Requirements Analysis and Documentation to migrate paper based forms onto existing mobile devices.May 2013 – June 2013, E-Tech Property Hub roll out (GreenDeal):Roll out E-tech Property Hub and Assessor app. to new business areas.Complete configuration of system for initial site, documenting process to enable handover to helpdesk in future.June 2013 – Dec 2013, Property Hub (Affordable Warmth):Implement Property Hub for Affordable Warmth business. Configure a test environment to validate that the proposed system also works for Affordable Warmth Business (which operates under different legislation to GreenDeal). Work with business users to perform UAT testing, feeding back issues to software vendor for rectification.Provide relevant information to training department to enable accurate documentation to be developed. Support Go live process.Jan 2014 – May 2014, Oracle Real-time Scheduler (ORS) Optimisation:Working with Commercial Engineering Delivery Management Team to identify inefficiencies in operations, their root causes and propose resolutions. Monitor and report on improvements post implementation. Utilise web services in order to obtain the raw data needed.Developed database triggers to record specific events in scheduling tool.Developed reports to summarise the data recorded across disparate systems.This allowed managers to identify where processes were not being followed correctly.May 2014 – Sept 2014, Property Hub Upgrade:Test new version of Property Hub system, including regression test current functionality and system test new functionality. Included “Hub to Hub” enhancement, requiring tests in multiple systems concurrently.Sept 2014 – Dec 2014, Testing New Mobile Devices for Engineers:Utilise knowledge of Works Order Management, Scheduling and Mobile Engineering Applications to assist with design and execution of test plans for the replacement of outdated mobile engineering platform.

National

Implement Multi Channel Sales Order Processing / Warehouse Management systems and create interfaces to 3rd party software utilising appropriate technologies.Installation of hardware / software on site.Create new databases - includes building database servers where required.Set up database back up and clean up scheduled tasks.Configure and test web services (e.g. PCI-DSS Credit Card Payments).Develop bespoke interfaces to 3rd party applications (SSIS). Develop customer specific reports and ad-hoc DBA activities. Create HTML email templates / stored procedures to inform customers of order / delivery details.Test import of XML files from 3rd party web sites.

Nationwide

British Energy Trading and Risk Management (TRM) System – performed a Business / Systems Analyst role in the migration of data from legacy systems to new relational database architecture.Shell – lead the design, development and implementation of new workflow tool (.NET / SQL Server), integrated with existing ERP system, to resolve invoice approval problems across 5 operating countries.Law Society – developed asp.net pages to query Oracle database containing details of Solicitors and the organisations they work for.

Blackburn, United Kingdom

SQL / Web Services specialist - primary customer point of contact.Provide consultancy to develop interfaces with 3rd party software (web services / .NET). Provide consultancy on use of standard reporting suite.Write bespoke SQL queries to satisfy client-reporting requirements where standard reports were insufficient.

Blackburn, United Kingdom

Work with clients to identify the Business needs for Document Management software.Install and configure core software to meet these needsInstall and configure other required components such as Database Servers (SQL Server / Oracle), Web Servers (IIS) etc.Develop ad-hoc SQL procedures / triggers etc. to integrate with other applications and ERP systems.

Preston, United Kingdom

Relational Database specialist, including:Develop SQL queries for use by reporting team in creating MI reports.Develop MS Access tools to query the Oracle database. Developing VBA tools to assist data integrity team.

Wilmslow, Uk

Identify changes needed to current application.Design and develop SQL database (tables / indexes etc.)Development and testing of T-SQL stored procedures (Sybase).Development of Object Oriented front end application (Power Builder).

Geneva Area, Switzerland

Working within the ATLAS project management team:Wrote Perl scripts to display UML drawings on the web.Worked within a team developing a progress-monitoring tool. Object modelling using StP and Rational Rose.Developed java servlettes (implemented Apache web server and MySQL database server) and active server pages (IIS). Developed web based application for managing globally distributed project.

Birmingham, United Kingdom

Manage all commercial aspects of multiple projects.Negotiating conditions for new contracts.Project change management.Agreeing value of work complete and ensuring payments are made.Organising inter-dependant operations and monitoring progress. Producing contract reports for management summarising key points. Managing sub-contractors and suppliers.

Birmingham, United Kingdom

As an apprentice I gained experience in all departments, including:Design: Production of drawings and equipment schedules for installation on site.Estimating: Production of price and program documents for competitive tenders.Contracts: Sourcing labour and materials to complete on site installations. Managing sub-contractor activity on site.Commercial: Vetting orders received to highlight onerous terms and conditions. Agreeing value of contract work complete with clients. Highlighting and valuing additional work complete. Ensuring payments due were received on time. Preparing order documents to ensure sub-contractors complete works to defined standards and within project timescales.

Bachelor Of Science (Bsc) (Hons), Business Information Systems, 2:1

Object Oriented Systems Analysis and Development. Database Design and Development. All from a Business Systems perspective.

Hnc, Building Services Engineering (Hvac)

Design and installation of Heating, Ventilation, Air Conditioning and Public Health Systems.