Christopher Cross

Company Name

EMEA

Position Held

BI Consultant

Dates

0000 - Present

Details

EMEA BI Solutions Architect/Senior BI Consultant ASSA ABLOY April 2012 - Current In this role, I was responsible for the planning, development and delivery of the EMEA BI solution, connected to the EMEA AX roll out. Preparing the solution for its 30 ,000 plus users, running a self-service BI solution. Using Microsoft BI stack, the solution included a replicated database, SSRS reports, report models, AX cubes and new cubes using AX data, legacy data and third party data. Managing a team of over 14 developers located in different locations and handling the budget for the BI solution. This included project management, meeting with the AX team to liaise with changes and development, meeting with various parts of the business, in multiple countries to view requirements. These were then documented as function requirement documents which the development team worked off, under my guidance and best practise rules. Skills Required Dynamics AX 2009/2012 , MS SQL 2008/2008 R2/2012 , SSRS, SSAS, SSIS, Visual Studio, Visual Studio TFS, All MS Office products, data warehousing solutions, ETL solutions, SharePoint 2010/13 , PerformancePoint, Excel Services, PowerView, Power Pivot, Management Reporter, MDX ~~ ~~ ~~

Company Name

Junction Solutions/

Position Held

Technical Consultant/IT Manager

Dates

0000 - Present

Details

Technical Consultant/IT Manager Junction Solutions/Manchester November 2010 -April 2012 In the dual role of Technical Consultant and IT Manager, I have fulfilled many requirements for Junction Solutions, an AX Implementation and Consultancy firm. In the role of IT Manager, I have implemented a new Exchange email system, built a large selection of virtualised solutions using Hyper-V and VMWare to provide Cloud and local based training, development and proof of concept installations. I installed a large Cloud based NAS solution and installed several networking solutions in the companys offices. I am also responsible for the procurement of any IT equipment from new systems to the companys phone solutions. I also build the demo systems to help the sales team present the best solutions to potential customers. As a Technical Consultant, I advise customers on their infrastructure for new and existing systems, performance tuning and upgrades. In projects, I train customers on their requirements for an Dynamics AX system on everything from system administration to data migration. I have built large scale cubes and BI solutions for customers utilising SSAS and SSRS solutions. Customer projects have included DABS AX 2009 BI solution, Enterprise Portal , Hunter Boots AX 2012 , BI, Enterprise Portal , Wick Hill AX 2009 , Reporting Solutions, Transform , Listers AX 2012 , Bettys AX 2012 , BI, Reporting, Enterprise Portal , JML AX 2009 , BI, Reporting, Enterprise Portal , Card Factory AX 2009 , AX 2012 , AX for Retail 2012 , Enterprise Portal Skill Required Hyper-V, VMWare, Dynamics AX 2009/2012 , SQL, SSRS, SSAS, SSIS, Exchange, Cloud solutions, Visual Studio, Networking, Performance Management tools, SharePoint.

Company Name

Self Employed Freelance Consultant

Position Held

Data Consultant

Dates

0000 - Present

Details

~~ ~~ ~~ Data Consultant Maginus/Manchester July 2008 - October 2010 Projects have included implementation of software, PCI compliance, bespoke data migration tools and solutions, BI solutions, reporting solutions. Projects completed include Jacobs Cameras, The Royal Mint bespoke data migration tools created for migration of business historic data, along with rebuilding reports processes based around new solutions , Lamberts HealthCare full data migration of current system Mailbrain, to new ERP solution along with creation of their new SQL Data Warehouse solution , Rapid Electronics, Cath Kidston, Tanners Wine Merchants and others. Along with these requirements, I also presented the in-house training of database schemas, reporting SQL management and training based around created solutions. I was also the internal resource for all SSRS, SSIS and SSAS projects, ranging from in-house reporting tools to customer based BI solutions. Skills utilised include ORACLE, MS SQL 2000/2005/2008 , Reporting Services SSRS , SSIS, DTS, Visual Studio, UNIX, Crystal Reports and Microsoft AX.

Company Name

Self Employed Freelance Consultant

Dates

0000 - Present

Details

