Project Developer

Sarita Desale

(:+1-309-***-**** ( : ******.******@*****.***

[pic]

Experience Summary

> Information Technology (I.T.) professional, with 5+ years of

experience.

> Technical Experience in Discoverer, BI Publisher,Oracle BI EE /Siebel

Analytics to work on Administration Tool and GUI

> Proficiency in building queries using Discoverer Plus

> Knowledge of creation of RTF,PDF EXCEL Template

> Experience in Building query using Query Builder

> Experience in Bursting of reports

> Creation of reports in BI Publisher

> Good Knowledge of Design Template Layout

> Knowledge of Scheduling reports in BI Publisher

> Proficiency in building queries using Oracle Answers (OBIEE Answers)

> Experience with building Metadata Repository at 3 layers Physical

Layer (connecting Data sources & import schema), Business Model &

mapping (creating Logical tables & data source mapping) and

Presentation layer level (creating presentation catalogs).

> Good knowledge about Dashboard.

> Knowledge of localizing the metadata in Administration Tool.

> Knowledge of creating Calculated measures in BMM Layer of the

repository.

> Good Knowledge of Creating the Dimensional Hierarchies on Specific

Dimensions.

> Configure BI Server and Presentation Server on different machines.

> Experience in Oracle Database Development and Administration.

> Excellent presentation and interpersonal skills.

> Conducted corporate batches on SQL, Discoverer 10g and Oracle BI EE

Modules.

> Knowledge of creating Reports in Discoverer 10g Reporting Tool.

> Sound knowledge about Scrum and Agile Practices.

> Self-motivated, responsible and proper time management with good

Written, Verbal and Listening skill, commitment to co-operative

teamwork.

Technical Skills:

Operating System Windows 2003 Server, XP

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

Web Technologies HTML,DHTML,XML

RDBMS Oracle

BI Tools Siebel Analytics (Oracle Business Intelligence

Enterprise Edition), Discoverer.

Reporting Tool Oracle BI Publisher 10g

Version Control Clear case

Tool

Educational Qualification:

> Master in Computer Management from Pune University

> OCA Certifications from Oracle University

Employment History:

> Vyom Lab Pvt Ltd,Pune (May-2007 - April-2010 )

> Minda Veleo Ltd,Pune (March 2005 -April 2007)

Professional Experience:

1. Software Engineer at Vyom Lab Pvt. Ltd., Pune

Vyom lab is an E-business consulting firm specializing in implementation of

ERP, SCM and CRM applications like Oracle E-Business Suite, JD Edwards

Enterprise One, PeopleSoft and Siebel. Vyom lab (IWare Logic) is a member

of Oracle Partner Network (OPN) and works with Oracle for sales, support

and implementation of Oracle applications products like E-Business Suite,

JD Edwards Enterprise One, PeopleSoft and Siebel.

It also has tie up with other Software company for conducting corporate

training for their Employee.

Technical Trainings Imparted:

Discoverer & BI Oracle BI Presentation Services 10g: Create

trainings imparted Reports/Dashboards

Oracle BI Server Administrator 10g: Build

Repositories

Other Training SQL, PL/SQL

Imparted

Project Name: IM7 (Inventory Management) Bulkprice & Billing Reports.

Duration: July2008 - April 2010

Client: British Telecom

Roles Sr. OBI Administrator, Developer, Publisher Developer

Software Used: ETI Tool as OWB, Toad, OBIEE (10.1.3.4.1) 10 g, BI Publisher

10g, Quality Center, Windows XP

Project Details: Client wants to implement two reports Viz. Bulkprice and

Billing.

Bulkprice which helps in implementing price changes as per the Market

Conditions and Business Strategies. Billing Report helps in deciding which

all Contracts are eligible for Unified Discount Scheme (UDS) & also shows

the unbilled data needs to reported till it gets billed; the report needs

to be for Priceline data for each site & contract for internal and external

customers.

Responsibilities:

> Created business model on the basis of requirements.

> Created physical layer, BMM layer & presentation layer objects in

administration tool.

> Implemented writeback functionality as user can put the request for

extracts.

> Creation of Dashboard shows the link for downloading the extract

reports.

> Worked on KSH UNIX protocol for transferring, zipping and E-Mailing

the extracts.

> Was involved in deployment of RPD and webcat on client Testing

Machine.

> Generation of reports on purchase order

> Generate Booking reports for product those are booked by end of day

for supplier.

> Generate cancelation and return reports for product those are

canceling by end of the day.

> Generate shipping Backlog Report, Unbilled Shipment Backlog Report by

end of day or week

> Creation of Profit and Loss Repots monthly and yearly basis

> Scheduling Reports in Publisher

> Design Reports layout

> Develop report Queries and Data models

> Creation of RTF Template using OBIEE Reports.

> Creation of reports in BI Publisher using subject Area.

> Creation of Reports Based on subject area using Query Builder in BI

Publisher.

> Creation of PDF Template using OBIEE Reports.

> Creation of EXCEL Template using Reports using excel analyzer.

> Scheduling reports in BI Publisher USING Bursting functionality

Project Name: Qatar Information Exchange

Duration: May2007 - June2008

Client: Qatar Information Exchange

Role: Lead OBIEE Administrator, Developer, Publisher Developer

Software Used: OBIEE (10.1.3.4.1), Oracle 10g, BI Publisher 10g, Toad,

Windows XP Professional

Project Details: Objective of this project is to build report on Qatar

information in English and Arabic Language like Reports Related to Births,

Death, Education, Population, Marriages, and Census, Labor Force, Foreign

Trade for Qataris and Non Qataris. As per requirement for project client

want to see me onsite for project coordination

Responsibilities:

> Created physical layer, BMM layer & presentation layer objects in

administration tool.

> Create Repository having different Subject area

> Creation of RTF Template using OBIEE Reports.

> Creation of reports in BI Publisher using OBIEE Subject Area.

> Creation of Reports Based on Business area using Query Builder.

> Creation of RTF Template using OBIEE Reports.

> Creation of EXCEL Template using OBIEE Reports using excel analyzer.

> Scheduling reports in BI Publisher

> Create complex join, calculated item and also created level based

hierarchy.

> Create Births and Deaths Reports For Qataris and Non Qataris

> Reports for no of marriages for mans and Divorce

> Creating various Prompts, Filters as per the requirements of the

Business

> Creation of Dashboard pages.

> Create reports on Population, Education, Labor Force for Qataris and

non Qataris

> Worked as an On-site Coordinator for this project.

> Understand the requirement from client and Based on the requirement

create High level design Document.

2. Valeo Ltd, Pune (March 2005 -April 2007)

Minda Valeo Security Systems (VSS) Pvt. Ltd. Is a 50-50 Joint Venture

Company formed in year 2007 between Valeo Security Systems (France) and

Ashok Minda Group (India).

Valeo is one of the world's leading suppliers of automotive systems,

modules and components.

Develop complete electronic and mechanical Access and Security systems

Be the supplier of enhanced access electronics (Smart Car Key, Passive

Entry and Start Systems, ESCL) and powered comfort (Power Closure Systems,

Smart Closing/Opening)

Provide Side Door Access System (SDAS) through excellence in core

components (Latches, Mechatronic handles & locksets) and integration

expertise (vehicle & system)

Project Name: VSS Analysis (Integrated Service desk Analysis)

Duration: Oct2006 - April2007

Role: OBI Developer.

Software Used: OBIEE (10.1.3.2.1 with BI Publisher) 10g, Oracle 10g,

Windows 2003 Server.

Project Details: IT department wanted to have business intelligence

solution for their IT helpdesk system.

This was one of the ISO compliance requirements for the IT department.

Responsibilities:

> (Service Level Agreement) SLA meet or not for the request.

> If your request is on "ON HOLD" status for some time being, then that

time should not be considered for SLA.

> If request has been entered in "OFF HOURS", then that time should not

be added while calculating SLA.

> Importing data sources using ODBC

> Created business model on the basis of requirements mentioned by IT

department.

> Created physical layer, BMM layer & presentation layer objects in

administration tool

> Put business logic in BMM layer according to the requirements

> Create dimension hierarchies and level-based measures

> Model aggregate tables to speed query processing

> Set up security to authenticate users and assign appropriate

permissions and privileges

Project Name: Sales and Report

Duration: March2005 - Sept2006

Roles: SQL Developer, Discoverer Developer, OBIEE Developer, Publisher

Developer

Software Used: Oracle Discoverer 10g, Oracle 9i, Siebel Analytics 7.7,

Windows 2003 Server.

Project Details:

Basic objective to drive this project is to create internal reports within

Organization, some of them shared between board of director and rest of

them to analyze company's growth and to drive process and Standard.

Billing Report helps in deciding which all Contracts are eligible for

Discount & also shows the unbilled data needs to report till it gets

billed. Inventory Reports for month end stock and newly added stock.

Different type of sales report based on vehicle parts.

The strategic direction was later changed to Siebel technology based on the

extensive Industry research conducted by the company

Responsibilities:

> Involved in Repository Creation in all the three layers i.e.(Physical

Layer, BMM Layer & Presentation layer)

> Worked in creating various database objects like tables, views.

> Create Repository having different business area.

> Creation of Dashboard Pages.

> Creating various Prompts, Filters as per the requirements of the

Business.

> Modified Existing dashboards functionality like adding new filters and

Prompts as well as look and feel of the dashboard so that it look more

attractive to the end user.

> Develop report Queries and data models

> Perform administrative task including: setting up users, setting up

data sources

> Month end stock reports and its regular updating.

> Billing Reports

> Generation of monthly MIS on

Budget Vs Actual results and

analysis of variances.

> Preparation of creditors ageing & its regular updating.

> Preparation of daily report of

dispatch, sales register.

> Inventory Reports

> Open Service Requests Reports

> Overdue Service Requests Reports

[pic]

Contact this candidate