SUMMARY

• 12+ years of IT experience with 9+ years of experience in full life cycle project development design, coding, testing, implementation, document and ongoing production support for Cognos 10.2, 8.x, 7 on multiple database platforms.
• Extensive experience on different Cognos 10.2 products ( Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Active Reports, Workspace, Workspace advanced, Dynamic cubes).
• Experience in installation and configuration of Cognos 10.2, Cognos 8.X BI, & 7 Series.
• Great breadth of knowledge about how to implement Business Intelligence solutions across the many different functional areas of an organization.
• Sound working domain knowledge in Banking, Pharma, Property and Casualty Insurance, HR, Retail, Gaming, Education, Healthcare and Government.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Experience inOLTP/OLAPSystem Study, Analysis and ER Modelling, Maintaining Database Schemas likeStar SchemaandSnowflake Schemaused in relational and dimensional modelling and Kimball methodology.
• Strong proficiency in different SDLC methodologies including Agile and linear models.
• Expert level with developing metadata models in Framework Manager following best practices
• Expert level with developing OLAP models, using Power plays Transformer.
• Strong skills developing DMR models in Framework Manager and Multidimensional reports in Report Studio
• Delivered solution - oriented complex reports using Report Studio and development of ad-hoc reporting interfaces using Query Studio and analysis of reports from cube packages using Analysis Studio.
• Experience Creating Reports using JavaScript and cascading style sheets.
• Experience in using Audit database native to Cognos to understand resource usage and implement performance measures.
• Experience with Multiple Relational Databases including Oracle, SQL Server, Teradata and IBM DB2.
• Experience in designing and developing of indexes, views, materialized views, triggers, functions, stored procedures and packages.
• Experience working at State Govt projects at New Mexico, Missouri, District of Columbia, South Carolina and Common wealth of Massachusetts.
• Experience in developing Project process related documents as per the CMM i standards.
• Capable of working in groups as well as independently with excellent communication skills.
• Good in trouble shooting with quick turnaround in fixing the issues.

TECHNICAL SKILLS

BI Tools: Cognos 10.2, Cognos 8.4 BI, Business Objects XI Rel 2.0.

Visualization: Tableau 8.2.

ETL Tools: Informatica 8, Data stage 7.5, Microsoft SSIS 2008, Cognos Data Manager.

Data Bases: Oracle 11G, SQL Server 2008, Teradata V2R6, DB2 8.0

Web Servers: Apache web server, IIS 7.0.

Languages: C, HTML, SQL, PL/SQL.

Scripting: Unix Shell, VB Script.

Internet Technologies: HTML, DHTML, ASP, Java Script and VB Script, XML.

Tools: MS Office, Visio, Erwin, TOAD, VSS.

Operating Systems: Windows XP, UNIX, Linux.

ERP: Oracle EBS 12, Peoplesoft 8.0.

PROFESSIONAL EXPERIENCE

Confidential

Senior Cognos Consultant

Responsibilities:

• Interacted with different business teams to collect the requirements for reporting analysis. Analyzed current business processes, assess opportunities for redesigning these processes.
• Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, data Sources and published packages to Cognos connection.
• Created various complex reports which involve drill through definitions, conditional formatting, JavaScript’s, conditional blocks such as Forecast Accuracy, Time&Revenue, Project Type Distribution using Report Studio.
• Used the Transformer model in the Framework Manager and published the packages consumed by report studio reports.
• Created and published cubes using Power play Transformer and implemented security.
• Performance tuning of the existing report studio and query studio reports.
• Involved in Production Support and Maintenance of existing cubes, reports, Tableau worksheets.
• Responsible for providing access to users and stakeholders across all environments.
• Migration of worksheets, User Management and Environment Maintenance in Tableau 8.2.
• Worked onbug fixingand enhancements to existing Cognos reports inReport Studio& models in Framework Manger.
• Worked onAnalysis Studioto develop multi-dimensional reporting. Analysed Business requirements from the analysts.
• CreatedActive Reportwhich provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Created Dashboards in Cognos Workspace Advanced using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Created Indexes and Views using SQL to enhance the performance of the reports.
• Involved in creation of various Tableau 8.2 worksheets using various visualization techniques.
• Created Sites, Projects, Views, worksheets, views, and data sources in Tableau 8.2 across multiple environments.
• Provided End User training in Workspace Advanced and Tableau.
• Involved in creation of technical specification documentation and actively involved in unit testing of multiple applications.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Assists in integration, systems, acceptance, and other related testing as needed.
• Identifying root cause, prioritizing of problems and resolve break fixes.
• Coordinated with Offshore team to manage day to day activities and project deliverables to meet the project timelines.

Environment: Cognos 10.2 BI, Tableau 8.2, Active Reports, Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11g, SQL Server Management Studio 2012, MetaManager, ITSM

