Summary of Experience

• Over 10years of IT experience in Enterprise Business Intelligence lifecycle implementation and Cognos BI tools
• Extensively worked on Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio for designing reports usingCognos Suite.
• Strong experience as a Report Author with experience in gathering requirements, assessing, developing project designs, tests, research and data analysis.
• Expertise in developing and testing Complex reports List, Cross tab, Charts, Maps, Drill
• through, Master-Detail, and Cascading and Dashboards using Report studio
• Expertise in Installing and configuring Cognos BI Server 8.4/cognos 10.1.1 using distributed Servers methodology.
• Experienced in building multidimensional models and creating Power Cubes for distribution using PowerPlay Transformer and Power Play reports.
• Strong experience in creating cubes using DMR.
• Expertise on cognos security configuration like Access Manager Administration, Active Directory, LDAP and NTLM.
• Good at Planning, Designing, Implementing and deploying Cognos solutions for the client
• Experience in maintenance, support, change-control and end-user training as part of setting up a sustainable BI life cycle.
• Proficient in all the phases of Data Warehousing concepts
• Experience in dimensional and relational modeling in Star Schema and Snowflake Schemas.
• Experience in cognos Virtual View manager VVM
• Expertise in multiple relational databases includes Oracle 9i, 10g , MS SQL Server 2000 and MS SQL Server 2005.
• Experience in SQL, SQL Plus,TOAD, SQL Programmer, SQL Developer, Stored Procedures Triggers.
• Involved in daily batch loads Full Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services SSIS 2005 and DTS.
• Participated in the complete life cycle development process in data warehousing.
• Proficient in developing and executing test plans based on system and validation requirements.
• Strong business knowledge of Financial,Healthcare, Retail and CRM domains
• Experience in Cognos TM1
• Strong Knowledge on Teradata
• Experience in Microsoft Bi suite, SQL Server Reporting Services SSRS and Report builder.
• Experience in Business Objects XI
• Proven ability to deliver and ensure success in high-pressure/high-risk situations.

Technical Skills

BI Tools : Cognos 10.1/8.0/8.2/8.3/8.4 BI Framework Manager, Report Studio,

QueryStudio, Analysis Studio, Metric Studio, Event Studio, SQL Server

Business Intelligence Development Studio SSIS, SSRS , Business

Objects XI

ReportNet1.1 MR1/2 : Cognos Connection, Framework Manager, Query studio, Report Studio,

Cognos Configuration

Cognos Series 7.x : Cognos Impromptu, Impromptu User, Impromptu Web Reports,

Cognos Power Play Transformer, Power Play User, Power Play Web

Reports, Power Play Enterprise server, Access Manager

ETL Tools : Informatica 7.x. Decision Stream, Data Stage.

Databases : Oracle 10g/9i, MS SQL Server 2008/2005/2000,

MS Access and Teradata

Web Servers : ApacheTomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0/7.5

Programming : C, C , Java, UNIX Shell Scripting, SQL, T-SQL, PL/SQL, HTML, XML

Environment :Windows XP/2000/98, Win NT,oracle 10g

Other Tools :SQL Plus, Toad, andMS-Office

Professional Experience

Confidential

Role: Senior Cognos Developer/Administrator

Responsibilities:

• Created Framework models, queries according to standards.
• Testing the report data with the PL/SQL stored procedures
• Created and published packages to Cognos Connection
• Re-designed Framework Manager Model to leverage Best practices to ensure predictable queries.
• Established framework for gathering and analyzing business requirements designed a star-schema datamart to meet requirements developed Cognos solutions to deliver information trained client's staff
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers
• Performed detailed documentation of design, development, testing and deployment activities
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 10.1and 10.2
• Developed filters, calculations, prompts, conditions, and created various reports, using Report Studio for users
• Worked with Relational Databases - Oracle and MS SQL and involved in ETL team discussions
• Designed, developed, administered and deployed Cognos Cubes based on requirement.
• Made judgments and took decisions while addressing complex business issues with minimal supervision
• Maintained source/version control for Cognos models, reports and involved in Documentation for user training
• Created the Key performance metric Dashboard Reports using the Cognos Report studio.
• Developed Ad Hoc Reports Using Business Insight Advanced, Query Studio and complex reports using Report studio
• Created the dashboard report using workspace and workspace Advanced.
• Created interactive reports using active reports
• Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.
• Created user roles in Cognos Connection
• Scheduling the monthly reports with saved prompts using Job Wizard
• Writing the test cases for SIT System Integration testing and UAT User Acceptance testing .
• Testing experience in SIT System Integration testing and UAT User Acceptance testing .
• Installed and configured Cognos products on server, distributed and client machines
• Maintained Cognos security using access manager
• Maintained Development/QA/Production Environments, including new installations, upgrades and fix packs
• Moving/deploying reports from Development to testing and production servers using Content Administration.
• Migrated content from Cognos 8.4.1 to Cognos 10
• Designed complex reports using report studio and performed UAT
• Performed regular administration tasks like content store backup and server maintenance.
• Provided technical support on day-to-day basis and troubleshoot installations.

