Worked For (Detailed)

Working on a very large SAP Data Migration Project in Dublin with SAP Consultancy Deloitte & Touche and the Irish Health Authority , this was during the Blue Print Phase. I was a member of the Data Team whose role was to look at Data Quality, Data Cleansing, Data Validation and looking at the whole process of migrating data from the old Legacy Systems to the new SAP Solution. Producing Documentation and highlighting issues with all the Data Objects to be migrated to SAP (both Master Data and Transactional Data). This role is mainly using my technical experience.

Skills Used : Data Cleansing, Data Validation, MS SQL Server 2000 / MS Access, Microsoft Visual Studio 2003, Dot, SAP Dot Net Connector 2.0 for Visual Studio 2003, Net Framework 1.1, Winforms, N-Tier, IIS, OOP, OOD, XML, SOAP & XML Web services, Data Access Application Block, NT/Win2K Security, TCP/IP, MS Office 2003.

This was a short eight week contract working with Axon Global Solutions (the largest UK SAP Consultancy) and one of their major clients ‘ Transport for London ’ in migrating from a Legacy System called OPAS to new SAP EH&S Occupational Health module from SAP’s Partner Technidata . Axon had previously failed twice before and I was tasked with simply getting the Data from the Legacy System to the new SAP EH&S Module and the getting the client to signoff a satisfactory result. There were lots of Data Cleansing, Data Validation and Data Consolidation issues and I basically had to take ‘garbage in’ and return ‘good out’. Due to another consultant leaving the project early, I basically completed the data migration single-handedly; I had to work extremely long hours and weekends to ensure a successful SAP data Migration (with signoff).

Skills Used : Data Cleansing, Data Validation, MS SQL Server 2000 / MS Access, Microsoft Visual Studio 2003, Dot Net Framework 1.1, Webforms, Winforms, N-Tier, IIS, OOP, OOD, XML, SOAP & XML Web services, SAP Dot Net Connector 2.0 for Visual Studio 2003, Data Access Application Block, NT/Win2K Security, Technical Support, TCP/IP, MS Office 2003.

Working on a very large SAP Data Migration Project in the Middle East ( Saudi Arabia ) for a reputable SAP Global Consultancy called Atos-Origin as a Microsoft & SAP Consultant. I had the responsibility for designing and delivering Data Validation Solutions for a highly successful client company called SABIC (Saudi Arabia Basic Industries Corporation) and 16 affiliate companies.

Whilst working on the FANAR Project working in the Data Team for this Major Systems Integrator, I created a Data Validation Solutions to validate both Master Data and Transactional Data. Here my system will actually improve the data accuracy and help 16 companies migrate from a variety of Legacy Systems to one large Global SAP ERP Solution.

Working within the SAP Data Team with 20+ SAP Consultants we created templates in Excel for the 16 Affiliates to enter their Master and Transactional Data into, using my Data Validation System we specified both simple and advanced rules for each column, we then empowered the affiliates to Self Validate their own data whilst remaining SAP System Configuration took place. The end result was validated excel spreadsheet colour coded in red and green with supporting comments inside excel. Performance-wise our largest Transactional Data File would benchmark 1.7 Million Validations in 21 minutes although smaller Master Data Files would take only a few seconds or minutes and generally process around 3000 to 4000 checks per second (and per instance) on standard hardware. This Validation Framework I put in place is extensible and designed so more advanced rules can be created and used in the future.

Utilising my Microsoft .NET Skills, I designed, developed, tested and rolled out a variety of tools for this Greenfield Project, the technology currently in use are: -   

This was a client facing consultancy role and the Entire project has been developed in Microsoft .NET Framework Version 1.1 (using Microsoft Visual Studio 2003).

I designed and implemented a security framework and connectivity for 16 Domains to access our centralised servers, this was a standard textbook implementation of how distributed security should be implemented and was accepted by the 16 other company’s security guidelines.

I also created an XML Web Service, which was a Gateway to SAP to download SAP Table Data using the SAP Dot Net Connector, this downloaded at far greater speeds than using older ‘classic’ methods.

