Manager Sales

Professional Summary

. *+ years of BI experience using Cognos8 ( Report Studio, PowerPlay

Studio, PowerPlay Client, Query Studio, Analysis Studio, Framework

Manager, Cognos Configuration), Cognos Impromptu 7.x, PowerPlay,

Transformer, Impromptu Web Reports (IWR), Upfront, PowerPlay

Enterprise.

. Strong experience with client interaction, understanding business

applications, business data flow and data relations.

. Expertise in Installing, Configuring and Administration of Cognos

products.

. Experience in Solution Architecture/ Business Analysis/ Dimension

modeling in various BI Projects.

. Experience working as a Cognos Administrator/ Modeler/ Developer in

Business Intelligence arena.

. Used Cognos best practices for dimensional modeling, relational

modeling using Framework Manager.

. Expertise in creating OLAP cubes in PowerPlay Transformer and

optimizing them for performance.

. Performed administrative task in Cognos environment.

. Implemented high quality reporting by creating complex reports,

dashboard reports using Cognos8.

. Good understanding of data warehousing concepts.

. Worked with multiple data sources like Oracle, SQL Server.

. Actively involved in creating project documentation for the complete

project life cycle.

. Interacted extensively with end users during requirement phase, system

test, user testing, provided training and support.

. Good analysis and problem solving skills. Self-starter with excellent

communication and Interpersonal skills.

. Ability to work in a team environment or independently, handle

multiple tasks concurrently and to work overtime as needed.

Technical Skills

BI Tools : Cognos 8.x/ ReportNet1.1(Framework Manager, Report

Studio, Powerplay Studio, Query Studio, Analysis Studio,

Cognos Connection), Cognos Series 7.x ( Impromptu,

PowerPlay, Upfront, Impromptu Web Reports(IWR), Power

Play Enterprise Server(PPES)), Access Manager, Scheduler,

Visualizer), Transformer 7/8, Cognos Configuration,

Cognos Migration Utilities.

Databases : Oracle 10g/9i/8i, SQL Server2000/2005, MS Access

Web Servers : IIS 4.0/5.0, Apache Tomcat

LDAP Servers : Sun one, Active Directory Server, Access Manager

Languages : HTML, XML, VB Script

Operating : Windows, UNIX

Systems

EDUCATION/CERTIFICATION

. Cognos 8.3 Certified BI Author

. Master of Engineering

. Bachelor of Engineering

PROFESSIONAL EXPERIENCE

Praxair, Inc. (IT Head Quarters) Danbury CT

July 2009 - Till to date

Developer/Administrator

Praxair is a global, Fortune 300 company that supplies atmospheric, process

and specialty gases.

Cube Migration for US and Canada

This Project involved in migration of sixty OLAP Cubes, eighty PowerPlay

reports, Catalogs from Cognos 7.4 to Cognos 8.3 and upgrade framework

manager models, reports, transformer models from Cognos 8.3 to Cognos 8.4.

Reports and Cubes development for Europe

Purpose of this project was to deliver a report studio, Powerplay reports

and cubes related to general ledger, accounts payable, accounts receivable

for Europe users.

Cube migration and upgrade from Report Net 1.1 to Cognos 8.4 for Asia

The job involved in migration of cubes, PowerPlay reports from impromptu

7.3 to Cognos 8.4 and upgrade reports and framework manager model from

ReportNet 1.1 to Cognos 8.4.

Responsibilities:

. Involved in the entire life cycle of the application, which involved

in understanding scope of the project, functionality,

development and reporting for analysis.

. Worked with business users, functional lead to understand and document

business requirements.

. Developed migration plan and completed the task well within the

project deadlines.

. Worked on Audit to find the usage of Cognos Users.

. Responsible for creating user groups and roles to manage security in

Cognos Connection and access rights of the reports for

the end users.

. Deployed packages, folders and Reports from a development to

production environment.

. Scheduled and burst multi-page reports to ensure that business users

receive relevant, consistent and timely information.

. Followed best practices for Framework Manager and Transformer data

modeling.

. Migrated Impromptu Catalogs and reports to Cognos 8.3 using migration

utility tool migratetoc8.

. Migrated Transformer Models from Cognos series 7.4 to Cognos 8.3

. Analyze Pros and Cons for Transformer data source.

. Replaced IQD's and used report studio list report as data source for

Transformer Model.

. Define OLAP cube structure and built the multidimensional analysis

cubes using Transformer.

. Built Cubes for multiple business disciplines such as Profits,

Accounts Receivable and Sales.

. Set up Cube security by implementing custom views combined with

dimension views to deploy member

level security.

. Defined Cube drill through to allow end users to drill through from

OLAP Cubes to detail relational report.

. Defined generic drill through on Cognos connection to allow mapping

data between packages from

different data sources.

. Developed batch scripts for Cube refresh and used deployment method

to copy newer version of the cube to deployment locations.

. Developed metadata model using Framework Manager and published

packages to Cognos connection.

. Extensively used determinants and star schema groupings in Framework

Manager Model.

. Applied data level and object level security in Framework Manager.

. Build PowerPlay Portable reports (.ppx) using PowerPlay client and

publish to Cognos connection.

. Created complex reports using PowerPlay studio for end users.

. Used OLAP packages to create crosstab and list reports in report

studio.

. Developed reports using various functionality like master detail,

conditional formatting, various prompts

and conditional blocks.

. Developed templates for list report and cross tab report to company

standards.

. Upgraded reports and models from ReportNet 1.1 to Cognos 8.4 for Asia.

. Upgraded reports, models and templates from Cognos 8.3 to Cognos 8.4

FP2 and fixed the broken reports after upgrade.

. Trained end users on using PowerPlay studio, Analysis studio and Query

