SUMMARY

10.3 years of total Information Technology Consulting experience. Involved in Design, Development, Migration, Product Analysis, Support and Maintenance. 9.6 years of Siebel Experience in Siebel Configuration, EAI, Scripting, Workflow, Business Service, Web Services, Siebel Administrations, EIM, OBIEE and OBI Publisher

Training and Seminars / Professional Qualification:
B.E (Computer Science & Engineering) from Bharathiyar University, TamilNadu, India.
M.E (Software Engineering & Management) from Anna University, TamilNadu, India.
APEX Certified in Diploma Java Programming for Business Development.
BIRLASOFT Certified in Business Conduct and Ethics
Successfully Completed SIFY PMP Training
Successfully Completed SIEBEL Essentials Training from Oracle Siebel Corporation.


Skills:
CRM Applications: Siebel eBusiness Applications (SEA) (8.1.1.5v, 8.0.1v, 7.8.2.3v, 7.7.2.9v, 7.0.2v, 6.8v) Siebel Industry Applications (SIA) (Loyalty, Life Sciences, Marketing, Financial,
Consumer Sector, TNT, Public Sector), Localization (English, French).
Database Management Systems: DB2, SQLServer 2008, Oracle Database 10g SQL, PL/SQL, 9i, 8i, 7.3, Access
Operating System: UNIX, Red Hat-Linux and Windows
Microsoft office Suite: (MS Projects 2003, Power Point, Excel and MS-Word)
Configuration MGMT: PVCS, Rational Clear Quest.
Platforms & Tools used: Toad, Sql, PL/Sql, Sql*Loader, VISIO, XML.
Middleware: Oracle SOA 10g R1, IBM MQ Series, MS BizTalk 2006 R2.
ETL: Informatica 8.6.1.0V, Abinitio 10.0.1.3 v GDE
Framework: BPEL, Oracle 10g SOA Suite ESB (Enterprise Service Bus)
Reporting Tool: OBIEE 10.2v, OBI Publisher 10.1.3.4(10g)

EXPERIENCE

• Working as a Siebel Consultant for Constellation Energy MD USA from Dec 2011 to till date.
• Worked as a Siebel EAI Consultant in HMA (Hyundai Motors America) for HISNA CA USA from May 2011 to Dec 2011.
• Worked as a Siebel EAI Consultant for Hartford Finance. PA USA from Dec 2010 to April 2011.
• Worked as a Siebel EAI Consultant for Britvic Inc. NJ USA from Apr 2010 to Nov 2010.
• Worked as a Siebel EAI Consultant for Ariba Inc. Sunnyvale CA USA from Dec 2007 to Feb 2010.
• Worked as a Siebel Consultant for Wyeth, Newark USA from April 2007 to Dec 2007.
• Worked as a System Analyst in Birlasoft Ltd, Bangalore, India From Dec 2005 to Mar 2007.
• Worked as an Application Programmer in IBM Global Services India Ltd, Bangalore, India from July 2005 to Dec 2005.
• Worked as a Software Engineer in Mahindra British Telecom Ltd (Tech Mahindra), Pune, India from June 2003 to Feb 2005.
• Worked as an Associate Software Engineer in Quark Systems, Mohali India from June 2002 to Feb 2003.
• Worked as a Software Engineer in Honeywell Software Lab, Bangalore India from Feb 2001 to Aug 2001.

PROJECTS

Confidential, Constellation Energy Baltimore MD
Siebel Consultant Dec 11 – Till date

Constellation, anExeloncompany, is a leading competitive supplier of power, natural gas and energy products and services for homes and businesses across the United States and Canada. Constellation provides integrated energy solutions that help customers buy, manage and use energy, fromelectricityand natural gas procurement to renewable generation and conservation.

Responsibilities included

