Supported and enhanced Python/Pandas in legacy codebase. Introduced standardized logging to daily data sync process for the Enterprise Risk Model Inventory. Leveraged PDF DataMiner to identify and extract target datasets as Pandas DataFrames from PDF Risk Model Validation reports. Implemented automatic generation of custom formatted HTML documentation from existing codebase NumPyDoc docstrings using Sphinx AutoAPI with ReadTheDocs theme. Added TypeHints and converted docstrings in mission critical CRO Reporting tool to NumpyDoc format. Mentored staff on Python basics, core idioms, and best practices in “The Joy of Python”, a recurring Zoom call 2-3x week.

Created ‘Sees OpEx’, an internal Budget Planning app for OpEx that allowed management staff to request budget line items and receive requisite approvals by upper management. The app supported periodic loading of line-item level payment actuals from G/L Journal data. It also allowed for line-item budget re-estimation throughout the active budget year. I acted as defacto BA, PM, and Lead Back End Python/Django developer on this project during the first year and a half of development.

Worked on Bank of America’s Cloud Service & Reliability Engineering team, performing problem resolution and development of reporting for the BofA Cloud Dashboard. Data was maintained in a large ElasticSearch cluster. Designed and developed automated scripts to periodically load consolidated cloud VM build info from upstream data sources (micro service APIs, relational DBs, and ElasticSearch indices). I concurrently developed ez-ElasticSearch, a Python package that implements a simplified API (using elasticsearch-py, pandasticsearch, and pandas internally) for developing python apps that access ES. This module abstracts the underlying 3rd-party package functionality with an API that made it easy for the novice ES developers on our team to quickly exploit the ES data management API with only a limited understanding of ES concepts and proprietary language syntax.

Responsible for porting Django web sites maintained by the university’s Emerging Technology and Web Services group from Django v1.2-3 to v1.11 LTS and from Python v2.7 to v3.6. A total of 7 sites were ported and validated during the first 3 months of the contract.

Assessed defects in client’s NoviaPwr Scheduling and EMR offering. The product codebase was built upon the J2EE-based Tolven open source EMR framework with numerous customizations. Due to pre-existing coding/build/deploy issues and lack of in-house Java development support, client was unable to extract patient EMRs from the underlying Postgres DB. Proposed several approaches to extracting and decrypting the unreadable patient records. Worked to develop a stand-alone Python script to perform DB extraction and decryption of the stored patient EMR documents.

Developed a re-usable RegW Compliance Tracking and Affirmation library in Python for the Corporate Treasury Global Funding IT group. I leveraged this library to integrate Reg W compliance and affirmation support into the FX Derivatives blotter and trade entry component of the bank’s strategic QzFunding Desktop application. From the beginning of 2015, I worked as a member of the QzFunding FX Derivatives development team, fixing defects and implementing new functionality, as required. During this period, I designed and developed a highly maintainable and easy to use Books Administration Tool that completely automated the setup of Trading and Customer Books used in the tracking of FX Derivatives trading activity for the QzFunding Desktop application.All development was done in Python 2.7, using the bank's proprietary Quartz enterprise development framework. An Agile development methodology was followed.

As a member of the Global Risk development team, implemented a system for applying manual month-end accounting adjustments from disparate external source systems to consolidated risk data maintained in the Netezza-based global risk data warehouse. This app supported both manual adjustment through a GUI and batch adjustment via a background import process.As part of an internal DB QA effort, built the SQL Testing and Automation Resource (STAR) system for scheduled/on-demand comparison of SQL query results. This tool was used by various teams within the bank to validate synchronization of data loads and DB schema changes between DB environments (i.e. staging vs. production), sanity metrics after daily loads of external system data feed rows, etc.Contributed a significant Quartz core DB API enhancement that implemented seamless automatic DB connection pool recovery after disconnection due to DB server timeout or temporary network/service outage. The code to be modified was part of the common Quartz core qztable_dbapi module used daily in production by numerous project teams across the bank, so extreme scrutiny was applied by the Quartz core team during the lengthy code review and approval process prior to pushing the fix to production.All work was done in Python 2.7, using the bank's proprietary Quartz enterprise development framework.

