Erica Carnathan, Mscs Email & Phone Number

Nashville, Tennessee, United States

A gardening gift box company providing custom garden themed gift boxes for any occasion. Great for employee and customer appreciation. Are you in real estate? These would make a great gift for you new homebuyer. • Manage and execute audience building, social media, and email marketing campaigns for funnel building and brand visibility• Technology stack design and implementation with automated solution integration managing social media advertising leads and email CRM campaign workflows using Meta, Zappia, Klaviyo and Wix• Landing page and email lead magnet strategy management and digital asset design for warm audience conversion• Logo and product packaging design and development• Manage market research and niche targeting execution• Inventory management, packaging and shipping system management

LEAP is a private exclusive network for members of the #LeapAcademy Program: executive leaders, entrepreneurs, and high achievers from around the world who inspire and drive growth and impact on themselves, their work and their communities.

I drive the execution of commercial transformation initiatives by partnering with department leaders to understand their business/data challenges and provide solutions quickly with low-expense options for high impact and ROI. I execute by leading the data science team to deliver bespoke and targeted data pipelines, process tracking applications, surgical instrument demand planning tools, sales performance KPI reporting, sales forecasting, market intelligence reporting, in-house CRMs, contract execution applications, contract compliance reporting, marketing campaign reporting, product launch dashboards, pricing request process tracking, and a cross-divisional contract deal rebate execution tools. Key Highlights:I serve as the principal architect of a custom in-house surgical instrument and implant logistics system that provides demand planning, shipment tracking, manufacturing demand signals, and ROI reporting metrics expected to contribute to an estimated $200 million in cost savings per year by 2025.Designed and led the deployment and change management of an internal robotics financial deal request process tracking tool that reduced standard contract preparation time from 60 to 2.5 days contributing to a 68% sales increase within the first 9 months of deployment

Memphis, Tennessee, United States

Established the first commercial analytics team in Costa Rica (later transitioned to the first data science team in commercial) to design and develop automated dashboards and application solutions. Created team processes and implemented Jira Agile project management tools as our development process framework. Responsible for implementing the first US Joint Reconstruction sales leadership stack rankings and standardized quarterly internal business reviews for sales leaders. Consolidated siloed internal and external reporting data marts by leading a Sas Institute SAS Viya (hosted internally on AWS) server implementation and the integration with Redshift, MySQL, and Azure SQL data warehouses.Key Highlights:Pioneered a commercial and operations reporting ecosystem by designing and leading the integration of SAS Viya, Azure SQL Server, MS Power BI workspaces, MS Power Apps, MS Power Automate, Redshift, Move Medical (MySQL)Created the concept and led the team in executing a “Sales Leadership Toolkit” that provides reporting needed to lead and run the day-to-day operations of the sales leaders' organizations.Led the automation of KPI reporting, product launch reporting, daily sales email with percent to quota attainment, customer rebate accruals, profitability, and open order reporting. Deployed several data pipelines to capture qualitative information from the sales field on new and lost customers, surgeon NPI to internal ID mappings, and sales rep special training programs.

During my first transitional role from pricing to the commercial organization, I worked directly with the Global SVP of Marketing and US Recon Sales SVP to serve as the reporting and process optimization SME that led initiatives to create new product hierarchies for product reporting and developed custom applications to support new processes or collect sales field intel.Key Highlights:Principal architect of the first scalable instrument logistics management system.Led new product hierarchy implementation for the US Joint Reconstruction business to support portfolio management decisionsDeveloped a tracking tool to monitor the progress of three specialized sales rep training coursesDesigned an enterprise-level customer insights dashboard executed by the enterprise BI team that segmented customers based on sales volume with visualizations of surgeon volume versus largest growthProvided DTC market analytics to support campaign decision-making based on third-party surgeon claims data

Greater Memphis Area

Key Highlights:Developed a contract rebate payment tool to provide sales details with rebate rates for the Wound Care business unit integrated with Model N data used by the contract and pricing team to execute rebate and admin fee paymentsInterpreted GPO and IDN contracts to generate the rebate and admin fee payments and managed the execution of an annual $3 million per year in rebate and admin fee payments for US OrthopedicsRepresented the Orthopedic business unit as a user acceptance tester for the global deployment of an integrated SAP ERP and new data warehouse on a Cognos platform.Executed pricing increase initiatives for the Orthopedic division that assessed current contracts and opportunities for price increases.Provided national contract performance reporting to executives on IDN and GPO contract performance

