Nicholas Sorrell

The DLL is a cross platform .NET assembly that extracts data from flat files based on a JSON schema file that describes the data, inserts that data into a SQLite database, then validates it based on the constraints described in the file and whatever custom validations are provided. It can also iterate through custom Transformations and can load ad-hoc queries in MSSQL using the datatypes described in the schema file. This all adds up to never having to recompile any code when the flat file… Show more

The DLL is a cross platform .NET assembly that extracts data from flat files based on a JSON schema file that describes the data, inserts that data into a SQLite database, then validates it based on the constraints described in the file and whatever custom validations are provided. It can also iterate through custom Transformations and can load ad-hoc queries in MSSQL using the datatypes described in the schema file. This all adds up to never having to recompile any code when the flat file format changes - simply change JSON schema file.

The interactive CLI exposes the custom .NET functions that, among other useful things, check data typing and expose ROW_NUMBER functionality to the SQLite database. It also features command history and word completion. Show less

Microsoft Word has its own dialect of regex, and has no capability to proximity search - but that's all solved with the release of Wordiscover, an addin for Microsoft Word. Regular Expression Find/Replace, Proximity search and Not-in-Proximity search make this the best tool for thoroughly searching your documents!

Some of the interesting challenges this project brought were creating scrollable panes like the native ones (https://github.com/sorrell/PanelScrollControl), creating an… Show more

Microsoft Word has its own dialect of regex, and has no capability to proximity search - but that's all solved with the release of Wordiscover, an addin for Microsoft Word. Regular Expression Find/Replace, Proximity search and Not-in-Proximity search make this the best tool for thoroughly searching your documents!

Some of the interesting challenges this project brought were creating scrollable panes like the native ones (https://github.com/sorrell/PanelScrollControl), creating an algorithm to perform the proximity search, and learning the in's and out's of async programming in C#. Show less

Working with a client to unify reporting of contractual data through a single format and interface. This project has involved:

- Working closely with stakeholders to capture business requirements
- Working with accounting staff to capture technical requirements
- Managing project's scope and implementation
- Integration with other databases and general ledger
- Building data landing areas, ETL pipelines (BIML/SSIS), databases (MSSQL), client/server architecture… Show more

Working with a client to unify reporting of contractual data through a single format and interface. This project has involved:

- Working closely with stakeholders to capture business requirements
- Working with accounting staff to capture technical requirements
- Managing project's scope and implementation
- Integration with other databases and general ledger
- Building data landing areas, ETL pipelines (BIML/SSIS), databases (MSSQL), client/server architecture (.NET/C#)
- Employing standard software development best practices:
+ Agile PM
+ Versioned source for all elements of data pipelines
+ Automated unit/integration testing
+ Thorough documentation - from requirements to code
+ Full view of requirement lifecycle: from written requirement, to spec doc, to case creation, to code commit and code review (FogBugz offers an outstanding solution here)
Show less

Shair was a college project that envisioned a future of social area networking. The project was not continued after its college deadline.

Shair's functionality is to provide a secure, personal cloud that extends file sharing to social networks. This was done by allowing a user to login to Facebook via Shair, and allow friends to download/upload files to directories. User based file permissions were implemented, as well as DH handshakes and AES encryption. My responsibilities in the… Show more

Shair was a college project that envisioned a future of social area networking. The project was not continued after its college deadline.

Shair's functionality is to provide a secure, personal cloud that extends file sharing to social networks. This was done by allowing a user to login to Facebook via Shair, and allow friends to download/upload files to directories. User based file permissions were implemented, as well as DH handshakes and AES encryption. My responsibilities in the project are provided below.

: Co-developed software architecture
: Leveraged C++, Qt and Botan (encryption library) to create secure connections between peers that relied on Diffie-Hellman handshakes, AES elliptic curve authenticated encryption, and user authentication via public key challenges
: Integrated Facebook’s OAuth capability into Shair by using Facebook’s PHP library and utilizing Qt WebViews
: Implemented established design patterns, took advantage of Qt’s signal/slot mechanisms, and helped design GUI
: Provided devops support - creating and maintaining Git repos, SSH credentials, Linux VMs, project website, and application credentialing website Show less

Worked with a third party logistics (3PL) brokerage to launch their operational tranportation management software (TMS) and managed the development side of their accounting migration from QuickBooks to Intacct. Both systems had to be migrated/launched in tandem, as their previous TMS software integrated directly with QuickBooks and the new software integrates with Intacct. We had a successful go-live, which included the migration of over 120 million data points, and experienced minimal… Show more

Worked with a third party logistics (3PL) brokerage to launch their operational tranportation management software (TMS) and managed the development side of their accounting migration from QuickBooks to Intacct. Both systems had to be migrated/launched in tandem, as their previous TMS software integrated directly with QuickBooks and the new software integrates with Intacct. We had a successful go-live, which included the migration of over 120 million data points, and experienced minimal downtime in core operational departments during the week of the launch.

TMS Development:
- Managed team of 5 + 1 contractor, coordinated all project priorities, deadlines, user testing, project scope, and created go-live plan and documentation
- Implemented version control (Git, Gitlab), issue management (Fogbugz/Gitlab), coding standards, code reviews, and config management (Vagrant/Docker)
- Created QA dept. and gave Dev/QA distinct and respected places in the organization
- Retained a key software developer, hired 2 other devs, 1 QA lead, restarted co-op spot in department
- Coorindated dev of custom web-based automated testing framework (Node, NightwatchJS)
- Created online portal and hiring process/screening for development which tested candidate aptitude within job description (as opposed to previously used general aptitude tests)
- Communicated project health and needs to company ownership and management
- Coordinated and ensured seamless migration and mapping of 4+ years of company data from previous TMS system

Accounting Migration Project:
- Managed data migration by eliminating a manual and unwieldy data extract from QuickBooks GUI and replacing it with a SQL Server-ODBC based connection to the company file, ensuring repeatable, reliable data extracts from the company file
- Worked directly with the accounting team to model data, capture business processes, and ensure all necessary data was migrated
- Migrated 7 years worth of company data, tying out to the penny Show less

In 2009, the Cincinnati Fire Department had data reporting issues. As companies began migrating their daily work logs from paper to spreadsheets, firefighters found themselves overwhelmed with a multitude of disparate spreadsheets that were redundant, not maintained, and often allowed users to corrupt data with a form of backup.

Since the fire department members were already familiar with Excel, the solution was to stay with the familiar while packaging a lot more functionality into the… Show more

In 2009, the Cincinnati Fire Department had data reporting issues. As companies began migrating their daily work logs from paper to spreadsheets, firefighters found themselves overwhelmed with a multitude of disparate spreadsheets that were redundant, not maintained, and often allowed users to corrupt data with a form of backup.

Since the fire department members were already familiar with Excel, the solution was to stay with the familiar while packaging a lot more functionality into the workbook by protecting the sheets, creating user forms for input/editing, and utilizing VBA for tying it all together. I was the sole developer and my responsibilities included:

: Designing the architecture of a workbook that included more than 20 spreadsheets
: Designing the user experience with forms and documenting this transition in a help document
: Creating seamless, zipped, one-click backups that were stored on remote network drives
: Protecting data by diverting user input from spreadsheets to forms
: Tying in all daily work tasks into a single workbook
: Created department reports used for run analysis
: Maintained workbooks for 50+ fire companies which totaled over 100,000 fire department responses per year Show less