Objective

To participate in management/development of Internet and/or Windows based applications that introduce greater efficiencies and return on investment through technology.  I also plan to continue my formal education through certification and seminars.

Experience

Nov. 96 – Present	Independent Computer Consultant (Specific Projects Follow)

Over the last several years I have primarily been focused on the Role of Technical Architect / Project Manager.  Depending on specific circumstances, an in depth analysis of the current system (and feasibility study of proposed project) occurs (potentially as part of the sales cycle). Recommendations and strategies are drafted which use well established data architectural guidelines and object and pattern oriented design principals. Use cases, milestones, resource allocation and costs are identified and compiled into various proposals that include Project Assessment, Software Development plan, and Application Architecture documents.  Concepts are then presented to peers and team members for review and finally to executives for approval.  Agile Approach is utilized during project implementation to maximize team productivity, mitigate risk and engage end users.  Guidance is then provided to team from inception of project to implementation.  Technologies and specific situations follow in the individual project sections below.

Computer Skills

Architectures:
N-Tier
Client Server
SOA

Industries:
Finance/Accounting
Sales/Marketing
Manufacturing
Pharmaceutical
Insurance

Methodologies:
Agile
RUP
Extreme Programming
UML                         

Programming:
VS 2005 (Win, ASP.Net)
VB.Net, C#
Javascript
AJAX
Crystal Reports  4 - 12
VB & ASP
C & C++
Flash
COM, COM+, ActiveX
Access 2.0 -2007
MTS, MSMQ
SAP 

Platforms:
Win 3.1 - Vista
Unix (SVR4)
MS Project
IIS 6.0                           

Database:                     
SQL Server 6 - 2005 
Oracle 5 - 10g               
MS Access 2.0 - 2007   
XML

Other Software:
MS Project
MS Visio


Projects

Sep. 04 – Present	confidential

VB.Net Architect of SSL intranet application designed to calculate various taxes and surcharges associated with multi jurisdictional telecommunication products and services.  Appropriate charges were identified, summarized and remitted based on monthly data feeds provided by CCH (into Oracle and SQL databases). The custom taxing functionality was also designed to run within SAP’s environment through SAP’s .Net Connector (via Proxy).  Extensive coordination with Networking and SAP personnel (based in South Africa) to design object structure (with multiple interfaces) and networking logistics to successfully implement solution.  Custom Crystal Reports were created to ensure proper audit documentation and to prevent imbalances between systems.

Sep. 06 – May 07	Bacons Information Services

