Summary of Qualifications

• 12+ years Information Technology experience with analysis, design, development and testing of client/server & web based CRM applications.
• 6+ years of experience in using OBIEE 11.1.1.5 (11g) /10.1.3.4/10.1.3.3/10.1.3.2 and Siebel Analytics 7.8/7.7.1
• 6 years of experience with Siebel application design, development, testing, configuration, Integration of CRM and client-Server applications
• In depth knowledge of Siebel Core Data Model, analysis and trouble shoot.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers creating reports / Dashboards, cache monitor, security implementation and building OBIEE/Siebel Analytics Repository.
• Strong experience with configuringInteractive Dashboardswithdrill-downcapabilities using dashboard and page prompts.
• Experience with Security Implementation(groups, access / query privileges),Metadata andWeb Catalog Objects(pages, folders and reports).
• Strong expertise with full lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using OBIEE/Siebel Analytics 7.x and Informatica7.x/7.x.
• Strong experience with Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica Power Center.
• Strong experience in Siebel interface data requirements for integration with other systems. Advanced Siebel technical experience in CRM using Siebel eMedical 8.0,Siebel ePharma 8.0/7.8.2, Siebel Consumer Sector 7.5.3, Siebel e Finance 7.5.3.4/7.0.4, Siebel e Communication 7.5.2, Sales, e Insurance, eService, Siebel Call Centre, Siebel 7.5.3.4, Siebel Tools 8.0/7.7.2.6, (EIM).
• Expert of MS-SQL, Oracle Database.
• Expert in languages like Siebel VB, PL/SQL.
• Excellent analytical skills, user interaction experience and ability to lead a team.

Technical Experience

CRM: Siebel Tools, Data Model, Server Administration, EAI, EIM
BI Tools: Siebel Analytics 7.x, OBIEE 11.1.1.5.0 (11g)/10.1.3.4/10.1.3.3,
BI Publisher, BI Delivers, OBIEE Dashboards, OBIEE Answers
Languages: Siebel VB, e Scripting, Visual Basic 6.0, PL/SQL, and XML
Operating Systems: Windows NT, Windows 2000/98/95, UNIX
Web Technologies: ASP3.0/2.0, JavaScript, and VBScript
Report Generation Tools:Actuate Reports
Databases used: MS SQL Server, Oracle 9i/8i/10g, and MS Access
ETL: Informatica Power Center 8.6.1,8.1/7.5.3/7.1.4

Professional Experience

Client: Confidential, San Jose, CA Jan'12 to Present
Position: OBIEE Tech/Functional Lead
Skill details: Oracle Business Intelligence (OBI) EE (11g)11.1.1.5, Oracle 10g, PL/SQL, TOAD, LINUX, SFDC (Sales Force)

Responsibilities:

• Interacted with business team and vendors to gather Business Requirements as well as to define business and functional specifications.
• Involved design and development of repository (RPD) (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Expressions mapped logical columns in BMM layer to physical columns in the physical layer. Developed Reports/ Dashboards with different AnalyticsViews (Drill-Down / Dynamic, Pivot Table, Column Selector, Tabular with global and local Filters).
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• Administered Permissions and Privileges fordashboard visibility and modifications to Users based on their groups or responsibilities.
• Reponsible for implementing Object level security for the various users who would be using the BI system.
• Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
• Setting up the AdministeredPrivileges and Security for various users using the LDAP security.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes toRepository.
• Interact with SFDC (Sales force), C3BL(Customer Service Data) & Voice team, and analyze the data and design the data model. Based on the data analyze created the dimension table for dash board reports.
• Involved set up the FTP site and supported the vendor for upload the data thru FTP site.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using Windows.
• Performed stakeholder analysis team and weekly status reports to leadership teams

Client: Confidential, San Francisco, CA Aug'11 to Dec'11
Position: OBIEE Lead
Skill details: Oracle Business Intelligence (OBI) EE 10.1.3.4, Oracle 10g, PL/SQL, TOAD, LINUX, DAC, Informatica 8.6.1, Oracle EBS

Responsibilities:

• 01.Interacted with executive team and users to gather Business Requirements as well as
• to define business and functional specifications.
• 02.Involved in design and development of repository (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• 03.Expressions mapped logical columns in BMM layer to physical columns in the physical layer. Developed Reports/ Dashboards with different AnalyticsViews (Drill-Down / Dynamic, Pivot Table, Column Selector, Tabular with global and local Filters) usingSiebel Analytics Web.
• 04.Extensively involved in configuring OBIEE Publisher and resolving issues.
• 05.Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• 06.Administered Permissions and Privileges fordashboard visibility and modifications to Users based on their groups or responsibilities.
• 07.Reponsible for implementing Object level security for the various users who would be using the BI system.
• 08.Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
• 09.Extensive experience in OBIEE and Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• 10.Configured iBots to deliver content based reports on schedule, automated iBots queries to obtain daily and weekly reports.
• 11.Setting up the AdministeredPrivileges and Security for various users using the LDAP security.
• Created ETL (informatica) to load data from external system (OLAP/OLTP) and this process will schedule to run everyday morning.
• Involved Data Warehouse Administration Console (DAC), for loading and monitoring of the Oracle Business Analytics Warehouse.
• Used ETL processes to accommodate changes in source systems and new business user requirements.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes toRepository.
• Interact with Oracle EBS team, and develop the dash board reports.

Client: Confidential, Hicksville, NY Nov'09 to Jul'11
Position: OBIEE Architect
Skill details: Oracle Business Intelligence (OBI) EE 10.1.3.4, BI Publisher, Oracle 10g, Oracle 10g, PL/SQL, TOAD, LINUX.

Responsibilities:

• 01. Involved in the full Project life cycle from analysis thru final implementation
• 02.Interacted with executive team and users to gather Business Requirements as well as to define business and functional specifications.
• 03.Involved in design and development of repository (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• 04.Extensively involved in configuring OBIEE Publisher and resolving issues.
• 05.Defined initialization blocks and created repository variables to be used in the expressions mapped logical columns in BMM layer to physical columns in the physical layer.
• 06. Developed Reports/ Dashboards with different AnalyticsViews (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) usingSiebel Analytics Web.
• Extensively involved in configuring OBIEE Publisher and resolving issues.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in Reports to improve performance.
• Administered Permissions and Privileges fordashboard visibility and modifications to Users based on their groups or responsibilities.
• Reponsible for implementing Object level security for the various users who would be using the BI system.
• Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
• Extensive experience in OBIEE and Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured iBots to deliver content based reports on schedule, automated iBots queries to obtain daily and weekly reports.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using Windows and LINUX.
• Experienced in upgrades to OBIEE software and migration to newer Versions.
• Created oracle packages to load data from external system (GERS/ SIESTA) and this process will schedule to run everyday morning using DBMS Scheduler.
• Used ETL processes to accommodate changes in source systems and new business user requirements.Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes toRepository.

Client Customer: Confidential, Boston, MA 09/2007- 10/2009
Position: OBIEE Consultant
Skill Details: Siebel Clinical Trail Managements(CTMS),Oracle Business Intelligence (OBIEE) 10.1.3.4, PL/SQL, TOAD, Oracle 10g Informatica 8.0/7.5.3, Post Production Support

Responsibility: Project: GEDI

• Involved in the full Project life cycle from analysis thru final implementation
• Works closely with the Infrastructure team and performance related issues.
• Involved in design and development of repository (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Responsible for develop the Reports/ Dashboards with different AnalyticsViews like Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters usingSiebel Analytics Web.

Client: Confidential, Cincinnati, OH
OBIEE Consultant 3/2007 - 8/2007
Skill Details: Oracle Business Intelligence (OBIEE) 10.1.3.4, Oracle 10g, Informatica 8.x, TOAD, Windows XP

Responsibility:
Project: CSI 2.0 (Customer Solutions Investigation)

• Responsible for create the Functional Design Document, Technical Detail Design Document, Data mapping and Data layout.
• Involved analysis the business requirements and validation process for all entity.
• Responsible for develop the OBI Metadata Repository using Oracle BI Administration tool, incorporating the Physical Model, creating multiple Dimensions (Drill-Down Hierarchies) and Logical & Facts / Measures objects in Business Model Layer and Presentation catalogs in Presentation Layer.
• Involved create the Ad-hoc and standardReports/ Dashboardswith differentAnalytics Views(Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with dashboard and page prompts) usingSiebel Analytics Web.
• Responsible for Create and Modify the Metadata repository (.rpd) and Configured Metadata objects using Siebel Analytics server Admin Tool.
• Responsible for create the ETL for Data Extraction, Data Mapping and Data Conversion using informatica Power Center 8.1.
• Created mappings using different transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.
• Involved in developing the incremental ETL process i.e. Mappings and Mapplets using various Transformations and Workflows with Sessions/Tasks. Executed the workflows through shell scripts using pmcmd.

Client: Confidential, Fort Washington, PA
OBIEE Consultant/ETL Developer 9/2006 - 2/2007
Skill Details: OBIEE 10.3.2, DTS,Oracle 10G, PL/SQL, TOAD, Informatica 7.1.4, UNIX

Responsibility: Project: Viewpoint

• Responsible for manages the requirements, data layouts, and validation process for all external data loads.
• Responsible for Call Plan, alignment/assessment manager process, marketing data loads, Call Activity loads.
• Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Experience in DTS for Scheduling jobs, data mappings and creating users.
• Assisted the ETL team in regards to schema and data model design Configured & Implemented Siebel Analytics
• Responsible for create the administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Interacted with Informatica Team in developing many complex Informatica Objects (Workflows, Sessions, Mappings, mapplets with various transformations i.e., expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy) for performing the full, incremental loading and processing.
• Responsible for creating the UNIX shell script, and run the workflow thru shell script.
• Informatica: OMJ group Call Plan & Sales Direction data loads thru Informatica.

Client: Confidential, Skillman, NJ
Siebel Consultant02/2005 - 08/2006
Skill Details: Siebel Pharma 7.7.4, Siebel Tools 7.7.4, Oracle 9i, EIM

Project: TRECnet pharma

• Responsible of Siebel 7.7.4 Data Mapping specifically focused on Account, Contact, Service Request, Related Questions and Product Mapping.
• Involved in Creating the IFB Files .Run an EIM Job thru command file and populate the data into Siebel Base Tables, also involved in extensive analysis and troubleshooting.

Client: Confidential, Eagan , MN
Siebel Consultant09/2004 - 01/2005
Skill Details: Siebel Finance 7.5.3.4, Siebel Tools 7.5, SQL 2000, EIM, Actuate Report 6.0

Project: Corporate Payment System

• Involved Migrate the Corporate Payment Systems (CPS) of Siebel 99.5 to Siebel 7.5
• Responsible of Siebel 99.5 to Siebel 7.5.3.4 Data Mapping, specifically focused on Opportunity
• Mapping and relationship (like opportunity to company, opportunity to activity, opportunity to source, opportunity to sales method, opportunity to contact, opportunity to call reports, opportunity to assessment).
• Involved in Creating the IFB Files .Run an EIM Job to populate the Siebel Base Tables, also involved in extensive analysis and troubleshooting.

Client: Confidential, Cincinnati, OH
Siebel Consultant 04/2004 - 08/2004
Skill Details: Siebel Sales (SFA) and Call Centre Application 7.5.3, Consumer Sector Goods Tools 7.5.3, Oracle 8.0, Siebel scripts, EIM

Responsibility: Project: IAMS

• Responsibilities for integration of the Sales and the Call Centre application for IAMS.
• Involved create the Technical Detail Design Document for Call Centre and Sales (SFA) module.
• Addressed knowledge and design issues with the offshore team, which comprised of six configuration developers from India through daily conference call.
• Maintained issue and logs of the progress of the offshore implementation.

Client: Confidential, Hopewell, NJ
Siebel Consultant 02/2003 - 03/2004
Skill Details: Siebel 7.5/7.0.4, Siebel e Finance 7.0.4, Siebel Tools 7.0.4, MS SQL 7.0, EIM process, PL/SQL procedure, Sales Force Automation (SFA)

Responsibility:
Project: Wealth Management System

• Involved in Data Mapping between Financial Foundations and Siebel Tables.
• Data Mapping between the applications was done in two tiers
• Involved in writing PL/SQL Scripts to extract the data from TGA and Populate the Siebel Interface Tables.
• As a Team Member Involved in Creating IFB Files .Run an EIM Job to populate the Siebel Base Tables, also involved in extensive analysis and troubleshooting.

Client: Confidential, Plano, TX
Siebel Consultant 10/2002 - 01/2003
Skill Details: Siebel 7.5.2, PL/Script, Siebel e Comm., Siebel Tools 7.5.2, Oracle 8i, EIM

Responsibility: Project: Siebel Order/Entry Management

• Involved into Import the Accounts, Contacts, Quote, Orders, Products, Sales Representative, Address, and Order Revenue information from existing oracle system into Siebel table thru EIM.
• Involved in create the IFB Files and execute the EIM Job to populate the Siebel Base Tables, also involved in extensive analysis and troubleshooting.

Client: Confidential, Phoenix, AZ
Siebel Consultant 05/2002 - 09/2002
Skill Details: Siebel 7.0.4, PL/Script, Siebel e Sales, Siebel Call Centre, Siebel Tools, MS SQL 7.0

Responsibility:

• Involved in project planning, architecture, analysis, design and implementation.
• Involved in write the stored procedure through PL/SQL Scripts to extract the data from TGA and Populate the Siebel Interface Tables.
• account type, date of birth, blank name field checks.
• Involved in create the IFB files and ran an EIM Job to populate the Siebel Base table.

Client: Confidential, New York City, NY
Siebel Consultant 03/2001 - 04/2002
Skill Details: Siebel 7.0, Siebel VB script, e Script, Siebel e Sales, Siebel Call Centre, e Insurance, Siebel Tools, Workflow, EIM, EAI, ASP, Visual Basic 6.0, Oracle

Responsibility:

• Project planning, architecture, analysis, design and implementation.
• Requirement study from Functional Leads, interacting with Process Owners and development of flows of application and effectiveness of the proposed solutions. Analyze the Business Processes, process flow and Key Performance Attributes.

Client: Confidential, Woodland Hills, CA
Siebel Developer 07/2000 - 02/2001
Skill Details: Siebel 6.0, Server, Thick Client, Thin Client, Object Managers, Siebel VB script, Siebel Tools, Workflow Manager, EIM, EAI, Siebel e Sales, Call Centre, MSSQL7.0, Siebel e Script.

Responsibility:

• Project planning, architecture, analysis, design and implementation.
• Requirement study from Functional Leads, interacting with Process Owners and development of flows of application and effectiveness of the proposed solutions. Analyze the Business Processes, process flow and Key Performance Attributes.

Below experience from India

Client / Customer: Confidential, India (Nov'97 to May' 2000)
Skill Details: VB 6.0, ASP2.0, HTML/DHTML, JavaScript, VBScript, Visual Interdev6.0, and SQL 7.0
Role: Sr. Software Programmer Responsibility:

Client / Customer: Confidential, India (Jan 96 to Oct 97)
Skill Details: Windows 3.11, Visual Basic 3.0, Access 2.0, SQL 6.5, and Crystal Reports 4.0

Education
MSMaster of Computer Application
BS Bachelor of Science
Certificate Siebel 7 Certified
OBIEE Essential Training Classes undertaken