Rajeshwari Kummargunta

Email: abkxqp@r.postjobfree.com

Ph: 201-***-****

SUMMARY:

. 5 years experience in System

Analysis,Design,Development,Testing,Implementation of Client/Server

apps.

. Expertise in Full Life Cycle implementation of Business Intelligence

and Data Warehousing.

. Experience in MicroStrategy products Installation, Migration,

Administration and Maintenance.

. Expertise in Design,Development,Deployment and Maintenance of complex

MicroStrategy environment.

. Expertise in developing complex canned/ad hoc reports, dashboards and

scorecards presenting overview and detail analysis of complete

business with special attention to Key Performance Indicators.

. Experience in setting up security levels in MicroStrategy.

. Extensively worked on SQL, PL/SQL, concepts & structures of a large

scale relational database management systems.

. Experience in Datawarehouse architecture, star and snowflake modeling

with Fact and Dimension tables.

. Experience in Extract, Transform and Load (ETL) process from source

systems to target data marts/datawarehouse.

. Successfully executed Onsite-Offshore Model in Project Lead,

Administrator, Developer and Support roles.

. Conversant with Quality procedures while executing projects.

. Reasonable exposure to Heatlh Care and Gaming domains.

. Ability to work with and mentor staff at all levels, work individually

and in a team.

. Excellent Business Analysis, problem solving, communication, time

management, and interpersonal skills.

SKILLS:

BI Reporting Tools: MicroStrategy 8i (MicroStrategy

Desktop,MicroStrategy Administrator,MicroStrategy Intelligence

Server MicroStrategy

Web,MicroStrategy Narrowcast Server,Object Manager),

Business Objects XI

R2,R3,6.x,5.x Suite (Desktop/Enterprise Server products

suite), Web Intelligence (2.x, 6.x), CMC, CCM, CMS,

Broadcast Agent, Auditor, Live Office,Enterprise

Performance Management, Crystal Reports XI.

ETL: Informatica 8.1.1 (Source Analyzer, Mapping Designer, Mapplet

Designer, Transformation Designer, Workflow Monitor,

Workflow Manager, Repository Manager), Data Stage.

Languages: SQL, PL/SQL, C, C++, Unix Shell scripting.

RDBMS: Oracle 8i,9i,10g, Teradata,MS SQL Server 2000, MS Access.

Tools & Utilities: Toad, SQL Developer, MS Access, Teradata SQL

Assistant, Putty, Mercury Quality Center.

O/S: Windows (NT, XP, 2000), DOS 6.22,

UNIX, Solaris.

CERTIFICATIONS:

. MicroStrategy Certified Project Designer

. MicroStrategy Certified Report Developer

. Teradata Certified Application Developer V2R5

. Teradata Certified Design Architect V2R5

. Teradata Certified Master V2R5

WORK EXPERIENCE:

Client : PartyGaming Plc.

Dec 2007 -

Present

Role : Senior Software Engineer

Business Intelligence team is responsible for creation/updating/maintenance

of data Warehouse, extracting, transforming and loading data from source

(which is in Oracle) into data warehouse and providing visibility to

relevant information to business user with the help of reports, dashboards,

scorecards etc. in MicroStrategy. Project involves understanding the source

structure and designing data Warehouse schema to facilitate data analysis

through MicroStrategy. The ETL process extracts the data from source, does

clean up and applies transformations and loads the data into warehouse. On

reporting front project involves understanding and validating Business

requirement, coming up with logical data modeling and report design,

developing objects and reports as per the specification and setting them

for information delivery options.

Responsibility:

. Develop and maintain business intelligence system for reporting and

analysis.

. Understanding and validating business requirement and data warehouse

schema and do logical data modeling for MicroStrategy.

. Doing report design and development as per the requirement specification.

. Creating reports, dashboards and scorecards presenting overview and

detail analysis of complete business with special attention to Key

Performance Indicators.

. Performing Architect/Admin activities like Intelligence Server

configuration and Management, Cache management, User Account management,

Scheduling, Job Monitoring and prioritizing, Diagnostic and performance

