Skills
Experienced senior-level DW/BI/ETL Consultant, Trainer with over 10 years of IT expertise in designing, developing and implementing Datawarehouse, BI and Reporting solutions at a variety of levels.
Technical skills:
Industry competencies:
Trainings that I read:
Technical skills:
- BI: Oracle BI 12c/11g/10g
- Database: Oracle 12c/11g/10g, Microsoft SQL 2008/2005, Pervasive/Btrieve
- ETL: Oracle Data Integrator 12c/11g/10g, Informatica Power Center 9.X
- EPM: Hyperion Planning, Oracle Essbase (BSO, ASO, Partitions, Calc Script, MDX, Reporting Script, User Defined Functions), EPMA, Financial Reporting, Shared Service, Web Analysis, Workspace
- Software & Tools: Oracle APEX 5.0/4.1/4.0, Oracle WebLogic 11g, Enterprise Pack for Eclipse
- Languages: Java/JavaScript, XML/XSD/XSLT/XQuery/XPath, C#/C++/C, Jython, Shell Scripts, SQL, PL/SQL
Industry competencies:
- Banking
- Retail
- Manufacturing
Trainings that I read:
- Oracle BI 11g for BI Developer
- Oracle BI 11g for Front-End Developer
- Oracle BI Publisher 11g Fundamentals
- ETL Fundamentals
- Oracle Data Integrator 11g Data Integration Basics
Project history
09.2015 – 07.2016
Kyivstar
(http://www.kyivstar.net)
Oracle EPM system Implementation Project
Role: Solution Architect, Implementation Specialist
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), Oracle DB 12c
09.2015-12.2015
Unison Bank
(http://www.unisonbank.com.ua/)
Virtual branch
Role: Solution Architect
Technologies: Oracle Database 12c (SQL,PL/SQL), Oracle Weblogic 12c, Apache HTTP Server 2.2, Oracle APEX 5, Node.JS (node-oracledb), AngularJS
04.2014 – 12.2014
Ministry of Emergency Sitations of the Republic of Kazahstan
(http://emer.gov.kz)
Data Warehousing and BI
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 11g, Oracle DB (PL/SQL)
09.2013 – 02.2014
Port of Mariupol
(www.marport.net)
Oracle EPM system Implementation Project
Role: Solution Architect, Implementation Specialist
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), Oracle DB 11g (PL/SQL)
01.2013 –
01.2012
Deutsche Bank /Luxoft
(www.db.com)
Data Warehousing and Dodd-Frank Act regulatory reporting Data Mart
Role: Senior Developer
Solutions and Technologies: Oracle DB 11g, Informatica PowerCenter
10.2011 –
10.2010
Prominvestbank
(http://www.pib.com.ua)
Data Warehousing and Regulatory Reporting Data Mart
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 10g, APEX (AJAX, Javascript), Oracle DB 11g (SQL, PL/SQL)
08. 2011 –
06.2010
Delta Bank
(http://deltabank.com.ua)
Oracle EPM system Implementation Project
Role: Solution Architect, Senior Developer
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), JAVA, Oracle DB 11g (PL/SQL)
10. 2010 –
05.2010
National Agency of Ukraine on Civil Service
(http://nads.gov.ua/control/en/index)
Data Mart "Civil Service in Numbers" Development and Implementation
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 11g, Oracle DB (PL/SQL)
06. 2010 –
11.2010
International Confectionery Corporation ROSHEN
(http://roshen.com/en)
Enterprie Performance Management Solutions Development and Implementation
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle Hyperion Planning, Hyperion Essbase (CalcScript, MDX, etc), Oracle DB 11g (PL/SQL)
10. 2009 –
05.2009
State Tax Administration of Ukraine
Data Warehousing and Reporting Systems
Role: Senior Developer
Solutions and Technologies: Oracle BI 10g, Oracle DB 10g (PL/SQL)
2011,
2010,
2009
UniCredit Bank
(http://en.unicredit.ua)
Role: Senior Developer
Solutions and Technologies: Oracle Hyperion Planning, Hyperion Essbase (CalcScript, MDX, Partition, Reporting Scripts etc)
04. 2009 –
12.2008
Insurance Company INGO Ukraine
(http://ingo.kiev.ua/en)
Business Intelligence Insurance System Development and Implementation
Role: Senior Developer
Solutions and Technologies: Oracle BI EE 10g, Oracle DB (PL/SQL)
12.2008 –
11. 2007
State Treasury of Ukraine
(http://treasury.gov.ua/main/en/index)
"Single Transaction System of Public Financial Management" Development and Implementation
Role: Senior Developer
Solutions and Technologies: Oracle BI EE 10g, OEBS (General Ledger, Payables, Cash Management), Oracle 10g (PL/SQL, OLAP), Oracle Warehouse Builder
2006-2008
Ukraininan Manufacturing and Distribution Company “System Group”
http://systemgroup.com.ua/
Implementation of budgeting and reporting solution
Role: Team Lead
Solution and Technologies: Pervasive SQL, Btrieve, MS SQL 2005, SSAS, SSIS, Microsoft SharePoint
2003-2005
Ukrainian Retail Corporation “Megamarket”
Operation Data Store and Single Data Warehouse Systems development and implementation
Role: Developer
Solution and Technologies: Pervasive SQL, Btrieve, MS SQL 2000, MS OLAP, MS DTS
Kyivstar
(http://www.kyivstar.net)
Oracle EPM system Implementation Project
Role: Solution Architect, Implementation Specialist
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), Oracle DB 12c
09.2015-12.2015
Unison Bank
(http://www.unisonbank.com.ua/)
Virtual branch
Role: Solution Architect
Technologies: Oracle Database 12c (SQL,PL/SQL), Oracle Weblogic 12c, Apache HTTP Server 2.2, Oracle APEX 5, Node.JS (node-oracledb), AngularJS
04.2014 – 12.2014
Ministry of Emergency Sitations of the Republic of Kazahstan
(http://emer.gov.kz)
Data Warehousing and BI
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 11g, Oracle DB (PL/SQL)
09.2013 – 02.2014
Port of Mariupol
(www.marport.net)
Oracle EPM system Implementation Project
Role: Solution Architect, Implementation Specialist
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), Oracle DB 11g (PL/SQL)
01.2013 –
01.2012
Deutsche Bank /Luxoft
(www.db.com)
Data Warehousing and Dodd-Frank Act regulatory reporting Data Mart
Role: Senior Developer
Solutions and Technologies: Oracle DB 11g, Informatica PowerCenter
10.2011 –
10.2010
Prominvestbank
(http://www.pib.com.ua)
Data Warehousing and Regulatory Reporting Data Mart
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 10g, APEX (AJAX, Javascript), Oracle DB 11g (SQL, PL/SQL)
08. 2011 –
06.2010
Delta Bank
(http://deltabank.com.ua)
Oracle EPM system Implementation Project
Role: Solution Architect, Senior Developer
Solutions and Technologies: Hyperion Planning (CalcScript, MDX, etc), JAVA, Oracle DB 11g (PL/SQL)
10. 2010 –
05.2010
National Agency of Ukraine on Civil Service
(http://nads.gov.ua/control/en/index)
Data Mart "Civil Service in Numbers" Development and Implementation
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle BI EE 11g, Oracle DB (PL/SQL)
06. 2010 –
11.2010
International Confectionery Corporation ROSHEN
(http://roshen.com/en)
Enterprie Performance Management Solutions Development and Implementation
Role: Solution Architect, Senior Developer
Solutions and Technologies: Oracle Hyperion Planning, Hyperion Essbase (CalcScript, MDX, etc), Oracle DB 11g (PL/SQL)
10. 2009 –
05.2009
State Tax Administration of Ukraine
Data Warehousing and Reporting Systems
Role: Senior Developer
Solutions and Technologies: Oracle BI 10g, Oracle DB 10g (PL/SQL)
2011,
2010,
2009
UniCredit Bank
(http://en.unicredit.ua)
- Development of the unified data transferring processes between local systems of UniCredit Bank Ukraine and global systems of UniCredit Group
- Oracle Hyperion Planning Support and Implementation
Role: Senior Developer
Solutions and Technologies: Oracle Hyperion Planning, Hyperion Essbase (CalcScript, MDX, Partition, Reporting Scripts etc)
04. 2009 –
12.2008
Insurance Company INGO Ukraine
(http://ingo.kiev.ua/en)
Business Intelligence Insurance System Development and Implementation
Role: Senior Developer
Solutions and Technologies: Oracle BI EE 10g, Oracle DB (PL/SQL)
12.2008 –
11. 2007
State Treasury of Ukraine
(http://treasury.gov.ua/main/en/index)
"Single Transaction System of Public Financial Management" Development and Implementation
Role: Senior Developer
Solutions and Technologies: Oracle BI EE 10g, OEBS (General Ledger, Payables, Cash Management), Oracle 10g (PL/SQL, OLAP), Oracle Warehouse Builder
2006-2008
Ukraininan Manufacturing and Distribution Company “System Group”
http://systemgroup.com.ua/
Implementation of budgeting and reporting solution
Role: Team Lead
Solution and Technologies: Pervasive SQL, Btrieve, MS SQL 2005, SSAS, SSIS, Microsoft SharePoint
2003-2005
Ukrainian Retail Corporation “Megamarket”
Operation Data Store and Single Data Warehouse Systems development and implementation
Role: Developer
Solution and Technologies: Pervasive SQL, Btrieve, MS SQL 2000, MS OLAP, MS DTS
Local Availability
Only available in these countries:
Ukraine