EXPERIENCE SUMMARY:

• Expertise in Cognos BI Modeling and Report Authoring using Cognos 10.1.1, Cognos Series 8, Cognos Series 7.0 and cognos Report net.
• Having 7+ years of experience in Business Intelligence and DWH/Database Applications on multiple domains. Strong abilities and Hands on experience in analysis, design, testing, development and implementation of client/server and web applications.
• Strong knowledge on Data Warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Working knowledge of designing multidimensional architecture for Extract, Transform and Load environment with Informatica. Solid understanding of data warehousing, OLTP and OLAP concepts.
• Created, modeled and published packages in Framework Manager from multiple databases for use with Report net, Report Studio, Query Studio and Analysis Studio.
• Involved in Metadata modeling using Framework Manager, creating Projects, Models and Packages, Security, Parameter mapping and Complex Reports building with Report Studio.
• Experience in Data Archiving using Cognos Report Studio, Framework Manager and Transformers.
• Through understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.
• Expertise with Framework Manager, Cognos BI 10.1.1/8.4/8.3/8.2/8.1/8.0/CRN, Cognos Connection, Report Studio, and Query Studio, Event Studio, Metric Studio and Analysis Studio.
• Developed Reports for Mobile phone applications Cognos Mobile Reports. Developed complex, dashboard reports for Mobile Applications.
• Proficient in SQL* plus and PL/SQL. Extensive experience with SQL and sound working knowledge of Oracle10g/9i/8i Database (including stored procedures and SQL programming).
• Experience in working with various databases that include Oracle, SQL Server, Teradata and DB2 Databases.
• Extensive Experience in Design Business Model (Foundation Layer/Business Layer/Presentation Layer), Dimensions using Cognos 8 Framework Manager.
• Strong background in building Relational and Dimensional model in Framework manager.
• Experience in advanced reporting like List, Cross tab, Repeater, charts and Dashboards using cognos8 report studios and ad hoc reporting using cognos8 Query Studio.
• Good exposure in Interacting with Business users to get requirements, to fix issues or train users on ad-hoc reporting. Expertise in design and reports including Dash board reports development of highly complex query.
• Experience in design, development, maintenance and support of Cognos Report Studio and Cognos Power Play reports.
• Prepared different P & C (properties and casualties) Data Models like CDM (Conceptual Data Models) and LDM (Logical Data Models) for Finance and Healthcare clients.
• Workedon different P & C elements like policy, claims, accounts, coverage, and reinsurance coverage.
• Versatile industry experience in HealthCare, Finance, Insurance and Retail Manufacturing.

SkillS:

BI TOOLS:

Cognos 10.1.1/8 series BI(Report Studio, Query Studio,
Analysis Studio, Event Studio, Metric Studio, Framework
Manager ,Cognos Connection), Cognos Series7i
(Impromptu, Power Play windows/web, Transformer Upfront),
Access Manager, Report Net 1.1 MR3, MDX

Migration Tools:

MigS7,Mig Deploy

Operating Systems:

Windows 2000/2003/ Vista/ 2008, Windows 7, MS-DOS

Software Packages:

MS- Office, Microsoft Word, Excel and Power Point vision

Databases:

MS SQL Server 2005/ 2008, Oracle 11g,10g/9i, DB2, Teradata

Database tools:

SQL*Plus 3.3/8.0,PL/SQL Developer Load

ETL/Data Modeling tools:

Informatica Power Mart/ Power Center 8.X/7.x/5.1, Data Stage 6.x., SSIS.

PROFESSIONAL EXPERIENCE:

Confidential, Hartford,CT March 2012- Current
Domain: INSURANCE

Role: Sr. Cognos Developer.

Responsibilities:

• Involved in Requirements gathering and specification writing after interfacing with Business Users, Line of Business Requirements and Other Stake Holders.
• Worked with project managers, Business Analyst and end users to understand business requirements and translated them in to the technical specifications.
• Designed Cognos Framework Manager Model with different views (Database View, Business View, Presentation View) using Oracle 11g as per Business Users Requirements.
• Involved in data modeling by creating/updating Logical EntityRelational Model (ERM) and published Packages using Framework Manager.
• Worked on Cognos 10.1.1 Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented stored procedure query subject in Cognos Framework Manager.
• Using Cognos 10.1.1 Report studio, created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports for Mobile and iPad Applications.
• Developed Reports with Multiple Cognos Viewers and with multiple Cognos Reports developed Complex Reports, Dashboards for Mobile and iPad Report Applications.
• Applied OLAP functionalities such as drill-down/drill-up in Analysis Studio and Report Studio.
• Customized data by adding no. of prompts, Filters, Calculations, Summaries and Functions.
• Developed complex reports using Cognos Version 10.1.1using Crosstab having different calculations, data items and customized Page Formatting.
• To improve functionality and performance created Cubes in Transformers and defined data items in cubes before publishing.
• Prepared different P & C (properties and casualties) Data sets and worked on different P & C data models.
• Wrote test scripts and queries for reports and cubes to verify data against the database.

Environment: Cognos 10.1.1 (Framework manager, Report Studio, Query Studio), Cognos PowerPlay Transformers, Cognos iPhone/iPad Reports, Access manager, Informatica 8.1, Oracle 11g , TOAD 8.6, SQL Server 2008,Windows 7.

Confidential, Philadelphia, PA Feb 2011- March 2012

Domain: HEALTH INSURANCE

Role: Cognos Developer.

Responsibilities:

• Participated in discussions with the Business users and senior management to create and gather the business requirements.
• Used Cognos Framework Manager to create different views (Database View, Business View, Presentation View) using Oracle and MS SQL SERVER Databases.
• Created Packages and DMR models in Framework Manager by importing metadata from different data sources with use of data modeling.
• Prepared logical, conceptual and Dimensional Data models using P & C data sets in Framework manager.
• Implemented stored procedure query subject in Cognos Framework Manager.
• Created users and user groups, assigned user privileges in Access Manager
• Interacted with Business Users to identify key performance indicators (KPI).
• Implemented security in Cognos Framework Manager in each level according to business users.
• Created ad-hoc report using Cognos Query Studio and SQL reports using Cognos Report Studio.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports for Mobile Applications.
• Created multiple layer reports providing a comprehensive and detail report with drill through facility.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Developed reports using System Development Kit (SDK) by java scripts at the back end.
• Created multi-dimensional cubes in Cognos Transformer using Impromptu Query Definition (IQD) generated from Cognos Framework Manager.
• Trained users to make their own ad-hoc reports using Cognos Query Studio.

Environment: Cognos 10.1 (Framework manager, Report Studio, Query Studio, Metric Studio), Cognos Power play Transformers, Cognos Mobile Reports, Access manager, Informatica Powercenter 8.0, Oracle 11g , TOAD 8.6,Windows7.

Confidential, Washington, DC Mar 2010 - Jan 2011

Domain: Tax Aide.

Role: Cognos Developer.

Responsibilities:

• Worked with project managers, Business Analyst and end users to understand business requirements and translating them to technical specifications.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Involved in data modeling by creating/updating Relational Model and publishing packages using Framework Manager.
• Worked on Cognos8.4 Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages.
• Apply OLAP functionalities such as drill-down/drill-up in Analysis Studio and Report Studio.
• Worked extensively with the Distribute the reports and dashboards widely with the right content distributed to the right recipient by executing a single report.
• Created Business views, namespaces, model query subjects in Framework Manager Model for easier report development and to enhance multi user environment.
• Proven experience in building Complex Reports using prompts and parameters in Report Studio.
• Technical Design of Reports, Report bursting and Report Distribution.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Involved in development of the Web Intelligence and Full Client reports.
• Cognos Multidimensional Cube development using Cognos Power play transformer and Report generation on Cognos Power play cubes.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Cognos Power PlayTransformer and published the Cubes.
• Developed test plans, scripts and test cases for Unit, Integration, Regression, UAT

Environment: Cognos 8.4/8.3(Framework Manager, Report Studio, Query Studio, Metric Studio, Event Studio, Power play Transformers),Oracle 10g, Informatica ver. 7.1.2, MS Excel 2003, SQL Server 2005,Windows XP.

Confidential, Dallas, TX Nov 2008 - Mar 2010

Domain: Financial

Role: Cognos Consultant.

Responsibilities:

• Worked in building Relational models and multi Dimensional packages and published packages to Cognos Connection using Frame Work Manager and created daily, weekly and monthly reports using those packages.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, cascading using different prompts.
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Extensively worked on complex reports using tabular sets, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Customized data using prompts, Filters, Calculations, Summaries and Functions.
• Developed Prompt pages and Conditional Variables.
• Involved in designing and building the PowerPlay cubes using Transformer.
• Built Power Play Reports based on these cubes and published to ReportNet Server.
• Administering the business users in the portal based on the requirements.
• Production Support which involves solving user problems.

Environment: Cognos 8.4 (Report Studio, Analysis Studio, Framework Manager, Query Studio), Oracle 9i, DB2, Data Stage, Microsoft SQL Server 2005/2008.

Confidential, Pune, India June 2007 -Aug 2008
Domain: Financial

Role: Cognos Developer / Analyst.

Responsibilities:

• Involved in gathering business requirements and understanding the complete SDLC through Business Analysts and front end users.
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created different Data sources and Created model using different Data Sources and created packages and published to the cognos portal.
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Involved in migration of cognos 8.0 version from cognos 7.3 versions.
• Extensively worked on complex reports using tabular sets, child tabular models, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Created user groups, Roles to implement the Cognos security using Accessmanager.
• Customized Cognos Connection Portal to personalize the homepage.
• Created the documentation for cubes & Reports. Testing and Validating the Reports.
• People Soft ERP is used to store all the source data and Decision Stream as well as Microsoft Integration Services (SSIS) is used to extract, transform and load between the source and the target databases.
• Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.

Environment: Cognos 8.0 (Framework Manager, Cognos Connection, Report Studio, Query Studio), cognos 7.3, Report Net1.1/1.2, PeopleSoft ERP, Oracle9i,Teradata, Informatica 5.1, SQL server 2005.

Confidential, India, Mumbai, India Jan 2005 - May 2007
Domain: Manufacturer

Role: Software Engineer.

Responsibilities:

• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Interaction with the Management and Development teams for gathering information for creating the FrameworkModel.
• Involved in Data Modeling and published the Model using FrameworkManager.
• Worked extensively on creating the Model and publishing the package on CognosConnection for Reporting purposes.
• Used conditional formatting and conditional blocks to display different sets of data based on different conditions in Report Studio.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on QueryStudio for Ad-Hoc Reporting
• Created filters within the Model for improving the performance of the Model.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Created Catalog in Impromptu Administrator to create Web Reports, Created Cubes by using Cognos Power Play for analysis.
• Optimized the cube performance and the report response time.
• Created Stored Procedures for Updating and Inserting data into the database.

Environment: Cognos 8.0 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos 7.0 (Power Play Enterprise Server), Oracle 9i, MS SQL Server 2000.