Profile of John Yeoh
John Yeoh Business Analyst Based on your resume, here is a more natural and human-sounding summary of your achievements:
My Professional Journey and Key Achievements
Over the past 18 years, I’ve built a career at the intersection of technology, training, and business transformation. What drives me is taking complex technical systems and making them work for real people—whether that means optimizing databases, training teams across continents, or leading large-scale system migrations. Along the way, I’ve helped organizations save over $400,000 annually while making technology more accessible to everyone from factory floor workers to C-suite executives.
Making Technology Pay Off
One of my proudest achievements happened at Seagate Technologies when I led the Oracle 11i to R12 migration. This wasn’t just a technical upgrade—it was a massive coordination effort involving 12 developers spread across India and Malaysia, working across different time zones. We managed to consolidate five servers into one, which saved the company $75,000 over three years. Beyond the cost savings, this consolidation reduced our energy footprint and simplified maintenance significantly.
But the real breakthrough came when I tackled a SQL performance nightmare. There was this critical report that took 6 hours to run—basically overnight processing that delayed decision-making until the next business day. I dove into the query optimization and managed to reduce the execution cost from 42,000 down to just 152. The result? That same report now runs in 15 minutes. Watching stakeholders get near-real-time data instead of waiting until tomorrow was incredibly satisfying.
I also led the migration from Oracle Reports to OBIEE, which saved another $100,000 annually by eliminating redundant servers. What made this project special was the training component—I personally worked with interns and end-users, teaching them XSLT and XSLFO templates so they could create their own reports. This meant the company wasn’t constantly calling IT for every report tweak.
At Renesas Semiconductor, I inherited a legacy COBOL system running on an expensive mainframe. After migrating everything to a client-server architecture, we cut maintenance costs by $35,000 a year. I also standardized the naming conventions across the codebase, which sounds mundane but made a huge difference for developers trying to maintain and debug the system.
The Vendor Quotation System was another win. The old process took 3 months from start to finish—painfully slow when you’re trying to make purchasing decisions. Through automation and process redesign, I got that down to 3 weeks. That’s a 75% reduction that saved $50,000 annually and dramatically improved our relationships with suppliers who appreciated the faster turnaround.
Training People, Not Just Systems
Here’s something I’ve learned: the fanciest system in the world is worthless if people don’t know how to use it. That’s why I’ve always focused heavily on training and change management, which honestly sets me apart from most technical folks who just want to build things and move on.
At Seagate, I developed comprehensive training programs for Oracle HCM and Fusion modules—Core HR, Payroll, Talent Management, Procurement. These weren’t just boring PowerPoint presentations. I created role-based materials and job aids that translated technical jargon into real business scenarios people could relate to. Finance teams learned about month-end balancing in terms of their actual workflows, not just system buttons to click.
The train-the-trainer approach has been particularly effective. Instead of making everyone dependent on IT forever, I built super-user capabilities within business teams. This reduced IT dependency by 60% and created a sustainable support model. People felt empowered because they could help their colleagues instead of always waiting for the help desk.
At Warisan TC, I faced an interesting challenge: 95 different management reports that nobody could keep straight. I consolidated them down to 15 streamlined dashboards using Google Data Studio, but the real work was training stakeholders across multiple sites—Lot 9, Lot 29, Sabah, Pahang—to actually use these new tools. I developed quick-reference guides specifically for non-technical users and conducted hands-on training sessions. The result? Support tickets dropped by 40% because people could figure things out themselves.
The Digi-Telenor-Axiata merger was particularly challenging from a training perspective. Imagine three different telecommunications companies, each with their own systems, naming conventions, and ways of doing things, suddenly trying to work together. I conducted stakeholder training sessions to establish standardized naming conventions and KPI reporting frameworks. The training materials I created helped hundreds of end-users navigate this transition without getting lost in the chaos.
Building Systems That Actually Work
I’ve always approached system implementation with a practical mindset. At Penang Water Works, I established the Assets Management System Project from scratch. This meant identifying resources, gathering requirements from multiple departments, evaluating vendor proposals, and presenting pros and cons to management. The migration from COBOL to Oracle was technically complex, but I focused on ensuring the new system actually met operational needs, not just checking boxes on a requirements document.
My QA background has served me well. I utilized HPQC and Micro Focus ALM for test case management, linking everything with Oracle Application Testing Suite for regression, load, and performance testing. I also implemented Selenium-based automation testing for Oracle applications. But beyond the tools, I managed QA teams through complete SDLC phases, establishing rigorous testing protocols that caught issues before they reached production.
The Mass Stop Ship project at Seagate shows how technology can solve real business problems. We built a serial-number-based system that let QC teams immediately halt shipments of defective hard disks. This saved $50,000 annually and, more importantly, prevented potential recalls and protected our brand reputation. I trained the QC and warehouse teams personally, making sure they understood not just the “how” but the “why” behind the system.
Turning Data Into Insights
Data warehousing and business intelligence have been consistent threads throughout my career. At Renesas, I designed a data warehouse with 2-hourly transactional loads and end-of-day master data updates, carefully architected to avoid conflicts. The Purchasing and Inventory reports I built replaced hours of manual Excel pivoting with automated dashboards. Finance teams went from drowning in spreadsheets to having clean, accurate data at their fingertips.
During the telecommunications merger, I didn’t just integrate systems—I created a unified reporting framework. I established standard naming conventions across business entities (no small feat when dealing with three different organizational cultures), compiled and consolidated BI reports, and created Master Dimension groupings that aligned KPIs with actual data attributes. This gave everyone a common language for talking about performance.
The Vendor Lot Tracking System I designed at Seagate saved $45,000 per year by automating consignment item tracking. I worked closely with Finance to customize Oracle screens for vendor lot visibility, eliminating tedious manual data entry and the errors that came with it.
Leading Through Change
What ties everything together is my ability to lead people through change. At Warisan TC, I led infrastructure modernization across multiple locations—upgrading CCTV systems, replacing outdated 100Mbps network cables with modern infrastructure, implementing EHS compliance alert systems. Each upgrade required change management to ensure smooth transitions and actual adoption, not just installation.
I’ve negotiated with countless vendors and suppliers over the years, always pushing for cost-effective pricing without sacrificing quality. Weekly PMO meetings kept projects aligned with organizational objectives, and I’ve learned to communicate effectively with everyone from developers to executives.
My educational background—an MBA in Marketing from University of Nottingham Trent and a Bachelor of Science in Computing from Greenwich University—combined with my recent IABAC Certified Artificial Intelligence Professional certification, gives me a unique perspective. I understand both the technical details and the business implications. I can optimize a SQL query in the morning and present ROI analysis to executives in the afternoon.
What really matters to me is making technology serve people, not the other way around. Whether I’m consolidating servers, training super-users, or migrating legacy systems, my focus stays on creating solutions that actually work in the real world and make people’s jobs easier.
This version sounds more conversational and authentic, like you’re telling your story rather than listing accomplishments.
Work History (0)
Work Experiences
Add work experience to your profile. (optional)
Certification
Add work certification to your profile. (optional)
Education
Add work education to your profile. (optional)