Manager Project

Poonam Tiwari

**** ********* ****** *****

Apt #116

Saint Louis Park

MN 55426

Phone: +1-612-***-****

E-Mail: abmgdd@r.postjobfree.com

Experience Summary

. Having 5 years of experience in designing and developing Decision

support system (DSS).

. Experienced in implementing Business Intelligence solutions using

Cognos 8.4, 8.2, 8.1 Tools (Framework Manager, PowerPlay Transformer,

Analysis Studio, Report Studio, Query Studio, Event Studio, Metrics

Studio).

. Cognos ReportNet v.1.1. MR2 (Framework Manager, PowerPlay Transformer,

Report Studio, Query Studio)

. Experienced in developing and maintaining mappings and workflows using

informatica.

. Experienced in writing Oracle SQL

. Experienced in writing Oracle PL/SQL (Views, Stored

Procedures,Packages).

. Good understanding of the Dimensional Modeling.

. Involved in the SDLC (Software Development Life Cycle) of data

warehouse reporting and responsible for design, development and

testing.

. Experienced in Functional specifications gathering and Report

designing.

. Good understanding of ETL and OLAP.

Technical Expertise

Elements Particulars

Primary Skills Datawarehousing

Operating Systems Unix(AIX), Windows Xp

Languages SQL, PL/SQL

Reporting Tools Cognos ReporNet 1.1 MR2, Cognos 8.1, Cognos 8.2,

Cognos 8.4

Scripting Language Unix Shell Scripts

Databases Oracle 10gR2

Configuration Microsoft Visual SourceSafe.

Tools

Domain Knowledge Manufacturing and Finance

Documentation MS Office and MS Visio

Language known English, Hindi, Urdu

Project Details

1. Keane International Inc

Project Name EU PSD (European Union Payment Services Directive)

Client MoneyGram International Inc.

Location Lakewood (CO, USA)

Project The Payment Services Directive (PSD, 2007/64/EC) is

Description a regulatory initiative from the European Commission

which will regulate payment services and payment

service providers throughout the European Union (EU)

and European Economic Area (EEA). The purpose is to

increase pan-European competition and participation

in the payments industry (also from non banks), as

well as to provide for a level playing field by

harmonizing consumer protection and the

rights/obligations for payment providers and users.

The final adopted text of the Directive (2007/64/EC)

was officially published on 5 December 2007, to be

transposed into national legislation by all EU (and

EEA) Member States by 1 November 2009 at the latest.

Whereas SEPA (Single Euro Payments Area) is a

self-regulatory initiative by the banking sector of

Europe (represented in the European Payments Council

- EPC ) which defines the harmonization of payment

products, infrastructures and technical standards

(Rulebooks for Credit Transfer/Direct Debit, BIC,

IBAN, ISO 20022 XML message format, EMV chip

cards/terminals), the PSD is driven by regulators

and provides for the necessary legal framework

within which all payment service providers will

operate.

Environment Database: Oracle 10g

Reporting: Cognos 8.2, Cognos 8.4

Duration From March 2009 To Feb 2010

(Mon/YYYY) (Mon/YYYY)

Role / Cognos Developer

Responsibili

ty

Contribution Analyzing the report mockups and the requirements.

s Creation of Reporting Field Matrix against the Data

Model.

Designing Cognos Framework manager Model from the

Data Marts.

Implementation of Framework Manager Model in Cognos

8.2.

Implementation of Data Level, Object Level and

Package Level Security in

Framework Manager Model.

Writing of stored procedure in Oracle PL/SQL to

import and use that as

Query Subjects in Framework Manager Model to fulfill

specific purpose.

Implementation of Short-Circuit Logic in Framework

Manager.

Creation of Model Query Subjects, Embedded and Model

Filters.

Developed FM Model against STAR,SNOWFLAKE and Fact

Constellation data

Models.

Created DMR in Framework Manager Model against

relational Data Source.

Creation of Packages and publishing the same.

Educating business users on how to make use of the

Cognos

Package/Namespace in Cognos Query Studio.

Creating of Complex Reports in Report Studio.

Made use of Value Prompt, Text Box Prompt, Date

Prompt, Select and

search Prompts. Almost made use of all it's

properties and feature.

Created complex report by making use of Style

Variable, Render variable

and Block Variables in Report Studio.

Module Team 7

Size

2. Keane International Inc

Project Name Oracle Partner Party Transformation (Oracle - PPT)

Client Honeywell Inc.

Location Phoenix (MN, USA)

Project The project deals with reporting against Oracle Apps

Description Financial Sources, that involved, re-engineer of

Partner Setup, Commissions, Settlement and Partner

Servicing processes and capabilities to achieve

sustainable growth, improve flexibility and

standardization of processes, increase automation,

enhance operating margins and selling effectiveness

Environment Database: Oracle 10g

Reporting: Cognos 8.2, 8.4

Duration From Jan 2008 To March 2009

(Mon/YYYY) (Mon/YYYY)

Role / Cognos Developer

Responsibili

ty

Contribution Designing Cognos Framework manager Model for the

s Data Marts.

Implementation of Framework Manager Model in Cognos

8.1.

Implementation of Data Level, Object Level and

Package Level Security in

Framework Manager Model.

Creation of Model Query Subjects, Embedded and Model

Filters.

Developed FM Model against STAR,SNOWFLAKE and Fact

