people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontakt


Kontakt


people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontaktdaten anfordern


Freelancerprofil: 26255

Oracle Datenbankspezialist (Entwurf, Entwicklung, ETL)

IT-Erfahrung seit:
1997
Position:
IT Datenbankentwicklung
Projekte im Werdegang

09/2013 - 12/2013 Data for operators
Rather big and important project for Nokia. The purpose was to deliver some specific data (originated in factory) to Nokia customers (mainly operators) in high data quality and shortest possible time. The project integrated 5 Nokia systems together, assuring data flow through all of them. “The system” was in the middle of them, integrating data from different sources (see more below in “Staging area improvements”), linking them together for one particular device and sending such set of data further. The project was in place already for 1 year, but an improvement was needed. Deliverables: • way of handling data: identified slow internal processes of data handling, proposed improvements • overview: a document of processes and dataflow through all includes systems (high level), and a document of the same in “the system” level (low level) • data quality: a new approach taken to avoid of some issues causing that data were not sent • design: all about was summarized for developers in a technical design document (a technical description of changes to be done in PL/SQL code) • development (PL/SQL) and implementation of all needed changes; unit and functional testing and a small simulation of integration testing (full e2e testing done by IT support after); installation script • provide an info-session to IT Support and developers

03/2013 - 06/2013 Staging area improvement
“The system” was integrating data from all factories (in a global level), and because of different data structures in the manufacturing system and “the system”, something called staging area was used for long time in “the system”. The staging area was a set of tables to store temporary data flowing constantly from factories and a set of functionality that made this data available in “the system”. Such approach was in place for long time; however, there was a need for some improvements (including one important change). Deliverables: • review the overall process, propose improvements • find a solution for the important change – changing the way how and what information about some device is the most important for “the system” (e.g. considering also upcoming project “Data for operators”) • design document • development (PL/SQL); unit and functional testing; installation script • provide an info-session to IT Support and developers

10/2012 - 01/2013 Upgrade Oracle 10g to 11gR2
“The systems’” upgrade from Oracle database 10g to 11g rel. 2. Before the upgrade itself, it was requested to do some consolidation work (as the database itself was created with Oracle 8g version, and then skipping Oracle 9i, it was upgraded to Oracle 10g - but without any internal improvements, e.g. what comes to tablespaces). Deliverables: • review “the system” and together with database administrators propose improvements • proposed changes (newly defined tablespaces, solution for system failover) • identify possible risks to “the system” application functionality that could occur due to upgrade • assist DBA during the execution of upgrade in low-level environments

10/2012 - 10/2012 Factory reference data – Informatica interface update
“The system” used different interface types when receiving data from other systems. To get some reference (master) data related to factory production, it used Informatica PowerCenter. The existing interface should be extended for some other data elements. Deliverables: • identify change needed • change the current interface (=Informatica mapping) and update also related Informatica workflows • assure the change is populated to production (by Informatica administrators)

09/2012 - 11/2012 Data copy mechanism
The new low-level environment of “the system” (see also project “Low-level environment”) required also an easy way how to populate particular data from production.(as before, it was done by a set of scripts). Deliverables: • a solution to copy data from production to low-level environment including a way how to populate 1) all reference data regularly and 2) set of data for particular device as needed; a special approach was needed to handle unique sequence numbers used as surrogate primary keys (as those were different in production and low-level environments because data were not only copied, but also created in the low-level environments) • design document: new functionality + new database objects • development (PL/SQL code); unit and functional testing; installation script; deployment to each of low-level environments • provide an info-session to IT Support and developers

08/2012 - 10/2012 Low-level environment
Some things should not be the case normally in such big and complex system and one of them was missing a real low-level environment for developers (DEV), integrating partners’ developers (IT) and quality assurance (QA) testing (till that time existed only one non-production database used for all purposes) Deliverables: • get a general consensus (between developers, IT Support and management) how the new low-level environment should look like (so e.g. considering what data, data volume and cost, user management, access management) • summarize all to a document; get approval from management • drive the implementation (e.g. create requests towards DBA, check when done) • provide an info-session to IT Support and developers

