SUMMARY:

• Confidential is a talented Client Server/Web/ETL - BI/SQL Developer with over ten years of progressively responsible IT experience.
• Over 15 years’ experience with Visual Basic 5.0/6.0, three years experience with Visual C++ 5.0/6.0, six years experience with Visual Studio .NET (C# and VB.NET), ten years experience with Crystal Reports, Oracle, DB2, SQL Server, InstallShield, Full lifecycle program development and multi-platform experience (Novell / Windows NT, 2000, XP).
• Confidential brings with him a reputation for detail, quality of work, coaching and mentoring team members, and a commitment to customer support.
• In addition, he possesses excellent verbal, written and interpersonal skills.
• Throughout his consulting career, he has displayed and excellent track record of delivering high quality results on time and under budget.

TECHNICAL SKILLS:

Visual Basic .Net

Windows XP/2000 Pro

DotNetNuke

NDoc

NUnit

Oracle 8.0/8i/9i/10g/11g

C# (2005 / 2008 / 2010 )

Windows 2000 Server

Macromedia Dreamweaver MX Macromedia Fireworks MX

Access 2.0/95/97/2000/ XP/2007

ASP.NET

Windows 2003 Server

MS Office 97/2000/XP/2003/2007

SQL Server 6.0/6.5/7.x/ 2000/2005/2008

Visual Basic 6.0

Unix

MS Project

MySQL

Visual Basic 5.0

Windows XP Pro X64

SMS

Pervasive SQL

ODBC

Windows Vista(32/64)

FrontPage

DB2/UDB

ADO

Windows 7 (32/64)

Visio

AS400 DB2

HTML

Crystal Reports 6/8/8.5/9.0/XI

MSDE

Java/JavaScript

SQL Server Data Transformation Services

ASP

Infragistics .NET

C/C++/Visual C++

Ja-Intrinsyc.NET

TSQL

InstallShield / InstallAware

PL/SQL

Windows Installer Technology (MSI)

Apex True Grid

Sheridan Data Widgets

Sheridan Designer Widgets

SQL Server Analysis Services 2008

SQL Server Integration Services 2005/2008

SQL Server Reporting Services 2000/2005/2008 , QNXT

EXPERIENCE:

Programmer/Analyst / SQL DBA/ETL Developer

Confidential

Responsibilities:

• Designed custom SSIS transformation components to perform Data Profiling (Column, Domain Pattern, Column Pattern and Statistical Profiling) and Data Cleansing (Regular Expressions, Standardization, Address Verification, GeoCoding, Phone, Email and Name).
• Designed custom SSIS transformation components to perform Data Profiling (Column, Domain Pattern, Column Pattern and Statistical Profiling) and Data Cleansing (Regular Expressions, Standardization, Address Verification, GeoCoding, Phone, Email and Name) to be completely database driven.
• Designed custom web front end interface and database for Mortgage company. This interface included the ability to upload and process various types of files (flat files and Microsoft Excel) through SSIS, generate reports utilizing SSRS and cubes utilizing SSAS to facilitate reporting and understanding data trends. Additionally the client has the ability to correct invalid and single entry records through the web interface utilizing SSIS processes.
• Designed custom web interface and database for reporting on Microsoft ISA Server logging. This interface includes the ability to do custom reporting on the data through SSRS and SSAS, as well as importation and cleansing of the files utilizing SSIS.

Environment: Windows 2003 Server X64, Windows 2008/2008R2 Server X64, Windows XP Professional, Windows XP Professional X64, C# 2005 / 2008, Infragistics NetAdvantage 2009, Microsoft SQL Server 2000 / 2005 / 2008 , Microsoft Analysis / Reporting /Integration Service, APS Net 2.0 / 3.5, Iron Speed V6.2.

SQL Server / ETL Developer

Confidential

Responsibilities:

• Designed custom web front end interface and database for large Midwestern bank. This interface included the ability to upload and process various types of files (flat files and Microsoft Excel) through SSIS, generate reports utilizing SSRS and cubes utilizing SSAS to facilitate reporting and understanding data trends. Additionally the client has the ability to correct invalid and single entry records through the web interface utilizing SSIS processes.
• Designed and implemented SSIS ETL processes for customer and Human Resources data for large Midwestern bank. Processes included data validation, cleansing and address correction. Created custom components to help facilitate these processes.
• Designed and implemented SSIS ETL processes for importing data from flat file sources and exporting data to Netezza Data Warehousing appliance for large Midwestern bank.
• Designed custom SSIS Control Flow and Data Transformation components to perform Data Cleansing (Regular Expressions, Standardization, Address Verification, and Index Building) and Control Flows (Zip/UnZip, Variable Properties) to be completely database driven.

Environment: Windows 2008/2008R2 Server X64, Windows XP Professional, C# 2008, Infragistics NetAdvantage 2009, Microsoft SQL Server 2008, Microsoft Analysis / Reporting /Integration Service, APS Net 2.0 / 3.5, Iron Speed V6.2.

Web / ETL - BI Developer

Confidential

Responsibilities:

• Designed and implemented ASP.Net / Ajax web based CHPE application to manage all continuing medical education requirements for medical personnel per Canadian requirements. Application utilized Windows Active directory for security.
• Designed and implemented an ASP.Net / Ajax web based Continuing Medical Education Application approval application to manage all requested by outside vendors for accredited courses. Application utilized Windows Active directory for security.
• Designed custom ETL package for Confidential to facilitate cleansing and importation of data into Continuing Education application from multiple distinct external sources, utilizing SQL 2005 SSIS.
• Designed custom SSRS and Stimulsoft reports on SQL Server 2005 for various reporting functions within NOSM Continuing Medical Education Session Planner and Continuing Health and Professional Education Web Applications.

Environment: Windows 2003/2008 Server, IE / Firefox, C# 2005/2008, ASP.Net 2.0, Ajax, Microsoft SQL Server 2005/2008, Microsoft SQL Server Integration Service, BO Crystal Reports, Microsoft SQL Server Reporting Services, Infragistics .Net Advantage 2007.

ETL - BI Developer

Confidential

Responsibilities:

• Performed ETL work designing and implementing various interfaces and data conversions to facilitate converting Medicare information from legacy systems to SQL Server 2005. Utilized SSIS and TSQL.
• Designed and implemented a ASP.Net 2.0 web application to facilitate creation of test data for the testing of various SSIS interfaces by test team. The test data application was designed to run within SharePoint 2007 utilizing Active Directory for security authentication.
• Designed and implemented a training class for Confidential project personnel on performance tuning of SQL Server SSIS and its usages in the current project.

Environment: Windows 2003/2008 Server, Windows XP Professional,, C# 2005, VB.NET 2005, Microsoft SQL Server2005, Microsoft Integration / Reporting Services.

ETL - BI / Web Developer

Confidential

Responsibilities:

• Performed custom DTS to SSIS conversion for a manufacturing corporation. Original DTS components read data / executed batch files to extract data from AS400 servers and text files, and are used to populate importation tables in SQL 2005. From these tables, data is then cleansed and presented in proper format to import into the production SQL 2005 database.
• Designed custom SSIS transformation component to solve problem relating to the importation CSV files created on AS400 into SQL Server 2005.
• Developed training documentation for personnel on uses of custom and stock transformation components to show them the uses of the components in manipulating the raw data in SQL 2005 with SSIS and SSAS.
• Designed and implemented a Data Warehouse application to manage all Unix / Linux hardware, software, lease agreements and maintenance contracts for a large Milwaukee Corporation. Data Sources included Flat File data feeds, CSV and Tab Delimited Files as well as Microsoft Excel spreadsheets. These files were merged and manipulated through the use of SQL Server 2005 Integrations services and custom transformation components written by Confidential . Reporting for the Asset Management Warehouse was provided by utilizing SQL Server 2005 Reporting services, SQL Server 2005 Integration Services and SQL Server 2005 Analysis services, and displayed through a custom SharePoint 2003 portal, utilizing Active Directory for security.

Environment: Windows 2003 Server, Windows, C# 2005/VB.Net 2005, Microsoft SQL Server 2005, Microsoft SQL Server Integration Service, Microsoft SQL Server Analysis Services, Microsoft SQL Server Reporting Services, Share Point 2003, Infragistics .Net Advantage 2007.

Independent Developer

Confidential, Grand Forks, ND

Responsibilities:

• Designed custom ETL package for Confidential School of Medicine to facilitate cleansing and importation of data into Continuing Education application, utilizing SQL 2005 SSIS.
• Converted and extended existing Continuing Education application from VB.NET 2003 to VB.NET 2005.

Environment: Windows 2003 Server, Windows XP Professional, VB.NET 2005, Infragistics NetAdvantage 2005,, Microsoft SQL Server 2000/2005, Microsoft Access, Crystal Reports XI

ASP.NET / C# Developer

Confidential

Responsibilities:

• Developed analytical reporting portal for State of Missouri EHR Medicaid project based on ASP.NET 2.0 / C#, utilizing role-based security.
• Reporting portal utilized Office Web Components as a fat client and CellSet Grid as thin client.
• Designed custom https component, which integrates into ASP.NET allowing developer / web administrator to dynamically set switching between HTTP and HTTPS protocols for specific pages through the web.config file.

Environment: Windows 2003 Server, Windows XP Professional, Windows XP Professional X64, VB.Net 2005, Infragistics NetAdvantage 2005,, Microsoft Access, Microsoft SQL Server 2005, Microsoft Analysis / Integration Services, CellSet Grid, Office Web Components

BI / C# Developer

Confidential

Responsibilities:

• Responsible for enhancing eCartography application; adding support for additional databases (Oracle, IBM DB2, Sybase).
• Responsible for designing and development of Database Reporting / OLAP Reporting application utilizing Contour Cube and SQL Server Analysis Services (Winform based application).
• Responsible for development of MRM (Master Record Duplicate) application.
• Package automated creation of scripts to cleanse/standardized selected data.
• Scripts included macro generation as well as utilization of RegEx functions.
• Application utilized full functionality of Infragistics controls (UltraGrid, TreeviewExplorer Bar) in the UI layer (Winform based application).
• Responsible for creating of custom Data Transformation components and UI’s utilizing C# and Infragistics NetAdvantage and third party components (Melissa Data, BCC).
• Responsible for creation of installation packages for AMB Dataminer applications utilizing InstallShield 11.5.
• Responsible for design and development of Database / Platform independent database access object utilizing C# / Mono. Additionally wrapped component into a SSIS Custom Connection component.
• Responsible for development of eCartography SDK package as an add-in for Visual Studio 2005. Add-in allows programmers to automate develop applications utilizing eCartography data cleansing functions as well as developing SSIS packages wrapping different data parsing and cleansing operations into Custom Transformation components.

Environment: Windows 2003 Server, Windows XP Professional, Windows XP Professional X64, Visual Studio 2005, Infragistics NetAdvantage 2005, Component One, Contour Cube, Microsoft SQL Server 2005, Oracle 9i/10gR2, Sybase iAnywhere/ASE 15, DB2 UDB, Microsoft Analysis / Integration Services

Contract Developer

Confidential

Responsibilities:

• Responsible for maintaining and enhancing Sales Compensation system applications, as well as developing new applications for system based on VB.NET.
• Responsible for end user support for the Sales Compensation system, as well as the Team Web application.
• Responsible for running/analyzing/maintaining/enhancing monthly PL/SQL procedures relating to the Sales Compensation system.

Environment: Unix, Windows 2003 Server, Windows XP Professional

Development Tools: VB.NET, VB6, Toad, Component One.Net

Database: Microsoft SQL Server 2000, Oracle

Contract Developer

Confidential

Responsibilities:

• Responsible for helping develop C# ASCX pages to be incorporated in a Confidential Medicare/Medicaid application based on a DotNetNuke web portal.
• Additional responsibilities included mentoring junior .net programmers in ASP.NET and C#.
• Responsible for developing/maintaining a VB6 based billing application. This application utilized Visual Basic 6, SQL Server 2000 and Crystal Reports. Access to the application was provided by desktop and Windows Terminal Server Client Access.

Environment: Windows 2000 Advanced Server, Windows 2003 ServerWindows XP Professional

Development Tools: VB6

Database: Microsoft SQL Server 2000, Microsoft Access

Contract Developer

Confidential

Responsibilities:

• Assisted in developing programming standards for Visual Studio developers at Confidential, including development of common components, error handling and database access. Developed common components based on components, which were in personal library. This includes converting components/controls in C# to VB.NET.
• Worked as part of a team developing an ASP.NET application, which replaced a green screen application. Performed analysis of different development methods (direct access to AS400, web services and Java-.NET bridging software). Worked on testing performance and ease of development for these methods, as well as mentoring JAVA programmers in ASP.NET and VB.NET.
• Responsible for developing a Yard Management application from an existing Microsoft Access application. It allows users, based on their security level, to enter or update trailer/yard records, as well as reviewing various yard / trailer reports. All existing Microsoft Access queries were converted to SQL Server stored procedures to facilitate better performance. This application utilized Visual Basic .NET, ASP.NET, and custom controls converted from C# to VB.NET and is designed to work with existing Oracle, AS 400 DB2 and SQL Server databases.
• Created unattended processes applications (scheduled VB.NET Console applications) to sync AS400 data with the SQL Server. Initial scheduling application was written as a Windows Service with VB.NET and scheduling was performed through an ASP.NET web application, which used .NET Remoting to communication with the service through a singleton object. The scheduler would allow the processes to be scheduled on a recurring basis, a single instance or a custom basis. All jobs are monitored based on the CPU% and memory being used, and based on parameters setup at time job was initially scheduled, the job would be terminated if it exceeded the maximum CPU% or memory utilized.

Environment: Windows 2000 Advanced Server, IE 5.5/6.0, Windows XP Professional

Development Tools: ASP.Net, VB.NET, C#, Ja-Intrinsyc.NET

Database: Microsoft Access, Microsoft SQL Server 2000, IBM AS400 DB2, Oracle 9i