Angel Lewis
San Antonio, TX ***** nPhone: 210-***-**** nEmail: ***.*****.*******@*****.***
Career Goal: Data Analyst / Staff Financial Analyst Dedicated Staff Financial Analyst with experience developing and implementing financial systems, strategies, and processes that significantly improve company performance and profit. Experience performing daily accounting functions, developing systems and perfecting practices. Computer skills include proficiency in Access, Excel, PowerPoint, Outlook and MS Office.
Education
AMERICAN INTERCONTINENTAL UNIVERSITY HOFFMAN ESTATES, IL Bachelor of Business Administration, 11/2008 (concentrated in Accounting/Finance) Experience
EMBREY DEVELOPMENT COMPANY SAN ANTONIO, TX
Accounting Administrative Assistant, 01/2015-Present Provides administrative support to the Accounting Vice President, Controller and HR department. Utilizing my advanced Excel and Access expertise simplified the analytics of projects in development, as well as, aided in companies IT conversion and upgrade.
Key resul ts:
Open new bank accounts for new development projects, and administrate access to bank websites
Complete and issue vendor 1099s, as well as, file all company 1099s and 1096s for annual tax filing with the IRS.
Complete new vendor assignments in both Yardi and Timberline.
Administrate the corporate credit card program, ensuring proper credit limits are assigned according to the employees position and duties.
Assist the Accounting VP with closings and sales, periodic reports, bank draws, and corporate filings with government agencies.
DEACON RECRUITING-REAL ESTATE DEVELOPMENT CLIENT (TEMP) SAN ANTONIO, TX Accounts Payable Clerk, 10/2014
Performed accounts payable functions. Ensured vendors and tenants were paid in a timely manner and tracked and documented all payments to prevent double and/or over payment. Key resul ts:
Analyzed and inputted invoices into the Yardi Database for all accounts payable transactions. Reviewed vendor invoices submitted for payment to ensure proper amounts paid and prevent over disbursement of funds. Performed check batch runs.
FIRST NATIONAL BANKTEXAS KILLEEN, TX
Staff Financial Analyst, 12/2009 to 08/2011
Promoted laterally from Reporting & Production to Analysis within three months of hire. Responsibilities developed from developing weekly and monthly financial reports to financial database management. Constructed financial databases for the purpose of enabling the production of new financial reports on a monthly basis. Key resul ts:
Reviewed contracts to ensure financial payouts adhered to contractual agreements. Meticulously evaluated contracts upon facility renewal to project expected continued profit or potential loss to enable a firm decision on lease renewals. As well, reconciled collection accounts with contracted agencies to guarantee proper payment to contractors. Reconciled the general ledger for accounts receivable and accounts payable.
Imported, analyzed and reviewed the daily general ledger statistical and financial data for daily operation. Worked closely with accounting to detect and rectify all financial inconsistencies. Utilizing accounting policies and procedures, constructed and maintained financial databases via Access for company financial data and specific projected/estimated budget modifications. Created various reports for projected annual income/loss for any potential budget adjustments.
Analyzed and compiled all financial reports to include income statements, balance sheets, and all reports presenting
Complete bank reconciliations for all corporate bank accounts. profit/loss. Evaluated financial reports ensuring accuracy and identified any irregularities or discrepancies prior to submission for the monthly board meeting.
Projected potential income via data compiled from constructed databases to produce reports demonstrating potential profit/loss for all suggested company expansion and/or reductions. Compared projected financial data to that of prior years to establish a sound fiscal projection and provide a more accurate basis for the annual budget. HAMPTON UNIVERSITY HAMPTON, VA
Project Coordinator, 5/2009 to 9/2009
Managed and coordinated 2-5 grants processed through the governmental relations department weekly ranging from
$100,000 to in excess of $1 million. This included establishing an ongoing schedule to monitor progress in the writing process resulting in the final submission of government grant proposals. Key resul ts:
Coordinating the grant writing process required an in-depth knowledge of the SF424 guidelines to ensure proper assembly of grant proposals and relaying these requirements to all principal investigators and contributing department heads/school deans.
Researched and compiled information to ensure proper and timely completion of grant proposals. Compiled information researched and gained through the InfoEd system into weekly grant opportunity reports distributed via electronicmail (e-mail) campus-wide. Corresponded with faculty and staff to address any additional inquiries, changes, and deadlines of the information contained in weekly reports. Provided technical and administrative assistance to faculty/staff on efficient use of InfoEd, the grants research database.
Organized, scheduled and attended tele- and videoconferences with partnering institutions and corporations on various grant projects. Served as the point-of-contact for disseminating information between all partners and corresponded frequently with key individuals, to include various senators, governors, and other government officials. Developed and assisted in initiating new partnerships and developing a working relationship with external corporations and other educational institutions. Coordinated meetings to discuss contractual partnership agreements with key personnel between the university and potential contractors/partners. Received, prioritize, and coordinated initial partnership proposals from external companies. Managed the correspondence and documentation during the negotiation process until a final contract was agreed upon.
Reviewed and verified proposal budgets throughout the grant writing process to ensure requested funds fell within set guidelines. Examined project budgets for funds allocated to salaries, indirect costs, and other expenditures to confirm proper percentages were applied. Maintained files of requested and awarded grant funds and ensured receipt of payments, to include payments through theWide Area Work Flow (WAWF) system totaling $7.5 million. DRUCKER & FALK, LLC NEWPORT NEWS, VA
Accounting Clerk, 1/2008 to 4/2008
Performed accounts payable functions. Ensured vendors and tenants were paid in a timely manner and tracked and documented all payments to prevent double and/or over payment. Key resul ts:
Analyzed and inputted invoices into the Yardi database for all accounts payable transactions. Reviewed vendor invoices submitted for payment to ensure proper amounts and prevent over disbursement of funds. Performed check batch runs and prepared daily spreadsheet reports utilizing MS Excel of each check run performed. Maintained spreadsheets of all checks to verify payment, prevent lost checks, and monitor unclaimed funds.
Prepared written reports and correspondence of distributed checks for internal tracking of vendor payment status. Submitted daily reports, to include trial balance, to Comptroller enabling proper review of account balances to release funds. Followed policy and procedures to manage distribution of funds. Submitted checks greater than $800,000 requiring approval and signature to Chief Financial Officer (CFO) prior to distribution. Corresponded with property managers regarded inquiries of vendor payments via telephone and electronicmail (e-mail).
Reviewed and recorded discrepancies on the general ledger. Annotated imbalances and contacted the financial institution to rectify accounting differences. Forecasted upcoming insurance premium and real estate tax payments from amortization schedules. Prepared payments to be mailed and performed wire transfers to guarantee timely receipt of payment.