We provide IT Staff Augmentation Services!

Senior Associate Consultant Resume

3.00/5 (Submit Your Rating)

Tampa, FL


  • 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.


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


Confidential, Tampa, FL

Senior Associate Consultant


  • 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.


Senior Cognos BI Developer


  • 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.


Cognos BI Developer


  • 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.


Cognos Developer


  • 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.

We'd love your feedback!