Summary

Of the 22 years of experience, Raghav has twelve years of experience exclusively in Siebel and OBIEE technologies alone. He has delivered multiple full life cycle projects to clients like CITI BANK, E*TRADE, DEUTSCHE LEASING, HONEYWELL, GENERAL MOTORS, P&G, ETHICON ENDO SURGERY, LEXIS NEXIS AND NATIONAL ARCHIVES, GENERAL ELECTRIC and FIFTH THIRD BANK in various capacities. He has been a Project Manager, Application Architect, Infrastructure Architect and Integration Architect for major Siebel Initiatives. He was a principal architect for P&G and a Solution Architect for both GE Energy and Aviation Businesses. Raghav has architected & delivered a Metrics solution for Diagnostics Application in Java/J2EE technology for the GE Aviation businesses.

Raghav is currently Siebel CRM, OBIEE and BI Pub Lead in Fifth Third Bank.

Skills
CRM Products

Siebel
SIEBEL Technology

All versions upto 8.1, Siebel Tools, EAI (Workflow, Business Services, Web Services), EIM, eScripting, Siebel Visual Basic, Data Modeling, Installation, Server Administration and Remote Administration, Siebel Upgrade, Siebel Configuration, Siebel Customization, Siebel Data Mapper.

BI

OBIEE 10.1.3.4, Answers, Dashboards and iBots, Oracle BI Apps and DAC/ETL/Informatica

LANGUAGES

C, C++, Windows SDK, VC++, C#, HTML, DHTML, VBSCRIPT, JAVASCRIPT, ASP, BOURNE SHELL SCRIPT, AWK, COBOL, SQL/PL-SQL, DOS PROGRAMMING.

JAVA SKILLS

Was Sun Certified, Java, JSP, Message Driven Beans, Java Tag Libraries, Struts, Hibernate, JSF, SPRING, JBoss, Eclipse

OPERATING SYSTEMS

UNIX (SOLARIS, HP, AIX), MS WINDOWS, MS-DOS.

DATA BASE SYSTEMS

ORACLE, SQL SERVER and DB2

PROJECT MANAGEMENT

MS PROJECT 2000

INDUSTRIES

Automobile, Banking, Consumer Goods, Life Science, Energy, Aviation

Reports

Crystal Reports, Actuate Reports and BI Publisher

Employer : Confidential
Location: Cincinnati, OH

Aug 2010 – Till Date

Fifth Third Bank uses Siebel CRM for Customer and Prospect Management, Opportunity and Campaign Management. Siebel CRM is also used for New Product Boarding and Service Request management.

Bank also uses Siebel Analytics Products to report various

• Pipelines and Revenues
• Service Requests
• New Product Boarding
• Activities

In terms of Companies, Relationships, Affiliates, Lines of Businesses, Positions (Primaries & Teams) and time dimensions.

Role: OBIEE and BI Pub Architect

Responsibilities:

• Work with users to develop new Subject Areas and associated dashboards and adhoc Answer queries.
• Design presentation layers, business model & mapping layer and physical layer to cater to the new Subject Areas and Dashboard requirements.
• Performance Tune dashboards and reports using techniques like caching and factless fact table designs.
• Design & Performance Tune new ETL jobs to improve dashboard performance.
• Transform all Actuate reports into BI Pub reports.

Highlights:

• Revived the Siebel Analytics delivery which was halted for more than 1 year for lack of right resources. This included both DAC/ETL and OBIEE application.
• Led the design, development and deployment of OBIEE application in Dev, Test, Stage and Prod environments.
• Led the design, development and deployment of Siebel application in Dev, Test, Stage and Prod environments.
• Led the design, development and deployment of BI Pub Reports in Dev, Test, Stage and Prod environments.

Technologies: Siebel 8.1.1.3.x, OBIEE 10.1.3.5 and DB2 UDB.

Client: Confidential
Location: Cincinnati, OH
Employer: Genpact

Nov 2009 – July 2010

Both GE Energy and GE Aviation use Siebel for Sales, Marketing and Call Center requirements of the business.

Role: Solutions Analyst – Infrastructure

Responsibilities:

• Provide technology leadership and advice on the best use of Siebel technology.
• Architect and design Siebel and related technologies with data integrity, robustness, performance, scalability, high availability and maintainability.
• Create and maintain architecture documents, drawings and other collaterals.
• Take ownership of all technical issues related to both Application and Infrastructure.

