SUMMARY:

• Over 8 Years of Professional IT Experience, inclusive of more than 6 years of Data warehouse reporting using Cognos 10.2.1/Cognos 10.1 (Business Workspace, Business Workspace Advanced, Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Query Studio, Powerplay Transformer, Powerplay Studio, Cube Designer - Dymanic Cubes), Cognos 8.x and Cognos Reportnet, Impromptu 7.3, Cognos Power Play Enterprise Server 7.3, Power Play Transformer.
• Experience in gathering requirements and converting business requirements into functional specifications and in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams and Class Diagrams with good knowledge of Business Process Modeling tools like UML, RUP and Rational Suite.
• Served as a mentor for offshore team for more than two years.
• Expertise on creating models in Cognos 10 Framework Manager for reporting and in creating Business Layers, Hierarchies, macros & folders.
• Sound Knowledge on Report Studio in using Tabular Objects, Tabular SQL, Customized Prompts, Conditional Formatting and Complex Layouts - Cross tabs and sub reporting, bursting.
• Created Multi-dimensional models using Powerplay Transformer, Cube Designer based on business gathering.
• Designed Developed and Implemented Cubes for various analyses / reporting purposes and worked with different Kinds of sources like Relational and Flat files.
• Designed, implemented normalized multi-dimensional Star schemas and Data Marts using Erwin4.0/7.5.
• Experience in Oracle 11g/9i/8i, PL/SQL, SQL, Stored Procedures, Functions, Triggers, and SQL Server 2000, 2005 on UNIX and Windows platforms.
• Excellent knowledge on Data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS:

Databases: Oracle7.x/8i/9i/10/11g, Teradata, DB2 9.5/10.1 and Microsoft Access, SQL Server 2005, 2008

Operating Systems: Windows 2003/2005/2008, Windows 8/7/XP

Business Intelligence Tools: IBM Cognos 10.2.1/10.1 (Business Insight/Workspace, Business Insight/Workspace Advanced (BIA), Cognos Connection, Framework Manager, Report studio, Query studio, Powerplay Studio, Analysis Studio, Cube Designer-Dynamic Cubes), Cognos 8 BI 8.4, 8.3, 8.2, 8.1.2 (MR2) suite, Cognos Power Play Transformer V8.x, 7.x, Cognos Report Net 1.1 (MR3)Cognos 7 BI 7.4, 7.3, 7.1 suite Cognos Impromptu Administrator 7.x/6.x,Power play Transformer 7x, Power play User 7x, Cognos Upfront, Decision Stream 7x, Impromptu Web Reports (IWR), Power Play Enterprise Server, Cognos Server Administrator .

Web Developing Tools: HTML, JAVASCRIPT, FrontPage, Flash and XML

Web Servers: IIS, Netscape Enterprise Server, IE, SharePoint

ETL ToolsInformatica: Power Center 9.x/8.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Cognos Analytic Application

Data Modeling: Erwin 4.0, ER Studio 7.1, MS Visio

Programming Languages: SQL, C, C++, and JAVA

WORK EXPERIENCE:

Confidential, Bloomington, IL

Senior Cognos BI Developer

Responsibilities:

• Migration of the reports from Cognos 8.4 to Cognos 10.1 environments.
• Validating & troubleshooting migrated metadata models and reports in Cognos 10.1/8.4 environment.
• Designing and planning for application migration from Cognos 8.4 to Cognos 10.1
• Providing strategic solutions after performing RCA and troubleshooting the BI issues.
• Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
• Successful Executing the Projects within the Budget and stipulated timeframe.
• Working on Incidents and Service calls using HP Service Desk/Service Manager to resolve the Production Issues.
• Responsible for managing the Framework Manager Projects, Models and Packages.
• Actively involved in adding new Reports, Cubes to the respective StateFarm Application.
• Coordinated in moving the Packages, Reports, Cubes from Development environment to SimProd and Production Environment.
• Coordinated in different Levels of Testing to achieve the common goal of High availability of Web Application.
• Troubleshot Framework Manager Model which is migrated from Impromptu Catalog.
• Created IQD from Framework Manager and used it to create a model/cube for meeting some requirements where users wanted drill through/slicing and dicing, which can be done with a cube.
• Used features in Cognos administration like monitoring activities, system and schedule
• Setup security using Access Manager Administration.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Effectively communicated with Business Analysts to resolve design action items. Involved in providing both business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis.

Environment: IBM Cognos 10.1/8.4 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Transformer, Powerplay Studio, Metric Designer, Metric Studio), Content Store, Oracle 10g/9i, IIS, Framework Manager on Windows XP Professional 2002, SQL Server 2005/2008, Toad 9.1, Control-m, Hp Service Manager, IBM DB2, ERStudio 7.1.

Confidential, Chicago, IL

IBM Cognos BI Developer

Responsibilities:

• Served as a liaison between Business & IT for multiple business areas such as BCC (Blue Care Connect), ASO (Administrative Services Only), and EPP (Enterprise Product Platform).
• Effectively communicated with Business to resolve design action items. Involved in providing both business and technical expertise in the requirements gathering, report design, report development by performing analysis of an underlying data source/schema.
• Created requirement design documents used by the development team in Illinois, Texas, New Mexico & Oklahoma that addresses the business needs and the proposed reporting solutions.
• Created and worked with complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged the data to create solutions that present data through Cognos BI Dashboards and KPI's.
• Migrated reports from Cognos 8.4 to Cognos 10.1 environments. Validated the migrated metadata models and reports in Cognos 10.1 environment.
• Developed Cognos reports using MDX and OLAP Cubes as a data source, Passing Parameters (MDX and regular) to drill down reports, etc.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Trained end users to develop interactive dashboards using Business Insight for ad-hoc query analysis.
• Assisted the business users in analyzing the data by utilizing various Business Insight functionality - slider filters, chart type changes, drill up/down techniques, pre-defined/custom calculations, on the fly prompt modifications etc. on the dashboard.
• Developed dashboard reports using Business Insight Advanced (BIA) from the base and on the existing reports using multiple query objects and by integrating external data on the fly.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Performed post-development peer review & coordinated migration/deployment of packages, reports and cube between environments.
• Designer Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos 10.2.1 environment to increase the performance.
• Developed SQL Server Stored Procedures for data migration and transformation from Teradata extracts to SQL Server objects.
• Articulated and implemented OLAP solutions that drive strong return on investment and provide robust high availability and performance.
• Worked with HP Service manager and Service Desk to handle the Service calls, problem records and work orders to resolve the issues for the Business partners.
• Presented demos to the business users to expose the proficiency of upgraded versions of Cognos tools.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.

Environment: Cognos 10.2/10.1/8.4 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio, Powerplay Studio, Powerplay Transformer, cube Designer - Dynamic Cubes),Oracle 11G/10G, SQL Server 2005/2008, MS Visio, Toad 10.5, HP Service Manager.

Confidential, Phoenix, AZ

Cognos BI Consultant

Responsibilities:

• Implemented business process re-engineering for several business units using modern business technologies. Duties included gathering business requirements, making recommendations, preparing technical specifications and overseeing the implementation of the new processes.
• Organized cube dimensions hierarchically in a pattern which can easily be used for reporting by Cognos BI suite (Report Studio, Query Studio and Analysis Studio).
• Designed and developed Framework manager models and Packages for various projects with the source as DB2, SAP BIcubes.
• Designed and created dashboards reports and scorecards in Report Studio and Analysis Studio. Developed complex reports and implemented Bursting for the reports.
• Individually developed complex reports consisting of multiple queries, and multiple joins, Unions, ranking, and drill through to other reports. Extensively used MDX OLAP functions in Creating report Studio Reports.
• Migrated Cognos objects from DEV - > QA - > PROD and Optimized Cube performance to improve the report run time.
• Involved in production support of reports and debugging issues raised by worldwide users there by fixing them in Dev and deploying them back to Production.
• Designed and developed Framework manager models and Packages for various projects with the source as DB2, SAP BIcubes.
• Migrated Cubes to Cognos 8 BI, Created externalized Query Subject to create Impromptu Query Definition (IQD) files to use as source in building Powerplay Transformer cubes and used as a cube data source to create a package.
• Published IWRs and Power Play cubes, Power Play reports, on the portal using Cognos IWR administration, Power Play enterprise server.
• Validated the reports against the planning data in the Cognos contributor along with unit testing by writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Trained end users in accessing the reports, interacting with prompts and in creating ad-hoc reports using Analysis Studio.

Environment: Cognos 8.3/10.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Powerplay Transformer, Powerplay Studio), Transformer 7.4, DB2,Toad, HP Service Center, Informatica 8.6.1, MS SQL Server 2005, IBM DB2.

Confidential, Los Angeles, CA

Cognos BI Developer

Responsibilities:

• Interacted with the user to understand the user reporting requirements for various financial planning applications like PNL (Profit & Loss) Forecasting and Budgeting Model. Facilitated Joint Applications Development (JAD) Sessions for detailed definition of business requirements.
• Created ‘Requirement Specification document’ to define the requirement specification which addresses Functional and Non-Functional structure of the PNL BI reporting model.
• Used access manager and Cognos Contributor to set user permissions and work flow access. Monitor and Maintain Job servers & Job Clusters.
• Published analyst cubes on the web using Cognos Contributor and set access using Access manager.
• Executed admin link macros upon the request for the real time reports, and performed GoToProduction on daily basis. Scheduled the batch files to publish the data from the planning to the ETL (AAF) and from ETL to the reporting.
• Created PNL Forecast reports for four decks (Monthly/Total Year Quarterly/Quarterly/Budget) for each individual company and created PNL Consolidated reports which capture the summarized data of the companies at different levels with drill through functionality.
• Expertise in developing Standard Reports, dash board, List Reports, Cross-tab Reports, Charts, and Multiple-levels of Drill through reports Using Report Studio.
• Deployed reports from development environment to the production ensuring the user group access and security.
• Validated the reports against the planning data in the Cognos contributor along with writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Implemented database partitioning to improve the performance tuning of all the reports that access the huge table.
• Analyzed and created indexes on certain fields to boost the performance of the reports.
• Responsible for the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of Cognos environment with good Knowledge of Cognos 8 BI and Cognos Connection portal.
• Trained the users in accessing the models and assisted them in building the adhoc reports from Query studio and also assisted the users to create dashboard reports using Analysis Studio.
• Participated in review meetings to propose enhancements to the existing application from business perspectives and coordinated with the users during the User acceptance phase.

Environment: IBM Cognos Planning 8.3 - Analyst / Contributor, Cognos 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio), IBM’s Adaptive Analytics Framework (AAF), SQL Server 2000 and Toad

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Worked on Sales and Marketing, OTIFIC (On Time In Full Invoice Correctly) and Manufacturing Reporting Projects. Created Framework Manager Models and reports using Cognos 8 BI for Gypsum, division of Lafarge which is the world leader in building materials.
• Worked on building models in Cognos 8BI environment. Created and maintained database query subjects, model Query Subjects, hierarchies, levels, members and packages.
• Worked on Star Schema Grouping, Calculations, Filters, and Parameter maps. Built Presentation Layers and published packages.
• Worked on Report Studio in creating List, Crosstab, Charts, and Repeater reports. Worked on exception reports to report critical information using conditional formatting.
• Created YTD reports, worked on stitching queries and created multiple query reports, multiple page reports, multiple prompt pages, and prompts and cascading prompts.
• Scheduled reports in Cognos Connection and output reports in various formats like HTML, PDF, CSV and EXCEL formats.
• Worked on Report Studio to Report Studio Drill thru reports. Created multiple drill thru’s from a single data item.
• Worked on unit testing by writing manual SQL queries against the database to validate reports.
• Upgraded Cognos 8 BI environment from MR1 to MR2 and provided support. Experience deploying reports in production environment and provide production support.
• Trained end users in accessing the reports, interacting with prompts and trained users in creating ad-hoc reports using Report Studio tool.

Environment: Cognos 8 BI MR1, MR2, Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Configuration