Constellation data

Models.

Creation of Packages and publishing the same.

Educating business users on how to make use of the

Cognos

Package/Namespace in Cognos Query Studio.

Creating of Complex Reports in Report Studio.

Made use of Value Prompt, Text Box Prompt, Date

Prompt, Select and

search Prompts. Almost made use of all it's

properties and feature.

Created complex report by making use of Style

Variable, Render variable

and Block Variables in Report Studio.

Made use of Java Scripts (HTML Items) in Report

Studio.

Working on Report Enhancements.

Module Team 4

Size

3. Keane International Inc

Project Name ITAM Datamart

Client Honeywell - EAS

Location Phoenix (AZ, USA)

Project The purpose of this project was to create a Datamart

Description for the Executive Reports of Global IT Asset

Management (Global - ITAM) that will provide the

capability to have a more robust reporting tool. The

current Executive Reports provides statistics of all

IT Assets in a tabular fashion. This presentation

does not facilitate taking business decisions. Hence

it is envisioned to create a new system that will

provide graphical details of the asset information

along with the current tabular details enabling

users to get easy information for their Business

needs. Since the current ITAM application data

structure is too complex to provide the dashboard

and graphical views a new Datamart is to be designed

specifically for reporting needs.

Environment Database: Oracle 8i

ETL Tool: Informatica 7.1.2

Reporting Tool: Cognos ReportNet 1.1 MR2

ReportNet Repository: Oracle 9i

Client: Internet Explorer 6.0.

Web Server: Apache 2.0.4.8

Duration From March 2007 To Jan 2008

(Mon/YYYY) (Mon/YYYY)

Role / Cognos Developer

Responsibili

ty

Contribution Preparing the report model using Cognos Framework

s Manager.

Development of complex reports using Cognos 1.1MR2.

Writing Java Script to implement look and feel

features in the reports.

Implementing Data level security using parameter map

filter.

Tuning the report to have optimum performance.

Ensuring that the reports that have to be delivered

to the client are of excellent quality and comply

with the requirements.

Prompt in bringing to notice any anomaly in the

application that could lead to a defect.

Perform efficient Unit Testing of the developed

reports.

Carry out performance testing of the reports.

Team Size 4

4. Data Method Inc

Project Name ITAM Datamart

Client Honeywell - Aero

Location Phoenix (AZ, USA),Bangalore (India)

Project The purpose of this project was to create Reports

Description for the Managers of Sales and marketing to helping

then do proper analysis of their business. The

current Executive Reports provides statistics of all

IT Assets in a tabular fashion. This presentation

does not facilitate taking business decisions but

helped them to make business decisions. A new system

that will provide graphical details of the sales

information along with the current tabular details

enabling users to get easy information for their

Business needs.

Environment Database: Oracle 8i

ETL Tool: Informatica 7.1.2

Reporting Tool: Cognos ReportNet 1.1 MR2

ReportNet Repository: Oracle 9i

Client: Internet Explorer 6.0.

Duration From Aug 2005 To Nov 2007

(Mon/YYYY) (Mon/YYYY)

Role / Cognos Developer

Responsibili

ty

Contribution Designed and developed reports built with Cognos

s Reportnet 1.1 MR2

Created drill-down reports.

Provided 24 x 7 supports for the application.

Provided trouble shooting for production issues in

the specified SLA

Executed performance tuning and enhancements to

existing reports.

Administrated the Cognos environments for different

users

Provided updates to Frame Work Manger

Set up and tested the Business Continuity Plan and

various environments

Maintained and supported scheduling of the reports

run by cognos Scripts

Documented the QA Process

Involved in various production activities such as

vendor application upgrade, pre-Coa dump, and

various down stream systems.

Created PL/SQL procedure and complex SQL queries as

per the requirements.

Migrated Cognos 7.1 reports to Cognos 8 BI

Interacted with the business users to get the

requirements and also guide them in the UAT phase

Team Size 3

Experience Details (starting from the current employer)

Sl. No. Name Of The Designation Joining Relieving

Organization Date Date

1. Keane Consultant 19-Feb-200 26-Feb-2010

International 7

Inc.

2. Data Method Inc. System Analyst 01-Aug-200 27-Nov-2006

5

Visa Details

Holding Valid EAD Till March 2012

Training Attended / Certifications Done

Course Details Duration

From To

PMO Basic Level September 2008 March 2009

Certification

Dimensional Modeling May 2007 May 2007

Cognos Reportnet 1.1 MR2 Feb 2007 Feb 2007

Oracle SQL Feb 2007 Feb 2007

Qualification Details (Highest Degree on Top)

Degree Name of the Place Year of passing Name of the

college / university

institute

MBA Nimbus Dehradun, UP, 2005 H.N.B.Garhwal

Academy Of India University

Management

B.Sc H.N.B.Degree Allahabad, UP, 2001 Poorvanchal

Collage India University

XII Nivedita Varanasi, UP, 1998 Indian School

Shikchha India Certificate

sadan School

Examination

Board

X G.G.I.C. Sitapur, UP, 1996 Indian School

India Certificate

School

Examination

Board

PERSONAL INFORMATION:

Father's Name Mr. Janardan Tiwari

Date of Birth 2nd Mar 1981

Gender Female

Marital Status Married

Nationality Indian

Contact this candidate