Building a new .NET Enterprise Application from the ground up.
Summary
From January 2006 to present working with a team of Senior Software Engineer’s architecting and implementing a new enterprise application responsible for translating Electronic Data Interchange (EDI) into a format usable by back-end business applications (SAP 2005, MAS 500, PeachTree and QuickBooks) in order to minimize or eliminate the need for manual data entry.
Responsible for designing and coding all layers of the applications architecture including User Interface (WinForms\ASP.NET WebForms), Service (ASP.NET Web Services), Business and Data Access (SQL Server 2005).
Client-Side User Interface utilized a loosely coupled Model View Presenter (MVP) design pattern in order to support multiple client platforms (Windows and Web).
The Service Layer was built for maximum scalability by adhering to a strict Service-Oriented Architecture that utilized Microsoft’s ASP.NET Web Service technologies.
The Business Layer consists of C# assembly libraries that leverage core .NET Framework 2.0\3.5 technologies.
The Data Access Layer uses Microsoft’s Enterprise Library Data Access Application Block [DAAB] to abstract and simplify back-end SQL Server 2005 data access. All SQL DML is encapsulated in Microsoft Transact (T-SQL) Stored Procedures.
Tools and Technologies Leveraged
Development environments
Visual Studio 2005\2008, SQL Server Management Studio
Technologies
Infragistics NetAdvantage 2006-2009, SQL Server Management Objects (SMO), IIS, ASP.NET Web Services, Distributed Transaction Coordinator (DTC), Web Service Enhancements (WSE 3.0), ADO.NET (connected and disconnected), SQL-CLR
Languages
C#, SQL, T-SQL, XML, XPath, XQuery
Databases
SQL Server 2005
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
C++ and J.D. Edwards OneWorld Xe Development...
Summary
From October 2001 until November 2003 I worked for a global manufacturing company designing and implementing J.D. Edwards OneWorld Xe business solutions. J.D. Edwards is a large, very complex enterprise suite of applications that provides a proprietary Integrated Development Environment so the client can customize the solution to meet the needs of the business. I was hired because of my C/C++ expertise.
J.D. Edward’s underlying system is a large, extremely complex library of ANSI C DLL’s. I was able to rapidly apply my C++ experience to debug and fix critical system issues. I had to write many custom business functions to meet their specific business needs. I also had to write applications that utilized Win32 API’s including a serial port reader application.
I also designed and programmed custom business applications, reports and interfaces using J.D. Edward’s proprietary development tools including Form Design Aid (FDA), Report Design Aid (RDA), Table Design Aid (TDA), Business View Design Aid (BDA) and the Universal Table Browser (UTB ).
Their J.D. Edwards solution was built on top of an Oracle 8 database. Analyzing this large and complex system during application design and implementation helped me garner a lot of Oracle expertise. This experience would soon be leveraged during my next projects.
During this time I also wrote several custom utilities that increased team productivity. These applications were written in C# with Visual Studio .NET 2003.
Tools and Technologies Leveraged
Development environments
J.D. Edwards OneWorld Xe, Microsoft Visual C++, Microsoft Visual Studio .NET 2003, Borland C++ Builder, SQL Plus, Toad
Languages
C/C++, Visual C++ 6/MFC, Win32 API, SQL, JDE ER
Databases
Oracle 8/9
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