Sandor Joos Email & Phone Number

England, United Kingdom

Budapest, Hungary

Oracle APEX and JavaScript WEB development

Budapest, Hungary

Working in Agile environment implementing Databricks modules using PySpark based on Greenplum specification.Design and develop Databricks modules using PySpark and Postgres SQLCreation of data structure for migration.Development of control programs for the workflows.

Budapest, Hungary

Analysis and transformation of an existing Sybase database system into an Oracle environment, including data migration.Functional specification and implementation of new functions according to current business needs.Redesign and implementation of DDL scripts and background procedures.Designed and developed stored procedures and triggers.Accomplished system.

Vienna, Austria

Verbund's DWH system covers the complete, centralized handling of various data, such as CRM, business data, daily consumer and consumption data and technical data collected from different branches. This DWH serve as basis for Data Marts, marketing campaign and reports to business decisions. My role is to maintain Oracle Warehouse Builder (OWB), ensure data.

Budapest

IT Services Hungary is the Hungarian subsidiary of T-Systems International, providing Information and Communication Technology (ICT) services for Deutsche Telekom’s corporate customers.Implement new features and maintain former versions for a Deutsche Telekom mobile network application

Wien, Austria

• Erste Group Bank AG is a leading corporate and investment bank in Austria, one of the largest financial services provider in Central and Eastern Europe, over 16 million customersInvolved in DataWareHouse testing team.
• Design test plans and prepare required SQL scripts for the test cases
• Analyse, generate and validate test data based on DWH database structure
• Complete test execution and present test reports into Confluence, JIRA and ExcelTechnologies: Oracle RDBMS, Oracle SQL Developer, SQL scripting

Wien, Austria

• Test Engineer. Involved in DataWareHouse testing team. I was responsible for testing DWH Interfaces, controlling the data flow between different DWH layers, providing data consistency.
• Design test plans and prepare required performance framework and test cases
• Analyse, generate and validate test data based on DWH database structure
• Complete test execution via ODI and analyse test result with HP Quality Center
• Present test reports into Confluence, JIRA and ExcelTechnologies: Oracle Data Integrator / ODI 11g, Oracle RDBMS, Performance Center, Loadrunner

Nottingham, United Kingdom

• Boots UK introduced a new Cisco Integration Gateway providing the ability to connect Alliance Boots to external organisations using untrusted networks. Conducting performance testing and baseline the performance.
• Design test plans and prepare required performance framework
• Conduct workshops and liase with the 3rd party supplier about required tests and benchmarks
• Carry out test execution and analyse test result
• Plan and accomplish Resilience/Failover/Alerts&Monitoring and Operational Acceptance tests

London, United Kingdom

Carrier management and financial study at BITE Consulting.

London, United Kingdom

• Headhunted by a previous client to join this start-up company. Initially to provide a performance test rig from scratch to ensure that the Company could achieve their stringent SLAs. Subsequently to act as the.
• Install and set up large Loadrunner environment from scratch situation on Linux CentOS and Windows platforms up to 10000 Vusers
• Determine KPIs and metrics for Loadrunner test rig
• Designed and developed test scenarios for test environment measuring benchmarks of response time, downloaded data volume, transaction rates, percentile distribution of WARP calls
• Analysis of multimillion customers contained production system and test requirements via Linux, Apache logs, Splunk and JMX console
• Simulate production behaviour into test system via Linux and Loadrunner scripting

Darmstadt Area, Germany, Budapest, Hungary

Managing the Teradata / Ab Initio ETL ( Entity Transformer Loader ) development team. Maintenance of decision support DWH database for internal use by the headquarters containing customers and communications data.

Vienna, Austria

• Involved in an evolution of an existing Common Virtual Private Network system development to also cover fixed network connections.
• Provided the client with additional functionality to an existing CVPN application
• Redesigned DDL scripts, redesign and implementation of background procedures
• Functional specification and implementation of new functions
• Designed and developed stored procedures and triggers
• Performance tuning of existing stored procedures, database structures, indexes and SQL queries

Budapest, Hungary

• The project was a migration of full-scale mainframe car insurance system to UNIX / Oracle environment.
• Analysed the data structure and data dependencies of an existing mainframe car insurance system
• Created and build deployment scripts for the application using AWK and UNIX shells
• Implemented data handling support via stored procedures
• Designed and developed the data validation scripts using C++ and Oracle RDBMS 9i
• Accomplished system migration to the new UNIX / Oracle platform

Frankfurt Am Main Area, Germany

Maintenance of different UNIX-Oracle based SAP and Non SAP systems using Oracle 8i, Oracle 9i, AIX, Sun Solaris

Budapest, Hungary

• The project was an adaptation of ticketing and reservation system from Sun Solaris Oracle environment into TANDEM SQL
• Understand client’s needs, refine them for best performance regarding of Financial Module
• Created the complete function specification for Finance Module
• Ported existing Oracle SQL code from Sun Solaris into TANDEM SQL
• Implement Ticketing and Reservation System

Budapest, Hungary

Building Data Model, Design and Implement stored procedures and control logic. Development of a new analytical database for the Vodafone Hungary to collect similar data from different transactional database systems and join the records by identical user account numbers using Oracle 9i, PL/SQL, Oracle Warehouse Builder, AIX, Sun Solaris

Stuttgart Area, Germany

Designed detailed specifications based on the requirements documents and developed SQR programs using PL/SQL, Oracle 8i, PeopleSoft V8, SQR, SQR Runner 4Pro

Bonn Area, Germany

Development of a new billing system application in UNIX Oracle V8 environment. Designing data model, planning data structures, implementing new functionality and migrating a 10 million+ customers’ legacy data to the new system.using UNIX AIX 4.2, Oracle V8, TOAD, PL/SQL, SQL Loader, UNIX Shells, PERL

Frankfurt Am Main Area, Germany

Involved in different development projects at Deutsche Bank in headquarter in Frankfurt. Technical Repository database for network of Deutsche Bank including central configuration and software distribution of mainframes, networks, servers, PCs, ATMs, printers. Designed and developed Oracle PL/SQL scripts, dependency graphs, database maintenance programs in.