BACKGROUND SUMMARY:

• Over 7 years of Strong design/development experience with Business Intelligence solutions, OLAP tools and Data Warehousing (DW).
• Strong user and administrative knowledge of the Cognos environment and tools IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos 8BI, Report Net,Impromptu, Power Play, Impromptu Web Reports (IWR), Access Manager, Upfront and IWR servers.
• Administered Access Manager to implement Security among Cognos applications.
• Expert in the analysis, design and performance optimization of Business Intelligence/OLAP/ROLAP Reports.
• Proficient in the developing Complex reports in Cognos 8BI, Report Net, Impromptu and Power play.
• Experienced in Identifying and building business solutions using Cognos to support business needs.
• Strong experience in performing a variety of complex and technical functions including designing, testing, and installing software.
• Experience in Installation and Configuration of various Cognos Products.
• Expertise in building models and publishing packages in Framework Manager to the 8BI server.
• Experience in delivery of solution-oriented complex reports using Report Studio andDevelopment of ad-hoc reporting interfaces using Query Studio andanalysis of reports from cube packages using Analysis Studio.
• Involved in administration of Access Manager to implement Security among Cognos applications.
• Experience in publishing the reports to IWR server with controlled access as per the end-user requirement.

TECHNICAL SKILLS:

BI Tools

IBM Cognos 8.4,Cognos 8BI(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric Studio), Report Net 1.0/1.1 MR2,Cognos Impromptu 7.x/6.x, Power play 7.x/6.0, Impromptu Web Reports (IWR), Access Manager, Cognos Query, Power Play Enterprise Server, Scheduler

Databases

Oracle 11i,10g/9i/8i/7.x,SQL Server 7.0/2000/2005/2008,Sybase,MS Access 97/00/XP/03

GUI

Developer 2000, Crystal Reports, Business Objects, Erwin

ETL Tools

Informatica PowerCenter/PowerMart 7.x, Cognos Decision stream, Oracle warehouse Builder 9.1.X

Web/App Servers

IIS, Apache

Programming Languages

SQL, PL/SQL, C, C++, Java, J-Script and HTML

Microsoft Tools

MS excel, MS word, MS Visio, MS Project and MS PowerPoint Studio.

Database Tools

Toad, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Server Profiler.

Operating System

Windows, Windows NT4.x/9X/2000/XP and CISCO (IOS), UNIX, Linux,AIX

CERTIFICATION:

Cognos Certification Program

IBM Cognos Certified Designer --ID: SR5700682

PROFESSIONAL EXPERIENCE:

Confidential,

San Jose, CA

Cognos Sr. Admin/Developer

Oct 08 to Till Date

Force10 Networks is a pioneer in building and securing reliable, high performance networks. It has pioneered advances in high density Gigabit Ethernet and 10 Gigabit Ethernet switching, routing and security. It has developed Reliable Networking, which delivers the high availability, network control and scalability required to ensure network infrastructure flexibility and application readiness. This Project was developed internally for Finance and Budgeting. This helps the users to analyze the Past and Current data.

RESPONSIBILITIES:

