Professional Summary

• 8 years of IT experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence Reporting Applications tools.
• Cognos BI Consultant with 7 years of experience in designing, development and deployment of Business Intelligence reports and models in Finance, Healthcare and Insurance domains.
• Expertise in building and maintaining complex reports and business models using Cognos 8 BI Suite Transformer, Framework Manager, Cognos Connection, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio , Cognos ReportNet and Cognos EP Series 7.x.
• Developed Active Reports Dashboards using Cognos 10.2.1.
• Expertise in building both Relational and DMR Models Physical Layer, Logical Layer, Business Layer, Packages using Framework Manager.
• Experience in developing complex reports using drill-through reports, prompts, conditional formatting, master-detail, dashboards, burst-reports, dynamic filtering in Cognos Report Studio.
• Expertise in creating and customizing Dashboard reports using Java Script in Report studio.
• Experience OLAP cube development using Cognos PowerPlay and Transformer and DMR Models in FM.
• Distribute reports on-demand or on schedules based on time, calendar, events, or external triggers.
• Created and customized dashboards to support business user's ever-changing needs for the most up-to-date information so they can make better business decisions more quickly.
• Experience in performance tuning and optimizing of the reporting solution.
• Developed IBM Cognos 8 Go Office Reports to embed in Microsoft Excel workbooks, Word Documents, Microsoft Power Point Presentations, including data, metadata headers, footers, and charts.
• Extensive experience with Cognos security LDAP, Active Directory, Access manager, object level security, data security, Row Level Security using Parameter Maps .
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
• Experience in installation and configuration of Cognos 7.x/8.x in standalone and distributed environment.
• Experience with data modeling including dimensional modeling, data migration, data cleansing and ETL Processes using ETL tools like Informatica, DataStage and SSIS.
• Well-versed productive working relationships with clients and staff, and excellent management and leadership skills.
• Talented in analyzing problems, developing simplified procedures, and finding innovative solutions.

Technical Skills:

• BI Tools : Cognos 10.2/10.1.1/8.4/8.x Suite, Report Net 1.1/1.0x, Cognos- Impromptu 7x/6x, Impromptu Web Reports IWR , Power Play, Power Play Transformer 7x/6x
• ETL Tools : Informatica, SQL Server Integration Services SSIS
• Databases : Oracle 8i/9i/10g, SQL Server 2000/ 2005/2008,PL/SQL Developer
• Modeling Tools : Erwin 4.0, MS Visio.
• Web Application Servers : IIS, Tomcat 4.x/5.x, WAS
• Programming : C , PL/SQL, T-SQL

Professional Experience

Confidential

SR. COGNOS DEVELOPER

Responsibilities:

• Involved in requirement gathering and analysis developing specification documents for reports as per client requirements.
• Developed Metadata Models using Layered Architecture Database, Logical and Business and DMR models using Framework manager and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created complex dashboards, portlets with area charts, pie charts, crosstab and Multi prompts in Report Studio for various reports.
• Created the active reports by using cognos10.2.1.
• Created the Global shared location for storing the cognos report outputs for different project streams.
• Created the events in the event studio.
• Extensively used cascading prompts, filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Drill through Reports Master Detail Reports.
• Created Burst Reports and Multilingual Reports based on groups of users Preferences for our Asian, American and European partners.
• Developed Transformer models by creating dimension maps, measures and levels and created power cubes according to business requirements.
• Extensively Build Power cubes and worked on cube optimization to improve performance.
• Good experience in migrating the views from cognos 10.1 power play studio to cognos 10.2.1.
• Good experience in creating Active Directory.
• Good experience in adding new custom roles by using Active Directory.
• Build report templates that include standard report objects, queries, and layouts.
• Involved in building Reporting Database using Informatica source analyzer, mapping designer, warehouse designer, transformation developer and Mapplets designer
• Involved in Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment, for Oracle and SQL Server databases.
• Good experience in the Cogos deployments.
• Involved in the admin related tasks. Creating the LDAP groups and assigning proper privileges to the users, authors and power users.
• Good experience in IBM Clear case and Clear quest
• Trained end users in understanding the functionality of Cognos Report Studio, Query Studio and Analysis Studio.
• Trained the end users to create the new reports by using the Report studio, Query studio, Business Insight.

Environment: Cognos 10.2.1/10.1, 8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer, Go Office , Oracle 11g, Cognos Access Manager, Informatica, Windows Server 2008, MS Project, MS Visio, PL/SQL Developer.

Confidential

SR. COGNOS DEVELOPER

Responsibilities:

Involved in requirement gathering and analysis developing specification documents for reports as per client requirements.

Developed Metric Studio, Active Reports Dashboards using Cognos 10.1.