Environments:

Cognos 10.2 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio,

Metric Studio, Metric Designer, Metric Studio Event Studio , Power Play Transformer, Cognos Access Manger, LDAP, Oracle 11g, Windows 2003 Server, Unix Shell scripting, Oracle E-Business Suite, Shell scripting, UNIX, Tomcat/Apache.

Confidential

Role: Senior Cognos Administrator /Developer

Responsibilities:

• Prepared Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by client's Systems Development Lifecycle.
• Developed Framework Model against ORACLE, Sql Server 2008databases with filters and calculations
• Developed DMR against underlying query subjects and defined scope relationship between regular dimension and measure dimension.
• Created the star schema grouping between measure dimension and regular dimension
• Defined business key and member caption for hierarchies.
• Edit/Delete the scope relationships
• Created Complex reports like the Multipage reports, drill though reports and conditionally formatted reports including graphsand images.
• Created, refreshed and supported Cognos Transformer models and cubes
• Developed dynamic reports to sort on column headers by implementing Java scripts as HTML items and without JavaScript.
• Created Conditional Block reports to dynamically hide or show report objects and provide the end userthe option to view the data in different formats.
• Developed Cascading prompts to filter data dynamically and conveniently locate the data the users are trying to use.
• Developed complex reports, multi-query reports and sub-selects queries to meet the client requirements.
• Developed List reports, crosstab, Dashboard reports, active reports and also created Business Insights in Cognos 10.1
• Created Business Insight
• Developed interactive Dashboard reports using Business Insight and Business Insight Advanced.
• Imported Cognos reports into Excel and formatted those using Cognos 8 Go Office and scheduled them.
• Using the Cognos Scheduler Schedule Management tool , scheduled the long-running reports to provide static views to the business user.
• Implemented custom JavaScript code to customize prompts/reports and developed several custom Cognos SDK applications
• Install and Configure the Cognos 10 Server Components on Windows 2008R2 servers for DEV, TEST and PROD Environment.
• Configured the Cognos 10 gateway in IIS Server on Windows Server.
• Involved in upgrade Cognos 8.4 to Cognos 10.1
• Deployed the reports/packages/ folders from Dev to UAT and UAT to Prod
• Performed Administration activities such as granting access to the users, modifying the distribution list and Deployment.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Involved in fixing the issues of the reports after migration of the reports from Cognos 8.2 to Cognos 8.4 reports.
• Upgraded the content store from cognos 8.4 to Cognos 10.
• Applied Security based on user roles and published reports.
• Involved in daily batch loads Full Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services SSIS 2008.
• Developed Reports and Dashboards using Active Reports and Business Insight.
• MigratedSSRS reports to cognos 8.4
• worked in Business Objects production support
• Created simple list reports using Business Object Designer
• Involved in Offshore/ Onsite call coordination's and Production support issues.
• Supported users from Australia ,UK and Singapore,

Environment: Cognos series 10.1.1/8.3/8.4, Framework Manager, Access Manager, Cognos Connection, Transformer, Cognos TM1, VVM,SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio SSIS, SSRS , .Net framework, Microsoft Office Share Point Server, Oracle 10g, Toad, SQL Programmer, Teradata, SQL Developer and Windows XP

Confidential

Role: Cognos Developer/Administrator

Responsibilities:

• Responsible for understanding Business Process and specific business needs from Business users
• Metadata modeling of both Relational and Dimensional data using Framework manager
• Queried data from different database tables as per the requirement.
• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created packages using multiple data sources in the framework manager.
• Created Calculated Levels based on Business Requirement to perform Analysis using Analysis Studio.
• Created highly complex and formatted reports in Cognos8 using most of the Cognos functionality such as Conditional Formatting, Drill Through, Repeaters, and Discontinuous Crosstabs, Dashboards etc.
• Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
• Administration and maintenance of Cognos Reporting Application which includes installing patches, fixes and deployment of code to higher environments.
• Provided support and troubleshooting problems as required
• Design and Development of Data Warehousing reports on Cognos Transformer, Analysis Studio and Power play.
• Created OLAP cubes using Power Play Transformer against various data sources like Oracle Flat Files.
• Creating and maintenance of Cognos data source with custom security for each user group
• Scheduling and maintenance of monthly and weekly reports
• Setting and maintenance of Dashboards and distribution of Cognos reports file system and bursting of the reports Network Bursting, Directory Bursting Email Bursting
• Responsible for Auditing reports in all 4 Cognos environments Dev/ Test,UAT,Training,Production
• Involved in Offshore/ Onsite coordination to discuss the requirements and development effort
• Lead development team located in offshore location
• Responsible for maintenance and backup of Content store all the environments
• Hands on experience on Performance tuning and Optimization of the reports and FM models.

Responsible for troubleshooting the issues resolving the open tickets created by user for application reports.

Environment: Cognos 8.3 Framework Manager, Query Studio, Analysis Studio Report Studio, Deployment Manager , Oracle 10g, 9i, MS Access, TOAD, Windows

Confidential

Role:Cognos Developer

Responsibilities:

• Assisted System Administrators in Cognos Migration from series 7 to 8
• Involved in data gathering and developing models in Framework Manager and publishing the packages onto Cognos Connection.
• Converted as many as 50 reports from Series 7 to Cognos 8.
• Implemented Package level security and object level security in Framework manager
• Created Simple List reports, Cross-tab reports, Conditional formatting and Drill - through Reports using Report Studio.
• Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
• Worked using OLAP tool, Power Play for building cubes and reports that meet the business requirements.
• Experience in building multidimensional cubes.
• Involved in creating complex reports involving stored procedures with parameters.
• Optimized cubes by selecting appropriate methods, which include partitioning, time-basedpartitioning, cube groups and incremental updates.
• Tuned transformer models for faster cube builds and access times.
• Provided documentation to the end users and conducted training workshops.

Environment: Cognos 8.1, Cognos Report Net Framework Manager, Query Studio, Report Studio, Deployment Manager , Cognos 7, Oracle 9i, Windows NT/2000

Confidential

Role: Cognos Consultant

Responsibilities:

• Validate the Report Spec according to the existing model
• Created logically complex list reports according to the client requirements
• Developed the reports using tabular model, tabular Sql, and tabular set
• Created Reports using with Cross tab, section Reports
• Created Text, value Prompts, Date Range, Cascading Prompts, Calculations, Filters
• Involved in various discussions with end user to analyze Meta data
• Created different Packages and Models based upon the Requirements and published them to Cognos Connection.
• Created shortcuts to all cubes, dashboards and other reports in BI and scheduled them every day.
• Tested all the reports including dashboards and created a template and solved many kinds of issues like Conditional Formatting to the Dashboards, and many other issues in Report Studio.
• Created simple and complex reports using Report Studio
• Developed Dash boards including custom charts, cross tabs, drill-through
• Designed and implemented data cubes using Microsoft OLAP services, Cognos Impromptu and Power Play to facilitate executive, management and end user reporting.
• Created Multiple Reports with COGNOS Impromptu and Power Play.
• Updated Impromptu Catalog by adding tables and creating new joins
• Created standard and Ad hoc reports using Cognos Impromptu tool.
• Developed Multi-Dimensional Cubes using Power Play

Environment: ReportNet, Framework Manager, Cognos Connection, SQL Server 2000, DB2, Cognos Impromptu 7.1, Cognos Power play 7.1, Cognos Transformer 7.1, Impromptu Web Reports 7.1, Oracle 8i