Sql Server Computer Science

Patrick Riley

Fiskdale, MA. 774-***-**** *********@*****.***

Summary

I have over 10 years of Software and Web Development experience. I have used a wide range of tools and technologies over the course of my career as dictated by the customer or project. I have worked on projects using the latest web technologies including HTML5 and the AngularJS, MVC and MVVM frameworks. Over the years I have developed web applications using several different JavaScript libraries including jQuery, dojo and Prototype. I have modified and maintained legacy applications built with classic ASP, HTML, CSS and both JavaScript and VBScript. I have used several different programming languages create back end business logic and APIs including Python, C#, VB.net and VB6. I have used both SQL Server and Oracle Databases and I am experienced writing complex SQL, creating Procedures, views and tables. In addition to creating custom solutions I have integrated several COTs products into new or existing application. The COTS packages include BussinessObjects from SAP, Novient from Aderant and Mi-Forms from Mi-Corporation. I have experience with both Private and Government projects over the last decade.

Programming

Languages:

HTML, JavaScript, including several JS libraries (DoJo, Prototype, and JQuery), AngularJS, CSS, SQL, C#, VB.NET, ASP.net, Python, VBScript, JSON, XML

Software:

I have used a wide range of software development environments and tools including several versions of Visual Studio, Oracle, SQL Server, BusinessObjects and others.

Experience

Package Handler Feb 2017 – Present

FedEx Auburn, MA

Working nights at FedEx has granted me the opportunity to be a stay at home Dad and primary caretaker while my Wife advances her career

I have kept my coding skills current and added new skills by using sites like Puralsite,, Codewars and Codefighters.

Application Developer Dec 2015 – Jan 2016

Stinger Ghaffarian Technologies (SGT) Cambridge, MA

Developed user interfaces for Windows based touch pads using VB.Net and a VB.Net based COTS application to collect data used in scientific studies run by the National Highway Traffic Safety Administration (NHTSA)

Created and maintained C# code to both process and insure the integrity of collected data to be stored in SQL Server and Mongo DBs

I worked as part of small team to develop a web application used to standardize and consolidate variables used across multiple NHTSA studies using HTML, jQuery and SQL Server

I debugged, updated and helped develop the main application of the NASS Study which was created using Angular and C#

I had originally started work on this project while working for CSC, and moved with the project to SGT when they were awarded the federal contract in December 2015

Professional Programmer Analyst, Mar 2014 – Dec 2015

Computer Science Corporation (CSC) Cambridge, MA

Developed user interfaces for Windows based touch pads using VB.Net and a VB.Net based COTS application to collect data used in scientific studies run by the National Highway Traffic Safety Administration (NHTSA).

Created and maintained C# code to both process and insure the integrity of collected data to be stored in SQL Server and Mongo DBs.

I developed a web application requiring HTML, JavaScript, jQuery, CSS and SQL Server that helped to standardize and consolidate variables used across multiple NHTSA studies.

I debugged, updated and helped develop the main application of the NASS Study which was created using Angular and C#.

Professional Programmer Analyst, Jan 2009 – Mar 2014

Computer Science Corporation (CSC) Norwich, CT

In this role I developed, supported and maintained several applications that made up a Global Resource Management suite used to track and deploy tens of thousands of employees across hundreds of thousands of projects globally

For this project I created and maintained code using HTML, ASP, CSS, raw JavaScript and several different JavaScript libraries including dojo and Prototype, these applications required me to support several versions of both Oracle, SQL Server databases

I was the lead developer asked to design, integrate and deploy a BusinessObjects xi 3.1 (SAP) reporting environment utilized by the Global Management team to provide real-time on demand business intelligence as well as several predesignated reports, the implementation of which improved transparency and global staffing productivity by combining data from Oracle, SQL Server and other external data sources

I developed complex SQL queries used to identify and reduce licencing fees thereby saving $100K+ annually

Other recurring duties included data migration and API development requiring but limited to Python, SQL XML, JSON, VBscript and Excel.

Web Developer Feb 2006 – Dec 2008

Computer Science Corporation (CSC) Norwich, CT

Developed, updated and supported several legacy applications requiring working knowledge of Classic ASP, HTML, VBScript, SQL, JavaScript CSS

Developed a web based ad-hoc reporting engine to support a global employee management system utilized by multiple clients within CSC, created with HTML and JavaScript to connect to both SQL server and Oracle databases

This position ended after an 18 month effort to consolidate and coordinate the North American, Australian and European instances of custom build web based applications, several instances of a COTS application named Novient and multiple Oracle 8i and SQL Server databases into a single global resource management application suite that were compliant with to strict EU privacy laws

Technical Service Consultant, 2004 – 2006

Sprint Shrewsbury, MA

My duties included analyzing and resolving software and hardware issues on both standard cell phones and smart phones

I worked as part of a group that was responsible for monitoring and resolving regional network issues for Sprint's national CDMA network

Since this work location was attached to one of sprints preeminent retail locations my duties also included inventory control including shipping, receiving and tracking, and customer service since many repairs were performed on site

I was instrumental in developing an inventory control system using VBScript and excel that was being utilized through-out the district.

Technical Service Consultant 2002 - 2004

Best Buy Framingham, MA

As A member of the ``Geek Squad'' My duties included detecting, diagnosing and resolving hardware issues, including but not limited to data recovery from damaged or corrupt hard drives, upgrading or replacing computer components

I was also charged with resolving software and OS issues due to OS corruption and or virus and malware infections

Interaction with the general public is an important part of this position, the ability effectively communicate complex issue to users who do not have a high level of technical knowledge was a key reason for my success in this position, and a skill that has served me well in every position I have had since.

Head Boatman, Guide 1993 - 2001

Raven Adventure Trips Canon City, CO

In my role as Head Boatman I was responsible for allocating staff and resources in a highly dynamic, fast-paced environment. During my tenure I helped developed and implemented a 21- day training programs for new river staff. My duties also included acting as a liaison with other outfitters and the Bureau of Land Management. I helped develop efficient team building strategies and safety procedures.

Education

Bachelor of Science Degree, Information Technology 2005 - 2007

University of Massachusetts at Lowell

Bachelor of Arts Degree, Psychology 1988 - 1992

Indiana University of Pennsylvania

Oracle & Microsoft Solutions Developer Certificate 2002

Boston University Computer Career Programs

Cisco Academy CCNA Program 1998 - 2001

Red Rocks Community College

Contact this candidate