SUMMARY:

• Around (9) years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities.
• Have RDBMS concepts experience in Oracle 9i/8i/7.x, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2000/2005/2008.
• Sound Knowledge in Data warehousing concepts like Bill Inman Methodology, Ralph Kimball Methodology, Star Schema, Snow Flake Schema, OLAP, ROLAP, MOLAP, HOLAP, EDW, Data marts, Normalization, Dimensions, Facts,
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.6.1/8.6.1/8.1/7.1/6.2/6.1, OLTP, OLAP.
• Expertise in working with relational Databases i.e. Oracle 8/9i, DB2 UDB, Sales force
• Experienced in Error Handling and Troubleshooting Techniques using various log files.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services etc
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 8/9i with database objects like triggers, stored procedures, functions, packages, views, indexes.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts. Collaborated onsite teams, interacted and well managed various offshore teams.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Data Warehousing/ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II,Data Flux, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Databases: Oracle 9i/8i, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000,SQL Server,Postgress,DB2,Teradata

Data Modeling: Star Schema and Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x

Tools: MS Office 97/2000/professional, SQL*Plus 3.3/8.0, TOAD,Microsoft Visio, Putty, Text Pad, .csv files, Erwin, ER Model, Salesforce Integration.

OLAP Tools: Business Objects X1R2

Programming Languages: Unix Shell Scripting, Oracle PL/SQL (Stored Procedures, triggers, Indexes).

Environment: Windows 98/2000/2003/ XP/NT and Windows NT, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact with the requirements team and designers to get a brief knowledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Extract data from flat files, DB2 and to load the data into the DB2 database.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Incremental extraction using CDC MD5 function
• Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded
• Worked with slowly changing dimension, Type1,Type2
• Designed and Developed Custom Mappings, Workflows
• Responsible for performance tuning at Mapping level, Session level, Source and Target level.
• Create and execute test cases
• Report the identified defects using Trac tool
• Keep track of the reported defects and support other teams to resolve defects
• Used control-m tool to schedule the jobs.

Environment: Informatica Power Center 9.1, UNIX,DB2 Database, Oracle, SQL*Loader, TOAD, Unix

Confidential, Boca Raton, FL

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact with the requirements team and designers to get a brief knowledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Extract data from flat files, Oracle and to load the data into the Oracle database.
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
• Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Loading data from various data sources and legacy systems in Teradata using FASTEXPORT, MULTI LOAD, FASTLOAD
• Refreshed the data by using fastexport and fastload utilities..
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Worked with slowly changing dimension Type2
• Worked on XML files using XML Transformations.
• Designed and Developed Custom Mappings, Workflows
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Prepare test data for positive and negative test scenarios as per the business requirements
• Create and execute test cases
• Report the identified defects using Trac tool
• Keep track of the reported defects and support other teams to resolve defects
• Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync

Environment: Informatica Power Center 9.1, UNIX,Teradata, SQL*PLUS, SQL*Loader, TOAD

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact with the requirements team and designers to get a brief knowledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Extract data from flat files,DB2 and to load the data into the SalesForce database.
• Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Prepare test data for positive and negative test scenarios as per the business requirements
• Create and execute test cases
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Validating source data and Target data usnig Data Flux
• Report the identified defects using Trac tool
• Keep track of the reported defects and support other teams to resolve defects
• Validate the data in source and target systems using SQL queries

Environment: Informatica Power Center 9.1, DB2, SQL, UNIX, Control-M, Data Flux, Salesforce Database, Unix

Data Integration Specialist/ ETL Developer

Responsibilities:

