Manager Sales

SREE HARSHA

PROFESSIONAL SUMMARY

. Around *+ years of experience in developing applications using Cognos

Business Intelligence (BI) Tools and Data Warehousing Environment.

. Proficient in handling Data Warehousing and Business Intelligence (BI)

Tools like Cognos Report Studio, Query Studio, Analysis Studio,

Framework Manager, PowerPlay, PowerPlay Transformer, Impromptu Report

Administrator, Impromptu Web Reports.

. Strong Experience in developing Business models, reports using Cognos

8.4 and Cognos ReportNet 1.1.

. Experience in creating Adhoc reports using Cognos Query Studio.

. Expertise in designing Advanced, Complex and SQL based Reports using

Cognos Report Studio 8.4.

. Experience in creating Dashboards using Cognos Report Studio.

. Expertise in migration from Cognos Series 7 to Cognos Reportnet 1.1

and Cognos 8 BI.

. Experience in creating Models in Framework Manager and publishing the

packages on Cognos Connection.

. Expert knowledge of the Cognos toolset including experience in design,

development, and support of Powerplay cubes and reporting.

. Experience in creating Multidimensional reports by implementing Multi

Dimensional Cubes using PowerPlay and Transformer.

. Experience in Optimization of reports by working on different levels

of issues.

. Experience in providing detailed Documentation for the models and

reporting solutions.

. High level experience in providing Production support to customers and

end users.

. Experience with ETL tools like Informatica, SSIS.

. Strong experience in Database development with Oracle, Sybase, SQL

server and MS-Access.

. Knowledge of programming languages such as C, C++, JAVA.

. Proficiency in Microsoft Office Suite, Openoffice.org Suite, Data

warehousing concepts.

. Proficient in Mentoring users and Business Analysts.

. Self-motivated and enjoy working in a technically challenging

environment.

. Possess excellent communication and interpersonal skills.

. Team player with the ability to communicate at all levels of a project

development process

CERTIFICATIONS

. COGNOS REPORTNET AUTHORING PRODUCT PROFESSIONAL

. COGNOS REPORTNET PRODUCT USER

EDUCATIONAL QUALIFICATIONS

. Bachelor of Technology in Computer Science from Jawaharlal Nehru

Technological University, Hyderabad, India

TECHNICAL SKILLS

Business Intelligence Tools: Cognos Reportnet 1.0/ 1.1/8.4 (Report Studio,

Query Studio,Framework Manager), Cognos EP BI

Series 7.x/6.x- Cognos Impromptu, Powerplay

Transformer, PowerPlay Enterprise Server,

Impromptu Web Reports (IWR), Upfront, Access

Manager, Metrics Manager, Cognos Migration

Utilities,

Data Modeling Tools: SQL Navigator, Visio 2003, Toad, Erwin

4.0 / 3.5, SQL Assistance

Databases: Oracle 7.x/ 8.x/ 9.x/10g, SQL

Server 5.x/6.X/7.x,Teradata

Programming Languages: C, C++, JAVA, PL/SQL, VB, VC++, SAS, COBOL

Scripting Languages: Java Script, VB Script

Web Development Tools: HTML, DHTML, ASP.NET, C#, XML, Crystal Reports

Operating Systems: Windows 98/2000/NT 4.0/XP, UNIX, LINUX

WORK EXPERIENCE

Boston Scientific, St Paul, MN May'09

- Till date

Cognos 8.4 Consultant

Boston Scientific is a worldwide developer, manufacturer and marketer of

medical devices with approximately 25,000 employees. For more than 25

years, Boston Scientific has advanced the practice of less-invasive

medicine by providing a broad and deep portfolio of innovative products,

technologies and services across a wide range of medical specialties. The

Company's products help physicians and other medical professionals improve

their patients' quality of life by providing alternatives to surgery. The

scope of the project is to maintain and process security, design model and

reports, provide day-to-day support to existing users for Sales and

Clinical departments.

Responsibilities:

. Requirements analysis with Business Analyst to translate business

requirements to technical requirements.

. Prepare technical and business specifications documentation.

. Created Framework Manager Model to facilitate creation of Reports.

. Created new reports for Sales team to analyze the sales data.

