An experienced IT Consultant with expertise in the telecoms, energy and financial sectors
Aktualisiert am 04.12.2022
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 11.12.2022
Verfügbar zu: 100%
davon vor Ort: 100%
Oracle/SQL
PL/SQL
Scrum Master
PLSQL

Einsatzorte

Einsatzorte

EU wide (+500km)
Deutschland, Österreich, Schweiz
möglich

Projekte

Projekte

7 Monate
2021-12 - 2022-06

meetings, follow ups and technical support

SCRUM master / Technical support, coordinator
SCRUM master / Technical support, coordinator
  • While working for TCS my role was one of SCRUM master / Technical support for NMBS Belgium Rail(same end client as previous role)
  • I was a coordinator between the offshore company TCS and Belgium Rail, for example Daily Agile meetings,follow ups and technical support
Tata Consultancy Services
Brussels, Belgium
11 Monate
2020-08 - 2021-06

IT application architecture

Technical Architect
Technical Architect
  • Responsible for IT application architecture within ORACLE area 
  • Analyse technology needs from the business demands and create technical product requirements 
  • Mentoring and coaching the offshore teams (Daily Agile meetings/follow-up)
  • Development of roadmaps /methods of approach for estate wide upgrade of oracle databases to ORACLE 19c (250 applications affected) 
  • Monitor the allocated budget and costing different proposals
NMBS Belgium Rail
Brussels, Belgium
8 Monate
2019-05 - 2019-12

Technical Support

