Drew Baumgartner Email & Phone Number

Angola, Indiana, Us

Configure SQL Server Agent Jobs to send daily inventory advice on 30,000 SKUs to 10+ catalog accountsImplemented and support Power BI and build reports across warehousing, sales, procurement, and production for 40+ usersDesign and deploy 50+ reports for SQL Server Reporting Services (SSRS)Build SQL Server Integration Services (SSIS) packages to handle ETL tasks between WMS and ERPAutomate daily order entry tasks saving 1,000 hours of manual data entry per yearOptimized weekly sales report query and tuned index usage saving 3 hours of CPU time per weekConsume APIs to integrate data from 3rd party software into ERP saving 250 hours per yearGather software requirements to replace ERP that supports 300+ usersConfigure and deploy Zebra mobile computers for warehouse team of 20+ usersAssist with help desk requests when necessary

I currently analyze the business and find ways to utilize technology to improve daily workflow for all areas of the business including sales, production, and office work.Implemented Google Apps for Business now known as G Suite and continue to manage the platform as administrator.Manage our third party CRM and coordinated the deployment of company tablets for in-field access of CRM.Manage purchasing and acquisition of new hardware and software for all locations.Collaborated with the CFO and regional sales manager for determining key reports within CRM.Worked with regional sales manager to gather requirements for a new calling center.Ran and terminated CAT-6 cable through office to support VoIP calling center.Trained existing employees and new hires on CRM, Google Apps, and calling center software.

Columbia City, In, Us

Gathered information for new feature requests for the in-house MES software platformAnalyzed and updated existing VB.NET codeWrote new code using C#.NET to support object-oriented designModified existing and created new stored procedures in SQL to support new feature requestsIntegrated stored procedures in VB.NET and C#.NET codeUsed Team Foundation Server to check files in and out between team members

Entered production, service calls, and sales for the local officePrinted and mailed special offers, statements, and invoices for the local officeProcessed payments for all branch locationsFielded customer support phone callsProcessed company new hires into customer management software and created login credentials

Provided excellent customer service and carried extensive product knowledgeStocked merchandise efficiently and reduced shrink by following security policiesOperated cash register promptly and accuratelyInstalled product displays, bracket-mounted TVs, and set-up demonstration laptops