We provide IT Staff Augmentation Services!

Sr. Siebel Consultant (eai Specialist/ Lead Data Conversion) Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Sr. Siebel Consultant with over 11 years of diverse experience in Analysis, Design, Implementation in application development and system integration, Upgrading, Testing of Siebel Open UI, Siebel 8.x, Siebel 7.5.x eAutomotive, eDealer, Siebel Call Center, Siebel eMarketing applications and deliver post - sales support and solutions. 12 years overall IT experience.
  • Extensive experience in Siebel Development using Siebel Tools, Integration, Configuration, Scripting, Workflows & extensive customization of Siebel applications.
  • Practiced as Subject Matter Expert, Business Systems Analyst, Production Support Lead, Critical Incident, Problem Manager, Developer and Test analyst in various engagements.
  • Extensively worked as a Techno-Functional consultant in providing CRM solution with excellent business domain experience in Siebel eCustomer, Siebel Call Centre, Automotive, Siebel Financials.
  • Worked on a number of RFPs in the capacity of Techno-functional advisor. Developed POCs for such RFPs and presented to the client.
  • Good working knowledge with various project implementations including vast experience developing in Agile Scrum methodology.
  • Adept at facilitating sessions defining user requirements, providing the gap analysis, developing and delivering end-user training, creating and maintaining project schedules.
  • Extensive experience in architecture, systems analysis, design, implementation, testing and development on various Siebel applications including Call Centr e, Manufacturing Industry and Financial Service .
  • Vast experience in Siebel EAI - C ustom Web Services, Integration Objects, VBC, EBC, Data Mappings, HTTP, File Transports, Siebel XML Converters, Adapters, WSDL, XSLT, SOAPUI, symbolic URLs.
  • Completed 7 Siebel project Lifecycles. The projects covered the entire gamut of activities required in a typical CRM implementation i.e. Project Scope and Feasibility Study, Configuration & customization using Siebel tools, Data Mapping with Legacy system, EAI, Troubleshooting Logs, Bug Fixing.
  • Rich experience in designing EAI solutions using Siebel EAI components, Siebel workflow, Business Service and MQ Series.
  • Highly skilled and experienced in Data analysis, Data migration and Data integration.
  • Highly skilled in the Data tools such as Oracle SQL, PL/SQL, Siebel EIM, SQL Loader, SQL Developer, OBIEE Reporting.
  • Extensive experience in DataStage IBM Infosphere Version 11.5.
  • Worked in Architecting/Design of Data Migration Projects using SQL Loader, EIM, IBM Infosphere DataStage V 11.5.
  • Worked in Architecting/Design of Data Migration Projects using SQL Loader, EIM.
  • Hands-on experience in Siebel Open UI.
  • Familiar with Siebel Performance tuning and Siebel Upgrades.
  • Sound knowledge of Web Technologies like HTML, JavaScript, JQuery, CSS to implement usability features in OpenUI.
  • Strong Knowledge of OpenUI Framework and its AP.
  • Hands-on Experience in customizing PM/PR files.
  • Experience with customizing Siebel Web Templates used in OpenUI.
  • Proficient in debugging Siebel OpenUI related issues.
  • Worked on integrating Siebel CRM Desktop with Outlook as a Lead Architect.
  • Vast experience in Requirement gathering, Analysis, Design and experience in creating Requirement Document with business, Functional Document and Technical Design Document.
  • Provide programming, technical & functional assistance to team & peers.
  • Strong knowledge in Best Practices and highly experienced in configuring objects on best utilization of Siebel out of the box solutions.
  • Extensively involved in resolving the issues found during Unit Testing, System Integration Testing and User Acceptance Testing.
  • Extremely motivated with good inter-personal skills, have ability to work under strict deadline
  • Ability to adjust in new environments, circumstances, with a drive for results through self-motivation.
  • Experience managing onsite-offshore module.
  • Experience in Team Leading.

