SRINIVASA BONGARALA (BOBBY) [pic]

Phone (***) *74 - 6264 . E-mail acpchg@r.postjobfree.com

OBJECTIVE

. To take up challenging and responsible position in software development

using leading edge technologies, where strong programming, analytical and

organizational skills can impact the bottom line.

SUMMARY

. Experienced in Customer Relationship management including Public

Sector, Loyalty, e-Pharma, Manufacturing, Consumer business, Sales

Force automation, e-energy, eClinical, and eCommunications.

. 14 years of strong data interfacing and Conversion, database

administration and excellent Siebel Configuration skills.

. 4 years experience implementing Siebel Loyalty module to Airline,

Cruise line and Retail clients.

. Areas of experience include: design, software

development/configuration, testing and deployment.

. Hands on experience using Siebel Tools, EIM, Work Flow, and Siebel

Server Administration.

. Hands on experience with PL/SQL, SQL Loader, Stored Procedures, Oracle

Warehouse Builder, Informatica, Data Stage IFB Files, batch scripts,

EIM scripts, UNIX scripts, SQL tuning and Automation.

. Excellent experience as a liaison between the end users and

information system staff in development of user technical and business

requirements.

. Energetic self-starter with excellent analytical, organizational and

creative skills

. Ability to work independently and fit equally well in a team.

. A competent and confident individual with a varied background who is

determined to succeed in all endeavors.

Education & Certifications

Siebel 8.0 Certified

2009

Siebel 7.0 Delta Certified

2002

Siebel'2000 e-business essentials

2001

Microsoft Certified Professional SQL Server 7.0

1999

Master in Applied Science - Concordia University, Montreal, Quebec, Canada

1999

Bachelor of Mechanical Engineering - Gulbarga University, Bellary. India.

1995

Technical Skills

Software / Products: Siebel 8.1.1.11/8.1.1.2, Siebel 7.8.2.3, Siebel

7.5/Siebel 7.0, Siebel'2000

Development Tools / Languages: C/C++, Java

Hardware / Operating Systems: Windows98/NT/2000, UNIX, Sun Solaris, AIX,

Linux

Middleware / Databases: Oracle 7x/8i/9i,10g,11i Oracle utilities, SQL

Server, MS- Access, OWB, Informatica, Data Stage

General Tools: Microsoft project, Toad, SQL Navigator, SQL Developer

PROFESSIONAL EXPERIENCE

End Client: Starwood Hotels & Resorts, CT

Oct'14 - Present

Environment: Siebel Hospitality 8.1.1.11, Open UI, Siebel EIM, Siebel

Workflow Manager, Oracle 11G, Window NT

Sr .Siebel Consultant/ Data Architect

. Led the data conversion effort for the hospitality upgrade from Siebel

8.1.1.2 to 8.1.1.11.

. Performed the gap analysis to identify the impact of data model

changes with the upgrade

. Worked closely with OES to resolve some of the data model

modifications in the upgraded repository.

. Developed & tweaked existing data conversion process including SQL's,

shell scripts, IFB files, database performance etc.

. Developed data conversion process for enhancements that were part the

Siebel upgrade.

. Developed & tweaked the entire data conversion process to load the

1200 Starwood properties into Siebel hospitality.

. Fixed Critical bugs during the SIT & UAT phases of the project.

End Client: New York Justice Center, NY

May'14 - Present

Environment: Siebel Public Sector 8.2.2.0, Oracle Data Quality 11.1.1..7.4

Siebel EIM, Siebel Workflow Manager, Oracle 11G, Window NT, Case Management

Sr .Siebel Consultant/ Data Architect

. Performed data profiling on the existing Siebel database to analyze

the quality of data.

. Familiar with Case management & Incident management in Siebel Public

sector module.

. Configured OEDQ for real time & batch address verification using

loqate files for NYJC existing public sector module

. Configured real time and batch deduplication & cleansing of Contacts

data for NYJC existing public sector module.

. Configured approximately 85 matching rules for contacts deduplication.

. Developed & scheduled several batch interfaces using Oracle PL/SQL and

windows batch jobs

. Developed several EIM jobs including IFB files to load the data into

the target base tables.

. Fixed critical bugs during the SIT & UAT phases of the project in

terms of OEDQ, EIM & Siebel batch jobs

. Closey worked oracle expert services for reviewing the OEDQ & data

interfaces and tuned OEDQ process by creating additional indexes.

End Client: Lexis Nexis, New Providence, NJ

Nov'13 - April'14

