SUMMARY:

• Confidential is an IT consultant with around 13 years of work experience in IT sector including more than 11 years of Data Warehousing experience. He is well versed in Cognos 10 tools like Framework Manager, Report Studio, Transformer and Analysis Studio. He has knowledge of other Cognos 10 tools like Query Studio and Planning. He also has expertise in Cognos 7.x tools like Impromptu, Powerprompts, Transformer and Powerplay.
• Confidential has been working as Lead Consultant for 6 plus years. His experience includes successfully managing teams of programmers/analysts to complete requirements gathering, technical analysis & design, development & maintenance of multiple Cognos reports and cubes. He has hand on experience with documentation of various activities as a Lead. He has also managed both onshore as well as offshore resources in parallel.
• He has experience on Microstrategy 8 - Desktop. He is proficient in SQL has extensive experience in building stored procedures, functions, packages and performing SQL tuning as per the business needs. He possesses domain expertise in HRMS, Banking, Retail, Life Sciences and Media & Entertainment. He has gained extensive knowledge of SDLC. Over the years he has acquired strong Analytical & Problem Solving skills.

TECHNICAL SKILLS:

Data Warehouse Tools: Cognos 10.1/8.x (Framework Manager, Report Studio, Transformer and Analysis Studio)/7.x, Cognos Planning, Scorecard, ReportNet, Microstrategy 8 (Desktop).

Databases: Oracle11g, Oracle10g, IBM DB2, SQL Server, MS-AccessLanguages C, C++, FoxPro, Visual Basic

Operating Systems: Win XP/NT/98, Windows for Workgroups, MS-DOS

Others: MS Visual Interdev, MS-Office, Data Modeling

Hardware: IBM Compatible PCs

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Cognos Lead / Architect

Responsibilities:

• Gathering the requirements from Business
• Engaged in project planning, controlling, and documentation
• Reviewing the existing FM models and suggesting performance improvement solutions.
• Suggesting changes to the DB model such that the performance of the reports is better in Cognos.
• Implementing the requirements to develop new Cognos reports
• Helping other Developers with doubts and Questions
• Proof of concept for of new solution
• Creation of testing documents
• Functional and Technical understanding of the requirements
• Leading the Reporting team for design, development, unit testing & deliver.
• Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.
• Involved in performance tuning, bug fixing and final validation before deployment.
• Managed several projects and completed them successfully

Tools: Used: Cognos Report Studio, Oracle 11g

Confidential

Senior Cognos Consultant

Responsibilities:

• Successfully completed Cognos separation of Cognos application from Confidential to Confidential
• Gathering the requirements from Business
• Implementing the requirements to develop new Cognos reports and modifying the existing reports including performance tuning
• Documentation of various activities in the process of Development or enhancement
• Enhancement and Issue Resolving of reports using Cognos 8.4 and Cognos10
• Functional and Technical understanding of the Issues
• Manage onsite and offshore team to get the work done in time.

Tools: Used: Cognos Framework Manager, Report Studio, Analysis StudioClient

Confidential

Senior Cognos Consultant

Responsibilities:

• Successfully completed Cognos Upgrade from Cognos 8.4 to Cognos 10.1
• Gathering the requirements from Business
• Implementing the requirements to develop new Cognos reports
• Interaction with Client and Off - shore Team
• Documentation of various activities in the process of Development
• Enhancement and Issue Resolving of reports and cubes using Cognos 8.4 and Cognos10
• Functional and Technical understanding of the Issues
• Issue Impact Analysis and monitoring the progress made towards issue resolution

Tools: Used: Cognos Framework Manager, Report Studio, Analysis Studio, Transformer

Confidential

Senior Cognos Consultant

Responsibilities:

• Analyse the Confidential Cognos environment
• Analyze the data marts
• Consume report mock ups and business rules
• Design, develop, QC, deploy the reports
• Interaction with Client and Off - shore Team

Tools: Used: Cognos Framework Manager, Report Studio, Powerplay, Transformer

Confidential

Project lead

Responsibilities:

• Interaction with Client and Off - shore Team.
• Documentation of various activities in the process of Development,
• Enhancement and Issue Resolving of reports and cubes using Cognos Reportnet and Cognos 7.3 versions.
• Maintenance of reports build in Microstrategy
• Preparation of Runbooks, playbacks and presentations as a part of Knowledge Transfer.
• Functional and Technical understanding of the Issues.
• Issue Impact Analysis and monitoring the progress made towards issue resolution.
• Work Orders handling related to new reports or cubes using Track IT.
• Provide resolution to Business Users for their queries related to Cognos Reports or Cubes raised as tickets in Track IT.
• Manage onsite and offshore team to get the work done in time.

