## BIO
Clifford Shively 1024 10th Ave NW Altoona, Iowa 50009 [login to view URL] 5158670963 Objective Edit Utilize my knowledge and experience in business intelligent, data warehousing and analysis to obtain a position that offers advancement potential. Work Experience 4/2005 - Present Management Metrics Analyst Wells Fargo Financial Des Moines/Iowa Continuous improvement efforts include the development and proliferation of Accounting, Metric Analysis, Production Analysis and Human Resource management tools. Developed in Hyperion Performance Suite 9.3 to create and automate Java scripted interactive dashboards, Crystal Reports, VBA programmed MS Access, VBA programmed MS Excel and Essbase OLAP cubes. Utilized SQL Sever 2000/2005 DTS/SSIS and scheduling features to gather and warehouse data. Also utilized SQL stored procedures to gather user variable to return data sets to above programs. 8/2000 - 3/2005 Supervisor Senior Financial Analyst MiPractice Solutions LLC Phoenix/Arizona Utilized Hyperion Performance Suite, MS Access (VBA) and MS Excel (VBA) to report Oracle and SQL Servers data to deliver and manage P/L margins, Production based Compensation and Accrual finance metrics for 110+ physicians. Additional responsibilities include maintaining quarterly and annual budget and forecasting, trending analysis and benchmarking as well as the reconciliation of budget vs. actual. Automated month end close processes and standard reports that optimize generation throughput time 90%. I trained all levels of staff and management to use above applications and MS Office products. 1/1998 - 8/2000 Report Analyst/Network Administrator Banner Health Phoenix/Arizona I used a file transfer program to gather mainframe data from billing software to create a data warehouse that was accesses to create month end financial reports and special requested reports utilizing MS Access and MS Excel. Provide local PC hardware/software and network support. I maintain inventory regarding IP addresses and pc hardware equipment for all clients. 10/1995 - 12/1997 Account Coordinator MedPro Phoenix/Arizona I handled all staffing issues including evaluations, HR issues and personal issues. Over seen collection teams for multiple AR accounts that totaled over 3 million dollars. I communicated with insurance representatives regarding delinquent payments and denial issues. I resolved all electronic billing and clearing house issues. Specialized in AHCCCS and Medicare collections and billing processes. 2/1991 - 10/1995 Radiological Technologist US Navy Bremerton/Washington Duties included the performance of routine and special radiological procedures; maintain imaging equipment and patient databases. Provided local PC hardware/software support.
## Area of Expertise
Skill Name Hyperion Brio Java Script SQL SERVER 2000/2005 Access (VBA) MS Excel (VBA) Crystal Reports Great Plains IDX Monarch Visio Visual Basic
