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.