SUMMARY:

He is a highly skilled and experienced Professional Software Developer. His area of expertise includes C#.Net, VB.NET, Visual Basic, VBA, VB Script, and front - end and back-end development for numerous database and application servers on major platforms including N-tier client/server and the web using Object Oriented, SDLC, and UML methodologies. John has experience with Microsoft COM/COM+ application server. He has performed numerous roles on both large and small development projects functioning as a technical lead, developer mentor, business area analyst, and acceptance tester. John has demonstrated he is a self starting and motivated contributor on either a team effort or an individual project.
SKILLS

Languages: VB.Net 2005, VB.Net 2008, ASP.NET, C#.Net 2010, Visual Basic 6.0/5./0/4.0/3.0 , C++.Net 2003, VBA, Visual Interdev, VB Script, JavaScript, XML, Transact-SQL, SQL Server DTS, Visual Studio Installer, .Net Web services, MVC

.Net Frameworks: 2.0 and 3.5, COBOL, PL/SQL Developer

Database: SQL Server 2008/2005/2000 , 2008 SMSS, SSIS, SRSS, SYBASE 12, MS Access, MS Access Forms and Reports, Oracle, Mercury Quality Center, DBASE IV, PARADOX, QuickBooks SDK 3.0, Hierarchical Mainframe (IMS), Relational Mainframe (DB2), RightFax

Communications : Novell, NT, Ethernet, Token Ring, Named Pipes, Microsoft Terminal Server, Citrix Metaframe

Other Exposure : DLL, COM+, COM, DCOM, DDE, API, OS2, AIX, UNIX

Hardware: IBM PC, IBM Mainframe

EXPERIENCE

Confidential

Responsibilities:

• Developed using C#.Net 2010, Microsoft SQL Server 2008, Oracle 10g
• Completed enhancements to the MB Doc Team Capture Configure system, a windows forms based system for maintenance of document types. Created report queries for Captiva imaging metrics using Oracle SQL Developer
• Developed applications to import OCC Article VII document into the iVault document imaging system for the ME Image Index Team. Assisted user department in clean-up phase of project, creating exception reports. Collaborated with testers in all phases of IST and UAT testing. Corrected bugs using HP Life Cycle Management 11.0.
• Successfully implemented applications to production, importing over 1 million documents
• Developed windows forms based applications for the QC Bulk Image Load Phase III, allowing user departments to perform bulk imports of document into the iVault document management system.

Confidential

IT SENIOR DEVELOPER

Responsibilities:

• Developed enhancements to the eContracting system, a web based form entry system to create automobile warranty contracts. Programmed in VB.Net 2008, Microsoft SQL Server 2008, ASP.Net, Adobe Acrobat, Java script
• Completed enhancements to monthly releases of the eContracting system web site and web services adding 30 new Adobe PDF contract forms, streamlined change control process, implemented testing standards and improved the performance of database queries.
• Added a new product line of warranty contracts for Recreational Vehicle Guaranteed Assets Protection (“GAP”) Agreements.

Confidential

CONSULTANT

Responsibilities:

• Developed enhancements to the ECOT system in Visual Studio C# 2010, MVS 3.0, LINQ database queries with Entity Framework, Team Foundation Server, MS SQLServer 2008, Microsoft SSRS, Java script
• Completed several sprints using the SCRUM methodology adding Resource Directory and Library to the system.

Confidential

CONSULTANT

Responsibilities:

• Supporting the AOA Combined quote system using C++ in Visual Studio 2003 and Beam Service in C#.Net 2010
• Successfully completed numerous changes and repair of defects for the Oct, Nov, Dec 2011 and Jan, Feb 2012 releases.
• Coordinated changes and testing of each release with system testers.
• Successfully completed a major modification of the Beam Service, a component for retrieving Affinity groups using web services for Mar 2012 release.
• Worked with members of AOA team and NP teams on successful testing of new version.
• Source code repositories used was Subversion using TortoiseSVN and Microsoft Visual SourceSafe.
• Authored queries against Oracle for gathering test data.

Confidential

CONSULTANT

Responsibilities:

• Supporting the IPAC (Interplan Pricing and Ceding System) using VB.NET 2008, SQL Server 2000, SSMS 2008
• Completed work on the IPAC system next maintenance release for NASCO, involving numerous user requests for enhancements including new process code and pushing plan profile changes to mainframe using Attachmate Extra HLLAPI API. Created new reports in MS Excel VBA, Created email using MS Outlook VBA
• Designed and prototyped next release of IPAC for service enhancements, created functional prototype of new service item window, worked with user group on refinements to requirements

Confidential

CONSULTANT

Responsibilities:

• Developed the Unemployment Tracking system for sister company CCI using C#.NET 2010, 2005 SSMS, 2005 SSIS. Created batch process to import data from client into new systems MS SQL Server 2008 database
• Developed the Reporting system ODS database using 2005 SSIS, extracting data from legacy AS400 to a MS SQL Server 2008 database

Confidential

ENVIROMENT SUPPORT ANALYST

Responsibilities:

• Supporting the ODAR (Claim overpayment system) using C#.NET 2010, 2005 SSMS, 2005 SSIS, 2005 SSRS
• Completed several changes to the web based ODAR system using C#.NET 2010.
• Created the Daily Status Reporting system for the environment team to track server uptime, disk space usage, scheduled SSIS batch job completion and other significant system events, using C#.NET 2010 and 2005 SRSS,
• created several tables and SQL stored procedures using 2005 SSMS
• Converted the ODAR events system to a more reliable infrastructure using C#.NET 2010
• Converted the ODAR alerts system to a windows application to improve response and reliability using C#.NET 2010
• Created a 2005 SSIS job to extract, encrypt and ftp the provider extract to customer

Confidential

IDENTITY MANAGEMENT SUPPORT ANALYST

Responsibilities:

• Supported the login process and reporting for Identity Access Management group using Oracle, VB.Net, Visual Studio 6.0 C++, 2005 SSMS, 2005 SSIS
• Created ad hoc reports of Cardinal.com user ids, names and shipping locations from the GA Oracle database based upon client requirements. Scheduled reports to run on a recurring basis.
• Created database scripts using Oracle SQL Developer and TOAD sql editors for conversion of shipping locations of Cardinal customers. Worked with account managers and project managers to schedule, execute and verify completion of database scripts.
• Authored 2008 VB.Net programs to display Cardinal.com user information from Oracle and SQL Server 2000 databases.
• Supported the Cardinal.com login DCOM/COM component authored in Microsoft C++ and SQL Server 2000, used to store authorization and authentication information for Cardinal.com users.
• Documented the encryption algorithm used to store passwords.
• Performed on call support for the Identity Access Management team, supporting UNIX and Microsoft Server machines, installed service packs and verified server processes were running correctly.
• Supported 2005 SSIS ETL process that imported Active directory information from PeopleSoft HR systems into the IDM SQL Server database

Confidential

CLIENT / SERVER DEVELOPER

Responsibilities:

• As a developer, using Visual Studio 2008 VB.Net, 2008 C#.Net, 2008 SSMS, 2008 SSIS
• Replacing the data layer in the Ohio Attorney General COIN System with a data object layer.
• Using x-tensiveable.net DataObects ORM
• Created a conversion process to translate the existing data store from Oracle to a new MS SQLServer ORM database
• Conversion process authored in 2008 C# with ADO.NET and SQLServer 2008 Integration Services (SSIS) SQLServer 2008 Reporting Services (SSRS)

Confidential

CLIENT / SERVER DEVELOPER

Responsibilities:

• As a developer, using Visual Studio 2005, 2008 VB.Net, 2008 C#.Net and Visual Basic 6.0;
• Converted enterprise legacy applications for Fraud and Claims systems from VB 6.0 to VB.Net 2005, 2008 and C#.Net 2008
• Tutored and assisted client developers on use of .Net 2005, 2008 development environments.
• Implemented the new Provider system using Web Methods in the Claims, Profiles and NewApp enterprise legacy applications
• Created production deployment installation msi files with new versions of the system.
• Supported Imaging application constructed in VB6 and Com+, responding to customer problems tickets.
• Setup and implemented new Window Server 2003 servers for the imaging system, using FTP, Fax and Scanner server interfaces.
• Validated and verified new imaging servers setups, making necessary changes to system components to use a DNS alias name for file and database server access.
• Documented the hardware and software components of the imaging system.
• Created support documentation for the imaging system.
• Converted the imaging components Com++ to VB.Net 2008 and C#.Net 2008 and MS SQLServer 2005.
• Mentored client employee on imaging system support and maintenance.

