MarcopoloniTechnical Founder/Senior Web Engineer
Oct. 2003 - Aug. 2016Greater Los Angeles AreaIdentified the need to transition our legacy code base from ColdFusion and SQL Server to Node.js and MongoDB. Designed architecture to divide monolithic application into separate services (catalog, cart, checkout, and admin) while still sharing a single database. Modularized and decoupled code. Moved code base to AWS and database to MongoDB Atlas. Created a secure REST API.
Integrated backend with the Quickbooks Online API. Optimize database with indexes based on usage patterns. Planned sharding of log collection.
Use MongoDB aggregation and D3 to build business intelligence reports. Designed and implemented our client-focused e-commerce web site and our entire back-office system. Used ColdFusion, SQL Server, HTML5, JavaScript, jQuery, JSON, AJAX, and CSS3 to implement a complete e-commerce solution, that proved to stand the test of time even when I began pursuing other opportunities. Wrote RESTful API for entire ERP system and created Object Oriented JavaScript modules to consistently consume those web services across all branches of the ERP system. Integrated payment system and shipping quote systems with PayPal, Verisign, USPS, and FedEx. Successfully improved user efficiency by as much as 60% in some areas. Simplified the creation of all future internal applications by ensuring code reuse. Tested code using JSHint, wrote unit tests in Jasmine.js running on node.js. Used d3.js to create marketing intelligence reports with data drawn from our SQL Server database through API calls (AJAX/JSON).