Jonathan Drought Email & Phone Number

Austin, Tx, Us

Tucson, Arizona, Us

Responsibilities include programming, debugging, database administration and projectmanagement.Programming/Project Management - Daily standups and grooming sessions on client tickets. - Created API solution for a client to verify user and credentials for login. - Created API solution to merge event information into CRM for client. - Created API solution between client information to update contacts and accounts to allow access to client site - Fixed various bugs from client and in house ticketsDatabase Administration - Created and ran store procedure that will aggregate between multiple clients. - Create/restore backups - Migrate client data into CRM environment - Mapped data from incoming client information to CRM - Wrote migration scripts to import data - Made database backup for client to test data

Austin, Texas, Us

Responsibilities include programming, debugging, database administration and project management.Programming/Project Management - Managed third party to create a custom search engine based on SOLR. - Created user dashboard with historical purchase information, training information, employee administration tools, product pricing information and product bookmarks. Using data from in-house DB2 erp system. - Added WYSIWYG for marketing to add content to microsites. Including documents, images, html links, navigation, and personalized pages. - Created new library to implement product video uploads by Vimeo API 3.0. - Implemented an API library to communicate between in-house systems, Brainier Solutions' LMS and Avatax to add classes, maintain user transcripts and charge users for course purchases. - Migrated data from in-house custom DB2 ERP system to Microsoft Dynamics 365. - Used Microsoft Dynamics 365 API to get and transform commerce data into csv files for IBM WebSphere. - Created API call for Salesforce to check authentication of user for SSO on to multiple webpages. - User Acceptance Testing on IBM WebSphere.Upgrades - Redsigned backend of websites to use CFWheels Framework. - Worked with business, graphic designers and end users to implement to redesign of site. - Upgraded database from MS SQL Server 2012 to MS SQL Server 2016. - Upgraded database from MS SQL Server 2016 to MS Azure SQL.Database Administraion - Added views, security logins, stored procedures, table columns, backups and restores. - Implemented changes to normalize data.

Responsibilities include programming, database administration and project management.Programming/Project Management - Company Intranet - Improved load time and navigation. - Added ability for staff to upload help documents for end users. - Automated a client conflict system for clearing client for attorneys to avoid conflict of interests. - Automated expense reporting to calculate and report billing expenses for travel and business. - Email Management System (Mimecast) - Designed and setup the stationary items that were automatically added to outgoing emails. - Administered gateway polices for outgoing mail. - Consulted a third party to create company's website by providing database information and design functionality of the site. - Accounting Software Administration (Elite) - Rebranded and customized the accounting reports. - Automated the end of the month accounting reports. - Maintained add-ons: WebView, Paperless Proforma, Image Connect. Database Administration - Upgraded MS SQL Server 2000 to MS SQL Server 2008 R2. - Reworked Server Integration Services and Stored Procedures. - Set standards and procedures for database and table creation. - Normalized the data and brought them up to set standards.

Responsibilities include programming and project management.Programming/Project Management - Online Membership Dashboard - Allowed members to register and pay for meetings/events/convention attendance online. - Provided administration back end for Meeting Planning Department. - Coordinated with TREPAC to get proper investment data shown for each association and individual member - Association Website - Created search engine for property, Realtor, and users. - Designed a feature for users to save properties they were interested in to their account. - Redesigned the interface of user setting pages. - Decreased load and response times. - Programmed and designed iPhone App that contained information for yearly conventions. - Custom CMS - Used to create and maintain 24 managed board websites. - Websites were used to add recurring event dates, links, member information and newsletters. - Provided instruction to staff on how to use CMS.Database Administration - Designed backend database tables. - Created and ran store procedures for data input and clean up.

Responsibilities include application development, database administration, network administration, computer building and maintenance.Programming Projects - Created a tool to estimate steel structural jobs for client to submit bids. - Created e-mail generation tool to request information from customers about current projects in a uniform design. - Created time card application for keeping track and reporting an individuals time spent on a job.Computer Building/Maintenance - Ordered and built computers & servers to meet the clients needs. - Maintained computers and servers by making sure security programs and operating system were up to date. Network Administration - Setup wireless and wired networks in office.

San Marcos, Tx, Us

Responsibilities include maintained campus network and training.Maintained Campus NetworksServer monitoring. Monitored multiple servers in on campus server farm for errors and trouble shooting. (Nagios).Loaded and ran nightly backup tapes. (UNIX)Setup and testing of servers. Installed new server blades. Worked with team to test battery backup raid and generator backup systems.ManagementSystem training. Trained others in the use of system, backup, and emergency procedures. (UNIX)Supervised employees. Supervised on shift employees making sure all safety regulations and duties were followed.

Managed a 15 member team that evaluated music from promoters for the station. Coordinated artist interviews and radio promotions with music label representatives. Reviewed data each week in order to correlate music rotation to listeners. Programmed the daily music rotation for on air play. Worked in cross functional team to promote the radio station around the community and college campus.

Mba

Bba, Finance