Scott Curtis Email & Phone Number

Mansfield, Texas, United States

• Launched IQVIA’s Orchestrated Customer Experience CRM (“OCE”), salesforce.com platform, for 2 new sales teams.• Harrow CRM administrator.• Implemented samples management into the CRM for rep-carry and direct-ship sample distribution.• Manager of Business Intelligence reporting, hosted on an IQVIA cloud platform.• Key liaison for Harrow with IQVIA for CRM and Business Intelligence.

Arlington, Texas, United States

Sr. Sales Analyst/SQL Developer, AGORA DATA, Arlington, TX 05/2022 – 08/2023• Primarily acted as the CRM Administrator of Salesforce and Zoho CRM. • Facilitated the successful migration from Salesforce to Zoho CRM in October 2022. o Was complimented by ZOHO implementation consultant our conversion data was the best prepared he had ever seen in any of his prior implementations. o Conducted in-person training on new system to Commercial Operations staff• Created SQL scripts/stored procedures used by our ETL tool, Hightouch, to transfer data from a variety of Snowflake data sources into Zoho modules.• Self-taught Zoho admin, security, and configuration techniques.

Fort Worth, Texas, United States

Sr. Comm. Ops. Analyst/SQL Developer, EYEVANCE PHARMACEUTICALS, Fort Worth, TX 06/2020 – 05/2022• Supported Commercial Operations, Sales and Marketing, daily. • Utilized MS Azure SQL Server to build from the ground up data warehouse utilizing IQVIA Xponent/PlanTrak data supporting our Field Sales and Marketing teams reporting needs. This improved weekly sales reporting by more than 24 hours, compared to the IQVIA hosted database solution previously provided.• Self-taught SSIS and Visual Studio in effort to develop automations for the weekly collection and loading of the above mentioned IQVIA Xponent/PlanTrak data warehouse.• Upon Santen purchase of Eyevance Consulted and worked with over 20 IQVIA counterparts:o To implement a new IQVIA-hosted Commercial Data Warehouse.o Transition from existing Eyevance CRM to IQVIA-hosted Salesforce.com implementation.

Fort Worth

Played a pivotal role supporting Operations, Billing, and Quality departments by leveraging MS SQL Server and Tableau to create robust reporting systems. They helped forecast physician staffing needs, address operational inefficiencies and enforced established performance measurement standards. Serving as a liaison between Finance and IT, received recognition as Radiology Associates' employee of the quarter in Q2, 2018. Helped in minimizing revenue loss by resolving data issues with 3rd party collection partner, Zotec.• Created compliance reporting system to identify non-participative physicians.• Co-created a charge audit process which ensured compensation was received for actual radiology work performed.• Identified inconsistencies related to physician and non-physician billing.• Implemented productivity reporting identifying scheduling inefficiencies and productivity inconsistencies.• Successfully completed data conversion for the implementation of a new third-party hospital credentialing system in March of 2018.• Executed a risk analysis to evaluate the amount of private health information (PHI) the company stored in disparate systems in order determine the level of liability insurance needed in the event of a data breach.• Created a system to forecast and report anticipated manpower/staffing needs for the upcoming year, based on historic radiology exam volumes and expected exam volume growth. This aided Sr. management in determining future radiologist staffing needs.• Designed and built a Tableau internal Scorecard dashboard to report physician metrics important to RANT leadership.• Built a reporting system to uncover Physician Quality Reporting System (PQRS) inefficiencies which increased physician reporting compliance to Medicare (CMS) standards, maximizing revenue reimbursement.• Collaborated on Standard Report Template auditing/reporting system to ensure consistency in the manner RANT physicians dictated reports sent back to referring physicians.

Fort Worth, Texas, United States

Technical Consultant, Global Solutions/Business Analytics 4/2013 – 02/2015Promoted for successful U.S. Sales and Marketing Operations achievements, I transitioned into a pivotal role within a cross-functional team focused on crafting an innovative global CRM and Business Intelligence system for both the Surgical and Pharmaceutical divisions. My responsibilities encompassed overseeing on/offshore developers handling the BI aspect of CRM and other global initiatives. This involved diverse tasks like requirements gathering across global affiliates, system design, ETL, user acceptance testing, and conducting training sessions. I also journeyed to Sao Paulo, Brazil, for the project kick-off and training on the new CRM/BI reporting platform. As a project manager, I led the design and implementation of a Global Digital Marketing BI platform driven by data from Google Analytics. This platform became a crucial resource, furnishing essential digital marketing insights to over 500 marketing users worldwide, offering visibility into web traffic on their respective marketing pages.

Fort Worth, Texas, United States

I supported U.S. Commercial Operations by spearheading sales and marketing functions, creating vital reporting tools, and managing T-SQL for data warehousing. Overseeing a prescriber data warehouse, I served as the primary IT contact and led a team in developing a Pharma Business Intelligence Tool, nominated for a Novartis IT Excellence Award. As a technical lead, I ensured a seamless transition to a new data provider, guaranteeing smooth operations for 400+ sales representatives and managers. I directed the creation of a SharePoint sales management tool, optimizing sales call quotas. Additionally, I consulted during CIBA Vision's integration into Alcon and contributed to the ERP transition from JD Edwards to SAP as the US Sales and Operations SME.

Fort Worth, Texas, United States

Participated on a team implementing a new CRM solution to our Alcon Japan affiliate. This involved the successful implementation of language conversions from English to Kanji for various field labels within the CRM system. Traveled to Tokyo Japan twice for onsite requirements gathering as well as training of the new CRM and related BI systems. This role also included the gathering CRM system updates and the preparation of global release notes, delivered to all Alcon global affiliates each month.