Scroll To View More
James Sun, Software Developer in Springfield, VA, United States
James Sun

Software Developer in Springfield, VA, United States

Member since July 29, 2015
James is now available for hire
James Sun, Software Developer in Springfield, VA, United States
James Sun

Software Developer in Springfield, VA, United States

Member since July 29, 2015
James is a software developer with over 20 years of experience helping organizations solve complex database, reporting, and system integration issues. He has worked on a variety of platforms and databases—including Microsoft and LAMP stacks.
James is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 20 years
  • Microsoft Access, 10 years
  • SQL Server Reporting Services (SSRS), 10 years
  • WordPress, 5 years
  • Crystal Reports, 3 years
  • Node.js, 3 years
  • Tableau, 1 year
Springfield, VA, United States

Availability

Part-time

Preferred Environment

Microsoft SQL Server

The most amazing...

...and complex systems integration project I'm currently working on supports the processing of thousands of applicants to a major U.S. graduate university.

Employment

  • Consultant

    2010 - PRESENT
    Casualty Actuarial Society
    • Developed a custom Microsoft Access application used for the CAS exam grading process. This is a semi-annual on site process where society fellows gather from across the U.S. and Canada to grade essay exams submitted by prospective fellows.
    • Developed a feature of the Access application which imports data from Microsoft Excel spreadsheets. The application also generates data which is imported into Excel as histograms. The Access application contains over 25 reports. Some reports have custom Access forms that are used to gather report parameters. Many reports have extensive report logic and complex grouping and sorting. Most reports are tabular, but some support multiple (newspaper) columns.
    Technologies: Microsoft Access, Adobe PDF
  • Senior Programmer and Analyst

    2009 - PRESENT
    Johns Hopkins University
    • Supported multiple functional areas—including registrar, admissions, and billing.
    • Developed custom SQL Server Reporting Services reports.
    • Developed and maintained automated processes to integrate three applications from different vendors—including a web-based application, an internal document management system (with workflow), and the university's student information system.
    • Acted as the lead developer for our internal OnBase (Hyland) document management system.
    • Developed a Salesforce-based application to help manage walk-ins to our one-stop student services help desk.
    Technologies: Microsoft SQL Server, OnBase (Document Management System), .NET (C# and VB)
  • Principal

    2008 - PRESENT
    Agile Media Ventures, LLC
    • Implemented a redesign for the Americas Diabetes Challenge website. This site was hosted in WordPress and had both English and Spanish versions.
    • Maintained several custom public-facing PHP and MySQL websites. Several of the web applications included subscription and one-time payment processing using PayPal.
    • Updated the content for a leading e-learning portal for emergency room nurses. This was a custom application developed with PHP and MySQL.
    • Developed the Power-of-a-Hug website using WordPress along with a few off-the-shelf plugins—including a front-end uploader, justified image grid, and PODS.
    • Supported custom reporting engagements for a major provider of secure print management solution. Custom reporting solutions were developed with a variety of tools—most notably SQL Server, Crystal Reports, and Tableau.
    Technologies: SQL Server, WordPress, PHP, MySQL, Node.js, MongoDB
  • Vice President for Software Development

    1998 - 2008
    American Technology Services, Inc.
    • Led teams that implemented multiple websites using various content management systems, including Ektron and DotNetNuke.
    • Managed the business development for the software development group—including writing proposals, and presenting at trade shows/conferences.
    • Led the team that developed the Bechtel Public Affairs Database (BPAD)—a web-based tracking system used by the internal PR department at Bechtel.
    • Served as the chief technical architect for the development of the Enterprise Information System (EIS) for the Petroleum Finance Company.
    • Led the development of the CU Analyzer—an ASP.NET/SQL Server application that allowed external customers to analyze the relative performance of a credit union as compared to its peers.
    Technologies: SQL Server, ASP.NET (C# and VB), Classic ASP, Ektron CMS, DotNetNuke

Experience

  • Sakura Matsui Festival (Other amazing things)

    In 2012—when the Internet of Things (IoT) was barely in its infancy—I served as the lead software developer for a team that completed a demonstration of a real-time, pedestrian monitoring system at Sakura Matsuri, a major street festival in Washington, D.C. The project was paid for with a grant via the Reliability IDEA program which is administered by the Transportation Research Board. The IDEA program funded proposals with potential to test innovative ways to improve the consistency or dependability of travel times, improve travel time prediction, and provide information to travelers and other highway system users when dealing with unexpected delays.

    The technical architecture consisted of five key elements: Bluetooth sensors, data server, messaging server, data publishers, and information consumers. PubNub served as the primary messaging backbone for our technical architecture. I developed a simple specification for how all messages should be formatted throughout the application. Once committed to the spec, the team was able to integrate publishers and subscribers very easily, across a variety of locations, platforms and technologies.

  • Automated Processes to the Support Admissions Cycle (Development)

    I worked as the lead developer on a project at a leading U.S. graduate school that integrates several different third-party web-based applications that support our admissions process. In addition to the day-to-day support of the various functional groups that use all three systems, I developed a series of automated tools and processes to integrate all three systems. The tools have been developed using a variety of programs and languages (primarily on the Microsoft platform), including PowerShell, C# (custom command-line executables), SQL Server stored procedures (T-SQL), and Python.

Skills

  • Languages

    T-SQL, SQL, Python 3, Python, JavaScript, PHP
  • Tools

    Microsoft Access, Crystal Reports, Tableau
  • Platforms

    OnBase, WordPress
  • Storage

    SQL Server Reporting Services (SSRS), Microsoft SQL Server, MySQL, MongoDB
  • Libraries/APIs

    jQuery, WordPress API, Node.js

Education

  • Bachelor of Science in Economics (Strategic Management)
    1986 - 1990
    University of Pennsylvania - Philadelphia, PA, USA
I really like this profile
Share it with others