Developer Software

Yogini Jobanputra

**** *** **** ***,

408-***-****)

Fremont, CA-94538, US

************@*****.***

SKILL SET

1. . Relevant Computer Skills: Siebel Analytics/OBIEE, ETL (Informatica),

Database Modeling OLAP, Data warehouse Application console (DAC), Siebel

CRM,extensive PL/SQL skills, Perl, Oracle Application

2.

CERTIFICATION and AWARDS

. Siebel Analytics Certification training

. Oracle Certified Associate (OCA)

. Award for best project implementation

. 100% CSI for projects implemented in Honeywell and multiple

appreciations from client & managers

. Top score for project work as intern at TCS - 91%

EXPERIENCE

United States, California - Sr. Software Programmer Feb

'09-till date

Client - AT&T, Accenture Technology Solutions Ltd

. Assisted in architectural design

. Interacted with clients and prepared detailed design and test cases

. Developed application components using informatica, PL/SQL & Unix

United States, Phoenix - Software Developer/Analyst Oct

'07-Mar'08

Client - Honeywell, Tata Consultancy Services Ltd

. Lead a Team of 4 and successfully implemented the project in

production

. Interacted with the clients and prepared detailed Requirement

Documentation, Functional & technical Design document, Test Cases and

deployed and implemented Multi-Organization structure using Siebel

Tools, Siebel Analytics Tools(RPD), PL/SQL & ETL development

(Informatica).

. Analyzed, Designed, Developed, Queried and tested Data models

. Developed Siebel reusable automated programs and EIM for data

migration using MS Excel for new organizations to move data and merge

processes in the base application.

. Configured Administration tool. Built organization wide security model

based on the runtime information from Siebel using Groups,

Initialization block and session variables of Siebel Analytics

. Designed & Built SLA Dashboards, reports and queries and worked on

Siebel Answers, iDelivers and iBots

. Worked on Production support team to handle business users. Handled

release activities for Siebel & Analytics.

India, Mumbai - Software Developer

Feb '07-Sep'07

Client - GE Aviation, Tata Consultancy Services Ltd

. Implemented full life cycle development of Siebel Analytics.

. Analyzed, Designed and developed data models - star schemas and other

snowflake schemas using Siebel Analytics administration tool. Created

test plans and tested the application.

. Worked on Informatica for creating maps to load both Full and

Incremental data in OLAP and change capture maps to facilitate

Auxiliary changes

. Setup and Configured DAC from scratch for sequencing and scheduling

Informatica workflows.

. Conducted multiple training sessions on Siebel Analytics to share

knowledge with other team members.

. Built Dashboards & reports based on user requirements

India, Mumbai - Software Developer

Dec '05-Jan '07

Client - GE Aviation, Tata Consultancy Services Ltd

. Worked on Opportunity-Quote to Order to help enhance the application

to improve effective execution of sales cycle.

. Worked on call center application to handle Service Request.

. Developed and enhanced the integration module to improve the

performance.

. Configured Siebel as per requirements which included configuration,

User Interface (UI), scripting - eScript, integration with other

application, EAI, XML, EIM, Smart Scripts with extensive use of

PL/SQL.

. Configured assessment module to build a new method to capture

assessment details using smart script which was dynamic in nature.

. Developed functional test cases to cover all the business scenarios.

. Performed both Unit & integration testing. Integration testing was

done to check all the inbound and outbound test cases.

India, Mumbai - Oracle Application Developer

Aug '05-Nov '05

Client - GE Aviation, Tata Consultancy Services Ltd

. Responsible for developing and enhancing the existing process using

PL/SQL.

. Built reports using Oracle Report builder.

. Worked on parts of GL and AP modules.

India, Mumbai - ERP System Jun

'04-Mar '05

Tata Consultancy Services Ltd

. Involved in development of Marketing and Sales module of integrated

ERP system using SQL, PL/SQL, and Java.

. Expertise in PL/SQL coding through various procedures, packages,

views, cursor, DBLinks, Triggers, creation of tables to implement

business logic.

EDUCATION

VJTI, Mumbai University

Masters of Computer Application (MCA) - June 2005

SPONSORSHIP - Authorized to work in US without any sponsorship

Contact this candidate