Financial Analyst Sales

Irene Francesca Castillo

*********.***@*****.*** - 202-***-**** - http://www.linkedin.com/in/icastillomultilingual5mba

Multilingual MBA - Excellent Global Analytical skills - Finance, Operations, Audit, Process Improvements skills

Client focused communication and management skills. Able to convey complexity in simple terms. Lean, Agile, ITIL, Cloud.

Highlight of Qualifications

US Treasury Community Dev. Fin. Institutions Fund - Certified Financial Analyst/Compliance Reviewer - Mkt. Cap. $500K - $100M.

US Treasury, Bureau of Fiscal Svc. - Reviewer/Auditor regulatory compliance for P&C insurance – Mkt. Cap. +$76 billion.

Performed due diligence for capital and regulatory constraints of PEs applicants’ portfolio to qualify for SBA, SBIC loans - Cap. $19.5M.

Managed Middle and Back offices’ of Wealth Management family business for transactions of $5K to $50K for US and LatAm.

Financial program management and operations of multimillion-dollar macroeconomic training in the US, Africa and Latin America.

Successful business and data analytics/modeling of 5 legacy systems into 3 saving 14 weekly labor hours or approx. $24K yearly.

Underwriting, background checks, credit risk assessment for simple and complex financial transactions.

IMF Sovereign Loan Surveillance: National Accounts for Quantitative performance criteria (QPCs) and Structural benchmarks.

Broad experience in: financial analysis, trade finance, structured finance, venture capital, private equity, microfinance.

ITIL v3, Agile SCRUM, Lean 6 Sigma, Green Belt, Data Analytics, Design Thinking. Big Data, SQL and Python training in progress.

Experience and Qualifications

Castillo Global Consulting - Senior Finance Consultant 12/18-Present

Provide financial consulting services in the areas of financial analysis, operations, payment quality assurance, internal audit, underwriting, credit risk, due diligence, regulatory compliance, FP&A. Improve process efficiencies using Agile SCRUM and Lean 6 Sigma. Multilingual contract management - Business Plans - Communication, social media - Financial projections - Financial analytics, interactive forecasting using Tableau. Robust Global research skills - Business and Data quantitative and qualitative analytics. Data visualization and Dashboards. Knowledge of GAAP, Statutory and Non-profit accounting. Excellent communicator and speaker. Team coordination. Knowledge of Microsoft Suite including Visio, Primavera, Pentana, Kiteworks, Tableau, SharePoint, Okta, and other BI Tools.

The Universal Service Administrative Co. (USAC), an independent, not-for profit corporation under the Federal Trade Commission (FCC) - Internal Auditor – Audit and Payment Assurance 6/2019-9/2019 – 1/20/-3/2020

Served as internal auditor providing support for their E-rate, Rural Health and High Cost programs. Perform quality assurance assessment procedures to determine payments with applicable FCC’s rules and guideline. valuate audit findings, implement corrective actions and monitor risk management activities in accordance with prescribed rules and compliance of the FCC.

Verify Audit and process review compliance in documentation with Rules and Regulations for Title 47 of the Code of Federal Regulations (CFR).

Verify testing results of geospatial location of the program beneficiaries and telecom providers for payment assurance.and audit notification preparation by verifying account balances and providing supporting documentation.

PotomacWave Consulting 9/2017-3/2018

Consultant: US Treasury, the Bureau of Fiscal Service, Surety Bonds

Sr. Financial Analyst/Auditor Regulatory Compliance: US Treasury, the Bureau of Fiscal Serv.

Performed Statutory Accounting audits of ins. companies’ financial statements with a capitalization in excess of $76 billion.

Conducted compliance reviews of ins. companies applying for certification for the US Treasury Surety Bonds’ program.

Monitored yearly and quarterly financial statements and appropriate schedules for matters.

Performed multilevel ratio analysis including solvency, liquidity, profitability, combined, loss, expense, operations and reserves.

Conducted trend analysis from historical and relevant data to evaluate credit risk, risk based capital and financial soundness.

Evaluated extraordinary event in the company’s business, e.g., M&A and any matter that may affect compliance.

Verizon - Senior Analyst Global Enterprise Sales Operations 1/2016-3/2017

Provided support to Global Sales Operations. Ensured effective analysis of sales and revenue trends and performance.

Analyzed revenue data to assist Finance and Product organizations with revenue forecasting and management.

Developed and implement process for global pre-sales account order credit on a monthly basis.

Worked on revenue assurance related to trend reporting, backlog identification and process operations’ improvement.

Worked in Deal Lifecycle Management for product improvements in global Hack-a-Thons.

Verizon - Senior Analyst - Financial Planning and Analysis (FP&A) 3/2014-1/2016

Auditor of complex $2M - $30M cloud Global Sales contracts for legal compliance and commissions’ payments.

