Microsoft Office Products
BRIAN FRANK
AZ - Prescott,AZ
Summary
Accomplished Business Intelligence Developer and Senior Quality Analyst with a proven track record at Yavapai Regional Medical Center. Expert in ETL development and SQL programming, I excel in data quality management and team collaboration. Achievements include data warehouse creation from conception to implementation and continuous improvement, streamlining data analysis processes and significantly improving product quality.
Overview
14
14
years of professional experience
Work History
Business Intelligence Developer
Yavapai Regional Medical Center
12.2016 - Current
- Improved data gathering, analysis, and visualization procedures with strategic optimizations.
- Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.
- Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
- Ensured data quality and integrity by implementing rigorous validation methods within the business intelligence framework.
- Designed customized data collection models for specific visualization tasks.
- Optimized data processing for faster insights by designing efficient ETL processes and data models.
- Supported senior management with timely ad-hoc analyses, enabling agile responses to market changes.
- Developed a scalable business intelligence architecture to accommodate future growth and changing requirements.
- Generated reports, updated spreadsheets, and presented results.
- Increased accuracy of forecasted trends by incorporating predictive analytics into business intelligence solutions.
- Streamlined data analysis by creating customized visualizations, dashboards, and KPIs using BI tools.
- Collected data from wide-ranging sources.
- Compiled, maintained and developed database systems for tracking tailored content reports.
- Assisted in budget planning activities by providing accurate projections based on historical trends and current market conditions.
- Wrote and optimized SQL statements to assist business intelligence practices.
- Designed and developed forward-thinking systems that meet user needs and improve productivity.
Senior Quality Analyst
Freeport-McMoRan Copper & Gold
01.2011 - 01.2016
- Improved product quality by implementing rigorous testing protocols and identifying areas for improvement.
- Streamlined quality assurance processes through the development of comprehensive test plans and checklists.
- Leveraged strong analytical skills in monitoring performance statistics against established benchmarks, identifying opportunities for targeted improvements in specific areas.
- Evaluated competitor offerings as part of ongoing market analyses, identifying areas where company''s products could be further differentiated through superior quality or innovation.
Education
MBA - Technology Management
University of Phoenix
01-2010
Skills
- ETL development
- SQL programming
- Data quality management
- Report writing skills
- Database creation
- Data warehousing
- Data integration
- Problem-solving
- Multitasking
- Team collaboration
- Programming languages: java, C#, net, Python
Software
Microsoft and Oracle SQL
Python, Visual Basic, C#
SSIS and SSRS
Cerner CCL and DA2
Lawson
HCI
Tableau
Crystal Reports
Timeline
Business Intelligence Developer
Yavapai Regional Medical Center
12.2016 - Current
Senior Quality Analyst
Freeport-McMoRan Copper & Gold
01.2011 - 01.2016
MBA - Technology Management
University of Phoenix
Similar Profiles
Ashtyn RodriguezAshtyn Rodriguez
Licensed Nurse Assistant at Yavapai Regional Medical Center WestLicensed Nurse Assistant at Yavapai Regional Medical Center West
Lindsay FannLindsay Fann
Registered Nurse, Medical-Surgical Unit at Yavapai Regional Medical CenterRegistered Nurse, Medical-Surgical Unit at Yavapai Regional Medical Center
Hailey MayhanHailey Mayhan
Emergency Room Technician at Yavapai Regional Medical Center EastEmergency Room Technician at Yavapai Regional Medical Center East