Director of Software Engineering
2009 - 2022SynQor- 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 - 2009SynQor- 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)
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
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.
Employment
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 CoreTools
Microsoft Excel, Microsoft Access, Microsoft Power BI, Microsoft Power AppsParadigms
Database Design, Business Intelligence (BI), MicroservicesStorage
Databases, Microsoft SQL Server, SQL Performance, Database Administration (DBA), Azure SQL, Oracle PL/SQL, Oracle SQL, PL/SQL, Azure SQL DatabasesOther
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 RDSPlatforms
Salesforce, Oracle, Azure, Amazon Web Services (AWS)Libraries/APIs
Windows Forms (WinForms)
Education
- Master's Degree in Electrical Engineering and Computer Science1991 - 1996Massachusetts Institute of Technology - Cambridge, MA, USA
- Bachelor's Degree in Electrical Engineering1991 - 1996Massachusetts Institute of Technology - Cambridge, MA, USA
