SUMMARY:

• Highly skilled professional with 20+ Years of experience out of which more than 13+ years in Data Warehousing/Business Intelligence and
• Database Business Applications. Well Versed with the Strategy, Design and Development of ETL architecture of the Data Warehouse using various tools. Industry experience includes Insurance, Financial, Banking, Healthcare and Retail. A self - motivated performer with experience as
• Lead architect and also Subject Matter expert for P&C Insurance Business.
• Highly Experience in leading ETL engagements from design through implementation of large/complex data ware house/ integration projects for various Clients
• Highly Experienced in handling end to end implementation of Data ware House projects
• Implemented large scale DW projects for Prudential Insurance, UK, Zurich North America, farmers Insurance, Nationwide Insurance, T-Mobile
• Highly experience in Defining Scope and Planning, Requirement Gathering, Data Analysis and Design.
• Hands on Experience in Project Management.
• Handled Multimillion dollar projects.
• Highly experienced in handling onshore and offshore model projects.
• Excellent problem solving skills with strong technical background and good interpersonal and communication skills.
• Expert knowledge and hands-on experience with Informatica Power Center 9.5.1 Hot Fix3 and other versions.
• Demonstrate ability to lead multiple projects of varying degrees of complexity.
• Hands on experience in Data Modeling Physical and Logical Data Modeling.
• Hands on experience with Teradata 13.0.
• IBM on IAA/IIW Data Model.
• Very Good Knowledge in UNIX.
• Hands on Experience in Netezza using ODBC and Informatica power exchange for Netezza
• Hands on Experience in the databases Netezza, DB2, Oracle and Teradata, SQL Server .
• Extensively used NZ Load, NZ SQL Scripts.
• Extensively used BTEQ Scripts using Teradata
• Extensively Worked on Netezza Twin Fin 6.0 and Twin Fin12 and Twin Fin24.
• Migrated 1500+ Informatica mappings from DB2 to Netezza,
• Migrated very complex queries from DB2 to Netezza.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management
• Hands on experience in Implementing large data ware house Projects using Kimball and Inman Methodology.
• Hands on Experience in Designing star schema, Snow Flake Schema and other dimensional data models
• Hands On experience with various Modelling tools including Erwin, Power Designer, ER Studio, Oracle Data Modeler.

TECHNICAL SKILLS:

RDBMS: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), Teradata, DB2,DAC,SYBASE,Netezza(Appliance),SQL Server,SAP

ETL Tools: Informatica Power Center 4.1/5.0/5.1/6.2/7.0/8.6.1/9.0.1/9.5.1 and other lower versions, Power Exchange,MDM-XU-DB2,Oracle Data Integrator 10g,OWB 10g

Operating Systems: UNIX (Sun Solaris, HP Unix, LINUX), Windows NT/98/95, WIN 2000

Data Modeling: Erwin 3.5.2, 4.0,Visio,IIA/IIW,ER Studio, Power Designer

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Cobol and C

Other Tools: Visual Basic 5.0/6.0 and Developer 2000, Actuate 7.0/6.0, Query Man 5.0,Toad 7.X,AQT,Cognos 8

Hardware: RS 6000, Pentium IBM PC

Functional Areas: Insurance, Finance, Banking, Healthcare and Retail

PROFESSIONAL EXPERIENCE:

Sr. Solution Architect

Confidential, Seattle, WA

Responsibilities:

• Source system analysis, Data Quality analysis
• High Level Solution Design Preparation
• LDM,PDM and S2TM Preparation
• Data Profiling.
• Architecture Design Document Preparation
• Data Integration and Data Migration strategy
• Data Model review and coordination with data modelers.
• System testing support, Regression testing support and UAT Testing Support.

Technologies Used: Informatica 9.5.1,Oracle 11.6,Teradata 13.0,Unix,Hadoop,ER Studio

Sr. Architect

Confidential, Chicago, IL

Responsibilities:

• Source system analysis
• LDM,PDM and S2TM Preparation
• Data Profiling.
• Data Migration strategy
• Solution Architecture for technology enhancement.
• Performance Tuning.
• Onsite and offshore Coordination
• Offshore team mentoring,

Sr. Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• High Level Design Preparation
• LDM,PDM and S2TM Preparation
• Data Profiling.
• Data Integration and Data Migration strategy
• Data Model review and coordination with data modelrs.
• Solution Architecture for technology enhancement.