Confidential

Senior Cognos Consultant

Responsibilities:

• Worked closely with the Business Analyst & System Analyst on the client side to define the scope of the reporting component. Actively involved in organizing and attending functional design sessions for various reporting components.
• Translated the notes gathered during these design sessions into functional design documents that were later used for report development.
• Shared the duties of developing metadata models using Cognos Framework Manager for enterprise wide reporting.
• Developed the model in line with best practices suggested by Cognos. Model was developed with a Database Relationship Layer, Business Layer and Presentation Layer.
• Assisted in upgrade of Cognos from 8.4.1 to 10.2. Upgraded all models and reports and validated those to make sure nothing was broken during the upgrade process
• Developed Dashboards for various Business groups using Cognos Active Report and Report Studio.
• Developed highly analytical reports that track Environmental risk activity like Crude rate, adjusted rate, Confidence Interval.
• Many of these reports were developed using highly beneficial features of Cognos such as Drill Through, Conditional Rendering, Style Formatting, Component Reference components, Embedding HTML Components for Webigeo Maps.
• Geospatial mapping tool Webigeo is used to integrate with Cognos in the delivery of business intelligence solution.
• Provided production support with the issues occurring in the environment for daily, monthly reports.
• Involved in the Cognos administration like creating new data source connections and creating packages, handling the deployment of reports from development to production server and also handling the user permissions on the packages and folders.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Assists in integration, systems, acceptance, and other related testing as needed.
• Identifying root cause, prioritizing of problems and resolve break fixes

Environment: Cognos 10.2 BI, Webigeo, Business Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11G.

Confidential

Senior Cognos Consultant

Responsibilities:

• Analyzed the business functional requirements and worked with the business units to define the strategy of the business and created IBM centralized reporting capability.
• Created multiple relational models and DMR models based on the requirements.
• Created Framework packages with various security settings and published onto cognos connection.
• Created Database layer, Business layer in the model by defining appropriate relationship between query subjects.
• Defined package level, object level securities to allow users create calculations over the query items.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio.
• Developed analytical reports for Enrollments, Scholarships, Completions, SAT, Programs, Courses & Faculty.
• Created drill through definitions in the reports based of the cubes to drill down to detail level of the data.
• Created dashboard-style reports combining list, cross-tabular, and chart displays to give executives an "at-a-glance".
• Responsible for troubleshooting Cognos BI Server issues.
• Administering user access to reporting applications which includes setting up cognos security by assigning users to the groups and roles defined in the cognos Namespace.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Scheduled and distributed reports using Schedule Management In cognos connection.
• Performed unit testing and documented test cases and detail design of the project

Environment: Cognos 10.1.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle 11g.

Confidential, CT

Senior Cognos Developer/Admin

Responsibilities:

• Communicate with the internal business users to gather requirements and systems analysis of business process and create functional and Technical specification documents.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and upgrading from Cognos 8.4 to Cognos 10.1.
• Managing user access and Cognos capability mapping through LDAP groups.
• Generating ad-hoc reports from audit database regarding usage, user count, report or cube build failure tracking etc when demanded by projects.
• Debugged and suggested solutions for problems in existing Report designs
• Used Cognos Best Practices for creating FM Packages, Reports, Dashboards and cubes.
• Created Dashboards in Cognos Business Insight for Slots by Applying filters and Configuring widget controls to customize the dashboard.
• Created Dashboards in IBM Cognos Business Insight Advanced for Slots using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Conducted User training for Business Insight Advanced users.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• CreatedActive Reportswhich made offline analytics easy to get truly portable business intelligence.
• Created Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Manage tasks and effort for enhancement releases and other critical support activities.

