Summary:

• Over 7 years of IT experience in design, analysis, development, documentation, coding and implementation on client/server environment using Cognos 10 Framework Manager, Query Studio, Report studio, Analysis studio, Event Studio, Business Insight, Business Insight Advanced , 8.x OLAP and reporting .
• Experience in the installation and administration of Cognos 10.2.1in a distributed environment and configuring third party security against Active directory to create users and user Groups.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos.
• Created complex Dash Boards with progressive charts/waterfall charts, bullet charts, area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
• Experienced in Kimball Methodology Dimensional Modeling, SCD Slowly Changing Dimension Types- 1, 2, 3 and 6, Data Marts and data warehouses.
• Hands on experience on ETL tools like Informatica.
• Expert in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008/2012.
• Experience in developing Custom Reports and using SQL Server Reporting Services SSRS and deploying them in Report Builder, Report Manager and Power View with SharePoint Integrated Mode.
• Experienced in analyzing Business and Functional requirements, studying the Source systems, thoroughly designing the Target by going through the Functional Specification Document and one- to- one interaction.
• Clear knowledge on OLTP and OLAP Systems, developing Database schema Star and Snow flake schema Dimensions and Facts , E-R Modeling- Logical and Physical Modeling Concepts.
• Experience in Database design using Normalization and E/R Diagrams.
• Administered Cognos Server and customized pages in Cognos Report studio.
• Worked extensively with dashboard report building using Report Studio and Analysis studio.
• Expert in developing Multi-dimensional Models using Cognos Transformer.
• Automated Transformer Cube generation both using Tidal Scheduler and scripting.
• Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers and using the advanced features to optimize performance Bulk binds, collections, Global Temporary Tables
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Loader, PL/SQL Developer, SQL Developer, External tables and UTL FILE.
• Strong experience in writing complex Stored Procedures, Triggers, Cursor, Linked Server Query, UDF, and other SQL Server objects using T-SQL.
• Extensive database experience using Oracle 10g/9i/8i, MS SQL Server 2005, SQL, PL/SQL.
• Experience with Software Development Life Cycle SDLC process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
• Experience working in waterfall model and agile methodologies
• Strong interpersonal skills, ability to interact with people at all levels. Responsible for interacting with business partners to identify information needs and business requirements for reports.

Technical Proficiency:

Projects Summary:

Confidential

Cognos Developer

Responsibilities:

• Worked as a business analyst in interacting with users to analyze requirements and generated POC's.
• Involved in creating various Projects Models in Framework Manager.
• Developed multi dimensional model using Cognos Framework Manager.
• Trained the end users effectively to use Business Insight, Business Insight Advanced and new features in Cognos 10.
• Created Dashboard reports from the OLAP source
• Developed Dashboard reports using Business insight in Cognos 10
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Involved in scheduled reports on a daily basis that will contain the revenue amount information. Created and improved dash-board report, drill down, drill though reports and cross tabs report using report builder.
• Integrated the reporting services with MS SharePoint while deploying the reports and implemented the report subscriptions to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Developed Cubes using Transformer.
• Creating the Cognos OLAP cube using Power Play transformer.
• Created Custom views in Cubes to implement security at territory level for all the customers.
• Created time based partition cubes to overcome the size limit in cubes.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
• Created Offline Interactive Dashboards using the Active Reports functionality in Cognos 10.
• Created user groups and assigned security using Access Manager.
• Improved database performance including CTE, View, Stored Procedures, Index, etc. and optimize the T-SQL statements using SQL profiler and Execution Plan.
• Proven experience in using Informatica in a real-time mode.
• Involved in defining Relationships and Cardinality between query subjects.
• Created Multi-Dimensional Models DMR and published the packages using Framework Manager and then generated reports based on these packages.
• Developed various chart reports like progressive charts/waterfall charts, bullet charts, bar charts, column charts, area and line charts, combination charts, etc.
• Extensively used Transformer to move relative Data Mart's data into Power-Cubes and cube groups by designing Dimensional Maps and Transformer Model to perform On-Line analytical processing OLAP .
• The reports that are built on these Cubes replaced the existing reports that run several hours when run on relational models.
• The cubes created are scheduled both daily and monthly using Tidal Scheduler.
• Installed configured Cognos in Distributed Environment.

Environment: Cognos 10 Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Cognos Connection, Framework Manager , MS SQL Server 2012, SQL Server Reporting Services SSRS , SharePoint Server MOSS2007, Hummingbird BI, Informatica 8.6.1, Power Play Transformer v8.4, Oracle 10g, DB2, Windows, PL/SQL, TOAD.

Confidential

Cognos Developer.

Responsibilities:

• Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Upgrade from Cognos 8.4 to Cognos 10.1 in multi-tier system.
• Manage the Cognos Production and Development Servers.
• Designed and Developed the Framework Manager models, imported Tables Views from Oracle, creating short cuts and aliases and Published into server.
• Developed multi dimensional model using Cognos Framework Manager.
• Involved in the Software Development Life Cycle SDLC processes including Analysis, Design, Programming, Testing and Documentation.
• Developed SQL scripts/queries such as Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL statements and validated completeness, integrity and accuracy of data and modified views and stored procedures according to technical specifications and business requirement.
• Built models, packages and published them using Framework Manager.
• Involved in defining the data, object and package level security in FM.
• Created Offline Interactive Dashboards using the Active Reports functionality in Cognos 10.
• Developed Dashboard reports using Business insight in Cognos 10.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Creating the Cognos OLAP cube using Power Play transformer.
• Developed Cubes using Transformer.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
• Trained the end users effectively to use Business Insight, Business Insight Advanced and new features in Cognos 10.
• Designed reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports. Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Involved in Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational and multidimensional modeling.
• Created Metadata Modeling in Framework Manager by using multiple databases, high volume databases in Cognos 8 BI Modeling.
• Performed Cognos Administration tasks such as Scheduling and Deployed Data to different environments.
• Established Security at the package level, data level, row level and object level using Framework Manager and maintained report and folder level security in the Cognos Connection.
• Created Complex Reports using drill through reports, multiple prompts and filters and dynamic sorting columns.
• Developed reports in Reports Studio and customized them using JavaScript.
• Performed Unit /QA testing and bug fixing.
• As Cognos Administrator:
• Deployed Reports from One Dev to UAT and UAT to Production.
• Data Source creation and modification
• Monitors performance on the application
• Scheduling Reports according to the client Request
• Trouble Shooting the Problems and bringing back the server's Up
• Analyzing the impact and preparing the document.

Environment: Cognos 10 Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Cognos Connection, Framework Manager , Qlik View 10, Informatica 8.6.1, MS SQL Server 2008/R2/2005, SQL Server Reporting Services SSRS , T-SQL, Visual Studio 2005/2008, Power Play Transformer v8.4, Oracle 10g, DB2, PeopleSoft, Windows, PL/SQL, TOAD.

Confidential

Cognos Developer

Responsibilities:

• Interacting with the key Business Associates for understanding the as-is process flow and new business requirements or enhancement activities
• Documenting the Business Requirements for report development, coding and passing it to Client Review
• Analysis of the Business/Functionality as provided in the requirements of the Business Stake holders
• Carrying out Feasibility study of the requirements within the scope of the project and creation of Feasibility Study documents
• Developed T-SQL DDL-Data Definition Language, DML-Data Manipulation Language statements using dynamically generated SQL.
• Allocating tasks and delegating responsibilities to the team members for the successful execution of the project
• Generated daily, weekly and monthly reports using SSRS 2005/2008.
• Daily reviews and status monitoring of the project
• Conduct Defect Prevention meetings every month and address the issues related to defects in the ongoing releases and device action items
• Conduct Team Meetings and address the issues faced by the Team Members and come up with solutions for the same
• Coordinating with onsite/offshore team for the day-to-day activities including status reports
• Creation of project estimates and detailed task work flows.

Environment: Cognos 8 Suite v8.3 , MS SQL Server, Oracle 10g, Windows XP. Windows Server 2003, MS SQL Server 2008/R2 Enterprise Edition, MS SSRS 2005/2008.

Confidential

Cognos Developer

Responsibilities:

• Gathered Business Requirements by conducting User Interviews and documented their query, business analysis reporting needs. Understood data and business logic with reports.
• Used Framework Manager to create and manage business related metadata for the report authoring in Report Net.
• Worked on models, namespaces, folders, query subjects, and packages from multiple data sources in Report Net Framework Manager.
• Created multi-lingual packages for various geographic locations
• Developed Cognos package and published on Cognos Connection using the Framework Manager.
• Created several different types of Ad-hoc simple list, grouped list, section heading, crosstab, and nested crosstab reports and represented data graphically by charts using Query Studio.
• Created several different types of professional reports mailing labels, web page style, cascading, drill through, production, business, ranking, and etc. with complex formatting using Report Studio.
• Used Cognos Report Net Tool to create, modify, and organize Ad-hoc reports using the Report Net Query Studio tool.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, and sub reports using SSRS 2008 and migrated the reports from SSRS 2005 to SSRS 2008.
• Involved in the upgrade and Migration of Cognos 8.2 to 8.4 from Sybase to Oracle

• Created a new Framework manager model with data source as Oracle.

• Created database connectivity, name spaces, query subjects, packages etc to reflect the Sybase model
• Changed Sybase syntax SQL reports to Oracle syntax SQL reports.
• Published the packages to Cognos connection
• Compare report outputs from Cognos 8.4 Sybase to Cognos 8.4 Oracle .
• Used Cognos Connection as Web Portal for managing reports.
• Created complex reports using Report Studio including prompt pages, conditional blocks, stored procedures, and materialized views.
• Supported report authors in making complex reports using cascading, range prompts, and calculations in Report Studio.
• Scheduled Reports using Cognos Connection.
• Converted legacy reports and developed web-based reporting application using Cognos Impromptu Web Reports IWR .
• Distributed Reports through bursting, e-mail, and uploading to folders.
• Developed power Play cubes which involved model definition in transformer, used multiple queries, calculated measures, customized cube content and optimized cube creation time.
• Created Multi-Dimensional reports using Power Play for Windows.
• Developed Analysis Studio Reports as per the user requirements and also created Report studio reports using cubes.
• Involved in Cognos Administration for giving access and DSN changes. Package import and export.
• Decreased the Cube build times drastically and increased runtime performance.
• Created value prompts and text prompts to filter the data using Cognos Report Studio.
• Applied user authentications to various user groups.
• Used Cognos Transformer to build multi-dimensional Cubes and used it in Cognos Power Play to build graphs and charts of Customer data. Created Models based on the Dimensions, Levels and Measures required for the analysis.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Wrote stored procedures, functions, packages and triggers for modules like -products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.

Environment: Cognos 8.2, 8.4 upgrade Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manger , Informatica, Power Play 7.3, MS SQL Server 2005/2008 Enterprise Edition, MS SSRS, Oracle 9i, TOAD, Windows, UNIX.