We provide IT Staff Augmentation Services!

Cognos Bi Consultant / Administrator Resume

WI

OBJECTIVE:

  • To obtain a position as a Developer/Technical Lead/Administrator in Cognos 10.2/10.1/8, Report Net, Impromptu and Power Play to effectively utilize creative and analytical problem solving skills.

SUMMARY

  • Around10 years of professional experience in the IT Industry
  • Around 10 years of experience in developing Cognos Applications and ETL processes.
  • Experienced with reporting and data modeling tools of Cognos like Cognos 10.2/10.1/8 (Query Studio, Report Studio, Analysis Studio and Framework Manager), Report Net, and Cognos EP Series.
  • Fine - tuned packages and cubes to optimize performance.
  • Created and managed reports in zero-footprint environment using Cognos.
  • Administered security using Access Manager among Cognos applications.
  • Provided extensive End-User Training and Support for Cognos Tools
  • Created extensive business and technical documentation.
  • Expertise in gathering end user requirements and converting the same into technical specifications.
  • Extensive experience in creation of ETL mappings and transformations using Informatica Power mart/Power Center to move data from multiple sources into target area.
  • Extensive experience in performance tuning, identifying bottlenecks and resolving to improve performance at database level and Informatica mappings, session’s level.
  • Troubleshooting production issues and gave post production support for couple of projects.
  • Proven presentation skill in grabbing new projects.
  • Excellent communication, analytical, presentation, and interpersonal skills.
  • Perform well under pressure and ability to effectively meet deadlines.

TECHNICAL SKILLS

BI Tools: Cognos 10.2/8 .x- BI(Query Studio, Report Studio, Analysis Studio, Framework Manager) / Planning Analyst/Contributor, Cognos Report Net 1.x, Cognos 6.x/7.x (Impromptu, Power Play, Transformer, Access Manager, IWR, PPES, Visualizer), Informatica 8.1

Programming skills: SQL, PL/SQL, Unix Shell Scripting

Databases: Oracle 9i/10G/11G, MS SQL Server 2005/2000, DB2UDB

PROFESSIONAL EXPERIENCE

Confidential, WI

Cognos BI Consultant / Administrator

Responsibilities:

  • Gathered Functional Requirements from end users.
  • Involved in the entire life cycle of the project from the user requirement gathering to deployment stage.
  • Extensively involved in designing and developing of both informatica ETL load and cognos BI reports.
  • Analyze and created customized Cognos BI reports linking various databases, to meet the user requirements.
  • Lead in systems analysis activities, including system requirements analysis and definition.
  • Expertise in designing/deploying the Packages/Reports across environments (Dev - > UA -> Production).
  • Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
  • Assists in integration, systems, acceptance, and other related testing as needed.
  • Provided assistance on advancement systems with Sungard Banner products.
  • Automated and modified payroll data processes with SQL and Sungard Banner tools.
  • Researched and deployed the changes (Gap Analysis) between Operational Data Store from ERP (Sungard Banner Student System) and Student system databases.
  • Imported Metadata from ODS 3.X/8.X into Framework Manager so that Packages can be built and published.
  • Identifying root cause, prioritizing of problems and resolve break fixes.
  • Involved in upgrade of cognos 10.2 to cognos 10.2.1
  • Analyzing existing Cognos server configuration for better performance and updating for best practices.

Environment: Cognos 10.2/ 10.2.1 , Sungard Banner 3.X/8.X, ODS 3.X/8.X, Informatica 8.4, Oracle.

Confidential, Hartford, CT

Cognos BI Consultant / Administrator

Responsibilities:

  • Communicated with the Business Insurance, business users to comprehend the requirements.
  • Worked as Cognos lead to provide the overall reporting solution foundation for development, implementation, and operation for data reporting, modeling, and analysis of a data warehouse.
  • Expertise in designing/deploying the Packages/Reports/Cubes across environments (Dev - > QA (Test Environments) -> Production).
  • Administered security using Access Manager among Cognos applications.
  • Worked on Cognos Security Administration to restrict the users.
  • Analyze and created customized Cognos BI reports linking various databases, to meet the user requirements.
  • Lead in systems analysis activities, including system requirements analysis and definition.
  • Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
  • Assists in integration, systems, acceptance, and other related testing as needed.
  • Created needed security implementation across all environments in Cognos 10.1.1
  • Elevates code into the development, test, and Production environments on schedule. Provides follow up Production support when needed. Prepares and submits change control requests and documents.
  • Coaches and mentors others, as required, to complete deliverables.
  • Participated in special projects and performs other duties as assigned.

