IT Manager
Mackenzie Isaac (George and Freddie at Amazon)
Total years of experience :15 years, 5 Months
Manage the Data Team, SQL report writing, Management Information System Development, liaise and interface with developers for Business and User requirements.
Writing new process procedures, pecifications, testing and new development acceptance.
Senior Analyst Developer
Developing new functionality and integrating the discrete systems into new system for client CVS Caremark. Development using Synon & RPGILE and change control using Aldon.
Senior Systens Analyst
Working primarily as Senior System Analyst with two teams of developers for two main projects, LFDL and LDL.
LFDL (Legacy Financial Data Load) is ETL (Extract Transform & Load) process, primarily it is developed using Java Spring Batch, and works on a number of different platforms. The legacy data is extracted from legacy systems, which are As400 and Mainframe machines, using Control-M, this initiate's the spring Batch job, which transforms the data by interfacing with another in house java application Legacy Translator and loads it into the new Common System tables onto a Linux machine. I was the Senior Analyst on the project and successfully developed the project to production release version 1.4, liaising with the TA and a development team based in Mauritius.
LDL (Legacy Data Load) is transactional process using XML messages, using Broker and MQ. I was the Senior Analyst for the development of the LDL process for Italy. Transactional information for consignments is sent in the form of XML messages from the AS400, these are then filtered using a set of complex rules and loaded into the appropriate tables on a Linux machine for use by the new suite of Common System application.
During my time TNT Express I was also responsible for redesigning and porting the WIKI for Cross Functional and Integration onto the internet. I was the Super User for the replacement Service Desk application HP's Service Now.
One of the other projects I was responsible for was using Sparxx Systems data modelling tool for UML Enterprise Architect to model all the existing Cross Functional systems.
Senior Analyst Programmer
P&O Ferrymasters initially had two Transport and Logistic systems, a Full load system (AS400) and a Part-Load Powerbuilder System (Pc)
Powerbuilder Systems worked on: Orders Planning
Administration Invoicing
Operations MIS
Services Customer Information
AS400 Systems worked on: Invoicing, interface to COIN, CODA Interfaces, EDI orders, sub-systems
Orders, Transport planning, RCN's MIS
Transport, Collection and Delivery planning Archive
Route Scheduling and Tolls, Equipment control Administrator on MKS Change Management
The MIS (Management Information System) on both platforms and ARCHIVE subsystem on AS400 required extensive analysis and interpretation of data from multiple databases & files to create reports and tables and present these in a number of different formats and views.
Along with development, documentation was produced to model the system and business processes. Project managed the integration and implementation of the DPS route scheduling software into Transport and Logistic System.
These systems were replaced by a new integrated Transport and Logistic System with a GUI front end; initially there was a requirement to replicate the master and transaction data from the DB2 system to the Sybase system.
This was achieved using Store Procedures.
Development in these systems was done in Powerbuilder, SQL and T-SQL on the Pc system and Synon 2E, DB2 Sql and T-SQL on the AS400 platform. The new system was a 3-tier application with a GUI front end, EA-server middle tier and a Sybase ASE database backend.
Mentor is a Software House and hence requires all types of skills. Consultants are required to Project Manage all aspects of the Software Life Cycle, including auditing of the clients systems.
Work for Mentor has included Y2K compatibility, fixing and testing. Making systems Euro currency ready and support work. All the work is done to a high standard and fully documented, because Mentor is ISO9001 and CheckIT accredited.
Client: Scania Great Britain in Milton Keynes; systems:
Invoicing Accounts
Parts
Vehicle Administration System. Orders
Initially due to the IT department being replaced by Mentor personnel, there was huge task of Analysis and documentation of the current system and features. The system is written in Synon 2e and runs on multiple AS400's. A major part of time was documenting the existing system and Project managing a new Archiving system, from inception through to coding, testing and implementation.
Senior Analyst Programmer - European Implementation Team
Work included all aspects of Implementation: Analysis work Reports, understanding the business processes. First part of the project was migration of existing systems diverse technologies into a unified new System. Secondary was making the existing systems Y2K compliant and able to handle the Euro currency.
During my tenure at Norgren my major projects were:
Euro compliance Y2K compatibility
User training Language support
Report writing System migration
Analyst Programmer - European Projects
Working in a multi-model Synon environment.
• Developing, supporting, upgrading, enhancing packages, supplied by Global to the automotive industry.
• Working closely with clients throughout the life of a project.
• Motor vehicle parts system, referencing and availability
• Ensuring year 2000 compliance of old software.
• Porting software from CISC to RISC machines.
My technical skill set has greatly enhanced here, learning all aspects of Systems development and some DBA duties. I have better understanding of RPG, as well as improving my CL.
Analyst Programmer/Support Analyst - European I.T. Group
Computer Science BSc 2.i (HONS)