This document provides an experience and skills summary for George R. Lewycky. It lists his proficiency with SQL Server Management Studio and related products. As a key project, it describes George's work from 2008 to present replacing a customized Filemaker database for a customer service claim processing system with a new intranet and internet application built using Visual Studio 2008, ASP.NET, and a SQL Server 2008 backend. The project involved requirements gathering, interfaces, third party product research, mainframe data integration, complex SQL, data conversion and documentation.
1 of 1
Download to read offline
More Related Content
Lewycky_SQL Server Skills and Experience
1. 1
1
Experience and Skills inventory ofExperience and Skills inventory ofExperience and Skills inventory ofExperience and Skills inventory of George R. LewyckyGeorge R. LewyckyGeorge R. LewyckyGeorge R. Lewycky
http://georgenet.net/resumehttp://georgenet.net/resumehttp://georgenet.net/resumehttp://georgenet.net/resume
SQL Server Management StudioSQL Server Management StudioSQL Server Management StudioSQL Server Management Studio SuiteSuiteSuiteSuite and related productsand related productsand related productsand related products
Configuration/RDMS SQL Server 2008 R2
Interfaces XML, sFTP, External interfaces & feeds from IBM mainframe
Tools SQL Server Management Studio
Third Party Apex SQL Log,
Redgate SQL Log Rescue,
Filemaker 5 (Windows),
QAS
Miscellaneous CTE (Common Table Expressions),
SourceSave
Programming
Languages
SQL,
Transaction-SQL (T-SQL)
Visual Studio 2008
Customer Service’s Claim Processing System 2008-present:
September 2008 to present
Replaced a customized Filemaker database/application, being used as a customer service tool for processing
customer claims into a intranet and internet application.
Environment used Visual Studio 2008 and ASP.NET with SQL Server 2008 R2 backend in order to
expedite customer claims in a diverse customized and complex customer claim processing system.
Involvement ranged from requirements gathering, work and data flow, bullding interfaces interfaces.
Third party product research, testing and review for address standardization to transaction logging.
Developed console applications to interface data between IBM mainframe and SQL Server for database feeds and
requests.
Complex SQL queries, views, data conversion and normalization and documentation.
Software: ASP, Visual Studio 2008, Filemaker 5.0 (Windows), Excel (macros & templates), XML,
SourceSafe
DBMS: SQL Server 2008, Transact-SQL (stored procedures), CTE (Common Table Expressions)
Platform & Server: SQL Server 2008, Microsoft SQL Server Management Studio