TECHNICAL SKILLS

• C#.NET
• WPF
• XAML
• WCF
• ADO.NET
• XML
• XSD
• XSLT
• XPath
• ASP
• ASP.NET
• .NET 1.1 - 4.5
• Visual Basic 3-6
• VB.Net
• COM
• COM+
• ActiveX and WIN32 API
• ADO.
• C++
• MFC
• ATL
• Transact SQL Stored Procedures
• Triggers
• User Defined Functions
• & Cursors
• Oracle PL-SQL
• Packages
• Stored Procedure
• Functions
• Triggers.
• MS SQL Extended Stored Procedures in C++.
• C++
• ATL
• COM
• MFC.
• MS SQL Server 6.5 - 2012
• DTS
• SSIS
• SSRS
• Oracle 8 - 12C
• Sybase SQL 12.5 & 15
• Sybase IQ
• SQL Anywhere 5.5
• MS SharePoint 2003.
• MS Access version 1.0 through 2010
• Visual Studio 5.0 through 2012
• Lotus Notes 4.6
• Evoware 2.2 for Tecan Liquid Handling Robots.
• ASTM E1381 Laboratory Information Systems.
• EPL & ZPL Programming for Bar Code Printers.
• HTML
• CSS
• ASP
• VB Script
• Javascript
• Jquery
• Infragistics NetAdvantage Developer Tools.
• Timberline Estimating.
• Cold Fusion and Silverstream.
• Crystal Reports 6.0 - 10.0
• Dos 6.22
• Windows 95/98
• Windows NT/2000/2003/XP
• Novell 3.12 & 4.1
• AutoCAD 2000
• WordPerfect 5.1
• WordPerfect 6.0
• MS Office Pro 4.3 - 2002.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer / Analyst

Responsibilities:

• Work on Meter Data Collection System using TCP/IP communication protocols and C#.Net in a Windows Service
• Developed a C# .Net framework designed for quickly creating WCF Services, Windows Services, Logging, Configuration, Conversions and Data Access that incorporates best practice patterns for Dependency Injection, Inversion of Control, Factory and Facade.
• Performed System Analysis of Application Architecture for performance issues and made recommendations for performance Improvements.
• Designed and programmed a new System Architecture for high performance data collection system.
• Designed a Bulk Data loading Framework for High Performance data processing in a real time data collection environment.
• Migrated all projects from Visual Studio 2008 to 2015.
• Migrated all projects from .Net 3.5 to 4.5 Framework.
• Migrated multiple projects from VB6 or VB.NET to C#.NET.
• Setup and Created SSRS Reports in SQL Server 2012 for use from Multiple Application Sites.

Confidential

Programmer / Analyst

Responsibilities:

• Updated Prediction Engine COM DLL written in C++ ATL to use new functions and create new versions to run in parallel.
• Redesigned a Prediction Test Tool using C# .Net 4.5 and COM interop to a COM prediction engine using factory pattern for perdition versioning.
• Application migration of Vista from a 32bit to 64 bit application written in C++ C#, ATL COM, and MFC as well as converting from .Net 2.0 to 4.5
• Designed and developed a Web Cam Capture application in C# .Net 4.5, Managed C++ using DirectX 11
• Designed and developed a new Picture Control in MFC to display bitmaps in MFC applications and support C# COM interop.
• Updated MFC OCX Controls with new picture control.
• Developed COM Interop COM Callable Wrapper for new C# dialog boxes
• Developed COM Interop Runtime Callable Wrappers for prediction engine.
• Designed and developed a configurable modular diagnostic utility using C#, SOA and .NET Remoting, custom configurations, and C++ ATL COM.
• Worked on DataAccessService SOA system using .NET Remoting.
• Migrated all projects from Visual Studio 2008 to 2012
• Work on Notification system using TCP/IP communication.
• SSIS packages to archive data between Oracle and SQL Server.
• SSRS Reports
• Updated Blood Bank System Interface to use new notification system which uses various CSV files for data transfer.

Confidential

Programmer / Analyst

Responsibilities:

• WPF (XAML) Application for editing cytogenetic fragments. WPF Application for a biochemistry calculator front end connected to a WCF web service hosted in IIS.
• Modified Portal Service Using WCF for Biochemistry Lab Systems and other Automated Windows Services.
• Worked on Team project and modified new application in WPF C# for Biochemistry Lab for tube tracking, run creation and instrument reading.
• Developed Data layer in C# to interface with Oracle backend database.
• Developed multiple reports using SSRS for Biochemistry Reporting.
• Developed multiple SSIS packages for Biochemistry & Reporting monitoring services.
• Modified Assays on Tecan Liquid Handling Robot using Evoware for the automation of the Tay Sachs Assay.
• Developed LIS Host Software using C# and ASTM Serial Communication to interface to DPC Immulite 2000, 2500, Versacell & DXI Immunoassay System medical instruments.
• Modified Bar Coding software using C#, EPL and ZPL for multiple bar-coding symbologies.
• Designed and Developed Emulation software to emulate DPC Immulite 2000, 2500, Versacell & DXI Immunoassay System medical instruments.
• New Applications developed using Oracle 10 PL-SQL packages, stored procedures, functions and triggers.
• Worked on Team projects writing back end database procedures in Oracle PL-SQL
• Provide guidance and mentoring in writing PL-SQL query and procedures in the area of design and performance.
• Support for Legacy Applications in VB3, VB6 for Accessioning, Lab and Biochemistry applications.

Confidential

Programmer / Analyst

Responsibilities:

• Developed Web Applications for Information Security Compliance using ASP.NET, C#, MS SQL, and SSIS. Web Application allows for importing Excel files, searching records, browsing records, editing, side by side comparing of records, and merging of records.
• Wrote Stored Procedures for standard transactional operations as well as for Data Cleansing and comparing records against the master list.
• Used SSIS for importing Multiple Excel Files and text files each of which had different layouts.
• Used SSIS for writing a 1 way replication between a SQL database to MS Access for the Travel Database.
• Developed XML & XSD templates for exporting data from Legacy system and importing it into SQL Server using SSIS.
• POC project converting AREV to SQL via XML,XSD. Imported AREV exported date into SQL

Confidential

Programmer / Analyst

Responsibilities:

• Created and designed ETL processes in Sybase SQL stored procedures to transform data from staging database to a data warehouse in Sybase IQ
• Setup adhoc reporting by creating data reporting models in SSRS using Sybase ASE and Sybase IQ as the backend. This is an exceedingly tricky setup.
• Created User Reports in SQL 2005 Reporting Services using Sybase data as the backend.
• Wrote complex optimized queries in Sybase IQ for use in SSRS reports.
• Data Analysis and research. Create statistical reports in Excel and advance calculations using MS Access and VBA.
• Gathered data from multiple sources including Ominture and Data Warehouse and compiled reports using MS Access, VBA Excel and CSV.

Confidential

Programmer / Analyst

Responsibilities:

• Designed Web based tools using ASP.NET C# and IIS for working with Microsoft Sharepoint Data, in order to import into SQL Server 2005.
• Transformed XML Sharepoint data using XSLT, XPath & XSD and imported the new data into SQL Server 2005.
• Created SSIS Packages for transfer of data from SharePoint & Oracle 8i & 9i Data Warehouse to SQL Server 2005.
• Created User Reports in SQL 2005 Reporting Services.

Confidential

Programmer / Analyst

Responsibilities:

• Redesigned n-tiered C# application for the construction business.
• Added on functionality to existing C# / SQL applications, used third party controls from Infragistics.
• Wrote new stored procedures and rewrote existing procedures for better optimization.
• Web Interface for scheduling using C# and ASP.NET.
• Designed and coded import procedures for third party estimating tool, Timberline Estimating.
• Established development processes to assist the IT department in documenting the clients needs.

Confidential

Programmer / Analyst

Responsibilities:

• Project Manager on 2 major projects to reengineer legacy applications and to migrate data to SQL Server.
• Business Solution Analyst, interfaced with clients to gathered requirements, document detailed requirements, build and document detailed design plan.
• SQL Server Administrator, setup and installed SQL Server 2000, administered and maintained servers, setup emergency recovery plans, created backup schedules, performance tuning, other administrative tasks.
• Assisted network administrator with NT Domain server, Windows 2000 & 2003 administration, and other network administration tasks such as security.
• Created and documented database design for a normalized transaction database for 2 major databases.
• Created a detailed design plan and object model for 2 applications.
• Web based interface for customer incident logging using web forms and ASP.NET
• Coded and tested applications according to the detailed design plans using Visual Studio and C#.NET as well as stored procedures, user defined functions, view, and triggers in SQL.
• Deployed and supported applications and preformed bug fixes as needed.
• Migrate existing MS Access & Fox Pro Applications and Databases to C#.NET & SQL 2000.
• Migrated Data from legacy databases using DTS, static and dynamically linked servers, and SQL stored procedures.
• Created Synchronization routines to maintain backward compatibility with still existing legacy databases and new database using SQL stored procedures.
• Create new .NET Application for a EPA database. This application and database replaced an existing legacy Fox Pro application.
• Assisted in formulating and establishing development process guidelines.