John Cheeren

Principal Consultant

858-212-1594

System Development and Design: Module Development, System, Design, Testing, Documentation, and Implementation

Operating Systems: MS DOS 6.2, NT 4.0, Windows 9x, 2000 Advanced Server, HP UNIX

CRM Packages: Siebel eMedical,ePharma,eMarketing,eClinical 7.8/7.7/7.5.x/6.0

Saleslogix 3.16/4.0/2000/5.3/6.0

RDBMS: Oracle v 7.3/8.0.x/9.x, Sybase 11, MS Access 2.0/97/2000, FoxPro 2.5, SQL Server 7.0/2000

GUI: Visual Basic 4.0/5.0/6.0, Visual C++ 5.0, and Developer 2000

Languages: C, C ++, Pascal, Shell Programming, Windows Programming, COBOL

Web Publishing: HTML, ASP

Business Areas: Order Entry, Inventory Management, Manufacturing, Portfolio Management, Payroll Automation, Annuities & Reinvestment, Publishing and E-Commerce, Banking and Finance, Leasing

Siebel Administration

Guidant is a cardiovascular device manufacturing company with 3 divisions (VI, CRM and ES).CTMS Clinical Trial Management System is a system that facilitates accurately recording data from obtained during clinical trials from various sites geographically distributed across the US and internationally. This system ensures compliance with FDA standards, reduces time to market because of shorter test cycles and records protocol deviations during the test process. Test data is entered into Siebel which interfaces with a document management system (Documentum) using External Business Components. An interface is also maintained into the SAP system for payments and billing data. This is done using XML messages over MQ series queing subsystem.

This is a high volume call center environment used by Guidant’s CRM division to support sales and support of CRM products. This is a high availability environment (24X7X365) with sufficient redundancy. The system consists of multiple HP-UX Application Servers on a Veritas Cluster. The Web servers are load balanced using F5.Mirroring and RAID level ensure redundancy at the database level.

Ensured data integrity and system uptime .Made recommendations and best practices for effective deployment. Responsible for system upgrade from 7.5.3 to 7.7.2.3/7.8 Wrote scripts using vbscript . Deployed Actuate Reports Server . Used workflow and MQ components for data integration. Administered and deployed Siebel remote clients. Made recommendations to improve network latency to ensure better system performance. Lead deployment of Patrol for Siebel for proactive monitoring of the system. Modified Oracle db parameters for better performance. Responsible for overall health of the system.

Application Development tools and Technologies

Siebel 7.5.3,7.7.2.3 Siebel VB, escript, Workflow manager, Assignment Manager, EAI, Oracle 9.2, XML, HP-UX, Shell Script, IBM MQSeries, Win 2000 Advanced Server, IIS , WMI , BMC Patrol.

Data Migration/ Process Improvement

As a consultant improved performance on the Email and fax blaster processes that would generate mass email lists for marketing campaigns.

Architected processes for Data Migration, reconciliation and cleansing.

Improved performance of SQL Loader and EIM table mapping scripts to load contact and account data into the system. Customized workflows and scripts.

Siebel 7.5 Call Center, Siebel emarketing,Oracle 9.02, SQL Loader, Windows 2000, HP-UX , Visual Basic 6.0., escript, VbScript, PL/SQL.Workflow Manager.

Elan Corporation is a neuroscience-based company that is focused on discovering, developing and manufacturing and marketing advanced therapies in neurology, autoimmune diseases and severe pain. The Siebel System was used to transmit and monitor sales information between Field Sales Reps and the Central Office. It was also used for Order Entry and quote generation.

As Data Integration Specialist designed data integration processes taking into account system availability, data volume and execution time. Data had to be migrated from a 6.3 Siebel Life Sciences system to Siebel 7.7 epharma. Designed EIM/EAI processes to accomplish the migration of contact and account data between systems for the Hospital Sales Division. Mentored junior employees and reviewed design specifications and integration methodologies. Modified data loads for optimum performance. Also built web services (Inbound/Outbound) to facilitate the real time booking and confirmation of orders between Elan and Theracom (an Elan affiliate). This involved creating workflows, integration objects and business services. Externally generated WSDL's were used to create integration objects while Siebel hosted workflow processes were used to generate WSDL's to be consumed by external systems.

Application Development tools and Technologies:

Siebel 6.3 Life Sciences, Siebel 7.7 Epharma ,Oracle 9.02, Oracle 8i, Windows 2000, XMLSpy, HP-UX , Visual Basic 6.0. escript, VbScript, PL/SQL.Workflow Manager, Assignment Manager.

Special Orders and Renovations Call Center Project