Worked on-site at Bank of America, as part of the Corp Treasury Debt Capital and Hedge Management trading floor support team in uptown Charlotte, NC. I was tasked with the conversion end validation of MS Excel workbooks from 32-bit Office 2007 to the 64-bit Office 2010 environment. This work involved creation of VBA macros in MS Excel (both 2007 32-bit and 2010 64-bit) for the actual workbook conversion. Python 2.7 was utilized, via the bank’s proprietary Quartz development framework, for the development of ad-hoc inventory and assessment tools.* Created an Excel workbook inventory process in Python to identify the production workbooks in daily use by the DCHM traders and determine their prioritization within the conversion task.* Assessed technical issues and identified potential migration problems across all DCHM workbooks.* Suggested approaches to problem mitigation, where possible.* Resolved problems by providing detailed technical proofs of concept in the 64-bit environment, where required.* Validated the Oracle 11g native RDMS client for 64-bit Win 7 installation, configuration, data retrieval and update capabilities.* Developed a simplified RDBMS access module in VBA for use in the 64-bit Excel environment. This module exploited the connection pooling and parameterized query capabilities of the Oracle 11g native client via VBA’s ADO API in order to improve DB access performance.

Worked independently to develop the Badger EDI (BEDI) e-Commerce framework; this system managed X12 EDI transaction processing, tracking, and response generation. The fully automated batch solution leveraged the functionality of an open-source Data Transformation Framework (BOTS), written in Python, which was then integrated with a custom-built data mapping framework to meet the varied and complex requirements of our EDI-enabled customer base. The BOTS framework provided a basic EDI administrative interface (using Python/Django) which was heavily modified to support our in-house tracking and reporting needs. * Developed and maintained versions 1.0 through 2.1 of the BEDI framework codebase.* Deployed and maintained websites in a LAMP environment using Python, Django, SQLite 3.7, and access via ODBC (Progress Connect64 ODBC SQL Server driver for Linux) to the MS SQL Server 8 RDBMS used by our legacy back-office MRP system.* Setup and maintained Python/Java/SQL Server development environment utilizing the Eclipse IDE and various development plug-ins.* Setup and maintain IT Trac Wiki and Subversion VCS to support a ticket-based development process workflow.* Assisted in solution design and planning sessions for other IT apps.* Created custom ETL/Reporting solutions for executive staff.* Assisted in day-to-day IT support activities.

Full life cycle software development. Linux system administration. Plone site build-out and deployment. Python and Plone development. LAMP/PHP site development and maintenance.* Performed Linux system build-outs, updates, and configurations.* Standardized clustered Plone site build-outs and configurations for ease of management..* Implemented system-wide daily backup process. Installed and configured distributed BRU Backup system.* Implemented system-wide monitoring application using Nagios* Managed off-shore development project* Developed, deployed and maintained websites in LAMP/Python/Plone CMS environments* Developed doc inheritance infrastructure in LaTeX.* Coded doc processing apps in Python.Training: Attended Python/Plone BootCamp and Advanced Python/Plone BootCamp in Fall 2008 at UNC-CH.

Maintained web application which tracked and managed cable sub-contractor service installations, maintenance, and contract compliance. * Optimized SQL queries/RDBMS scheme for best performance.* Created custom reporting solutions. Performed data mining using tsearch2 module to identify erroneous data.

Observa2 Reporting Subsystem suffered from performance/reliability issues. Reviewed alternative open source reporting engines. Identified performance and stability enhancement solutions. Maintained reporting templates/code. * Profiled reporting subsystem to assess extent of memory utilization and scalability problems. * Ported core reporting engine from version 6.5 to 8.0 (at suggestion of vendor). * Reduced overall memory footprint through identification and resolution of application memory leaks. * Designed and implemented multi-threaded report serialization solution to limit memory utilization and increase scalability.* Designed and documented an Electronic Signatures module for Observa3 product.

Consulting, Install, Analysis, Architecture, Software Design and Development, Functional Testing, Documentation. * Collected requirements and created functional specs for installation of Opsware product. * Implemented multi-platform installer for Opsware distributed configuration management application.