monitoring, Object Migration, creating/managing Logical data model.

. Training end users and new comers to be able to make best use of the

system.

. Alert and delivery management using Narrowcast server, implementing

automated event based delivery mechanism, catering to devices like Email,

Wireless, File system.

. Defining and enforcing the processes and standards for the project.

Environment:

MicroStrategy 8i, Teradata v2r6, Informatica 8, Oracle 9i, Sun

Solaris/Windows 2003 Server.

Company : Congizant Technology Solutions,Chennai,India

Nov 2006 - Nov 2007

Client : Ingenix, Connecticut

Project : Employee Assistance Program (EAP) and Non Claims Based Data

Role : Programmer Analyst

Ingenix provides knowledge and information services to physicians and

health care professionals, health insurers, employers and other health care

buyers, pharmaceutical and biotechnology companies, medical device

manufacturers and government entities.

Data and Information Services -- Database and data management services,

software products, publications and consulting services to help employers,

health insurers, health care buyers, physicians and other health care

providers, and pharmaceutical companies improve health care delivery and

operations.

Drug Development and Marketing Services -- Clinical research services,

medical education services, and therapeutic outcomes and epidemiology

research to help pharmaceutical companies, biotechnology companies and

medical device manufacturers develop and deploy new therapies on a global

basis.

Based on the Data and information Services the Company publishes reports to

be accessed by the users (customers, companies etal).These reports are of a

highly complex nature and covers the entire gambit of MicroStrategy's

services. Our responsibilities included remodeling and restructuring of the

reports for this purpose we had to create new reports and work on the data

model as also the schema/public objects existing and also create

new schema/public objects to facilitate the process.

Responsibility:

. Understanding the new business flow and breaking it into various

business areas from reporting perspective.

. Defining and designing the reports to span the entire business

workflow and cater to needs of various user profiles.

. Defining and enforcing the processes and standards for the project.

. Design, development and maintenance of the data warehouse schema and

do logical data modeling for MicroStrategy.

. Design and review of the reports developed.

Environment:

MicroStrategy, Toad, Oracle 9i, Windows 2003

Client : Ingenix, Connecticut

July 2006 - Oct

2006

Project : LAB

Role : Programmer Analyst

Ingenix provides knowledge and information services to physicians and

health care professionals, health insurers, employers and other health care

buyers, pharmaceutical and biotechnology companies, medical device

manufacturers and government entities.

LAB subject area has dimension and fact tables that have the location

details of labs, types of services and coverages provided in the labs,

Claim details, employees covered for the particular labs etc. Reports are

developed to analyze the benefits paid to the claimants, lab results of

claimants etc.

Based on the Data and information Services the Company publishes reports to

be accessed by the users (customers, companies etal).These reports are of a

highly complex nature and covers the entire gambit of MicroStrategy's

services. Our responsibilities included remodeling and restructuring of the

reports for this purpose we had to create new reports and work on the data

model as also the schema/public objects existing and also create

new schema/public objects to facilitate the process.

Responsibility:

. Analysis of the Requirement.

. Co - ordination of Offshore and onsite

. Developing the Reports.

. SQL tuning of the reports

. Defect tracking

.

Environment:

MicroStrategy, Toad, Oracle 9i, Windows 2003

Client : Schering Plough

March 2006 - June 2006

Project : ODW BI Reporting

Role : Programmer Analyst

Schering-Plough, we aspire to earn the trust of doctors, patients and

customers by providing a steady flow of innovative, science-based medicines

and services that improve the health and well-being of people around the

world. To achieve these goals and grow our company, we are working to earn

the trust of all stakeholders. We understand that earning trust demands

hard work, sharp execution, integrity and transparency. Our customers and

patients are our most important constituents. Our vision for the New

Schering-Plough clearly sets forth what we will do as a global team, what

makes us special as a company and what will give us a competitive

advantage. To become the best, we are getting back to basics and

reinventing our company by driving positive change. We are focused on

becoming the best in three key strategic areas: people, products and

processes.

The aim of the project was to develop a reporting system which will enable

