DWH/ETL Architect / Consultant

Experienced and certified Oracle Data Integrator, OBIEE, Esbasse Architect and Developer (working on 6 full life cycle DWH/BI projects based on ODI & OBIEE) passionate about the Oracle Technological Stack, member of Oracle Partner Network.

• Business Analyse

o Experienced and proficient Oracle Data Integrator Architect and Developer (working on 6 full life cycle DWH/BI projects based on ODI) passionate about the Oracle Technological Stack (including ODI, WebLogic Server, Oracle DB, Oracle SQL Developer, Oracle Modeler, Java, OBIEE etc.) and business intelligence and data warehousing solutions and professional in delivering end-to-end ODI – based solutions covering entire development life cycle (development, QA, acceptance testing and roll-outs to production).

o Collected experience in installations, set-up, configurations of Oracle Data Integrator on Linux server machines (Linux Red Hat as well as Oracle Enterprise Linux based on the Red Hat Linux) as well as Windows Server 2008 server, installation of ODI Studio, ODI console, ODI agents (standalone and JEE on WebLogic Application Server) managing and communicating with data center regarding DWH/BI team server machines farm.

o Performed QA of Oracle Data Integrator projects by integration of Oracle Data Quality and Profiler with Oracle Data Integrator

o Responsible for roll-outs of ODI solutions to productive environments and projects promotion between the following development life cycle stages: DEV/QA/UAT/PRD and complex monitoring of executions and fault management to ensure reliable solutions.

o In delivered solutions often applied programming skills in Java, Jython, Shell Scripting and PL/SQL as a part of procedures inside of ODI packages for internal external systems APIs and Web Services.

o Fast-lerner, results-oriented with very strong problem-solving, analytical and communication skills worked in peace with full attention and focus in rapidly changing environments delivering cutting-edge solutions under the time pressure and changing conditions.

o Communicating with external and internal stakeholders in multi-cultural environments to ensure the reliable specifications and correspondence between requirements and delivered solutions including the user acceptance testing (Certified Business Analyst Professional).

o Very strong enterprise architectures design skills combined with data integration and data quality and profiling knowledge.

- Oracle Data Integrator 11g Implementations
- OBIEE 11g RPD Development: Physical Layer, Business Layer, Subject Areas including relational and multidimensional sources
- OBIEE 11g Analytics, Dashboards, Bi Publisher, RTD (Real-Time-Decisions) Design & Development
- Oracle Essbase OLAP Cubes Design & Development (including integration with OBIEE)
- Oracle PL/SQL Development
- Full SDLC including all development stages DEV/QA/UAT/PRD of DWH/BI Projects
- Data Integration
- Java and Web Services (SOAP, REST) implementations and integration with ETL
- Architectures design including multi-dimensional modelling, star schemas, snowflake schemas, Facts and Dimensions design, data historization etc.
- Requirements Analysis, Specifications Writing, Communication with Stakeholders, Projects Mgmt.