Ronald S. Andrade

abhtjj@r.postjobfree.com

916-***-****

OBJECTIVE As a Siebel Developer seeking a challenging technical

position in the area of Customer Relationship Management.

SKILLS:

CRM

SIEBEL 8.0/7.8//7.7/7.5/2000, SIEBEL Tools, Siebel VB,

EIM, EAI, Escript, WorkFlow, Siebel Sales, Siebel Call

Center, Siebel Finance, Siebel eChannel(PRM), Actuate 6.0

ERP

SAP R/3 Abap/4, Menu Painter, Screen Painter, Dialog

OP. SYSTEMS Programming, Data Interfaces, BDC, Interactive Reporting,

SAP Script, ALE, EDI, RFC

SOFTWARE Windows XP, Windows NT, Windows-2000, Unix, OS/400,

MS-DOS, Novel NetWare.

Visual Basic 6.0, Abap/4, RPG/400, Cobol/400, CL/400,

SQL/400, DB2/400, Oracle, PL-SQL, FoxPro, Java, HTML, MS

Word, MS Excel.

WORK EXPERIENCE

Fourteen years in analysis, design & development, System Testing,

Programming in which last 9 years in Siebel environment as a

Configurator/Developer. I have extensive experience in Customizing the

Siebel Applications using Siebel Tools, Siebel VB, eScript and creating

reports using Actuate.

September 2009 to Current US CONCRETE

(client)

Siebel Sales

Environment: Siebel 8.0, Siebel Tools, eScript, ORACLE, Windows XP.

Responsibilities :

. Understanding customer business process and requirements.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services,

EBC, Workflow etc. Extended existing tables by adding new columns.

- Used User Properties to avoid using scripting.

. Used Escript to configure and enhance Siebel Applications functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

. Trouble Shooting/Fixing Issues

. Merging Repository/SRF from Development to Production environment.

. Involved in Maintenance, Testing, Debugging, Performance Tuning and

writing Technical Documentation.

October 2008 to July 2009 CITRIX SYSTEMS

(client)

Siebel Call Center

Environment: Siebel 7.8, Siebel Tools, eScript, SQL Server, Windows XP.

Responsibilities :

. Understanding customer business process and requirements.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services etc.

- Extended existing tables by adding new columns

- Used User Properties to avoid using scripting.

. Used Escript to configure and enhance Siebel Applications functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

. Created Business Service :

- to delete records from different BC based on user selection criteria

- to update fields on a Business Component based on field values from

other BC

- to update Owner field in eService BC, if it is null.

- to update Partner Order Type if it is null.

. Trouble Shooting/Fixing Issues

. Created Runtime Events to execute Business Services.

. Used EIM to Delete duplicate activities

. Involved in Testing, Debugging, Performance Tuning and writing Technical

Documentation.

October 2007 to August 2008 VISION SOLUTIONS

(client)

Siebel Call Center

Environment: Siebel 7.8, Siebel Tools, Siebel VB, eScript, SQL Server,

Windows XP.

Responsibilities :

. Understanding customer business process and requirements.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services etc.

- Extended existing tables by adding new columns

- Used User Properties to avoid using scripting.

- Created several calculated fields.

. Used Escript to configure and enhance Siebel Applications functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

. Trouble Shooting/Fixing Issues

. Involved in Testing, Debugging, Performance Tuning and writing Technical

Documentation.

June 2004 to JULY 2007 AIM INVESTMENTS (client)

Siebel Finance (CSC)

Environment: Siebel 7.8, Siebel Tools, Siebel VB, eScript, SQL Server,

Windows XP.

The CSC project was heavily customized to include all the features and the

functionality of client's existing home grown CRM application into Siebel

Application.

Responsibilities :

. Understanding customer business process and requirements.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services etc.

- Created New Tables and Extended existing tables by adding

new columns

- Created New Table to store Risk Factors

- Used User Properties to avoid using scripting.

. Used Escript/Siebel VB to configure and enhance Siebel Applications

functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

- Wrote script to check overlapping dates for Contact Phone Numbers

and Address.

- Wrote script to set the primary phone/address based on start and

end date