Environment: Siebel e-Media 8.1.1.2, Data Stage 8.x, Siebel EIM, Siebel

Workflow Manager, Oracle 10G, SQL Server 8.0 SSIS, Linux.

Siebel EIM / Data Architect

LexisNexis was a short term engagement to assist data migration from their

existing Siebel call center application into eMedia vertical.

. Developed DS jobs to extract data from the source Siebel call center

application database using database links and populate data into

target EIM tables of eMedia.

. Developed DS jobs to extract data from existing customer master

database and populate the data into the XREF tables.

. Developed DS Jobs to extract LOV's, responsibilities, territories,

positions and employees from the source database and populated target

EIM tables.

. Developed several EIM jobs including IFB files to load the data into

the target base tables.

. Used several transformations during the extracts and configured the

several parameter files in Data stage to connect to several data

sources.

. Developed SQL Server SSIS packages to extract data from their existing

SQL server database into the staging area.

. Closely worked with DBA/Admin team to improve the performance of

activities and camp con load by dropping indexes on EIM & base tables

and running multiple threads.

. Fixed critical bugs generated from the test build.

End Client: PETCO Animal Supplies Inc, San Diego, CA

May'11 - Nov'13

Environment: Siebel 8.1.1.3 Loyalty, Siebel Marketing, Siebel EIM, Siebel

Workflow Manager, Oracle 11G, Linux, SQL Server 8.0, SSIS packages

Data Migration Lead/EIM Lead/Data Architect

PETCO Loyalty Implementation is the application developed to promote up-

sell & cross sell opportunities and maximize long term sales as part of

their business and IT Transformation program (embark). This application

replaced their existing Loyalty Engine which was a packaged solution of

SQL. Siebel Loyalty has various Inbound /Outbound interfaces to Petco.com &

other external vendors.

. Designed, developed and executed complete data migration process for

PETCO Loyalty implementation. (~115 Million records)

. Coordinated and interacted with in house team to solidify data

requirements for data migration into Siebel.

. Coordinated with off-shore team regarding the development of any

mappings of fields etc.

. Coordinated and dictated staging table structures with the internal

CRM ONLINE, Epiphany teams to import the data into Siebel Loyalty.

. Organized JAD sessions with business & functional teams to validate

the data fields.

. Delivered a high quality design document for the entire data migration

approach & Cut over strategies.

. Performed data mappings that are required for the PETCO data migration

into Siebel Loyalty.

. Extensively used PL/SQL, SQL Loader and stored procedures for building

interfaces and data conversion.

. Developed SQL Server SSIS packages to load customers, transactions and

coupons data from Petco's existing SQL server database to Oracle

staging tables.

. Currently tuning the data migration & interfaces scripts by working

with DBA & Oracle On-Demand teams.

End Client: Starbucks, Seattle, WA

April'10 - May'11

Environment: Siebel 8.1.1.2 Loyalty, Siebel EIM, Siebel Workflow Manager,

Oracle 11G, Linux.

Data Migration Lead/EIM Tech Lead/Data Architect

Starbucks Loyalty implementation is the application developed to present

and enrich customer experience through starbucks.com and to keep track of

their stars (points), promote their tiers depending on certain business

rules with Oracle Loyalty 8.1.13. The project involved replacing of their

existing loyalty program with external vendor First Data. The other

significant feature of the application is POS transactions which checks the

card balances in real time. It is the first Loyalty implementation to go-

live for a retail client.

. Designed, developed and executed complete data migration process for

Starbucks Loyalty implementation. (~225 Million records)

. Coordinated and interacted with existing loyalty team "First Data" to

solidify data requirements for data migration into Siebel.

. Coordinated and dictated file formats with the internal Starbucks.com"

team to import the data into Siebel Loyalty.

. Organized JAD sessions with business & functional teams to validate

the data fields.

. Extensively used informatica for loading the data from flat files to

Siebel EIM tables.

. Performed data mappings that are required for the Starbucks data

migration into Siebel Loyalty.

. Extensively used PL/SQL, SQL Loader and stored procedures for building

interfaces and data conversion.

. Tuned the data migration & interfaces scripts by working with DBA &

Oracle On-Demand teams.

. Identified the tables and defined the data model for Loyalty module as

per the business requirements.

End Client: Holland America Cruise Lines, Seattle, WA

Jan'10 - Apr'10

Environment: Siebel 8.1.1.1 Loyalty, Informatica 8.0, Siebel EIM, Siebel

