SUMMARY:

• Informatica certified developer with over 9+ years of experience in Information Technology, with focus on Data warehousing, Business Intelligence, Onsite - Offshore model & Team Management. Informatica Data Quality IDQ 9.6.1. Informatica MDM 9.6.1.
• Over 9 years of experience Informatica development, testing, deployment with various versions of Informatica, Informatica Power Center 9.6.1/9.1/8.6.1/7.1, and Informatica power exchange 9.6/9.1. Informatica MDM 9.6.1.
• Over 5 years of experience in DB 2 9.7/10.1/10.5/11.0 (Ingest, Import, Export, DB2 load, DB2 explain), Oracle 10g, SQL Server, one year of experience in Teradata.
• Worked with various versions of Informatica, Informatica Power Center 9.6.1/9.1/8.6.1/7.1, and Informatica power exchange 9.6/9.1. Informatica IDQ 9.6.
• Worked with reporting teams on Cognos and Business Objects tools on Reporting Platform to create Business reports.
• Worked in several areas of SDLC including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation.
• Experienced in Software Development and gained expertise in Data Warehousing and Business Intelligence.
• Extensively used DB2, Oracle Server, Informatica power Center and Informatica power exchange, Informatica power exchange, Informatica data quality.
• Good exposure to Finance and compliance, Insurance auto/fire/Life.
• Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables.
• Worked in remediation (Performance Tuning) team for improving query performance of user queries and production SQL’s.
• Worked on Hadoop migration project for enterprise performance management analytics project.
• Very good experience in customer facing skills and release and change management.
• Knowledge on workload automation and job Schedulers, extensive used scheduling tools Control - M, Informatica schedulers, worked extensively on designing and scheduling of the jobs using Control - M as per the projects requirements.
• Very good experience in migration projects like UNIX to LINUX migration, Avia to Cisco migration, Lotus Notes to EUC Migration, FDW1.0 Host to FDW2.0 BIRA environments.
• Exposure to Hadoop, Big Data, and experience in writing Linux scripts for EPMA Landing Zone project.
• Worked on Data modelling using ER studio and Erwin.

TECHNICAL SKILLS:

DB2 Technologies: 7.1, 8.1, 9.1, 10.5 Databases; SQL, Load utilities, PLSQL (procedures, functions, triggers, packages, collections) Aggregate and Analytical Functions; Utilities Import/Export, Data Pump, SQL Loader, External tables; Packages redefinition, scheduling, mail

Oracle Technologies: 8i, 9i Databases; SQL, PLSQL Utilities Import/Export, SQL Loader, External tables; Packages redefinition, scheduling, mail

Data Modeling/Other Tools: Erwin, Toad Modeler, PLSQL Developer, Toad for Oracle, Rapid SQL 7.2

Scripting: Windows and Unix/Linux Batch Program

Data Quality Tools: Informatica Data Quality

Microsoft Suite: Access Database; MS Excel; Excel Functions VLOOKUP, Financial, Pivot, Dashboards and charts.

Other Databases: SQL Server 2005/2008, SSAS and SSRS; DB2 UDB, TeraData

Scheduling Tools: Control M 10.1, 11.0, Unix Edward scheduler 6.0

Reporting Tools: Cognos, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

ETL Informatica Lead Developer/ETL Architect

Responsibilities:

• Worked with various internal teams to understand the existing systems and environments
• Facilitates the rigorous identification and documentation of Customer Care Network BI/Data Management architecture by participating in a variety of activities to meet Client’s needs.
• Gathering and document requirements for Analysing business needs and design appropriate data architecture and roadmap.
• Coordinating and executing the transition and ongoing management of business architecture
• Provides support of business architecture vision and direction, providing communication and education
• Develops execution level architecture and communicates business needs to execution efforts.
• Contribute to refining Client’s Business Intelligence and architecture standards established by Enterprise Architecture in order to produce quality artifacts.
• Works with business partners from multiple Delivery centres/business areas to reach agreement for future state architectural direction
• Creation of Business Artifacts required by the development teams for design and Documentation purpose.
• Involved in gathering and creating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery team for many big data movement projects within State Farm.
• Worked on Design, Development and Implementation of Data movement effort for moving huge Claims data from DB2 tables lying in d ata warehouse to Analytics environment for Predictive Analytics . Accomplished this effort using IBM HPUexport to unload data from DB2 tables and then loading into Aster NCluster using NCluster load scripts .

