Manager Sales

Swetha Poddutooru

Email: **********@*****.***

Phone: +61-430-***-***

Professional Skills

. Cognos Certified Professional with 5+ years' experience in analysis,

design, development, deployment, testing and support of Cognos reports.

. Expertise knowledge in metadata modeling using Cognos Framework Manager

to create and publish packages by using the best practices.

. Good understanding of Data warehousing Development life cycle.

. Experience working with Cognos 8.4 and Cognos 10.2

. Knowledge working on Cognos Power Play Transformer.

. Experience in Relational and Dimensional modeling using star schema.

. Proficiency in report design, development and modification of major

reports using concepts of Prompts, Drill-through, Master/detail,

Conditional formatting, bursting, cascading prompts and graphical

reporting using Report studio and Query studio.

. Scheduling reports and creating agents to notify business critical

operations using Event Studio.

. Worked on Analysis Studio to develop multi dimensional reporting.

. Developed hide and show report using Conditional variables and Render

variable.

. Ability to gather and understand the business requirements, translate

them to IT solutions.

. Strong understanding of relational database design concepts and in depth

knowledge of OLAP solutions.

. Deployment of reports and packages across various environments.

. Sound understanding of Oracle RDBMS concepts and ETL tools like

Informatica.

. Knowledge of databases like Oracle, SQL Server (T-SQL).

. Excellent written and communication skills, strong experience with

stakeholders interaction including customers, senior management, business

people, and technical staff.

Professional Experience

November 2010 - Present Avant Insurance, Sydney

Reporting Analyst

Avant Insurance is a health insurance organization designed for doctors. It

offers professional indemnity insurance, medico-legal and risk management

advisory services for medical professionals.

The main aim of the project is to provide ongoing report development across

all business units (Sales, Marketing, Membership, Claims, Legal, IT) to

analyze premiums received, claims paid to the members, retention and growth

of our product, assisting in debt collection reports. I have significantly

contributed to the business expansion by developing 80 + critical business

decision making dashboards, summary and detailed reports across various

divisions at Avant.

Projects

Practitioner Reporting

Practitioner reporting is a collection of reports that help the business to

monitor and analyse the overall growth/performance of the business across

various segments. The purpose of this project is to provide the higher

management a better insight about customer retention, acquisitions, and

losses, monitoring actuals against budgets, analysing the market share,

strike rates, renewals, conversion of quotes to policies and member

demographics management reports. The dashboard, summary and detailed

reports offers business a better overview about the business growth and

focus on the key opportunities for achieving outstanding results.

. Involved in the requirements gathering

. Designing the dashboard using designing principals by Stephen Few.

. Developed reports against DWH data and SQL generated queries.

. Worked with stored procedure query subjects in Framework manager and

reports.

. Creating list reports, cross-tab reports and chart reports using

multiple queries in a single report, drill- through reports and

conditional formatting to highlight the business needs.

. Extensively worked in Scheduling and Deploying (Staging to Production)

Reports.

. Provided customized reports by creating advanced prompts as well as

hyperlinks on the report main page.

. Used master detailed reports to display the dashboard pages by each

state.

. Provided drill-through across dashboard and the management reports to

their detailed level.

. Testing the reports and reconciling against the source systems.

. Updating the Cognos Framework model as and when required.

. Deploying the required model updates and reports across test and

production environments.

. Providing report level security.

. Scheduling reports to the business users.

Renewals Reporting

Renewals reports assist the business to examine renewals conversations,

losses, and competitive analysis during the renewals periods. These reports

give the breakdown of the renewals number and premium against various

dimensions that enable critical business decisions.

Responsibilities

. Interacted with business users to identify various key dimensions and

measures

. Created/Enhanced data models using cognos framework manager (Creating

query subjects, query items, relationships, calculated measures,

filters for cognos models and providing security to the Model)

. Defining drill-through and drill down paths for providing an in-depth

view of the data across multiple dimensions.

. Created organized and formatted reports, folders and other contents on

Cognos Connection Portal

. Involved in preparation of Report Specifications document.

. Working on Report Studio and Analysis Studio.

. Created complex multiple Crosstab Reports which involved multiple

levels in the dimensions.

. Creating complex reports with the functionalities like Prompts,

Conditional Variables, Conditional Blocks, Formatting, Page Layout,

Drill-Through, Calculated Measures, Parameters, report level

security.

. Creating jobs for multiple report views to schedule these as per the

requirements. To verify scheduled jobs and its logs.

. Transferred technical knowledge specific to Cognos tools and the

existing data model to other team members

Debts Reporting

The purpose of these reports is to provide improved visibility in tracking

and reporting on outstanding debt of members across different states. Suite

of Debt Reports provides a continued support for the member services debt

collection team to maintain and monitor their aged old debt that allows

making improved decisions for recovery of the outstanding premium amounts.

This helped the business recover over $3 Million aged old debts.

Responsibilities

. Gathered business requirements from the business users.

. Analyzing specifications and developing specification documents for

reports.

. Updating the existing cognos model to import metadata from the data

source.

. Collecting the data marts and created cognos models based on the data.

. Creating database layer, business layer and presentation layer by

defining appropriate relationships between the query subjects.

. Designing and developing multiple reports using cognos report studio.

. Developing dashboards, summary and detailed reports.

. Created drill-through from summary to detailed reports.

. Creating calculated columns based on the available query items in the

model.

. Testing reports for Quality assurance before delivering to the end users.

. Deploying of reports from development to Test and to Production.

. Provided security to the reports.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved multiple prompts and multi-queries.

. Extensively provided production support for ongoing projects.

. Scheduling the reports for the executive team.

Helpdesk Reporting - IT

This project is to allow the executives and the users to review the entire

helpdesk request by their status. These reports are designed to guide IT

managers in making critical decisions on investment in helpdesk operations

and strategies. This gives a better insight for resource allocation and

monitoring the performance of the staff.

Responsibilities

. Developed drill-through reports and dynamic dashboards that display the

top 10 performance categories.

. Worked with Stored Procedure Query Subjects and Direct SQL reports in

Report Studio.

. Transferred technical knowledge specific to Cognos tools and the existing

data model to other team members.

. Creating relationships between query subjects to better represent the

logical structure of the business and the user requirements.

. Creating list reports, cross-tab reports and chart reports using multiple

queries in a single report, drill- through reports and conditional

formatting to highlight the business needs.

. Customized data by creating filters prompts and calculations.

. Administering the business users in the portal based on the requirements.

. Created several drill through to several reports for providing better

functionality.

. Created reports views to provide users the ability to run the custom

reports by securing the underlining base reports.

Finance reporting

The Finance General Ledger project is to assist the finance team with their

finance reporting. This project helped the finance team to monitor their

acquisition and losses, premiums gained and lost by various segments,

Claims, payments and transaction histories. This gave a better insight for

the finance team to manage their critical day to day activities.

Responsibilities

. Developed and published cognos packages in framework manager - connecting

and testing the data source, created database layer, business layer,

defining relationship between the dimensions and fact tables.

. Design and developed Framework manager model using stored procedures and

database tables and published to the server.

. Used DMR and Star Schema modeling techniques to develop models.

. Interacted with the technical team for enhancements related to ETL and

database tables.

. Applied filters and calculation to the query items.

. Provided security for the model and deploying the package across various

environments.

. Developed Dashboard for the executive to monitor their finance within

each of the business units.

. Designed reports using most of the report studio advanced features

(Conditional Formatting, Conditional Page Layout, Sections and Drill-

through).

. Provided customized reports using prompts on the cover page.

Market Share Reporting

The aim of Market Share reports is to provide better analysis on the Avant

Market Share by comparing external data sources (Medical Deans) to Avant

Member numbers. This project is for strategic reporting which enables

markets to carry out the required decision support. These reports enable

for better insight for competitor analysis and to action appropriate

strategies to maintain superior market share.

Responsibilities:

. Developed framework manager models with dimension, business layers to

cater for various business needs.

. Publishing the models across various environments.

. Created list reports, cross-tab reports and chart- reports using multiple

