Post Job Free

Resume

Sign in

Sql Server Oracle .Net Service Application Project

Location:
Strongsville, OH, 44136
Posted:
March 09, 2010

Contact this candidate

Resume:

Lee A. Fine

abnpu9@r.postjobfree.com

440-***-****

Work Experience:

President & Consultant, JBJC Enterprises LLC Feb, 2002 – present

Barnes Distribution Jan, 2009 - present

• Worked on creation of a .NET (VB.Net) Compact Framework 3.5 hand-held device

application to view, and update orders. Also was responsible for writing a VB.Net web service

layer to communicate between the hand-held device application and the AS400 host.

• Part of a team that upgraded Classic ASP website to ASP.Net.

Litigation Management Incorporated Mar, 2008 – Dec, 2008

• Responsible for maintaining and enhancing a variety of the company’s web, web service,

windows service, and windows forms applications utilizing platforms such as .Net 2.0, .Net 1.1,

VB 6.0, and SQL Server 2005, and languages such as C#, VB.Net, Visual Basic, and T-SQL.

Progressive Insurance Aug, 2006 – Feb, 2008

• Designed and developed a multitude of web, web service, and console applications for

company’s IT Security team utilizing .NET Framework 1.1 & 2.0 tools, along with SQL

Server 2000, including:

o Enterprise wide security provisioning web and accompanying console applications,

which allow Progressive employees to request security roles.

o Various console and web applications to maintain certificate ownership and renewal

o Web service and accompanying console application to assist Progressive’s enterprise

wide HR Express application setting up new employees

Precision Dialogue

• Created public facing web application (ASP.NET 2.0/SQL Server 2005) to allow users to

advertise various items for sale on radio stations web sites. Site included an administrative piece

for radio station administration.

Penske Logistics Nov, 2004 – Aug, 2006

• Created VB.NET extranet application that gives third party partners the ability to

update order information. Application interfaces with mainframe backend by way of a VB.NET

wrapper dll and Attunity Connect middleware.

• Maintained C# intranet application that makes it easier for operations personnel to

monitor active routes. Drivers use cell phone enabled application that sends and receives

messages from Java based middleware. Web site utilizes the Microsoft MapPoint web service

to show maps with the routes displayed. Modifications also include the creation of new and

updates to existing Oracle PL/SQL stored procedures.

• Created VB.NET “crisis management” intranet web site that allows upper management

to quickly determine all Penske Logistics locations affected by a natural disaster. The user

simply plots points on a map, and the application will determine all Penske locations within the

bounded polygon. Utilizes Microsoft MapPoint, Oracle, and Oracle Spatial technologies.

• Modified Java middleware application to allow for the transfer of order and route data

to/from mainframe and handheld PDA device.

Main Sail LLC Oct, 2004 – Feb, 2005

• Support company’s project management/time management application. This involves

modifications to ASP.NET (VB.NET) pages as well as SQL Server 2000

tables/sequences/stored procedures.

Ernst & Young LLC Feb, 2004 – Sep, 2004

• Maintained existing SQL Server 2000 applications utilizing DTS workflow.

Lee A. Fine

abnpu9@r.postjobfree.com

440-***-****

Proforma Nov, 2003 – Apr, 2004

May, 2002 – Sep, 2002

• Created and maintained complex SQL Server 2000 stored procedures and views for

sophisticated Crystal Report reporting structure for a large web-based order processing system.

Also leveraged SQL knowledge to research data anomalies in the system.

• Merged company’s marketing and order processing customer data stores into one

database. Project involved writing a SQL Server 2000 stored procedure conversion process

along with significant Visual Basic COM and ASP enhancements.

Fidelity National Aug, 2003 – Nov, 2003

• Developed enhancements for leading field service firm’s customer and employee

extranet. Utilized Oracle PL/SQL stored procedures, the PL/SQL Web Toolkit, and Oracle

Reports to implement a variety of modifications.

Rockwell Automation Jun, 2003 – Jul, 2003

