Andrew Wicker Email & Phone Number

Portland, Oregon, United States

• Developed a middleware to intercept GraphQL queries, enabling data fulfillment from cache, which minimized latency and improved responsiveness without additional API calls.
• Optimized middleware by strategically utilizing Bun's minimal dependencies, enhancing Web API, file delivery, and promise chaining through native methods.
• Devised algorithms to align cached data with query shapes, significantly reducing data re-fetching and accelerating response times by a factor of up to 100.
• Fused IBM Cloudant DB with PouchDB for a seamless user experience, enabling real-time sync, offline data access, and auto conflict resolution.
• Developed performance tests with the Performance API, benchmarking database versus cache speeds, illustrated via Chart.js for stakeholder engagement.

Portland, Oregon, United States

— Enhanced test coverage by 5% for React components using React Testing Library and Jest, ensuring reliability in user interaction scenarios and boosting code maintainability.— Spearheaded the transition of React components to TypeScript, reducing technical debt by 30%, enhancing code stability with type safety, and facilitating future development and.

Portland, Oregon, United States

• Custom-built three high-performance workstations for an accounting firm with Core i5 CPUs, 32GB RAM, and NVMe SSDs, achieving cost-efficiency and upgradability for increased productivity.
• Optimized the firm’s technology stack for future updates, balancing performance with budget considerations, enhancing overall team output.
• Overhauled office networking with custom solutions including Wi-Fi, LAN, and security systems, bolstering infrastructure for seamless in-office and remote operations.
• Performed regular network assessments and maintenance, ensuring robust and uninterrupted connectivity for a diverse range of work environments.
• Revolutionized project management and client relations by transitioning from Excel to Karbon, streamlining data migration, and automating workflows, cutting admin time by 20%.
• Configured critical IT services such as Ultra Tax CS and Office 365, facilitating efficient remote work through Windows Remote Desktop and LogMeIn.