Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
Belkin Roman Viktorovich
** ***** *** (20 of April 1984) Male
Oslo (ready to relocate)
Ready for business trips
+47 45539160 +7-925-******* preferred contact
******.*@*****.***
Skype: roman.v.belkin
Resume was updated 10 of October 2013
Desired position and salary
Oracle DWH/BI Architect, TL, PM, Department Head
IT, Internet, Telecom
Programming, Development
Telecommunications
Full-time, Full time schedule
Experience 8 years 6 months
July 2013 September 2013 (3 months)
Kamagames (Moscow, www.kamagames.com/) Information technology, system integration, internet
PM, DWH, BI Architect
Project:
DWH and BI
Responsibilities:
• Implementation DWH and BI from scratch
• Creating project plan
• Controlling team
• Develop project architecture
• Selection hardware
Using: Oracle 11g, Oracle BI, MS Project
B
Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
Communication with foreign team
April 2011 June 2013 (2 years 3 months)
Prime Group (Moscow, www.primegroup.ru/) Information technology, system integration, internet
Oracle BI/ODI/DWH Architect, Oracle DBA
Developing analytical portal for control and analyze oil and petrochemical for the ministry of Russia
Responsibilities:
1. Collect heterogeneous data from different sources
2. Develop OLTP, DWH, MART layers и ETL process between them
3. Create BI models, dashboards and answers.
4. Developing with regard to version of the data
Using: Oracle BI 11, Oracle Data Integrator 11, Oracle DB 11
January 2010 October 2010 (10 months)
Luxoft (outsourcing Deutsche Bank) (Moscow, www.luxoft.ru/) Information technology, system
integration, internet
Senior Oracle Developer
Project:
CM project (Client manager). CRM System for supporting banking records. OLTP
Responsibilities:
• Develop CM
• Develop in release-based method
• Support and implement ETL process
• Write roadmap refactoring entire project.
• Support local and production environments
• Implement requirements regarding specification
Using: SQL, PL/SQL, Sqlplus commands, Oracle 11g, Unix shell, self-made ETL, Perforce(SVN),
PowerDesigner.
April 2009 November 2009 (8 months)
Mobimark (Moscow, www.mobimark.ru/) Mass-media, marketing and PR, showbiz
Oracle Developer
Mobimark
Oracle Developer
Project:
Mobile Marketing System. Aimed to process SMS, WAP and WEB request from customers. OLTP
B
Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
Responsibilities:
• Create and support projects
• Create report and GUI in Oracle Apex.
• Support of current system
• Implement new requirements
Using: Oracle Apex, Oracle 10g, SQL, PL/SQL, Tortoise(SVN), PowerDesigner
July 2008 February 2009 (8 months)
Tops BI (Moscow, www.topsbi.ru/) Information technology, system integration, internet
Oracle Architect
Project:
Billing for two big Russian Electricity Companies RusHydro and MosEnergoSbyt.
Responsibilities:
• Design huge DB using PowerDesigner
• Develop reports in Oracle BI (Publisher, Answer)
Using: Oracle 11g, Oracle BI (Publisher, Answer), SQL, PL/SQL, PowerDesigner, InterBase,
Tortoise(SVN)
November 2006 June 2008 (1 year 8 months)
AT Consalting (Moscow, www.at-consulting.ru/) Information technology, system integration, internet
PL/SQL Developer
AT Consulting
PL/SQL Developer
Project:
Data-Quality System for DWH of Russian mobile company Beeline. The focus of project is data
validation.
Responsibilities:
• Invent and implement new system and conceptions of control data
• Develop modular, flexible system structure
• Create and read ETL schemes in Informatica
• Program systems running in parallel with up to 300 variable parameters
• Create data quality system from scratch with ability to detect all potential malfunctions
Remarks:
• Worked with tables containing more than 1 billion rows which were increased up to 150 million
rows per day
• Wrote 30 000 lines on PL/SQL and SQL
Using:
B
Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
Oracle 9-10, SQL, PL/SQL, PowerDesigner
March 2006 November 2006 (9 months)
General Directorate of Social Protection of Population of Irkutsk (Irkutsk, society.irkobl.ru/) State
Organizations
Developer
Responsibilities/Using: Developer on Oracle, Delphi, Access, JSP.
September 2004 November 2006 (2 years 3 months)
Estom (Irkutsk, tcestom.ru/) Retail
Developer, Windows Domain Administrator
Project:
CRM System.
Responsibilities:
• Create CRM system with module of import from 1C
• Collect requirements
• Act as supervisor of the project (responsible for analyzing, implementation and selling)
Using: Oracle 10g, PowerDesiginer, 1С, Delphi.
Skills
SQL- 11 years
Oracle DB (9,10,11), PL/SQL – 8 years
DWH - 5 years
Oracle BI - 2,5 years
ODI 2 - years
Informatica - 6 months
Experience with:
• OLTP and DWH (up to 100 TB)
• Design and implement ETL process (ODI and hand-coded using PL/SQL)
• Design data base model for OLTP and DWH perpose
• Oracle BI (Creating models, dashboars, answers and publisher reports)
• Oracle DBA skills
• Analyze, reengineering, testing, documenting.
• Optimization SQL and PL/SQL
• Using designer's tools (PowerDesiginer, ERWin)
• Scrum
• Release-based development method
Unix(AIX, Solaris, FreeBSD)
B
Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
Experience with creating automatical trade system on Oracle.
Understanding financial market.
Recommendations
Luxoft
Alexander Nevolin (Project Manager)
Mobimark
Rim Zakirulin (Head of Department)
AT Consalting
Alexander Zverev (Team Lead)
PrimeGroup
Alexander Shtikov (PM)
Kamagames
Andrey Kuznetsov (Deputy of finance director)
Education
2006 Irkutsk State Thechnical University
Cybernetic department, Engineer
Languages
Russian native
English fluent
Additional education
2011 Intensive English language courses in Christchurch, England
CELC
2009 Foundations of Stock Exchange (2-week training course)
Finam
B
Oracle DWH/BI Architect, TL, PM, Department Head Belkin Roman
2008 Oracle Database 10g: Optimization perfomance
RDTEX, Specialist
Citizenship, travel time to work
Citizenship: Russia
permit: Russia
address: ******.*@*****.***
time: Any
B