Jake Wigal Email & Phone Number

San Diego, Ca, Us

San Diego, California, United States

Developed a database and full stack application to support data-driven decision making and collaboration on technical projects related to addressing climate change- Led development of database and serverless deployment infrastructure using AWS resources including Cognito for authentication, DynamoDB for database management, and API Gateway endpoints for scalable efficient backend services- Automated cleaning and ingestion of internal data to cloud database using Python-based AWS Lambda functions- Implemented cloud-based CI/CD pipeline using AWS CloudFormation and CodeDeploy, reducing deployment times and system downtime- Designed and implemented full-text search, filters, and visualizations of data from database to enhance usability and accessibility for stakeholders

Monterey, Ca

Led software development, data analysis, and instruction for federal government sponsors-Designed and published an operational model using Pandas, SciPy, and Pyomo to analyze Oahu’s road network and emergency food demand that generated findings and visualizations (Plotly, Leaflet) incorporated into the State of Hawaii’s Distribution Management Plan -Built physical terrain-based model leveraging gdal, rasterio, and multiprocessing to accurately predict gaps in cell phone network coverage areas in the US Virgin Islands, enabled strategic infrastructure planning and investment-Led interagency working group to develop authoritative data and data cleaning processes that provided 50 GB of accurate data fundamental to Hurricane Irma and Maria recovery infrastructure construction projects-Completed training and projects on Python and R ML frameworks (NLTK, randomForest, Keras, TensorFlow)-Developed cloud-deployed software (Angular/AWS/Jenkins) for federal projects exceeding 1M in funding-Guided master’s students through hands-on exercises in Python, Git, and AWS as guest lecturer from 2021-2023

Developed full stack application to automate synthetic image generation for testing computer vision APIs-Developed Query History and Image Hosting REST API backend services allowing users to log and retrieve past requests using Node.js, Express, AWS S3, and RDS PostgreSQL database-Established authentication library using bcrypt with JWT authentication to manage user administration-Produced a ~30% reduction in AWS EC2 deployment times by leading transition to Docker based CI/CD pipeline using Github Actions and AWS CodeDeploy-Implemented React web interface to enable users to query from and send to user defined and OpenAI APIs-Integrated Google analytics to monitor user behavior and track KPIs to establish feature roadmap-Built supertest and Jest integration tests for REST API and user administration, reducing testing time by 40%

Orange County, California Area

Analyzed policy and produced data visualization for City leadership-Prepared detailed maps, charts, and reports for the City Council on transportation initiatives including Traffic Signal Synchronization and Walk to School Day-Researched and evaluated city polices on shared mobility devices, film permit process, and other areas, delivering internal reports to Mayor and Chief of Staff to support policy recommendations-Identified grant-eligible city facilities, resulting in active transportation infrastructure installed at 20+ locations

Austin, Texas Area

-Prepared and maintained written records for attorneys-Provided customer service while interacting with prospective clients-Operated office equipment and standard business software

Austin, Texas Area

-Compiled and analyzed census data using pandas and geospatial python packages-Reported data to PI revealing associations of voter demographics with district attorney political lean

-Created promotional flyers and press releases to support degree programs and faculty research-Organized information on Communications database-Produced video content and stills for use by public relations staff

-Wrote press releases and condensed manuscripts into brief summaries -Pitched to media and event coordinators-Researched media and event target lists

Austin, Texas Area

-Created and designed musician resource directory for client use-Scheduled artists for career guidance consultations-Designed posters and pamphlets using Adobe Suite applications-Used Excel to collect and organize data from artists and events-Greeted and educated event attendees about purpose of AMF-Helped edit press releases

Newport Beach, Ca

Managed patient database and contributed to publication in child and adult ADHD studies-Managed a comprehensive database of >700 study subjects that included Demographics and Patient Populations/characteristics that supported recruitment and retention across 12 clinical trials-Defined descriptors and keywords for identifying patient characteristics and provided subject mental health history summaries for clinical review-Coded patient response transcripts on long term clinical outcomes related to addictive behavior, which contributed to the 2018 publication: “The Qualitative Interview Study of Persistent and Nonpersistent Substance Use in the MTA: Sample Characteristics, Frequent Use, and Reasons for Use”-Trained fellow research associates on office procedures including clinical, diagnostic, and outcome assessment data measurement and database entry

Master Of Science - Ms, Operations Research

Bachelor Of Arts (B.A.), Urban Studies/Affairs