PROFESSIONAL SUMMARY:

• Experienced Siebel Certified (Core Consultant Course 8.0) Developer with 9+ years of diversified IT experience in Consulting, Implementation, Development, Configuration, Production Support and
• Customer Relationship Management (CRM) expert with around 8 years of experience on the Siebel CRM application suite and has realized valuable hands on experience in Siebel CRM Project engagements.
• Worked extensively with business team on the requirements and Solution blueprinting
• Solid project management skills and proficiency with explaining technical data clearly and concisely to non - technical staff
• Extensive experience on Siebel EAI, Custom Inbound/Outbound Web Services, VBC, EBC, Data Transformation Engine (DTE), Dispatch Rules, Data Mappings, HTTP, File Transports, Siebel XML Converters, WSDL, XSD, DTD, MQ.
• Solid experience in onsite-offsite-offshore model. Successfully led offsite-offshore team for 2-3 implementations from onsite. Offsite-offshore working experience with large team, transition and team building
• Closely worked with business users/BAs to analyze, gather and map requirements, solution recommendation, scope, costing, prototype and implementation.
• Excellent knowledge of best implementation practices, implementation issues, QA, deployment process, defect resolution process, support process, CRM fundamentals and technical documentation.
• Delivery and solution oriented, committed to customer satisfaction, self-motivated team player and good communication and interpersonal skills.
• Exceptional strategic planning, troubleshooting, and crisis management skills; passion for customer service; strong internal and external relationships; record of extraordinary results achieved through technology innovation and team inspiration.

TECHNICAL SKILLS:

Siebel Versions: Siebel 7.7/7.8/8.0/8.1

Siebel Technical Skills: Configuration, eScript, EIM, Workflow Processes, Assignment Manager, EAI, Tools, Siebel-VB, Business Services, XML/XSD, HTTP/JMS, Web Services, SOAP, Siebel Administration.

Siebel Web Applications: Call Center, Clinical, Loyalty, Sales, Communications, Marketing, Automotive, Universal Customer Master (UCM)

ETL Tools / EDI: SQL Server Integration Services (SSIS), Informatica PowerCenter 8.1.1

MDM: Informatica Identity Resolution (IIR)

Development Tools: Toad, SQL Developer, iSeries Navigator

Languages: C++, T-SQL, PL/SQL, JavaScript

Databases: SQL Server 2000/2005/2008, Oracle 9i/10g/11g, DB2

Operating Systems: Windows 7/XP/Server 2003, DOS, UNIX, AS/400

Internet: XML, HTML, CSS

PROFESSIONAL EXPERIENCE:

Senior Consultant - Siebel Order Management

Confidential, Columbus, IN

Responsibilities:

• Served as Solution Architect for Confidential 's Distribution Unit (DBU) to streamline their Service, Sales and Warranty repair processes to effectively use the real time data and serve their customers with accurate invoicing, inventory tracking, service & parts pricing.
• Work with users to gather requirements for design specifications.
• Responsible for the design, and development of the System Life Cycle for Order Management applications.
• Responsible for creating Solution Design Documents (SDD), Worked on inbound and outbound web services as part of solutioning and as a Proof of Concept (POC) for integrating internal and external interfaces like QSOL, iLog, UCM, EBS, O2C PIP etc.
• Provided business support as needed. As a member of Siebel Practice Foundation (SPF) team, responsible for providing Siebel Best Practices and perform code reviewswith programmers.
• Testing of the components/modules/subroutines developed as part of DBU NextGen project.
• Responsible for overall stability of the Siebel CRM applications.

Software Engineer - Siebel Order Management

Confidential, Saint Petersburg, FL

Responsibilities:

