Data Analyst

Ryan Loper

**** ********** ** – Austin, Texas ***41

512-***-**** **********@*******.***

OBJECTIVE To employ my knowledge, creativity and experience in a challenging position where my technical and analytic skills would be used for the betterment of the organization while finding automated solutions to substantially improve efficiency and accuracy.

SKILLS

Metrics

Data Analysis

Visual Basics (macro / VBA /VBSCRIPT)

Expert in MS Office Applications

SQL Programming & Administration

EXPERIENCE

Centene Corporation, Austin Texas

Healthcare Analyst /10/2016-Present

Developed automated reporting to increase demographic data accuracy provided by the Department of Health and Human Services using Oracle, Teradata, SQL, Toad and Access

Increased the Speed of automated reporting jobs some from 8 hours to 2 minutes (Replaced cursors etc).

Inserted verification into existing jobs importing data to check for bad data.

Helped the team with automating SQL and Excel Solutions.

Developed metrics to identify trends and track data discrepancies over time.

Defined relationships and data flows, optimized structure, classification for automated reporting and validation.

ETL (extraction, transformation, loading) for complex and sometimes inaccurately formatted state files (like 834 file format).

PDS Tech (Contract For Dell), Austin Texas

Global Fulfillment Advisor 1/2012-7/2016

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 reporting.

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 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.

Monthly testing & requesting IT code improvements for approval and release into production.

Daily activities include supporting customers, project managers, sustaining team, ODM Manufactures, and IT with setting up customer projects as a subject matter expert.

Manage user access and provide support to the project management team for the main reporting database interface (sharepoint) as well providing custom ad-hoc data from SQL Queries.

Dell Computer Corporation, Austin, Texas

Global Data Analyst (DAO) –03/07-1/2011

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 external organizations performance analysis needs through standard templates or customized summarization.

Executed data analytics by combining and summarizing multiple large data sources including Oracle, SQL & Teradata.

Testing and validation of new IT infrastructure.

Participated and assisted in many Kaizen (lean manufacturing) projects as a data and manufacturing subject matter expert with other teams.

Dell Computer Corporation, Austin, Texas

CE Expeditor Specialist (DAO) –7/06-3/07

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 team for assisting them with furthering the development of their metrics.

Dell Computer Corporation, Austin, Texas

Logistics Specialist (ASL) –9/03-7/06

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 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.

Dell Computer Corporation, Austin, Texas

Inventory Control Data Sr. Analyst (ASL) – 6/99- 9/03

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, 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.

Rewarded with a position in the Logistics team for assisting them with the automation of their PO adjustment process.

Contact this candidate