Summary

• Total 15+ years of experience in IT.
• Have over 5+ Years of Business Analysis and Project Lead experience involving Siebel and Informatica.
• Have over 9+ years of experience in Full Life Cycle Siebel implementations using Siebel ePharma, Siebel eConsumer Goods, Siebel Call Center, Siebel Sales Enterprise.
• 9+ years or experience in Data Migration from SAP, Legacy Systems into Oracle Applications, Siebel CRM applications using Siebel Webservices, Siebel Workflows, SQL*Loader, MQ Series and Siebel EIM, Siebel Adapters, Siebel COM Objects, Siebel Business Services and Informatica.
• Have over 6+ years of experience in Data Analysis, Designing and developing reports using OBIEE, Crystal Reports, Excel and Microsoft Reporting Services
• Have over 10 years of experience in Oracle GUI tools (Reports & Forms), Case tools, PL/SQL, Unix Shell scripts, Applications, Database Administration and support. Has extensive experience in database migration, fine-tuning and troubleshooting.
• Strong capability to lead the team and as well as massive experience on coordinating project work between on-site and off-shore.

Education

• Bachelors Degree in Electronics & Communication Engineering.

Technical Skills

OS

UNIX, Windows XP Pro, WIN NT, WIN 95, WIN 98, Windows for Workgroups

Languages

C, C++,Pro*C,Java, Perl, PL/SQL, HTML, XML, Siebel VB, Siebel eScript, VB.NET,C#, Unix Shell Programming

Database

ORACLE7.X/8i/9i/10g, MS SQL 7

ETLTools

Informatica Power Center 5.1/6.x/7.x/8.x

Quick Test Pro

Forms 6i/5.0/4.5/3.0, Reports 6i/3.0/2.5/1.0, SQL*Plus, Case V5.1, Designer 2000, Crystal Reports V5.0/6.0, Microsoft Reporting services 2005, Actuate Reports

Applications

Oracle Financials, OAS 4.0

CRM

Siebel 99.5/2000/7.x/8.x

Siebel Analytics 7.x, OBIEE 10.1.3.4

Source Code Management

Visual Source Safe, Harvest

Document Management Tool

Share Point, MS office, MS Visio, Power Point, Microsoft Project Plan

Specialization

Client/server application development with extensive use of
Oracle tools.
Good experience in customization and implementation of front office solutions using Siebel.
Install and maintenance of Siebel Servers and Oracle Database.

PROJECT PROFILE

Project Siebel Sample Management
Confidential, Indianapolis, IN
Environment Siebel ePharma 8.0.0.8, Informatica Power Center 8.1.3, OBIEE 10.1.3.4
Duration October 2009 - Till Date
Role Integration Lead/Administrator

• Developed Informatica ETL mappings, PL/SQL procedures, packages, ifb files, Unix shell scripts for EIM process and scheduled the jobs in Control M.
• Developed complex data mappings to load data from Siebel Database to Analytics Database.
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs in Oracle Business Analytic Warehouse.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads
• Responsible for Migrating the Informatica Mappings, Informatica Repository, Informatica Users and Siebel Repository between environments.

Project North America Siebel Development
Confidential, Cincinnati, OH
Environment Siebel 7.5/7.7, Oracle 9i, Informatica Power Center 6.2, Siebel
Analytics 7.8
Duration February 2003 - September 2009
Modules Siebel eConsumer Goods
Role Project Lead/ Developer/Analyst managed a team of 12 offshore and onsite
resources

• Designed and Developed Informatica Mappings, PL/SQL packages, procedures, functions, SQL*Loader scripts, ifb files and unix shell scripts to extract the data from different source systems to load data into Siebel
• For data sharing and loading designed and developed EIM process, Web Services, Siebel COM objects as per the requirements and got it approved from the Architect.
• Used Siebel Tools to configure and customize Business Objects, Business Components, Applets, Views, Screens, Actuate Reports as per the requirements.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Designed and developed Data Analysis Reports using Crystal Reports and Excel for Business Team.
• Worked with QA team in preparing and validating the test plans and test cases.
• Designed and developed the shell scripts and scheduling of jobs using Control M
• Developed complex data mappings to load data from Siebel Database to Analytics Database.
• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration, ETL Configuration

Project Call Center
Confidential, Sandiego, CA
Environment Siebel 2000, Oracle 8.1
Duration June 2001 - January 2003
Modules Siebel Call Center, Workflow Manager, Assignment Manager, Siebel
Field Service, Siebel Channel Configurator, Siebel Product Configurator,
Siebel eScript, Actuate
Role As a developer I was involved in Designing, Developing, implementing and supporting
system.

• Understanding the business requirements and specifications for a new campaign and coordinating with the Clients Team for implementation of the same.
• Interacting with Client and analysis of Client requirements for Implementation of Siebel Call Center Module for Opportunity Management, Account Management, Contact Management, Activity management
• Created Workflow rules for Sales, Marketing and Service Management to monitor, activity creation and escalation of the requests and alert the Sales and Service Executives.
• Configured the assignment rules for assigning of requests to the appropriate position.
• Configured Siebel Product Configurator for marketing and product managers to create product bundles. Distribute them to sales and service channels.
• Involved in integrating the Siebel Sales, Service, Channel and Configurator for sales, service and marketing departments to access a consolidated pool of product information, competitive attacks, and customer references.
• Designed and developed Actuate Reports.
• Configured E-mail Agent to create all Inbound emails as Activities.
• Analyzed the user requirement and defined the Integration object to represent the Siebel business objects and the external meta data
• Used eScripts for date calculation, field capturing and etc.,
• Developed process for life cycle test methodology for the entire application.

