Post Job Free

Resume

Sign in

Project Sql

Location:
United States
Posted:
February 19, 2013

Contact this candidate

Resume:

RESUME

Name : Indu Unni

Mobile-No : 214-***-****

Email-Id : aboezq@r.postjobfree.com

Summary:

* ***** ** ********** ** analyzing, designing, developing, implementing and

testing of various client/server and web-based applications which include

Siebel Power Communication and Siebel Call Center.

Three years experience in monitoring and developing DB using SQL and

PL/SQL. Also development of web pages using HTML, PHP and CSS.

Technical Skills:

CRM : Siebel Power Communication and Call Center

Operating Systems : Windows 07/Vista/98/00/NT/XP, UNIX

Programming : C/C++, HTML, Java basics, CSS, PHP

Databases : Oracle 10g, SQL plus, PL/SQL, MS-SQL Server

7, DB2

Tools : MS Office

ETL Tools : SQL Loader

Professional Experience:

Accenture Services Pvt Ltd.

Bangalore,India

Role: Siebel Developer.

Responsibilities:

. Configured UI elements like Screens, Views, Applets and objects like

Business Components, Links, MVG, Pick Applet and Picklists.

. Configured workflows to update a particular flag in asset BC when the

line item was being deleted during asset Modification.

. Configured Symbolic URL in order to display error messages through

scripts and workflows.

. Created static, Dynamic Picklist, Constrain Pick List and Hierarchical

Picklist to check the status of a quote.

. Worked on Performance by monitoring the various transitions of the

application from 1 view to the other that covered all the major

screens.

. Created form applets using the ATTRIB_XX columns of the extension

table.

. Involved in implementing Access Control Mechanism according to

BusCompViewMode and Visibility Applets.

. Created links between the parent business components and child

business components when designing master-child views based on this

link.

. Ran Genb Scripts for Browser Scripts.

. Applied applet level and BC level user properties.

. Created Custom buttons in form and list applets.

. Worked with data maps.

. Created User Defined Messages for displaying custom error messages.

. Created Quotes and Orders for the client.

. Used position and Organisation to distribute the functions among the

different users so that visibility is restricted.

. Worked with view personalisation.

. Created Workflow policies and executed them.

. Performed SQL Queries on the DB to analyse the performance of the

application and also to insert or update and delete values for testing

and development purposes.

. Extended columns in base tables and interface tables in the database.

Created custom extension tables.

. Performed Oracle Reviews on the existing Codes, Workflows and BS in

order to check whether they are in compliance with the best practices.

. Written test scripts for unit testing of the developments.

. Written test scripts for Regression Testing of the existing

functionalities.

. Designed and Documented Technical Documents for all the development

and configuration changes made for each requirement.

. Done Peer Review of the Developments made and Test Scripts written by

my peers.

. Taken sessions for my peers related to Multi-Lingual and Multi-

Organisation in Siebel.

. Prepared Functional Document of the whole functionality of the

project.

. Good knowledge in Oracle RDBMS and Normalization Techniques.

. Used Oracle Analytical functions like ROW_NUMBER, FIRST_VALUE.

. Involved in project planning and scheduling, System Design, Functional

specification, Design specification, Preparation of impact analysis,

Coding, System Test Plan, User Acceptance Testing (UAT), Code Review,

coordinating user training and user testing, Project demonstration,

Implementation, Maintenance.

. Expert in performing DCL Commands like Grant and Revoke of Privileges.

. Applied MySql to manage DB2 for development environment.

. Helped optimise the application using PL/SQL procedures and functions

to perform a check on the data inserted every time save action was

performed.

. Created packages for relevant for the application.

. Applied Sql for creating and managing a DB that was created as part of

the college project for an event.

. Created web page using HTML, PHP and CSS and to update the DB online.

. Applied performance tuning methods to reset the HWM and to improve the

overall performance.

. Used bulk collect instead of cursors to reduce the number of

handshakes between SQL & PL/SQL engines and hence improved the

performance.

. Worked and involved in gathering business requirements, designing

technical and functional requirements, along with solutions and its

reviews.

. Excellent analytical, problem solving, communication and inter-

personal skills to manage and interact with my peers.

. Able to interact effectively with members of other teams involved with

the System Development Life cycle.

. Worked and involved in gathering business requirements, designing

technical and functional requirements, along with solutions and its

reviews.

Environment: Siebel Client 8.0,Siebel Tools 8.0, Siebel Tools 7.x,Siebel

Client 7.x, Siebel Call Center, eConfigurator, Power Communications, Siebel

Tools, eScripts, Personalisation,Workflow Process Manager, Catalog

Administration: IBM DB2, PL-SQL, Oracle 8.x.

Education:

Bachelor's Degree in Electronics and Communication



Contact this candidate