Samantha Frank Email & Phone Number

Chicago, Illinois, United States

• Configured and optimized Financial Planning StrataJazz cloud solution for 25+ health systems and hospitals, as large as $6 billion in annual operating revenue
• Served as project lead throughout full lifecycle of implementations including requirements gathering, system configuration, data reconciliation, quality assurance, addressing client feedback, training, and go live.
• Scoped optimization projects through leading discussions with client leadership, creating timeline documentation, analyzing license agreements, and generating SOWs using Salesforce
• Supported fellow consultants as module Subject Matter Expert on challenging technical requests and discussions

Chicago, Illinois, United States

• Reconciled large, complex data sets from ERP and EHR source systems including general ledger, payroll, accounts payable, purchase order, and inventory data using SQL queries, Excel, and proprietary software tools
• Lead administrator and end user trainings both onsite and virtually to groups as large as 100 participants, receiving an average 9/10 survey score
• Functioned as Team Lead to a team of four analysts and consultants in agile processes to ensure timely and on-budget project delivery

Chicago, Illinois, United States

• Built custom metrics, reports, and dashboards using SQL and proprietary tools based on client design requests
• Collaborated with team in an agile environment to ensure project deliverables met communicated milestones
• Selected to lead sessions at Expert Bar during annual user conference to assist clients with technical questions

• Processed applications for the MBA, MS, and PhD programs involving verifying accurate student information, reviewing resumes and transcripts, calculating GPAs and work experience, and collecting test scores.
• Handled potential applicant inquiries and applicant questions and concerns.
• Managed process of collecting application fees and tuition deposits; and updated and maintained spreadsheets to analyze workflow and application information.

Buffalo, New York

• Completed project focused on making improvements to the medical claims forecasting model.
• Enhancements include changing the regression type from linear to segmented linear, adding the ability to remove seasonality from historical data, and writing a VBA script that automates formula updates.
• The majority of my work was completed using Excel but I also worked in SQL Management Studio and SAS.
• Presented findings and recommendations to 40+ managers, directors, and executives.

Buffalo, New York

• Reconciled cash transactions of accounts daily to ensure accurate reporting.
• Researched cyclical break related to differing accounting practices.
• Analyzed accounts and reclassified them appropriately based on transactions.
• Created presentations clarifying team procedures and responsibilities, and proposed new recruiting strategies to the Human Resources Department with team of interns.

Master Of Business Administration - Mba, Analytics, Consulting, And Finance, 3.8/4.0

Activities and Societies: LeaderCORE™ - Leadership development program designed to enhance core competencies (Role Model certification).

Bachelor Of Science In Business Administration, Finance, 3.9/4.0

Activities and Societies: School of Management Honors Program, Women In Management ClubRelevant Courses: -Leadership Development -Data.