Confidential

CLIENT / SERVER DEVELOPER

Responsibilities:

• As a developer, using Visual Basic 6.0, .Net C#, .Net Web services and Oracle 9.1 SQL and stored procedures and packages.
• Completed projects on the IJetII enterprise application making numerous changes including Pilot contract, which allows the system to track the home and satellite airports used by pilots on a tour of duty.
• Created a new release of the Crew Availability and Crew Schedule Maintenance application adding functionality to track training and sick buy back time for a pilot, modifying an existing using VB, Oracle stored procedures and .Net Web services with WSDL and XML protocols per requirements of business. Created a setup MSI program using Visual Studio Installer, collaborated with production support to test and validate installation of new program version.
• Working on a new version of the Crew Availability and Crew Schedule Maintenance system, converting from VB 6.0 to .Net C#

Confidential

CLIENT / SERVER DEVELOPER

Responsibilities:

• As a developer, worked on the provider match system using Visual Basic 6.0, .Net C# and SYBASE 12, creating several new stored procedures and redesigned the matching logic used to find a provider for a claim

CLIENT / SERVER DEVELOPER

Confidential

Responsibilities:

• As the developer for the client, worked on a conversion of a Microsoft Access 2000 database system to an Oracle back-end system.
• Redesigned the PRAD system, the project reporting actuals database, from Microsoft Access to Microsoft SQLServer and VB.Net and ASP.NET
• Created a series of SQLServer DTS processes that gather project reporting information from other data sources, automatically updating the PRAD database on regularly scheduled basis.
• Redesigned the Project Life Cycle System to use the Siebel Team Sales System legacy Oracle database for project reporting. The project was completed successfully on time and on budget.
• Created new reports using Microsoft Access 2002 and using Microsoft Access VBA.
• Mapped data from the previous database structure to the new database structure.
• Revised Access reports for the new data structure; documented the new data flow; and trained the staff.
• Developed a new system in Microsoft Access 2002 using Microsoft Access VBA for deployment and application testing validation for the corporate rollout of Windows XP to 17,000 client machines.
• Created a new system in Microsoft Access 2002 that tracked the legacy application systems and their compatibility with Windows XP.
• Created a new system in Microsoft Access 2002 using Microsoft Access VBA for the Initiative and Status Tracking System for the project management reporting team.
• Created an update process in Microsoft Access 2002 using Microsoft Access VBA to the Siebel Team Sales System legacy Oracle database from several data sources for project expenditures and costs, saving the client a significant amount of resources and time.

CLIENT / SERVER DEVELOPER

Confidential

Responsibilities:

• As the developer for the client, developed an Microsoft Access 2000 database and QuickBooks 2003 Pro order entry system; prototyped a new system proposal to be developed in Microsoft .Net and Microsoft SQLServer.
• Developed an interface for a proprietary order entry system to add invoices to a QuickBooks database.
• Used Microsoft Access VBA and Intuit QuickBooks SDK to create an XML update for adding/querying: invoices, customer jobs, A/R, and service items.
• Analyzed business problem; developed a new interface that increased productivity by eliminating the duplicate entry of invoice information.
• Proposed, designed, and programmed a new system in Microsoft Visual Basic 6.0 and Microsoft Access 2002 to automate the creation of FDMS CardNet Master Card Level III transactions for transmission to the credit card processor.
• Modified the existing application to add invoices created by Visual Basic program to QuickBooks data store.
• Implemented a new/modified system; performed user training on the new interface.
• Created a prototype in Visual Studio .Net as an intranet site using Microsoft SQLServer as part of a proposal to replace the old proprietary system.
• Teamed with the client management to ascertain the feasibility of creating a new system in-house or develop with contracting firm or use the existing system.

LEAD COMPONENT DEVELOPER

Confidential

Responsibilities:

