ASP.NET C# VB.NET SQL Server

John DeFrain

*** ******* ****** **** **********, GA 30022

Mobile 678-***-****

***********@*******.***

KEY SKILLS

Software Development - 18 years

SQL Server, Oracle - 12 years

Management / Project Lead - 14 years

ASP / ASPX / Ajax - 10 years

C, C# - 10 years

.NET 1.0, 1.1, 2.0, 3.0, 3.5 - 10 years

Java - 2 years

EXPERIENCE

Verizon Wireless, Alpharetta, GA

July 2009 to Present – Contract

Senior Architect/Developer

100% design and development of a User Acceptance Test intranet site. A companywide tool used to test and track internal and external software releases. Users have the ability to manage custom groups, user permissions and a multitude of notifications options. Developers, Testers, Approvers, and other group types can upload test scripts, custom groups and user lists. Technologies include ASP.NET 3.5, C#, MS SQL 2008, and Ajax.

Curtis 1000, Atlanta, GA

May, 2009 to June, 2009 (4 week contract)

Senior Architect

Designed and built 100% of a subscriber based website to be used by major universities to broadcast emergency messages and activities to their student’s mobile phones. Site includes abilities for students to select what types of SMS message they would like to receive on their mobile phones. University administrators have the ability to manage messages and distribution lists. Technologies included ASP.NET, C#, MS SQL, CodeSmith, JavaScript and Ajax.

RBS WorldPay, Atlanta, GA

July, 2000 to March, 2009

Principal Architect, ATM Management and Distribution Systems

Experience leading teams through all phases of the software development lifecycle. Responsible for architecting and developing applications that allowed a small company to grow to a billion dollar enterprise. Have a combination of leadership, strong technical abilities and inter-personal communication skills.

ATM Accomplishments:

Created an entire suite of integrated applications automating nearly every ATM business processes. The Real-time Transaction System collects over one million messages per day on 30,000 automated teller machines country wide. The system interfaces directly with the Stratus, a multi-million dollar, high availability, high volume financial data processing system. The Real-time Transaction System required five nines reliability, meaning less than 6 minutes of down-time per year. To achieve this, my team designed and built an N-tier redundant application using multi-threading, multiple servers and proprietary protocols between applications and servers using C++, C#, ASP.NET, WCF, ADO.NET, .NET 3.5 and MS SQL Server.

Echo, a cash management system was built using C#, ASP.NET, ADO.NET, and MS SQL Server. The system is designed to provide the Cash Management Department at RBS everything needed to maintain ATM balances, forecast ATM replenishments, manage bank accounts, armored car services, and customer billing. The system interfaces daily with RBS banks worldwide and automated teller machines in the system, synchronizing the balance with its associated bank account. I personally established relationships with each bank, providing them with the design and requirements necessary. This system provided RBS WorldPay and our banking partners enormous efficiencies.

Designed and developed the Incident Management System (IMS). This is a software package that collects and processes over one million messages per day. This unique application proactively reviews the latest activity of thousands of automated teller machines to determine if each is operating within the bank’s specified constraints. RBS WorldPay personnel, ATM service personnel, and the banking partners are notified automatically with fault information through an escalation, priority weighted, hierarchical decision tree. Technologies used in the development of the IMS system include C#, ASP.NET, WCF, third-party Java applet integration, ADO.NET, VB 6, XML, ActiveX, and COM+.

The ATM customer self-service website encapsulates the above services while exposing them to RBS WorldPay’s customers. Customers have the ability to review current, daily, monthly, annual billing and profitability with customizable reporting tools. Integration and modification of third-party java controls provided navigation and property selection throughout the site. Additional features included an Electronic Journal and Reconciliation System allowing ATM customers direct access to the log of their ATM machines without physically visiting them, an industry first. This enhancement has a U.S. patent listed under RBS WorldPay and my name recorded as the sole inventor.

CashLynk, an issuing system, built using C#, ASP.NET, WCF, and MS SQL Server is a customer facing web application providing clients the ability to disperse cash to customer credit cards. Millions of transactions per day are maintained on distributed MS SQL Servers. The arrangement of this data into cubes enhanced customer service’s ability to solve customer’s issues and removed the limitations of the relational database. To improve performance and functionality I assisted with the conversion of this product to MS SQL 2008.

Distribution Accomplishments:

The Distribution division manages, fulfills, and tracks all shipped products to RBS WorldPay’s customers. I took responsibility of this group to further enhance and automate their processes. New applications included the development of mobile barcode devices, inventory, billing, tracking, ordering and fulfillment systems. It was determined that this function in part could be better managed by an outside provider. With a team of developers, we built an interface between our systems and a 3rd party fulfillment company, releasing over 20 personnel to new opportunities at RBS WorldPay and closing a warehouse while improving product fulfillment, billing and tracking of customer orders. This has provided RBS WorldPay a cost reduction of eight million dollars.

Additional Accomplishments:

Designed and built a Change Control System to manage corporate wide changes to all systems including hardware, software and processes. This fulfilled an external audit requirement.

Initiator and leader of a team of VPs, Directors and Managers to establish RBS WorldPay’s Software Development Standards.

HomeBanc Mortgage Corporation - Atlanta, GA

July, 1996 to July 2000

Senior Developer / Project Lead

Participated in full lifecycle development of high-traffic, content-rich e-commerce applications, including: design, development, testing, implementation, and documentation of the applications. Approximately 75% of time spent with hands-on development, and the remaining 25% in a project lead role. Project leadership duties included use of MS Project to create project plans, scope, milestones, and deliverables, supervision of two other programmers in the development cycle, and serving as a liaison between technical management and the development team. Extensive programming of Internet/Intranet applications with the following technologies: Active Server Pages (ASP), JavaScript, VBScript, MS SQL, XML, HTML, DHTML, Cascading Style Sheets (CSS), NT, IIS, Visual Basic, COM, Visual Studio 6.0, MS SQL Server, Oracle Enterprise Tools, Macromedia Flash 4.0, and Dreamweaver.

Converted all daily printed reports (over 600 per day) to an automated Intranet application. This process saved the company an estimated $225,000 per year. Designed and developed a high volume web application, collecting client’s personal information and credit history over a secure connection.

United Capitol Insurance Company - Atlanta, GA

April, 1995 to July, 1996

Senior Programmer

Designed new applications to run seamlessly within existing applications in FoxPro, MS Visual Basic, and C++ for both Windows and DOS platforms. Maintained and enhanced over 1,000 programs of existing applications written in FoxPro for Windows and DOS. Documented new and pre-existing software and procedures.

Unity Mortgage Corporation - Atlanta, GA

February, 1993 to April, 1995

MIS Director

Responsible for all computer related operations of the entire company, including over three hundred employees at nine branches and sixteen satellite offices across the country. Planned, designed, and implemented the restructuring of the local area network, which consisted of 150 nodes and several file servers. Project included coordinating with contractors and executives to ensure timeliness and consistency throughout the corporation. Developed applications in FoxPro for Unity's loan tracking system. Responsible for all technical aspects of relocating over 200 personnel including contractor selection, voice/data wiring, equipment selection, and project management. Managed and maintained corporate databases for all departments including Accounting, Servicing, Personnel, Quality Control, Underwriting, and others. Hands on management of the development team.

Capital Data, Inc. - Lansing, MI

September, 1991 to February, 1993

Network Administrator/Application Developer

Applications support for network users in-house and at customer sites. Responsible for system development, design, and implementation of a national imaging product.

Dart Container - Mason, MI

September, 1990 to September, 1991

Computer Information Systems Programmer

Developed quality control and file management applications on Sun workstations.

Contact this candidate