CV на критику ETL Developer

[Sintetik]

Summary
18 years experience in IT field, last 10 years of progressive experience as a Enterprise DataWarehouse Developer in Oracle and IBM environment.
Excellent knowledge of Relational Data Model, Enterprise Data Warehouse, Oracle, PL/SQL, SQL. Strong Data Warehouse and BI Skills, solid development background besides DBA skills. Expert in ETL processes and ETL Tools. Clear understanding of Enterprise 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/11g, options - RAC, Partitioning, OLAP, Transparent Gateway (12+year)
IBM Netezza, DB2 i series

BI/ETL tools
Oracle Warehouse Builder 10g/11g(5year), Oracle Data Integrator 10g/11g(6year), IBM DataStage 8.7/9.1(2year)

Operation Systems
Windows NT/2000/2003/2008(16+year), HP-UX, Linux SLES/RedHat AS/Oracle UL(10+year)

EMPLOYMENT HISTORY

December 2012 – present
IT Consulting company
Head of design and developing ETL division

DWH projects for the public sector.
1.Oracle Database 11g, RAC, Exadata, Oracle Data Integrator, OBIEE
2.IBM PureData system (ex. Netezza), DB2 iSeries, DB2 for z/OS, InfoSphere DataStage, FastTrack, CDC, Data Replication

Projecting ETL arcitecture
Implementing ETL developing methodology
Presale activities, assessment of labor, consulting of sales.
People management, hiring, couching.

03.2007 – 12.2012 Oracle Russia representetive office
Technical Presale Consultant – Data Warehouse and BI
Product expert - Oracle Data Integrator
-Acting as the expert in the ETL/BI product set (Oracle Warehouse Builder, Oracle Data Integrator, Oracle BI EE)
-Designing and delivering customer demonstrations/presentations to articulate, update and evangelize Oracle based BI product solutions as required
-Support the sales reps and specialists to identify the best Oracle solution for their customer's business
-Engage with customers by translating their business needs into appropriate Oracle solutions.
-Present and articulate features and benefits of Oracle technology solutions showcase Oracle Database product stack using existing solutions and internal development resources
-Deliver product demonstrations and presentations to customers using the latest web technology.
-Ongoing education and training of the sales force and partner’s staff on Oracle DWH/BI products, technologies and solutions.
-Coach sales representatives to identify and create sales opportunities for the broad range of Oracle solutions and assist the sales teams to identify customer up sell opportunities.
-Support partners in Oracle DWH/BI products implementation

10.2004 – 03.2007
IT Consulting company Oracle Certified Advantage Partner, Analytical Systems and Data Warehouses competence center
DataWarehouse Developer
----------------
Projects
X5 Retail Group (http://www.x5.ru) - Large Retailer - Enterprise Data Warehouse
As ETL-engineer on pilot project phase (Data mart)
-Developed ETL design
-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
-Optimized long-running SQL-queries (VLDB, billions rows)

As System Architector on main project phase
-Was responsible for logical and physical model design, project documentation
Environment – Oracle 10g R2, Warehouse Builder 10g R2, PowerDesigner 11, Business Objects XI

Top30 Russia Bank - Enterprise Data Warehouse
ETL-developer Informatica PowerCenter, DB2 AS/400r

Food factory “...”- Enterprise Data Warehouse
-Realized full life cycle: logical, physical design, ETL developing, implementing, testing, performance tuning, documenting.
Telecommunication corporation “...”- Building data warehouse multidimensional model
Metallurgical company “...” - 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 “...”- Enterprise Data Warehouse, 4 data mart: Management reports, 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 reports, 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 “...” - Enterprise Data Warehouse
Gold-mining Company “...” - Pilot presale Enterprise Data Warehouse
Some project on introduction Oracle High Avaliability Architecture (Real Application Cluster, StandBy)

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

03.2003 – 10.2004 Russia Bank 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 Financial Company, 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

[Sintetik]

Можно еще глубже 1999... написать, но надо ли?
Может вообще все что раньше чем 10 лет выкинуть?
Принято ли расписывать детали проектов для госструктур?

[Clear]

Spelled Systems Architect, не Architector.
Зайдите на indeed.com там есть образцы ETL резюме.