Anna Hull Email & Phone Number

El Cajon, CA, US

Navasota, Texas, US

• Write custom SQL queries to gather tech support insights from the HelpSpot database for use in weekly, monthly, and yearly reports for management using Excel, VBA, and Power Query.
• Act as the point person and database administrator of the tracking system for technical support inquiries.
• Create complex SQL queries to collect data from the Sentinel EMS (MS SQL Server), SAP SQL, HFDB (PostgreSQL) databases for reporting on licensing statistics.
• Provide technical support for software installation, deployment, security, and licensing inquiries.
• Develop technical documentation, webinars, tutorials, and training for end-users on installation/security issues.

Indianapolis, Indiana, US

• Planning, preparation, and beginning setup for internal MediaWiki site for Data Visualizations using SQL and R.

Foothill Ranch, California, US

• Designed and programmed a tracking system for True Fresh HPP Shipping and Receiving data using Podio, SQL Server 2016, Simego, Power Query, VBA, custom Excel formulas and complex T-SQL triggers and functions.
• Created scripts for iMacros using Excel formulas and functions to generate 100K+ lines of code to automatically add and manage users, workflows, managers for 1200+ properties for an AvidXchange Yardi Portal.
• Created an integrated “All-in-One” spreadsheet to calculate Service Commissions and Product Commissions for the Polished Perfect accounting team, replacing 30+ spreadsheets. Automated all the manual data.
• Wrote PowerShell scripts for the Intermedia Hostpilot PowerShell Utility to get information on Email Distribution List Membership for all entities and save this directly into a CSV file.
• Created several custom PDF forms using JavaScript for field validation, calculations, email generation, etc..
• Created a custom Excel Spreadsheet to write Customer and Invoice data directly from Excel to QuickBooks using VBA and the VBA functions provided by the QODBC driver. Also used Power Query to transform the data to ready.

• Freelance Web Development (and more!) including:
• Website Development for Wordpress
• Resume Writing
• Personalized Computer Literacy and Instruction

Orange, CA, US

• Created SSRS-type reports and custom queries, views, functions and stored procedures in Microsoft SQL Server 2012 to manage security for users/groups/roles, verify OCR data capture for scanned forms, and track.
• Created custom Excel spreadsheets that displayed SQL views on a SharePoint website for management review.
• Developed advanced eForms in Form Designer using JavaScript for data validation.
• Optimized TeleForm forms for OCR data capture of critical enrollment data.
• Customized Liquid Office workflows which involve heavy JavaScript validation.
• Created technical writing in the form of a developer MediaWiki with SQL code and project data, using markup.

Rolling Meadows, IL, US

• Gallagher Insurance acquired e3 Financial.
• Set up, implemented, and updated online enrollment systems for both open enrollment and ongoing enrollment.
• Cleaned up and formatted employee data/census for import/export into various online enrollment systems such as ADP/Employease, ADP/Workforce, PlanSource, bswift, Benetrac, and Paycom.
• Created benefit portal websites, customized PlanSource CMS CSS, managed domain name registrations, updated content, and created site utilization reports for 30+ clients.
• Created Excel forms, spreadsheets for data analysis, and Adobe Acrobat PDF forms.
• Wrote technical documentation in the form of user guides for fellow employees on ADP/Employease, PlanSource, and other online benefits enrollment systems.

Los Angeles, CA, US

• Coordinated Cal Grant EDI feed and troubleshooting of student errors related to the feed, and reconciled the USC Cal Grant account for $25 million dollars.
• Adjusted financial aid packages to accommodate scholarships and Cal Grants for students.
• Chose scholarship recipients for Mabel Wilson Richards Foundation and the John Randolph and Dora Haynes Foundation (total funds $130k).
• Processed scholarship forms for students, and verified their GPA and enrollment status for agencies.

Certificate Of Achievement, Web Design

M.Ed., Education

B.A., Psychology