Lead Financial Reporting Systems implementation for consolidation purposes, Create Budgeting and Forecasting Modeling, BOD package, Consolidation and Reporting of Financial Statements, KPI analysis. Revenue analysis and reporting.

Managed and coordinated Scorecard implementation project for upper management (Management Reporting) with extraction, transfer and validation of data from Hyperion to SQL to Tableau and ensure quality of figures and KPIs for Canada and USA customers. Gathered requirements and serve as a Liaison between IT and Finance end users. Perform validation and adjustments for month end close to ensure all reporting systems are in sync.

Responsible for managing and coordinating all corporate reports presented to upper management and parent company.• Create and maintain consolidated corporate budget package for parent company in SmartView.• Responsible for creating monthly forecast process, forecast model and consolidated forecast package including variance analysis using Hyperion. • Create financial models and responsible for Ad Hoc and corporate moth end reports using Essbase, SmartView, Financial Reporting Studio and Lawson. Support various levels of management and operations.• Serve as a subject matter expert in Hyperion system and give guidance to Corporate and Operational Finance in how to extract data from the system for quick analysis. Help users with any system related issue.• Create the corporate Intercompany allocation methodology in the system for Budgeting and Forecast purposes. Creating/editing logic for business scripts and work close with system developers and system end users to implement the scripts. Training and coordinate with accounting the proper booking of Intercompany entries according to the budget. Support Accounting during month end close. Prepare ISOs Variance analysis for Operational Finance. Prepare analysis related with Billing Cost per case using billing system attributes from the system. Support RCM with various costs analysis reports.

Supports Hyperion Implementation related with Budgeting process and perform UAT (BSO and ASO). Create financial models for budgeting and reporting purposes using Essbase and Lawson.Create, maintain and approve changes in the structure and mapping for the Geographic Account Units Hierarchy and the GL accounts hierarchy in BSO cube: • Understand geographical Account Unit reporting structure and GL structure. • Maintain integrity of hierarchies according to standards issued and business requirements. • Coordinate/maintain alignment between BSO and ASO cube. • Map and re-map Account Units, GL accounts and attributes to new or revised standards, as necessary. • Manage and resolve open items related to hierarchy with Business partners and Technical teams. Partner with IT to build automated solutions in reporting for Finance Team. • Collaborate end users in troubleshooting Hyperion Planning related issues and coordinate with IT for resolution.Responsible for Financial and Management Reporting: • Full understanding of Hierarchies and Reporting Structure including dimensions, attributes and metadata mapping to ensure transparency of data across different areas. • Identify potential problems, if any, in case of changes in structure in team work with the IT Hyperion Administrator and accounting. • Oversee various Financial Reporting projects for Management Reporting in FR as needed and support the reporting and analysis needs of various level of management and operations. • Running ad hoc reports for upper management in a timely manner and analyze large volumes of data in Essbase. • Coordinate with IT the upload of data in the various systems (Lawson, BSO) and reconcile the data.Train all Finance personnel in the current hierarchy structure and reporting to make their work more efficient.

Supported Hyperion Implementation related with Budgeting process and performed UAT. Created financial models for budgeting and reporting purposes using Essbase and Lawson. Acted as a Hyperion Administrator. Supported the reporting and analysis needs of various levels of management and operations and provides training on related systems, reporting, tools and policies. Ad hoc data manipulation, querying, analysis and modeling to support business needs.

Developed internal reports/dashboards for Customer for Life Initiative project. Extracting data from different systems and creating meaningful metrics and dashboards for decision making process.

Supported implementation of Business Objects Reporting System in LATAM Markets by validating accuracy of data in the countries. Implementation of Tier 1 and Tier 2 reports following guidelines of reporting systems in United Kingdom.

