teresa atwood

Implemented an already existing collection of datasheets (Excel 2007) into a widely connected Access 2007 database using macros, forms, queries, visual basic, etc. The integration of different types of information into one compact format and use of the different functionalities of Microsoft Access to analyze, sort and deliver information to the end users was an important step into making the existing process much more efficient. I also made sure that it was incredibly user-friendly for those who would be using it for data analysis, as well as those manipulating the data with updates/revisions. Also became familiar with market analysis and how numbers should be shown for interpretation.

 Develop and run recurring weekly reporting of the Away From Home channel’s $300M+ Annual Operating Plan attainment to focus Sales leadership attention on performance improvement opportunities  Develop and maintain internal database based on OLAP cube highlighting key sales metrics across hundreds of SKUs, enabling self-serve business intelligence among sales teams into customer/ship-to location trends  Partner with Master Data Management/Business Intelligence to maintain data integrity across multiple systems by SKUs and customers in SQL OLAP cube; enabled deep dive go to market analysis by strategy team  Lead indirect data alignment with 3rd party provider and internal MDM to ensure visibility at the territory and sales rep level in reporting, which is used to calculate sales team yearly compensation  Coded and implemented VBA for cross-functional reporting that reduced work time by ~15% per file

* Customer Master Data – North America and Canada. * Create and maintain customer information in two SAP Kernels for Philips Healthcare accounts in North America and Canada for both PCMS (Patient Care and Monitoring Systems) and Imaging / Ultrasound Businesses. * Work with Commercial Operations (Order Processing, Quoting, Credit, Collections, etc.), Finance, DEMO, Commercial Contracts, Healthcare Informatics, Sales, and others to ensure customer account accuracy. * On top of daily responsibilities I created a reporting system for monthly metrics for the Customer Master Department, which had never been reported on prior. Microsoft Excel was the environment of the reporting workbook I created that calculated multiple different metrics off of a single data pull from our queue tool, SOLAAR. The reports were reported to the VP of Commercial Operations, and are still being utilized to this day. * Other projects during this role include: * eStore Metrics * Commercial Contracts Workflow Analysis Tool

* Commercial Contracts Business Analyst for multiple GPO accounts across North America, as well as the South and Mid America zones for local agreements (non-GPO). Supporting the Patient Care and Monitoring Systems side of the business (6 product lines). * Scheduled reporting to the GPOs for Admin Fee Rebate payments, monthly and quarterly depending on contract language. * Scheduled quarterly updates to price files per GPO. * Work with Contract Managers and Contract Support Specialists to see agreement pricing from inception to expiration. Includes RFI/RFPs, Execution, Implementation in SAP, and Updates (both paper contracts and SAP). * Work with multiple departments/roles within Philips – Order Processing, Quoting, Customer Master, Government Contracts, Sales, Proposal Center, Finance, Account Managers, GPO Relationship Managers, Director of Commercial Contracts, and Senior Managers. * Advanced Excel work and knowledge – Pivots, formulas (extensive), Macros, VBA, Charts/Graphs * Attended two-day Kaizen Training * Attended two-day Daily Communication Training * Lean Six Sigma

Dual enrollment: My senior year of high school was spent taking a full course load at the University of Massachusetts Lowell, while remaining enrolled with the high school.