08/2012 - 12/2013 Solution and Database Architect, Business Analyst and Developer
As an IT consultant, I worked with a brand new team of Oracle developers and database architect; the team has been established as a result of internal changes in Nokia (I’ve been member of the previous team for 11 years). The team was responsible for a Global Product Lifecycle Management system, based on Oracle database. The size of database was about 23 TB - storing, maintaining and providing data to about 30 frontend systems over the world for more than 3.8 milliard Nokia products –> handling about 30 requests (queries) in a second (in peak hours 75/sec). Technical environment and tools: Oracle 10g and 11g database Oracle SQL Oracle PL/SQL (SQL Navigator, TOAD, SQL Developer) SQL Developer Data Modeler Informatica PowerCenter 8.6 and 9.1 Magic Draw Accept 360 My main responsibility was • to make the whole team self-confident and ready for the new role • to act as a mentor and advisor for the new database architect to get him experienced with such system (what comes to the size and complexity) • to assist external IT Support team (located in India) when solving production issues • to work on new releases based on business requirements (see the list of projects below) • to analyze business needs/requirements and to consider their implementation • to provide an effort estimation (man-days) for particular releases • to keep technical and functional design documentation and other documentation related to overall system architecture up to date Main projects (not including small and ad-hoc deliveries) are listed below. Note: In projects mentioned “the system” means the “Global Product Lifecycle Management system”

07/2010 - 07/2012 Lead Developer / Database Architect
Note: Below mentioned “Equipment Master” or its abbreviation “EM” is an internal name for so far mentioned “Global Product Lifecycle Management system”. Project: Equipment Master knowledge transfer and Biz Continuity 2011/12 – 2012/07 Knowledge transfer project to set up a new, trained EM team in Finland due to ramp-down of Nokia IT site in Ratingen (Germany). Deliverables: • class room and online trainings • finalizing EM related documentation using Nokia documenting tools and methodologies Project: Equipment Master rel. 5.5 2011/05 – 2012/02 Major upgrade of the system in order to prepare EM to support Nokia Windows Phones Deliverables: • analysis of business needs/requirements, consideration of implementation • creation of functional and technical database design (to be used and implemented by developers) • development (PL/SQL) and also lead, support and control of team of developers and technical development activities • update of technical and functional design documents and other documents related to overall system architecture Project: Sandra 2009/11 – 2010/11 Infrastructure project to centralize EM service, cut-off regional databases and simplify EM architecture Deliverables: • analysis of the whole system (EM) • creation of functional and technical database design to cover all needed changes/improvements • major ETL process (done by Informatica) replaced by solution based on Tuxedo; it required to clean-up the Informatica repository and to create brand new staging area to load data • develop, test and deploy a new solution/code (PL/SQL) to process data from staging area to production Project: Equipment Master rel. 5.0 – 5.4 2010/05 – 2011/05 Several create and deploy projects for EM 5.0 architecture (umbrella project for all EM5.0 to EM5.4 releases) Deliverables: • analysis of business needs/requirements, consideration of theirs implementation • creation of functional and technical database design (to be used and implemented by developers) for each release and sub-release • effort estimation (for design, development and testing) • lead, support and supervision of team of developers and technical development activities • keeping technical and functional design documents and other documents related to overall system architecture up to date • responsibility for Technical Roadmap • communication with Nokia enterprise architecture community and assurance that new requirements follow the Nokia enterprise architecture framework • changes in existing Informatica mappings due to changes in sources/targets or business logic Project: Archie 2 2010/01 – 2010/06 Infrastructure project to create a High Availability HW cluster environment for EM service Deliverables: • test scenarios and testing in cooperation with infrastructure team and integration systems to smoothly transfer to HA cluster environment

09/2005 - 06/2009 Senior Application Specialist
Project: Equipment Master Oracle Upgrade 2007/07 – 2008/03 Infrastructure project to upgrade the Oracle 8i version of EM databases to Oracle 10g Deliverables: • Oracle replication differed in 8i and 10g a lot, therefore carefully planning and testing was needed; test data and test scenarios to test Oracle replication • coordinating activity with integrating systems to assure compatibility with Oracle 10g Project: Equipment Master rel. 2.x – 4.x 2002/08 – 2008/03 Several upgrade, maintenance and integration projects for Nokia Customer Care’s Equipment Master (EM) service. Deliverables: • Oracle replication differed in 8i and 10g a lot, therefore carefully planning and testing was needed; test data and test scenarios to test Oracle replication • Oracle SQL and PL/SQL development • integration with other Nokia systems (solutions providing data to variety of front-end systems) • design, development and maintenance of front-end application based on Oracle Forms (Forms Builder ver. 6.0) and Oracle Reports (Reports Builder ver. 6.0) • utilizing Case Tool (Oracle Designer) to support design and development • development, maintenance and support for Informatica PowerCenter (mappings, worklets, workflows, sessions) • creating test cases, supporting unit and integration testing, deployment of new releases • post-delivery support

