Francis Castillo, Mba Email & Phone Number

Washington, Dc, Us

Washington, Dc, Us

Washington, United States

Bethesda, Md

• Provided analysis and reports of annual and quarterly property financial statements and rent rolls to Capital Markets lenders. • Developed insightful variance analysis and data visualization for financial performance to proactively mitigate the portfolio risk. • Obtained updates from borrowers related to variances in property, operating performance, tenant rollover, and new lease terms. • Supported the development of co-financing partner relations. • Undertaked ad-hoc assignments at the discretion of the Manager. • Updated and complete data entry in the portfolio database on Enterprise! Salesforce and Share point.

Washington D.C. Metro Area

As a finance intern reporting to the Financial Operations Division, I served by reviewing the accuracy of the bank reconciliations presented by the 34 National Offices in their local currencies, and after doing its exchange rate conversions, I prepared the bank reconciliations at Headquarters in US dollars.•Processed Reconciliations of General Ledger accounts with Subsidiary Ledgers at the end of every month.•Managed the reconciliation accounts related to Specific Fund projects of 30 countries in 21 different currencies. •Updated procedures manuals for incoming interns training. •Assisted in the preparation of the bank and investment Reconciliations for Headquarters and the National Offices.•Provided assistance in the Account Payables and Receivables analysis using macros and Oracle Financial System.

Remote

•Prepared and certified financial reports, including reviewing the general compliance of the financial data applying adjustments. •Reviewed and analyzed financial statement accounts for accuracy, budget variance, and unusual trends.•Prepared monthly, quarterly and ad-hoc reports of Specific Clients and Services.•Promoted the integrity of the financial agreements and contracts signed by the company by reviewing their clauses. •Supported the preparation of charts and financial information compilations as requested by senior management •Led an investment plan of $30K (Local currency) in new equipment and staff training which improved manufacturing workflows and operative efficiencies.•Financial analysis for procurement purposes.

Bogotá D.C., Colombia

• Coordinated the payments to suppliers, payroll, and insurance for 35 employees in compliance with the Colombian law. • Prepared revenue/expense analysis and reports to support business decisions and strategic planning. • Implemented an expansion strategy in the Colombian market. Successfully positioned company products in 4 new cities and 15 new stores within 3 months. • Analyzed, reviewed, and tracked the financial performance of market share and industry competitors.

Bogotá D.C., Colombia

•Successfully completed the migration of company data to SAP which reduced manual data management by 70%. •Monitored customer database of ThyssenKrupp, Otis and Mitsubishi Electric; and their market indicators (Sales volumes, consumption trends and fill rates). •Increased consolidated business by 5% after adjusting the cost price of past economic proposals. •Created contracts for services, consultants and contractors.•Identified and promoted the company's services to new leads following up with emails, calls, and others proactively and responding promptly to complaints and concerns.•Prepared commercial interim and final reports, providing information on the goals, and indicators achieved in the projects of the company.

Bogotá D.C., Colombia

•Analyzed in Excel over 100 bids and prepared a report which showed that 65% of the hiring were public sector, generating 35% increase in profitability, and a reduction of risk in return on investments. •Supported the design and development of the budget for bids, according to the company’s procedures. •Reviewed and analyzed the fulfillment of the technical and economic capacity of the company, preparing and submitting periodic reports to the Planning and Financial Department, utilizing Microsoft Office Suite.

International Master In Bussines Administration, Finance, Finance, General

Certification, English As A Second Language Program

Bachelor'S Degree, Professional In Finance And International Trade

Certified Diploma, Professional Development Of Management Skills

Case Study (On-Site and Virtual) Knowledge management Strategic thinking Strategic Planning sales management New physical and digital.