- Wrote script to create Prospect/Household from Contact

- Wrote script to calculate Remittance Date based on Payment

Frequency

- Wrote script to populate combined name based on more than one

contacts

. Created Business Service

- To retrieve and display external customer data into

Siebel applets.

- To retrieve the last Account Number, Client Code, Household

code, Prospect Code

- To Terminate a Client and Update information on related

external Tables.

- To send email request to give Access permission to selected

Portfolios.

. Involved in testing, debugging, Performance Tuning and writing Project

Documentation.

Siebel Sales (WINS)

Environment: Siebel 7.7, Siebel Tools, Siebel VB, eScript, SQL Server,

Windows XP.

WINS was developed to allow client's Sales representatives to interact and

keep an up to date information about their customers. WINS was integrated

to clients existing home grown CRM application MARS. 1st phase of the

project was to upgrade the WINS to Siebel 7.7 version. 2nd phase of the

project was to decommission MARS and incorporate all the MARS

functionality in WINS.

Responsibilities :

. Involved in upgrading the Siebel 7.5 application to Siebel 7.7 version.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services etc.

- Created New Tables and Extended existing tables by adding

new columns

- Used User Properties to avoid using scripting.

. Used Escript/Siebel VB to configure and enhance Siebel Applications

functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

. Created VBC/Business Service

- To retrieve and display external customer data into Siebel

applets.

- Dealer Notes, Contact Notes, Location Notes, Order

info etc.

- To update external MARS tables depending on user action.

. Maintaining Correspondence, Proposals.

. Involved in testing, debugging and writing project documentation.

. Production support and Maintenance.

. Used Siebel enterprise application to create Positions, Employees,

Responsibilities,

Registering View, Assigning View to Responsibilities etc.

Siebel Sales (DSS)

Environment: Siebel 7.7, Siebel Tools, Siebel VB, eScript, SQL Server,

Windows XP.

DSS was developed to allow client's Sales representatives to interact and

keep an up to date information about their customers, customer survey etc.

Responsibilities :

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, MV Links, Business Object,

Business Services etc.

- Created New Tables and Extended existing tables by adding new

columns - - Used User Properties to avoid using

scripting.

. Used Escript/Siebel VB to configure and enhance Siebel Applications

functionality.

- Wrote Browser Scripts for interactive actions, Custom Buttons and

data validations.

- Wrote Server Scripts for data validation and data manipulations.

. Created several calculated fields to calculate Risk Score based on client

survey.

. Involved in testing, debugging and writing project documentation.

February 2004 to May 2004 McKesson Information Solution

(client)

Siebel Sales

Environment: Siebel 7.5, Siebel Tools, Actuate 6.0, Escript, Oracle.

Responsibilities :

. Understanding customer business process and requirements.

. Interacting with Users, Business Analysts in support of applications -

including requirement definition, problem resolution & training.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created/Modified Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, Business Services etc.

- Customized Account, Contact, Opportunity, Quote, Order Entry

Applets.

. Used Escript to configure and enhance Siebel Applications functionality.

- Wrote Browser Scripts for interactive actions and data validations.

- Wrote Server Scripts for data validation and data manipulations..

. Created and Modified reports for Siebel applications using Actuate,

version 6.0.

- Created Master Detail reports, Parameterized reports, Memory

Sorted reports,

Combined Data Stream reports etc.

- Contract Supplement, Budgetary Quote, Sales Order, Opportunity

Planner, Opportunity Detail

. Involved in testing, debugging and writing project documentation.

September 2003 to December 2003 Network Appliance

(client)

Siebel Sales/eChannel(PRM)

Environment: Siebel 7.5, Siebel Tools, Actuate 6.0, Escript, Siebel VB,

Oracle.

Responsibilities :

. Creating Organizations, responsibilities, Positions, Employees, Access

Groups, Categories, Partner Registration, Personalization and configuring

visibilities in eChannel to restrict the partner access to information.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created New Business Components, Screens, Views, Applets, MVG

Applet, Pick

Applets, Pick Lists, Joins, Links, Business Services etc.

. Used Escript/Siebel VB to configure and enhance Siebel Applications

