SUMMARY:

I have 19 years of software development experience. I have used a variety of software tools, including Visual Basic, C#, SQL, .Net, HTML, VBScript, JavaScript, ASP, T - SQL, SQL Server, SSMS, TFS, LINQ, Oracle, Assess and VBA with the Microsoft Office Suite.

TECHNICAL SKILLS:

Hardware/Software: Hardware/Network: IBM PC Compatibles, set up Network with Server 2000, Knowledge of TCP/IP, Knowledge of Active Directory, set up users and computers on the network, Set up internet email accounts. Terminal Services, Remote Desktop, Veritas Backup, Symantec Antivirus, Microsoft Exchange

Software: Visual Basic, C#, SQL, .Net, HTML, VBScript, JavaScript, ASP, Access, T-SQL, SQL Server, Oracle and VBA with the Microsoft Office Suite, Crystal Reports and Active Reports report engines.

RELEVANT EXPERIENCE:

Confidential, VA

Software Developer

Responsibilities:

• I was responsible for maintaining and enhancing the company’s CRM Access database, using linked tables to a SQL Server backend.
• I was also responsible for several other Access databases, all used SQL Server backend.
• I designed and developed several C# console apps that communicate via API to a Marketing tool - Pardot.
• The console app updates CRM data changes made in Access CRM to Pardot.
• I was also responsible for maintain these apps. I designed, and assisted in developing, an application to be used within the CRM application for building quotes, this app was written in .NET.
• I was responsible for writing stored procedures, views, TSQL, creating tables, queries in SQL Server.

Confidential, Norfolk, VA

Database Developer

Responsibilities:

• I was responsible for writing, maintaining and editing SQL scripts using Oracle and Toad for Oracle and running and scheduling batch files in Business Objects.
• I was also responsible for creating and revising Crystal Reports and scheduling reports in Business Objects.
• I was also responsible for setting up users and groups in Business Objects and maintaining security for Business Objects.
• I was responsible for data conversions from Access, Excel, SQL Server to Oracle.

Confidential, Norfolk, VA

Visual Basic Developer

Responsibilities:

• I was responsible for maintenance on a Visual Basic application that is used by credit unions-Qlending.
• I was also working on redesigning the application and database as the original has a lot of bugs and faulty coding.
• The backend is a Borland product call Interbase 7.0. It is very similar to SQL Server.
• I also maintained several small applications for converting databases (Access and Interbase).
• This is a long-term contract position.

Confidential, Chesapeake, VA

Senior Data Analyst

Responsibilities:

• I was responsible for training shipboard personnel on applications for inventory and maintaining Chemical, Biological and Radiological safety gear.
• I was responsible for converting data from Sybase Database to SQL Server database without technical specifications, data dictionary or diagrams.
• I was responsible for extensive use of Access and Excel and data manipulation between the two.
• I wrote Visual Basic code to convert some of the data from Sybase to SQL Server.

Confidential, VA

Computer Programmer

Responsibilities:

• I worked on an Access database for the Department of Agriculture.
• The application had been through several developers until I received it and worked through all the issues surrounding the application.
• I developed an interface in Visual Basic to link the Mettler PM6000 scales (used for weighing peanuts) and the Access database, using the Confidential object to pass the scale weight to the textbox on the Access form.
• I also wrote an export utility for all weight samples stored in the database to be exported to a disk and sent to the actual Confidential /Companies to be imported into their system.
• I also had external dlls and ocx files that needed to be on all computers using this program, so I wrote a small external visual basic application to install all files needed for the application to work properly.
• There were numerous problems with the application at the start, as there was a lack of documentation and design documents.
• The application was not designed with any consistency and the structure of the database was a concern as well as the lack of error handling code.
• I had to examine, revise and upgrade the application and all its functionality with an extremely tight deadline and satisfy all parties in the process.

Confidential, Norfolk, VA

Computer Programmer/Technician

Responsibilities:

• I was responsible for 2 servers and approximately 20 computers and users.
• This position requires knowledge in every area of the IT department. I was originally hired to maintain an Access Database and develop another one, as well as deal with hardware problems as needed. I architected 2 applications, started coding one and did all the other functions the job required.
• Most of the computers were outdated and I received calls for everything.
• It was a challenging position but I was totally dedicated to completing every task.

Confidential, Chesapeake, VA

Solutions Developer and IT Manager

Responsibilities:

• I started as an outside consultant working on an Access application and was soon offered a position as the IT Manager.
• There was not an IT department and I was assigned the task of developing an IT department and working on the project of developing an application for the call center.
• The application was designed with a SQL Server backend with a Visual Basic front end.
• As IT manager I was responsible for the supervision of 4 individuals.
• The IT department was responsible for the Network, 4 Win2000 Servers, backups, virus protection, disaster recovery, purchasing and installing of up to 100 computers.
• As a developer I was responsible for developing Access applications used for importing phone data, payment data and web sales.
• I also developed a Help Desk database that used VBA in Outlook and Access.
• I was the project manager and one of the senior programmers, coding the import process for Access to SQL conversion for the call center sales application.

Confidential, Chesapeake, VA

Solutions Developer

Responsibilities:

• My last assignment with Compass was converting a poorly designed Access database into a well-structured database for a call center in Chesapeake.
• I worked with Access and VBA to develop this application.
• I developed Web-based applications (Intranet and Internet) and standard applications for various clients using Visual Basic, Visual Interdev and SQL Server.
• I was assigned to a project team in support of developing a Web-based application (Intranet) using Visual Basic and SQL Server.
• The application was used to track the client’s programs, projects, and events as well as their contacts and organizations.
• I assisted in the development of the detailed design and was responsible for coding the user services portion of the application.
• I was assigned to a leading healthcare organization where I assisted in developing reports in support of various projects, using Visual Basic, Data Dynamics Active Reports, and SQL Server.
• I supported the Network Support Query Conversion Project, which entailed the conversion of over 700 MS Access 2.0 and 97 queries from MS Access to SQL Server 6.5 pass-through queries.
• The project team followed a life-cycle methodology by examining existing queries, converted the SQL code to utilize a different data source and the proper T-SQL syntax, documented all SQL code and applicable business rules, and tested the new queries.
• I also supported the Regulatory Reports Project for the same client, which involved the creation of numerous reports to meet regulatory requirements.
• The project required contract reviews, interviews, with various departmental business owners, issue management and conflict resolution, and detailed, meticulous documentation of all reports.

Confidential, Virginia Beach, VA

Solutions Developer

Responsibilities:

• I was one of a few programmers working on a great variety of computer systems integration projects in a diversity of industries.
• For a health care call center service company, I stabilized an Intranet site designed in Microsoft Visual Interdev, with the data residing in a Microsoft SQL Server database.
• I was then assigned to a team to develop a new 3-tier application (Version 2) consisting of Visual Basic 6 Webclasses for the interface, with business rules encapsulated in ActiveX DLLs, and the data residing in a Microsoft SQL Server 7 database. For the Code Enforcement Division of Virginia Beach, I was assigned to a development team to produce a custom 3-tier application consisting of a Visual Basic interface, with business rules encapsulated in 10 ActiveX DLLs, and data services residing in a Microsoft Access database (to migrate to SQL Server).
• I was responsible for testing and debugging the application and for creating and coding 25 Reports in Data Dynamics Active Reports.
• I was a maintenance programmer on a Microsoft Access application that created invoices for tracking commercial vehicles entering the AVI parking system.
• To prevent duplication of data and incorrect invoicing, I developed a procedure to detect and flag duplicate data.
• For Electrical Suppliers, I developed a 20-page Web site using Microsoft FrontPage, Microsoft Image Composer, VBScript, and an HTML editor.
• The site was designed as a foundation for future electronic commerce.
• At a client site, I worked with other developers converting Microsoft Access queries and reports and Microsoft Excel reports into customized GQL reports using data from the client’s SQL Server data warehouse.
• GQL allows developers to create a graphical data model, which can then be manipulated to produce reports. I created 13 data models and 7 reports, requiring the creation of many complex SQL statements.