• Deploy technologies by following reference architecture models, methodologies and best practices.
• Manage large-scale project and deliver within estimated timelines.

Highlights:

• Led the deployment of OBIEE application in Dev, QA and Prod environments.
• Led the deployment of Siebel application in Dev, Test, QA and Prod environments.
• Architected the Secure Enterprise Search product

Technologies: Siebel 7.8.x, OBIEE 10.1.3.5, Siebel Analytics 7.8.4, Secure Enterprise Search 11.1.2 and Oracle 9i.

Client: Confidential
Location: Cincinnati, OH
Employer: Confidential

Sep 2008 – Oct 2009

Ethicon Endo Surgery (EES) uses Siebel Life Science module to monitor their product defects and report to Federal Authorities. When customer calls with a Product Issue (PI), a call center agent creates a Service Request and depending upon the severity of the call a Product Issue is created. Business ensures that each PI is tracked to closure and is reported to FDA through eMDR module. Legacy systems feed Siebel with Accounts, Products, Assets and other relevant data and Siebel remains the system of records. Various interest groups and stakeholders pull reports from Siebel analytics as charts, tables and as iBOTS.

Role: Siebel Integration Architect

Responsibilities:

• Architect, Design and Development of interfaces to load entities like Accounts, Products and Assets from legacy applications to Siebel using Informatica and EIM processes.
• Architect, Design and Development of Workflows and Business services to cater to various business requirements.
• Architect, Design and Development of Siebel Inbound and Siebel Outbound Web services.
• Development of Integration Objects and Data Maps.
• Development of Actuate reports.

Highlights:

• Could successfully lay out the flow of data from external system to Siebel and to Siebel Analytics Application through multiple technologies.

Technologies: Siebel 7.7.x, Siebel EAI, Siebel eScripts, Oracle 9i, Actuate Reports.

Client: Confidential
Location : Cincinnati, OH
Employer : Confidential

Apr 2007 – Aug 2008

GE monitors their engines fitted in aircrafts of various carriers through a diagnostics system. Since their diagnostics system is not able to cater to their expanding business, there is an acute requirement for a reliable metrics system to monitor its performance. The project was to provide a comprehensive framework to reliably monitor / metric the diagnostics system wing–to-wing. The diagnostics system is an ecosystem consisting of various programs, databases, UI and network systems.

Role: Project Manager and Solution Architect.

PM Responsibilities:

• Identify pain points in the diagnostic system
• Provide a plan to instrument various module.
• Identify various phases and their timelines to execute the project.
• Monitor various deliverables and their timelines.
• Manage Risk

Solution Architect Responsibilities:

• Reverse Engineer all applications and lay it out from end to end.
• Identify all the points of instrumentation.
• Strategize & design framework for Metrics collection, routing and storage.
• Design individual components and monitor their development
• Derive capacity requirements
• Metrics Database Design and integrity check.
• Design & Implementation Message Driven Beans in UNIX and Windows based JBOSS App Server.

Highlights:

• Reverse Engineer C++, Visual Basic and Java programs to identify the metric points.
• Rewrote the Message Driven Beans code written for Windows based JBoss to Unix Based JBoss
• Metrics Project was delivered successfully inspite of its dependency on multiple other projects.

Technologies: JBOSS 4.0.5, J2EE 1.4.2, Oracle 9i, C++, Cognos 8 reports.

Client: Confidential
Location : Dayton, OH
Employer : Confidential

Oct 2006 – Mar 2007

Lexis Nexis uses Siebel eSales module as their Sales Force Automation Tool. The application has been integrated with host of legacy systems. Project also involved developing ASP applications based on the Siebel data source.

Role: Project Lead and Integration Architect

Responsibilities:

• Develop ASP application using Siebel exposed Com Objects
• Design various workflows and interfaces to import data from legacy applications.
• Devise a strategy to merge Siebel records through EIM.

Highlights:

• Could successfully integrate Siebel COM objects into ASP application when Infosys Resources (Microsoft Guru’s) and HCL resources (Siebel Guru’s) both were struggling to understand each other’s technology.
• Could conclusively with metrics tell that a WF was not a bottleneck when every one was spending time and resources to tune its performance.

