PROFESSIONAL SUMMARY

• 12 Years of IT experience in analysis, design, development and implementation of Business Intelligence solution using Data Mart/Data Warehousing Design, ETL, OLAP, Client/Server and web application on Unix and windows platform in various domains such as Health Care, Pharmaceuticals, Insurance, Finance, Travel and Retail

• 3 Years of extensive experience in Informatica 9.5.1/9.1.0/8.6, Informatica Data Quality, Informatica B2B Data Transformation Studio, Informatica Data Exchange 9.1.0/9.5.1, Managed File Transfer MFT , HL7 9.1.0 Libraries, EDI X-12 9.1.0 Libraries, HIPAA 9.1.0 Libraries Installation and Configuration on Linux, AIX and Window's servers Cloud environment, Dev. Prod servers environment setup, creating user id's and granting user level permissions, Folder's Creation, setup Source Target database connections, Administration, Code Migration, Informatica Architecture design for various brand new Health care clients

• 8 Years of experience in loading and maintaining Data Warehouses and Data Marts by using Informatica 9.5.1/9.1.0/8.6/8.5.1/7.1/6.2/5.1, Epic Clarity Database summer2009/2010, McKesson Star Database, Cache Database, ECHO, Premier, SIS data subset, Oracle 11g/10g/9i/8i, DB2, SQL Server 2008, SAP R/3, Teradata V2R12, Netezza 7.0

• 2 Years of extensive experience in Informatica 9.5.1/9.1.0/8.6, Informatica B2B Data Transformation Studio, Informatica Data Exchange 9.1.0/9.5.1, Managed File Transfer MFT , HL7 9.1.0 Libraries, EDI X-12 9.1.0 Libraries, HIPAA 9.1.0 Libraries Installation and Configuration, Administration, Code Migration, Informatica Architecture design for various brand new Health care clients

• 2 Years of Data modeling experience using Dimensional Data modeling, Star/Snowflake Schema modeling, Physical Logical data modeling by using Erwin

• 2 Years of Business Intelligence experience using Business Objects XIR3/6.5/5.1 Designer, Business Objects and Migration and OBIEE 11g

• Experienced in Data Extraction, Transformation, and Loading ETL from disparate Data sources like Multiple Relational Databases Oracle, Teradata, SQL Server, DB2, SAP R/3, SAP BW and Worked on integrating data from flat files and CSV files into a common reporting and analytical Data Model using Informatica

• Expertise in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets, Debugging and Performance tuning of Informatica Mappings and Sessions

• Extensive experience in Offshore and Onsite model. Received good Customer feedback for timely delivery and fulfilled the customer expectations

• Experience in Write High Quality SQL's, Stored Procedures, Functions and SQL Loader scripts as per client business requirements.

• Handled critical job failures in the production environment and Involved in fixing the data issues in the EDW database.

• Hands on experience in Agile Methodologies, Software Development Life Cycle SDLC , Quality Assurance Life Cycle

• Used Calculations, Variables, Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports

• Experience in analyzing, designing, developing Universes and Created different types of Business Objects reports

• Experience in Unix Shell Scripts to support data warehousing tasks and Exposure on Perl Scripting

• Expertise in the System integration testing, Regression testing and User acceptance testing for Data warehousing Applications ETL and OLAP

• Strong analytical, presentation, problem solving and excellent inter-personal communication skills and flexible to learn new technologies in the IT industry towards company's success

TECHNICAL SKILLS PROJECT EXPERIENCE DETAILS

Confidential

Sr Informatica Administrator/ETL Consultant

Roles Responsibilities:

