Pradeep

abokph@r.postjobfree.com

Sr. Cognos Developer

832-***-****

Professional Summary:

? Over 8 years of IT experience in Dataware housing environment with Analysis, Design, Implementation

of Business Intelligence systems, Reporting tools and OLAP environments along with strong analytical

skills & vast Report Net expertise.

? Certified IBM Cognos BI Author with over 7 years of experience in the area of Framework Manager,

Query Studio, Report Studio and Cognos Connection.

? Excellent working knowledge of BI tools like Cognos 10, Cognos 8BI (8.4/8.3/8.2/8.1), Cognos Report Net

1.1/1.0 MR2 (Query Studio, Report Studio, Framework Manager, Cognos Connection), Cognos

Impromptu 7.x/6.x, Cognos Impromptu Web Reports (IWR) 7.x/6.x, Cognos Transformer & Power

Play 7.x/6.x, Upfront 7.3, Power Play Enterprise Server (PPES) 7.x/6.x, Access Manager 7.0.

? Strong experience in Installing, Configuring, Monitoring and Management of Cognos on Windows

platform.

? Extensively worked Framework Modeling and Complex Report building using C10.

? Strong Experience in developing Business models and publishing packages using Framework Manager

along with Cognos Connection in Cognos 8 and Report Net1.x.

? Expertise in OLTP/OLAP system study, analysis, E-R Modeling and developing Database schemas like Star

Schema and Snowflake Schema.

? Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and

reports with easy navigation into subsequent reports by drill down feature.

? Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.

? Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.

Extensive one to one interaction with end users/Business analysts to identify their needs and wants,

?

then translate the functional requirement into reporting requirements, design and business data flow.

? Migrated the Framework Manager Models and reports from Cognos Report Net to Cognos8 BI.

? Designed the Transformer model and built the cubes using Power Play Transformer, explored the Cube data

using the Report and Analysis Studio.

? Excellent skills with expertise in Data design and analysis using Oracle 10g/9i, DB2, MS SQL Server

2005/2000, Excel, SQL, PL/SQL.

? Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.

? Knowledge in HealthCare, Pharmaceutical, Finance, Banking, Telecom, and Manufacturing domains.

? Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design,

development, testing and documentation.

? Strong troubleshooting and production support skills and coordination/ interaction abilities with end users.

? Self-motivated and enjoy working in a technically challenging environment.

? Possess excellent communication and interpersonal skills.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in

?

work schedules and possess good communication skills.

Technical Skills:

BI Tools COGNOS 10, COGNOS 8BI: Framework Manager, Report Studio, Query

studio, Analysis Studio, COGNOS 8.4/8.3/8.2/ 8.1, REPORT NET

1.1(MR1/MR2), COGNOS connection.

COGNOS Series 7.x: COGNOS Impromptu Administrator, Impromptu User, Impromptu Web

Reports, COGNOS Power Play Transformer 7.x/6.x.

Operating Systems: Windows 95/98/2000/2003/XP/2008 and UNIX.

Languages C, C++, SQL, PL/SQL.

Databases: ORACLE 7.x /8i, 9i, 10g, DB2, Teradata data base, MS SQL Server 2000, 2005

and MS Access.

GUI: Visual Basic 6.0, Toad, HTML.

Software Packages: MS-Office, Microsoft Word, Excel and Power Point

Data Modeling Tool: Erwin 4.1, Transformer and Frame Work Manager

CERTIFICATIONS

? Certified IBM Cognos BI Author- IBM COG-112 certification .

? Cognos Report Net Modeling Product Professional Cognos Certification Program

? Cognos Report Net Authoring Product Professional Cognos Certification Program

PROFESSIONAL EXPERIENCE:

Michigan State University (MSU), Lansing, MI MAR?12 ? Till Date

Sr. Cognos Developer

Enterprise Business System Planning (EBSP)

Key Financial Reports: The Key Financial Reports summarizes Income and Expense related activities based on

Prior Period End Balance, Current Period Activity, and End Balance of the Current Period providing a basis for users

to reconcile their accounts, funds at different MSU structures.Provide an easy to use statement, to perform

