Jesse Roberge (INTP)(5w4)(S/C) 1651 South Dobson Rd. Apt# 358 Mesa, AZ 85202 (480) 620-6386 YeshuaAgapao@gmail.com DOC | ODT | PDF | RTF | TXT OBJECTIVE To be your a back-end to middle tier database and application performance guru. SUMMARY Eight Years of experience in developing database intensive web applications. Bring structure and performance to a programming environment (classic ASP) that normally lacks such utilizing my own insights and the wisdom of more experience developers in my team. Experience in integrating custom business logic structure in ASP.net by extending the page class utilizing inheritance and abstract classes. Databases and search-heavy web applications that can handle well over a hundred thousand page views per day on each server. Very good out-of-the-box analytical problem-solver. RELEVANT SKILLS Operating Systems:    Windows XP, Windows NT, Windows 2000, Windows 2003. Development Languages:    T-SQL, Classic ASP, ADO, ADO.net, PHP, C#, JavaScript, VBscript, VB.Net, Visual Basic, C/C++, HTML, DHTML, CSS. Database Platforms:    SQL Server 2000, SQL Server 2005, SQL Server 7, MySQL, MS Access '97-2003. Project Experience:    Search Engines, Search Agents, Hierarchies, Mapping, Distancing, Surveys, Product Reviews, Shopping Carts, Tracking, Reporting. Database Tasks:    Schema design / data modeling, normalization, index planning / tuning, query optimization, stored procedure / view development, backups, performance monitoring, user / permissions management, SSIS, DTS, log shipping, replication. PREVIOUS EMPLOYMENT InteGreat Solutions - Scottsdale, Arizona SQL Server 2000 / 2005 Database Developer. September 2007 to December 2007 T-SQL, Classic ASP, ADO, VBscript, HTML, SQL Server 2000, SQL Server 2005, Windows XP, Windows 2000, Windows 2003 Optimize the database and application performance of the IC-Chart electronic health records system Jobing.com - Phoenix, Arizona Web / Database Developer. February 2001 to June 2007 T-SQL, Classic ASP, ADO, ADO.net, C#, JavaScript, VBscript, HTML, DHTML, CSS, SQL Server 2000, SQL Server 2005, Windows XP, Windows 2000 Refine and Expand the relational database design for the job board site. Optimize queries, refine application code, and tweak indexes to enhance the performance of the job board site. Design and Code ASP applications for the new features of the job and resume search engine & agents, mapping, area/category hierarchy system, and many other areas of the job board site. Code C# .net applications for automation tasks such as search agents, e-mail notifications, etc.. Allegro Medical - Scottsdale, Arizona Database Developer, Web Developer, and Database Administrator. October 1999 to January 2001 Classic ASP, ADO, T-SQL, JavaScript, VBscript, HTML, SQL Server 7.0, MS Access '97, Windows NT Design, implement, maintain, and upgrade the relational database infrastructure for the e-commerce site. Develop stored procedures for the e-commerce site's bulk interactions with the database. Code ASP for the shopping cart, universal promotions, customer login, affiliate tracking, traffic tracking, and many other features of the e-commerce site. PROJECT HISTORY - InteGreat Solutions - Scottsdale, Arizona IC-Chart database and application performance optimization 80% T-SQL, 20% Classic ASP Elimitate excessive application-to-databse roundtrips, particularly in health summary, which averaged 200-250 per page view. Eliminate the epidemic cursor infestation in the IC-Chart database's triggers and stored procedures Utilize a horizontal delimited data -to- vertical table conversion inline table-valued function to stored-procedure-ize ad-hoc queries that would otherwise have to remain dynamically generated SQL. PROJECT HISTORY - Jobing.com - Phoenix, Arizona Consistent Performance Guru 50% T-SQL, 35% Classic ASP + ADO, 10% Index Tuning and other non-code database tuning, 5% C# + ADO.net When first starting Resume search was sped up from 'unusable, timing out' to something quite reasonable. In 2001, the overall site was optimized from something mediocre to average to quite zippy in speed with no hardware upgrades. In 2003, the site averaged over 4,000,000 page views per month on 1 web/database server and 1 offsite SMTP server. In 2004, the site averaged over 6,000,000 page views per month on 1 database server, 1 web server, and 1 SMTP server - two CPUs, eight disk RAID 5, 4gig RAM on the database. In 2005, the site averaged over 9,000,000 page views per month on 1 database server (same setup on DB server, faster CPUs), 2 web servers, 1 SMTP server, 1 image/map server, and 1 upload server. In 2006, the site averaged over 11,000,000 page views per month on the same setup with an external fibre-channel RAID 1+0 box added. Search Engine Overhaul 50% T-SQL, 50 % Classic ASP + ADO Performance optimization and a lot of new features over several projects. Original version was using LIKEs and bringing all data into page for manual ranking, and was running select statements for every individual result. Over 150,000 page views per day on search_results.asp alone on a single web and a single database server. Full Tracking and integration into visitors, sessions, page views, and logins. Great-Circle Distancing - Both filtering and display. On-the fly parameter changes. JobingTV and Career Expo integration. Expansion of areas based on the universal hierarchy system. Tracking and reporting 85% T-SQL, 15% Classic ASP + ADO Visitors, Sessions, Page Views, Searches, Misc Events, and Logins. Extensive integration into the other systems on the site. Pre-generated aggregate reporting tables in a star schema. Good amount of reports developed particularly with web traffic, searches, and job applications. Major data mining potential in the searches. Result Keyset tracked with clicks, views, FTI ranks, and area-expansion rank. Search Agents 65% T-SQL, 25% C# + ADO.net, 10% Classic ASP + ADO Full featured searches with the same level of tracking and reporting as the regular searches. E-mail frames customized by market. All markets and HRW clients run in the same process run. 20,000 job search agents crunched per hour without the e-mails - just crunching and tracking the search queries. 8,000 job search agents crunched per hour when including the e-mail sending with a single mail server on the same network. Universal Survey System 60% Classic ASP + ADO, 40% T-SQL Implemented as virtual interviews, HRW event sign-ups, Custom member registration forms, and HRW Universal form chunks. Almost any type of question including multi-answer check boxes and multi-selects. Universal foreign key system allow loose integration into virtually any system. Universal admin, user, and reporting interfaces. Smart 'Entry' Page 80% T-SQL, 20% Classic ASP + ADO Converts City/State/Zip into Affiliates. Many misspellings are accommodated for. Robust for users who can not follow directions. Multiple result conflict resolution, especially for city-only queries. Will use the area hierarchy system to send state results to the largest regional site if there is no state-level site. Will send to a portal HRW client site if there is absolutely no jobing site to accommodate the query. Affiliate/Profiles 75% Classic ASP + ADO, 25% T-SQL Sites customized by market or by individual client. Jobs restricted by one or more of any combination of areas, categories, or companies. Custom colors, font sizes, and style sheet parameters. HRWs have custom framing and a content management system. Universal Hierarchy System 100% T-SQL Implemented for areas and categories. Base data is adjacency and the 'rendered' data is a very elaborate implementation of transitive closure. Optimized for a very high read to write ratio. Query virtually any subset, including 'cousins' and 'aunts/uncles' of a reference node within the tree without the need of a join. Powers search area expansion in job and resume search and Area/Category listings in various forms. Can support hierarchical structures as complicated as amazon.com's and ebay's categories. Universal Mapping 50% C# + ADO.net, 30% Classic ASP + ADO, 20% T-SQL Universal .net Microsoft MapPoint mapping component and distancing component. Has Great-Circle Distance functions and Address to Geocode conversion functions. Accepts Geocodes or parameters for the universal PK-lookup system to look up cached GeoCodes from the database. Actual mapping function returns a URL on Microsoft's server, a local image path, or the image itself. MapPoint maps are fully cached, with parameterized database location and parameterized file-system paths and automated sub-folder creation. Great-Circle Distancing functions have been ported to both an ASP include file and a SQL Server scalar-function. MapPoint is obsoleted by Google Maps which is a lot easier to code for and just better. Universal job listing system. 60% Classic ASP + ADO, 40% T-SQL Extremely flexible way to show jobs for affiliates with too few jobs to need or want a search. Emulated 3-tier structure (classic asp) with the middle tier as an include-file function library. Three major formats and all display components are optional. Three overall structural options plus over a dozen individual element options for the layout. 5 Restriction options beyond the affiliate's filters - further by one or more companies, one or more areas one or more categories, one or more industries, or the job's age. Universal site_email system. 60% T-SQL, 40% Classic ASP + ADO Universal system of configurable e-mails and universal removal of e-mail addresses from hyperlinks on the site. Emulated 3-tier structure (classic asp) with the middle tier as an include-file function library. Customizable header/footer frame for each e-mail type and/or category. Additional, multiple footer messages by e-mail type. Can auto-lookup e-mails from IDs fed by page/link (meaning is determined by e-mail type). It also can be fed plain e-mail addresses, or run off of e-mail addresses put in the database record. Universal Tracking for auditing and reporting tracks everything except the e-mail body text. Tracking includes links to session / visitor / navigation / login tracking. Universal PK-to-data Lookup System 100% T-SQL Used by Site_Email system and map geocoding. One stored procedure call will look up one or two values via parameters. It looks up the FK reference via metadata tables and retrieves the values via output parameters. Another version of the stored procedure will return the looked up values for multiple comma separated PK values to a table variable. Universal banner system 50% T-SQL, 50% Classic ASP + ADO Multiple random banner pools. Multiple display locations per page, same pool or different or mixture of same and different. Multiple restriction dimensions per banner/pool combination. Banners are weightable within their random pools. A weight of '4' means 4 entries in the random pool. Universal click and view tracking that can support very analytical data mining. Very adaptable and flexible. FeedMeSQL 60% C# + ADO.net, 35 % Classic ASP + ADO, 5% T-SQL Universal SQL-to-HTML service that can work via web browser, write to file, or send thru e-mail. Older ASP version that has a 'middle tier' include file and a universal portal ASP file. ASP file interface needs admin login. Many reports in JRD use direct function calls to FeedMeSQL. The ASP page that requires admin passes SQL through the query string to FeedMeSQLL for those <15 min whip em up quick reports. .Net version has a FeedMeSQL.dll middle tier and a universal Portal .EXE and also a number of other processes call FeedMeSQL through the DLL. .Net FeedMeSQL can also do Basic or Pretty HTML, Excel, and CSV Biggest Time savings is when sending multiple result sets in separate worksheets in an Excel file. DataAssimilator. 90% C# + ADO.net, 10% T-SQL Imports an import data file into a staging table on any sql server. Currently supports CSV and one worksheet at a time from excel. Either can import to a pre-existing table or to just have it read the schema out of the import file and create a new table. Option to run an import script automatically after staging import is completed. Option to send a status report e-mail via FeedMeSQL.dll. PROJECT HISTORY - Allegro Medical - Scottsdale, Arizona Overhaul of shopping cart 50% T-SQL, 50% Classic ASP + ADO Previous system had an unsuccessful attempt to differentiate an order from a customer, which caused an inability to have an effective order history beyond the order date. Added support for storing and handling multiple addresses and multiple credit cards. Normalized product categories and product suppliers into separate tables so a product can have more than 1 category or more than 1 supplier. Product review system 60% Classic ASP + ADO, 40% T-SQL Short ratings survey plus a text review. Users can vote whether the review was helpful or not. Review rating questionnaires are customizable by product category. Summaries integrated into featured product rotators and product listings. Unlimited capacity featured product rotator 50% T-SQL, 50% Classic ASP + ADO Existing featured product system did not rotate and was limited to 6 products because of 1st normal form violation. Separate random pools for the home page, each category, and each subcategory. Pool entries were weighable. A weight of 4 would mean '4 entries into the pot', but only within the code, not in the database. Wheelchair configurator 70% Classic ASP + ADO, 30% T-SQL 3-Tiers: Sections, Sub-Sections, and choices. Custom configurator profiles for each product. Flexible enough to use on non-wheelchairs such as catheter sizes and product colors. Seamless integration into the shopping cart. Universal promotion system 75% T-SQL, 25% Classic ASP + ADO Fully integrated into the shopping cart. Highly flexible to accommodate marketing's unpredictable ways. Promotion conditions could be scope-restricted to one or more products, one or more subcategories or categories, one or more industries, or global. Promotion conditions can be expressed as product quantity or dollar amount. Promotion conditions can be greater than, less than, between, or equal too. Promotions can be locked by a coupon code with or without other conditions. Multiple promotion concurrency handling and automatic resolution of line-item conflicts. Tracking system 85% T-SQL, 15% Classic ASP + ADO Powers many of the memory features of the site. Visitors, Sessions, searches (keywords only), and limited page views. Able to generate reports on page views, sessions, visitors, search keywords, and logged in customers by product, subcategory, category, or industry. Used the SessionID to look up the most recent product, category, subcategory, or industry viewed by the customer and fed the 'continue shopping' button with that information to have the button send him back there automatically . EDUCATION SUNY Institute of Technology at Utica/Rome - Utica, NY September 1997 to May 1999 BS degree in Computer and Information Science Orange County Community College - Middletown, NY September 1994 to May 1997 AAS degree in Computer Information Systems REFERENCES Available upon request. BACK