Projects

How can I help you?

Roberson Software Services is just me, Scott Roberson. Being in solo practice means I focus on my clients’ needs. It means I can deliver exceptional service with my own personal commitment.

I do Custom Business Programming. This means that I can do whatever your business needs. I can build a custom database application for you. Or I can help you modify an existing one. Perhaps you’re having a problem with your database, or you’d like it to do something else. I can also build a web-based database or develop an e-commerce site.In plain language, I can, for example, set you up to get information out of your accounting system and put it into an Excel spreadsheet with one click of a button. I can develop automated reports that analyze your inventory information. I can put your product information onto a website, or I can help you collect customer information from a website for marketing purposes.I can also offer help in intangible ways. Relying on my 8+ years of application development experience, I can help you understand the issues surrounding your software technology needs. People often don’t know what they want until they know what is possible.

Project Examples

  • Developed methodology for public key authentication to encrypt traffic through a forwarded tunnel to enable secure communication through the internet (SSH,SOCKS)
  • Developed backup routines using rsync, a linux differential backup routine (Ubuntu Linux, Debian Linux, rsync, ssh, chron)
  • Developed desktop-level C# form-based utility to display the calendar day in the taskbar of Windows (C#)
  • Developed numerous Oracle stored procedures and functions in pl/sql utilizing cursors, loops, and types that did everything from maintain data integrity to developing xml outputs of hierarchical data structures (Oracle 9.2, Oracle 10g, XML)
  • Developed Microsoft .NET Web Services to serve as a business layer to facilitate Role-based security for an end-user application.  Business logic was implemented in C# with outputs in XML (Microsoft .NET 1.1, C#, ADO, XML)
  • Designed & Developed an MS Access 2000 application that serves as a front-end to an Oracle DataMart database (MS Access 2000, ASP.NET, C#, Oracle 9.2)
  • Customized a PHP content-management system (Mambo) for a network management company allowing customers to log in and view statistics related to the services to which they subscribe (email messages delivered, viruses trapped, etc) as well as requesting services (online backup). Back-end Oracle data was used in animated Flash graphs. (PHP, Oracle 9.2, Flash, XML, HTML, CSS)
  • Developed a profit & loss analysis tool for a local investment management company that matches security trades, applies First-In,First-Out accounting principles, calculates the profit or loss, and creates Excel spreadsheets that highlight short-term and long-term capital gains. (MS Access 2000, Visual Basic)
  • Developed an internal, database-driven website for a large, direct marketing company to help manage product marketing, sales, and distribution. This website uses Lotus Notes/Domino as the middleware between the client browser and the back-end AS/400 (DB2) database system. (Lotus Notes/Domino, LotusScript, DECS, AS/400, SQL, D/HTML, JavaScript, CSS)
  • Developed a Microsoft Access database application to collect medical research information for a leading medical university research group.
  • Developed a Microsoft Access accounting application that records student printouts, computes billing totals, and charges their accounts for a university law school. The system integrates with the university billing system and with the printing server software. An integrated website allows the users to see their account balance and history of printouts. (MS Access, Visual Basic, DOS, SQL, ASP, HTML, CSS, JavaScript)
  • Developed a database-driven website for group e-mail list management for a major university. Students, faculty, and alumni can subscribe/unsubscribe to various e-mail lists. (Microsoft IIS, SQL Server, PHP, TML, HTML, CSS, JavaScript)
  • Converted a local company’s static website to a database-driven one so that they could manage their own website content, making changes to text and such without having to get a programmer to do it.
  • Built an administrative database-driven website to enable university staff and faculty to send individualized mass-emails. Related pages allow students to enter course evaluations that are reviewed online by the staff / faculty. (Microsoft IIS, ASP, VB Script, SQL, HTML, CSS, JavaScript)
  • Developed a database-driven website listing all public school jobs for a state Department of Education. 15,000+ registered applicants can browse and apply for 2000+ jobs. School system staffs have administrative functions. 800,000 page views in 2000. (Lotus Notes/Domino, JavaScript, LotusScript, D/HTML)
  • Built an e-mail-based communication application to coordinate company computer system-related events such as scheduled down-time, upgrades, application bug fixes, emergency repairs, etc. Users would complete an electronic Change Management Request form proposing times for their change. Department representatives would receive an email if their department would be affected. The email contained a link to the electronic request form and they could then accept or reject the request. The originator gets notified if the change is either accepted by everyone or rejected by any. (Lotus Notes/Domino, LotusScript)
  • Developed a database-driven website for advertising customers to upload display advertisements for publishing in the newspaper (www.ajcadweb.com) (Lotus Notes/Domino, JavaScript, LotusScript, D/HTML)
  • Developed silent auction websites for internal company fundraising for charity events. (Lotus Notes/Domino, JavaScript, LotusScript, D/HTML)
  • Developed Customer Relationship Management (CRM) system for 200 sales reps calling on 25,000 potential clients, sales tracking systems, forecasting database systems, direct marketing database management systems (Lotus Notes/Domino, FileMaker Pro, Microsoft Access)

Comments are closed.