• Prepared design document and developed Applets and Bus Comps for RTT load shape requirement and created DB view based EBCs (External Business Components) to update data from Lode star (Pricing Components).
• Implemented new work package (RTT Load shape) with existing Quotes and Contract modules to facilitate users can handle load shape data for individual client between Siebel and lode star .
• Interact with customers (Constellation Siebel Business Team) and prepare design (HLD/LLD) documents for new Siebel enhancements.
• Using Siebel tools configure the new enhancements and provide fixes for Siebel application related bugs.
• Troubleshoot issues related to mappings between Siebel and Salesforce.com in Siebel conversion Development Project.
• Understand the In-house build ACT Tool and use the tool for Siebel EIM run and troubleshoot the issues related to Siebel EIM Job.
• Identify the issues related to Siebel performance tuning and interact with network and database teams for the performance related issues.
• Provide training to the Siebel users once the new enhancements has been delivered to the Siebel application.
• Implemented custom data mapping and runtime events to newly create a Contracts from existing quote and revise quotes from parent quote trigger by signals.

Environment: Siebel 8.1.1.7, Windows 2008 Server R2, Solaris 10.5, Oracle 11g R2, IIS server 7.5v, iQUAD (Document Server), PL/SQL, Informatica 8.6.1.0v, OBIPublisher 10g, Windows XP.

Confidential, HISNA Costa Mesa CA Siebel EAI Consultant May 11– Dec 11

Hyundai Information Service North America (HISNA), an information technology organization committed to providing world-class technology services to its clients throughout North America. With extensive industry and technology expertise, HISNA can deploy the right mix of technology and resources to our clients to help them reach their business goals. By consolidating all IT related resources into one company, HISNA will be able to maximize its synergy to provide top quality IT services to its Hyundai Kia Motor Group companies and act as the information bridge between Global Headquarters and North America.

Responsibilities included

• Prepared Upgrade plan and performed (Siebel Upgrade) UPGREP, merging, post merge and UPGPHYS from 7.8 to 8.1 Siebel (SIA) automotive applications.
• Prepared fixes and configuration solutions for dev-post upgrade phases (Siebel Upgrade) and tested case management entity after post upgrade in 8.1 dev environment.
• Installations and configurations of Siebel gateway (Siebel Upgrade) and enterprise server in red hat Linux and windows and database configurations for prior to restore Siebel repository from prior release.
• Prepared automated and scheduled (Siebel EIM) batch interfaces for Dealer master and Dealer contact from AS-400 mainframe systems in to Siebel base table.
• Prepared Siebel EIM batch interface for (Siebel EIM) RDR and WRTCLM data from EDW and warranty application in to Siebel application.
• Prepared HLD/LLD for HACC/HMA to sales Order and service orders business process customizations.
• Provided Siebel application support for Product configuration and Sub-Products attribute maintenance in Administration-product screen.
• Implemented Campaign work package (Siebel Configuration) to facilitate Hyundai marketing processes for HACC/KCI/HMA.
• Implemented Siebel Marketing infrastructure(Strong Mail/ESD/CTD) for Email and Direct mail campaign in HMA/HACC
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Developed (OBIEE) Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Prepared custom Business Services in lead Aging and Dealer allocation process for offline leads coming from Auto Show Event.
• Prepared segmentations (Siebel Marketing) using BI Publisher screen in 8.1.1.5v for HMA/KCI and used the segment for “new vehicle sales marketing” in marketing applications.
• Involved in improving Siebel performance related issues (Siebel and Database Tuning) in contacts and case entities and provided configuration solutions using Siebel Tools.
• Prepared Siebel scheduled batch interfaces (Siebel EIM) for campaign history (CAMPHIST) related to Siebel case entity.
• Prepared inbound web services (Siebel EAI) for Corrosion settlement interface to facilitate the integrations between SAP and Siebel systems to provide the settlement for salt belt oriented customers.
• Prepared inbound web services (Siebel EAI) for SRNUM creation in to Siebel for SRNUM created in SAP and eBIZ systems.
• Prepared detailed design document and implemented Marketing process (Marketing Campaign) in siebel 8.1 marketing application for HMA/HACC/KCI divisions for Hyundai sales, Parts and services.
• Prepared mapping (Informatica) and workflow for Hyundai HQ DASHBOARD reporting for North America, HACC, KCI.
• Provided production support (OBIEE) and added dynamic filters for an enhancement to existing OBI Answers.

Environment: Windows 2008 Server R2, Oracle 10g R2, Siebel 8.1.1.5, IIS server 7.5v, SAP, eBIZ systems, SQL, PL/SQL, Informatica 8.6.1.0v, OBIEE

