Derek Cramer Email & Phone Number

Bellevue, WA

A contract position with the Business Applications Group (BAG) Analytics and Insights team.I am automating the scheduling of events using tools including Microsoft Flow, SQL Server, Selenium IDE, and REST API's.

Everett, Washington

Contractor to build internal tools using MVC. The tools extract data from other systems using REST API's and SQL and then present the information to end users.

Kirkland, WA

ATS does contract manufacturing for Valve Corporation. As a software engineer in a factory I provide support for integrations between their data systems. I built and maintain our software build chain based around Jenkins and GIT to build, test, and deploy our web services. This infrastructure was not available when I started at ATS, and I had to set it up.

Bellevue, WA

I develop microservices to power voice applications in an Agile environment. These are primarily written in C#.NET and deployed in Docker containers. Inter-container communication is usually done with JSON messages, but when connecting to an external API, other technologies such as XML and managing web service tokens are required.

Bellevue, WA

As a Senior Agent Developer, my responsibilities involve design and development of voice recognition agents. This involves converting a voice user interface (VUI) flow chart into commands and contexts required for the user to interface with our clients.An agent consists of a mixture of internal xml code and SQL with some C++ portions for advanced.

Westminster, CO

• Census Block RoutingMy current project involves merging large amounts of geographic data with USPS carrier route textual information in order to generate groups of streets that comprise of a local geographic area.
• The project is mostly written in SQL Server T-SQL with components in C#.
• Performance optimization is necessary because of the large amount of data required to be processed and limited resources. The scope of the delivery area consists of 10,000 zip codes across the United States.
• The system consists of several databases that reside on different servers. Inter-database communication is managed with link servers, passthrough queries and service broker. The source data is loaded into the database.
• Developed stored procedures to standardize data sources and identify and remove duplicate street information.Map GenerationMaps are generated using a C# Windows form tool that reads information out of the database and.
• Developed tools in C# to convert spatial data between SQL Server geospatial data, KML, MapInfo TAB files, MID/MIF and Well-Known-Binary/Well-known-text formats.

Westminster, CO

• Developed tools to assist in job function in VB, C# and SQL
• Wrote Ad-hoc SQL queries to assist in data processing
• Created algorithm to detect and remove duplicate customers
• Developed Australian processing requirements
• Processed customer information for phonebook deliveries.
• Loaded and standardized addresses in SQL database

Costa Mesa, CA

• Worked with the Vice President of Field Service to maintain a department of 200 employees.
• Developed and maintained tracking method for key performance indicators used by senior staff to make business decisions.
• Generated ad-hoc reports when necessary from Clarify database for Field Service and Service Sales departments
• Developed report to dynamically determine service dates for 20,000 customer maintenance cases used by the Customer Care Center