Rob is available for hire

Rob Lepard

Verified Expert in Engineering

SQL Server and .NET Developer

Location

Milford, MA, United States

Toptal 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.

Data Queries Integration SQL Microsoft Excel Databases Microsoft SQL Server SQL Performance T-SQL (Transact-SQL).NET Visual Basic 6 (VB6)Database Design VB.NET C#C#.NET Data Engineering

Portfolio

SynQor

.NET, SQL, Salesforce, Oracle, Oracle Application R12 EBS, Microsoft Excel...

SynQor

Visual Basic 6 (VB6), .NET, SQL, Oracle EBS, Oracle, Microsoft Excel, Analytics...

Experience

Oracle EBS - 20 years SQL - 20 years Oracle - 20 years Visual Basic 6 (VB6) - 15 years .NET - 15 years VB.NET - 12 years C# - 8 years Oracle Application R12 EBS - 4 years

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.

Work Experience

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

1991 - 1996

Master's Degree in Electrical Engineering and Computer Science

Massachusetts Institute of Technology - Cambridge, MA, USA

1991 - 1996

Bachelor's Degree in Electrical Engineering

Massachusetts Institute of Technology - Cambridge, MA, USA