Peter Bubeliny+420 602 367

Objective / Database Specialist/Consultant with more than15years of experiencewith data warehouse and OLTP systems, with Teradata and Oracleskills and many years of international experience is offering his expertise.
Summary of technical skills /
  • Database and Data Architecture, Modeling, Design, Development, and Administration; ETL Development, Database Performance Tuning
  • Business and Data Analysis
  • Data Warehouse and OLTP systems, Business Intelligence
  • RDBMS: Oracle, Teradata; including tools and utilities
  • Programming languages: SQL, PL/SQL, TD SPL, UNIX shell script, C
  • Tools: CA ERwin, SAP Sybase PowerDesigner, IBM Rational System Architect, Sparx Systems Enterprise Architect, TortoiseSVN, OBIEE, JIRA

Industry experience /
  • Telecommunications
  • Financial: Banking, Insurance
  • Retail
  • Healthcare
  • Transportation
  • Pharmaceutical

Other skills and attributes /
  • Strong analytical skills
  • Consulting experience, customer orientation
  • Excellent communication skills, both oral and written
  • Excellent documentation skills and technical writing abilities
  • Attention to detail
  • Wide problem-solving and troubleshooting capabilities
  • Team player, always willing to help/support team efforts
  • Able and willing to work independently with minimal supervision
  • Ready to take initiative/leadership,should situation require it

Experience

February 2016 – presentIndependent Contractor with Acamar Corporation

Prague, Czech Republic

Database Specialist

Customer:Tesco Stores, Prague, Czech Republic

Projects:WAM (Tesco’s analytical database)

WSSI (Weekly Sales, Stock, and Inventory)

TGAP (Tesco Group Accounting Policy)

  • Data, database and business analyses, data modeling, database development, test, and deployment work on the mentioned projects. Technologies used: Oracle, SAP Sybase PowerDesigner.
  • Mentoring a junior database analyst/developer.

September 2015 – January 2016Independent Contractor with Profinit Corporation

Prague, Czech Republic

Data Warehouse Specialist

Customer:Komerční banka(KB), Prague, Czech Republic

Komerční pojišťovna (KP), Prague, Czech Republic

Projects:KB DQIM (Data Quality Improvement Management)

KP Solvency II, KP Solvency II EIOPA

  • Various tasks, mostly data analysis and database development work on the mentioned projects with the common database of the two companies.
  • Prepared and presented to co-workers a 2-day training on fundamentals of Teradata technology.

April 2015 – August 2015Independent Contractor with Acamar Corporation

Bratislava, Slovakia

Data Warehouse Developer

Customer: Československá obchodní banka (ČSOB), Bratislava, Slovakia

  • Extension of existing Oracle data warehouse, addition of new fields and functionality based on bank’s requirements and input from analyst. Utilization of SAP Sybase PowerDesigner, Oracle PL/SQL, TortoiseSVN and JIRA in the process.
  • Migrated to Oracle set of Teradata scripts used in reporting.

June 2014 – April 2015Independent Contractor

Brno, Czech Republic

Data Warehouse Designer

Customer: Home Credit International (<embed/it>), Brno, Czech Republic

Projects: Homer Select 2.4, Group Data Warehouse

  • Participated in card business module analysis to extend the data warehouse by revolving credit functionality, designed the corresponding parts of the data warehouse.
  • Participated in the Group Data Warehouse reporting solution troubleshooting efforts, utilized Oracle Business Intelligence (OBIEE) tool in the process.
  • Interfaced HCI risk management specialists, analysts and architects as well as database developers.

March 2014 – May 2014Independent Contractor with IBM Corporation

Maastricht, Netherlands

Teradata Data Modeler

Customer: Vodafone, Maastricht, Netherlands

Projects: Unify, phase 2.2

  • As a Teradata data modeler, worked on Teradata CLDM-based logical data modeling of the data warehouse. The goal was to accommodate new data structures coming from the source system extension.
  • Studied various Amdocs source modules (CRM, OMS, EPC, TC, AR/IC, etc.) and based on their extensions, proposed changes to data model and mappings. Discussed the changes with the client and documented them.
  • Interfaced Vodafone system analysts and architects as well as other IBM data modelers, mappers and ETL developers.

September 2013 – December 2013Independent Contractor with Indra Corporation

Prague, Czech Republic

