jorge penso

Highly motivated and results oriented finance and BI professional, Bi-Lingual, possessing exceptional communication and cross-cultural skills with thorough experience in Accounting, FP&A and Strategic Planning & Analysis and Business Intelligence experience, reporting to highly visible positions within the senior management. Significant experience in the USA and LATAM backed by a bachelor’s degree in business administration, major in management, advanced studies in finance and substantial BI tools, financial systems knowledge, and Project management. 

Skilled in Power, Power Pivot, Business Intelligence, Reporting Platforms, Data Modeling, KPI, Project Management, Requirements Gathering and Business Analysis  A quick learner with strong work ethic. Consistently meets all deadlines and exceed expectation. Always interested in new Challenges.

Highly motivated and results oriented finance and BI professional, Bi-Lingual, possessing exceptional communication and cross-cultural skills with thorough experience in Accounting, FP&A and Strategic Planning & Analysis and Business Intelligence experience, reporting to highly visible positions within the senior management. Significant experience in the USA and LATAM backed by a bachelor’s degree in business administration, major in management, advanced studies in finance and substantial BI tools, financial systems knowledge, and Project management. 

Skilled in Power, Power Pivot, Business Intelligence, Reporting Platforms, Data Modeling, KPI, Project Management, Requirements Gathering and Business Analysis  A quick learner with strong work ethic. Consistently meets all deadlines and exceed expectation. Always interested in new Challenges.

Power BI Consultant

• Experience in Microsoft Power BI Suite (Power Query, Power Pivot, Power BI Pro, Power BI Premium, Power BI Desktop), Microsoft Excel Pivot Table, and Data Models to gather information from multiple sources and deliver information to the end user.
• Excellent DAX Skills and the ability to create and troubleshoot complex calculations and measures. 
• Experience creating custom visualizations.
• Ability to communicate with Supervisors, Executives, BA’s, DBA’s, Developers.
• Create company PBI Template with company colors.
• Work with different sources like Excel, OData feed, Azure, SSAS.
• Introduction and train other developers in Power BI Desktop and Power BI Services.
• Create Role Level Security

Capgemini – Ft. Lauderdale FL                                                                                                                                                                               2019  - 2022

Finance Transformation Manager

Part of the Business Services division of Capgemini, a Digital Transformation and Digital Manufacturing practice, my main competencies are Record to Account and Financial Planning and Analysis, specializing in designing and implementing business intelligence transformation solutions for a variety of clients across industries. Lead architect and delivery manager for multiple projects aimed at automating and optimizing the clients reporting and analytics capabilities through a variety of platforms. 

Es Solo Holdings – Miami FL                                                                                                                                                                                   2018  - 2019

Financial Planning and Business Intelligence Analytics Manager

Lead management and development of the Power BI system of Es Solo Holdings, a fully-integrated fintech infrastructure platform specialized in the prepaid cards segment. A hands-on position which entails the design and development, management and administration of all operational and profitability metrics reporting through multiple databases and application software interfaces (API’s) enabling a fully dynamic and visual solution to senior management and clients.

• Power BI implementation project manager
• Lead developer for all reports and metrics in Power BI; DAX coding and dashboards
• Lead Visualization projects; requirements gathering - implementation
• Power BI Super user and Admin functions
• ETL admin and maintenance; Microsoft SQL Server Integration Services. Integration to JD Edwards, Cognos BI and Salesforce
• Data validation and mapping
• Lead Power BI integration efforts into a variety of providers platforms 
• Preparation of financial and operational KPI performance analysis & commentary to support the monthly reporting, pipeline tracking, flash performance reports & CEO’s presentations

ACAMS – Adtalem Group – Miami FL                                                                                                                                                                    2017  - 2018

Sr. Finance Manager- Financial Planning and Analysis and BI – Senior finance manager

Responsible for managing all planning, forecasting and reporting processes for the Association of Certified Anti-Money Laundering Specialists (ACAMS) a division of Adtalem Global Education group (formerly DeVry). This includes oversight of planning software/applications, leading all budgets/forecasts and preparing analyses for new business opportunities and efficiency initiatives. Lead the strategic and long-term planning process with global oversight and emphasis on the development of metrics to enhance accuracy and impact. In charge of the FP&A regional functions for the Americas, APAC and Europe, developing processes to ensure a proper finance support to our expanding global footprint.

