Teri Radichel | Seattle Programmer & Web Developer | Web & Database Programming | Seattle Web Development | XML Programming Consultant .Net, C#, Java, SQL, XML, XSL

Java/SQL Programmer
Global Financial Services Company
November 2010 to present

Back office applications.

E-commerce Architect
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. (For more on web site and web application security and performance see http://twitter.com/teriradichel)

Ajax wireless phone checkout process in progress.

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
bMetrix 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. Email newsletters, inventory management, customizable databases, e-commerce, and Cybersource (being purchased by Visa) payment processing integration.

Integration with Fulfillment Center
December 2009
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/Financial Applications
Nordstrom 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 Seattle, Washington, Feb 2008
Contract through Robert Half Technology
Two week contract to implement multiple file upload and e-commerce checkout for real estate agent services. Java, JavaScript, ColdFusion 8, Eclipse, Subversion, Ubuntu, SQL.

Facebook, Games, Adminstation Web Sites and Data Feeds
Fantasy Moguls Seattle, Washington, 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
Real Networks Seattle, Washington, 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
Qwest, 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:

Nordstrom
Sound Mind & Body Gym (SmbGym.com)
Rosetta Inpharmatics (Merck)
Silicon Valley Bank
Wrox
F5 Networks (via subcontract)
Prentice Hall
T-Mobile (via subcontract through IS Domain)
Renaissance Realty (Bid4Dirt.com)
FusionTek
ArtisanWindow.com
SmileWestSeattle.com
Weiss CPAs
RainierRhododendrons.com
MarketingPhilharmonic.com
Staenberg Venture Partners
Efund, LLC
Institute for Family Development
eMerchandise
AquaFlowHose
Bratopia.com
Cascade Trade
MIT Enterprise Forum / Venture Lab
Social Investor Forum
Dulce Design
Mailwell Envelope (Cenveo / State of Washington Department of Printing)

Invitation Web Site: E-commerce Content Management System & SEO
MyGatsby.com, Los Angeles, California, 2001-2005
Custom Software Client of Radical Software
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 JBoss/Jetty platform.

Wireless Company: Customer Service Application for Number Portability
Leap Wireless, 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
Architect, project 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
F5 Networks, 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
Prentice Hall and Wrox, 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, Cybersource, Authorize.net) 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

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

Sales Force Automation & CRM Systems
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 and proposals.

Seattle Java Programmer · Web & Database Programming · XML Programming Consultant · .NET Programming · E-commerce · Web Marketing · Contract Programming

Technologies & Skills

Software Projects, Web Sites and Web Applications

Education

Employment

Other Information