Category: Delphi
Design and Implementation of Lot Traceability Application...
Summary
From November 2003 until December 2005 served as Lead Software Engineer on a project that interfaced with multiple third-party ERP software applications to provide lot traceability through the entire manufacturing process.
Designing, planning and implementation fazes of the project required both foreign and domestic travel in order to work side-by-side with Business Analysts to insure proper design and integration of the project.
This application was created from the ground up to join disparate ERP systems by plugging into their back-end database systems and providing a new custom suite of applications and reports. All development was done utilizing Borland Delphi. All reports were written using ReportBuilder for Delphi.
All new applications gathered data from the following ERP systems; J.D. Edwards OneWorld Xe, WinSPC and VicSys (custom legacy application). JDE and WinSPC leveraged an Oracle database while the legacy application used a Pervasive database. A new Oracle database consisting of a 20 to 25 table schema had to be created to store newly acquired lot traceability data.
Tools and Technologies Leveraged
Development environments
Delphi, TOAD for Oracle, ReportBuilder, Model Maker, Visual Studio .NET 2003
Languages
Delphi, SQL, C/C++, C#
Databases
Oracle 8/9, Access, Pervasive, SQL Server
The first two years, genesis of a young programmer...
Job Summary
I spent the first 2 years of my career working for a software company that specialized in providing solutions for the Printing and Publishing industry. I worked with a team of Software Engineers responsible for creating bindery systems software applications.
All applications utilized advanced C++ programming language features including object-orientation (encapsulation, polymorphism, inheritance), advanced data structures (double-linked lists, red-black trees, arrays, stacks, etc), and the Standard Template Library (STL) to name a few.
Projects ranged from hunting down complex bugs to designing and implementing new applications.
Tools and Technologies Leveraged
Development Environments
Microsoft Visual Studio 6, Borland C++ Builder, Borland Delphi, SQL Plus, Database Desktop, Model Maker
Languages
C/C++ (STL), Visual C++ 6/MFC, Win32 API, Delphi, SQL, UML
Databases
Oracle, Paradox, InterBase