TECHNICAL SKILLS:

Siebel Skills: Siebel 8.1/8.0/7.8X/7.7 Siebel Tools, e-Script, Workflow Manager, EAI, EIM (HTTP, Web Services), Siebel Call Centre, Siebel Marketing, Siebel eAutomotive, Siebel eDealer, Siebel Finance, Assignment Manager VBC, EBC, SOAP, Open UI - Presentation Model, Physical Renderer, jQuery, CSS, Themes, State Models, CRM Desktop, Data Validation Manager DVM, Data Quality Manager DQM . OBIEE Report

Programming: Java script, Shell Script, SQL, PL/SQL, HTML, XML, XSLT, Python, C, C++

Integration Technologies: XML, Web Services, Oracle SOA Suite, MQ Series, HTTP Transport, XSLT, SOA

Database: Oracle 9i, Oracle 11g, SQL/PLSQL, IBM DB2, MS AccessOperating SystemWindows 95/98/NT/2000/XP, UNIX, MS - DOS

Tools: Toad, SQL Developer, SQL*Loader, Rfhutil, SOAP UI, VISIO, XML, Actuate Reports 6.0, BI Publisher, Reporting, IBM DataStage Infosphere

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Siebel Consultant (EAI Specialist/ Lead Data Conversion)

Environment: Siebel 8.1.1.14 eAutomotive and eMarketing application, Open UI, Siebel Tools, Siebel EIM, Siebel EAI, Siebel Configuration, Scripting, Workflow, Business Service, Web Services, Siebel Administrations, Java Scripts, jQuery, CSS, SWT, Oracle SOA Suite, IBM DB2, BI Publisher, OBIEE Reporting, IBM DataStage Infosphere