ASP.Net 2.0 (C#) Architect working with SQL Server 2005 on customer facing internet portal application.  Twenty member team developed application to support a thousand concurrent users on load balanced Sql Server (using Entity-Relationship model) and IIS machines.  Portal application designed to manage life cycle of a Press Releases and monitor their audience and affect throughout the world.   Intensive usage of recent Microsoft technologies including Team Foundation Server, Cruise Control, Master Pages, Site Maps, Client Callbacks, AJAX, JavaScript, XML Web Services, Web Controls and Asynchronous Calls.

Nov. 05 – Jul. 06	Kraft
ASP.Net Architect of the Commodity Tracking System.  Creation of dynamic Kraft purchasing group where data could be dynamically allocated to other Kraft groups for reporting and analysis purposes.  Converted project team from the waterfall model to Unified Process style to better facilitate development efficiency.  Created Web Service proxy to receive daily stock quotes in batch mode or on demand. Modified application functionality through vb.net (Object Oriented Design and custom controls), Sql Server stored procedures (deeply embedded), and Crystal Reports (Enterprise Server) while formally documenting and strictly adhering to existing design principles.  Successfully rolled out required and optional changes within budget.

Jan. 04 – Aug. 04	Preston Enterprise

Project Manager of a Web application development team that designed an application to track sales leads from inception to sale, provide employee performance analysis, weekly work schedules, billing/bonus guide and to allow client access to review schedule and leads remotely. Managed project using MS Project and followed iterative development process. Full life cycle including feasibility study, budgeting, requirements analysis, creation of use cases, architectural, database and object design, implementation, testing, and roll out.  ASP.Net application using C# with SQL Server database.  Software was successfully finished ahead of schedule and within budget.

Jan. 03 – Nov. 03	Siemens Building Technologies

Enterprise VB.Net developer of Great Plains/ Service Management System (Sql Server based) and its supplemental proprietary scheduling and reporting application.  Extensive migration of data and application customizations to the latest version of Great Plaines were successfully rolled out (and integrated with other Enterprise wide systems).  Process includes identifying undocumented customizations (VBA Code, Custom Fields, Stored Procedures, or Triggers), determining ramification of changes, determining if changes are already implemented in latest version, implementing changes (if necessary), and testing that the customizations have not altered any of the new versions functionality.  Latest version introduced and refined will save countless hours and cost in 60 branch offices throughout North America.

Apr. 02 – Oct. 02	International Truck and Engine

Enterprise Visual Basic developer of an Ordering Processing System designed to allow for the proper customization of a truck.  Developed component that compares vehicle performance based on the selection of various truck parts prior to committing to any one.  Extensive object manipulation using existing interface to generate desired information. Highly structured object oriented design approach used to facilitate large development teams concurrent modifications and in preparation for XML and VB.Net.  Dynamic data driven approach used due to multifaceted validation design and enhancement release schedule.  Heavy data interplay between DB2 and potentially disconnect local Access database. Application changes were put into pilot on time and accepted as developed.

Jul. 01 – Dec. 01	Blue Cross Blue Shield of Illinois

SQL Server/Access developer coordinating the integration of multiple Access databases into one consolidated SQL Server database with an Access front end.  Application is designed to run from remote locations so that the Actuarial department may track details needed to underwrite insurance policies.  Bound and unbound data forms are used throughout the entire application.  Modified forms to provide greater functionality, consistency and ease of use.  Optimized SQL statements (Access queries, pass through queries, stored procedures, triggers, views where appropriate) and VB code for faster execution speed.  Several dynamic Crystal Reports were created to allow many different logical presentations of information.  Automation of manual upload process and data migration script into Data Transformation Service packages.

Feb. 00 – Apr. 01	Rollprint Packaging Products

Technical Project Manager coordinating full life cycle development in an FDA regulated QA department.  Responsibilities include: Requirements analysis, data modeling, distribution of development tasks, fine tuning of development process, resource/deadline management through MS Project, creation of a COM based, N-Tier distributed ERP add-on using Visual Basic and SQL Server providing organizational structure for building and storing internally manufactured materials.  System highlights include: Extensive validation processing, Cascading Approval Scheme, Security Scheme utilizing Windows NT Authentication, Template (Save/Save As) functionality provided for data object (material recipe), accurate tracking of unlimited embedded materials.  Dynamic Reporting features provided through ASP (VBScript).  SQL Server development of database structure, tables, stored procedures, triggers, users, and security. Multi-database (Oracle and SQL Server) transactions secured using MTS.

Jul. 98 – Dec. 99	Allstate Insurance

The role of Project Manager was achieved through demonstrating proficiency in issues management and an aptitude for a diverse set of technologies.  Job responsibilities included coordinating and mentoring a team working on multiple Visual Basic development projects using DB2/Access databases.  Key elements of the life cycle environment included; analysis of client needs, application specifications, data modeling, estimating elements of cost and time frame, data migration involving Oracle and SQL Server, distributing development tasks, creation of complex Crystal Report, system documentation, creation of user manuals and test plans, application/support training, application enhancements/maintenance and automation of windows tasks through VBScript.  Direct development of graphical SQL tool and audit trail components.

Aug. 97 – Jun. 98	Pharmacia & Upjohn

Visual Basic 5 programmer of a regulatory document management system, which creates, stores, and retrieves different renditions of the documentation required by the FDA to market new drugs.  Distributed application uses an Oracle/Documentum database on a Unix (SVR4) platform.  Duties include working with the system administrator to define and modify the system to increase and improve functionality. Other responsibilities include system administration involving back end database management through SQL statements, data migration, managing user accounts, and quality assurance testing.

Jan. 97 – Jun. 97	ADP

Visual Basic analyst developing sales automation software for newest “roll out” of PCs.  Worked with hardware and software vendors and gained extensive experience in base loading, designing, testing, and customizing software and environments.  Setup security and users accounts in Lotus Notes and certain other proprietary software.  Troubleshot software from previous generation, in order to determine areas of improvement including boot-up, printing, bios, syncing and replicating of data onto server, dial-up and e-mail functions, Microsoft Office plus other general and/or specific difficulties.

Jul. 96 – Jan. 97	Preston Enterprise

Created proprietary front-end software using Access and Visual Basic.  Process included preliminary analysis, creation of relational database, design, implementation and training of staff on use of application.  Development of turnkey applications with features including data security, user passwords, and replication as necessary.  The software was designed to provide employee performance analysis, plus salary and bonus information as it relates to functional client contract balances, weekly work schedules and billing.

Education

1994-1995
Illinois State University                  
Normal, IL
Major:  Applied Computer Science
                             
1993-1994
Northern Illinois University
DeKalb, IL