AWS Architect | Cloud & Big Data, Java, SQL, NoSQL
Radical Software, Inc.
1998 to Present - latest project:
Configured AWS VPC, security groups,roles, elastic IPs.
content and web site management system to Amazon AWS Cloud infrastructure.
Currently optimizing logging to log requests through SQS to DynamoDB AWS SQS, DynamoDB implementation
Re-architecting system per best practices from AWS Architecture Training
Master Software Engineer (Team Lead) | Java/SQL Programmer
November 2010 to present
Lead a team on strategic projects for online brokerage ShareBuilder.com
Design new dividends system which automates 28 step process. Matches what is reviewed and reconciled to what is posted. Horizontally scalable, queued architecture that reduces load on database. Dividends team lauded as most collaborative technical project they ever experienced.
Upgrade transfer in system to allow customers to use web site to transfer in funds. Improve reconciliation vendor systems. Led to 175% increase in transfer conversions.
Research and present solution for document upload and management which includes digital signature.
Championed new technology such as AWS, REST, NoSQL and horizontally scalable, distributed architecture. Gave presentations on AWS and cloud security. Trained new developers in object oriented concepts.
Utilize skills from SANS Master of Information Security program and working to improve security knowledge within the company.
Implement FDIC sweep of investor funds as directed by DBA team. Successful launch and continues to drive revenue for the company.
Changes for 2011 tax year cost basis legislation, integrating with GainsKeeper and Wall Street Concepts. Revamped cost basis systems to support new API from tax vendor for options cost basis legislation for 2012 tax year. Bulk upload process to GainsKeeper to correct tax reporting errors in short period by reusing existing system components effectively. 2012 tax season survey of customers indicated best tax year ever despite complete data migration to new tax system version.
Integration of LiveChat (online chat system) and SalesForce data for financial industry compliance. Logs exceptions and continues to process in many cases compared to similar applications typically fail completely.
As scum master from 2010-2012, implemented changes to process to create the team that was consistently recognized for efficiency and frequent quality deliverables.
Online/Offline Regional Retailer
November 2009 to October 2010
Technical architecture, design, development of new web site features, functions, e-commerce web sites, and systems integration.
Management of off-shore developers including tasks and technical design specifications for new product and comparison pages. Provide recommendations to management to move to a true software development process including requirements and technical specifications, source control, build process, testing and test cases. Migration of web site to more robust architecture using object-oriented design
and design patterns (in progress for some components). Integration with third party content and e-commerce systems (Amazon payments, Etilize, etc.)
Implementation of hourly inventory update feeds from warehouse and stores. SQL Server database administration and development.
SVN (source control) implementation and management. Development environment set up process and documentation. DBA, system monitoring
and maintenance functions. Set up secure firewall rules in development environment to protect source control system prior to data center move. Assist
other departments with SQL data replication queries and Java programming. Make recommendations to those responsible for security and PCI compliance.
In three months: Work on project to migrate web site/servers to new data center. Move from single database and dev/production environment to dev, test and production environment with separate databases and clustered SQL Server databases in production. Migration of web site code and databases, set up source control system and migrate SVN database, migrate SQL Server databases, integration and components. Coordinate with IS
department for set up of network/server and feeds to/from other company systems. Convert e-commerce and tax components that did not work on 64 bit Windows 2008 OS to upgraded web services. Set up configuration files to run web sites across dev, test and production systems with different settings in each environment. Set up SQL Server script for migration of databases, automatically dropping orphan users, setting up roles and schemas for increased security. Remove old insecure components and set up secure file access by application on integration server. Reverse engineer systems since documentation was either
non-existent or out of date. Research information to determine how web site
functions, what components are used, how to get the information to set them up in the new environment and document for future reference.
Restore databases. Project management and task assignment. Reported project status to management who was responsible for directing those to whom tasks were assigned to get them completed. Project put on hold due to change in company direction and lack of testing resources.
Migrate public web site off failing COM component to web service tax component. Add failover in case web service failed. Optimize existing web site for performance. Fix subsequent changes that had negative impact on performance as needed. SQL Server profiling of queries to optimize indexes and stored procedures. Optimize key pages slow to load and move problem queries into stored procedures. Optimize Cold Fusion server configuation for optimal system utilization including threads, request timeouts, JVM memory usage and other system memory and CPU usage factors. Optimize some pages for better search engine rankings. Set up detailed error logging including user metrics, stack trace and error messages to pinpoint errors on site. Add detailed logging and fix 404 errors to help search engine rankings and sales. Fix problems caused by problematic caching routine. Set up transaction tracking and monitoring of e-commerce payment gateway transactions. Fix security flaw in analytic tracking tags which allowed code injection to break order tracking due to improperly validated url output. Make recommendations to fix other security problems to management.
Ajax wireless phone checkout process successfully launched with almost no errors in production.
Cold Fusion, JRun, Java, SQL Server 2000, SQL Server 2008, XML, XSL, AJAX, Maven, Visual SVN, Collabnet SVN, Tortoise SVN, IIS 6 and 7, Windows 2008, Windows 2003,
Mercent, Etilize, CCH Sales Tax Online, PayPal/Verisign PayFlowPro (Ecommerce gateway), GERS integration, Amazon Payments.
Development of Web Marketing, Content Management and E-commerce Web Site System
Jan 2009 to Present
(continued work on system developed over past 10 years)
Run web sites for primarily small to medium sized retail/wholesale companies needing a system that provides end to end web site
management and web application features such as SEO, fulfillment integration/processes, invoicing, inventory, social media integration, marketing analytics, customized databases,
e-commerce and web/mobile/email publishing on the bMetrix
platform. (New customers currently by invitation/recommendation only).
Manage data center, DBA, development of customized web management platform using Java.
Custom MVC, scalable architecture using open source, customized web servers and web services to communicate between
server and client components. Web publishing for multiple environments and formats, SEO friendly design and urls,
HTML publishing for optimized server network performance. Detailed logging, metrics and analytics. Web security functions.
inventory management, customizable databases, e-commerce, and Cybersource (being purchased by Visa) payment processing integration.
Integration with Fulfillment Center
Integration of data in Volusion shopping cart system with fulfillment house. Automation (as much as Volusion allows) via Java application and import/export via XML and CSV files.
Plant Nursery Online Ordering and Inventory System
September 2009 to December 2009
Customized inventory management database and online ordering system for retail and wholesale plant nurseries. SEO for large plant inventory. Search by product attributes. Online availability list. Plant location tracking. Coupons. Completely customizable web design. Customizable pricing. Email list and online newsletter. Customers can update web site without programming including plant database, text on site and plant photos. Ability to preview changes before publishing to web site.
E-commerce Event Registration & Mobile Web Site
Sound Mind & Body Gym
August 2009 to October 2009
Ecommerce services, event registration and mobile phone web site for Sound Mind & Body Gym. Pay per click advertising management and SEO. These services are provided on the bMetrix web platform.
E-commerce Web Site
Feb 2008 to December 2008
Contract Programming Client of Radical Software
Worked as team architect and lead developer to create a tax system which read data from sales audit department passed in from POS systems and e-commerce web site, processed in staging database and C# system, then passed via web services into third party tax system (Vertex). Created multi-threaded, configurable library to submit millions of records into tax reporting system which had no threading errors in production. One database timeout issue in one section of code occurred after the system went live which had not occurred in load tests or test environment. The issue was
quickly and easily pinpointed due to appropriate error handling and logging and easy to fix. Replaced previous problematic system with new system that only was off by under $25 in the first month
and cause of those out of balance transactions were pinpointed as soon as the system was launched and due to a robust and detailed
means of balancing transactions between systems. Uncovered and helped address issues in existing POS and sales audit systems in the process of designing and developing this system. System had detailed balancing and error checking functions to ensure reliability and a system architecture which allowed developers to make future business changes without introducing complicated threading errors by creating a separate threading library.
Additional work for Nordstrom included a Java error checking component for a TIBCO queue, assistance in creating Maven build system, .NET and SQL Server database build system improvements to coordinate builds on development, staging, test and production environments using 3rd party source control system, proof of concept test using SQL Server XML query functionality, and functional specifications document for shipping UI functionality on Nordstrom e-commerce web site.
Technologies and Applications: .Net, C#, XML, Web Services, SQL Server, Java, XML, Maven, Eclipse, TIBCO integration, Dimensions, Junit, Nunit, Vertex.
Real Estate Web Site
Windermere Real Estate
Contract through Robert Half Technology
Facebook, Games, Adminstation Web Sites and Data Feeds
Sept 2007 - Jan 2008
Contract through Robert Half Technology
Initially hired to create games integrating IMDB (Amazon's movie database) running on Facebook. Import datafeeds from multiple sources using XML physical files and web requests. Reverse engineer complex system written by multiple engineers to design administrative system to update movie games and replace data feed from another source with almost no documentation/information. Java, Rest, XML, MySQL, Hibernate, Spring, Webwork, Freemarker, Maven, Eclipse.
E-commerce & Marketing Web Sites
Nov 2006 to Sept 2007
Contract through Volt
Support e-commerce and marketing web sites and content management system. Implement updates to Rhapsody.com and Real.com web sites including web pages, new features, debugging system performance issues, JUnit tests and architecture for new e-commerce system. JSP, Java, SQL, XML, XSL, Apache, Tomcat, JMeter, Junit, CVS, Eclipse, Ant.
Intranet Telecommunications Product Management System
, Seattle, Washington, 2006
Contract through Robert Half Technology
Developed internal product management system for Qwest to manage mass market products. Included
online publishing, editing, review and legal approval mechanism. Java, XML, JSF, Facelets, CVS, Lucene, Spring
Custom Programming and Web Development
Radical Software, Inc.
, Seattle, Washington, December 1998-Present
Started out as a custom software development firm, managing employees to create custom web software and e-commerce web sites for companies.
Since have developed a web platform to host small businesses which includes and SEO publishing platform and all in one web marketing services.
Work on contract for large companies, government or non-profits through Radical Software and via third parties as projects above indicate.
Helped a small e-commerce business grow from garage operation to multi-million dollar company acting as sole web architect and manager including data center operations, programming, e-commerce, SEO and analytics.
Projects include work in .NET, C#, ASP.Net ASP, JSP, Java, ColdFusion, SQL Server, MySQL
Provided technical consulting, programming, database development, technical book reviews and technical due diligence to numerous companies. Project details and customer names and contact information for reference can be provided upon request.
Some clients include:
Sound Mind & Body Gym (SmbGym.com)
Rosetta Inpharmatics (Merck)
Silicon Valley Bank
F5 Networks (via subcontract)
T-Mobile (via subcontract through IS Domain)
Renaissance Realty (Bid4Dirt.com)
Staenberg Venture Partners
Institute for Family Development
MIT Enterprise Forum / Venture Lab
Social Investor Forum
Mailwell Envelope (Cenveo / State of Washington Department of Printing)
Invitation Web Site: E-commerce Content Management System & SEO
, Los Angeles, California, 2001-2005
Custom Software Client of
Oversaw IT for web site for three and a half years. Technical architecture. SEO. Project management
and vendor coordination for networking, design and development.
Personally implemented most complex components and search engine optimization changes to web site
that improved search engine rankings and sales for customer over and above work done by
a major SEO company.
Helped customer increase sales from $1,000 per month to over $70,000
per week before company
was sold to major printing industry company. Company was sold off to one of, if not the biggest, privately held
invitation industry printing companies. Web site I created is pretty much still in tact. I chose not to work for
the company that bought them out, even though they asked me to name my price to go work for them.
Technologies include Java, JSP, JRun, SQL Server, all hosting, network, e-commerce, search engine
optimization implementation and improvements that dramatically increased sales.
Implemented JBoss configuration and managed development to migrate system to
Wireless Company: Customer Service Application for Number Portability
, San Diego, California, 2004
Contract through Dataskill
Implement changes to customer service and sales
application written in Cold Fusion to provide functionality for number
portability. Completed in time for federally mandated deadline.
Print Proofing Web Site / Java, XMLRPC (like web services) .NET Integration
State of Washington Dept. Of
Printing / Mailwell Envelope (Cenveo
), Seattle, 2003
Custom Software Client of Radical Software
manager and developer of system for company to sell customize printed
materials online. Includes xml-rpc calls from .NET to a Java component that
provides proofs in PDF format. Expanded system supports multiple printing
customers via customizable site and product list.
Retail E-commerce Web Site
Aquaflowhose.com, Seattle / San Diego, 2002
Manged web site client of Radical Software, Inc.
Temporary e-commerce web site for a company selling a shipment of unique garden hoses manufactured overseas. Successfully sold all products and site was shut down.
Java Web Application Troubleshooting
, Seattle, 2002
Subcontract for Radical Software, Inc.
Troubleshooting of Java/Linux
web licensing application. System was crashing randomly. Was able to pinpoint
the error that caused the code to break, resulting in ever increasing JDBC
connections to a SQL Server database. Resolved the error and corrected the
error handling to prevent the problem from occurring in the future.
Technical Book Reviews - Java Web Services
, Seattle, Washington, 2002
Review technical books before publication and provide technical feedback as to the accuracy of information and usability of sample code. Sample project: Java Web Services For Experienced Programmers
Search for "Teri Radichel" - bottom of preface.
Lingerie E-commerce Web Site
Bratopia.com, Seattle, Washington, 2000-2001
E-commerce web site client of Radical Software, Inc.
E-commerce web site for lingerie company. One of over-funded dot com companies that went out of business. Project Management / Consulting.
Venture Capital: Technical Due Diligence
Staenberg Venture Partners
, Efund LLC
, Seattle & Kirkland, Washington 2000
Technical consulting client of Radical Software, Inc
Technical due diligence services for two Seattle
venture firms. Reviewed technology created by potential portfolio investments
to determine feasibility, competency of technical staff, and accuracy of
technical claims, schedule and budget. Projects ranged from wireless to
online advertising technology to network monitoring systems.
Venture Capital Web Site & Content Management System
Staenberg Venture Partners
, Seattle, Washington, 2000
Web site client of Radical Software, Inc.
Built a content management system for venture capital firm portfolio.
Firm has since merged with Rustic Canyon Partners and site has since been changed by internal staff.
Java API for International E-commerce Gateway
Online Commerce Solutions, Seattle (parent company in Germany), 2000
As a senior software engineer, created the Java API for an e-commerce gateway (like Verisign
in Europe. Wrote demo for Java developers to show how to use the API.
Also set up the company's US web site and an e-commerce web site to demonstrate
their multi-currency, micropayment processing e-commerce gateway.
Technologies included Java, XML, JRun, and SQL Server.
MP3 Streaming Music Download & E-commerce Web Site
SlowBlue.com, Seattle, Washington, 1999-2000
Worked on a team, which created a web site for a now defunct Internet
record label. Site included streaming media, file uploads, ecommerce and a
web interface for administration. Technologies included JServe, Java, JSP,
servlets, JDBC, Real Server, Linux, MP3, Apache and MySQL.
Seattle e-commerce web sites
Shownow.com (purchased AXC Interactive), Seattle, Washington, 1999-2000
As an e-commerce consultant, implemented order process and site architecture to
integrate with Oracle database and I-Syndicate Java/XML news feeds. Part of 5 person
team sent to Shopnow.com by AXC Interactive to form relationship which resulted in
Shopnow.com buying AXC Interactive and not another firm they were considering at the time.
- Athletenow.com (Consulting for ShopNow.com), Seattle, Washington, 1999
- Stairmaster.com (Consulting for ShopNow.com), Seattle, Washington, 1999
- shop.raymarine.com (Consulting for ShopNow.com), Seattle, Washington, 1999
- magnoliahifi.com (Consulting for ShopNow.com), Seattle, Washington, 1999
Technologies include Interworld, Oracle, Unix, NES.
Various Web/Programming Projects
AXC Interactive (Sold to Shopnow.com), Seattle, Washington, 1998-1999
Sales Force Automation & CRM Systems
- Airplane Part Test Scheduling System for Boeing subcontractor - Oracle, Access, VB
- OLAP Demo for Microsoft - Oracle, Access, VB
- Events Registration System for Microsoft - VB, ASP
- Subcontractor Database System- VB, ASP
- Press release file transfer- OLE Automation, MS FTP Component, VB
ATL Ultrasound (now Philips), Bothell, Washington, 1996-1998
As a Database Analyst and Database Developer, created quote automation tool for field sales reps to
generate quotes for ultrasound equipment and send in-house electronically for
processing. Wrote SAP/ABAP4 queries to pull product information and sales
text out of SAP database. Mail-enabled prototype was implemented in Visual
Basic, ABAP, GroupWise, Access, and Oracle. Additionally created systems integration
applications for marketing department to combine databases from multiple systems, and resolve
systems integration errors. Multiple database technologies and sources.
Oil Company - Telecommunications Management Systems
Tosco Marketing Company, Seattle, Washington, 1994-1996
(gas stations & oil refineries)
As an Information Technology Analyst, created system for tracking telephony and wide area
network lines and related services, equipment, projects and expenses. Monthly
enterprise-wide reports showed expenditures by employee, department and
location. System included budget analysis and expense tracking reports.
Invoice processing and expense tracking was automated by uploading invoices
available in digital format into the system. Project management module
tracked orders, due dates and project contacts. Technologies included Access,
Oracle, Quadbase, Visual Basic and other database sources.
Telecommunications & Networking - Project Management System
Tosco Marketing Company, Seattle, Washington, 1994-1996
As an Information Technology Analyst, acted as project manager for
installation of ISDN lines for credit
card processing at Tosco-owned BP gas stations. Determined line
specifications needed for x.25 packet switching over D channel. Coordinated
vendors, site personnel and headquarters to resolve business and technical
issues. Wrote project management system to track installations and project details.
Freelance Business Writer
The Write Connection (Freelance / Owner), Seattle, Washington, 1993-1994
As a freelance writer, wrote sponsorship proposal for Summits Adventure Travel (Peter
Whitaker) that resulted in $35000 worth of gear from Marmot Mountain
International. Proposal to Microsoft for AIESEC that landed $2000 in
sponsorship. Brochures for companies and non-profit organizations, resumes