functionality.

- Wrote Escript to add internal employee to Partner's Opportunity

Sales team.

. Created Workflow policy to send email to partners when an opportunity is

assigned to them.

. Created and Modified reports for Siebel applications using Actuate,

version 6.0.

- Quote, Account Profile etc.

. Involved in testing, debugging and writing project documentation

May 2003 to August 2003 Dantz Development Corporation

(client)

Siebel Call Center

Environment: Siebel 2000, Siebel Tools, Siebel VB, SQL Server.

Responsibilities :

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created or Modified Business Objects, Business Components,

Standard and

Custom table extensions, Screens, Views, Applets, LOV, Predefined

Queries etc.

. Used Siebel VB to configure and enhance Siebel Applications

functionality.

November 2002 to April 2003 Vision Solutions (client)

Siebel Call Center/eChannel(PRM)

Environment: Siebel 7.5, Siebel Tools, Actuate 6.0, Escript, SQL

Server, Windows XP.

Responsibilities :

. Involved in the Upgrade process from Siebel 6 to Siebel 7.5.

- Analyzing Siebel 6 application with Sebel 7.5 applications.

- Analyzing and Categorizing script into Server Script/Browser Script.

- Adding missing Applets, Views, Screens, Fields to 7.5 applications.

- Mapping applets, Views to Web Templates.

- Mapping fields to the Web Templates place holders.

- Modifying the existing Business Component, Applets, Views, Screens.

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Customized Account, Contact, Opportunity, Quote, Order Entry, Asset,

Campaign, Forecasts Applets.

. Created new Applets, Views as well as modified the existing applets in

eChannel

. Used Escript to configure and enhance Siebel Applications functionality.

- Wrote Escript for calculating Discount, Tax etc for Order Entry.

. Created and Modified reports for Siebel applications using Actuate,

version 6.0.

February 2002 to October 2002 Bessemer Trust (client)

Siebel Finance

Environment: Siebel 7, Siebel Tools, Actuate 5.0, Escript, Siebel VB,

Oracle, Windows NT.

Responsibilities :

. Used Siebel Tools to customize the Siebel Applications according to

Customer requirements.

- Created and Modified Business Objects, Business Components,

Standard and

Custom table extensions, Screens, Views, Applets etc.

. Created VBC/Business Service to retrieve and display external customer

data into Siebel applets. Used Escript/Siebel VB to configure Siebel

Applications in accordance to user requirements including data

validation, forcing business rules etc.

. Created and Modified reports for Siebel applications using Actuate,

version 5.0.

- Created and Modified report objects (.rol) in Siebel Tools.

- Modified standard Siebel reports by sub-classing existing reports

and added new

fields.

- Created Master Detail reports, Parameterized reports,

Combined Data Stream:

Contact Profile, Contact Summary, Account Governing

Provision, Officer's Committee Report,

Accounts/Sub-Accounts, Closed Accounts, Relationship,

Client Relationship Profile etc.

- Used Actuate Basic to override Actuate methods (Fetch, Start,

Finish etc.) in order to change the report functionality.

. Involved in Testing, Writing Specification and Project Documentation.

Mar 1996 to May 2001 ADVANCED COMPUTER SERVICES

Nov 96 to May 2001 LUCENT TECHNOLOGIES. (Project through IBM

Global)

Financial and Treasury System

Environment : AS/400, RPG/400, RPG IV, ILE RPG, CL/400, SQL/400, QUERY/400,

VB

Role : Development & Maintenance

July 96 to Oct 96 FRIGIDAIRE (Client)

Purchase, Sales & Production (PSP)

This system consists of Purchase, Sales Production and Inventory modules.

Environment : AS/400, RPG/400, RPG IV, ILE RPG, CL/400, SQL/400, QUERY/400,

VB

Role : Development & Maintenance

March 96 to June 96 COMP USA (Client)

Merchandise Management System

Environment : AS/400, RPG/400, RPG IV, ILE RPG, CL/400, SQL/400, QUERY/400,

VB

Role : Development & Maintenance

EDUCATION

. Bachelor of Science

STATUS

. US Citizen

Contact this candidate