Sathish

510-***-****

abl1sk@r.postjobfree.com

_____________________________________________________________________

Summary:

. Over 7 years of experience as an IT professional with in-depth

knowledge of systems development, database management, data warehouse

design, ETL, business intelligence (BI), along DW with advanced SQL

coding, and process analysis.

. Around 6 years of experience in working with Cognos 8.4, ReportNet 1.1

utilizing Framework Manager, Cognos Connection, Report Studio, and

Query Studio, .

. Expertise in analysis, design, development, testing and deployment of

mission critical software applications using Oracle, PL/SQL, SQL,

Business Objects and Informatica.

. Involved in Creating prompts, Calculations, Conditions & Filters in

Framework Manager and Report Studio.

. Extensive experience in modeling using Framework Manager including

applying Object level, and data level security,Cognos Macros,

migration of impromptu catalogs to Cognos 8, migrating reports from

Impromptu to ReportNet.

. Proficient in designing multidimensional Model in Framework Manager,

designing Reports in Query Studio, and Report Studio.

. Expertise in designing and development of Cognos 8 BI complex report

i.e. Drill Through, Dash Board Reports & Master Detail Reports using

Report Studio.

. Involved in creating Dashboards and modified the existing Dashboards

using Report Studio.

. Extensively involved in Transformer model design and Power play cube

building.

. Strong understanding of Dimensional Modeling, Star and Snowflake

schema.

. Expertise in modeling Framework Manager with OLAP cubes (MDX

Reporting) and relational database as source including applying data

level, query subject level, package level security and Publishing

packages to Cognos server.

. Extensive experience in Installing, configuration, and system

administration of Cognos series 7 and 8 on Windows and UNIX

environments.

. Prepared Functional specifications, Technical specifications and

Mapping documents for various projects and prepared test cases for

several reports and analyzed the test cases to ensure the test case

efficiency is up to the desired standards.

. Experience in interacting with end users to gather requirements for

reporting.

. Excellent Interpersonal and communication skills technically competent

in result oriented and problem solving skills.

Education Qualification:

Bachelor's in Computer Science

Technical Experience:

Operating Systems UNIX (AIX, HP), Windows NT/2000/XP

RDBMS DB2 UDB v7.2/5, Oracle 10g/9i/8i/7.3,

SQLServer 2000/2005, MS Access, Sybase

Languages Java, J2EE, C++, C, SQL, PL/SQL

Modeling Tools Erwin 4.0/3.5, Visio 2000

ETL Tools Informatica 7.1.2,Informatica (Power Center

6.x, Power Mart 6.x), DTS, Data ware house

center

OLAP /Reporting Cognos 8.4, Cognos ReportNet MR1.1, Cognos

(Impromptu 6.0/7.x, Power Play 6.6/7.x.)

Tools SQL Navigator 4.0, TOAD, MS Office 2000, MS

Project

Web Servers Websphere, Weblogic, Apache/Tomcat 4.x, IIS

5.x

Scripting JavaScript, Shell Script

Other XML, HTML, DHTML, JavaScript

Cardinal Health, Columbus, OH

05/2009 - Till Date

Sr.Cognos Developer

Description:

Cardinal Health is a leading provider of products and

services in health care industry. Cardinal Health develops, manufactures,

packages and markets products for patient care, distributes

pharmaceuticals, medical, surgical and laboratory supplies, and offers

consulting and other services that improve quality and efficiency in health

care.

Responsibilities:

. Created Models & Packages using Framework Manager.

. Involved in creation of various reports like grouped-list reports,

also used cascading prompt.

. Responsible for creating the report packages for report deployments in

various environments.

. Exclusively worked on a very big set of legacy systems for maintaining

Rebate reports across the world.

. Understanding existing business Data Model and customer requirements.

. Working on DB2 database in Framework manger in the creation of

package.

. Used Cognos Connection for the design of reports using Report Studio

and Query Studio.

. Developed the Burst reports in Report Studio.

. Extensively used filters and Tabular SQL in reports.

. Prepared prompt-page requirements based on the Functional

specifications.

. Involved in writing the SDD and Unit test documents.

. Generated reports by creating groups, defining filters, defining

prompts and creating summary fields.

. Worked with various initiates like Diabetes, CHF and CAD and developed

around 20 Reports.

. Created Reports using Page breaks to display the list of patients

under each Hospital.

. Involved in training the end users on various Cognos components.

. Trained other consultants on Cognos 8 and Cognos ReportNet.

. Generated reports using data from multiple databases.

. Generated various Master-Detail, Drill Up and Drill down Reports.

. Involved in creation of different kinds of complex reports.