reconciliation activities for that accounts and sub accounts. The driver behind the report is that the Internal Audit

office has indicated to the President that an alarming amount of account reviewers are not reconciling their accounts.

The reporting requirement is to ultimately be used to get these individuals to perform the reconciliation activities

related to their accounts.

Roles & Responsibilities:

? Installed & Configured the Cognos 10 BI environment, administering the servers, Troubleshooting and

Performance Tuning

? Created reports using List, Cross tab, and Chart templates in Report Studio.

? Developed standard reports, Charts, Drill-through Reports and Master Detail Reports

? Created query prompts, calculations, conditions and Filters.

? Created Lists, Groups and Cross-tab reports with Drill-through functionality.

? Created Bursting Reports and Multilingual Reports bases Using Report Studio.

? Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several

business users.

2

? Developed List reports, crosstab, Dashboard reports and also created Business Insights in C 10

? Developed Relational and Dimensionally Modelled Relational Models in Framework Manager.

? Created Ad hoc reports like Grouped List Reports, List Reports and Cross-Tab reports using Query Studio.

? Also created documentation for all the processes involved like applying security for reports, deployment,

portal customization etc.

? Create packages to suit the business needs and to improve the performance of the reports by defining filters,

adding calculations and performing SQL tuning on the model and report level using Oracle database.

? Load balanced the Cognos 10 BI Multi server environment for performance issues.

? Proactively managed multiple environments to ensure high availability, high performance, and minimization

of risk.

? Migrated all the cubes and reports from Cognos 8.4 to C10

? Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.

? Worked extensively on EDW and Facets databases.

Environment: COGNOS 10.1/8.4BI (Framework Manager, Report Studio, Query Studio, Cognos

Connection), Oracle 10i, SQL Server 2005, Sybase, DB2, Toad, MS Excel, Windows 2008/ XP

Kaiser Permanente Information Technology, Pleasanton, CA NOV?10 ? FEB?12

Sr. Cognos Developer

Description:

Kaiser Permanente is the largest nonprofit health plan in the United States, serving 8.6 million members in

nine states and the District of Columbia. It is an integrated health delivery system which provides entire

scope of care including preventive care well-baby and prenatal care, immunizations, emergency care,

screening diagnostics, hospital and medical services and pharmacy services.

Project: Health ways Replacement Project. I had worked on the reports which should display the outcomes reported

by members enrolled in the Life Style Management Program, which identifies the risks and number of enrollees

associated with the outcomes for risks and diseases and also worked on the reports which fall under Disease

Management, Health Coaching.

Roles & Responsibilities:

? Analyzing the specifications provided by the client and developing the specification document for the reports

as per the client requirements.

? Installed & Configured the Cognos 8 BI environment, administering the servers, Troubleshooting and

Performance Tuning.

? Developed and Published Packages in Framework Manager 8.2 ? Connecting and testing the data source,

created database layer, physical layer and presentation layer, defining appropriate relationships between the

tables.

? Used Dimensional Modeling (DMR) and Relational Modeling and Snow Flake Schema modeling

technique to develop models.

? Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports,

cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master

Detail, drill through, drill up, drill down and have extensively used the other features in Cognos 8.

? Created cubes using Power play Transformer and implemented security into the cube model.

? Developed Unit Test Cases, documents for report validation and testing after interacting with the end users.

? Created jobs to schedule reports in Cognos connection.

? Customized Cognos connection Portal based on User Specifications.

? Worked with ETL team for developing various mappings and workflows in Informatica as required by the

design specifications.

? Experience in writing HTML/Java Script in Cognos Report Studio reports as per the requirements.

? Provided Production support and resolved maintenance issues.

? Performed Data Validations, Unit testing and prepared some Test cases.

? Worked extensively on EDW and Facets databases in various environments.

Environment: COGNOS 10.1/8.4BI (Framework Manager, Report Studio, Query Studio, Transformer, Cognos

Connection), SQL Server 2005, Sybase, DB2, Win SQL, Windows vista/XP

I

Contact this candidate