PROFESSIONAL SUMMARY:

• Over 10+ years of IT experience with extensive experience in Analysis, Design, Testing, Development and Documentation of Business Intelligence applications using Cognos products.
• Experience in installing and configuring Cognos 8 BI components.
• Experience in working with Framework Manager, Query Studio and Report Studio for model design, Ad - hoc reporting and advanced report authoring.
• Excellent Proficiency in Cognos Impromptu (Cognos Series 7)
• Excellent Proficiency on the usage of tools such as Cognos 8 (Framework Manager, Report Studio, Query Studio, Cognos Connection)
• Experience in PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 2000/05/08, Oracle 10g/9i/8i,
• Created SHELL SCRIPTS for generic use.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created Dashboards using Report Studio. Used functionalities like drill through, drill down and applied conditional formatting, conditional blocks, and different kinds of prompts for different reports.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, Unix, Windows98/00, Windows2003, Windows XP, Windows NT4.0

Reporting Tools: Cognos10, Cognos 8.x, ReportNet1.1/, Report Studio, Query Studio, Analysis Studio, Frame Work Manager, Cognos Impromptu, Business Objects 5.x, 6.x: Designer, Business Objects, Supervisor, Auditor, BCA, Web Intelligence and Info view

Languages: SQL, PL/SQL,& Unix shell scripting.

Databases: Oracle7.x/ 8i/9i/10g, SQL Server 2000/05/08, and Microsoft Access.

PROFESSIONAL EXPERIENCE:

Confidential, Southlake, TX

Cognos BI Architect

Responsibilities:

• Migrated reports & framework Model N Cognos 8.4 to Cognos 10.
• Created multiple layer reports providing a comprehensive and detail report with drill-through facility.
• Created Prototypes for various dashboards and worked on enhancement of existing reports
• Created and fine-tuned existing reports & Framework Model.
• Created some Dashboards for upper management. Involved in re-engineering of more than 100 reports for the BFOE (Bridgestone / Firestone Original Equipment) department, which includes Complex, Moderate, and Simple reports using the Powerful Professional Report Authoring Tool - Report Studio
• Helped end-users build Customized portal pages.
• Created jobs to run reports and deliver the latest version of the reports to the Customers.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Raised and managed cases with Cognos support to help fix problems encountered in the team. Understanding of the Cognos EP models, these are used as a data source for building the framework model used for reporting.

Environment: Cognos 10 (Framework Manager, Report Studio, UNIX, Event Studio, Query Studio), MS SQL Server 2008.

Confidential, Pleasanton, CA.

Sr.Cognos consultant

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Cognos8 server.
• Built Framework Manager Models, and established the cardinalities to suit the business needs.
• Imported various sources such as Relational Databases, flat files into the Framework Manager.
• Created various report types like list reports, cross tab, charts, Dashboards, which cover the entire range of enterprise reporting requirements.
• Used various functionalities in report studio like drill through, conditional formatting, parameter displays, and Conditional blocks.
• Created Dashboards using various functionalities in Report Studio.
• Worked with the users for report enhancements and other data related issues.
• Used Java Scripts to enhance report functionalities.
• Created portal tables to show report on Cognos connection.
• Personalized Cognos Connection, Specified display options, regional options and rmation.
• Used bursting options and scheduled reports to run at a different time to send e-mail to users.
• Developed and published Drill through Reports.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Cognos8.2, Cognos Connection, Report Studio, Query Studio, Framework Manager, Oracle 10g, MS-Access, Windows NT/2003 Servers.

Confidential, Raleigh,NC.

Sr.Cognos consultant

Responsibilities:

