Ryan Shaw
Summary of Qualifications
Over ** years of professional information technology experience. Significant experience in Database Administration, SQL Server, AWS, Azure, C#, Python, SSIS, SSRS, Machine Learning/AI, and more. Solid candidate with excellent problem-solving and communication skills.
Technical Skills
Technologies/Tools: SharePoint, .NET, C#, Python, AWS, Azure, Azure Dev Ops, Machine Learning/AI, HTML, JavaScript, PHP, XML, SAP, SSRS, SSIS, Swift, Objective-C, Visual Studio, Photoshop, Microsoft Office, LINQ, Agile, IBM InfoSphere Optim, Delphix
Skills: Database Administration, Data Analysis, Business Process Improvement, Enterprise Resource Planning (ERP), Change Management, ETL, Procurement, Business Analysis, Project Management, Project Planning, Supply Chain Management, Continuous Improvement, Application Development, iOS Development, Shell Scripting,
Computer Systems: Windows, MacOS, Linux, UNIX
Databases: MS SQL, MySQL, Oracle, PostgreSQL
Professional Experience
ETL Developer at Zions Bancorporation Dec 2018 – Jun 2024
System Development, Data Analysis, Process Management, Data Privacy, IT Solution Analysis, Global Testing, Reference Data, Management Reports, Vendor Relations, Release Management
·Responsible for identifying, classifying, downloading, and obfuscating PII information across multiple banking systems comprising a variety of databases including MSSQL, Oracle, PostgreSQL.
·Analyzed and evaluated possible IT solutions in consultation with data security and outside vendors, and made recommendations to procurement advisory board.
·Supported and administered credit card testing/analysis systems.
Developer at Self-employed Dec 2015 – Dec 2018
Application Development
·Created iOS application to graphically map astronomical telescope FOV (field of view) to specified sensor size as well as displaying DSO (deep-sky objects) as an optional overlay.
·Created Windows application using C# to map device input assignments using open-source library SharpDX.
Specialist, System Development at Rio Tinto Aug 1994 – Dec 2015
System Development, Data Analysis, Process Management, IT Solution Analysis, Global Testing, Reference Data, Management Reports, Vendor Relations, Release Management
·Created custom system to track and analyze various metrics combining external data with internal procurement processes and data.
·Managed re-engineering of multiple internal processes and data to optimize fit with current or future systems.
·Analyzed and evaluated possible IT solutions in consultation with procurement and outside vendors, and made recommendations to procurement advisory board.
·Led regular meetings with consultants, team members and other participants in systems development across the globe.
·Liaised between technical/development team and procurement, facilitated design decisions where necessary and communicated regular updates to all parties involved.
·Coordinated and conducted global testing of new development.
·Maintained, developed and supported internal databases related to procurement transactional data.
·Created and maintained all reference data. Provided proposals for structural modifications where necessary.
·Maintained, developed and supported bespoke systems to import vendor external data for transformation, analysis, and reporting.
·Responsible for data standards for reference data where needed and documented their use. Created and maintained all reference data. Provided proposals for structural modifications where necessary.
·Monitored procurement transaction data and systems on a regular basis. Created regular management reports on transactional data.
·Highlighted problems and investigated issues with transactional data, or instructed users on how to investigate.
·Responsible for troubleshooting and provided solutions to existing data or procedural problems (in cooperation with IS&T where necessary) and followed up on corrections.
·Coordinated meetings and negotiated with vendors regarding procurement agreements and interfaces. Worked in cooperation with IS&T to create and maintain direct connect interfaces to ensure data integration.
·Coordinated and conducted testing of bug-fixes, new releases and upgrades.
Specialist, Systems Development, Procurement (2007 – 2012)
Data Analysis, Project Tracking System, Document Management System
·Responsible for data analysis and reporting on key metrics.
·Developed and maintained project tracking system.
·Managed department document management system.
Specialist, Data Systems (2001 – 2007)
Data System Management, Document Management Systems, Price Analysis
·Developed and maintained project tracking system.
·Managed department document management system.
·Responsible for analysis and import of external vendor pricing data.
More experience and references available upon request