Environment Siebel 99.5, MSSQL 7.0
Duration Oct 2000 - May 2001
Modules Siebel Sales, Siebel Field Service, Assignment Manager, Workflow Manager, Email Configuration, EIM, Product Configurator, Actuate Reports, Thin Client, Siebel VBScript.
Role In a team of four I was responsible for

• Configuring Siebel Applications using Siebel tools to meet the business requirements of the clients.
• Involved in Process Mapping, Design, Configuration, Validation and Training.
• Used EIM to Import data from Legacy systems.
• Designing and implementing work flow rules to monitor and enforce the policies of the organization.
• Enabling Siebel Remote and synchronizing Siebel Remote user.
• Installed the application for various mobile users and trained them effectively in using Siebel.
• Configuring assignment rules to route the requests to the appropriate position.
• Worked extensively with Product Configuration using Quote Assistant and Configuration designer.
• Designed and developed Actuate Reports.
• Used VBScript to improve the functionality.
• Involved in preparing a Test strategy for the whole application.
• Configuring Thin Client to access the Siebel Project Module over the internet.

Project Datawarehouse
Confidential, Memphis TN
Environment Oracle 7.x, Oracle 8i, OAS v4.0 ON Unix and Win NT,
PL/SQL, Sql*Plus, Sql*Loader, HTML, Developer 2000, Crystal Reports V5.0, Power Center 5.1
Duration Nov 1997 - Sept 2000
Role As a developer I

• Designed specification to map data from the legacy system.
• Designed tables, constraints, Indexes and related objects.
• Wrote Control file scripts for SQL*Loader to handle flat file.
• Developed various UNIX shell scripts to automate the data loads using CRON and to monitor the server performance.
• Involved in fine tuning of database and PL/SQL code.
• Developed mappings to load data from xml file to Oracle Database using Informatica 5.1

Project Agreement Management System (AMS)
Confidential, USA
Duration July 1997 - Oct 1997
Environment Oracle financials (Order entry), PL/SQL, Sql*Plus, Sql*Loader, Developer 2000
Role As a developer I was responsible for

• Designed tables, constraints, Indexes and related objects.
• Developed database triggers, procedures, functions and packages to handle validation for various data loads.
• Customized reports in Oracle Order Entry using reports 2.5

Project MCI Commissions
Confidential, Portland, Oregon,
Duration April 1997 - June 1997
Environment Oracle v7.x, Developer/2000 (Forms 4.5, Reports 2.5), PL/SQL, SQL* Loader
Utilities Designer/2000, Oracle CASE v6.0, Repository Object Navigator, Preferences Navigator, Data Diagrammer, Module Logic Navigator, Module Structure Diagrammer, Module Data Diagrammer, Forms Generator
Role As a developer I was responsible for

• Configuring & Installation of Oracle database for the application
• Designed tables, constraints, Indexes and related objects.
• Created Database triggers, procedures, functions and packages.
• Performed the duties of day-to-day operations of a DBA like backup, creating schemas etc.
• Handled basic Win NT administration skill like adding users, setting permissions, setting groups, user profiles etc.

Project Project Esperanto
Confidential, India
Duration August 1996 - March 1997
Environment Oracle v7.x, PL/SQL, SQL, Developer/2000, WIN NT
Role As a developer I

• Used PL/SQL in procedures and triggers
• Used Reports v2.5 to create custom specific reports.
• Used Forms V4.5 in creating custom data entry screens.

Project Clinical Administration System (CAS)
Confidential, USA
Duration January 1996 - August 1996
Environment Oracle v7.x, WIN NT, Developer/2000 (Forms 4.5, Reports 2.5), PL/SQL, C,
C++, Designer/2000, Oracle CASE v5.1, Customizer/2000
Role As a developer I was responsible for

• Used PL/SQL, C in creating custom specific reports.
• Written C, C++ programs and embedded into forms executables using Oracle CASE API.
• Extensively used Designer V2000 to generate Forms V4.5 and Reports V2.5 and modified them using Developer V2000
• Developed new Forms V2.5 and Reports V2.5 using Developer V2000

Project Stores Accounting System
Confidential, India
Duration Jan 1995 to January 1996
Environment Oracle v7.x on SVR Unixv4.2, Forms v3.0, Reportwriter v1.0, SVR Unix v4.2,
SQL*Menu v5.0
Role As a developer I

• Used PL/SQL to create procedures and triggers
• Used Report writer v1.0 to create reports.
• Used Forms v3.0 to create data entry screens

Project Inventory System
Confidential, India
Duration August 1994 to Dec. 1994
Environment Oracle v7.x on SVR Unixv4.2, Forms v3.0, Reportwriter v1.0, SQL*Menu v5.0
Role As a developer I

• Used PL/SQL to create procedures and triggers
• Used Report writer v1.0 to create reports.
• Used Forms v3.0 to create data entry screens