Summary:

Meticulous Software Engineer bringing 11 years' experience in the Software, Energy, Banking and Semiconductor industry with In-depth understanding of web technologies with a focus on delivering innovative business solutions. Consultant serving corporations by bringing superior solution for Marketing, Order Management, Asset management, Property management and Process integration. Current objective is to work in exciting project to bring innovative solution for challenging requirements.

Qualification Summary:

• Around 11 years of experience in software development for UCM, Sales, Marketing, Order to Cash, Product management and Asset management.
• Managing on premises and off shore employees for work distribution.
• Around 6 years of Siebel Finance, Siebel eBusiness Enterprise Applications Implementation experience including Siebel Sales, Siebel Oil, Gas Chemical and Siebel Call Center, Siebel Marketing, Siebel Order Management.
• Industry experience includes Software, Semiconductor, Oil and Gas, Banking and POS systems.
• Siebel implementation with hands on experience in Integrating, Configuring, Installing and Migrating metadata.
• Proficient with CRM Implementation Methodology involving modification of Data Object Layer, Business Object Layer and User Interface Layer.
• Extensive experience in Customizing CRM application, Modifying Screen, View, Applet, BC User properties, eScripts, Data Import, Export and data load using EIM Enterprise Integration Manager , EAI and Web Services.
• Expertise in using pl/sql Package, Procedures, Function, Cursor and Triggers.
• Strong knowledge in SQL Loader, Exports Imports, SQL Optimization in RDBMS.
• Maintaining Database Security Using Profiles and Assigning Profiles to Database Users.
• Experience on Seebeyond, Informatica, FDM and AS400 job scheduler Robot.

TECHNICAL SKILLS

• CRM Siebel 8.1, Open UI, Siebel 7.7, Siebel 7.5.2, Siebel 6.x Tools Configuration, Migration, EIM, EAI, web Services , Installation
• Reporting Tool HFM, HFR, Cognos, Actuate, OBIEE Dashboard
• Scripting eScript, VB Script, SmartScripts
• CRM Modules Siebel Call Center, Siebel Order Management, Siebel Finance, Siebel Marketing, Siebel Sales, Siebel Workflow, Siebel EIM
• Programming Languages C, C , HTML DHTML, SQL, Pl/SQL, VB, JAVA
• GUI Visual Basic 6.0/5.0
• Middleware Seebeyond, Informatica, PL/SQL, FDM
• Database Connectivity ADO, RDO, DAO, ODBC and OLEDB
• RDBMS ORACLE 9i/8i, SQL SERVER 7.0, DB2, MS-Access
• Operating Systems MS-WINDOWS NT/2000/2003/98/95, Vista, UNIX, LINUX
• Tools Utilities SQL Loader, Exports, Imports, TOAD, SQL Navigator
• Package's MS-Word, MS-Excel, MS-Power Point.
• Data Model Siebel 7.0.3, Siebel 7.5, Siebel 7.7, Siebel 8.0
• Web Technology HTTP, IIS, Apache, WAP, XML, ASP, CSS
• OOP C , Visual Basic, Java

Confidential

Java Developer

Role Siebel Consultant

Environment: Windows 2003, Siebel 8.1.1.1, Siebel 8.1.1.7, Siebel 8.1.1.9 Siebel Sales, Siebel Call Center, Siebel Marketing, Siebel eChannel, Siebel eService EIM, eScript, Siebel Workflow Manager, SQL Server

Responsibilities

Confidential

Marketing Experience include Response creation, Response to Opportunity Creation, Smart Script, ESD, CTD, Integration with OBIEE, Creating Segmentation from OBIEE, Creating and executing campaign, offer treatment.

• Created Segmentation in OBIEE to run Siebel campaign
• Troubleshooting ESD, Segmentation and campaign
• Configuring workflow, business service for response creation and response to opportunity creation.
• Configuring accounts and partner for automated lead assignment.
• Cleaning up unwanted account and contact created by marketing offers.

Confidential

I have Installed Siebel Gateway, Enterprise, Siebel Server, Database server in windows environment. Siebel clients and tools installation is to setup developers. Installation includes LDAP connectivity. I have experience in maintaining Linux and UNIX systems. Data maintenance using Putty and shell scripts.

Confidential

The project is to convert Japanese Onyx Order management system to Siebel. Integrating Japanese text Service Request, Account, and Contact Attachments into one database english language records. Japanese language records are stored in Onyx system. Tasks include writing SQL scripts to collect data from ONYX database inserting into Siebel database and creating staging tables for organization conversion, LOV conversion, populating EIM staging table and running EIM jobs. Task activities are as bellows:

• Analyzing Japanese data in the database. Defining joins and structure of the data.
• Mapping columns from Onyx database to Siebel database tables.
• Analyzing relationships of data and converting them to Siebel Service request, Account, Contact, Asset, Attachments relationship applying demoralization
• Using Excel macros to clean data
• Preparing EIM tables with data using SQL scripts procedures.
• Creating ifb files and files systems to run EIM job.
• Optimizing EIM performance.
• Validating data after the process.

Confidential