Technologies: Siebel 7.8.2.x, EAI / eScript, MS SQL 2000, Actuate Reports

Client: Confidential
Location : Blue Ash, OH
Employer : Confidential

Apr 2006 – Sep 2006

Ethicon (EES) uses eConsumer module to monitor their product defects. Trending and Thresholding (TNT), one of their critical modules needed to assess the occurrence of product defects, was not available ‘Out of Box’ in Siebel. Hence this module was developed and integrated with Siebel eConsumer.

Role: Integration Architect

Responsibilities:

• Code and Unit test TNT functionality.
• Report design, configuration and testing.
• Develop various workflows and Business Services based on business requirement.

Technologies: Siebel 7.7.x, Siebel EAI, Siebel eScripts, Oracle 9i, Actuate Reports.

Client: Confidential
Location : Cincinnati, OH
Employer : Confidential

May 2004 – Mar 2006

P&G uses Siebel eConsumer package for generating, tracking, auditing and disbursing their trade funds to all their customers. Siebel interacts with host of other systems like SAP, shipment database and homegrown systems like NCS and NASA, to effective manage trade funds. The Interfaces are written using PL/SQL procedures. Few of the constraints interface team had to face are 1) huge shipment data to process (hundreds of Millions), 2). Definite time window, 3) Complex fund structure 4) Enormous flags and complex computation logic and 5) Inherited UI constraints. Interface team strength is 28.

Role: Lead Architect

Responsibilities:

• Architecting and Designing the application architecture.
• Develop High Level and Low Level Design Documents and unit test scripts.
• Code Review and Issue Resolution.
• Provide short term and long-term solution strategy for the project. Participate in the user requirements verification sessions.
• Ensure application architecture meets P&G standards and SBBP business requirements.
• Ensure coding meets P&G standards, is quality, and adheres to SBBP design documents and requirements.
• Work with Application DBA to ensure compliance to Siebel/Oracle best practices.
• Manage the delivery of Volume Load into stress environment.

Highlights:

• Managed a design team of five designers and a development team of twenty-three developers and two database administrators.
• Guided Siebel consultants of Siebel Corp, now Oracle, during their review of our design and in appreciation I was given an offer letter, which I could not accept for GC reasons.

Technologies: Siebel 7.5.x, Siebel EIM, Oracle 8i and PL/SQL and Oracle Reports.

Client: Confidential
Location : Detroit, MI
Employer : Confidential

April 2003 to Apr 2004

The Dealer Information Database (DID) of an auto major serves as a central repository of all dealer related data. The system is currently implemented in mainframe. The system gets data from many upstream applications and feeds data to many down stream applications. Over the years the system has become highly inflexible and rigid, hence there was an acute necessity to reengineer this system into a web-based environment, which can cater to dynamic business needs. Siebel was selected as COTS product to be implemented. Reengineering Dealer Information Database into Siebel OLTP application had its challenges: 1) Complex Dealer Network, 2) Dynamic Market and Business Requirements, 3) User based operational requirements.

Role: Siebel Lead Architect

Responsibilities:

• Interact with the stakeholders to scope the project.
• Conduct interviews with key business owners and identify problems and inefficient practices.
• Conduct the feasibility study and the assess the suitability of the Siebel application to the reengineered database.
• Architect the overall solution.
• Reports design and testing.
• Prepare functional specifications, architecture and design documents.
• High level and Low Level design.
• Interact with SeeBeyond team on all aspects of integration.
• Provide inputs and guidance to the offshore team and arrange deliverables in time.

Highlights:

• GM was trying to reengineer a Mainframe application into a Siebel Application. After detailed study, we recommended GM to reassess their Siebel project

Technologies: Siebel 7.5.x eAutomotive, SeeBeyond, Oracle 9i, Crystal Reports.

Client: Confidential
Location : Bad Homburg, Germany
Employer : Confidential

May 2001 to Mar 2003

Client: Confidential
Employer : Confidential

Sep 2000 to Apr 2001

Client: Confidential
Employer : Confidential

Feb 1999 to Aug 2000

Education

Degree Diploma in Advanced Computing (of CDAC, Pune) Year Passed June – Dec 1998

Degree (Metallurgical Engineering)Year Passed 1991-1993

Degree (Mechanical Engineering) Year Passed1984 – 88