Stuart Collinge
Business Systems Analyst at Family Mosaic- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Family Mosaic
-
United Kingdom
-
Construction
-
300 - 400 Employee
-
Business Systems Analyst
-
Apr 2012 - Present
London, United Kingdom Family Mosaic provide good quality, affordable homes to rent and buy, as well as care and support services to thousands of people who need extra support. As a Business Systems Analyst I managed the development, upgrades, support and reporting of the company’s CRM system, Front Office (FO). Developed and enhanced processes on the business requirements including design of the Total Agility work flow, map development, activity design, back office capabilities and SQL Server database… Show more Family Mosaic provide good quality, affordable homes to rent and buy, as well as care and support services to thousands of people who need extra support. As a Business Systems Analyst I managed the development, upgrades, support and reporting of the company’s CRM system, Front Office (FO). Developed and enhanced processes on the business requirements including design of the Total Agility work flow, map development, activity design, back office capabilities and SQL Server database triggers, cursors and stored procedures, on a wide range of FO processes including Complaints, Tenancy Review, Transfer Requests and Succession. This included the monthly promotions to the live environment of changes and updates outside the call centre’s hours. Analysed, preplanned and implemented the FO server upgrade project. Included plan development, extensive testing and updates to the data files and databases. Designed and developed numerous reports based on FO process data to inform business sectors on outstanding cases, case loads and call centre performances. Developed and supported the company’s Sharepoint sites for the Intranet, external shared calendars to customers and FO support request portal. Extensive FO support to the call centre and internal business users, including changes in the related applications, Compass and Northgate Housing. Show less
-
-
-
Vuelio
-
United Kingdom
-
Software Development
-
1 - 100 Employee
-
Technical Consultant
-
Jun 2009 - Oct 2011
London, United Kingdom AIMediaComms is Europe’s leading provider of media relations, marketing communications and incident management software. As a Technical Consultant I am consulting re media CRM application that tracks media relations communications, monitors contact interactions, press coverage and provides press releases distribution. Liaising with corporations in the airline, tourism, retail and insurance industries, as well as police and health sectors, to configure and implement the company… Show more AIMediaComms is Europe’s leading provider of media relations, marketing communications and incident management software. As a Technical Consultant I am consulting re media CRM application that tracks media relations communications, monitors contact interactions, press coverage and provides press releases distribution. Liaising with corporations in the airline, tourism, retail and insurance industries, as well as police and health sectors, to configure and implement the company products with onsite visits throughout the UK and international. Provided hosted service installations and upgrades. Delivering a high level of pre and post sales support, training and customer care. Analysis, development and testing the media application for tactical enhancements and providing workable solutions to identified issues. Provided new reporting features by developing bespoke queries, as well as RSS feeds and contact imports. Provided data conversion from XML/spreadsheet data, analysis and SQL Server database copying. Redesign of the company website to represent the new product and fresh content Show less
-
-
-
psd group
-
United Kingdom
-
Staffing and Recruiting
-
200 - 300 Employee
-
Business Information Analyst
-
Oct 2007 - Dec 2008
London, United Kingdom PSD is a leading Executive and Management recruitment organisation operating across a range of functions, industry sectors and countries, providing specialist expertise in each. As a Business Information Analyst I was in charge of the management and analysis of CRM databases Analysed and reported on the state of the company data across nine servers. Ensured database integrity and data quality was maintained. Provided SQL Server and Sybase queries and reporting solutions… Show more PSD is a leading Executive and Management recruitment organisation operating across a range of functions, industry sectors and countries, providing specialist expertise in each. As a Business Information Analyst I was in charge of the management and analysis of CRM databases Analysed and reported on the state of the company data across nine servers. Ensured database integrity and data quality was maintained. Provided SQL Server and Sybase queries and reporting solutions. Maintained daily, weekly and monthly reporting and procedures. Statistical Reporting with Macro enabled Excel spreadsheets, Housekeeping through Sybase and Duplicate Record Merging within the company CRM system. Support and troubleshooting of issues in the CRM system, Profile 2000, and worked with the features and procedures customised for the company’s recruitment consultant requirements. Documentation of procedure routines and logged and actioned system issues. Show less
-
-
-
Amec Foster Wheeler
-
United Kingdom
-
Oil and Gas
-
700 & Above Employee
-
Engineering Technical Assistant
-
Feb 2007 - Sep 2007
Reading, United Kingdom Foster Wheeler is a prestigious worldwide engineering and construction company. Projects document control for client Saudi Aramco. Engineering document and design release control, liaising with the client to ensure that quality levels were met.
-
-
-
ClarkMorgan Ltd.
-
China
-
Business Consulting and Services
-
1 - 100 Employee
-
Web Application Project Manager
-
Oct 2004 - Jan 2007
Shanghai, China ClarkMorgan is an industry leader in developing training programs and providing the corporate world with a first point of reference for improving communication and evolving people within organizations. As the Web Application Project Manager I developed the company CRM (Openeye) system. Contact and call management; course, student and class management for Trainers and course tracking for clients. Managed the CRM website project through full system development lifecycle. The… Show more ClarkMorgan is an industry leader in developing training programs and providing the corporate world with a first point of reference for improving communication and evolving people within organizations. As the Web Application Project Manager I developed the company CRM (Openeye) system. Contact and call management; course, student and class management for Trainers and course tracking for clients. Managed the CRM website project through full system development lifecycle. The application provided users with company, course and financial information and provided class information for clients and trainers. Upon completing the system Openeye had 250 users, 6,500 multinational companies and 500 courses. Added features to process non contacted companies, to manage student pre-assessment, class results and seminar scores, and enabled online reporting in Word and Excel. Later enhancements included task management, mass emailing, storing student survey results and logging of service requests. Responsible for management and analysis of the CRM database including developing queries, extracts and reports. Analysed data to identify trends. Developed with ASP, Javascript and HTML scripting. Use of MS SQL Server views and stored procedures as well as profiling and query tools for data maintenance. Managed company staff for maintenance and training. Provided customer support, assessments of client Trainees, gave online class training and updated the ClarkMorgan website Show less
-
-
-
WHSmith
-
United Kingdom
-
Retail
-
700 & Above Employee
-
Retail Department Manager
-
Aug 2003 - Sep 2004
Reading, United Kingdom Managed the stores book department daily resupply during evening hours. Provided customer service and implemented new store layouts.
-
-
-
PepsiCo
-
United States
-
Food and Beverage Services
-
700 & Above Employee
-
Database Analyst
-
Mar 2003 - Mar 2004
Reading, United Kingdom Part time database and analysis work supplied by Randstad Employment Ltd. Generating data results using Access and Excel to process sales statistics data.
-
-
-
Pitney Bowes
-
United States
-
Software Development
-
700 & Above Employee
-
Archive Manager
-
Mar 2002 - Sep 2002
Reading London Archive Manager for WorldCom International Inc Managed archives and used VBA in Access and Excel for reporting and statistics.
-
-
-
-
Web Application Developer
-
Feb 2000 - Aug 2001
Reading, United Kingdom Web Application Developer of Intranet Sales Reports using MS Interdev for ASP, Javascript and HTML scripting and using MS SQL Server database. Use of MS Visual Basic for processing data from Navision database to MS SQL Server database for use by Intranet Sales Reports. Development of Intranet reports for Stock Discrepancies with ASP. Development of test Internet site for customer query and stock purchase. Updating sub company web site as well as replacing CGI script… Show more Web Application Developer of Intranet Sales Reports using MS Interdev for ASP, Javascript and HTML scripting and using MS SQL Server database. Use of MS Visual Basic for processing data from Navision database to MS SQL Server database for use by Intranet Sales Reports. Development of Intranet reports for Stock Discrepancies with ASP. Development of test Internet site for customer query and stock purchase. Updating sub company web site as well as replacing CGI script with ASP. Testing systems over three servers for use of XML and SOAP using ASP web pages and MS Visual Basic for COMS and ActiveX controls. Show less
-
-
-
Sanderson from Aptean
-
United Kingdom
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Analyst Programmer
-
Feb 1999 - Dec 1999
Melbourne, Australia Analyst Programmer for Libraries Department Support Desk Customer support work for Spydus Library application, PICK language Operating with Unidata (UNIX) using wIntegrate 4.2 MS Windows emulation Developing internal Client Application with MS Visual Basic and Access Use with MS VBA and templates with MS Word and Excel
-
-
Education
-
RMIT University
Bachelor of Business Information Systems, Minor in Business Management -
Glen Waverley Secondary College
Victorian Certificate of Education