Created and streamlined tasks to support flow of monthly and quarterly consolidated financial information and reports across four companies. Continuously improved modeling, planning and analysis, minimizing errors and reduced delivery timelines by automating processes. •Increased transparency of budgeting process through creation of new various analytical models: cash flow, balance sheet and P&L variance analysis. Coordinated annual budget process.•Reduced turnaround time on ad hoc reporting from three days to 30 mins by extracting data from ERP system and designing database relationships using Crystal, MS Queries (SQL), and synthesizing data using vlookups and pivot tables.•Reduced Daily Sales Report process from four hours to 15 mins by automation of Crystal Report.•Reduced average DSO by designing and introducing DSO process and related cash flow and AR analysis. Supervised activities and performance of collection personnel.•Improved decision-making process for upper management through creating and automating Matrix Report that showed Gross Margin by product category and customer type.•Increased efficiency of targeted Marketing and media efforts by creating critical telemarketing/media models and sales projection data for direct response campaigns in collaboration with Marketing and Sales VPs.•Created and coordinated Board Meeting PowerPoint presentations.•Worked in liaison with accounting and IT department.

Developed Balance Sheet budgets/forecasts for all US entities including creating and maintaining excel based planning models, utilizing Hyperion budgeting software, developing planning assumptions, and interfacing with accounting, tax, FP&A, risk management and other departments•Created and maintained model that reconciles local p&l vs. CREST p&l by mapping and merging several databases. •Responsible for submission of Balance Sheet in CREST. Acted as a CREST super user. •Prepared Monthly Cash Flow for the overall company. Prepared and designed PowerPoint USMB (US Member Board) global presentation for balance sheet and cash flow.•Prepared P&L monthly variance analysis and corporate presentations for USMB. •Prepared weekly scorecard. Presented weekly variance of PFTE productivity report for all areas and created models to integrate data from multiple timekeeping databases. Streamlined process from two days to four hours.•Developed, maintained, and automated flash reports for management during month end close and provided prospective financial information and analysis of data. Prepared accruals for month-end close.•Prepared fuel forecast for annual budgeting purposes. Supported Fleet team for actual and forecast purposes.

•Built financial model for company-wide cash flow forecast. •Reengineered and automated financial reporting methodology for daily cash position.•Supported project that improved vendor terms which optimized Balance Sheet ratios.•Took initiative to analyze and forecast cash clearing and performed statistical analysis of financial databases.•Prepared financial reports to CFO using Hyperion Essbase. Forecasted Balance Sheet and uploaded into Hyperion. Maintained relationships with banks in Mexico and USA.

Managed, prepared and coordinated annual company budget - all Financial Statements. Prepared variance, and supervised development of all reports associated with budgeting. Responsible for performance, evaluation, and professional development of two interns.Financial Professional I•Earned promotion to the above position due to proven work history and enhanced skills.•Supported CFO on Board Meeting and Budget processes.•Prepared, analyzed, and updated US and Colombian GAAP 20-year financial forecast model for strategic planning. Assisted in implementation and analysis of Economic Value Added (EVA) financial measurement and prepared company stock valuation using CAPM (Capital Asset Pricing Model).•Led team that implemented SAP Budget Module. Trained 50 employees on SAP software related to budget entry data and budget control.•Prepared and coordinated monthly Board of Directors Meeting. Supervised interns in development of Board of Director reports, Financial Statements, prepared monthly variance, and developed monthly corporate PowerPoint presentations for company executives. •Prepared weekly status reports including transported volumes, revenues, and net income for US stockholders.•Performed monthly cost analysis, variance reports and evaluated financial projects.•Assisted with financial tariff calculation model (pricing) and Annual Report of Company Investments Portfolio.•Supported CEO by preparing Promigas Annual Report to shareholders.Treasury AnalystAssisted Treasury Director with overall Cash Management and forecasted Cash Flow for company. Studied investment opportunities for use of available cash.Managed daily loans in national and foreign currencies and negotiated letters of credit. Negotiated buying and selling of foreign currencies to pay foreign loans.