SUMMARY:

Expert in use of relational technology to solve knowledge management graph problems. Extensive experience in solving large complex IT problems in healthcare, telecommunications, manufacturing, project management, process management, product management, personnel management, education, and computer - aided engineering. Use of NLP to ontologically classify underlying structured and unstructured data into millions of categories. World leader in transitive closure algorithms to provide powerful graph navigation and knowledge inference capabilities on these ontologies in relational databases, enabling powerful data mining, statistical analysis, and Google-like query capability. These technology achievements enabled a potential 10,000x reduction in R&D time.

TECHNICAL SKILLS:

Skills: MS SQL, SQL, T-SQL, Triggers, Stored Procedures, User-Defined Functions, Common Table Expressions, VB.Net, C#.Net, ASP.Net, ETL, SSIS, SSAS, SSRS, SQL Service Broker, SQL Job Agent, C++, C, Oracle, MySQL, Ingres, HTML, DHTML, CSS, JQuery, XML, JSON, SOAP, XML Web Services, REST, Javascript, Unix, Shell, UMLS, Metathesaurus, Semantic Network, Ontologies, NLP, TFS, Waterfall and Agile SDLC methodologies, EDI, EDI 850, XSLT, GitHub, ERP.

WORK EXPERIENCE DETAILS:

Confidential

Senior SQL Developer

Responsibilities:

• Implementation featured creation of an EDI database, extraction of EDI 850 XML documents from SPS Commerce, use of XSLT style sheets to flatten the XML documents, loading of the flattened XML documents into source data warehouse tables, and execution of SSIS ETL packages to map the source data to target data warehouse tables.
• Target data warehouse tables served as source to 5 ERP systems.
• System replaced the manual work of 12 customer service representatives.
• Designed and implemented EAI database.
• Database featured ability to query data generated from process steps executed in the population of target data warehouse tables.
• Process data included SQL Job agent tasks, task steps, SSIS packages, stored procedures called within SSIS packages, tables populated via stored procedure execution, columns and indexes associated with populated tables.

Confidential

Senior Developer

Responsibilities:

• Worked remotely as a consultant to United Airline on a project providing workstation provisioning.
• Project architecture featured use of SQL Server stored procedures, SQL Service Broker, and SQL Job Agent.
• Developed messaging system that provided the ability to capture all possible messages associated with a process and to use those messages to drive both the run-time response to error conditions encountered and to automatically generate documentation of the run time system.
• In conjunction with the messaging system, I developed a sophisticated automatic regression test system that featured ability to automatically generate test scripts covering the full set of parameter value permutations of the run time system and the ability to use those to regression test the system whenever software changes were made to the system.

Confidential

SSIS Developer/Designer

Responsibilities:

• Developed SSIS packages that mapped data from Oracle and SQL Server transactional and reference systems to a data warehouse that served as the input source to an Anaplan budgeting system.
• Technologies included SSIS, C#, and T-SQL. Packages featured sophisticated audit, balance, and control modules to track which packages were currently running, when a package last successfully executed, how many records were inserted or updated from a given task, executed, whether the actual results matched the expected results, etc.

Confidential

Lead Developer

Responsibilities:

• Developed Park Street’s Ontx knowledge modeling system used extensively today by major hospitals.
• Ontx consists of award-winning/patent-receiving SQL-based graph management software.
• Extensive use of JavaScript, ASP.Net, VB.Net, T-SQL stored procedures, user-defined functions, common table expressions, triggers, and CLR functions were used to develop a library of sophisticated XML web services for managing ontology-graph-based knowledge models.
• These ontologies enable powerful and sophisticated subsumption, inference, polymorphic, and path queries that drive Park Street’s clinical query, business intelligence, and analytics capabilities.
• Developed the full set of AHRQ quality measures used by all Park Street healthcare customers.

Confidential

Lead Developer

Responsibilities:

• The ability to directly support OOP using relational technology has been the holy grail of the relational database industry.
• Confidential removes the need for object-relational mapping (ORM) technologies such as Hibernate and removes the need for competing technologies such as NoSQL and graph databases.
• Use of Confidential has demonstrated a 100x reductionin software maintenanceand 1000x reduction in data storecomplexity.
• Developed a system that supports personnel, process, project, product, portfolio, and program management.
• System utilized DHTML, JavaScript, VB6.0, COM+, IIS, and RDS and featured the automated generation of task network project plans from high-level process descriptions using Confidential technology.

Confidential

Senior Software Architect

Responsibilities:

• Developed graph algorithms that resulted in 5 patents.
• Lead architect of process/project management system used to track the development of multiple large telecommunications projects.
• This system used Unix, C and Ingres (pre PostgreSQL) database technologies. esigned client/server database reporting architecture that supported subscription to reports.
• System produced SGML, HTML, Postscript, and ASCII reports launched automatically from a WEB browser.
• Developed an automated regression testing system using C and Shell.
• System algorithmically determined appropriate feature test sets.
• Responsible for coordinating all system testing activities for my organization.
• Co-developed/maintained a large C++ application that mapped a high-level declarative programming language into C modules that maintained data integrity of a large relational telecommunications database.
• Designed a declarative/procedural CAE/CAD database programming language and implemented a corresponding language interpreter written in C.
• The programming language featured the ability to store SQL-like query results into data structures and to perform arithmetic, relational, and boolean operations on these data structures procedurally through sequential, branch, and loop language constructs.
• Language featured the support of a collection of operators whose syntax and semantics were user-modifiable.
• Interpreter also featured dynamic loading of user-definable operators, support of typeless operands, automated memory management and string manipulation, and support of associative arrays.
• Interpreter implemented operations as a stack architecture.
• Led team in designing the next-generation CAE/CAD system for the entire laboratory.
• Designed and developed a CAE/CAD electronic circuit design paradigm that allowed a designer to define constraints on design tasks using a high-level declarative/procedural database programming language (described above).
• The framework provided a foundation for support of design tradeoff analysis.
• Developed Computer Aided Engineering (CAE) circuit pack placement and discrete wire prototyping tools in C.
• Tools featured interactive and automated graphical placement of circuit devices onto circuit packs through the implementation of a bounding rectangle algorithm that minimized wiring length of net connections.
• Inventor of a computer based authoring paradigm that featured the automated construction of electronic books from a high-level BNF-grammar instructional strategy and table of contents descriptions. Paradigm featured distributed knowledge content reusable in multiple contexts.
• Electronic books featured interactive text, graphics, audio, video, and simulation multimedia objects.
• Designed and implemented runtime multimedia object placement algorithms for electronic books (before internet browsers existed).
• Designed runtime system features written in platform-independent GUI.