~~ ~~ ~~ Self Employed Freelance Consultant Based in Manchester November 2006 - July 2008 I was working self employed as a freelance consultant. I have a question and answer forum online that allows clients and the public to ask questions or technical queries, based at www.enigmitecsolutions.co.uk. During this time, I worked on a major project for : NCO Europe Financial Services - November 2006 to April 2007 The project for NCO involved extensive changing in their reporting structure. This involved creating new databases, installation of Crystal Reports solutions and changing business procedures. During the time there, I created a new coding system for their invoice reports, manuals of procedure and documentation of the reporting system, along with training programs for the new systems. Technically, the project required the creation of several MSSQL 2003 tables which had to be cross referenced with and sometimes populated with data from a PROGRESS database. Skills Required Creation and management of cross referenced database tables, linked to client invoicing codes. These then built a complete invoice in reference to debtors payments. Each invoice was cross-referenced with debtors payments which were coded with a unique reference produced by an external VB program. Reports were created to be utilised by account managers using Crystal Enterprise with data produced with views built into Crystal reports XI.

Position Held

Technical Director

Dates

0000 - Present

Details

~~ ~~ ~~ Technical Director Please Hold UK, Manchester August 2005 - November 2006 Responsibilities to manage all areas of IT infrastructure for both Please Hold UK and its sister company, CVS. This covered creation of reports to be utilised by both finance and management staff, installing and maintaining a VPN, anti spam solutions and web mail solutions. The role also involved defining business processes and training for new and current staff. I also was responsible for all the technical aspects of the web-development arm of the company, Please Hold Interactive, a team of 6 account managers and designers. This meant dealing with client enquires, solving technical issues of web development and hosting, auditing current clients for implementing into new CRM solutions and many other tasks. I was also responsible for the creation and maintenance of email based marketing solutions, data management. Also I was whole responsible for the replacement and maintenance of the phone systems for both companies, creating bespoke solutions for time management, call reporting and department call monitoring using a range of Crystal Reports XI and Crystal Enterprise. Skills used Active directory, MS SQL, VPN, Crystal Reports Enterprise, Windows XP, 2003 , Mac based solutions, Linux based solutions, Web development software Dreamweaver, Photoshop, PHP , Anti Spam solutions, Exchange 2003 , firewall solutions, Sage MMS, ACT 8 , Microsoft Office, Avaya Phone systems, VB programming.

Position Held

IT Consultant

Dates

0000 - Present

Details

~~ ~~ ~~ Self Employed IT Consultant Feb 2004 - August 2005 Was running my own small business, providing IT support to small businesses. This is done under the business name, enigmitec IT Solutions.

Company Name

Anderson Eden/Blue Sky

Position Held

Systems Developer

Dates

0000 - Present

Details

~~ ~~ ~~ Systems Developer Anderson Eden/Blue Sky Group, Preston August 2003 - Jan 2004 Responsibilities to develop the in-house, PI case management system. This involved creation of a multi-variable workflow using the bespoke system of Videss. From data created by the system, a collection of spreadsheets and reports were used to provide data analysis of case status, workload of fee earner and business standing. This position required knowledge of the Progress database, extensive use of Word and Excel, report writing and multi-system administration. The role also included the creation of training materials, training courses and the actual training of staff in a fast changing environment that required keeping up with changing company and legal procedures. Skills Used Data extraction from Progress database using SQL tools in Excel and Access to provide daily, weekly and monthly reports of data input for all levels from board to user. Provided forecasting tools built into Excel spreadsheet using simple macros tools. Used SQL navigator tools to map out Progress database for future projects and, the development of migration tools to the companies bespoke MS-SQL customer management system. I also developed the in house training procedures for the systems being developed, writing not on the manuals but also the training material. Also utilised Crystal Reports X to allow practise managers to interrogate data from the case management system to allow them to see levels of clients cases, budgeting analysis and milestone definition. Reasons for leaving The company terminated my contract when they found that they had to liquidate part of the company.

Company Name

Watermark

Position Held

Senior Technical Consultant

Dates

0000 - Present

Details

