SUMMARY

• 10+ Years of IT experience in Data warehouse/Business Intelligence Technology with expertise in COGNOS BI Series Reporting (10.2//8.4/7.x)
• Cognos Reporting (Version 10.2/8.4/7.x) - Cognos Insight, Cognos Workspace, Scorecards, Dashboards, Cognos SDK, Javascripts Cognos
• OLAP Reporting - DMR Cognos Transformer Cognos TM1 Cognos Framework Manager Model designing
• Relational and Dimensional, Star and Snowflake Model Cognos Environment Maintenance and Support (Multi Server Load Balancing)
• SQL, PL/SQL Development - Oracle DB,SQL Server, Sybase, Teradata and MS Access, Performance Tuning
• 5+ years of ETL Tools – Informatica, Data Stage, MS BI support exposure
• VB Macros, Javascripts, HTML, XML
• Excel Expertise - Data Management, Pivot Table Management
• MS Office, MS PowerPoint presentations
• Data analysis Project Planning – Cost Estimations, Impact Analysis
• Documentation – Proposals, Technical and Functional Specifications, SLAs, SOPs, UAT
• Quality Assurance Data entry Process Improvement Team Leadership
• Time Management Excellent Organizational/Inter Personal Skills and Active Team Player

TECHNICAL SKILLS

• Cognos Go Mobile, Go Dashboard
• Cognos OLAP/ROLAP tools like Powerplay and Analysis Studio
• Cognos SDK using Java,VB.NET
• Cognos Multi/Single server Installation, Configuration & Patches, Administration, Support & Upgradation
• Data Warehouse Concepts Data Modelling, ETL Concepts, Star Schema, Snow Flake Modelling, Slowly Changing Dimensions, OLTP, OLAP LDAP, Active Directory, Site Minder, Series 7 Informatica 9.1, DataStageDatabases SQL, PL/SQL development, stored procedures, Triggers, Materialized views, Performance Tuning, Dynamic SQL
• Oracle 10g, SQL Server 2005, Sybase 9.1,DB2,Teradata, MS Access 7.0, Peoplesoft EPMOperating System
• Windows 2008/2003/NT/XP,Unix 7.0, MS Dos
• Development/Productivity Tools
• MS Office, MS Excel, MS Project, MS Visio, MS Share Point, Erwin, Mercury Quality Centre 9.0
• Rational Tools – Clear Case, Clear Quest, Quality Centre, PL/SQL, SQL*Plus, TOAD, EPM PS Query
• Web Technologies
• HTML, XML, Java scripts
• Web Client IIS, Apache Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Responsibilities –

• As a Technical Consultant for Cognos environment, used to handle various Business BI requirements like Finance Reporting, HR, Shipments and Sales Reporting
• Involved in Requirement gathering and analysis of the Business Needs and data that needed to be developed into Cognos Cubes/Reports with Use of Framework manager and Transformer
• Performed Capacity planning, Configuration, Installation setup in Cognos 10.2 environment
• Involved in Complete lifecycle of DWH project from Developing Transformation using Informatica and creating Models in Cognos Framework Manager, designing Transformer Models, Cubes and Reports
• Handle Multiple Business requirements to enable Reporting using Report Studio, Analysis Studio in Cognos environment
• CreatedPL/SQL PackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Performance tuning using HINTS, EXPLAIN PLAN, SQL*TRACE, TKPROF andAUTOTRACE. and Explain Plan for Query tuning
• Created Shell Scripts for invoking SQL scripts and schedule them
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Development of Cognos Framework Models and Packages with RDBMS Databases and DMR approach
• Experience with Dynamic Query Mode approach
• Dynamic cubes and Power Cubes in Transformer (8.4) and Analysis Studio (8.4,10.2) using IQDs, Framework Manager Packages and Report (IMR) as Datasources
• Developed Complex executive Dashboard/Scorecard for HR Department using Complex Report Studio Features like Active Reports (8.4,10.2)
• Support and Maintenance of Cognos Multi server both Production and Non Production environment with over 2000 users globally within the Confidential
• Developed Reports using Cognos Workspace Advanced and Cognos Insight Features that were used as an interactive update on reports from different departments like Sales and Finance team
• Defining Complex Security of reports at the Portal Level and Report level using Row Level and also Model level using Data Level security and Parameter mapping
• Multi Query Complex Reports using multiple unions and Joins were been used to develop hierarchy structured cross tab reports that were sourced directly from Relational databases like oracle, sql server and Transformer Models
• Created complex statistical and Forecasting reports for HR domain which involved customized styling, filtering only the specified data
• Exposure to Windows Scripts to handle Cube Refreshes and Scripts for Server Temp files Cleanup
• Defining Complex Custom Views for various Security groups in Transformer Models, Reports and various security level in Framework Manager Models
• Hands on Migration from Cognos 7.x to Cognos 8.4 and Cognos 8.4 to 10.2 environment
• Involved in Deployment of Reports/ Analysis Cubes to Production environment
• Created and maintained Windows Scripts for Jobs to refresh Cognos Cubes and maintain in Multi Server Environment
• Trouble shooting issues, Production support, Performance Tuning and Implementing Security of Cognos Environments
• Support and Maintenance of ETL in tools like Informatica, Data Stage

Confidential

Cognos Architect

Responsibilities –

• As an Architect, Involved in Installation and Configuration of Cognos 10.1 Version MutliServer Load Balancing Environment
• Have used Lifecycle Manager to compare performance Cognos 10.1 reports with cognos 8.4.2 reports
• Reengineering of Excel Macro/Pivot Report and charts Reports into equivalent Cognos Reports
• Developed Data Model for Cognos Reports/Cubes using Cognos Framework Manager (Cognos 8.4/10.1 version)
• Developed Active Reports for Go Mobile Users
• Executive Dashboards Multidimensional cross tab/charts reports which had complex queries to be retrieved from multiple datasources
• Designed Executive Dashboard reports through Global Edit and filter options to enable multi tab Dashboard report approach
• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQL Navigator, Toad. Generated server sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances. Wrote Shell Scripts forData loadingandDDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc. Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Complex Reports were designed for Bursting that were stored in Local Server Locations and sent to the users through Email Notification
• Multi Query Complex Reports using multiple unions and Joins were been used to develop hierarchy structured cross tab reports that were sourced directly from Relational database oracle and sql server
• Used Conditional Blocks, render variables and Conditional Formatting for creating complex reports
• Employed Customized cascading prompts, drill-through/Drill Down, HTML Script and sub-reports
• Developed some Java Scripts (SDK) to enable the Cognos Reports customization to be called from 3rd Party Applications
• Customized a complete Cognos Connection page using SDK (Java and VB.Net) that the User Group would look depending upon the authentication, Various menu objects were modified like Report Names, Description was attached to the report, comment popup was enabled, Column width, some icons were disabled and reports were accessed through 3rd party web portal
• Also Report template was modified to give a look of
• Web Portal that the user used to access reports directly so that the users wouldn’t know the difference between web portal and cognos web page
• Version control and baseline using Clear Case and Clear Quest
• Involved in Deployment Reports to Production environment
• Trouble shooting, Production support, Performance Tuning and Implementing Security
• Created and maintained Jobs and Schedules

Confidential

Cognos Architect

Responsibilities –

• As an Architect in Cognos Solution Centre have been involved in various Design, Implementation, Consulting and Solution Providing tasks
• Involved in Enterprise Level upgradation of Cognos Environment from 8 to 8.4 on Multi Server Environment (Active DR setup)
• Have been supporting and maintaining 26 cognos Active –Active DR servers of the organisation for Prod, UAT & Dev environments
• Involved in Cognos Standards at the organisation level like security implementation LDAP, Site Minder and configuration, naming conventions for report/Model/any components that the user wants to used
• Defining Windows Service/Batch accounts to implement Cognos 8.4 and Cognos Tm1 data connectivity in LDAP, Active Directory server
• Administration tasks like creating and maintaining data sources, creating users, groups and roles,
• Developed complex executive Dashboard/Scorecard sales and marketing reports using Advanced Business Insight feature which provided flexibility of creating multi chart/tabs in multi page widgets
• Developed Active Reports that were used as an interactive update on reports from different departments like Sales and finance team
• Performed Business User Interaction for Requirement gathering and analysis of the Business Needs and data that needed to be developed into Cognos Cubes with - -Reengineering of Excel Macro/Flat File Report as Data source into equivalent Cognos Tm1 Cubes
• Developed Multidimensional Cognos Tm1 Cubes. Applications, Dimensions from multiple datasources to provide data analysis flexibility
• Developed Processes to perform cube creations using Cognos Turbo integrator
• Defined Chores to schedule cube uploads
• Provided Excel/web viewer components to user enabling data modification at real time
• Configured Cognos Tm1 Security in alignment with Cognos 8.4 security environments using LDAP and Siteminder
• Troubleshooting, Performance Tuning and Cube enhancements request were been handled
• Installation, Configuration and Maintenance of 64-bit Cognos TM1 environment

Confidential

Cognos Consultant/Sr Developer

Responsibilities -

• Performed requirement gathering and analysis of the reports that needed to be developed into Cognos Reports.
• Reengineering of the Oracle Reports into Cognos Reports
• Developed/Enhancements of Framework Data Model for Cognos Reports using Cognos Framework Manager based on the reporting needs (Cognos 8.2 version)
• Maintained and published multiple Packages from the same Model to cater different Business needs
• Developed complex list, drill through and master detail relations, Multi dimensional cross tab reports successfully that considerably had good performance when compared with the existing oracle report.
• Involved in performance tuning and oracle SQL,PL/SQL coding to enhance report performance
• Quality control using Quality Centre
• Designed Master-detail relationship reports to cater multi report output formats like PDF, Excel, HTML on a click of a button through reports directly

Confidential

Cognos Consultant

Responsibilities:

• Have been involved in the complete SDLC lifecycle of the MDW Phase 2 project.
• Have been involved in ETL Data Mapping using Informatica
• Developed Complex Reports like Cross tab, Charts, Summary and detail report using Cognos Report Net MR1
• Designed OLAP Cubes using Transformer that used IQD Report data and developed cube snapshot analysis report using PowerPlay

Confidential

Cognos Consultant

Responsibilities -

• Have been involved in the complete SDLC lifecycle of the MDW Phase 2 project.
• Have been involved in ETL Data Mapping using Informatica
• Involved in the requirements gathering have provided the cost estimation and also provided the Business/Technical Design document
• Developed Complex Reports like Cross tab, Charts, Summary and detail report using Cognos ReportNet MR1
• Designed OLAP Cubes using Transformer that used IQD Report data and developed cube snapshot analysis report using PowerPlay
• Have been actively involved in supporting and advising the Subordinates in achieving the work assigned to them.

Confidential

Cognos Developer

Responsibilities -

• Created the packages defining the business rules and calculations with folders to store conditions, calculations and prompts.
• Developed List, crosstab, drill through, master-detail using Report Studio and Query studio, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in Report Net.
• Developed reports with List, Repeater data/chart reports that were handled through conditional formatting and multi query reports
• Report (row level and data level) Security based on Macros and Parameter maps were designed