SUMMARY

• 7+ Years of experience in Business intelligence reporting, development, analysis, design, testing and implementation of Cognos applications and maintenance of Data warehouses, Database, Data Marts and providing solutions for Finance, Banking, and Health Care domains.
• Experienced in various Cognos tools such as Cognos10 Suite (framework Manager, Metric Designer, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio)
• Expertise in Report building using Report Studio, Query Studio and Analysis Studio.
• Extensive experience in creating Complex reports using Customized prompts, Conditional formatting, Drill through relationships and Master Detailed Relationship.
• Experience in creating and translating information from various corporate systems and data into visually rich Dashboards using gauges, Maps, Charts, and other Graphical elements.
• Developed and Published Packages using Framework Manager - Connecting and testing teh data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Worked wif business users/Business Analysts to gather and document teh requirements. dis information was used for enhancing teh package and developing new reports
• Experience in setting up user groups, Cognos Active Directory roles and Data Differentiator model to assign User Permissions and to enable folder & data security.
• Setup row level security using Session Parameters and Security Dimension in Framework Manager
• Automated reports generation according to a schedule or by trigger using Cognos Scheduler.
• Involved in Migration and deployment of reports, metadata, packages & models from IBM Cognos 8.4 to 10.1
• Prior involvement in end-to-end BI Life Cycle Development Process - Requirement Analysis, Feasibility Study, Design Documentation (Functional Requirements Preparation, Technical Design), Specification Definition, Development, User Walk-through and demo, Testing, Maintenance, Post-deployment check-out and Production Support.
• Experience in Administration tasks of Cognos 10 BI Suite
• Experience in Deployment (Export, Import) in Cognos Administration and Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing Database schemas like Star Schema and Snowflake Schema.
• Performed different Test scenarios (Unit, System & Integration and UAT).
• Extensively worked on Relational databases like Oracle, SQL Server, DB2 and Teradata
• Extensive one to one interaction wif end users/Business analysts to identify their needs and wants, tan translate teh functional requirement into reporting requirements, design and business data flow.

TECHNICAL SKILLS

BI Tools: Cognos 10.1 Suite, Cognos 8.X (8.1, 8.2, 8.3, 8.4) (Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection, Framework Manager), Cognos Impromptu 7.x/6.x, Power Play Transformer 7.x/6.x,Cognos Power Play 7.2/7.0/6.6, Access Manager 7.0, Impromptu Web Reports (IWR) 7.x, Tableau

ETL Tools: Informatica, Data Manager.

Operating Systems: Windows XP/Vista/7, UNIX, LINUX

Languages: SQL, PL/SQL, SQL Plus, TOAD

Databases: ORACLE 7.x /8i, 9i, 10g,11g, MS SQL Server 2000/2005/2008 and MS Access, TERADATA,DB2

Data Modeling Tool: ERWIN, Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Sr. Cognos Developer

Responsibilities:

• Involved in frequent JAD sessions wif teh Business Users in requirement gathering and documenting teh Business Requirement Documents prior to reporting.
• Worked Extensively in Cognos Suite 10.1 which involves Data Modeling using Framework Manager, built reports off Report studio.
• Worked in building reports out of Cognos 10.1 Report Studio.
• Imported tables, views and stored procedures from SQL server database into Framework Manager and created relations and filters in teh model.
• Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.
• Developed Reports using Conditional Formatting and Cascading Prompts. Developed List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page reports.
• Developed and unit-tested list, cross tab, master-detail and Drill-through reports using data model and Pass-thru SQL.
• Standardized reports to maintain uniformity across teh organization.
• Worked on teh Active Reports to provide teh interactive behavior outputs to teh users. Created tabbed reporting wif complex calculations/formatting.
• Worked wif Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Involved in user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for teh same.
• Maintained Security via LDAP and Cognos Administration, in assigning roles to teh user groups and assigning teh same to teh Folder Structure in Cognos.
• Resolved Administration issues such as maintaining teh parameters effecting teh output of teh reports, setting up teh Audit Logging features, maintaining teh Cognos environment in events of database upgrades.
• Experience in deploying teh Reports as well as Content stores from one environment to another using File Transfer Protocol (FTP).
• Resolved critical production issues wif quick turnaround times.
• Experience in using Cognos Connection to organize and schedule reports based on teh user requirements.
• Supervised Off-Shore resource for Cognos Reporting.
• Experience in using SQL to validate reports

Environment: Enterprise DWOracle 10g, Oracle 11r2, Windows XP, Vista, ROLAP, Cognos 10.1 Report Studio, Query Studio, LDAP, and Cognos Access Manager.

Confidential, El Segundo, CA

Sr. Cognos Developer/Administrator

Responsibilities:

• Developed reports, maintained and provided Production support for multiple projects simultaneously.
• Provided end-to-end support, maintenance and enhancements to teh Cognos reporting framework (security, data model, packages and reports).
• Created reports primarily focused on providing Yearly and Quarterly Revenue and Profit Accounting.
• Wrote Technical Design documents, Supplementary specifications, designed Active Directory Security model, Data Differentiator model, user groups and access request tool changes.
• Presented pre-implementation Cognos reporting sales pitch & post-implementation walk-through to business end-users in collaboration wif Business Analyst.
• Proposed and implemented Cognos environment improvements and Cognos reports' performance improvements to increase productivity.
• Completely revamped reporting environments for a couple of applications reducing total number of maintained reports by extensive use of parameterized reporting & Report Views to reduce number of maintained reports by 80%.
• Improved Cognos Framework manager model by breaking loops in data model wif teh use of alias shortcuts.
• Created Active Directory roles to enable folder access and sign-on security permissions in Cognos Connections.
• Migrated reports, packages, and models from IBM Cognos 8.4 to 10.1 and from Test to Production.
• Worked extensively on Conditional Formatting using prompt parameters, Conditional Blocks, conditional styles, render variables, conditional variables and classes.
• Maintained Security via LDAP and Cognos Administration, in assigning roles to teh user groups and assigning teh same to teh Folder Structure in Cognos.
• Experience in using Cognos Connection to organize and schedule reports based on teh user requirements.
• Applied row level security on query items to ensure data security using Session Parameters and Security Dimension in Framework Manager.
• Enhanced and maintained Framework Manager models to support new reporting requirements.