~~~ Senior Technical Consultant Watermark, Swindon August 2002 - January 2003 Responsibilities to provide a suitable client/consultant interface while completing the require project parameters quickly and efficiently. Major Projects completed Baan system migration for Lister Shearing Disaster Recovery Planning for Ishida Baan Upgrade for XLT Timberlex System Upgrade for XLT Timberlex Exchange 2000 Install for Ishida System Upgrade for W and H Crystal Reports Training for Hanix Skills Used During the time at Watermark, various skills were required, from database migration from Informix to Oracle, creation of Crystal Reports, re-mapping of Active Directory for Exchange 2000 implementation. The system migration for Lister Shearing involved an upgrade from Informix to Oracle 9i database that required use of the SQL navigator systems for both databases to allow for smooth transition of data and the re-development of disaster recovery routines. I also was the companies Crystal Reports trainer and implementation consultant. I also developed a range of Crystal Reports functions to allow all the consultants to rapidly build reports to the requirements of their clients. Reasons for leaving The company had to cut some of its base costs and this involved the removal of staff. As I was one of the last to join the company, I had to leave when a Last in - First Out policy was invoked.

Company Name

Milton

Position Held

IT Consultant

Dates

0000 - Present

Details

~~~ IT Consultant Novasoft Information Technology, Milton Keynes October 2000 - June 2002 Responsibilities to provide a suitable client/consultant interface while completing the require project parameters quickly and efficiently. Projects completed Systems Administration for : Intermec, Reading Baan 4 , UNIX, Informix Britax, Camberley Baan 4 , UNIX, Informix, 3 systems Screenbase, Andover Baan 4 , NT, MS SQL Disaster Recovery for : Hanix, Manchester Baan 4 , NT, MS SQL Intec, Slough Triton 3 , UNIX, Oracle Screenbase, Andover Baan 4 , NT, MS SQL Micromass, Manchester Baan 4 , NT, Oracle System Upgrades for : Britax, Camberley Baan 4 , UNIX, Informix, 3 systems Screenbase, Andover Baan 4 , NT, MS SQL Colorama, London Baan 4 , NT, MS SQL Napier, Lincoln Baan 4 , NT, Oracle SAP Administration for : Alstom, Lincoln SAP R/3 , UNIX, and Oracle ASAP Administration for : Alstom, Lincoln ASAP, NT, MS SQL Also several 2-3 day projects on scoping exercises, training, updates, patch management and various other solutions. Skills used This position utilised many of my skills and abilities in relational databases. I performed many disaster recovery procedures and helped implement others. I performed in-house training in Crystal Reports and development of database training material to allow for crossovers of data migration. Utilising various SQL tools, I performed data migration from legacy systems to implementation and performed ODBC mapping utilising Cognos Powerplay. I also performed multiple DBA positions in Oracle, Informix and MS-SQL. Along side these tasks, I also helped with the development of several VB solutions to data migration, manipulation and external connections from the database to other units such as handheld devices and non-standard printers. Reasons for leaving Due to a slowdown in the ERP market, the company trimmed itself to a more cost effective model. This involved multiple redundancies.

Position Held

IT Manager

Dates

0000 - Present

Details

~~~ IT Manager Polimoon, Sandycroft, Chester February 1998 - October 2000 Responsibilities Responsible for all IT operations in the company from desktop management to IT based training. Installation of new network, ERP system and telephone system was included in the position. Responsible for budgeting of IT purchases, all communication budgets and IT training. Implemented several new concepts into the company Digital photography of items for sales people, email and internet for all users with controls, controlled time for door entry system, easier reporting system for finance . I also helped with the relocation and re-implementation of the ERP system to Norway. Skills Used The company has a mix of Windows and UNIX servers that held various databases, systems and files. My role was to combine the databases to allow for standardisation, create a new method of file handling for the company plus migrate the current data they had into the Baan implementation at the time of joining. It also utilised my IT management skills with standard IT department requirements of resource management and budgeting. I also implemented training procedures and manuals for the new implementation. The company also worked to an ISO9000 standard which I helped implement with usage and development of online training manuals, data managing techniques and maintaining and utilising equipment in the industry. Reasons for leaving to pursue consultants career path with Novasoft.