$0/hour

Database Developer

Experience

  • - Applications development, Oracle Developer/2000 (Forms&Reports): 5 years
  • - Project documentation writing, 5 years
  • - Support, consulting, training of employees, 5 years
  • - Projects coordination, 2 years
  • - Lecturer, 6 years
  • - PL/SQL, SQL, 8 years

Resume

Key areas of experience
- ETL development (Informatica PowerCenter 9.0.1, 8.6.1)
- Oracle 8i, 9i, 10g
- Database modeling ErWin, functional modeling Bpwin
- Physical database design
- PL/SQL, SQL; (> 8 years)
- Query optimization
- MSSQL, MySQL, FoxPro, Paraccel (PADB 3.1.1)
- Unix schell/ batch scripting
- 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 Technologies: 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 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 Technologies: 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. Technologies: MS SQL Server; HTML, MySQL, C# Lecturer at Transnistrian State University september 2002
- july 2011 (8 years 5 months) 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 Technologies: 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

Let's talk: