Summary of Qualifications:

• Over Eight 8 years of SDLC experience in Data warehousing with extensive knowledge on Informatica 8.x, 9.x ETL tool and Business Objects XI R2 Reporting tool.
• Having strong conceptual knowledge in Data Warehousing, Extensively used ETL methodology for supporting Data Extraction, Transformation Loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Extensive knowledge on Informatica Master Data management MDM , Informatica Data Quality IDQ .
• Extensively worked on Informatica PowerCenter Designer, Workflow Manager, and Workflow Monitor. Implemented Various Performance Tuning techniques on Mappings.
• Worked on Production support Environment and extensively worked on Control-M Scheduling tool.
• Worked on different phases of data warehouse development lifecycle, from gathering requirements t testing and implementation.
• Thorough knowledge on Data warehouse Concepts like Star, Snow Flake Schemas and good understanding on Data warehouse architecture.
• Having functional experience in design, analysis and development of Universe, Creating classes and objects as per the business requirements using Universe designer.
• Involved in the Preparation, implementation and maintenance of the universe using universe designer.
• Designed and developed reports using Desktop Intelligence, Web Intelligence, and Crystal Reports.
• Extensively used Business objects reporting functionalities such as Sectioning, Grouping, Slice and Dice, Drilling methodology, Filters, alerts, Ranking and Breaks.
• Having extensive knowledge on Dashboard manager and Key Performance Indicators KPI .
• Extensively worked on large database applications and Data marts.
• Extensively worked on Databases like Oracle, DB2, Teradata, and Netezza.
• Good knowledge on writing the PL/SQL Scripts like Procedures, Packages and Functions.
• Testing skills include performing Unit, Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
• Experience in providing On Call 24 7 Support for Production Problem Resolution Resolve Production issues and problems in an expedited manner .
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Worked on preparing Low level, High level design documents along with Release notes Run book.
• Good understanding of Product Life Cycle and Comprehensive Delivery Process's.

Technical Competencies:

• Operating Systems Windows XP/2003/NT, UNIX, Linux
• Languages C , SQL
• Databases GIU DB2, Oracle, Netezza, Teradata, Toad, SQL Developer, Visi .
• Scheduling Tools Control-M, Informatica Scheduler, TWS Tivoli
• Tools Utilities Informatica 8.x, 9.x, IDQ, MDM, Business Objects XI R2, Crystal Reports XI, Dashboard Manager, Xcelsius, Putty, PVCS, SVN, HP Quality Center11

Professional Experience:

Confidential

Role: ETL Developer, Onsite Coordinator Project lead

• ICDW Integrated Customer Data warehouse is an initiative in JP Morgan Chase Retail Financial Services division t move away from the existing technology landscape and its inherent pain areas of an outdated infrastructure's performance, inability t support time-to-market, scalability and lack of support for cross-lob analytical needs. ICDW Development and Support involves the integration of various LOB data int ICDW framework that will be hosted on a new, faster, scalable platform and a data model that will support cross-LOB analytical requirements.
• The source system for this application is flat files. ICDW is having different modules like CUSTOMER, CREDIT, CHANNEL, CIG, CTO, etc. The architecture for this application is Flat file data will comes int STAGE zone then it will goes int Integration and semantic layers IBM BDW Model and then finally we load int different data marts. In each stage the data will be cleansed/transformed as per the requirements.

Roles Responsibilities:

• Involved in doing reverse engineering on existing EDW logic for preparing new mappings in ICDW.
• Leading as an onsite/offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact POC for the offshore team.
• Worked on Teradata TPT loads
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation Connected and Unconnected , Joiner Transformation, and Router Transformation, and Normalizer Transformation in Informatica.
• Interacted DBA team t make sure application data base and als created all necessary data base objects for our project in Dev and Test Environments.
• Als provided all Database Object scripts for DBA team t deploy stage and prod DB environments.
• Created and Configured Sessions, Worklets and Workflows t load the data int target/s using Informatica Workflow Manager.
• Created Mapplets and Reusable Transformations t prevent redundancy of transformation usage.
• Worked as onsite coordinator t transfer work t offshore and made sure the deliveries happen on time.
• Created sessions and workflows for the mappings.
• Involved in performance improvement on the long running jobs.
• Documented the mapping process and methodology used t facilitate future development.
• Prepared the CCR for deploying the code into production
• Involved in requirement gathering meetings with clients.
• Used performance improvement techniques in Informatica for tuning mappings.
• Involved in running the loads t the data warehouse involving different environments.
• Analyzed business information requirements.
• Involved in creating jobs using control M scheduler tool.
• Involved in supporting the production jobs

Environment: Teradata, Informatica 9.5.1, Business Objects XI R2, UNIX

Confidential

Role: Informatica ETL Developer

• Confidential company whose primary operations are originating, servicing and collecting on student loans. With more than 10 million borrowers, the company primarily provides federally guaranteed student loans originated under the Federal Family Education Loan Program FFELP .Sallie Mae Inc. is the corporate management and marketing subsidiary of SLM Corporation
• The purpose of this project is t have the Marketing database loaded with all the customer data from different sources like Arrival, Harte- Hanks and Unica.

Roles Responsibilities:

• Understanding the Business requirements.
• Design ETL processes using Informatica t load data from various data sources t target Data Warehouse.
• Developed mappings using Informatica Power Center for data loading.
• Developed Mapplets using Mapplet designer for usage of reusable.
• Used Informatica Power Center Workflow manager t create sessions, workflows t run tasks.
• Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
• Worked with Slowly Changing Dimensions and Version Controlling.
• Used Informatica Power Center Workflow manager t create workflows and Sessions t run tasks.
• Used Debugger t debug the mappings and used target load order plan for loading data correctly int different Target Tables.
• Participated in weekly meetings with client and discussed all the week days' activities/issues.
• Improved the application performance by fixing bugs in the application.
• Responsible for communicating the support processes within the team and t the customers.

Environment: Netezza, Informatica 8.6.1, Business Objects XI R2, Windows XP

Confidential

Role: Informatica ETL Developer

• The purpose of the Private Credit Collections and Reporting project is t :
• Provide Collections Strategies CS with data needed for Modeling, Analytics and Reporting functions.
• Data will be stored at the loan level in the Enterprise Data Warehouse EDW.
• Provide Private Credit Collections PCCR with data needed for daily Reporting functions.
• Provide data that can be used t calculate metrics which were identified as measurable outcomes that should be tracked.
• The PCCR team expends significant resources maintaining its own SQL Server Database, which is used for reporting and analysis. It uses a variety of file feeds from external systems such as CLASS, Artiva, FACS, Strata, IVR, Collection Agency data, the Dialers and Kronos as input t the DB.

Advantages:

• Provide a central repository for all Collections data.
• Reduce cost through automation of labor intensive maintenance.
• Improve query/report performance significantly by leveraging the Netezza DB Appliance.
• Provide the ability t store more historical data for modeling, analysis and reporting.
• Eliminate redundant data stores.
• Expose Collections data in data mart solutions integrated with Oracle BI front ends to provide robust reporting and analysis capabilities. i.e. Browser based dashboards, guided drill navigation, email alerts, and self-service ad-hoc capabilities
• Provide documentation on data collection processes and elements

Roles Responsibilities:

• Understanding the Business requirements.
• Design ETL processes using Informatica t load data from various data sources t target Data Warehouse.
• Developed mappings using Informatica Power Center for data loading.
• Developed Mapplets using Mapplet designer for usage of reusable.
• Used Informatica Power Center Workflow manager t create sessions, workflows t run tasks.
• Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
• Worked with Slowly Changing Dimensions and Version Controlling.
• Used Informatica Power Center Workflow manager t create workflows and Sessions t run tasks.
• Used Debugger t debug the mappings and used target load order plan for loading data correctly int different Target Tables.
• Involving in preparation of Unit Testing, Test Case Execution. Involved in designing the universe and created classes and objects according t the requirement of the Reports using Designer.

Environment: Netezza, Informatica 8.6.1, Business Objects XI R2, Windows XP

Confidential

Role: Informatica ETL Developer

• The application services provided by License Reporting and Enforcement team focus on following
• License Reporting and Enforcement LRE This Project involves enables Skill Soft, t analyze the License data by product and by customer. The project serves as a tool t take the important decisions. Reports are generated using the tool Business Objects XI R2 and made available t the decision making team.
• Data Warehousing
• Planning
• Reporting
• Analysis
• LRE basically consists of 2 modules, Skill port and Books 24 7.This project mainly tracks the information regarding the licenses provided t the customers for different products over a period of time.

Roles Responsibilities:

• Involved in designing the universe and created classes and objects according t the requirement of the Reports using Designer.
• Tested the joins, cardinality, and loops and resolved the loops using aliases and contexts as per the business rules.
• Created different types of prompts and created classes, objects and user defined variables according t the requirements.
• Web Intelligence Reports were created and deployed through Infoview, customized the Webi Reports.
• Created metric universe and developed metrics according t the measures in the report.
• Effectively communicating with all the region users about their issues.
• Involved actively in solving all the data related issues.
• Unit testing of the data in the reports by cross checking the database.
• Participated in weekly meetings with client and discussed all the week days' activities/issues.
• Improved the application performance by fixing bugs in the application.
• Responsible for communicating the support processes within the team and t the customers.
• Responsible for providing weekly reports t the project manager and actively involved in the weekly meetings t discuss current project status.
• Actively involved in Production support activities.

Environment: SQL 2000, Business Objects XI R2, Windows Server 2003, Java Apache Tomcat

Confidential

Role: Informatica ETL Developer

BICS Belgacom International Carrier Services is a leading Telecom service provider. BICS delivers best-in-class international wholesale solutions to any communication service provider worldwide. Through its Mosaic portfolio, a comprehensive, flexible and innovative suite of solutions designed to be used individually, or collectively, BICS meets the existing and future requirements of the global telecoms industry

Roles Responsibilities:

• Involved in designing the universe and created classes and objects according t the requirement of the Reports using Designer.
• Resolved the loops using Aliases, Contexts in the Universe.
• Created Prompts and user defined variables in the reports.
• Worked with Dashboard manager, which provide the ability t create management dashboards, SPC charts, Paret charts which are at a glance displays that shows the status of business metrics.
• Created classes, subclasses and objects including complex measure and objects according t the business requirements from the Universe schemas and database tables.
• Participated in weekly meetings with client and discussed all the week days' activities/issues.
• Involved in the unit testing of the Universe using the integrity check in the designer.
• Cross checked the data in the reports by executing the database queries.
• Effectively communicating with all the region users about their issues.

Environment: SQL 2000, Business Objects XI R2, Windows Server 2003, Java Apache Tomcat

Confidential

Informatica Certified Developer