Financial/Data Analyst with Strong Excel & SQL skills

B. Arceo Page *

Financial/Data Analyst

A highly skilled, detail oriented, and analytical individual looking for an opportunity to work in a well-established company, to be in a working environment that would help redefine my skills and help enhance my abilities as a Financial/Business Systems Analyst.

Professional Experience

U.S. General Services Administration (contractor), reported to the following Departments: RWA and Capital Projects Division/Financial Management Division/ RWA Severable Services Group/ RWA Financial Administration Realignment Team. Hired through the following Companies: DSI Corporation, Solutions Guidance Corporation, ELOCEN, Capitol Creag, Washington DC

Financial/Data Analyst June 2007 – March 2025

Responsible for processing and managing of RWAs (Reimbursable Work Authorizations)

Assigned under the RWA and Capital Projects Division, process and manage both severable and non- severable RWA’s, issue project numbers, calculate fees, solicit signatures, and submit RWAs to Finance. Interact with building managers, project managers, and agencies, insure RWA requirements are met and that they are properly documented. Audit and reconcile RWA obligations and payments. Manage RWA close outs.

Help improve customer service, financial performance, and work performance of the RWA financial team.

Management of data systems and make recommendations for how they can be efficiently and effectively utilized.

Perform data extraction, cleaning, and analysis. Build various reporting tools and streamline data processes.

Assist management by providing data analysis needed in monitoring trends, identifying discrepancies and provide appropriate solutions.

Handle multiple financial data related inquiries and support desktop user operations. .

Maintain Reports and help Develop Reporting Tools used for tracking Financial Activity.

Facilitate help with desktop computer troubleshooting. Current Applications being used: Pegasys, RETA, FMIS, Invoice Search, VCSS, EASI, ULO Database, Power Bi and Business Intelligence.

Phoenix Health Systems/Dimensions Healthcare, Cheverly, MD Junior Systems Analyst/ Helpdesk Liaison December 2005 – April 2007

Assist in analyzing requests for support that require system changes and recommends appropriate solutions in accordance with the strategic plan.

Assist in design, development, and implementation of new system features and capabilities.

Documents application and project design for ongoing support.

Respond with the appropriate resolution for assigned financial applications and systems. Adventist Healthcare, Rockville, MD

Business/Financial Systems Analyst 2001- December 2005 SMS-INVISION User Support for Patient Accounting

PRMN & PRINS maintenance – update insurance profiles, demographics, and bill formats.

PROUT analysis – update & modify system access for different users.

AD-HOC reporting

Review & analyze various SMS reports like the ADM.CIS, PA-ATF, PA-IAR, & the ABS-CTRL or Controller’s Report.

Benedict M. Arceo

Contact: 301-***-**** (Cel) *************@*****.*** B. Arceo Page 2

SMS Document Imaging Administrative Support

Responsible for setting up user accounts and determine the type of access needed.

Monitor day-end reports, making sure they crossover to document imaging.

Offer Technical support and perform basic trouble shooting related to the application. ImageSilo Administrative Support

Responsible for setting up user accounts and determine the type of access necessary. Desktop User Support

Assistant to various users; enable them to be more proficient in several computer applications like MS Word and Excel.

Liaison for Patient Accounting, Helpdesk, and Information Systems Department. Send out notifications or updates on various IS problems or issues.

Financial Analyst 2001- December 2005

Report directly to the Regional Director of Patient Financial Services. Perform extensive data analysis. Provided support to Finance/Accounting, Billing, Reimbursement, and Customer Service Departments. Assisted in streamlining a number of department processes and helped evaluate productivity.

Contribute in the reduction of Accounts Receivable.

Analyze revenue, monitor cash collections, contractual adjustments and write-offs.

Present information and strategic recommendations to Senior Decision-Makers. Reimbursement Team Leader/Managed Care Specialist/Patient Financial Services Representative 1998-2001 Act as an adviser to managers, respond to employee needs, provide assistance on legal cases, supervised training, assess employee performance, and target financial goals, update reference materials and plan documents. Handled patient calls, researched claims history

Evaluated claims being submitted to the different Managed Care Organizations.

Handled both medical and technical appeals.

Update and audit accounts, posted payments and handled refunds.

Assisted in the reduction of insurance denials and claim processing delays. Specialized Skills

Extensive knowledge in the following computer applications:

MS Word

Excel – (create various formulas, pivot

tables and VLOOKUP)

Access – SQL/QUERYING

PowerPoint

MS Publisher

Patient Accounting/MIS Applications include:

SMS-INVISION

ImageSilo

ICS-Premise

SMS- Document Imaging

Express Query

Remedy Action Request System

Education

University of the Philippines/BS Communication Arts/Majored in Speech Communication/ 1997

- Taken up 6 units of public relations and advertising courses, 12 units of writing courses (9 units in Technical Writing and 3 units in creative writing).

- Taken up 14 units of Chemistry Courses (5 units of General Chemistry, 4 units of Organic Chemistry, and 5 units of Biochemistry).

Contact this candidate