SUMMARY:

• More than 8 years of IT experience in Data Warehousing technology in Informatica.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support.
• Extensive experience in Informatica ( 9.6.1/9.5.1 ) applications. Designed and developed the Workflows, Worklets, Mappings and Sessions.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked on documentation of Design requirements, Test data, Data movement schema and Mapping between applications.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Extensively used Slowly Changing Dimension (SCD) technique in banking application.
• Conducted Unit tests, Integration tests and Customer Acceptance tests.
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Production support experience. Extensive understanding of Production issues and Data issues.
• Excellent communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.

TECHNICAL SKILLS:

Languages-: C, C++, SQL, PL/SQL, XML, UNIX

Etl tools: Informatica Power Center 9.6.1/9.5.1 / Power Mart 8.x/7.x

Databases-: Oracle 11g/10g, MS SQL Server, DB2

Development Tools-: Microsoft Visual Studio, Dream. Weaver.

Drafting Tools-: Visio, Erwin

Office Suite-: MS Word, MS Power Point, MS Excel,Ms Access

Environment: -: Sun Solaris, UNIX, WINDOWS XP

Scripting Languages-: : VB Script and UNIX Shell Scripting

DB Tools-: SQL*PLUS, SQL*LOADER,TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Informatica Developer

Tools and Technologies used: Informatica Power center Designer 9.6, Workflow Manager, Workflow monitor, Autosys Scheduler, Repository manager, Oracle 11g, Toad, SQL *Loader, SQL, PL/SQL, UNIX, Shell script, Visio, Quality Center 9

Roles & Responsibilities:

• Converted business requirements into technical documents - Business Requirement Document, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and Sql Server, IBM DB2, XML files.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, Index Cache, Data Cache and incremental aggregation.
• Worked on complex Informatica Mappings for Household dimension, Multi valued dimension and Point in time dimension.
• Utilized Quality Center 9 web based test management tool to keep track of all the releases, requirements, test plans, labs and defects.
• Extensively worked on Integration testing and User Acceptance Testing (UAT). Reviewed UAT with business users.
• Utilized Autosys to schedule all the jobs and closely worked with the production team.

Confidential, CT

Informatica Lead

Responsibilities:

• Understand the business functionalities of XLRe Latin America, Greenwich Insurance Company, Indian Harbor Insurance Company, XL Europe Ltd and XL Singapore-Sydney OBU’s data and convert them into Destiny Application based on Destiny Business rules.
• Extract the data from RSG application to staging area through flat files and Tables.
• Upload the data from staging area into Destiny database.
• Implemented Dashboards Analytics using Business objects Performance manager.
• Extract the data from RSG application to staging area through flat files and Tables.
• Developed stored procedures for generic values instead of using the sequence generator transformations.
• Involved in the Software Development Life Cycle.
• Converted different Line of Business: XL Property, XL Casualty, XL Excess of loss based on business rules.
• Involved in supporting the project and resolved production issues.
• Work closely with database administrators and reporting team to ensure data is refreshed for each cycle and balancing the reports of converted data.
• Involved tuning the session performance by using various techniques.
• Used Autosys for Scheduling Informatica batch and stand alone sessions with different jobs.
• Created Web Intelligence reports with dynamic objects that are linked to the values those are returned from the database.
• Attended web conference with Business Objects.

Environment: Windows2010, Business Objects XIR2/6.x, WEBi, Crystal Reports, LDAP, Informatica PowerCenter 9.6.1/9.5.1, Autosys, SQL Server, Documentum, Defect Track tool.

Confidential, Burlington, MA

Informatica Developer

Responsibilities:

• Involved in designing of Informatica mappings by translating the business requirements.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner.
• Crated Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter Files, round robin and Key range Partitioning.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Handled Business objects Connectivity, migration, authentication and security.
• Involved automating retail prepaid system process. Created packages and dependencies of the processes.
• Prepared common issues in Business Objects XI and published to Confidential Wiki page to view across all users.
• Involved in support, maintaining, enhancing and developing new interfaces for Confidential application.

Environment: Informatica Power Center 9.6.1/9.5.1, Business objects XIR2/6.5, Oracle 11g, Netezza, Win SQL, UNIX, Autosys, CVS and Test Tracker

Confidential, Waukesha, WI

Informatica Developer

Tools and Technologies used: Informatica Power center Designer 9.1, Workflow Manager, Workflow monitor, Repository manager, Oracle 11g, SQL *Loader, SQL, PL/SQL, Shell script, Visio, Test Director 7.x.

Roles & Responsibilities:

• Worked on enhancement and version upgrade projects in Informatica 9.1, Webmethods and IBM crossworlds.
• Extensively worked on Debugging, root cause analysis and fixing defects with testing team for Production Informatica applications used Test Director 7.x to track all the defects.
• Worked on Performance tuning like increasing index, data caches for lookup and aggregation transformation and having verbose performance log for testing purpose.
• Participated in change control reviews to code changes that go into production, used Comparison utility tool by Informatica to compare the code.
• Worked extensively in Production support environment. Extensive understanding of production and data issues.
• Maintained 99% of uptime of ETL silver, gold and platinum servers during quarter close.
• Resolved high severity production issues relating to Platinum applications.
• Worked extensively in production support 24x7 in war rooms/command center and on call during quarter close.
• Worked on middleware and ETL support process integration and knowledge transfer for GEHC and Amersham applications.
• Developed shell scripts for automating system maintenance issues saving 1 hour per month of cycle time.
• Identified and documented all the critical information of the design so that future users are facilitated.
• Participated in knowledge transfer of new applications in Informatica, Webmethods and IBMcrossworlds application.

Confidential, Pittsburgh, PA

DW Informatica developer

Tools and Technologies used: Informatica Power Center 9.1, Informatica Power Connect, OLAP, Oracle 11g, MS SQL Server, IBM DB2/400, Sybase, Flat files, PL/SQL, SQL, SQL*Loader, Erwin 3.5, Toad 7.0,, HP-UX, and Unix Shell Scripting.

Roles & Responsibilities:

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping &Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Developed PL/SQL procedures/packages to load the data into Oracle 9i. Tuning Informatica Mappings and Sessions for optimum performance.
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for ETL process under development, test and production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.