SUMMARY:

• I’m a certified Teradata 14 technical specialist and certified data integration PowerCenter developer 9 specialist having 5+ years extensive experience with Informatica PowerCenter, 5+ years experience in designing, analyzing, developing and maintaining extract transform load processes and data integration systems such as data warehouse, master data management, capture data change and business intelligence.
• I am an active, cheerful, self - motivated and positive thinking person.
• I have good communications skills and ability to quickly learn new technologies and systems.
• I like getting unusual and interesting challenges and finding different ways to solve them, I can work equally well and hard in a team or alone.

TECHNICAL SKILLS:

• Data Warehouse (DWH) 6
• Extract Transform Load (ETL) 6
• Informatica PowerCenter 8.1.1, 8.6.1, 9.5.1 6
• Oracle 10g, 11g 6
• Teradata 14, 15 1
• Oracle BI EE 10, 11 1
• IBM Data Stage 8.7, 9.1 1
• Informatica PowerCenter Mapping Architect for Visio 1
• Informatica MDM 9.5.1 1
• Teradata Mapping Manager
• Informatica Data Replication
• Informatica PowerExchange
• ERWin, Sybase PowerDesigner, Data Modeling
• Oracle XML DB
• Oracle Utilities Customer Care and Billing ( &B)
• Oracle Transportation Management, Oracle Inventory
• Diasoft 5NT
• Openway Way4 Cards

WORK EXPERIENCE:

ETL Consultant

Confidential

Responsibilities:

• Analysing Enterprise Data Warehouse
• Analysing and developing ETL processes
• Analysing ETL incidents from customer
• Searching for and removing ETL error causes
• Developing patches for ETL processes
• Simulating data errors and testing patches
• Reviewing ETL code

Tools: Teradata 14 DB, Informatica PowerCenter 9.1.0

Confidential

Responsibilities:

• Analyzed system of accounting document processing
• Analyzed Teradata subsytem for storing transactional data
• Calculated control performance indicators
• Developed measures and dimensions
• Refactoring ETL code
• Analyzed and fixed ETL error causes
• Analyzed and developed analyses and dashboards

Tools: Teradata 15 DB, Oracle BI EE 11

Confidential

Lead Consultant

Responsibilities:

• Analyzed customer requirements
• Designed ETL processes
• Developed mapping templates using PowerCenter Mapping Architect For Visio
• Generated multiple IPC mappings and IPC workflows
• Analyzed sources
• Mentored ETL developers

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, PowerCenter Mapping Architect For Visio, Informatica Data Replication

Confidential

Responsibilities:

• Analyzed FormIT system
• Created FormIT templates
• Developed Control Processes

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, FormIT

Confidential

Responsibilities:

• Led a team of 5 developers, 2 analysts and 1 tester
• Analyzed Master Data Management system and ETL processes
• Used Informatica MDM: Informatica MDM Data Director, Informatica MDM Hub Console
• Developed IDD: Subject Area Group, Subject Area, Subject Area Child
• Used MDM Hub Console: Metadata Manager, Schema, Schema Viewer, Queries, Packages, Cleanse Functions, Mappings, Hierarchies, Security Access Manager, Data Steward, Batch Group, Batch Viewer

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, Informatica MDM

Confidential

Responsibilities:

• Gathered ETL design requirements
• Designed ETL processes
• Developed ETL processes
• Created 2500+ IPC mappings, 1300+ IPC workflows with a team of 3 ETL consultants in 3 months (8 sources, 434 tables)
• Analyzed PowerCenter Mapping Architect For Visio
• Designed mapping templates using PowerCenter Mapping Architect For Visio and generated multiple IPC mappings
• Generated multiple IPC workflows using XML and VBS scripts
• Tuned IPC mappings and workflows performance
• Generated multiple file parameters using VBS scripts
• Imported multiple IPC objects using pmrep
• Created dynamic SQL and shared IPC mapping for referential integrity checking
• Extracted database objects metadata using SQL scripts
• Created document for generating IPC mappings using PowerCenter Mapping Architect For Visio
• Mentored bank ETL developers
• Used Informatica PowerCenter Versioning

Tools: Informatica PowerCenter 9.5.1, PowerCenter Mapping Architect For Visio, Oracle 11 DB

Confidential

Responsibilities:

• Analyzed S2T (Source To Target)
• Analyzed sources
• Developed ETL processes
• Analyzed Neoflex Summary Report system
• Completed Neoflex Summary Report system conversion
• Developed Summary Report ETL processes
• Tuned IPC mappings and workflows performance
• Analyzed Data Warehouse
• Analyzed ETL processes
• Extracted IPC objects metadata using SQL scripts for IPC repository DB
• Wrote document «Data Warehouse technical description»
• Wrote document «Administrator guide»
• Used Informatica PowerCenter Versioning

Sources: Openway Way4 Cards, CFT-Bank, Summary Report Forms (Excel files)

Tools: Informatica PowerCenter 9.5.1, Oracle 11 DB

Confidential

Responsibilities:

• Communicated with client
• Designed generic architecture
• Created data migration methodology description

Confidential

Responsibilities:

• Analyzed ETL processes
• Reviewed code
• Tested individual person account statement formation

Tools: T-SQL

Confidential

Responsibilities:

• Communicated with client
• Estimated scope of work

Confidential

Responsibilities:

• Communicated with client
• Estimated scope of work
• Analyzed current Data Warehouse

Confidential

Software Programmer/Analyst

Responsibilities:

• Analyzed sources
• Created S2T (Source To Target) for source systems
• Developed ETL processes
• Created Loan Portfolio Data Mart
• Maintained new and old ETL processes
• Tuned IPC mappings and workflows performance

Sources: Diasoft 5NT, FIS Profile, Openway Way4 Cards, FICO Capstone Decision Accelerator

Tools: Informatica PowerCenter 8.1.1, Oracle 10 DB

Confidential

Data Warehouse maintenance

Responsibilities:

• Analyzed and maintained ETL processes using PL/SQL
• Made conversions for ETL processes using PL/SQL
• Analyzed and corrected data in Data Warehouse using PL/SQL
• Analyzed data in Data Mart using Oracle BI EE
• Processed business user’s requests
• Analyzed and maintained Reference Data Management Module

Sources: XML files from branches

Tools: Oracle XML DB, Oracle 11 DB, PL SQL, Oracle BI EE 10g

Confidential

Data Warehouse implementation

Responsibilities:

• Analyzed and maintained ETL processes
• Analyzed and corrected data in Data Warehouse and Data Mart
• Tested and installed releases, datafixes and hotfixes
• Processed business user’s requests
• Wrote usercases
• Used Informatica PowerCenter
• Developed IPC mappings and workflows
• Tuned Oracle BI EE
• Designed repository
• Tuned web-interface
• Developed Answers
• Developed Dashboards

Tools: Oracle 10 DB, Oracle BI EE 10g