Summary:

• Over 7 years of total IT experience in Analysis, Design, Development, Documentation and Implementation of applications.
• Over 7 years of experience in Development of Business Intelligence Solutions using OLAP Tools such as COGNOS 8, Reportnet, Impromptu, PowerPlay, Transformer, IWR, Upfront, Access Manager.
• Involved in installation, configuration and testing of Cognos 8 BI.
• Experienced in Migrating Reportnet 1.1 MR2 to Cognos 8 BI.
• Experienced in Analysis Studio, Query Studio, Report Studio and Framework Manager to design Complex Reports and to create Models and Packages in Cognos 8 BI.
• Extensive experience in using Report Services for developing Dashboards reflecting business performance.
• Experienced in publishing Packages and Reports to Reportnet portal.
• Experienced in Cognos ReportNet Administration and Security.
• Experienced in Power Play Transformer to design Models and analyze the Power Cubes.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Proficient at analyzing business processes and providing Business Intelligence solutions.
• Involved in Interacting with Business Analysts and Business Users to gather Reporting Requirements.
• Excellent team player with good interpersonal and communication skills and the ability to work in a team or as an individual.
• Transformed projects into successes by completing on time and within budget in difficult circumstances.

OLAP Tools: Cognos 8 (Report Studio, Query Studio, Analysis Sutdio, Framework Manager) Cognos 7.3 (Impromptu, PowerPlay, Transformer, IWR, PowerPlay Enterprise Server, Visualizer, Scheduler, PowerPrompts, Noticecast, Cognos Query, ReportNet)
Operating Systems: Windows NT/2000, UNIX
Databases: Oracle 10G/9i, SQL server 7.0/2000, MS Access 97/00/XP/03
Web Servers: Microsoft Internet Information Server (IIS) 4.0/3.0, (MTS), Netscape Directory Server
Modeling Tools: Rational Rose
Microsoft Tools: MS excel, MS word, MS Visio, MS Project, MS PowerPoint

Confidential,Chicago IL Mar’10 – Till Date
Cognos Developer
Confidential, is the world’s leading marketing and media information company. The project focus was to create a state of the art BI solution that will address AC Nielsen’s reporting needs from internal and external clients.

• Actively involved with the business users and Development teams for gathering information for creating the Framework Model.
• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Created filters within the Model for improving the performance of the Model
• Developed Standard Reports, Charts, Drill-Through Reports, and Master Detail Reports using Report Studio.
• Developed Dash Board reports for Corporate Performance Management Purpose.
• Created Query Prompts, calculations, Conditions & Filters.
• Developed Multi Page Reports.
• Developed Prompt pages and Conditional Variables.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Testing and improving Report Performance.
• Created views in the SQL Database for complex reports.

Environment: Cognos 8.4, Cognos ReportNet 1.1MR2 (Frame work manager, Cognos Connection, Report Studio, Query Studio), Active Directory, Sql Server, Oracle 10G

Cognos Consultant
Confidential,is a leading U.S based multinational insurance organization focusing on profitability, distribution and claim processing. Focus of the project was to deploy a Cognos BI based solution for reporting needs.

Responsibilities:

• Worked with various user groups and gathered Business Requirements
• Worked with architects to develop POCs
• Developed various types of reports per user requirements
• Developed Framework Manager Design documentation and ReportNet Report documentation.
• Created Packages which includes Query Subjects, Joins, Filters, Prompts in Framework Manager.
• Published the 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.
• Involved in scheduling Report Studio and Query Studio reports in Cognos Connection.

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

Confidential,Wilmington, DE Jul’06 – Sep’07
Cognos Consultant
Confidential,is a leading global financial services firm. The primarygoal of this project is to helpthe Retail Credit Card divisionmake faster/effective decisions by generating web based reports. Thisproject tracks the Trends by Products, Customer Average Balances by Productand Customer Distribution by YTD Revenue. Dashboards were created to display information in an easy and efficient manner through which end user was able to analyze the assets and liabilities of the product.

Responsibilities:

• Responsible for gathering requirements, writing specifications, developing reports, and coordinating with the production staff to publish the finished product to the production environment.
• Installed and Configured Cognos 8 BI tools (Cognos Configuration, Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio)
• Designed and Developed Framework Manager Models to be deployed as packages on ReportNet Server.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Developed Standard Reports, Charts, Drill Through Reports, Cross tab Reports, List Reports, Summary Reports and Multi Object Reports using Report Studio.
• Developed Prompt Pages and Conditional Variables, Creating Query Prompts, Calculations, Conditions & Filters in ReportNet.
• Created Web-based reporting solution that can address reporting needs using Dashboards.
• Extensively used Report Studio in designing Complex Dashboard Reports.
• Worked in Migrating Reportnet 1.1 MR2 to Cognos 8.
• Created Catalogs and Reports in Impromptu.
• Assigned various types of Securities like Table Security, Row Security, and Column Security using Governor Settings.
• Tuned performance of Impromptu to decrease the run time for reports.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using PowerPlay and Transformer.
• Modified existing cubes by slicing and dicing, adding alternate drill-down paths, special categories.
• Migrated existing Impromptu catalogs and Reports to Reportnet.
• Published Power Cubes to Cognos 8.

Environment: Cognos 8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio), Reportnet 1.1 MR2, PowerPlay,Impromptu,Oracle 9i, SQL, JavaScript, Windows XP.

• Confidential,Dayton, OH Oct’05 – Jun’06
• Cognos Consultant

To create model, and generate reports for University Officials from various departments, Deans and Government Reporting from ORACLE data warehouse developed on SunGuard Banner Higher Education System.

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Designed the Reports and Catalogs using Impromptu as per the requirements.
• Assigned Weightage to the table and resolved loop problems in the joins.
• Created Multi-Dimensional Cubes and Reports in PowerPlay Transformer.
• Modified Power Cubes by adding new Dimensions, alternate drill-down paths, Special Categories.
• Created Drilling down, Slice and Dice Reports in PowerPlay.
• Created reports providing summarized and detail data via Drill-Through in PowerPlay.
• Configured LDAP and Access Manger 7.3 for the Security of Cognos Products.
• Installed Reportnet 1.1 MR2, Framework Manager and setting Cognos Configuration.
• Migrated several existing Impromptu Catalogs into XML files and importing them into Reportnet.
• Developed PowerPlay Cubes and published them using Cognos Connection.
• Designed Models and Packages using Framework Manager and deployed Packages to the Reportnet Servers.
• Developed Templates, Standard Reports, Master Detail Reports, Drill Through Reports, Bursting Reports and Multilingual Reports using Report Studio and Query Studio.
• Created dashboards to present critical data in easy-to-understand format.
• Developed reports using Cascading and Range Prompts and Calculations in Report Studio.

Environment: CRN 1.1 MR2, Cognos Connection, Report Studio, Query Studio, Framework Manager, PowerPlay 7.3, Transformer 7.3, PowerPlay Enterprise Server, Impromptu, Access Manager, Oracle 9i, Windows XP.

Confidential,Seattle, WA Mar’04 – Sep’05
Cognos BI Consultant
Nordstrom, Inc operates as a fashion specialty retailer in the United States. This project reduces long lead time for report generation and gets a deeper insight for making better business decisions. This project is aimed at evaluation of Sales and Functional Performance of the business. This project gives the information on customer’s buying patterns and trend over a period of time.

Responsibilities:

• Interpreted complex Business Specifications developed by the client and generated Cubes and Reports to meet Customer Specifications.
• Designed Catalogs and defined User Classes, Security and Privileges.
• Created Folders with Complex Calculations, Conditions, Filters, Prompts in Impromptu.
• Created Joins and Database definitions according to the requirements.
• Implemented Folder Level and User Class Level Security to the Catalogs.
• Developed sub-reports and various reports using different types of Prompts like Catalog Pick List, File Pick List, Type-in, Cascading Prompts and using Conditional Formatting.
• Used Date Wizard to create Time Dimension in Transformer for creating Cubes and PowerPlay Reports.
• Calculated fields, Created Manual Dimensions and used Special Categories for creating Cubes and Reports using Transformer models.
• Provided Security for Cubes of various User Classes.
• Created Lists, Groups and Cross-tab reports with Drill-Through functionality.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using PowerPlay and Transformer.
• Used PowerPlay Enterprise Server to publish the cubes.

Environment: Cognos Impromptu 7.3, PowerPlay 7.3, PowerPlay Transformer 7.3, PowerPlay Enterprise Server 7.3, Access Manager, Oracle 8i, Windows XP.