Motivated junior developer eager to utilize my C#, ASP, Groovy and SQL skills to build rock solid data driven web and ETL
applications. My experience with data analytics, ability to explain complex processes, and juggle large data
sets allow me to leverage my development skills in a way that allows me to work seamlessly with
multifaceted teams. I am driven by a hunger for knowledge and am always looking to learn something new.
EDUCATION
- Grand Circus
- .Net C# Bootcamp | Detroit, MI
- October 2017 - December 2017
- University of Connecticut
- Master of Arts in Geography | Storrs, CT
- August 2001 - April 2003
- Western Michigan University
- Bacheslor of Science in Geography - GIS Specialty | Kalamazoo, MI
- August 1997 - April 2001
CERTIFICATES
- Certificate in C++ Programming, Washtenaw Community College 2012
- GIS Certificate, University of Connecticut 2001
TECHNICAL SKILLS
EXPERIENCE
- Junior Software Developer
- Level Data, Inc. | Kalamazoo, MI
- January 2018 - Present
Configure complex ETL programs for K-12 school districts throughout the US. Support existing ETL programs and enhance existing internal code libraries.
- Work with Business Analysts to write YAML and Groovy configuration files that align with clients’ business
requirements for moving data between client applications on a scheduled basis .
- Contribute to Level Data’s internal code library by enhancing or creating methods related to HTTP Requests/API
calls
- Assisted Level Data’s Help Desk team during ‘peak season’ by handling change requests, troubleshooting ETL job
issues, modifying ETL jobs to scope, and migrating legacy ETL jobs from older code bases to newer standards.
- Contributed to a large, highly visible project for the South Carolina Department of Education regarding poverty
reporting compliance for federal funding to South Carolina School Districts. This involved configuring ETL jobs for
83 school districts across eight different meals system vendors utilizing either SQL back ends or flat files.
- Interact with clients on a regular basis during testing phases to ensure software quality.
- Work with a host of target and source technologies such as Active Directory, GoogleApps and PowerSchool.
- Senior Statistical Analyst
- Intalytics, Inc. | Ann Arbor, MI
- April 2015 - October 2017
Developed sales potential models for a web-based software platform that enables retail clients to create ad hoc
forecasts for optimizing brick-and-mortar real estate decisions.
- Used demographics and sales histories to develop forecasting models for various businesses such as retailers,
banks, and daycare facilities.
- Used Alteryx, a data-intensive BI tool, to blend statistical models, data, and reports into cohesive, replicable
packages for use in SiteIntel, our proprietary, map-based web portal.
- Utilized SPSS, MS Excel, and SQL Server to quantify statistical model parameters.
- Database Analyst
- TerraSeer, Inc. | Pueblo, CO
- July 2010 – August 2014
Provided data support for small, predictive analytics and web-mapping company. Built databases, constructed repair rate regression models, administered Amazon Web Services resources and provided PHP programming support for company’s web applications.
- Produced ‘failure rate’ regression models for brake and chassis components for all vehicle types using surveys of repair data. From these I derived demand forecasts for auto parts in all U.S. counties, zip codes, states, and
Canadian FSAs.
- Models and associated data were composed in MS SQL Server utilizing stored procedures and T-SQL templates.
- Constructed back-end MySQL databases in support of our web applications.
- Migrated very large data sets between AWS instances running SQL Server, local machines, and LAMP instances on AWS.
- Wrote PHP for accessing data stored in MySQL databases and returning data to Javascript function calls in the
appropriate format.
- Administered all of the company’s AWS resources (EC2, SES, IAM, S3) using AWS Management Console. Included servers for production, testing, and development. This included setting up and administering Amazon Linux, setting
up Apache, setting up cron jobs for backup, installing SSL certificates via GoDaddy.
- Senior Analyst
- Pitney Bowes (aka, MapInfo Corp.) | Ann Arbor, MI
- July 2005 – July 2010
Formulated location and sales forecasting models using a combination of linear and multiple regression modelling. Helped clients leverage customer intelligence to facilitate logical real estate/site location decision making.
- Acted as a trusted advisor to retailers concerning demography-based methods of forecasting sales for potential store locations.
- Aided retailers in optimizing their existing store networks.
- Queried data and presented solutions to data related problems using MS SQL Server and MS FoxPro.
- Created and analyzed geographic trade areas around client sites using MapInfo and SPSS.
- Cleaned, prepped, and translated data into various formats from various formats.
- Worked with software developers to troubleshoot statistical model integration into desktop mapping software.
