Andrew VanStee
Business Analyst at BAPTIST HEALTH SOUTH FLORIDA FOUNDATION INC- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Spanish Limited working proficiency
-
Romanian Elementary proficiency
-
Tagalog Elementary proficiency
-
English Native or bilingual proficiency
Topline Score
Bio
Tess Goswami
Andrew was a dedicated community member; he was focused on developing quality connections with his residents and was reliable member of the leadership team.
John C. Medendorp
Andrew was a level-headed Resident Assistant who was able to carefully balance the necessary roles of listening to students and enforcing school policy. His presence made the floor a safe, orderly environment that allowed people to flourish in both academic and social life.
Tess Goswami
Andrew was a dedicated community member; he was focused on developing quality connections with his residents and was reliable member of the leadership team.
John C. Medendorp
Andrew was a level-headed Resident Assistant who was able to carefully balance the necessary roles of listening to students and enforcing school policy. His presence made the floor a safe, orderly environment that allowed people to flourish in both academic and social life.
Tess Goswami
Andrew was a dedicated community member; he was focused on developing quality connections with his residents and was reliable member of the leadership team.
John C. Medendorp
Andrew was a level-headed Resident Assistant who was able to carefully balance the necessary roles of listening to students and enforcing school policy. His presence made the floor a safe, orderly environment that allowed people to flourish in both academic and social life.
Tess Goswami
Andrew was a dedicated community member; he was focused on developing quality connections with his residents and was reliable member of the leadership team.
John C. Medendorp
Andrew was a level-headed Resident Assistant who was able to carefully balance the necessary roles of listening to students and enforcing school policy. His presence made the floor a safe, orderly environment that allowed people to flourish in both academic and social life.
Credentials
-
CompTIA Project+ Certification
CompTIAJul, 2014- Sep, 2024 -
Certified Pharmacy Technician
Pharmacy Technician Certification BoardJan, 2010- Sep, 2024
Experience
-
BAPTIST HEALTH SOUTH FLORIDA FOUNDATION INC
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Business Analyst
-
Jan 2019 - Present
Created Dashboards and reports using data from Raiser's Edge, PeopleSoft, and other systems using Power BI, Excel and other reporting tools Created Dashboards and reports using data from Raiser's Edge, PeopleSoft, and other systems using Power BI, Excel and other reporting tools
-
-
-
Wolverine Worldwide
-
United States
-
1 - 100 Employee
-
Cash Analyst (Contracted)
-
Nov 2017 - Feb 2018
• Processed incoming payments from Check, ACH and credit card transactions using SAP • Documented payment variances involving discounts, returns, and freight charges • Analyzed payment data exported from SAP and third-party processors using Excel • Processed incoming payments from Check, ACH and credit card transactions using SAP • Documented payment variances involving discounts, returns, and freight charges • Analyzed payment data exported from SAP and third-party processors using Excel
-
-
-
AmerisourceBergen
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Territory Account Manager
-
Jun 2016 - Nov 2017
• Launched 15+ new locations while collaborating with nearly 50 medical practices to create on-site outpatient pharmacy dispensaries • Identified, monitored, and documented financial information detailing average days outstanding, and margin and category breakdowns for 13 accounts monthly with deposits ranging from $40-500K • Designed and led over 30 trainings for medical staff on QS/1 PrimeCare software; implemented and demonstrated best practice examples in pharmacy dispensing • Installed, customized, and maintained pharmacy dispensing software remotely for clients • Created and maintained customized financial and compliance reports 1-2 times a month for medical practice clients • Coordinated with insurers, licensing boards, and payment processors to register, enroll and maintain compliance for pharmacy dispensing at partner locations Show less
-
-
-
HomeTown Pharmacy
-
Pharmaceutical Manufacturing
-
100 - 200 Employee
-
Pharmacy Accounts Receivable Specialist
-
May 2015 - Apr 2016
• Oversaw and tracked insurance billing, accounts receivable, and financial analysis for 60-70 locations with facility accounts and 1500 patient accounts • Audited all medical charges and billing statements, notifying medical facilities and patients of incorrect charges to ensure accurate and timely payment; resolved payment exceptions in collaboration with third-party vendors • Extracted information from complex databases for 30, 60, and 90-day outstanding payments; generated reports using advanced Excel methods including pivot tables and macros Show less
-
-
-
Spectrum Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Certified Pharmacy Technician
-
Jun 2010 - Apr 2015
• Created detailed reports using Business Objects while overseeing medical billing, inventory, and usage tracking • Performed medical billing audits to rectify incorrect charges and receive accurate payment • Organized and maintained comprehensive records including filing physician orders and prescriptions • Processed Medicaid claims for 340B carve-out • Created detailed reports using Business Objects while overseeing medical billing, inventory, and usage tracking • Performed medical billing audits to rectify incorrect charges and receive accurate payment • Organized and maintained comprehensive records including filing physician orders and prescriptions • Processed Medicaid claims for 340B carve-out
-
-
-
Advanced Specialty Hospital Toledo
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Lead Pharmacy Technician
-
Jan 2010 - May 2010
• Integrated reporting system for pharmacy accounts payable and receivable accounts; updated and maintained data/computer systems for accurate billing statements • Created and maintained pharmacy dispensing software system with reports and labeling compliant with Joint Commission standards • Developed financial reporting structure leading to accurate and compliant monitoring of revenue and expenses • Created and updated policies and procedures and formulary to ensure standard of care • Integrated reporting system for pharmacy accounts payable and receivable accounts; updated and maintained data/computer systems for accurate billing statements • Created and maintained pharmacy dispensing software system with reports and labeling compliant with Joint Commission standards • Developed financial reporting structure leading to accurate and compliant monitoring of revenue and expenses • Created and updated policies and procedures and formulary to ensure standard of care
-
-
-
Fundatia Noi Orizonturi/ New Horizons Foundation
-
Romania
-
Civic and Social Organizations
-
1 - 100 Employee
-
Youth Development Consultant
-
Sep 2009 - Dec 2009
• Led community development courses focused on problem solving, project management and entrepreneurship for 8 students on behalf of Northwestern College • Monitored national and international program expansion impact to align with grant standards • Led community development courses focused on problem solving, project management and entrepreneurship for 8 students on behalf of Northwestern College • Monitored national and international program expansion impact to align with grant standards
-
-
-
World Renew
-
United States
-
Non-profit Organizations
-
1 - 100 Employee
-
International Staff Philippines
-
Sep 2008 - Sep 2009
• Coordinated and led trainings for groups of up to 50 individuals on financial management, strategic planning and board governance for local partners; oversaw disaster response planning processes• Supported the work of the organizational communications and logistics both on a local and international basis • Bought together community organizations with international NGO partners to plan for disaster response situations
-
-
Youth Development Researcher
-
Feb 2008 - Sep 2008
• Created new youth development field manual for international education and training activities used across the organization• Researched best practices in training youth abroad on financial literacy topics, entrepreneurship, civic engagement, and community health
-
-
-
Calvin College
-
United States
-
Hospitals and Health Care
-
Resident Assistant
-
Aug 2007 - May 2008
• Oversaw International Floor at Calvin College• Planned educational programming related to anti-racism and multiculturalism
-
-
Director-Faith and International Development Conference
-
Oct 2005 - Mar 2008
• Founded and directed 3-day conference averaging over 500 annual attendees designed to educate, inspire and develop students from a faith-based perspective• Developed and administered $40,000 annual budget; gaining and retaining support of numerous domestic and international sponsorships• Created and presented extensive final conference reports to sponsoring donors, detailing conference statistics and related outcome information• Facilitated communication and interactions between 23 organizations, 30 colleges, and 40+ volunteers• Planned all event operations, including guest speakers, housing, food, marketing, and evaluations Show less
-
-
-
-
Youth Engagement Intern
-
Feb 2007 - May 2007
• Participated in youth capacity building programming promoting trust-building and civic engagement • Updated English language manual for new technology and possible international expansion • Wrote several funding grants • Participated in youth capacity building programming promoting trust-building and civic engagement • Updated English language manual for new technology and possible international expansion • Wrote several funding grants
-
-
-
-
Certified Pharmacy Technician
-
Sep 2004 - Jan 2007
• Assisted Pharmacist in preparing both oral and IV drugs for administration • Assisted Pharmacist in preparing both oral and IV drugs for administration
-
-
Education
-
2013 - 2016
Western Governors University
Bachelor of Science (B.S.), Accounting -
2012 - 2013
Grand Valley State University
Accounting -
2010 - 2012
Calvin College
Biology -
2004 - 2008
Calvin College
BA, International Development and Economics -
2000 - 2004
Grand Rapids Christian Highschool
Highschool Diploma, 3.3
Community
