Home: Data Key Design
Foretelling Triumph
Winning Strategies
Understanding Nature
Position of no Error
Web Application Design
Web Programming
Database Design
Company Information
 
     
     
 

 
     
 

Recent web sites that I have worked on:

The following URL is for Warner/Chappell Music Inc.:     http://www.warnerchappell.com/

This is an extensive B2B web site written in Java and JSP on IBM Websphere that licenses music to the motion picture, television, and music industries. This site uses very advanced and sophisticated techniques that have pushed the envelope in web site design and functionality. This Java framework has been used to develop several more sites for affiliate countries such as Italy, UK, Scandinavia and Holland, Word (Christian Music) e-License Club, Warner Special Products, and OneStopTrax. I designed the program flow in the Interactive Online Help section, several Online Multimedia Players, the Benji Project Management Subsystem, and the Spider Detection Code.

Benji Project Management System: After finishing the first phase I then completed a second-phase version in the earlier part of 2004 which expanded the original into a web based integrated workspace incorporating nested folder trees using drag & drop capabilities. This version uses a complex frame structure from which one frame could broadcast to the others so that each could then take the appropriate action. Using the management icons at the bottom left, users can drag an icon to add, delete or modify an object as needed. Folders or documents could be easily moved by dragging and dropping that object into any folder within the tree structure. This was a fully integrated project management system from which our clients could create projects, select songs, listen to audio clips, collaborate with colleagues, and then license their song selections online.

 
     
   
     
 

Online Help: I designed the program flow and developed the code for this interactive help section that includes walking the user through actually adding projects, searching for songs, adding songs to projects, modifying and deleting songs and their project folders.

Spider Detection Code: Designed and developed the code that detects and keeps third-party web crawlers (Spiders) from data mining the company's music database. This includes an extensive backend admin tool that allows the administrator to bar users for a specific time or completely. This also provided auto tracking of selected users with different levels of detail reporting. Although there are tools on the market with functionality that is similar, we needed a web based background application that was customized to allow legitimate search engines access to the site and at the same time stopped unauthorized data mining.

Other Warner/Chappell sites I've worked on include:

Warner/Chappell Italy:

http://www.warnerchappell.it

Warner/Chappell Scandinavia: http://www.warnerchappell.se
Warner/Chappell U.K.: http://www.warnerchappell.uk
Warner/Chappell Holland: http://www.warnerchappell.nl
Warner Special Products: http://www.warnerspecialproducts.com
Word Music Publishing: http://www.wordmusicpublishing.com
OneStopTracks: http://www.onestoptrax.com

The following URL is for a site called Hockey911:      http://www.hockey911.com

I wrote the shopping cart from the ground up using Active Server Pages with a MS-SQL 2000 backend database. Hockey911's shopping cart required a unique approach because the owner had already spent a substantial amount on a web site that was visually pleasing but impossible to integrate with the off-the-self shopping carts that were on the market. So as to not lose the company's original investment I created a customized back-end solution with automated features that I then interfaced with the original framework.

I also migrated the site of about 300 pages from HTML to ASP during a two phase operation . The first phase of this migration dramatically cut maintenance cost by providing an include method from which only one file needed to be modified when certain information required changing and those changes would then be reflected throughout the rest of the site.

For the second phase migration I re-designed the framework so that all products could be displayed using three active server pages instead of several hundred as was the case when I first started working on the site. The site now has an inventory of over seven hundred products and uses an online data entry system which requires no knowledge of HTML, uses web based file uploading, and images uploaded to the server are automatically resized for use in the product display and shopping cart.

 
     
   
     
  Overall, I have more than seven years experience as a web developer programming in Active Server Pages, Java Servlets, JSP, VBScript, JavaScript, and Action Scripting for Flash. Databases I've worked with include Access, MS-SQL7, MS-SQL 2000, DB2 (AS 400), and Oracle. Other programming languages I have used for non-web development include Visual Basic, Assembly, and C. I work with Photoshop, Illustrator, Visual Studio, Dreamweaver UltraDev 4, VisualAge for Java, and C++Builder. I have a strong ability to visualize ways to overcome design challenges with extensive experience building very complex B2B, B2E, and E-Commerce applications for both the sports and entertainment industries.  
 
Fernando Roldan
(619) 248-2949
fernandois@cox.net
   
     
 
Home: Data Key Design
Foretelling Triumph
Winning Strategies
Understanding Nature
Position of no Error
Web Application Design
Web Programming
Database Design
Company Information