Data Developer

IRINA VITA

Senior ETL Analyst / Developer

**** ********** **.,

Boca Raton, FL 33433

Phone # 612-***-****

Summary of Qualifications

• Over twelve years of experience in Information Technology including Data

warehousing,

Internet and Client Server applications in retail, marketing and health domains.

• Design, development and support of ETL processes for Oracle and Teradata Data

Warehouses

and Data Marts.

• Creation of logical and physical data models as a part of building and enhancement of

the

corporate Data Warehouse using Power Designer and SQL scripts.

• Application performance tuning, troubleshooting, data loading, problem resolution,

and

modification of changes required to meet performance requirements

• Extensively used ETL methodologies for supporting data extraction, transformations

and

loading processing, in a corporate-wide-ETL Solution using Informatica PowerCenter

8.6 /

8.1/ 7.1.4 / 7.1.2 / 6.2

• Involved in product life cycle development from product concept through full

deployment.

• Expert at creating logical and physical data models as a part of building and

enhancement of

the Data Warehouse using Power Designer and SQL scripts.

• Exceptionally good team player/lead with oral and written communication skills.

Technical Skills

Languages/Software: SQL, PL/SQL, C, UNIX Shell Scripting (Korn Shell),

SQL*Loader, HTML, XML, Java, SAP

ETL Tools: Informatica Power Center (6.2, 7.1, 8.6), B2B Data Transformation

(Complex Data Exchange)

Reporting Tools: Business Objects, Cognos, Siebel

Databases: Oracle(8i, 9i & 10g), SQL Server (2008), DB2, Teradata

Operating Systems: Windows NT/9x/2000XP, Unix, Lunix, MS-DOS

Database Modeling tools: Visio, Ervin, Power Designer (6.2,7.1)

Professional Experience

Thomson Reuters

Senior ETL/ Informatica Analyst/Developer Consultant January 2009- April 2010

Design and development of ETL processes using Informatica PowerCenter 8.6.0 for an advanced

online legal application. Created few Data Warehouses for SQL Server and Oracle databases

using flat files, XML files, database tables and views as sources and targets. Database Dataflow

performance tuning, troubleshooting, data loading, problem resolution . Prepared documentation

for deployment project to production.

Centene Corporation

Senior ETL/ Informatica Analyst/Developer Consultant September 2008-December

2008

Development of ETL processes using Informatica PowerCenter 8.6.0 for Data

Warehouse. Application performance tuning, troubleshooting, data loading, problem

resolution. Preparation of detailed specifications for new and modified Informatica units.

Cargill

Senior ETL/ Informatica Analyst/Developer Consultant April 2007-August2008

Extensive use of developer and analytical skills. Developed ETL processes using Informatica

PowerCenter (7.2 & 8.1) and Oracle PL/SQL development on 9i and 10g Platforms for Cargill

FISNA-IT Shared Service in such business areas as Inventory adjustments, Purchase and Sale

Contracts, Pricing.

Allina Hospitals & Clinics

Consultant November 2006-Feburary 2007

Design and development for new Data Warehouse and Data Mart for Diabetes Registry using

Informatica PowerCenter (7.2) and Oracle PL/SQL development on 9i Platform .

Carlson Companies

Consultant December 2005-October 2006

Design and development for direct marketing and data warehousing. Modification, development

and support of ETL processes for multiple projects using INFORMATICA PowerCenter 7.1,

UNIX Korn Shell scripting, PL/SQL, Sql*Loader within travel and manufacturing industries for

ORACLE, SQL Server and TERADATA databases.

Accenture

Senior Analyst Programmer November 2002-September 2005

Design, development and support of ETL processes for Oracle and Teradata data marts using

tools/languages: Informatica PowerCenter (6.2, 7.1), UNIX Korn Shell scripting, SQL, PL/SQL,

Sql*Loader, Teradata. Creation of logical and physical data models as a part of building and

enhancement of the corporate Data Warehouse using Power Designer and SQL scripts.

Retek, Inc.

Software Engineer IV October1998-October2002

Designed and developed Retek Merchandise System software applications in Pro C* and PL/SQL

using Sun Solaris operating system. Designed and developed Oracle Forms and Reports utilizing

Oracle Developer 2000. Fixed and enhanced the Retek software products according to the client’s

needs and programming standards.

Carlan Consulting Group, Pensacola, FL

Programmer June 1996- October 1998

Worked as data technician in Civil Engineering Group. Gathered and organized field data

followed by creation of Oracle relational database for new City Drainage Systems Project.

Created PL/SQL applications to process and support data.

Education

1988 MS in Engineering, Moscow State University of Civil Engineering, Moscow,

USSR

Certifications and Training

2008 B2B Data Transformation (Complex Data Exchange), Virtual Academy Course, Informatica

Corporation

2002 Teradata, Accenture Training Center, Minneapolis, MN

2000 Retek Data Warehousing, Retek Training Center, Minneapolis, MN

2000 AppWorx Enterprise Job Scheduling Software, Retek Training Center, Minneapolis, MN

1998 Oracle Developer 2000, Retek Training Center, Minneapolis, MN

1998 Pro*C, Retek Training Center, Minneapolis, MN

1998 Retail Sale and Retek Merchandise System, Retek Training Center, Minneapolis, MN

1996 Oracle 7 and PL/SQL Programming Course, Technical Community College, Pensacola, FL

Contact this candidate