. Created Sales Dashboards for Sales team in order to create an overview

of sales for Sales Reps, Regional Manager and Area Directors.

. Created new reports for Clinical team to analyze the clinical data.

. Creating advanced reports in Cognos Report Studio including multi-

prompt reports, drill down reports and conditional lay-outs etc.

. Involve in Unit and Regression testing of the reports created.

. Create and execute test plans and test scripts.

. Documentation of the reports by creating Report Specification Design

Documents which has both technical and business perspective of the

reports.

. Deploy reports among different Cognos Environments - Development,

Testing and Production.

. Provide Production support to already developed and existing reports.

. Provide Production support to new user and newly developed reports.

. Resolve the Cognos related Issue tickets which are logged in by users

of both production and non-production environments as a part of the

day-to-day support.

. Troubleshoots Cognos problems and tunes for performance.

. Provide training, support and best practices for Adhoc Query users,

Business users and Power users.

. Worked with IBM Cognos Technical support to get additional support

regarding the outstanding issues.

Environment: IBM AIX 5.3 ML5, Cognos Report Studio 8.4, Cognos Framework

Manager, Cognos Connection, Oracle 9i, SQL Server 2000, Toad, Microsoft

Visio, MS-access, MS-Excel, MS Windows XP Professional.

Quest Diagnostics, Collegeville, PA

Mar'08 - Apr'09

Cognos 8 Consultant

Quest Diagnostics provides customers with a comprehensive menu of routine

and specialty laboratory tests and services. With the consolidated

capabilities of regional laboratories, expanding international presence

they are able to offer unequaled convenience in utilizing one laboratory

for all diagnostic and prognostic clinical testing needs. Quest

Diagnostics deal with doctors, insurance companies and third party vendors

for their revenue generation. The scope of the project is to design reports

for Finance and Business departments to analyze the revenue and cash flow.

Responsibilities:

. User interaction to analyze and gather the business requirements.

. Involved in building models in Framework Manager.

. Created and published packages using Framework Manager.

. Created and applied security filters to restrict the access to

packages.

. Create simple to complex reports including various List reports,

Crosstabs and Charts.

. Involved in Design of Finance and Business reports in Cognos 8.2

Report Studio and Query Studio.

. Developed Monthly, Yearly reports, Top X reports of cash and revenue

flow.

. Designed the business reports for historical analysis and comparison.

. Designed business reports using SQL.

. Designed Trend Reports for trend analysis of the data.

. Created new reports and redesigning the migrated reports in Cognos

Report studio 8.2.

. Created various types of filters to narrow the focus of reports and

data.

. Designed the Prompt pages to have wide scope for users to choose the

data.

. List Report layout design with Page Set, List Properties.

. Created Drill Through Reports, Master Detail Reports.

. Involved in Scheduling and bursting the reports depending upon

schedules and privileges for users.

. Created prompts to facilitate user's choice of data and created

parameters to focus the data.

. Created Summary and Detailed reports for overview and detail analysis

of the data.

. Distributed and Scheduled Reports through Schedule Management in

Cognos Connection.

. Used Conditional Variables to create and combine summary and detail in

a single report.

. Optimization of already existing reports and new reports.

. Provided User Support for all the reports created.

. Created Ad hoc reports using Query Studio.

Environment: Cognos Report Studio 8.2, Cognos Framework Manager, Cognos

Connection, Analysis Studio, Oracle 10g, SQL Navigator, MS-access, MS-

Excel, MS Windows 2000.

Capital District Physicians' Health Plan (CDPHP), Albany, NY Dec '06 -

Mar'08

Cognos ReportNet Consultant

CDPHP is a leading health insurance provider in New York State. CDPHP

offers a range of choices of comprehensive benefit packages to accommodate

member needs, including routine care, check-ups, prenatal and post-natal

care, mammography, and childhood immunizations. The scope of the project

was to generate reports for users in various departments that include

Information Technology, Accounting, Marketing, Finance, Budget and

Actuarial, Vendor Services.

Responsibilities:

. Interacted with business analysts for gathering and analyzing report

requirements from users of various departments.

. Involved in building models in Framework Manager.