• As a Developer and Administrator involved in the complete cycle of Project Plan, Design, Installation, Development, and Testing, Production Cutover, End User Training and Post Production Maintenance of the system.
• Involved in the installation and configuration of IBM Cognos 8.4,Cognos 8 BI suite of products
• Involved in setting up the Dev, Test and Production Environments with multi structure architecture
• Installed Gateway servers, Dispatchers, Cognos BI Servers (Application Server) and configured all the servers in Application server environment using Cognos Configuration in all the environments.
• Tested the Report/Cube Performances, Security, Batch Process, Report schedules in the new Cognos 8.4 environment.
• Involved in setting up the Content store by creating content databases in SQL Server Management Studio, SQL Server 2005 and Oracle.
• Involved in setting up the Security of Cognos Suite of Products Query Studio to General Users, Report Studio Report Authoring to Power Users, Report Studio Professional Authoring to Report writers based on User Roles
• Involved in setting up the Security to Cognos FM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Participated in requirements gathering process to bridge gap between user needs and tool functionalities
• Involved in giving permissions to User Groups & User Access.
• Involved Monitoring and Troubleshooting of servers with Performance Issues.
• Involved in upgrades, applying patches to the servers to fix the version bugs.
• Involved in deployment of Packages, Folders and Reports from one environment to other.
• Involved in Upgrade Cognos 8.3 Environment to Cognos 8.4 and Deploying and testing all the Reports.
• Worked on the Framework Manger to develop efficient data models like Entitlements, Invoice & Shipments, Force10GL, shipment by product line, Attach Rate, Balance Rate, Published Financial Statement, Sales order processing Metrics, Quotes & Details.
• Created the Dashboard portlets using portal tabs in cognos connection using dashboard.
• Designed Dashboards to different user groups and implemented security to dashboards.
• Created the different cube views using Analysis studio.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Generated all types of complex Reports –Purchase Order, Credit Debit Memo, Invoice Detail, Cost of Revenue Reconciliation, Expense Report details, Attach Rate, CRM Sales Orders & Comments, and Product Shipments.
• Involved in writing SQL DDL and DML commands in oracle.
• Generated Drill through Reports like Balance Sheet Details, Expense Report Details, OPEX Details, SOS Details, Statement ops Internal Details.
• Updated and maintained all cubes using batch files.
• Involved in Design and Creation of Datamarts using Star Schema/Snow Flake Schema.
• Involved in basic user training, product documentation, user test documentation.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created Value Prompt, Text box Prompt, Select & search Prompt, Date & Time Prompt, Tree Prompt.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.

ENVIRONMENT: IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.4 (Impromptu, PowerPlay Transformer and all Server Administration), MDX, DB2, SQL Server, SSIS, Oracle 10g,Windows XP.

Confidential,VA

Sr.Cognos BI Analyst

Jan 08 to Sep 08

This project is a part of USPTO Internal Data warehousing. This project is developed for their Budgeting and Forecasting to analyze data for their requirements. The Projects helps users to analyze the Past, Current Budgets and forecast the Future Budgets. Involved in administration, development and troubleshooting of Budgeting and Forecasting reports, scorecards and dashboards.

RESPONSIBILITIES:

• Involved in the complete installation and configuration of all the suites of Cognos 8BI products and setting up Content store database, Active directory configuration, and Mail exchange server.
• Involved in creating Data marts by using extract, transform and logic operations in SSIS.
• Involved in setting up 3 tier architecture environments dev, test and prod.
• Involved in setting up different project databases like Oracle, SQL server and imported and managed users, groups and roles from active directory.
• Worked on the Framework Manger to develop efficient star schema data models like SPR model, Program Objective model, Retailer model using multiple data sources.
• Design the framework manager model into various layers like Database layer, Transformation layer, Business layer, Dimensional layer and published as packages.
• Created Power Play cube as data source from both cognos series 7 and 8BI versions in framework manager and published as packages.
• Involved in setting up the Cognos 8 BI environment to Client locations. Installed and configured all the 8BI Components, Access Manager, Contributor, Query Studio, Report Studio, LDAP directory server.
• Involved in Upgrade Cognos 8.2 Environment to Cognos 8.3 and Deploying and testing all the Reports.
• Created List Reports, Dash Board Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Created and scheduled the alerts and events and emailed to users using Event studio.
• Generated all types of complex Reports– Staff on Board, Funds used by Business Area, Performance Goals, Fee Collections, Spending summary by BOC and ad hoc – Spending vs.Actuals used by Business Area, Applications Received using Report Studio and Query Studio from Model Packages and analyzed – General Ledger Detailreportsfrom cube packages planning.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and Master Detail Reports using Report Studio.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio.
• Involved in creating the Metadata models and Cubes using 8BI Planning and Contributor and generated reports in Report Studio from these Models.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports.
• Involved in Trouble shooting of the Planning and Contributor Models and Cubes according to the Report design and Business Requirements.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.

