Mark Halpin Mba Email & Phone Number

Ireland

Eden Prairie, MN, US

New Brunswick, NJ, US

• Process improvements and automations projects undertaken to optimize business results and improve efficiencies for global Supply Chain - Finance.
• Complex financial modeling undertaken to redesign quarterly and annual forecasting for global intercompany transactions in the vision care Dept.
• Alteryx Technology used to help automate Inventory write off process across multiple products/regions/sourcing/plants/currencies/end affiliates.
• Tableau Dashboard enhancements enabled front end redesign for aesthetic improvements and seamless interactive features added to enable end user control for scalability.

Brussels, Brussels, BE

• Build and combine data tables using Alteryx and SQL to create real time dashboards from one database, worked with data engineers in order to clean up relational data tables in effort to build one source of truth.
• Key insights on monthly revenue accounts identified and outlined and presented to management, key metrics also communicated to Order to Cash Operations managers in the form of real time dashboards using Tableau.
• Partnered in the Strategic project finance transformation for the To-be requirements global operations reporting structures in providing recommendations; Lead investigations on current reporting structures and tools.
• Set up an inventory of current reporting structures to isolate key metrics that are common across global teams with a view to building the current As-is reporting library from one data source to ensure data reliability.

Brussels, Brussels, BE

• Manage the end to end Data Migration activity for Client to strict Project Deadlines.
• Pre go live Cleansing Activities in conjunction with technical and finance resources for UAT.
• Validation of all datasets, and perform full reconciliations on all Datasets to the legacy system requirements, including GL reconciliations, PO Receipts, AR and AP modules, Assets.
• Development of stock ledger reconciliation, enabling tracking of complete P+L after go live system migration, successful implementation gave surety to the business, that migrated data was correctly migrating as planned.
• Ability to work at pace, to create solutions in cross collaboration with internal and external teams, across multiple locations; namely with finance managers, AP managers, Project managers, Business Analysts, IT.

Basking Ridge, NJ, US

• Finance business partner to international regional commercial managers, examining commercial deals in light of future re-contracts, with particular focus on financial analysis.
• Financial modeling forecasts in relation to volume trends, seasonality, or known peak destinations to analyse cost impact(Tableau, advanced Excel).
• Project; Developed an information repository for roaming KPI’s, which acted as a tracker for the team, several data sources were extracted from disparate system sources, through use of excel vlookup ups/ Index matches.
• Dashboards developed for monthly representation of business area KPI’s/Analytics. (Tableau)key strenghts to the team; strong technical aptitude in developing sleek presentations, clear logical approach in improving.

Dublin, County Dublin, IE

• Work to tight month end deadlines in pressure environment for delivery of KPI’s (Customer Acquisition Costs), accruals calculations, inventory reports & Balance Sheet reconciliation’s.
• Identified revenue leakage for Online prepay customers and investigated for successful revenue gain.
• Key insights on monthly Prepay CAC accounts identified and outlined and presented to management, key insights also communicated to commercial partners in the form of bi-monthly decks. (experience with Oracle, SAP.
• Key Process improvements including streamlining of the commissions balance sheet for better audit and internal review, journals and Genpact processes also streamlined for more accurate and timely reporting.

Dublin, County Dublin, IE

Provide support on bid offers for business customers, creating offers that are competitive and attractive within company forecasted targets. Negotiating skills a must in creating solutions that is attractive to the customer, and adds value to the business.Finance Contact and relationship management of the PR budget and Channel marketing budget with.

Dublin, County Dublin, IE

• Produce monthly accounts on Costs of Sales ensuring strong financial controls are upheld according to forecast.
• Produce Weekly / Monthly reporting packs on individual channel performance.
• Responsible for Calculating Prepay CAC (Customer acquisition Costs) Report on Sales and Marketing finance. Liase in commercial finance with external third partys.
• Responsible for setting Prepay Targets for third party commercials, analysing return on investment for the company, including presenting trends from data analytics.Transformation SAP to Oracle project; I Lead in.

New York, NY, US

• Financial analysis of trading markets in London, reporting on headcount, technology and management accounting.
• Month End: Produce reports, analysis and reconciliation’s, Flash reports, Balance Sheet Analysis.
• Advanced Excel skills e.g. V-lookups, pivot tables, macros, Essbase, data manipulation performed within weekly strict deadlines.
• Produced monthly reports on Business Headcount, budgets to actuals for month-to-month comparison, breakout of business cost incurred within the several EMEA business areas of the company.Lead projects and communicated.

Master Of Business Administration (Mba)

Masters Of E-Learning Design And Development

Ba (Hons), Industrial Design