Professional Summary:

• Having 8+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Extensive experience in Data Warehousing projects, preparation of datadimensioning, physical data modeling and Logical Data Modeling.
• Extensive experience on Cognos Business Intelligence Series - 10.1.1 /8.4 /8.3 /8.2 /8.1 Suite (Report Studio, Analysis Studio, Query Studio, and Cognos Connection), Cognos ReportNet 1.1 MR3, Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play Windows/Web).
• Expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional & Technical design documentation.
• Extensively worked on Cognos 8 Framework Manager - Creating Models in Framework Manager, Importing Meta Data from Different Sources, Dimension Hierarchy, Determinants, Star Schema Grouping, and Packages.
• Good experience on developing List, Sub and Cross-Tab reports, prompts, multiple queries and conditional blocks.
• Good understanding of Data Warehouse & Data MartArchitecture, data modeling and DMR modeling using Star Schema and Snow-Flake SchemaMethodologies.
• Strong Knowledge with Transformer model design and Multidimensional cube building.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, and DB2.
• Experience with SQL Stored Procedures, Functions, Cursors and Triggers.
• Implemented Third Party Security using Access Manager, Active Manager and LDAP.
• Knowledge in ETL tools IBM Infosphere Datastage, Informatica, SSIS.
• Knowledge on developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts.
• Worked with testing team to develop test cases, scenarios and conditions.
• Highly motivated and hardworking individual with penchant for learning new technologies.

Technical skills:

Reporting tools: Cognos 10.1.1/8.4/8.3/ 8.2 /8.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos ReportNet 1.1MR3, 1.1MR2(Framework Manager, Report Studio, Query Studio, Cognos Connection) Administration and Security, Cognos Impromptu (7.x and 6.x), PowerPlay Transformer (7.x, 6.x), PowerPlay for Windows, Crystal reports 9.0.
Databases: Oracle 10g/8i//9i/, MS SQL Server 2000/2005/2008, DB2.
Operating System: Windows NT/98/2000//XP,
ETL: Datastage 7.5.2, Informatica 8.6, SSIS

Certifications in Cognos:

• Cognos 8 Reporting
• Cognos Framework Manager

Education:
Master of Computer Application

Professional Experience:

Confidential, NJ | Sr. Cognos Developer | Sep 2010 - Till Date

Advertising and Sales Reporting System
The target audience of the project is the Sales and Advertising Management Team. It addresses the Sales and Advertising line of business. The system gathers data from different servers and stores it into the main server with which the cubes are created. Power Play Transformer was being employed to create cubes and Cognos was used as the reporting tool. Extensive types of reports such as Management, Accounting and Sales Target Tracking reports were developed for better business continuity.

