PROFESSIONAL SUMMARY:

• Around 8+ Years in Cognos Analytics 11, Cognos 10.2.2, 10.1, 8.4, 8.3 (Query Studio, Report Studio, Analysis Studio, Business Insight/Workspace, Business Insight/Workspace Advanced, Metric Studio (Score checking), Framework Manager, Cognos Connection)
• Experienced in Installation and Configuration of Cognos BI Products in distributed environment on Windows.
• Expertise with Framework Manager Modeling (Physical Layer, Logical Layer, Business Layer) and Complex Report working with Report Studio.
• Experience creating complex reports utilizing drill - through reports, prompts, dashboards, burst-reports.
• Expert in creating dashboards, giving security to dashboards according to the specifications and authorization rules.
• Good Experience with MDX Functions in Report Studio utilizing Multi-dimensional Sources.
• Extensive involvement with Cognos security (LDAP, Active Directory, Access supervisor, object level security, information security).
• Experience in creatingCascadingPrompts, Filters,Grouping, Sorting, Sectionand Conditional Blocks
• Have 8+ years of experience creating Active reports.
• Have good experience in creating Ad-Hoc reports by using Query Studio/Cognos Workspace Advance and also trained users how to use these tools.
• Created dimensions and cubes using TM1 Architect, Turbo integrator and Performance Modeler
• Created Scorecard cubes in Cognos TM1 Performance Modeler.
• Extensively used TM1 TI for loading data into Dimensions and Cubes, added new dimensions and cubes to existing environment.
• Experienced in Model deployment between different Cognos TM1 servers
• Created subsets, cube views, picklists and data links (move data between cubes)
• Experienced with writing rules and feeders and created drill through processes
• Created chores to schedule Turbo Integrator process
• Performed BI dimensional reporting on TM1 cubes

TECHNICAL SKILLS:

BI TOOLS: Cognos Analytics11 (Business Insight, Business Insight Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Framework Manager), Cognos TM1 10.2.2, 10.1,9.5.2, 9.4 Business Objects XI Rel2.0, Report Net 1.1 MR3, MDX

Microsoft BI Tools: SSIS, SSRS, SSAS

Migration Tools: MigS7, Mig Deploy

Other Reporting Tools: Tableau 9/9.2, MicroStrategy 8.1/ 8.0.2/ 7.5, QlikView 11x

Databases: MS SQL Server 2005/ 2008/2010/2012 Oracle 11g,10g/9i, Teradata 12/V2R6, DB2 8.0, Exadata, Netezza

Database tools: TOAD, PL/SQL Developer

ETL/Data Modelling tools: Informatica 8.6/9, Power Mart/Power Center 8.X, IBM DataStage 7.5, Cognos Data Manager

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

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Cognos BI Developer

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement..
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 10.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created Dashboards using Cognos Workspace comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.

Environment:, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio), Transformer, Cognos SDK, Oracle 10g/11g, Custom Java Authentication Provider (CJAP)

Confidential, Sacramento, CA

Sr. CognosDeveloper/ CognosTM1 Developer

Responsibilities:

• Installed and configured Cognos Analytics 11 on R&D servers.
• Developed some POC reports using Cognos Analytics 11.
• Involved in meetings with the users which included discussing and gathering the business requirements, reporting enhancements, changes and issues.
• Worked on enhancements and modifications of the Meta data models using Framework Manager.
• Used Framework Manager to create different layers like Database Layer, Transformation Layer and Presentation Layer by defining appropriate relationships between query subjects.
• Designed Meta Data Model’s - Packages in Framework Manager.
• Created Packages in Framework Manager and published them to Cognos connection.
• Worked on the Enhancements and Changes in the existing reports based upon the new requirements from the end users.
• Developed Active reports for marketing team to access reports on Tablets and iPhone as an offline solution.
• Developed various kinds of Reports like Lists, Crosstabs, Charts, Drill through Reports, Master Detail Reports, Repeater Table in Report Studio and Cognos Workspace Advanced.
• Created user Notification reports and created agents using Event Studio.
• Used different functionalities like Cascading Prompts, Optional prompts, Conditional Formatting, Conditional Variables, Render Variables, Page Break, Page Sectioning, Drill through, Drill Down, Drill up, Bookmarks and Conditional Blocking.
• Improved the report performance by analyzing and comparing the turnaround times between Database and Cognos.
• Created Dashboards using Cognos Workspace comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Worked closely with the ETL and QA teams and involved in meetings to discuss test case documents and resolve any kind of issues reported during the testing process.
• Wrote simple to complex SQL queries in the process of unit testing of the reports.
• Involved in Scheduling and distributing the reports using Cognos administration.
• Created the export and import packages in content administration.
• Worked closely with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.
• CustomizedCognosData Source Connection with appropriate reports and security measures.
• Created Standard Template design for report studio reports and Created ad hoc reports using Cognos Workspace Advanced.
• Created Sales dashboard for Sales Department using Tableau Desktop and published work book to Tableau server.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Installed and Configured Cognos TM1 and various components.
• Conducted sessions to help users generate reports to meet their daily reporting needs. Creation of dimensions cubes and processors using TM1 architect for Finance team.
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Created TM1 Workflow process and assigned the Task to TM1 Users. Created reports using TM1 web base application.
• Creating TM1 Application by adding TM1 objects and External files to an application
• Loading and Maintain Data in Cube using Turbo Integrator. Optimize the Rule Performance by adding SKIPCHECK and FEEDERS. Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.

