Ron Patz
Huntersville,NC
Summary
- Twenty years of experience in .NET applications - Twenty years of experience in SQL Server database design and construction - Problem solving, analytical, and communication skills - Enthusiasm for learning new technologies and challenging concepts
Overview
20
20
years of professional experience
1
1
Certification
Work History
Application Systems Engineer 5
Wells Fargo
03.2016 - Current
- - Archive Validation Platform – Enterprise-wide message validation platform
- O Developed a message validation engine used for the validation on multiple source and destination systems in the enterprise.
- O Developed database partitioning schemas to facilitate rapid archiving of table partitions.
- - Tetris – Application used to manage all the enterprises Exchange servers
- O Modernized so that so that it was deployable through TFS controlled build
- O Designed a crawler to decrypt all Voltage encrypted emails on the production Exchange servers.
- O Developed a standalone application for decrypting
- - Enterprise Provisioning Framework – Application used as a back end for all BAU messaging through Service Now and other source systems
- O Integrated Apigee endpoint for all Mobile Device Provisioning requests.
- O Developed Apigee endpoint for to be able to consume EPF APIs
- O Update the application to work with ZL 9.2
- O Lead developer for the Compliance report which was tied to a regulatory control
- - Developed an ASP.NET MVC site used for orchestration between Informatica Web Services Hub, Python, AutoSYS, and an Oracle database.
- - Responsible for site look/feel and producing site design wire frames.
- - Responsible for site design and overall site architecture.
- - Conducted code reviews and mentored junior team members.
- Environment: Informatica Web Services, Oracle 12g, JavaScript, ASP.NET, HTML, CSS3, ASP.NET MVC, WebAPI, Kendo UI
Lead Web Developer - FSB Phase Three
Bank of America (Tek Systems)
09.2014 - 03.2016
- - Sr. Programmer Analyst - FSB Phase Two
- O Part of team responsible for the creation, enhancements, and bug fixes of ASP.NET MVC 4.5 site used by Bank of America to submit report to the Financial Stability Board.
- O Developed an import process to import Excel spread sheets into SQL databases.
- O Developed a dashboard using Chart.js and NG-Grid.
- O Developed an administration section of the site.
- O Enhanced multiple .Net 4.5 WCF services used in conjunction with the FSB site.
- O Enhanced console applications used to monitor file imports from authorized data sources.
- O Conducted code reviews and mentored junior team members.
- Environment: Windows 7, Windows Server 2012, Visual Studio 2012/2013, Team Foundation Service, SQL Server 2012, Beyond Compare 3, Chart.js, NG-Grid, Grid.MVC, SQL, JavaScript, VB Script, ASP.NET, HTML, CSS3, ASP.NET MVC
Sr. Programmer Analyst
Radix Bay
08.2013 - 09.2014
- - Part of team responsible for the creation, enhancements, and bug fixes of ASP.NET MVC 5 applications designed for clients.
- - Developed an ASP.NET MVC 4 site used for multi-client document management and publication on a very constricted time line.
- - Provided enhancements and bug fixes for an ASP.NET MVC 5 site used as a data analytics front end for Microsoft’s business intelligence stack
- - Created ETL packages for client’s data warehouse.
- - Extensive use of Keno UI controls
- - Developed an ASP.NET MVC 5 site used for multi-client historical document management.
- - Developed an ASP.NET MVC 5 administration site used to create and edit access for multiple client sites.
- - Developed many demo sites presented by the sales team to prospective clients.
- Environment: Windows 7, Windows Server 2008R2, 2012, Visual Studio 2010/2012/2013, Git, Jira, BitBucket, SourceTree, SQL Server 2012, SSIS, SSRS, SSAS, Beyond Compare 3, C#.NET, VB.NET, SQL, JavaScript, VB Script, ASP.NET, HTML, SQL, CSS3, ASP.NET MVC 4/5, Kendo UI, Windows Azure, WebAPI, Twitter Bootstrap, Less CSS, NuGet, Knockout-Kendo
Sr. Programmer Analyst
American Tire Distributors
10.2011 - 08.2013
- - Part of team responsible for all enhancements and bug fixes for a number of mission critical applications.
- O Market Manager – Application of record for marketing information and offer payments.
- O War Room – Executive level application displaying sales and demographics information.
- O Market Dashboard – Sales level application displaying sales and demographics information.
- O Business Intelligence – Microsoft business intelligence stack used by all departments
- - Helped develop an application used by the call center to load the customer’s information for incoming calls.
- - Used VSTO to create a Microsoft Excel add in that prepared flat files for processing by Oracle systems.
- - Responsible for executing and accuracy of yearly MYSQL rollups that aggregated data used multiple systems.
- - Performed load testing on all sites maintained by the ATD Microsoft team.
- Environment: Windows XP/7, Windows Server 2003/2008, Visual Studio 2005/2008/2010, Git, CVS, MYSQL, SQL Server 2005/2008R2, SSIS, SSRS, SharePoint 2007, Beyond Compare 3, C#.NET, VB.NET, SQL, JavaScript, VB Script, ASP.NET, HTML, SQL, CSS, Classic ASP
Programmer Analyst
AAA Carolinas
09.2010 - 10.2011
- - Performed PCI compliance testing on credit card system with First Data and PNC
- - Enhancements/maintenance on all AAA Carolina internal and external C#.NET, VB.NET ASP.NET, and Classic ASP websites
- - Finished Single Sign On/Internet Profile project
- O Once a user has successfully logged in, the application will grant users access to all AAA Carolina websites without having to re-enter their login credentials
- O Increased complexity due to the required interaction with AAA National, varying membership levels, and numerous partner sites
- - Enhanced AAA’s credit card processing VB.NET web service to handle void and manual authorization transactions
- - Created a SSRS report (SSRS R2Report Builder 3.0) used by accounting to pay commissions from information pulled from Bank of America
- - Created a process to dynamically build a mailing list using SSIS and Visual Studio 2008 BIDS from a number of disparate sources for a company publication
- - Project coordinator for multiple companywide upgrades of the point of sale solution
- - Created ETL packages using SSIS and Visual Studio 2008 BIDS for companywide SharePoint business intelligence project
- Environment: Windows XP, Windows Server 2000/2003/2008, Visual Studio 2005/2008, Visual Source Safe, SQL Server 2005/2008R2, SSIS, SSRS, SharePoint 2007, Beyond Compare 3, C#.NET, VB.NET, SQL, JavaScript, VB Script, ASP.NET, HTML, SQL, CSS, Classic ASP
Programmer Analyst/ Document Imaging and Development Specialist
Asset Management Technologies
08.2005 - 08.2010
- - Implemented drag and drop dashboards and menus using dynamically created Telerik AJAX Controls
- - Integrated ad-hoc reporting into our existing application using web services, with 3rd party software, C# and XML
- - Worked with a team of developers doing site enhancements using Classic ASP and ASP.NET, VB.NET, and C#.NET
- - Created and enhanced user reports using Crystal Reports version 8.5 and 11
- - Migrated existing classic ASP web application to ASP.NET 2.0 and 3.5 with new look and feel using master pages and themes with CSS and AJAX
- - Performed maintenance on existing modules of a multi-tiered application in ASP.NET, C#.NET, VB.NET and Classic ASP
- - Created stored procedures, views and tables to support the back end of a web application using SQL Server 2000/2005
- - Used agile software methodologies to develop and enhance proprietary real estate management software using Classic ASP and ASP.NET, VB.NET, and C#.NET
- - Developed an OCR and scanning process to prepare documents for upload into the company’s proprietary software.
- - Trained and managed employees on proper scanning and OCR
- Environment: Windows XP/7, Windows Server 2000/2003, Visual Studio 2003/2005/2008, Team Foundation Server 2008, Visual Source Safe, SQL Server 2000/2005, Crystal Reports 8.5/11, C#.NET, VB.NET, SQL, JavaScript, VB Script, ASP.NET, HTML, SQL, CSS, Classic ASP
Education
Bachelor of Arts - Software and Information Systems
University of North Carolina at Charlotte
01.2011
Bachelor of Science - Computer Science
University of Pittsburgh
01.2005
Associate in Applied Science - Network and PC Specialist, Computer Forensics
Butler County Community College
01.2004
Skills
- Microsoft NET Framework – NET 11/20/35/44/50
- Languages – C#NET, VBNET, SQL, JavaScript, VB Script, Java
- Development Environments – Visual Studio 2003/2005/2008/2010/2012/2013, Team Foundation Server 2008/2012, DBForge Studio
- Web Technologies – ASPNET, JavaScript, VB Script, HTML, SQL, DHTML, CSS, Classic ASP, Microsoft Azure, Less CSS, Razor
- Database Technologies – SQL Server 2000/2005/2008 R2, DTS, SSIS, MS Access
- Source and Version Control – Team Foundation Server, Visual Source Safe, Git, CVS
- APIs & Libraries – Microsoft ASPNET AJAX, Telerik, ASPNET, AJAX, Kendo UI
- Reporting Tools – Crystal Reports 85/11, SSRS
- Operating Systems – Windows 2000/XP/Vista/7/10, Linux
Certification
- Microsoft
- MS-900 Microsoft 365 Fundamentals (2022-12)
- AZ-900 Azure Fundamentals (2022-08)
- 70-480 Programming in HTML5 with JavaScript and CSS3 (2014-06)
Affiliations
Phi Theta Kappa Honor Society Member, December 2002 - 2004
Timeline
Application Systems Engineer 5
Wells Fargo
03.2016 - Current
Lead Web Developer - FSB Phase Three
Bank of America (Tek Systems)
09.2014 - 03.2016
Sr. Programmer Analyst
Radix Bay
08.2013 - 09.2014
Sr. Programmer Analyst
American Tire Distributors
10.2011 - 08.2013
Programmer Analyst
AAA Carolinas
09.2010 - 10.2011
Programmer Analyst/ Document Imaging and Development Specialist
Asset Management Technologies
08.2005 - 08.2010
Bachelor of Science - Computer Science
University of Pittsburgh
Associate in Applied Science - Network and PC Specialist, Computer Forensics
Butler County Community College
Bachelor of Arts - Software and Information Systems
University of North Carolina at Charlotte