Thomas Dew Email & Phone Number

Chicago, Il, Us

New York, Ny, Us

New York, Ny, Us

• Created SQL model to measure product consumption per customer across our customer base, providing us new insight into customer usage• Utilized historical consumption measures to set a consumption target for our top 30 largest customers, which was used to determine variable compensation for our newly established Customer Success Engineering team• Built and maintained numerous dashboards in Grafana utilizing SQL to assist in reporting on KPIs for our Solutions Engineer, Technical Support, Customer Success, and Professional Services teams• Assisted in implementation of Planhat as a data expert, mainly driving the creation of new datasets for consumption specifically within the system

Boston, Massachusetts, Us

• Built scripts utilizing Workato to maintain alignment between 10,000+ Customer and their subscription renewal opportunities for the following year saving the operations team 5+ hours in manual work per week• Analyzed our 2022 sales data consisting of ~150,000 individual sales to determine if team level customer retention targets for Sales users in 2023 are reasonable• Construct reporting tools in Tableau, NetSuite, and Salesforce to maintain system cleanliness and facilitate sales users in their workflows• Assist Customer Success Managers in understanding the forecast data for their territory and help identify and correct issues in data streams that lead to inconsistencies• Day to day usage of Tableau, Power BI, NetSuite, Salesforce, UiPath, Workato, and VBA to solve operational issues

Verona, Wi, Us

• Collaborated weekly with 30 Hospital Billing IT analysts across four organizations• Tailored communication styles to fit the preferences and technical competency of the audience• Solved approximately 20 issues and spent between 5 and 15 hours on each organization weekly• Grew as an expert in System Automation, contributed to spreading knowledge by authoring 5 internal wikis on building and troubleshooting techniques• Assisted in analyzing data from automation scripts in client systems to determine areas for improvement, joined calls to communicate ideas to clients leading to the reduction of script run times by 2+ hours per day per client• Developed searches in MUMPS to assist in troubleshooting and discovering root causes of system errors• Certified in Hospital Billing

Boston, Ma, Us

• Instrumental in the optimization of reporting systems, reducing necessary time to complete Management and Board Reports by 10+ hours per month• Created 5+ reports for multiple departments, including multiple variance and earnings reports• Assisted with paperwork for swap deals and sat in on calls for completion and confirmation of the deals• Examined reports for accuracy, and used creative problem solving to determine how to make reports currently in development display accurate information• Utilized Excel (Vlookups, Hlookups, conditional statements, etc.) and Tagetik Management Solutions software to analyze data on Earnings and Expenses

Belmont, Ma, Us

• Bid 6 projects including two $10MM+ jobs, one of which reached the final round of bidding• Employed analytical and logical thinking to construct the process of the job in my mind to get an accurate timeline for the project, ensuring accurate estimates• Utilized cost schedules and interacted directly with suppliers to accurately estimate the costs of labor and materials• Examined engineering drawings and conducted site visits to plan how a job would be executed on a specific site• Constructed Models in Microsoft Excel which speed up the pricing process by approximately an hour per job