| Portfolio of Work | |||||||||||||||||||||||||||||||||
| by Fernando Roldan | |||||||||||||||||||||||||||||||||
| Overall Experience | |||||||||||||||||||||||||||||||||
| I have over fourteen years experience designing and developing dynamically driven web applications with a special emphasis in online tracking and evaluation systems. Programming technologies include Classic ASP, J2EE, AJAX, C, C++, C#, JavaScript, Visual Basic 6, and ActionScript for Flash, Database skills include designing relational databases for DB2 on IBM AS400s, MS-SQL 7, MS-SQL 2000, MS-SQL 2005, MySQL, and Oracle on Sun Microsystems servers. Have worked with IBM WebSphere, Visual Studio 6, Visual Studio.NET 2005, UltraDev 4, Dreamweaver, Flash, VisualAge for Java, Turbo C, C++Builder, Photoshop and Illustrator. Have integrated third-party technologies such as Flash, RealPlayer, Java Applets, and Adobe Acrobat with database driven content. I have a background in cinematography, photography, with the ability to analyze an audience and then design presentations or programs accordingly. Overall, I have extensive experience building B2B, B2E, and E-Commerce applications for the public health, sports, electronics, and entertainment industries.The following provides a brief description of projects I've worked on with links where appropriate. | |||||||||||||||||||||||||||||||||
| Warner/Chappell Music | |||||||||||||||||||||||||||||||||
| 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 Object-Oriented Design techniques that have pushed the envelope in web site design and functionality. The J2EE framework we developed was then used to create several more e-licensing sites for affiliate countries such as Italy, UK, Scandinavia, Holland, Word (Christian Music) e-License Club, Warner Special Products, and OneStopTrax. Where I played a major role was in designing and writing the programming for the Interactive Online Help Section, several Online Multimedia Players, the Multi-Project Management System, and Spider Detection Code used to block unauthorized data mining of the company’s online database. Note: Warner/Chappell Music was sold by Time/Warner Inc. in 2004 and some of the web sites may have been modified. |
|||||||||||||||||||||||||||||||||
| Affiliate E-Commerce Sites | |||||||||||||||||||||||||||||||||
| Once developed, the J2EE extended framework allowed us to quickly and cost effectively go international with the following e-commerce sites using the same under-the-hood programming engine. Each e-commerce site could then maintain a cross-the-board uniform look and feel or provide their users with their own unique layout experience through CSS. Artwork designed specifically for a site could also be changed by simply using the the same file name. | |||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
|
Note: The original framework used a CSS Zen Garden strategy for altering each sites layout and appearance: http://www.mezzoblue.com/zengarden |
|||||||||||||||||||||||||||||||||
| Multi-Project Licensing Management System | |||||||||||||||||||||||||||||||||
| This is a screen shot of a Multi-Project Licensing Management System I programmed while at Warner/Chappell Music. The management system was designed to be used by our clients within the music, motion picture, and television industries. I designed the application to be modular using several sub-systems which I also developed and programmed. Modules included a core module for managing complex projects, a multimedia sub-system used to create and play database driven play lists, a collaboration module, and an AJAX messaging system that allowed communication between the different modules. This application was later modified for use as an internal pitching tool to promote artists and their songs between international offices. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| Data Key Design | |||||||||||||||||||||||||||||||||
| I designed the main site, wrote the content, and used photographs from my own portfolio. I use quotes from Sun Tzu as the main theme to drive home the need for detail planning in all phases of web site design and development. | |||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| Note: On 3D Photography of vase use arrows to rotate vase. On the curtain display, click on swatch to change the curtain to that swatch. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| Evaluation & Tracking System | |||||||||||||||||||||||||||||||||
| The following URL is to the web site for The Center for Cancer Quality Assurance and Professional Education. Screen shot is of an evaluation/tracking system I developed using a location centric database that I also designed. Due to privacy issues the data in this screen shot uses test data with fictitious names, addresses, and MediCal ID numbers. http://qap.sdsu.edu/ | |||||||||||||||||||||||||||||||||
| The application is used by ten regional offices within the State of California who oversee the providers within their region. Each provider is evaluated for quality and timeliness of care provided to women receiving the program’s free breast, cervical cancer screening and diagnostic services. The application was written using Classical ASP, MS-SQL 2005 as the database back end, and JavaScript for the client side programming. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| Sony Electronics | |||||||||||||||||||||||||||||||||
| mylo® Labs: http://www.mylolabs.com Originally a two to five month contract with Sony Electronics in which the contract was extended to a year. During that year I worked with an artist who did the artwork and layout while I focused on the server programming using Classical ASP, MS-SQL 2005, and JavaScript. The site was designed to act as a central depository where developers can share their widgets with the rest of the mylo® COM-2 community. The application provides pagination, file uploading, data encryption, and was designed to minimize security issues such as SQL Injection Attacks. |
|||||||||||||||||||||||||||||||||
| Note: Screen shot of application taken during the development phase. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| mylo® Mini Site Admin Interface | |||||||||||||||||||||||||||||||||
| mylo® mini web site: After completing mylo® Labs the artist and I were asked to redesign the mylo® mini site, a web site specifically designed to be viewed by the device. While the artist worked on the look and feel, I redesigned the pages to be database driven and easily changed through an administrative interface. The artist left the project prior to our developing the Marketing Interface. I reused the assets, such as PSD files, from mylo® Labs to match the fonts and backgrounds for the newer navigation links and headers. I created the image of the mylo® COM-2, displaying a mini site web page, in Adobe PhotoShop merging an existing image of the device with a screen shot taken of a mini test page. I used the Adobe PhotoShop Scale and Perspective functions to match the screen shot of the test page to the same angle of the image of the mylo® COM-2 device. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| Picasa Widget | |||||||||||||||||||||||||||||||||
| While at Sony I also developed several mylo® COM-2 widgets that included a To-Do List Widget that was basically a miniature database using a multi-dimensional JavaScript array to emulate the functionality of a database. The widget used mylo® COM-2 specific library functions to read and write record sets to an internal XML file that mapped to the fields in the array. The screen shot below is of a Picasa Widget I developed that allows a user to download photo album feeds from the Google Web Site. The widget interacts with the Google Server through XML feeds allowing users to download and work with photos within their online albums. Albums are displayed four at a time with the ability to iterate forward and backwards through a set of albums by using the blue arrow icons. Clicking on a thumbnail displays the photos within an album, one at a time. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| The widget also allows users to search the Picasa web site for images that are marked as public. This screen shot is of a single image display resulting from a public search using the keyword "horses". The users can iterate through the feed using the arrow buttons. They can also set how many images to display per feed and from where to start in the feed. | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| U.S. Army Substance Abuse Program | |||||||||||||||||||||||||||||||||
| ACSAP Public Interface: http://acsap.army.mil/sso/pages/index.jsp I worked on a one-year DoD government contract adding new functionality to several existing web based applications. Systems included Classical ASP and Oracle J2EE using an Oracle 10g database. The systems provided the Army with a centralized training and educational depository; methods of tracking the results from drug/alcohol testing; and evaluation/tracking through all phases of soldier counseling. Projects included mitigating site security risks; programming in ASP, Java, and JavaScript; and developing SQL queries for use in several reporting tools. While there, I also created a design document for a web service the agency will be using to expose their data to other authorized agencies within the U.S. Army. |
|||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
| I currently own several web sites which I use to stay current with different technologies, prototype new concepts, and explore the inner workings of various frameworks. I have an ASP.NET 3.5 site I use for ASP.NET development; a Tomcat 6 server which I'm currently using to develop Java solutions on the Spring framework; and a JBoss server from which I plan to develop Enterprise Service Buses. I enjoy what I do and I don't mind putting in the extra time exploring new techniques, ideas, and concepts. In short, I plan to continue with independent studies for a long time to come. | |||||||||||||||||||||||||||||||||
|
Regards, Fernando Roldan (619) 248-2949 FernandoDeRoldan@gmail.com |
|||||||||||||||||||||||||||||||||