Workflow Manager, Oracle 10G, Window NT.

Data Migration Lead/EIM Tech Lead/Data Architect

Group of Cruise lines under Carnival exchange database for marketing

purpose on quarterly basis. As part of this interface between various

cruise lines to HAL, VIP interface was designed, developed and automated

for quarterly runs.

. Designed, developed and automated complete VIP import interface for

HAL.

. Extensively used PL/SQL, SQL Loader, stored procedures, IFB files,

batch jobs and EIM scripts for building VIP interfaces.

. Designed & developed the data scrubbing scripts to match the contacts

& address information from various sources.

. Interacted and co-coordinated with business & functional teams to

validate the correctness of data.

. Tuned the VIP import interface to assure minimal impact on the daily

batch jobs.

. Fixed critical bugs generated from the test build.

End Client: Southwest Airlines, Dallas, TX

April'08 - Apr'10

Environment: Siebel 8.1.1 Loyalty, Siebel EIM, Siebel Workflow Manager,

Trilium, Oracle 10G, Sun Solaris.

Data Migration Lead/EIM Tech Lead

Southwest call center & Loyalty implementation is the application developed

to help their call centers to keep track of the contacts and service

requests with a data conversion of mileage plan from existing rapid rewards

database to Oracle Loyalty 8.1.1.

. Responsible for complete data conversion and interfaces.

. Designed, developed, deployed and automated various interfaces. (SWA

HR interface, Bulkmail Interface and SWA HR Employee Conversion).

. Extensively used PL/SQL, SQL Loader and stored procedures for building

interfaces and data conversion.

. Identified the tables and defined the data model for Loyalty module as

per the business requirements.

. Performed data mappings and defined the file formats that are required

for the data conversion and data interfaces.

. Complete ownership of designing, developing, deploying the entire data

interfaces.

. Fixed critical bugs generated from the test build.

. Designed, developed and deployed partner inbound file processing.

(Chase).

. Designed, developed and deployed various workflows and Webservices as

part of interface integration. (Payment Preferences & Partner

affiliations)

End Client: Holland America Cruise Lines, Seattle, WA

Mar'09 - Sep'09

Environment: Siebel 8.1.1.1 Loyalty, Siebel EIM, Siebel Workflow Manager,

Oracle 10G, Data Quality and Window NT.

Data Migration Lead/EIM Tech Lead

(Worked simultaneously on SWA & HAL data conversion projects).

HAL Loyalty Implementation is to replace an existing third party data

vendor (BOWNE) and in-house the marketing database thereby enabling to run

an effective Siebel Loyalty program and retain the customer base by running

marketing campaigns, house holdings and reporting.

. Led a team of 2 EIM developers for huge data conversion from external

vendor BOWNE to Siebel Loyalty.

. As part of data conversion, migrated Contacts(~28-29M),

Households(~20M), VIP Cruise History (~32 M), Contact Addresses(~26-

27M), Loyalty Members (6-7 M), Loyalty transactions (10M),

fulfillment, history (~2M), Contact Survey Preferences (~12 M),

Voyages, products, ships, cruise history agreements, Household Level

summary (Addresses, marketing suppress flags), Bookings(Orders),

Booking details, accounts etc.

. Tuned PL/SQL & EIM Scripts to load 140 Million records in 54 hrs into

Siebel

. Developed several EIM jobs/batch interfaces and enabled DQXI cleansing

tool on input data

. End to end testing of Siebel EIM batch interfaces

. Worked with DBAs to enhance the database performance on several

occasions during full data migration testing cycles.

. Worked on many existing data fixes as part of Maintenance.

Client: Alaska Airlines, Sea-Tec, WA

Nov'06 - Mar'08

Environment: Siebel 7.8.2.3 Loyalty, Siebel EIM, Siebel Workflow Manager,

Tibco, Oracle 10G, Oracle Warehouse Builder (OWB) & Window NT.

EIM Tech Lead/ Data Specialist

Alaska Airline Loyalty implementation is conversion of existing Mileage

Plan System from Mainframes to Oracle Loyalty 7.8.2.3. This is the first

project in US to implement Oracle Loyalty module. It also consisted of

integration from various legacy systems like AS.com, PIT, Points.com, VRU,

TSA, OCRA and Image.

. Responsible for complete data conversion from mainframes into Oracle

Loyalty.

. Extensively used OWB (Oracle ware house builder) for data conversion.

. Identified the tables and defined the data model for Loyalty module as

per the business requirements. Performed data mappings and defined the

file formats that are required for the OWB.

