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
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
Senior Staff Engineer
Schell Brothers
- Led a redesign and implementation of an enterprise grade back office system for home building utilizing state of the art AI assisted applications.
- Led multiple offshore teams in creating multiple database-driven applications, including scheduling and cost tracking modules.
- Created a sophisticated pricing tool specific to home building that maintained backward compatibility with the legacy system using SQL Server.
- Automated refresh of a multi-platform, integrated development environment utilizing AWS CLI and PowerShell to provide a realistic environment for creating new functionality.
- Mentored and coached multiple junior software engineers.
Consultant
Atlas Tech Group
- Provided support to a defense contractor post go-live on an Oracle EBS ERP upgrade.
- Coordinated and complex integration with a Salesforce implementation.
- Performance-tuned MS SQL Server and MySQL databases, both local and on AWS.
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), Power BI REST APIs
Tools
Microsoft Excel, Microsoft Power BI, Microsoft Access, VPN, Power BI Report Server, Microsoft Power Apps, AWS Command Line Interface (CLI), Power BI Embedded
Languages
SQL, Visual Basic 6 (VB6), C#, VB.NET, C#.NET, SQL DML, Transact-SQL (T-SQL), Excel VBA, Visual Basic for Applications (VBA), Python, TypeScript
Frameworks
.NET, .NET Core, ASP.NET, Windows PowerShell
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, MySQL
Platforms
Salesforce, Oracle, Azure, Amazon Web Services (AWS)
Other
Integration, Data Queries, Performance Tuning, Data Center Infrastructure, Data Modeling, Data Transformation, 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), Scripting, DAX, Microelectronics, Oracle EBS, System Integration, Salesforce Reports, Red Gate, Intuit QuickBooks, Amazon RDS, FTP, Sage ERP, Cursor AI, Artificial Intelligence (AI), Google BigQuery
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