Environment
Cognos 10.1/8.4.1 (Cognos Connection, Cognos Administration Security for User Groups, Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos Power Play 8.4/7.4, Microsoft SQL Server 2008 R2.

Responsibilities

• Interacting with Business Users for gathering Business Requirements to develop the report mockups.
• Imported Meta data from different data sources, Developed Framework Manager Model to meet reporting requirements.
• Created database layer and business layer, defining appropriate relationship between query subjects based on the user requirements.
• Bursting, Scheduling and Distributing Reports through Cognos Connection.
• Customize the Cognos connection portal using existing port lets and customized tabs.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Burst Reports against database.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Built Power Play Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Added Package level security to the packages and Object level security to the Query Subjects.
• Having good experience on Portal Administration in Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Developed and published packages in Framework Manager, connected and tested the data source, created database layer and presentation layer, defined appropriate relationships between query subjects.
• Created Model Filters, Query filters, and User access filters in Framework Manager.
• Developed Framework Manager Model to meet reporting requirements.
• Worked extensively on report studio to create list reports, multi prompts and crosstab reports based on the user specifications.
• Created transformer models and built power cubes using PPT (Power play Transformer) and published them onto Cognos Server.
• Maintained different levels of cube security.
• Performed multidimensional analysis of the cubes created.
• Designed and developed time-based partitioned cubes using IQD data sources and applied security.
• Worked on different user issues on Report studio and Analysis Studio and helped them in understanding the tools.
• Worked on different levels of security and even with the permissions of various users and user classes.

Confidential, NJ | Cognos Developer | Nov 2008 - July 2010

Confidential, is the holding corporation for theMetropolitan Life Insurance Company, orMetLife, for short, and its affiliates. MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries.

Environment
Cognos 8.4/8.3/8.2/(Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio), Impromptu, Power play Transformer, Cognos Power Play 8.4,Microsoft SQL Server 2008.

Responsibilities

• Involved in Requirement gathering from Business Users.
• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Designed & developed multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Developed security for reports, bursting the reports and Scheduling and Distributing Reports through Cognos Connection.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Creating Query Prompts, calculations, Conditions & Filters.
• Managing User ID's and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Involved in Designing and developing power Play transformer model (Creating dimension maps, Levels and calculated measures for generating power cubes (OLAP Cubes)).
• Testing and improving Report Performance.
• Deployed Reports & Dashboards from Development to QA and QA to Production using Deployment.
• Tested all the reports with Generated SQL and Manual SQL data.

Confidential, Canton, OH | Cognos Developer | Aug 2007 - Oct 2008

Description:

The Timken Company is a leading global manufacturer of highly engineered bearings, alloy steels, and related components and assemblies. Our technologies and products turn up virtually everywhere equipment moves or power is transmitted. By applying our knowledge of friction management and power transmission, we help our customers' products run smoother, faster and more efficiently.

Environment:

Cognos 8.4/8.3/8.2/(Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio), Informatica 8.6, Impromptu, Power play Transformer, SQL, TOAD, Oracle 10g, Cognos Active Directory, Windows NT/XP and UNIX .

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Designed & developed multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Developed security for reports, bursting the reports and Scheduling and Distributing Reports through Cognos Connection.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.
• Creating Query Prompts, calculations, Conditions & Filters.
• Managing User ID's and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Involved in Designing and developing power Play transformer model (Creating dimension maps, Levels and calculated measures for generating power cubes (OLAP Cubes)).
• Testing and improving Report Performance.
• Deployed Reports & Dashboards from Development to QA and QA to Production using Deployment.
• Tested all the reports with Generated SQL and Manual SQL data.

Confidential, NJ | Cognos Developer | Aug 2006 - May 2007
Confidential, is the largest chemical company in the worldventured in more than 80 countries and operates six integrated production sites and 390 other production sites. It is one of the leading global producers of styrenics, engineering plastics and polyurethanes.
Cognos On Demand
Cognos on Demand project is a support project where users will post issues in the form of AHD (Advanced Help Desk) tickets. The issues are related to bad performance, report enhancement and data mismatch. The project also caters for new report development and enhancements.

Responsibilities

• Troubleshooting the issues posted by the user in the form of the ticket.
• Understanding the functional requirements provided by the report users.
• Communicating with End Users/ Onsite coordinators to understand the business requirements in the specification provided
• Developing technical specification documents for the reports
• Developing the reports (List, Cross tabs, Sub-reports, Drill-through reports) and validate the report data with the backend data

Confidential, Hershey, PA | Cognos Developer | July 2005 -Jun 2006
Confidential

Project Description:

Confidential, is the largest North American manufacturer of quality chocolate and sugar confectionery products. They discovered few issues while developing the reports in Cognos 8.2 using SAP BW. The issues are related to report performance, report design and Cognos 8.2 features. The purpose of this project is to analyze and test these issues in Cognos 8.3 to provide the possible resolution.

Responsibilities:

• Involved in developing the BEx Queries in SAP BW
• Developing Models and Packages on Cognos 8.3 Framework Manager
• Developing and testing of different reports like list, crosstab and chart
• Performance tuning of the reports

Confidential, India | Cognos Developer | Mar 2004 -Jun 2005
Confidential

Project Description:

The 3K Time sheets project will provide the comprehensive business intelligence system for 3K Technologies. This project will include the development of different reports for Board of Directors, Senior/Middle managers and several dashboards for the targeted business areas. The reports (Yearly/Quarterly/Monthly/Weekly) provide the clear information to the Directors, Mangers as well as HR Dept on basis of Employee effort estimations, calculations and variances on different criterion like Project, Reporting Manager and Account based.

Responsibilities:

• Created the data sources in Cognos Connection.
• Developed FM Projects and Published Packages in Framework Manager - Installed Framework Manager, connected to different data sources, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Implemented Framework Manager Security for Data access, Object level access and Package access.
• Designed & developed multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Developed Dash Board reports, Scorecards, Visual Layouts, Master detail Drill through reports, Drill up and Drill down reports, multiple prompt reports and cascading prompts in Report Studio.
• Implemented different functionalities using report filters, sorting, multiple queries and conditional blocks.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Developed security for reports ,Conditional formatting, Bursting and scheduling of the reports
• Developing technical specification documents for the reports
• Involved in development and production testing and peer reviews
• Performance tuning of the reports