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-Access

Languages: 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:

• Worked as Sr. Software Engineer in Data Warehouse Team (COGNOS, ETL) with HCL Technologies Ltd., Noida, India for Confidential, USA
• 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

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

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