Resume

Jeremy Harrington

Orange County, CA

http://www.chromadex.com

http://www.jharrington.net

Summary

System Administrator and IT generalist with experience in custom programming (both WinForm and Web), COTS modification and extension, data/system migration, database design, database administration, Sarbanes-Oxley documentation and audit response, project management and Windows network administration.
Special interest in designing and implementing databases and software applications to store, manage, and expose business data.

Specialties

System Administration, Software Architecture, Data-driven Intra and Extranet solutions, Visual Basic .Net, Database design, SQL programming, Microsoft CRM 3.0, Microsoft Great Plains 9.0, Scribe Insight Integration middleware, LIMS Systems, Avaya IP Office phone system,Trouble-shooting and correcting complex issues within interconnected systems

Skills

• SQL
• System Administration
• Microsoft CRM
• VB.NET
• Database Design
• Databases
• SQL Server
• Sarbanes-Oxley
• Great Plains Software
• Nexxis iLab
• Microsoft SQL Server
• Integration
• R&D
• Business Intelligence
• Software Development
• CRM

Experience

ChromaDex Inc.

01 / 2007 - Present

System Architect

Responsible for managing all aspects of ChromaDex's IT infrastructure, with one subordinate, for 2 offices 1,000 miles apart, including end user support for 70 employees, IT vendor selection and contact, networking, COTS and internally-developed software, hardware, MS Dynamics GP ERP, MS Dynamics CRM, Labtronics Nexxis iLab LIMS, BI reporting, and Sarbanes-Oxley/Regulatory compliance. Work with other departments to identify inefficient processes and offer solutions. • Recommended, customized and implemented MS Dynamics CRM, including import of all data from Access and Excel. • Migrated all business data from MS Small Business Manager to MS Dynamics GP in 2 weeks with one other person and without the assistance of Microsoft Support • Continued improvements and additions to Extranet solution developed for ChromaDex while at previous company • Write and maintain all IT-related Sarbanes-Oxley documentation. • Created SQL Reporting Services reports for all departments against both ERP and CRM databases • Identified gap in Logistics department inventory tracking procedures. Developed a system and set of reports to identify products restocked into incorrect bins, which previously was untracked, and corrected only on individual basis. • Led multi-department group from Lab and Headquarters to identify requirements, evaluate alternatives, and choose a product and vendor for a Laboratory Information Management System. Currently customizing and implementing Labtronics Nexxis iLab. • Led group to evaluate phone systems and vendor proposals and make purchase recommendation. With vendor, implemented 2 new Avaya IP Office phone systems in 2 locations, supporting a total of 70 users. As part of the project, implemented Bavo Fax Server for network fax send/receive. • Evaluated new routers and configured/deployed new Juniper SSG routers at 3 locations

ProJoba International

07 / 2002 - 12 / 2006

Software Architect & Systems Administrator

In small company environment, maintained network, phone system, desktops and servers. Supported 5 employees and several hundred distributors and customers. Responsible for maintaining and modifying multiple company websites, written in ASP.Net, Coldfusion MX and HTML, with frequent functional changes and additions. Assisted in other departments, primarily customer service and shipping, when needed. • Conceived and created an online signup in ASP.Net, integrating with the existing Back Office Software package, VisualFlex. • Customized Visualflex code base, adding required functionality in customer management, order entry and fulfillment, commissions, and common modules. • As a contracted developer to a partner company (ChromaDex), designed and developed a fully-featured extranet solution incorporating role-based security, reporting, inventory data management, customer order management, and site management in ASP.Net against a SQL Server 2000 Great Plains Database.

Viking Software

01 / 2002 - 05 / 2002

Software Architect / Co-Owner

Identified a market need for a modern and reliable software system to manage network marketing companies. Started a company with a partner do so, while supporting multilevel and network companies in their current systems. • Designed and created a relational database, structured specifically to allow for the frequent business structure changes endemic of network marketing industry companies. • Worked with partner to begin coding modules of package, including customer management, commission plan management and payout, order entry, payment and shipping. • Provided service, support and software development to multilevel marketing companies.

Voyager Group

05 / 2001 - 12 / 2001

Software Architect

Provided technical support for 12 employees. Reconciled and corrected stock business reports from company ERP systems, which provided conflicting results in the version installed. • Developed and integrated new applications and software components to add functionality and efficiency to the business process using Visual Basic 6.0 and Microsoft SQL Server 7 • Saved approximately 12% per month in commission payouts by designing and programming an application to automate clawbacks and recoveries. • Identified and rectified inadequacies and bugs in unsupported enterprise management software • Managed IT asset sale upon business closure.

Education

Purdue University

1998 - 2002

BS , Information Systems

Big Brothers Big Sisters, IEEE Computer Society - Student Chapter

Interests

Private Sector Space Exploration, Project Management, Business Process Management, Reading (pretty much anything), Genealogy

Associations

Association for Computing Machinery, SoCal .NET Architecture User Group, Orange County .NET User Group, IEEE Computer Society

Certifications

ITIL Foundation

12 / 2013

Loyalist Certification Services