Shawn Farley has spent the last 9 years working on a variety of web development projects, including enterprise solutions, most of which required tying together back end MS SQL Server databases with the use of .NET, ASP and DHTML to front-end Web pages. In addition, Shawn has created browser-based applications that displayed data returned as XML from SQL Server 2000, formatted with XSL transformations. He has also functioned as a development lead, database architect and UI/Graphic designer for several Web projects.
In his recent work at Microsoft, Shawn has been focusing on an ASP.NET solution that uses XML Web Services to administer content for mobile devices, such as Smartphones and Pocket PC's. This solution gave Shawn a chance to gain some valuable experience with the next version of MS SQL Server, code-named Yukon, to be released in 2005. |
- VB.NET, ASP.NET, ADO.NET, C#, Web Forms, XML Web Services, Win Forms, HTML, DHTML, JavaScript, VBScript, ASP, XML, XSLT
- SQL Server 7.0/2000/2005 (Yukon), T-SQL, Stored Procedures, Triggers
- MS MapPoint.NET, Visual Studio.NET 2003, Microsoft Office
- Adobe Photoshop, Macromedia Flash, Macromedia Fireworks
|
| Bellevue, WA |
| Visual Studio.NET 2003, ASP.NET, C#, Microsoft SQL Server 2005, HTML/DHTML, XML, JScript |
| At Infospace, I have worked with several team members on maintaining a set of ASP.NET applications designed to provision mobile content for Infospace's major cellular carrier customers. I assisted in developing Custom Controls for functionality that was shared between several tools. |
| Bellevue, WA |
| Visual Studio.NET 2003, ASP.NET, C#, Microsoft SQL Server 2000, DHTML Behaviors, T-SQL, Stored Procedures, HTML/DHTML, XML, JScript |
| At Redtech, I worked with several team members on implementing an ASP.NET application designed to be a component of a system that integrated with a client's MAS500 accounting software. Most data manipulation was done using JScript with XML on the client browser (IE only, as we were using DHTML Behaviors, a technology currently only supported by Internet Explorer). Use of server-side code was purposely limited at the client request, to eliminate page "round trips." Server controls were implemented to wrap up often re-used layout and functionality. I wrote any necessary stored procedures for data manipulation and updates. |
| Seattle, WA |
| Visual Studio.NET 2003, Windows Forms, ASP.NET, Syncfusion Windows Controls, C#, XML Web Services, WSE 1.0 & 2.0, Microsoft SQL Server 2000, T-SQL, Stored Procedures, HTML/DHTML, XML, JavaScript |
| At Corbis, I worked with several team members on implementing a Windows Forms application used to manipulate pricing data for Corbis’ products. I implemented various views and popups to edit the data (accessed via Web Services, to a SQL Server backend). The existing Corbis architecture is half .NET and half COM, and returns and accepts data as XML strings, so another layer of objects had to be implemented to create typed objects for the UI from the XML returned from the database. I assisted in this implementation, creating custom objects to support UI functions where warranted. |
| Redmond, WA |
| Visual Studio.NET 2003, ASP.NET, C#, XML Web Services, WSE 1.0 & 2.0, Microsoft SQL Server 2000/2005 (Yukon), T-SQL, Stored Procedures, HTML/DHTML, XML, JavaScript, Photoshop |
| Mobile Device Services is implementing a product called Windows Mobile Start Service, which is a client application that runs on SmartPhones and Pocket PC's. The application is used to configure the user's device with content, such as home screens, ringtones, software apps, and games, made available by mobile operator customers. My work centered around a Web-based administration portal that allows content providers and mobile operators to administer the content they make available for users. The portal is an ASP.NET site, with code in C#, that accesses a SQL Server 2000 database via XML Web Services. The Web Services implemented some features of WSE 1.0 (and later the 2.0 update), such as DIME attachments, allowing binary files to be serialized and added to Web Service calls. I implemented data classes that the Web Services used to interface with SQL Server, including writing all necessary stored procedures. I was responsible for UI and design of the content portal, in addition to coding all pages to spec. I also created and implemented the UI for the sample portal code to be included in the MDS Window Mobile Start Service SDK. The most recent revision of the portal interface used a new feature of SQL Server 2005 (Yukon), that allows the usage of XPath queries to be passed to stored procedures to return data. These XPath queries are run against the new XML datatype available in the next version of SQL Server. |
| Redmond, WA |
| Visual Studio.NET, VB.NET, ASP.NET, C#, Visual Studio 6, Microsoft SQL Server 7.0/2000, T-SQL, Stored Procedures, Triggers, HTML/DHTML, XML, XSL, VBScript, JavaScript, ASP, ADO, IIS, Photoshop, Flash |
Employed as a Developer and subsequently promoted to Technical Lead for this consulting firm of software developers. Due to their varied consulting assignments, I had a wide range of experience in many different end-user environments, creating and maintaining a mix of database solutions as well as web-enabled front-end interfaces to these databases.
These were primarily developed utilizing ASP, MS SQL 7.0, VB.NET, ASP.NET, HTML/DHTML, JavaScript, VBScript, and Macromedia Flash.
Duties involved some direct client liaison, working as part of an internal development team, some program management, and leading/coordinating/training of junior staff members.
|
| |
Lakehaven Utility District: Lakehaven Utility District had an existing ASP-based system for employees to enter their daily time logs. They wished to upgrade this application with functionality which would enable their employees to enter leave slips (for vacation, overtime, etc.). For the new functionality, we created ASP.NET web forms with code-behind written in C#. All database access (SQL Server 2000) was handled with middle-tier objects written in C#. The existing pages were left in ASP, but modified to handle new DB requirements. I made any necessary database architectural modifications, and wrote all new stored procedures, in addition to all new Web forms.
| |
| |
Shurgard S2: I worked on a large development team on this enterprise solution scheduled to be rolled out to Shurgard storage centers worldwide. The application was initially conceived as a browser-based application, which used middle-tier Web methods (ADO.NET) to return data from MS SQL 2000 for display on Web forms. The data could then be edited/updated. I wrote all ASP.NET code and middle-tier methods using VB.NET, and created all necessary stored procedures for the method calls. I was also required to write and keep current a Technical Specification for each middle-tier class. Mid-way through the project, the application was switched to a Win32 app, so we converted our existing Web forms to Windows forms. I assisted in the creation of many inherited .NET form controls. I also integrated an external SOAP-based web service, MS MapPoint.NET, into the solution for use in finding Shurgard locations on a map. The implementation included the ability to use a full-address search, or a zip code search. The returned map displayed Shurgard locations near a search location.
| |
| |
Alpine Glass: Alpine Glass is a company that dispatches trucks to various sites to replace automobile windshields around the country. They needed a solution that would coordinate customer data, daily job schedules, driver itineraries, dispatch records, and job histories/status. They wanted a browser-based intranet application that would connect to a central MS SQL Server. I created the back-end SQL Server data model, and wrote functional and technical specifications for the application. The application allowed various users to schedule new jobs or review older ones, to assign jobs to a specific driver/route, and to create warranty work orders. Reports were created which included individual job invoices and driving directions, to the daily schedule for drivers, to data analysis. To avoid the constant page-refresh of typical ASP applications, we retrieved and modified data in real-time, from the client. To do this, we returned data from SQL Server via http (using IE’s XMLHTTP object) as XML, and formatted and displayed the data on the client using XSL transformations. In addition to my own development work on the project, I supervised the work of two junior developers.
| |
| |
BeDynamic.com: BeDynamic created a service offered to major hotel chains, usually concierges that allowed them to create a detailed report of activities, events, and local areas of interest to the hotel customers. I updated and modified the existing SQL database. A browser-based data entry application was created, separate from the main service. My responsibilities included the creation of an event search, which returned different results depending upon the input parameters entered by the user. The results of this search were then used to create separate reports. All pages were written in ASP, displaying data and results in sometimes complex DHTML content, which had to display correctly in all major browsers. I also implemented the graphic design and graphic creation (provided by another design company), which was also data-driven: each BeDynamic client had its own logo, color schemes, and layout considerations. I supervised the work of two other junior developers. This project also required much direct client interaction and support.
| |
| |
Whatcard.com: This was a subscription-based entertainment “portal” website designed for teenage and younger audiences. It was an ASP site with a SQL Server 7 back-end. This project required constant interfacing with the client, and I again supervised the work of two developers, coordinating a work schedule to meet deadlines. Though I wasn’t a Project Manager by title, I was in effect the Project Manager on this project. I assisted in the initial creation of the SQL data model, and made all later feature modifications. I supervised the graphical design, and implemented it. The main menu had a very elaborate “animated” appearance that I created using CSS layers and JavaScript; essentially the menu options were floating balls that would bounce off each other and the edge of the browser, which when hovered over would change their appearance. This menu was required to be cross-browser compatible. I also created dynamic features such as instant surveys, online auctions, and daily news updates. Another feature allowed the user to drag and drop smaller images together, which would then create a composite file for download. These features and others were maintained using a browser-based administration tool that interfaced with the SQL database to create content. The user was also able to choose from many graphical “skins” for the site, so the display and layouts were also data-driven.
| |
| |
Net2itive: The concept behind the Net2itive site was to be a comprehensive information source for nationwide high school sports. High school athletes could have their entire careers documented, including all statistics, won/loss records, personal information, etc. All current high school sports teams needed to be represented, including updated box scores and standings. In addition, “Sport Reporters” could write news stories that would feature prominently on the website. The site was designed to be a subscription service, and to be integrated into the subscriber’s own website. Therefore, layout had to be data driven and flexible enough to display correctly in virtually any site. I created and modified ASP pages, including the development of a statewide coaches’ poll, error handling, form validation, a statistics module, and box scores and standings. In addition, I planned and built the “Sport Reporter” Web-based administration application that provided complete management of all site contents. I also designed and implemented the UI (including all online graphic creation), ensuring that the layouts were cross-browser compliant.
| |
| |
BranchMerchandising.com: This was an e-commerce solution, written in ASP with a SQL Server 7 back-end. Credit card payments were processed via Cybercash. I assisted in the creation of the data model, and created about 80% of the site’s ASP pages, including the extensive online catalog, which displayed item information by category. I implemented the graphical design provided by the firm itself, creating all graphics and writing all HTML. Hundreds of stored procedures were written. I wrote a detailed shipping matrix that calculated shipping based on location and freight.
| |
| Redmond, WA |
| ASP, SQL 7/2000, DHTML, HTML, Photoshop, Real Producer |
I was on the IE Strike Team. My duties included proving debugging and debugger setup support, and supplying testing support for IE Web releases, Quick Fix Engineering (QFE) releases, and security updates. We also provided internal support to the IE team, in addition to other product teams that utilize IE, and supported beta releases through bug triaging and bug reproduction.
|
| Available on request. |
| Word format |
|