Summary

• Five years of IT experience in analysis, design, development and implementation of Client/Server
• Applications, Data Warehousing and Data Modeling, and generating OLAP reports using Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio), ReportNet 1.1.
• Involved in analysis, design, development and implementation (SDLC) of Business Intelligence and Maintaining Applications using Cognos Business Intelligence Tool suite.
• Extensive experience in modeling using Framework Manager with OLAP cubes (MDX Reporting) and relational database as source including applying data level, and query subject level and package level security & Publishing packages to Cognos server.
• Expert in Designing and developing complex reports (List Reports, Cross Tab Reports, Charts, Maps, Drill Through, Dash Board Reports & Master Detail Reports) using Report Studio and developed Catalogs using Cognosimpromptu.
• Created Prompts and Cascading Prompts. Worked on designing the multiple Report pages and multiple Prompt pages. Worked on Report bursting.
• Extensively worked on Power Prompts, Impromptu Web Reporting (IWR), and Data Modeling - Dimensional & ER DataModeling.
• Published power Cubes on Upfront through Cognos Server Administration tool.
• Experience in building complex cubes from various multiple data sources in Power Play Transformer (Multidimensional Modeling tool).
• Experience in design and implementation of Dimensional Data Warehouse (Star and Snowflake schemas & Slowly Changing Dimensions).
• Extensive experience in Relational Database Systems Oracle 10g, 9i/8i, SQL Server, and database development experience with stored procedures, Packages, Triggers, Materialized Views.
• Experience in Security Implementation in Cognos8, ReportNet on various levels using Access Manager.
• Expertise on Financial, HealthCare, Retail, Sales, Inventory & HR domains.
• Excellent Communication and Interpersonal skills, resulting in good rapport with employees and executive management

Technical Skills

BI Tools

Cognos Series 8 BI Suite (Report Studio, Query Studio, Analysis Studio, Frame work Manager) Cognos Report Net 1.x Suite (Report Studio, Query Studio, Frame work Manager, Cognos configuration) Cognos Series 7.x Suite (Cognos Impromptu 7.1/7.0/6.0, Cognos Power Play Transformer 7.1/7.0/6.6), Upfront, Access Manager, Scheduler, PowerPlay Enterprise Server.

Databases

ORACLE 7.x /8i, 9i, 10g, MS SQL Server 2005 Enterprise Edition, MS SQL Server 2000 and MS- Access

Database Tool

TOAD, Query Analyzer, SQL*Plus

Data Modeling Tool

Erwin

ETL Tools

Informatica 6.0

Languages

C, SQL, PL/SQL, HTML, XML

LDAP

SunOne, Tivoli Directory Server

Application Servers

Tomcat, WebSphere

Web Servers

IIS, Apache, iPlanet

OS

Windows XP/NT/2003/2000/98/95, UNIX

Education
Bachelor of Technology

Professional Experience

Confidential,New York, NY Feb 09 - Dec 09
Sr. Cognos consultant
Domain: Financial & Insurance
The main goal of this project is to create Metadata modeling using Framework manager for HR Deportment and Report studio reports and Query Studio reports.
Responsibilities:

• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Developed Stored Procedures and created Stored Procedure Query Subjects in Framework manager to enhance Report Performance.
• Implemented Relational Modeling in Framework Manager and developed dash boards in Report Studio.
• Created security at package level, object level in model and security to package in cognos connection.
• Created Adhoc reports based on user requirements using Query Studio.
• Developed reports like List, Crosstab and Dashboards by using Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which Involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple data bases
• Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.
• Verification of the data in the back end database using TOAD.
• Making enhancements of the report based upon the requirements of the user.

Environment: Cognos 8.3 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio), Oracle 9i, Windows 2003.

Confidential,Atlanta, GA Jun 08 - Dec 08
Cognos Developer
Domain: Banking / Investing Banking
The Sun Trust Banks, Inc. is one of the nation\'s largest commercial banking organizations in the southeastern U.S. The company provides deposit, credit, trust and investment services to a broad range of retail, business and institutional clients. Other subsidiaries provide mortgage banking, asset management, and brokerage and capital market services. The STIS Surveillance project addresses gaps in our supervisory capabilities, and an opportunity for efficiency improvements in our annuity processing through the implementation of Annuity Net The main aim of this project is to create Frame work manager model and consolidated reports by using Cognos8.
Responsibilities:

• Installed and Configured Cognos 8.2 and 8.3 Framework Manager.
• Participated in discussions with the senior management to create the business requirements
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created model using different Data Source
• Upgraded model and reports from Cognos 8.2 to Cognos 8.3.
• Created security at package level, object level in model and security to package in cognos connection.
• Created stored procedure Query Subject in Frame Work (FM) model.
• Created Report Using SQL code in Report Studio.
• Created Adhoc reports based on user requirements using Query Studio.
• Created Managerial reports like List, Crosstab and Dashboards by using Report Studio.
• Created Drill through reports and Conditional Formatting by using Report Studio.
• Involved in deploying packages and reports from Dev to QA.
• Involved in Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.
• Verification of the data in the back end database.

