• Developed Tableau dashboards for revenue analysts, finance, marketing, and senior management.• Built complex ETL solutions ensuring the accuracy and usability of incoming data.• Used Alteryx, Excel, Tableau, SQL, and Salesforce to develop ad-hoc reports and data pulls for a number of stakeholders including sales, marketing, market access, finance, compliance, legal, and upper management.• Collaborated with Legal and Compliance to pull data for government audits. Ensured that data was complete and accurate in order to comply with all regulations.• Developed Alteryx and Tableau solutions to track new customer initiatives and changes in government regulations.• Led business initiatives such as getting a new SQL server in place and introducing enhanced validation practices. Wrote business plans/requirements and partnered with the right people to drive these to completion. • Created innovative solutions to audit third party vendors. One example was combining state Medicaid rules with insurance claims to produce Tableau reports with email alerts. This project was so successful that an outside vendor modified their process resulting in higher data accuracy.• Monitored import files from multiple vendor sources. Tracked issues, validated data, and partnered with other teams to resolve issues. Documented findings with specific examples and test cases.• Produced Tableau dashboards to monitor monthly service level agreements with vendors to track their progress.• Pro-actively provided recommendations to teammates based on analysis of patient and insurance data. The result was increased revenue in our department.• Develop mapping dashboards based on sales territories combining volume and revenue to assist Marketing in making alignment changes.

• Developed and deployed Tableau dashboards for multiple business areas to visualize sales and customer trends.• Analyzed and prepared data in SQL and Alteryx to create efficient data integration with Tableau.• Drove best practices and standards in developing sustainable reporting.• Provided technical support and maintenance of existing production reports and data workflows.• Validated data, workflows, and reports in order to ensure accurate information.• Served as a coach and mentor to other team members for both technical and business related questions.• Performed extensive analysis on customer survey data and develop Tableau visualizations to share the story line with management and peers. • Led a team to brainstorm and implement ideas for improving the consumption of data and reports. Outcomes include an analysis of usage statistics, improved communication with customers, and improved training.• Collaborated with peers and leadership to manage the year over year process of “freezing”, updating, and validating reports. My attention to detail often results in identifying and resolving existing or potential errors. • Worked closely with sales leadership to develop and support Salesforce reports to track and analyze sales incentives.• Served as a Roche tour guide for internal employees and outside groups. This requires the ability to clearly communicate knowledge of Roche business units, products, and history.

• Managed the process of moving several sales teams from an outdated reporting system to Tableau. Gathered requirements, facilitated customer pilot teams, validated data, and implemented training programs. • Drove continuous improvement in providing daily support across multiple business units involving analysis of data.• Wrote test cases and validated data for the integration of Ariosa data feeds into Roche to be used for reporting and compensation.• Developed ad-hoc reports using SQL, Alteryx, Tableau, and Excel. This often involved pulling large sets of complex data from multiple sources.• Was a liaison between sales leadership and report developers. Analyzed inquiries and documented specifications for enhancements and new projects.• Developed and implemented a process for monthly reconciliations with Finance.• Instructed new hire training for incoming sales reps on how their Tableau reports and data could be used to drive business. Also provided 1:1 training and refresher sessions with reps and leadership in the field.• Received the 2016 Customer Service Award based on peer and customer recognition.• Communicated with various levels within sales, management, and leadership.

• Developed and managed an e-commerce retail business (educational toys) reaching annual sales of $3 million. • Documented requirements for all IT projects, researched solutions, and executed thorough testing during implementation and system upgrades.• Analyzed the results of SQL queries to report trends in sales and make knowledgeable purchasing decisions on over 2000 products from 20 vendors. • Used data analysis and reporting to drive the strategic direction of the company while also managing daily priorities and assigning tasks to improve workflow.• Integrated an order management system (MS Access) with an e-commerce website (MS SQL Server). Transferred data between these systems multiple times per day. • Wrote SQL queries to analyze customer, sales, shipping, and inventory data in order to make knowledgeable business decisions. This included ad hoc requests in addition to maintaining a library of frequently used queries.

• Developed project requirements for an in-house system designed for Lilly's regulatory department. This system ensured compliance with FDA regulations and provided tools to manage the process of submitting clinical trial data and regulatory documentation.• Was certified in software development life cycle methodology.• Project Manager of End User Support – Led a seven person team providing technical support and business solutions to the Discovery Research labs. Implemented several training initiatives as well as a centralized technical knowledge base. This assignment required the ability to quickly troubleshoot and resolve technical issues covering a wide range of technologies. It also required versatility in working with a diverse customer base in terms of skill level and position within the company.• Facilitated several customer service initiatives to improve communication, support, and training resulting in improved customer confidence.• Managed a project to migrate an entire department from the Macintosh to Windows. I developed a streamlined process for gathering customer information, archiving data, installing new equipment, and converting files. I successfully used a number of communication methods to prepare a very reluctant customer base for the transition. The overall process served as a model for other conversions done at Lilly.• Led a task force to develop a formal career path for research scientists who bridged science and computer technology. I worked with Lilly’s HR department, multiple directors within research, and IT management resulting in a formal recognized career path blending scientific research and computer support.• Served as a consultant for new multimedia and scanning technologies, Developed training workshops for large groups of customers in addition to 1:1 consulting for specific projects.• Provided pharmaceutical sales data and reports to marketing analysts.