• Responsible for the design, development, testing, and support stages of the System Life Cycle for Order Management applications.
• Created and Identified Siebel Internal Integration Objects and mapped to External IO’s according to Business Requirements using Data Mappings and DTE and dispatching using EAI Dispatcher Servicer. Used Pre built/Custom EAI Business Services by using Integration Workflows.
• Worked on inbound and outbound web services for integrating internal and external interfaces like ADS, QAS, Campaign Management Systems etc.
• Design and develop code of low to high complexity.
• Work with users to gather requirements for design specifications.
• Document development and design work. Develop test procedures, write and execute QA test plans and perform validation on test results.
• Provide business support as needed. Participate in production supporton call rotation andPerform code reviewswith programmers.
• Follow the IT change management process.

Siebel Integration Expert / MDM Expert

Confidential, Roseland, NJ

Responsibilities:

• Manage a team of ETL developers to support the data migration needs of the enterprise.
• Consulted with client representatives/SME’s to gather business requirements.
• Actively engage in design discussions for all data migration initiatives.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Develop custom T-SQL stored procedures to perform ETL operations.
• Develop and maintain best practices for the successful design and deployment of Siebel solutions.
• Enforce adherence to Confidential ’s design, coding, and security standards.
• Lead for coordinating development effort for EAI related requirements.
• Develop Interface design documents and perform POC tasks.
• Providing Solutions to various EAI/EIM issues that occurred in the Production environment
• Design and developed Online Integration with Confidential ’s various benef Confidential s and Display its details in Siebel using VBC’s and EBC’s.
• Design & Development of the various benefits module in Siebel to display external systems data.
• Engage with the enterprise architecture group to provide thought leadership on technology discussions impacting Siebel.
• Developed Business services, EAI Data Maps, Scripting, Workflows, Policies and Assignment rules.
• Responsible for analyzing and clarifying the business requirements.
• Responsible for designing process based on the business requirements to shape the overall solution.
• Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations.
• Set Customer best practices expectations revolving around MDM.
• Part of a team that oversaw UCM tool evaluation and selection.
• Worked on solution performance (analysis/tuning) to ensure alignment between business solution definition and system architecture.
• Development of data synchronization, Extract, Stage and Load process from legacy (Billing, Payroll, Siebel CRM, Clarify CRM and Benef Confidential like FSA, COBRA, SASS, VE, SAM) to UCM. Successfully Migrated Data from 15 Legacy Systems in to UCM
• Responsible for the successful implementation of all assigned deliverables
• Drive Master Data Strategy, Data Governance/Standardization, Matching and Merging, Master Data Process Design, UCM Architecture and the Implementation.
• Advise Siebel UCMusage and design to best fit customer business process requirements
• Participated in discussion groups regarding ideal architecture for MDM/Siebel UCM and its interaction with customer business and technology topology.
• Provided Siebel product demonstrations and technical guidance to business users on the capabilities of Siebel UCM
• Involved in team that is implementing Address Standardization, data standardization using Address Standardization Module (ASM), Address Doctor and Informatica Data Quality (IDQ).

Siebel Integration Expert

Confidential, Reading, MA

Responsibilities:

• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Develop custom T-SQL stored procedures to perform ETL operations.

Siebel Integration Expert

Confidential, Morrisville, NC

Responsibilities:

• Creating Functional Design Documents (FDD’s) and Technical Design Documents (TDD’s).
• Played key role in design and development of key business entity for data sync between Siebel and central TMODS system.
• POC for data sync trigger mechanism using Run Time Events and EBC.
• Designed and developed custom error logging data structure and business service for integration error with auto resubmit mechanism.
• Developed integration objects and generic data driven workflow to sync data for multilevel (parent/child) business entities. Developed business service for soft delete on TMODS.
• Developed views/user-interface to monitor agent and executor repeating components processing status and transaction details.
• Worked on capacity planning and critical levels for component and distribution.
• Created stored procedures to take care of syncing merged records and related tables.

Siebel Technical Lead / Siebel Admin

Confidential, Niagara Falls, NY

Responsibilities:

• Lead technical teams successfully.
• Provide Clarifications on Business Requirements Document’s and Preparation of Technical Design Document (TDD).
• Preparing DEV Task Lists and Deployment Admin Task List.
• Manages Database Servers, Web Servers, Siebel Servers and its Components.
• Responsible for managing the entire deployment process.
• Deploying of SRF and Repositories from one environment to another.
• Coordinating with various teams such Configuration, Database, Integration and Business Intelligence teams.
• Designed and Implemented ETL from DB2 to Oracle DB using Informatica.
• Created reports using BI Publisher.
• Responsible for setting up DEV, UAT and PROD clustered Environment which includes Siebel Industrial Application SIA 8.1.1 (Siebel, Enterprise, Gateway and Web server) and Oracle 11g database server on DEV and UAT.
• Developed and designed necessary staging tables, PL/SQL scripts, IFB’s to import data using EIM.
• Imported sample data.
• Created users and local database extracts for development.

Senior Siebel Consultant

Confidential, Melville, NY

Responsibilities:

• Responsible for preparing table schema
• Manage new requirements in the existing Configuration.
• Customize the existing configuration if needed.
• Create and modify business objects, applets, views, and screens and adapt business components, fields, joins, and links using Siebel Tools.

Senior Siebel Consultant

Confidential, Boston, MA

Responsibilities:

• Customized and Created NewBC’s, BO, Links, Applets, Views, & Screensas per client’s requirement Using Siebel Tools.
• Worked onHierarchical Picklist, Search Specification, Pre-default values
• Modified Static and Dynamic pick lists, and used data administration to modify the LOVs.
• Worked onImplicit joinsand also createdExplicitJoinsto get and show data from some other table.
• CreatedCalculated fieldsand incorporated BC level user properties to make child BC’s read only based on the parent field.
• WroteComplex logic scripts to achieve certain business logic, which could not be achieved via configuration.

Siebel Consultant

Confidential, Newton, IA

Responsibilities:

• Responsible for leveraging and enhancing methodology
• Manage new requirements in the existing Configuration.
• Manage the configuration change formats, best practices if any.
• Customize the existing configuration if needed.
• Develop the user requirement in DEV, test in UAT and deploy the changes in the production.
• Create and modify business objects, applets, views, and screens and adapt business components, fields, joins, and links using Siebel Tools.
• Worked intensively on Order Management and Confidential custom screens like sales Order, CLLI, TBS Order, Tasks, Data Map, Sales Module, Engineering and Service Tickets.
• Experience working on data mapping to accommodate data structure changes.
• Interacted successfully with clients extensively, via phone and email.
• Manage the Siebel implementation process by coordinating business personnel and technical personnel to assure successful implementations of Siebel applications
• Develop status reports and other written documents in accordance with the recommended methodology.

Siebel Consultant

Confidential, Chicago, IL

Responsibilities:

• Monitor and maintain availability of Siebel Applications in all environments (DEV, TEST and PROD).
• Monitor/correct performance related anomalies.
• Participate in operational readiness reviews
• Manage and perform application deployment process
• Lead and perform determination and resolution of application failures
• Working on Siebel tickets.
• Assist in documenting, reviewing, and enforcing company standards and procedures
• Run reports as needed utilizing Siebel.
• Take on a technical lead role as needed for major rollouts and or changes to the environment.

Siebel Consultant

Confidential, Buffalo, NY

Responsibilities:

• Primary Resource for coordinating development for Siebel 7.8 Data Migration, Scripting and EAI related requirements. Develop Interface design documents and perform POC tasks
• Convert some of the EIM batch jobs during the Siebel upgrade to version 7.8
• Performed one time and daily EIM tasks Contact, Benefits and merging Duplicate Contacts using EIM Merge tasks
• Performed one time and daily EIM tasks to import File attachments of the document and faxes received from the customers related to Medical claims
• Creating IFB scripts, Custom Business service using eScripts, prepping batch data using Data warehouse tools
• Providing Solutions to various EAI/EIM issues that occurred in the Production environment
• Conducted knowledge transfer and sessions on Siebel EAI and EIM to client employees