Резюм на растерзание

[Sintetik]

xxxxxxx xxxxxxxxxxxxxxxx
e-mail: xxxxxxx@xxxx.xxx
Status in Canada Permanent Residence

OBJECTIVE
Seeking a challenging career as Database/DataWarehouse Developer on Oracle platform

SUMMARY
10 years experience in IT field, including 5 years in banking and financial environment.
Over 6 years of progressive experience as a Database Developer and DBA with Oracle and
MS SQL Server in Windows and UNIX environment. Last 3 years focused on DataWarehouse and
Business Intelligence technology.
Excellent knowledge of Relational Data Model, Enterprise Data Warehouse, Oracle, MS SQL Server,
PL/SQL, Transact-SQL.
Strong Data Warehouse and Business Intelligence Skills, solid development background besides DBA skills.
Expert in Extract, Transform and Load processes and ETL Tools such as Oracle Warehouse Builder.
Clear understanding of Enterpriese Data Warehouse implementation methodology. Good knowledge of
physical and logical database design, installation, performance tuning (include VLDB), capacity planning,
security, backup and recovery, data migration and maintenance of database systems.

TECHNICAL SKILLS

RDBMS
Oracle 7/8/8i/9i/10g, options Real Application Cluster, Partitioning, OLAP, Transparent Gateway
Microsoft SQL Server 6.5/7.0/2000,
Centura SQLBase 6.x/7.5
Design and Development tools
SQL, PL/SQL, T-SQL, Power Designer, Oracle Warehouse Builder, Oracle Workflow Server, Informatica 7.5.1,
AWM, HTML DB, Oracle BPEL, Delphi, VB6.0
BI and Reporting
Crystal Report 8/9, Oracle Discoverer, Business Objects XI Enterprise
Operation Systems
Windows NT/2000/2003/XP, Solaris, Linux SLES/RedHat AS

EMPLOYMENT HISTORY
07.2006 – now xxxxxxxx IT Consulting company
DataWarehouse Developer
Projects
Large Retailer - Enterprise Data Warehouse
Developed ETL design
Optimized long-running SQL-queries (VLDB, billions rows)
Environment – Oracle 10g R2, Warehouse Builder 10g R2, PowerDesigner 11, Business Objects XI

10.2004 – 07.2006 xxxxxxxxxx
IT Consulting company Oracle Certified Advantage Partner, Analytical Systems and Data Warehouses competence center
Senior DataWarehouse Consultant
Data Warehouse architecture design - conceptual, logical, physical
Data modeling and developing objects in Oracle Database
Creating staging design and analyzing source data
Design, implementation and development of ETL
Customer consulting for DataWwarehouse/BI concept and methodology
Projects
Food factory “Lebedyansky”- Enterprise Data Warehouse
Realized full life cycle: logical, physical design, ETL developing, implementing, testing, performance tuning, documenting.

Telecommunication corporation “RosTelecom”- Building data warehouse multidimensional model

Metallurgical company “OMK”- Building business analytical monitoring dashboards based on data warehouse
Involved in logical model projecting
Developed ETL design
Designed Oracle Portal and Discoverer portlets

National drugstore network “36.6”- Enterprise Data Warehouse, 4 data mart:
Management repots, Budgeting, IAS, KPI
(~2000 dimensions, stored and calculated measures, the largest project - 1 year duration)
Assisted in data warehouse architecture design
Implemented multidimensional model in Oracle Warehouse Builder (Management repots, IAS)
Played a leadership role in the design, implementation and development of ETL
Developed ETL extracting data from Oracle E-Business Suite( General Ledger module) to IAS Data Mart Managed of DWH QA group

Pharmacology Factory “NijFarm”- Enterprise Data Warehouse

Gold-mining Company “Polus”- Pilot presale Enterprise Data Warehouse

Bank - Enterprise Data Warehouse
Design, implementation and development of ETL

Some technology project on introduction Oracle High Avaliability Architecture (Real Application Cluster, Stand by)

Environment: Windows 2000/2003, HP-UX, Oracle 9i/10g, Oracle Warehouse Builder 10g, Oracle Discoverer,
Oracle Workflow Server, Oracle Application Server 10g, Oracle Portal 10g, Delphi 2005, PL/SQL Developer, Informatica 7.5.1