• Developed Metadata Models using Layered Architecture Database, Logical and Business and DMR models using Framework manager and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• general settings to create metric types to define attributes.
• calculations for a collection of related metrics.
• Created complex dashboards, portlets with area charts, pie charts, crosstab and Multi prompts in Report Studio for various reports.
• Extensively used cascading prompts, filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Drill through Reports Master Detail Reports for Accounts Department.
• Created Burst Reports and Multilingual Reports based on groups of users Preferences for our Asian, American and European partners.
• Developed Transformer models by creating dimension maps, measures and levels and created power cubes according to business requirements.
• Extensively Build Power cubes and worked on cube optimization to improve performance.
• Good experience in migrating the views from cognos 8.2 power play studio to cognos 8.4.
• Good experience in creating Active Directory.
• Good experience in adding new custom roles by using Active Directory.
• Build report templates that include standard report objects, queries, and layouts.
• Involved in building Reporting Database using Informatica source analyzer, mapping designer, warehouse designer, transformation developer and Mapplets designer
• Involved in Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment, for Oracle and SQL Server databases.
• Trained end users in understanding the functionality of Cognos Report Studio, Query Studio and Analysis Studio.

Environment: Cognos 10.1, 8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer, Go Office , Oracle 10g, Cognos Access Manager, Informatica, Windows Server 2008, MS Project, MS Visio.

Confidential

ROLE: COGNOS DEVELOPER

Responsibilities:

• Involved in preparing Business Requirement Documents and Functional specification documents.
• Used Framework Manager to build models, Segments, Security Object, Data, and Package , set Governors, resolved complex cardinalities and integrated VSS.
• Developed new reports using Report Studio that include master-detail reports, drill-through, prompts, bursting reports, crosstab, charts.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Converted financial reports from MS Excel to Transformer Power cubes and created reports in Cognos Analysis Studio.
• Responsible for definition, deployment and monitoring of important organizational metrics using Cognos Metrics Manager.
• Built models using Framework Manager and power cubes using Transformer.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Migrated numerous existing Cognos 7.4 impromptu catalogs and Impromptu Reports IMRs to Cognos 8 series.
• Good experience in creating Active Directory.
• Good experience in adding new custom roles by using Active Directory.
• Good experience in Web Portal Exchange 2007 Active Directory.
• Upgraded reports from Cognos 8.3 to 8.4 and modified packages to enhance report performance.
• Worked with ETL team to load data into Data Warehouse/Data Marts using Informatica.

Environment: Cognos 8.3/8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer, Cognos Office Connection , Oracle 10g, Cognos Access Manger, Informatica, Windows Server 2003,MSProject,MSVisio.

Confidential

ROLE: COGNOS DEVELOPER

Responsibilities:

• Involved in requirement gathering and analysis developing report specifications as per business requirements.
• Involved in developing Data modeling and Logical/Physical model using Erwin 3.5
• Coordinated the development effort with a team of 5 offshore members in India.
• Designed and configured user roles and access to packages and reports.
• Developed complex reports with various functionalities including drill through and cascading prompts.
• Created report templates utilizing impromptu ad hoc and reports utilizing Cognos Query Studio.
• Created hierarchies in models to provide drill-down options for end-users.
• Modified the existing reports based upon the change request by the user.
• Created user prompts, conditions and filters to improve report usability.
• Resolved the performance issues of the Reports and Cubes related to query optimization, database optimization and index tuning.
• Implemented Security in Cognos Connection by creating User Groups, Users and assigning privileges to various Users for accessing Reports.
• Created Power cubes using Transformer for multi-dimensional cross sectioning and drill down analysis.
• Developed Data Flow Tasks using SSIS and scheduled jobs.
• Enabled users to access the distributed HTML reports through local network folders, intranet and via e-mail.

Environment: Cognos 8.2 Framework Manager, Report Studio, Query Studio, Analysis Studio , Transformer 8, SSIS, SQL Server 2005, Windows XP, MS Excel, Erwin 3.5.

Confidential

ROLE: MANUAL TESTER/ COGNOS DEVELOPER

Responsibilities:

• Worked with Business Analysts for requirement gathering and business analysis for any new enhancement in Cognos 8 reports. Involved in making project plan, forming the analysis and migration team.
• Developed new reports in Cognos 8 Report Studio Query Studio.
• Created ROLAP models and published for Analysis Studio and trained business users for Analysis Studio.
• Involved in the analysis and migration team and analyzed all Impromptu Catalogs to get the information for impact analysis.
• Used the utilities migartetoc8 and deploytoc8 to migrate impromptu reports and catalog into Cognos 8
• Troubleshoot and resolved errors while migrating packages from Cognos 7 series to Cognos 8 series.
• Used Framework Manager to import those converted catalogs as a data source and published the package into Cognos Connection.
• Involved in Strategic Planning for Cognos 8 Framework Model Master model, Segments, Governs, Cardinalities, VSS and Security .
• Used VSS for change management CCR and abide by the company Security Standards.
• Automated job scheduling and monitoring done through the Event Studio.
• Testing and Documentation of the reports and troubleshooter the issues on ad hoc basis.

Environment: Cognos 8.0 Framework Manager, Report Studio, Query Studio, Analysis Studio , Transformer, SQL Server 2005, MS-Excel, Windows XP.