Environment:Cognos8.4(Cognos Connection, Report Studio, Power play

Transformer,DB2,Windows NT, SQL, PL/SQL, UNIX Shell Scripting, Oracle

10g/9i,Sql server 2005.

Bank Of America, SFO, CA

08/2008 - 05/2009

Sr.Cognos Developer

Description:

BOA is one of the major Financial Companies in USA.

The project involved migrating their reporting environment to ReportNet to

make the Business Environment more convenient for the Departments like

Fixed Income, Mortgage & Real Estate sectors.

Responsibilities:

. Experience working directly with the business users for gather

requirements, manage scope and schedule.

. Involved in creating various Rapid Development Templates Reports for

various CMS initiates.

. Involved in designing the best possible approaches to develop

the models using Framework Manager and published the packages to

ReportNet Server.

. Involved in development of various mapping using informatica against

the fact to summary tables.

. Created views as per the business logic to populate the data against

the Fact table to Summary table.

. Prepared detailed user manual(s), for different package(s), explaining

the business rule behind all the fields in the package and illustrate

the functionalities available in Query Studio, to help users create ad-

hoc reports.

. Implemented the Cognos Best Practices.

. Created different kinds of complex reports using Report Studio.

. Involved in production support and fixed the issues based on priority.

. Created the stored procedures to apply the business logic and present

in the Reports.

. Designed Reports with various conditional formatting to identify the

measures for the different types of reports.

. Involved in tuning the SQL and Reports to reduce the report runtime.

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

Cognos Connection), Powerplay Transformer), DB2, Oracle 10g, PL/SQL, MS

Visio, Shell Scripts, Windows 2000, SQL Server 20005.

Merck & Co Inc, Cokes burry, NJ

07/2007 - 08/2008

Cognos Developer

Description:

PeopleSoft's Enterprise Performance Management (EPM)

solution provides an effective means for global data collection. The EPM

system gathers information about Merck's workforce and uses sophisticated

business analytics to calculate HR metrics and then provide users with

powerful multidimensional reporting capability through Workforce Insights

(cubes). Delivery to the end users will be accomplished via the various

decision support tools.

Responsibilities:

. Created Jobs to Schedule multiple reports in Cognos Connection.

. Personalized Cognos Connection, Specified display options, regional

options and personal information.

. Involved in collecting Business Intelligence reporting data from

managers, staff across divisions and across geographies

. Created and edited the sessions, tasks. Developed different

workflows using workflow manager.

. Created multi-dimensional cubes using Transformer and deployed the

same along with reports using PowerPlay Enterprise Server.

. Optimized the performance in powerplay cubes by reducing the query

time and partitioned cubes.

. Integrated Cognos Upfront Newsboxes and NewsItems in Cognos

Connection.

. Given training on Reportnet for developers and End users.

. Implemented Single Signon between Upfront reports and Cognos

Connection.

. Involved in architecture and design of the Cognos ReportNet 1.1

Application.

. Created Metadata modeling by using Framework Manager.

. Imported metadata from various sources such as Relational Databases,

XML Sources, ReportNet models, Impromptu Catalogs and Architect

models into the Framework Manager.

. Installed and Configured Cognos Reportnet on Windows and Unix

environments.

. Installed and Configured Framework Manager.

. Created complex reports by using Report Studio .

. Administering the Impromptu Catalogs by creating User classes and

User class filters.

. Used Cognos Architect to create packages and published them to

Upfront.

. Applied security on user class level in upfront by giving access

privileges.

Environment: Cognos 8 BI Series, (Cognos Connection, Framework Manager,

Query Studio and Report Studio), Windows NT, IIS and Oracle 9i.

American International Group, Inc, Atlanta, GA

01/2006 - 07/2007

Cognos Developer

Description:

American International Group, Inc. AIG is the world's

leading international insurance and financial services organization,

operating in more than 130 countries worldwide. The primary concern of AIG

was data integration within the Cognos Enterprise Business Intelligence

solution. The scope of this project was complete enterprise reporting

coverage. The project involved designing of Functional Requirement

Specifications for report development, defining relationships between

different database tables and building models using Framework Manager.

Reporting included the development of flexible scorecards, dashboards their

web publishing

Responsibilities:

. Created models in Framework Manager and published packages to Cognos

Connection to generate ad-hoc and professional reports using Query

Studio and Report Studio.

. Analyzed the needs by interaction with the business analysts.

. Tested reports for data validation and Performance Tuning.

. Migrated objects from Cognos 7.1 to ReportNet 1.1 .

. Created templates and enhanced reports using Conditional Formatting.

. Generated Standard reports, Charts, Drill Through, Master Detail

reports and multilingual reports using Report Studio.

. Created and Managed the Report Generation Job schedules.

. Implemented Data level and Object level security for packages.

. Communicated with the business users to comprehend the requirements.

