Manager Data

Abhinandan

Phone: 732-***-****

Email: ab9x3t@r.postjobfree.com

PROFESSIONAL SUMMARY:

• About 8 years of IT experience in Data warehousing and Business intelligence with emphasis on

Business Requirements Analysis, Application Design, Development, testing, implementation and

maintenance of Data Warehouse and Data Mart systems in Financial, Banking, Manufacturing, Retail,

Insurance, and Pharmaceutical industries.

• Experience in Cognos 10.1 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis

Studio, Query Studio, Business Insights and Business Insights Advanced)

• Experience on Cognos Tools – Cognos 8.4/8.3/8.2Suite (Report Studio, Analysis Studio, Query Studio,

Metric Studio and Cognos Connection), Cognos ReportNet 1.1 MR3, Cognos EP Series 7.3(Impromptu,

IWR, PowerPlay Transformer and PowerPlay Windows/Web, upfront)

• Developed Complex Framework Manger Models & involved in Debugging FM Models

• Experience in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8.x

and Cognos 10.1

• Involved in designing and building the PowerPlay cubes using Transformer.

• Handling complete range of BI capabilities: reporting, analysis, score carding, dashboards and

business event management.

• Expertise in OLTP/OLAP/OOAD System Study, Analysis and ER modeling, developing Database

Schemas like StarSchema and Snowflake Schema used in relational, dimensional and

multidimensional modeling.

• Provided best practices for day to day operations, performance analysis, tuning and capacity

planning.

• Involved in Designing Data Models Relational, Multi-Dimensional Models in order to building Data

Marts and Consolidated reporting Environments.

• Implemented FM Level Security as Row Level & Data Level Security.

• Architect the Cognos BI environment to support high concurrency. .

• Experience in understanding existing business processes, data analysis requirements, business systems

analysis and design, converting requirements specifications into functional specifications

• Experience in implementation of the Cognos Series 8 Business Intelligence Software and

migration from Cognos Series 7 where applicable.

• Experience with Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.

• Proven experience at building, motivatingandleading professional teams, managing projects and

supporting client relationships.

TECHNICAL SKILLS:

Reporting Tools: Cognos 10.1.1(Framework manager, Report Studio, Analysis Studio, Cognos

Connection, Event Studio, Query Studio, Business Insight, BI Advanced)

Cognos 8.2/8.3/8.4 Suite (Framework manager, Report Studio, Analysis Studio,

Cognos Connection, Event Studio, Query Studio)

Cognos EP Series 7.3, Cognos Impromptu 7.3, PowerPlay 7.3, IWR, Upfront.

Databases: Oracle 11g/8i/9i, MS SQL Server 2008, DB2 UDB, Teradata V2R6

Data Modeling: Erwin, Microsoft Visio.

Oracle Tools: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, WinSql.

Languages: SQL, PL/SQL Programming, Visual Basic.

Operating Systems: Windows, Unix/Linux, Sun-Solaris, AIX

PROFESSIONAL EXPERIENCE:

Sutter Health, Sacramento, CA Jul 11 – Till date

Sr. Cognos Developer

Sutter Health is the most recognized and respected group of health insurance provider in the world. It is a

trade association for the independent locally operated Sutter health Plans, Insurance focus on offering the

best mix of insurance coverage and pricing, and fulfilling the promise of our products when a loss occurs to

most of their consumers – auto, homeowners and small-business policies. Involved in creation and

maintenance of databases, migration and created reports.

Responsibilities:

• Involved in Requirement Analysis, Functional Design and Technical Design.

• Deployed Cognos portlets in Web Sphere Portal.

• Deployed Cognos application into WAS Application Server 6.0

• Involved in implementing Intermediate layer and Presentation Layer, defining appropriate

relationship between query subjects and Fact Table in Framework Manager.

• Created star schema grouping for better understanding of the model & facilitate multi-fact (cross-

fact) reporting.

• Developed Framework ManagerDMR models with time shift fact tables.

• Developedframework model to perform most of the calculations and give power to user to create

Ad-hoc reports with ease.

• Developed Standard Reports, Charts and Master Detail Reports using Report Studio.

• Created chart, crosstab weekly, daily reports using summary page and page breakup functionality.

• Created Active reports with different data decks and data cards.

• Created a custom prompt page by enabling system driven cascade options, dynamic dimension

selection and conditional display of prompts.

• Created Business Insight Dashboardsand Business Insight Advanced prototypes for the user to

understand the new Cognos 10.1 features and functionalities

• Created daily, weekly jobs in Cognos scheduler and published reports to sharepoint portal.

• Created BAR dashboard for the Marketing Intelligence to track the market share across different

stores.

• Created additional reports on an ad-hoc basis as requested by business users.

• Created SQL queries using Microsoft SQL Server Management Studio to verify accuracy of Cognos

reports.

• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using

Cognos connection.

• Implemented user group custom view security in transformer cubes

• Involved in Deploying reports, cubes and packages from Development to Production environment.

• Created KPI metric dashboard for the PMO’s to track the different testing phases within the project

release.

• Provided data profiling reports and troubleshoot anomalies discovered in data sets.

Environment:Cognos 10.1.1 (Framework Manager, Query Studio, Report Studio, Metric studio, Event

Studio, BI, BIA), Cognos 8.4, Oracle 11g (SQL, PL/SQL), Sql Server 2008, Windows XP, Unix,

Web Sphere.

Country Financial, Bloomington IL Sep 09- Jun 11

Sr. Cognos Developer

Country Financial is a group of US insurance and financial services companies. The

project Application consists of set of systems/applications that extracts information from

Abhinandan

Phone: 732-***-****

Email: ab9x3t@r.postjobfree.com

the various upstream systems like Wholesale, Retail, Equity, Traded Product Systems,

Securitization Data etc and then process the information for generating Credit Risk Report

by the downstream Regulatory Report applications.ETL process performed using

Informatica and the DB used are Oracle and Teradata. Reports are developed using

Cognos

Responsibilities:

• Integrated Cognos with WASportal.

• Worked with Business Analysts,client users and internal systems resources on Cognos installations,

upgrades, troubleshooting, and bug resolution

• Handled complete range of BI capabilities: reporting, analysis, score carding, dashboards and

business event management.

• Enhanced the Cognos technical design and development process.

• Providedtechnical support for Cognos 8.4/8.3 applications including report analysis, development,

maintenance, and report migration.

• Provide best practices for day to day operations, performance analysis, tuning and capacity

planning.

• Designed Functional Requirement Specifications for report development, modified relationships

between different database tables and building models using Framework Manager.

• Createdstar schema grouping for better understanding of the model & facilitate multi-fact (cross-

fact) reporting.

• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive

• Setting up cardinality (minimum, maximum & optional), Determents to avoid double counting,

support loop joins, optimize data source, and identify dimensions and facts..

• Decreased the Cube build times drastically and increased runtime performance.

• Designed multidimensional models using Transformer

• Maintained the packages and reports in development, test and production environment.

• Created Filters, Prompts, Calculations both at package level and report level.

• Created ad-hoc packages for the query users with pre-defined filter conditions, prompt customization

• Calculated fields, created manual dimensions and used special categories for creating cubes and

reports using Transformer models

• Implemented User group level custom view security in recruitment Analysis cube.

• Designed and implemented a robust security architecture which includes both row level security and

object security.

• Involved in Production support activities (Monthly cube refresh, validating the cube results with the

database results, analyzing the data by querying the database for data related issues).

Environment: Cognos 8.4/8.3/8.2 (Framework Manager, Query Studio, Report Studio, Analysis

Studio),Upgrade Manager 8.3, Cognos PowerPlay 7.3/8.3/8.4, Cognos Transformer

7.3/8.3/8.4,SQL server 2005, Oracle 10g,Windows XP, Unix

BBVA Compass Bank, Birmingham, AL Jun 08–Aug09

Sr. Cognos Consultant

Business Intelligence solution is to identify and retain the most profitable portion of its customer base, attract

new customers with similar profiles, and increase the overall effectiveness of its marketing programs and

overall profitability. The project’s main objective is to create a central database for data and to provide a set

of standard reports to give better analysis to the financial group. The Data warehouse project was developed

for reporting and high level business needs for their financial sector, using historical and online data.

Responsibilities:

• Installed & configured the Cognos 8.4 BISingle Server Environment, Administering the Servers,

Troubleshooting, Performance Tuningandimplementing security, managing users, user groups

and roles in the organization.

• Involved in Requirement gathering from Business Users and Developed Technical

Documentation for the Business and Team.

• Created customized ad-hoc packages in Framework Manager for Query Studio users.

• Developed Framework ManagerDMR modelsand PowerPlay Transformer cubesfor reporting by

Analysis Users.

• Created custom views in PowerPlayTransformer model to limit access to information in a cube to

members of a given user class.

• Customized Cognos Connection with appropriate reports and security measures

• 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 )

• Modifying the existing report based upon the change request by the user.

• Created a Metric Studio application by defining and creating scorecards, metric types,

qualifiersand metrics.

• Loaded data to staging area and Metric store using flat files, relational tables and transformer cube

source.

• Extensively worked with Stored Procedure Query Subjects in FM and Reports.

• Created diagrams and added reports to scorecard application.

• CreatedDash Board Reportsfrom cube using Report studio 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.

• Created batch script toupdate and publishcognos8.4 powerplay cubes daily.

• Analyzed the accessibility of the Product & Developed evaluationSheet 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.

• Used Java Script for passing prompt parameters to report studio reports.

• Developed PL/SQLStored Procedures, functions and views in database to improve the performance

of Cognos Report Studio reports.

• Upgraded Framework Manager packages, Transformer cubes and Report Studio reports from 8.3 to

8.4.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio,

Analysis Studio, Metric Studio), Cognos Series 7.4 (Impromptu, PowerPlay Transformer, PowerPlay

Windows XP),Oracle 9i/10g/ (SQL/PLSQL),Cognos Access Manger, Windows 2003 Server.

Marriott International, Bethesda, MD Dec 07- June08

Sr.Cognos Consultant

Sales Goal Reporting

Marriott International, Inc. is a leading lodging company. Its heritage can be traced to a root beer stand

opened in Washington, D.C., in 1927 by J. Willard and Alice S. Marriott. Today, Marriott International has

more than 2,900 lodging properties located in the United States and 67 other countries and territories. The

aim of this project is to develop consolidated reports to their business by using Cognos8 as a reporting tool.

Abhinandan

Phone: 732-***-****

Email: ab9x3t@r.postjobfree.com

Responsibilities:

• Involved in Requirement gathering from Business Users.

• Analyzing the specifications provided by the clients and Developing specification documents for

reports as per client requirements

• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports

• Design & development of multiple reports using various templates like list reports, cross-tab reports

and chart reports

• Interacting with the End users on a regular basis for resolving issues pertaining to the reports

• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.

• Designed and Developed the Framework Manager models and Published into server..

• Created ad-hoc packages for Query Studio users.

• Created OLAP cubes usingPowerPlay Transformer against various data sourceslike Oracle & Flat

Files.

• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal

• Developed Stored Procedures and Database Triggers in PL/SQL.

• Export and Import of Packages / Reports for Auto / Manual Deployment to UNIX Box (Dev, QA and

PROD).

• Co-facilitate client workshops and training, typically small to medium group of clients.

• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2.

• coordinating with Development Team tasks& Deliverables and working on high priority issues

• Testing reports using review checklists for Quality Assurance before delivering to the end users.

• Used Java script for dynamic sorting of columns in list, cross tab reports.

• Identifies, researches, and resolves ETL root cause of production issues or system problems.

• Performance tune ETL programs, Maintenance and enhancements of ETL code.

• Involved into move to Deployment to UAT and Production.

• Developed Dash Board reports in Report Studio using MDX Functions.

• Used Cognos Office Connection to publish the reports in Powerpoint and format them for business

presentation.

Environment: Cognos 8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio,

Analysis Studio, Cognos Office Connection), Oracle 9i, Neteeza, Cognos Access Manger, Windows 2003

Server, Unix Aix server.

Jul06–Dec 07

Sanofi Aventis, Bridgewater, NJ

Sr. Cognos Consultant

Systematic Performance Measurement:

The Contract Operations & Pricing department’s Contract Analytics team provides monthly, quarterly and ad-

hoc reporting and analysis of the company’s performance in the Managed Care Markets. The majority of this

analysis is developed by pulling data from various sources within the Systematic Performance Measurement

(SPM) application and then consolidating and formatting this data into an output format that can be easily

understood.

Responsibilities:

• Migrated Cubes, Reports from Version 7 to C8 using the migration utilities.

• Upgraded the environment from Cognos 8.1 to Cognos 8.2

• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a

single report to meet the business needs.

• Used Dimensional functions to build crosstab reports from cube datasource.

• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to

Cognos8 Server.

• Built Power Play Reports in Report Studio by replicating the powerplay functionality in Report Studio

using dynamic Measure selection, Dynamic Sorting, ranking.

• Created Dashboard Reports by translating data into visually rich presentations using different types

of charts, and other graphical elements to show multiple results together.

• Customize the Cognos connection portal using existing portlets and customized tabs.

• Worked on complex reports using Static Prompt and mdx functions and union conditions.

• Used Cognos SDKfor passing prompt parameters to report studio reports.

• Customized reports using Cognos SDK andintegrated with Portal.

• Used Java script for dynamic sorting of columns in list, cross tab reports.

• Used Cognos Office Connection to publish the reports in Powerpoint and format them for business

presentation.

Environment: Cognos 8.2 (Report Studio, Analysis Studio), Cognos Series 7.3/7.4 (Impromptu, Transformer),

Cognos Office Connection 8.1.0, Oracle 9i, Toad, Tivoli LDAP.

Aug05 -Jun06

GM LFO, Chennai, India

Cognos Developer

General Motors Lead Fulfillment Operations:

Lead Management is the process by which lead and prospect information is captured, standardized,

qualified, and output/transmitted to third party vendors responsible for fulfilling consumer information

requests, forwarding qualified leads to dealers (as appropriate), and performing other marketing activities

Responsibilities:

• Worked on Cognos8.1 Framework manager to import metadata from multiple data sources and to

create subject oriented business models, create and publish packages to Cognos 8 server.

• Creating relationships between query subjects to better represent the logical structure of the

business and the user requirements.

• Creation of procedures, views, tables and functions according to business requirements in Oracle.

• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.

• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using

Query 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 ReportNet Server.

• Successfully implemented the set based design and join forcing conditions in universe

• Created complex reports using calculation subquries and data synchronization techniques

• Helped the remaining team to resolve Computation and MultiValue errors in the reports

• Identifies, researches, and resolves ETL root cause of production issues or system problems.

• Performance tune ETL programs, Maintenance and enhancements of ETL code.

• Assisted client in training activities to the Business users

Abhinandan

Phone: 732-***-****

Email: ab9x3t@r.postjobfree.com

• Assisted client in creating business documentation based on the Cognos Framework Manager

Package.

Environment: Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, C.C, Query Studio, Report

Studio), BusinessObjectsXI R2/R1, Oracle 8i, Toad, Tivoli LDAP, Informatica 7.1.3.

Contact this candidate