queries in a single report.

. Created various Report Studio reports using calculations, filters,

prompts and conditional formatting, drill through.

. Designed extensive business Reports to cater the needs, which can meet

the business demands on behavioral, trend analysis.

. Production support which involves solving user issues.

. Reconciling the reports against the source data.

. Provided technical assistance, training and mentoring to Users and

Business Partners.

. Deployed reports and provided report level security.

. Scheduled reports and to run the reports periodically.

. Trained the end users to effectively use the reporting tool to build and

customize their ad-hoc reports.

Claims reporting

The purpose of Claims reporting is to assist the claims department in their

claims management. These reports helped the business users to manage the

claims policy limits compared to their targets.

Responsibilities:

. Involved in Requirement gathering from Business Users.

. Analysing and creating the functional and technical specifications to

implement business logic for the user requirement to generate Framework

Manager Models and Cognos report studio reports.

. Involved in creating security, and deployment (exports and imports).

. Created and maintained Projects, Models, and Packages using Cognos

Framework manager.

. Designed & developed multiple reports using various templates like list

reports, cross-tab reports and chart reports.

. Developed Master detail Drill through reports, Drill up and Drill down

reports, multiple prompt reports and cascading prompts in Report

Studio.

. Implemented different functionalities using report filters, sorting,

multiple queries and conditional blocks.

. Created conditional variables to change the graph headers and list

column headers based on the user parameter selection.

. Developed security for reports, bursting the reports through cognos

connection.

. Interacting with the End users on a regular basis for resolving issues

pertaining to the reports.

. Testing reports using review checklists for Quality Assurance before

delivering to the end users.

Retention and Growth

The Member Retention and Growth reports enable the business to monitor the

member retention and losses during a specified time. This helps to monitor

the retention rates against the targets enabling the business to identify

the key channels for the business. This assists the business to improve the

renewals tactics that get high retention rates.

Responsibilities:

. Interaction with the Users and Business Analysts for better

understanding of the reporting requirements.

. Analysing the business specification and the report prototypes.

. Involved in Strategic Planning for Framework Models.

. Responsible to design frame work manager packages, reports, cubes.

. Designing and Developing Framework models, creating Packages, setting

up the security for the Packages and publishing them to ReportNet.

. Created complex multiple Crosstab Reports which involved multiple

levels in the dimensions.

. Created Master-Detail queries according to user requirements.

. Supplemented regular prompts, cascading prompts, filters, conditional

style, static headers, Drill through, sub queries to add interactivity

for users in Report Studio.

February 2008-October 2010 Innovative Hub Pty ltd, Sydney

Report developer

Projects

Project 1

Name Secondary Sales Reporting

Client Novartis

International Basel, Switzerland

Role Cognos Report developer

Environment Cognos 8.3 BI (Query studio, Report Studio and Framework

manager), Oracle, Windows XP

Description:

Novartis International is a Multinational pharmaceutical Company based in

Basel, Switzerland and operates in 140 countries. The Company is mainly

involved in manufacturing of Drugs and Pharmaceutical products and other

Generic elements used in the Biotechnology. Novartis provides an integrated

healthcare solutions provider with pharmaceutical product basket, it caters

to many therapeutic areas that include cardiovascular, gastrointestinal,

analgesics, haematinics, anti-infectives and antibiotics, respiratory

agents, ant diabetics and immunological.

Secondary Sales Reporting BI project is an initiative to bring about a step

change in the process of data gathering secondary sales data, analysis and

reporting in order to better inform the decision making process by the

business. The functional area covers sales and inventory. Data from

different branches are integrated at the central repository of Head Office.

The Data Warehouse resides on an ORACLE Database with Cognos8 BI providing

OLAP functionality.

Responsibilities:

. Involved in Business Requirement Gathering.

. Using Frame work manager model to create and publish packages.

. Created DMR package using Regular Dimension and Measure Dimension to the

Business Users to generate the reports in Analysis Studio users.

. Created model query subjects and query items and analyzed the

cardinalities and joins between query subjects in framework manager.

. Deploying the Cognos models across various environments.

