SUMMARY

• 9+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Aerospace/Defence and Public Sectors.
• 9+ years of design and development of complex ETL processes using Informatica Power Center (9.x/8.x/7.x).
• 5+ years of experience developing ETL using SSIS.
• 2+years Tableau experience
• 7+ years’ experience in Data Analytics and architecture, designing of DW, BI, OLTP and OLAP MS SQL, MS BI Stack (SSIS, SSRS, SSAS) and Oracle databases technologies.
• Experience with Visual Studio, SSMS, Report Builder, SharePoint Designer, SharePoint Dashboard Designer.
• Experience with relational databases such as Oracle8i/9i/10g/11g, unstructured data sources (XML, COBOL and flat files)
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
• Strong experience in PL/SQLDevelopment.
• Extensive hands - on experience in IDD, IDQ and designing user interfaces.
• Strong experience designing Star Schema and Snowflakes Schema in relational
• Data Profiling and Data cleansing experience.
• Have led the team for Stress testing and optimization for Informatica.
• Experience of production support and making sure loads are done in an efficient manner
• Strong skills in SQL, PL/SQL packages, functions, stored procedures and materialized views to implement business logic in oracle database.
• Design and Development of extension/customizations to the services (SIF) tier of Informatica MDM Hub.
• PL/SQL, Sybase and other database coding.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Experience in identifying and resolve ETL production root cause issues. Expertise in maintenance, enhancements, performance tuning of ETL code.
• Integrating Informatica MDM Hub with Middle Tier such as Web Methods.
• Knowledge of Informatica administration in windows and Linux environment.
• Developed test cases for business and user requirements to perform System/Integration/User Acceptance testing.
• Interact with business units to understand their needs and design appropriate RPD objects.
• Experience in designing out-of-the-box RPD objects and report layout framework, designing various dimensions and facts for star/snowflake and practical knowledge to design the ETL and reporting layer for the same.
• Preparing hub objects, creating message queues & triggers, accessing APIs using Java/ Web Services, performing cleanse, cleanse put, match, merge, unmerge operations, configuring logging, Improving SIF API performance, auditing and configuring security.
• Prepared technical documentation for all new or modified RPD objects and ETL mappings.
• Prepared Code Migration requests using automated code migration tool.
• Participated in design of new data warehouse tables as needed.
• Designed and conducted unit tests of new or changed RPD objects and ETL mappings.
• MS SQL Server 2008/2012 SSIS/ETL, SSAS and in SSRS report design and implementation.
• MS SQL Server RDBMS platform with an emphasis on the sql parser/optimizer and performance tuning.
• Experience creating SSRS reports - complex drill downs, parameterized, matrix, and charts in SSRS

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.1/6.2/5.1

Data Modeling: ERWin, Data Modeler r7.3/4.x (ERD), MS Visio 2000

Databases: Oracle 8i/9i/10g MS SQL Server 2000/2005, 2008/2012 SSIS/ETL, MS Access, Teradata, Sybase, Netezza, SQL Server, MS Share point, PL/SQL, Sybase procedures/coding.

Job Schedulers: Tidal, Control M

Languages: SQL, T-SQL, Oracle PL/SQL, Korn Shell Scripting (KSH), Unix

Version Control: MS Visual Source Safe (VSS), IBM Rational Clear Case

Others: Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY, OBIEE, SSRS

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer/Data Expert

Responsibilities:

• Developed ETL Design Documents and managed the Business rules and data validation.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Sybase and Oracle PL/SQL procedures (database programming).
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Simple, Medium, complex mapping design, development and scheduling.
• Doing extensive data analysis, data profiling, designing analytical application for data mining and reporting for Investigative Unit, Vendor management, Clinic, Nutrition, Caseload Management, Quality Assurance, Food Management, EBT (Electronic Benefit Issuance, Fiscal/Financial Management.
• Preparing High level and low level technical ETL mapping specifications, Doing extensive data analysis and business analysis.
• Vendor Data profiling and matching/removing duplicate data using IDQ 9.5.1.
• Generating error messages when statistical thresholds are breached and reporting to users.
• Building data profiling rules and standardizing the data using Infomatica Developer.
• Completed system testing utilizing toolsets of Mercury quality center.
• Implementation of Informatica MDM Customer Master Data implementation.
• Collaborate with customers, vendors, and technical workgroups to identify and document data and reporting requirements, reporting processes, gap analysis, and prioritization of reporting needs.
• Design, configuration of Custom IDD interfaces.
• Preparing hub objects, creating message queues & triggers, accessing APIs using Java/ Web Services, performing cleanse, cleanse put, match, merge, and unmerge operations, configuring logging, Improving SIF API performance, auditing and configuring security.
• Using Rule based analyser and matching components for profiling and generating data set for propensity models.
• Worked as Data Steward, Working towards Data Governance.
• Preparing matching plans to prepare for consolidation of enhanced datasets.
• Identifying duplicate, inconsistent data/records for Investigation.
• Creating profile rules mapplets using developer for data cleansing.
• Development and maintenance of the Enterprise Data Warehouse, Data Marts and Reporting services.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Excellent visualization experience - charts, bars, images, dynamic reports etc.
• Maintain internal SSRS Reports and ad-hoc SQL scripts.
• Configure and Business Connectivity Services (BCS) for accessing backend data sources (external databases, etc) from SharePoint

Environment: Windows vista/7, PL/SQL developer, Sybase, Informatica Power Center 9.5, Oracle, SQL Server/ SSIS, Erwin, Agile/Scrum development methodology, DW solutions (SQL PDW, Teradata, Netezza), Tableau Reports, Business objects. SSRS, SSAS. MS SharePoint integration.

Confidential

Sr Informatica Architect/Developer

Responsibilities:

• Interacted with Business Owner for day-to-day ETL progress monitoring.
• Project coordination, End User meetings.
• Researched Sources and identified necessary Reusable Components for Mapplets and Reusable Transformations.
• Co-coordinated with Source System Owners for proper data feeds and Defaults for the Incoming Data.
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources.
• Installed Informatica Power Center on Client and Server Machines and Configure the Informatica Server and Register Server.
• Hands on experience working with IMS data.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Responsible for moving mapping elements to UAT, QA and production by Importing/exporting as XML files, subsequently create the data migration documents for UAT.QA & PROD.
• Performed Data Migration where the relational data is extracted from different sources (Flat files / Excel sheets / XML files), transformed and loaded into the target Oracle database without any data loss.
• Extensively involved in code conversion and Data Migration activities while moving the code from DB2 to Oracle 10g.
• Doing extensions and customizations to the SIF tier of Informatica MDM Hub
• Used Power Connect to extract data from SAP into the target database.
• Experience Star Schema modeling, and Snowflake modeling. Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Tuned the Informatica Mappings for optimum performance. Replaced filters with Routers and SQL overrides in place of homogeneous sources, performance tuning.
• Preparing hub objects, creating message queues & triggers, accessing APIs using Java/ Web Services, performing cleanse, cleanse put, match, merge, and unmerge operations, configuring logging, Improving SIF API performance, auditing and configuring security.
• Creating data plans in IDQ 8.5 working managing reference data integrity and defect resolution.
• MS SQL Server Reporting Services with an setup, implementation and report writing.
• MS SQL Server Integration Services with an implementation and how to optimize ETL processes.
• The gathering and requirements for the Tableau Workforce & Service Performance Management platform
• SQL Server Reporting Services (SSRS) to design complex reports.
• Experience in Cube/analytical data model.
• MS SharePoint page development including workflows, web components & dashboards.
• Dimensional/ Star Schema design

Environment: Windows vista/7, PL/SQL developer, Informatica Powercenter & IDQ 8.5,SSIS Netezza, Erwin, Agile/Scrum development methodology, Teradata SQL assistant, ODI, Tableau Dashboard Reports. SSRS, SSAS, SharePoint page.

Confidential

Sr Informatica Developer

Responsibilities:

• Designed the ETL solution for doing various complex computations (involving Pivoting, Interpolation, Logarithmic calculation, Rounding to match Access Database for accuracy of up to 16 decimal precision accuracy
• Used Informatica's Data Transformation Accelerator to map customer information contained in an XML file and map it to different XML file format for the downstream application
• Also Sourced XML files containing market data. Used source qualifier transformation to Pass XML data and an output file name to the Unstructured Data transformation. Used data Transformation Engine to transform the XML data to a Microsoft Excel file. Used XML Parser transformation to split the input data into segments. Sending the header and detail rows to relational targets for downstream processing while returning the pass-through data to a Filter transformation
• Successfully delivered most complex ETL code with only 1 defect under constantly changing user requirements.
• Using Informatica MDM solution for doing impact analysis and preparing the lineage chart for business.
• Proficient in understanding COBOL and XML files and experience loading data using Unstructured data transformation, XML Parser, Normalizer, WSDL transformations.
• Preparing the audit procedure to provide User with flexibility to rerun the process for any previous day, to align the audit procedure to track the data flow from different source system including the daily market data and the updated product portfolio.
• Helped the QA team by preparing complex SQL queries (to reproduce highly complex ETL code having around 150 columns) thus decreasing the testing times by almost 30-40%.
• Analysis, design, development, production migration and troubleshooting of complex ETL mappings.
• Designed the ETL solution for doing various complex computations (involving Pivoting, Interpolation, Logarithmic calculation, Rounding to match Access Database for accuracy of upto 16 decimal precision accuracy.
• Preparing the audit procedure to provide User with flexibility to rerun the process for any previous day, to align the audit procedure to track the data flow from different source system including the daily market data and the updated product portfolio.
• Successfully promoted the first phase of ETL development under constantly changing
• Quick in adjusting code making sure none of the other component breaks
• Proficient in understanding COBOL and XML files and experience loading data using Unstructured data transformation, XML Parser, Normalizer, WSDL transformations.
• Helped the QA team by preparing complex SQL queries that converted whole ETL code having around 150 columns into SQL code thus decreasing the testing times significantly.

Environment: Windows vista/7, Informatica 9.1.0, SQL navigator, Toad, Fixed width flat file, Mainframe COBOL files, Informatica MDM. SQL Server (2005/2008/2012 ), SSAS, SSIS, SSRS

Confidential

Sr Informatica Consultant

Responsibilities:

• Designed data model and an optimized ETL solution for populating Facts, Dimensions, Minidimension, Factless fact, Bridge tables, Audit and error table.
• Design & Build BI Delivery components (Dashboards, Reports, iBots, etc.).
• Translated business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Reports and dashboards development inOBIEEusing data from both relational and OLAP data sources.
• Expertise in understanding the Reporting/OLAP concepts.
• Implemented Change Data capture, pushdown optimization, Partitioning in Informatica.
• Prepared fully excel based automated test scripts for reducing the time required by developer for testing ETL code.
• Preparing higher level and lower level design of the Informatica maps.
• Implementing different Change Data capture and incremental technique while pulling the data from DB2, flat file, SAP and SQL server and populating in SQL server.
• Currently designing the data profiling and data cleansing approach since the Data Warehouse involves integrating the data from SAP, DB2, flat file, Oracle and SQL server.
• Actively involved in designing, developing, creating complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Mentoring the team on standard design and development practices and doing POC for different team to facilitate their work using the Informatica ETL.
• Hands on various Informatica transformations like expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation, normalize etc.
• Experience with OLTP and OLAP database design, creation and reporting.
• Connections to systems allowing the display of dashboards and KPIs using components such as Excel, SQL Reporting Service, etc. Perform & support data analysis & cube development for report delivery.

Environment: Windows vista/7, Informatica 9.1.0, SQL Server Management Studio, Toad, DB2, Fixed width flat file, OBIEE 11g. Business Objects, SSIS Intregation, SSRS, SSAS.

Confidential

Informatica Solution Architect

Responsibilities:

• Designing the table level structure for an optimized ETL solution, denormalizing the table as required.
• Successfully led a team of 7 resources (including Informatica and DBA’s) and build a data mart from scratch, the project was delivered on time and within budget.
• I worked as a Developer to prepare a POC where we used Unstructured Data transformation to call a Data Transformation parser service to extract order information from a Microsoft Word document and write the order information to an order header table and an order detail table.
• Used Unstructured Data transformation to call a Data Transformation parser serviceto extract order information from a Microsoft Word document and write the order information to an order header table and an order detail table.
• UsedData Transformation Parser and Mapper componentsto transform data from word fileto generate XML data.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency.
• Created Power Exchange Data maps to Capture Changed data (CDC) from Legacy Systems
• Created JMS services to read source file for each partner and assigning to real time workflow.
• Installed Data Transformation Engine, Studio, configured JMS to pass source as BUFFER and pass Data By Reference to Data Transformation.
• Created scripts by parsing different formats of sources like .xls, cvs, xml, pdf, etc. and related variables and assigning values for source and target columns and passing into mapping.
• Validating, Running the scripts and deploying the scripts in server DB folder.
• Designed the ETL solution for doing various computations required for Forecasting, Valuation and Material Management.
• RPD Development for Sales subject area using OBIEE administration tool (Building hierarchies, Using bridge tables, Aggregate tables and Partitioning).
• Developed dashboards and assisted in development of complex ad hoc queries and analyses. (Using prompts, filters, sections and various views).
• Mentoring the team on standard design and development practices and doing POC for different team to facilitate their work using the Informatica ETL.
• Understanding SAP R/3 business functional areas and discussing with users the report layout structure and getting the UAT signoff’s.
• Actively involved in designing complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Working as an ETL onsite lead and making sure the implementation is done according to standards and is optimizally designed.
• Reviewing Informatica maps developed by the offshore people on a daily basis.
• Preparing higher level and lower level design of the Informatica maps.
• Interacting with multiple vendors for successful of the project.
• Designed the OBIEE repository and report layout, resolving the fan traps, designing the star schemas, hands on experience working OBIEE.
• Experience with UNIX shell (Scripts) for processing, FTP, file listing concept.

Environment: Windows vista/7, Informatica8.6.1, SAP R/3, Oracle, Informatica IDQBusiness Objects, SSIS Intregation, SSRS, SSAS

Confidential

Informatica Consultant

Responsibilities:

• Conduct a gap analysis between Current and Future Service and Application model options and identify required changes to processes and technology and successfully implement the organizational redesign.
• Actively involved in designing, developing, creating complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Installing Informatica Power center 9.0/8.x/7.x/6.x on windows/ Linux environment.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Conducted Dimensional Modeling Analysis for each ORDM subject area
• Used inline Lookup within the transformation language script (tgp) in DT studio andusing an external table (XML),and dynamically using variables of type code: lookup Table
• Used mapper, serialiser, parser for parsing COBOL files (EBCDIC)
• Used Power center unstructured datatransformation to automate real time transformation of unstructured data.
• Was responsible for Data Modeling of events and filings subject area using Erwin.
• Loading XML files to oracle using Informatica, handling variable length XML files using Informatica.
• Have led the team for Stress testing and optimization.
• Experience processing multiple XML files using Informatica.
• Coordinated the release management and migration support for PAT.
• Business requirement gathering by conducting several iterative Joint Application Design (JAD) sessions and interviews with the business user community and business analysts for the new CCMS application.
• Preparing the macro design document and creating High Level design document translating business requirements into functional specifications and writing pseudo codes
• Translate functional specifications document into technical specifications explain business and technical transformation rules.
• Collaborated with the BI Architect / BI Team and the business community to define information use cases and approaches for supporting them with Oracle BI Analytics dashboards & reports
• Confidential and extended company's BI platform, including hands-on technical development of Oracle BI Dashboards, Reports and ETLs.
• Developed usingOBIEE10g Components: Server, Administrator, Presentation Services, Dashboards, and Answers and Semantic Models.
• Developed dashboards with grids, charts, KPIs, filters and drill down.
• Used query as web option to build visualizations based on the reports built in Business Objects.
• Exported visualization contents to various file formats (PDF, PPT, HTML and Flash).
• Involved in troubleshooting the visualizations for various problems faced during data connectivity.
• Managed development and production environments using Power Center, MS SQL Server. Monitored the load jobs, error log files for regular load and interacting with end users.
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Confidential both development and production environments since a long time using Power Center, Oracle (PL/SQL). Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas
• Use Clear Case for version control across common source code used by developers
• Deploy all the code that has to be migrated to QA/Production environment
• Coordinate with System Testing and UAT team to analyze and resolve opened defects.
• Expertise Technical in data architecture, data management standards and artifact for Data Warehouse and Operational Data Stores (ODS)

Environment: Windows vista/7, Informatica9.0.1, MS SQL Server 2008, Erwin, XML, OBIEE 10g, SSRS, SSIS, SSAS

Confidential

Data Modeler

Responsibilities:

• Duties during Application Functional Design Approach: The core of the Data Warehouse design process was an iterative Joint Application Design (JAD) and involved close interactions with business and IT Subject Matter Experts (SME) on a daily basis.
• Worked as a Data modeler to build conceptual and physical data model using Erwin for subject areas like engineering, supply chain and integrated operations to define entities, attributes and their relationships.
• Loading XML files to oracle using Informatica, handling variable length XML files using Informatica.
• Technical Design Overview phase had following duties: The functional specification was translated into a technical design to support configuration and build of the application.
• Upon completion of design, major responsibility involved handing over and communicating the complete design to offshore team to develop the code and resolve any technical and design issues faced by the team
• Responsibilities included designing architecture and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping’s run process.
• Experience in Building Slowly Changing Dimensions
• Extensively worked with various transformations like expression, filter, joiner, aggregator, lookup, rank, sequence generator, sorter, etc.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Worked with trouble shooting in Production support and was responsible for fixing bugs in Production Server.
• Coordinated with system and business analyst for early investigation of data.
• My role also included analyzing ETL loads, data quality of the Dimensional Data Warehouse, auditing the error handling modules.
• Proficient in Installing Informatica Power Center
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation
• Knowledge transfers with team members for efficient design of the mappings and programs.

Environment: Informatica 9.0.1, Teradata, WINSCP, PUTTY, ERWIN, XML

Confidential

Informatica Developer

Responsibilities:

• Advanced Informatica (using Dynamic lookup, Parameters, Advanced transformations) mappings.
• Designed and conducted unit tests of new or changed RPD objects and ETL mappings Interacted with business units to understand their needs and design appropriate RPD objects.
• Developed and Confidential corporate data model, documented various data sources.
• Worked in conjunction with users for developing dashboards.
• Developed complex OBIEE reports, building RPD, designing aggregate tables, reports and dashboards. Did performance tuning for Informatica mappings and RPD object.
• Business requirement gathering by studying the current enterprise model
• Interview Subject Matter Experts and IT team and develop foundational understanding of current system architecture
• Develop high-level estimate using Microsoft Project Plan, schedule, resource plan and risk analysis
• Develop a full lifecycle proof of concept to further explore selected technology option
• Supplement financial analysis by comparing performance over time across key value drivers using Value Analytics
• Actively involved in designing, developing, creating mappings, mapplets using Informatica source, warehouse and loading the data.
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Worked as Informatica Administrator.
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Analysed the Fulfilment requests (FR) and Change request (CR) as per requests from HPPM.
• Installing Informatica Power center 8.5.1 on HP-UNIX.
• Creating SR to Informatica Inc- related to any Power center product issues.
• As per Fulfilment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Performed Upgrading Informatica Power center Version 7.x to Informatica Power center 8.X.
• Ensures proper configuration of the Power Center Domain components.
• Experience in nodes, Repository services and Integration services.
• Ensures proper application of the licensing files.
• Create, backup, restore for Informatica Repositories.

Environment: Informatica7.1.1, TOAD, Oracle9i, MS SQL Server, Teradata and sql, Informatica9.0.1, Oracle, OBIEE 10g, Control M

Confidential

Informatica developer

Responsibilities:

• Involved in Requirement gathering.
• Creating the Technical design specifications based on Client functional specifications.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Worked extensively on different types of transformations like Joiner, Aggregator, Router, and Expression, Normalizer, connected/ unconnected Lookups, Data Masking transformation and Update strategies.
• Created Slice and Dice, Drill down and Cross Tab reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Various ad hoc reports were created using User module in Business Objects according to the given requirements.
• Modified two universes, Market Risk and Interest Risk on Wells Fargo Bank side with SQL Server 2005 as DBMS.
• Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Worked on data modeling by creating derived tables on universe level.
• Used POWEREXCHANGE for SAP R/3to connect and import source data.
• Designed mappings which identify duplicate customer records. Match and merged records based on business rules.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Developing PL/SQL Packages, procedures, Functions, Triggers, Cursors as per the business requirements.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Performance tune ETL mappings, Maintenance, enhancements and deployment of ETL code.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Created several projects, packages and metadata models in Cognos Framework Manager.

Environment: InformaticaPowerCenter7.0.1, Power Exchange, IDQ, IDE,Oracle10g,PL/SQL,SQL Server 2005,DB2,SAP R/3,SAP BW, Erwin, Data Modeler r7.3,AutoSys,Toad.