Confidential, Catalyst-360 Horsham PA
Siebel EAI Consultant Dec 10 – Apr 11

Catalyst360° was created to provide customer care for one of the nation’s premiere service organizations, bringing The Hartford’s passion for customer service and dedication to doing the right thing, becoming a center for answers on behalf of our clients. We\'ve been in the business of protecting businesses since 1810, and through the years we\'ve insured thousands of different types of companies. We\'ve also amassed a wealth of experience in a number of industries, enabling us to understand the unique risks, goals and needs of each. Fromcore coverage’s designed for all types of businesses, to specializedindustry solutions,the insurance coverage and service you need to protect your company employees.

Responsibilities included

• Interact with different business team and prepared JAR and JAD documents for all new functionalities and or enhancements in Siebel FINS application.
• Worked on VBC framework based interfaces (Siebel Configuration) to display product entity without using Siebel base table.
• The (CTI) Contact Activity SR Restrict View has implemented for modified transfer flow for Health LOB.
• Implemented (CTI) IC for Blind Transfer and consultative transfer implementations for AARP.
• Created Inbound (Siebel Household) and outbound web services (Siebel EAI) (NICE system) for 8.1.1 SIA Financial Services and deployed the web services in INT and Dev environment.
• Prepared Design document for ECR and DCR and configured Siebel application using Siebel tools, Profile attributes file and LOV Import/Delete (Siebel EIM) operations using Custom developed VB Script based tool.
• Involved in designing performance improvement solution in Application and data layers.
• Prepared transform Business Services (Siebel Configuration) for Plan Benefit details from external system (Vitria) using VBC frame work.
• Prepared inbound web services (Siebel EAI) in Siebel Handheld entity for AARP and outbound web services for Siebel update request to (Vitria) external system.
• Prepared JBS interface for locator (Java based application) functionality (Siebel Configuration) and exposed locator db inside Siebel using EBC.

Environment: Windows 2008 Server R2, Oracle 10g R2, Siebel 8.1.1.3, IIS server 7.5v, Siebel Financial 7.8v , Genesys 7.8v, IBM MQ Series, Serena Dimensions (Change management), Oracle 10g SOA suite Integration methodology.

Confidential, Bloomfield NJ
Siebel EAI Consultant April 10 – Nov 10

Britvic plc, through its subsidiaries, engages in the production and distribution of soft drinks primarily in the United Kingdom and Republic of Ireland. The company offers stills and carbonates under the brand names 7UP, Ame, Britvic, Britvic, J20, Drench, Gatorade, Idris, Pennine Spring, Pepsi, Purdey\'s, Really Wild Drinks, Red Devil and Tango. The company sells its products primarily to supermarkets, shops, restaurants, pubs, cinemas, and hotels. Britvic also exports its products to approximately 50 countries worldwide. It was formerly known as British Vitamin Product Company and changed its name to Britvic Plc in 1971. The company is headquartered in Chelmsford, the United Kingdom.
Siebel Virginia is Siebel implementation and interface (Siebel – SAP) development projects in Siebel 8.1.1.3v eConsumerSector.

Responsibilities included

• Prepared Siebel Custom Interfaces using Business Services and workflows for Britvic’s Inbound and Outbound Functionalities.
• Prepared UI Objects (List Columns and controls) customizations and prepared eScripts on BC and Applet.
• Bug fixes involved in Siebel 8.1(eConsumer) after Migrations.
• Siebel integration with external systems with different codepages and Localization of the Siebel user interface in multiple languages
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in the OBIEE Administration tool.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Dashboards, BI Publisher (xml publisher), Delivers (iBots), BI Office component with OBIEE.
• Converted MSSQL server from Non-Unicode to Unicode database to support internationalization for 16 bit codepage support for multiple languages.
• Integrated Order management by the Sales Order flows from Siebel Consumer Application to SAP.
• Involved in Siebel upgradation from Siebel 7.5 (SIA) to 8.1.
• Prepared inbound and outbound web service (Siebel EAI) interfaces between SAP and Siebel using middleware BizTalk.
• Prepared Installation, Upgrade and Merge technical documents based technical implementation.
• Designed the workflow process, Workflow Policies, Workflow Policy Actions and Business Services for the real time integration.
• Migrated workflows and configured web templates from 7.5 to 8.1v.
• Prepared Siebel interface documents (Interface Testing Plan) for migrated interfaces in 8.1v.
• Prepared functional design documents for Inbound/outbound interfaces between Siebel 8.1 and SAP using middleware (BizTalk Server).
• Modified eScript to improve the performance and UI level object customizations
• Extended custom Columns in Siebel 8.1v Database.
• Prepared IO and created WFs for EAI Outbound requests from Siebel.