Environment: Cognos 10.1/Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos connection), DB2, Oracle, Teradata.

Confidential, Malvern, PA

Cognos BI Consultant

Responsibilities:

  • Communicated with the retail business users to comprehend the requirements.
  • Experienced with a system development lifecycle methodology.
  • Translated technical specifications, and logical/ physical design into code for new or enhancement projects.
  • Lead and participated in design, code, and test inspections throughout life cycle to identify issues and ensure methodology compliance.
  • Analyze and created customized Cognos BI reports linking various databases, to meet the user requirements.
  • Lead in systems analysis activities, including system requirements analysis and definition.
  • Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
  • Assists in integration, systems, acceptance, and other related testing as needed.
  • Elevates code into the development, test, and Production environments on schedule. Provides follow up Production support when needed. Prepares and submits change control requests and documents.
  • Coaches and mentors others, as required, to complete deliverables.
  • Participated in special projects and performs other duties as assigned.

Environment: Cognos 8.3/8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos connection), DB2, Oracle, Control-M, Shell Scripting.

Confidential, Fort Lauderdale, FL

Cognos Planning Consultant

Responsibilities:

  • Communicated with the financial analyst to gather requirements.
  • Customized planning models such as P&L and Budget forecasting to meet the user requirements.
  • Design of models using cognos planning analyst and maintaining/deploying it through cognos planning contributor administration /client console.
  • Design and implementation of Security.
  • Testing and deployment of planning models across environments.

Environment: Cognos 8.4 Planning - Analyst/Contributor Administration Console, MS SQL Server 2005, Windows 2003.

Confidential, Seattle, WA

Senior Technical Consultant /Administrator

Responsibilities:

  • Communicated with the business users to comprehend the requirements.
  • Created customized BI reports linking various databases, to meet the user requirements
  • Developed Templates, List, cross tab, drill through, master-detail, Repeater, Bursting Reports, Multilingual Reports, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases and materialized views.
  • Created new Cubes and modified the existing Power Cubes by adding new Dimensions, Levels and Measures using the Power Play Transformer.
  • Implemented Drill-Through from Power Play to provide users with detailed information.
  • Design and implementation of Data Level Security and Package Level Security.
  • Involved in Maintaining Cognos 8.4 server and Framework Manager in an interim environment as a proof of concept.
  • Deployment of packages/reports/cubes across environments (Dev - > QA (Test Environments) -> Production).
  • Administered security using Access Manager among Cognos applications.
  • Worked on Cognos Security Administration to restrict the users.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection
  • Data analyze and extract the data from existing database and involved in query optimization.
  • End to End execution provided with UAT Test Plans on all the user reports

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos connection, Access Manager), MS SQL Server 2005, Windows 2003

Confidential, Chicago, IL

Senior Technical Consultant /Administrator

Responsibilities:

  • Communicated with the business users to comprehend the requirements.
  • Worked as Cognos lead to provide the overall reporting solution foundation for development, implementation, and operation for data reporting, modeling, and analysis of a data warehouse.
  • Expertise in designing/deploying the Packages/Reports/Cubes across environments (Dev - > QA (Test Environments) -> Production).
  • Administered security using Access Manager among Cognos applications.
  • Worked on Cognos Security Administration to restrict the users.
  • Developed Standard Reports, Charts, Drill through Reports, Master Detail Reports, Scorecards, Dashboard and Bursting Reports using Report Studio and Query Studio.
  • Used HTML, Java scripts in report studio reports
  • Developed Templates, standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Lead the other Cognos developers in the Reporting Center of Excellence.
  • Involved in Query Optimization and UAT Test Plans on all the user reports.

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos connection, Access Manager, Oracle 10g, Oracle Discover, MS-Excel, Shell Scripts, HTML, Java Scripts, Windows 2000.

Hire Now