siebel consultant Resume

Title
siebel consultant

Primary Skills
Siebel EIM/Informatica ETL/Actuate Reports/Oracle Plsql

Location
US-NJ-Edison

Posted
Oct-07-08

PROFESSIONAL SUMMARY

• Over 6 years of progressive experience in various phases of IT project life cycle
• Concentrated highly on the Siebel application suite and has hands on experience on Siebel 7 and above
• Strong in Siebel (CRM, PRM and Consumer Goods), Oracle PL/SQL
• Experience in designing and developing of interfaces using Siebel EIM for Data Integration.
• Siebel eBusiness Enterprise Applications Implementation experience including eChannel, eConsumer Goods, Siebel Call Center and Siebel eSales.
• Siebel CRM experience with expertise in Configuration, Scripting, Workflow, Assignment manager and Integration of Enterprise applications, Siebel CRM product and tools, Siebel Business Services.
• Configuring Applications using Siebel Tools and Siebel eScript.
• Designed the ETL processes using Informatica to load data from non homogeneous source system (File source and Oracle) into the targets in to Enterprise Data Warehouse
• Excellent knowledge on OLTP using Siebel EIM and OLAP using Informatica, PlSql Scripts
• Excellent experience in ETL Development using Informatica, PL/SQL, SQL Loader
• Involved in configuring and customizing UI objects like applets, views, screens, Pick Lists, Drill down, MVG using Siebel tools.
• Excellent knowledge on Oracle database Stored Procedures, Functions, Packages and Triggers.
• Well acquainted with software development life cycle (SDLC)
• Having experience in design and execution of test scenarios and test cases for SIT
• Good experience in reporting tool Actuate eReport Designer Professional for Siebel Applications
• Good knowledge and understanding in preparing various documents required for testing environment

TECHNICAL SKILLS

CRM : Siebel 7.5 / 7.7 / 7.8 / 8.0
Siebel Applications : Call Center, Sales, PRM, Consumer Goods
Siebel customization tools : Siebel Tools, Siebel VB, e-Script
Siebel business automation : Workflow, Assignment Manager, EIM
ETL : Informatica 7.2
Reporting Tools : Actuate 6.0/7.0, Siebel Analytics
Testing Tools : Test Director
GUI Tools : Visual Basic 6.0
RDBMS : Oracle 9i, SQL Server, IDM DB2
Languages : C, C++, JavaScript, HTML, PL/SQL
Operating System : Windows NT/2000, HP-UX., SUN SOLARIS
Project Management Tools : Visual Source Safe 6.0

EDUCATION
• Master of Science in Computer Science.

TRAININGS

• Siebel Essentials, Siebel CCC trainings from Oracle University
• Corporate Training on Informatica 7.2




PROFESSIONAL EXPERIENCE


Thomson Reuters, Valhalla, NY June 08 -- Till Date
Siebel Consultant
Order Management -- RIA (Research Institute of America)
The Tax & Accounting business of Thomson Reuters is the leading provider of technology and information solutions, as well as integrated tax compliance software and services to accounting, tax and corporate finance professionals in accounting firms, corporations, law firms and government. Tax & Accounting includes the Professional Software & Services, Corporate Software & Services, and Research & Guidance business groups.
Responsibilities
• Design and development/enhancements of Batch Interfaces (Orders, Pricing, Product Conversions) using Siebel EIM, UNIX Korn Shell Scripts
• Involved with the production issues and provided fixes as part of the enhancement release.
• Perform bulk loads for Orders and Pricing (Volume and Attribute Pricing).
• Providing Extracts to the Down stream system from Siebel OLTP using Informatica ETL.
• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM
• Creating and modifying configuration (ifb) files to run the EIM tasks (Insert) in order to populate the base tables in optimal manner.
• Reviewed and analyzed the Application Requirements & mapped the requirements to Siebel Data Model.
• Data Layer changes like extending database table columns and applying the changes
• Scheduling the batch jobs using Crontab tabs.
• Involved with the migration of data from the Inbound system for integration
• Design and Development of Siebel Actuate reports for Quote, Products and Orders
• Involved with the configuration and customizing the reports objects using Tools
• Development and Support of Simple, Master -- Detail, Group and Parameterized Reports
Environment
Siebel Call Center 7.5.3, Siebel Tools, Informatica, IBM DB2 8.2, Solaris 5.8, Actuate 6.0

Hewlett-Packard, Marlborough, MA Apr 07 -- May 08
Siebel Consultant

HP - PRM
Loading the data through batch interfaces using EIM and need to extract data from OLTP to Downstream using Informatica ETL(Full & Incremental). For Integration HP developed a portal called DIF (Data Integration Framework). DIF provides the services EIM, Sql, Java, FTP, File services etc. Call the services by an XML through DIF portal.
Responsibilities
• Worked on upgrade of Batch Interfaces from Siebel 7.5.3 to version Siebel 8.0
• Design and development of Inbound and Outbound Siebel Interfaces for Data Integration
• Modifications to existing interfaces to load the required columns for Siebel Upgrade 8.0 as part of the Data Model Changes and enhancement requests for the existing interfaces
• Creating and Executing the Test Cases for the interfaces
• Development of complex Packages, procedures and functions for preprocessing of Data
• Running EIM Task after Analyzing and mapping legacy data into Siebel Interface tables
• Creating EIM mapping columns for the extended columns
• Involved in the analyzing, planning and execution of data transfer from legacy systems
• Data mapping of EIM tables to Base tables.
• Creating and modifying configuration (ifb) files to run the EIM tasks (Insert) in order to populate the base tables in optimal manner.
• Performed Data Mapping, Bulk imports of data in the Siebel database using EIM
• Involved in the analyzing, planning and execution of workflow process to enforce business rules
• Extracting data from Siebel Partner Application to MDE (Mass Data Extraction) using Informatica Workflows.
• Designed the ETL processes using Informatica tools to load data from non homogeneous source system (File source and Oracle) into the target Oracle database•
• Developed mappings/sessions using Informatica power center for data loading (Extraction, Transformation, Loading)
• Responsible for developing extraction /transformation /load (ETL) artifacts , using INFORMATICA 7.1.2
• Creating jobs in Informatica to transfer (ETL) from regional SBL-OLTP
• Knowledge sharing on all the related issues on Siebel Configuration, EIM, EAI, Workflow, Assignment Manager, Siebel Analytics and Actuate Reports
Environment
Siebel Partner Manager 7.5.3, eChannel, Siebel Tools, Informatica, Oracle 10g, IIS, Windows 2003/HP-UX and Toad.

Worldwide CRM, Hewlett-Packard, Houston, TX July 06 -- Mar 07
Siebel Consultant

World Wide CRM application of HP, that will serve the needs of each region while maintaining a world-wide architecture that complies with HP's CRM and eBusiness roadmaps. Primary components of this platform include a Web portal that will provide appreciation & advisory content, store customer profile, maintain customer account hierarchy, provide database for Appreciation & Loyalty Management. The project interfaces HP applications viz HPP, eProfile.
Responsibilities
• Built necessary Joins and Links among the business components to emulate the business processes and logic within the Siebel configuration
• Worked on Business Process Automation techniques of Siebel -- Assignment Manager and Workflow Policies and Processes
• Involved in configuration activities: Writing search specifications, Calculated fields, Field data validations using BC User Properties, Drilldown Objects and toggling
• Designed & Configured Screens, Views, List, Form and Pick applets and pick list as per business requirement. Configured special objects such as Drill Down and Toggle for applets
• Created joins, links and MVG applets. Configured Business Layer Objects like Product, Skill Set, Activities, Contacts, and Opportunities as per business requirements
• Extensive work on Siebel Tools for the configuration of Business Components, Views, Applets
• Created Business rules (Policies, Conditions and Actions) using Work flow manager
• Involved with Performance team assisting them on Performance testing on Siebel application
• Worked closely with Quality Assurance team to generate test cases for validating functional requirements
• Created Workflow policies and Assignment rules to automate sales related activities
• Data mapping of EIM tables to Base tables.
• Developed Informatica ETL mappings that validate Header/Trailer records and generate the same for outgoing feeds for down stream applications.
• Involved in developing Batch Scripts to run the sql scripts.
• Worked on improving the performance of Complex SQL's and PL/SQL scripts by applying various performance techniques using hints, indexes and also looking query's explain plan.
• Involved in code migration to TEST, QA and PRODUCTION using Harvest packages.
• Involved in writing implementation plans for code migration for various environments like TEST, QA, and PRODUCTION.
Environment
Siebel Call Center 7.5.2, eSales, eService, Oracle 9i, PL/SQL, Windows Batch Script, Toad, Informatica, Xml

Procter & Gamble (P&G), Cincinnati, Ohio Oct 05 -- Jun 06
Siebel Developer/Configurator
Trade Promotions Management project is to access the feasibility and impact of managing Category Development Fund (CDF), Deduction and Liability Accounting processes using Siebel. All funds, including CDF are defined, tracked and managed in Siebel. All promotions are defined, tracked and managed in Siebel. Deductions data sent by the Integrated systems will be resolved in siebel and sent back to the assigned system.
Responsibilities
• Designing and Developing the Actuate Reports for Trade Promotions, Fund Categories, Fund Participants, Products, Product Categories, SVP
• Developed Simple, Master -- Detail, Group and Parameterized Reports
• Involved in the integration for the Siebel server and Actuate iServer
• Implemented using the Actuate VB to organize and filter the report data coming from different data streams.
• Generating Reports in Actuate Ver.7
• Administrating the Reports and the users in Report Server
• Created Stored Procedures required for report
• Managing Reports in Report Server
• Report User administration in Report server
• Configuration of Applets/Business Components to suite the client requirements.
• Developing Interfaces using Business Services, Workflow Processes.
• Developing 6 integration modules which import/exports the data to and from siebel in batch mode.
• Creating technical specification for the interfaces.
• Implementing Error and File Handling in Interfaces using a modular approach.
Environment
Siebel eConsumer Goods, Windows 2000, Oracle 9i, PL/SQL, Siebel 7.8, Actuate eDesigner

IBM Global Services, India Sep 04 -- Oct 05
Siebel Consultant
Siebel Systems, Inc., USA
EEQA (Engineering Escalation Quality Assurance) QF's (Quick Fix) and Fix Packs
Handling the Fix Requests, Processing, assuring the patches and delivered to the Siebel customers and product testing for Life Science Application (ePharma & eClinical)

Responsibilities
• Handling the requests, analyzing the customer environment, setting the same environment on which the customer is presently using, reproducing the bug, and validating them by applying the patch (QF).
• Installing Application Server, Web Server, and Actuate Server on different platforms (Win/Solaris/AIX) based on the requirement.
• Setting the Heterogeneous environment
• Executing the Test Plans.
• Handling Reports server fixes.

UNILEVER -- Consumer Goods
Siebel Developer

UNILEVER is a consumer goods company and they are having wide range of Products such as Foods, Beverages, and Cosmetics etc. They are the biggest consumer company in the world. Implementing the application for different countries according to Organizational structure for around 16 countries

Responsibilities
• Developed and Configured Pick lists, Applets, Screens, Views, Links, Joins, Business Objects, Business Components to meet the User Interface Layer requirements.
• Customized Opportunity, Account, Contact, Service Request and Activity Management Business Objects to meet the business requirement.
• Developed new Views, Applets, MVG and Pick Applets to display relevant data. Created drilldowns leading to different views.
• Created new business components to meet the client requirements.
Customized the application to the best needs of the client.
• Customized Opportunity, Product, Account, Contact, Service Request and Activity Management Business Objects to meet the business requirement.
• Created Workflow policies and Assignment rules to automate sales related activities
• Created new logical fields by mapping with Newly Created Extension Columns in Accounts, Opportunities, Products and Orders-Order Entry Business Components.
• Defined specifications for Data Object, Business Object and User interface Object layers that best meet the customer's business requirements. Customize business objects, Business Components, Applets, Views and Screens to match requirements using Siebel Tools
• Configured changes as per the requirements for user interface, Business logic and data.
• Designed Business Objects, Business Components, Applets, Screens, and Views using standard Siebel design templates.
• Designed and Developed Siebel Actuate reports for simple, Master--Detail and parameterized reports.
• Implemented using the Actuate VB to organize and filter the report data coming from different data streams
• Generating Reports in Actuate Ver.7
• Administrating the Reports and the users in Report Server.
• Created Stored Procedures required for reports.
• Managing Reports in Report Server.
• Report User administration in Report server.
• Involved in code migration to TEST, QA and PRODUCTION.
• Involved in writing implementation plans for code migration for various environments like TEST, QA, and PRODUCTION
Environment
Siebel eConsumer Goods, Windows 2000, MS SQL Server, PL/SQL, Siebel 7.7, Informatica, Actuate eDesigner


Data Vision Technologies, India Aug 02 -- Aug 04
GMAC Mortgage Corp.,
Siebel Developer / Configuration
GMAC (Mortgage) does business with all the employees, customers working under General Motor's family. GMAC has several business units like first mortgage-finance, Second mortgage-finance, and planned to deploy customer-centered Siebel sales. Siebel sale was the software used for the Mortgage Corporation. Responsibilities:
Responsibilities
• Created Siebel UI components like Screen, View, and Applets. Part of developing the UI involved modifications.
• Created local databases for Siebel tool's developers and mobile clients.
• Translated business requirements into functional requirements for logical and detailed design documents, Siebel configuration changes and UI enhancements.
• Created business objects, business components, standard & custom table extensions, Screens, Views, Applets, static and dynamic pick lists, multi value links, and multi value groups.
Environment
Siebel Sales, Windows 2000, ORACLE, PL/SQL, Siebel 7

Zenith Computers Ltd.,
Siebel Developer / Configuration
Sales Application for Online Store is a callcenter application for online computer store that allows the sales person to interact with the customers and quote based on their requirements and provides a single, comprehensive view of all customer information
Responsibilities
• Configuring business objects and business components.
• Generating Applets, Views, Screens, MVG's and associating with the appropriate Business components.
• Created links and joins for the business components.
• Testing and created patches for existing application.
• Design and development of Actuate reports Quotes, Sales and Products.
Environment
Siebel Sales, Windows 2000, ORACLE, PL/SQL, Siebel 7, Actuate Reports 6.0

Fastener Financials, India
Software Developer
Sundaram Fasteners is a major supplier of fasteners to all the leading vehicles and engine manufacturers in India. The company's products are exported to various quality conscious markets like USA, UK and GERMANY. The project was to group data in the financial department to generate reports for different categories
Responsibilities
• Involved in writing procedural scripts using PL/SQL
• Involved in coding and testing of the system
• Created GUI for end users
• Stored procedures and triggers were developed for business rules
• Generated various types of reports by using Actuate reports
• Involved in implementation and documentation of the system
Environment
Oracle, PL/SQL, Windows NT, Actuate Reports

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Edison, NJ | Resumes in New Jersey

View other siebel consultant resumes, System / Network Administrator resumes