Dan French: Banner Health

Download as pdf or txt
Download as pdf or txt
You are on page 1of 2

Dan French

Banner Health
Systems Consultant
March/2008-Current

Reporting and analysis for all departments in a 150+ Physician Practice.


Create and maintain SQL procedures for finance and budget.
Auditing of CPT Codes from Medicare.
Dashboard creation for Executives.
Crystal Enterprise Management

Safeway Corporation
Business Analyst
January/2004-March/2008

Over 1000 reports created with Crystal, SQL, SAS, PowerPoint, Access and Excel.
Advanced coding abilities that create compelling adhoc and standard reports.
Strength in data prediction with advanced scanning techniques of historical data.
Focus on sequential code organization that ensures accurate and organized programming.
Ability to incorporate design and logic into each report.
Forte in dynamic report structure that eliminates maintenance.
High aptitude for exception reports that show variations in large amounts of data.
Expert comprehension of different database schemas within a Mainframe environment.
ODBC connections to Microsoft SQL Server, Oracle, Informix, and CR Servers.
Management of a report review process that keeps the client environment updated.

Developed the Report Archive Database in Access.


RAD is a report warehouse that provides a central spot to create and share a variety of
reports. This program provides a report search, storage, version control, number
assignment, distribution and detailed descriptions.

Mainframe and Desktop SAS experience including automation.


Completed SAS Programming I Essentials and SAS Programming II Manipulating Data
With The Data Step. Creation of automated SAS programs with the help of Batch files
and Scheduled Tasks. Improved Proc SQL steps that were pulling millions of
unnecessary records and increasing CPU time. Enhanced the SAS Production Summary
program to use less than half the code. Created a central lookup SAS Dataset which
replaced hard coded numbers in many programs.

Developed a FTP process to export many different Crystal Reports to one source that is
automatically refreshed on opening.
Experience working with Supervisors, Managers, Analysts, Directors, DBA's, and VP's.
Fulfill requests from a variety of departments including Payment Service Center,
Blackhawk Gift Card, .com, Avia Partners, Marketing, Pharmacy, SRG, Corporate
Brands, Pricing, Secret Shopper and Out of Stock. Ability to analyze Call Center data
such as ASA, AHT, and WSL.
Reports QA Coordinator
Constructed an exception SQL program that filtered out anomalies from store reports.
Created a VBA macro based User Interface.
This UI exported report data directly to the database which greatly reduced data entry.
Created a VBA formula based Secret Shopper Store Calculator for all Store Managers.
This program relied on many advanced mathematical formulas to calculate a stores
overall score. The Calculator allowed Management to interact with the scoring process to
see the effect of one observation.
Engineered a PowerPoint process for the high profile Checkout Success and Out of Stock
reports. This process eliminated human error and production time by automatically
importing data directly to the Slideshow.
Created a HTML based DirecTree webpage that centralized department files.
Built a fully operational PHP forum for colleague collaboration.

Allowance Auditor
Quickly adapted to a complex auditing style.
Developed vendor contacts for tactful invoice negotiations.
Founded a grab and go type auditing style that increased the department’s productivity.
Set record findings with over 3 million funds recovered.
Developed the More Money Macro with VBA.
3M was integrated with another program to transform data into a trend spotting overview.
This new technique allowed for quick auditing and is still in use today.

Education
Bachelors, Northern Arizona University. December, 2003.
Major: Applied Communications, Bachelor of Arts.
Honors: National Academic Honor Society, Alpha Lambda Delta
Outstanding Program Graduate, Cum Laude, 3.5 GPA

Skills
SQL, Crystal Reports, Crystal Enterprise, ePortfolio, Business Objects, Teradata
Queryman, eGain, Oracle, Informix, SAS,
HTML, VBA, Aspect Suite, eWorkforce Management, eWFM, Producer, Access &
Excel Programming, Macros, Pivot Tables, Business Tracker, FTP,
Filezilla, Self-motivated, Interpersonal/Written/Oral Communication, Detail-Oriented,
Excellent Analytical Skills, Trend Analysis, Problem Solving.

You might also like