Environment: Windows 2008 Server R2, Genesys, MS SQL Server 2008 R2, Citrix® NetScaler 7.0v, Siebel 8.1.1.3, IIS server 7.5v, Red Hat Linux, Oracle HTTP Server 10.1.3.v, Oracle 10g R1.

Confidential, Sunnyvale CA
Siebel EAI Consultant Dec 2007 – Feb 2010

Oracle As the leading provider of Spend Management solutions, Ariba helps companies analyze, understand, and manage their corporate spending to achieve increased cost savings and business process efficiency. Ariba Spend Management Solutions comprise a unique, comprehensive blend of domain expertise, operational services, and technology that accelerate each customer\'s journey toward an improved bottom line.

Responsibilities included

• Created new WFs to handle XML file to update the Defect entity for Ariba’s Product related defects.
• Created new Business Services and WF policy to automate default product Owner assignment in SR entity.
• In depth experience with Virtual Business Components (VBC) and EAI technologies including the utilization of Siebel Integration Objects and Adapters to promote seamless external data interfaces
• Used specialized Bus Comp User Properties for configurations.
• Implemented product configurations (Siebel Product Configurations) for all Ariba’s products (Ariba Buyer, Ariba Analysis) and setup pricing for the products using pricing engine.
• Worked on HI and SI (Standard Interactivity) mode CRs. Prepared Design document for CRs.
• Configured Hierarchical (constrained) pick lists.
• Configured Pick list, Dynamic drilldown and Applet Toggling.
• Prepared inbound web services to facilitate AN Punchout and configured outbound web services to get Defect records for Account from Connect Systems.
• Prepared Inbound/outbound interfaces between AN(3rd party) system.
• Worked on eScript and UI level object customizations
• Created custom fields in Order Line items to map the data in to Asset for “Auto Asset” functionality.
• Configured UI Object Customizations and extended Columns in Siebel Database.
• Prepared Customizations using e-Script in SR and Defects entity level.
• Configured Workflows based on customer requirements.

Environment: Windows XP professional, SQL Server 2000, Siebel 7.7.2.11 eService, IIS server 5.1v.

Confidential, New Jersey, NJ Siebel Consultant April 2007 – Nov 2007

The Wyeth Consumer Healthcare is Siebel consumer healthcare 7.8v based Siebel industry application. The Siebel Application supports the closed loop cycle, which consists of the 3 processes. Account hierarchy implies the ability to view customer dependencies within Siebel. The master data will serve as the basis for supporting major functional areas of the Siebel application – SVP.

Responsibilities Included

• Responsible for enhancement the current eScripts to meet new business requirement and performance tuning of the application.
• Ran Siebel sever tasks such as Siebel upgrep, upgphys as part of Siebel upgrade process; EIMdiff utility to identify differences in columns & tables from Siebel 6.0 to Siebel 753 version; and other tasks like DEV2Prod, exprep, imprep for repository migration & maintenance.
• Developed a complete EIM mapping from Siebel 6.0 model to new Siebel 7.5.3 model including S_PARTY model mappings.
• Provided data analysis, data modeling, and Siebel EIM expertise in data conversion & loading to Siebel 753 including troubleshooting data related issues.
• Provided Oracle back-end support writing adhoc-scripts (DDLs, SQL, PLSQL, Com scripts and Shell) for data extraction/mining for developing adhoc-reports for clients.
• Has good understanding and proficiency in writing PL/SQL for data staging, cleansing/Massage.
• Involved in the configuration of the customization process and move data using EIM from one environment to the other for Application Administration, which involves Employees, Positions, Responsibilities, Views, LOV’s and all the Reference entities.
• Customized CG SVP Workflow Process based on client (Wyeth) requirements.
• Customized Siebel application for performance improvements as per the business requirements.
• Using Siebel tools interface, configure the application, which uses some of the vanilla components. Extended new database columns and Applied and Activated to Database layer. Configured vanilla business components, business objects to support screens, applets and views to meet the business requirements. Map the logical fields of the business components to the original database fields.
• Mentored other developers in troubleshooting and writing scripts for pre-validation and post-validation of data.
• Installed Siebel Servers for Development and Test environments

