Sheldon Linker, ISAM Developer in Irvine, CA, United States
Sheldon Linker

ISAM Developer in Irvine, CA, United States

Member since June 14, 2020
Dr. Linker has been doing consulting/contract programming (and other job functions) for decades. He has specialized in database work since 1978. His doctoral work involved AI and knowledge bases. He is also adept at programming servers, client systems, desktop systems, embedded systems, and a number of other types of systems. He has served in a database, programming, business analyst, and project management capacity. He currently teaches the latter two at the University of Maryland online.
Sheldon is now available for hire

Portfolio

  • University of Maryland
    Quality Assurance (QA), Performance Tuning, Cron, KornShell...
  • Freelance
    Quality Assurance (QA), Data Cleaning, Data Cleansing, Big Data, Oracle DBA...
  • The PIASC
    .NET, Borland C, C++, C#, Oracle, SQL Server 2017, Windows, HTML, CSS, ASPX...

Experience

Location

Irvine, CA, United States

Availability

Part-time

Preferred Environment

Mainframe, Embedded Systems, Win32, .NET, Windows, Java, C++, Linux, Unix, SQL

The most amazing...

...project I've worked on was the Strategic Defense Initiative; I optimized a message-passing system, allowing throughput to enable taking out an incoming ICBM.

Employment

  • Adjunct Professor

    2016 - PRESENT
    University of Maryland
    • Taught students project management and operational techniques involving requirements gathering, requirements writing, choosing a project methodology, and QA.
    • Helped to write and improve new textbooks currently in use.
    • Helped to update the curriculum (currently under review for use next year).
    Technologies: Quality Assurance (QA), Performance Tuning, Cron, KornShell, Writing & Editing, Lecturing, Management, Analytical Thinking, Debugging, Code Architecture, Business Analysis, Shell Scripting, Project Management, Unix, Microsoft Excel, Architecture, Technical Instruction, C, Linux, Assembly, Business Intelligence (BI), Reporting, Reports, Software QA, SDKs, Business Logic, Business Rules, Business Process Analysis, Analysis, Consulting, Agile, Waterfall Methodology, ANSI C
  • Full-stack/Desktop/Embedded Developer

    1984 - PRESENT
    Freelance
    • Vastly improved the operational speed and normalization of databases for a number of clients.
    • Simplified the amount of code in use (and the time taken) by a number of clients' applications through rewriting and refactoring of code.
    • Improved system design resulting in shorter and clearer message flows and business processes.
    • Managed projects, sometimes from the onset, and sometimes from the point of original failure to successful completion.
    • Brought clients' website ideas from original sketches to finished websites, boxed products, and embedded products.
    • Closed security holes for a number of clients, including insurance and banking endeavors.
    • Helped in the transition from one system to another, such as SQL Server to Oracle and DB/2, from Borland C to C#, and from Amiga to Mac, Windows, and SGI.
    • Found and fixed a number of bugs for a variety of clients.
    Technologies: Quality Assurance (QA), Data Cleaning, Data Cleansing, Big Data, Oracle DBA, Enterprise, Performance Tuning, SDKs, Indexing, BI Reporting, ETL Development, Analysis, Business Process Analysis, Business Rules, Business Logic, T-SQL, POSIX, Embedded C++, Embedded C, RESTful Development, RESTful APIs, REST APIs, Data, Analytics, Hibernate, SSRS, Cron, Pascal, KornShell, Prolog, SSRS Reports, Software QA, ASPX, REST, z/OS, Acceptance Test-driven Development (ATDD), JCL, AS/400, Kofax, Data Visualization, Data Migration, Writing & Editing, Database Analytics, Data Engineering, APIs, Oracle 12c, PL/I, ETL Implementation & Design, Oracle RDBMS, DB, Column-oriented DBMS, Database Triggers, Stored Procedure, Database Modeling, Management, Yacc, Analytical Thinking, Master Data, Data Aggregation, Reports, Modeling, Debugging, Code Architecture, Complex Data Analysis, Data Quality Analysis, Triggers, Relational Database Services (RDS), Relational Database Design, Relational Data Mapping, Stored Procedures, Query Optimization, Database Table Optimization, Data Architecture, Database Optimization, Data Analysis, Data Modeling, Reporting, Business Analysis, ISAM, Shell Scripting, SQL Server Reporting Services (SSRS), Python, Node.js, Teradata Databases, Teradata, Test-driven Development (TDD), NoSQL, Visual Basic for Applications (VBA), Project Management, Machine Learning, Data Analytics, Artificial Intelligence (AI), PostgreSQL, MySQL, Visual Basic .NET (VB.NET), JSP, Web Architecture, API Architecture, Microsoft Access, Visual Basic, Business Intelligence (BI), Microsoft Excel, Data Warehouse Design, Data Warehousing, PHP, SQL Server Integration Services (SSIS), SQL Server 2014, Microsoft SQL Server, ETL, IBM Db2, Oracle SQL, Oracle, Oracle PL/SQL, SQL Architecture, Database Management Systems (DBMS), Oracle DBMS, SQL Triggers, Database Transactions, Relational Databases, Transact-SQL, SQL Stored Procedures, Database Architecture, Database Design, Databases, PL/SQL, C, Data Profiling, Data Reporting, JavaScript, HTML, Fortran, CSS, Crystal, COBOL, C#, C++, BASIC, Assembly, ASP, APL, Architecture, Financial Reporting Dashboards, Financial Reports, CSV File Processing, Database Development, Consulting, Oracle SQL Data Modeler, SQL Server 2017, Database Performance, Database Schema Design, Waterfall Methodology, Agile, SQL, Linux, Windows, Unix, .NET, Mainframe, Win32, Borland C, Pro*C, DB/2, SQL Server 2010, JSON, Swing, ANSI SQL, ANSI C, Data Analyst
  • Programmer/developer/designer

    2002 - 2020
    The PIASC
    • Redesigned their database (and communication with the database) for speed and accuracy.
    • Sped up many of their reports and batch processes, for instance, changed their accounting run from 25 hours to less than an hour.
    • Took over and managed their web project, getting the site online, and fully integrated with their desktop applications, fixing security flaws in the process.
    • Fully automated many manual functions, so that on the programming side, fewer staff were needed, and on the customer representative side, more time could be spend with customers.
    Technologies: .NET, Borland C, C++, C#, Oracle, SQL Server 2017, Windows, HTML, CSS, ASPX, PL/SQL, Kofax, Google, Crystal Reports, Excel VBA, SQL, Data Reporting, Data Profiling, Data Analytics, C, Databases, Database Design, Database Architecture, SQL Stored Procedures, Transact-SQL, Relational Databases, Database Transactions, SQL Triggers, Oracle DBMS, Database Management Systems (DBMS), SQL Architecture, Oracle PL/SQL, Oracle SQL, ETL, Microsoft SQL Server, Data Warehousing, Data Warehouse Design, Microsoft Excel, Business Intelligence (BI), Visual Basic, API Architecture, Web Architecture, Project Management, Visual Basic for Applications (VBA), Business Analysis, Reporting, Data Modeling, Data Analysis, Data Architecture, Database Optimization, Database Table Optimization, Query Optimization, Stored Procedures, Relational Data Mapping, Relational Database Design, Triggers, Data Quality Analysis, Complex Data Analysis, Code Architecture, Debugging, Modeling, Reports, Data Aggregation, Master Data, Analytical Thinking, Management, Database Modeling, Stored Procedure, Database Triggers, Column-oriented DBMS, DB, Oracle RDBMS, Crystal, ETL Implementation & Design, Oracle 12c, APIs, Data Engineering, Database Analytics, REST, Software QA, Win32, Data, REST APIs, RESTful Development, RESTful APIs, SDKs, Business Logic, Business Rules, Business Process Analysis, Analysis, ETL Development, BI Reporting, Performance Tuning, Enterprise, Data Cleansing, Data Cleaning, Quality Assurance (QA), Financial Reporting Dashboards, Financial Reports, CSV File Processing, Database Development, Consulting, Oracle SQL Data Modeler, Database Performance, Database Schema Design, Agile, Waterfall Methodology, SQL Server 2010, Dashboards, SQL Server 2016, ANSI SQL, ANSI C, ANSI X12, ANSI X.12, Data Analyst
  • Programmer/developer/designer

    2007 - 2017
    Friar Tux Shop
    • Enhanced their web-site and integrated it with their other systems.
    • Enhanced their internal flow, including adding specialty print drivers for "tag" printers.
    • Set up an internal information web-site to help with inventory management and processing.
    Technologies: SQL Server 2015, SQL Server Integration Services (SSIS), T-SQL, Crystal Reports, HTML, VBScript, ASP, Java, SQL, Data Reporting, Data Analytics, C, Windows, Databases, Database Design, Database Architecture, SQL Stored Procedures, Transact-SQL, Relational Databases, Database Transactions, Database Management Systems (DBMS), SQL Architecture, ETL, JavaScript, SQL Server 2014, Microsoft Excel, Business Intelligence (BI), Visual Basic, Web Architecture, Visual Basic .NET (VB.NET), .NET, Visual Basic for Applications (VBA), SQL Server Reporting Services (SSRS), Business Analysis, Reporting, Data Modeling, Data Analysis, Data Architecture, Query Optimization, Stored Procedures, Relational Data Mapping, Relational Database Design, Code Architecture, Debugging, Reports, Data Aggregation, Analytical Thinking, Database Modeling, Stored Procedure, Column-oriented DBMS, DB, REST, Software QA, SSRS Reports, Win32, BASIC, SSRS, Data, REST APIs, RESTful Development, RESTful APIs, SDKs, Business Logic, Business Rules, Business Process Analysis, Analysis, BI Reporting, Quality Assurance (QA), Consulting, SQL Server 2017, Waterfall Methodology, SQL Server 2010, ANSI SQL, Data Analyst
  • Programmer

    2001 - 2016
    Delta Dental Plans Association
    • Sped up some processes as much as 1600x by reworking the algorithms, and by adding code to decide on the best algorithm for a given job.
    • Added a web-site for employers to manage employee elibibility.
    • Added EDI processing so that the system could read transactions in a number of formats.
    • Enhanced their reporting system, so that it could generate a broader range of reports more quickly, and replaced two pages of controls on a complicated report generator to a field that took an English description of what was needed.
    Technologies: AS/400, C, Pro*C, DB/2, RPGLE, iSeries, Crystal Reports, Visual Basic, Java, Windows, EJB, JSP, XML, Microsoft Access, HTML, JavaScript, Visio, UML, SharePoint, Oracle, Data Reporting, Data Profiling, PL/SQL, Databases, Database Design, Database Architecture, SQL Stored Procedures, Relational Databases, Database Transactions, SQL Triggers, Database Management Systems (DBMS), SQL Architecture, IBM Db2, ETL, Data Warehouse Design, Data Warehousing, Business Intelligence (BI), Web Architecture, Visual Basic .NET (VB.NET), Visual Basic for Applications (VBA), SQL Server Reporting Services (SSRS), Reporting, Data Modeling, Data Analysis, Data Architecture, Database Optimization, Database Table Optimization, Query Optimization, Stored Procedures, Relational Data Mapping, Relational Database Design, Triggers, Data Quality Analysis, Complex Data Analysis, Code Architecture, Debugging, Modeling, Reports, Data Aggregation, Master Data, Analytical Thinking, Database Modeling, Stored Procedure, Database Triggers, Column-oriented DBMS, DB, Crystal, ETL Implementation & Design, Oracle 12c, APIs, Database Analytics, REST, Mainframe, Software QA, Win32, BASIC, SSRS, Data, REST APIs, RESTful Development, RESTful APIs, SDKs, Business Logic, Business Rules, Business Process Analysis, Analysis, ETL Development, BI Reporting, Performance Tuning, Enterprise, Data Cleansing, Data Cleaning, Quality Assurance (QA), Financial Reports, CSV File Processing, Database Development, Consulting, Database Performance, Waterfall Methodology, ANSI SQL, ANSI C, ANSI X12, ANSI X.12, Data Analyst
  • Programmer

    2006 - 2008
    Kofax
    • Ported their SQL Server T-SQL code to run on all variants of Oracle's PL/SQL, including the capability for the Kofax system to act as a DBA in the target environment.
    • Ported their SQL Server T-SQL code to run on all variants of IBM's DB/2, including the capability for the Kofax system to act as a DBA in the target environment.
    • Reengineered their SQL Server T-SQL code, to act much faster, and to do its own DBA work to make the database structure much faster.
    Technologies: Visual Basic, C#, .NET, C++, T-SQL, SQL Server 2010, Oracle, PL/SQL, DB/2, Unix, Linux, Windows, z/OS, SQL, Databases, Database Design, Database Architecture, SQL Stored Procedures, Transact-SQL, Relational Databases, Database Transactions, Oracle DBMS, Database Management Systems (DBMS), SQL Architecture, Oracle PL/SQL, Oracle SQL, IBM Db2, Microsoft SQL Server, SQL Server 2014, Business Intelligence (BI), Database Optimization, Query Optimization, Stored Procedures, Relational Data Mapping, Data Quality Analysis, Code Architecture, Debugging, Analytical Thinking, Stored Procedure, Column-oriented DBMS, DB, Oracle RDBMS, ETL Implementation & Design, Oracle 12c, Kofax, Mainframe, Software QA, Win32, Data, SDKs, Business Logic, Business Rules, ETL Development, Performance Tuning, Data Cleansing, Data Cleaning, Quality Assurance (QA), Database Development, Database Performance, Agile, Waterfall Methodology, ANSI SQL
  • QA/Programmer

    2006 - 2006
    DIRECTV
    • Found a number of bugs and documented them as a QA tech. Switched to a programmer role and fixed those that had not yet been fixed.
    • Added channel-hopping and compression related features, so that older satellites could be retired without replacement.
    • Added an extension to the file system so that rolling-buffer files could be used with raw open/read/write/tell/seek/close calls.
    Technologies: C, C++, Java, Java Native Interface (JNI), XML, Shell Scripting, Linux, HTML, SOAP, UML, Relational Databases, API Architecture, NoSQL, Code Architecture, Debugging, Analytical Thinking, APIs, REST, Software QA, Data, REST APIs, RESTful Development, RESTful APIs, Business Logic, Business Rules, Quality Assurance (QA), Consulting, ANSI C

Experience

  • JCB™ English and JCB Robotics
    http://linker.com/jcb

    A knowledgebase/AI that can learn, understand, and make intelligent decisions. Additionally, JCB Robotics can reject a command based on safety/morality grounds. You can see my patents by searching on USPTO.gov or go to the product website.

Skills

  • Languages

    APL, Assembly, C, C++, C#, Fortran, HTML, Java, JavaScript, PHP, PL/I, SQL, Crystal, Stored Procedure, Transact-SQL, Embedded C, Embedded C++, T-SQL, ANSI C, Visual Basic, COBOL, CSS, Visual Basic .NET (VB.NET), XML, Pascal, Prolog, Visual Basic for Applications (VBA), Python, BASIC, Excel VBA, VBScript, Pro*C, RPGLE, UML
  • Libraries/APIs

    POSIX, ASPX, Node.js, REST APIs
  • Tools

    Oracle SQL Data Modeler, Borland C, Crystal Reports, Visio, JCL, Microsoft Access, Microsoft Excel, Cron, SSRS
  • Paradigms

    Management, ETL, Database Design, ETL Implementation & Design, Database Development, Agile, Business Intelligence (BI), API Architecture, Web Architecture, Acceptance Test-driven Development (ATDD), REST, Test-driven Development (TDD), RESTful Development
  • Platforms

    Linux, Windows, Oracle, AS/400, z/OS, KornShell, Unix, Win32, SharePoint
  • Storage

    IBM Db2, PL/SQL, Databases, Microsoft SQL Server, Database Architecture, Database Modeling, SQL Server 2014, SQL Server Integration Services (SSIS), SQL Stored Procedures, Relational Databases, Database Triggers, Database Transactions, SQL Triggers, Oracle DBMS, Database Management Systems (DBMS), Column-oriented DBMS, SQL Architecture, Oracle PL/SQL, Oracle 12c, Oracle SQL, DB, Oracle RDBMS, SQL Server 2017, Database Performance, SQL Server 2010, SQL Server 2016, ANSI SQL, MySQL, PostgreSQL, JSON, Teradata, Teradata Databases, NoSQL, SQL Server Reporting Services (SSRS), Oracle DBA
  • Other

    Shell Scripting, ISAM, Yacc, Business Analysis, Reporting, Data Modeling, Data Analysis, Data Architecture, Database Optimization, Database Table Optimization, Query Optimization, Stored Procedures, Relational Data Mapping, Relational Database Design, Relational Database Services (RDS), Triggers, Data Reporting, Data Quality Analysis, Data Analytics, Complex Data Analysis, Code Architecture, Debugging, Modeling, Reports, Data Aggregation, Data Profiling, Master Data, Analytical Thinking, Data, SDKs, Business Logic, Business Rules, Business Process Analysis, Analysis, ETL Development, BI Reporting, Indexing, Performance Tuning, Data Cleansing, Data Cleaning, Architecture, CSV File Processing, Consulting, Database Schema Design, Waterfall Methodology, Technical Instruction, SQL Server 2015, DB/2, iSeries, Java Native Interface (JNI), Data Analyst, Kofax, Data Migration, Writing & Editing, Lecturing, Data Warehousing, APIs, Data Warehouse Design, Data Engineering, Database Analytics, Data Visualization, Analytics, Enterprise, Big Data, Quality Assurance (QA), Financial Reporting Dashboards, Financial Reports, EJB, SOAP, Dashboards, ANSI X12, ANSI X.12, Software QA, Artificial Intelligence (AI), Machine Learning, Embedded Systems, Mainframe, SSRS Reports, RESTful APIs, Google
  • Frameworks

    ASP, JSP, Swing, .NET, Hibernate
  • Industry Expertise

    Project Management

Education

  • PhD in Computer Science and Software Engineering
    2008 - 2011
    Auburn University - Auburn, AL
  • Master of Science degree in Computer Science
    2006 - 2008
    University of Illinois - Springfield, IL
  • Bachelor of Science degree in Applied Science and Technology
    2004 - 2006
    Thomas Edison State College - Trenton, NJ
  • Coursework in Electrical Engineering
    1973 - 1977
    University of California - Berkeley and Los Angeles, CA

To view more profiles

Join Toptal
Share it with others