Amanda Herr Email & Phone Number

Published Azure databases using Visual Studio and the Azure portal Responsible for creating and maintaining Azure database Elastic PoolsMaintained 500+ Azure DatabasesDeveloped and executed a data conversion plan from Standard SQL to Azure for over 400 customersExtensive use of SQL to query and report on in house, cloud and customer hosted databasesDeployed .dacpac to update databasesManaged the use of webjobs and database sharding to ensure the fluid movement of dataAdded indexing where needed to improve database performanceAnalyzed and evaluated data to determine accuracy of reportingDeployed database using scripts in Snowflake

Acted as top tier support to the customer service departmentCollaborated with Development to report and fix bugs in softwareApplied knowledge of SQL server to provide support to customers with regards to installing SQL and recovering dataActively wrote and refined SQL Functions and Stored Procedures to optimize data querying and reporting in codeUsed queries to rebuild customers SQL Databases from other sources when no backup was availableWas responsible for deployment and management of hosted servers in AWSLead the installation, conversion and support of customers to new proprietary POS (Point of Sale) software

Helped plan and develop new cloud based point of sale software Received, logged and lead a team to determine necessity and value of incoming customer feature requestsCoordinated communications between in house and overseas developers to ensure the timely delivery of software updates Acted as liaison between Customer Service team and Development ensuring critical information was disseminated quickly and accuratelyDeveloped and maintained detailed documentation and technology standards for use by customers

Responsible for management of Customer Service teamCoordinated all day to day customer service responseManaged all open support tickets to ensure timely follow up and resolutionsProvided high level top tier support for customer issuesWorked with development to log bugs and ensure resolution of customer issues and feature requestsCollaborated with Sales to provide high level customer demos

Triaged incoming customer requests and issues in fast paced support call center environmentTroubleshot software, data and networking associated with proprietary applications; including Point of Sale, online payment porthole, National School Lunch Program Tracking, Online and Installed Admin PortalSetup and troubleshooting customer hardware including gun scanners, RFID readers, pin pads, biometric scanners and scalesProvided timely follow up and resolution to customer issues and requestsCompleted data file importsLogged accurate tickets and detailed resolutions in a timely mannerCreated and ran SQL Queries to extract customer requested data from databasesProvided Onboarding services and Training for new customers

Wrote extensive reports using Human Resources & Payroll data for various departments throughout the agencyEntered and extracted data from Ultipro systemPerformed general Human Resource dutiesWrote, maintained and distributed monthly reportsInterviewing and screening potential candidates

Evaluated, recommended and implemented appropriate solutions for departmental system and procedural shortfallsUsed VB.net to develop, implement and maintain survey processing software; used in house to enter, store, translate and convey data back to the customerDeveloped and maintained databases of customer data using Microsoft Access and SQL ServerUsed VB.net to create a program for the sequential numbering and tracking of a classified product and assisted with the facilitation, evaluation and monitoring of the contractWas instrumental in company software conversion from VB 6 to VB.netUsed Microsoft Excel and VB 6 to develop a program that created and emailed a daily report throughout the companyUsed Crystal Reports on a daily basis to create customized reports for efficient database accessibility and analysis Provided end user with detailed documentation for effective use of personally developed software