Skills Used : Microsoft Visual Studio 2003, Dot Net Framework 1.1, Microsoft SQL Server 2000 (using Stored Procedures, Webforms, Winforms Excel Object Model and ASPOSE.Excel, N-Tier, IIS, OOP, OOD, XML, SOAP & XML Web services, SAP Dot Net Connector for Visual Studio 2003, Data Access Application Block, NT/Win2K Security, Technical Support, TCP/IP, MS Office 2000 & 2003, Data Cleansing, Rolling out updates and providing ad-hoc consultancy on a variety of other technical areas.

Supporting a Business Critical application that currently processes over 2 Million Updates per Month. I have also assisted in a massive Data Cleansing exercise to clear out Data Issues with BT and the 2 Largest UK Licensed Operators. Performing a variety of tasks including Analysis, Design, Documentation, Testing, Training and ongoing support of Internal Business Applications. Created and Tested a Disaster Recovery Plan for a Production System. I received a ‘Quality Award’ for ‘the production of a software system’, which will eventually assist in migrating over 6 Million records to a new system.   

Skills Used : Application Support, Application Development & Enhancements, Data Cleansing, Win 2K, MS Access 97 & 2000, VBA, VB, MS Office 2000, TCP/IP, MS Excel, NT & Microsoft Security, SQL, Troubleshooting, Outlook 2000.

Part of a £4.5 Million relocation-project. Ownership and responsibility for Upgrading and Converting over a dozen Business Critical Applications from Microsoft Access Version 2 to Access 2000. The primary contact for all departments and ensured that everything went smoothly and ensuring that all upgraded applications was performing at optimal level after upgrade. Deployment of software updates, over a variety of different Business Areas.

Skills Used : Application Support, Business Support, Troubleshooting and Documentation, NT 4.0 Workstation, MS Access 2 & 97, VBA, VB, MS Office 97, MS SQL Server 7.0, TCP/IP, MS Excel, NT & Novell Security, SQL, Data Migration, Data Analysis.

SAP R/3 ABAP/4 Training

Attended: SAP R/3 TeamSAP Academy Training TABC40 Application Development Workbench Release 4.6B .

Working as a Member of the Euro Conversion Team, we had to ensure that Caledonian Life was fully Euro Compliant before Jan 2002 when Ireland joined the Euro. Every Business Areas and Business Function had to be Analyzed, Documented and assessed as to the amount of Euro Impact. To keep track of all these details I created a bespoke Euro Inventory System in Microsoft Access to track the Projects Progress, working closely with the Business and Systems Analysts this System was used extensively on a daily basis and it helped greatly with the creation of Systems Impact Documents and for providing information to the Business. After this I gave ongoing Applications Support to the Euro Team, I also doubled up as the local Technical Support Person and channeled all support calls through to the Help Desk. Later I helped in Database Analysis on a Life Assurance System. Working along side a Business Analyst we eventually covered all areas of this complex application, which had a Microsoft SQL Server 7.0 backend. I evaluated a variety of Euro Conversion Software Packages to assist the Business Areas users in converting a large amount of Excel Spreadsheets and Microsoft Access Databases.

Skills Used : NT 4.0 Workstation, MS Access 2 & 97, VBA, MS Office 97, MS SQL Server 7.0, ODBC, LAN, TCP/IP, MS Excel, Euro Conversion, Novell, NT & Novell Security, SQL, Data Migration, Data Analysis, Troubleshooting, Lotus Notes.

Reporting to the Chief Technology Officer. Originally this was a High End Support Role, Supporting the Internal Network, including the Live, Production and Test Windows NT/Web Database Environments. Later I additionally used my MS Access, MS SQL Server and Database skills to produce the Daily MIS Site Usage Statistics for Management, Business Operations and Marketing. Supported Microsoft Desktop Application Products and the following Microsoft Server Products: - MS SQL Server, WINS, DHCP, Proxy, MS Exchange, MS Site Server. I created a bespoke Call Management System for the Customer Service Department tracking all calls. Always approachable to solve problems. Basically keeping all the VIP/Users happy with whatever request or problem they had. Working exceptionally well on my own whilst also being a Team Member within the Company. Working the hours the job needed.

Skills Used : NT 4.0 Server and Workstation, MS Access 2000, Office 2000, VBA, WINS, DHCP, TCP/IP, Proxy Server, FTP, IIS, NT Security, Access, MS Site Server, Servers & Workstations MS Excel, MS Word, Troubleshooting, Comms, Exchange Server 5.5.

Working with the Directors I listened to the ideas and thoughts of a new Website venture, I designed a prototype system in MS Access. I sourced an ISP, Hardware and Software to host the Website. Installing a Microsoft Solution of MS Windows 2000 and MS SQL 7.0 as the back end repository and ASP Active Server Pages. I did all Internal Installation and Support. Assisted with Marketing Ideas. Specified all Data requirements for the Website. Installed all Laptops for Sales Force and provided remote Application Support. Created a bespoke Marketing and Telesales Allocation System. Working as a key Individual whilst being a popular Team Player and Contributor.

Skills Used : Local and Remote Application Support, Windows 2000 Server and Windows 2000 Professional, MS Access 2000, MS Office 2000, VBA, IIS 5.0, ASP, MS SQL Server 7.0, Laptops, TCP/IP, Servers, Workstations, Modems, Troubleshooting, MS Access + MS Office, FTP, DHCP.

Providing Technical support for an interim period, this was whilst the company was growing and employing new staff.

Trading Room Support, Bloomberg, Reuters, Financial Data, I also created a bespoke Portfolio Management System.

This was a year 2000 project, Data Migration and Conversion for 6 systems from MS Access 97 to MS Access 2000.

Trading Room Support, Bloomberg, Reuters, Financial Data.

I rapidly developed a banking reconciliation tool using Microsoft Access to clean up financial trades of a failed system.

Jun 1989 – Jun 1997

British Petroleum PLC , London	June 97 – Apr 98	Dealing Room Support Analyst, Zone 1
Network Rail , UK	Dec 96 - Jun 97	Microsoft Access Development / Support / Rollout
BMW Finance , Bracknell	Oct 96 - Dec 96	Microsoft Back Office Support & Migration
Macquarie Bank , London	Sep 96 - Oct 96	Interim I.T. Support ( Holiday Cover)
UBS Bank , Switzerland	June 96 - Sep 96	NT Support & Development Analyst
Burton Group Logistics, Milton Keynes	Apr 96 - Jun 96	Data Migration Analyst
Charles Stanley Stockbrokers , London	Jan 96 - Apr 96	I.T. Support Analyst
HMIP , London	Oct 95 - Dec 95	Local Area Network Support
OFTEL , London	Aug 95 - Oct 95	Migration Analyst
Seven Layer Systems, Bicester	Aug 94 - Jul 95	Microsoft Access Software Developer
I.C.A.E.W , Milton Keynes	Jan 94 - Aug 94	Technical Support Analyst
Unipart , Cowley	Jul 93 - Dec 93	Microline Support & Development Analyst
Unigate , Kidlington	Jun 89 - Jul 93	PC Support & Development Analyst

Education: Bicester Community College – 7 GCSE’s

Qualifications:

MCP  : Microsoft Certified Professional passing the following modules:-   Installing, Configuring and Administrating Microsoft Windows Professional ( MCP ), Four older Microsoft NT4.0 modules (MCP)