Makida W-Meskel
***** **** ********* **. (Apt#***0) Dallas, TX, 75218 Phone 214-***-**** ******.********@*****.***
OBJECTIVE
Seeking for a challenging career in finance to effectively use my skills and contribute to the company’s overall growth.
SUMMARY OF QUALIFICATIONS
• Financial data analysis, budgeting, forecasting, ad-hoc reporting, variance analysis
• Data manipulation through Ms Access, Ms Excel (Advanced), Oracle/SQL (Basic)
• Audit, Account Reconciliation, Accounts Payable/Receivable
PROFESSIONAL EXPERIENCE
BROADLANE INC (Contract Engagement) Dallas,
TX
Cost Analyst (Pricing Analyst) May 2010 – Sept 2010
• Extensively audited client data in relation to the prices and suppliers used
• Uploaded audited data into a ‘cost analysis’ tool for further audit and categorization
• Selected the best price available for each and every product that was left unmatched by the tool
• Prepared a report that shows the possible benefits to the client through Broadlane contracted vendors
• Exported results to Excel database and presented to senior staff
• Prepared Implementation Reporting worksheets (IRW) for Clients’ CFO which explains the resulting effect
if a client were to implement a new contract or conversion to another vendor
Financial Analyst May 2010 – July 2010
• Pulled manufacturers’/distributors’ AP data by using SQL
• Identified, tracked, measured savings and progress in contract implementation of the clients
• Analysed variances related to documented savings and collaborated with account team members to
determine reasons for variance
• Conducted revenue, payment and contract analysis and communicated results in a detail oriented manner
• Provided support to various account teams in managing the ground level work
• Responsible for timely and accurate analysis, trending key metrics and outcomes
ERNST & YOUNG LLP (Contract Engagement) Dallas, TX
Financial Analyst (Advisory/Consultant) – June 2008 – Oct 2009
• Gathered and uploaded financial records of Medicare/Medicaid patients into Ms Access database
• Scrubbed and cleaned the data for easier use
• Reconciled data received from the hospital to the cost report filed to Medicare Reimbursement Office
• Resolved and reported any inconsistencies in the data received
• Extensive data manipulation through Ms Access/Ms Excel database
• Identified risks/opportunities in a project both individually and as a team
• Audited Accounts Payable/Receivable
• Brainstormed and discussed ways to improve a project’s efficiency/profitability
• Visited clients’ sites as needed (up to 30% travel) to gather more materials for effective project progress
• Daily use of Lotus Notes
• Accurately monitored project time-management by keeping daily log of staff hours
• Ensured compliance between a clients’ policies and E&Y’s
• Responsible for preparing and archiving work papers and other administrative tasks
EDUCATION
• B.A. Business Economics and Finance
London Metropolitan University (London, UK) (Sept 2004 – Dec 2007)
• Ms Excel (Advanced) and Oracle Database (Basic)
Richland Community College and Northlake Community College (Jan 2010 – Mar 2010)
COMPUTER SKILLS
• MS Access (Queries), MS Excel (V-lookups, Pivot Tables, Macros), MS Power Point, Oracle Database: SQL
(Basic Level)
REFERENCES - Available upon request