Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Timeline
Generic

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

Similar Profiles

  • PATRICIA M. SCHERER

    PATRICIA M. SCHERERPATRICIA M. SCHERER

    Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors

  • Andrew S. Hollenbach

    Andrew S. HollenbachAndrew S. Hollenbach

    Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA

  • Laxmikanth Chittampally

    Laxmikanth ChittampallyLaxmikanth Chittampally

    Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo

  • Mayank Oberoi

    Mayank OberoiMayank Oberoi

    Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)

  • Chloe Duquesne

    Chloe DuquesneChloe Duquesne

    Marketing and Communications Coordinator at Angels to the Animals: 501(c)(3) Non-profit OrganizationMarketing and Communications Coordinator at Angels to the Animals: 501(c)(3) Non-profit Organization

CREATE PROFILE
Ron Patz