Environment: Windows XP Professional, Siebel Life Science (SIA) e-clinical 7.8.2.0v, Oracle 9i, SQL/PLSQL, SQL Loader, IIS server 5.0v

Confidential, Bangalore India
System Analyst Dec 2005  Apr 2007

GE Commercial Finance (GECF) is one of General Electric\'s (GE’s) largest "growth engines". With lending products, growth capital, revolving lines of credit, equipment leasing of every kind, cash flow programs, asset financing, GECF plays a key role for client businesses. The Siebel implementation for the following two major businesses of GECommercial Finance: Commercial Equipment Financing - CEF, Commercial Equipment Financing (CEF) falls under GE Capital\'s Mid-Market Financing group and provides innovative solutions to the ever-changing equipment financing and asset management needs of growing companies around the world.

Responsibilities Included

• Created upgrade plan and checklist for Test, Dev and production environment.
• Using Siebel Tools merge your existing repository with the repository in the new release. Postmerge utilities upgrade form applets and verify that applets and views are configured correctly.
• Used Siebel eScripts for defining Business Services and also to extend data validation beyond the validation already provided in the Siebel standard applications
• Design and Develop Siebel Virtual Business Components for real-time legacy integration
• Design and Develop EAI XML Interface connecting Siebel EAI and Java Servlets
• Used Siebel Tools and added new functionality like buttons, customized validations in Order Entry Modules using:Business Components & Business Objects, Applets, Views, Screens & Application.
• Determined and documented the responsibilities needed for each position within the application.
• Responsible for enhancement the current eScripts to meet new business requirement and performance tuning of the application.
• Designed Workflow Processes for Inserting and Updating fields in Business Components
• Developed high level Design documents for data mapping of various function points discovered during Discovery and Design stage

Environment: Windows 2000 Professional, Siebel Financial Services 7.5v, Oracle 9i, SQL/PLSQL, SQL Loader.

Confidential, Bangalore India
Application Programmer Jul 2005  Dec 2005

Siebel Loyalty allows companies to build customer loyalty by creating reward programs and promotions. For example, it can be used to create and manage like Frequent-Flyer programs for airlines. To design a loyalty program we must do the research and analysis to determine whom our best customers are and how we want to affect their behavior. Depending on our business model, we may want to increase frequency of a customer’s Interactions; the total dollars spend per transactions, the total life cycle of the customer, or other behavior.
Responsibilities Included

• Involved in the EIM data mapping from Staging database to the Siebel 7.7.2.1 DB.
• Built SQL procedures for each entity based on the business requirements to migrate data from Staging Database to Siebel Interface tables (EIM tables).
• Created the IFB files (Control Files) used to execute EIM tasks for Accounts, Contact, Address, Service Requests, Activities, Products, Correspondence, Programs, Employees, Positions objects.
• Executed the EIM tasks to load the data in to Siebel DB from Siebel Interface tables.
• Content development (Create new QTP scripts from Test Plan)
• Porting QTP scripts from 7.8 to Siebel8.0V
• Performed Testing in both Manual & Automation Mode.
• Bug finding and filing in eBiz (Siebel Defect Tracking system).
• Troubleshooting of Siebel EIM processes on all entities.

Environment: Windows 2000 Professional, Siebel Loyalty, TNT 7.5v, Oracle 9i, SQL/PLSQL, SQL Loader.

Confidential, Pune India.
Software Engineer June 2003  Feb 2005

