Uploaded File
Brian
brian.oliver451@gmail.com
407-748-0378
Norfolk, VA 23501
Web/Sr. Programmer
37 years experience W2
3
Recommendations
Average rating
255
Profile views
Summary

Software Projects: Health Insurance Enrollment and Claims Processing, ePrescribing, Inventory Control, Sales Orders & Invoicing, Custom POS, Surveillance, Computer vision/defect recognition, Automated Process Control in Semiconductor Manufacturing, Numerical modeling, Educational/Training, Health Care Enrollment Application Process (WCF,SSIS, ASP, C#), Healthcare COB/MSP, Healthcare Claims Processing

Languages/Frameworks: C# (WCF, MVC, ADO), ASP.NET, JQuery (AJAX, Kendo UI, Angular,Node), T-SQL(SSIS,SSRS), HTML, CSS, VB.NET, ASP(Classic), VB6 , C++ , Java, PHP, Javascript, Flash ActionScript, XML, FORTRAN, Physics Simulation Engine Scripting(Working Model), OOP Methods and Design Patterns (MVC, Factory, Singleton, Builder, etc.)

Content Management: DNN (nee DotNetNuke), WordPress, Joomla

IDE: Visual Studio 6 – VS 2019, Business Intelligence Development System (BIDS), Xamarin Studio, Eclipse, Flex Builder, Xcode, Arduino

Databases: SQL Server 2000 – 2017, Azure, MySQL, Access, Oracle, Aspen IP.21(NoSQL Real-Time Database)

BI Tools: SSRS, Crystal Reports, Tableau, Alteryx

Source Control: VSS, TFS, SVN, GIT

Teaching: Calculus based physics, algebra/trig. Based physics, general science, pre-algebra, algebra, trigonometry and analytic geometry, calculus, differential equations, Statics, Dynamics, Strength of Materials, ESL, composition, technical writing

OS: Windows NT,2000,P,VISTA, 7,10; VAX/VMS; UNIX; LINUX (UBUNTU)

Applications/Libraries: Business Objects, MathCad, MatLab, Mathematica, LabVIEW for Equipment and Product testing, Pspice, OpenCV, IMSL, MS MapPoint, MS Speech Library, AutoCad, Solid Works, Working Model, AJAX, Android SDK, Kinect SDK, National Instruments Measurement Studio 2019

Utility Applications: MS Office (all apps) primarily Word, Powerpoint and extensive use of Excel, Crystal Reports XI, MS Visual Studios 6/2005/2008, Quick Books

Fields of Interest: Data mining, mathematical modeling, nonlinear dynamics and chaos, optimization algorithms, neural networks, artificial intelligence, computer vision, quantum mechanics

Human Languages: Advanced English, Intermediate Mandarin Chinese (verbal)

Experience
.NET/SQL Developer
Aerospace/Defense
Jun 2019 - Aug 2019
Bethel, CT
  • Developed the new .NET based test software using GPIB interface and National Instruments Measurement Studio 2019 based on old VB6 app controlling pressure transducers and switches manufactured by Eaton Corporation.
.NET Switches SQL SQL Developer
Remove Skill
DB2/.Net SOAP Engineer
Consumer Goods
Feb 2019 - Mar 2019
Astoria, NY
  • Tasked with reverse the engineering existing AS400 DB2 queries that are called by VB.NET SOAP web services.
  • The AS400 WMS system is to be replaced with Netsuite ERP
  • The .Net web services are to be replaced by Dell-Boomi’s cloud-based integration, API management, and Master Data Management system.
  • Used TFS for source control.
.NET DB2 MS TFS SOAP WebServices VB.NET NetSuite ERP Data Management Boomi AS/400
Remove Skill
Application Developer .NET/SQL/OSI PI /Production Support Level 3
Construction/Engineering
Oct 2018 - Jan 2019
Corning, NY
  • Developed and deployed the application to Wire Electro-Discharge Machining (WEDM) Module to maintain setpoints, machine stop reasons, maintenance activities and guide usage using VB.NET and SQL.
  • Product testing and analysis an reporting of results.
  • Worked on machine status reporting using data obtained from OSI PI on Sodick WEDM machines (400,600, and 800 models)
  • Used TFS for source control.
  • Made extensive use of excel, creating formulas, pivot tables, formatting, statistical results.
MS TFS VB.NET Production Support OSI Microsoft Excel Database Maintenance Analysis .NET SQL
Remove Skill
SQL/ETL Developer
Education
Jun 2018 - Sep 2018
New York, NY
  • Developed and maintained stored procedures and Integration services packages for moving and transforming data into DataMart for SalesForce.
  • Worked with Data Loader and Informatica to sync data from other applications into SalesForce.
Informatica Salesforce Stored Procedure ETL ETL Developer SQL
Remove Skill
Applications Developer/.Net/C#/Data Programmer
Healthcare
Apr 2018 - May 2018
Manhasset, NY
  • Developed a .Net Core multi-tenant portal application to replace an existing portal based on Cass.
  • Created multiple ETL SSIS packages to load data from various flat-file and excel file sources.
  • Assisted in work on a common warehouse-like database with a flattened table designed to store information from both CMS CCLF claims files and proprietary health insurance claims files.
  • Used TFS for source control.
.NET ETL MS TFS SSIS Microsoft Excel Database Design C#
Remove Skill
Applications Developer/Data Programmer/Production Support Level 3
Insurance
Oct 2014 - Apr 2018
New York, NY
  • Designed and implemented automated processes to assist with Amida Care’s need to satisfy State and Federal compliance laws for Medicaid and Medicare Advantage programs.
  • Made extensive use of T-SQL including database design and development, creation of stored procedures, functions, and triggers with an emphasis on optimized execution.
  • Also, assisted individual business units with their department based Access databases and Access code.
  • Built automated jobs that combined execution of stored procedures and SSIS packages via SQL Agent.
  • SSIS packages included many components including a range of control and data flow elements. Many of them included C# script tasks that leverage 3rd party .NET/.Com objects to complete specialized operations, e.g. sFTP. email, archiving, EDI parsing and generation, ADO database access, JSON parsing, and XML Xpath analysis.
  • SQL/SSIS.NET/C#/VB Projects included:
    • CMS MARX Inbound/Outbound Transaction Automation Project
    • NYS Medicaid/Health Homes Automation Project
    • AmidaCare Healthy Rewards Incentives Project based on Claims
    • X12 5010 834/837 EDI Parsing/Generation for Healthix (RHIO)
    • 834 EDI process to receive and send enrollment data to NYSoH.
    • 837 All Payers Database (APD) Project for Encounters submission to NYS
    • Variety of specialized reporting using multiple BI tools, e.g. Crystal Reports, SSRS, etc.
    • Made extensive use of excel, creating formulas, pivot tables, formatting, statistical results, vLookup
    • Experimented with using Python for claims data analysis
    • BizTalk development of EDI 834 eligibility files
  • Used TFS for source control.
  • Used excel, creating formulas, pivot tables, formatting, statistical results.
  • Attended workshop and week course using Azure focused on general knowledge, data factory, and machine learning.
  • Built a prototype system to demonstrate to IT management and C-Suite.
  • Move data warehouse table to Azure and run ETL packages from local transaction tables to cloud-based DW tables.
C# Compliance Crystal Reports Data Analysis Data Warehousing ETL JSON Machine Learning MS Azure MS TFS Python SQL SSIS SSRS Stored Procedure T-SQL Triggers XML Microsoft Excel Medicare FOCUS EDI Database Design BizTalk Azure Data Factory Analysis .NET Production Support Visual Basic 834 837
Remove Skill
Web/Database Developer/Production Support Level 3
Healthcare
Jul 2012 - Apr 2014
Orlando, FL
  • Developed and support web/windows applications created using Visual Studio written in C#/ASP.Net using a variety of design patterns, e.g. factory, MVC, and frameworks, e.g. Linq to SQL, Entity, etc.
  • Created T-SQL stored procedures and SSIS packages that were used to support web/windows apps access to db stuctures and acted as steps in jobs run by SQL Agent.
  • Developed reports using Crystal Reports and SSRS
  • Made extensive use of excel, creating formulas, pivot tables, formatting, statistical results
  • Also was required to assist individual business units with their department based Access databases and Access code.
  • Developed and implemented SSIS packages that with multiple steps including; DTS operations, looping through multiple files, executing stored procedures, calling C# scripts, etc.
  • Developed and maintained web service (WCF) to facilitate secure communication between iOS7 mobile application and sql database.
  • Supported, maintained and enhanced existing sql processes, ssis packages, ssrs reports, and web projects.
  • Worked with Manage Engine to handle helpdesk dev requests, submittals of change control and creation of tasks for deployment to Test and Production environments.
  • Gathered requirements from business for healthcare processes including medicare enrollment, prior auth, claims, COB/MSP, EDI 834 and 837 file parsing/translation.
  • Work with off-shore teams to relate requirements and assist in deployment of 3rd party developed solutions.
  • Initiated interest in use of Xamarin Studio to provide in house ability to build iOS7 and Android versions of previously developed iOS7 Healthcare Enrollment App (PupEnroll in Aplle App Store).
  • Used TFS extensively as source control.
C# SSIS ASP.NET SQL SSRS Visual Studio T-SQL SQL Server .NET Design Patterns LINQ MVC Stored Procedure WebServices Database Design Android Crystal Reports MS TFS Xamarin Windows MS MAM Microsoft Excel Medicare EDI Production Support 834 837
Remove Skill
References
Average Rating

3 recommendations
Programmer/Developer
Information Technology
May 2012 - Jul 2012
Orlando, FL
  • Developed and supported the latest technologies in Web, SOA, and Desktop Applications to support the business needs of SNI Technology clients.

SOA Application Support
Remove Skill
Business Analyst
Information Technology
Oct 2011 - Feb 2012
Orlando, FL
  • Gathered functional requirements for web applications from business project owners.
  • Wrote functional requirement documents (FRDs).
  • Communicated FRDs to lead and offshore developers.
Business Analysis
Remove Skill
Web Developer/Production Support Level 3
Information Technology
Jun 2011 - Oct 2011
Orlando, FL
  • Migrated previously developed windows/desktop applications to the web.
  • Used ASP.NET, C#, VB.NET and MySQL to take inventory control, accounting and POS system to a web-based environment primarily to facilitate ease of future upgrades and modifications.
  • New features included a pictorial map of products in shop and warehouse and voice control for sales order generation.
  • Used VSS (predecessor of TFS) for source control.
ASP.NET C# VB.NET MySQL .NET Web Developer Windows VSS Database Upgrades Inventory Control Production Support
Remove Skill
Senior Programmer III/Production Support Level 3
Medical Devices
Feb 2010 - Jan 2011
Port Saint Lucie, FL
  • Acted as a development lead on e-Prescribing Point of Care (POC) application with Medco. The e-Prescribing project was implemented using a combination of web and windows services. The windows services consumed web services hosted by Medco on SOA Data Power Appliances. The liberty Based web services were SOAP services created in VS 2005 (.NET 2.0) or using WCF in VS 2008 (.NET 3.5).
  • Created new in-house applications with VB (also C# for personal prototyping) .NET 2.0,3.5 and SQL 2000,2005.
  • Supported legacy VB6 and Access apps.
  • Worked with the business owner to develop application requirements.
  • Served as a Subject Matter Expert (SME) by ensuring that the project is feasible from a technical standpoint and the functional requirements of a project are sufficiently documented for development to proceed.
  • Supported and maintained existing applications.
  • Worked within the CMMI or “WaterFall” SDLC.
  • Followed health service provider's compliance rules, e.g. PHI, IHI, and Hippa2.
  • Provided production support through troubleshooting and assessing challenges.
  • Systems QA/Testing.
.NET C# SQL SQL 2000 SOAP SDLC SQL Server 2005 VB.NET SOA WebServices Visual Basic Windows WCF Waterfall Prototyping Production Support Problem Solving HIPAA DataPower Compliance CMMI
Remove Skill
Senior Programmer/Lead Developer
Information Technology
Jan 2009 - Feb 2010
Jacksonville, FL
  • Developed applications and widgets on windows platform using VB, VB.NET, ASP, ASP.NET, C#, HTML, Javascript, PHP, and Java for Linux platforms.
  • Used Content Management add-ins to simply web-site modification, e.g. DotNetNuke Wordpress, Joomla for Linux-based sites.
  • Built widgets and small apps using Google Web Toolkit, Yahoo Widget Developer, and Adobe Flash.
  • Wrote detailed manuals to accompany completed projects and bid-proposals to help acquire new jobs.
ASP.NET C# VB.NET HTML JavaScript PHP Java Linux Adobe Flash Visual Basic ASP Classic Wordpress Windows DotNetNuke Content Management
Remove Skill
Senior Programmer/Lead Developer/Production Support Level 3
Consumer Goods
May 2008 - Jan 2009
Daytona Beach, FL
  • Acted as chief architect and lead developer using an Agile SDLC for inventory control and quality assurance(QA) reporting applications.
  • Used VB, VB.NET, ASP, ASP.NET, Crystal Reports, HTML, XHTML, Javascript, SQL, MY SQL, MS ACCESS to create custom windows applications for reporting that interfaced with third-party applications run by Bright House, i.e. ICOMS and TOA.
  • Created a prototype job mapping and routing application using MS MapPoint.
  • The QA application provided centralized client access to a data-repository that was updated with daily feeds from mobile client applications.
  • Similarly, the inventory control application facilitated remote access to a centralized server located in the main warehouse and fed data to a mobile area network of handheld devices used by field engineers.
  • Software documentation and a quick-reference guide to operations were also provided.
ASP.NET SQL JavaScript MySQL HTML VB.NET MS Access Documentation ASP Classic Crystal Reports Agile Methodology Visual Basic Windows SDLC Quality Assurance Inventory Control Production Support
Remove Skill
Senior Programmer/Lead Developer/Production Support Level 3
Information Technology
Jun 2007 - Apr 2008
Orlando, FL
  • Designed and developed a new inventory control, accounting and POS system in an AGILE environment.
  • Used VB, VB.NET, ASP, ASP.NET, Crystal Reports, SQL, MY SQL, MS ACCESS to facilitate the migration of inventory and accounting data from a 15 year old legacy DOS based data collection and reporting system known as Q&A to MS Access and MY SQL.
  • The imported data was rearranged into a more logical/normalized table structure in Access and made accessible through the use of a custom-built windows application created using Visual Basic 6.
  • This application provided complete search capabilities, enables the generation of sales orders and invoices by multiple clients and performs a multitude of reporting tasks using embedded Crystal Reports XI.
  • Later the application was migrated to .NET and is currently being implemented as a web application using ASP.NET and C# (see present position).
  • Documentation for the VB6 application was provided and the VB.NET documentation is still in progress.
.NET ASP.NET C# SQL VB.NET Visual Basic Documentation Crystal Reports MS Access Agile Methodology Windows Inventory Control Database Design Production Support
Remove Skill
Programmer
Information Technology
Jan 2007 - Jun 2007
  • Worked with a team of subcontractors based in Vietnam to develop computer vision algorithms in C++ using MathCad and OpenCV include libraries.
  • The algorithms were able to take the input from a camera and track moving objects, identify objects, and locate defects in images such as micrographs of semiconductor wafers.
  • This software was intended for use in surveillance and identification systems marketed and sold by a US company.
C++ MS Visio
Remove Skill
Instructor/PhD candidate
Education
Feb 2004 - Jan 2007
  • Provided instructions in Intermediate English Conversation for the NCTU EFL continuing education department.
  • Student backgrounds included public school teachers, office workers, engineers and graduate students at NCTU.
  • Collaboration on several technical preprints we’re prepared and proof-reading for many of the Asian researchers at the University was facilitated through my work with an online business.
No skills were added
Remove Skill
Web Programmer/ Applications Engineer
Manufacturing
May 2000 - Feb 2004
  • Wrote prototype software intended to demonstrate the flexibility of the Symphony-Systems APC solution to the semiconductor manufacturing community.
  • Coding was performed in C++, VB6, ASP(Classic), SQL, HTML, and Javascript.
  • The completed programs were of two basic types; 1) client-side data viewing and configuration programs that run in a web browser; 2) server-side programs that run in the background performing online-fault detection analysis on real-time data and email notification of alarms and events generated by the equipment or fault detection software.
  • Documentation and user guides for the APC portal were written and translated into Chinese, Japanese and Korean.
  • Applications engineering functions were performed in the field at a variety of OEM and manufacturing sites in the US and Taiwan, including Micron, Novellus, AMAT, LAM, UMC, TSMC, Winbond, Promos, etc.
  • Advanced Energy was an investor in Symphony Systems and purchased them in 2002.
  • The same work as at Symphony Systems was continued as well as providing customer service and application engineering support to a variety of the semiconductor fabs in the Hsinchu based Science Industrial Park.
  • Hardware applications included Noah Thermoelectric Chillers, 4th State Plasma Abatement Systems, and Advanced Energy RF sensors and End-Point detection systems.
  • Equipment and product testing were performed for these Semicon tools.
