Data Developer, Tsql, SQL, SQL Server, MS Access, C#, ADO.NET, XML Etc

Christopher Kraszewski

**** ******** **** **. #*** Brecksville, OH 44141 C: 440-***-****, ******************@*****.***

Profile

Advanced SQL query developer with mid-level to advanced .Net development skills in applications, reports, data conversion and mapping. Ascertained and satisfied many moderate to complex query, .Net automation and data conversion project requests.

Skills

SQL; SQL Server: TSQL, SProc, Views, Query Optimization, Functions, SSMS, Normalization(3NF);

Complex Datasets using TSQL; Data conversion, mapping & formatting, RDBMS Concepts; SSIS (Basic,) C#\VB.Net (WinForm & WPF with MVC), SDLC (Methodology), Linq, XML, SOAP, ADO.Net, ASP.Net, HTML, CSS, and JavaScript (Intermediate), Crystal Reports, MySQL (Query) SSRS in Visual Studio, Excel(Pivot Table, Line Chart, VLookUp), VBScript, MS Access, VBA, Power BI and DAX (Basic.)

Work Experience (Current and Recent)

Agents Choice Insurance Agency, 2008 – Present (SQL Developer/Analyst)

Developed many moderate to complex SQL queries using joins, correlation (sub-query,) unions, embedded and dynamic SQL, SProc, views, functions, pivot tables, data normalization, and SQL optimization. Developed many interactive apps or reports using .Net, Crystal, XML, SSRS, Excel and Access controls/tools. Queries, apps and reports enabled automation, data retrieval for analysis, or data conversion. Developed desktop apps with queries and AMS360 web service to automate several manually cumbersome tasks. Created a variety of test queries to verify consultant and vendor data. Worked with users to ascertain desired form/report interaction and output which was satisfied through a graduated release of apps or reports. Developed C# custom apps using Shoretel features and telephony data to help improve employee efficiency. Developed many other queries and custom VB.Net ETL type apps primarily for 3 areas: 1) reduction of employee data reentry: transformation and transfer of data to insurance carrier websites or in-house vendor apps via programmatically mapping & formatting insurance data to XML or AL3 Acord formats or reading such formats to insert data into databases or output to file; 2) transfer of data from legacy software into SQL Server; 3) Various managerial ad-hoc query requests. To support end users, wrote extensive technical documentation for custom applications.

Relevant Work Experience

Agents Choice Insurance Agency, 2004 – 2006 (Programmer/Analyst)

Developed .Net data conversion applications which converted csv file data to AL3 and XML Acord formats. Created/maintained MS Access database.

Character Builders 2002 -- 2004 (MS Access Developer)

Developed many queries and interactive forms/reports in MS Access using orders/sales data for accounting purposes.

The CSC Group 2000 -- 2002 (Programmer)

Developed and maintained Visual C++ EDI apps for hospital and/or health insurance data.

Developed Visual C++ DLLs for OCR software to enhance the software's verification of data extracted from scanned hospital or health insurance forms.

Platforms

Visual Studio 2019. SQL Server 2014/2017. MS Office 2019. Most reports and apps were developed for data involving property and casualty insurance and Shoretel VOIP phone system. Primary vendor platforms: Vertafore's AMS360 database system (SQL Server) and Shoretel VOIP system (MySQL). Extensively utilized AMS360 and Shoretel database design guide.

Education

BS Computer and Information Science Cleveland State University.

Strong emphasis on programming courses utilizing C, C++, Visual C++, Unix and Vi editor.

Contact this candidate