e-Volve SME is a customized CRM application for the BT SME sales and Ordering agents. The e-Volve SME application enables the ordering of various BT products like PSTN, ISDN, Business Highway and Conversions between access products, select services, Inspiration switch, Compact plus switch and ancillary equipment. The ODM (Operational Data Management) system feeds the business data (customer data, Order data, products data) from Mainframe systems (CSS, COSMOSS, CCAT) into siebel systems (e-Volve, Volume CRM, Converge). The Ab-Initio (ETL) tool helps to extract, transform and load the operational data from the MFS files into EIM tables and trigger the EIM process which will load the data from EIM tables into siebel base tables.
Responsibilities Included

• Involved in the design and deployment of Accounts, Contacts, Opportunities, Orders, and Service Requests.
• Configured Hierarchical (constrained) pick lists.
• Involved in the configuration of Applets, Views, Business Components and underlying business and data layer objects.
• Created link to associate the new child Business Component to parent Business Component according to the client requirement.
• Prepared PL/SQL procedures for Data Loading from Legacy systems into siebel schema through EIM.
• Involved in gathering requirements for Adding controls, creating and configuring pick applets and multi value applets, joins and links.
• Interacting with the Business Users and Prototyping the modules Service requests, Accounts and contacts.
• Created Abinitio Graph for Extracting the customer data from Legacy systems, cleansed using Abinitio and Loaded into Siebel Schema
• Siebel server and client installation and system setup with Oracle9i as the RDBMS
• Created Actuate Reports for Account, Opportunity and Service Request entities

Environment: Windows 2000 Professional, Siebel Call center (eVolve) SEA 6.8, 7.0.4v, Oracle 8i, SQL/PLSQL, SQL Loader.

Confidential, Mohali India.
Associate Software Engineer June 2002  Feb 2003
Infinys is a flexible, integrated product that enables wireline carriers to provide comprehensive customer lifecycle management. Infinys is an integrated product that provides a flexible, powerful, and scalable solution for next-generation telecommunications, IP, and convergent service providers. The Product Management module utilizes the Geneva Product Configuration, Product Synchronization. The Customer and Account Management module utilizes Geneva (stores information only – except customer hierarchies, cost and budget centers), Address Validation Adapter and Payment Handler’s Authorization/Verification Module. The Service Order, Inventory, and Provisioning Management modules utilize the Cygent Customer & Order Management (COM). The Billing utilizes Geneva Bill Engine and Vertex Taxation.
Responsibilities Included

• Developed user interface as per the specifications in Siebel tools. Configured the Business Object layer expose the newly created Data Object Definitions
• Prepared data mapping from Legacy systems into siebel schema.
• Prepared .IFB file for EIM import and delete operations
• Created PL/SQL code for Data Re-conciliation between Legacy systems and siebel schema.
• Created custom joins and multi value links, custom business components and objects by modifying existing BOs and BCs
• Created pick lists and multi value groups
• Configured the user interface to add custom screens, views, Applets and controls
• Involved in the configuration of the customization process and move data using EIM from one environment to the other for Application Administration, which involves Employees, Positions, Responsibilities, Views, LOV’s and all the Reference entities.

Environment: Windows NT 4.0v, Siebel 2000 Call center, Oracle 8i, SQL/PLSQL, and SQL Loader.

Confidential, Bangalore India.
Software Engineer Feb 2001 - Aug 2001

Honeywell’s Primus Apex integrated flight deck offers pilots an intuitive alternative for turboprops and light to mid-size business jets. Primus Apex consists of a base system with unique options, which provide new capabilities and the flexibility to effectively meet new airspace mandates. Primus Apex offers new functions based on those available in the most sophisticated global business jets, including integrated auto throttle and graphical flight planning for exceptional safety and situational awareness. Honeywell’s system integration expertise combined with leading technological breakthroughs and world-class graphical displays provide the ultimate experience for pilots and operators.
Responsibilities Included

• Prepared test functions for CBIT functionality.
• Worked in DEOS RTOS for CBIT testing.
• Prepared C code file for test functions for CBIT functionality.

Environment: Primus Epic based DEOS (Digital Engine Operating System) RTOS for Air Craft, Core BIT, C/C++.