Rachel Johnson Email and Phone Number

Works closely with the highest levels of leadership to identify and achieve business objectives by utilizing project management methodologies combined with data-driven decision making. Responsibilities include; identification and oversight of projects to align business goals with technology solutions to drive process improvements, competitive advantage, and bottom-line gains.- Utilize Power BI development skills to create artistic effective interactive dashboards. - Expert data manipulation skills used to turn disparate data sets and reports into comprehensive actionable intelligence. - Audit creation to ensure accurate and timely processing of all financial transactions. - Created process to track key performance indicators against stated business objectives.

Data and project manager responsible for technical data manipulation, reconciliation and business intelligence visualization via manual gathering, analyzing and preparation of data. Prepares and presents monthly reports, financial analysis, audits and dashboards at multiple sites for varying levels of upper management both internal and external. • Design and maintain various interactive dashboards and databases used to analyze internal proficiency and provide interpretation of data output; analysis includes budget management, statement reconciliations, productivity, balanced scorecards, schedule utilization, timeliness, no-show rates, also adherence to contractual engagement requirements, measures and budget restrictions. • Prepares and maintains various programs budgets and resource allocations for multiple business units and state/federal contract deliverable requirements. • Created reoccurring audit process for various business units to ensure entry accuracy and data cohesion between people, process and systems. • Responsible for tracking and reporting on organizational quality improvement programs and key performance indicators (KPIs.)• Travels to provider locations to assist with education, training and data interpretation as needed.• Prepares and presents ad hoc reports as requested.

Duties include initiative implementation, data analytics, spreadsheet manipulation and financial analysis. • Managed Electronic Billing Platform conversion project from conceptualization through implementation to streamline reconciliation of multiple ERPs and billing systems. • Created technical documentation of various billing and data entry processes, by extension identified areas for process improvement.• Created and implemented reconciliation process between billing and cash application departments.• Trained end users on system use and process to continually reconcile the billing platform to the CRM. • System administrator for billing system; outlined access control, definition requirements and reporting structure for 800 employees. • Compiled and analyzed monthly bank and merchant statements to include complex fee analysis for executive management. Responsible for monthly bank reconciliations for 36 bank accounts within multiple individual corporate entities.

Assistant AR manager and technical point of contact responsible for integrating a new entity into existing shared service center. Led team of fifteen accountants during system integration, applying high volume payments via multiple payment sources/ avenues. Manually created reconciliation process to balance cash between billing system, the bank and general ledger for multiple revenue streams.• Bank Money Movement (Funds Transfer, Lock Box Uploads, Flat File Processing, Remote Deposit Capture, External Bill Payment, etc.)• Assisted in coordination and integration of a new property into an existing Financial Shared Service Center. • Was technical point of contact for Citrix Circulation and AdBase systems, GEAC, multiple banking interfaces, software upgrades, performance testing, etc. • Developed best practices for AR activities, reporting, communications, processes, and procedures.• Audited error reports and trained team members on manual cash application, processing large volume A/R utilizing multiple interfaces to multiple A/R accounts.• Audited error reports from various interfaces and banking institutions.

Managed operations and marketing for local division of a nationwide membership association. • Averaged 25%-30% growth in revenue year over year.• Processed all monetary dues, statistics, schedules and paperwork for 34 competitive divisions encompassing 265 teams with over 2,000 local members weekly.• Coordinated and directed 30 tournaments annualy with a local annual cash payout >$1M to include various awards and trophies.• Prepared budget and ran financials; overhead, player cash payouts, high volume monetary tracking, deposits. Vendor contracting and invoicing, general ledger, account reconciliation and financial report generation.

Professional ninja responsible for leadership of 5 independent studio locations. Implemented marketing strategies and sales techniques resulting in exponential growth for all studios in the region.