Environment: Cognos Analytics 11, Cognos 10.2.2/10.1 (Report Studio, Cognos Workspace Advanced, Cognos Workspace, Cognos Connection, Framework Manger, Query Studio, Event Studio), Cognos TM 1 10.2.2/10.2.1, TM1 Architect, TM1 Web, Turbo Integrator, Tableau Desktop 9.2/9, Tableau Server, Oracle 10g/11g, SQL Server 2008/2010/2012, SSIS, Informatica 9, TOAD Data Point 3.4 .

Confidential, San Diego, CA

Sr. Cognos Developer / TM1 Developer

Responsibilities:

• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
• Used some advanced features likeConditional Formatting, Conditional blocksinReport Studioin generating multipage Reports
• Implemented Star Schema grouping methodology and 2 layer/3-layer approach in Framework Manager
• Worked on performance tuning of existing reports and models.
• Implemented report bursting to distribute reports effectively.
• Regular interaction with users and intensive user requirement gatherings.
• Developed more than 2000 reports including Active reports, Dashboard reports, dimensional reports using Report Studio, Query Studio, Business Insight, Analysis Studio
• Designed and Implemented 40 Relational and DMR (dimensional) metadata models in Cognos Framework Manager using Cognos Best Practices
• Developed reports using Power Play Studio, Drill down, slice and dice and change displays, Analysis of Power Play cubes in Analysis Studio
• Successfully designed and implemented security on different levels including object and row level security.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication technique
• Prepared materials, developing Business models and users in Query Studio according to their specific needs and requirements.
• Created dimensions and cubes using TM1 Architect and Turbo Integrator
• Created Dynamic cubes using IBM Cube Designer 10.2
• Developed advanced dashboards in business insight for commercial sales department which includes Activity, Alignment, Sales and Prescriber data.
• The Cognos BI Architecture is web based.

Environment: Cognos 10.1, Cognos 10.2, Cognos 8x (Framework Manager 10.2, Cognos Connection 10.2, Powerplay Transformer 10.1, Dynamic Cubes, Business Insight 10.1, Business Insight Advanced 10.1, Report Studio 10.2, Query Studio 10.2, Dynamic Query Mode (DQM), Analysis Studio, Cognos TM1,Teradata 12, Netezza 7.2.0,Netezza 7.1.0, Motio

Confidential, Chicago, IL

Cognos BI Developer

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Created metadata models using Framework Manager with relational data and deployed packages to the CognosReporting Servers.
• Designed and Developed DMR models using regular & fact dimensions in Framework Manager.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed Framework Manager Models against Teradata and Oracle Database.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Create and enforce polices for effective data management.
• Establish rules and procedures for data sharing with upper management, stakeholders etc.
• Assist with reports and data extraction when needed.
• Ensure digital databases and archives are protected from security breaches and data losses.
• Troubleshoot data-problems and authorize maintenance or modifications.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 8.4.
• Developed reports in Analysis Studio from Powerplay Transformer Cube.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi-dimensional cubes, cube groups, Power Play reports.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed dimensional models in Transformer, built cubes and published cubes to Cognos Portal.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Assigning work to the offshore team on daily basis.
• Developed technical specification document for the offshore team.

Environment: Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio), Transformer, Cognos SDK, Oracle 10g/11g, Custom Java Authentication Provider (CJAP)

Confidential

Cognos Developer

Responsibilities:

• Creating reports (Report/query studio) which cater to different employees at different levels.
• Report includes all types such ascharts(bar, bubble, line, lists etc).
• Analyzing the requirement and building complexSQLQueries.
• Dashboards andDrill-throughreports for the complete management hierarchy.
• Interacting with the user to get the detailed information about the issues.
• Preparing and testing the code to fix the issues in Development and QA environment.
• Involved in preparing Test scripts and validating the data based on the Scenarios.
• Performed thorough analysis of relational, multi-dimensional, and other data sources for business analysis, reporting, and presentation efforts
• Participated in IT implementation projects which intend to improve the day-to-day operations of the organization
• Created, designed and published reports using Cognos Report Studio, SSRS and Excel Eservices
• Collaborated with project team, effectively managed the delivery of reports and accommodated any changes and new business requirements
• Created SharePoint Server 2007 User Guide for strategic management analysis and reporting technologies s
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom templates and custom toolboxes for the use of reporting.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in the Testing of the reports and updating the Bug Tracking Tool.

Environment: Cognos 8.3,Framework Manager, Report Studio, Cognos Connection, Query studio, Analysis studio, Power play Transformer, Cube Reports, Oracle 9i.