SUMMARY:

• Seeking high - responsibility I.T. position where creativity, strong communication, and deep technical skills result in profitable innovations and implementations.
• Native English speaker. Learn other languages relatively quickly.
• Spanish and Portuguese, conversational.
• Multiple college courses in German and Russian.
• Basic Cantonese (Chinese), Japanese, Portuguese, French, and Pilipino (Tagalog).

TECHNICAL SKILLS:

VB.Net w/ WinForms VS2010-2003

C#.Net

Windows Services

Linq

Multithreading

HL7

Public Health Data (including HIV/AIDS)

XML

SQLServer (2012, 2008, 2005, 2000, 7) relational database development/support

T-SQL (2012, 2008, 2005, 2000, 7)

Database design and modeling

SQL Server Integration Services (SSIS)

Extract Transform&Load

Access (including Visual Basic for Applications) thru 2010

Excel (including VBA) thru 2013

MVC 4, 5

ASP.Net

HTML

CSS

Javascript

JQuery

Razor

PowerShell 4

Windows Management Instrumentation (WMI)

VisualBasic6.0

Windows Script Host (VBScript)

Tortoise SVN

Team Foundation Server

Visual Source Safe

C

Python Scripting

SystemDevelopmentLifeCycle

Documentation

Visio

Algebra

Statistics

EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Creating MVC 5 Web applications with C#; designing, creating, and maintaining SQL Server 2012 databases; programming in T-SQL; creating SSRS 2012 reports and SSIS 2008 transformations.
• Creating PowerShell 4 scripts. Creating documentation with interactive flowcharts using PowerPoint 2010.

Confidential

Senior Developer

Responsibilities:

• Converted major application from VB6 to VB.Net, including database design. Incorporated logic from two other applications into the new one.
• Design and develop additional data transformation and storage processes with VB.Net (Windows forms and Windows Services), t-SQL programming, Interfaceware, and some Python scripting.
• Design and develop databases to store the data.
• Manage multiple data interface projects simultaneously.
• Analyze/support C#.Net applications.
• Converted a VB 6.0 procedure-based data-conversion application (of call center call detail records), to a modular VB.Net 2005 application with MySQL backend and WinForms.
• Created WCF Web Service-to-MS Access reporting service.

Confidential

Programmer/Analyst

Responsibilities:

• Five years of daily development in VB.Net 2005 and 2003 (Multithreading, Windows Services, WinForms, ADO.Net, etc.), VB6, and/or ADO. Daily support of and occasional development of SQL Server 2000 and 2005 relational databases. Also often MSAccess/VBA.
• Testing/ETL project brought data from various sources (SQL Server 2005, Windows file presence, and text data) to a central repository for analysis of the success of the test.
• T-SQL 2005 programming: complex queries to parse file-processing data to a relational database.
• Reliability of the stored procedures was extremely important since legal compliance (HIPAA, etc.), correct dosage, and correct shipping relied on the accuracy of the queries.
• Application support remedies saved $210,000 in user time, prevented HIPAA compliance penalties, and otherwise-lost customers.
• Mentored and/or trained 5 colleagues in VB.Net 2005, VB 6.0, and/or T-SQL 2005 programming.
• Daily duties required solid understanding and application of full SDLC.
• Designed and programmed application upgrades that allowed for $500,000 in increased sales.
• Identified need for, designed, and created research tools while solving software problems in 20 applications.
• Designed XML-based custom application configuration system.
• Mentored Quality Assurance staff in testing my applications, providing test case scenarios and T-SQL 2005 code for identifying normal and abnormal data, saving $2,000 per rollout.
• Applied highest standards in documenting my research and applications.
• Served as interim manager of Marketing Department.

Confidential

Disease Surveillance & Informatics Coordinator

Responsibilities:

• Guided implementation of Confidential i’s Bio-Terrorism Response Suite for 150 users.
• Guided and developed Confidential i’s Confidential initiative, full SDLC. Planned and executed Confidential custom ETL processes using T-SQL 2000, XML, MS Excel, and MS Access to integrate 8 varied legacy systems into a single SQL Server 2000 relational database.
• Configured, managed, and created reporting for data on published MRSA study.
• Developed 4 disease-response databases in MS Access, often in emergencies, resulting in 4 awards for the response team. A federal grant reviewer called a 5th database the best of its kind in the USA.
• Participated in the Confidential i Strategic National Stockpile Exercise and planning.
• Participated in national health informatics conferences, founded the healthDB discussion list and a 3-state (UT, CA, HI) user’s group for users of PHS3, a Confidential solution.
• Greatly improved our relationships with other agencies, including other states.
• Supported or assisted 5 State sites; TB, STD, HIV/AIDS, Epidemiology, and Immunization.
• Received training on handling of HIV/AIDS data by CDC staff.

Confidential

Immunization Consultant

Responsibilities:

• Hired, trained, and managed clerical staff of 4 people.
• Designed and created Confidential ’s immunization registry for 30,000 at-risk children using complex custom T-SQL queries and automated ETL processes, converting flat files to a fully-relational SQL Server 7 database of over 1 million records. Created VB6 interface to allow clerical supervisees to review and combine records, reducing the database size by 30% and increasing accuracy by 60%.
• Created user-friendly help and training documentation for the registry in HTML and Javascript.
• Designed and coded immunization Web page on State intranet, "the best content on our intranet".
• Administered SQL Server 7, including all immunization data.