Environment: Cognos 8.4, 10.1.1 BI (Life Cycle Manager, Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle 11g.

Confidential, Washington, DC

Senior Cognos Consultant

Responsibilities:

• Analysis of the business requirements, understanding client's data warehousing requirements and system analysis of business process.
• Collaborate with business users to capture and document their analytical requirements.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather Requirements and create functional and Technical specification documents.
• Translate requirements into flexible semantic layers using solid semantic layers, deploy solutions that provide easy to build ad-hoc analyses and visualizations.
• Interacting with the users for understanding of Data Analysis of Fixed assets module and deriving its underlined table structure.
• Identifying the relationships between Fixed Assets, G/L, Receivables module tables and designing facts and Dimensions from Oracle EBS system.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Developed various fixed asset property reports including Monthly G/L Posting, Depreciation Summary, Book Value Report and Asset Acquisitions reports.
• CreatedActive Reportswhich made offline analytics easy to get truly portable business intelligence.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments
• Created Dashboards in IBM Cognos Business Insight Advanced for Fixed assets using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques
• Skilled at training users to use Query Studio, Analysis Studio and Business Insight Advanced.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Environment: Cognos 10.1.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle EBS 12.1, Oracle 11g, Toad.

Confidential, Windsor CT

Cognos Lead

Responsibilities:

• Involved in the full project life cycle of planning, development and implementation stage across Cognos applications.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather the requirements and create functional and Technical specification documents.
• To handle the requirement, we started developing the Framework Manager Models using multiple data sources and these models were published as multiple packages to the Cognos report servers for building the cubes and the reports.
• The data modeling was done using the Star Schema model and the database layer and the business layer were created in the model defining the relationship between the query subjects.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Created appropriate user classes, groups, database signons in Access Manager to provide different levels of authentications and privileges.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Developed the Dashboard and Scorecard reports using Cognos Report Studio and Metric Studio respectively.
• Created analysis reports/graphs using a DMR (Dimensionally modeled relational) package.
• Involved in the Cognos Administration like creating new Data source Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Provided production support with the issues occurring in the old environment for daily, monthly reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Involved in daily scrum meetings and sprint planning meeting.
• Created test plans, cases and scripts from Use Cases and other user requirements.

Environment: Cognos 8.4 BI, Cognos 8.4 Transformer, Analysis Studio, Metric Studio, Framework Manager, Oracle 11g.

Confidential

Senior Consultant

Responsibilities:

• Involved in the full project life cycle of planning, development and implementation stage across Cognos applications.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather the requirements and create functional and Technical specification documents.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Set Data and Object level security inside FM package before publishing to Cognos Connection.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling,
• Security and other complex features.
• Extensively worked on bursting reports to 10 Districts, 9 Troops, 110 Counties and 962 Cities by naming them as per
• Prompt selection.
• Resolved abruptly terminating reports by Configuring Dispatcher URL, Edited the Cognos system files to hide some of the Cognos features from Cognos Users.
• Created appropriate user classes, groups, database signons in Active Directory to provide different levels of authentications
• And privileges.
• Changed advanced settings for Excel and PDF format, increasing the logging level for tracking the user activities.

Environment: Cognos 8.4 BI, Framework Manager, Report Studio, Active Directory, IIS 6.0, Oracle 10g.

Confidential, Atlanta GA

Sr Cognos Developer

Responsibilities:

• Responsible for gathering report requirements, creating functional and Technical specifications.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and migrating from Cognos Report net to Cognos 8.4.1.
• Migrated Packages, reports from Cognos report net to Cognos 8.4.1.
• Created dashboards using Report Studio in order to organize the information to change the display type and collaborate with insights about the business performance.
• Created Dashboards in Cognos Connection by Applying filters and Configuring page controls to customize the dashboard.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security.
• Created Burst, master detail, conditional formatting, and drill through reports.
• Administration of Cognos Server/Environment including performance tuning and Issue resolution.
• Analyzed, designed and Implemented Multi dimensional cube for Claims analysis.
• Created Dashboard using Go Dashboard for Audit analysis and trained user community.
• Used Dimensional modeling DMR and Snow flake Schema modeling technique to develop models
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Processed and summarized data in the application layer and generated summaries of that data.
• Involved in the design and development of indexes, views for performance up gradation wherever required based on the requirement.
• Followed the best practices in development of packages, reports and cubes.
• Created Adhoc reports using Query studio using custom groups and combined filters.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling,
• User Management, Security and other complex features.
• Imparted guidance and mentoring in Cognos report development best practices.
• Worked on Onsite offshore team environment.

Environment: Cognos 8.4 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Power play Transformer), SQL Server 2008.

Confidential

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.
• Developed and Published Packages in Framework Manager.
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Maintained Content Manager for Cognos8.4.
• Created calculations and filters in the Framework manager model.
• Modified packages to generate reports for better analysis.
• Worked on MDX queries for Multidimensional reports used in Report studio.
• Create Drill through and Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page breaks.
• Scheduled bursting reports and distribution of Cognos 8 reports using portal administration.
• Created appropriate dimensions and manual levels in the Transformer model.
• Optimized the cube performance by partitioning and caching.
• Modified existing Cubes as per requirement.

Environment: Cognos 8.4 BI, Cognos Data Manager, SQL Server 2005.

Confidential, Tampa FL.

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.
• Developed and Published Packages in Framework Manager, Connecting and testing the data source,
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Create Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page breaks.
• Created Drill- through reports and Customized Reports with Prompts.
• Created complex Dashboard using report studio having charts and graphs.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Created test plans from Use Cases and other user requirements.

Environment: Cognos 8.4 BI, SQL Server 2005

Confidential, Santa Fe NM

Cognos Developer

Responsibilities:

• Analyzed the specifications provided by the clients and Developing Technical Design Documents for reports as per client requirements.
• Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.
• Created separate views to retrieve specific information.
• Created a single federated view combining the individual views.
• Developed and Published Packages in Framework Manager, Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Customizing Cognos Connection Portal based on user specifications.
• Designed and setup Cognos security using LDAP.
• Developed Dashboard reports using Cognos Report Studio which has count of programs and further drill through for details.
• Worked with Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports with Prompts.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Created test plans from Use Cases and other user requirements

Environment: Cognos 8.4 BI, SQL Server 2005, VSAM, DB2 9.0.

Confidential, New York

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.2 BI.
• Involved in Analysis, Design, Development, Migration, Testing and Maintenance of reporting environment.
• Hands on experience of Kimball approaches to data mart implementation using Framework manager.
• Worked on logical and physical modeling like normalization, star schema, data flow diagrams and workflow diagrams.
• Used frame work manager to develop relational as well as dimensional model. Implementing best practices, using disparate data sources. Also worked in multi user modeling environment.
• Worked on multiple data sources to create C Level dashboards, complex reports, drill through, conditional formatting, using manual sql and set operartors.Implemented bursting using cognos report studio.
• Used conditional and dynamic formatting techniques to present the data in a format specified.
• Involved in Query Optimization, Developing Prompt pages, User defined functions and Conditional variables.
• Perform Cognos Administration tasks including the Scheduling and Deploying of metadata and reports from development environments to production environments.
• Modeled dimensional information using DMR methodology in Framework Manager and published Package for comparing Fiscal year Analysis Reports in Analysis Studio.
• Worked with Java programmer for bursting the reports to different users based on security using Cognos SDK.
• Used cube optimization techniques to reduce cube build time in Power Play Transformer
• Worked on Cognos Administration for content management, System Administration, Data management, Security administration.
• Prepared Test cases for SIT/UAT, conducted User Sessions to end user.
• Debugged and suggested solutions for problems in existing Report designs
• Execute the month end process. Production and distribution of daily, weekly and monthly reports, as defined by the business.
• Proficient with database performance management, writing PL/SQL stored procedures.
• Experience writing and executing shell scripts.
• Worked with business users for report validation and knowledge transfer.

Environment: Cognos 8.2 BI, Oracle 10G, Apache, AIX.

Confidential, Detroit

Cognos Developer

Responsibilities:

• Communicating with the business users to comprehend the requirements on converting the business process requirements into technical specifications.
• Manage tasks and effort for enhancement releases and other critical support activities.
• Review and approve offshore code changes that are implemented as a part of releases or support activities.
• Preparing the OLAP Reporting Design Document for reports.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Implemented security for Data access, Object level access and Package access.
• Developed and Published Packages in Framework Manager.
• Created Filters, Calculations, parameter maps and session parameters used by report authors.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Customized the Cognos portal, edited the system.xml and the default.css files to have a better user interface.
• Scheduled reports in the Cognos Connection portal using Schedule Management Tool.
• Extensively used Conditional block sections for creating Multiple Queries in a single Cognos Studio Report for reuse and layout
• Created adhoc reports using Query Studio.
• Scheduled the reports to run on daily/weekly basis, using Cognos connection depending upon the end user choice and the level of administration.
• Performed Unit testing and System testing of the reports based on the specification.
• Provided extensive end user support and training on Ad-hoc reporting using Query Studio.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Developed and tuned complex PL/SQL queries for better performance.

Environment: Cognos Report net 1.1 MR3 & Cognos 8.2 BI, BAE Web logic, Oracle 9i.

Confidential

Developer

Responsibilities:

• Support the application Toscanini like Data extract, transformation and load processes to ensure successful receipt.
• Development and Administration of the Power play cubes.
• Publishing power cubes on Toscanini servers using PPES.
• Administration of Sql Server database.
• Managing user security using Access Manager and Administration of the Toscanini intranet.
• Involved in migrating reports from Impromptu to Report Net.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Involved in developing design documents and mapping documents.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.
• Debug and resolve production support issues in order to meet the customer service level agreement.

Environment: IBM AS/400, VB 5.0, SQL Server 7, Cognos 7 EP, Report net 1.1, Informatica.

Confidential

Developer

Responsibilities:

• To interact with the Clients and On-site coordinator on a regular basis for resolving issues pertaining to the data delivered and change requests
• Initial analysis and understanding of Specification documentation and report layouts, Synchronizing Catalogs with latest views, adding the joins wherever necessary.
• Create Calculations and prompts at Folder levels, designed the Report formats and developed reports using Impromptu, and Developed multiple Impromptu reports and Documented as per client requirements.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Involved in developing design documents and mapping documents.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.

Environment: Oracle 9i, Informatica, Cognos 7.1 mr3, 7.3 mr2

Confidential

Developer

Responsibilities:

• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Involved in developing design documents and mapping documents.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.

Environment: Informatica 7.1, Oracle 9i.