ETL Consultant Resume

SUMMARY:

5 years and 10 months experience in Data Warehousing(ETL), Data Migration and Business Intelligence(reporting) at both offshore and onshore locations with prominent experience in Banking
Financial and Insurance domains. Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects and has worked on ETL job development, code migration/deployment, scheduling and production support etc.
Worked extensively on IBM Datastage, Actuate erdPro and Actuate BIRT, PL - SQL, UNIX scripting and scheduling tools
Expertise in Data Requirement Analysis, Design, Development of ETL process using IBM DataStage
Extensively worked on various DataStage Stages like Transformer, Join, Lookup, Pivot, Merge, Sort, Filter, Aggregator, Copy, Remove duplicates, Funnel, Change capture, Data Set, Sequential File etc.
Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects
Has played various roles like developer, onsite coordinator, ETL designer etc.
Experience in analysis, requirement gathering, design, development, deployment and testing of ETL jobs
Strong knowledge of data warehousing concepts like schemas, data marts, data load, facts and dimensions etc.
Understanding of business process and data models

TECHNICAL SKILLS:

Business Domain: Banking and Finance Domain and Insurance Domain

Programming Languages: SQL and PL/SQL, Shell Scripting

Operating System: Windows 7/XP/2000, UNIX

Tools: /DB /Packages: DataStage 8.0/8.5, Actuate erdPro, BIRT, DB2, Oracle SQL, PL/SQL, AbInitio (Trained), QlikView(Trained), Khalix(Trained)

Technical Domain: Business Intelligence and Data Warehousing

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant

Responsibilities:

Member of AMIG’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
Transforming and providing source data to agents in required formats using Datastage
Responsible for developing new DataStage jobs, re-designing and simplification, performance tuning and upgrade activities
Contributes to both DataStage development and Support activities
Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
Providing support to code deployment process
Coordinates with both onsite and offshore team
Support Guidewire Policy/Billing center issues

Environment: Windows Server 2008, Infosphere DataStage 8.7, Oracle 11g, Putty, Control - M, SQL Developer, DB2

Confidential

Senior DataStage Developer

Responsibilities:

Member of Munich Re’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
Contributes to both DataStage development and Support activities
Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
Responsible for DataStage jobs re-designing and simplification, performance tuning and upgrade activities
Providing end to end support for Datastage ETL jobs
Transforming and providing source data to ISyCl application based on client requirement
Providing support to code deployment process

Environment: Windows Server 2008, Infosphere DataStage 8.7, Oracle 11g, Putty, Control - M, SQL Developer

Confidential

Project Member

Responsibilities:

Environment: Windows XP, Datastage 8.5, Teradata v13, SQL Assistant

Confidential

Project Member

Responsibilities:

Environment: Windows XP, Actuate eRDPro, Unix, SVN, IBM DB2

Confidential

Project Member

Responsibilities:

Environment: Windows 98/XP, Actuate BIRT, Oracle

Confidential

Project Member

Responsibilities:

Environment: IBM WebSphere DataStage Ver. 8.0, MS SQL-Server