Responsibilities:

  • Work closely with business for gathering requirements for enhancements.
  • Coordinate with users and Business Analysts to determine and finalize the requirements.
  • Responsible for joint application requirement and design to understand business needs; preparation of process document and high-level design document.
  • Coordinate Siebel team with external teams to complete integration activities.
  • Create data mapping between Siebel and Oracle could for integration.
  • Created internal and external Integration Objects and wrote eScript code to transform telematics related data from external systems in to Siebel Data and vice versa.
  • Designed workflow architecture, configured workflow processes and business services for different triggering events of the interface, Configured Business Services for use by workflows.
  • Designed and developed inbound and outbound web services to retrieve and update telematics related data using Oracle SOA Suite as middleware. Created and modified integration Object, developed custom business service to invoke webservice and implement security for invoking web service.
  • Extensively involved in using eScript to code the Siebel events and implement business logic at client level.
  • Perform end to end testing to satisfy the requirement.
  • Perform interface testing using SOAP UI.
  • Resolve communication issues between components and or applications and aggressively fix programming issues that lead to the application issues.
  • Supported system testing, UAT, performance testing and post production support activities.
  • Performed one-time data conversion using IBM Datastage Infosphere and SQL Loader. Developed Unix shell script to automate the load process.
  • Worked on production support’s ticket related to Order Management.
  • Customized and created new BI Publisher list and master-detail reports.
  • Supporting the Siebel Application in CIT and SIT testing environment thereby resolving any defects.
  • Work closely with business for gathering requirements for enhancements
  • Coordinate with users and Business Analysts to determine and finalize the requirements
  • Responsible for joint application requirement and design to understand business needs; preparation of process document and high-level design document.
  • Automated the process of loading FOTA affected Vin list into Siebel using DataStage job, SQL loader and Unix shell scripting.
  • Customized Siebel objects like business object, business component, applets, views, screen to create FOTA campaign and assign Vins from UI.
  • Created outbound web service to send any update on FOTA campaign and the list to RedBend using Oracle SOA Suite.
  • Created and modified integration Object, developed custom business service to invoke webservice.
  • Designed workflow architecture, configured workflow processes and business services for different triggering events of the interface, Configured Business Services for use by workflows.
  • Created inbound web service to process FOTA claims submitted by Redbend through SOA Suite and submit a server component task to run the claim through claim engine process.
  • Perform end to end testing to satisfy the requirement.
  • Perform interface testing using SOAP UI.
  • Resolve communication issues between components and or applications and aggressively fix programming issues that lead to the application issues.
  • Supported system testing, UAT, performance testing and post production support activities.
  • Work closely with business for gathering requirements for enhancements
  • Coordinate with users and Business Analysts to determine and finalize the requirements
  • Responsible for joint application requirement and design to understand business needs; preparation of process document and high-level design document.
  • Created external tables, external business component, applets, views.
  • Mimicked Siebel out of the box server request job using external tables.
  • Developed complex oracle stored procedure, function and packages to perform data validation, data manipulation before loading data to Siebel external tables.
  • Generate report with error. Post correction reprocess the data.
  • Work with Oracle SOA Suite to Integrate with SIS (Handles SIS Credentials, Polling Frequency, writes response as-is to DMS Staging Tables)
  • Schedule and submit server request job for all dealers (to get Deals, Repair Order, Inventory and Parts detail) in Siebel.
  • Automate the entire process of integrating DMS data.
  • Schedule oracle DBMS scheduler job to process any server request job submitted in Siebel.
  • Created data mapping for one-time data conversion, creating control files, IFB files, Unix shell script for executing the interfaces.
  • Developed and scheduled DataStage job to sync DMS data from Siebel to WebD database(Legacy).
  • Create materialized view and write complex PL/SQL query for Reporting.
  • Involved in SQL Query tuning and provided tuning recommendations to DataStage jobs, time/CPU consuming queries
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
  • Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
  • Work closely with business for gathering requirements for enhancements
  • Coordinate with users and Business Analysts to determine and finalize the requirements
  • Coordinate Siebel team with external teams to complete integration activities
  • Designed workflow architecture, configured workflow processes and business services for different triggering events of the interface, Configured Business Services for use by workflows.
  • Developed complex eScripts to achieve the business requirements.
  • Designed and developed workflow to send out emails to FSE with the attachments related to service request. Used Outbound Communications Manager for e-mail notifications.
  • Configured Business Layer Objects like Asset, Vehicle Service History, Account, Contacts, Service request, Activities, Products, Agreement as per customer requirements.
  • Designed and configured List Applet, Form Applet, Pick Applets, MVG Applet and Picklists as per customer requirement
  • Configured specialty objects such as Drill Down and Toggle for applets.
  • Designed the Workflows to manage the flow of Work in a Business process using Business Objects, Business components with the pre-defined actions such as Notifications, Assignment, Database Operations, view navigation, Integration requests, and Server component requests along with exception handling.
  • Created various workflow processes and policies.
  • Populated EIM tables using EIM Mapping Wizard and other techniques.
  • Configured EIM configuration files (.ifb) prepared the interface tables and Imported data into Siebel Base tables.
  • Coord inate with users and Business Analysts to determine and finalize the requirements
  • Actively involved in upgrade from Siebel IP14 (HI) to IP15(OpenUI) and resolve conflicts resolution.
  • Coordinate Siebel team with external teams to complete integration activities
  • Implemented JavaScript Open UI jQuery file to fix Providers form applet controls overlapping in chrome browser issues.
  • Wrote custom jQuery controls, color list rows differently based on other field's value, etc.
  • Created Custom PM’s and PR’s JavaScript to implement Open UI feature slider on cotrol name.
  • Created custom PM’s and PR’s JavaScript to validate email address.
  • Created custom PM’s and PR’s JavaScript to toggle applet(show and hide fields conditionally) based on field value.
  • Worked on Java Script, CSS, XML, Web Template files to implement usability features.
  • Updated .CSS file(theme-mb-structure-ext.css) to change the theme of the applet.
  • Update .CSS file to change the screen icon.
  • Apply customm CSS styling for colorbox classess in the main .CSS file theme-aurora.css
  • Modified .SWT files to fix collapse and Expant of Applet.
  • Created plugin wrapper and use jQuery dialog method to expand the text from textarea.
  • Troubleshooting issues in field focus in Java Scripts and implemented custom functions on field focus on child applet fields.
  • Configured Business Layer Objects like Asset, Vehicle Service History, Account, Contacts, Service request, Activities, Products, Agreement as per customer requirements.
  • Designed and configured List Applet, Form Applet, Pick Applets, MVG Applet and Picklists as per customer requirement
  • Resolve communication issues between components and or applications and aggressively fix programming issues that lead to the application issues.
  • Supported system testing, UAT, performance testing and post production support activities.
