Melvin B. Swann, Jr.

*** ********* ******, *** ******, CT 06320

(860) 514- 6136

Career Summary: Professional Financial Analyst with expertise in cash management and project financial analysis. Experience with general

accounting practices and methodology, and experience in handling complex financial transactions. Solid knowledge of the following financial and

software packages: SQL, Access, Excel, PeopleSoft, Crystal Reports, Timberline, Black Baud (Financial Edge), Cognos and QuickBooks.

EDUCATION:

University of Maryland - Baltimore County, 2009

Bachelor of Arts, Economics

PROFESSIONAL EXPERIENCE:

Mohegan Sun Resort & Casino October 2012 to Present

One of the largest, most distinctive entertainment, gaming, shopping and meeting destinations in the United States.

Revenue Management Analyst

• Provide support to the property Revenue Management leaders in the areas of data compilation, market research, reservations and

database/system maintenance.

• Participate in growing revenues for the property and casino through the management of on-line extranets and reservations sites.

• Monitor and evaluate room rates and availability across all distribution channels in accordance with established guidelines to maximize

occupancy and revenues.

• Measure, analyze and report out on booking trends, pickup, no shows, and sources of business.

• Assist in the evaluation and strategic planning of future hotel acquisitions.

National Media Connection May 2011 to October 2012

A full-service media production and direct response marketing agency, creating direct response TV advertising that generates real-time leads.

Bookkeeper / Finance Coordinator

• Create and maintain spreadsheets for reporting purposes.

• Accounts receivable and collections for overdue accounts.

• Accounts payable for all vendors and overhead expenses.

• Oversee daily reconciliation of customer accounts regarding lead delivery.

• Calculate and monitor production costs in preparation for State of Connecticut production tax credit.

• Preparation of 1099s for end-of-year tax purposes.

• Perform commission analysis on a monthly basis.

Lawrence and Memorial Hospital (Consultant assigned by Kelly Services), New London February 2009 to December 2012

A non-profit, general, acute care and private hospital serving Southeastern Connecticut.

Medical Records Analyst

• Create new patient charts and deliver to various departments throughout the hospital, as needed.

• Assist management in the analysis and maintenance of medical records, using Meditech, Softmed, and Smartlink.

• Perform document compliance and prepared medical records for storage as needed.

Northeast Utilities, Inc. (Consultant assigned by CCSI, Inc.), Berlin, CT February 2010 to July 2010

Operates New England’s largest utility system serving more than two million electric and natural gas customers in Connecticut, Western

Massachusetts, and New Hampshire.

Meter Data Analyst

• Researched and provided information to key stakeholders in support of Metering Services and associated departments.

• Performed mainframe queries to troubleshoot a variety of issues related to the metering process.

• Analyzed and transferred large pieces of information between databases.

• Validated and used meter data for use in customer billing, load analysis, and other areas.

Noble Environmental Power, Essex, CT May 2008 to October 2008

Leading renewable energy company with a 726-megawatt generation portfolio and approximately 1,900 megawatts of windparks under development

throughout the United States.

Financial Analyst

• Established new bank accounts necessary for the timely completion of windpark construction projects.

• Developed and updated cash flows for several different wind turbine projects, and supported the development of project forecast

projections.

• Implemented and analyzed operations, development, and asset management budgets using Timberline.

• Used calculations and pivot tables in Excel, to perform actual vs. estimated cost analysis for the purpose of determining the

cost -effectiveness of wind energy projects.

Mitchell College, New London, CT January 2007 to March 2008

A coeducational, private residential institution offering associate and bachelor degree programs in the liberal arts and professional areas.

Project Accountant/Perkins Loan Representative

• Performed daily and monthly accounting functions related to Business Development projects.

• Prepared monthly financial statements for College business projects.

• Managed the reporting of new borrowers and former students to billing agencies according to specified compliance standards.

• Reconciled student loan journal entries monthly and annually for year end auditing.

HMSHost Corporation, Bethesda, MD October 2004 to July 2006

The world’s largest provider of food, beverage and retail services for travelers with revenues of more than $2.7 billion.

Cash and Sales Processor

• Processed cash and sales vouchers for multiple HMSHost locations throughout the United States.

• Balanced and reconciled cash and reports.

• Performed account reconciliation utilizing PeopleSoft and Excel.

Online Resources Corporation, McLean, VA July 1999 to September 2004

Facilitates financial interactions between millions of consumers and the company’s financial institution and biller clients.

Financial Control Analyst and Inquiry Resolution Specialist

• Balanced, reconciled, and posted bill pay accounts daily.

• Prepared and maintained monthly collection analysis, earnings and operational expenditure reports.

• Queried data in Access, for the purpose of totaling Remittance Processing Service files and identifying encoding errors.

• Reconciled Inner Bank Transfer accounts for rejected items.

ACHIEVEMENTS:

• Served as Treasurer for 7th Regiment Drum & Bugle Corps (2007)

• Member of Men’s Basketball team at the University of Maryland - Baltimore County (1989 – 1993)

• Baltimore City Youth Outreach Program in 1991

Contact this candidate