Sr.Siebel Data Architect /Big Data Consultant
Resume:
SRINIVASA BONGARALA (BOBBY) [pic]
Phone (***) *74 - 6264 . E-mail *****@************.***
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