James Patrick Tanner

Phone: (312) 933-3385

Burr Ridge, IL 60527

jimtnnr@yahoo.com

SKILLS OVERVIEW:

Skills and Experience Overview – MS Visual Studio 2005, MS Visual Studio 2003, C#.Net, VB.Net, Visual Basic versions 3.0, 4.0, 5.0, 6.0, Visual Basic for Applications (VBA) Scripting Languages, Excel VBA, Excel Object Library, MS Word VBA, MS Word Object Library, CRM VBA Object Scripting, Siebel 7 Tools, Siebel 7 Administration, Siebel Scripting, ODBC, ADO (ActiveX Data Objects), DAO, Data Access Objects, Stored Procedures, Triggers, Class Libraries, Crystal Reports, VB Report Writer, Sybase, MS Access, PL SQL, Oracle 8i, Oracle 9i, MS SQL Server 7.0, MS SQL Server 2000, HTML, Java Script Object Reference Libraries, Object Component Libraries, COM, UNIX, Shell scripting, Windows NT 4.0, Windows 2000, Siebel 2000, Siebel CTI Configuration, Quintus CRM, Quintus eContact Center, Avaya CRM, Avaya Interaction Center, Remedy, Apropos CTI middleware, IVR scripting, TCL, PIL (phone interface language) ContactPro IVR, ContactPro Call Center, Davox Lyricall, InstallShield 7.0 Professional Script, Surado CRM, Plumgroup VoiceXML IVR.

PROFESSIONAL EMPLOYMENT HISTORY:

Comvigo Inc , Chicago, IL

Senior Consultant - (June, 2000 – Present)

Clients:

At: JP Morgan/Chase Chicago, IL (January 2005 to Present)

Skills: Visual Studio 2005, C#.Net, SQL ServerVisual Basic 6.0, Creation and support of a large document imaging, processing, and cataloging system. Core project technologies are Visual Studio 2005, C#.Net, SQL Server and Visual Basic. Core project is a large document management facility where documents are scanned, processed, and decisioned.

- Created Production Windows Service using C# .Net which handles the disposition of over 20,000 documents per day. Code has been working successfully in production for over one year with zero defects. Created numerous enhancements to functionality of core code base.

- Created Web Services using C# .Net currently used in production.

- Created numerous C# .Net libraries for document handling and other decisioning libraries related to the final disposition of documents and document types.

- Created C# .Net API interfaces for third party applications such as OnBase. Code base is currently working in production with zero defect.

- Managed and enhanced legacy code bases in Visual Basic 6.0, SQL Server TSQL, and Crystal Reports.

Other Clients (2000-2005)

At: Marriott Corporation, Orlando, FL

Skills: Visual Basic.Applications Scripting VBA, Siebel 7.7 VBA Scripting, Siebel 7.7 Tools, Siebel 7.7 Configuration, Siebel 7.7 Application Administration, Oracle. Siebel configuration for Sales and Customer Support Siebel applications. Planning, implementing, and supporting live Siebel Application. Providing Level 2 and Level 3 Support.

At: PepsiCo, Chicago, IL

Skills: Visual Basic 6.0, Siebel 6, 7 Tools, Siebel 6, 7 VBA Scripting and Configuration, Oracle Stored Procedures. Application development for consumer product sales management applications. Visual Basic 6.0 coding for application specific COM DLL’s. Involved in unit and system testing of enterprise applications. Extensive use of Visual Basic 6.0, Siebel Tools and Siebel VB Scripting

At: Monster.Com, Boston, MA

Skills: Visual Basic 6.0, VBA, SQL Server, Siebel CTI, Siebel 7 Tools, Siebel 7 Configuration

Lead consultant to implement Siebel CTI with a predictive outbound dialer for a telemarketing call center. Create and configure Visual Basic 6.0 dll’s to connect Siebel CTI API set with the Siebel CTI Toolbar and Server. Designed and created screen pops and workflows to escalate prospects through the CRM system. Coordinate with team members for project planning and consulting.

At: Schlumberger Corporation, Mobile, AL

Skills: Surado CRM, VBA, Visual Basic 6.0, SQL Server 2000

Led implementation of Surado CRM system at GlobalTel Link, a subsidiary of Schlumberger Corporation. Extensive VBA scripting to implement business rules into application. Creation of SQL Server stored procedures for data mining and data migration.

At: Concerto Software, Chicago, IL / Boston, MA / Client Sites Nationwide

Skills: Visual Basic 6.0, VBA Scripting, SQL Server, ContactPro IVR, Davox Lyricall, EnsemblePro, Call Center Integration, JavaScript, IVR, CTI, Siebel 7 API, Siebel 7 Communications Servers, Siebel 7 CTI. Contract Consultant for the implementation of call center products including IVR, Dialers, Web and Client Server Interfaces, API’s and other software. Responsible to interface with clients to gather and organize business rules and requirements, customize products, code business rules, provide implementation services, provide project updates, perform acceptance testing, and complete live system cut overs. Created component install applications using InstallShield Professional 7.0 and Visual Basic 6.0. Created Visual Basic 6.0 .dll’s for API to API connectivity between predictive dialers and Siebel 7. Integrated telephony products to Siebel 7.0 Communications servers which included writing the desktop dll’s and creating the Siebel 7.0 CTI setup for the communications driver, the commands, and the events. Customized the toolbar interface for Siebel CTI and wrote custom code to manage inbound/outbound messages and other functionality such as button states. Wrote customized CTI configuration files for Siebel CTI. Completed two full life cycle implementations of Siebel CTI at major Fortune 500 clients.

At: Cendant (RCI) - Lead Consultant – Siebel, Indianapolis, IN

Skills: Visual Basic 6.0, VBA, SQL Server, Siebel CTI, Siebel 7 Tools, Siebel 7 Configuration

At: Pitney Bowes – Lead Consultant – Siebel, Stamford, CT

Skills: Visual Basic 6.0, VBA, SQL Server, Siebel CTI, Siebel 7 Tools, Siebel 7 Configuration

At: Northern Trust Bank – CRM Consultant, Chicago, IL

Skills: Visual Basic 6.0, VBA Scripting , SQL Server, Oracle, Avaya CRM, Quintus 5.5.1

Consultant to design, integrate, customize, and enhance Avaya CRM applications used by over 2500 associates worldwide at a large bank corporation. Responsible to interface with the business owners to gather and organize requirements, provide project updates, write code, perform acceptance testing, and complete live system cut overs. Participated in the planning and implementing software product upgrades. Created VB MS Word object code, VB CRM object code, VB business rule scripting.

Covansys, Chicago, IL

Senior Consultant (May, 1999 – July, 2000)

VB 6.0 /VBA/Avaya Interaction Center/Quintus CRM/IVR/CTI/Oracle 8/SQLServer 7.0/Sybase

Senior Consultant to design, integrate, customize, and enhance Avaya Interaction Center CRM software package at Fortune 500 and startup company customer locations. Responsible to interface with clients to gather and organize business rules and requirements, provide project updates, perform acceptance testing, and complete live system cut overs

Clients:

At: IQ4Hire.com, Chicago - Coded Word VBA and Excel VBA system to automatically generate MS Word documentation from relational Oracle database entries. Wrote object oriented code utilizing Word and Excel object libraries and pass through SQL with ADODB connectivity. Created GUI interfaces.

At: Allied Van Lines, Chicago - Wrote Object oriented Visual Basic 6.0 code against SQL Server 2000 to integrate Avaya CRM web front end. Wrote a Visual Basic 6.0 application for testing the success of object transferal across application layers. Created GUI interfaces with data validation.

At: United Airlines, Chicago - Created an Avaya/Visual Basic 6.0 system using DB2, SQL Server, and MS Access that collected passenger lists from late/delayed flights and automatically generated envelopes, letters, and compensation. Maintained an Avaya CRM Visual Basic script based data entry system that integrated with a Filenet imaging system via DDE and object API to attached scanned image to a record.

At: John Deere, Illinois - Wrote Visual Basic 5.0 data load system for Avaya/Quintus CRM Oracle database.

Apropos Technology, Inc., Oakbrook Terrace, IL

Professional Services Consultant CTI/CRM (January, 1998 – March, 1999)

Visual Basic 4.0 and 5.0/Sybase/Win NT/TCL/PIL/Crystal Reports /Remedy and other CRM

Responsible for the integration of Apropos Call Link (CTI middleware) call center management software at Fortune 500 client sites. Responsible to work with clients to gather system requirements and to customize Apropos Call Link to meet requirements. Responsible to travel to client site and integrate the product to work within customer specific environments. Worked with various client personal to integrate software with their CRM interface, RDBMS, PBX, etc. Performed acceptance testing with the client, and performed live cut overs. Created customized applications as required.

Projects - Responsible for integrating CTI middleware, creating IVR, creating screen pops, and integrating CRM. Created requirements for call flows and wrote the corresponding IVR using TCL and PIL. Integrated CTI middleware with phone switch and RDBMS (Oracle, SQL Server). Responsible for setting up agents and skills based call routing. Successful client installs included Nokia (Dallas, TX), Infonet (El Segundo, CA), FileNet (Costa Mesa, CA), Redstone Arsenal (Huntsville, AL).

CNA Insurance Company, Chicago, IL

Lead Programmer/Project Manager (November, 1995 - November, 1997)

Visual Basic 4.0, 5.0/Sybase/Access/Excel VBA

Team leader in charge of planning, developing, and implementing a Price Model program, an expert system used to estimate cash flows and charges for large commercial insurance accounts. The Price Model application was used by 38 branch offices nationwide. Led successful quarterly rollouts of the Price Model for two years. Earned a LOMA/FLMI fellowship in life and health insurance management. Performed conversion of VB 3.0/Access stand-alone application to VB 4.0/Sybase distributed application. Wrote a VB application to transfer data and application from Access to VB/Sybase. Wrote GUI, scripting, stored procedures, triggers, and pass through SQL.

EDUCATION:

Southern Illinois University

Bachelor of Science

Siebel 2000 Certified Consultant