Maintained a dynamic, data-driven web site for remote calibration of environmental testing instruments. * Performed query optimization and tuning. * Provided crisis management support and leadership in hiring, project management, and management of client expectations. * Performed website code fixes, upgrades and testing. * Developed a prototype hospital equipment tracking system using RFID technology.

Reporting Software Development Tech Lead. Software product collected real-time data from biometric instruments that performed Organism Identification and Antibiotic Susceptibility Testing of human/industrial test samples. As Lead Developer for reporting I was responsible for development of all custom data reports. * Selection and integration of a Reporting Subsystem for a Centralized Data Management workstation that utilized a non-standard object database storage paradigm (non-RDBMS).* Development and verification of key Organism ID and AST Reports. * Performed all development within an Agile XP development environment. * Maintained compliance with all CFR 21 Part 11 FDA regulations.

Gathered requirements, designed, developed and tested various on-line credit card application websites in Java using Servlet and J2EE technology.* Migrated flat file based code to utilize Oracle DB storage solution. * Developed and executed test plans to assess scalability by profiling end-to-end (HTTP to DB update) transaction metrics under differing server loading conditions. * Developed concurrent HTTP agents capable of executing custom client interaction scripts to simulate load and stress the server(s) per test plans. * Improved performance and scalability of MBNA online application system. * Designed and coded J2EE-like services to support DB connection pooling and server clustering in a servlet-based (pre-J2EE) environment. * Ported on-line application systems from a servlet-based container to a J2EE compliant container. * Implemented a DB utility in Java to support automated batch table (ETL) data updates.* Designed and developed a batch job execution manager to serialize back-end processing. * Designed and developed form management infrastructure packages to support simplified creation and deployment of online Credit Card application sites. * Packages supported secure access, stateful session management, and encrypted data storage. * Designed a Radiology client-server workflow solution for use in a Radiology web portal.

* Overall responsibility for requirements gathering and business object model design and review.* Architected N-tiered information system solutions.* Led a technical team of 10 developers in implementation and delivery of SupplyNET, a pharmaceutical cost/interchange based analytic tool that could be used to generate cost-idealized Hospital Formularies based on annual wholesale purchasing contract provisions and historical dispensing patterns.* Created information system solutions to support streamlining of business processes and overall cost reduction. * Created reusable business object models (class libraries) for the Healthcare, Insurance Payor, Contracts, and Billing domains.* Designed and built an automated tool to generate persistence scheme metadata (for our custom ORM) from BOM design definitions.* Designed and built a Smart Medical Billing System (MBS) for hospitals and professional providers. This system provided an innovative Bill Explanation Facility that would generate an English language description detailing why the payor/guarantor was being charged the fees that appeared on the bill, whether based on payor (insurance) rules or managed care contract provisions.* Designed and led a team in building Hospital Information Management System (HIMS) and EMR implementations that integrated with our Smart MBS.* Designed and built a Contract Editor to capture legal contract provisions used for managed care scenario identification, repricing, and billing.* Designed and built a system for predictive modeling and evaluation of wholesale supply contracts in the context of a hospital’s historical pattern of consumption.* Created materials and taught courses in "Object Oriented Design and Programming in Smalltalk" and "Programming with IBM’s System Object Model (SOM) for OS/2".

IBM joint research project to explore high bandwidth commercial internet applications. * Responsible for recruiting and leading the team that developed the client-side GUI applications that displayed stored media to students at the university. * This programming was all done on OS/2 in Smalltalk, one of the first commercially available Object Oriented programming languages.

During my time at the center, I worked on these projects:* Feature Based Pattern Recognition in Manufacturing (USAF): This was an effort to design Neural Networks that could classify part design features and enable queries against an existing DB of airplane part designs. It was hoped that this would reduce the cost of new part design efforts by allowing the designer to start from a working design that exhibited characteristics similar to the new part to be manufactured.* Explored modifications to Neural Network topology/parameters/links/layers to reduce network training time.* Power Grid Fault Detection: PhD thesis of Dr. Dejan Sobajic. Research in applying Neural Networks to perform 'a priori' fault detection in large power grids. I ported a Power Network simulation program from Fortran to C, enhancing performance and maintainability.

Various commercial projects at AIWare to apply AIExpert Neural Networks product to real-world manufacturing and control problems.