Data Warehousing Resume Profile

Summary:

Total 12 Years of IT experience encompassing a wide range of skill-sets, roles and industry verticals.
Over 5 years of experience in Data Warehousing and using IBM Infosphere Datastage 8.x.
Over 2 years of experience in Data Modeling using CA Erwin 7.x, data architecture, business and data analysis.
Over 10 years of experience in Insurance, Finance, Banking Domain MDM
Experience in leading and managing teams. Handled multiple roles Consultant, Client side Delivery Manager, Technical Lead, Designer, Systems Analyst, Developer.
Involved in Requirement Gathering, Project planning, Project estimation, Project tracking, and Risk Stakeholder management.
In-depth knowledge of Systems Development Life Cycle SDLC In Agile as well as water fall model.
Expertise in various data load strategies and scenarios like historical data, surrogate keys and summary tables.
Experience in designing, optimizing and fine-tuning ETL environments taking into consideration aspects like efficiency, performance, restart ability and ease of maintenance.
Good understanding of various databases such as Teradata, DB2 and Oracle.
Proficient in analyzing and translating business requirements to technical requirements and architecture.
Executed software projects for Telecom Billing , Insurance, Finance and Banking industry.
Significant experience in providing 24 x 7 support, and resolving business user issues.
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Technical Skills:

Data Warehousing Tools: IBM InfoSphere DataStage 8.0, 8.1 8.5
Development Tools: CA Erwin Data Modeler 7.3, TOAD
Functional Modules: Telecom Billing , Insurance, Banking, Warehousing, OTC, Finance, MDM and Data Modeling
Data Models: Dimensional Star, Snowflake , Relational, Normalized and De-normalized
RDBMS: Oracle 10g, 9i, Teradata, DB2, MS Access 2000
Languages: SQL, C, C , UNIX Shell Script, COBOL, JCL, CICS, VB, HTML, DHTML
O/S: Windows XP, Windows NT Server, UNIX, DOS, MVS/ESA, OS/390, IBM-AIX
Other Tools: OPC, DB2 Platinum, Alchemist, File-Aid, MS Visio, RPM Rational Portfolio Manager , Rational Clear Quest, SAP, TOAD, SQL Developer