SUMMARY

• Over 7 year and 5 Months of IT experience in field of Business Intelligence and Data Warehouse Projects.
• Strong 7 years of experience and good understanding of business process especially in teh Banking, Financial Services & Human Resource Management.
• Expertise in Cognos 10x, 10.1, 10.1.2, 10.2, 10.2.1 (Report Studio, Framework Manager, Business Insight), Cognos 8 BI suite (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Transformer.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 10x Report Studio, Analysis Studio and Query Studio.
• In - depth experience of Cognos Framework Manager, Analysis Studio and Query Studio.
• Created Multidimensional Models & Cubes using PowerPlay Transformer for generating various reports.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level and data level security.
• Experience on OLAP cubes, relational and multi-dimensional Data models.
• Hands-on experience in implementing Data warehousing methodologies including Star Schemas and Snow-Flake Schemas for huge data warehouses.
• Developed very complex reports using Report Studio, Query Studio and Analysis Studio.
• Hands on experience in Cognos Administration like creating user, Deployments, Creating data sources, Managing Configuration settings etc.
• Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified teh SQL in Report Studio to tune and/or to write reports using Report Studio.
• Created dashboards for users using Business Insight, Business Insight Advanced.
• Exposure to client interaction and user-requirement analysis.
• Experienced with migration of Cognos code (reports/models/frameworks) from one environment to another.
• Progressive hands-on experience in Data warehousing and ETL processes using Informatica.
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementing and Production Support using Cognos as a BI tools.
• Team player with good interpersonal and communication skills and teh ability to work in a team environment.
• Excellent analytical, problem solving, communication with ability to interact with individuals at all levels.

TECHNICAL SKILLS

BI/Reporting Tools: Cognos 10x, 10.2.2 10.2.1, 10.1.2 and 8x (Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection), Java Script, Unified Reporting Layer

Databases: Oracle, Netezza, Teradata, SQL Server

Data Modeling Tools: Erwin Data Modeler, Cognos Framework Manager 10.2, 10.1.1, Cognos PowerPlay Transformer

Languages: SQL, PL/SQL, UNIX scripting

Scheduling Tools: Cognos Event Studio, UAL Schedule Simulator

Other BI/ ETL Tools: Informatica Powercenter 9.x, Cognos Access Manager

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior Associate Consultant

Responsibilities:

• Direct interaction with teh Business users for requirement gathering, perform feasibility analysis for teh business requirements and estimate teh efforts required for any new Federal reporting.
• Working as team lead and tracking progress of project deliverables from onsite and off-shore development teams.
• Working with ETL team and Database teams explaining teh Business requirement and business benefits for teh new change and requirements for reporting.
• Participated in peer-to-peer testing of reports.
• Managing KT sessions to business users after GO LIVE of Federal reports and releases.
• Responsible for managing teh team and getting required report review sign off from teh business users.
• Dimensional Modeling using Relational Data Sources in Cognos 10.1 to 10.2.
• Development of Framework Manager Model considering teh underlying database schema model and teh reporting requirements.
• Designed and configured Cognos security framework.
• Implementing teh Data/Object Level Security using teh Cognos Framework Manager and Cognos administrator.
• Creating Report Requirement Technical Specification documents (RRTS) for all teh new business change in teh reports
• Creating Complex reports and dashboards in Cognos Workspace and Cognos Report Studio depending on teh business requirements.
• Design complex reports based on identified architecture and support implementation of design by resolving complex technical issues faced during development, deployment and support.
• Perform automation of scheduling teh Cognos reports directly to group of users using bursting functionalities of Cognos Report Studio.
• Managing advanced scheduling of reports using Cognos Event Studio.
• Migrating new and existing reports in various environment from Development to Production using Cognos Administration.
• Worked on performance optimization and SQL tuning for teh Cognos reports.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Designing and developing reporting solutions including OLAP cubes, Dynamic cubes using Cognos Transformer and Framework manager.
• Designing and developing dashboards using report studio, workspace and workspace advanced.
• Migration of reports and catalogs from Cognos series 8.4 to Cognos series 10.2.1, 10x.
• Manually modified teh SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.
• Indulge with teh team in Cognos Controller Administration task.
• Analyzing existing transactional database schemas and designing star schema models to support teh users reporting needs and requirements.
• Testing teh reports generated with teh database for correctness of data by writing SQL Queries.

Environment: Cognos10x, 10.2.2, 10.2.1, 10.1.1 and 8 BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Cognos 8.3, Frame Work Manager, PowerPlay Transformer, Oracle SQL, Netezza, XML.

Confidential

Senior Cognos BI Developer

Responsibilities:

• Involved in providing both business and technical expertise in teh requirements gathering, report design, report development, and support of all client/server layers and components of teh data warehouse.
• Migrating reports from Cognos 10.2.2 to Cognos Analytics or Cognos 11.
• Designed and developed Framework model to better suit complex report development using Oracle as backend.
• Designed and developed dashboards using report studio, workspace and workspace advanced.
• Involved in creating an ad-hoc query model for query studio users.
• Created and published various packages to meet different requirements.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Developed Prompt Pages, Cascaded input Prompts to display only teh selected entries in teh report and also worked on teh customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Resolved complex problems by performing root cause analysis.
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Experience in providing read access to all modeled data in IBM Cognos 8 metadata environment.
• Worked on tickets/defects for various enhancements of reports to monitor and respond.
• Analyzed teh user tickets, troubleshoot/resolving and closing teh help desk user tickets in accordance with all SLA established timeframes.
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual.
• Designed and developed teh multi-dimensional model using Power play Transformer.
• Build and Published teh Cubes to Cognos 8 connection.
• Created Event Studio Jobs to run scheduled based on Business Events and email report outputs to Email Distribution List.
• Indulged in writing different SQL statements, creating views and coding on Netezza.
• Created and published teh Packages to teh Cognos connection.
• Developed Simple and Complex reports using Report Studio and Analysis Studio.
• Worked closely with teh migration team to deploy teh reports and packages from Development to QA, UAT and Production environments.
• Added HTML button on teh report in order hide and show teh List and Crosstab reports.

Environment: Cognos 10x,/.2/.2.1, 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Power Play Transformer, Windows NT, Linux/Unix.

Confidential

Cognos BI Developer

Responsibilities:

• Gatheird and documented requirements from end users and designed reports in Cognos report studio, Cognos Query Studio and ad - hoc reports.
• Worked on Report Requirement Technical Specification documents (RRTS) for all teh new business change in teh reports.
• Analyzing and debugging teh code to fix issues reported by making changes in teh existing reports and making adhoc reports.
• Responsible for creating test Cases of reports for various project releases.
• Worked on solving teh Service Requests related to Cognos reports raised by teh end users within time frame.
• Worked on Jira stories and delivered teh adhoc reporting request from end users.
• Created CPF (Project files) and Published projects from teh FM Models
• Worked on creating database objects Scripts (MV) for any change in teh project requirement.
• Handling and Tuning of teh SQL queries
• Developed FM model for report studio developers
• Created CPF (Project files) and Published projects from teh FM Models
• Comprehensive Admin Review: Created multiple models to meet teh need of adhoc and canned reports. Modified teh existed model of Phase 1 and took care of all business needs for phase 2.
• Back-end Development: Developed multiple SQL statements/files for exceptions management to exclude accounts based on complex business logic.
• Handled Complex Queries as separate Query Subjects.
• Created Power Play models using Transformer by developing various dimensions, measures and calculations in Cognos Transformer.
• Scheduled Power Play cubes to run on a monthly, weekly and daily basis using Windows Scheduler.
• Tuned teh performance of teh Cognos BI 8 for quick runtime of reports
• Tuned teh performance of Cognos Servers for better response and decreased run time of reports.
• Performed BI Content Administration tasks including scheduling and content management
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Worked on Star Schema Database Design.
• Responsible for creating users, groups and roles to manage security.

Environment: Cognos 10x,/.2/.2.1, 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Power Play Transformer, Jira, Windows NT, Unix.

Confidential

Cognos Developer

Responsibilities:

• Releasing Yearly/Monthly/Weekly reports built on HR attrition model and creating Access/Roles of teh various users and assigning them to respective verticals using Cognos Access Manager.
• Worked on Cognos Administrator for migrating Cognos objects to various environments like Development to QA and QA to Production environment.
• Perform feasibility analysis for teh business requirements and estimate teh efforts required.
• Worked on Cognos multidimensional packages for creating and updating teh Cubes in Cognos Transformer.
• Responsible for giving teh KT sessions to business users after GO LIVE of Cognos Cubes in Analysis Studio.
• Responsible for managing teh team and getting required report review sign off from teh business users.
• Responsible for creating teh UAT test Cases and Database objects Scripts (MV) for any new requirement.
• Worked on solving teh Service Requests(SR) related to Cognos raised by teh end users within time frame
• Worked on tuning teh SQL queries used in Cognos reports to increase teh performance of reports.
• Converting business requirements into product documentation.
• Interacting with Development and Management Teams.
• Involved in Testing and Exploring New Tools ReportStudio and QueryStudio (ReportNet).
• Developed standard Templates
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursted Reports and Multilingual Reports Using ReportStudio and QueryStudio.
• Query Optimization.
• Creating Query Prompts, calculations, Conditions & Filters.
• Developed Prompt pages and Conditional Variables
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection

Environment: Cognos 10x,/.2/.2.1, 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Cognos Access Manager, Power Play Transformer, Unix.