Confidential

Sr. Siebel Consultant/Lead

Environment: Siebel 8.1.1.11 Patch Set 17 eAutomotive application, Open UI, Siebel Tools, Siebel EIM, Siebel EAI, MQ Series, IBM DB2, OBIEE Reporting

Responsibilities:

  • Leading the development team of 3 people and support team of 3 People.
  • Work closely with business for gathering requirements for enhancements.
  • Coordinate with users and Business Analysts to determine and finalize the requirements.
  • Coordinate Siebel team with external teams to complete integration activities.
  • Successfully designed and developed interfaces based on Web Service, MQ and HTTP Transport.
  • Worked on various Siebel Inbound and Outbound interfaces between Siebel, Legacy CIS & CC .Net Application which involved building the workflow framework with custom business services, Siebel Data Maps and run time events to insert/update data.
  • Primarily involved in integrating Siebel with RBA .net application hosting dealer locator site. Created inbound web service and used SOA as middleware for sending and receiving soap message when the request is submitted through RBA site.
  • Primarily involved in integrating Siebel CRM with legacy eDeal SPA System to process Truck SPA (Special Pricing Authorization) requests from dealers and NAMs (National Account manager).
  • Tested the interfaces via SOAP UI, RfhUtil and end-to-end to satisfy the requirements.
  • Primarily involved in Data Mapping for loading the Legacy data, creating control files, IFB files, batch files for executing the interfaces. Worked on major data loads involving the entities like Account, Contacts, Address, Position, Employees, Responsibilities, Response, Opportunity, Activities, Asset, Products, and Assessment.
  • Primarily involved in performance tuning during data load and automate the data load process using batch scripts.
  • Worked with Patch Updates and version Upgrades. Upgrade from 8.1.1.7 to 8.1.1.11, Open UI.
  • Modified OBIEE reporting to include an Account Planning report (BI Publisher) as well as the ability to view Activities and Purchase Potential by Month and other aggregations.
  • Work with the offshore team for complete design, built, review and Unit testing.
  • Worked on EIM Interfaces to load pricing and product data from legacy system.
  • Worked on Workflow process, eScript, Inbound and Outbound Web Services to achieve Order Submission and fulfillment.
  • Developed outbound Workflows, Workflow Policies for automation of order
  • Configured Product and Pricing module in Siebel Application
  • Worked on production support’s ticket related to Order Management.
  • Supporting the Siebel Application in CIT and SIT testing environment thereby resolving any defects.
Confidential, Illinois

Sr. Siebel Consultant

Environment: Siebel 8.1.11 eDealer Application, OpenUI, Siebel Tools, MQ Series, Oracle 11g, IBM MQ, Siebel Actuate, OBIEE Reporting, SOA, Agile methodology.

