freiberufler IT Consulting auf freelance.de

IT Consulting

offline
  • auf Anfrage
  • 44229 Dortmund
  • Nähe des Wohnortes
  • sk  |  cs  |  en
  • 29.10.2018

Kurzvorstellung

Database architecture - physical and logical database design (Oracle)
- Database Development (Oracle SQL, PL/SQL, Forms, Reports)
- ETL (Informatica PowerCenter)
- Business requirements analysis, impact analysis, solution feasibility and solution

Qualifikationen

Projekt‐ & Berufserfahrung

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
9/2013 – 12/2013 (4 Monate)
Telekommunikation
Tätigkeitszeitraum

9/2013 – 12/2013

Tätigkeitsbeschreibung

Project: 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

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
3/2013 – 6/2013 (4 Monate)
Telekommunikation
Tätigkeitszeitraum

3/2013 – 6/2013

Tätigkeitsbeschreibung

Project: 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

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
10/2012 – 1/2013 (4 Monate)
Telekommunikation
Tätigkeitszeitraum

10/2012 – 1/2013

Tätigkeitsbeschreibung

Project: 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

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
10/2012 – 10/2012 (1 Monat)
Telekommunikation
Tätigkeitszeitraum

10/2012 – 10/2012

Tätigkeitsbeschreibung

Project: 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)

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
9/2012 – 11/2012 (3 Monate)
Telekommunikation
Tätigkeitszeitraum

9/2012 – 11/2012

Tätigkeitsbeschreibung

Project: 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

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office + Salo, Espoo (Finland) - business tri
8/2012 – 10/2012 (3 Monate)
Telekommunikation
Tätigkeitszeitraum

8/2012 – 10/2012

Tätigkeitsbeschreibung

Project: Low-level environment

As mentioned by "Obsolete objects", some things should not be the case normally in such big and complex system. One other such thing 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

Solution and Database Architect, Business Analyst and Developer
Nokia Oyj Finland, Home Office; Salo, Espoo (Finland) - business trip
7/2012 – 12/2013 (1 Jahr, 6 Monate)
Telekommunikation
Tätigkeitszeitraum

7/2012 – 12/2013

Tätigkeitsbeschreibung

My main responsibility was
- 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

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
- Magic Draw
- Accept 360

Note: "the system" mentioned in another projects related to Nokia means the "Global Product Lifecycle Management system"

Lead Developer+Database Architect
Nokia GmbH Deutschland, Ratingen
7/2009 – 7/2012 (3 Jahre, 1 Monat)
Telekommunikation
Tätigkeitszeitraum

7/2009 – 7/2012

Tätigkeitsbeschreibung

Note: here is the list of projects I worked on as an employee of Nokia

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 [12.2011 - 07.2012]
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 [05.2011 - 02.2012]
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 [11.2009 - 11.2010]
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 [05.2010 - 05.2011]
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 [01.2010 - 06.2010]
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

Senior Application Specialist
Nokia GmbH Deutschland, Düsseldorf
9/2005 – 6/2009 (3 Jahre, 10 Monate)
Telekommunikation
Tätigkeitszeitraum

9/2005 – 6/2009

Tätigkeitsbeschreibung

Note: here is the list of projects I worked on as an employee of Nokia

Project: Equipment Master Oracle Upgrade [07.2007 - 03.2008]
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 [08.2002 - 03.2008]
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

Application Specialist
Nokia GmbH Deutschland, Düsseldorf
9/2001 – 8/2005 (4 Jahre)
Telekommunikation
Tätigkeitszeitraum

9/2001 – 8/2005

Tätigkeitsbeschreibung

Note: here is the list of projects I worked on as an employee of Nokia

Project: Data loading - target change [06.2003 - 08.2003]
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 [09.2001 - 05.2002]
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

Zertifikate

Togaf 9 Certified
2012

Ausbildung

Technical University of Kosice; Cybernetics and Control systems; 5 years
Master of Engineering degree with Diploma thesis
1996
Kosice, Slovakia

Über mich

Keeping promises and being open in communication – those are the values I am following not only in my personal, but also in professional life. My best teachers have been my team-mates in both companies I’ve worked – and having this in mind, I keep sharing my knowledge as well.
Spending free time with my two daughters, basketball, jogging through a forest, good music and literature energize me and make me enjoying my life.

Weitere Kenntnisse

Skills or Knowledge/Level/Time (Year/Month):
(Levels: 1 = Junior, 2 = Intermediate, 3 = Senior, 4 = Expert, 5= Guru)

Modeling Methods and Tools
Logical and physical database modeling/design/4/8 Years
Data modeling/3/5 Years
SQL Developer Data Modeler/2/1 Year
UML/1/1 Year
Magic Draw/1/2 Years

Databases & Database management
Oracle SQL/5/17 Years
Oracle PL/SQL/5/17 Years
Oracle Forms/Reports/3/10 Years
Oracle DBA/1/13 Years
Oracle Designer/3/7 Years
SQL Developer/4/5 Years
SQL Navigator (Quest)/4/13 Years
TOAD (Quest)/4/17 Years


Data Integration, Data warehouse and Business Intelligent
Informatica PowerCenter/4/12 Years
(Designer - Workflow Manager - Workflow Monitor)

Operating systems
Windows/5/20 years
Linux/1/5 years

Other special fields of knowledge
Agile Development/2/3 Years
Scrum/3/3 Years
Accept 360/2/3 Years
Requirement analyze/4/6 Years

Persönliche Daten

Sprache
  • Slowakisch (Muttersprache)
  • Tschechisch (Muttersprache)
  • Englisch (Fließend)
  • Deutsch (Gut)
  • Russisch (Grundkenntnisse)
Reisebereitschaft
Nähe des Wohnortes
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
3022
Alter
51
Berufserfahrung
26 Jahre und 5 Monate (seit 10/1997)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden