Shailin Shah

abh2q2@r.postjobfree.com

201-***-****

SUMMARY

Software professional more than 4 years experience in various parts of the

SDLC experience as a Cognos Developer developing effective Business

Intelligence (BI) & Data warehousing solutions to facilitate business

decisions. Extensive experience in Architecting, Data modeling (reporting

and OLAP Cubes) with Cognos BI Tools including Cognos EP Series

8.x/7.x,Cognos,Cognos 8.x/Report Net 1.1 (Report Studio & Query Studio,

Cognos Framework manager). Self motivated, creative, work with minimal

supervision, debugging and crisis management. Excellent interpersonal and

oral and verbal communication skills.

. Experience installing Cognos 8 BI and architecting and delivering data

warehousing using Cognos 8 BI suite.

. Multidimensional and Relational modeling in Framework manager.

. Experience migrating legacy systems and other low end BI tools to Cognos

8.

. Design of complex reports in Report Studio and Design of Adhoc reports in

Query Studio.

. Created, modeled and published packages in Framework Manager from

multiple databases for use with Reportnet, Report Studio and Query Studio

and Analysis Studios.

. Monitor jobs with the Cognos Administrators, debug and enforce scheduled

report.

. Extensive experience with multidimensional models (OLAP) using Framework

Manager and Power Play Transformer and Cognos Analyst.

. Experience in understanding the business requirements and designing

Cognos applications.

. Planned and constructed OLAP Power Play Transformer OLAP/CUBE 7.3/6.0 for

Data modeling of the corporate Data for building multi dimensional cubes.

. Worked extensively with the Metadata Modeling utilizing Framework

Manager.

. Expertise in design and development of highly complex query reports

including Dash board reports.

. Expertise with Framework Manager, Cognos BI 8.4/8.3/8.2/8.1/8.0/CRN,

Cognos Connection, Report Studio, and Query Studio, Metric Studio and

Analysis Studio.

. Implemented Security at different levels in Framework Manager and Cognos

Connection to restrict access.

. Supporting cubes on weekly basis with verifying the sales with SAP Globe.

. Suggest ETL changes to enhance data integrity and data warehouse

reporting.

. Experience in metadata modeling including star-schema and dimensional

modeling.

. Versed with other BI tools like Business Objects, SAP BW and Hyperion

Essbase.

. Expertise in OLTP/OLAP system study, analysis and developing Database

schemas like Star Schema and Snowflake Schema.

. Recommend Cognos Enhancements, up gradation and chart the path forward.

. Extensively interacted with business users in understanding business

application, business data flow and data relations.

. Worked with Different Databases like Teradata 7.1, Oracle 8.0/8i,

9i,10g,11g,,MS-Access, MS-SQL, and PL/SQL 8.0

. Troubleshooting Cognos environments UAT.

. Testing, debugging of reports, Defect identification in Cognos and back

end databases, resolution.

TECHNICAL SKILLS

OLAP Tools Cognos Impromptu 7.0/6.2/6.0, Power Play Transformer, Power

Play for windows, Cognos BI 8.4/8.3/8.2/8.1/8.0 (Framework

Manager, Report Studio and Query Studio),TM1 9.5

Database Teradata 7.1, Oracle 7/8i/9i/10g,SQL Server 7.0/2000/2005,

DB2

Operating Systems Windows NT4/2000/XP, Solaris 2.6

Programming &ETL SQL, PL/SQL, TOAD Informatica 6.0/7.0

PROFESSIONAL EXPERIENCE

Deutsche Bank, NY

Cognos Developer

April 2009 - Oct 2010

Deutsche Bank is a leading global investment bank with a strong and

profitable private client's franchise. Its businesses are mutually

reinforcing. A leader in Germany and Europe, the bank is powerful and

growing in North America, Asia and key emerging markets. Currently working

with Cognos 8 BI on the Corporate and Investment Bank (CIB) group. CIB is

subdivided into two Corporate Divisions: Corporate Banking & Securities and

Global Transaction Banking. Corporate Banking & Securities covers Deutsche

Bank's origination, sales and trading of capital market products, corporate

advisory and corporate financing businesses, asset finance and leasing, and

commercial real estate. Global Transaction Banking covers Deutsche Bank's

trade finance, cash management and trust & securities services businesses

and serves both financial institutions and corporate clients.

Responsibilities:

Reporting

. Requirements gathering and specification writing after interfacing

with Business Users, Line of Business and Other Stake Holders.

. Interacted and interfaced with high level management to conceive and

deliver BI solutions, dashboard reports and score card structures.

. Multidimensional and Relational modeling in Framework manager.

. Designed and Developed List & Cross Tab reports, Charts, Drill through

Reports, Master Detail Reports using Report Studio. Worked on Query

Studio.

. Developed complex Dashboard reports.

. Tuned and improved the performance of the reports by optimizing SQL

generated, suggesting changes to backend schemas.

. Lead the team of Cognos administrators and developers and collaborated

with ETL, database teams to work on the development, sanitization and

optimization of data streams.

. Supporting cubes on weekly basis with verifying the sales with SAP BW

Globe.

. Resolved conflicts and provided recommendation in data modeling,

permissions issued to Cognos and ETL teams by setting up meetings

between the teams.

. Worked extensively with the Metadata Modeling utilizing Framework

Manager.

. Experienced in implementing various prompts such as cascading,

conditional, date, value based on the user's needs.

. Imported metadata from various sources such as Relational Databases,

Cognos 8.4 models.

. Create Master-Detail Relationships for reporting from multiple data

sources.

. Created Business views, namespaces, model query subjects in Framework

Manager Model for easier report development and to enhance multi user

environment.

. Testing, debugging of reports, Defect identification in Cognos and

back end databases, resolution

. Deployment of Framework Manager Packages and reports from Development

to UAT and to Production.

. Cognos Multidimensional Cube development using Cognos Power play

transformer.

. Report generation on Cognos Power play cubes.

. Worked extensively in OLTP/OLAP system study, analysis and developing

Database schemas like Star Schema and Snowflake Schema.

. Apply OLAP functionalities such as drill-down/drill-up in Analysis

Studio and Report Studio.

. Worked extensively with the ongoing support for data loading,

validation with SAP BW Tool.

. Oversee transition from Cognos 8.2 to 8.4 and Experience installing

Cognos 8 BI.

. Worked with ETL tool Informatica to change mappings and enhance data

warehouse reporting.

. Technical Design of Reports, Report bursting and Report Distribution.

. Developed complex reports, Scorecards and Job sets.

. Developed test plans, scripts and test cases for Unit, Integration,

Regression, UAT.

. Testing, debugging of reports, Defect identification in Cognos and

back end databases, resolution.

Environment: Access Manager 8.0/7.3, Cognos 8.4/8.3/8.1 (Framework Manager,

Report Studio, Query Studio, Metric Studio, Event Studio, Cognos

Connection, Power play Transformer),TM1 9.5,SAP BW/BI, MS Excel 2003,

Teradata 7.1/12.0, SQL Server 2005, Informatica 7.0, Windows XP.

Deluxe Corporation, Minneapolis, MN

Cognos Developer

Feb 2008- March 2009

Deluxe Corporation is the leading provider of personalized printed products

and services to small businesses, financial institutions, and consumers

primarily in the United States and Canada. The company operates through

three segments: Small Business Services, Financial Services, and Direct

Checks. The project was aimed at creating Cognos cubes to Segment the 9000

Financial Institutions into 15 unique segments. Cubes were also developed

to track sales, revenues and costs of 25 different new projects (financial

products). The cubes were designed in a way to facilitate unique reporting

and analysis of the data housed in the cubes.

Responsibilities:

Report Studio

. Interfaced with business users and line of business to gather

requirements and translated into specifications.

. Lead the project team giving direction and inputs to be used by

Project Owner, Cognos Developers, ETL, database teams and Cognos

administrators.

. Developed List & Cross Tab reports, Charts, Drill through Reports,

Master Detail Reports using Report Studio. Worked on Query Studio.

. Developed Dashboard reports.

. Created Prompts, and Cascading Prompts. Worked on multiple Report

pages and multiple Prompt pages.

. Framework Manager modeling with MS SQL Analysis Server Cube.

. Created reports having Filters, multiple Prompts (Select & Search

prompt, value prompt, tree prompt) and provided option of bursting of

reports.

. Worked on ETL to change existing mappings to enhance the data

warehouse and quality of data.

. Built Power play cubes using Cognos transformer.

. Developed Prompt pages and Conditional Variables.

. Experience in metadata modeling including star-schema and dimensional

modeling.

. Created New Jobs using Cognos Connection.

. Worked on Cognos Connection. Scheduled the reports.

. Merged different block objects to create desired complex report

structures.

. Documentation of all phases of development of Business Intelligence

solution.

. Developed test plans and test cases for testing new reports.

Environment: Cognos Planning 8.0/7.3 Analyst, Contributor 8.0/7.3, Access

Manager 7.3, Cognos 8.0 (Framework Manager, Report Studio, Query Studio,

Cognos Connection), TM1, SAP BW/BI, MS Excel 2003, SAP, Lotus Notes 7.0,

Oracle 9i, Informatica 6.0, Windows XP.

Lanco Group, India

Cognos Consultant

June 05 - July 06

Resource Management System is a web application for Lanco Group. This

project is used to automate the Lanco Companies day-to-day activities and

transactions. It is an Intranet based enterprise application, which

automates the process of resource management and provides better services

like stock management, and accounting. It links their activities like

office maintenance and inventory control and provides access to all of

their branches.

Responsibilities:

Reporting

. Involved in gathering Business Requirements for New models.

. Interacted with Development and Management Teams.

. Provided Technical Assistance to Developers.

. Built models using Framework Manager.

. Involved in Testing and Exploring New Tools ReportStudio and

QueryStudio.

. Developed Standard Reports, Charts, Drill Through Reports, Master

Detail Reports, Bursting Reports Using ReportStudio and QueryStudio.

. Developed Dashboard reports and Scorecard reports.

. Optimized queries.

. Created Query Prompts, calculations, Conditions & Filters.

. Developed Prompt pages and Conditional Variables.

. Created New Jobs using Cognos Connection.

. Scheduled and Distributed Reports through Schedule Management in

Cognos Connection.

. Worked with ETL teams for data quality control and cleansing.

. Tested and improved Report Performance.

. Trained Users on QueryStudio for Ad-Hoc Reporting.

. Documentation for User training.

PowerPlay

. Designed models by mapping business needs using PowerPlay Transformer

and created multi dimensional cubes, cube groups, Power Play reports.

. Decreased the Cube build times drastically and increased runtime

performance.

. Deployed Cubes and Reports on Power Play Enterprise Server.

Environment: Cognos 8.0 (Framework Manager, Report Studio, Query Studio,

Cognos Connection), Cognos 7.3 (Power Play, Transformer, Power Play

Enterprise Server), Oracle 9i, MS SQL Server 2000, Windows 2000.

Tata Infotech, Goa India

Cognos Consultant

Aug 04 - May 05

Tata InfoTech is a leading software service provider in India. The project

dealt with "Integrated Information Warehouse" which provides flexible

reporting and analysis environment for business users to identify

opportunities in the banking market space.

Responsibilities:

. Worked with Business Units to define Business strategy and create a

centralized reporting capability for users to perform analytical, and

ad-hoc reporting for business applications and provide accurate

information available to Decision Makers.

. Developed reports for Call Center managers and workload scheduling

team.

. Used Cognos Report Net as the web reporting solution of choice by

conducting product demonstrations and improve business performance at

all levels of their enterprise.

. Used Cognos Connection for organizing, security, scheduling and

distributing reports.

. Built models and published packages in Framework Manager to the Report

Net server.

. Developed filters, calculations, prompts, conditions, and created

various reports, using Cognos Report Studio.

. Responsible for the delivery of solution-oriented complex reports

using Cognos Report Studio.

. Developed complex Dashboard reports.

. Responsible for Business Data Analysis, Design, Development of

Multidimensional OLAP Cubes, deployment and providing drill-through

targets to another Cube, Power Play Portable Reports, Impromptu

reports and Report Net reports.

. Published Cubes and Reports through Power Play Enterprise Server

Administration and integrated access to information using Cognos

Connection.

. Used Transformer with a variety of sources and combined them into

Multi-Dimensional Cubes.

. Provided technical assistance, training and mentoring to Users and

Business Partners.

Environment: Cognos BI New Tool Report Net 1.01 (Frame work manager, Cognos

Connection, Report Studio, Query Studio), Impromptu, Power Play, Power Play

Transformer, Oracle 8i.

Education:-

Masters in Computer Science (M.S) December 2007

University of Bridgeport, Bridgeport, CT

Bachelor in computer science (B.E)

SVIT, Vasad, INDIA

August 2004

Contact this candidate