SUMMARY:

• Strong data development with SQL Server (T - SQL, SSIS and SSRS) and MS Access (VBA)
• Experience with TFS
• .Net full stack programming experience with VB.Net, C# and SQL-Server
• Worked in an Agile Development environment including sprints

OBJECTIVE:

To obtain a SQL Server developer position.

SKILLS:

Languages: Visual Basic .NET 2003, 2005 & 2010, C# 2012 & 2015, ASP .NET 2003, 2005 & 2010, Visual Basic for Applications (VBA), T-SQL, Visual Basic, Visual FoxPro, C, Pascal, Basic, Magic, HTML

Operating Systems: Windows, UNIX, Novell, AIX, MS DOS, OS/2

Databases: SQL Server 2000, 2005, 2008 & 2012, Access, FoxPro, Paradox

Other Tools: Visual Studio, Winforms, SharePoint, Visual Source Safe, Crystal Reports, Excel, Integrated Services (SSIS), ETL, Reporting Services (SSRS), Agile Methodology, Windows Presentation Foundation, Silverlight, TFS, DevExpress

EXPERIENCE:

Confidential

Professional Consultant - Developer

Responsibilities:

• Updated Excel VBA code to organize key performance indicators for graphs used by managers before and during their most successful outage in more than three decades.
• Created an Access and SQL Server security application for plant users to schedule deliveries and visitors, including Access reports and exporting to Excel.
• Rewrote Work Order Tracking System (C# and ASP.NET) to use new data source (SQL Server).
• Created an Access and SQL Server security shift operation log application for the Security team.

Skill set utilized: Visual Studio 2015, C#, ASP.NET, SQL Server 2008, T-SQL, Access 2010, Excel 2010, SharePoint 2007 & 2013

Confidential

Professional Consultant - Developer

Responsibilities:

• Created numerous TSQL scripts to insert and update SQL Server tables.
• Added and changed code in an ASP.NET, VB.NET and SQL Server application.
• Assisted another developer during sprints.

Skill set utilized: Visual Studio 2010, ASP.NET, VB.NET, SQL Server 2012, T-SQL, Agile Methodology, TFS

Confidential

Professional Consultant - Programmer Analyst

Responsibilities:

• Fixed and enhanced forms and code and optimized reports.
• Added new functionality for creating package items (cheese burger basket, birthday party) in a Winforms, Silverlight, VB.NET and SQL Server application.

Skill set utilized: Visual Studio 2010 & 2012, VB.NET, SQL Server 2008, T-SQL, Windows Presentation Foundation, Silverlight 5 Toolkit December 2011, Crystal Reports 2012

Confidential

Programmer Analyst

Responsibilities:

• Migrated two Access participant directed health care services (PDS) payroll programs to C# and SQL Server.
• Exported calculated payroll data to a formatted Excel file for the CFO.
• In charge of running two PDS programs payroll programs weekly and troubleshooting inconsistencies.

Skill set utilized: Visual Studio 2012, C#, SQL Server 2008, T-SQL, Access and Excel

Confidential

Professional Consultant - SQL Server Developer

Responsibilities:

• Updated tables using T-SQL and imported Excel and text files.
• Created and enhanced stored procedures and Crystal Reports.

Skill set utilized: SQL Server 2008, T-SQL, Crystal Reports 2005

Confidential

Professional Consultant - Programmer Analyst

Responsibilities:

• Created tables, stored procedures, reports, forms, code and classes to enhance and support a rate calculation and processing VB.NET GUI Windows application used to track and publish interest rates for use throughout the bank’s daily operation.
• Created eight interest rate reports (simple to complex) using SSRS to be run from the VB.NET application.
• Created stored procedures to get data for reports and forms for the VB.NET GUI Windows application.
• Worked with T-SQL to query tables and to create SQL scripts to update tables via stored procedures on a daily basis.
• Used advanced T-SQL programming techniques to work with data in a large, highly normalized database.

Skill set utilized: VB.NET 2010, SQL Server 2008, T-SQL, Visual Studio 2010 & 2012, SSRS, Windows 7, Visual Source Safe

Confidential

Professional Consultant - Programmer Analyst

Responsibilities:

• Enhanced and fixed ASP.NET and VB.NET Web programs.
• Created and maintained tables and stored procedures for Web programs.

Skill set utilized: VB.NET 2010, ASP .NET 2010, SQL Server 2008, T-SQL, Visual Studio 2010 & 2012, Agile Methodology, DevExpress, HTML, Windows 7, Visual Source Safe

Confidential

Programmer Analyst

Responsibilities:

• Enhanced and fixed DOS and Visual FoxPro programs.
• Migrated FoxPro applications to new VB .NET GUI Windows applications, SQL-Server, Integrated Services and Crystal Reports.
• Created and maintained more than 50 Crystal Reports and VB.NET code to supply data for the reports.
• Created new forms in a VB.NET GUI Windows application and code to import data from different file types, manipulate the data and save it to SQL-Server tables.
• Enhanced and maintained numerous individual and team VB.NET GUI Windows applications, SQL-Server, SSIS, ETL and Crystal Reports projects.
• Responsible for daily mainframe data download process to FoxPro tables and reports.

Skill set utilized: VB.NET 2003, 2005 & 2010, SQL Server 2000, 2005 & 2008, T-SQL, Visual Studio 2010 & 2012, Visual FoxPro 6.0, DOS FoxPro, Windows XP, SSIS, ETL, Crystal Reports, Visual Source Safe

Confidential

Professional Consultant

Responsibilities:

• Relinked tables in multiple Access databases to SQL Server databases, saving client money.
• Assisted in converting a Visual Basic 6 application to a VB.NET 2005 GUI Windows application.
• Created screens that worked with a data access layer to manipulate the data between the application and the SQL 2005 database.
• Assisted in researching, designing, developing, testing and documenting a dynamic, multi-lingual web application using VB.NET 2005 with SQL 2000.
• Enhanced and fixed SCS intranet programs written in ASP.NET, VB.NET, HTML and SQL Server.

Skill set utilized: VB.NET 2003 & 2005, ASP .NET 2003 & 2005, SQL Server 2000 & 2005, T-SQL, Visual Studio, Access 2003, Visual Basic 6.0, HTML, Windows XP

Confidential

Professional Consultant - Programmer Analyst

Responsibilities:

• Converted Excel applications to Access Windows applications allowing users to enter and manipulate data via GUI forms and export the data to three different formatted Excel spreadsheet billing invoices using VBA.
• Designed and developed an Access Windows application to import text files, process and format the different services and dynamically create a phone bill in Excel for more than 240 clients. Reduced time by more than 90% and increased accuracy.

Skill set utilized: Access 2003, VBA, SQL, Excel 2003, Windows XP

Confidential

Programmer Analyst

Responsibilities:

• Analyzed, documented, enhanced and fixed multiple databases to institute several incentive plans, reduced time and effort of the user and exported 30 plans into Excel.

Skill set utilized: Access 2003, VBA, T-SQL, Excel 2003, Windows XP

Confidential

Programmer Analyst

Responsibilities:

• Developed a database that combined more than 2.5 million records of financial information.
• Automated database and query processes for multiple cash recovery projects.

Skill set utilized: Access 2002, VBA, T-SQL, Excel 2002, Windows XP

Confidential

Programmer Analyst

Responsibilities:

• Developed, enhanced and fixed more than 100 Access reports using queries and VBA for internal and external clients in our eight reporting Windows application databases.
• Proactively worked with the claims manager to adjust fees on a report for all clients, which collected thousands of dollars of claims fees immediately.
• Was department’s main trouble shooter for report problems and contributor to the end of month (EOM) process. Organized the running, validating, fixing and explaining EOM reports in our testing and production periods. Documented the EOM process.

Skill set utilized: Access 97, VBA, T-SQL, Excel 97, Visual Source Safe, Windows 2000

Confidential

Professional Consultant

Responsibilities:

• Developed a GUI Windows application for the IS department to give employees rights to database programs and for the employees to select from a list of database programs to run.
• Developed several GUI Windows applications for managers to view and manipulate data from various sources and enhanced existing EDI Inbound and Outbound processes.

Skill set utilized: Visual Basic 6.0, T-SQL, Access 7.0, Windows 98

Confidential

Professional Consultant

Responsibilities:

• Developed several GUI Windows applications for the sales reps to use out in the field.
• Developed several GUI Windows applications for internal staff including a program to schedule national sales meetings and a program to calculate and graph 401K and stock investments for the sales reps.
• Developed a program to generate reports on manager and restaurant data on three levels.
• Developed two programs to allow restaurant managers to schedule workers.

Skill set utilized: Visual Basic 4.0, T-SQL, Access 2.0, Crystal Reports 5.0, Magic, Windows 95