. Designed the reports and catalogs using impromptu as per the

requirements.

. Extensively used PowerPlay Transformer to convert the data into power

cubes.

Environment: Cognos ReportNet, Cognos Impromptu 7.1, Impromptu Web Reports

7.1(IWR), Cognos Power Play 7.1, Cognos Power Play Transformer 7.1, Cognos

Power Play Enterprise Server 7.1, Cognos Upfront 7.1, Access Manager 7.1,

Configuration Manager 7.1, Oracle10g, Erwin, Ms-Excel, UNIX, Windows NT

WorldCom, TX

06/2004 - 12/2005

Cognos Developer

Description:

This system was built with an objective to help top-

level management is decision making. The data from different departments is

collected and integrated into a data warehouse and is sent to data marts

that are built based on subject areas.

Responsibilities:

. Installation and Configuration of Cognos EP Series 7 Products

Impromptu, PowerPlay Transformer, IWR, Reporting Administration,

PowerPlay Enterprise Server, Access Manager and Upfront Server

Administration using Configuration Manager.

. Extensively used Impromptu in accessing the source data to built

reports and to feed the transformer models

. Created Multi-dimension cubes using PowerPlay Transformer to create

reports in PowerPlay

. Created Drill-Through Reports to provide users with more detailed

information and query linking Created Business Mix Reports, Ranking

and Variance Reports

. Used Impromptu Audit Configuration and Impromptu Audit File Processor

to assess report activity and performance of Impromptu reports.

. Administration of Access Manager to implement Security among Cognos

. Catalog creation and modification.

. Setup security using Access Manager Administration.

. Creation of users and changing their profile.

. Generated List Reports, Cross Tab Reports and Drill Through reports

using Cognos Impromptu tools querying database.

. Customized data by adding Filters, Prompts, Calculations, Summaries

and Functions.

. Published reports and catalog to Upfront.

. Interaction with end users to identify key dimensions and measures for

business performance.

. Created Multi-Dimensional cubes using PowerPlay transformer.

. Created daily, weekly, monthly and quarterly reports for the

management team and field operation managers using PowerPlay.

. Worked on PowerPlay Enterprise Server to publish PowerPlay cubes &

reports on web.

. Provided end user training and Production System Support

Environment: Cognos 7(Impromptu & Powerplay), Oracle 8i, Windows NT, UNIX

(HP-UX).

TCS,Chennai,INDIA

01/2003 - 05/2004

Informatica Developer

Description:

The purpose of the File Inventory Management (FIS) project is

help TTSL track the inventory at various storage locations it moves from

the Warehouse to the Dealer and then to Subscriber and vice-versa. FIS

tracks the FWP movement from circle/Cluster warehouse to various agencies

as well as the activations, churns and the reverse flow of stock from

agencies to circle/cluster warehouses. FIS also tracks movement of stock

from warehouse to Authorized Service Center and Refurbishment agencies and

back to warehouse. Being a web based application it provides access to all

business users of the Tata Tele-Services across India, who use the system

for stock requisition, to view stock reports, acknowledge stock received,

transfer stock and submit retrieval information. Thus the system helps

track the status including location and condition of any FWP Instrument.

The FIS System has interface with Systems such as SAP, Tallyman, AIS,

Metasolv, CAP and POS which provide it the activation, stock transfer and

disconnection details of FWP Instruments.

Responsibilities:

. Developed and supported the Extraction, Transformation and Load

process (ETL) for a Data Warehouse using Informatica 5.1.

. Analyzed Star Schemas and advised necessary changes for better

performance and extraction of data.

. Imported data from various Sources transformed and loaded into Data

Warehouse Targets using Informatica Power Center 7.1.

. Worked on Informatica SourceAnalyzer, WarehouseDesigner,

Transformations Developer, Mapplet Designer and Mapping Designer.

. Interacting with business users to analyze the project requirements

Involved in designing logical models.

. Created reusable Lookup transformations.

. Created users and assigned privileges.

. Created and Monitored Sessions and Batches using Server Manager to

load the data into the Target Database.

. Created InformaticaMappings using transformations like Source

Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected

lookups, Filters, Sequence Generator, Router and update strategy.

. Created and managed the global and local repositories and

permissions using Repository Manager in Oracle Database.

. Created shell scripts for pre and post session actions.

. Managed versioning of folders in a repository.

. Involved in Oracle Apps and HRMS

. Used pmcmd command line utility to execute sessions using Perl

scripts.

. Involved in analysis and performance tuning of mappings/sessions.

. Increased performance by tuning the transformations and discussing

database issues with the DBA.

Environment: Windows NT, HP-UNIX, Oracle 8i, InformaticPowerCenter 7.1,

Business Objects, AutoSys, TOAD.

Contact this candidate