Ernest Bonat, Ph.D.
Hillsboro, OR 97124-6863
Cell: 503-***-****
Email: ******.*****@*****.***
LinkedIn: https://www.linkedin.com/in/ernest-bonat-ph-d-8888b319 POSITIONS
• Senior Software Engineer
• Senior Data Scientist
• Senior Database Engineer
• Senior Quality Assurance Engineer
EDUCATION
• Ph.D. Computer Sciences and Engineering (Equivalent). University of Phoenix, Portland. USA. 2001
• Ph.D. Computer Sciences and Engineering (Equivalent). University of Toronto, Canada. 1992
• Ph.D. Computer Sciences and Engineering. National Technical University of Ukraine, Kiev, Ukraine.1987
Thesis: “Automatic Subsystem Design of Silicon Oxidation Thermal Process using CAD Software Engineering”
• B.Sc. and M.Sc. Electrical Engineering. National Technical University of Ukraine, Kiev, Ukraine.1983. Thesis: “Dynamic Mathematical Modeling of Electrical Power Converters using Linear and Non-Linear T-Transform Method”
EDUCATIONAL AND SCIENTIFIC AWARDS
• “2004 Information Technology Instructor of the Year”, University of Phoenix, Oregon Campus, Jun 2004
• “Emeritus Member”, Students Scientific Association, National Technical University of Ukraine, Ukraine, Jan 1983
• “First Premium Award”, Third Scientific-Technical Conferences of Cuban Students in Kiev “Numerical Math Modeling, Optimization and Design of Linear and non-Linear Electrical Power Converters”, National Technical University of Ukraine, Ukraine, Oct 1982
• “First Premium Award”, Second Scientific-Technical Conferences of Cuban Students in Kiev “Analytical Math Modeling, Optimization and Design of Linear and non-Linear Electrical Power Converters”, National Technical University of Ukraine, Ukraine, Nov 1981 SCIENTIFIC-TECHNICAL BACKGROUND
• 5 Practical Methods of Teaching Laboratory and Researching
• 5 User Manuals of Computer Interactive Programs
• 44 Scientific-Technical Articles
• 2 Technical Books
• 17 Articles on Visual Basic Windows Programming and GUI Guides Design
• 5 Articles on MySQL/VB.NET Windows Applications Programming
• 17 Scientific-Technical Conferences and Seminars
• 3 Tutored Ph.D. Thesis
• 1 Tutored M.S. Thesis
• 2 Tutored Microelectronic Thesis Specialists
Page 2 of 7
SKILLS SUMMARY
• 23 years of experience in designing, developing and deployment Windows desktop applications using VB 3.0 - 6.0 (12 years), MS Excel/MS Access/VBA (16 years), VB.NET (11 years), Visual C#.NET (8 years), Borland C++ (4 years), Visual C++ (2 years) Windows and Web Services (6 years), Win Forms
(19 years), ActiveX (EXE, DLL and OCX), COM, DCOM, OOP, VSS, N-tiers Application Design (GUI, Business Logic and Database Objects), Access, SQL Server, Oracle, IBM DB2, MySQL and PostgreSQL
• 16 years of experience in software development life cycle (SDLC) using Agile, Waterfall and Scrum methodologies
• 14 years of experience in software business analysis including collecting, studying, analyzing and documenting the projects business requirements including functional specifications, user interface designs and guides, user and developer documentations, unit and system tests, etc. (MS Office and Visio Enterprise)
• 12 years of experience managing and leading IT employees and consultants for business database applications using Microsoft and Open Source technologies
• 5 years of experience in designing, developing and deployment Microsoft web applications using VB.NET, Visual C#, OOP, VSS, ASP Classic, ASP.NET Web Forms, ASP.NET/C#/MVC/Razor, Entity Framework, WCF SOAP Web Services, RESTful Web API Services, DHTML, XHTML, XML, CSS, VBScript, JavaScript, Java J2EE, jQuery and AJAX
• 7 years of experience in Quality Assurance of software design and development including Unit/System Test using NUnit for C#.NET, PyUnit for Python and JUnit for Java EE
• 7 years of experience in designing, developing and deployment Microsoft WCF SOAP Web Services and ASP.NET RESTful Web API Services
• 18 years of experience in designing, developing and migrating database system using Access, SQL Server, Oracle, IBM DB2, MySQL and PostgreSQL (database objects development, maintenance, optimization, monitoring and tuning including tables, views, indexes, stored procedures, triggers, functions, packages, data transformations services, etc.)
• 5 years of experience in Python Data Stack scripting language using Python 3.x/Eclipse IDE/PyDev Plug-in/PyUnit/Linux/Windows, Data Science/Pandas/NumPy/SciPy/IPython/Matplotlib
• 19 years of experience in Microsoft SQL Server, DTS, SSIS, SRSS, Transact-SQL programming using Management Studio
• 13 years of experience in Oracle PL/SQL programming using Toad for Oracle
• 11 years of experience in IBM DB2 using Toad for IBM DB2
• 11 years of experience in MySQL SQL:2003 programming using Toad for MySQL
• 4 years of experience in PostgreSQL PL/pgSQL programming using pgAdmin
• 17 years of experience in report design and development using Crystal Reports, Active Reports and Microsoft SRSS (6 years)
• 17 years of experience in ETL custom design and development (IBM DB2-to-Excel, Oracle-to-Excel, SQL Server-to-Excel-Access, Excel-to-MySQL, etc.)
• MySQL Development Zone Online Contributor for advanced Windows applications development using VB.NET, Visual C#.NET and MySQL
• 13 years of experience in teaching computer programming courses for Portland Community College, Mt. Hood Community College, University of Phoenix and University of the People (onground and online)
• 7 years of experience in teaching Business Statistics courses for University of Phoenix and Concordia University (onground and online)
• 5 years of experience in Business Statistics Analysis using SPSS, Minitab, Excel, Python Data Stack, etc.
Page 3 of 7
TECHNICAL SUMMARY
• Operating Systems: Windows XP, Vista, 7, 8.1, 10
• Programming Languages and Libraries: Visual Basic 6.0, VB.NET, Visual C#.NET, Borland C++, COM, DCOM, HTML, XHTML, XML, JSON, CSS, ASP classic, ASP.NET/MVC, WPF, WCF, VBScript, VBA, PHP, JavaScript, JQuery, SQL99, T-SQL, PL/SQL, SQL:2003
• Programming Environments and Tools: Visual Studio Enterprise, MS Office, Visio, UML Modeler, SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, Adobe Studio, NetBeans, Zend Studio, phpMyAdmin, Toad for MySQL, dbForge Studio for MySQL, Eclipse ad NetBeans IDE, Java EE, Python Data Stack, etc.
• Third Party Controls Infragistics and Telerik ASP.NET AJAX and Win Form Controls. PROFESSIONAL EXPERIENCE
• Thermo Fisher Scientist (Oct/2017 – Current)
Job Title: Senior Software Engineer / Senior Data Scientist (Consultant) Projects: “C#/Emgu and OpenCVSharp Image Processing” Technologies: Microsoft C#/Emgu and OpenCVSharp Image Processing, Microsoft WFP/MVVM Application Development, Data Analytics and Intelligence Report Generation using Eclipse IDE, PyDev Plug-in, PyUnit and Python Data Stack (Pandas, NumPy, SciPy, Statsmodels, Keras, Matplotlib, scikit- learn Machine Learning, scikit-image, Seaborn, ReportLab) etc.
• 15 IT Resources LLC (Aug/2015 – Current)
Job Title: Senior Software Engineer / Senior Data Scientist (Consultant) Projects: “ETL (Extract-Transform-Load) Healthcare Data Cleansing and Business Intelligence Reports Generation”, “Designing and Implementing MVC Architecture in Python for Data Analytics” Technologies: SQL Server T-SQL Stored Procedures, Functions and Triggers, C#.NET, MVC Architecture, .NET Entity Framework, Business Intelligence reports generation (CSV, XML and JSON). Data Analytics and Intelligence Report Generation using Eclipse IDE, PyDev Plug-in, PyUnit and Python Data Stack (Pandas, NumPy, SciPy, Statsmodels, Keras, Matplotlib, scikit-learn Machine Learning, scikit-image, Seaborn, ReportLab, etc.), Design and Developing RESTful API Web Services using Python Flask Microframework, ETL MongoDB-JSON/XML/CSV/TXT Files using Python Data Stack, GitHub, etc.
• Carver Technology Consulting LLC (Jun/2017 – Aug/2017) Job Title: Senior Java Engineer (Consultant)
Projects: “Intel Java Unit Test xIF”
Technologies: Java EE, JUnit Test Case and Suite projects, Java Reflection implementation, etc.
• McledSoft LLC (Oct/2014 – Nov/2015)
Job Title: Senior Software Engineer / Senior Data Scientist (Consultant) Projects: “Recipe Notebook Mobile Application”, “ETL Excel-JSON”, and “Network Log Frequency Distribution Data Analytics”
Technologies: Mobile Applications (Android, iOS and Win Phones) design and development using VS.NET, Xamarin Platform, SQLite and NUnit Test, GUI Design and Development, .NET Entity Framework, C#.NET Portable Libraries design and development, Microsoft WCF SOAP and ASP.NET RESTful Web API Web Services, Database modelling, design and implementation, T-SQL Stored Procedures, Functions and Triggers development, Business Intelligence Reports Generation, Excel, VBA and Crystal Reports, Data Analytics and Intelligence Report Generation using Eclipse IDE, PyDev Plug-in, PyUnit and Python Data Stack (Pandas, NumPy, SciPy, Statsmodels, Keras, Matplotlib, scikit- learn Machine Learning, scikit-image, Seaborn, ReportLab, etc.), Design and Developing RESTful API Web Services using Python Flask Microframework, GitHub, etc. Page 4 of 7
• Intel Corporation (Jul/2015 – Oct/2016)
Job Title: Senior Application Developer / Senior Data Scientist (Full-time) Projects: “ETL Gate Keeper Extract SSIS Package Updates”, “Download Center 404's Errors .NET Console Application”, “ETL Excel Conversion to XML/JSON .NET Utility Library”, “Machine Translation Web and Windows Services”, “ETL eGain-SFDC Articles Migration .NET Utility Library”, “Ask Intel Website Application Update”, “ETL Access Management Oracle /SQL Server/ Data Migration”, “Setting and implementing .NET SonarQube Code Analyzer”, “ETL ICS KM Project Updates using Salesforce”,
“APB 2020 Model” and “Automated Weekly Diversity Report”. Technologies: ASP.NET, MVC Architecture, C#.NET, ASP.NET RESTful API Web Services, HTML, CSS, JQuery, JavaScript, .NET Entity Framework, SQL Server, TFS, Salesforce, MongoDB, Data Analytics and Intelligence Report Generation using Eclipse IDE, PyDev Plug-in, PyUnit and Python Data Stack (Pandas, NumPy, SciPy, Statsmodels, Keras, Matplotlib, scikit-learn Machine Learning, scikit-image, Seaborn, ReportLab, etc.), Modeling Population Dynamics using Leslie and Lefkovitch Matrix Models, GitHub, etc.
• Creative Fitness Solutions (Jun/2015 – Feb/2016) Job Title: Senior Software Engineer / Senior Data Scientist (Consultant) Projects: Bounce-Meter WPF Windows Application and ETL Excel-XML Library Technologies: WPF, C#.NET and MVVC Architecture Application Development, Excel, Access, VBA, Data Analytics and Intelligence Report Generation using Eclipse IDE, PyDev Plug-in, PyUnit and Python Data Stack (Pandas, NumPy, SciPy, Statsmodels, Keras, Matplotlib, scikit-learn Machine Learning, scikit-image, Seaborn, ReportLab, etc.), Design and Developing RESTful API Web Services using Python Flask Microframework, GitHub, etc.
• X Factor Advertising (Jan/2014 – May/2015)
Job Title: Senior MySQL Database Engineer (Consultant) Projects: “SMART Database Management System” and “ETL MySQL-Excel” Technologies: MySQL Database Engineer, Administrator and System GUI Designer, Toad for MySQL, Database objects development, maintenance, optimization, monitoring and tuning including tables, views, indexes, stored procedures, triggers, functions, ETL custom design and development (Excel-to- MySQL, MySQL-to-Excel, etc.), Data Analysis, Migration and Business Intelligence Reports Generation, GitHub, etc.
• Concordia University – Portland Campus (Oct/2013 – Apr/2015) Job Title: Senior Application Developer (Full-time) Projects: “Enterprise Student Identification System” and “ETL Active Directory-XML-JSON” Technologies: Microsoft WCF SOAP and ASP.NET RESTful Web API Web Services, NUnit Test, ASP.NET, C#.NET, MVC Architecture and NUnit Test, GUI Design and Development, .NET Windows Services, .NET Multithreading and Task implementation, WPF, MVVC Architecture Application Development, Microsoft Active Directory, XML, JSON, ColdFusion 10 Components design and development, PHP/MySQL, Database modelling, design and implementation, Data Analysis, Migration and Business Intelligence Reports Generation, SQL Server, T-SQL Stored Procedures, Functions and Triggers, Oracle, PL/SQL, GitHub, etc.
• Correct Tech (Jan/2013 – Dec/2013)
Job Title: Senior Software Engineer (Consultant)
Projects: “Correct Technology System Application” and “ETL SQL Server-Excel” Technologies: Client/Server applications development, VB.NET, C#.NET, NUnit, GUI Design and Development, ASP.NET, MVC Architecture, NUnit Test, Microsoft WCF SOAP and ASP.NET RESTful API Web Services, Data Analytics, Migration and Business Intelligence Report Generation using Excel, VBA and Crystal Reports, Database modelling, design and implementation, SQL Server, SSIS, SRSS, T-SQL Stored Procedures, Functions and Triggers development, Subversion, etc. Page 5 of 7
• Premier Press (Jul/2012 – Oct/2013)
Job Title: Senior Software Engineer (Full-time)
Projects: “Job Ticket Enterprise System” and “ETL HagenOA Progress Database-Excel” Technologies: Client/Server applications development, VB.NET, C#.NET, NUnit Test, GUI Design and Development, WPF, MVVC Application Development, Database modelling, design and implementation, HagenOA/Progress Database and SQL Server, SSIS, SRSS, T-SQL, Stored Procedures, Functions and Triggers development, ASP.NET, MVC Architecture, NUnit Test, Microsoft WCF SOAP and ASP.NET RESTful API Web Services, Business Intelligence Reports Generation using Excel, VBA, Crystal Reports, Subversion, etc.
• PSU Information Technologies Department (Apr/2012 – Jul/2012) Job Title: Senior Software Analyst (Full-time)
Projects: “Enterprise Student Finance System”
Technologies: Java J2EE, Linux, Shell Scripting, Oracle, PL/SQL, SQL Developer, T-SQL Stored Procedures, Functions and Triggers development, Migration and Business Intelligence Reports Generation using MS Excel, VBA and Crystal Reports, Java EE/JUnit, etc.
• Intel Global Language Solutions, IT Flex Services (Oct/2011 – Apr/2012) Job Title: Senior Localization Engineer (Consultant) Projects: “Tizen Pseudo Localization System”
Technologies: Text files data localization and analysis using Python, Eclipse IDE, PyDev, PyUnit for Linux and Windows, Subversion, etc.
• Dynamic Connections (Sep/2011 – Feb/2012)
Job Title: Senior Software Engineer (Consultant)
Technologies: Microsoft Dynamic CRM plug-in development in .NET C#.NET, ASP.NET, MVC, Razor, NUnit Test, GUI Design and Development, Microsoft WCF SOAP and ASP.NET RESTful API Web Services, WPF, MVVC Application Development, Database modelling, design and implementation, SQL Server/MySQL/PostgreSQL database design, development and data migration, SSIS, SRSS, T- SQL Stored Procedures, Functions and Triggers development, System and Unit Tests, Java EE/Junit, Subversion, etc.
• Cranston Machinery (May/2011 – Oct/2011)
Job Title: Senior Software Engineer (Consultant) and “ETL SQL Server-Excel” Technologies: ASP.NET, C#.NET, MVC, Razor, NUnit Test, GUI Design and Development, Microsoft WCF SOAP Web Services, HTML, CSS, JavaScript, JQuery, Database modelling, design and implementation, SQL Server, SSIS, SRSS, T-SQL Stored Procedures, Functions and Triggers development, MS Access, AJAX Control Toolkit, Telerik ASP.NET AJAX controls, Data Analytics, Migration and Business Intelligence Reports Generation using MS Excel, VBA and Crystal Reports, Subversion, etc.
• Daverci (Jan/2011 – Nov/2011)
Job Title: Senior Software Engineer (Full-time)
Technologies: Client/Server/Win Forms applications development, C#.NET, NUnit Test, WPF, MVVC Application Development, GUI Design and Development, Microsoft WCF SOAP Web Services, EDI/Healthcare electronic sub-systems for Business Partners (nursing home-pharmacy), HL7 Interface, Database modelling, design and implementation, Data Analysis, Migration and Business Intelligence Reports Generation using Data Analytics with Python, Eclipse IDE, PyDev, PyUnit, Pandas, NumPy, SciPy, IPython, Matplotlib and MS Excel, VBA and Crystal Reports, SQL Server, SSIS, SRSS, T-SQL Stored Procedures, Functions and Triggers development, Subversion, etc.
• Concordia University - Portland Campus (Oct/2010 – May/2011) Job Title: Senior Software Engineer (Consultant)
Page 6 of 7
Technologies: Windows Services, C#.NET, NUnit, GUI Design and Development, Microsoft Active Directory, ColdFusion 10 Components design and development, SQL Server, T-SQL Stored Procedures, Functions and Triggers development, Subversion, etc.
• Professional Real Estate Appraisal (Jan/2010 – Oct/2010) Job Title: Senior Software Engineer (Consultant)
Technologies: WPF, C#.NET, MVVC Application Development, ASP.NET Web Forms, GUI Design and Development, Microsoft WCF SOAP Web Services, Database modelling, design and implementation, MySQL, ETL custom design and development (txt-to-MySQL-to-Excel), Crystal Reports, Visio for Enterprise Architects, 3-tiers architecture design and development (GUI, Business Logic and Database Objects), Data Analytics using Python, Eclipse IDE, PyDev, PyUnit, Pandas, NumPy, SciPy, IPython/Matplotlib, Migration and Business Intelligence Reports Generation and MS Excel/VBA/Crystal Reports, Subversion, etc.
• Multiple Choice Modeling (Feb/2009 – Dec/2009)
Job Title: Senior Software Engineer (Consultant)
Technologies: WPF, C#.NET, MVVC Application Development, ASP.NET Web Forms, GUI Design and Development, WCF SOAP Web Services, ETL custom design and development (Excel-to-MySQL, MySQL-to-Excel), Crystal Reports 11, Visio 2007 for Enterprise Architects, 3-tiers architecture design and development (GUI, Business Logic and Database Objects), Data Analytics and Business Intelligence Reports Generation with Excel, VBA and Crystal Reports, Subversion, etc.
• Visual WWW, Inc. (Jan/2000 – Current)
Consulting Part-time Company
Technologies: Business application development for selected clients at nights and weekends TEACHING EXPERIENCE
College: University of the People
Position: Adjunct Information Technology Instructor (online) Date: Oct/2015 – Current
Courses: CS 1101: Programming Fundamentals
Technologies: Python Programming Language, Eclipse IDE, PyDev plugin, PyUnit, GitHub, etc. College: Concordia University, Oregon Campus
Position: Adjunct Business Statistics Instructor (onground/online) Date: Aug/2009 – Current
Courses: Quantitative Methods and Analysis, Quantitative Methods for Managers Research:
• “Adjustment Appraisers Tools and Business Intelligent using Multiple Regression Analysis” (Multiple Regression Analysis, Chi-Square Test, t-Test and ANOVA)
• “Math Statistic Simulator for Multiple Choice Modeling” (MS Excel, VS.NET and Multiple Regression Analysis)
Tutoring:
• Math Statistics Tutor for Chad R. Towe, Ph.D. student of Department of Educational Methodology, Policy and Leadership, University of Oregon. Thesis title: “HISPANIC STUDENT ‘S CONNECTION TO SCHOOL: THE RELATIONSHIP BETWEEN EXTRACURRICULAR PARTICIPATION AND GRADE POINT AVERAGE”, 2010
Course Creation: Designed, developed and taught the CU Business Stats Online Course Technologies: MS Excel, PHStat2, Minitab, IBM SPSS College: University of Phoenix, Oregon Campus
Page 7 of 7
Position: Adjunct Information Technology Instructor (onground/online) Date: Feb/2001 – Jun/2013
Courses: Computer Programming (VB.NET, Java, SQL, ASP, PHP, etc.), Database Design and Development
(Access, SQL Server, MySQL, etc.), Statistics Research and Evaluation (MS Excel, MegaStat add-in, PHStat2 add-in, etc.)
Research:
• “The Relationship between IT Multiple-choice Students Assessments and Grade Point Average”
(Multiple Regression Analysis, Chi-Square Test, t-Test and ANOVA)
• “StatPro Add-in for MS Excel Design and Development” Technologies: MS Excel, MegaStat, Minitab, IBM SPSS College: Superior Polytechnic Institute of Havana, Research Centre of Microelectronic, Cuba Position: Instructor/Microelectronic Researcher (onground), Date: Sep/1987 – Jun/1990
Courses: Basic Electronic, Math Statistics Modeling “Quantitative Methods Design and Analysis of Multi- Factor Experiments” applied to Microelectronic Technologies Research:
• “Statistical Design and Analysis of Microelectronic Technological Process” (multi-factor design of experiments, linear and multiple regression analysis for multi-factor experiments, data mining, sampling, t-Test and ANOVA)
Software: DAME Statistics Software (Design and Analysis of Multi-Factor Experiments) College: National Technical University of Ukraine, Kiev Position: Ph.D. Student-Instructor (Part-time/onground) Date: Sep/1986 – Jun/1987
Courses: Engineering Statistics Labs “Quantitative Methods Design and Analysis of Multi-Factor Experiments” Research:
• “Statistical Design and Analysis of Microelectronic Technological Process” (multi-factor design of experiments, linear and multiple regression analysis for multi-factor experiments, data mining, sampling, t-Test and ANOVA, etc.)
Software: DAME Statistics Software (Design and Analysis of Multi-Factor Experiments).