Informatica/Oracle Developer

Key areas of experience
- ETL development (Informatica PowerCenter 9.0.1, 8.6.1) (3 years)
- Oracle 8i, 9i, 10g
- Database modeling ErWin, functional modeling Bpwin
- Physical database design
- PL/SQL, SQL; (10 years)
- Query optimization
- MSSQL, MySQL, FoxPro, Paraccel (PADB 3.1.1) (2 years)
- Unix schell/ batch scripting/support
- COBOL code support
- Applications development: Oracle Developer/2000 (Forms&Reports) (>5 years)
- Project documentation writing (English – Russian) (>5 years)
- Support, consulting, training of employees (>5 years)
- Projects coordination (2 years)
- Lecturer (Russian, >6 years).

Specialization
RDBMS: Oracle, MS SQL, MySQL, ParAccel
ETL development in Informatica PowerCenter; Lecturer

Languages
Russian (fluent), Ukrainian (fluent), English (technical documentation reading/writing, spoken English skills), German (A1 level)

Education
University degree – Transnistrian State University; “Physics, Mathematics and Informatics” department; Computer science engineer, diploma with honor

Experience
Informatica Developer for Microstrategy project on behalf of Augaroo/Ciklum
december 2011 - july 2013 (1 year 8 months)
Job responsibilities and skills:

• Informatica 9.0.1 workflows, mappings, worklets developing
• Creation of ETL control schema (automation of registering of workflows, consumers in own meta-data layer,
• Monitoring and logging of ETL processes, scheduling of workflows, errors notification)
• DWH logical and physical modeling
• Db scripts creation
• Batch scripting
• Work with Informatica MX views
• Work with Web Services Hub
• Work with different targets and sources: flat files, MySql and Paraccel dbs, Hadoop
• Versioning of workflows

Informatica Power Center 9.0, MySql 5.5.9, Paraccel PADB 3.1.1, Tortoise SVN, batch scripting, JIRA


SQL Support at PHLY insurance company
December 2012 – january 2012 (2 months)
Job responsibilities and skills:
• SQL BI Support
• queries optimization
• reports for BA creation
• fixing of breaks in data and reports

MS SQL

ETL/Oracle Developer at UBS/Luxoft
february 2011 - november 2011 (10 months)
Job responsibilities and skills:
• Software development for UBS Investment bank
• Database modeling, query optimization
• Informatica workflows developing
• Stored procedures, triggers, reports creation

Oracle 10g, PL/SQL Developer, SQL, PL/SQL, Informatica PowerCenter

Project coordinator, technical writer, tester; at Natural Codes
july 2009 - september 2011. (2 years 3 months)
Job responsibilities and skills:

• technical documentation writing (Russian/English)
• Database development: database modeling and creation; stored procedures writing; query optimization.
• Project team coordination: client-developer coordination, testing, project documentation writing.

MS SQL Server; HTML, MySQL, C#

Lecturer at Transnistrian State University
september 2002 - july 2011 (8 years 5 months)
Job responsibilities and skills:

Disciplines:
- Databases – introduction;
- Information systems;
- Innovation Management;
- Oracle SQL \\ PL SQL;
- Metrology, Standardization and Certification (General course).

Oracle developer at JSCC Moldova Steel Works
july 2004 - july 2009 (5 years 1 month)
Job responsibilities and skills:
- Database objects modeling, physical database design;
- forms development (Oracle Forms);
- query optimization;
- reports creation using Oracle Reports;
- preparation of technical specifications for software development, user guides creation;
- Support, consultations, trainings of company employees;
- Analysis and modeling of business processes in payroll, HR;
- Oracle Applications 11 I (11.5) Oracle 8 I (8.1.7.) support, users/forms/reports adding

Oracle Forms 6i, Oracle Reports 6i, ErWin, Bpwin, HTML;
Oracle SQL, PL/SQL, FoxPro;

Professional courses:
INFORMATICA PowerCenter 8.6 Developer Level 1
Perfomance tuning Oracle
INFORMATICA PowerCenter 8.6 Developer Level 2