ENVIRONMENT: Cognos8.3 Planning (Analyst, Contributor), Cognos 8.3(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.3(Impromptu, PowerPlay Transformer), Oracle Migration Utility, Oracle10g, DB2, Windows 2003 Server.

Confidential,

Danbury, CT

Cognos Administrator/Developer

Feb 07 to Dec 07

This project is a part of Prudential Internal Data warehousing. This project was developed for Sales, Marketing, and Support user groups to analyze data for their requirements. Sales and Marketing departments can get different reports on previous sales and on present sales and get benefited by focusing on particular Product Families, Sales Regions and Lead Generation Process. Support group reports are concentrated on the number of Service Requests received for different Products, average time taken to resolve the issues etc.

RESPONSIBILITIES:

• Installing & Configuring of Cognos 8BI, ReportNet, Access Manager, Upfront, LDAP directory server.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in setting up the Cognos 8 BI environment to Client locations. Installed and configured all the 8BI Components Access Manager, Framework Manager, Analysis Studio, Event Studio, Query Studio, Report Studio, Upfront, LDAP directory server.
• Used 8BI Framework Manager in building the Models, Cubes using different data sources for CoA (Chart of Accounts), PDI (Prudential Distribution Inc.).
• Generated all types of complex – Work Order, Purchase Order, Account Balance Reports and ad hoc - Department Expense by Manager, Supervisor Reports using Report Studio and Query Studio from Model Packages and analyzed – General Ledger Detailreportsfrom cube packages using Analysis Studio.
• Created the Notifications and Alerts for the Reports that are critical in budget calculations using Event Studio.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Migrated several existing Cognos Impromptu Catalogs into xml files and imported thexml files as data sources into Cognos Report Net.
• Invloved in Migrating Cognos Series 7.3 to Cognos BI 8.1
• Closely involved in security administration using Series 7 for the Cognos Report Net reports.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports and ReportNetreports.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Involved in Documentation and Training Users and Business Partners on Query Studio for Ad Hoc Reporting.

ENVIRONMENT: Cognos8BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7. 3 (Impromptu, PowerPlay Transformer), SQL Server 2005, Windows 2003 Server.

Confidential,

Dallas, TX

Cognos Consultant/Analyst May 06 to Jan 07 CompuCom helps clients accomplish their business objectives by providing the comprehensive strategy, assessment, procurement, implementation, integration, and support services that help them derive maximum value from their IT operations. Primary tasks included designing, developing and implementing Models. The analysis of the Scorecards and Reports helped them in having increased understanding of their customer base, across all product businesses, as well as the ability to provide their customer relationship managers with meaningful, actionable information that impacts their decision-making processes.

RESPONSIBILITIES:

• Administered reports in Cognos like Scheduling ad hoc reports, viewing the run history of reports, distributing ad hoc reports by email.
• Used Access Manager to configure multiple user classes, defined dimension views and user class views for different user groups to provide high security for highly sensitive data.
• Administered Impromptu to Limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve for different User Classes.
• Involved in Migrating Cognos Series 7.3 to Reportnet 1.1
• Involved in creating different types of ad hoc reports (grouped lists, crosstabs, etc.) using ReportNet.
• Customized ad hoc reports (adding charts, titles, etc.).
• Compared and analyzed data in ad hoc reports (using filters, summaries, prompts, etc.).
• Developed Power play reports like variance reports and exception reports.
• Troubleshoot and evaluated report effectiveness by tuning query data’s and controlling user access.
• Defined, created, maintained and published power cube
• Created Impromptu Reports, published on the web using IWR.
• Provided End User training and Support.

ENVIRONMENT:Cognos Report Net v1.1, Cognos series 7.3(Impromptu, Powerplay, Transformer, Power play enterprise server), Access Manager, UPFRONT, IWR Server 7.3, Netscape Directory Server, Oracle8i and UNIX.

EDUCATION:

• M.S in Computer science
• Bachelors in Computer Science Engineering