Evan Symank Email & Phone Number

Texas, United States

Dallas-Fort Worth Metroplex

Company/Organization: Omnicell / PSG / ICSPosition/Title: Business Solutions Engineer / Analyst Manager / Reporting Analyst (Omnicell / PSG)Location: Plano, TXDates of Employment: 2020 to 2022Description:★ Retained and promoted through successive changes in company ownership.★ Builds customized applications, creates stored procedures and SQL packages, and develops ad-hoc reports using SQL Server Reporting Services (SSRS) in response to requests from clients and stakeholders in Business Development.★ Identified lost revenue opportunities for health system clients by creating a Fuzzy Matching application that identified potential variations in the patient names of hospital and pharmacy systems.★ Used Microsoft Access and SQL to develop custom applications that enable non-SQL users to interact with information stored in databases. Additionally, joined with a colleague to implement Power BI to enable non-technical employees to view product information and data.★ Developed SQL packages in order to validate or audit TPA accumulation processing.★ Worked with a Python developer to create a geo-mapping tool.★ Recruited and supervised two analysts on a two-year project to migrate an internal application. Trained the analysts in pharmacy and hospital workflows, the 340B program, system requirements, and the audit platform.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT OMNICELL / PSG / ICS(NASDAQOMCL) Omnicell provides automation and business analytics software solutions for the healthcare industry

Company/Organization: Omnicell / PSG / ICSPosition/Title: Business Solutions Engineer / Analyst Manager (Omnicell / PSG)Location: Plano, TXDates of Employment: 2019 to 2020Description:★ Retained and promoted through successive changes in company ownership.★ Builds customized applications, creates stored procedures and SQL packages, and develops ad-hoc reports using SQL Server Reporting Services (SSRS) in response to requests from clients and stakeholders in Business Development.★ Identified lost revenue opportunities for health system clients by creating a Fuzzy Matching application that identified potential variations in the patient names of hospital and pharmacy systems.★ Used Microsoft Access and SQL to develop custom applications that enable non-SQL users to interact with information stored in databases. Additionally, joined with a colleague to implement Power BI to enable non-technical employees to view product information and data.★ Developed SQL packages in order to validate or audit TPA accumulation processing.★ Worked with a Python developer to create a geo-mapping tool.★ Recruited and supervised two analysts on a two-year project to migrate an internal application. Trained the analysts in pharmacy and hospital workflows, the 340B program, system requirements, and the audit platform.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT OMNICELL / PSG / ICSOmnicell provides innovative pharmacy and medication management solutions for healthcare professionals and health systems. The company acquired the 340B Link business of Pharmaceutical Strategies Group (PSG) in 2020. The 340B Prime Vendor Program is issued by the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program that provides access to discounted medication.

Company/Organization: Omnicell / PSG / ICSPosition/Title: Business Solutions Engineer / Analyst Manager (Omnicell / PSG)Location: Plano, TXDates of Employment: 2019 to 2020Description:★ Retained and promoted through successive changes in company ownership.★ Builds customized applications, creates stored procedures and SQL packages, and develops ad-hoc reports using SQL Server Reporting Services (SSRS) in response to requests from clients and stakeholders in Business Development.★ Identified lost revenue opportunities for health system clients by creating a Fuzzy Matching application that identified potential variations in the patient names of hospital and pharmacy systems.★ Used Microsoft Access and SQL to develop custom applications that enable non-SQL users to interact with information stored in databases. Additionally, joined with a colleague to implement Power BI to enable non-technical employees to view product information and data.★ Developed SQL packages in order to validate or audit TPA accumulation processing.★ Worked with a Python developer to create a geo-mapping tool.★ Recruited and supervised two analysts on a two-year project to migrate an internal application. Trained the analysts in pharmacy and hospital workflows, the 340B program, system requirements, and the audit platform.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT OMNICELL / PSG / ICSOmnicell provides innovative pharmacy and medication management solutions for healthcare professionals and health systems. The company acquired the 340B Link business of Pharmaceutical Strategies Group (PSG) in 2020. The 340B Prime Vendor Program is issued by the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program that provides access to discounted medication.

Company/Organization: Omnicell / PSG / ICSPosition/Title: Audit and Compliance Analyst (ICS)Location: Plano, TXDates of Employment: 2015 to 2019Description:★ Created multiple databases, and used Microsoft Access, Microsoft Excel, VBA, SSIS, SQL queries, and stored procedures to support work with hospitals to gather and map client data back to the company’s standardized table structure for further reporting and analysis.★ Developed databases and algorithms aligned with audit sampling methodologies.★ Examined claims/dispensation, encounter, and provider data sets in order to generate targeted samples to guide on-site audits.★ Supported an audit by creating a Microsoft Access database enabling the on-site processing of areas of risk and development of reports.★ Designed Corrective Action Plan databases to identify liability and generate individual reports on drug manufacturers receiving refunds.★ Automated portions of a monthly Walgreens audit, improving accuracy while reducing the time required to develop reports.★ Credited with building a Workflow tool that safeguarded quality, reduced complexity, and promoted repeatability in audits.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT OMNICELL / PSG / ICSOmnicell provides innovative pharmacy and medication management solutions for healthcare professionals and health systems. The company acquired the 340B Link business of Pharmaceutical Strategies Group (PSG) in 2020. The 340B Prime Vendor Program is issued by the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program that provides access to discounted medication.

Company/Organization: ApexusPosition/Title: Senior AnalystLocation: Irving, TXDates of Employment: 2013 to 2015Description:★ Automated monthly and quarterly tasks in collaboration with ETL developers.★ Performed user acceptance testing to validate and verify SQL changes★ Leveraged the use of MicroStrategy to build reports for internal clients.★ Partnered with portfolio executives, marketing personnel, managers, distributors, and hospital stakeholders to define projects, collect business requirements, and build technical solutions.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT APEXUSApexus manages the 340B Prime Vendor Program for the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program. Apexus contracts with manufacturers and distributors to ensure access to discounted medications.

Company/Organization: ApexusPosition/Title: Staff AnalystLocation: Irving, TXDates of Employment: 2012 to 2013Description:★ Developed What If scenarios for forecasts, financial performance, and impact assessments to support data-driven decision-making.★ Built Pricing Integrity reports that improved processes, introduced step sequencing, and enabled greater data transparency, leading to a time savings of 98% and millions of dollars in expense reduction annually.★ Delivered over 95% time savings by designing database structures for the DEA Invalids research process.★ Won the 2012 Exceeding Excellence Award as well as a Wow Award.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT APEXUSApexus manages the 340B Prime Vendor Program for the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program. Apexus contracts with manufacturers and distributors to ensure access to discounted medications.

Company/Organization: ApexusPosition/Title: Associate AnalystLocation: Irving, TXDates of Employment: 2010 to 2012Description:★ Oversaw reporting, pricing, and revenue streams for 110 340B PVP contracts.★ Responsible for reviewing pharmaceutical and non-pharmaceutical information relating to pricing, spend, and other data from distributors, PVP participants, HRSA, and internal stakeholders.☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲☲ABOUT APEXUSApexus manages the 340B Prime Vendor Program for the Health Resources and Services Administration, which is responsible for administering the 340B Drug Pricing Program. Apexus contracts with manufacturers and distributors to ensure access to discounted medications.

Managed Accounts Receivables

Business, Marketing

Bba, Mktg

Activities and Societies: ISO (international student outreach) & YI (youth impact)Activities involved in focused on learning how.