Analysis C++ HTML SQL JavaScript VB6 Visual Basic RF OEM Novell Manufacturing Documentation Customer Service
Remove Skill
Programmer
Information Technology
Jul 1998 - May 2000
Jacksonville, FL
  • Wrote code in VB6, ASP(Classic), HTML, Java, SQL, JavaScript for use in client and server-based databases.
  • Past projects included a variety of websites intended for electronic-commerce traffic as well as a technical database intended for distribution on CDROM.
Java SQL JavaScript HTML VBA
Remove Skill
Instructor of Physics
Education
Sep 1993 - Jun 1998
Sanborn, NY
  • Taught at least 18 contact hours each semester in college level, calculus based physics, trigonometry based physics, engineering statics and dynamics, as well as mathematics and computer courses.
  • Teaching responsibilities include preparing and delivering daily lectures, supervising laboratory exercises, and keeping track of student records.
  • Additional responsibilities include assisting the division chair in scheduling physics courses, preparing the physics budget, and acting as co-coordinator for the Liberal Arts Math and Science curriculum at NCCC.
  • Important accomplishments include the development and maintenance of a multi-station LAN in the physics laboratory with each machine equipped with computer aided data acquisition software and hardware, the design and construction of novel transducers and sensors, and the implementation of new collaborative and interactive teaching techniques that make extensive use of the computer tools in the laboratory.