Activity Management

Responsibilities:

• Facilitates the rigorous identification and documentation of Activity Management BI/Data Management architecture by participating in a variety of activities to meet Client’s needs.
• Gathering and document requirements for Analysing business needs and design appropriate data architecture and roadmap.
• Coordinating and executing the transition and ongoing management of business architecture
• Provides support of business architecture vision and direction, providing communication and education
• Develops execution level architecture and communicates business needs to execution efforts.
• Contribute to refining Client’s Business Intelligence and architecture standards established by Enterprise Architecture in order to produce quality Artifacts
• Works with business partners from multiple Delivery centres/business areas to reach agreement for future state architectural direction
• Creation of Business Artifacts required by the development teams for design and
• Documentation purpose.
• Involved in gathering and creating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery team for many big data movement projects within State Farm.
• Worked on Design, Development and Implementation of Data movement effort for moving huge Claims data from DB2 tables lying in data warehouse to Analytics environment for Predictive Analytics. Accomplished this effort using IBM HPUexport to unload data from DB2 tables and then loading into Aster NCluster using NCluster load scripts .

Associate Register

Responsibilities:

• Facilitates the rigorous identification and documentation of Activity Management BI/Data Management architecture by participating in a variety of activities to meet Client’s needs.
• Gathering and document requirements for Analysing business needs and design appropriate data architecture and roadmap.
• Coordinating and executing the transition and ongoing management of business architecture
• Provides support of business architecture vision and direction, providing communication and education
• Develops execution level architecture and communicates business needs to execution efforts.
• Contribute to refining Client’s Business Intelligence and architecture standards established by Enterprise Architecture in order to produce quality Artifacts
• Works with business partners from multiple Delivery centres/business areas to reach agreement for future state architectural direction
• Creation of Business Artifacts required by the development teams for design and
• Documentation purpose.
• Involved in gathering and creating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery team for many big data movement projects within State Farm.
• Worked on Design, Development and Implementation of Data movement effort for moving huge Claims data from DB2 tables lying in data warehouse to Analytics environment for Predictive Analytics. Accomplished this effort using IBM HPUexport to unload data from DB2 tables and then loading into Aster NCluster using NCluster load scripts

Property and Casualty

Responsibilities:

• Facilitates the rigorous identification and documentation of Activity Management BI/Data Management architecture by participating in a variety of activities to meet Client’s needs.
• Gathering and document requirements for Analysing business needs and design appropriate data architecture and roadmap.
• Coordinating and executing the transition and ongoing management of business architecture
• Provides support of business architecture vision and direction, providing communication and education
• Develops execution level architecture and communicates business needs to execution efforts.
• Contribute to refining Client’s Business Intelligence and architecture standards established by Enterprise Architecture in order to produce quality Artifacts
• Works with business partners from multiple Delivery centres/business areas to reach agreement for future state architectural direction
• Creation of Business Artifacts required by the development teams for design and
• Documentation purpose.
• Involved in gathering and creating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery team for many big data movement projects within State Farm.
• Worked on Design, Development and Implementation of Data movement effort for moving huge Claims data from DB2 tables lying in data warehouse to Analytics environment for Predictive Analytics. Accomplished this effort using IBM HPUexport to unload data from DB2 tables and then loading into Aster NCluster using NCluster load scripts

Confidential, USA

ETL Informatica Lead Developer

• Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer
• Used various transformations in Informatica
• Done data cleansing and aggregation while transformation
• Done performance tuning in Informatica
• Done Error Handling and debugging using Informatica debugger

Confidential

ETL Informatica Developer

Responsibilities:

• Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer
• Used various transformations in Informatica
• Done data cleansing and aggregation while transformation
• Done performance tuning in Informatica
• Done Error Handling and debugging using Informatica debugger