Steven P.

Steven P.

Oak Ridge, United States of America
Hire Steven P. Hire Steven P. Hire Steven P.

About Me

Steven is a senior web developer with over 15 years of experience using the Microsoft technology stack. Much of Steven's experience has been spent developing heavily data-driven web applications utilizing strong SQL development skills. Steven's worked in small groups and corporate environments on a variety of projects from maintaining and optimizing legacy applications to planning and developing new applications.

AI, ML & LLM

Frontend

Backend

ASP.NET ASP.NET Web Forms ASP.NET MVC

Database

SQL T-SQL (Transact-SQL) Microsoft SQL Server SQL Server Management Studio

Other

C Visual Basic .NET (VB.NET) Web Services Windows Microsoft Visual Studio Microsoft Team Foundation Server

Work history

Lash Group
Senior Web Developer
2012 - Present (13 years)
Remote
  • Supported data-driven websites for specialty pharmacies for the Lash Group which provides patient services as part of AmerisourceBergen, one of the largest pharmaceutical distributors in the United States.

  • Oversaw and was responsible for external websites for doctor’s offices, patients, and pharmaceutical sales reps, as well as internal websites for managing data related to the external websites.

  • Served as the lead developer for websites supporting both external and internal users in an Agile work environment.

  • Acted as a subject matter expert for offshore resources for both development and testing.

  • Worked directly with many areas of the business—assisting product owners in setting timelines, business analysts in requirements gathering, testers in setting up test cases and bug reports, and release management in coordinating deployments.

  • Developed electronic signatures—populating PDF documents with data entered from a website. Then sending the documents to a third-party vendor so users can sign the documents on our websites.

  • Worked on electronic prior authorization—sending data via a JSON service to a third party vendor so users could use their form library and tracking the response data.

  • Maintained and enhanced electronic prescription web service integration. Developed updates to the web service itself as well as integration into websites for different clients.

  • Developed intranet websites that allowed users to review data before it gets pushed into the CRM system.

Primo Water
Senior Web Developer
2011 - 2012 (1 year)
Remote
  • Developed enhancements to Primo Water's existing internal tools for data management. Primo Water is the leading provider of self-service purified water and water dispensers in North America.

  • Developed applications for tracking water meters, managing logistical data across the United States, and Canada, as well as tracking shipments to and from customers.

  • Worked on UPS shipment tracking—sending and receiving data via a UPS web service to track shipments from the website and in SQL procedures.

  • Supported intranet applications for managing water meter readings. The data was fixed once it was committed so that the tools had to support auditing data.

  • Updated and optimized T-SQL stored procedures for processing financial data.

  • Managed internal business website—they were used for tracking sales, inventory, distribution, and more.

JavaScriptXMLC#Web ServicesT-SQL (Transact-SQL) ASP.NET Web Forms
TheraCom
Senior Web Developer
2010 - 2011 (1 year)
Remote
  • Created database reports using SSRS as well as creating an internal portal for managing SSRS reports. TheraCom was a specialty pharmacy distributor providing custom solutions to pharmaceutical companies.

  • Created and optimized SSRS reports to meet requirements provided by business analysts.

  • Built a SSRS reporting portal for viewing and managing SSRS reports. The site would parse XML files and store them in the database. Then used that data to allow users to input parameter values and view reports.

Visual BasicXMLSQL Server Reporting Services (SSRS) T-SQL (Transact-SQL) ASP.NET Web Forms
Guilford County Schools
Programmer Analyst 2
2008 - 2010 (2 years)
Remote
  • Served as the primary developer, supporting the human resources department with managing employee information. Guilford County Schools is one of the largest school districts in North Carolina.

  • Built an employee self-service portal—created a portal for employees to look up information, e.g., pay stubs or current information on file with human resources.

  • Managed data feeds between AS400 databases and Microsoft SQL Server databases.

  • Implemented general reporting and data management for the human resources department.

  • Developed a field trip manager website for tracking bus availability.

T-SQL (Transact-SQL) AS400Visual BasicC#ASP.NET Web Forms
Fourth Factor Technology Services
Software Developer
2005 - 2008 (3 years)
Remote
  • Worked for Fourth Factor Technology Services: a small privately owned company that provides technology solutions to a variety of businesses, from small local shops to large corporations.

  • Provided tech support for local businesses, built storefront websites, created internal solutions for managing employee benefits, and worked on public-facing corporate websites.

  • Created an employee phone program: a system for tracking employee phone usage. The company had it's own internal phone policy so we parsed phone records to calculate employee phone usage to compare to their allotted plans.

  • Built an event-planning portal: a website to book and manage flights and hotel rooms for a company trade show.

  • Developed an intranet photo gallery: a web-based tool for tagging and managing images.

  • Worked on an employee rewards program which included building a site for tracking an internal employee rewards program and allowed users to view their rewards and track progress.

Showcase

Data Warehouse Web and API Development for RtChex
  • Focused on web and API development for RtChex to scale business capacity.

  • Refactored web pages to handle larger data sets and improve customer experience.

  • Developed API enhancements including automated testing for customer data access.

Sunbelt Rentals
  • Client: Sunbelt Rentals

  • Project Focus: Website Overhaul

  • Current Site Status: Updated to newer technologies, but layout and data structures largely unchanged.

Healthcare Provider Portals
  • Developed and managed websites for healthcare providers to view and manage patient data.

  • Features include patient status review, benefit investigations, electronic signatures, prior authorization, and electronic prescriptions.

  • Prioritize security and HIPAA compliance through strict data access controls for users.

SSRS Reporting Portal
  • The SSRS Reporting Portal is an intranet website for managing SSRS reports.

  • Users can upload RDL files (report definition XML) to the portal.

  • The portal allows editing of report options like SQL parameters, title, description, and security roles.

UPS Return Tracking
  • A process was implemented for tracking bottle exchanges, generating return tracking numbers and labels.

  • A scheduled job monitored tracking numbers to ensure returns were mailed.

  • The process utilized UPS web services and SQL stored procedures for data monitoring and data storage.

Employee Self-service Portal
  • An intranet site for employees to manage their data, including contact information and address details.

  • Employees could review pay stubs through the website.

  • Management tools were provided for HR administrators to view, edit, and manage notifications and active dates.

Quota Tracking System for Marketing Surveys
  • Developed web pages for setting up quota rules.

  • Implemented logic for grouping rules into layered sets of conditional AND/OR criteria.

  • Created reporting tools for viewing quota matches and targets.

Education

Education
Bachelor of Science Degree in Computer Science
North Carolina State University
2000 - 2004 (4 years)