SUMMARY

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

Skills:

• CRM Applications: Siebel eBusiness Applications SEA 8.1.1.7v, 8.1.1.5v, 8.1.1.3v, 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.
• 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: Oracle 10g SOA Suite ESB Enterprise Service Bus
• Reporting Tool: OBIEE 10.2v, OBI Publisher 11g

PROJECTS

Confidential

Siebel Developer

Presbyterian Healthcare Services is a not-for-profit system of hospitals, a health plan and a growing medical group. For more than 100 years, Presbyterian has been committed to a single purpose -- improving the health of the patients, members, and communities we serve. Presbyterian reinvests the margin we earn into better health care for New Mexico. We have no shareholders to satisfy only fellow New Mexicans to serve. We have reinvested more than 350 million into local health care in the last five years.

Responsibilities included

• Implemented new custom Inbound interface Siebel EAI for provider to add attachment for their claims using NPI and TaxID through JCAPS Queue.
• Implemented e-Script on BC level events Siebel e-Script to auto populate product code for each plan ID while new Inbound SR records coming from JCAPS Queue Web Form .
• Fixed data quality issues in members UCI batch interface using PL/SQL automation framework and Siebel EIM jobs for contact and asset entity.
• Prepared batch interface automations between Siebel EIM FACETS and Siebel to load providers entity in weekly interval.
• Implemented batch assignment Assignment Mgr on Service Request for all closed SRs for more than 30 days or 60 days to EWCM Report administrator position.
• Using Siebel tools configure the new UI and Business Object enhancements and provide fixes for Siebel application related bugs.
• Implemented javascript Open UI Jquery file to fix Providers form applet controls overlapping in chrome browser issues.
• Implemented siebel Inbound Webservices to Siebel EAI send Siebel notes to FACETS while PCSC agents using Genesys CTI inbound calls.
• Prepared Siebel custom ASI services to create SR in to Siebel EAI Siebel for every complaint created using EWCM web Advocate portal application by members/patients.
• Troubleshooting Siebel browser related issues in PCSC and EWCM agents and siebel production server's performance related issues.
• Performed Cross Platform Upgrade UPGREP , Merge and Post Upgrade operations in Solaris environment from Siebel 7.7 to 8.1 Siebel SIA Financial Services application.
• Identify the issues related to Siebel performance tuning and interact with network and database teams for the performance related issues.
• Provide training to the EWCM PCSC users once the new enhancements has been delivered in Siebel application.
• Fixed Siebel OpenUI browser issues with Facets and Genesys GUD bridge SDK compatibility for PCSC's CTI users on call with members.
• Implemented custom Java Scripts scripts to enable First DOS/Incident field based SR created field logic on Applet Load Event.
• Troubleshooting issues in field focus in Java Scripts scripts and implemented custom functions on field focus on child applet fields.
• Implemented code on SR Bus comp to send Siebel e-Script email notification on SR Owner change or status changed to closed
• Prepared custom assignment attribute, Assignment Mgr assignment Object and assignment criteria for assign the inbound SR PHS/PHP to appropriate EWCM coordinators.

Environment: Siebel 8.1.1.11v, e-Script, Windows XP, Genesys CTI Tserver 8.0v,Agile Scrum, GUD bridge, FACETS 5.0.1v, Eclipse, JQuery, IE10v, Oracle 11g R2, IIS server 7.5v, PL/SQL.

Confidential

Siebel Developer

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.
• Implemented custom business service and coding on e-Script BC level events to restrict non-managers to update SR record on closing status.
• 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 interface between Oracle Apps Invoicing, Billing business models.
• 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
• 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, Agile Scrum, Siebel 8.1.1.5, IIS server 7.5v, SAP, eBIZ systems, SQL, PL/SQL, Informatica 8.6.1.0v, OBIEE .

Confidential

Siebel Developer

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.

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
• Converted MSSQL server from Non-Unicode to Unicode database to support internationalization for 16 bit codepage support for multiple languages.
• Implemented same Oracle Apps Organization GL, LE, Sub Ledger structures in to Siebel to after Siebel upgrade and update new organization structures in to Siebel.
• 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

Siebel Developer

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, TSQL scripting, Siebel 7.7.2.11 eService, IIS server 5.1v.

Confidential

Siebel Developer

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