Environment: Cognos8.3 (Frame work Manager, Query Studio, Report Studio), Cognos8.2, SQL Server 2005, Windows XP

Confidential, Kent, OH Nov 07 - Apr 08
Cognos Developer
Domain: Educational
Kent State University is located in Kent, OH. It has several departments such as Student, HR, Finance and Advancement. The main aim of this project is to create consolidated reports by using Cognos8 as a reporting tool.
Responsibilities:

• Installed and Configured Cognos8 on different servers.
• Created Models using ODS and published packages using Framework manger.
• Created Stored Procedure QS in FM and Created Reports using SQL code
• Created Metric studio reports using Metric Manager packages
• Created Adhoc reports based on user requirements by using Query Studio.
• Created Managerial reports like List, Crosstab, Repeater and Dashboards by using Report Studio.
• Created Drill through reports and Conditional Formatting by using Report Studio.
• Involved in deploying packages and reports from Dev to Prod.
• Created IQD\'s by using Framework manager.
• Involved in Creating Users and User classes by using Sun Java Directory Server.
• Involved in Scheduling and bursting the reports to the end users.
• Involved Different type\'s securities by using Framework Manager and Cognos Connection.
• Involved in Migrating reports and Cubes from Cognos7 to Cognos8.
• Using Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
• Resolving the Performance issues of the Reports.
• Developed PL/SQL procedures for processing business logic in the database and Tuning of SQL queries for better performance.
• Created complex stored procedures and functions using PL/SQL
• Testing the report and the validity of the data it retrieves from the database.
• Verification of the data in the back end database using TOAD.

Environment: Cognos8 (Query Studio, Report Studio and Framework Manager), Cognos 7(Impromptu, Power play), Oracle 9i, Sun One Directory Server, TOAD, IIS, windows XP

Confidential,Memphis, TN Jan 07 - Sep 07
Cognos Developer / Administrator
Domain: HealthCare

Medtronic, Inc. is the world's leading medical technology company, alleviating pain, restoring health, and extending life for people with chronic disease. Our Business Intelligence team worked for reporting of Asset Management, Inventory, Pricing, Sales, Forecast, Loaners, Finance and Customer Care.
Responsibilities:

• Installed and Configured Cognos Report Net 1.1 (MR2) and upgraded the existing Cognos versions of the PowerPlay and impromptu, Access Manager, Upfront, LDAP directory server for different environmental phases of Project (Development, Testing, and Production)..
• Worked on the Framework Manger to develop efficient star schema data models and embed data level security into the models.
• Worked on implementing Data level security on the Framework Manger.
• Created List Reports, Dash Board Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Created Reports using Tabular SQL, Tabular References, and Tabular Sets to reduce the load on the Framework Manager model and improve the report performance.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Worked on Bursting of Sales Reports to different sales level people in the Organizations Sales hierarchy
• Extensively used Jscript and HTML coding to include the HTML Items for customization of reporting and integrating the prompt parameters using PHP variables.
• Closely worked with ETL-Informatica team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Involved in integrating the Cognos generated Reports into SAP Portal using PHP.

Environment: Cognos ReportNet 1.1 MR3, Series7.3 (Impromptu, PowerPlay Transformer, PPES, Access Manager, Upfront and all Server Administration), Informatica 6.0, Java, J-Script, HTML, Oracle9i, Windows XP.

Confidential,INDIA Mar 06 - Nov 06
Developer
Domain: Business
Sales Management System: SMS provides effective sales management for the organization. Project deals with the sales and marketing management of an organization for order entry, sales analysis, and dispatch details.
Responsibilities:

• Interaction with the user to know their requirements.
• Analysis, coding and documentation, according to user requirement.
• Developing screens for order entry and sales analysis using Visual Basic.
• Provided necessary data validation checks against data entry.
• Developed a facility to get sales report from stored data.
• Developed various reports using Crystal Reports.

Environment: Oracle7.x, Windows'95, Visual Basic 5.0, and Crystal Reports.

Confidential,Bangalore Aug 05 - Feb 06
Data Warehouse Developer
Domain: Business
Involved in the design and development of WDM (Warehouse Data Management) using Informatica and Cognos as reporting tool. This warehouse is to generate reports and analyze the sales of various products. It provides information to retailers with fast and convenient distribution of high quality products including franchisees in Canada, Europe and India. This warehouse reports the historical data stored in various databases like Oracle, XML files and Flat Files.
Responsibilities:

• Analyzed the systems, met with end users and business units to define the requirements.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• The objective is to extract data stored in different databases such as Oracle, XML files, flat files and to load finally into a single data warehouse repository, which is in Oracle.

Environment: Oracle8i, PL/SQL, Erwin, XML, Win 2000/NT, SQL*PLUS.