• Compile senior management presentations summarizing growth assumptions, profitability projections and department initiatives ensuring clear communication of business strategy and KPIs
• Produce period-end reporting packages for corporate finance and accounting teams including actuals vs budget/forecast walks and departmental expense analyses
• Create dynamic P&L and cash flow models to support annual budget and long-range plan creating high
• Prepare, review and communicate financial budgets and forecasts. Included in this process is updating the 5-year strategic plan on a consistent basis. 
• Prepare financial analysis of business unit strategic capital initiatives, including business cases, calculating and presenting return analysis for capital requests. 
• Provide financial guidance to the business unit department leaders and ensure their adherence to the budget and operational guidelines. 
• Assists in the preparation of financial and operational KPI performance analysis & commentary to support the monthly board report, flash performance reports & CFO and boards monthly presentations
• Lead developer for all metrics in Power BI
• Coordinate and provide finance support for all Investor Relations activities regarding all public communications, press releases and regulatory documentation

Finance Consultant–Miami FL                                                                                                                                                                               2015  - 2017

Providing financial management consulting services with broad expertise in the corporate finance, FP&A and reporting areas. Clients ranged in size from $50M-$4B+ in annual revenues for private and listed companies. 

• North American Transport Service (12 months): Interim Finance and Accounting Controller (backfill)
• Cardinal Health - Johnson and Johnson (6 months): Budgeting manager, directing efforts for a company under disposal
• Harris Corporation (6 months): Purchase accounting technical analyst, part of M&A team (Exelis-Harris M&A) due diligence and audit efforts

Cable & Wireless Communications PLC–Miami FL                                                                                                                                           2014  - 2015

Corporate Finance Division –Financial Planning and Analysis – LATAM - Director

Lead the monthly reporting processes of a publicly listed company in UK, a major telecoms operator in the Caribbean and Latin America with presence in 15 countries, providing insightful analysis to the Board, EXCO & senior management by detailed understanding & insight into a portfolio of business units, contributing to the achievement of financial performance targets through high quality analysis & commercial support. Responsible for the Group’s capex & investment appraisal processes, working with the regions to ensure business cases are well grounded & evaluating the commercial & financial impacts including the economic profit delivered. Own the annual strategic planning & budgeting cycle for the Group, ensuring cohesion with the central Commercial & Technical functions, preparing & communicating targets & ensuring that business plans are robust & focused on achieving at the Group’s strategic imperatives.

• Assists in the preparation of financial and operational KPI performance analysis & commentary to support the monthly board report, flash performance reports & CFO's monthly presentation to the executive committee and board
• Coordinate and provide finance support for all Investor Relations activities and specially regarding all public communications, press releases and regulatory documentation (UK Financial Services Authority)
• Lead the Capex allocation process in close partnership with the Commercial and Technology divisions.
• Project lead of the Miami Corporate Centre Finance integration effort; in charge of design and execution of accounting and reporting processes 
• Responsible of Miami Corporate Centre financial controllership functions
• M&A team finance member; developed financial models in order to support a major acquisition. Development of sensitivities analysis, synergies models and valuation scenarios. Demerger and disposal financial due diligence in disposal of one of the company’s Europe business unit; covenant stress testing and financial model development

Pearson PLC–Old Tappan NJ                                                                                                                                                                                   2009  - 2013

Global Procurement Division – Senior financial analyst -Business intelligence Strategic Reporting & Analysis – Senior finance analyst                  

In charge of the financial analysis, planning and reporting process for the Global Procurement division, in a company with presence in over 80 countries, working across functional and geographic boundaries in order to maximize the company’s leveraging and purchasing power. With an increasing emphasis on the process and data enhancement, I have added significant value by leading in a variety of projects, encompassing systems design and implementations as well as the standardization of global risk processes. 

• Provide financial support to the Global procurement division with emphasis is on the BI analytical and reporting aspect.
• In charge of the financial analysis planning and reporting process for the Global Procurement; Act as the liaison with the Finance group for the monthly, quarterly and year end reporting, via Essbase-Hyperion, Oracle financials and SAP business warehouse (Business Objects)
• Preparation of regular operational performance tracking and reporting metrics
• Lead developer for OBIEE reporting; preparation and maintenance of data integrity and preparation of dashboards
• Lead and management of Risk database, KPI dashboards, etc., Standardization of data
• Manage the Data analytics process, trough strong knowledge of data warehousing concepts, technologies and best practices including logical data modeling and physical database design (Business Objects, Cognos, Hyperion)
• In charge of the Strategic Financial Risk evaluation process.

Merrill Lynch  – New York NY                                                                                                                                                                               2007  - 2009

Corporate Finance Division, Financial Planning and Analysis AVP

