Rob Lepard, SQL Server and .NET Developer in Milford, MA, United States
Rob Lepard

SQL Server and .NET Developer in Milford, MA, United States

Member since July 21, 2022
Rob studied electrical engineering and computer science at MIT and now specializes in SQL and .NET. His expertise includes manufacturing, data collection, and system integration in all business areas. He prides himself in being able to identify the right problem and solve it. After years of both management and technical duties, Rob is now focusing on hands-on development. The ideal client for Rob is a growing company that needs highly scalable database-driven applications.
Rob is now available for hire

Portfolio

  • SynQor
    .NET, SQL, Salesforce, Oracle, Oracle Application R12 EBS, Microsoft Excel...
  • SynQor
    Visual Basic 6 (VB6), .NET, SQL, Oracle EBS, Oracle, Microsoft Excel...

Experience

Location

Milford, MA, United States

Availability

Part-time

Preferred Environment

SQL, .NET

The most amazing...

...system I've developed is a fully integrated manufacturing execution system for a defense contractor, written in .NET and using SQL Server as the back end.

Employment

  • Director of Software Engineering

    2009 - 2022
    SynQor
    • Provided technical guidance to executives to set the direction of the internal software for SynQor. Led the software development team at SynQor while still maintaining lead developer status.
    • Redefined and optimized business processes for a CRM upgrade that included multiple integration points between Salesforce and Oracle EBS.
    • Optimized performance and partitioned a 2TB SQL database while maintaining backward compatibility for existing software infrastructure.
    • Led a major ERP system upgrade of Oracle EBS. Hired and managed subcontractors. Simplified, consolidated, and eliminated significant amounts of PL/SQL.
    • Redesigned and developed multiple manufacturing processes and data collection tools in .NET and SQL Server.
    • Analyzed products to determine if the make-or-buy decision was right for the company.
    Technologies: .NET, SQL, Salesforce, Oracle, Oracle Application R12 EBS, Microsoft Excel, Salesforce Reports, Analytics, Data Analytics, Database Design, Business Intelligence (BI), Integration, Customer Relationship Management (CRM), Reporting, Database Schema Design, Data Engineering, Team Leadership, Data Visualization, Data Analysis, Microsoft Access, Databases, Microsoft Power BI, .NET Core, Microservices, APIs, Back-end, C#, C#.NET, Microsoft SQL Server, Full-stack, Azure, Azure SQL, Red Gate, Dashboards, Azure SQL Databases, Microsoft 365, Microsoft Power Apps, Intuit QuickBooks, API Integration, SQL DML, Data Queries, Performance Tuning, SQL Performance, T-SQL (Transact-SQL), Database Administration (DBA), Amazon RDS, Amazon Web Services (AWS), Oracle PL/SQL, Oracle SQL, PL/SQL, Business Continuity & Disaster Recovery (BCDR)
  • Software Engineer

    2002 - 2009
    SynQor
    • Led development for enterprise-level manufacturing execution system praised by large defense prime manufacturers.
    • Developed software requirements and communication interfaces for a multi-million dollar automation system for manufacturing.
    • Developed, managed, and optimized a complex SQL Server database system that handled millions of transactions per day.
    • Implemented various business process automation to eliminate errors, reduce complexity, and improve efficiencies.
    • Created and implemented systematic production and data collection controls for military-grade products, including component usage and traceability.
    Technologies: Visual Basic 6 (VB6), .NET, SQL, Oracle EBS, Oracle, Microsoft Excel, Analytics, Data Analytics, Database Design, Business Intelligence (BI), Integration, Reporting, Database Schema Design, Data Engineering, Team Leadership, Data Visualization, Data Analysis, Microsoft Access, Databases, Microservices, APIs, Back-end, C#, C#.NET, Microsoft SQL Server, Full-stack, Red Gate, Dashboards, API Integration, SQL DML, Data Queries, Performance Tuning, SQL Performance, T-SQL (Transact-SQL), Database Administration (DBA), Oracle PL/SQL, Oracle SQL, PL/SQL, Business Continuity & Disaster Recovery (BCDR)

Experience

  • Manufacturing Execution System

    I acted as the architect and lead developer for an enterprise-grade manufacturing tracking system (MES). The code was written in .NET and used SQL Server as the back-end database. At various points in time, over one million rows a day were added to the database. The system was built to be flexible and extensible.

    Over time, numerous pieces of third-party hardware and software were integrated into the system. Executives used this MES as a showpiece when large defense contractors visited the company to show the level of detail, control, and continuous improvement that drove the company's success.

  • Custom Pivot Report Tool

    Created a reporting application that provided tremendous flexibility to the company to empower users for data discovery and analysis.

    Key features included:
    • Role-based access to reports.
    • Row-level access controls to data.
    • User parameter input at query run time.
    • Run-time grouping, sorting, and filtering, similar to Microsoft Excel Pivot reports.
    • Powerful visualizations.
    • Extensible APIs.
    • Ability to export to Excel.

  • Component Level Traceability

    Provided unique identifier to every raw material, subassembly, and final assembly. I monitored human manual operations and machine activities to track full product genealogy. This traceability allowed for deep analysis and continuous improvement in manufacturing, with results that included unmatched levels of quality and reliability in the power electronics industry.

Skills

  • Languages

    SQL, Visual Basic 6 (VB6), C#, VB.NET, C#.NET, SQL DML, T-SQL (Transact-SQL)
  • Frameworks

    .NET, .NET Core
  • Tools

    Microsoft Excel, Microsoft Access, Microsoft Power BI, Microsoft Power Apps
  • Paradigms

    Database Design, Business Intelligence (BI), Microservices
  • Storage

    Databases, Microsoft SQL Server, SQL Performance, Database Administration (DBA), Azure SQL, Oracle PL/SQL, Oracle SQL, PL/SQL, Azure SQL Databases
  • Other

    Integration, Data Queries, Performance Tuning, Computer Science, Oracle Application R12 EBS, Reporting, Analytics, Data Analytics, Customer Relationship Management (CRM), Database Schema Design, Data Engineering, Team Leadership, Data Visualization, Data Analysis, APIs, Back-end, Full-stack, Dashboards, Microsoft 365, API Integration, Business Continuity & Disaster Recovery (BCDR), Microelectronics, Oracle EBS, System Integration, Salesforce Reports, Red Gate, Intuit QuickBooks, Amazon RDS
  • Platforms

    Salesforce, Oracle, Azure, Amazon Web Services (AWS)
  • Libraries/APIs

    Windows Forms (WinForms)

Education

  • Master's Degree in Electrical Engineering and Computer Science
    1991 - 1996
    Massachusetts Institute of Technology - Cambridge, MA, USA
  • Bachelor's Degree in Electrical Engineering
    1991 - 1996
    Massachusetts Institute of Technology - Cambridge, MA, USA

To view more profiles

Join Toptal
Share it with others