SUMMARY:

• Over 8 years of total IT experience with Sound knowledge and experience in different phases of software development life cycle SDLC including analysis, design, development, testing and production.
• Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions using Cognos EP Series 7 Tools such as Cognos10.1.1, 8.4 CognosReportnet 1.1.MR3, CognosImpromptu 7.x/6.x, Cognos IWR 7.x/6.x, Power Prompts, and Analysis Tools such as Cognos Transformer Power Play 7.x/6.x, Cognos Visualizer 7.0, Access Manager, Server Installation Maintenance.
• Hands on Experience with Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Report building.
• Strong Knowledge with Transformer model design and Power Play cube building.
• Data Modeling Tools like Erwin using Oracle, DB2, UDB, Teradata, and MSSQL Server databases.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Involved in migrating Cognos EP Series 7 to CognosReportnet. Involved in a data migration process between different versions of Cognos.
• Worked on migration of Impromptu catalogs to Cognos 8.4 and upgraded Frame Work Packages from Report Net 1.1MR3to Cognos 8and reports from Report Net 1.1MR3 to Cognos8.4
• Extensively worked on customization of Cognos Connection Portal to resemble application look and feel.
• Extensively worked on building prompts and prompt pages using Java Scripts.
• Extensively worked on Data Warehouse and Business Intelligence projects with ETL teams
• Extensively worked with SQL Analyzer, SQL Plus, Oracle SQL Developer and TOAD.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Involved in creating and working with PL/SQL stored procedures.
• Extensive work on Data Extraction with Oracle, SQL Server MS-Access.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos Consultant

Responsibilities:

• Installation and Configuration of the Cognos Report net 1.1 MR3 environments and upgraded to Cognos 10.1 on Test and Production Environments.
• Worked on Cognos 10.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Report Net server.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Analysis of data necessary to resolve issues uncovered relating to source data
• Optimize the Cognos 10.1 reports performance.
• Defined, stored and maintained security information using Access manager.
• Implemented Folder level security on Cognos 8 Environment and to restrict access to the sensitive information Credit Card Details
• Implement Package Security.
• Troubleshoot and resolve functional issues.
• installing the Content Store
• Creating User Classes in Access Manager and adding users to those user classes
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Examined store procedures using PL/SQL, which were used to transform data
• Optimized SQL for faster extraction.
• Involved in Migrating metadata and reports from Cognos 8.4 to Cognos 10.1 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio and Report Studio
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Extensively worked in Scheduling and Deploying Staging to Production Reports.
• Worked on complex reports using Tabular Objects, Static Prompt conditions.
• Built Power Play Reports based on these cubes and published to Report Net Server.
• Administering the business users in the portal based on the requirements.
• Helped the team members in resolving any technical issues with Cognos Report net and Power Play objects.
• Co-coordinating with Cognos Support team in resolving the technical issues of the Cognos suite of products

Environment: Cognos 10.1, Cognos 8.4, Cognos ReportNet1.1 MR3 Framework Manager, Query Studio, Report Studio , Oracle 11g, Toad, Tivoli LDAP, Migration Utilities, SQL Loader, Access Manager

Confidential

Senior Cognos Developer

Description:

Manufacturing Resources Planning includes modules such as Product Development, Sales Purchases module efficiently monitors purchase requisition inquiries, quotations, purchase order and tracking pending order supplies and follow-ups. It provides facility for purchase indent, authorization of indent, order preparation, order amendment and various reports. This module provides the information about the status of sales order and allies' information.

Responsibilities:

• Installed, configured and migrated the existing Cognos 10.1.1 BI POC/production installation consisting of Cognos Report Server, Framework Manager, Data Manager, Cognos GO Office, Transformer and Power Play Client.
• Installed database Clients for SQL Server 2005 and Oracle, established and tested database and content store connectivity on the Cognos Production environment.
• Involved in trouble shooting of ODBC connection to install 32 bit ODBC, as 32 bit Cognos was installed on 64 bit windows server.
• Created reports using MDX
• Created Executive level Dashboards in Cognos showing various high level key performance indicators.
• Created complex reports using tabular sets and master-detail queries.
• Carried out bursting of reports to distribute reports to different end users.
• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.
• Created SOP for migration of Framework Manager Packages, reports, Data Manager Packages, fact builds, dimension builds and the job streams.
• Edited System.xml as per client requirements to display or hide options in Cognos Connection.
• Created Fact builds, Dimension builds and Job Streams to extract transform and load application data generated by Data Stage in Oracle into SQL Server 2005 data warehouse to support varied reporting needs.
• Created a portal page in Cognos to depict a web page on company portal having links to Cognos Power play reports and Cognos 8 reports.
• Created reports such as Job Size, Port Warehouse Inventory Management, Gross Margin Reports against the finalized Freight and non finalized freight factors present in the cube.
• Maintained the scheduled data manager jobs to generate cubes to support legacy Power play reports and the Dimension and Fact tables in SQL Server 2005 Data warehouse.
• Monitored and used the Data Manager logs on a daily basis to debug the Cube build failures and the data warehouse inconsistencies.
• Unit tested the update reports for performance and consistency against different amounts of test data.

Environment: Cognos 10.1.1 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos GO Office, Cognos Data Manager, SQL Server 2005, Oracle, IIS webserver, Windows Server 2008 R2 and Toad, SQL Dbx

Confidential

Responsibilities:

• Installation and Configuration of the Cognos 8 and Cognos Report net 1.1 MR3 environment and upgraded reports and packages to Cognos 8.3 on Development Environments.
• Worked on Cognos 8.4 Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos Connection Portal.
• Implemented Star Schema Grouping
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Analysis of data necessary to resolve issues uncovered relating to source data
• Optimize the Cognos 8.4 reports and SQL for faster performance.
• Defined, stored and maintained security information using Access manager.
• Implemented Folder level security on Cognos 8 Environment and to restrict access to the sensitive information.
• Created complex reports using tabular sets and master-detail queries.
• Carried out bursting of reports to distribute reports to different end users.
• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Tuned the performance of the reports by using functions created at the database level and filtering out unwanted data at the framework manager level and also recommended and utilized the aggregate tables in the database to achieve user acceptable level of run-time for the reports.
• Examined store procedures using PL/SQL, which were used to transform data
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8.3 using utilities.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs
• Worked on complex reports using Tabular Objects, Static Prompt conditions.
• Created prompts using Java scripts in Cognos Report net and Cognos 8 environments.
• Extensively worked in Scheduling and Deploying Staging to Production Reports.
• Worked as a Quick Turn team member to resolve Production issues.
• Involved in understanding existing Business Model and Customer Requirements by participating in the SRS review meetings and created Technical Design Documents and created Unit Test Case documents.
• Created reference documentation for some of the important tasks to be performed in Cognos environment.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Administering the business users in the portal based on the requirements.
• Helped the team members in resolving any technical issues with Cognos 8, Cognos Report net and Power Play objects.
• Co-coordinating with Cognos Support team in resolving the technical issues of the Cognos suite of products.

Environment: Cognos8.3, ReportNet1.1 MR3 Framework Manager, Cognos Connection, Query Studio, Analysis Studio, Report Studio , Oracle 10g, Toad, Tivoli LDAP, Migration Utilities Impcat2xml, Migratetoc8, Deploytoc8 , SQL Loader, Access Manager

Confidential

Sr. Cognos Developer

Responsibilities:

• Worked closely with users requirement analyst in gathering and documenting the business requirements.
• Participated in review, sign-off and communication of all changes or modifications to specification documents.
• Worked with business units to create centralized reporting capability for users to perform Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, and Data Sources and publish packages to the Report Net Server.
• Created associated data source/cube in Cognos 8 portal and configured connection to the Power Cube.
• Published packages to the portal to be accessed by Analysis Studio.
• Created Security at Object Level, Data Level and Package Level
• Created prompts, conditions, filters, bookmarks and calculations in Report Studio
• Developed several reports by using Lists, Crosstabs and Charts and also created a burst report to run the report automatically and send out the output to the users by email.
• Helped users in creating ad hoc reports using Query Studio.
• Deployed the modified reports from development to test and from test to Production systems.
• Created Business model, calculated measures, special categories, multiple dimensional cubes using Transformer.
• Worked and resolved performance tuning of Power Play models and Cognos8/Reported packages and configuration settings.

Environment: Cognos 8.1 Report Studio, Analysis Studio, Query Studio, Cognos Connection , Power Play Transformer 7.x, Power Play Enterprise Server7.x, Cognos Impromptu Administrator 7.x, Access Manager, Report Net 1.1, Framework Manager, IWR, Upfront, SQL Server 2000, DB2, DTS.

Confidential

Cognos Developer

Description:

Manufacturing Resources Planning includes modules such as Purchases, Sales and Stores for Reddy Labs Purchases module efficiently monitors purchase requisition inquiries, quotations, purchase order and tracking pending order supplies and follow-ups. It provides facility for purchase indent, authorization of indent, order preparation, order amendment and various reports. This module provides the information about the status of sales order and allies information. Stores module takes care of effectively Inventory management by regulating process of receipt and issue of items at stores.

Responsibilities:

• Administered security to Report net, Cognos 8 environments using Access manager.
• Upgraded Cognos content to the latest version of Report net.
• Created standard list, cross tab, charts and drill through reports in report studio.
• Built reports using conditional blocks to implement certain complex business logic and also implemented conditional styles to highlight business sensitive data.
• Provided data security, object security and package access in Framework Manager. And also secured the folders by setting up access permissions in Cognos Connection.
• Scheduled reports to run daily, weekly and monthly using Schedule Manager.
• Carried out bursting of reports to distribute reports to various end users by email.
• Deployed packages from development environment to production environment.
• Created most commonly used calculations and filters in framework manager and organized into different folders in business view.
• Created ad-hoc reports in Query Studio and Standard Reports in Report Studio.
• Created complex reports using Tabular sets and master-detail queries.
• Tuned the performance of the reports by creating functions, procedures and packages at the database level and filtering out unwanted data at the framework manager level. And also recommended and utilized the aggregate tables in the database to achieve user acceptance level of run time for the reports
• Prepared documentation for the setup and configuration of the Cognos application.
• Prepared training documentation for the developers to accomplish complex tasks in Report net.
• Installed and configured Development and QA Report net servers.

Environment: Cognos 8, Cognos Report net CRN 1.1, Sun One Directory Server, Access Manager, SQL Server, Windows 2000