ORACLE consultant SCRUM AGILE ORACLE 11g ...
ORACLE consultant
  • Translated the requirements of functional analysis into technical design.
  • Designed / validated ERD / 3NF data models based on these functional analyses.
  • Architecture, design and development in PL / SQL.
  • Management and application tuning of Oracle Databases in development and test environments.
  • Promotion management processes and the associated Database scripts working in a DevOps process environment
  • Using BUILDMASTER /  PowerShell Scripting  to access GIT and do automated oracle based releases (packages ,scripts)
  • Technical support for various projects within Belgium Rail (Timetabling, Infrastructure)
  • Code reviews for team members
  • Using ETL tools for the extraction and loading and transformation of data from different interfaces
    SCRUM AGILE ORACLE 11g PL/SQL ServiceNow Buildmaster JIRA Agile DevOps
    NMBS Belgium Rail
    Brussels
    3 Jahre
    2015-10 - 2018-09

    Technical Support

    Technical Support Analyst
    Technical Support Analyst

    • DevOps process environment supporting specialised in house and 3rd party systems for EON Solution Support UK
    • Monitoring batch jobs (reading Unix logs, fixing and re-running batch jobs) 
    • Change delivery (PL/SQL), testing, and deployment
    • Operational engagement, working with project teams and managers to support implementation of changes including offshore teams 
    • AGILE methodology as part of our development process

    ORACLE11g PL/SQL REMEDY FIDDLER2 ServiceNow Dimensions
    EON Solutions Support
    Nottingham, UK
    3 Jahre 6 Monate
    2011-07 - 2014-12

    Support

    Technical Support Analyst CDRator Oracle 9 ? 11 Toad ...
    Technical Support Analyst
    • Ensured that computer systems were functioning properly, installing software, incident fixing, and monitoring the current processes regarding activations of new customers and identifying and solving any problems that affect day to day operations of our customer Telefonica/O2 in a DevOps process environment.
    • Use of KANBAN for tracking the incidents from analysis right through to deployment.
    • Production of various reports detailing new activations and associated packs. These then furnished to Telefonica as part of our stakeholder requirements and service level agreements.
    • Monitored the different workflows and ensured that the different order queues were functioning correctly and had constant contact with our customers.
    • Monitored the Apache servers, analysing the logs and supporting the application over UNIX / Windows infrastructure.
    • We also analysed different parts of the system and produce enhancements using PL/SQL.
    • Organized and worked on deployment of software on the different environments.
    CDRator Oracle 9 ? 11 Toad Squirrel Remedy Nagios ASN 1 XML Active Directory Apache Tomcat Java. Browsers Jenkins Microsoft Office MySQL Juno Pulse Lotus Notes Adobe Jira Confluence DevOps
    BASF / TELEFONICA
    München
    7 Monate
    2010-10 - 2011-04

    FORMS to support a client policy applications

    Technical Business Analysts
    Technical Business Analysts
    • Using Business Objects and SAP Crystal Reports software, and backend modules in SLQ
    • FORMS to support a client policy applications
    • Providing the front end Policy Application letters in the English and Danish languages (SAP Crystal Reports)
    • Gathering user requirements
    ORACLE10g PL/SQL SAP Crystal Reports SQL*Forms SQL*Reports.
    ING LIFE
    Luxembourg
    6 Monate
    2010-01 - 2010-06

    Provided consultancy services for the construction and development of an Asset Tracking Database

    Technical Business Analyst
    Technical Business Analyst
    • Provided consultancy services for the construction and development of an Asset Tracking Database. This involved design, construction and testing of an Asset Tracking database with related user reports, GUI mechanisms, implementation and support of the system when live
    • Gathering user requirements, design, development, testing and implementation using the ORACLE 10g suite of tools
    • Sizing requirements, database management and the day to day running of the implemented system. I completed the data modelling in Designer 2000 and from there developed the GUI interface and reports for the Asset Tracking system.
    • Loading of excel sheets containing data to ORACLE database tables.
    ORACLE10g TOAD PL/SQL Designer 2000 SQL*Forms SQL*Reports
    VIETNAMOBILE
    Hanoi, Vietnam
    9 Monate
    2009-05 - 2010-01

    English Teaching

    English Teacher
    English Teacher
    • During the economic downturn, I decided to try a change of direction and went to Vietnam to both teach English and diversify my skill set.
    • The institute itself promoted learning English through a variety of classroom activities, such as group and individual assignments and real-life interaction with an English-speaking community.
    • I enjoyed my time there, having taught age ranges from kids to adults. 
    • This gave me great experiences interacting with different cultures.
    CLEVERLEARN INSTITUTE
    Hanoi, Vietnam
    7 Monate
    2008-10 - 2009-04

    Kopernikus.

    Technical Business Analyst
    Technical Business Analyst
    • Design, Development, Unit Testing, documentation and implementation of newly developed code for the project Kopernikus.
    • Tasks included writing detailed functional specifications, design of interfaces to different systems, unit testing, End to End testing, configuration management, user liaison and installations of newly developed software.
    ORACLE 9i TOAD PL/SQL Rational Rose HP-UX unix Rational ClearCase Explorer Rational ClearQuest BMC Remedy user Reflection X
    TELEFONICA/O2
    Munich, Germany
    9 Monate
    2007-11 - 2008-07

    Enhance and maintain a business critical, short term order planning and logistics application

    Oracle Designer / Developer
    Oracle Designer / Developer
    • Worked in an international team to enhance and maintain a business critical, short term order planning and logistics application with hundreds of end users in an internationally distributed database environment.
    • Oracle 10g R2 database with a complex data model containing more than one thousand tables and views. Flexible reaction to customer’s changing business requirements.
    • Customer contact and requirements definition in German. 
    Oracle 10g R2 SQL-NAVIGATOR PL/SQ
    SIEMENS/QIMONDA
    Munich, Germany
    2 Jahre
    2005-11 - 2007-10

    Ensured data and database structural integrity

    Technical Business Analyst
    Technical Business Analyst
    • Ensured data and database structural integrity maintained throughout full development life-cycle and extended through the roll-out phase for the Dealer-Sales project
    • Version control, testing, and release management of complex PL/SQL modules
    • Modifications to ensure enhanced performance and optimization of developed code within an oracle 9i environment.
    ORACLE 9i TOAD PL/SQL Rational Rose HP-UX unix Rational ClearCase Explorer Rational ClearQuest BMC Remedy user Reflection X
    TELEFONICA/O2
    Munich, Germany

    Aus- und Weiterbildung

    Aus- und Weiterbildung

    2 Jahre 10 Monate
    1982-09 - 1985-06

    Computer Science

    Degree Informatkier, DUNDALK RTC IRELAND
    Degree Informatkier
    DUNDALK RTC IRELAND
    Computer Science

    Position

    Position

    Technical Data Analyst--application support. Available remotely too

    Kompetenzen

    Kompetenzen

    Top-Skills

    Oracle/SQL PL/SQL Scrum Master PLSQL

    Produkte / Standards / Erfahrungen / Methoden

    Adobe
    agile Software-Development
    Buildmaster
    CDRator
    Confluence
    DevOps
    Dimensions
    FIDDLER2
    Jenkins
    JIRA
    Lotus Notes
    Microsoft Office
    Nagios
    REMEDY
    ServiceNow
    Squirrel
    Toad
    Tomcat
    XML
    Profile

    An experienced IT Consultant with expertise in the telecoms, energy, rail and financial sectors: 

    • Many years? experience of supporting ORACLE RDBMS databases (8 ?19c). 
    • Great Knowledge of PL-SQL / SQL including performance tuning. 
    • Data warehouse (DWH) , ETL and DevOps experience 
    • Database design techniques ,Data modelling techniques ,and oracle architecture. 
    • Ability to participate in multi-lingual meetings, very good communication skills. 
    • Ability to work in multi-cultural environment, on large projects. Team Player. 
    • Fluent in German (Certificate from Goethe Institute) 


    Software Skills

    • Oracle DBA 11G/19c; UNIX; SQL; PL/SQL. Experience with a wide variety of telecoms applications providing Mediation, rating, Charging and Billing Functionality 
    • Database developer using PL/SQL version 19 & MS SQL 
    • MS Project, Word, Access, Excel. 
    • Systems Implementation and operations support including applications over UNIX / Windows infrastructure 
    • Data modelling, writing, tuning and optimizing SQLs and PL- SQL statements 
    • DevOps, ETL, DWH 
    • Good knowledge of Jenkins, GIT, Kubernetes, GitHub 


    Software / Tools

    • Jira, Confluence, Bitbucket 
    • Rational Clearquest 
    • Buildmaster 
    • GIT 
    • Microsoft SQL Server / Enterprise Manager, Query Analyzer 
    • TOAD / SQL Developer 
    • ClearCase Explorer
    • Reflection X 
    • BMC Remedy user 
    • SAP Crystal Reports 
    • KANBAN, AGILE methodologies 
    • JENKINS Builds / Console 
    • Linux / Unix 
    • DevOps process environments 
    • ETL (extract transform and load data) For various data warehouse applications


    Experience

    2010-01 - 2010-06

    Role: Technical Analyst

    Customer: VIETNAMOBILE, Hanoi, Vietnam


    2009-05 - 2010-01

    Role: English Teacher

    Customer: CLEVERLEARN INSTITUTE, Hanoi


    2008-10 - 2009-04

    Role: Technical Business Analyst

    Customer: TELEFONICA/O2, Munich, Germany


    2007-11 - 2008-07

    Role: Oracle Designer / Developer

    Customer: SIEMENS/QIMONDA, Munich, Germany


    2005-11 - 2007-10

    Role: Technical Business Analyst

    Customer: TELEFONICA/O2, Munich, Germany


    2003-07 - 2004-11

    Role: Oracle Designer /Developer

    Customer: CAMPUSIT, Dublin, Ireland


    2001-04 - 2002-11

    Role: Data Modeller

    Customer: SIEMENS BUSINESS SERVICES, Munich, Germany


    2000 - 11 - 2001-04

    Role: Database Programmer

    Customer: T-MOBIL, Bonn, Germany


    1998-03 - 2000-07

    Role: Billing Technical Consultant

    Customer: CSC PLOENZKE, Munich, Germany


    1997-06 - 1998-02

    Role: Data Warehouse Analyst

    Customer: PROCTOR & GAMBLE, Warsaw, Poland


    1989-08 - 1997-06

    Role: Analyst/Programmer

    Customer: THE LAW SOCIETY, London


    1987-07 - 1989-07

    Role: Programmer

    Customer: UNITED STATES ARMY, Berlin, Germany

    Datenbanken

    AGILE
    ENERGIE
    Lotus Notes
    MySQL
    MySQL
    ORACLE 11g
    Oracle 9 ? 11
    ORACLE11g
    ORACLE11g
    SCRUM
    TELECOMMS

    Datenkommunikation

    oracle
    pl/sql

    Einsatzorte

    Einsatzorte

    EU wide (+500km)
    Deutschland, Österreich, Schweiz
    möglich

    Projekte

    Projekte

    7 Monate
    2021-12 - 2022-06

    meetings, follow ups and technical support

    SCRUM master / Technical support, coordinator
    SCRUM master / Technical support, coordinator
    • While working for TCS my role was one of SCRUM master / Technical support for NMBS Belgium Rail(same end client as previous role)
    • I was a coordinator between the offshore company TCS and Belgium Rail, for example Daily Agile meetings,follow ups and technical support
    Tata Consultancy Services
    Brussels, Belgium
    11 Monate
    2020-08 - 2021-06

    IT application architecture

    Technical Architect
    Technical Architect
    • Responsible for IT application architecture within ORACLE area 
    • Analyse technology needs from the business demands and create technical product requirements 
    • Mentoring and coaching the offshore teams (Daily Agile meetings/follow-up)
    • Development of roadmaps /methods of approach for estate wide upgrade of oracle databases to ORACLE 19c (250 applications affected) 
    • Monitor the allocated budget and costing different proposals
    NMBS Belgium Rail
    Brussels, Belgium
    8 Monate
    2019-05 - 2019-12

    Technical Support

    ORACLE consultant SCRUM AGILE ORACLE 11g ...
    ORACLE consultant
    • Translated the requirements of functional analysis into technical design.
    • Designed / validated ERD / 3NF data models based on these functional analyses.
    • Architecture, design and development in PL / SQL.
    • Management and application tuning of Oracle Databases in development and test environments.
    • Promotion management processes and the associated Database scripts working in a DevOps process environment
    • Using BUILDMASTER /  PowerShell Scripting  to access GIT and do automated oracle based releases (packages ,scripts)
    • Technical support for various projects within Belgium Rail (Timetabling, Infrastructure)
    • Code reviews for team members
    • Using ETL tools for the extraction and loading and transformation of data from different interfaces
      SCRUM AGILE ORACLE 11g PL/SQL ServiceNow Buildmaster JIRA Agile DevOps
      NMBS Belgium Rail
      Brussels
      3 Jahre
      2015-10 - 2018-09

      Technical Support

      Technical Support Analyst
      Technical Support Analyst

      • DevOps process environment supporting specialised in house and 3rd party systems for EON Solution Support UK
      • Monitoring batch jobs (reading Unix logs, fixing and re-running batch jobs) 
      • Change delivery (PL/SQL), testing, and deployment
      • Operational engagement, working with project teams and managers to support implementation of changes including offshore teams 
      • AGILE methodology as part of our development process

      ORACLE11g PL/SQL REMEDY FIDDLER2 ServiceNow Dimensions
      EON Solutions Support
      Nottingham, UK
      3 Jahre 6 Monate
      2011-07 - 2014-12

      Support

      Technical Support Analyst CDRator Oracle 9 ? 11 Toad ...
      Technical Support Analyst
      • Ensured that computer systems were functioning properly, installing software, incident fixing, and monitoring the current processes regarding activations of new customers and identifying and solving any problems that affect day to day operations of our customer Telefonica/O2 in a DevOps process environment.
      • Use of KANBAN for tracking the incidents from analysis right through to deployment.
      • Production of various reports detailing new activations and associated packs. These then furnished to Telefonica as part of our stakeholder requirements and service level agreements.
      • Monitored the different workflows and ensured that the different order queues were functioning correctly and had constant contact with our customers.
      • Monitored the Apache servers, analysing the logs and supporting the application over UNIX / Windows infrastructure.
      • We also analysed different parts of the system and produce enhancements using PL/SQL.
      • Organized and worked on deployment of software on the different environments.
      CDRator Oracle 9 ? 11 Toad Squirrel Remedy Nagios ASN 1 XML Active Directory Apache Tomcat Java. Browsers Jenkins Microsoft Office MySQL Juno Pulse Lotus Notes Adobe Jira Confluence DevOps
      BASF / TELEFONICA
      München
      7 Monate
      2010-10 - 2011-04

      FORMS to support a client policy applications

      Technical Business Analysts
      Technical Business Analysts
      • Using Business Objects and SAP Crystal Reports software, and backend modules in SLQ
      • FORMS to support a client policy applications
      • Providing the front end Policy Application letters in the English and Danish languages (SAP Crystal Reports)
      • Gathering user requirements
      ORACLE10g PL/SQL SAP Crystal Reports SQL*Forms SQL*Reports.
      ING LIFE
      Luxembourg
      6 Monate
      2010-01 - 2010-06

      Provided consultancy services for the construction and development of an Asset Tracking Database

      Technical Business Analyst
      Technical Business Analyst
      • Provided consultancy services for the construction and development of an Asset Tracking Database. This involved design, construction and testing of an Asset Tracking database with related user reports, GUI mechanisms, implementation and support of the system when live
      • Gathering user requirements, design, development, testing and implementation using the ORACLE 10g suite of tools
      • Sizing requirements, database management and the day to day running of the implemented system. I completed the data modelling in Designer 2000 and from there developed the GUI interface and reports for the Asset Tracking system.
      • Loading of excel sheets containing data to ORACLE database tables.
      ORACLE10g TOAD PL/SQL Designer 2000 SQL*Forms SQL*Reports
      VIETNAMOBILE
      Hanoi, Vietnam
      9 Monate
      2009-05 - 2010-01

      English Teaching

      English Teacher
      English Teacher
      • During the economic downturn, I decided to try a change of direction and went to Vietnam to both teach English and diversify my skill set.
      • The institute itself promoted learning English through a variety of classroom activities, such as group and individual assignments and real-life interaction with an English-speaking community.
      • I enjoyed my time there, having taught age ranges from kids to adults. 
      • This gave me great experiences interacting with different cultures.
      CLEVERLEARN INSTITUTE
      Hanoi, Vietnam
      7 Monate
      2008-10 - 2009-04

      Kopernikus.

      Technical Business Analyst
      Technical Business Analyst
      • Design, Development, Unit Testing, documentation and implementation of newly developed code for the project Kopernikus.
      • Tasks included writing detailed functional specifications, design of interfaces to different systems, unit testing, End to End testing, configuration management, user liaison and installations of newly developed software.
      ORACLE 9i TOAD PL/SQL Rational Rose HP-UX unix Rational ClearCase Explorer Rational ClearQuest BMC Remedy user Reflection X
      TELEFONICA/O2
      Munich, Germany
      9 Monate
      2007-11 - 2008-07

      Enhance and maintain a business critical, short term order planning and logistics application

      Oracle Designer / Developer
      Oracle Designer / Developer
      • Worked in an international team to enhance and maintain a business critical, short term order planning and logistics application with hundreds of end users in an internationally distributed database environment.
      • Oracle 10g R2 database with a complex data model containing more than one thousand tables and views. Flexible reaction to customer’s changing business requirements.
      • Customer contact and requirements definition in German. 
      Oracle 10g R2 SQL-NAVIGATOR PL/SQ
      SIEMENS/QIMONDA
      Munich, Germany
      2 Jahre
      2005-11 - 2007-10

      Ensured data and database structural integrity

      Technical Business Analyst
      Technical Business Analyst
      • Ensured data and database structural integrity maintained throughout full development life-cycle and extended through the roll-out phase for the Dealer-Sales project
      • Version control, testing, and release management of complex PL/SQL modules
      • Modifications to ensure enhanced performance and optimization of developed code within an oracle 9i environment.
      ORACLE 9i TOAD PL/SQL Rational Rose HP-UX unix Rational ClearCase Explorer Rational ClearQuest BMC Remedy user Reflection X
      TELEFONICA/O2
      Munich, Germany

      Aus- und Weiterbildung

      Aus- und Weiterbildung

      2 Jahre 10 Monate
      1982-09 - 1985-06

      Computer Science

      Degree Informatkier, DUNDALK RTC IRELAND
      Degree Informatkier
      DUNDALK RTC IRELAND
      Computer Science

      Position

      Position

      Technical Data Analyst--application support. Available remotely too

      Kompetenzen

      Kompetenzen

      Top-Skills

      Oracle/SQL PL/SQL Scrum Master PLSQL

      Produkte / Standards / Erfahrungen / Methoden

      Adobe
      agile Software-Development
      Buildmaster
      CDRator
      Confluence
      DevOps
      Dimensions
      FIDDLER2
      Jenkins
      JIRA
      Lotus Notes
      Microsoft Office
      Nagios
      REMEDY
      ServiceNow
      Squirrel
      Toad
      Tomcat
      XML
      Profile

      An experienced IT Consultant with expertise in the telecoms, energy, rail and financial sectors: 

      • Many years? experience of supporting ORACLE RDBMS databases (8 ?19c). 
      • Great Knowledge of PL-SQL / SQL including performance tuning. 
      • Data warehouse (DWH) , ETL and DevOps experience 
      • Database design techniques ,Data modelling techniques ,and oracle architecture. 
      • Ability to participate in multi-lingual meetings, very good communication skills. 
      • Ability to work in multi-cultural environment, on large projects. Team Player. 
      • Fluent in German (Certificate from Goethe Institute) 


      Software Skills

      • Oracle DBA 11G/19c; UNIX; SQL; PL/SQL. Experience with a wide variety of telecoms applications providing Mediation, rating, Charging and Billing Functionality 
      • Database developer using PL/SQL version 19 & MS SQL 
      • MS Project, Word, Access, Excel. 
      • Systems Implementation and operations support including applications over UNIX / Windows infrastructure 
      • Data modelling, writing, tuning and optimizing SQLs and PL- SQL statements 
      • DevOps, ETL, DWH 
      • Good knowledge of Jenkins, GIT, Kubernetes, GitHub 


      Software / Tools

      • Jira, Confluence, Bitbucket 
      • Rational Clearquest 
      • Buildmaster 
      • GIT 
      • Microsoft SQL Server / Enterprise Manager, Query Analyzer 
      • TOAD / SQL Developer 
      • ClearCase Explorer
      • Reflection X 
      • BMC Remedy user 
      • SAP Crystal Reports 
      • KANBAN, AGILE methodologies 
      • JENKINS Builds / Console 
      • Linux / Unix 
      • DevOps process environments 
      • ETL (extract transform and load data) For various data warehouse applications


      Experience

      2010-01 - 2010-06

      Role: Technical Analyst

      Customer: VIETNAMOBILE, Hanoi, Vietnam


      2009-05 - 2010-01

      Role: English Teacher

      Customer: CLEVERLEARN INSTITUTE, Hanoi


      2008-10 - 2009-04

      Role: Technical Business Analyst

      Customer: TELEFONICA/O2, Munich, Germany


      2007-11 - 2008-07

      Role: Oracle Designer / Developer

      Customer: SIEMENS/QIMONDA, Munich, Germany


      2005-11 - 2007-10

      Role: Technical Business Analyst

      Customer: TELEFONICA/O2, Munich, Germany


      2003-07 - 2004-11

      Role: Oracle Designer /Developer

      Customer: CAMPUSIT, Dublin, Ireland


      2001-04 - 2002-11

      Role: Data Modeller

      Customer: SIEMENS BUSINESS SERVICES, Munich, Germany


      2000 - 11 - 2001-04

      Role: Database Programmer

      Customer: T-MOBIL, Bonn, Germany


      1998-03 - 2000-07

      Role: Billing Technical Consultant

      Customer: CSC PLOENZKE, Munich, Germany


      1997-06 - 1998-02

      Role: Data Warehouse Analyst

      Customer: PROCTOR & GAMBLE, Warsaw, Poland


      1989-08 - 1997-06

      Role: Analyst/Programmer

      Customer: THE LAW SOCIETY, London


      1987-07 - 1989-07

      Role: Programmer

      Customer: UNITED STATES ARMY, Berlin, Germany

      Datenbanken

      AGILE
      ENERGIE
      Lotus Notes
      MySQL
      MySQL
      ORACLE 11g
      Oracle 9 ? 11
      ORACLE11g
      ORACLE11g
      SCRUM
      TELECOMMS

      Datenkommunikation

      oracle
      pl/sql

      Vertrauen Sie auf GULP

      Im Bereich Freelancing
      Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

      Fragen?

      Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

      Das GULP Freelancer-Portal

      Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.