• Proposed enhancements and changes to the technical and business solution to meet the new requirements.
• Estimated Efforts accurately & actively worked with PM’s in completing the project plan.
• Engaged with external vendors to develop a new Highly Available Open systems platform for the customer to support new applications (Master) and move data from the existing platforms(read-only) into the HA environment.
• Shared & provided details about all Design & Transformation rules document with Offshore & guided them to build the necessary components. Worked with offshore team members to prepare Coding Standards, ETL Specification & Test case documents template.
• Worked with new ETL tools to decide which would be the most suited for all of the upcoming data conversion projects. Focus here was mainly to cut down licensing and maintenance costs by moving to open source tools suite (where ever possible, without compromising on any of the main criteria)
• Conducted Proof of Concept/ Technology and created Architectural Design Documents (ADDs).
• Assisted Project Business Analysts by providing key Design & Data mapping inputs for documenting the FSD. Involved in QA Test plan & Test case review meetings. Worked with Release Management team in migrating the components to QA environment for QA testing. Provided necessary technical assistance in fixing the QA defects.
• Designed patterns for Data movement and Transformation. Here factors such as data replication, synchronization, availability for real time/initial load and batch processing played a key role. Designed the patterns for Data Replication and Data Synchronization of Master and Slave (read - only type) data.
• Lead the effort to implement Cloud functionality (Sales force) using Informatica Power Center for data movement and transformation (read and write) data to cloud from DB2 and PostgreSQL.
• Drove an effort on Web Service interaction with Informatica Power Center 9.1 using a WSDL and SOAP UI client.
• Created data maps for Change Data Capture (CDC) for db2 capability using Informatica MD5 function
• Lead an effort for using Power Center mappings for XMLs.
• Used Performance tools to Measure /Monitor Performance of the ETL jobs and loader utilities (EDB loader).
• Automated scripts for Enterprise Database Loader (similar to Oracle’s PL/SQL).

ETL Informatica Developer

Confidential

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked with relational databases like Oracle.
• Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Worked with Source qualifier override, lookup override for customizing the SQL queries.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Implemented Type 1 and Type 2 Slowly changing dimensions for Dimension and Fact loads.
• Responsible for performance tuning at Mapping level, Session level, Source and Target level.
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
• Responsible for Unit Testing of Mappings and Workflows.
• Worked closely with reporting team and helped them whenever they had any ETL issues
• Responsible for creating and running the batch jobs in UNIX.
• Tested Mappings using Debugger.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Responsible for Production support, maintained the standard SLA in resolving the production failures.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Manager, Workflow Monitor), Oraclel, Flat files, Windows XP Professional

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked with relational databases like ORACLE 9i.
• Developed mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Worked with Source qualifier override, lookup override for customizing the SQL queries.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Implemented Type 1 and Type 2 Slowly changing dimensions for Dimension and Fact loads.
• Responsible for performance tuning at Mapping level, Session level, Source and Target level.
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Responsible for Unit Testing of Mappings and Workflows.
• Worked closely with reporting team and helped them whenever they had any ETL issues
• Responsible for creating and running the batch jobs in UNIX.
• Tested Mappings using Debugger.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Manager, Workflow Monitor), Oracle9i, SQL, Toad 9.7.2,Mapplets, Repository, UNIX, Flat files, Windows XP Professional

Confidential, Chicago, IL

Business Objects X1R2

Responsibilities:

• Actively involved in gathering requirements from business users, involved in modifying various technical & functional specifications in the development.
• Designed, developed Universes and Webi Reports.
• Worked with health payer related data such as customers, policy, policy transactions, policy coverage, claims.
• Generated weekly and monthly report status for the number of incidents handled by the support team.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL
• Extensive PLSQL Programming with design and development of physical and logical data model using ERWIN.
• Created web reports through report template in Web Application Designer.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
• Handled complex functions like @Prompt, @Select and @Where in the designer
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data. Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Business Objects XIR2 Designer, Web Intelligence, Info view, Oracle 10g, SQL, PL/SQL, TOAD 10.5, UNIX Shell Scripting, Windows XP, WinSCP.

Confidential, San Antonio, TX

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the user requirements and converting the same into technical specifications
• Responsible for designing of transformations, mappings, and workflows to implement the business logic.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy
• Worked on loading techniques like slowly changing dimensions and incremental loading for extraction, transformation, and loading of the data.
• Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override in the Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Created Connected and Unconnected lookup transformation to get the related values.
• Responsible for Performance tuning of sources, targets, mappings and SQL queries in the transformations
• Created reusable transformations and used in various mappings.
• Responsible for error handling using logs

Environment: Informatica Power Center 7.1,Oracle, SQL, DB2 UDB, Windows XP