• Installed and Configured Informatica 9.5.1 version on Linux 2.6.32 and Windows 2008 Prod and Test server's
• Involved in setting up Informatica test and prod environment's for new CDW project
• Created Shared folders, folders for different subject areas to start new development work
• Created users and assigned different roles for Informatica team
• Created Informatica coding standard and best practices document for new Implementations
• Responsible for Business Analysis and Mapping documents creation and involved in Designing Technical Specification
• Actively paricipated in daily scrum meetings and also all clients projects implemented in agile methodologies
• Involved in various KAP sessions with SME's to understand the existing McKesson Star Health care database system
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Extensively used Informatica to create Flat files from Clarity Database and Loaded data into HCD Appliance database
• Created several complex mappings as per business requirements by using Informatica
• Handled critical data bottlenecks and Informatica mapping bottlenecks while loading data into HCD Appliance
• Involved in Code Reviews and Unit testing
• Migrated mappings from Development to Testing and Testing to Production and also automated job scheduling on production environment
• Conducted various Informatica seession with cleint ETL team to bring them upto seepd and also participated in HCD knowledge presenation's in client's kickoff meetings
• Involved in 24/7 Informatica Administration porduction support and handled critical issues
• Trouble shooted users data issues and created adhoc reports to verify it
• Created SFTP script from HCD Informatica sever to HCD appliance server

Environment: Informatica 9.5.1, Informatica B2B Data Transformation Studio, Informaica Data Exchange 9.1.0,Oracle11g, McKesson Star Database, truven files,LINUX 2.6.32, Windows XP, Flat Files, Cache Database, Oracle SQL Developer 2008, Erwin 9.0, OBIEE 11g and Business Objects XIR3

Confidential

Sr Informatica Consultant

Roles Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Extensively used Informatica to load data from Flat Files to Oracle, Oracle to Flat Files
• Strong experience in creation of tab delimited files with counts for specified sub totals and totals
• Involved in the creation and maintenance of the logical and physical data model
• Created several complex mappings as per business requirements by using Informatica
• Worked on Informatica Power Center 8.6 tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, Transformations, Work Flow Manager Task Developer, Worklets and Work Flow Designer and Work Flow Monitor
• Created reusable transformations and Mapplets and used them in complex mappings
• Created Complex SQL's, Stored Procedures and Functions to support ETL process
• Used for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Participated in full life cycle of the project
• Migrated mappings from Development to Testing and Testing to Production
• Involved in Code Reviews
• Involved in the Backend testing for Data Warehousing Applications
• Performed Unit Testing and Integration Testing and tuned for better performance
• Involved in production support and expertise in trouble shooting the application
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, Mainframe Analysts, external vendors, marketing group and business users in the process of recovery
• Expertise in fixing the critical data issues in production EDW database

Environment: Informatica 8.6, Oracle10g, UNIX 3.0, Windows XP, Flat Files, ESP workstation 4.5.1, HP OpenView service desk 4.5 client, IBM DB2, Seibel, Mainframe files, SQL Server 2005, TOAD, CRT 4.1, MicroStrategy8.0, OCS website, marimba, Erwin and Autosys

Confidential

Sr ETL/BI Consultant

Roles Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Created Physical Star/Snowflake schemas for Mass Mutual Financial data warehouse system
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Extensively used Informatica to load data from Flat Files to Oracle, Oracle to Flat Files
• Strong experience in creation of tab delimited files with counts for specified sub totals and totals
• Involved in the creation and maintenance of the logical and physical data model
• Created several complex mappings as per business requirements
• Worked on Informatica Power Center 8.5.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, Transformations, Work Flow Manager Task Developer, Worklets and Work Flow Designer and Work Flow Monitor
• Created reusable transformations and Mapplets and used them in complex mappings
• Created Complex SQL's, Stored Procedures and Functions to support ETL process
• Used for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Migrated mappings from Development to Testing and Testing to Production
• Involved in Code Reviews
• Performed Unit Testing and Integration Testing and tuned for better performance
• Involved in the Backend testing for Data Warehousing Applications
• Involved in production support and expertise in trouble shooting the application
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, Mainframe Analysts, external vendors, marketing group and business users in the process of recovery
• Expertise in fixing the critical data issues in production EDW database
• Participated in full life cycle of the project

