Kevan Haynes

Data mining & extraction

Interfacing between SAGE X3 ERP platform and ancillary applications (Dispensary Management System - DMS, Bartender, Orchestrate (O8), CDC and Tungsten) in a pharmaceutical and cosmetics manufacturing environment. Talend Open Studio ESB 7.1 for data integration, SQL Server SSIS 2014, T-SQL and SSRS Reports. Maintenance and faultfinding of Enterprise Service Bus data extracts via JMS/ActiveMQ, Apache Camel messaging routes and Apache Karaf container 4.1.6.

• Data modelling for various client projects (financial and retail) • Data mapping from source to target Microsoft Azure cloud storage • Translation of data mpapping into ETL flows using Microsoft SSIS • Generate reports using Microsoft SSRS

• Liaise with business users to create use cases and data mapping spreadsheets • Fault analysis and correction on various Data Warehouse issues. Working with DataStage 11.5 • Teradata database environment (source and target)

• Business Analysis to refine specifications for development cycle and produce data mapping spreadsheets. • Mentoring and training of junior DataStage developers. • DataStage 11.5 development in an Agile environment. • Data migration from Kafka bus to Netezza and Oracle databases. • Data migration to AWS cloud database. • Parsing of JSON messages from various applications. • Continuous integration using GIT, Ansible and Jenkins.

Extract data from SAP using DataStage BAPI stage. Mentoring of junior developers. DataStage administration.

Develop DataStage extracts for new Admin system data warehouse at Telenor. Performance tuning of DataStage.

 Required to introduce DataStage, Business Glossary and other IBM Infosphere products into the Capital Markets division of Nordea Bank.  Establish a development framework for DataStage to enable full system development life cycle within Infosphere.  Create developer and general user guideline documents for developer on-board process  Set up the various environments for DataStage: Dev, Test and Production  Set up new projects for teams starting to use DataStage 9.1 and mentoring of developers

Configure FastTrack, Metadata Workbench, Infosphere CDC and Infosphere source code management. Develop data migration jobs in DataStage 9.1

DataStage 8.7 development in Investment Banking environment.

DataStage developer for Stream and IBM at Danske Bank, Denmark. Environment is DataStage 8.5, Information Analyzer, SQL Server 2008, FastTrack and IBM Data Architect

Data Analysis, Mapping and Quality Control. Programming of DataStage jobs to migrate data from source systems to a new target database. Using InfoSphere DataStage, QualityStage, Information Analyzer and FastTrack.

Business Analysis and Data Mapping of source data to be extracted from SAP and migrated to a new Oracle 10g target database. PL/SQL, DataStage v8.1, Informatica, IBM Data Architect

Computer Programming, Electronics, Electrical Engineering, Digital Systems, Telecommunications, Industrial Technology