William Zorn Email & Phone Number

Jackson, Mississippi Area

Develop visual analytics in McKesson Explorer (Tibco Spotfire), and Power BI using Power Query and DAXDevelop Power Apps for data submission and scheduling.MS SQL Server - Define and build databases, SSIS and SSRS developmentSQL Server Analytic Services - Cube development and deploymentData Warehouse (McKession Performance Manager) AdministratorManagement of Data governance and Data quality McKession Business Intelligence AdministratorStatstical data analysis using Python and Jupyter NotebooksReport creation for clinical and financial data. Including Cost analysis, HCAHPS scores, Core Measures, readmissions, patient satisfaction, and others.ETL for creating data extracts and processing data integrations. Responsible for Patient Satisfaction (NRC Picker and Press Ganey), Crimson, and Truven data feeds.SharePoint site administration for data submission and analytic report repository.Dashboard development for goal tracking and statistical analysis of data.Full automation of data flow processes for ETL (Extract-Transform-Load) supporting multiple projects.

Ridgeland, Mississippi

* JIRA (Trouble Ticket and Work Request System) Admin* actiTime Time Tracking Admin* Report generation from MYSQL and ORACLE databases* SAP Business Objects, Xcelsius: Reports and Dashboard creation.* Perl scripting with Tk GUI creation.

Hardware Design Engineer Design of hardware to meet customer specifications targeting high redundancy applications. Responsible material managment (supply identification and ordering) on design projects. Customer support on products in the field Troubleshoot and repair of devices with in-the-field failures.

Austin, Texas / Ridgeland, Mississippi

* Analog Circuit Designer - design, simulation and test of current bias generators, voltage references, comparators, and operational amplifiers. - Design of consumer analog circuits. - Address Customer performance and and requirement concerns. - Computer simulations for circuit design and verification.* Product Engineer - device qualification, failure analysis, yield analysis, product testing, statistical analysis, product introduction. - Product qualification and failure analysis. - 65% yield improvement by fixing critical memory design issue. - Statistical analysis of electrical distribution data using VBA and PERL scripts. - 23% yield improvement through test time reduction.* Lead Test Engineer - leadership of test team assigned to develop manufacture automated test programs. - Lead team to develop production test program and holding individual members to committed deadlines. - Saved $96K/million devices sold by reducing production probe test time by 30%. - Developed and improved program code in C improving yields by %23. - Focused on customer issues, debugged and suggested appropriate action on Customer returned devices.

Validation project lead responsible for establishing new validation processes and data report templates. Set new standards for turnaround time by reducing milestone completion intervals. Wrote software to fully automate validation devices in TCL/TK, established hardware setup reducing device sampling time down from one month to two weeks. Authored customer and internal reports for product validation meeting accelerated device sampling schedule while setting new company standards for report quality. Developed innovative techniques to locate high power-up current draw in digital circuitry.

B.S, Electrical Engineering ­ Computer (Eec)

Eec, Computer Engineering