MS Visio MS Dynamics 365 LAN Database Maintenance Database Design
Remove Skill
Adjunct Instructor in Physics
Education
Jan 1990 - Aug 1993
Rochester, NY
  • Taught three classes each semester in college-level physics.
  • Responsibilities included preparing and delivering daily lectures, supervising laboratory exercises, and keeping track of an average of 100 students records for any given semester.
No skills were added
Remove Skill
Researcher/Graduate Student
Education
Sep 1984 - Jun 1989
Rochester, NY
  • Performed theoretical investigation of correlated quantum optical systems.
  • Developed mathematical model of multimode laser instabilities.
  • Ran numerical simulations of multimode electromagnetic field interacting with atoms.
  • Made extensive use of VAX/VMS Fortran for a variety of numerical simulations.
  • Constructed frequency stabilized He-Ne laser.
  • Assisted in construction of frequency stabilized tunable dye laser.
  • Published three articles in technical journals.
  • Presented findings at meetings of the Optical Society of America.
VAX/VMS Fortran Simulation
Remove Skill
Research Assistant
Education
Dec 1983 - Sep 1984
Orlando, FL
  • Developed mathematical model of a novel passive sonar system.
  • Made extensive use of VAX/VMS Fortran for a variety of numerical simulations.
Fortran VAX/VMS Simulation
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Optical Engineering
University of Rochester 1993
Bachelor's in Physics
University of Central Florida 1984
Related Courses
Information Management, Institute of Information Management - Post Grad Studies, 2007
SUNY Workshop on Design of Computer Based Instructional Materials using Assymetrix Toolbook, 1996
Microsoft Azure Developers Workshop, 2016
Skills
Documentation
2009
29
Analysis
2019
19
SQL
2019
15
HTML
2010
14
JavaScript
2010
14
T-SQL
2018
14
.NET
2019
12
Database Design
2018
12
Visual Basic
2018
11
Production Support
2019
10
Fortran
1989
8
VAX/VMS
1989
8
VB.NET
2019
8
Visual Studio
2014
8
ASP.NET
2014
7
C#
2018
7
Microsoft Excel
2019
7
MS Access
2009
7
MS TFS
2019
7
MySQL
2011
7
SDLC
2011
7
834
2018
6
837
2018
6
Database Maintenance
2019
6
EDI
2018
6
Medicare
2018
6
Simulation
1989
6
Windows
2014
6
Compliance
2018
5
LAN
1998
5
Linux
2010
5
MS Dynamics 365
1998
5
MS Visio
2007
5
Azure Data Factory
2018
4
BizTalk
2018
4
Customer Service
2004
4
Data Analysis
2018
4
Data Warehousing
2018
4
ETL
2018
4
FOCUS
2018
4
JSON
2018
4
Machine Learning
2018
4
Manufacturing
2004
4
MS Azure
2018
4
Novell
2004
4
OEM
2004
4
Python
2018
4
RF
2004
4
SOA
2012
4
SQL Server 2008
2013
4
Triggers
2018
4
XML
2018
4
PHP
2010
3
SQL 2000
2011
3
WebServices
2019
3
Adobe Flash
2010
2
Agile Methodology
2009
2
Android
2014
2
C++
2007
2
Design Patterns
2014
2
Inventory Control
2011
2
LINQ
2014
2
MS MAM
2014
2
MVC
2014
2
SSIS
2018
2
SSRS
2018
2
Stored Procedure
2018
2
Xamarin
2014
2
Business Analysis
2012
1
CMMI
2011
1
Content Management
2010
1
Crystal Reports
2018
1
DataPower
2011
1
DotNetNuke
2010
1
HIPAA
2011
1
Java
2010
1
OSI
2019
1
Problem Solving
2011
1
Prototyping
2011
1
Quality Assurance
2009
1
SOAP
2019
1
Waterfall
2011
1
WCF
2011
1
Wordpress
2010
1
ActionScript
0
1
Adobe Flex
0
1
AJAX
0
1
AngularJS
0
1
Application Support
2012
1
Arduino
0
1
Artificial Intelligence
0
1
AS/400
2019
1
ASP Classic
2010
1
AutoCad
0
1
Boomi
2019
1
Business Intelligence
0
1
Business Objects
0
1
CLIPS
0
1
CSS
0
1
Data Management
2019
1
Data Mining
0
1
Database Upgrades
2011
1
DB2
2019
1
DNN
0
1
Eclipse
0
1
ERP
2019
1
ETL Developer
2018
1
Git
0
1
Informatica
2018
1
jQuery
0
1
Kendo
0
1
Labview
0
1
Matlab
0
1
MongoDB
0
1
NetSuite
2019
1
Neural Networks
0
1
OOP
0
1
Oracle
0
1
quickbooks
0
1
Salesforce
2018
1
Scripting
0
1
Solidworks
0
1
SQL Developer
2019
1
SQL Server
2014
1
SQL Server 2005
2011
1
SVN
0
1
Switches
2019
1
Tableau
0
1
Technical Writing
0
1
Training
0
1
Ubuntu
0
1
UI
0
1
VB6
2004
1
VBA
2000
1
VSS
2011
1
Web Developer
2011
1
Xcode
0
1
Languages
Mandarin, Intermediate