Responsibilities:

  • Activel y involved in upgrade from Siebel 8.1.1.7 (SIA) to Siebel IP14 (HI), OpenUI upgrade 8.1.1.11 in conflicts resolution.
  • Fixed all issue identified during siebel upgrade to Open UI. Issue like grid layout, double horizontal scroll bar, Vertical scroll bar missing, "Edit Layout" button is not able to move applet up or down, iHelp listing in Screen Home Page not being rendered, Applets not contained in the boundaries of screen, Applet field label name wrap.
  • Written PM and PR java script files for long description text area field issue.
  • Created Custom PM’s and PR’s JavaScript to display salutation applet in home page (which was not visible earlier).
  • Created Custom PM’s and PR’s JavaScript to implement Open UI features like color code account record in list applet based on account status (Active, Inactive, Terminated).
  • Worked on Java Script, CSS, XML, Web Template files to implement usability features.
  • Developed complex workflow for outbound interface . Created Integration Objects and Business Services for business logics.
  • Successfully designed and developed interfaces based on XSLT transformation and MQ
  • Developed OBIEE reports.
  • Worked in configuring symbolic url to access third party applications from Siebel.
  • Worked on EIM for loading data from one extension table to another newly created extension table.
  • Developed complex eScripts to achieve the business requirement.
  • Questioning, Interviewing and Brainstorming with the user for requirement analysis.
  • Responsible for preparing joint requirement document and functional document and traceability matrix.
  • Created technical design document.
  • Worked with the offshore team for built, review and Unit testing.
  • Supporting the Siebel Application in SIT and UAT testing environment thereby resolving any defects .
Confidential, Illinois

Sr. Siebel Consultant

Environment: Siebel 8.1 Siebel eDealer Application, Siebel Tools, Siebel EIM, EAI, OBIEE Reporting, MQ Series, IBM DB2.

Responsibilities:

  • Leading the offshore integration team of 7 people.
  • Responsible for joint application requirement and design to understand business needs; preparation of process document and high level design documents.
  • Successfully designed and developed interfaces based on Web Service, MQ and HTTP Transport.
  • Primarily involved in design and developed real-time integration between Siebel and DAX Sales Order System using Siebel EAI (Business services, VBC, Data Mappings, HTTP, File Transports, Siebel XML Converters, Adapters, WSDL, XSLT, SOAPUI, Workflow and Integration Objects).
  • Worked on various Siebel Inbound and Outbound interfaces between Siebel, Sterling and workspace which involved building the workflow framework with custom business services, Siebel Data Maps and run time events to insert/update data.
  • Coordinate Siebel team with external vendor iCRM to complete integration activities.
  • Performed complete technical design, development and deployment of full scale Siebel CRM desktop integration with outlook for truck and dealer business group.
  • Primarily involved in creating new object manager for CRM Desktop Integration. Create LDAP user account.
  • Worked with data security team to setup user in TAM.
  • Created responsibility and user setup up in siebel to download the package when performing initial sync.
  • Involved in creation and modifying outlook package and metadata file for both truck and dealer instance based on business needs.
  • Modified existing integration object for Account, Opportunity, Contact and Activities and generate the XSD and follow-up with iCRM developers to in corporate the changes done in Siebel to be available in outlook.
  • Successfully upgraded CRM Desktop from version 3.5 to 3.9.
  • Involved in implementing various CR’s related to the areas like Siebel 8.0 Configuration, EIM, EAI, eScripting, Workflow, Assignment Manager.
  • Primary involved in building custom sales team assignment (STA) tool for pilot dealership. Created custom table, business service, and workflow. Used complex SQL queries, stored procedure, cursor and packages.
  • Primarily involved in designing and creating user interface objects like BC, Applets, View, Screen and customizing the same for Sales Team Administration (STA). This tool would assign sales rep to all customer at dealership under his territory (Area of responsibility) based on Zip code.
  • Supporting the Siebel Application in CIT and SIT testing environment thereby resolving any defects.

Confidential, Illinois

Siebel Consultant

