SUMMARY

• Over 7 years of IT experience in software development, designing and implementing quality business solutions, with more than 6 years major focus on Business intelligence
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 10.1.1/10.2/ 8 Report Studio, Analysis Studio and Query Studio.
• Experienced in developing models in Framework Manger and publishing packages onto Cognos Connection.
• Extensively worked on publishing of (IWR) Impromptu Web Reports and PowerPlay Web Reports.
• Expertise in Implementing Cognos Business Intelligence tools like Cognos Impromptu, Cognos IWR, Power Prompts, and Analysis tools such as Cognos Transformer & Power Play, Cognos Visualizer, and Cognos Query.
• Expert in the development of Cognos Impromptu, Transformer, Power Play Reports.
• Created Multidimensional Models & Cubes using Power Play Transformer for generating various reports.
• Extensive experience in Relational Database Systems like Oracle, SQL Server, TeraData, MS Access, design and database development experience with SQL, PL/SQL, SQL PLUS, Stored procedures, Triggers.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Involved in modeling the Data. Expertise in tuning up the database queries.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.1.1/10.2/8 (Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio, Cognos Connection), Cognos ReportNet 1.1 MR2 (Report Studio, Query Studio, Framework Manager

Operating Systems: Windows95/98/2000, Windows NT 4.0, and UNIX

Languages: SQL, and PL/SQL

Scripting Languages: JavaScript, Perl and VBScript

ETL Tools: Informatica, Decision Stream

Databases: Oracle, MS - SQL Server, DB2 and MS-Access

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Cognos Developer

Responsibilities:

• Work closely with functional and technical teams to implement and maintain optimal reporting environment.
• Assist users with the report design, running, and troubleshooting
• Experience with upgrading software applications and the ability to coordinate implementations with end-users from various areas.
• Installation and implementation of Cognos analysis for MS Excel
• Plan and maintain upgrades, patches, and hot fixes for Cognos
• Basic knowledge of security technologies and the ability to apply user security for the Business Intelligence application
• Perform backup and upgrades and troubleshooting by understanding the various log messages
• Familiar with support and troubleshooting IISweb servers.
• Extensive knowledge ofActive reports design
• Monitoring daily report scheduler on Tidal Scheduler
• Publishing reports to Cognos mobile environment to multiple mobile devices
• Basic understanding of MS SQL server 2008
• Implement package deployments and troubleshoot package issues.

Environment: Cognos 10 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio), Cognos analysis for MS Excel, Oracle 9i, SQL, Windows XP, IIS Web server

Confidential, Whitehouse Station, NJ

Cognos Developer

Responsibilities:

• Worked with business analysts and end users to understand business rules and interpret data.
• Created Packages which includes Query Subjects, Joins, Filters, Prompts in Framework Manager.
• Developed Framework Manager Model and Report Studio reports design and solution implementation documents.
• Published designed FM model as Packages to Cognos Connection.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Developed ad-hoc reports in Query Studio.
• Used Analysis Studio to build Multidimensional Reports.
• Developed List, Crosstab, Drill through, Master-Detail, and Charts which involved Multiple Prompts, Multiple Frames, Filters, Multi-page, Multi-query reports against different data sources in Report Studio.
• Created the Reports in different formats like PDF, XML, HTML, Excel and CSV.
• Involved in Bursting Report Studio reports and sending reports via Email to several business users.
• Developed data model to be used in FM and Report studio
• Established relationships across star schema
• Involved in scheduling Report Studio and Query Studio reports in Cognos Connection.

Environment: Cognos 10 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio), Oracle 9i, SQL, Windows XP.

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Created simple and Ad hoc reports using Query studio.
• Involved in creation of advanced reports using Report Studio.
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts and Filters.
• Involved in gathering and analyzing Business requirements.
• Performed Metadata Modeling using the Cognos 8 Framework Manager and published the packages.
• Queried star schemas to check data availability
• Created physical and logical views within database
• Created dimensions, levels and hierarchies using Framework Manager.
• Developed Database and Business Views for Meta Data Models using Framework Manager by Importing Tables, Views, creating short Cuts and Aliases.
• Created joins, views and packages using Framework Manager to be used for report development.
• Developed Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio.
• Involved in the training and knowledge transfer of tool to the client.
• Created complex reports such as dashboard reports, master detail reports, drill through reports.
• Applied model filters, query filters, detail filters and summary filters to generate user specific reports.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Worked on exploring large volumes of summarized data in a variety of formats drilling through to the details.
• Designed the Cognos Connection portal according to user specifications.
• Supported the reports in Production environment for a limited time and transferred knowledge on maintaining/ modifying reports in the future to the support team.

Environment: Cognos 8.4/8.3(Query Studio, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle 10g,Toad, Query Analyzer, Microsoft Excel, Windows 2000, LDAP.

Confidential - Sunnyvale, CA

Cognos Consultant

Responsibilities:

• Interacted with Users, Management.
• Gathered Requirements by participating in various users level meetings.
• Involved in project planning and workflow analysis of the project and designed Meta models as per the Business Requirement.
• Used SQL Server as the data sources.
• Developed Database and Business Views for Meta Data Models using Framework Manager by Importing Tables, Views, creating short Cuts and Aliases.
• Specifying Dimensions, Levels, Hierarchies and Key values for data flow.
• Created joins, views and packages using Framework Manager to be used for report development.
• Modified Metadata in the model by defining Filters and adding Calculations to better suit the requirements of the end users.
• Created Ad-hoc report using Query Studio and complex report using Report Studio.
• Created Mix reports, Financial and Top ten reports.
• Developing Standard Reports, Charts, Drill Through Reports, Nested Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio.
• Involved in the training and knowledge transfer of tool to the client.
• Created complex reports using Report studio with calculated columns and Formatting.
• Created New Jobs using Cognos Connection.
• Created User Groups and assigned user privileges using Cognos Connection.
• Testing and improving Report Performance.
• Training Users on Query Studio for Ad-Hoc Reporting.
• Involved in Documentation for training and knowledge transfer of tool to end User.

Environment: Cognos Framework Manager, Cognos Connection, Report Studio, Query Studio, Powerplay Transformer, Content Manger, SQL Server 2000 and PeopleSoft CRM.

Confidential - Cincinnati, OH

Cognos Report Net Developer

Responsibilities:

• Involved in the Requirements Gathering by participating in various user level meetings.
• Converting business requirements into product documentation.
• Used SAP BW, SQL Server 2000, Architect Models and Impromptu Catalogs as the data sources.
• Interacting with Development and Management Teams.
• Providing Technical Assistance to Developers.
• Built models using Framework Manager a tool of Report Net
• Involved in Testing and Exploring New Tools Report Studio and Query Studio (Report Net).
• Developed standard Templates
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Query Optimization.
• Creating Query Prompts, calculations, Conditions & Filters.
• Developing Prompt pages and Conditional Variables
• Creating New Jobs using Cognos Connection.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Maintaining Files through File Management.
• Testing and improving Report Performance.
• Training Users on Query Studio for Ad-Hoc Reporting.
• Involved in Documentation for User training.

Environment: Cognos Reportnet1.02, Frame Work Manager, PowerPlay, Impromptu, PowerPlay Transformer, Access Manager Administration, Netscape Directory Server, Informatica, IIS Web Server, Windows 2000, SQL Server 2000 and SAPBW.