SUMMARY

5 years of IT experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence tools.

• Worked on multiple Cognos BI/Data Warehouse projects with strong technical skills Modeling and Report Authoring and deep Functional/Domain/Business knowledge.
• Experience in Cognos 10.1.1 and Cognos 8 8.4/8.3/8.2/8.1 Suite Framework Manger, Cognos Connection, Report Studio, Query Studio and Analysis Studio with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Experience in Installation, Configuration, Monitoring and administrating of Cognos 10.1.1/8/8.4/8.3 on distributed environments.

Upgraded Cognos 8.4 content to Cognos 10.1.1.

• Extensively worked on Framework Manger in creating models and implementing 'best practices' while modifying relationships, resolving the loops and Dimensionally Modeled Relational data DMR/ROLAP .
• Designed and implemented data cubes using OLAP services, PowerPlay, Transformer to facilitate executive, management and end user reporting.

Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data warehousing concepts and Dimensional modeling Star schema and Snowflake schema.

• Expertise in developing List, Cross-tab and Chart Reports using Drill-Through, Master-Detailed and Customized reports using dynamic Prompt functionalities.
• Proficient in developing complex Dashboard reports using Business Insight, Report studios and Implemented Security among various Cognos applications.
• Strong programming and debugging skills in Oracle Data Warehouse, PL/SQL, SQL.
• Hands on experience in administering, deploying and maintaining models, reports and cubes.

Installed and configured various components, such as the Framework Manager and Content Manager.

• Designed and developed OLAP applications, Transformer Models and Multidimensional Power Cubes.
• Experience in installation and configuring the Cognos environment with web servers Apache, etc.
• Worked with Oracle8i/9i/10g, SQL Server 2000/05, Teradata, DB2, SAP BW and MS Access.
• Extensive experience in supporting Enterprise Data warehouses and Data marts.
• Knowledge in planning, designing, developing and deploying Data warehouses, Data Marts/ODS by Following Star and Snowflake Schema with experience of both relational and multidimensional database design using Data Modeling tool Erwin 4.0 Physical and Logical data models .
• Experience in Integration of various data sources like Oracle, DB2, SQL Server, MS Access, and Flat Files into a Staging Area.
• Experience in Migrating reports from Cognos 8.4/8.3 to Cognos 10.1.1 Environment.
• Excellent track record demonstrating strong analytical and problem solving skills.
• Excellent interpersonal skills with an ability to adapt to new and challenging environments and ability to work independently with good degree of independent judgment as well as with a team.

TECHNICAL SKILLS

EXPERIENCE

Confidential

Cognos Consultant

Responsibilities:

• Actively involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and IT Team.
• Worked actively in Cognos 10.2 Environment, worked actively with Report Studio, Query Studio and Analysis Studio.
• Developed Executive Dashboard reports using Cognos Report Studio, Workspace and Workspace Advanced.
• Developed and Deployed Cognos Go Office to access to Cognos Business Intelligence content in Microsoft Excel spreadsheet.
• Developed Active Reports Work Space, Mobile applications, List Reports, Bar Charts, Drill through Reports, Master Detail Reports using Report Studio and Query Studio.
• Build complex reports which involved multiple Prompts in Report Studio, Burst Reports against database.
• Developed reports which used Conditional blocks/variables and associated them with queries to show data only when the conditions were fulfilled.
• Developed Reports using Conditional Formatting, Cascading Prompts, Optional prompts.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, 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.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Drill- through reports and Customized Reports with Prompts List and Crosstab .
• Actively involved in developing Transformer model design and Power play cube building and implemented Securities on cubes.
• Worked on Performance Tuning to maintain fast performance of the cubes and Transformer models.
• Writing the test cases for SIT System Integration testing and UAT User Acceptance testing .
• Resolved issues resulting from User Acceptance Testing UAT .
• Coordinated with Development Team Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.

Environment: Cognos 10.2, 10.1, 8.4 Cognos Connection, Framework Manager, Report Studio, Query Studio, Power Play Transformer , Cognos Go Office, Cognos Go Mobile, SQL Server.

Confidential

Cognos Developer

Responsibilities:

• Interact with business analysts and end users to gather business requirements.
• Generated various List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, data Sources and publish packages to report server.
• Created Security at Object Level, Data Level and Package Level.
• Created Audit dashboards to track the statistics of various report applications using tools in Business Insight such as Value filter and Slider filter.
• Actively involved in Maintenance Production Support.
• Design and Document the technical specification documents.
• Deployment of Cognos reports and packages into various environments.
• Unit Test the reports before deploying to Test environment.
• Pass instructions to the offshore team about the Production Support activities and tasks in a weekly basis.
• Developed Performance and Audit dashboards for accurate on-time representation of application usage data using graphs, crosstab, lists and drill through functionality.
• Designed the Transformer model and built the cubes using Power Play Transformer and explored the Cube data using Analysis studio.
• Created and published cubes using Power play Transformer and implemented security into the cube model.
• Coordinate with Offshore team to manage various releases of Cognos applications.
• Review and Analysis of the offshore development work with Client Manager.
• Weekly Calls, Status reports, Performance review with offshore team.
• Trained users in Query, Report studio and Business Insight for report design understanding and gaining technical knowledge.
• Coordinate with the Testing team to fix the logged defects in HP Quality Center.

Environment: Cognos 10.1, 10.1.1, 10.2 Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advanced, Workspace, Active Reports, Cognos Connection, Powerplay Transformer, Framework Manager , Microsoft SQL Server 2008, HP Quality Center, Windows XP

Confidential

Cognos Developer

Responsibilities:

• Involved in requirements gathering and design of data warehouse and data mart entities.
• Used Framework Manager to create models, packages and publish packages to the server with the required query subjects, query items, and namespaces for the reporting needs.
• Worked on Analysis Studio, Report Studio and Query Studio in Cognos 10.1.
• Extensively worked on different options in Report Studio like drill through, master detail, charts to meet the user requirements.
• Created static choice value prompts, conditional variables Boolean and string and conditional blocks associated with these variables to display/hide columns and queries based on user's selection in Prompt page.
• Developed standard templates in Report Studio for developing reports.
• Designed the Dashboard Templates and created various Dashboards for the Business Users.
• Worked on PowerPlay Transformer to create multidimensional models after importing source data IQDs and Architect Models. Enhanced the model by adjusting the dimensions, levels, creating categories, calculated measures, alternate drill downs.
• Created power play cubes using Power Play Transformer to permit multi-dimensional Cross Sectioning and drill down analysis.
• Created security setup using Access Manager. Automated the process of building user classes and Apexing in Cognos Transformer Models using Macros.
• Involved in performance tuning of reports.
• Created Active Reports using Cognos 10 BI.
• Designed and created stored procedures, configuration files, tables, indexes, views, and functions implemented best practices to maintain optimal performance.
• Was part of SQL server administration, which involved developing proper maintenance and back up plans.
• Involved in upgrading of Cognos 8.3 to 10.1 BI Suite.
• Responsible for Cognos 10.1 Installation and configuration set up.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 10.2.0/10.1.1/10.1.0/8.3/8.2 Cognos Connection, Analysis Studio, Studio, Report Studio, Query Studio, Frame Work Manager , PowerPlay 10.x, PowerPlay Transformer 10.x, IIS 7.5 Web Server, SSIS 2005/2008, SQL server 2005, DB2 9.7,Windows 2008

Confidential

Cognos Developer

Responsibilities:

• Created Dash Board Reports using JavaScript in Report studios and adding it to the portal page using HTML Items for critical performance metrics Operations, Sales, Human Resources, Information Technology, and Standards using MDX functions.
• Designed Reports using most of the Report studio features Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up .
• Customized Cognos Connection with appropriate reports and security measures.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and Master Detail Reports using Report Studio.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise reporting architecture.
• Created security filters at the Framework level to restrict data access.
• Developed required models for reporting using advanced Framework Manager Techniques to meet all the reporting requirements.
• Worked on modeling the metadata extracted from multiple databases and established joins and cardinality to meet the business needs.
• Developed requirement specification documents with inputs given from Power users and also designed report mockups when required.
• Analyze the accessibility of the Product Developed evaluation Sheet within the context of overall product priorities, timing and cost.
• Used Enhanced suppression in Cognos 8.4 Report Studio by suppressing reports against dimensionally-modeled relational, and OLAP sources.

Environment: Cognos 8.4 Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Transformer and Event Studio , JavaScript and HTML, Oracle Database 10g, Impromptu 7.4, Cognos Powerplay 7.4.

Confidential

Data warehouse Consultant

Responsibilities:

• Extracted operational data from multiple sources, merged and transformed the data to facilitate enterprise wide reporting and analysis and delivering data to co-ordinate data marts.
• Used Data Manager to transfer data in to single database tables and where complex transformations where required to populate data warehouse fact and dimension tables.
• Delivered metadata to Framework Manager which allows target data warehouse and data repositories to be modeled for Cognos projects.
• Created couple of Dashboards in Cognos 8.4.1 with the help of the Cognos Go dashboard.
• Publishing data movement tasks to Cognos Connection where they can be run and scheduled.
• Designed and created various projects and models using Framework Manager.
• Worked extensively on creating Models and publishing packages on Cognos Connection for Reporting purpose.
• Created filters and calculations within the Framework Manager Model for improving performance of the Model.
• Created the reports template to match the organization's standard.
• Incorporated the State of Utah seal and the organization's logo in the reports template.
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
• Scheduled reports to run using Cognos Connection Schedule Management.
• Developed new reports in Report Studio upon requests from business users.
• Created, organized and formatted reports, Folders, Tabs and other contents on Cognos Connection portal.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards.
• Trained staff in all aspects of knowledge for Data Manager, Framework Manager, Report creation etc.
• Troubleshooting was done on issues, which arose while creating data manager Dimension and Fact builds, Job Streams and scheduling the builds on the Cognos Connection and also with Framework Manager and Reports.
• Provided day-to-day support for all COGNOS Report studio users.
• Assist in end user acceptance testing.
• Analyzed Data model , business requirements and Source System documents
• Developed the mappings for slowly changing dimensions for loading history data.
• Interacted with Business Users in designing the Reports to meet their requirements.
• Created List, Crosstab, Drill through, Master Detail Reports and Charts.
• Used Singleton Blocks in the Reports.
• Reports were built with multi prompts like Cascading, Date prompts and Value Prompts.
• Conditional Formatting features were applied on the Reports for conditionally rendering the data.
• Performed SQL analysis using Toad to validate the Cognos Reports with Oracle Database Tables.
• Performed SQL Tuning to optimize the delivery performance of the Reports Output.
• Worked on Data Audit and Data fixing.
• Scheduled the Reports through Cognos Connection as per the requirements of the Users.

Environment: Cognos 8.4 Framework Manager, Report Studio, Query Studio, Cognos Connection and Cognos Administration , Oracle 10g and Windows 2000 server.