ReCasa Financial Group – Loan Tracking and Invoicing System – System Upgrade, 7/2015 – 9/2015
- Technologies/Tools: C#, ASP.NET, JavaScript, .NET Framework 4.5, IIS 7.5, SQL Server 2012, T-SQL, ActiveReports.NET, Amazon AWS
- Principal architect for upgrade of ReCasa Loan Tracking system that Arisen built in 2004.
- Upgraded database from SQL 2000 to SQL 2012, upgraded from .NET Framework 1.1 to .NET Framework 4.5, moved hosting to Amazon AWS cloud.
- Directed rewrite of New Deal Worksheet portion of system from an ActiveX VBA Excel workbook embedded in the web application to an Excel application using C#.
- Upgraded and enhanced security to database server
- Team Members: Bridget Smith, Steve Keller, Rebecca LaBrake
Nestlé VeryBestBaking.com – Phase 3, Resource/Ammirati, 5/2015 – 7/2015
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.5, VS 2013, MVC 3, Entity Framework, SQL 2008 R2, Sitefinity CMS, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Added Facebook sign-in authentication and integrated it with Nestle CR3 user service
- Consolidated header navigation for MVC and Sitefinity pages
- Added new category types and categories for recipe search
- Updated keyword search on desktop and responsive mobile views
- Created responsive template for article pages for use on mobile, tablet, desktop devices
- Integrated Live Chat functionality into site
- Added support for images and videos in recipe instructions
- Team Members: Brent Bogrees, Kim Hamper, Lauren Subler, Owen Gwilliam, Vanessa Keller
United Dairy Farmers – Site Redesign, Resource/Ammirati, 4/2015 – 6/2015
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.5, Umbraco CMS, VS 2010, SQL 2008 R2, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Created data export program from prior UDF Umbraco CMS site user data to .yaml files for use in new site redesign
- Produced data dump for production release
- Team Members: Ryan Landers, Cameron Tullos, Kevin Kaiser
White Castle – Website Transition, Resource/Ammirati, 2/2015 – 7/2015
- Technologies/Tools: C#, JavaScript, Ajax, AngularJS, jQuery, ASP.NET, .NET Framework 4.5, IIS 7.5, SQL Server 2012, T-SQL, Amazon AWS, Amazon S3, Redis
- Helped complete transition from prior advertising agency vendor to Resource/Ammirati
- Set up build process and set up DEV, QA sites on Amazon AWS
- Ensured delivered source code could be built and regression tested to match what was in production
- Resolved CMS file upload issues to Amazon S3 storage
- Created SQL database scripts for Craver ID (loyalty card) reports and automated report delivery
- Created responsive email templates for loyalty card member emails
- Installed and configured Redis key/value cache store
- Updated site from SliderGram to Castle Card including CMS and AngularJS views
- Team Members: Chad Jackson, Cameron Tullos, Darren Cunningham, Vanessa Keller
United Dairy Farmers – Web Service Upgrade, Resource/Ammirati, 1/2015 – 3/2015
- Technologies/Tools: C#, ASP.NET, Umbraco CMS, .NET Framework 4.5, VS 2010, SQL 2008 R2, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira, Amazon AWS
- Updated Excentus web service from SOAP to REST for loyalty card tracking
- Helped complete move of udrivefuel.com site from prior hosting platform to Amazon AWS
- Transferred and imported database from prior host to Amazon AWS Elastic Beanstalk database
- Set up single-click deployments to Amazon AWS using AmazonAWS SDK in Visual Studio
- Fixed issue in email address validation
- Updated media permissions to allow uploading of images through Umbraco to Amazon AWS
- Proposed resolution for handling loyalty card alternate IDs with third-party processor
- Team Members: Ryan Landers, Cameron Tullos, Darren Cunningham
DiGiorno Pizza Super Bowl Promotion, Resource/Ammirati, 1/2015
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.5, MVC 3, VS 2010, SQL 2008 R2, Git, Atlassian Stash, Atlassian SourceTree
- Helped resolve site/server issues prior to Super Bowl promotion launch
- Helped resolve Bamboo build setup issues
- Team Members: Bridget Smith, Brent Bogrees
Hewlett-Packard Las Vegas 2015 Discover Conference Portal, Resource/Ammirati, 2/2015 – 4/2015
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2012 Conference in Frankfurt, Germany
- Principal architect - Created and implemented server-side architecture for website
- Supervised gap analysis for transition from Active Networks to WEG API for session, speaker, demo, track, and sponsor data
- Created architectural plan for updating the Discover data import process for the new API
- Guided HP personnel implementing the new data import process
- Team Members: Karm Parker, Chad Summervill, Hector Flores
Nestlé VeryBestBaking.com – PumpkinCan Integration, Resource/Ammirati, 12/2014 – 4/2015
- Technologies/Tools: JavaScript, AngularJS, jQuery, isotope.js, VS 2013, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Integrated PumpkinCan microsite into VeryBestBaking.com
- Developed front-end modifications and optimizations (JavaScript, AngularJS)
- Updated social support, detail page, and filtering
- Added YouTube video support into PumpkinCan
- Added support for promotions on recipe page in Other Suggestions area
- Added support for Libby’s Pumpkin coupons
- Updated verybestbaking.com to include responsive sub-menu navigation
- Added intrinsic ratios to image and video containers to make the isotope layout and animation better
- Built and released web application to stage and production on Nestle servers
- Team Members: Brent Bogrees, Jacqueline Clark
Hewlett-Packard Barcelona 2014 Discover Conference Portal, Resource/Ammirati, 8/2014 – 12/2014
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2012 Conference in Frankfurt, Germany
- Principal architect - Created and implemented server-side architecture for website
- Completed Event Platform site migration to HP Sitebuilder platform
- Helped HP personnel learn how to set up a new event for Discover Barcelona 2014
- Trained HP personnel on use of Livestream and on-demand video administration
- Updated to allow user scheduling of sessions for conference
- Moved Discover reporting to new servers
- Team Members: Karm Parker, Adam Oakley, Michele Degani, Hector Flores
Nestlé VeryBestBaking.com – Phase 2, Resource/Ammirati, 10/2014 – 12/2014
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.5, MVC 3, Entity Framework, JavaScript, Ajax, VS 2013, SQL 2008 R2, Sitefinity CMS, BazaarVoice, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Helped direct integration of MVC site into Sitefinity CMS
- Designed and implemented database connectivity for Sitefinity CMS in the Nestlé server environment
- Created BazaarVoice XML product feed generation
- Integrated BazaarVoice rating and comment components into the recipe and product detail pages
- Created Favorites service to allow users to select and track favorite recipes
- Helped Nestle engineers resolve server deployment issues
- Team Members: Brent Bogrees, Brett Whittington, Jesse Hemminger, Lauren Subler, Jacqueline Clark
Nestlé VeryBestBaking.com Redesign, Resource/Ammirati, 7/2014 – 9/2014
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.0, MVC 3, Entity Framework, JavaScript, Ajax, VS 2010, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- New site redesign for Nestle Toll House, Libby’s Pumpkin, and Carnation Milks
- Principal Architect - designed MVC server-side architecture for website
- Created recipe search and product search pages
- Designed and implemented C# service classes to interact with Nestlé MRS web service
- Added caching for products and recipes
- Optimized recipe and product search pages for SEO
- Created Coupon Service to handle coupons for Toll House and Carnation
- Set up and tested DEV, QA, and Stage servers.
- Team Members: Brent Bogrees, Kevin Kaiser, Adam Weis, Aaron Himmel, Jacqueline Clark, Amanda (Arnett) Hurte
TidyCats.com Littervention Promotion, Resource/Ammirati, 6/2014 – 7/2014
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.0, MVC 3, Entity Framework, LINQ, JavaScript, Ajax, VS 2010, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Created scripts for database schema updates
- Created Littervention registration page, photo upload, and Littervention Gallery and integrated with TidyCats.com site
- Integrated with web service for social aggregator
- Added support for coupons
- Team Members: John Keber, Bridget Smith, Rajesh Subramanian
Hewlett-Packard Las Vegas 2014 Discover Conference Portal, Resource/Ammirati, 2/2014 – 6/2014
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, LINQ, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2012 Conference in Frankfurt, Germany
- Principal Architect – Created and implemented server-side architecture for website
- Planned and executed migration of Event Platform to new server platform within HP
- Implemented jump ID handling for marketing campaign tracking
- Helped plan and implement ad campaign landing pages
- Guided HP personnel in making content zone updates for the conference site
- Created Videos page for Las Vegas 2014
- Added Google snippet for SEO
- Team Members: Ryan Landers, Andrew Hellard, Demond Smith, Karm Parker, Chris Taylor, Michele Degani, Hector Flores
Purina Cat Chow WhyWeight Promotion, Resource/Ammirati, 3/2014
- Technologies/Tools: C#, ASP.NET, .NET Framework 4.0, MVC 3, Entity Framework, LINQ, JavaScript, Ajax, VS 2010, SQL 2008 R2, T-SQL, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- Created WhyWeight registration page with unobtrusive validation
- Created jsonp endpoint for results and updated Campaign Manager
- Team Members: John Keber
Hewlett-Packard Barcelona 2013 Discover Conference Portal, Resource Interactive, 6/2013 – 12/2013
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, LINQ, SQL 2008 R2, T-SQL, Subversion, Git, Atlassian Stash, Atlassian SourceTree, Atlassian Jira
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2013 Conference in Barcelona, Spain (December 2013)
- Principal Architect – Created and implemented server-side architecture for website
- Trained Resource personnel on how to create a new event in the Event platform
- Helped migrate code base from Subversion to Git
- Created Report Processor for Discover and updated it to generate encrypted Excel documents
- Created architecture for single sign-on mechanism between Discover and Active Networks web applications
- Added back-end service for Session Catalog searching
- Designed architecture for Sponsors pages
- Designed new user role tracking per event
- Defined and reviewed Exhibitor and Session API changes for Speakers and Sponsors pages
- Defined new site architecture and new site map for Barcelona event
- Designed architecture for synchronizing My Briefcase items between Discover database and HP mobile application
- Guided implementation of Active Network API import modifications
- Trained front-end developer in how to use partial views for pages
- Updated import process to handle alias names for XML elements due to Las Vegas/Barcelona Active API schema differences
- Created SQL queries for in conference user reports
- Added support for auto-reset of locked out users after configurable wait time
- Added service for saving users’ conference schedules
- Team Members: Andrew Hellard, Barrett Tenney, Nick Mele, Sherri Divierte, Chris Taylor
Hewlett-Packard Las Vegas 2013 Discover Conference Portal, Resource Interactive, 4/2013 – 6/2013
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, LINQ, SQL 2008 R2, T-SQL, SubversionSVN
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2013 Conference in Las Vegas (June 2013)
- Principal Architect – Created and implemented server-side architecture for website
- Designed database schema for conference event
- Created video state manager page to ease management of live and on-demand videos during the HP conference
- Evaluated Vivastream API and integration
- Refactored source code to more easily support multiple distinct conferences simultaneously
- Directed gap analysis of Active Network API differences between Frankfurt 2012 conference and Las Vegas 2013 conference
- Created QR code jump service
- Helped direct site navigation and architecture modifications to allow access to past events and current events at the same time
- Updated handling of search filters and corresponding back-end service calls
- Directed data exports/imports for new web application and database
- Built and deployed versions of Discover and CIO Summit for DEV, QA, ITG, and Production servers
- Provided technical guidance for issue resolution during the HP conference
- Team Members: Ryan Landers, Andrew Hellard, Luke Askew, Nick Mele, Chris Jeunelot, Chris Taylor
Hewlett-Packard Global Partner Conference Portal 2013, Resource Interactive, 1/2013 – 5/2013
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, LINQ, SQL 2008 R2, T-SQL, SubversionSVN
- The site allowed users to search and watch digitally recorded keynote speeches and conference sessions for the HP Global Partner Conference in Las Vegas (March 2013)
- Principal Architect – Designed and implemented server-side architecture for website
- Added localization and multi-event support to the event platform for all pages, content zones
- Created services for Polls, Comments, Ratings, and comment moderation for sessions and speakers
- Designed database schema for multi-lingual event platform and added support for polls, surveys, comments, ratings
- Created EventDataService methods for retrieving Session Summaries by Track and by Session Type
- Created architectural design for HP Global Partner Portal security and keeping it separate from Discover authentication while in the same web application
- Designed and implemented translation export/import for content so that it could be translated by translations.com
- Set up DEV, QA servers
- Team Members: Ryan Landers, Josh Greenwald, Luke Askew, Nick Mele, Chris Jeunelot, Darren Cunningham, Jill Bremer, Chris Taylor
Hewlett-Packard Frankfurt 2012 Discover Conference Portal, Resource Interactive, 8/2012 – 12/2012
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, MVC 3, Entity Framework, LINQ, SQL 2008 R2, T-SQL, SubversionSVN
- The site allowed users to search and watch live and digitally recorded keynote speeches and conference sessions for the HP Discover 2012 Conference in Frankfurt, Germany (December 2012)
- Principal Architect – designed and implemented server-side architecture for website
- Designed database schema for conference event
- Created Event Content Request application for content request from HP to Resource
- Created AccountService for Login, Register, Upgrade Registration
- Created ActiveService to retrieve XML data feed from Active Networks API and to import data to database.
- Wrote service methods for searching and sorting conference session data
- Created Session Search view with knockout.js binding for search criteria and results
- Added handling of data feed from Design Reactor for digitally-recorded video metadata
- Added iCal calendar support for sessions
- Implemented Extras Finder search page to allow user to find downloadable session extras
- Implemented My Briefcase service for bookmarking favorite extras
- Created time-based content zone filtering
- Added SMIL file support for session video playback
- Added support for QR-code short urls
- Added output caching and Twitter feed caching
- Added cross-site scripting prevention
- Provided technical guidance for issue resolution during the HP conference
- Team Members: Ryan Landers, Josh Greenwald, Luke Askew, Nick Mele, Jill Bremer, Chris Taylor, Gary Yochum
Hewlett-Packard Graphic Arts Portal, Resource Interactive, 8/2012
- Technologies/Tools: C#, ASP.NET, .NET Framework 3.5, VS 2008, SQL 2005, T-SQL, XML
- Added Hi-Flex support to existing Hewlett-Packard web application
- Multilingual: English, French, German, Japanese, Korean, Portuguese, Spanish, Simplified Chinese, Traditional Chinese
- Team Members: Jeff Griffith
McGraw-Hill Education – Building Blocks Assessment, Horizons [Companies], 3/2012 – 8/2012
- Technologies/Tools: JavaScript, jQuery, PHP, MySQL, McGraw-Hill ConnectED web service
- Principal Architect – created architecture for web application used by teachers to assess and track student progress in Building Blocks math curriculum
- Team Members: Tina Frissora, Chris Jeunelot, Amanda Kleinpaste, Cherie Hatton, Jon Adams
McGraw-Hill Education – Fusion Reading Learning Management System, Horizons [Companies], 1/2012 – 6/2012
- Technologies/Tools: JavaScript, jQuery, PHP, MySQL, McGraw-Hill ConnectED web service
- Principal Architect – Created web-based multi-media learning management system for teachers learning Fusion Reading
- Team Members: Tina Frissora, Aaron Denny, Cherie Hatton
Hewlett-Packard Print Excellence Awards Contest Platform, Resource Interactive, 10/2011 – 1/2012
- Technologies/Tools: C#, ASP.NET, .NET 4.0, VS 2010, SQL 2008 R2, MVC 3, T-SQL, JavaScript, jQuery, Ajax
- Helped create architecture and implementation of multi-lingual contest platform for Hewlett-Packard’s Print Excellence Awards
- Multilingual: English, French, German, Japanese, Korean, Portuguese, Spanish, Simplified Chinese, Traditional Chinese
- Team Members: Ryan Landers, Jason Shigley, Luke Askew, Krupali Bhayani
Hewlett-Packard Capture – Phase 4, Resource Interactive, 9/2011 – 10/2011
- Technologies/Tools: C#, ASP.NET, .NET Framework 3.5, VS 2008, SQL 2005, T-SQL, XML
- Multilingual: English, French, German, Japanese, Korean, Portuguese, Spanish, Simplified Chinese, Traditional Chinese
- Team Members: Ryan Landers
Ohio Department of Development – OCEAN (Ohio Community Energy Assistance Network) Phase 2, 9/2009 – 9/2011
- Technologies/Tools: C#, ASP.NET, .NET Framework 3.5, Entity Framework, LINQ, SQL Server 2008, T-SQL, JavaScript, Team Foundation Server, Telerik RadControls for AJAX
- Principal Architect and Technical Lead for five-million dollar Phase 2 of the Ohio Community and Energy Assistance Network (OCEAN) project
- OCEAN is a web-based solution designed to centralize data collection, reporting mechanisms and perform eligibility determinations for applications to energy assistance programs offered by the State of Ohio.
- Defined User Interface Guidelines and Programming Guidelines for entire team
- Defined Software Configuration Management process for team
- Reviewed architecture and design for Electric Partnership Plan (EPP) subsystem
- Directed transition of business logic in stored procedures to C# business tier
- Designed and directed implementation of security subsystem
- Helped design Grant, Encumbrances, Distributions
- Gathered requirements from users through field visits, energy audits
- Reviewed functional specification documents for EPP, Inventory
- Wrote benefit determination services for HEAP/E-HEAP to calculate benefits for energy assistance customers
- Coordinated transition to Team Foundation Server for source code revision control, build and deployment
- Team Members: Brian Cooksey, Brian Bare, Chris Jeunelot, Matt Casto, Bridget Smith, Dennis Dunn, Chris Goelz, Jeff Hume, Brian Schultek, Ranjitha Ponnan, Phoebe Hyder, Seowa Gbala, Sarah Fitch, Levi Levingston, Ryan Kaelin, Amy (Neumann) Nicholas, Jason Wood, Krupali Bhayani, Anshul Vishwakarma, Gerald (Jay) Kastigar, Anne (Kissh) Kuschnerus, Matt Clark, Madhu Pidisetti, Sabitha Ganneboina, Hong Li, Yuping Wang, Christine Gilman, Bill Sempf, Shawn Robinson, Chris Bowsher
Ohio Department of Development – OCEAN (Ohio Community Energy Assistance Network) Phase 1, 10/2005 – 9/2009
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1/3.5, ADO.NET, SQL Server 2005, T-SQL, JavaScript
- Helped rescue the Ohio Community and Energy Assistance Network (OCEAN) project which had fallen behind schedule due to work of another vendor
- Helped release OCEAN for HEAP/Winter Crisis/Summer Crisis Programs 2007, 2008, 2009 processing over 800,000 applications per year
- Optimized significant system components in C# for Data Access layer, Client Search, Payment Batching, and T-SQL database stored procedures to allow over 400 simultaneous system users
- Responsible for implementing Payment Reconciliation Processing for direct credits, vouchers, and warrants between state and utility companies
- Gave technical direction to three (3) development staff and five (5) other consultants for specific issue resolution and for better coding techniques in C# and in T-SQL stored procedures
- Created development tool (OCEAN Workbench) to optimize and eliminate errors in developer database synchronization and in database script deployment. Typically saves development staff 1 hour/developer/day
- Created batch job processor Windows service that is responsible for batch job processing including all nightly export jobs for direct credits and payment processing and for importing accepts/rejects files from utility companies
- Suggested, designed, and implemented the online reconciliation of direct credit payments for utility vendors which eliminated the need for voucher processing and dramatically decreased time for client to received credit and for utility vendor to receive payment
- Developed T-SQL error handling technique that reduced the lines of code and could precisely pinpoint exact line in stored procedure on which an error occurred. Created error handling code template and trained other developers.
- Helped other development staff prepare pages and implement ASP.NET Ajax support.
- Team Members: Brian Cooksey, Chris Jeunelot, Jeff Miller, Shawn Robinson, Chris Bowsher, Oleg Chystyakov, Li Wang, Buddy Karvois
The Ohio State University Alumni Association – Nightly Synchronization of University database to Alumni Association database, 11/2007 – 7/2008
- Technologies/Tools: SQL Server 2005, SQL Server Integration Services (SSIS), T-SQL, C#, ASP.NET, .NET Framework 2.0, ADO.NET
- Worked closely with Alumni Association IT Director and Database Administrator (DBA) to quickly understand the business process for synchronization project that had fallen behind schedule
- Helped define data transformations needed to transform data from non-relational University database to highly normalized Alumni Association database
- Provided technical direction to DBA and another consultant for synchronization stored procedure development including optimization and error handling
- The data flow for detecting data differences in the source database, transforming the data from non-relational to relational, transforming key values, and synchronizing the target database required multiple databases, over 300 tables, hundreds of stored procedures
- Suggested technique for writing scripts in a way that allowed them to be tested against one set of databases in a test environment and deployed to other databases in production environment quickly and without alteration – speeding deployment and eliminating errors. Implemented technique using Synonyms.
- Created ASP.NET web application to allow Alumni Association personnel to request University ID numbers for new alumni association enrollees
- Team Members: Michael Meeker, Jon Shoberg, Martin Winders
Traxion IT – Managing In The Zone web application, 4/2007 – 10/2007
- Technologies/Tools: C#, ASP.NET, .NET Framework 2.0, ADO.NET, SQL Server 2005, T-SQL, JavaScript, LLBLGen Pro
- Worked closely with President to design sales management review and tracking system to be offered as an Application Service Provider through distributors to client companies
- Principal Architect – designed user interface workflow and SQL Server database schema
- Customized framework security subsystem to handle multi-level distributors and extended XML data-driven security sitemap
- Coordinated 100% of programming and testing to deliver system that exceeded client expectations
- Team Members: Jason Shigley, Julia Choops, Paul Carpenter
ReCasa Financial Group – Loan Tracking and Invoicing System – Phases 2 & 3, 4/2006 – 11/2007
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1, O/R Mapper, SQL Server 2000, T-SQL, ActiveReports.NET, Salesforce.com
- Worked closely with Controller and VP of Sales to design New Deal Worksheet subsystem for sales people to gather potential borrower information and for underwriters to analyze borrower risk prior to lending.
- Principal architect and technical lead for team of three that developed, tested, and deployed subsystem that integrated Microsoft Excel and web service into Phase 1 web application.
- Created new accounting data reports used to facilitate movement from QuickBooks to Great Plains.
- Directed the integration of the ReCasa loan system with Salesforce.com
- ReCasa processed nearly 600% more loans now than prior to system implementation.
- Team Members: Jason Shigley, Julia Choops, Robert Calhoun, Steve Keller
Ohio Department of Development – Independent Validation and Verification, 5/2005 – 6/2005
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1, ADO.NET, SQL Server 2000, T-SQL, JavaScript
- Solely responsible for reviewing approximately 900 C#, T-SQL, and JavaScript source files for new .NET web application for the Ohio Community and Energy Assistance Network (OCEAN)
- Produced 100 page document of observations and recommendations for areas such as how to decrease database round trips by 85%, fix security holes open for SQL injection attacks, etc.
- Team Members: Shawn Robinson, Nick Sunday
Executive Jet Management/NetJets – Availability/Scheduling System for Subcontract and Charter Flights, 2/2005 – 4/2005, 7/2005
- Technologies/Tools: Visual Basic .NET, ASP.NET, .NET Framework 1.1, SQL Server 2000, SQL DTS, T-SQL, ActiveReports.NET, Microsoft Excel, VBA
- Worked closely with Vice President to quickly understand business process, define system goals and requirements, and implement a solution that saves company thousands of dollars per day
- Created Excel front-end and new ASP.NET web application that eliminated the data-corruption issues prevalent in a prior system and significantly increased throughput of process
- Reduced generation time of executive analytical reports from days to seconds to allow for more reliable and faster decision making and potentially saving company several million dollars per year
- Team Members: Jeff Reid, Brian Gallagher
Procter & Gamble – Virtual Special Pack Retail Promotion System, The NTR Group, 6/2003 – 1/2005
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1, O/R Mapper, SQL Server 2000, T-SQL, ActiveReports.NET, XML, Flash MX 2004
- Technical point person for writing, negotiating, and securing contract with Procter & Gamble
- Phase 1 (10/2003 – 3/2004): Developed C# program for patent-pending process that processes retail transaction logs and tabulate matches for virtual special pack promotions; coordinated test with Meijer
- Phase 2 (3/2004 – 1/2005): Principal architect and technical lead for team that developed ASP.NET application to allow manufacturers (e.g. Procter & Gamble) to create virtual special packs of UPC numbers for promotions, to allow retailers to upload transaction logs, to process transaction logs, and to report incentive payouts based on the number of promotion matches in the transaction logs.
- Dramatically reduced time frame and eliminated packaging and warehouse costs of traditional special pack promotions
- Team Members: Julia Choops, Brian Cooksey, Jason Shigley, Paul Carpenter, Joseph Balbo, Paul White
ReCasa Financial Group – Loan Tracking and Invoicing System, 6/2004 – 10/2004
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1, O/R Mapper, SQL Server 2000, T-SQL, ActiveReports.NET
- Worked closely with President and Controller to design ASP.NET workflow system for loan initiation, funding, invoicing, and payoff of specialty financing for residential property rehabilitation market
- Principal architect and technical lead for team of four that developed, tested, and deployed system
- System reduced invoice generation from days to minutes and eliminated possible interest calculation errors
- Within six months of deployment, ReCasa was processing 3 times the number of financed loans (something that would not have been feasible with the prior system)
- Team Members: Jason Shigley, Julia Choops, Brian Cooksey, Steve Keller
Textron Financial Corporation – Net Collectible Value Analytical System, 4/2004 – 8/2004
- Technologies/Tools: Visual Basic 6, ADO 2.x, SQL Server 2000, T-SQL, ActiveReports, XML, EDI, Extreme Translator, Citrix
- Worked closely with business area expert to determine requirements for a Net Collectible Value system to allow collateral specialists to import and analyze Explanation of Benefit (EOB) records from healthcare providers to determine potential financing for those providers
- Principal architect and technical lead for team that created client-server (mandated) system to parse and import X12 835 EDI (Health Care Claim Payment/Advice) files and allow analytical data filtering and reporting
- System processed data in ways not feasible before and provided new insight for executives in the financing process to greatly minimize risk
- Team Members: Brian Cooksey, Patrick Quinton, Art Yarumian
Subaru North America – “Drive Your Cares Away” Sweepstakes, The NTR Group, 10/2003 – 12/2003
- Technologies/Tools: C#, ASP.NET, .NET Framework 1.1, SQL Server 2000, T-SQL, Flash MX
- Technical point person for sales process and negotiations
- Directed creation of “Subaru – Drive Your Cares Away” promotion for the Cincinnati and Indianapolis markets whereby consumers were driven to website from print/TV/radio ads to enter sweepstakes and print certificate for 2 years of free service with the purchase of a new Subaru
- Redemption of certificates leading to new auto purchases was higher than projected
- Team Members: Julia Choops, Paul Carpenter, Brian Kotenko
Grange Insurance Company – Personal Lines Workflow, Results Engineering, 7/2003 – 11/2003
- Technologies/Tools: Visual Basic 6, IBM DB2, ActiveReports
- Technical lead for designing and implementing reporting system for Grange Personal Lines workflow system.
- System provided status and analytical reporting for management to more effectively meet application processing targets and increase workflow throughput
- Team Members: Scott Mills
Kodak Archive Writer System, Results Engineering, 5/2003 – 10/2003
- Technologies/Tools: Visual Basic 6, Kodak Archive Writer, OnBase Imaging System, ADO 2.x
- After others were unable to successfully create a working product, I was called in
- Designed, created, and documented product to allow the easy archiving of documents from imaging systems (such as OnBase) to microfilm via the Kodak Archive Writer for long term backup records storage
- System is currently being marketed and sold to county departments (e.g. Delaware County, Wood County in Ohio) and other organizations in need of long-term archival backup of electronic documents
Procter & Gamble – Web-based Promotions Builder, The NTR Group, 3/2002 – 10/2002
- Technologies/Tools: ASP, IIS, ADO 2.x, SQL Server 2000, T-SQL, Flash 5
- Principal architect of new promotions builder system to allow Procter & Gamble to quickly set up promotions, instant-win games, and sweepstakes for their brands and retailers
- Led team that created games such as Fill-In & Win, Multibrand Fill-In & Win, Clip & Win, Scrambler, and Crossword intended to educated and reinforce brand attributes during sweepstakes submission
- System created to save time and money and allowed for much quicker reaction to market conditions by reducing calendar time required to create new promotions from months to a couple of days
- Team Members: Julia Choops, Paul Carpenter, Southy Grinalds
Grange Insurance Company – Commercial Lines Workflow, Results Engineering, 3/2002 – 6/2002
- Technologies/Tools: Visual Basic 6, IBM DB2, ActiveReports
- Designed and implemented reporting system for Grange Commercial Lines workflow system.
- System provided status and analytical reporting for management to more effectively meet application processing targets and increase workflow throughput
- Team Members: Tom Wible
Grange Insurance Company – Commercial Lines Workflow, Results Engineering, 12/2001 – 1/2002
- Technologies/Tools: Visual Basic 6, InputAccel, IBM DB2
- Converted InputAccel watcher program from C to Visual Basic and added enhancements to allow multiple processes to copy files from InputAccel servers.
- Program provided reliability and verifiability of nightly processing required for workflow system
Command-Alkon Corporation – EBatch Code Review, Results Engineering, 12/2001
- Technologies/Tools: Visual Basic 6
- Provided consulting for development staff regarding VB control development for EBatch ready-mix concrete batching system.
- Team Members: Craig Yeack
Rayovac – CD In-Pack Promotion for Christmas 2001, Rhinosoft Interactive, 4/01 – 8/01
- Technologies/Tools: Macromedia Director
- Technical lead for CD in-pack promotion whereby Who Wants To Be a Millionaire – Sports Edition, Tomb Raider II, or Disney Arcade Frenzy was included in packages of Rayovac batteries as an incentive for consumers to purchase Rayovac brand instead of competitors’ brands
- Created multimedia user interface for CDs to feature Rayovac marketing message and allow consumers to install and play games
- Worked closely with representatives of Rayovac, Disney Interactive, and Eidos to produce CDs
- Over 300,000 CDs were published
- Team Members: Greg Swan
Pacesetter Apparel – Enterprise Website for Ad Specialties Distributor, 2/2001 – 3/2001
- Technologies/Tools: ASP, HTML, Javascript
- Worked with President to design website (YourLogoOurCoolStuff.com) to align with other marketing collateral
- Created website that integrated with Advertising Specialties Institute (ASI) for online catalog of over 500,000 promotional items
- System allowed creation of promotions and promotional codes to track advertising success
- Consulted and reviewed code for Corporate Store offering
- Team Members: Jon Price
View Kevin's profile