Programmer Analyst Travel Consultant

JoYoshida

Results-Driven IT Professional – background in systems engineering and software development. Adept at distilling complex issues into concise project requirements, then developing and deploying innovative IT solutions that enhance business processes and streamline workflows. Platform Language Tools

SQL Server T-SQL Visual Studio

SQL Server Analysis Services C# Netbeans

SQL Server Reporting Services Java IntelliJ

SQL Server Integration Services Subversion, Git

Employment

QHR TECHNOLOGIES (Kelowna, British Columbia, Canada) 2018.01 – now Software Developer

Supported analytics effort for a vendor of electronic medical record (EMR) management solution.

• Developed features and bug fixes for a proprietary ETL service to process records between an EMR solution and data warehouse (Netbeans, IntelliJ, Java).

• Performed similar duties with internal tools to prepare and import client data (Visual Studio, C#).

• Developed scripts for ETL workflows and schema changes (SQL Server, T-SQL). WELLCYCLE (Novato, California, USA) 2014.01 – 2016.06 Technical Services Engineer

Customized deployments for a vendor of web-based project management solution targeting the energy sector.

• Developed reports and dashboards for web application (SQL Server, SSRS, T-SQL, Telerik).

• Developed scripts to migrate data from external systems (SQL Server, T-SQL).

• Developed custom workflows via triggers and stored procedures (SQL Server, T-SQL).

• Designed and developed Windows service to automate asynchronous document processing (.NET, C#, SQL Server, T-SQL, Visual Studio).

• Designed and developed data warehouse, data mart, and cube to analyze task durations; created ETL integration packages to load and refresh warehouse data. (SQL Server, SSAS, SSIS). PACIFIC PULMONARY SERVICES CO. (Novato, California, USA) 2010.07 – 2013.09 Systems Analyst

Created various web and data-driven solutions for a durable medical equipment and service provider.

• Developed application modules (ASP.NET, C#, SQL Server, T-SQL, WCF, VisualForce, Apex).

• Designed and developed corporate reporting platform (SSRS, SQL Server, T-SQL).

• Designed and developed Windows service to automate outgoing electronic faxes (.NET, C#, SQL Server, T-SQL, Visual Studio).

• Developed web-based workflow solution for centralized order intake system (Websphere Lombardi, Java).

• Developed reports (SQL Server, T-SQL, SSRS, Crystal Reports). Kelowna, CANADA adw5dn@r.postjobfree.com

+1-250-***-**** [Skype] durian2durian

2/2

Employment continued...

CITY OF CALGARY (Calgary, Alberta, Canada) 2010.02 – 2010.06 Programmer Analyst

Assisted parks department projects focused on asset management, data migration, and reports. Developed reports and migrated data for web-based asset management system (ASP.NET, C#, Oracle, PL/SQL, Telerik, ActiveReports).

BECHTEL CORPORATION (Frederick, Maryland, USA) 2002.07 – 2009.02 Programmer Analyst

Contributed to projects to automate 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/increase productivity.

• Developed a Pocket PC application that recorded construction site checklist data on disconnected handheld devices (.NET Compact Framework, VB). Result: created a flexible tiered design that became the core framework for other key web applications.

• Developed a plug-in applet to compensate for flawed architecture of a third party web application (ASP.NET, C#, Oracle). Result: 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). Result: enabled field managers nationwide to systematically select top-performing subcontractors and ensure high service levels for corporate clients.

• Developed an intranet web application that allowed functional groups to add monthly KPI data to a single repository (ASP.NET, C#, SQL Server, Infragistics, ActiveReports). Result: reduced time to generate 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). Result: solution deployed nationally across multiple projects.

Previous roles:

Applications Programmer @ Sensate Inc Calgary, Canada Travel Consultant @ Adventure Travel Co Calgary, Canada Programmer Analyst @ Zi Corp Calgary, Canada

English Composition Instructor @ Aoyama College Soai College Konan University Osaka/Kobe, Japan Systems Programmer @ Daewoo Telecom Incheon, Korea Project Engineer @ Nortel Saskatoon, Canada

Education

Bachelors of Science, Electrical Engineering

University of Saskatchewan (Saskatoon, Canada) 1977.09 – 1982.05 Six Sigma Yellow Belt certification (Bechtel Corporation) 2005.09 Silent Way teacher training (Osaka, Japan): theory, English, Spanish, Vietnamese, and Japanese Basic conversational skills in Japanese; familiarity with Korean and Chinese script systems stackskills.com courses: poodaH, giP, eviH, esaBH, nohtyP, krapS, alacS, rRr, avaJ, ardnassaC, 2016.11 emulF, pooqS, iezoO, gninrael enihcam, gnissecorp egaugnal larutan Kelowna, CANADA adw5dn@r.postjobfree.com

+1-250-***-**** [Skype] durian2durian

Contact this candidate