OBJECTIVE:

• Results - oriented IBM Cognos Business Intelligence Developer with Most Admired Global Companies.
• Exceptional problem solving skills in complex highly integrated data warehousing environments.
• Proven ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.
• Strong leader creating vision and inspiring teams to drive results

SUMMARY

• Having 9+ years of Complete BI project life cycle experience with BI Tool COGNOS 10.X, 8.X & Report Net 1.1/ EP Series 7 including Framework Manager, Report Studio, Query Studio, Impromptu Administrator, Analysis tools such as, Analysis Studio, Power play and server installation and maintenance.
• Sound knowledge on reporting using Cognos 10& 8 Report Studio/CRN 1.1
• Sound Knowledge on Cognos 10/8 BI Suite (framework Manager, Cognos connection, Report Studio, Business Workspace, Business Workspace Advanced . Metric Studio, analysis Studio and Query Studio)
• Customized the Cognos Connection Portal/reports based on user requirements.
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Hands on Experience in installation and Configuration of Cognos Components (Web, Application & Data) for Distributed Installation Environment Setup both Windows and UNIX.
• Good experience with Transformer model design and Power play cube building.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, DB2 and Teradata.
• I have maintained effective client service relationships and Implemented business process improvements
• Good Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Experience in Customization of Cognos Connection Portal/reports according to the user requirements.
• Trained End Users in Cognos Business Insight/Business Insight Advanced and prepares User Guides/Workshops on the same.
• Created Complex Active Reports using Tab Controls, Decks & Conditional highlighting of chart bars.
• Experienced with Cognos 10.2 new features Dynamic Cubes, DQM, Active Reports etc.
• Experienced with Cognos 10.2 Workspace and Workspace Advanced for creating reports and Complex Dash Board Reports.
• Excellent knowledge on data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.x & 8.x (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio), CRN 1.1 MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront)

ETL Tools: Informatica 8.x/ 7.X, Data Stage and SSIS, Cognos Data Manager 8.x

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, Windows XP Professional, UNIX-AIX

Web Servers: IIS,Tomcat and Apache

Application Servers: Weblogic and OAC

Databases: DB2,Oracle 10g/11g, SQL Server 2000/2005,Teradata

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.Cognos Developer

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Developed Technical Design Documents.
• Developed logical & physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snow flake /star schemas for better understanding of models using ERWIN.
• Designed Relational/DMR models in Framework Manager
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Report Studio
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our Asian, African and European partners
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Used Union, Intersection for creating queries.
• Created dashboard reports for Managers group daily monitoring purpose.
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Created complex reports in Cognos mainly dealing with Risk, Customer, Banking Data.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Created models in Transformer, built cubes and published cubes and analyzed in Analysis Studio
• Carried out performance tuning of reports.
• Interacted with ETL team to gather the requirements for the reporting.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Involved in creation of Active reports using Cognos Business Insight and Advanced tools. Built Dash Board reports with multiple Active reports created using multi source data and defined filters to filter data on specific business criteria.
• Exceptionally good and experienced in handling the problem and troubleshooting.
• Trained End users to operate the reports.
• Involved in Upgradation from Cognos 10.1.1 to Cognos 10.2, Migrated Models, Reports and Tested the models, Reports which are migrated from Cognos 10.1.1 to Cognos 10.2

Environment: - Cognos 10.1.1/10.2 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Advanced, 10.2 Work Space and Advanced and Cognos connection), Powerplay Transformer, Cubes, Oracle 9i,Dash Board Reports, Windows 2003 server.

Confidential, East Hanover, NJ

Sr. Cognos Developer

Responsibilities:

• Analyzed the functionality and Business Requirement and transformed the Functional Design Document into Technical Design Document.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using Multi Layer Approach and Modeling best Practices to meet the reporting requirements.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi Dimensional Reporting.
• Published Packages to Cognos Connection and implemented Package Level Security.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Using Transformer cubes as data source import into Framework Manager, and created Models, packages for Analysis Studio.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi Dimensional Analysis.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved in creation of MultiQuery and MultiPage Reports in report Studio.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups

Environment: - Cognos 8.4/8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), DB2, Oracle 9i, SQL Server 2000, Cognos Access Manger, Windows 2003 Server

Confidential, RI, Providence

Sr.Cognos Developer

Responsibilities:

• Developed List, Charts, Drill-Through, Master-Detail reports using Report Studio and Query Studio.
• Created standard filters, calculations, and conditions in Models
• Created standard Calculations, Filters, and Prompts for Ad-hoc queries.
• Created complex reports with Cross tab, conditions to evaluate the business performance tasks.
• Design, developing and publishing packages using Framework Manager
• Created multi page report based on multiple queries using Prompts and Parameters.
• Involved in Data Validation and Testing of code and reports, Sql queries.
• Automization and customization the report generation.
• Implemented security at Report side using Cognos Connection
• Scheduled (Daily, weekly, Monthly and Quarterly) and distributed reports using Schedule Management in Cognos Connection.
• Creation of Transformer Model and Power Cubes, Deployment of Model from One environment to other.
• Creation of Relational and Multi dimension Dash Board Reports.
• Created Business Summary and Prompted version of reports based on used security.
• Defined roles that will have access to two types of reports: reports published and scheduled in Cognos 8 portal (Canned reports) and prompted reports and their security levels.
• Understanding of Cognos BI security model and will be able to identify best practices for configuring applications and work with the development teams to implement the standards.

Environment: -Cognos 8.1 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio), Powerplay Transformer, Cubes and Oracle 10g

Confidential, Bethesda, MD

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design & development of the reports using Cognos Report Studio, Query Studio reports.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Design and Developed the Framework Manager models and Published into server.
• Developed Report Studio and Query Studio Reports in Cognos ReportNet portal.
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Migrated catalogs and reports from Cognos 7.4 to CRN.

Environment: - Cognos Report Net (Cognos Connection, Framework Manger, Report Studio, Query Studio) Oracle 9i, Cognos Access Manger, Windows 2003 Server.

Confidential - New York

Cognos Developer

Responsibilities:

• Created PowerPlay cubes using Transformer (PowerPlay).
• Data retrieval, Multidimensional analysis, PowerPlay structure.
• Reporter Operations such as Sum and Average.
• Exception Highlighting, Sorting, Ranking etc, Changing filters, layers and measures.
• Created Multi-Dimensional reports using PowerPlay.
• Cognos Impromptu Reports, Created Business Mix reports and Top ten reports.
• Designed and developed multi dimensional cubes, Visualizations.
• Queried data from different database tables as per the requirement.
• Joined the different table as per the requirements.
• Created reports in HTML format for easy navigating of data from web browser.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Presenting complex data summary report, Exception highlighting.
• Created Report and prompts, Created summary and detailed filters.

Environment: - Cognos Impromptu 7.4, Impromptu Web reports (IWR), Power Play, Transformer, Oracle 9i, Cognos Access Manger, and Windows 2003 Server

Confidential, MI

Cognos Developer

Responsibilities:

• Created catalogs with the help of Impromptu utilizing relational databases.
• Developed impromptu reports with various functionalities (Drill - through, Cascading prompts).
• Created templates utilizing Impromptu, Created ad hoc reports utilizing Cognos Query.
• Created user prompts, conditions and filters to improve report generation.
• Created hierarchies to provide drill-down options for end-users.
• Created powerplay cubes using powerplay transformer to permit multi dimensional cross sectioning and drilldown analysis.
• Coordinated training sessions and demonstration of Cognos tools to end-users.
• Used various OLAP query/reporting tool to maximize or reinforce the data delivery function in a data warehouse environment.
• Provided support to projects for new applications / report needs.
• Provided technical support to other team members in all supported areas.

Environment: -Impromptu 6.0 Transformer 6.6 and Power play windows and Web Internet Information Services (IIS) 5.1, MS SQL Server, Windows 2000,.