SUMMARY

• Eight (8) 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.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 in developing Finance domain.
• 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: Informatica PowerCenter 9.x/8.x/7.x/6.x, Power Exchange, ETL, ETI, Data mart, OLAP, OLTP, Mapplets, Transformations, Control M, IDQ, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Dimensional Data Modeling and Relational Data Modeling using, Star Join Schema/Snowflake modeling, FACT & Dimension tables

Business Analysis/Data Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office, Visio.

Database: SQL Server 2008/2005, Oracle, SQL*Loader, Teradata

Programming: SQL, PL/SQL, T- SQL, C, Unix Shell Scripting.

Environment: Windows NT/XP/2003, Unix, Sun Solaris, MS-Dos.

Reporting Tools: Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr Informatica Developer

Responsibilities:

• Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
• Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices.
• Produce detail design document, low level design document and involved in code/document review. Participated in the maintenance and enhancement of the application and perform bug fixing.
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.5.1.
• Worked with PowerCenter Designer tools in developing mappings and mapplets to extract and load the data from various sources.
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance.
• Extensively used ETL to load data from Flat Files, Oracle and Teradata to Teradata.
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor.
• Incremental extraction using CDC MD5 function.
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Worked with slowly changing dimension, Type1, Type2.
• Worked with Pre-Session and Post-Session SQL scripts.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Created Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Modified Workflows and Mappings to accommodate the new features of log files in Informatica
• Modified Shell Scripts to facilitate the implementation of Informatica Upgrade Project.

Environment: Informatica-Power Center 9.5.1,Oracle 10g, Flat Files, SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, LINUX v 2.4.36,SecureCRT 4.1.0,Control-M 7.0 and Windows NT

Confidential, Insurance, 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.
• Worked on several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• 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.5.1, DB2, SQL, UNIX, Control-M, Data Flux, Salesforce Database, Unix

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• Reviewed Functional Requirement Documents (FRD) and Technical Specifications Documents (TSD) and communicated with the concerned users. Conducted Impact and feasibility analysis.
• Worked on Subject Areas like MEMBERSHIP, CLAIMS and PURCHASES.
• Played Key Role in Integrating Data from Ameri Group into EDW.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Involved in designing mappings using Mapping Parameters and Mapping Variables.
• Used Informatica Debugger for debugging mappings.
• Implemented Slowly Changing Dimensions - Type II mappings as per the requirements.
• Successfully Loaded Data into different targets from various source systems like Flat files, SQL Server into the target database Oracle and Flat files.
• Created views, functions and stored procedures as per the requirements and debugged them.
• Involved in Unit testing of database objects such as views and stored procedures.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used Informatica Workflow Manager to create workflows.
• Worked with Pre-Session and Post-Session SQL scripts.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Workflow Monitor was used to monitor and run workflows.
• Involved in production support which also includes trouble shooting issues.
• Worked closely with testing team and assisted them in creating test cases.
• Involved in designing mappings with Mapping Parameters and Mapping Variables.
• Worked with DBA to fine tune SQL queries for better performance.
• Created deployment groups for deploying the mapping from one environment to another.

Environment: Informatica-Power Center 9.0.1, 9.5.1, Intormatica Data Explorer, Power Exchange, Metadata Manager, Web Services, Oracle 10g, Teradata V13.10, WLM Scheduler

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements from business users, involved in modifying various technical & functional specifications in the development.
• Extensively involved in developing ETL code using Informatica in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Used Source Analyzer and Warehouse designer to import source and target elements, then Informatica powercenter designer to create complex mappings based on Business requirements.
• Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly incremental data loads.
• Created Mappings, Mapplets, Sessions and Workflows using Informatica Power Center 8.6.1
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Developed Datamaps from Mainframe systems and COBOL copy books using Informatica Powerexchange.
• 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.
• Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
• Used Control-M as Third Party Scheduling tool.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Involved in unit testing of mappings, mapplets also involved in Parallel Testing.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL, PL/SQL, TOAD 10.5, UNIX Shell Scripting, Informatica Power Center 8.6, Informatica PowerExchange, Windows XP, Control-M, WinSCP, Mainframe

Confidential, PA

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 InformaticaPowerCenter 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 PowerCenter 8.6.1, Oracle, SQL, DB2 UDB.

Confidential

Informatica Developer

Responsibilities:

• Requirement analysis in support of Data Warehousing efforts.
• Designing and customizing data models for Data Warehouse supporting data for multiple sources on real time.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Maplets Designer and Transformations Developer.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Created various data marts from data warehouse and generated reports using Business Objects.
• Involved in extraction, transformation and loading of data into Oracle database from sources like flat files, Excel Files.
• Involved in the business requirements gathering and analysis.
• Created complex workflows and worklets using Informatica 8.6.1 workflow manager
• Created different transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator.
• Scheduled sessions and batches on Informatica server using Informatica server manager.
• Created events and tasks in the work flows using workflow manager.
• Used workflow manger and work flow monitor to run and monitor jobs.
• Involved in unit testing of mappings, mapplets and sessions.
• Used Parameter files for multiple DB connections for the sources.
• UsedWorkflow Managerfor creating and maintaining the Sessions. AdministratedWorkflow Managerto run Tasks and Worklets.
• Responsible for migrating projects between multiple environments.
• Developed the deployment documents, release notes and deployed the code in production.
• Responsible for migrating projects between multiple environments.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Teradata, UNIX Shell Scripting, SQL, PL/SQL, Toad, SQL*Loader, SQL Server.