Database Specialist

Customer: Telefónica O2, Prague, Czech Republic

Projects: Analytical CRM (aCRM) and Group Data Warehouse (GDW)

  • As a Teradata database specialist, worked on various tasks connected to unification of the two data warehouse systems. Used Teradata 13.10 and its temporal feature as well as Oracle RDBMS.
  • Interfaced other database developers and analysts.

July 2013 – September 2013Independent Contractor

Prague, Czech Republic

Data Architect

Customer: DHL, Prague, Czech Republic

Project: Shared Data Hub for Human Resources

  • Participated in high-level design of the first version of the system, whose ultimate goal is to be the single repository for all DHL HR data worldwide, holding information loaded from disparate sources.
  • Created and documented data model for the first release of the system utilizing IBM Rational System Architect.
  • From the data model, built Oracle database schema objects; set up a process of (mostly) automatic propagation of data model updates to the database structures.
  • Worked in close cooperation with business architect as well as application developer.

April 2012 – June 2013Independent Contractor with Cleverlance Enterprise Solutions

Prague, Czech Republic

Senior Developer

Customer: Pension Company of Czech Savings Bank, Prague, Czech Republic

Project: Cleverlance Pension System

  • Wrote SQL and PL/SQL for the system’s Funds, Demands and Bankruptcy modules based on inputs provided by company’s analysts in UML-based model.
  • Created/participated on creation of data model for the mentioned modules.
  • Performance-tuned written SQL and PL/SQL code.
  • Helped fixing data migration errors from the legacy systems.
  • Interfaced front-end Java developers as well as other database developers, analysts and testers.

April 2011 – May 2012Independent Contractor with Adastra Corporation

Prague, Czech Republic

Data Warehouse Specialist/Consultant

Customer: Vodafone, Prague, Czech Republic

Projects: DaVoFone Data Mart (Data services data mart), Churn Data Mart, Fraud Prevention Data Mart

  • Architected mentioned data marts on top of Vodafone’s existing data warehouse running on Oracle database.
  • Analyzed business user requirements and relevant data warehouse data.
  • Designed and implemented data model.
  • Wrote and performance-tuned ETL code to load data mart.
  • Wrote SQL code to create layer to facilitate data retrieval for Business Objects tool.

January 2010 – February 2011Adastra CorporationMarkham, ON, Canada

Consultant

Project: Retail Data Model for Loblaw, Brampton, ON(January 2010 – December 2010)

  • Held ETL Developer role on this assignment.
  • Participated in data warehouse load redesign, designed key parts of ETL – templates for the other developers to follow.
  • Participated in architectural decisions regarding the newly built system.
  • Wrote SQL for Oracle and Teradata, scripts for Teradata loading utilities and Linux/UNIX shell scripts.

January 2006 – August 2009Teradata CorporationPrague, Czech Republic

Professional Services Consultant

As member of the Professional Services team, participated in several projects and pre-sale activities for customers from telecommunication, transportation, and retail industries.

Project: Enterprise Data Warehouse for Telefónica O2, Prague, Czech Republic

(July 2009 - August 2009)

  • Held Teradata Database Specialist role on this assignment.
  • Optimized performance of daily load SQL according to project lead’s requests.

Pre-sale activity: Database support for DHL, Houston, TX(June 2009)

  • Worked as a Teradata Database Specialist on this short assignment, supported Cognos reporting development efforts.

Project: Enterprise Data Warehouse for Lidl, Neckarsulm, Germany

(September 2008 – March 2009)

  • Held Teradata Database Specialist role on this project.
  • Developed/modified, tested and performance-tuned data manipulation procedures for the warehouse: store-day combination data deletion procedure (for unload of erroneous data), aggregation calculation procedures and others.
  • Tested, modified and performance-tuned ETL jobs for load of XML-formatted data into the warehouse, ensured consistency of new database structures with already existing ones. Interfaced POS software developers regarding XML structures and data.

Pre-sale activity: Intelligence Platform for Nokia Siemens Network, Augsburg, Germany

(August 2008 - September 2008)

  • Held Teradata Database Specialist role on this project.
  • Wrote in Korn shell, tested and debugged almost all use case control scripts including scheduler to parameterize their execution. There were the following use case types: select-statement, mini-batch load and real-time load. Finished the scripts in half of expected time.
  • Participated in overall system architecture as well as design of implementation details.

