
Rob Lepard
Verified Expert in Engineering
SQL Server and .NET Developer
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.
Portfolio
Experience
- Oracle - 20 years
- SQL - 20 years
- Oracle EBS - 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
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
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.
Software Engineer
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.
Experience
Manufacturing Execution System
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
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
Education
Master's Degree in Electrical Engineering and Computer Science
Massachusetts Institute of Technology - Cambridge, MA, USA
Bachelor's Degree in Electrical Engineering
Massachusetts Institute of Technology - Cambridge, MA, USA
Skills
Libraries/APIs
Windows Forms (WinForms)
Tools
Microsoft Excel, Microsoft Access, Microsoft Power BI, Microsoft Power Apps
Languages
SQL, Visual Basic 6 (VB6), C#, VB.NET, C#.NET, SQL DML, T-SQL (Transact-SQL)
Frameworks
.NET, .NET Core
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
Platforms
Salesforce, Oracle, Azure, Amazon Web Services (AWS)
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring