Jesse F. McAnally

92 Indian Trail, Bristol, CT 06010

860-583-2125� ����Email jmcanally@openmindgroup.com

SUMMARY

I have over 8 years of professional development experience in Web and Client Server solutions, at the desktop and enterprise level, primarily using Microsoft solution strategies.� I have recently been specializing in .NET Web and Windows solutions, using both C# and VB.NET. I am continually excited by the creative options in working with cutting edge technologies, and the satisfaction of solving problems as part of a dedicated team.� Prior to entering the IT field, I enjoyed a successful and innovative 26 year career in management.�

PRIMARY FOCUS: C#� and VB.NET, Visual Basic 6, Visual Basic for Applications 6, HTML, Active Server Pages (ASP, ASP.NET), ADO/ADO.NET, ODBC, MS SQL Server and T-SQL Stored Procedure programming, PL/SQL and Oracle7.x � 10g programming.

SECONDARY SKILLS:� MS Access and MS Office automation, Macromedia Dreamweaver MX, Macromedia Homesite+, XML, JavaScript and DHTML, IIS 5 Server, , Brio SQR Report Writer, Borland Paradox

EDUCATION

MS, Economics, University of Baltimore, Baltimore, MD � Delta Mu Delta, Beta Gamma Sigma

BS, Business, Cum Laude, University of Baltimore, Baltimore, MD

Brown University, Graduate School of Savings Banking � Honors Graduate

CERTIFICATIONS

Microsoft Certified Professional:

Developing and Implementing Web Applications in VisualBasic.NET (Jan. 2005)

Developing and Implementing Windows based Applications in C#.NET (Dec 2004)

Designing and Implementing Desktop Applications in VB6 (Feb 2002)

Designing and Implementing Distributed Applications in VB6 (Mar 2002)

COURSES

JAVA Bootcamp, New Technology Solutions, 2004

