Eric Leasure, Database Developer in Tampa, FL, United States
Eric Leasure

Database Developer in Tampa, FL, United States

Member since July 7, 2020
Eric is a full-stack software developer with 20+ years of experience and a passion for the back-end. He has a can-do-anything attitude with proven expertise in the full life cycle of many successfully launched projects. He has automated and optimized processes shaving many hours off his client's weekly schedules, and his expert integrations added value to products. Eric's ability to revamp existing code into a smoother, faster, more reliable version without disrupting service is outstanding.
Eric is now available for hire

Portfolio

Experience

Location

Tampa, FL, United States

Availability

Part-time

Preferred Environment

T-SQL, Python, JavaScript, C#, PostgreSQL, Microsoft SQL Server

The most amazing...

...project I've worked on created a highly automated graded testing system including notifications, PDF certificate generation, web interface, and reporting.

Employment

  • Owner, Software Developer

    2018 - PRESENT
    Eric Leasure, LLC.
    • Automated real-time client system integration by exposing and consuming web APIs, saving the client 20 hours per week, while improving accuracy and speed over the previous redundant manual processes.
    • Designed and implemented a branded SPA for B2B clients to use on mobile devices during live speaker events to manage their customer registrations, improving the experience for clients and their customers, and providing better data collection.
    • Developed a complete system for providing insights into financial markets by analyzing billions of rows of data using a custom blend of SQL and Python.
    Technologies: JavaScript, T-SQL, C#, Python, PostgreSQL, Microsoft SQL Server
  • Full-stack Software Developer

    2011 - 2018
    R&R Healthcare Communications, Inc.
    • Produced a reporting module for web portals to provide role-based, customizable, interactive reports for web use, email, and/or export to Excel/PDF. Provided a mechanism for the business to produce high quality branded reports very rapidly.
    • Automated all internal reporting and client dashboards, improving accuracy and saving each of the 20+ project directors in the company at least six hours per week.
    • Redeveloped 11 pre-existing customer-facing websites, used by over 100,000 unique users, from the ground up using C#, MS-SQL, JavaScript, HTML, and CSS to improve performance, usability, appearance, and maintainability.
    • Architected and implemented an entire system for creating tests/surveys, including automated grading, communications, PDF certificate generation, reporting, and ETL processes with partnered accrediting institutions.
    • Developed a company-wide email system integrated with Mandrill/Mailchimp, allowing to generate scheduled email campaigns, templates with customizable tokens, and dynamically generated attachments, along with tracking capabilities.
    • Created four DotNetNuke web portals with custom features, complex business rules, and branding specific to each B2B client for use by their employees.
    • Coded 10 DotNetNuke (v7-9) modules for use on customer-facing websites using ASP.NET MVC architecture.
    • Developed a web API service layer to enable real-time syncing of data between R&R and client systems.
    • Supported all in-house/hosted servers and worked on transitioning code from hosted servers to Azure.
    • Documented process flows, recorded training videos, and presented at training sessions for employees and business clients as new systems/features were developed.
    Technologies: T-SQL, DotNetNuke (DNN), MySQL, CSS, JavaScript, HTML, C#, Microsoft SQL Server
  • Software Engineer III

    2004 - 2011
    Talbots
    • Assisted with the Internal Consulting Team, comprised of a few elite developers, to aid other Talbots' programming teams challenged by technical requirements and/or tight project deadlines.
    • Supported, maintained, and developed 200+ ETL batch processes using SSIS packages for Windows/MS-SQL environments and shell scripts for Unix/Oracle environments.
    • Created SSRS and SSAS reports to meet business reporting needs.
    • Owned all of the core code for the company-wide cipher system using Java, VB.NET, RPG, and CL.
    • Served in a software engineering role as the SME on various systems to manage installs/upgrades/patches, ensure PCI compliance, create/maintain technical documents, and troubleshoot/resolve system issues.
    • Assisted in a production control role, managing batch processing schedules, and maintaining computer room operations.
    Technologies: JavaScript, T-SQL, Oracle, VB.NET, Java, SSAS, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server

Experience

  • Instant Reporting and Administration Module

    Developed DotNetNuke 9 reporting and administration module that instantly converted a database procedure, view, or table into a web-based and role-secured interactive report supporting custom styling, pagination, filtering, sorting, drilling, pop-outs, tool tips, cell/row level action definitions, role-based column viewing/access, along with with the ability to have delivered to email or exported to Excel/PDF.

    The administrative interface automatically generated default report definitions for admins, which could then be modified down to the column level as needed, reducing report development time to stored procedure development time plus two minutes of administration in most cases. This module responded to frequent client requests for custom reporting and allowed us to over-deliver high quality and branded new reports usually within hours and some times within minutes of the request. Since the feature-rich module supported role-based access/actions, it was also used as an administrative interface for internal project directors to view and/or modify 20+ tables/views.

  • Survey and Testing System

    Built a complete system for creating and managing surveys or graded tests. The system included an administrative interface supporting system-level and event-level templates and tokens, an automated workflow featuring real-time grading with instant feedback, email communications, dynamic PDF certificate generation/issuance, and a back-end process to provide ad hoc and scheduled reporting, auditing, and ETL processes with partnered accrediting institutions.

  • Email Management System

    Designed and implemented a company-wide email system integrated with Mandrill/Mailchimp, allowing to generate scheduled email campaigns, templates with customizable tokens, and dynamically generated attachments, along with tracking capabilities. The robust system included whitelisting and blacklisting, CC/BCC/Replace recipient capabilities, work flow integration, logging, auditing, and automated reporting of delivery failures to internal admins. The system also presented a web interface with different views to easily track and manage emails per event, user, or across the entire portal.

Skills

  • Languages

    T-SQL, PL/pgSQL, C#.NET, JavaScript, SQL, Python 3, Java, HTML, CSS, Visual Basic .NET (VB.NET), C++, C#, Python, VB.NET
  • Frameworks

    ASP.NET MVC, Windows PowerShell, Bootstrap 3, React Native
  • Libraries/APIs

    jQuery, Google APIs, Web API 2, React, Vue, Node.js, D3.js
  • Tools

    Microsoft Access, Visual Studio, VS Code, pgAdmin, Plotly, Git, Subversion (SVN), SSRS, SSAS
  • Paradigms

    Database Design, Object-oriented Programming (OOP), REST, ETL
  • Platforms

    DotNetNuke (DNN), Visual Studio Code, Azure, Oracle, Amazon Web Services (AWS)
  • Storage

    SQL Server Management Studio, Database Modeling, Database Transactions, Database Triggers, Relational Databases, MySQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), PostgreSQL, Data Pipelines, SQL Server Analysis Services (SSAS), Microsoft SQL Server
  • Other

    Database Optimization, IIS, Data Analysis, MicroStrategy

Education

  • Associate of Science Degree in Programming and Analysis
    2006 - 2008
    Brevard Community College - Titusville, Florida, USA

Certifications

  • SQL
    APRIL 2020 - APRIL 2023
    TestDome
  • Project+
    JUNE 2008 - PRESENT
    Comptia

To view more profiles

Join Toptal
Share it with others