studio.

Environment: IBM Cognos 8.4(Report studio, PowerPlay studio, PowerPlay

Client, Analysis studio, Query studio, Framework Manager, Transformer,

Cognos Connection), Cognos 8.3, Impromptu Series 7.x, Transformer 7.x,

Upfront, Access Manager, SQL Server 2005 and JD Edwards, Windows XP.

Softpath Systems llc, Norcross, GA Oct 2008 - June 2009

Role: Cognos Developer/Administrator

Softpath System llc, is a Cognos accredited services and technology

partner, implementing Cognos BI solutions at various industries. The

project involved developing reports for Sales and marketing department and

was involved in migration from Cognos series 7 to Cognos 8

Responsibilities:

. Involved in the full project life cycle of planning, development and

implementation stages

. Gathered reporting issues from the users and analyzed user

requirements.

. Involved in server administration, which includes applying security

and publishing and managing reports.

. Analyzed and studied the existing Cognos 8 reports and series 7

Impromptu reports.

. Migrated Impromptu Catalogs to Cognos 8 series using impcat2xml

Migration tool.

. Fixed the issues in the migrated/upgraded environment, trouble shoot

and test the reports.

. Modified packages to generate reports for better analysis.

. Created multiple data source connections for development, testing,

production stages.

. Designed a multidimensional model using star schema grouping in

Framework Manager.

. Implemented data security, object level security, package level

security in Framework Manager and Cognos Connection.

. Created Calculations and Filters in the Framework Manager model.

. Employed cascading prompts and drill-through.

. Performed data validation of reports using Query Analyzer in SQL

SERVER 2000.

. Created complex Dashboard reports using Report Studio and performed ad-

hoc reports using Query Studio.

. Create Drill through and Master Detail reports using Report Studio,

Sales analysis and Summary reports for current year and previous year

using Analysis studio.

. Scheduled bursting of reports and distribution of Cognos 8 reports

using portal administration.

. Generated trend over time, variance reports using PowerPlay/ Analysis

Studio.

. Developed impromptu query definition (.iqd) files, imported into

Transformer for creation of cubes.

. Created appropriate dimensions and manual levels in Transformer

model.

. Optimized the cube access time by partitioning and caching and by

using dimension views.

. Created multiple cube groups in Transformer.

. Analyzed the scope for upgrade to Cognos 8.4 (FCS).

. Installed and Configured Cognos 8.4 on single test environment

server.

. Upgrade reports from Cognos 8.3 to Cognos 8.4.

. Tested compatibility of existing Cubes in latest Cognos 8.4 PowerPlay

studio.

. Provided End user training in Cognos 8 and Cubes.

Environment: IBM Cognos series 8.4 and 8.3 (Report Studio, Analysis

Studio, Query Studio, Framework Manager, Migration Utilities), Cognos EP

series 7, PowerPlay, Transformer 7.4, Oracle 9i, SQL Server 2000 and

Windows XP.

Amtex Systems, Chennai, India Jan 2006 -July 2007

Role: Cognos Developer/Business

Analyst

Amtex Systems provides high quality end to end software solutions across

industries through unique models and methodologies, to deliver time, cost,

quality and full service advantages best of breed in nature. Project

consists of offshore development, business intelligent reporting modules by

creating data marts and designing reporting application.

Responsibilities:

. Analyzed and explored user requirements.

. Created complex SQL views, custom functions and imported into

Framework Manager.

. Involved in dimensional modeling to design and develop Star schema

using Erwin.

. Built dimensional models in Framework Manager that can be used in

Analysis Studio for in-depth analysis.

. Extensively used determinants, star schema grouping and parameter maps

while building DMR's.

. Created multiple namespaces in which included filters and calculations

while working with multiple data sources and defined relationships and

cardinality between different database tables.

. Resolved loop joins in Framework Manager.

. Applied data level, object level, and package level security.

. Applied best practices to tune the model and published the packages in

Framework Manager.

. Created alternate drill-down paths, manual and calculated categories

and relative time categories in a Transformer model which uses

multiple data sources such as iqd's, ascii files, excel files.

. Set up calendar and fiscal years in single time dimension.

. Consolidated data using duplicates, regular and time state rollup

function.

. Created power cube groups based on sales territories for different

sales managers.

. Customized cubes with dimension and user class views.

. Improved cube build time by incremental updates, time based

partitioning, reducing category numbers, good partition strategy,

enabled crosstab caching.

. Managed Scheduling of reports, public and individual folders and

distribution lists, users, groups and roles using Cognos connection in

Cognos 8.

. Installed and configured 8.2 in a distributed environment.

. Developed list, cross-tab reports from cubes that show inventory

reorder and shortage while updating existing reports.

. Designed bookmarks, query calculations, layout calculations, tables,

page sets, and conditional blocks Presented key data in a single

dashboard reports.

. Worked with filters, sections, prompts, conditional formatting and

conditional rendering to create user friendly reports.

. Distributed daily sales summary reports to different departments by

using burst report technique.

. Created report-based drill through access and master detail

relationships.

. Created reports in PowerPlay using layers, suppressing zeros, using

parentage, find in cube, advanced subset definitions, drilled

through to PowerPlay reports, cubes, and impromptu reports.

. Ranked data for top-n analysis and highlight exceptions using custom

exception definitions.

. Trained users in using Cognos reports and cubes.

Environment: Windows XP Pro, IBM DB2, Microsoft SQL server 2000, Cognos 8.2

(Framework Manger, Cognos Connection, Report Studio, Query Studio, Analysis

Studio), PowerPlay 7.4, Transformer 7.4, Cognos PowerPlay for excel, Access

Manager, LDAP Directory server (Sun One).

Contact this candidate