Scroll To View More
Steven Perkins, T-SQL Developer in Greensboro, United States
Steven Perkins

T-SQL Developer in Greensboro, United States

Member since August 1, 2016
Steven is a senior web developer with 13 years of experience in ASP.NET web development. Much of his experience has been spent developing heavily data-driven websites and utilizing his strong SQL development skills. Steven has worked in small groups and corporate environments on a variety of projects and would be a valuable addition to any team.
Steven is now available for hire

Portfolio

  • Lash Group
    ASP.NET Web Forms, ASP.NET MVC, ASP.NET Web API, REST, jQuery, T-SQL, TFS...
  • Primo Water
    ASP.NET Web Forms, T-SQL, Web Services, C#, XML
  • TheraCom
    ASP.NET Web Forms, T-SQL, SSRS, XML, Visual Basic

Experience

  • T-SQL, 13 years
  • C#, 13 years
  • ASP.NET Web Forms, 13 years
  • VB.NET, 7 years
  • Microsoft Team Foundation Server, 6 years
  • ASP.NET MVC, 4 years
  • TypeScript, 1 year
Greensboro, United States

Availability

Part-time

Preferred Environment

Windows, Visual Studio, SSMS, TFS, Git

The most amazing...

...project I've worked on was a website for managing and displaying SSRS reports. The site managed report data files, users, and user security.

Employment

  • Senior Web Developer

    2012 - PRESENT
    Lash Group
    • Managed the web applications in a corporate environment; these websites were built using ASP.NET Web Forms and MVC. Some were client-facing and others were internal websites.
    • Implemented database work using MS SQL Server.
    • Acted as the team lead/subject matter expert for offshore developers on some projects.
    • Had regular involvement in meetings reviewing requirements, business logic, and project timelines.
    • Worked on electronic prescriptions—sending data gathered from a website via a SOAP XML web service and processed the responses.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.
    • 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.
    • Built public-facing websites for clients to allow health care providers to view and manage patient data.
    • Developed intranet websites that allowed users to review data before it gets pushed into the CRM system.
    Technologies: ASP.NET Web Forms, ASP.NET MVC, ASP.NET Web API, REST, jQuery, T-SQL, TFS, Web Services, C#, Visual Basic
  • Senior Web Developer

    2011 - 2012
    Primo Water
    • Managed web applications using ASP.NET, database work using SQL Server. Primarily did intranet site work for managing business data with some external site work.
    • Managed internal business website—they were used for tracking sales, inventory, distribution, and more.
    • 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.
    Technologies: ASP.NET Web Forms, T-SQL, Web Services, C#, XML
  • Senior Web Developer (Contract)

    2010 - 2011
    TheraCom
    • Worked as a contract employee—primarily developed SSRS reports while doing maintenance on existing websites.
    • Did SSRS reporting—creating and updating SSRS reports.
    • Built a SSRS reporting portal; created an ASP.NET website for viewing and managing SSRS reports because an SSRS server was not available. 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.
    Technologies: ASP.NET Web Forms, T-SQL, SSRS, XML, Visual Basic
  • Programmer Analyst 2

    2008 - 2010
    Guilford County Schools
    • Developed web applications using ASP.NET, database work (SQL Server and IBM iSeries), and converting Java WebSphere applications to ASP.NET.
    • Built an employee self service portal—created a portal for employees to lookup information. For example, 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.
    Technologies: ASP.NET Web Forms, C#, Visual Basic, AS400, T-SQL
  • Software Developer

    2005 - 2008
    Fourth Factor Technology Services
    • Developed web applications, did tech support work, and did database development using SQL Server. Also performed work for s small business doing contract work for larger companies. Worked on a variety of projects from small business sites with one or two pages to large corporate sites.
    • Worked on an employee rewards program. Built a site for tracking an internal employee rewards program. Allowed users to view their rewards and track progress.
    • 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.
    Technologies: C#, SQL, HTML, JavaScript, ASP.NET Web Forms, Photoshop, Regular Expressions

Experience

  • Sunbelt Rentals (Development)
    https://www.sunbeltrentals.com/

    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.

  • Healthcare Provider Portals (Development)

    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.

  • SSRS Reporting Portal (Development)

    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.

  • UPS Return Tracking (Development)

    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.

  • Employee Self-service Portal (Development)

    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.

Skills

  • Languages

    VB.NET, HTML, SQL, C#, T-SQL, XML, ASP.NET Razor, JavaScript, TypeScript, HTML5
  • Frameworks

    ASP.NET Web Forms, ASP.NET MVC, ASP.NET Web API, Angular
  • Libraries/APIs

    jQuery, Web API
  • Tools

    Microsoft Team Foundation Server, Visual Studio, Adobe Photoshop, Git
  • Paradigms

    Model View Presenter (MVP), Model View Controller (MVC), Agile, REST
  • Platforms

    Windows
  • Storage

    Microsoft SQL Server, SQL Server Management Studio, MySQL
  • Other

    Web Services, PDF

Education

  • Bachelor of Science degree in Computer Science
    2000 - 2004
    North Carolina State University - Raleigh, NC, USA
I really like this profile
Share it with others