Consultant at Catapult Systems
Houston, Texas Area
Consultant at Catapult Systems
Houston, Texas Area
Ryan is custom application development consultant specializing in Microsoft technologies and a former internal control specialist with broad industry experience, especially in the construction, information technology and oil & energy sectors. His professional interests include developing systems to automate the design, documentation and execution of internal controls programs; building and motivating teams; and educating and mentoring others.
Ryan has special interests in utilizing web technologies to make business processes more efficient and enable more seamless integration between existing systems and new business requirements.
Application Development using C#, VB.NET, SQL Server, MySQL, and the Microsoft Office suite (including SharePoint)
Web Development using ASP.NET, CSS, Javascript, PHP, Ruby on Rails, (X)HTML, XML, XForms, XQuery, XSLT
Other:
Sarbanes-Oxley (SOX) Compliance, Segregation of Duties (SOD), Control Rationalization, Risk Assessment, IT Audit (CISA), Construction Audit, Approva BizRights
(Privately Held; 51-200 employees; Information Technology and Services industry)
January 2008 — Present (10 months)
• Extended a FTP client application to use the SFTP protocol using the SecureBlackBox library for a professional sports team.
• Created a web-based, dashboard that compiles hierarchical reports off of data stored in a SQL Server database and a utility to load data nightly from an Access database for a non-profit company.
• Configured custom SharePoint web services to impersonate a Forms Based Authentication (FBA) user for a software company. Also, built a custom multi-upload web part and worked with Catapult consultant John Sifri and Microsoft to identify the proper configuration for enabling My Sites with FBA.
(Public Company; 1001-5000 employees; EPE; Oil & Energy industry)
July 2006 — January 2008 (1 year 7 months)
• Led a project team to segregate duties (SOD) across multiple ERP and legacy systems to reduce compliance risk.
• Assisted in analyzing and documenting risks and internal controls for compliance with the Sarbanes-Oxley Act of 2002 (SOX).
• Created collaborative workspace (Microsoft SharePoint) for the Risk Control department and related parties for managing SOX and SOD efforts.
• Re-organized the risk and control documentation database model to reduce duplication of risks, controls and management forms for SOX compliance.
• Re-wrote the EPCO's Sarbanes Tracking and Reporting Tool (START) application to use SharePoint, Excel, InfoPath and SQL Server to enable users to work more effectively.
• Created risk assessment processes for analyzing financial reporting risks and reducing the number of key controls for both business and IT functions.
(Public Company; 10,001 or more employees; CBI; Construction industry)
August 2004 — July 2006 (2 years)
• Assisted in the documentation and testing of internal controls in compliance with the Sarbanes-Oxley Act of 2002.
• Assisted in the oversight of staff and contract personnel.
• Analyzed and reported audit exceptions and coordinated with the internal and external audit teams to consolidate exceptions from their reviews.
• Oversaw the development and implementation of the START tool at CB&I, including user testing and training and the development of queries and reporting tools required by the Corporate Compliance Group.
(Partnership; 10,001 or more employees; Accounting industry)
September 2002 — August 2004 (2 years)
• Developed a database application in Microsoft Access used by more than twenty publicly traded companies to track and assess internal controls as part of their Sarbanes-Oxley Act of 2002 compliance projects.
• Managed the documentation of internal controls for two overseas branches (United Kingdom and Australia) of a global, publicly traded company as part of their Sarbanes-Oxley Act of 2002 compliance project.
• Performed general computer controls assessments as part of an audit, including a healthcare provider (hospital) and healthcare fund.
• Researched virtual private networks and middleware controls to grow corporate knowledge.
M.S., B.B.A., Management Information Systems, Accounting, 1997 — 2002
Bible study, teaching, web development, programming, reading, writing, western martial arts, skiing, basketball, soccer, traveling, mac, ruby on rails, .net
Artifact, ISACA
Certified Information Systems Auditor (CISA)
Texas A&M University Buck Weirus Spirit Award