Database Administrator

• Apr 2022 - Present

Azure DBA and Sql Developer at RPM

• May 2018 - Apr 2022

- Lead the development team on best practices related to database design- Assist developers with complex query optimizations, performance tuning, and refactoring stored procedures and triggers- Table index optimization, removing unused/redundant indexes, and curating query-specific indexes as needed for optimal performance- Create and schedule database maintenance tasks, index optimizations, archival scripts, user log table purges, and Elastic Sql jobs- Architecting database tables, triggers, table valued functions, procedures, and views- Generate recurring reports and ad hoc queries for all levels of the business for analysis and data exploration- Investigating, troubleshooting, and resolving data issues with third party vendors and proprietary software- Established naming conventions and best practices- Management of user permissions for applications and direct-query users including role-based access- Organization of database objects into intuitive schemas - Enabled cross-database querying using Elastic Query- Develop, deploy, and maintain living documents with Excel, Power Query, and M Language which are used by operations and accounting where real-time data is needed on demand- Service interruption triage team including emergency availability for troubleshooting, root cause analysis, resolution, and system restoration Show less

Business Intelligence and Analysis

• Jan 2018 - May 2018

- Domo power user, responsible for nearly 1000 card catalogue and each underlying dataset- Administer Domo ETL operations, data cleaning, dataset joining, database, and Salesforce connectors- Managing visualizations, report creation, lag and lead measures, and KPIs for all levels of organization, from executive to accounting- Ensured departmental and operational success through data availability and management visibility

Accounts Receivable Specialist, Team Lead, and Manager

• Aug 2015 - Jan 2018

Began as the sole accounts receivable specialist when RPM was a young, 45 employee organization. As the company tripled in size, I transitioned into accounts receivable team lead and then manager before advancing into Business Intelligence and Junior SQL Server Administrator responsibilities. Accounts Receivable duties include- Collections calls, emails, and efforts for the organization's entire customer portfolio- Communicating with management and customer sales teams regarding past due accounts, collections disputes, and customer non-payments- Reporting payment history, credit worthiness, and aging reports- Appending invoices with additional customer-required information (purchase order numbers, cost itemization, etc.)- Issuing account credits and write-offs- Receiving payments from customers and applying payments to accounts- Cash application reconciliations- Exporting customer invoice and vendor bill data from the TMS and importing into the accounting system Show less

Accounts Receivable Specialist

• Jun 2013 - Jul 2015

-Initiate contact with customer regarding past-due freight bills -Demonstrate consistent follow-up routines and resolution abilities that are results oriented -Expedite collection process via ACH, EFT, or EDI setup -Apply customer's payment by matching remittance details with reference numbers -Updating and maintaining aging statements on customer accounts -Build rapport with customers, agents, and contractors through diligent customer service -Resolving calculation errors, over billings, address changes, duplicate billings, and other invoicing issues Show less

Private Skills Trainer

• Apr 2012 - Jun 2013

-Assess student’s ability in every lesson -Identify problem areas in student’s ability -Train student with knowledge, learned experience, and exercises -Create drills that target underdeveloped skills -Communicate progress to parents -Coordinate schedules with multiple parties -Assess student’s ability in every lesson -Identify problem areas in student’s ability -Train student with knowledge, learned experience, and exercises -Create drills that target underdeveloped skills -Communicate progress to parents -Coordinate schedules with multiple parties

Painter's Apprentice

• Sep 2011 - Jun 2013

-Prepare cars to be painted by isolating the working area, sanding, and taping -Identifying and preventing paint overspray from unwanted surfaces during paint process -Inspect and remove minute blemishes after paint process -Deliver a finished product for management inspection and approval -Prepare cars to be painted by isolating the working area, sanding, and taping -Identifying and preventing paint overspray from unwanted surfaces during paint process -Inspect and remove minute blemishes after paint process -Deliver a finished product for management inspection and approval