Collaborated with VZ Lean Six Sigma Team in streamlining a multi-system reporting flow into two system, saving $24K yearly.

Participated in the end of the month closings of complex multi-million-dollar contracts for Verizon’s cloud products.

SME contract management for multilingual, multi-year complex contract in English, Portuguese and Spanish for compliance with the Statement of Work. Provided VZ ComOps with order analysis for sales reps’ commission payments.

Provided Forex Exchange Operations’ for multi-currency contract transactions to Commissions Operations.

International Consultant, Castillo Global Consulting 8/2009-3/2014

Worked as a Certified CDFI Financial Analyst/Reviewer to audit US Community Development Financial Institutions.

Performed qualitative and quantitative analysis for CDFI Certification review of financial institutions from $500K – $100M.

Performed ratio analysis using the US Treasury Financial Ratio Minimum Prudent Standards (MPS): asset ratio, current ratio, self-sufficiency ratio, operating liquidity ratio, net income ratio analysis to verify the financing entity’s financial sustainability.

Reviewed loan growth, deposit growth, loan deposit ratio, credit quality. Responsible for Middle and Back offices’ operations.

Managed Middle and Back Offices of a wealth management specializing in factoring to Latin America and the United States.

Managed the middle and back offices’ transactions, credit risk analysis, contracts, funding compliance and loan disbursement.

Performed due diligence on suppliers’ products quality and past performance delivery of products. Product sourcing.

Creation of ad hoc procedures for special loans

Performed weekly and monthly reconciliation of all financial transactions ranging from $5K to $50K.

Created an operations’ Trading Manual including all due diligence, risk and background analysis.

SBA, SBIC Debenture Program, Investment Division - Private Equity Intern 2/2012-5/2012

Worked in the pre-approval process of the SBCI Investment Fund.

Performed due diligence, quantitative and qualitative, on the Private Equity (PE) applicants’ multi-million funds - $19.5 val.

The due diligence included but it was not limited to the company’s Fund(s) financial performance, management team, length of the team working together, investment fund(s) focus and exist strategy.

Performed weekly quantitative and qualitative analysis of PEs’ management track record, term sheets, deal summaries, exit strategies, calculation of various metrics required by the SBIC including ratio analysis for realized as well as unrealized funds.

Participated in the weekly PEs’ presentations to the Investment Committee and the Investment Committee’s selection Mtgs.

Provided feedback on the fund(s) interview assessment and MAQ to the Senior Investment Officer.

Created a PE Training Manual for SBIC interns covering the requirements to perform due diligence and vetting the PE Teams.

Training Administrator, International Monetary Fund (IMF), IMF Institute for Capacity Development (ICD) 3/1995-8/2009

Participated in multi-million dollar loans’ surveillance and covenant compliance for sovereign national accounts.

Covered operations and logistics mission work between foreign officials, IMF mission staff and the IMF back office.

Managed successful relationships with 189 member countries’ technical assistance programs. SME macroeconomic training.

Conducted multilingual briefings to high government officials related to budget, policy and reimbursement compliance.

Contributed to training analysis metrics to develop best business practices and processes to reduce expenses by 20%.

Managed multi-million dollar program of six annual macroeconomic training in the U.S. and overseas.

Conducted yearly country review and analysis of 600 government officials to vet and qualify for participation in ICD training.

Organized monthly meetings, presentations and facilitation of economic dialogue between foreign officials and the IMF staff.

Developed a knowledge management depository for PeopleSoft and Excel to accelerate the training of new IDC staff.

Education

Master of Business Administration (MBA), Johns Hopkins University, Carey Business School

Focused in finance and HR. Capstone: M&A, GPA: 3.7

Master Certificate, Business Analysis, Villanova University

Bachelor of Arts (BA), focus: International Affairs, American University

Diploma - French Language and Civilization, La Sorbonne University, France

Portuguese Language and Culture Certificate, IDIOMA Language School, Salvador, Brazil

IT – Data Analytics

SQL and Python training in progress. Tableau and data analytics. AWS and Amazon’s ecosystem. Sales Performance and Analysis, SalesForce, Excel, PowerPoint, Contract Management, other Verizon analytical proprietary tools. Design and Strategic Thinking. Sales, Planning & Analysis (SPA). Hyperion Essbase OLAP cubes BI tools.

Technical and Professional Development

Immersive Data Analytics (175 hours of class work) – 2019 - ITIL Certification - 2016 - Agile Scrum - Verizon Agile Program – 2016 - Verizon Lean Six Sigma - Green Belt – 2015 - Certification – US Treasury Community Development Finance Institution Fund - 2013

Language skills, fluent in: French, English and Spanish. Working proficiency: Italian and Portuguese

Contact this candidate