SUMMARY:

• IT professional with 19+ years of experience in design, implementation, deployment and maintenance of in - house and client applications utilizing VB6, ASP.Net, VB.Net (2002 - 2010), SQL Server (2000 - 2012) .
• Strong in application and database design, development, deployment and maintenance with extensive experience in Troubleshooting, Software and SQL Server Development, Software and SQL Server Upgrades/Migrations, Database Archiving, Replication and Report Servers, Supporting clients internal and external.
• Seeking challenging role within an organization that values exceptional developmental and troubleshooting skills, broad range of technical knowledge and proven ability to complete projects on time, while meeting and exceeding client objectives.
• Proven expertise with all phases of product life cycle, including requirements analysisapplication design, implementation, data conversion, design review, and system testing
• Broad technical knowledge spanning diverse range of technologies, skills, and methodologies
• Demonstrated skill at identifying and utilizing leading-edge technologies. brainstorming

TECHNOLOGY:

VB.Net 2005-2008-2010 VB6 conversion to VB.Net - New development, Enhancement and Support (Exp 12yr) C#, ASP.Net Enhancements, Maintenance and Troubleshooting (Exp 1yr) SQL Replication - Merge, Transaction and log shipping (Exp 10yr) SQL Server 2000 - 2014 - SSIS-SSRS - SSRS Server, DTS Package (Exp 12yr) MS-SQL/Create and support Tables, Indexes, Triggers, SP, Functions, Views (Exp 12yr) SQL Migration 2000-2005-2008 (R 2)-2010-2012-2014 (Exp 10yr) MS Project (10yr) DNS/DHCP (Exp 4yr) VMWare - Methodologies (Waterfall, Spiral, Modified Agile, SCRUM) (Exp 7 yr)

PROFESSIONAL EXPERIENCE:

Programmer Analyst/SQL Developer

Confidential, TX

Responsibilities:

• Performed new development, Troubleshooting, Enhancements and Maintenance for several large in-house program utilizing VB6, VB.Net 2010, ASP.Net 2010, SQL Server 2000, 2005, 2008 R2.
• Upgrade/Migrated SQL 2000 to SQL 2008 R2.
• Converted DTS packages into SSIS packages.
• Converted Crystal reports 11.0 into SSRS 2012 reports, Created SSRS server 2012 for proof of concept and presented it to management.
• Setup, Deployed TFS server.

Programmer Analyst/SQL Developer

Confidential, TX

Responsibilities:

• Performed Troubleshooting, Enhancements and Maintenance for large in-house program utilizing VB6, VB.Net 2010, ASP.Net 2010, SQL Server 2000, 2005, 2008 R2.
• Work as DBA assistant.

Programmer Analyst

Confidential, FL

Responsibilities:

• Performed many enhancements to in house programs (VB6/VB.Net and SQL) to perform ETL functions on all types of file formats (EDI, XLSX,CSV…).
• The data was then loaded through Stored Procedure into MS SQL Server. Created Crystal Report Server utilizing Transaction Replication to update Report Server database.
• Created many SQL Queries to pull data into MS Excel to be emailed out to managers.

Senior Engineer/Software Developer

Confidential, Charlotte

Responsibilities:

• Oversight of all internal and external infrastructures with responsibility for data storage (SAN) Networks, Phone System, SQL Data Bases which also included Merge
• Replication, Virtualization of Help Desk and DR (Disaster Recover), all maintenance (apply patches, Create Stored Procedures, Triggers, Indexes…)
• Migrate from 2000 to 2005 to 2008 and Virtualize all small SQL DB’s.
• Responsible for the management of Confidential Senior System Engineer and SQL DBA.
• Responsibilities also included creating Best Practices documents for developers and infrastructure. Managed IT Infrastructure budget.

Senior Developer

Confidential, Charlotte

Responsibilities:

• Responsibility for all phases of software design and development for developer of applications used for the front end web face to the client, all in house supporting application and data manipulation applications; excellent knowledge of system life cycle methodologies (SDLC);key role in IT department growth and development, including staff hiring and guidance; collaboration with clients on product specifications, problematic issues and user training; delivery of technical presentations; product development and management.
• Collaborated with 3rd party vendors, to achieve project completion in a timely manner.

Lead Software Developer/SQL DBA

Confidential, Charlotte

Responsibilities:

• Migrated Monitoring system from VB6 to VB.Net. The monitoring program allowed for customized (process, data and hardware) monitoring 24/7. Used C#, VB.Net, ADO.NetVisual Source Safe and SQL Server 2000.
• Migrated Data Entry program from Delphi to VB.Net. The VB.Net program allowed users to perform data entry and verification locally (no interruption) before committing to production server through process programs.
• Led Development team in design and development of a Secure Client Data Entry and Retrieval site. Used C#, VB.Net, ASP.Net, ADO.Net, VBScript, JavaScript, Visual Source Safe and LDAP/SQL Server 2000.
• Created process programs that would spawn new instances if the current program that was under a heavy load - VB.Net, ADO.Net, Visual Source Safe and SQL Server 2000.
• Designed a database to house Choicepoints proprietary Theft Data. This data was accessed through https real time from Kiosks and customized data entry web sites.
• Migrated many in house VB6 programs to VB.Net enhancing the functionality of each to access both the Production and Archive databases and Report Servers.
• Designed and created Archive database which was updated weekly through DTS packages allowing the production database to remain lean.
• After acquisition, Led Development team in finishing and enhancing a three year long Drug Testing project utilizing VB.Net, ASP.Net, ADO.Net, VBScript, JavaScript, Visual Source Safe and SQL Server 2000.
• Created replicated databases for Report Servers allowing for Quarterly and Yearly reports to run without affecting the production database.
• Completed a multitude of Client Specific enhancements utilizing VB, VB.Net, ADO.Net, ASP.Net, Visual Source Safe and SQL Server.

Senior Developer/SQL DBA

Confidential Charlotte

Responsibilities:

• Responsible for each phases of software design and development of applications used to perform background checks for banking, retail and airline clients; excellent knowledge of system life cycle methodologies (SDLC); key role in IT department growth and development, including collaboration with clients on product specifications, problematic issues and user training; delivery of technical sales presentations and product development.
• Created the Client setup program utilizing VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.
• This program was created to allow users to easily setup a client with customized products.
• This program also allowed users to customize EBI (Data Entry) Screens for each client.
• This program logged tracking information of changes that were made during client customized setup.
• All changes were verified and data accounted for with this program.
• Created a Monitoring program to monitor (Processes, FTP overload, Timing, Row counts…) 24/7.
• This program allowed for staging of on-call persons with flexible notification (email, text message…). Utilized VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.
• Created Data Entry program for in-house users.
• This program was created to allow screen customization per client without touching the code. Training to use this Data Entry program was cut in half because of data validation and correction help.
• Utilized Delphi and SQL Server 6.5.
• Created Teleform process programs customizable for each client.
• This program allowed users to just verify the information faxed in while business rules were applied in the background. This program made Data Entry very fast and accurate for clients using Teleforms.
• Utilized 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.
• Client asynchronous Data Entry and Retrieval program.
• Allowed clients to send and receive encrypted Background Investigation data.
• This program would also check for updates of (program version, table field changes, static table updates…..) and update clients site automatically.
• Each client could customize their screens and logos.
• Utilized VB 6, RDO/ADO, MS Access, Visual Source Safe and SQL Server 7.0.
• Created Utility program for internal users.
• This program gave the users the ability to make changes to fields in the DB accurately. Before this program was created, some super users would link a SQL table through Access and make changes. Many of these changes were incorrect, made to the wrong field or just not complete. This Utility program verified the data, updated associated fields and tracked all changes. This cut data update error by over 75%.
• Utilized VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.
• Created FTP Process programs customized for each client.
• Each FTP Process had business rules run in the background to allow direct and accurate Data Entry. This allowed for many file formats (Delimited file, XML file, Customized file….).
• Utilized VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.