. Complete ownership of designing, developing, deploying the entire data

conversion process.

. Developed scripts for Liability Validations of member & transaction

level attributes. Achieved 0% tolerance of miles before and after and

data conversion.

. Worked very closely with Infrastructure group to tune the data loading

process by implementing various techniques.

. Loaded heavy volume data ranging to 110 Million records and could

achieve a data loading speed of 1.6 million records/hr.

. Designed and deployed Delta data loading process after the initial

data loads during the cut over weekend.

. Designed, developed, deployed and automated the outbound interface

from Siebel to external vendor "WhatCoutnts" to generate the e-

statement for the Mileage plan members.

. Built Administration screen for the business users to manage and

maintain Seed data. (Ex: Products, Partners and Partner Contacts)

. Fixed critical bugs generated from the test build.

Client: Organon Pharmaceuticals, Roseland, NJ

Sep'04 - Oct'06

Environment: Siebel 7.5.3 e-Pharma, Siebel Remote Administration, Siebel

EIM, Siebel Workflow Manager, Oracle 9i & UNIX.

EIM Tech Lead/ Data Specialist

Organon project was a re-alignment of sales force with the launch of new

contraceptive "Implanon. Designed, developed, and tested end to end data

migration for this initiative.

Client: Cadbury Schweppes, Siebel e-Consumer, Parsipanny, New Jersey

Apr'04 - Sep'04

Environment: Siebel 7.0.5, Siebel Configuration, Siebel EIM, Oracle 9.2,

SAP & Windows NT

Sr. Siebel Consultant

Cadbury Schweppes project involved Siebel e-Consumer 7.0.5. It involved

the entire conversion process of Products, Accounts, baseline and shipment

data from Pfizer back end SAP system into Cadbury back end SAP system and

integration with Siebel 7.0.5. Intensively used build trees (Sales Volume

Planning) to help the management to forecast their plans and promotions and

allocate the funds accordingly.

Client: Symantec, Call Center Siebel Implementation, Springfield, Portland

Sept'03 - Mar'04

Environment: Siebel 7.5.2, Siebel WF Manager, Siebel EIM, Oracle 9.2, First

Logic & Windows NT

Sr. Siebel Consultant

Symantec project involved upgrade of Siebel Call Center Application from

Siebel'2000 - Siebel 7.5.2. Various partners to Symantec were managed in a

separate application called "Partner net" in Dublin, UK. During this

upgrade to Siebel 7.5.2, Symantec did a huge conversion exercise to bring

in all the partners into Siebel and bi-directional interface with Partner

net database.

Client: AT & T, eCommunication Siebel Implementation, Middletown, NJ

May'03 - Aug'03

Environment: Siebel eCommunication 7.5.2, Siebel Workflow Manager, Siebel

EIM, Oracle 9.2, Data Stage & Solaris Environment.

Sr. Siebel Consultant

AT & T project involved design and implementation of Siebel eCommunication

7.5.2 for porting its Sales and Marketing applications to CRM (Customer

Relationship Management). Siebel eCommunication acted as a tool that

enhances the pre-sale workflow process from customer Needs Assessment

experience using advanced applications platform to form CRM's Design Price

Propose and Contract (DPPC).

Client: INGENIX eClinical Siebel Implementation, Basking Ridge, NJ

Oct'02 - May'03

Environment: Siebel eClinical 7.5, Siebel Workflow Manager, Siebel EIM,

Oracle 9 & AIX.

Sr. Siebel Consultant

Project involved upgrade of Siebel eClinical 6.3 to 7.5. The system is

used to support and capture pre-study qualification information and

tracking of regulatory documentation for sites and investigators. It will

provide the capability to track the status of pre-study site visits and

their outcome (i.e. site recommended or rejected). Siebel eClinical

provides the capability to track investigators and also maintain detailed

information such as multiple addresses, state licensure, site background

information, etc.

Deloitte Consulting . Toronto . Canada

Dec'99 - Oct'02

Senior Consultant CRM practice

KFNA Siebel Implementation, Toronto, Canada

Mar'02 - Oct'02

Kraft Canada Inc., Toronto, Canada

Oct'01 - Mar'02

NPower, Birmingham, UK

Jun'01 - Aug'01

General Motors - Canada, Oshawa, Canada

Mar'01 - Jun'01

Bell Actimedia, Montreal, Canada

Jan'01 - Mar'01

General Motors - Canada, Oshawa, Canada

Dec'99 - Dec'00

Contact this candidate