. Created and published packages using Framework Manager.

. Created and applied security filters to restrict the access to

packages.

. Involved in resolving recursive relationships, Verified and modified

query item properties and relationships to control the presentation of

data and ensure expected results

. Create simple to complex reports including various List reports,

Crosstabs and Charts.

. Involved in consumer and user level training in Cognos Query studio

and Report studio.

. Provided support to all the reports with in the company and involved

in maintenance of reports and Framework Manager Models.

. Involved in Creating Documentation for User training.

. Created various types of filters to narrow the focus of reports and

data.

. Modified existing reports with the new changes given by the users.

. Directly interacted with the users to discuss issues regarding the

reports.

. Created Drill Through Reports, Master Detail Reports.

. Involved in Scheduling and bursting the reports depending upon

schedules and privileges for users.

. Created reports using Conditional Formatting for specific details of

the report.

. Created prompts to facilitate user's choice of data and created

parameters to focus the data.

. Created summary and detailed reports based on the level of information

requested by the user.

. Distributed and Scheduled Reports through Schedule Management in

Cognos Connection

. Integrated the existing security with Report Net Security Managing and

Administering the Cognos portal.

. Created Ad hoc reports using Query Studio.

. Created Analytical reports using Analysis Studio.

. Created Dashboards, Scorecards using Metric Studio.

. Involved in Migration from Cognos Series 7 to Cognos 8.

Environment: Cognos ReportNet 8.1.1, Cognos ReportNet 1.1, Framework

Manager, Cognos Connection, Analysis Studio, Metric Studio, Oracle 9i, SQL

Navigator, SQL Server, MS-access, MS-Excel, MS Windows XP.

Anchor Blue Retail Group, Ontario, CA May '05 -

Nov '06

Cognos ReportNet Developer

Anchor Blue retailer stores are fashion conscious, youth oriented stores

who develop their own brand of clothing. They develop quality clothing that

is in style and is reasonably priced. The scope of the project was to

generate reports for users in various departments that include

Merchandizing, Planning, Sourcing and Allocation and documenting the

progress and analysis according to established IT standards.

Responsibilities:

. Interacted with business analysts for gathering and analyzing report

requirements.

. Involved in building models in Framework Manager.

. Created and published packages using Framework Manager.

. Create simple to complex reports including various List reports,

Nested, Crosstabs and Charts.

. Created prompts, conditions, filters and calculations in Report

Studio.

. Developed Standard Templates which could be used as foundation for all

reports.

. Created Drill Through Reports, Master Detail Reports

. Bursting reports depending upon user class and privileges for users.

. Developed Prompt pages and Conditional Variables.

. Scheduling and Distributing Reports through Schedule Management in

Cognos Connection

. Configured security according to the departments.

. Cascading scorecards to ensure consistent focus across divisions and

departments.

. Built scorecards using Metrics Manager.

. Integrated the existing security with Report Net Security Managing and

Administering the Cognos portal.

. Cognos SDK programming to automate the process of modifying the

reports created in Report Studio.

. SDK solutions to work on Content store.

. Developed the OLAP cubes in Cognos transformer and analyzed the data

using Cognos PowerPlay.

. Built multi dimensional power cubes in PowerPlay Transformer by using

IQD as a Data Source

. Created Ad hoc reports using Query Studio.

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Transformer

7.3, Cognos Powerplay 7.3, Oracle 9i, Toad, SQL Server, MS-access, MS-

Excel

Cardinal Health, Dublin, OH Jul '04 -

Apr '05

Reportnet Consultant

Cardinal Health is a leading provider of products and services in health

care industry. The scope of the project is about developing business

solutions and reporting using Cognos for various departments like pharmacy

management, hospital, diagnostic laboratory and manufacturing in order to

transform valuable enterprise data into shared information for insightful,

timely decisions to improve the business performance.

Responsibilities:

. Involved in Installing and Configuring ReportNet, FrameWork Manager.

. Interacting with Development and Management Teams.

. Involved in gathering requirements from end-users.

. Involved in mentoring entry-level developers, regarding various issues

of scope of project.

. Update Model, Repair joins, Create new joins according to the changing

requirements.

