Andrew Haley Email & Phone Number

Danville, California, US

San Francisco, CA, US

New York, New York, US

• Solution Architect on two projects and the Project Manager / Model Builder on a third.
• Built an Anaplan Contract Analytics model for a global pharmaceutical client.
• Built enhancements for a global pharmaceutical company's clinical research office planning model in Anaplan.
• Grew a book of business in excess of $250k in 2020.

New York, New York, US

• Built enhancements around a large scale, multi-division FP&A model, aimed at increasing security and limiting potential for unauthorized adjustments to the B/S, C/F or overall P&L statements.
• Built a demand planning and sales forecasting model for the United States arm of a pharmaceutical company and a global beverage provider.
• Built a Monte Carlo proof of concept in Anaplan using random number variates to allow for basic simulation computation, sensitivity analysis and selection of probabilistic distributions of forecasted input variables to.
• Conduct in depth data analysis to derive existing processes and their process flows to show cause and effect relationships between variables and how they apply to the planning process.
• Identify methods of quantifying qualitative variables to apply to mathematical models.
• Build dashboards for use by in-house forecasting, demand planning and finance teams.

Boston, Massachusetts, US

• Provided analytics reporting to senior leadership. Creating process workflows covering current and future state design. Worked with Tableau, Visio, Excel and SQL.
• Created interactive dashboards with Tableau.
• Wrote SQL queries to extract data and connecting databases to Tableau for live feeding data.
• Created an end-to-end process flow in Visio for procurement requests based on existing SOPs and use cases.
• Created optimization models and forecasting models in my MS-Applied Business Analytics coursework, and am currently focusing on financial concepts surrounding managerial and financial accounting, and corporate reporting.

Boston, Massachusetts, US

• Created a project plan for a reporting transformation initiative across Global Compliance and led the data aggregation portion of the project.
• Gathered requirements for process enhancements to Global Compliance’s reporting structure and identified gaps in Global Compliance’s reporting structure and made technological recommendations for enhancement to their.
• Defined KPIs for successful reporting across Global Compliance and created a process redesign model for future state that would allow for them to be continuously monitored for proper performance.
• Wrote a project proposal for implementation of a new candidate onboarding process that is projected to save an estimated $2.5 million in lost labor per year.
• Led an organizational redesign and workforce analysis for Corporate Audit, resulting in a restructuring of their group, an implementation of basic technology to better run their business unit, and a savings of over.
• Standardizing and analyzing data with Excel, Alteryx and Tableau to provide visualizations and concrete points to support client deliverables.

Boston, Massachusetts, US

• Wrote test scripts for validation of legacy data being stored in a newly created in-house database and wrote SQL queries to in TOAD to execute these test scripts.
• Managed Defect Log for testing of new database as well as the Oracle Application Framework Pages that make the data user friendly.
• Lead the testing effort on post Go-Live fixes to Account Code Combinations, Cost Centers and Organizational Units and wrote the test scripts that found the errors required to be fixed.
• Liaised with finance to facilitate performance of post Go-Live reconciliation of project accounts.
• Managed the Day 2 Issue Log for post Go-Live tracking of required and newly identified features to be developed or configured, and updated senior management on their status, expected due date and of any issues.
• Liaised with both the software provider and the master services provider (MSP) to ensure that all post Go-Live issues are addressed as expected, and assist with getting past any bottlenecks they run into.

Dublin 2, IE

New York, NY, US

Arlington, Virginia, US

Went to boot camp at Fort Knox, KY in 2004 and was stationed at Fort Campbell, KY for a little over two years. During this time, I spent a year in Iraq with the 1/32 Cavalry, 1st Brigade, 101st Airborne.

Master Of Science - Ms, Applied Business Analytics

Bachelor'S Degree, Business Administration