SUMMARY

• Having over 11+ years of professional IT experience and Over 10 years of experience in Cognos Reporting and administration on Cognos Enterprise Suite 10.x/8.x/7.x.
• Experience in all phases of Business Intelligence projects including Requirements Gathering, Analysis, Design, Package Modeling, Development, Testing / Preparing Test Strategy, Deployment (importing & exporting reports across multiple environments like Dev / Test / UAT etc), Maintenance, Functional Studies and Quality Reviews / Audits.
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design converting requirements specifications into functional specifications.
• Good experience in creating different layers like Database Layer, Business Layer, Logical Layer in Framework manager.
• Strong experience in creating DMR (Dimensionally Modeled Relational) models in FM.
• Experience in Cognos Cube Designer.
• Involved in Creating Models and publishing packages using Framework manager.
• Expertise creating different kind of Ad - hoc/Professional reports (list, crosstab, charts, Repeater) using conditional blocks, conditional layouts, master detail, Conditional formatting, Prompts, Filters calculations using Query studio/Report studio and Analysis studio.
• Experience in Content Deployment, Scheduling and automated report bursting.
• Strong experience in Installation, Configuration and Administration of Cognos BI.
• Experience in Creating Impromptu Catalog and Built Transformer Model.
• Providing support during theUser Acceptance Testing and Production.
• Have knowledge on creating Mappings and workflows in Informatica.
• Experienced with Multiple Relational Databases like Teradata, Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000 and data access tool TOAD.
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team well.
• Analysis of the defects raised and providing quicker fixes. Responsible for keeping track of defects for capturing the Metrics.
• Performed Unit Testing of Reports and Framework Model.
• Responsible for providing support to users as part of post-implementation support.
• Having knowledge on SSRS, Tableau Desktop/Server.

TECHNICAL SKILLS

Reporting Tools: Cognos 7.3, Report net MR1.3, 8.X / 10.1/10.2.1

Data Base: Oracle 9i/10g, SQL Server

Configuration Management Tools: MS Visual Source Safe (VSS)

Development Tools: Microsoft Office Suite

Operating Systems: Windows XP/2K/Vista, UNIX.

ETL Tool: Informatica 9.1

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

Cognos Lead Developer

Environment: Cognos 10.2.1 Suite (Framework Manager, Report Studio/Query Studio/Analysis Studio, Transformer), Teradata V14.10, Control-M, Windows7

Responsibilities:

• Involve in Client meeting for gathering requirement from the client to offer a proper solution by understanding the total business logic.
• Create database layer by defining appropriate relationship between query subjects, Business layer to define logical names/business definition and presentation layer in Framework Manager.
• Developed various type of reports ranging from simple list,Cross-tabs,Charts by using different functionalities like drill-through, Master-detail, conditional formatting, Multiple prompts, Cascading prompts, Conditional blocks filters, multi-pages, Dashboards and Report Bursting.
• Created Active reports with different data decks.
• Used Query Studio for Ad-Hoc reporting.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Assign the tasks and review the deliverables from Onsite.
• Involve in support QA/UAT validation.
• Involve in support deployment activities.

Confidential, Oregon

Cognos Lead Developer

Environment: Cognos 10.2 Framework Manager, Cognos 10.2 Report Studio, SQL Server 2012, Windows7.

Responsibilities:

• Involve in requirements gathering and Analysis.
• Preparing design document for the reports and framework model.
• Modeling metadata using Framework Manager.
• Create Standard and Dashboard reports using report studio.
• Prepare unit test case for reports.

Confidential

Cognos Lead Developer

Environment: Cognos 10.1.1/8.1, Framework Manager, Report Studio, Informatica 9.1, Oracle 10g, TOAD, Windows XP, UNIX.

Responsibilities:

• Created Framework Manager Models for various line of business & utilized the modeling practices to ensure proper query generation.
• Report generation and Enhancement.
• Report Bursting for each dealers.
• Cognos Server Installation and Configuration.
• Involved Cognos server performance tuning.
• Involved in LDAP setting with Cognos configuration.
• DeployedPackagesand Reports from DEV Environment to UAT and PROD Environments.
• All documents in the working of the project to be presented and signed off by the client at each stage of development.
• Working with a team of more than 30 professionals in requirement gathering, report design, Unit Testing, System and User Acceptance Testing, Production Deployment Support.
• Maintain quality coding and documentation standards as set by the organization.
• Design and Implement ETL process.
• Experience in developing Mapping/ Mapplets, Sessions/tasks, Workflows.
• Creating the ETL high level /Low level design for the entire informatica mapping.