Oversee the capital and IT appropriation process, its governance and the financial reporting process around it. Managing of corporate policies and procedures, governing the firm's engagement into long-term financial capital commitments and projects. The role expanded to manage the firm-wide Balance Sheet forecasting and consolidation, modeling and forecasting process as well as the Support FP&A/Expense Management reporting.

• Preparation and consolidation of annual Capex budgets and strategic plans, analysis of actual vs. budget performance for all operations and corporate IT divisions.
• Coordinate and perform review of POA’s (project opportunity assessments) for executive reviews and post-implementation reviews (PIR's) of projects. 
• Ongoing Management, Review and Guidance of the Business Case Process for all capital and commitment intensive projects. 
• In charge of monthly, annual and strategic Capex budgeting (1.9 billion/year) and forecasting process, all the way to project level (over 2.5MM and above; 250 projects at any time)
• Cyclical Reporting on Capital Spending & Projects progress to the Management board
• Firm-wide Balance Sheet forecasting and consolidation process as well as the Support FP&A/Expense Management reporting (Hyperion, Clarity, Oracle)

DHL EXPRESS – FT. Lauderdale FL                                                                                                                                                                       2003  -2007

Financial Planning & Analysis Division, Capital Planning and special Projects – Finance Manager                                                                   2005 – 2007

Manage the development, review and administration of the Company's Investment Controlling processes, budgets, financial plans and forecasts.  Perform financial reviews, analysis, and reporting of all capital commitment activities and project proposals. Ongoing management, review and guidance of the investment process with high emphasis on project controlling.

• Oversee the capital appropriation process, its governance and the financial reporting process, including IT spend and FTE’s
• Project and Business case preparation and evaluation (Net Present value, discounted cash flow, internal rate of return, pay backs, etc.)
• Coordinate project monitoring and due diligence efforts, which includes the evaluation of project’s strategies and financials and facilitating additional technical reviews.
• Coordinate and perform review of POA’s (project opportunity assessments) for executive reviews. 
• Perform as liaison with all the functional Project Controllers, on project reporting, including benefits and costs, reviews. 
• Project reporting to Global management board, and all other activities required from the functional Project controllers and the US management board. 

Financial Planning & Analysis Division - Financial Reporting – Finance Analyst                                                                                                  2003 –2005

Coordinating and performing the financial reporting activities for Danzas Air and Ocean US, a Deutsche Post company, headquartered in Germany. Analysis and interpretation of financial statements as well as full acknowledgement of Deutsche Post internal reporting requirements in order to comply with GAAP and the specific management needs of the logistics business. High interaction with key financial areas as accounting, treasury, taxes, controlling and operations in order to coordinate the closing schedule. Operating in JBA, an AS400 system as well as in SAP which demands a sophisticated knowledge of data base management.

• Lead the financial close and consolidation efforts; interface with Headquarters on actual/forecast results vs. plans. 
• Preparation of monthly reports for CFO. P&L & Balance Sheet consolidation, modeling and quantitative analysis
• Finance Support for planning, budgeting, cost control, and project control to provide informed recommendations to leadership across DHL

Baker Hughes - Venezuela 1998  - 2002                                                                                                                                                                                                                                                    

Financial Planning & Analysis Division - Finance Analyst

Controller for the finance division budget of an oil production and exploration service company in Caracas Venezuela, supplying Venezuela’s primary oil corporation. Position entailed overviewing Accounting adherence to GAAP Principles, authoring financial reports, elaboration of actual performance and variance analysis, financial reporting and consolidation of multiple operating divisions. Preparation of annual operating budgets and 5                                                                                                                                                                      -year strategic plans. 

Procter and Gamble, Latin America Headquarters - Venezuela                                                                                                                      1996 - 1998

LATAM Financial Planning & Analysis Division - Budget Controller, R&D Division

Manage the multi-million R&D budgets of a worldwide producer of consumer products for Latin America in the Caracas-Venezuela headquarters. Position included actual performance and variance analysis, conducting cost analyses, monitoring cash flow and profitability indicators, consolidating regional accounting and producing financial reports, preparation of budgets, forecasts and strategic plans.

Banco Mercantil de Venezuela - Venezuela                                                                                                                                         1993 - 1996

Corporate Banking Division, International institutional Group -  Credit Manager                                                                                                      

Promoted by the leading South American banking institution to manage credit portfolios of banks throughout South America, conducting financial analyses and advising the executive committee on lending operations. 

Education

Universidad Metropolitana, Venezuela – Licentiate in Business Administration, major-Finance Management (Master’s degree equivalent)      1986 –1992

languages

Fluent in Spanish and English, conversational in Dutch

Nationality

US Citizen, Venezuelan, Spanish