Andrew M. Email & Phone Number

Crewe, Gb

Manchester Area, United Kingdom

London & Manchester

- Power BI Proof of Concept- Power BI Development- Data Analysis - Data Quality Assessments- Data Cleansing- Technical Documentation- Data Consultancy - Technical Pre-sales- Project Proposals

Manchester, United Kingdom

- Client Management- Business Development- Discovery Workshops- Tableau Development- Power BI Development

Crewe, United Kingdom

- Analysis and understanding of company wide data requirements to enhance Data Warehouse within business.- Working with Senior Management Team to establish reporting requirements for the business.- Supporting software users within the business and providing training to upskill users.- Developing PostgreSQL queries and deploying via Tableau workbooks.- Querying existing data sources using SQL.- Developing reporting packs for key projects within the company.- Management of software use and roll out within the business.- Administrating Tableau Online across the business, managing permissions and users.- Managing workflow using Jira.- Documenting processes using Confluence and - Data Mining/Reconciliation to understand discrepancies between source data and data warehouse.- Working with ETL developers to improve reliability, scalability and quality of data within the data warehouse.- Assisting ETL developers with logic for complex ETL tasks.- Providing requirements documents for additional data development within the data warehouse.

Crewe

End to end processing for a small company within the group including:- Cashbook Reconciliations- Monthly Bank Reconciliations- Purchase and Sales Ledger Reconciliation- Processing Purchase Invoice including Payment Runs- Production of Sales Invoices using the Sage Line 200 system- Submission and reconciliation of returns to HMRC- Completion of monthly management accounts for submission to the FinancialController for consolidation- Weekly sales volume reporting.Weekly sales invoicing including:- Completion of Sales invoicing run for 20,000 customers.- Analytical review of transaction data before invoicing is undertaken.- Heavy involvement of the progress and improvement of the invoicing process.- Organizing regular meetings to review progress of new projects with senior management and company directors.- Substantially improving the efficiency of the invoicing process reducing the volume of manual work and consolidating reports where possible.- Liaising with external sales offices to improve relationships with external offices and improve efficiency of receipt of data from them.- A key part of the ongoing migration of the invoicing process into a new database reporting to the Financial Controller and IT Manager.- Support & guidance of other member of the finance team in their invoicing processes sharing efficiencies already achieved within the process I currently complete.Weekly Management Reporting- Completion of reporting on sales margin and volume for three new projects within the group submitting to the company directorsAd Hoc Duties- Heavy support in the absence of the Finance Manager giving guidance and support to other team members when required.- Data reporting at the request of the Financial Controller and Managing Director of the company to assist with decision making within the company.- Completion of analytical review of all invoicing processes within the team submitted to the Financial Controller

Crewe, United Kingdom

- Completion of Daily Importing- Timely Sending of Daily Export Files and Reports- Completion of weekly reporting- Completion of monthly reporting- Supporting the Operations Manager in their duties

Btec National Diploma, Business Studies, Mpp

Gcse