• As a Visual Basic 6.0 COM/Web developer for a state public website; used Visual Basic, Visual Interdev, MS SQLServer 2000, and MS COM+.
• Component developer on the Internet/intranet Medical Case Management System.
• Mentored six component developers on standards and coding conventions to ensure a high quality, professional system. Conducted component code reviews. Administered a Microsoft Visual SourceSafe source code library. Deployed releases of system at client site.
• Designed a fully normalized Microsoft SQLServer database for the Case Management System.
• Deployed components and web elements in Microsoft Visual Basic 6.0 for MS COM+ from middle tier to the system and QA environments.
• Created change control, a quality assurance process involving testers, project managers, and developers.
• Designed and developed the correspondence generation sub system.
• Developed database stored procedures using MS SQLServer Transact/SQL. Created and supported the data layer tier of the application.
• Created MS SQLServer DTS packages and jobs to convert the legacy FOXPRO DBASE IV data to a MS SQLServer database

CLIENT / SERVER DEVELOPER

Confidential

Responsibilities:

• As the lead developer for the client, worked on a client contact management system using Visual Basic, MS SQLServer 2000, Transact SQL, and MSCOM+.
• Completed development of an imaging subsystem in Microsoft Visual Basic 6.0 that was incomplete and inaccurate.
• Created architecture for an n-tier-based case management system using Microsoft Visual Modeler; established component programming standards.
• Mentored client developers in use of in Microsoft Visual Basic 6.0 in designing and programming an n-tier architecture.
• Used Microsoft SQLServer Transact-SQL stored procedures for imaging catalog system to store image attributes.
• Convert the legacy FOXPRO DBASE IV data to a MS SQLServer database

LEAD COMPONENT DEVELOPER

Confidential

Responsibilities:

• As a Visual Basic 6.0 COM/Web developer for a state public website, used Visual Basic, Visual Interdev, MS SQLServer 7.0, and MS Com+.
• Performed the role of component mentor in Microsoft Visual Basic 6.0 for 30+ developers on the Dolphin Internet development project.
• Established component programming standards for in Microsoft Visual Basic 6.0; performed code reviews of the developers work to ensure high degree of quality standards.
• Mentored developers on Visual Basic, Java Script, HTML, and Visual SourceSafe.
• Coordinated the activities of a developer pool of 30+ developers with the needs of four release project managers.
• Interfaced with the architecture team of application standards used in the development effort. Reported development teams status to the release team leads, vendors, and BWC management.

CLIENT / SERVER DEVELOPER FOR

Confidential

Responsibilities:

• Served as a Visual Basic 6.0 developer using Microsoft Access 1997. Developed a billing system for wholesale and business dial lines of business.

CLIENT / SERVER DEVELOPER

Confidential

Responsibilities:

• As a lead developer using Visual Basic 5.0 Visual Interdev and Oracle PL SQL, directed the efforts of four other developers on the use of Visual Basic and development programming standards.
• Developed a database maintenance system for an Internet commerce system replacing legacy system previously created with EFT case tool.
• Create a new system and conducted several initiative system walkthroughs with user management to finalize a design of the new system.
• Assisted the database analyst on the design of the Oracle database schema, applying the necessary changes to the legacy database.
• Completed the project on time and on budget for the shopping season.

CLIENT / SERVER DEVELOPER

Confidential

Responsibilities:

• As a Visual Basic 3.0 developer, used MS SQLServer 4.5 on the customer information systems team.
• Converted a legacy system created in DbaseIV and FoxPro to Microsoft Visual Basic 3.0 and MS SQLServer 6.0.
• Used Visual Interdev to create Transact-SQL stored procedures for customer information systems.
• Developed a voice response system (VRU) for a Conversant 2000 system that used the Transact-SQL stored procedures to inquiry and calculate lease and loan payoff amounts for leasing customers.
• Created process to convert legacy DBASE IV data to a MS SQLServer database

Confidential

IBM MAINFRAME ANDLIENT / SERVER DEVELOPER

Responsibilities:

• Served as a senior programmer/analyst using COBOL, JCL, Visual Basic 3.0, IBM IMS, IBM DB2 on the subscriber and provider support team developing and maintaining both legacy systems and new system development.
• Develop and maintain health insurance applications for claims processing, subscriber and provider maintenance, and legal and contract systems in COBOL, JCL, Visual Basic 3.0, IBM IMS, and IBM DB2.
• Created a legal subrogation system using COBOL, JCL, and IMS DB/DC saving the company four million dollars in lost claims expense.
• Created a contract benefit booklet generation system for the legal department using COBOL, JCL DB2, and TSO Dialog Services.
• Created an interface to the IMS database using HLLAPI and Visual Basic 3.0.