Mark Saxby
Freelance Consultant 2002-current
- Carried out freelance Pre-Sales work for WhiteCross.
- Advised companies on effective design of websites for business insight.
- Designed and developed websites for various organisations.
Sand Technology Bid Manager 2001-2002
Architected Data Warehouse solutions for Sand’s major clients in telecommunications and internet markets based around Sand Nucleus technology.
Responsible for initial data model design, ETL flow design and rule definition (for Ab Initio ETL tool), performance optimization, data cleansing, permissions and privacy controls and data warehouse/data mart distribution.
Systems integrated data from billing systems, Web servers, dial up servers, other contact sources and customer demographics.
Instrumental in closing business with, long sought after, major UK mobile telephone operator – business worth about £350,000.
Received training in Sand Nucleus database internals.
WhiteCross Systems Senior Consultant 1995-2001
Architected, designed and delivered Data Warehouse solutions for WhiteCross’ major clients in telecommunications and internet markets based around WhiteCross Database Server technology.
Responsible for all phases of the project lifecycle, from initial requirements gathering, through design, development, testing to user training and sign off.
Work involved data model design, including logical and physical designs, aggregations, ETL flow design and rule definition, performance optimization and data warehouse/data mart distribution.
Systems integrated data from billing systems, Web servers, dial up servers, banner ad servers, content management systems, other contact sources and customer demographics.
Developed ETL, aggregation, transformation and reporting/analysis software in SQL (ANSI 89/92), Awk, Unix shell scripting and Perl.
- Acted as design authority/Technical Project Manager on a number of major systems, including a pricing analysis system for C&W (now used by ntl:) and a Web Analysis system for Freeserve.
- Responsible for communicating and co-ordinating technical requirements across WhiteCross, customer and third party technical teams, including other suppliers’ staff and contractors.
- Acted as technical authority/team leader to a team of 10 developers on the further development of the Freeserve system into a productised Web Analysis system used by organisations such as BA, Channel 4, CNN and the Daily Telegraph.
- Carried out consultancy projects and workshops, focussed on business intelligence, analytical CRM and data mining for numerous major corporations in Telecommunications, e-Commerce, Retail and Marketing fields, using SQL, Data Mining tools (Decision Trees, Segmentation, etc), Business Objects, BRIO and Unix shell scripting.
- Evaluated data warehousing tools, including ErWin and Datastage ETL.
- Provided support to sales team, including assessment of business issues and identification of alternative technical solutions during customer meetings.
- Received professional training courses in Advanced Consulting, Data Warehousing, C++ and Unix tools.
- Joined WhiteCross as a Systems Engineer, transferred to the Consultancy team in 1997 and was promoted to Senior Consultant in 1998.
Freelance Contractor 1987-1995
- Digital Equipment 1994 – 1995
Principal Developer on a Call Logging System. System used Client/Server model extensively, utilising DECMessageQ technology. Coding in Pascal and C, with SQL, RDB and other Digital products
- EDS 1994
- Member of Performance team on a Control Room operations system for an Electricity company
- Role involved extensive performance and capacity testing of RDB databases and conversion of SQL routines to ANSI compliant standards (being introduced at that time).
- Digital Equipment 1990 – 1994
- Team leader on a number of data warehousing projects using RDB and SQL.
- Co-ordinated work between the team and acted as the design and technical authority.
- Responsible for analysis, design and development of data warehouse for Effort Tracking and Order Fulfilment.
- Analyst, responsible for designing, specifying and testing changes and additions to a Portfolio management system.
- Coding was carried out in Basic.
- Digital Equipment 1988-1990
- Involved in development, and pan-European support, of data warehouses and business reporting systems, using RDB, SQL, Pascal, DCL, Datatrieve and Basic, plus Digital layered products such as RMS, CMS, CDD, etc.
- Department Of Trade & Industry 1987-1988
- Developer on Management system for Research Establishments. Coding was in Basic and covered elements such as Accounts receivable and payable, general ledger, fixed asset management and management reporting.
- Trained incoming DTI support team in elements of the system.
Allen Computers Team Leader 1985-1987
- Responsible for facilities managing an EPOS system for a chain of DIY stores.
- Ensured that data was collected and processed from stores on a nightly basis and transactions processed and reports delivered each day.
- Carried out requirements analysis exercises with clients and designed and managed development of new modules/functionality.
- Undertook Project Management training (1 week residential course)
- Recruited as Analyst/Programmer and promoted to Team Leader, 1987
Spectra Strip Analyst/Programmer 1983-1985
- One of a team of two running IT department for cable manufacturer.
- Responsible for developing and supporting computer systems which controlled sales, manufacturing, accounting and other business areas. All software was developed in-house.
- Carried out analysis, design, coding and implementation of a Quotation system for telesales team.
- Recruited as Programmer and promoted to Analyst/Programmer, 1984
South Coast Systems Junior Programmer 1981-1983
- Carried out analysis, design, coding, delivery and training for bespoke systems for a number of small businesses in the Hampshire/Dorset area, including billing system for a taxi firm and a production system for a furniture manufacturer.
- Provided on-site technical support for a number of clients, including bakers and engineering companies.
- Developed software in Basic and Bristol Software Factory’s early 3 GL product.
- Recruited as Trainee Programmer and promoted to Junior, 1981
Stage One Computers Trainee Programmer 1980-1981
- Carried out development of accounting and file management software in Basic.
- Provided technical and demonstration support to salesforce.
- Developed rolling demonstrations for use in premises and at shows.
- Acted as ‘shopfront’ salesman.
Education:
City & Guilds IT qualification & 9 ‘O’ levels