Environment: Oracle 11g, PL/SQL, AIX, Siebel 8.0.0.10, Siebel Tools 8.0, Siebel 8.0 Client Application Configuration, Siebel EIM and EAI (Inbound and Outbound Web Services), eScripts & Administration and Workflows, IBM MQ, Siebel Actuate, OBIEE Reporting, SOA, Agile methodology.

Responsibilities:

  • Leading the Siebel Scrum Team of 6 while working under Agile methodology.
  • Delivery of the requirements/stories using the Agile Framework.
  • Working with the client to understand business needs and objectives and assist in the design and implementation of new solutions.
  • Primarily involved in design and development of real time integration and batch integration of Lease, Retail Notes and Repo Transactions submission in legacy system to sync to Siebel using EAI. Worked with Workflows, XML, DTDs, Integration Objects, HTTP and MQSeries as the transporting agents to achieve integration.
  • Involved in design and development of real time integration of payoff quote (repossession) initiated in siebel and sync to legacy lease management system using EAI. Worked with Workflows, XML, DTDs, Integration Objects, HTTP and MQSeries as the transporting agents to achieve integration.
  • Extensively worked in real time integration of Siebel application with third party vendor to perform vehicle inspection for repossessed vehicles by configuring VBC's, developing secured web services.
  • Designed the Workflows to manage the flow of Work in a Business process using Business Objects, Business components with the pre-defined actions such as Notifications, Assignment, Database Operations, view navigation, Integration requests, and Server component requests along with exception handling.
  • Review and clarify requirements, estimate the work, develop designs/solutions to support defined business requirements, and provide technical guidance and support to other team members.
  • Addressing client’s issues / concerns raised during showcase and providing solution recommendations.
  • Configured Siebel eAutomation application using Siebel Tools to customize Applets, Business Components and Business Objects, MVG’s, Picklists and Extension tables wherever necessary.
  • Assisted and mentor the team with daily issues, tasks involved and lead the design effort from the front along with the Solution Architect.
  • Supported system testing, UAT, performance testing and post production support activities.
Confidential

Software Engineer

Environment: Oracle 10g, PL/SQL, AIX, Siebel 7.8, Siebel Tools 7.8, Siebel 7.8 Client Application Configuration, Siebel EIM and eScripts & Administration and Workflows.

Responsibilities:

  • Primarily involved in Data migration for any new merger or acquisition done by HP.
  • Primarily worked in Admin data, Accounts, Contacts, Addresses, Quotes, Orders, Assets, Account Profiles, Products, campaign and responses
  • Prepared the Data Mapping Sheets for various entities
  • Design Data Migration Logic between source and Target Systems
  • Created custom Columns as compared with source system and new design document
  • Executed EIM Import, Delete, Merge, Export tasks
  • Execute EIM Task to load data from source database/flat files to EIM tables and populate the base tables
  • Developed IFB Scripts for EIM Tasks for all the entities
  • Developed PL/SQL procedures, Cursor, Packages for data conversion
  • Extended siebel table by extending the columns as per the requirements
  • Generate ad-hoc reports using SQL queries based on the User requirement
  • Configured BC’s, Applets, Views and Screens to support the customization
  • Created business objects, business components, standard & custom table extensions, Screens, Views, Applets, static and dynamic pick lists, multi value links, and multi value groups
  • Configuration and creation of business components links and joins customizing to the customer requirement.
  • Designing and implementing of pick lists, drilldowns and dynamic drill downs
  • Customized the application using Siebel eScript as alternative to configuration extending the functionality
  • Created virtual Business Component with custom code for additional functionality and validation.
  • Guide the QA Data Migration Team in coding the test cases to make sure Data Migration Successful
  • Involved in handling fallouts/Bugs in the Siebel System Database Level
  • Worked in modifying existing workflows to suit the change in business requirements
  • Involved in preparing and executing the test scripts which involved setting up the data to execute the test cases
  • Monitor the batch Jobs and handle any issues when fails due to some reason
  • Communicating with onsite team on daily basis through emails and Telecons

We'd love your feedback!