Project: Revenue Assurance Tool for DHL, Prague, Czech Republic(April 2008 – July 2008)

  • Held Teradata Database Specialist role on this project.
  • Overhauled database and user rights for application.
  • Wrote System Requirement Statement for additional application functionality.
  • Adjusted data model and database objects for new application functionality.

Project: DHL Data Warehouse Commercial for DHL, Prague, Czech Republic

(January 2008 – March 2008)

  • Held Teradata Database Specialist role on this project.
  • Participated in database consolidation carried out along with migration between Teradata servers.
  • Modified data materialization procedures based on business analyst’s inputs.
  • Wrote several shell scripts necessary for warehouse operation/miscellaneous tasks.

Project: Enterprise Data Warehouse for KyivStar, Kyiv, Ukraine(August 2006 – July 2008)

  • Held two roles on this project: Telco Data Model Specialist and Teradata DBA.
  • Participated in the following analyses:
  • KyivStar’s source systems analysis
  • Current data warehouse analysis
  • Business analysis with end users
  • Also, participated in Teradata’s Telecommunication Logical Data Model customization to KyivStar’s requirements, physical data model design and its database implementation. Worked on finance and campaign-related subject areas and tested the corresponding ETL.
  • Carried out on daily basis most of DBA activities: designed and created database hierarchy, initially sized the databases and managed their sizes afterwards, created and modified according to developers’ needs all database objects, set up users, roles, profiles and general security rules based on customer’s internal standards, designed and maintained table compression and statistics collection, carried out various maintenance tasks (packdisk, showfsp, scandisk, checktable, etc.), backed up and restored databases according to project’s needs, monitored operations of Teradata systems, etc.
  • Participated in ETL development: implemented, in Teradata user-defined function written in C, finite state machine algorithm to determine phone number call area. Also implemented in C phone number normalization functions.
  • Interfaced business users at interviews during business analysis phase, KyivStar’s IT staff, Ukrainian contractors developing ETL, Teradata technical support staff and others.
  • Wrote several manuals: “C User-defined Functions Documentation”, “DBA Documentation”, co-authored “ETL Operation Documentation”, “ODI Development Documentation”, “ODI Knowledge Module Documentation”, “ODI Administration Documentation” and “Technical Architecture Documentation”.
  • After initial customer’s discontent with automatically generated “ODI Development Documentation”, designed documentation sample to their satisfaction and subsequently documented finance-related facets.
  • Administered Oracle occasionally – e.g. saved Sunopsis repository by fixing its corrupted database.

Pre-sale activity: Business case for DHL, Prague, Czech Republic(July 2006)

  • Prepared supporting materials for business case with the customer; analyzed their warehouse data and calculated approximate potential savings.
  • From the financial point of view, the resulting project turned out to be the most successful one for Teradata with this client.

Project: Enterprise Data Warehouse for Eurotel , Prague, Czech Republic

(January 2006 – June 2006)

  • Held Analyst role on this project.
  • Worked on bug-fixing in production data warehouse; analyzed data and ETL process, diagnosed the bugs and proposed changes to ETL and/or data. Implemented the changes – wrote the necessary SQL.
  • Took part in team effort to test the 3R customer segmentation.

August 2005 – November 2005McKinsey & Company, Inc.Prague, Czech Republic

Oracle Database Administrator

December 2003 – July 2005Group Health, Inc.New York, NY

Data Architect

July 2003 – October 2003Czech Savings Bank, Inc.Prague, Czech Republic

Oracle Database Specialist/DBA

August 2002 – January 2003Merck & Co., Inc.Rahway, NJ

Oracle Database Engineer/DBA

July 1999 – July 2001News Digital Media, Inc.New York, NY

Database Administrator/Engineer/Data Modeler, Lead DBA

April 1995 – March 1999Login, Inc.Stupava, Slovakia

Oracle Database Administrator/Developer, Business Analyst/Data Modeler

July 1992 – March 1995Slovak Insurance Co., Inc.Bratislava, Slovakia

Business Analyst & Designer/Data Modeler, Programmer/Analyst

Education

1987 - 1992Comenius University, Faculty of Mathematics and Physics

Bratislava, Slovakia

Master's degree in mathematical analysis.

1 of 7