Environment: Informatica 8.5.1, Teradata V2R6, Oracle10g, UNIX 3.0, Windows Server 2003, Flat Files, ESP workstation 4.5.1, HP OpenView service desk 4.5 client, IBM DB2, SAPR3/BW, Mainframe files, SQL Server 2005, TOAD, CRT 4.1, OCS website, marimba, Cognos ReportNet, Erwin

Confidential

Sr ETL Consultant

Roles Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Extensively used Informatica to load data from Flat Files, XML files to Oracle, Oracle to Flat Files and Mainframe to Oracle
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations
• Configured, installed Power Center Connect for SAP, data accessed from SAP Master Data MD app server, integration using ABAP, BCI and data to SAP systems using ALE/IDOCS and BAPI integration with stream modes and file modes
• Created several complex mappings as per business requirements
• Worked on Informatica PowerCenter 8.5.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, Transformations, Work Flow Manager and Work Flow Monitor
• Created Complex SQL's, Stored Procedures and Functions to support ETL process
• Created reusable transformations and Mapplets and used them in complex mappings
• Used for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Participated in full life cycle of the project
• Migrated mappings from Development to Testing
• Involved in Code Reviews
• Involved in production support and expertise in trouble shooting the application
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, Mainframe Analysts, external vendors, marketing group and business users in the process of recovery
• Involved in the Backend testing for Data Warehousing Applications
• Performed Unit Testing and Integration Testing and tuned for better performance
• Developed Reports, Charts, Drill through Reports, and Master Detail Reports, Cross Tab Reports using Report Studio
• Involved in production support and expertise in trouble shooting the application
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, Mainframe Analysts, external vendors, marketing group and business users in the process of recovery
• Expertise in fixing the critical data issues in production EDW database
• Used union set, query reference objects to join multiple queries in cross tab ReportNet report
• Created models and published packages thru Framework Manager
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document

Environment: Informatica Power Center 8.5.1 Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor , Power Exchange, DB2, Teradata V2R6,Oracle 9i, Flat Files, XML/XSL files, Autosys, Cognos 8.2, SQL, PL/SQL, Windows XP, UNIX, Erwin

Confidential

ETL Consultant

Roles Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Involved in creation of logical and physical citigroup sales data mart
• Extracted data from Flat files, Oracle8i and SQL Server loaded into EDW data base by using Informatica
• Designed and developed complex Expression, Look up, sequence generator, Source qualifier, Aggregator, Stored procedure, joiner rules business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL Power Center tool
• Creating and configuring folders, users and user groups using Informatica Repository Manager
• Writing SQL's and Stored procedures to customize the ETL operations in Informatica
• Created sessions, database connections and batches using Informatica Workflow Manager
• Creation of materialized views to improve query performance on source tables
• Reviewing the Informatica code developed by team and validating design standards and performance issues
• Involved in the Backend testing for Data warehousing Applications
• Paticipated in Code Reviews
• Involved in the preparation on Test Case and Test Script Documents
• Involved in migration from dev Environment to QA and Production
• Involved in production support and expertise in trouble shooting the application
• Participated in full life cycle of the project
• Created Standard reports, Cross-tab reports, Sub Reports and Drill-Down Reports
• Developed BO Universes using Designer and Business Objects for the reporting solution for Operational reporting System
• Used Calculations, Variables, Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports

Environment: Informatica PowerCenter 7.1.3, Oracle 9i, SQL, PL/SQL, SQL Server, Maestro, UNIX, Windows2000, BO XIR2

Confidential

ETL/BI Data Analyst

Roles Responsibilities:

