PROFESSIONAL SUMMARY:

• 9+ Years of Professional IT Experience in Data warehouse reporting using Cognos 10.2.2/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), Cognos 8.x and Cognos Reportnet, Impromptu 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.
• Experience with IBM Cognos 10.2.2 version.
• Expertise on creating models in Cognos 10/Cognos 8.x Framework Manager for reporting and in creating Business Layers, Hierarchies, macros & folders and publishing the packages using Framework Manager to the Cognos Content Store.
• Experience in designing models with Framework Manager involving Relational Models and Dimensional models (DMR).
• Having Knowledge of Upgrading from TM1 9.4.1 to TM1 9.5.
• Sound Knowledge on Report Studio in using Tabular Objects, Tabular SQL, Customized Prompts, Conditional Formatting and Complex Layouts - Cross tabs and sub reporting, bursting.
• Experienced in developing Active Reports and Dashboard Reports in Cognos 10.2.2 and Cognos 10.2.1.
• Experience in using the latest RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Experience with installation and configuration of the CAFE (Cognos Analysis For Excel) tool integrating it in Microsoft Excel 2010.
• 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.
• Experience in Oracle 11g/9i/8i, SQL and SQL Server 2012.
• 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:

Project Management Tools: Microsoft Project, JIRA, Confluence, MS-Word, Excel, Power Point

Business Intelligence Tools: IBM Cognos 10.2.2/10.2.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, RAVE Visualizations and Cognos Analysis for Excel (CAFE) Tool.

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

ETL Tools: Informatica Power Center 9.x/8.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor)

RDBMS/DBMS: Oracle 9i, SQL Server 2008 and 2012, Access 2007

Operating Systems: Microsoft Windows 2003/2005/2008, XP, Win 7 and Win 8.1

WORK EXPERIENCE:

Confidential, Jacksonville, FL

Senior Cognos BI Developer

Responsibilities:

• Migration of the reports from Cognos 10.2.1 to Cognos 10.2.2 environments.
• Validating & troubleshooting migrated metadata models and reports in Cognos 10.2.2 environment.
• Creating models in Cognos 10.2.2 Framework Manager for reporting and in creating Business Layers, Hierarchies, macros & folders and published the packages using Framework Manager.
• Designed and developed Dashboard for Acosta's Walmart Client using Active Reports and RAVE Visualizations.
• Active involvement in SCRUM meetings related to projects on a daily basis.
• Working in a Agile Project Environment and responsible for attending daily Scrum meetings conducted by the Scrum Master.
• Responsible for managing the Framework Manager Projects, Models and Packages.
• Involved in Designing and Planning for application migration from Cognos 10.2.1 to Cognos 10.2.2 environment.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Responsible for designing models with Framework Manager involving Relational Models and Dimensional models (DMR).
• Coordinating in different Levels of Testing to achieve the common goal of High availability of Web Application.
• Coordinating and moving the Packages, Reports, Cubes from Development environment to Test, Stage and Production Environment.
• Responsible for performing 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.
• Responsible for creating List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis
• Active involvement in adding new Reports, Cubes to the respective Acosta Application.
• Troubleshooting the existing Framework Manager Model and update the model with IBM Standards.
• Providing strategic solutions after performing RCA and troubleshooting the BI issues. 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.

Environment: IBM Cognos 10.2.2 (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, Microsoft SQL Server, Framework Manager on Windows 7 Professional, Toad 9.1, JIRA, Confluence.

Confidential, Lisle, IL

Senior Cognos BI Developer

Responsibilities:

• Involved in the Migration of the packages and reports from Cognos 10.1 to Cognos 10.2.1 environments.
• Validating & troubleshooting migrated metadata models and reports in Cognos 10.2.1 environment.
• Participated in Designing and Planning for application migration from Cognos 10.1 to Cognos 10.2.1 environment.
• Provided strategic solutions after performing RCA and troubleshooting the BI issues.
• Designed models with Framework Manager involving Relational Models and Dimensional models (DMR).
• Created models in Cognos 10 Framework Manager for reporting and in creating Business Layers, Hierarchies, macros & folders and published the packages using Framework Manager to the Cognos Content Store.
• Actively involved in re-modeling the existing Framework Models and updating the current packages to suit the IBM standards.
• Attended Analytics Summit yearly meeting for Ryerson and gave a short demo on Cognos Workspace Advanced to the Business users and answered their questions and concerns.
• Sound Knowledge on Report Studio in using Tabular Objects, Tabular SQL, Customized Prompts, Conditional Formatting and Complex Layouts - Cross tabs and sub reporting, bursting.
• Responsible for developing Active Reports and Dashboard Reports in Cognos 10.2.1.
• Worked with the latest RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Involved in the installation and configuration of the CAFE (Cognos Analysis For Excel) tool.
• Involved in providing user level security to the users depending on their roles and responsibilities.
• Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
• Successfully executed the Projects within the Budget and stipulated timeframe.
• Responsible for managing the Framework Manager Projects, Models and Packages.
• Coordinated in moving the Packages, Reports, Cubes from Development environment to Test and Production Environment.
• Coordinated in different Levels of Testing to achieve the common goal of High availability of Web Application.
• Used features in Cognos administration like monitoring activities, system and schedule
• Involved in setting up security using IBM Cognos Administration.
• Created detailed documentation of the requirements in a professional document.
• Created basic documentation on IBM Cognos Workspace Advanced for business users.
• 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.

Environment: IBM Cognos 10.2.1 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Transformer, Powerplay Studio, Metric Designer, Metric Studio), Content Store, Oracle10g/9i, Framework Manager on Windows 7 Professional, Toad 9.1

Confidential, Bloomington, IL

Cognos 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.
• Participated in designing and planning for application migration from Cognos 8.4 to Cognos 10.1
• Attended SCRUM meetings related to projects on a daily basis. Actively participated in Retrospective Planning Meetings.
• Primary contact for On-call/Production support of SMI, WSDM, WLM and Servce Management .
• Worked on Incidents and Service calls using HP Service Desk/Service Manager to resolve the Production Issues.
• Actively worked with Management team and Designers to get the Requirements and create High level Application Design.
• Successfully executed the Projects within the Budget and stipulated timeframe.
• 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.
• 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.
• Managed security using Cognos Administration.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• 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.
• Scheduled and Distributed 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.
• Individually developed complex reports consisting of multiple queries, and multiple joins, Unions, ranking, and drill through to other reports.

Environment: IBM Cognos 10.2.1/10.1.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, 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.
• 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.
• 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.
• 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.

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.
• 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, dashboard, 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.
• 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.

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 8 BI 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.

Environment: Cognos 8 BI MR1, MR2, Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Configuration, DB2, Oracle 9i and SQL Server 2000, MS Visio 2003, MS Project 2000.