Environment: Enterprise DWOracle 10g, Windows Vista, Cognos BI 8.3Deployed - Report Studio, Query Studio, Analysis Studio and Metric Studio. Cognos Data Manager, Cognos Access Manager.

Confidential, Indianapolis, IN

Cognos Developer

Responsibilities:

• Involved in requirement gathering during teh business analysis and planning phase of teh project.
• Built Framework Manager Models and established teh cardinalities to suit teh business needs.
• Created list, cross tab, chart reports including report studio features such as filters, calculations, prompts, Conditional Formatting, sections and Page Breaks.
• Developed various report formats, based on teh user requirements.
• Created Drill- through and Master -Detailed Reports wif Prompts (List. Cross tab).
• Involved in Cognos Administration using Cognos Connection for security implementation, scheduling, distributing reports and performance tuning of teh application server (tomcat).
• Developed various complex models in framework manager which included teh tables from two different data sources i.e. SQL SERVER and ORACLE.
• Developed Adhoc reports using Query Studio and mentored business users on query studio.
• Configure, support and maintain online BI applications and SQL reporting.
• Performed Data validations, Unit testing and preparation of Unit test cases while prompting reports to QA & UAT
• Resolved issues resulting from User Acceptance Testing (UAT).S
• Provided extensive end user support and training on Ad-hoc reporting using Query Studio & Analysis Studio.
• Documented Entire Data Flow, Program Development, Logic, Testing, Changes and Corrections.

Environment: Cognos8.x (Framework Manager, Cognos Connection, Cognos Report Studio, Query Studio, Analysis Studio, Transformer) SQL Server, Oracle10 g, Toad.

Confidential, Des Moines, IO

Cognos Developer

Responsibilities:

• Working wif data modelers and provided them wif queries required to develop teh facts and dimensions in teh data model.
• Tested teh Metadata model and relationships in Framework Manager.
• Created various reports like lists, cross tabs, charts, complex reports wif conditional block, static choices in prompt etc.
• Used Query Studio for developing Ad hoc reports and Report Studio for developing Dash Boards.
• Used joins to extract data from different tables.
• Created calculations, filters, prompts and conditional formatting in Report Studio reports.
• Developed hide and show reports by using Conditional blocks.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Moved and deployed reports from Development to testing and production servers using Content Administration.
• Upgraded reports from Cognos 8.3 BI to Cognos 8.4 BI.
• Provided administration support and Development support for production issues.
• Scheduled and distributed reports using Scheduler in Cognos Connection.

Environment: IBM Cognos 8.4.1/8.3- Framework Manager, Report Studio, Analysis Studio, Query Studio Cognos Transformer, Power play Web, Oracle10g, Informatica 8.1.

Confidential

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing teh source data from different databases.
• Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements.
• Installed and Configured Cognos 8 BI Suite in multi-server environment on Windows and UNIX environments.
• Created Complex Reports using Cognos 8 BI Report Studio and Ad-hoc web based reports using Cognos 8 BI Query Studio.
• Developed various Complex report types ranging from simple Lists, Cross-tabs through complex dashboards, drill-through, Master-detail & conditional formatting reports for both HR and end-users
• Created Complex Dash Boards and published into connection portal.
• Created Member based security, Custom/ Dimension views, Apex custom views and cloak.
• Created Scheduled Jobs by (Triggers) and scheduling multiple reports a job.
• Tested and validated teh report output against teh database to measure performance of reports.
• Deployed Reports, Packages and Folders from DEV to UAT and from UAT to PROD Environments. Used Informatica Source Analyzer and Warehouse Designer to import teh source and target database schemas and teh mapping designer to map source to teh target.

Environment: Cognos 8.4/8.3 BI( Report Studio, Query Studio, Analysis Studio, BI Modeling, Framework Manager, Cognos Connection), Report Net 1.1, Cognos Series 7.4, Power Play Transformer, Migration Utility Tool, Oracle 10g,DB2, PL/SQL, UNIX and Windows 2000,SQL server 2005/2008

Confidential

Cognos developer

Responsibilities:

• Modified existing Cognos reports and model files in Framework manager.
• Implemented parameter maps to teh existing Framework model.
• Added additional columns and new filters to teh existing Cognos reports as per teh request.
• Created conditional blocks and conditional formatting in teh reports.
• Implemented Governor Settings and published teh packages using Framework Manager.
• Involved in bug fixing and created few complex calculations in teh report.
• Done complete testing of Cognos Reports and validated data using Database.
• Move teh Cognos Framework Manager Models and reports from development, test environment to production environment.
• Documented functional and technical requirements for teh meta data modeling and BI reports.

Environment: Windows XP, Oracle 10g, Cognos 8( Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio.