Jan 2000 to Dec 2002

I was responsible for architecting, designing, coding and also managing a team of 3 Jr. Siebel developers to build a complete CRM solution using Siebel 2000 for Lumenos’ Sale Force, Marketing and Call center divisions. As Lumenos is a startup healthcare company, I had to assume many roles and was required to perform all aspects of the development life-cycle including analysis, business processes, design, coding, testing, deployment and production support. To provide updates of Siebel data from external sources, I built a MS VB/COM application to load client data from an Oracle 8.1.5 db into Siebel using Siebel VB/COM dataserver and EIM technology.

I was also responsible for migrating and upgrading Lumenos’ Siebel CRM solution from Siebel 2000 to Siebel 7.0. I was responsible for all aspects of the Siebel 7.0 migration, which included custom Siebel VBscript migration, as well as the migration of 100’s of custom views and applets. I built many new customer service screens utilizing new Siebel 7.0 technology and eliminated data update issues with external systems and incorporated all external healthcare data into a few easy to use views which greatly reduced call times and CSA personnel frustrations.

I built a Siebel view, which allowed CSA’s to search for a member directly against an external Oracle database. This solution eliminated the need to replicate external data into Siebel, thus reducing data update errors and the resources required to manage this process. I also built a customer service view which provided critical member demographic data along with the member’s healthplan information, segment dates, web profile, all healthcare claims, SR’s, SR Activities, and SR attachments all on one view. This greatly reduced the Siebel "view thrashing" for CSA’s and was achieved by using Siebel VBC technology along with custom MS VB/COM components and Oracle PL/SQL stored procedures.

I was responsible for architecting, designing, coding, deploying and managing development for the LITES custom claims processing system. The LITES system was a batch load claims processing system with a web front-end. The LITES system was integrated with an off-the-shelf traditional claims processing system called QMACS. The LITES system contained a claims processing engine to enforce Lumenos’ consumer-driven healthcare claim processing rules required by our clients. The LITES system provided claim work flow, claim manual entry, batch claim load automation with logging and claims processing. The LITES system also contains a financial module, which produced checks to pay providers, a check register, and an automated Positive Pay module. I was the Sr. tech lead, solution architect and Sr.. developer on the LITES project and was also responsible for managing 5 other developers.

The LITES system was built using MS SQL Server 2000, IIS 5.0, .ASP (HTML, JavaScript), and utilized SQL Server DTS technology.

Nov 1999 to Jan 2000

Sr. Technical lead/developer for Siebel ’99 development, maintenance, and deployment, which included design, development, and testing of customization for Siebel ’99 SFA modules, which supported 500+sales reps at Teligent (75% were remote clients). Architected, designed and coded a sales portal in .ASP (HTML, JavaScript), MS SQL Server and integrated Siebel Contact, Account and Opportunity modules into the web portal using Siebel thin-client technology.

Designed and coded real-time integration from Siebel to Metasolv’s TBS order entry/provisioning system to submit sales orders directly from Siebel to an in-house vendor order entry system (TBS).

Assisted with implementation of an off-the-shelf telecommunications commissioning system which included analysis and development of Oracle PL SQL data load scripts and data load job development using Informix DataBlade.

Product Development Manager for VIPER, ProLink Services Headquarters October 1998 to Aug 1999

Responsible for requirements, design/architecture, development, testing, deployment and marketing of ProLink’s VIPER (Vendor Invoice Processing, Evaluation, and Reconciliation) Software suite. VIPER is a vertical market Telco Cost Management (TCM) system for the telecommunications industry. The VIPER system is a 3-tier Intranet application composed of 4 software components that provide a telecommunication’s companies TCM (Settlements) department with a complete solution for importing, storing, auditing, disputing, paying and reporting of telco vendor invoices.

Also responsible for: product comparisons and competitor research to develop requirements and system functionality to ensure a competitive product. Defining and documenting TCM business and system requirements and business rules. Developing system object models using Rational Rose (UML) and data models using Erwin. Design and implementation of a web-based multi-platform (Windows NT 4.0 and Solaris) system architecture. Designing, developing and documenting of all VIPER GUI, business, and data application services. Coding and unit testing of all VIPER software components and prototypes in Visual Basic 6.0, ASP, SilverStream application server, HTML, JavaScript, and Java. Responsible for project timelines, project budgets, and development team management. Also responsible for developing and giving presentations to potential VIPER clients.

Lead Developer/Systems Architect, Winstar (thru ProLink Services) WinStar

October 1997 to October 1998

Lead VB developer and system architect responsible for designing, architecting, developing and implementing telecommunications settlements system.

This system provided WInStar's Carrier Relations organization with an automated means of importing, auditing, and variance reporting on electronic invoices received by WinStar's telco vendors. The system automated the workflow of the Carrier Analysts for processing vendor invoices and providing a means to identify, track, and communicate invoice disputes to vendors. The system processes over $5 million worth of carrier invoices and assisted in saving the company hundreds of thousands of dollars in invoice item disputes on a yearly basis.

The system was developed in Visual Basic 5, Oracle 7.3.3, and Oracle's PL-SQL. The system employed Client Server architecture using Microsoft's COM-DCOM, Active-X, and MAPI technologies.

Responsibilities included:

Systems analysis: Conducted client meetings to gather system requirements, business rules and process flows. Documented requirements in the form of DFD (Data flow diagrams), Use Case scenarios (using Rational Rose) and requirements/business rule matrixes. Developed document templates to assist the client in communicating business rules and specifications for the importing and auditing of vendor invoices to the development team.

Design: Produced software component and database designs for solutions to requested system requirements. Produced design documentation which provided GUI, Business, and Data services specifications for each component of the system. Produced object models using Rational Rose and data models using ERwin. Was responsible for communication of specifications to development team and to client. Scheduled and conducted design walk-thrus and assisted client with presentations to users and management.

Development Tools Used: VB 5, Oracle 7.3.3, ERwin, Rational Rose, Protoview's DataExplorer.OCX, and Crystal Reports 6.0

July 1997 to Sep 1997.

Worked part-time on a Contract tracking system for a private company to track government contracts, contract modifications, bookings, bids, and pursuits. Developing this as a client/server application, developing the major business objects as ActiveX components, some of which will eventually be used as applets through a web browser to allow other company departments to access and query the systems data using a web browser through a company intranet. Using MS Access 97 as a backend with eventual upgrade to MS SQL Server.

April 1996 to June 1997

Design and coding of a benefits outsourcing system for an on-line call center Service Center Desktop application using PowerBuilder 5.0, and Sybase System Xl. Designed and coded a CTI component that provided telephony functions for an on-line call center desktop application. This application provided call dialing, call transfer call screen-pops from an lVR. Conferencing speed dialing, and agent statistics tracking through a PowerBuilder 5.0 GUI. The telephony functions were communicated to the PowerBuilder application through a custom built Windows NT DLL which maintained communication with an AT&T telephone switch through A LAN connection to a telephony server on an HP 9000. Consultant through ProLink Services, converted to regular employment at WellSpring Resources.

Responsibilities included: Setup and administration of MS SQL Server database server and conversion' of mainframe and desktop based financial applications for the Financial Technical Services group. All phases of application development used Visual Basic. Assisted in designing', coding and implementing an corporate-wide mail-enabled electronic timesheet using MS Mail Visual Basic 3 0 and MS Forms Designer Produced requirements and design for a corporate-wide Procurement Request system

Senior Programmer/Analyst, MacFadden & Associates & Associates, Inc. (MAI) February 95 to April 1995.

Responsibilities include DOS multi-user and MS Windows Client/Server application development in Clipper 5.1, Visual Basic, and MS Access for the U.S Department of Energy’s Office of Procurement and Assistance Management in Washington, DC.

Projects include development of the Contractor Review Tracking System, development of the Employment Distribution by Program System, development of the Automated Contractor Capabilities and Experience Source System, and maintenance of several Clipper applications. All applications are multi-user and execute in a Novell LAN environment.

Development responsibilities include requirements analysis, system design, coding, documentation, and end-user training. Other duties include assisting in developing a Procurement corporate database and data dictionary, assisting in configuration management of Windows 3.1 applications on several Novell 3.11 Netware servers and providing evaluations, testing and support for migration to Windows '95.

Senior Programmer/Analyst, Comprehensive Technologies International Inc., October 1993 to February 1995

Performed the same duties listed above under MacFadden & Associates on the same DOE contract.

Systems Analyst, Advanced Engineering & Programming Corporation Inc. (AEPCO), April 1993 to October 1993

Responsibilities included: multi-user application design, coding, testing, implementation and documentation of financial and database tracking systems in Clipper and FoxPro for Windows for the U.S department of Navy's AEGIS Information Systems. Projects included: Procurement and Contract Tracking System in Clipper Summer '87, 5.1, and 5.2 and the File and Document System in FoxPro for Windows.

Responsibilities included life-cycle supports, configuration management, task leader duties, application design, coding, and implementation for the Department of Defense Joint staff Manpower and Personnel Directorate through the Defense Systems Support Organization (DSSO). Projects included: Joint Manpower Automation system in Clipper 5.1. This system executed in a single and multi-user environment (Lantastic and Novell) with telecommunications components.

Performed same duties listed under computer Based Systems, Inc. on the same DOD contract.

Responsibilities included: all aspects of application development in Clipper and dBase III+ for the information systems, human resources, and highway maintenance sections in the Northern VA District office. Organized and assisted in providing hardware and software troubleshooting for 200 DOS based microcomputers and over 250 end-users. Projects included: design, coding, testing, documentation, and implementation of the Adopt-A-Highway management system used statewide by VDOT.