Resume of ETL Developer

Title
ETL Developer

Primary Skills
Sr. Informatica Powercenter and Oracle Datawarehouse professional

Location
US-NY-Levittown (will consider relocating)

Posted
Feb-07-08

HIGHLIGHTS OF QUALIFICATION:
Over 11+ years of experience in database application development and 6+ years of experience in Data Warehousing, especially in banking and telecommunications industry:
* Excellent knowledge of data warehouse architectures, concepts and technologies, dimensional Star Schema and Snowflakes Schema methodologies
* Expert in designing and developing complicate ETL mappings using Informatica PowerCenter
* Proficient in optimizing performance issues using Informatica PowerCenter
* In depth understanding in data modeling, entity-relationship modeling , slowly changed dimensions modeling
* Extensive background in SQL ,PL/SQL programming, mainly Oracle 9i/10g in Unix environment
* Hands-on production experience in large data warehousing (more than 20+ Terabytes) implementation
* Solid SAS development experience in Unix environment, hands-on shell scripting experience in Unix environment
* Very familiar with Business Intelligence technologies using Microstrategy
* Detailed knowledge of multi-tier architecture in client/server environment
* Strong analytical skills, "big picture" thinker
* Pro-active and adaptive in nature.

WORK EXPERIENCE
Feb 2006 - present Senior Datawarehouse /ETL Developer, Informatica Corporation http://www.informatica.com
Project: Implementing an Enterprise Datawarehouse in top five investment Russian bank , Alfabank http://www.alfabank.com
In large mix of DBMS and ERP Data System environment, as an employee of a consulting company:
* Determined ETL Architecture and ETL Processes;
* Defined structure of dataflow for seamless migration from large mix data systems;
* Designed and implemented complex data transformation mappings using Informatica PowerCenter;
* Installed and loaded data into SAP BW using Informatica PowerCenter Connect for SAP BW ;
* Resolved performance issues in Informatica PowerCenter workflows, so reduced incremental load data duration more than three times, from 6 to 2 hours;
* Optimized heavy-load queries in DB2/AS400 and Oracle environment for using in Informatica Power Center mappings;
* Installed and configured Informatica PowerExchange 8, that provides high-performance extraction data in Oracle environment;
* Transformed business requirements into technical specifications, source-to-target mappings;
* Installed and configured Informatica Power Center Server 8.1.
Environment: DB2/AS400 iSeries DBMS, Informatica PowerCenter 7.x, 8.x, Informatica PowerExchange 8.x, Oracle Database EE 9i, Sybase Power Designer .

Feb 2005 - Feb 2006 Senior Datawarehouse/ETL Developer , the largest telecommunication vendor `MTS' http://www.mts.ru that serves 123 million customers.
Project: Extending and support the Enterprise Datawarehouse .
In large data warehousing (more than 20+ Tb) implementation and Oracle large-scale VLDB (as a main source) 10+ Tb environment:
* Developed advanced mappings using Informatica Power Center;
* Resolved performance issues in Informatica Power Center workflows;
* Tuned heavy-load Oracle database queries (billions rows) by implementing partition, indexing and materialized Views for using in Informatica Power Center mappings;
* Participated in designing SAS program modules for creating Multidimensional(MDDB) SAS cubes;
* Collected business requirements and objectives and transformed business requirements into technical specifications;
* Involved in writing Unix Shell scripts on Solaris platform to automate loading process, schedule them at crontab, and notified the success / failure to users.
Environment: Informatica Power Center 7.1, Oracle Database 8i/9i, SAS MDDB Server, SAS Warehouse Administrator, SAS Base v.8/9, Sun Solaris.

June 2000 -Feb 2005 Senior Datawarehouse/ETL Developer, The largest investment bank in Central and Eastern Europe -Savings Bank http://www.sbrf.ru/eng/
Project: Implementing an Enterprise Datawarehouse
As a member of the project team I was involved in full project lifecycle utilizing Oracle Datawarehouse methodology (DWM). My main responsibilities included:
* Played a key role in designing and developing ETL model for the project;
* Analyzed data sources and targets using Informatica Data Profiling option;
* Designed and implemented ETL mappings/processes using Informatica Power Center ;
* Migrated the legacy PL/SQL code functionality into a mappings using Informatica Power Center;
* Identified and resolved performance issues in Informatica Power Center mappings and workflows;
* Designed some dimensions, especially slowly changed dimensions type 2 and type 3;
* Created some applications modules and stored procedures using Oracle PL/SQL;
* Determined data acquisition requirements;
* Installed and configured Informatica Power Center Server 7, Oracle Database 9i/10g;
* Created analytical reports using Oracle Reports 6i, Crystal Reports 8, Visual Basic 6, XML/XSLT,HTML;
* Participated in designing data load strategy for full and incremental data load process.
Environment: Oracle Database 8i, Informatica Power Center 7.x, MS SQL Server 7.0, Linux RH 2.1, Oracle Reports 6i , Crystal Reports 8, Visual Basic 6.

Jan 1997 - June 2000 Software Engineer, JSC `Liftremont'
Project: Enterprise billing system
* As a developer of the team designed Corporate billing system in 3-tier Client/Server environment, using MTS/DCOM for complete more than 100000 orders per month;
* Designed database model and implemented business level objects and storage-retrieving objects.
Environment: MS Visual Basic 6.0, MTS Server 2.0, COM/DCOM, ADO 2.0, Crystal Reports 6.0, MS SQL Server 6.5.

Certifications
PROFESSIONAL CERTIFICATIONS
* Oracle Certified Professional 9i DBA since August 2002.
* Microsoft Certified Solution Developer since November, 2000 .
* IBM Certified Specialist in XML and Related Tecnologies (141) since March 2003.

* 1990-1996 M.Sc.degree in Computer Science.



You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-Levittown »
View all resumes in US-NY »

View other ETL Developer resumes, Programmer / Developer resumes