09/2001 - 08/2005 Application Specialist
Project: Data loading – target change 2003/06 – 2003/08 Initial solution, when Informatica used regional databases as targets, was reviewed and to achieve better performance and data quality, a new approach was implemented – using global server and tables in so called staging area as the target. Deliverables: • Oracle SQL and PL/SQL development to update functionality processing data from staging area to production • changed setup of Oracle Advanced replication • review and update of Informatica mappings and workflows to use global database as the target Project: Equipment Master 2001/09 – 2002/05 Create and deploy a Product Life-cycle Management system for global Nokia Customer Care to support Warranty Management, Product Security, Product Validation, Product Service and Repair and other Customer Care and Sales and Marketing processes Deliverables: • data analysis – what data for such a new system from business point of view • Oracle SQL and PL/SQL development • design, development and maintenance of front-end application based on Oracle Forms (Forms Builder ver. 6.0) and Oracle Reports (Reports Builder ver. 6.0) • utilizing Case Tool (Oracle Designer) to support design and development • creation of ETL process using Informatica PowerCenter 5.0, its deployment and maintenance; the sources were manufacturing and shipping systems in tens of Nokia factories; the targets were regional databases of the system • maintenance of Oracle jobs running Oracle Advanced Replication between regional servers and a global one • solving data quality issues • coordinating support activities with T3 and T2 support layer teams

09/1997 - 07/2001 Database Developer
• PL/SQL and SQL developer • Oracle Forms developer (Oracle Forms 4.5) • Oracle Reports developer (Oracle Reports 2.5) • using Oracle Designer for development and design • leading small team of developers

 
Branche

  Metall-, Holz- und Papierindustrie
Telekommunikation
 
Kenntnisse

Hardware
Betriebssysteme
Linux (++ (trained), 0-2 yrs.)
Microsoft Systemadministration (++++ (excellent), > 4 yrs.)
Programmiersprachen
PL/SQL (++++ (excellent), > 4 yrs.)
SQL (++++ (excellent), > 4 yrs.)

Datenbanken
Oracle (++++ (excellent), > 4 yrs.)
Oracle Designer (++++ (excellent), > 4 yrs.)
Oracle Developer (++++ (excellent), > 4 yrs.)
Oracle Forms (+++ (good), 2-4 yrs.)
Oracle Reports (+++ (good), 2-4 yrs.)

Datenkomm. / Netzwerk

Design / Entwicklung

SAP / ERP Module

Software / Tools
Informatica Power Center (++++ (excellent), > 4 yrs.)

Standards / Prozesse
ALM (Application Lifecycle Management) (+++ (good), 2-4 yrs.)
Changemanagement (+++ (good), 2-4 yrs.)
ETL - Extract/Transform/Load (++++ (excellent), >4 yrs.)
Incident Management (+++ (good), 2-4 yrs.)
ITIL (++ (trained), 0-2 yrs.)
Requirement Management (++ (trained), 0-2 yrs.)
SCRUM (+++ (good), 2-4 yrs.)
UML (++ (trained), 0-2 yrs.)
 
Ausbildung & Zertifikate

05/2012 - 05/2012 TOGAF 9 Certified
TOGAF 9 Certified - The Open Group, License 56408

06/1998 - 05/2012 Kurse/Trainings
2012/05 TOGAF 9 2008/03 Java Programming Language 2005/09 Oracle Forms Developer 10g: Build Internet Application 2005/06 Oracle Database 10g: Advanced PL/SQL 2005/06 Oracle Database 10g: Develop PL/SQL Program Units 2004/04 Informatica 6 – New Features 2002/08 Oracle 9i DBA Fundamentals I 2002/05 Informatica PowerMart/PowerCenter 5 2001/10 Introduction to Communication Networks 1999/12 Oracle Designer: Server Design and Generation 1999/06 First Certificate in English (University of Cambrige - International Certification) 1998/09 Oracle Developer 2000 rel.2: New Features 1998/07 Oracle Developer 2000: Oracle Reports 2.5 1998/06 Oracle SQL and SQL*Plus, Oracle PL/SQL

09/1991 - 06/1996 Technical University of Kosice, Slovakia
Cybernetics and Control systems Master of Engineering degree with Diploma thesis (Ing./Engineer)

 
Sprachen

deutsch (++)
englisch (++++)
slowakisch (++++)
tschechisch (++++)


Sonstiges

 

We love Freelancing
& project work

die people4project Recruiting-Spezialisten unterstützen IT Fachbereiche und Unternehmensberatungen mit der Auswahl von geeigneten Freelancer / IT Fachkräften

Kontakt

Wir freuen uns auf Sie...

people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Tel: +49 (89) 55 29 39 -40

  Google Map  |  Kontakt

 

über uns

wir sind Recruiting-Spezialisten für die temporäre Unterstützung von IT Entwicklungs- und Betriebsthemen, sowie das Managen von Freelancer-Einsätzen bei unseren Kunden.

...mehr