Key Highlights:Provided monthly explanations for US Ortho, Sports Med, and Wound sales performance driven by price, volume, or mix fluctuations to US sales, marketing, and finance executivesDesigned and executed ambulatory surgery center pricing evaluation and internal request functionality integrated into the US sales pricing request and processing toolInterpreted GPO and IDN contracts to generate the rebate and admin fee payments and managed the execution of an annual $3 million per year in rebate and admin fee payments for US OrthopedicsPrincipal developer responsible for enhancing and maintaining the US sales field pricing request process tool.Developed an in-house pricing evaluation and request tool for Trauma products that streamlined the request process and provided a defined view of discounts within the larger business lines

Bartlett,Tn

System Administrator for Allscripts Homecare application, Point Click Care, and American Health Tech. All systems are electronic medical record systems implemented at 50 skilled nursing facilities across the U.S.Key Highlights:Led reconfiguration of the Ark Hospice Allscripts Homecare billing and clinical modulesManaged system updates for new releases for Allscripts Homecare and change management to the rest of the organization. Validated new release versions complied with the latest final rule from the OIG.Designed a role based security model for clinical and administrative users guided by regulatory requirements and transitioned current users from the user based security model.Authored the project charter for Allscripts system reconfiguration, managed stakeholder requirements and executed the changes

Greater Memphis Area

Prescription drug data analysis and patient dashboard developmentChiropractic billing/clinical data analysis, practice process optimization, HIPAA compliance and revenue cycle management consulting.Zounds hearing aid device market intelligence reporting and campaign strategy consulting.Commercial construction - billing and dispatch management system configuration

Frisco, Texas, United States

Specialized in designing solutions to optimize Pharmacy Benefit Management reporting tools, and dynamic dashboards used by client management, account managers, and clinical pharmacists. Key Highlights:Spearheaded the creation of a best-in-class Microstrategy in advanced analytics client management enterprise dashboard. The two-year initiative started by designing and piloting client quarterly business review reports using only Excel and PowerPoint scaled by VBA programming. The pilot gave me the information needed from a client perspective to partner with the VP of Client Management, VP of Actuarial Services, IT, and Data Warehouse leadership to design a dynamic dashboard blueprint that included the dashboard layout, data visualizations, KPIs, attributes, and metrics."The innovative dashboard capitalizes on MicroStrategy's powerful analytical capabilities, employing more than 1,000 metrics, yet it delivers critical business intelligence in a clear, understandable format. The MicroStrategy-based implementation involves extensive use of analytical capabilities, including advanced statistical analyses, data mining, and predictive analytics." Microstrategy

Frisco, Texas, United States

Client-facing business analyst in the client management organization responsible for reporting accuracy on pharmacy benefits spend to clients, providing in-person or virtual training classes to clients on the OptumRx reporting system, providing support to clinical pharmacists data analytics requests for formulary initiatives, data analytics SME for new client implementations, and client management partner to the data warehouse team.Key Highlights:Designed quarterly and annual business review presentations to external clients with metrics and visuals to explain the key drivers of an increase in costs and benchmarks to compare their spending to a similar book of businessLed the optimization of the creation of 100+ client quarterly business reviews by partnering with actuarial services to enhance the tool with VBA programming. This initiative reduced the business review preparation process from 2 weeks to a few hours. Led the deployment of the new quarterly business review creation process across multiple client management teams while dually collecting information from the execution process, which also served as the pilot for a future initiative to automate using Microstrategy dashboard technology.Developed a small-scale copay modeling tool that provided cause and effect analyses of varying copay model designs for external clients.

Memphis, Tn

• U.S. Spinal and Biologics Marketing Research • Competitive Intelligence Research• ICD-9 Medical Claims Database Administration• Collaborated with Market Specialist to develop and implement an internal market share and brand share report used for strategic planning.

B.S., Business Administration And Management, Marketing

Activities and Societies: Alpha Chi Honor Society

Master Of Science - Ms, Computer Science

Concentration in Data Science