Ertan M. Email & Phone Number

High Wycombe, England, United Kingdom

Reading, England, United Kingdom

London, England, United Kingdom

●Spearheaded the identification of reporting and insight gaps across product lines, laying the groundwork for a comprehensive insight strategy and roadmap to address them at Hanson Wade.●Established, standardized, and refined Key Performance Indicators (KPIs) and leading metrics to guarantee consistency and accuracy in reporting across various business domains.●By leveraging SQL, Power BI, Excel, and proprietary software like Salesforce; created, automated, and consolidated dashboards efficiently in critical areas such as Production, Marketing, Sales, Finance, Customer Delivery, and HR. ●Collaborated with the Database Manager, Data Engineer, and Salesforce Manager to enhance data quality and streamline processes within the Data Management Office at Hanson Wade.●Played a pivotal role in initiatives aimed at optimizing Salesforce by identifying and removing unnecessary fields and files, rectifying inaccuracies, and implementing new data fields. These efforts resulted in improved data accuracy and actionable insights for the organization. Led workshops across various departments to facilitate collaboration and communication, contributing to the creation of a comprehensive roadmap for resolving identified data issues.●Provided mentorship and technical guidance to the Insight team, fostering their professional growth, and enhancing their skill set to meet the dynamic demands of the industry.●Analysis created as part of the insight strategy included benchmarking, sales and marketing rep performance, campaign review, sales pipeline and conversion rates by channel, product usage stats, A/B analysis, Google Web Analytics, pre-sale/early bird promotion performance, and customer satisfaction.●Created bespoke and strategic dashboards for senior managers and board members such as Weekly KPIs Dashboard, Financial Milestone Dashboard, Cross-Product Sales Dashboard, and HR Dashboard Pack which included churn, tenure, absences, holidays, and other hypothesis testing analysis.

Reading, England, United Kingdom

●Contributed to the development of the Water Networks Transformation Program (WNTX) by building strong relationships with internal departments, which resulted in successfully delivering the Performance Framework project on time.●Carried out meticulous data analysis and collaborative workshops, leading to innovative KPIs and OKRs in the business.●Leveraged advanced analytics tools including Power BI, SQL, Excel, Power Automate, and SAP to create dynamic dashboards and analyses, significantly enhancing stakeholder visibility and decision-making accuracy.●Collaborated with data teams to identify the availability, quality, and consistency of data, as well as the suitability of data capture in the new salesforce system.

Reading, United Kingdom

●Provided essential operational and financial insights to senior management by leading the creation of consolidated performance reports and dashboards for finance, inventory, logistics, and incident management departments aimed at empowering informed decision-making, and driving organizational success.●As the go-to analyst for complex projects, conducted in-depth analyses of front-end operations using Power BI, and Excel, interfacing with systems such as ORTEC, SAP, and 3rd party software for data extraction. Projects included identifying stronger ways of distributing alternative water, insourcing, maximizing vehicle/tanker utilization, and “Buy vs. Hire” on plant and equipment.●Delivered expert assistance to project and program managers with cost/benefits tracking, inventory and logistics analysis, forecasting budget, operational analysis, risk management, process mapping, and implementation on some improvement projects.●Held ownership of producing consolidated reports for strategic projects and initiatives as well as monitoring the performances of key partners.●Led the development and implementation of the long-term commercial and operational strategic plan and priorities, ensuring plans met company objectives.●Served as a trusted advisor to project managers, SMEs, and sponsors to provide support with developing effective process solutions to briefed projects. Used Power Automate, Excel, Forms, and SharePoint for process improvements.●Facilitated workshops to drive projects forward, utilized negotiation and influencing skills to gain buy-in for business cases.

Reading, United Kingdom

●Provided support to Strategic Sourcing Managers and Business Partners to deliver cost-effective tender●Assisted with strategy development by cleansing, collating, and modeling spend and operational data into a structured format, translated findings to produce meaningful insights ●Created commercial models and bid sheets that will serve the future needs of the business●Applied commercial thinking to perform thorough market research and analysis of tender responses to identify suppliers that will bring the highest possible value to the business

Oxford, United Kingdom

Client Services Analyst is a busy and varied role that involves extensive data analysis and client management. With tight SLAs and ongoing demanding client requests, I have been continually demonstrating exceptional organisational, planning and management skills to meet expectations.The purpose of the role and day-to-day duties were: Managing large volumes of clients’ data, formatting and amalgamating multiple sources of data from different systems to identify trends, data patterns, and key areas that require improvements.Conducting clear and accurate analysis of data and producing reports for clients and senior management concisely.Having monthly meetings with each client to present reports and discuss mobile expanse optimisation opportunities, and organising ad-hock meetings to discuss and implement solutions for existing issues. Working with colleagues from other departments to improve on data integrity issues and data analysis automation.Creating mobile charges profiles by analyzing contracts and billing data and handling both client and network provider communications for disputes.

Oxford, United Kingdom

Working as part of a small team, I used established practices and reporting to correct and align customer data within the electricity industry. I was responsible for determining the root cause of problems with customer data and for taking corrective action. Taking ownership of problems was key as I owned the resolution through to completion. The role combined analytical and problem-solving skill sets.Good investigation and communication skills were essential as I have worked with several internal teams and external Industry parties to resolve data mismatches and errors. I have used my initiative and also organised and prioritized my workload since much of the work had multiple stages.

Wheatley Campus

Oxford, United Kingdom

Bachelor'S Degree, Business And Management, 1St

Access To Higher Education, Business, Distinction

Management Accounting and Finance Marketing Study Skills