Jo is available for hire
Hire JoJo Yoshida
Verified Expert in Engineering
Software Developer
Location
Kelowna, BC, Canada
Toptal Member Since
June 18, 2020
Jo has a background in software development, engineering, and systems implementation. Jo is also adept at distilling complex issues into concise project requirements and developing and deploying innovative IT solutions that enhance business processes.
Portfolio
QHR Technologies
T-SQL (Transact-SQL), Java, ETL, Azure Databricks, SQL Server BI
WellCycle
Visual Studio, C#, .NET, Telerik, T-SQL (Transact-SQL), SSAS...
Pacific Pulmonary Services
Crystal Reports, Java, WebSphere, Apex, Visualforce, C#, WCF Web Services...
Experience
Availability
Part-time
Preferred Environment
Microsoft BI Stack, Azure Databricks
The most amazing...
...thing I've coded is a Chinese glyph stroke-based input method for Macintosh System 6.
Work Experience
Developer
2018 - PRESENT
QHR Technologies
- Developed a Data Lakehouse pipeline for the data lake to support corporate and client business intelligence projects (Databricks).
- Architected features and bug fixes for a proprietary ETL service to process records between an EMR solution and data warehouse (NetBeans, IntelliJ IDEA, and Java).
- Developed scripts for ETL workflows and schema changes (Microsoft SQL Server and Transact-SQL).
Technologies: T-SQL (Transact-SQL), Java, ETL, Azure Databricks, SQL Server BI
Technical Services Engineer
2014 - 2016
WellCycle
- Developed reports and dashboards for a web application (SQL Server, SSRS, T-SQL, Telerik).
- Wrote scripts to migrate data from external systems (SQL Server, T-SQL).
- Built custom workflows via triggers and stored procedures (SQL Server, T-SQL).
- Designed and developed a Windows service to automate asynchronous document processing (.NET, C#, SQL Server, T-SQL, Visual Studio).
- Designed and developed a data warehouse, a data mart, and a cube to analyze task durations; created ETL integration packages to load and refresh warehouse data (SQL Server, SSAS, SSIS).
Technologies: Visual Studio, C#, .NET, Telerik, T-SQL (Transact-SQL), SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server
Systems Analyst
2010 - 2013
Pacific Pulmonary Services
- Built application modules (ASP.NET, C#, SQL Server, T-SQL, WCF, Visualforce, Apex).
- Designed and developed a corporate reporting platform (SSRS, SQL Server, T-SQL).
- Designed and developed a Windows service to automate outgoing electronic faxes (.NET, C#, SQL Server, T-SQL, Visual Studio).
- Created a web-based workflow solution for a centralized order intake system (WebSphere Lombardi Edition, Java).
- Developed reports (SQL Server, T-SQL, SSRS, Crystal Reports).
Technologies: Crystal Reports, Java, WebSphere, Apex, Visualforce, C#, WCF Web Services, ASP.NET, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), Microsoft SQL Server
Programmer Analyst
2010 - 2010
City of Calgary
- Assisted in projects for the parks department that focused on asset management, data migration, and reports.
- Developed reports and migrated data for a web-based asset management system (ASP.NET, C#, Oracle, PL/SQL, Telerik, ActiveReports).
Technologies: ActiveReports, Telerik, PL/SQL, Oracle, C#, ASP.NET
Programmer Analyst
2002 - 2009
Bechtel Corporation
- Contributed to projects that automated data processing and report output for internal clients by clarifying workflows and gathering requirements.
- Modeled data and built databases.
- Designed, coded, and deployed web solutions; provided post-rollout support and authored user/technical documentation.
- Implemented process improvement plans as part of Six Sigma initiatives to reduce costs and/or increase productivity.
- Built a Pocket PC application that recorded construction site checklist data on disconnected handheld devices (.NET Compact Framework, VB)—created a flexible tiered design that became the core framework for other key web applications.
- Created a plug-in applet to compensate for flawed architecture of a third party web application (ASP.NET, C#, Oracle)—improved load/update times for a project milestone tracker by more than 75%.
- Developed an intranet web application to store subcontractor ratings in a central repository (ASP.NET, C#, SQL Server, Dundas, ActiveReports)—enabled field managers nationwide to systematically select top-performing subcontractors and ensure high service levels for corporate clients.
- Built an intranet web application that allowed functional groups to enter monthly key performance indicator data into a single repository (ASP.NET, C#, SQL Server, Infragistics, ActiveReports)—streamlined the generation of metrics reporting for departments across global business units from hours to minutes, improving accuracy, availability and security.
- Developed an intranet web application to track and expedite service requisition processing via collaborative, centralized access (ASP.NET, C#, SQL Server, ActiveReports)—the solution is currently deployed nationally across multiple projects.
Technologies: PL/SQL, Oracle, Infragistics, VB, .NET Compact, ActiveReports, Dundas BI, Microsoft SQL Server, C#, ASP.NET
Applications Programmer
2000 - 2001
Sensate Incorporated
- Coded applications for this startup firm that offered a media server-client software framework targeted for OEMs.
- Drove development efforts in order to meet major deadlines.
- Devised a content delivery method ("trickle mode”) which played the first downloaded audio track while retrieving the second in a background thread (Visual C++)—the method allowed audio playback to work on handheld devices that lacked processing power for live streaming.
- Delivered 2 key PDA applications (Pocket PC, Visual C++)—enabled the firm to demonstrate its core technology (wireless content streaming between PCs and handheld devices) at 2 major trade shows.
Technologies: PC, Microsoft Visual C++
Programmer Analyst
1995 - 1996
Zi Corporation
- Performed development tasks for this firm that marketed desktop and embedded software solutions that allows stroke-based predictive entry of complex Chinese glyphs via standard 12-button keypads.
- Designed an application programming interface (API) by extracting a text input method engine from a DOS word-processing application (C)—facilitated the release of a Windows solution to consumers in Hong Kong.
- Assisted in bringing up hardware and coded firmware on an educational handheld unit targeted for markets in Mainland China (C)—facilitated the completion of the prototype and expanded the application of the firm’s technology to embedded implementations.
- Developed a Chinese text input method component for the Macintosh (Metrowerks CodeWarrior, C, System 7)—enabled the firm to enter licensing negotiations with Apple Asia.
Technologies: C, CodeWarrior
Systems Programmer
1986 - 1987
Daewoo Telecom Company Limited
- Developed production line diagnostic modules (x86 Assembly, C).
- Tested the compatibility of hardware against standard DOS applications and system software.
Technologies: Microsoft Assembly x86 (MASM), C
Project Engineer
1983 - 1985
Nortel Networks
- Implemented the technology transfer of a chemical vapor deposition gas delivery control system in a joint venture between Nortel Networks and Daewoo Telecom.
- Provided technical support during the installation and commissioning of production equipment at the licensee’s optical cable manufacturing facility in South Korea; trained local engineers.
- Administered the employee suggestions plan and associated database.
Experience
Mount Burdell
https://www.youtube.com/watch?v=2E3NceWnnFUMy favorite local ride; able to ascend to the top (3 of 10 rides) without stopping.
Skills
Languages
T-SQL (Transact-SQL), Apex, Java, VB, Microsoft Assembly x86 (MASM), C, C#, JavaScript
Other
Writing & Editing, Business Processes, Data Modeling, SSRS Reports, WCF Web Services, Data Warehouse Design, Azure Databricks
Storage
SQL Performance, Microsoft SQL Server, SQL Server Reporting Services (SSRS), PL/SQL, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Oracle PL/SQL, SQL Server Management Studio (SSMS)
Industry Expertise
Photography
Frameworks
ASP.NET, Visualforce, .NET Compact, .NET
Libraries/APIs
Infragistics
Tools
Dundas BI, Microsoft Visual C++, CodeWarrior, SSAS, Visual Studio, Photoshop CS6, Visual Studio .NET, Toad, ActiveReports, Crystal Reports, SQL Server BI
Paradigms
ETL Implementation & Design, ETL
Platforms
Microsoft BI Stack, WebSphere, Oracle, Telerik, PC
Education
2005 - 2005
Lean Six Sigma Methodology in IASSC Certified Lean Six Sigma Yellow Belt™ (ICYB™)
The International Association for Six Sigma Certification (IASSC) via the Bechtel Corporation - Frederick, MD, USA
1977 - 1982
Bachelor's Degree in Electrical Engineering
University of Saskatchewan - Saskatchewan, Canada
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring