Gerhard Schick

As a Data Solutions Consultant, I empower clients in the F&B, pharmaceutical, and stationery industries by delivering data-driven solutions that transform business operations. I specialize in building MS Access databases using SQL and VBA, streamlining processes, and enhancing decision-making. • Developed and implemented custom databases, MS PowerApps, reducing process times by up to 80% and mobile access to 700+ SKU data through automation and business intelligence solutions.

I keep developing and maintaining database applications and provide business data to ensure smooth back-end business processes and efficient decision making. • Expand and optimize MS Access front- and back-end database to further streamline CRM, payments and order processing. • ETL to maintain and update accurate customer and product data . • Analyse customer purchase data for promotional campaigns. • Upkeep of company product website and online shop. • Data Analysis and Visualization using PowerBI

I led IT, operations, and finance for an F&B wholesaler, harnessing data analytics to optimize business processes. My focus was on building robust data systems and conducting market research to drive strategic decisions. • Designed an MS Access database with a MySQL back-end for CRM, inventory, and order management, supporting S$650k in annual order fulfillment. • Conducted data-driven market analysis on 7,000 FMCG products to inform pricing and market entry strategies. • Implemented Xero for bookkeeping.

I transformed operations for a premium wine agent by leveraging data analytics and automation. My work focused on converting manual processes into efficient, data-driven systems to support business growth. • Built an MS Access database with VBA and SQL, achieving 90% time savings in inventory management, CRM, and business data analysis utilizing data visualization for actionable insights and enhancing decision-making.

I managed high-impact IT projects, focusing on data analytics and automation to drive business outcomes. My role involved developing solutions that enhanced data accessibility and decision-making. • Led a S$300k project to build automated trading modules and an online interface for FX trade analysis, improving data-driven decision-making. • Programmed a POS system with mobile router setup, boosting operational efficiency and real-time data access.

I spearheaded the development of a proprietary foreign exchange trading platform, integrating data analytics and visualization to enhance trading efficiency. • Managed a S$400k project to design a trading platform, improving trade execution and data visualization for stakeholders. • Built a CRM database for 600+ clients using MS Excel, driving sales and marketing initiatives. • Coordinated FX training for 300+ students, using data insights to tailor educational content.

I drove market expansion for CT systems in SE Asia, using data analytics to inform strategy and optimize processes. • Conducted market research and produced business intelligence reports for China and SE Asia, supporting S$1.5m in sales. • Analyzed 3D CT measurement data, reducing quality assurance time by 75% for precision parts. • Deployed data-driven marketing strategies, enhancing product adoption and market penetration.

As an RF/uW Technical Support Engineer at Agilent Technologies, I provided expert pre- and post-sales support for communication test equipment, ensuring optimal performance and customer satisfaction. My role involved deep technical knowledge of RF/μW and optical technologies, as well as strong problem-solving skills. • Resolved technical issues, achieving service levels above 95% through effective problem-solving. • Analyzed and troubleshot complex customer issues, implementing resolutions and workarounds.

I contributed to the development of Optical Coherence Tomography (OCT) systems, focusing on data-driven enhancements. • Improved OCT optical resolution by 300% through dispersion compensation techniques. • Tested and enhanced application software, collaborating with developers to optimize performance.

Certificate including following areas: • Python programming • SQL • Business intelligence • Working with databases • Data visualisation using PowerBI • Dashboard design • Statistical analysis & regressions • Machine learning algorithms • Structured problem solving • Building a business case • Story-lining, presentation & communication • Human – centered design • Digital use case and lifecycle • Business excel modelling • Design thinking • Agile Methodologies

Operation-, Project-, Quality- and Process- Management, Analytics, Supply Chain Management Marketing Research and Marketing Management, Financial and Fund Management.

Successfully designed, built, and tested an optical neural network for test and study purposes.

Optics design, Laser, Optical Metrology, Optical Communications