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.
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.
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.
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.
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.
On this project, the bulk of my work consisted of web and API development for RtChex to help them scale up their business capacity. This specifically involved refactoring their web pages so they could handle larger data sets and improve the customer experience. I also developed enhancements to their API to enable customer access to more data; automated testing was included for all API enhancements.
At Fourth Factor Technology Services, one of our clients was Sunbelt Rentals. One of our bigger projects was overhauling their primary website. The bulk of my work was on their equipment catalog pages. The site has since been upgraded to newer technologies, but the layout is still very similar and the back-end data structures haven't changed much.
I created and managed websites for healthcare providers to view and manage patient data. These are secure websites that allow users to perform various patient-related tasks. Some features include reviewing patients' status, benefit investigations, electronic signatures, prior authorization, and electronic prescriptions. Some of these features utilized web services and data feeds to communicate with external vendors.
Security is very important for these sites. Users must only be able to view their own patient information. HIPAA violations are always a concern and controlling who can view what data is vital.
Clients included companies like Bayer, Janssen, Lundbeck, and more.
The SSRS reporting portal is an intranet website for managing SSRS reports. An SSRS server was not available so this website was created instead. The site allows users to upload RDL files (report definition XML files). The uploaded files are parsed and the user is then allowed to edit certain report options like the SQL parameters, report title, report description, and security roles.
These reports are then stored in the database and made available to users based on their approved security groups. Reports are viewed on the SSRS reporting portal itself or on other websites based on the security roles assigned to the reports.
This was a process for tracking bottle exchanges. When a bottle was sent out to a customer a return tracking number and label would be generated. A scheduled job was created to periodically check these tracking numbers to get the status of the return. Customers would be emailed reminders if the return had not been mailed after certain periods of time. The tracking numbers were also monitored to make sure the return bottles were received after they had been shipped.
This process used UPS web services to monitor the data. The UPS services were called from MS SQL stored procedures as well as websites. The UPS services returned XML data and that XML data was then parsed and stored in the database.
This was an intranet site for employees to manage their data. Employees were able to update their information like contact information and address details. They were also able to review their pay stubs. Notifications were also displayed to employees via the website.
There were management tools for HR administrators to view and edit employee information. Administrators were also able to manage notifications and set the active dates for notifications.
I created web pages to allow users to set up quota rules for tracking survey participants. This work included developing the logic for grouping rules into layered sets of conditional AND/OR criteria and algorithms for matching survey participants to quota rules. It also included reporting tools for viewing quota matches and quota targets/goals.