Confidential is to remove duplicate and erroneous account and contact from the database to enforce data integrity. Two steps approach is used. First step is to identify and rectify duplicate data and second step is to introduce logic to prevent bad data to be allowed. Third party vendor was used to identify erroneous account. The tasks are as follows

• Identifying the erroneous account using third party list.
• Identifying internal logic to identify erroneous account.
• Identifying such accounts and contact associated with Order, and Service Request.
• Account and contact status delete or merge unwanted account using EIM.
• Identifying non recognizable XML characters from Asian languages using EAI.
• Setting up Data Quality to enforce data integrity.
• Running data quality jobs correct data.
• Enforcing unique email for contact using scripts in Business component level.

Confidential

Enterprise data is distributed among various enterprise applications. Marketing segment data reside in data warehouse, campaign and offer process resides in CRM systems. Integration between the systems allows up to date segments to be targeted in email campaign to market products in efficient manner. Responsibilities are as follows

• Symbolic URL is used to integrate data ware house and CRM marketing email campaign.
• Creating segments for product marketing based on specific criteria.
• Attaching offers to campaigns
• Creating segments for product marketing based on specific criteria.
• Executing response and measuring ROI
• Creating prospect from response
• Managing prospect and upgrading to contact.

Develop application for sales department to consolidate accounts across globe to give sales person global perspective of opportunity and sales activity. Assigning global account opportunity to sales people based on priority. Providing account hierarchy across globe and their associated contact to the designated sales person only.

Configuration/Siebel Tools

• Setting up and maintaining different Siebel environments for Development, Test, and Production.
• Gathering requirements from business user and business analysts.
• Converting process requirements into Siebel functional design, determining Siebel object best suited for requirements to available Siebel data model.
• Configuring using Siebel tools to define/modify objects-applets, views, screens to suit customer requirement.
• Modified and Created Web Applets, Views, BC's, BO's, MVG, MVL using Siebel Tools.
• Customizing functionality using BC User properties, Hierarchical List of values, eScript and workflow.
• Converting eScripts logic into BC user properties to reduce dependency on Scripts.
• Ensure Data validation using BC User properties, script.
• Creating activity automatically based on status of opportunity.
• Designed the Organization Division - Position structure and define the visibility rules with regard to positions and responsibilities.
• VBC for home page to increase performance

Confidential

Business process changes rapidly in technological edge to maintain competitive edge. Computer revolution is obscured by mobility computing revolution as computing power move from desktop to palm of our hand. Software upgrade is essential to migrate business process from standalone computer to paradigm shift mobile devices. Oracle Siebel CRM version 8.1.1.9 allows business user access their data across mobile platform such as IOS devices and Android devices. Responsibility performs software upgrade to Siebel 8.1.1.9 from 8.1.1.7 to facilitate mobile devices access. Responsibility includes

• Prepare upgrade checklist, Object list to Migrate from Siebel 8.1.1.7 to 8.1.1.9 and manage timeline
• Create Siebel environments, Perform database schema upgrade and repository upgrade
• Cleanup Applet, View, Workflow, EIM tables after the repository upgrade.
• Performing EIM testing to validate Data integrity of the interfaces.
• Creating Open UI Object managers.

Confidential

Role Siebel Consultant

Environment: Windows NT/2000, Siebel 8.0, Siebel 7.5.2 Siebel Sales, Siebel Call Center, Siebel Oil Gas Chemical, Siebel ERM, Marketing, ePriser EIM, eScript, Siebel Workflow Manager, Oracle 9i.

Responsibilities

Develop and customize existing Confidential to meet customer requirements. Gather requirements and convert them into Siebel functionality, develop the application and provide user training and support. Build interface to transfer Order, Invoice and Account between Siebel CRM and Financial software Infinium, EBS. Create Siebel interface, middleware Seebeyond to transfer asset interface between Siebel and CMMS. Create interface between Siebel CRM and Human Resource software and third party software such as Vertex. Develop Informatica ETL logic to transfer data from Siebel database to warehouse OBIEE. Develop and customize application using Siebel tools, eScript and workflow.

Configuration/Siebel Tools

• Setting up and maintaining different Siebel environments for Dev, Test, and Production.
• Gathering requirements from business user and business analysts.
• Converting requirements into Siebel functional design, determining Siebel object best suited for requirements to available Siebel data model.
• Configuring using Siebel tools to define/modify objects-applets, views, workflow, screens to suit customer requirement.
• Modified and Created Web Applets, Views, BC's, BO's, MVG, MVL using Siebel Tools.
• Customizing functionality using BC User properties, Hierarchical List of values, eScript.
• Converting eScripts logic into BC user properties to reduce dependency on Scripts.
• Ensure Data validation using BC User properties, script.
• Creating activity automatically based on status of opportunity.
• Designed the Organization Division - Position structure and define the visibility rules with regard to positions and responsibilities.
• Configuring eMail Response module and maintain communication using this module.
• Migrating metadata changes from Development to QA and QA to production environment. Migrating related List of Values, Workflow In Version earlier than 8.0 and scripts.

Confidential

• Creating ifb files Configured .ifb files to optimize data import, invoked EIM, verification and debugging
• Creating SQL Loader Control files and Procedures to load the data into Siebel Interface tables and executed the EIM process to populate the base tables.
• Mass data loading from external databases to Siebel database.
• Interacting with Internal Clients on various issues ranging from fixing the Workflow Manager, Visibility control settings for the end-users, Data manipulation handling using EIM.
• Data conversion to facilitate financial software change from Infinium to EBS using PL/SQL.
• FTP files from or to Bank websites for interface manipulation.
• Writing SQL Procedures to massage the data at EIM level and check SQL's to check whether the data is missed any required columns.
• Real-time XML data transfer using EAI. FTP xml files between servers.
• Using of Database Triggers to maintain security from Backend side.
• Migrating Seebeyond changes, Troubleshooting Seebeyond environment.
• Developing Informatica workflow for Siebel CRM to Analytics data transfer.

Workflow Manager

• Monitoring service requests such a way that, whenever a service request is pending for more than an hour a message will be broadcasted to the corresponding representative.
• Creating service request activity whenever a new service request has been created.
• Sending E-mails through the workflow manager making use of E-mail agent.
• Enforcing Business rules using Workflow Policies and created corresponding Workflow Processes
• Creating Workflow policies Using Policy Manager.
• Ensuring response time, Objectives are met for customer callbacks and open service requests
• Specifying review policies for important process like contracts
• Creating Workflow Action types, Workflow groups and workflow policies using Workflow Manager.
• Maintain Server Load Balancing Using of Workflow Groups.
• Using of the State Model's Data Driven Method, Extends the Workflow Control based on the status of an object such as SR or PD

Siebel Upgrade

• Prepare upgrade checklist, Object list to Migrate from Siebel 7.5.2 to 8.0 and manage timeline
• Create Siebel environments, Perform database schema upgrade and repository upgrade
• Cleanup Applet, View, Workflow, EIM tables after the repository upgrade.
• Performing EIM testing to validate Data integrity of the interfaces.

Production Support

• Installing software in production environment.
• Troubleshooting interface issue real time in windows and Linux systems
• Migrating changes from UAT environment to Production
• Troubleshooting Siebel, R12, Hyperion, Informatica and OBIEE and reporting applications.
• Creating access report for auditing purpose.

Confidential

Role Siebel Consultant

Environment: Windows 2000, Siebel 6.0.3, Siebel 7.5.2 Data Model , EIM, MS-Access, Oracle8i, PL/SQL, Oracle 9i, SQL Navigator, Safe Source

Responsibilities

Develop and Customize user GUI for Opportunity. Create interface to import opportunity, Account and Contact. Ensure data integrity, schedule automation, send notification incase of failure and troubleshoot various interface. Provide level 3 supports, data cleanup and access support for end user.

Java Developer

• Creating Custom Opportunity screen, View and applet for Capitol investment department.
• Modified and Created Web Applets, Views, BC, BO, MVG, MVL using Siebel Tools.
• Customizing functionality using BC User properties, Hierarchical List of values, eScript and workflow.
• Ensure Data validation using BC User properties, eScript.
• Creating activity automatically based on status of opportunity.
• Data mapping with the custom applet to table level to facilitate data import.
• Using Siebel Tool for mapping Applet controls to database base table column.
• Determining EIM table to Account, Opportunity, Activities and Contact base tables based on data model and requirements.
• Creating Map from EIM Table column to base table extension column.
• Configuring ifb file for Account. Opportunity and Contact import into Siebel schema from external Oracle table.
• Writing PL/SQL Package, Procedure, block to populate EIM Table from external Oracle table using Link in SQL Navigator.
• Optimizing query to increase performance. Troubleshooting application for optimization.
• Implementing Data Validation into PL/SQL coding to ensure data integrity.
• Running EIM job in Development environment and performing Regression Test to ensure functional accuracy.
• Mapping EIM table to base table for update.
• Determining the cause of the problem after consulting with support group and suggesting solution.
• Production Maintenance:
• Developing Informatica Workflow to transfer data to Siebel Analytics.
• Scheduling the whole process using VB to invoke Oracle packages in weekly basis.
• Writing log information into an Oracle table for further evaluation. And using JAVA methods to email notification to concerned individual the log.
• Creating PL/SQL block to populate EIM table to update the base table.
• Configuring the ifb file for Update.
• SQL optimization to troubleshoot performance issue.
• Running EIM Job to update
• Performing regression test to validate.

Confidential

Role: Software Developer

Environment: MS-Excel, VBA, MS-Access, C

• Creating custom pay-roll system using MS-Excel and VBA
• Creating Excel forms and chart
• Using formulas and Macro to enhance automation

Confidential

Role: Intern as Test Engineer

Environment: Teradyne test script, MS-Excel, VBA, MS-Access, C

• Executing Teradyne test script to measure test results of semiconductor CHIPS.
• Creating custom MS-Excel and VBA script to analyze thousands of devices test data to meet six sigma
• Creating Excel forms and chart
• Using formulas and Macro to enhance automation