Technologies Used: Informatica 9.0.1,Oracle 11.6,Teradata13.0,TOAD for Oracle 11.6,Unix,ERwin

Lead Data Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• Gather Business requirements
• Design a dimensional model using Dimensional Modeling techniques
• LDM,PDM and S2TM Preparation
• Works closely with the user community, technical staff and team members to develop reporting and analysis specifications
• Create the ETL Design document
• Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures
• Works closely with Reporting/Analysis teams to educate end-users on the proper usage of Data Marts
• Provide input and recommendations on design/technical issues to project manager/senior managers

Sr.Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• Analyzing the existing source systems and estimated the impact.
• High Level Design Preparation
• Review of Low Level Design for critical components
• System testing support, Regression testing support and UAT Testing Support.
• Traceability from Business Requirements to the System Requirements.

Lead Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Analyzing the existing source systems and estimated the impact.
• Data Model changes to in corporate the new changes
• High Level Design Preparation
• Review of Low Level Design for critical components
• Technical solution and mentoring the team.
• Delivery and Implementation.
• System testing support, Regression testing support and UAT Testing Support.
• Performance Tuning.
• Traceability from Business Requirements to the System Requirements.

Lead Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Analyzing the existing source systems and estimated the impact.
• Data Model changes to in corporate the new changes
• High Level Design Preparation
• Review of Low Level Design for critical components
• Used Netezza using ODBC and Informatica powerexchange for Netezza
• Used NZLoad to load flat file data into Netezza tables.
• Technical solution and mentoring the team.
• Delivery and Implementation.
• System testing support, Regression testing support and UAT Testing Support.
• Performance Tuning.
• Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 8.6.1,Netezza,AQT,Unix,Erwin,DB2

Lead Architect

Confidential, Schaumburg,IL

Responsibilities:

• Review the existing informatica mappings and create design documents to migrate them to Netezza.
• Defining Converted DB2 Materialized views into Netezza views
• Worked on performance and tuning Netezza queries
• Worked on identifying and setting up proper distribution keys.
• Good knowledge on Netezza architecture like Zone maps, distribution keys etc
• Delivery and Created design approach to lift and shift the existing mappings to Netezza.
• Created design documents to convert the existing mappings to use informaitca pushdown optimization.
• Analyze the impact on the downstream systems and recommend the solutions to keep them intact.
• Developed reusable frameworks for DB constraints and NZLoad.

Technologies Used: Informatica 8.6.1,DB2,Netezza,AQT,Unix

Architect

Confidential, Schaumburg, IL

Responsibilities:

• Requirements Gathering, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Defining Technical Architecture
• High Level Design Preparation
• Change Request impact analysis and cost estimation
• Design walk-through with Client and sign-off
• Delivery and Implementation.
• Performance Tuning using Netezza
• Used Netezza using ODBC and Informatica powerexchange for Netezza
• Used NZLoad to load flat file data into Netezza tables.
• Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 8.6.1,DB2,TOAD,Unix,ERwin

Lead Architect

Confidential, Schaumburg, IL

Responsibilities:

• Existing mappings analysis
• Defining Scope, Planning and Estimation.
• Re-designing the existing data model to improve the performance.
• High Level Design Preparation
• Re design the Reinsurance and commutations processing to improve the performance.
• Technical reviews and co-ordination
• Assigning the tasks to Tech Leads and review the progress.
• Delivery and Implementation

Technologies Used: Informatica 8.6.1,DB2,TOAD,Unix,ERwin

Lead Architect

Confidential, Schaumburg,IL

Responsibilities:

• Source system analysis, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Defining Technical Architecture
• High Level Design Preparation
• Review of Low Level Design
• Technical solution and mentoring the team.
• Delivery and Implementation.
• System testing, Regression testing and UAT Testing Support.
• Performance Tuning.
• Traceability from Business Requirements to the System Requirements.

Technologies Used:Informatica 8.6.1,DB2,TOAD,Unix,Erwin

Onsite Coordinator and Architect

Confidential

Responsibilities:

• Source system analysis, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Defining Technical Architecture
• High Level Design Preparation
• Review of Low Level Design
• Technical solution and mentoring the team.
• Delivery and Implementation.
• System testing, Regression testing and UAT Testing Support.
• Performance Tuning.
• Traceability from Business Requirements to the System Requirements.