Tools: Used: Cognos Reportnet Framework Manager, Report Studio, Cognos 7.3 - Powerplay, Transformer, Impromptu, Microstrategy 8.

Confidential

Project Lead / Senior Software Engineer

Responsibilities:

• Successfully managing team of 5 programmers/analysts to complete Requirements Gathering, Technical Analysis & Design, Development & Maintenance of multiple Cognos reports and cubes and also involved in Documentation of various activities.
• Development and review of the Cognos reports and cubes using Cognos 8.4 Framework Manager, Report Studio, Analysis Studio, Transformer.
• Preparation of Requirements Specifications Documents and Design Issues Template as a part of Knowledge Transfer.
• Work Orders handling related to new reports or cubes using Team Track.
• Provide resolution to Business Users for their queries/issues/concerns related to Cognos Reports or Cubes raised as tickets in Remedy.
• Review of Delivery to ensure adherence to standards and Perform Enhanced Quality Assurance to modules within the project.
• Coordinate with client onsite and manage the development and delivery of reports & cubes from offshore team.

Tools: Used: Cognos 8.4 Framework Manager, Report Studio, Analysis Studio, Cognos 7.4 - Powerplay, Transformer, Impromptu, Access Manager

Confidential

Senior Software Engineer

Responsibilities:

• Documentation of various activities in the process of Development, Enhancement and Issue Resolving also did Review of Requirements Specifications Documents and Design Issues Template.
• Functional and Technical understanding of the Issues. Issue Impact Analysis and monitoring the progress made towards issue resolution.
• Work Orders handling related to new reports or cubes including Specification Preparation for those issues.
• Resolved issues raised as Tickets in Peregrine.
• Review of Delivery to ensure adherence to standards and Performed Enhanced Quality Assurance to modules within the project.

Tools: Used: Cognos 7.3 - Powerplay, Transformer, Impromptu, Access Manager, UNIX (for ETL)

Confidential - IB

Associate Consultant

Responsibilities:

• Gather and analyze the business requirements.
• Created Cognos Proof of Concept (PoC).
• Developed reports using Cognos 8 tools like Framework Manager and Report Studio.
• Interacted with Client and On - site Team.
• Documentation of various activities in the process of Development, Enhancement and Issue Resolving.
• Review of Requirements Specifications Documents and Design Issues Template.
• Functional and Technical understanding of the Issues.
• Development and Testing of Reports.
• Change Request handling related to new reports.
• Specification Preparation for new issues.
• Review of Delivery to ensure adherence to standards.
• Testing Reports thoroughly thru Quality Assurance prospects and preparation of UTC.
• Lead for Cognos Reporting Team

Tools: Used: Cognos 8.0(Framework Manager and Report Studio), Oracle 9i

Confidential - IM

Associate Consultant

Responsibilities:

• Gather and analyze the business requirements.
• Creation of Reports using COGNOS ReportNet.
• Interaction with On-site Team and Clients.
• Documentation of various activities in the process of Development, Enhancement and Issue Resolving.
• Review of Requirements Specifications Documents and Design Issues Template.
• Development and Testing of Reports.
• Functional and Technical understanding of the Issues.
• Change Request handling related to new reports.
• Review of Delivery to ensure adherence to standards.
• Perform Enhanced Quality Assurance to modules within the project.

Tools: Used: Cognos 8.0(Framework Manager and Report Studio), Oracle 9i

Confidential

Associate Projects Consultant

Responsibilities:

• Team member for Creating ReportNet reports.
• Interaction with Client and On-site Team.
• Documentation of various activities in the process of Development, Enhancement and Issue Resolving.
• Review of Requirements Specifications Documents and Design Issues Template.
• Development and Testing of Reports.
• Functional and Technical understanding of the Issues.
• Specification Preparation for new issues.
• Review of Delivery to ensure adherence to standards.
• Perform Enhanced Quality Assurance to modules within the project

Tools: Used: Cognos ReportNet Report Studio, IBM DB2

Confidential

Associate Projects Consultant

Responsibilities:

• Team member for Creating ReportNet reports.
• Interaction with Client and On-site Team.
• Documentation of various activities in the process of Development, Enhancement and Issue Resolving.
• Review of Requirements Specifications Documents and Design Issues Template.
• Development and Testing of Reports.
• Functional and Technical understanding of the Issues.
• Specification Preparation for new issues.
• Review of Delivery to ensure adherence to standards.
• Perform Enhanced Quality Assurance to modules within the project.

Tools: Used: Cognos 7.0 and 7.1 (Impromptu, Powerprompts, Powerplay), Oracle 8i

Confidential

Software Developer

Responsibilities:

• Understanding the client requirements.
• Development using VB and SQL Server.
• Testing

Tools: Used: ADO to access data from database, VB 6.0 and Seagate Crystal Report for Report Writing, SQL server 2000