03.2003 – 10.2004 Bank
Senior Oracle Developer/DBA
Provided maintenance of Oracle 7/9i production, test and development instances including banking ERP,
on Windows 2000/2003, SPARC Solaris 2.6/9, x86 Solaris 9 platforms.
Performed installation, capacity planning, monitoring of instance performance, tablespaces utilization,
database objects, connectivity and database availability, verification/validation of database backups,
archive log space availability and maintenance, import/export procedures, performance tuning,
Modified database structure, developed server logic - stored procedures, packages, triggers.
Consulted developer team about PL/SQL development and Oracle database features best practices.
Developed enhancements to Bank ERP using PL/SQL and Delphi 5/7
Branches and currency exchange offices yields calculation Module
Improved cards processing module for working with overdrafts, charge interest on past-due loans,
reservation for past-due loans
Auto loading currency rates from Federal Bank web-site.
Involved in project for migration to new Bank2Customer system that improved performance
of the bank computing center (was responsible for developing connection third-party middle-tier server with bank's ERP)
Environment: Windows 2000/2003, SUN Solaris 2.6/9, Oracle 7/9i, Delphi 5/7, PL/SQL Developer,
PowerDesigner

08.2000 – 03.2003 xxxxxxxxxxxx
investment & brokerage company, special-depositary, dividends payment agent
Database developer/DBA
Implemented Depositary System (MS SQL Server 2000 on Windows 2000)
Administrated and maintenanced Business Critical applications:
Back-Office System (Centura SQLBase 6.1 on Windows NT 4.0)
Dividends-Payment System (Centura SQLBase 6.1 on Windows NT 4.0)
Provide technical support to production systems to ensure they are running error-free.
Provided ETL procedures, data integrity verification and necessary conversation, performance tuning.
Installed patches and upgrades, configured production, reserve and development databases.
Involved into Project "Migration Legacy Dividends-Payment System to Oracle platform"
(new functions, more adaptive to tax-law changes, more integrated with back-office and accounting system).
Used Visual Basic 6.0 + Oracle 8i (later 9i).
Designed and developed programs for:
Data exchange with emitters, registry holder, banks - dividends payment subagents.
Tax-income reports about paid-up dividends in electronic format for State Tax Department.
Developed ASP pages for printing stockholders statement of an account.
Created analytical reports for emitters, management and State Tax Department.
Environment: Windows NT 4.0/ 2000, Oracle 8i/9i, MS SQL 2000, Centura SQLBase 6.1, Visual Basic 6.0,
Centura SQLWindow, PL/SQL Developer, ErWin, Seagate Crystal Report 8.x, ADO, ASP, IIS

08.1999 – 08.2000 xxxxxxxx
Financial and credit consulting
System administrator/DBA
Responsible for company's network infrastructure including WindowsNT multidomain network,
MS SQL Servers 6.5(later migrated to 7.0) running on NT 4.0, FreeBSD based Mail, FTP, Web, DNS Servers.
Involved in installations, configuring, upgrades, performance tuning, standby databases,
scheduling backups/recovery.
Daily administration of network, servers and clients workstation, including installation,
configuration, troubleshooting and provision of appropriate access privileges.
Troubleshooting network malfunctions that may involve analyzing / diagnosing network components.
Set up user and group accounts, rights, and permissions, network and printing resources.
Installed applications, service packs, patches and operating system upgrades.
Specified all new hardware and software purchases for the company, assisted CIO with the preparation
of annual department budget.
Environment: Windows NT 4.0/9x , MS SQL 6.5/7.0, FreeBSD 3.x

EDUCATION
1991-1997 State Academy of Aerospace of Instrument making Saint-Petersburg, Russia.
MSc.Degree in Computer Science (Specialization - system programmer )
2005 Oracle University Course

Oracle 9i Database: Data Guard Administration
Oracle 9i Database: Advanced Replication

Finansials for nonfinansial managers
2006 Oracle University Course

Oracle Application Server 10g Administration Part I
Oracle Application Server 10g Administration Part II
Oracle Discoverer Administrator 10g: Developing EUL

AWARDED CERTIFICATES
1999 MCSE Windows NT 4.0
2001 MCDBA SQL Server 7.0, MCSD VB 6.0, MCSE Windows 2000
2002 OCA DBA Oracle 9i
2003 OCP DBA Oracle 9i, OCA PL/SQL Database Developer Oracle 9i
2006 OCP DBA Oracle 10g

PROFILE
Team player, highly organized, self-motivated and hardworking. Problem solver,
have comprehensive approach to resolve a problem. Easy adaptive to new situation,
quick learner with ability to grasp new technologies. Excellent working under stress-pressure.

REFERENCES AVAILABLE UPON REQUEST

[Gatchinskiy]

... Operation Systems
Windows NT/2000/2003/XP, Solaris, Linux SLES/RedHat AS

Operating Systems

[ir]

//Status in Canada Permanent Residence //
это тоже не надо. вы даете местныи тел. и адрес - этого достаточно
//Optimized long-running SQL-queries // - как-то режет глаз.

[Дима]

А я как-то переписал свое резюме в другом стиле, и оно резко стало смотреться куда интереснее.. Про стиль читать тут: http://www.susanireland.com/resumeguide ... ments.html

Most resumes are boring because they focus on job duties (yawn!).

[Zy]

ir как раз админов ищет.

ir, может, это тот, кто тебе нужен?

[ir]

может быть.
но у нас нет етого резюме. если человек по каким-то причинам не посылал резюме на нашу позицию - то я не могу настаивать.

[Zy]

может быть.
но у нас нет етого резюме. если человек по каким-то причинам не посылал резюме на нашу позицию - то я не могу настаивать.

Ну, может, он в процессе шлифовки резюме, а по поводу настаивать опять же - вам шашечки? Хватай, пока свободен Рынок сейчас горячий!

[ova]

может быть.
но у нас нет етого резюме. если человек по каким-то причинам не посылал резюме на нашу позицию - то я не могу настаивать.

Ну, может, он в процессе шлифовки резюме, а по поводу настаивать опять же - вам шашечки? !

Вот это называется - ненавязчиво выслать.

[Sintetik]

Да я б с удовольствием дал бы местный телефон и адрес, но я пока в москве, в свое время залендился и вернулся. Поэтому и не рассылал его никуда еще. Да и искать работу буду и в Канаде и штатах.