際際滷

際際滷Share a Scribd company logo

Lewycky_SQLServerASPDOTNETVisualStudioJava

G
grlewycky

George Lewycky has experience with SQL Server 2008 R2 and 2010, ASP.NET, Visual Studio, Java, JavaScript, and related technologies. He has worked on projects involving customer service claim processing systems using these tools. His responsibilities have included requirements gathering, interface development, third party integration, complex queries, stored procedures, scheduling jobs, custom scripts, and reporting. He has skills in T-SQL, VB.NET, Java, JavaScript, JSON, JQuery, and SQL Server Integration Services.

1 of 2
Download to read offline
1 1 Experience and Skills inventory of George R. Lewycky http://georgenet.net/resume SQL Server, ASP .NET, Visual Studio, Java, Javascript & related products Configuration/ RDMS SQL Server 2008 R2 SQL Server 2010 Interfaces XML (eXtensible Markup Language) sFTP, External interfaces & feeds to/from IBM mainframe and AS/400 Tools SQL Server Management Studio (SSMS) Visual Source Save (VSS) Java / AJAX Technologies Javascript AJAX (Asynchronous JavaScript and XML ) JQuery jquery-ui-1.10.4.custom JSON (JavaScript Object Notation) JDBC Third Party Products & Vendors Apex SQL Log Redgate SQL Log Rescue Fiddler Miscellaneous CTE (Common Table Expressions) & Temp tables Automation: Scheduling jobs Custom scripts (sqlcmd , ftp, file processing, Excel templates, COMSPEC ) Custom & Complex reports / Stored Procedures Xp_cmdshell Reporting Services / Business Intelligence (BI) SQL Server Reporting Services (SSRS) 2008 SQL Server Integration Services (SSIS) Programming Languages SQL Transaction-SQL (T-SQL / Stored Procedures ) Visual Studio 2008, 2010 Visual Basic ( .net 3.0 4.0 )
2 2 PROJECTS: Customer Services 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 dual 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, building interfaces. Third party product research, testing and review for address standardization to transaction logging. Developed and modified: console applications to interface data between IBM mainframe and SQL Server for database feeds and requests together with T-SQL, sFTP, Complex SQL queries and Stored Procedures (T-SQL), views, data conversions and normalization and documentation. Software: ASP 3.0, 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 Development, Maintenance, Troubleshooting (Debugging) and Modifications for: Java: preventing end-user from scheduling events on employees birthday VB Console App: for troubleshooting rare scheduling mishap using StreamWriter to append to text file logging activity and errors T-SQL: Stored Procedure to generate mass email notifications in HTML format using sp_send_cdosysmail along with images, links Secure FTP between IBM mainframe, s-FTP server and SQL Server for daily scheduled jobs to request, receive and process data requested. With email notifications and checks and balances for tracking and troubleshooting. Javascript: using tooltip to mouse over gridview of csv file to pre-analyze and report errors before upload Javascript: utilized autocomplete, autotab, keydown together with AJAX/Json to mimic legacy application keystroke procedure in converted ASP DOT NET application Legacy Applications Maintenance, Development and support and converting to ASP.NET

More Related Content

Lewycky_SQLServerASPDOTNETVisualStudioJava

  • 1. 1 1 Experience and Skills inventory of George R. Lewycky http://georgenet.net/resume SQL Server, ASP .NET, Visual Studio, Java, Javascript & related products Configuration/ RDMS SQL Server 2008 R2 SQL Server 2010 Interfaces XML (eXtensible Markup Language) sFTP, External interfaces & feeds to/from IBM mainframe and AS/400 Tools SQL Server Management Studio (SSMS) Visual Source Save (VSS) Java / AJAX Technologies Javascript AJAX (Asynchronous JavaScript and XML ) JQuery jquery-ui-1.10.4.custom JSON (JavaScript Object Notation) JDBC Third Party Products & Vendors Apex SQL Log Redgate SQL Log Rescue Fiddler Miscellaneous CTE (Common Table Expressions) & Temp tables Automation: Scheduling jobs Custom scripts (sqlcmd , ftp, file processing, Excel templates, COMSPEC ) Custom & Complex reports / Stored Procedures Xp_cmdshell Reporting Services / Business Intelligence (BI) SQL Server Reporting Services (SSRS) 2008 SQL Server Integration Services (SSIS) Programming Languages SQL Transaction-SQL (T-SQL / Stored Procedures ) Visual Studio 2008, 2010 Visual Basic ( .net 3.0 4.0 )
  • 2. 2 2 PROJECTS: Customer Services 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 dual 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, building interfaces. Third party product research, testing and review for address standardization to transaction logging. Developed and modified: console applications to interface data between IBM mainframe and SQL Server for database feeds and requests together with T-SQL, sFTP, Complex SQL queries and Stored Procedures (T-SQL), views, data conversions and normalization and documentation. Software: ASP 3.0, 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 Development, Maintenance, Troubleshooting (Debugging) and Modifications for: Java: preventing end-user from scheduling events on employees birthday VB Console App: for troubleshooting rare scheduling mishap using StreamWriter to append to text file logging activity and errors T-SQL: Stored Procedure to generate mass email notifications in HTML format using sp_send_cdosysmail along with images, links Secure FTP between IBM mainframe, s-FTP server and SQL Server for daily scheduled jobs to request, receive and process data requested. With email notifications and checks and balances for tracking and troubleshooting. Javascript: using tooltip to mouse over gridview of csv file to pre-analyze and report errors before upload Javascript: utilized autocomplete, autotab, keydown together with AJAX/Json to mimic legacy application keystroke procedure in converted ASP DOT NET application Legacy Applications Maintenance, Development and support and converting to ASP.NET