ASP.NET Bootcamp (C#), New Technology Solutions, 2004

C# Bootcamp, New Technology Solutions, 2004

ASP Bootcamp, New Technology Solutions, 2000

RELEVANT PROJECTS

C# / ORACLE DEVELOPER�� Northeast Utilities (NU), Rocky Hill, CT

February 2005 to Present (Contract position)

Create an interface to integrate data from NU�s, newly installed, Oracle based work-management system with existing proprietary Excel spreadsheet tools used by NU crew supervisors and leaders to estimate/track local property tax adjustments related to the installation/upgrading of electric utilities.�

• Created a C# utility program and related PL/SQL stored procedures to extract data from Oracle 9i database and insert it into spreadsheet templates.
• Once the spreadsheet was completed by the user, I supplied C# methods to extract the calculated results and PL/SQL stored procedures to insert data into Oracle database
• Also created a C# - PL/SQL utility to manage a library of spreadsheet templates stored in the Oracle back-end as BLOBs.

Skills Utilized: C#, ADO.NET, Oracle PL/SQL, MS Access / MS Excel VBA

SQL / ERA TRAINER�� Tuition Management Systems, Corp, Newport, RI

March 7 � 10, 2005 (Contract position)

Created and presented a four day training class covering basic T-SQL language and programming structures, Relational Database Architecture and operations as implemented in SQL Server 2000, Relational database design using the Extended Relational Analysis modeling approach, and basic data import/export operations using the SS2K Data Transformation Services utility.

Skills Utilized: T-SQL, Extended Relational Analysis (ERA), SQL Server 2000 Database and Data Transformation Services

VB6 / MS ACCESS DEVELOPER GE Insurance Services, (ERC/LTC) Avon, CT

July 2002 to November 2004 (Contract position)

GE Insurance Services, (ERC/LTC), and its predecessor AUL Long Term Care Solutions, provided third party administration (TPA) services, and reinsurance facilities, for Long Term Care insurance products to approximately 50 carriers nationwide.� The TPA services included Policy Underwriting and Issuance, new LTC Product development and registration, Policy Billing and Account administration, and Claims Processing services.�

Assignments:

February � November 2004: Organizational Devolution In January 2004, GE Insurance Services decided to shut down the TPA services unit, and to transfer its client carrier�s account to various successors. Coding for these utilities was produced in C# using ADO.NET.

• Created custom programs to extract Underwriting and Issuance historical records, and package that data for successor entities in specified formats.�
• Created a utility to allow the identification of approximately 4,500 attending physician statements (APS) files, stored in PDF format on our network, correlating them with applicant records the MS Access database, and packaging these files as sets for the appropriate successor entities. By exploiting the .NET Regular Expression functionality, I was able to �automate� identification of roughly 80% of these files.

Skills Utilized: C#, VB.NET, ADO/ADO.NET, T-SQL, MS Access VBA

October 2002 � January 2004: System Consolidation Project The TPA�s services were supported by three discrete systems, An MS Access based a system for Policy Underwriting and Issuance (which I was responsible for), a Clarion based Benefits and Claims Administration system, and a SAS based policy administration system.� These systems were coordinated through an array of dynamic and batch interfaces.� Shortly after acquiring the TPA, GE identified the need for a holistic system as an IT priority.� I provided support for this initiative by:

� Porting the MS Access 2.0 database (16 bit) to MS Access 97 (32 bit) to improve operating functionality and prepare the data for consolidation into the final data store.

� Assist IT team in developing specs and requirements for identifying and evaluating programs from third-party vendors that could be implemented or modified to provide an integrated solution (Preferred approach: five options were considered, but none satisfied our technical and user requirements.)

� Assist IT team in developing specs and requirements for an �Internal Build� of a consolidated system.� This alternative was conceived as phased porting of the discrete systems, Claims/Benefits, Underwriting and Issuance, and finally Policy Administration, into a C# - SQL Server 2000 based structure.� This process had proceeded to the point that a consulting data architect had completed a preliminary model for the database, and IT management was recruiting staff to comprise the build team.

� Created a SQL Server 7.0 version of the MS Access 97 database as an interim �back end� structure to support the phased consolidation.

Skills Utilized: C#, VB.NET, ADO/ADO.NET, T-SQL (SS2K), MS Visio

July 2002 � November 2004: Operations Support With the termination of the integrated solution, my assignment to maintain and extend the MS Access database application was continued indefinitely.� Over the course of the next several months I extended the system by:

• Implementing (on a state by state basis) a series of new LTC Insurance products for various carriers. (The implementation process involved creating a custom pricing VBA routine, implementing various validation procedures to enforce unique/specific business rules, append relevant benefits data into the database, create an appropriate Schedule of Benefits for the product/state, and map appropriate (external) Policy and Rider documents to specific benefits.)
• Created a VB6 standalone process that automated the export of daily activity to the SAS based Policy Administration system. (Previously, this had been a series of manual exports that had to be accomplished prior to the start of the business day.)
• Specified the design of, and created an automated extraction utility for, a Web based agent inquiry system to allow agents at participating carriers to track the TPA�s progress in processing applications.�

The web site was created and administered by GE Insurance Services� web server facility in Kansas City; the data extraction utility was located in Avon, and provided daily feeds to the web server facility.� In addition to reporting the TPA�s own activity, the data extraction utility was extended to integrated data from provided �by a third party vendor.��

Skills Utilized: MS Access VBA (Access Basic), VB6, ADO, T-SQL

ASP/DHTML, VB6, MS ACCESS DEVELOPER AUL Long Term Care Solutions, Avon, CT

March 2002 to June 2002 (Contract position)

Assignments:

March 2002 to May 2002� Web Development �In addition to the maintenance responsibility described below, I also assisted in the development, �bug swatting,� and testing of ASP and DHTML pages for the Intranet based Rating, Underwriting, Claims Management and Administration system that was to replace three discrete systems.� Five weeks after I joined AUL, the company was acquired by GE Insurance Services, (ERC/LTC), and this project was terminated.�

Skills Utilized: VB6, Visual Interdev, ADO, IIS/ASP/DHTML/HTML, VB Script and JavaScript.

March 2002 � June 2002: Operations Support I joined AUL as a short term, temporary assignment to maintain a critical MS Access 2.0 database application for Underwriting and Issuing Long Term Care policies as a Third Party Administrator. ��The system was to be replaced by an integrated Rating, Underwriting, Claims Management and Administration system that was to be released to production w/in six months.�

The database was approximately 8 years old, and comprised approximately 100 tables, 75-80 GUI forms, 200+ internal documents (reports).� It interfaced dynamically with a Clarion based Benefits selection utility that was part of the Claims system, and by batch exports to a SAS based policy administration system.� (I received a one-half day introduction to the system by the previous custodian, prior to taking over.)

Skills Utilized: MS Access VBA (Access Basic)

SOFTWARE DEVELOPER Open Solutions, Inc, Glastonbury, CT

March 1997 to January 2002

Assignments:

October 2001 to January 2002: Intranet Developer Maintain and extend reporting utilities for internal CRM system to support corporate operations.

At the point I joined the project, the CRM database was being ported from Oracle 7.3 to SQL Server 7.� The intranet site had been developed in Allair (Macromedia) ColdFusion 5.

• Recoded all existing stored procedures from PL/SQL to T-SQL syntax to allow the continued use of the existing CRM report pages.
• Rewired the existing ColdFusion 5 pages to use the new SPs.
• Created 20 new reports in ColdFusion 5, together with supporting T-SQL stored procedures, and parameter driven report selection pages.
• In a few cases, integrated ASP pages and VB6 Components into the intranet site, to extend functionality beyond what was possible in a ColdFusion environment.

Skills Utilized: ADO, T-SQL (SS7), Oracle 7.3 PL/SQL, IIS/ASP/DHTML/HTML, Homesite 5, ColdFusion 5, JavaScript (Dreamweaver 4)

October 2000 to October 2001: Web Developer, Internet Banking project Part of a team responsible for maintaining and extending an Internet Banking solution. The underlying program had been developed by an acquired company, and required substantial modification to allow it to scale sufficiently for OSI�s client needs. The Internet Banking product was hosted at OSI�s ASP facility for all client banks.

• Recoded numerous ASP pages to extract in-line SQL queries and processing statements, porting the functionality to VB6 components and T-SQL stored procedures.
• Added ASP pages, and related components, to permit client banks to �self administer� portions of their web-site�s functionality.
• Created a set of standard user reports generated though a VB6 based component that implemented Microsoft�s �Data Report� ActiveX component.

• Created a Visual Basic based �Web Site Deployment� solution for the Internet Banking program, resulting in a standardized and streamlined multi-server deployment process.

Skills Utilized: VB6, T-SQL (SS7), Visual Interdev, ADO, IIS/ASP/DHTML/HTML, VB Script and JavaScript

February 2000 to October 2000: Web Developer, eCommerce Portal project Selected for a 10 person �New Initiatives� team charged with the development of an eCommerce site, that would allow OSI�s client banks to provide access to national and local merchants through their own branded portal.�

The innovative portal �hosted� subscribing merchant web-sites, and provided a consolidated shopping cart to allow purchases from multiple merchants in a single session.� When the session was complete, the user was given the opportunity to do a consolidated checkout with all merchants, to manage the contents of the consolidated shopping cart, or to save their various selections for a future session.

• This project, developed in conjunction with an experienced 5 person team from a local technology contractor, was completed and launched within 9 months of the original idea, using technology and platforms that were completely unfamiliar the OSI team members at the outset.� The effective use of RAD techniques in this project had a transforming effect on OSI�s enterprise wide approach to development.
• Created ASP pages to implement administrative support for the eCommerce Portal.
• Created ASP pages and related VB6 components to implement an industry standard XML Purchase Order specification that would facilitate efficient transactions between subscribing merchants and our portal.� (While this functionality succeeded in test, none of our subscribing merchants had elected to implement the specification by the time the project was completed.)
• �Created �screen scraper� ASP pages using Regular Expressions to detect whether a user had selected an item from the �hosted� merchant�s site, and redirect the transaction to the portal�s internal �Shopping Cart.�� At least one of these pages was required for each hosted merchant, and would need to be updated whenever the merchant�s page changed.
• Participated in the Unit and Integration testing process for the project.

Skills Utilized: VB6, T-SQL (SS7), Visual Interdev, ADO, IIS/ASP/DHTML/HTML, VB Script and JavaScript

August 1998 to January 2000: Professional Services Developer Created reporting tools, techniques and solutions for client banks in a Windows NT Client Server environment against an Oracle database.

• Developed and maintained a diverse array of data reporting projects using Visual Basic 6, Brio SQR, Oracle PL/SQL and MS Access 97.
• Developed several custom �batch� processing routines for client bans, using Brio SQR and PL/SQL.� A typically routine was a daily automated process that extracted and exported customer transaction data to a bank�s Internet Banking solution provider.
• Conceived of, championed and developed a VB6 utility that allowed the merger of multiple sets of data from client banks that each used the OSI core database.� The process relied on the internal consistency of the database structure, and used ADO to �walk through� the source database tables, perform relevant transformations and insert the result into the target database.� The tool replaced a huge amount of custom programming, and thousands of lines of project specific coding, for each such merger situation, and illustrated the viability of using RAD techniques and VB6/ADO as an alternate programming strategy for custom projects.

Skills Utilized: VB6, VBA, ODBC, ADO 2.1, Oracle 7.3 PL/SQL, Brio SQR, MS Access 97,

March 1997 to August 1998: User Reporting Services Programmer I joined OSI as a Banker and �Power User�, charged with finding ways to� empower users to exploit the power of� OSI�s Oracle based core banking system, by creating �ad hoc� custom reports using �off the shelf� desktop tools.� We ultimately settled on MS Access as the primary desktop tool we supported.� While the company and I knew that this interaction was possible, no one had succeeded in implementing the technique in a �user friendly� way.

• While connecting tools like MS Access was fairly straightforward with ODBC, retrieving useful data, given the highly normalized structure of our data, was problematic.

• Created and presented a series of training classes for OSI clients to show them how to structure MS Access queries appropriate to retrieving specific data points.
• To suppress the complexity of certain operations, I developed custom tools, basically MS Access functions, which wrapped embedded SQL statements and were available for �in-line� calls in MS Access queries.� Initially this functionality was implemented using ODBC.� It eventually became almost as efficient as OSI�s native GUI when I was able to use ADO 1.5 to make calls to our PL/SQL stored procedures.

Skills Utilized: VB6, VBA, ODBC, ADO 2.1, Oracle 7.3 PL/SQL, MS Access 95/97, MS Access 2.0 (Access Basic)

OTHER WORK EXPERIENCE

Prior to entering the IT field professionally, I had a longstanding interest in exploiting desktop and distributed technologies to enhance business processes.�

The Bushnell Performing Arts Center, Hartford, CT��������������������������������������� 1995 � 1997

Manager, Telemarketing Systems (Acting)

The North American Bank & Trust Company, Waterbury, CT������������������������ 1984 � 1996

Vice President, Loan Workout and Collections,

Vice President, Residential Mortgage Lending

Exectrav, Inc., Newington, CT������������������������������������������������������������������������� 1990 � 1998

Founder, Co-owner

First National Bank of Maryland, Baltimore, MD��������������������������������������������� 1979 � 1984

Vice President, Residential Mortgage Production

The Savings Bank of Baltimore, Baltimore, MD���������������������������������������������������������� 1968 � 1979

Vice President, Residential Mortgage Production

OUTSTANDING REFERENCES ON REQUEST