Experience

MoJo Active

• United States
• Advertising Services
• 1 - 100 Employee

• Web Programmer

  • Mar 2022 - Present

  Creating and configuring API endpointsDesigning and updating ETL operations through many different technology stacksDiagnosing and troubleshooting complex data issues Creating and configuring API endpointsDesigning and updating ETL operations through many different technology stacksDiagnosing and troubleshooting complex data issues



Gregory Welteroth Advertising

• United States
• Advertising Services
• 1 - 100 Employee

• Senior Software Developer

  • Sep 2021 - Mar 2022

  Migrate Accounting SystemsTroubleshoot Hybrid Active Directory issuesCreate UAT and Dev environments for various applicationsDevelop and support changes to multiple applicationsUse C# and TSQL to create and improve ETL solutions Migrate Accounting SystemsTroubleshoot Hybrid Active Directory issuesCreate UAT and Dev environments for various applicationsDevelop and support changes to multiple applicationsUse C# and TSQL to create and improve ETL solutions



PsyTech Solutions, Inc.

• United States
• Software Development

• Software Developer

  • Feb 2015 - Sep 2021

  • Provide Level 1, 2, and 3 support for customers with a wide range of capabilities• Perform ETL operations for EHR migrations• Support and design business intelligence tools• Advise on best practices for behavioral health centers• Customize reporting• Train customers on Excel to better utilize drill-through reporting • Provide Level 1, 2, and 3 support for customers with a wide range of capabilities• Perform ETL operations for EHR migrations• Support and design business intelligence tools• Advise on best practices for behavioral health centers• Customize reporting• Train customers on Excel to better utilize drill-through reporting



Huron Consulting Group

• Analyst

  • Jul 2013 - Jun 2014

  • Distinguished myself through the creation of complex reporting and querying tools• Built reputation as logic guru• Provided first line of defense for client issues across all implementers• Solo troubleshot hundreds of complex and unique system issues under client scrutiny• Updated company-wide training materials and tools• Contributed to ticketing system replacement project• Developed implementation and QA procedures for complex customizations• Provided functional analysis of healthcare revenue cycle systems• Created and deployed system monitoring tools• Presented QA guidelines to project implementation teams• Rolled out patches, hotfixes, and updates• Improved database and system efficiency through elegant coding and deep understanding of query executions• Maintained direct contact with multiple client staff members to ensure rapid and effective system improvement• Flexed hours to provide morning and weekend support• Designed import triage systems and strategies• Consulted colleagues on advanced Excel techniques• Monitored and remedied database and log file size issues• Improved first alert systems and proposed proactive problem-solving strategies• Operated and improved work management systems• Encouraged participation in volunteer opportunities



Portland Rescue Mission

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Project Coordinator / Data Analyst

  • Feb 2013 - Jul 2013

  • Created user-friendly multi-user inventory database• Trained replacement database administrator / data analyst• Consulted for multiple data analysts in parent organization• Researched and tested replacement company message board• Researched, tested and coordinated mission’s first client database• Improved reporting through API and ODBC coding• Migrated volunteers from Raiser’s Edge to Volgistics database• Continually monitored ROI for all staff, processes, and improvements• Mitigated risk through communication, research, and planning• Created ETL systems to synchronize and centralize data across multiple platforms including SQL• Vetted and advised on new HRIS database, ensuring best ROI and longevity of system• Trouble-shot and created emergency systems for telethons and radiothons• Managed data entry, reporting, and fulfillment teams for events• Coordinated workflow and training for busy seasons by engaging stakeholders• Facilitated training for over 100 staff and residents• Provided constant resource management information to leadership as priorities changed via user stories

• Database Administrator / Data Analyst

  • Jun 2012 - Feb 2013

  • Invented process to rapidly deduplicate and import hundreds of records from outside sources• Improved algorithms and data-entry standards to further reduce duplication• Researched then created views and dashboards for instant data distribution• Automated complex reporting• Eliminated unnecessary complexity in database with a focus on change management• Enforced and updated business rules to ensure high data health• Enhanced and created stored procedures to facilitate higher-quality data access and security• Created multiple ETL systems to facilitate rapid and cost-effective data warehousing• Trained data entry staff• Provided back-up IT support to administrative office• Improved backup of SQL database• Designed and implemented automated procedures to enhance data tracking and report options• Continually adapted to shifting data and resource needs• Foresaw and addressed multiple security and data-health concerns

• Gifts Processing Manager

  • Feb 2011 - Jul 2012

  • Reduced staff budget from $150,000 to $70,000 a year• Facilitated rapid response to various departments• Reduced receipt lag from 6 weeks to 48 hours• Acted as liaison between multiple departments• Outsourced many processes to volunteers• Added OCR scanlines to all in-house documents, increasing efficiency and accuracy of gift processing• Removed dependency on costly 3rd party software• Wrote SQL queries, exports, and imports for organization• Designed adaptive Luhn algorithm for Access and Excel• Applied array formulas to facilitate massive data manipulation• Coded Excel and Access procedures to mass-format hundreds of thousands of names and addresses• Created adaptive unique key construction methods with built-in false-positive and false-negative detection• Researched and developed cost-saving bulk-mail technologies• Provided on-site support for multiple events incorporating gift processing, receipting, fulfillment, and tracking• Managed multiple projects with varying timelines and departments• Anticipated and eliminated hurdles to team achievement

• Gifts Processing Associate

  • Nov 2010 - Jan 2011

  Learned Raiser's Edge database software while improving learning center systems.



Self Employed

• Real Estate
• 1 - 100 Employee

• Licensed Math Instructor

  • Dec 2005 - Nov 2010

  Tutored and taught Mathematics at various schools and programs.Created and operated Millersville University's private math tutoring program.Trained to teach SAT prep. Tutored and taught Mathematics at various schools and programs.Created and operated Millersville University's private math tutoring program.Trained to teach SAT prep.