• Implemented various modifications to company’s automated order and sales tracking

system. This web-based application utilized ASP, VB 6.0, and SQL Server 2000.

Western Reserve Internet Services Inc May, 2003 – Jun, 2003

• Developed an ASP based website with a Microsoft Access 2000 backend for a large

educational institution.

Avery Dennison Dec, 2002 – May, 2003

• Rewrote data warehouse load process implemented in SQL Server 2000 and populated

using SQL Server 2000 stored procedures.

Kelly Services Aug, 2002 – Oct, 2002

• Modified company’s job search website to allow company’s recruiters to choose which

online job boards to export jobs to. This project required the creation of new and modifications

to existing Oracle PL/SQL stored procedures and table definitions, the creation of a new Visual

Basic COM component, and one new and several altered ASP pages.

Baker ER Feb, 2002 – Nov, 2002

• Designed and implemented web-based statistical modeling intranet application. Site

consists of over 20 ASP/HTML pages that are used to add/update/delete data and to create

graphical charts and reports from a SQL Server 2000 database. Site also utilizes SQL Server

2000 DTS package to load data.

Digiknow Sep, 2001 – Feb, 2002

• Created SQL Server 2000 stored procedures for permission-based marketing application.

• Modified VB COM objects and Oracle PL/SQL stored procedures for web-based survey

application’s reporting module

• Created ASP interface program for online job search engine so that third party site can seamlessly

transfer jobs. Interface program validates data, logs input, and posts jobs to backend Oracle

database.

FutureNext/VantageOne Apr, 1999 – Sep, 2001

• Member of project team that created best of breed real estate web site. Responsible for database

design, Oracle PL/SQL stored procedure creation, and SQL query datatasks.

• Supported 20 separate web sites for Fortune 500 company. This included an online job search

engine written in NetDynamics/Java with an Oracle backend that received thousands of hits per

day. Led project team that re-wrote application using an ASP/VB 6.0 COM/Oracle architecture.

In addition to designing the database, screens, and many of the components for the new application,

was also responsible for all SQL and stored procedure (PL/SQL) creation.

Lee A. Fine

abnpu9@r.postjobfree.com

440-***-****

• Developed SQL and Oracle stored procedures (PL/SQL) for an online survey application for a

Toronto-based research and analysis corporation. Wrote approximately 30 queries and 30 stored

procedures, including some requiring highly complex statistical analysis.

• Member of project team responsible for creating a stand-alone Java/Swing application for a

Chicago-based research firm.

• Responsible for the creation of ASP/HTML pages for a scheduling application for a leading supplier

of hair-care products.

KeyCorp Dec, 1994 - Apr, 1999

Blue Cross Blue Shield of Ohio Feb, 1990 - Dec, 1994

Ernst & Young Jul, 1988 - Dec, 1989

Technical Experience:

Operating Systems/Software: Windows NT/2000/XP/2003

Web Servers IIS

Application/System Languages: ASP.NET 1.1/2.0/3.5 (C# and VB.NET), .NET Compact Framework,

.NET Web Services, Java, (including some classroom experience

with J2EE, JSP, Servlets, and JDBC), J2ME (limited), PL/SQL, T-

SQL ASP, HTML, VB 6.0, VBA, NetDynamics, COBOL, CICS,

JCL, SQL, DYL280, REXX

Databases/Datastores Oracle 8i/9i, Oracle Spatial, SQL Server 2000/2005, DB2, Access

2000, VSAM

Tools/IDE’s: Visual Studio.NET, Eclipse, Microsoft MapPoint, Oracle Reports 6i,

SQL Loader, DTS, Crystal Reports, IBM Visual Age, JBuilder,

Toad, Microsoft Interdev, Attunity Connect, Allaire Homesite,

Embarcadero Rapid SQL

Productivity Software: Microsoft Office Suite

Education:

Youngstown State University Bachelor of Science degree, 1988

Major: Computer Science

Minors: Accounting, Mathematics

GPA: 3.49



Contact this candidate