Developer Data

Name: DEEPIKA SHEELAVANTAR Email: ************@*****.***

Work Authorization: L2-EAD Phone: 408-***-****

PROFESSIONAL SUMMARY:

> Around 6 years of IT experience in Data warehousing and Business

intelligence with emphasis on Business Requirements collection and

Analysis, Application Design, Development, testing and delivery.

> Extensively utilized Business Intelligence Reporting Tools such as

Business Objects Enterprise XI R1/R2, 3.1

> Expertise in building/enhancing/migrating Universes, Retrieving data

using Universes.

> Expertise in creating Reports using Business Objects, Web Intelligence

tools.

> Experience in building Universes, Free Hand SQL methods and creating

Ad-Hoc Reports using Business Objects.

> Knowledge in building extraction, transformation and loading (ETL).

> Experience of onsite (Indonesia, Jakarta) for customer (INDOSAT)

presales activity on Business objects reports development and

analyzing.

> Extensive experience interacting with business users, business owners

for requirements gathering, analyzing business process and making

necessary changes to schema objects to fulfill reporting needs.

> Very good interpersonal and communication skills, and is experienced

in working with senior level managers, business people and developers

across multiple disciplines

> Experience as SAP Consultant i.e Business objects Enterprise trouble

shooting issues.

> Worked as a Technical co-coordinator for SAP Business Objects

Enterprise release patches Upgrade management in the whole project.

> Have Worked in Waterfall, Agile Model SDLC.

EDUCATION & CERTIFICATIONS:

> Bachelor of Science in Information science (computers) in 2005

TECHNICAL SKILLS:

ETL Tools Business Objects Data Integrator 11.7.3, BO Data Services

BI Tools: Business Objects XI R2/R3 Suit, Web Intelligence, Desktop

Intelligence, Universe Designer,

Databases Oracle 10g/11g(RAC)

Languages SQL, PL/SQL, Java

Operating Systems Linux(RHEL),Windows XP/NT

DB Tools SQL Plus, PL/SQL Developer

Scripting Language Shell scripting, Perl scripting

Enterprise/web Tomcat 5.5,Websphere 6.1

servers

Tools and Eclipse, Subversion, Maven, Clear Case

utilities

PROFESSIONAL EXPERIENCE:

Nokia Siemens Networks, Bangalore India (Feb-08 to Feb-11)

Clients: Telephonica Spain, Telephonica Columbia, Globe-Philippines,

Polkomtel (Lisbon) Indosat (Indonesia)

Roles: Business objects consultant, Senior Developer & Tester, Lead

((Product Maintenance team, Business Objects reporting team)

Description: Nokia Siemens Networks is a leading global enabler of

telecommunications services (http://www.nokiasiemensnetworks.com). Serve

atOnce Intelligence (SAI) is a data warehousing product of Nokia Siemens

Networks that provides a centralized control of a rich, near real time

network traffic data produced by several data sources like the Nokia

Siemens Networks Traffica system, SAI System can be used in the following

areas: Operations and Engineering, Marketing and Sales, Customer care,

Product Management and Third party Data ware house tools.

Responsibilities:

> Worked in creating tables using oracle for the reports data retrieval.

> Involved in creating CMS repository, BODI repository.

> Involved in developing ETL Jobs (Stage, Raw, Aggregation) using

BODI/BODS.

> Involved actively in universe design, report design.

> Developed various WebI reports as per the business requirements.

> Administered user groups, report scheduling and report security.

> Implemented Row level and Object Level security as per the user

requirement.

> Created webi reports with hyperlinks.

> Worked extensively on modules Infoview, Central Management Console.

> Created reports using Business Objects XI using functionalities like

slice and dice, drill down, @functions, cross tab, master detail,

Alerts, tables and formulas, etc

> Created on the fly adhoc reports using WEBI for business users.

> Scheduled the reports in Infoview to be sent to the users email or

folders on a daily, weekly or monthly basis.

> Worked with PL/SQL Developer of versions Oracle 11g.

> Made changes to the existing reports to improve the reports

performance.

> Involved in trouble shooting SAP BOXI product issues, follow up with

SAP support people for fixing the same.

> Worked in shell & perl scripting.

> Implemented installation, deployment of BUSINESS OBJECTS XI in

LINUX/UNIX servers and configuration

> Involved in SAP Business Objects release patches Upgrade management

Environment: Business Objects XI R2/R3, BOXI 3.1 Web Intelligence, Business

Objects Data Integrator 11.7.3/Business objects Data services, Oracle

10g/11g, XML, PL/SQL Developer, Linux (RHEL)

2) Polaris Software Labs Pvt Ltd, Hyderabad India (Aug-05 to Feb-08)

Clients: Citibank (Europe & Japan)

Roles: Business Objects Developer, tester, Module lead

Description: Founded in 1993 and publicly-listed, Polaris Software is the

world's most sophisticated banking and insurance software company

(http://www.polaris.co.in/). Polaris is the chosen outsourcing partner for

10 of the top 15 global banks and 6 of the 10 top global insurance

companies. Polaris Software is also recognized by the world's top analysts

(Forrester and Gartner) as global leaders in banking and insurance

software.

Project: Intellect Treasury is a web-based system that meets treasury

requirements in the areas of fixed income Foreign Exchange, Money markets,

Funding Swap, Interest Rate swap and Risk management. Risk management

covers the structural interest rate risk (asset/liability management)

covering liquidity, interest rate and earnings at risk. This product offers

a data warehouse reporting ability that helps to analyze business trends in

Banking and help in taking decisions.

Responsibilities:

> Involved in Interacting with users and functional analyst to gather

new requirements.

> Interacted with Business Users and Managers in gathering business

requirements.

> Involved in analyzing, documenting business requirements, functional

requirements for developing universes and reports.

> Involved in understanding the scope of application, present schema,

data model and defining relationship within and between groups of

data.

> Participated in design and development of Star schema database and

mappings between sources and operational staging targets by

identifying suitable Fact and Dimensional tables for the schema.

> Created various Classes, Objects and Measure Objects in the Universe.

Measure Objects and Dimension Objects were created keeping in view of

the end user.

> Created Contexts and aliases for resolving Loops in the Universes

> Implemented default and custom hierarchies for drill down reports.

> Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting

Reports

> Created Master/Detail Reports, Cross-tabs, Charts etc

> Migrating Universes and Reports from Business Objects XI R2 to

Business Objects XI 3.1 using Import Wizard.

> Analyzed business requirements and worked closely with the various

application teams and business teams to develop ETL jobs that are

consistent across all applications and systems.

> Made substantial contributions in simplifying the development and

maintenance of ETL by creating re-usable Source, Target, Mapplets and

Transformation objects.

> Worked as lead for Fixed Income securities module. Involved in

developing and testing SECURITY TRADING REPORTS, MONEY MARKET REPORTS

which was very much vital for clients in Fixed Income Securities

module.

Environment: Business Objects Enterprise XI R2 Designer, Business objects

WebI, Business Objects Data Integrator 11.7.3,Oracle 10g, Core Java, XML,

JSP/HTML, and JDK 1.5

ACHIEVEMENTS/CERTIFICATIONS:

> Conferred the award Polaris - 'Team Excellence Award' for the year

2006

> The 'SPOT EXCELLENCE' award in October-2007 for performance in Fixed

Income Module in Polaris.

> Conferred 'SAI AWARD' in Dec-10 for Customer Pre-sales activity in

Nokia Siemens Networks.

> Certification: Sun Certified Java Programmer 1.5

Contact this candidate