the business users of Schering Plough to view key critical Sales &

Marketing information. This new reporting system is developed from old

legacy system where reports were developed in MicroStrategy and Mainframe

reports. The project involved development of BO Universe, for each of the

reporting subject areas (Modules) and development of 255 reports. The

different modules in the project were . Weekly Retail . Monthly Retail .

Monthly Incentive . Monthly Non-Retail Incentive . Monthly Non-Retail .

Common Dimension Reports. The Water fall model was followed consisting of

following stages . Requirement Analysis . Design . Construction and Unit

Testing. Documents like Report Specification, Unit Test Plan and Unit Test

Documents were developed for each report.

Responsibility

. Creating Report Specification from old reports

. Construction of report

. Creating Unit test plan and Unit testing of reports

. writing Manual SQL on base tables, retrieving data and Comparing the

Manual SQL data with BO report data

.

Environment:

Windows NT server, OS, Windows 2003 S/w: PL/SQL, Oracle 9i, Business

Objects XI Release 2.

Project: ClaimSphere

Nov 2005 - Feb 2006

Role : Programmer Analyst

ClaimSphere - Cognizant's end-to-end Enterprise Reporting Solution,

collates data from various information sources of MCO, and generates

reports to operational and analytical requirements. Thus, ClaimSphere

integrates data across Lines of Businesses & across applications to offer

reports in the areas of Claims, Member-Subscriber, Provider, Billing,

Commission and Utilization Management.

ClaimSphere consists of an Operational Data Store, a Data-

Warehouse/Analytical Data Store, a set of commonly used Canned Reports, KPI

Dashboards for top management use, Analytics derived from analyzing the

enterprise data on multiple dimensions, and ETL loads.

Operational Data Store and Analytical Data Store

. A key feature of the ClaimSphere is storing of operational data in

De-normalized Operational Data Store (ODS) and analytical data in

multi-dimensional Analytical Data Store (ADS) for analytical and ad-

hoc reporting.

. Design of data stores was based on analysis of various parameters

such as volume, performance and complexity of calculation involved

in the Reports. This rigorous approach to data model design

translates into tremendous benefits for ClaimSphere customers in

terms of enhanced performance through fast and efficient report

generation.

. The Operational Data Store is designed to contain all data that is

required to analyze and report upon for operational activities.

Extracts from the production system database (or its replica) are

loaded into the Operational Data Store (ODS). The ODS thus contains

current data and minimum history.

. ClaimSphere documentation includes the physical as well as the

logical data model, attribute descriptions so that the clients can

easily extend and expand their reporting systems when required for

developing new reports to address evolving business requirements.

. ClaimSphere includes a set of over hundred commonly used operational

and analytical reports. Apart from reports, ClaimSphere also has Key

Performance Indicators that can be tracked using dashboards of

reporting tool. The range of the reports includes areas such as

provider affairs, claims processing efficiency, group/member

affairs, utilization management etc. These reports would address a

large part of the reporting requirements of any health plan.

Moreover, the reports would require minimal customization, if at

all, to match the specific requirements of a health plan that

chooses to implement the solution.

Responsibility

. Developing a standard report template.

. Creating Complex List reports, Cross Tab reports and Charts.

. Creating the KPI reports

Environment: Business Objects XI Release 2, Sybase, PL / SQL, Windows 2003

Company: Congizant Technology Solutions,Chennai,India

Aug 2005 - Oct 2005

Role : Software Trainee

Started my professional career with Congizant Technology Solutions. one of

the World's leading and India's largest IT services company. Was inducted

as a trainee and was given a rigorous training in field of software

development.

Entry Level Training (8 Weeks):

. Dataware Housing

. Foundation Course To Healthcare

. SQL Basics for Cognizant Entry Level Trainees

. Project Training sessions for newly inducted into the Organization

. Attended finishing school for basic managerial skills.

EDUCATION:

Bachelor of Technology - Chemical Engineering (B.Tech ) in Jawaharlal Nehru

Technological University, India, 2005 pass out.

Contact this candidate