Confidential

Cognos Lead Developer

Environment: Cognos 8.4, Framework Manager, Analysis Studio, Oracle 10g, TOAD, Windows XP/Vista, Office 2007.

Responsibilities:

• Involved in building relational and DMR Models from various source system and created/modified published packages based on the reporting requirements and implemented star schema grouping.
• Design of the ad hoc analysis capability for sub field force and Sales data.
• Development and Unit testing
• Involved in InstallationandConfiguration ofCognos BI
• DeployedPackagesand Reports from DEV Environment to UAT and PROD Environments.
• Support for User Acceptance Testing

Confidential

Environment: Cognos 8.4, Framework Manager, Informatica 9.1, Analysis Studio, Oracle 10g, TOAD, Windows XP/Vista, Office 2007.

Responsibilities:

• Involved in building relational and DMR Models from various source system and created/modified published packages based on the reporting requirements and implemented star schema grouping.
• Design of the ad hoc analysis capability for sub field force data
• Creation of 11 standard reports
• Performed Unit and Integration testing of the products.
• Participated in supporting the User Acceptance Testing.
• Involved in creating Mappings in Informatica Power Center Designer.

Confidential

Cognos Developer

Environment: Cognos 8.3 Framework Manager, Report Studio, SQL Server 2005, IIS, Win XP.

Responsibilities:

• Analyzing the user requirements and Preparing design document for the reports.
• Created the reports using Cognos8.3 Report studio.
• Created Technical Design Documentation for Reports, Framework Models.
• Created Test Cases for Reports, Framework Models and Stored Procedures.
• Deploying the reports developed on the customer environment

Confidential

Environment: Cognos series 7.3, SQL server, Windows 2000.

Responsibilities:

• Analyze the user requirements and Preparing design document for the reports.
• Created the reports using Cognos Impromptu.
• Prepare Test plans.
• Created Test Cases and test logs for Reports.
• Deploying the reports developed on the customer environment

Confidential

Environment: Cognos 8.3 Framework Manager, Report Studio, TOAD, SQL Server 2005, Win XP.

Responsibilities:

• Interacting with the End users to gathering the reporting requirements.
• Created Technical Design Documentation for Reports and Framework Models.
• Created Test Cases for Reports and Framework Models.
• Designed models using Framework Manager and deployed packages to the Servers.
• Created reports using Report Studio

Confidential

Environment: Cognos 7.3 Transformer, SQL Server2000, Windows 2k.

Responsibilities:

• Analyze the requirement document and differentiating
• Prepared the design document for Power Play cubes.
• Built the model file for cube using Cognos Transformer

Confidential

Environment: Cognos BI 8.3 Framework Manager, Report Studio, MS SQL Server 2000, IIS, Windows 2000.

Responsibilities:

• Analyzing the requirement document and differentiating the metrics for Cognos report for design purpose.
• Preparing the design document Cognos reports.
• Created the reports using Cognos Report Studio.

Confidential

Cognos Developer

Environment: Cognos BI 8.1 Framework Manager, Cognos connection, Query Studio, Report Studio, MS SQL Server 2000,IIS, Windows 2000.

Responsibilities:

• Worked on Framework manager to import metadata and to create subject oriented business models, create and publish packages to Report Net server.
• Created Reports using Report studio.
• Installation and Configuration of the Cognos8 and Framework manager.

Confidential

Cognos Developer

Environment: Cognos Reportnet1.1 Framework Manager, Report Studio, MS SQL Server 2000, IIS, Windows 2000

Responsibilities:

• Involved in Creating Package for report generation using Framework Manager Module in Report Net.
• Producing various reports as per the requests of the sites.
• Created Reports using Report Studio module in Report Net.
• As a part of report development created the reports using Package as main data providers and using the Powerful business objects functionality’s.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Testing the Reports & Package.

Confidential

Environment: Visual Basic 6.0, SQL Server and Win XP

Responsibilities:

• Involved in analysis, design and coding
• Coding and Testing the modules