The SOG and Renovations Group of Home Depot is concerned with the quoting ordering and fulfillment of Special Order parts. The system was designed to be used by Call Center agents. Ease of use, rapid quote generation, pricing based on customer pricing level and product lines were some of the required features. The Renovations department processed opportunities with a longer sales cycle and an ordered sales process. Opportunity and activity management were critical factors in the business process. In order to accelerate integration with the back-office systems EAI methodologies were used. Siebel 7.5.2/7.5.3 Call Center module was implemented. (Project budget ~ 1.5M.)

As Enterprise Siebel Architect designed system architecture to ensure scalability and integration with back-office and external systems. Interacted with Line of Business executives to determine system requirements. Coordinated development efforts and communicated progress to LOB executives. Derived metrics for performance calculations and employee productivity. Reviewed and accessed RFP responses submitted by vendors and business partners. Configured and customized the Siebel Application using Siebel tools configurator. Created escript, VBScript, user properties and workflow processes to facilitate system integration. Implemented Pricing models using ePricer. Oversaw Siebel System administration and monitored performance. Made recommendations to improve performance. Created EIM processes, which were used to synchronize customer order and sales information with the legacy Oracle system Designed EAI architecture to facilitate exchange of messages with legacy Oracle 7.3 application to allow for real-time exchange of data in XML format. This was designed using a HUB and spoke architecture, which consisted of common objects residing on a WebSphere Application Server where incoming and outgoing messages were transformed. Created Inbound and Outbound Web services which allowed for seamless integration of data across heterogeneous environments using HTTP. Optimized system architecture. Created and optimized Actuate reports.

Siebel 7.5.x, Siebel VB, escript, Workflow manager, Assignment Manager, EAI, Oracle 7.3, Oracle 9.02, XML, Sun 5.3,Solaris 8, Unix, Shell Script, WebSphere Application Server, Java, IBM MQSeries, Win 2000 Advanced Server, Smartscripts

Integration of Siebel with legacy and third party software. Performed product comparisons with Peoplesoft and Saleslogix products. Customized forms and applets, Created drilldowns and MVG applets. Scheduled EIM (Enterprise Integration Manager) tasks. Also responsible for pilot installation.

Siebel 7.03, VB, Siebel Tools, COM, SQL Server 2000, SQL Anywhere, Siebel Call Center.

Sales Information System (SIS)

As CRM consultant designed new processes and optimized existing procedures to efficiently capture and process sales data. Pyxis Corporation, one of the group companies in the Cardinal Group, designed the Sales Information System for use. Pyxis is a leading provider of medication and supply dispensing systems to hospitals and other healthcare facilities. The SIS system was designed to enable Field Sales and Service associates to keep track of contacts, accounts and opportunities and respond to client requests in a timely and cost effective fashion. Data gathered from all users was also to be analyzed and disseminated for tracking and forecasting .The Sales Information System supported a remote Field Sales force with 250 users all over the United States and 50 users in-house. The System Architecture consisted of 50 workstations running Saleslogix on Windows 2000 accessing data from a SQL Server 2000 Database. Remote users used dialup to access an ftp site from where changes were distributed. SIS was also integrated with Oracle Applications System and the DSI Asset Management System.

Design and implement a UBB (usage based billing system) to vary leasing revenue based on usage. Integrated Crystal Reports with saleslogix. Administered the Sync Process, which included administering the Sync Server and the deployment and installation of remote databases. Modified interface between Oracle Apps System, SAP and Saleslogix. Created Scribe jobs to import account and financial data from SAP and Oracle into Saleslogix. Also imported pricing information from Excel into Saleslogix using Scribe Migrate. Optimized performance of batch loads from legacy DSI system. Designed A File Transfer Process to optimize transfer of remote files. Installed and configured SalesLogix for Workgroup Clients and Workgroup Administrator. Designed solution for remote access to Workgroup Server. Performed extensive customizations. Also performed backup and administrative tasks using Saleslogix suite of tools. Optimized performance of the SQL Server Database. Created DTS, stored procedures and triggers using T-SQL. Managed upgrade from Saleslogix 4.0 to 5.2. Also studied Saleslogix 6.0 for possible upgrade.

Saleslogix Architect, Saleslogix WorkGroup Administrator, COM, BDE 5.01, Crystal Reports 7.0, VBScript, Visual Basic 6.0,SQL Server 7/2000, MS Outlook, Scribe Migrate, Oracle 11.0.5, SAP 3.0

As CRM Implementation Specialist designed system architecture for Key Lease Plus’s LeaseLogix System. LeaseLogix was used to process Key Equipment Finance Group’s small ticket leases (Leases < $100,000). Key Equipment Finance Group is Key Bank’s equipment leasing organization having an equipment portfolio of over $ 7 billion. The System Architecture consisted of 40 workstations running Saleslogix on Windows NT communicating with an Oracle 8.03 database running on a Windows NT server. The system also included 10 remote users with dialup access to the Sync Server. The LeaseLogix System interfaced with a Credit Scoring System (FICO), Legacy Leasing System (Leasepak) and the QCS’s CTI system.

As CRM Implementation specialist assisted senior management in development of a phased Project Plan with deliverables and deadlines. Ensured timely deployment of deliverables. Discussed implementation costs with client and evaluated ROI. Advised client on issues relating to implementation and suggested re- engineering existing process to make the organization more customer centric. Was involved in all phases of System Development. Actively participated in user requirements definition. Provided strategic technical advice on technology initiatives taken at KeyLease Plus. Mentored other team members and provided training and resources to developers as and when needed.

Installed and configured SalesLogix for Workgroup Clients and Workgroup Administrator. Designed solution for remote access to Workgroup Server. Performed extensive customizations. Designed an interface to the Fair Isaac Credit Scoring System (FICO) to instantly credit score lease applications. Developed reports to review credit information. Credit decisions would automatically populate the LeaseLogix database, which would allow creation of leases. Developed a XML based Interface to the Legacy leasing System (McCue’s Leasepak) that would allow for autobooking of leases. Developed a tax calculator to calculate taxes based on asset locations. Imported data from Excel files into the saleslogix system using Scribe and saleslogix API's. Developed a document management subsystem designed to send documents to recipients based on their preferred method of delivery (fax, email, post). Developed a COM based interface to Lotus Notes email system and WinFax. Setup workflow processes to ensure that the entire sales cycle was process driven. Integrated CTI component (Qcall32.ocx) into the LeaseLogix client to display screen popup and corresponding customer information if found in the database. Also performed backup and administrative tasks on Oracle database using Saleslogix suite of tools. Tuned Oracle database for optimal performance.

VBScript, Visual Basic 6.0,Visual C ++ 5.0, Oracle 8.03, Sybase 11, Saleslogix Architect, Saleslogix WorkGroup Administrator, QCS’s Qcall32.OCX, COM, DCOM, WinFax 10.0, Lotus Notes, Borland Database Engine (BDE 5.01), ADO, RDO, XML, Crystal Reports 7.0, Visual SourceSafe, Scribe Migrate/Integrate

Responsible for system design of The LeaseTec International Front End (LIFE) for LeaseTec (KEFG ‘s Affiliate for vendor based leasing). The LIFE system consisted of Saleslogix 2000 deployed on a Citrix Metaframe Server accessed globally through Citrix ICA client. The Oracle 8.03 database resided on a HP-UX server. LIFE was also designed to interface with the Legacy Leasing System (Leasepak)

Developed a document management subsystem and an and asset management subsystem. As Technology Architect designed the remote access solution to the Primary Synchronization server using dial up access. Assessed performance over the network and made optimizations to improve remote as well as direct access to the Citrix Servers. Interacted with users internationally to gather requirements. Developed roll out plans for deployment of the product at International LeaseTec locations. Assisted in the development of project plans and risk assessment strategies. Developed a Crystal report based DLL for creation of editable reports. Customized Saleslogix to meet user requirements.

VBScript, Visual Basic 6.0,Visual C ++ 5.0, Oracle 8.03, Sybase 11, Saleslogix Architect, Saleslogix WorkGroup Administrator, COM, DCOM, Winfax 10.0, Lotus Notes, Borland Database Engine (BDE 5.01), ADO, RDO, XML, Crystal Reports 7.0, Visual SourceSafe

Winpath

NYSHESC is involved in the business of guaranteeing student loans. Winpath is a software package developed to enable schools and other financial institutions to send student data to NYSHESC for processing. The project consists of visual basic screens that were used to capture data stored in an Access database. Data stored in the database is then uploaded to the Mainframe using PDQComm. The project also allowed for the printing of reports based on data sent and received from the mainframe. The project also transformed data from different file formats to a standardized CommonLine format. Packaged software was created using InstallShield 5.0.

Designing screens using Visual Basic 6.0 according to user specifications. Designing the database to minimize data redundancy and maintain relationships between entities. Created reports using Crystal Reports 5.0. Wrote queries to access the database. Optimized queries. Used ADO 2.0 to access data.

Windows 95/98, Visual Basic 6.0, MS Access 97, Seagate Crystal Reports 5.0

The project involved the printing of all McGraw Hill catalogs like The Weekly Bulletin, The Title Index, New Book Listing, Author Listing and the Price List. These catalogs are to be published from the McGraw- Hill website. The project involved migrating the current file system to an Oracle 7.3 database and then using Visual Basic to access the database using RDO 2.0. This involved writing queries stored procedures and triggers to access the Oracle database. Visual Basic was used to develop 32 bit (. OCX) controls, which were then hosted on a web browser. This will allow all Internet users to access McGraw-Hill catalogs of the Internet.

Writing queries stored procedures and triggers to access the Oracle database. Optimizing queries. Creating reports using ActiveX Word objects from Visual Basic. Modifying reports according to user requirements. Active Server Pages were used to host Active X word objects.

Internet Explorer 2.0 (client), Visual Basic 5.0 ActiveX Controls on Windows NT Server (middle tier), Oracle 7.2 on Windows NT Server (database).

CFE (Common Front End)

Performance engineering to determine the feasibility of scaling the user load from the present load of 50 users to the suggested load of 1500 users. Testing the interfaces between the systems involved for varying loads did this. Simulating multiple users over multiple client machines and recording the timing information at a central repository varied user loads. A master control machine was used to drive client machines over a network. Tests were run on different machines to give cumulative timing information. Test scripts were developed that would test the various system interfaces.

Analyzing the system architecture, designing test cases using Visual Basic (scripts) and Sybase 11 (stored procedures) to stress test the system

Visual Basic 4.0, Windows NT, Windows 95, Visual C++ 4.0, Sybase 11

The SMG project for GE Appliances was designed for the Sales and Marketing group of GE Appliances. This project would enable the capturing of data during Sales transactions; forecast future demands and also gives region wise and account wise distribution of sales data. The system is part of a larger Physical Distribution Inventory System at GE Appliances .The project involved migration from a DEC-VAX System to a 3-tier client server architecture. ActiveX DLL's were used to access the Oracle database. These DLL's used RDO to access stored procedures at the Oracle backend ActiveX. Controls were developed to replicate the functionality of the screens. These controls resided on an Object Server. These were hosted on a web browser.

Creating ActiveX objects and ActiveX Documents using Visual Basic 5.0. Created screens in Visual Basic according to specifications. Created ActiveX DLL's to call Oracle stored procedures. Wrote queries to access Oracle database. Active Server Pages were used to host ActiveX controls and access ActiveX DLL's. Prepared and developed prototype according to client specifications. Also performed unit testing, system testing, and system documentation. Prepared test plans reviewed written code.

Internet Explorer 2.0 (client), Visual Basic 5.0 ActiveX Controls on Windows NT Server (middle tier), Oracle 7.2 on Windows NT Server (database).

(Electrical Distribution and Controls) Plainville, Connecticut

Six Sigma Project Management System. The ED & C Six Sigma Project was developed in Visual Basic 4.0 and uses an Access Database The system was designed in such a way that it would be convenient to convert the database to Oracle without having to redesign the graphical user interface. The user has the option of connecting to a local database on the individuals PC or connecting to a business wide Network database. There is an interface into MS Mail and MS Exchange to allow simple communication of project data. Adequate security has been provided to the system so that access is denied to unauthorized users. The system is built in such a way so that it is very flexible and can easily be modified to accommodate varying business needs.

Preparing and developing prototype screens and reports according to client specifications, Coding, Unit Testing, system testing, preparing test plans, reviewing written code, system documentation. Designed user interface. Created Reports using Crystal Reports, wrote queries to access Oracle as well as Access databases.

VB (4.0), Windows 95 (client), Access (2.0) (database), HP-UNIX, Oracle 7.2 (database) Crystal Reports.

The system supported an entire gamut of activities in the Order entry process like Order processing, Invoicing, Shipping, Customer Support, Availability, Claims and Returns. The project involved migrating the existing database from a Honeywell Bull Mainframe based system to client server architecture. The system uses Visual Basic Screens to communicate with the Oracle database. This is done using ODBC connectivity. The stored procedures and SQL queries are invoked from the Visual Basic front end. Maintenance of the project was also done in phases .The existing screens were enhanced and modified according to user requirements

Writing queries and stored procedures to access the Oracle database. Migrating the existing system over to Oracle. Designing screens and reports to meet client requirements using Visual Basic and Crystal Reports. Preparing and developing prototype screens. Coding, Unit Testing, system testing, Preparing test plans, Reviewing written code, Documentation

Windows 95, Visual Basic 4.0 (client), Oracle 7.1, HP- UNIX (server)

EDUCATION: Completed a Bachelor's Degree in Computer Engineering, (B.E.) (Hon.) University Of Bombay. Dissertation " The Remote Procedure Call Mechanism"