SUMMARY:

• 25 years of IT experience which includes over 20 years of experience in Development and Design experience with MS SQL Servers 2016, 2012, 2008, 2005, 2000 and 7.0 in Production, QA, and Development environments.
• 14 plus years of Web development using a variety of environments,
• 14 plus years in ASAP .NET environment.
• Extensive Knowledge of Ajax, HTML, XML, jQuery, JavaScript, and VB Script.
• 25 years of Client/Server development using a variety of environments.
• Extensive knowledge of C#, Visual Basic in .NET environment.
• Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
• Flexible and versatile to adapt to any new environment and work on multiple projects.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS and SSIS Packages, Integration using .NET Bulk Copy
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production. Microsoft Team Foundation Server (TFS), Visual Source Safe, TOAD
• Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS), SQL Server Integration Services (SSIS)
• Extensive knowledge of Relational Database Management Systems.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging stored procedures and triggers.
• Extensive knowledge in Data Modeling using ERWIN and TOAD tools and normalization of tables.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in working with Reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Access
• Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS:

Operating Systems: Microsoft Window NT, 2000, 2003, XP, Vista, Windows 7, Windows 10

Languages: C#, VB.NET, Visual Basic 3.0 - 6.0, C++, XML, T-SQL, JavaScript, VB Scripts, Pascal, COBOL

RDBMS: MS SQL Server 6.5 - 2016, Sybase 10, 11, 12, MS-Access, MYSQL

Front End: .NET, MS Visual Basic, Dreamweaver, Delphi

Internet Technologies: Ajax, ASP, ASP.NET, JavaScript, JQuery, VB Script, HTML, XHTML

Version Control Tools: Visual Source Safe, Microsoft Team Foundation Source Control

Other Tools: ERWIN & Toad Data Modeling, Crystal Reports, SQL Backup, Infragistics grids (client server and web)

Hardware: Microsoft Environment

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS, SSIS), Reporting (SSRS), Visio, Database Connectivity

Specialty: Trizetto Facets

WORK EXPERIENCE:

Confidential

Sr. Developer

Responsibilities:

• Senior Analyst/Developer
• Programming for maintenance/enhancement of 3rd party software (includes SQL Server work)
• C# and SQL Server development for new application.

Confidential - Mounds View, MN

Sr. Developer

Responsibilities:

• Senior Analyst/Developer
• Update existing Powerbuilder/SQL Anywhere MDI application to C# (2015-4.6.2)/SQL Server 2016
• Program built around C# object-oriented design features. Forms included MDI parent window, 10 MDI child forms, and 20 misc. support forms
• Additional enhancements included building of C# interactive (CSI) user interface.
• Extensive use of C# screen to screen drag and drop functionality.
• Backend database work involved modeling of additional tables and 60-70 stored procedures for action queries.
• Reporting using MS SQL Server Reporting Services (local) and Built-in C# classes for Excel.

Environment: Windows 10, MS SQL Server 2016, MS SQL Server SSRS Reporting Services, .NET 2015 (4.6.2), Microsoft Access, Tortoise Source Code Management

Confidential - Minneapolis, MN

Sr. Developer

Responsibilities:

• Senior Analyst - Corporate Treasury Systems
• Work with support staff in a variety of issues including maintenance and development of 10 .Net Client Server Windows Forms applications (C# and VB.Net)
• Worked with a variety of SQL Server issues including design of new tables, creation and enhancement of stored procedures (including testing), views, logins, users, and roles
• Extensive creation and enhancement of data migration using Microsoft SQL Server Integration Services (SSIS)
• Enhancement of existing reports using Microsoft SQL Server Reporting Services (SSRS)
• Maintenance of 5 Microsoft Access applications

Environment: Windows 7, Windows 10, MS SQL Server 2008 & 2012, .NET, .NET 3.5 - 4.7 environment (C# and VB.NET), Microsoft Access, TFS Source Code Management

Confidential - St. Paul, MN

Sr. Developer

Responsibilities:

• Worked with documentation of 9 C#/ASP.NET web applications in anticipation of major rewrites.
• Work included giving recommendations as to possible enhancements for the new applications

Environment: Windows 7, MS SQL Server 2008 & 2012, .NET, .NET 3.5 (C# and VB.NET), Microsoft Access 2010

Confidential - Bloomington, MN

.NET Developer

Responsibilities:

• C# support development for several existing biometric applications incorporated into .NET Client Server applications
• Development of custom Client Server software for analysis of user ids (Drivers licenses, Passport, etc)

Environment: Windows 7, .NET 2012, .NET 3.5 - 4.0 (C#), TOAD Source Code Management

Confidential - St Louis Park, MN

Developer

Responsibilities:

• Assigned to contract for coding and testing support of data center migration. The contract was originally scheduled for 12 month minimum.
• Contract afforded me the opportunity to acquaint myself with MVC pattern and Bootstrap.
• Due to budgetary issues, project and contract were cancelled.

Confidential - Minneapolis, MN

.NET Developer

Responsibilities:

• Redesign of client web application to manage credentialing of energy system operator, including maintenance of provider courses and operator transcripts. Application was developed in .NET 2010 C# 3.5 framework with asp.NET, Microsoft AJAX and JavaScript/JQuery with Microsoft SQL Server backend. Web application made extensive use of user control design technique. Clustered environment.
• Development of new software to manage marketing of energy across the Energy Grid.
• Enhancement and maintenance of current Energy Accounting System per customer needs (Client Server Windows application).
• Enhancement and maintenance of current Control Area Scheduling System (Client Server Windows application) per customer needs
• Custom reporting using Microsoft SSRS reporting and Crystal reports.
• ETL data transformations using Microsoft SSIS packages and SQ: jobs.

Environment: Windows XP, Windows 7, MS SQL Server 2008 & 2005, T-SQL, C#, Custom built frameworks. .NET 2010 with 3.5 environment

Confidential - Eau Claire, WI

.NET Programmer/Analyst, Web Development

Responsibilities:

• Design and development of various Client/Server and Web Applications for call center (property and auto glass).
• Work included several custom web interfaces (ASP.NET and C#. NET). All applications were designed using object-oriented design and incorporated a large variety of the C# classes, as well as JavaScript for web pages. Application work included database design (modeling, stored procedures, testing, Microsoft SQL Server). JavaScript and style sheets.
• Custom DTS & SSIS Packages and batch processes.
• Interface structures for client/server to Unisys mainframe.
• Design and Development of custom on-line customer billing application (C# .NET 2005, SQL Server 2000)
• Design and development of Ecommerce web site. Tools included C#, ASP.NET and Microsoft SQL Server. Extensive use of JavaScript and style sheets.
• Conversion of Applications .NET 2003 to .NET 2005
• Currently updating applications to .NET 2008

Environment: Windows XP, MS SQL Server 2008 & 2005, C#, ASP.NET.

Confidential, Virginia Beach, VA

Developer/Consultant

Responsibilities:

• Conversion of Microsoft Access database to SQL server stored procedures and database. DTS packages uses to extract data from a variety of sources.
• Process to merge data from a variety of sources (SQL, Oracle, Excel) into a single user SQL Server database using a combination of DTS packages and stored procedures
• Performance tuning for existing stored procedures.

Environment: MS SQL Server 2005, Windows XP.

Confidential - New Berlin, WI

Developer/Consultant

Responsibilities:

• Microsoft SQL Server Development to enhance existing Property and Casualty insurance program (web app C#).
• Task involved the addition of new stored procedures as well as changes to existing procedures to move from single user to multi-user environment. In addition, many other enhancements were added to the program, requiring updated or new stored procedures.

Environment: MS SQL Server 2005, .NET 2005

Confidential - Washington DC

Developer/Consultant

Responsibilities:

• Telecommuting position - design and implementation of custom Web application using EZPublish web content management system. (Partial overlap with M&S/B Project). PHP and MYSQL database.

Environment: Windows, SQL Server 2005.

Confidential - Sparta, WI

Developer/Consultant

• Development of specialized database for incoming Army Reserve and National Guard Units.
• Process required design and development of SQL Server database with approximately 50 tables and 70 stored procedures.
• Design and implementation of Web interface, using ASP pages, with extensive use of VB Scripting and Dynamic HTML.
• Reporting capabilities were included.

Environment: SQL Server 2000, Visual Basic.

Confidential, Denver, CO

Consultant (telecommute)

Responsibilities:

• Telecommuting position - Access development. Position required updates to existing Microsoft Access program, including enhancements to existing screens and reports, as well as development of new screens and reports.
• Position required additional work done on the back-end Access database including additional fields and new tables

Environment: Windows, Access.

Confidential - Portland OR

Developer/Consultant (telecommute)

Responsibilities:

• Development of SQL Server backend stored procedures to service Crystal reports Facets reporting data warehouse.
• Project involved mainframe conversion to Facets Client-Server involving approximately 120 reports and stored procedures.
• Work was performed completely telecommute via a VPN connection (Virtual Private Network) to the client-site.
• Creation of user-defined data types and functions. Stored procedure tuning (speed & indexing) was the responsibility of the programmers.

Confidential - Overland Park, KS

Consultant/DBA

Responsibilities:

• Design and development of custom database, including specifications and data modeling, SQL Server 2000, along with VB 6.0 front-end for access and edit of data. Database comprised of 160+ tables and 200+ stored procedures, and user-defined functions. Worked also included design of reports (VB Print object and Microsoft Access) and custom letters (Microsoft Word and Access). As the sole programmer on-site, work also included DBA role, including stored procedure tuning, table indexing, triggers, database backups, DTS and Job Scheduling packages
• Custom applications to gather information from United States Patent Office web site, in order to develop company database for marketing.

Environment: SQL Server 2000, Windows.

Confidential - Kansas City MO

Consultant/Programmer

Responsibilities:

• Development of additional batch processes to work done in prior consulting role at the company. Additions included the auto loading of benefit and provider rows to Facets proprietary database. Process included the full analysis, table design and data modeling (indexes, foreign key and triggers), development, all stored procedures, as well as enhancement of previous Visual Basic front-end application to handle maintenance of the auto loads. Work required extensive knowledge of both the benefit and provider subsystems within facets. Work included the communication with front-end users
• Worked with internal employees in a consulting role relative to issues on stored procedure implementation (query analysis, writing, and tuning for performance).

Environment: SQL Server 2000, Visual Basic 6.0.

Confidential - Leavenworth KS

SQL Developer/Consultant

Responsibilities:

• Backend database work in Microsoft SQL Server 7.0 to support Multi-Tier, OOP Visual Basic application used in conjunction with larger system-wide application. Work involved design of relational database, including approximately 150 tables, user-defined data types and functions, using Erwin database modeler, coding of 200+ stored procedures, including several batch processes to handle conversion of information from file to database tables. Project also included automated processes, using SQL Server Job Scheduler, through system-stored procedures. Process included extensive work with company DBA.

Environment: SQL Server 7.0, Visual Basic.

Confidential - Overland Park, KS

Developer/Consultant

Responsibilities:

• The conversion of Microsoft Access databases into a single SQL server 2000 database. Redesigned Access databases as interim step. Process involved development of database tables to handle a variety of topic matter covering 60+ magazines, in addition to a Visual Basic front end for data access/ input, and all stored procedures for data access and update. Program used ADO data access and stored procedures exclusively for access to the database (20 screens).

Environment: SQL Server 2000, Visual Basic, Access.

Confidential - Kansas City, MO

Developer/Consultant

Responsibilities:

• The Design and development of Visual Basic application to handle a variety of inquiries for Automobile insurance company, against NT SQL Server database. Process included design and development of VB front-end application, using ADO data access, and extensive use of Microsoft flex-grid control, and writing of all stored procedures against existing database. Process included some refinement to back-end database to support front-end application,
• Design and Development of a variety of Company reports using both Crystal Reports and Visual Basic Print object. Work involved conversion of data and front end application from Fox Pro program.

Environment: SQL Server 2000, Visual Basic.

Confidential - Kansas City MO

Consultant/Programmer

Responsibilities:

• Design and development of broker commission batch process to replace Legacy system program. Extensive work on developing data model in conjunction with data analyst and DBA. Process included the addition of 30+ tables and stored procedures to handle the batch processes.
• Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end.
• Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end. Life Cycle (design, development, and implementation) Visual Basic program to allow broker and provider access to database information. (Group, claim, membership, and provider) used with Citrix remote access. Visual Basic 6.0, ADO data access, TrueGrid data control (18 screens). Design of back-end database structures. Sybase stored procedures used in conjunction with Internet access.
• Sybase stored procedures used with system-wide phone inquiry system.
• Developed stored procedures used with company batch processes, including commission, customer explanation of benefits, provider remits reports, provider capitation, claims, subscribers and membership, membership benefit, product plan, customer service, and utilization management for Facets proprietary database. Process required modeling of new database (tables, indexes, foreign keys, triggers etc.)
• Designed and developed, in conjunction with Business analysts, DBAs, and end-users, custom batch processes to auto load benefit and provider rows to Facets database. Process included the design and development of new database, database tables and stored procedures, as well as Visual Basic front-end application to handle maintenance of the auto loads. Task included 5 provider batches (network, out-of network, and covering provider, provider groups, and capitation) and 4 benefit batches (products, limits, variable components, and service prefixes)..
• Work with internal employees in a consulting role relative to issues on stored procedure (query analysis, writing, and tuning for performance).
• The contract allowed for extensive use of tables across a variety of Facets subsystems, including the XP database, claims, customer service, finance, commission, benefit, providers, subscribers, and members.

Environment: SQL Server 7.0, 2000, Visual Basic 6.0.