• Analyzed the business requirements and involved in preparation of detailed technical design documents for PBM Daily and PBM Aggregation modules
• Created logical and physical star schema for Walgreen's PBM system
• Extensively used Informatica to load data from source Oracle 8i to target Oracle 10g data base
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations etc.,
• Worked on Informatica Power Center 7.1.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, Transformations, Work Flow Manager Task Developer, Worklets and Work Flow Designer and Work Flow Monitor
• Involved in SQL Performance tuning using Explain plan, TK Proof and Hints
• Migrated mappings from Development to Testing environment
• Involved in production support and expertise in trouble shooting the application
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, Mainframe Analysts, external vendors, marketing group and business users in the process of recovery
• Involved in the Backend testing for Data Warehousing Applications
• Involved in Unit testing, Integration testing, System testing and code reviews
• Created various documents such as Unit test cases and data migration documents
• Updated wrapper scripts as per current requirements
• Developed Reports, Charts, Drill through Reports, and Master Detail Reports, Cross Tab Reports using Report Studio
• Used union set, query reference objects to join multiple queries in cross tab ReportNet report
• Created models and published packages thru Framework Manager

Environment: Informatica PowerCenter 7.1.1 Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor , Oracle 9i, Autosys, SQL, PL/SQL, Windows XP, UNIX, Cognos ReportNet 1.1

Confidential

ETL Data Analyst

Roles Responsibilities:

• Developing detailed ETL specifications based on business requirements
• Involved in creation of logical and physical data model
• Used Informatica Designer to create complex Mappings and Mapplets

• Extensively used transformations like Router, Aggregator, Lookup, Source qualifier, Joiner, Expression and Stored Procedures in extracting data in compliance with the business logic developed

• Creation and Modification Of informatica Mappings
• Creating TD macro's for loading the data from staging to target tables
• Creation and Testing Informatica Mappings and Workflows
• Monitoring and performance tuning of ETL mappings
• Involved Creation of Merge SQL's to improve the performance
• Used heterogeneous data sources like Oracle and flat files

• Performed data validation with predefined test scripts or criteria as per the requirement from development or testing coordinator

• Involved in Code Reviews
• Involved in the preparation on Test Case and Test Script Documents
• Involved in migration from dev environment to QA and Production
• Extensively used PL/SQL and SQL

Environment: Informatica6.2, Oracle, Teradata, Flat Files, Toad, Appworx, UNIX, Windows XP, Microsoft Office and Business Objects

Confidential

ETL Developer

Roles Responsibilities:

• Understanding the Requirement Specifications

• Maintaining source definitions, transformation rules and targets definitions using Informatica repository manager
• Using Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target

• Extracting order entry data, product and revenue data from Oracle using Informatica

• Designing and developing the filter, Joiner, lookups and Aggregator transformations that are used in mappings

• Creating and executing sessions and batches using Server Manager
• Performance tuning and Error handling of Informatica mappings

• Developed BO Universes using Designer and Business Objects for the reporting solution for Operational reporting System
• Used Calculations, Variables, Sorted inputs, Drill down, Slice and Dice
• Generated reports using Business Objects
• Extensively used PL/SQL and SQL

Environment: Informatica 6.0, Business Objects 5.1, Oracle, DB2, flat files, CSV files, UNIX, Toad, Windows NT and Microsoft Office

Confidential

ETL Data Analyst

Roles Responsibilities:

• Involved in reviewing functional and Technical design document
• Source data analysis and designing of the mappings

• Involved in analyzing the sources, transforming the data, mapping the data and loading the data into
• Targets using Informatica
• Involved in creating mappings

• Used various components like source qualifier, join, filter, lookup, update strategy and sequence generator

• Creation of materialized views to improve query performance on source tables
• Involved in preparation of test cases, unit testing and code reviews
• Analyzing UNIX shell scripts and modify according to current requirement
• Handled small and large modifications in Enhancements
• Monitoring the Warehouse Load and fixing the Load issues
• Extensively used PL/SQL and SQL

Environment: Informatica5.1, UC4, Bugzilla, Oracle, PL/SQL, flat files, CSV files, UNIX, Windows2000