• Extensive interaction with Business Users and gather information and requirements.
• Worked extensively on creating Models and publishing the packages on Cognos Connection for reporting.
• Created filters within the Model for improving performance of the Model and reports.
• Developed Standard Reports, Charts, and Drill through Reports, Master Detail Reports and Bursting Reports and developed Dashboards using Report Studio and Query Studio.
• Creating Query Prompts, Calculation, Conditions using Cognos Connections
• Trained power users to use Query Studio for Ad-hoc reporting
• Scheduled Impromptu and Report Studio reports to run on a monthly, weekly, and daily basis using Cognos Scheduler
• Used Toad to write and test SQL Scripts to test data against reports and ETL tool.
• Created Stored Procedures and Views
• Data analyze and extract the data from existing database and involved in query optimization
• Set security for individual reports in Cognos Connection.
• Implemented security and granted privileges according to user classes using Access Manager.

Environment: Cognos8, Cognos Connection, Report Studio, Query Studio, Framework Manager, Access Manager, Oracle, Windows NT/2003 Servers.

Confidential

Confidential, Indianapolis, IN

Cognos/SQL Developer

Responsibilities:

• Involved in User Requirements, Analysis and Gathering
• Worked on Cognos Security Administration to restrict the Users
• Created folders, filters, prompts and complex financial calculations in Framework Manager and Report Studio.
• Generation of standard reports (Advanced Booking Analysis, Post-Departure Analysis and Revenue Analysis)
• Generation of Graphical analysis reports (Passenger profiles, Frequency and Activity rates).
• Creation of models, projects and packages in the Framework Manager.
• Creation of filters, calculations and namespaces in the Framework Manager.
• Graphical Analysis reports like passenger profile, frequency, s and activity rates.
• Ad-hoc analysis on detailed passenger and flight data to support various business scenarios and departments.
• Scheduled reports using different filters and saving option in different folders and set up E-mails options
• Created different types of prompts like Type in, Pick list, Cascading prompts etc.

Environment: Cognos8, Report Net 1.1, Cognos Connection, Report Studio, Query Studio, Framework Manager, Access Manager, Oracle, Windows NT/2003 Servers.

Confidential, Addison, TX

Cognos ReportNet Developer

Responsibilities:

• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reports.
• Used Framework Manager to create new Models and Packages and Published Packages for Report Development.
• Worked Closely with Finance Department to identify Business requirements and provided appropriated Gauges and Pie charts.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Expertise in using Report Studio for building complex reports, Templates, charts, gauges, Drill-through and Master Detail Reports.
• Responsible for creating users, groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Deployed packages, folders and Reports from a development environment to Production environment.
• Created Lists, Groups and Cross-tab reports with drag and drop functionality.
• Mentored users on Query Studio to create Ad-hoc Reports.

Environment: Cognos Report Studio, Cognos Query Studio, Cognos Analysis studio, ReportNet 1.1MR2, Cognos Connection, Framework Manager, Cognos Configuration, Cognos Impromptu 7x, SQL Server 2000, Oracle 9i, MS-Access, Access manager, ODBC for OLAP.

Confidential, Corona, CA

Cognos Developer

Responsibilities:

• Generation of Reports in Client Server Environment.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Responsible for creating the Catalogs, Joins and Folders for the users
• Managing and testing of Catalogs using Cognos Impromptu 6.0.
• Published Impromptu reports to upfront through Cognos Server administration.
• Used Cognos Scheduler to schedule various reports.

Environment: Cognos Series 6, Impromptu 6SQL, Oracle 8.1, MS Access, MS Excel, Windows 97/2000/XP

Confidential, Tampa, FL

Cognos Developer

Responsibilities:

• Involved in Upgrading Catalogs and reports from Cognos 6.0 to Cognos 7.0.
• Involved in creating and modifying catalogs, developed and analyzed a Join strategy.
• Developed reports based on business requirements using Cognos Impromptu
• Created standard Reports, Cross Tab Reports and Drill Through reports.
• Developed many OLTP reports in Cognos impromptu by Developing Catalogs
• Involved in Upgrading reports from Cognos 6.0 to Cognos 7.0.

Environment: Cognos Impromptu 7.0, SQL Server 2000, MS Access, Oracle 8i, MS Excel, Windows 2000/NT