Ryan Loper Email & Phone Number

Austin, Texas, United States

• Led strategic meetings with directors and CIOs across Texas, fostering strong relationships and aligning IT initiatives with business objectives.
• Played a pivotal role in enhancing data quality at TxDot by collaborating with the Risk and Compliance team. My focus was on gathering critical data, ensuring high data integrity and reliability for organizational.
• Collaborated in a key initiative at TxDot focused on the creation of a centralized… Show more
• Collaborated in a key initiative at TxDot focused on the creation of a centralized data repository, utilizing advanced SQL techniques to ensure the highest standards of data integrity and quality. This project.

Austin, Texas Area

• Prioritized data accuracy and streamlined SQL query processes to reduce latency, Improving data processing speed by 30% through optimizing ETL processes. Actively monitored and managed database resources to support.
• Engineered and automated complex reporting processes using a variety of tools including Oracle, Teradata, SQL, Toad, Python, and Access, specifically tailored for healthcare enrolment data analysis. Innovated a Python.
• Engineered and automated complex reporting processes using a variety of tools including Oracle, Teradata, SQL, Toad, Python, and Access, specifically tailored for healthcare enrolment data analysis. Innovated a Python.

Austin, Texas

• Developed a database using complex SQL queries against other reporting databases for monitoring and reporting on upstream system as well as the performance of customer report delivery utilizing SQL, Oracle & Excel for.
• Interface with the reporting database & Dell Data Warehouse (Teradata) using SQL, Oracle & Excel to provide VP level performance metrics on overall customer reporting performance.
• Developed an audit of emailed reports by connecting a group outlook email box… Show more
• Developed an audit of emailed reports by connecting a group outlook email box to a SQL database with a refreshable excel report to see if orders are falsely showing reported.
• Led a project to transition existing FTP customers and worked directly with project managers and IT security to transition them to a more secure file transfer system.
• Working with IT programmers and developed SQL code to achieve more accuracy in Dell's purchase order data for the main reporting database.

Round Rock, TX

• Converted an existing Access cycle time database into a more flexible SQL database reporting server.
• Administrator and developer for manufacturing operations performance database, supported and monitored daily SQL jobs and SQL SSIS packages for performance & granted user security access.
• Automated global order performance metrics using a direct connection to SQL database and Excel Pivot Tables.
• Published weekly cycle time metrics for Global Operations.
• Supported… Show more
• Supported external organizations performance analysis needs through standard templates or customized summarization.

Austin, Texas

• Improved expedite management by creating an access database to measure performance.
• Coordinated among supervisors and specialist to set expectations for order completion while utilizing multiple dell systems.
• Research and resolution of aged orders in the factory.
• Worked with warehouse management, warehouse employees and on occasion even Michael Dell to coordinate the fast expedition of special orders.
• Rewarded with a position in the operations performance analysis… Show more
• Rewarded with a position in the operations performance analysis team for assisting them with furthering the development of their metrics. Show less

Austin, Texas

• Well over 230k of cost avoidance by working with supplier managers and finance to verify pricing and verification process improvements.
• Created a Visual Basics macro for the direct ship team in order to correct data transaction failures and properly adjust inventory in Dell’s system so that finance could properly credit effected lines of business.
• Interfaced with Oracle database for reconciliation of ODM invoices.
• Further developed direct lines of communication and a solid… Show more
• Further developed direct lines of communication and a solid rapport with external customers. Two letters of appreciation were received from my highest volume vendors for attention to detail.
• Worked with vendors to consolidate invoices greatly reducing the work load caused by multiple invoices. In many cases turning 100 invoice a month into 1. Show less

Austin, Texas

• Successfully achieved Yellow Belt BPI certification (six sigma alternate) by creating a reconciliation process that allows Dell to reconcile monitor transactions with a third party vendor.
• In charge of the accuracy of 3 million dollars of inventory at a 3rd party vendor maintaining 99% net accuracy.
• Designed an Access user interface to create bar-coded manifests and store a record of the inventory being transacted.
• Created an expedite reporting tool, using Visual Basics… Show more
• Created an expedite reporting tool, using Visual Basics, Access, and Outlook, to enable the efficient submission and tracking of lost parts requests.
• Designed a tool that interfaces with an Oracle database to query order substitution failures, which resulted in a net $25k daily write-off reduction.

Education record

Diploma, General