Efe Mirkan Guner

• Built and maintain a stock reconciliation automation in Excel and Python pandas that standardises ticket IDs, removes duplicates within and across displays, applies conditional formatting by status, and writes an Unmatched exceptions tab with a run summary, freeing up four to five hours of manual checks per week, lowering error rates by 95 percent, and reducing the staff required for the process.
• Engineer a POS linked web scraping workflow in Python that prioritises top selling items, calculates landed cost including VAT, shipping and minimum order quantity, finds the lowest cost across approved wholesalers and produces a ready to order buy list, lowering average landed cost on priority SKUs by 7 percent, shortening reorder decision time from 2 days to 4 hours, and lifting gross margin.
• Reconcile cycle counts vs POS; investigate variances (mislabels, missing stones, SKU errors) and maintain a variance log to drive fixes, reducing repeat issues.
• Maintain product master data (SKU, gemstone/metal/size, certificate); standardise attributes and optimise listing titles/descriptions for search, improving data integrity and search visibility.
• Alerts & action lists: automated flags for low-stock, aged-stock and high-risk SKUs; generate owner-tagged action lists (reorder/markdown/photography refresh), ensuring timely follow up.

Took a sabbatical to focus on a personal health matter. This period helped me develop greater resilience and a proactive approach to managing challenges. I am now fully recovered and eager to apply my skills and experiences to a new role.

• Conducted diagnostic assessments and built individual learning plans, improving grades by an average of 1.5 levels within one academic year.
• Taught algebra, calculus, geometry, trigonometry, probability and statistics with methods matched to learning style, helping 90% of students achieve their target grade or higher across AQA, Edexcel and OCR.
• Ran structured revision cycles using past papers, timed drills and mark scheme feedback, delivering an average mock to final uplift of 1.8 grades.
• Produced bespoke resources, homework schedules and revision packs, raising homework completion from about 60% to around 90% and strengthening independent study habits.
• Tracked progress with regular quizzes and termly assessments and shared reports with parents, maintaining student retention near 88% and average parent satisfaction at 4.8 out of 5.
• Delivered targeted interventions on fundamentals and exam technique, reducing common method mark losses by approximately 40% in the final term.