Unicredit 10 years datastage, teradata

Personal statements
A graduate computer programmer with 25+ years experience, the last 10 years as a Datastage developer. Strong analytical and technical aptitudes, now seeking new project challenges.
I am a confident team player and can work independently. I am part of a multi-cultural, multi-language team. I enjoy working hard under pressure, and am determined in achieving the goal of a project.  I am self-motivated, proactive and highly focused with strong analytical skills, and a logical approach to problem solving. 

Professional Experience

International Bank                            2007-Present

    Datastage developer 

    Profile:

    • Approx. 10 years of career reflecting experience Design, Development, Implementation, ETL Application development projects.
    • Project based work, involving project management and tight delivery deadlines.
    • Strong skills in IBM Datastage 8.1 , 9.1, 11.5 and Teradata 13.x.
    • Experience in Data warehousing, Application development
    • Experience in Designing, Developing, Documenting and Testing of ETL Jobs in DataStage 
    • Experience in Bteq scripting
    • Stage to populate tables in Data warehouse and data marts.
    • Performed SDLC cycle of Data Integration, Unit testing, System Integration testing, Implementation, Maintenance and Performance tuning
    • Leading experience in GCD project phase I.
    • Work in ALM and RISK management project

Technical Skills 

    • ETL Tools:  IBM Datastage Enterprise Edition 8.1
    • Database: Teradata 13.x, MS SQL
    • Operating System: LINUX , Windows
    • Tools& Utilities: HP Quality Center, Excel
    • Additional programming language: C++, C#, Visual Basic

Description

    • Extracted data from Complex Flat Files (CFF) and Persistent Datasets.
    • Effectively used Persistent Datasets to transfer the data between jobs.
    • Performed Unit Testing and System Integration Testing based on Test cases.
    • Creating test cases for Unit Test
    • Build Datastage jobs to read files from multiple vendors using Complex Flat File and Sequential File stages.
    • Creating Teradata sql scripts.
    • Optimising Datastage jobs
    • Optimising Teradata sql scripts
    • Cleanse and transform the data as per business logic.
    • Design and Execute test scripts.
    • Load data into Teradata tables using Teradata connector stage.
    • Analysed the defects and applied fixes in the Datastage jobs and Sequencers.
    • Document and track the defects in Quality center.
    • 2nd level support 

Technical analyst
   Description

    • Creating Source Target Matrix (STM) based on Business Data Elements (BDE)
    • Creating mappings and DDLs
    • Creating Teradata scripts 

Vicom                                         2003-2007
      
   Preparation of invoicing and stock-register programme in Visual Basic language.

Sláger Rt., Budapest                                1997-2003

    • Preparation of invoicing and stock-register programme. Management of this programme, operation and maintenance the NOVELL network and other computer facilities of the company.

Hema Vegyiáru Nagykereskedelmi Kft, Budapest                1995-1997

    • Preparation of invoicing and stock-register programme. Management of this programme, operation and maintenance the NOVELL network and other computer facilities of the company.

Számítástechnikai és Ügyvitelszervező Vállalat, Budapest            1986-1994

    • Initially, system-programmer of R20 and R40 computers, preparation of programmes in PL/1 and JCL languages. Later turned to programming of IBM PC computers in FOXPRO, PASCAL, C and CLIPPER languages.
    • Preparation of contract-register programme for CHEMOLIMPEX in 1987 and 1988.
    • In 1988 recommended application of NOVELL network system at the company. Later on, responsible for development and operating network system.
    • Participated in preparation of programmes for the Parliamentary Election in 1989 and 1990.
    • Participation in preparation of insurance policy-register programme for Hungaria Biztosító in 1994.

Education

Eötvös Lorand University, Budapest                        1984-1987
Faculty of Natural Science

Special subject:  Programmer-mathematician
Main subject:      Programming, Analysis, System-programming, Operational research

I. István Grammar School, Budapest                        1980-1984
Specialising in physics and mathematics.

Skills
    • Fair knowledge of English
    • Driving licence (B)

Interests and Hobbies
    • Model making
    • Other: cooking, history, gardening