. Created complex reports with the functionalities like prompt, conditional

blocks, page layout, drill-through, calculated measures.

. Unit testing of reports.

. Using Layout Component Reference developed re-usable components.

. Created a report with select and search prompt, header and footers.

. Designed advanced list reports with blocks.

. Created advanced list operations with various types of cascading prompts.

. Provided data level security using session Parameters.

. Provided Report Level Security.

. Involved in the performance optimization of the reports.

Project 2

Name Access.

Client Eagle, Mearsk, Panasonic,

Hitachi

Position Report Developer

Technology Cognos 8.3,

Oracle 9i, Windows XP

Description

The Access is a product. It provides business intelligence analysis

services to our major clients. Data from various online transaction

processing (OLTP) applications and other sources is selectively extracted,

related, transformed and loaded into the Oracle data warehouse using

Informatica Power Center ETL tool. Then the transformed data from data

warehouse is loaded into an OLAP server to provide Business Intelligence

Analysis Services.

A data mart had developed for Sales sector that cater to the reporting

requirements of the Business Users. The business users used to analyze,

what products are selling on which stores on what dates under what

promotional conditions. Ad-hoc reporting was developed on this data mart

along with end-user customization. The end users can drill through the

information using Business Key Factors over intranet/internet. Security has

been implemented to control the end user data access.

Responsibilities

. Created Models in Framework Manager and publishing into Content Store.

. Worked with Report Studio like List Report, Repeater and Line charts.

. Created Master details Reports and Drill-through Reports.

. Worked with Conditional Variables to highlight the data based on

reporting Requirements.

. Created cascading prompts and value prompts.

. Using of render variable for dynamic column selections.

. Designed advanced list reports with conditional blocks.

. Involved in report bursting.

Project 3

Name Sales Reporting Data warehouse

Client Sonoco Products,

Hartsville, S.C., USA

Role Report Developer

Technology Cognos 8.0, Power Play Transformer (Framework

Manager, Report Studio), Oracle 9i.

Description

Sonoco Products which are one of the organizations that sells various

numbers of products. Sonoco Products have various stores, which maintain

database has lots of historical data.

This project was to create Sales Data Warehouse and generate reports using

Cognos 8.0 and Power Play Transformer. The aim of sales data Warehouse is

to analyze sales of major brands varying with different promotional

schemes.

The system has a database which stores information about sales, profits and

contacts of customers. Using this existing database, the system should

analyze the sales and profit and generates reports for Sales and Profits in

month wise and year wise. The resulting model gives us an idea about growth

in profit, prediction about increase in sales. The data Warehouse was

further used to do Market Based analysis. The data Warehouse plays a major

role in enabling various stores to view the data at a lowest level and help

them to make decisions to bring more revenue to company with new policies.

Responsibilities

. Understanding the business requirements and designing applications to

meet their needs.

. Creating Ad-hoc report using Query Studio and Report Studio.

. Developed some complex Reports by using calculated fields in Report

Studio.

. Used Report Studio & Query Studio to develop various types of reports

like List Reports, Crosstab Reports, chart Reports & Master Detailed

reports.

. Involved in creating the Burst Report in Report Studio to distribute the

report to the multiple Recipients.

. Creating Prompts, Calculations, drill through reports, Conditions and

Filters in the Reports.

. Used Ranked to show Top or Bottom performers in client business.

. Scheduled and Distributed reports using Schedule Management in Cognos

Connection.

Certifications

IBM Certified Designer - Cognos 8 BI Reports SR5767388

Technical Skills

BI Tools : Cognos 8/10 BI Report Studio, Query studio, Analysis Studio,

Event studio, Framework manager, Cognos

Connection, Cognos Power Play Transformer,

Event Studio

Database: Oracle 9i/10g, MS Access, SQL Server 2005/2008

ETL: Informatica power center 7.x

Professional membership details

Member of ACS (Australian Computer Society)

Education

. Masters of Information Technology, University of Ballarat, VIC,

Australia, 2008

. Masters of Computer Applications, Osmania University, India,

2005[pic][pic]

[pic]

Contact this candidate