. Built filters, prompts, determine hierarchy and dimension information

in Framework Manager and publish packages.

. Updating the FrameWork Model when new metadata is imported.

. Applying Security and User Authentication to the various User Groups.

. Created List, Crosstab, Charts & Nested Crosstab reports ranging from

simple to complex reports.

. Apply conditional style, drill through, calculations and prompts to

add interactivity for users in Report Studio.

. Creating multilingual reports using Report Studio

. Maintain Roles and Groups in ReportNet, schedule reports to publish,

and manage Cognos Connection.

. Deploying the packages (exporting and importing the packages) using

the Deployment functionality under Cognos Connection Portal.

. Helped users using ad-hoc reports using Query Studio.

. Trained power users to use query studio for Ad-Hoc reporting.

. Created Catalog in Impromptu Administrator to create Reports.

. Updated Impromptu Catalog by adding tables and creating new joins.

. Developed analysis reports in Impromptu, Power play and published onto

Upfront

. Generated IQD files to feed PowerPlay Transformer Models to create

Multidimensional Cubes to generate PowerPlay Reports.

. Involved in Documentation for User training and testing.

. Involved in migration of reports from Impromptu to Reportnet.

Environment: Cognos ReportNet 1.0, Framework Manager, Cognos Transformer

7.3, Cognos Powerplay 7.3, Impromptu 7.3, MS-SQL Server 2000, Oracle 9i,

Toad, MS-Access, Windows XP.

Alliance Pharmaceutical Corp., San Diego, CA

Oct '03 - Jun '04

Cognos Developer

Alliance Pharmaceutical is a pharmaceutical research and development

company that uses perfluorochemical technology to develop gaseous medical

imaging and drugs. The company holds a number of patents in the US, Europe,

Japan, and other regions. The aim of the project is to create Transformer

Models and Packages and publish the reports on the web server providing

secured access to the users for Business application.

Responsibilities:

. Develop Catalogs, Impromptu reports and IQD files for the Cognos BI

Application.

. Design of the Transformer Models for Cognos Powerplay OLAP cubes.

. Set up of the Drill down paths and the convergence levels.

. Maintain User sign on information and auto access privileges for data

sources.

. Created models in Transformer to generate OLAP cubes using PowerPlay.

. Optimize the Impromptu reports and PowerPlay Cube performance.

. Defined, stored and maintained security information using Access

manager.

. Analyze the existing Data sources to the Catalog and document them.

. Involved in Publishing IWR's and PowerPlay cubes, PowerPlay reports,

on the portal using Cognos IWR administration, PowerPlay enterprise

server

. Developed a number of portable customizable reports using Power play.

. Created Trend over Time reports to identify developing trends.

. Created Variance reports to examine the difference between the actual

and the expected results.

Environment: Cognos (Power Play / Transformer, Cognos Impromptu, Cognos

IWR, Upfront, Cognos Scheduler, Access Manager, Power Play Enterprise

Server) Version 7.1, Oracle 8i, Windows NT.

JTM Telecom, India Oct '02

- Sep '03

Cognos Developer

Marvel Communications is the local distributor for JTM Telecom mobile

phones giant, located at Netherlands. The Company gets connections from

suppliers and Distributors and the same they supplies to various customers

like Agents and Resellers etc. we have developed automated system for them

which includes customer Information, purchase details, sales and Invoices

details. It automatically generates invoices such a way that they will go

to customer through mails. We developed various reports like Connections,

Reconnections, Account paid, Dues, Customer and sales.

Responsibilities:

. Created Catalogs and Reports Using Cognos Impromptu.

. Primarily responsible for converting, testing and enhancing Impromptu

reports and Implementing Macros.

. Worked on Cognos security to restrict access to users.

. Interacted with the clients and published the reports as per their

request.

. Involved in creating cubes and presented cubes according to the

business user requirement and set up security to cubes according to

user classes

Environment: Cognos Impromptu v6.1, PowerPlay Transformer, PowerPlay,

Oracle 7.3, SQL, PL/SQL and Windows NT.

SHAPE [pic] SHAPE [pic] SHAPE [pic] SHAPE [pic] SHAPE [pic] SHAPE [pic]

Contact this candidate