Ronald Garlit
* ***** ******* ***., ******** Park, NJ 08063
Phone: Home 856-***-**** Email: *********@****.***
CAREER SUMMARY
Enterprise software and data architect with years of experience in both software and database development. I've spent many years architecting and implementing software platforms in the fields of medical, pharmaceutical, logistics, financial, payment processing and business intelligence.
TECHNICAL SKILLS.
Languages
Web Development
Software
C#
JavaScript
TypeScript
TSQL
PL/SQL
PSQL
Visual Basic
Java
C/C++
HTML5
CSS3
Bootstrap
JQuery
KnockoutJS
AngularJS
NodeJS
Visual Studio (All Versions)
Microsoft Office (All Versions)
Visio
MS Project
Team Foundation Server (TFS)
Jenkins
Nexus
DBArtisan
Toad
PL/SQL Developer
Aqua Data Studio
Databases
Big Data (Hadoop, etc…)
Server/OS/Virtualization
SQL Server (6.5 thru 2016)
SSIS, SSRS and SSAS
Oracle 8i, 9i, 11g and 12c
PostgreSQL 9.3 and 9.4
Horton Works 1.3, 2.2
HDInsight
Windows (All Versions)
Windows Azure
HyperV
VMware
Oracle VirtualBox
Linux
Communications and Project Management
Has a board range of experience in effectively communicating complex technical topics too all types of people ranging from board room upper management to non-skilled staff.
EXPERIENCE
American Express, Enterprise Application Architecture, National Park, NJ & Phoenix, AZ
Lead Technical Architect, December 2007 to Present
(September 2015 – In AEXP all LTA’s job titles are being changed to “Senior Engineer I” keeping same duties)
Design, Implement and Drive Enterprise adoption of the “.NET Reference Architecture" and "Azure Reference Architecture” across the entire Enterprise. (Currently Primary focus on driving the Enterprise Cloud Strategy)
Provide technical leadership while serving as subject matter expert (SME) for all Microsoft .NET application development, deployment projects, and infrastructure initiatives to deliver innovative solutions based on Microsoft .NET technologies throughout the organizations.
Oversee the continuing enhancement and adoption of .NET Prescriptive and Reference Architectures, ensuring best-of-breed technology identification and implementation, as well as technical troubleshooting, consulting and governance support to the Global American Express Technical Community.
Major Projects and Responsibilities:
oLead Architect of the ".NET RA Component Suite" development team.
oGovernance Architect - Joint Application Design Review (Global Application Development and Governance)
oTeam Data Architect and DBA - SQL Server, Oracle and PostgreSQL
oBusiness Intelligence SME - Enterprise Liaison for Microsoft BI Technologies (SSIS, SSAS, SSRS, HDInsight, and HortonWorks)
oOpen Source Governance Process (OSGP) - .NET LTA working with Java LTA reviewing and approving Open Source prior to use with AEXP. (Currently evolving OSGP into the Open Source Framework - OSF)
oEnterprise Multi-Platform Continuous Build System (Nexus/NuGet/Jenkins/ IBM Security AppScan Source)
American Express, Business Intelligence Systems, Newark, DE
Sr. Programmer/Analyst, August 2005 to December 2007
Served as primary Subject Matter Expert (SME) on Microsoft Technologies and SQL Server Business Intelligence Services.
Shaped BIS applications development and reporting systems.
Managed the full software development life cycle of custom built internal Business Intelligence Applications involving Microsoft .NET, SQL Server and Analysis Servers 2000 and 2005.
Designed, developed, and implemented messaging services, DataMart integration, data modeling and reporting systems for the Loyalty Effectiveness Project (Full Life Cycle Development).
Directed the design of the BIS Reporting application components and deployment of the reporting system built around Microsoft SQL Server 2005 Reporting Services (SSRS)
Developed several internal reusable components written in C#, including the BIS Data Tier Generator 2005 code generation utility, BIS DBAccess and BIS Logger reusable components. These were later moved to the .NET Reference Architecture and redesigned for use in all .NET development through the enterprise.
Created, Implemented and Maintained the "Data Flow Manager,” a windows service controlling all the ETL processing of credit card system data for the Data Warehouse that handled ETL, QA Checking, and Reporting of 20 plus GB of data weekly.
IPS Solutions Inc., LLC. A PayByTouch Company New Castle, DE
Applications and Database Developer, 1/2003 - July 2005
Served as project lead, process owner, and programmer analyst in dynamic technical environment requiring continuous application of new skill sets to develop and support software.
Managed the full software development life cycle of internal support and management applications, including hands-on Client/Server development on the presentation tier (Windows Client/Server and Web based), middle tier (Visual Studio.NET) and database backend (Oracle 8i & 9i).
Built, installed, tuned and managed Microsoft Reporting Servers and Crystal Enterprise 8, 9 & 10 Report Servers.
Developed applications for advanced Crystal Reports using Visual Basic and ASP for CITRIX and IIS deployment.
Designed and developed Business Intelligence (BI) Reporting Systems.
Developed data warehouses using Oracle 9i and MS SQL Server 2000
Administered and developed MS Reporting Services.
Led MSI package development for application deployment using Wise Installer.
Rewrote custom internal project management package.
Carried out migration from Oracle 8i to 9i.
Developed applications for C#, WinForms and ASP.NET projects.
Converted Visual Basic to C# and moved all software to .NET Platform.
Avecia Inc., Wilmington, DE
Microsoft Developer/Consultant, 10/2002 - 1/2003
Assisted in the strategic implementation of several Dos/Windows 98 migrations to Windows XP for the Mentor XP Project (a customized version of Windows XP). Tested modifications and functionality of proposed client platform in preparation of global rollout.
Reviewed current third party software packages for install, and compatibility with Windows NT & XP. Created Microsoft Installer packages as needed for Install Servers.
Reviewed and modified existing Visual Basic applications for use on Windows NT 2000 Servers and XP Clients.
Provided training for programmers in the development of programs using MS SQL Server and Visual Basic on a Windows NT & XP platform.
Bastille Group, New Castle, DE
Microsoft Developer/Consultant, 4/2002 - 6/2002
Modified and debugged custom VB/Access VBA based application linked to SQL Server 2000 to capture and maintain data for use in distributed, multi-user environments.
Performed all aspects of the relational database development cycle from requirements analysis, to design, coding, and delivery.
Client-side and server-side development using Access VBA code.
ATK Tactical Systems, Elkton, MD
Microsoft Developer/Consultant, 10/2001 - 12/2001
Coordinated a technology advisory group to define service requirements and guide technology implementation of a Windows based applications development environment in order to restore team productivity.
Provided training for staff in the real world application of Microsoft development philosophies for full software development life cycle and database administration on Windows NT with Visual Basic 6, ASP 3.0, Access 2000, MS SQL Server 2000 and Oracle 8i.
Designed, developed, and implemented the coding standards, reusable code modules, classes and controls to jumpstart development efforts. Transitioned current set of IBM mainframe based programs to the Microsoft NT Platform.
Introduced and implemented the use of third party tools which included Seagate Crystal Reports Developer (using RDC and API) and Crystal Enterprise 8, Infragistics Ultragrid controls, DBArtisan and SAX Setup 6 to return the department to full productivity.
Dynamic Imaging, Marlton, NJ
Sr. Visual Basic Developer/Consultant, 3/2001 - 7/2001
Designed, developed, and implemented software components as requested without formal specification and assist the owner/developer of this small company in their product development efforts.
Improved and changed existing product written in Visual Basic 6 and HLLAPI interfaces to legacy terminal emulators.
Constructed a prototype for a new company product designed for intranet use based Visual Basic Documents as requested along with some custom Dynamic Link Libraries.
NFI Interactive, Cherry Hill, NJ
Manager of Applications Development & Lead Visual Basic Developer, 5/2000 - 12/2000
Managed technical infrastructure operation and development of multiple software projects while designing and coding on those projects for a multiple platform supply chain Startup Company. (Full software development life cycle).
Devised plans to move eleven enterprise applications from Microsoft Access 97 VBA to Visual Basic 6.
Established documentation, tools and coding standards on both Microsoft Office 97/ 2000 and Visual Studio 6 development platforms.
Designed and implemented standardized COM components for use by programming staff.
Worked as programmer while mentoring VBA/VB programming staff in Advanced VB 6 Applications Design and Development. (Implementation of Win32 API Functions and VB Class Design and Usage)
Responsible for EDI and Network Services staff until a manager could be hired.
Worked as MS SQL Server and Oracle DBA and Web developer.
Reviewed and wrote test code for Visual Studio 7 and .NET with the first of the pre-beta and evaluate the potential usefulness as replacement platform.
Lead a voluntary training program for the VB programmers to learn Java and prepare them for development platform change.
AstraZeneca Pharmaceuticals, Wayne, PA
Lead Visual Basic Programmer and Microsoft Developer, 4/1999 - 5/2000
Assigned to Quantitative Decisions Sciences (Drug Development) as the lead developer for the PC component of the multi-platform MacStat Software package used by the Statistical Scientists.
Reverse engineered older version of software to redesign it to meet current Object Oriented and Microsoft design philosophies by employing MS Visual Basic 5, MS Visual Basic 6, Win32 API and MS Office 97 running on Windows 95 with access to a UNIX SAS and backend via RDO 2.0 and ANSI SQL92.
Responsible for design of training presentations and documentation for the organization.
Worked on the "New Technology" redesign of next version of MacStat to take advantage of MS Windows 2000 and MS Office 2000 with MS Visual Studio 6 and Multi-platform versions of SAS via ADO 2.1 and ANSI SQL99.
Completed full software development life cycle starting from the Technical Requirements and Design Specification to implementation of the finished PC Component.
Our Lady of Lourdes Medical Center, Camden, NJ
Software & Hardware Specialist - Senior. BMET, 9/1982 - 5/1999
Managed technical infrastructure operation and development of Bio-Medical Electronics department in a research hospital.
Demonstrated hands-on expertise in both hardware and software maintenance, repair, and engineering.
Served as systems programmer on the design and implementation team to develop a custom in-house clinical software system (early version developed in Basic Compiler 7.1 in DOS).
Lead team in conversion to Windows platform developing in COM, MS SQL Server and Visual Basic 5 & 6.
Worked on the related medical billing software using Basic Compiler 7.1, Turbo C and Asm.
Wrote custom in-house materials management and equipment maintenance programs using SmartWareII 4GL, dBase and Delphi (Ver. 1).
Established an independent Bio-Medical Electronics Department for the Regional Artificial Kidney Center.
Supervised the maintenance, repair and technical support of clinical computer hardware and software systems, including a large assortment of advanced microprocessor controlled medical equipment.
Doctors Office Computer Consultants, Woodbury, NJ
Systems Analyst, 6/1991 - 7/2000
Provided consulting, training and technical support services to an array of customers in the medical field for assorted hardware and software systems. (Visual Basic 4, 5 & 6, ASP, HTML, COM (DCOM), Client Server Backend: Advantage, MS SQL, ANSI SQL92, and assorted other databases through ODBC and OLE-DB)
CapCom Medical Computer Systems, Inc., Haddonfield, NJ
Systems Programmer, 6/1990 - 5/1991
Created documentation and maintenance programming of medical billing and clinical nursing system for Nephrology. (C and ASM used for interface development. Basic compiler 7.1 used for the applications programming)
Opex Business Machines, Cherry Hill, NJ
Electronics Lab Worker, 1/1982 - 9/1982
Worked in various areas of production on the company's two main products that rely on embedded software and microprocessors for control. (Late CP/M and early DOS era programming)
EDUCATION
U.S Professional Institute, Cherry Hill, NJ
Oracle 8i Database Administrator course
Information Management Group, Chicago, IL
Mastering Microsoft Visual Basic 6 Development (skills update training)
Mastering Distributed Application Design using Microsoft Visual Studio 6
Mastering Microsoft SQL Server 6.5 Administration and Development
Franklin College, Albuquerque, NM
Microsoft Visual Basic 5 (skills update training)
Computer Language Arts, Cherry Hill, NJ
C Language Advanced Techniques
Camden County College, Blackwood, NJ
C Language Programming
Lyons Institute, Cherry Hill, NJ
Digital Electronics and Microprocessor Technology Curriculum
Los Angeles Community College, Iwakuni, Japan
Law Enforcement Curriculum
Assorted Factory and Corporate Training from ExtraCorporeal, Johnson & Johnson, Baxter Healthcare and Osmonics Corporations
SPECIALIZED TECHNICAL TRAINING AND COURSES
.NET Micro ORMs
A Web developer's guide to images
Advanced BI development with SQL Server 2005
ARC201 Decoupling Contract from Implementation: Microsoft .NET Interface-Based Programming End-to-End
ARC202 Architectures: The Good, the Bad, and the Ugly
ARC208 Why Software Sucks
ARC209 Understanding Software-Plus-Services: A Perspective
ARC306 Choosing Communication Styles: SOAP/WS-* vs. REST
ARC402 Architectural Considerations for the ASP.NET MVC Framework
ASP.NET 2.0 Developer Update Training
ASP.Net MVC - Client To Server, There and Back Again
ASP.NET MVC4 Fundamentals
Building Applications with ASP.NET MVC 4
Building ASP.NET MVC Apps with EF Code First, HTML5, and jQuery
Building ASP.NET MVC Apps with EF Code First, HTML5, and jQuery
Building Web Applications with ASP.NET MVC
Collabnet and Subversion Training
COS308 - Using Microsoft SQL Azure with On-Premises Data: Migration and Synchronization Strategies and Practices
DAT06-ILL Stupid SQL Tricks: Insights from Microsoft IT
DBI403 - Building Scalable Database Solutions Using Microsoft SQL Azure Database Federations
DEV333 - Hack Proofing Your Microsoft ASP.NET Web Forms and MVC Applications
Developing XML Web Services Using Microsoft ASP.NET (2524)
DPR312 - Architecting for a Secure Cloud
Extending ASP MVC with jQuery, AJAX and JSON
Hack-Proofing your ASP.NET MVC Web Applications
HTML Fundamentals
HTML5 Fundamentals
Implementing XML using the new native XML Datatype in SQL 2005
Introduction to Bootstrap
JavaScript + jQuery Design Pattern Framework 2013
JavaScript Fundamentals
jQuery Fundamentals
MID306 - Design Patterns, Practices and Techniques with the Windows Azure AppFabric Service Bus
MID307 - Make Yourself Comfortable and REST with Microsoft .NET
MID314 - Services Made Easy with WCF 4, Microsoft Visual Studio 2010 and Windows Server AppFabric
MS2792A – Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
MS2795A – Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services
MS2797 – Designing A Solutions Architecture Using SQL 2005 Reporting Services
Node Application Patterns
Node.js for .NET Developers
PRC06 - Professional SharePoint Development
Professional .NET Design Pattern Framework 4.5
RESTful Web Services with Node.js and Express
Scrum Fundamentals
SOA10-TLC More Windows Workflow Foundation Hosting Options than You Thought
SOA14-ILL Introduction to Windows Communication Foundation
SOA16-ILL Developing Workflow Services
SOA205 Extending the Application Platform with Cloud Services
SOA206 Messaging, Identity, and Workflow in the Cloud
SOA305 Getting Workflows Running and Talking in Your Applications
SOA311 Building Human Workflows with Windows Workflow Foundation State Machines
SOA315 Productive Windows Communication Foundation
SQL and Database Design Pattern Framework
SQL Server 2005 Analysis Services
SQL Server 2005 BI in Project REAL
SQL Server 2005 Integration Services
Structuring JavaScript Code
T4 Templates - Introduction to Microsoft's Text Template Transformation Toolkit
Using HTML5 and CSS3
Visual Studio Team Edition for Database Professionals,
Web performance
Windows Workflow Foundation and Web Designs with Expression Web