Edmund Elsner
Phoenixville,PA
Summary
Business analyst with expertise in creating innovative solutions for organizational challenges. Proficient in contract management tools and processes, with a strong background in project management. Demonstrated ability to enhance operational efficiency and drive project success.
Overview
26
26
years of professional experience
1
1
Certification
Work History
Lead Business Analyst
IQVIA
04.2025 - 05.2026
- Served as lead business analyst for MFP (Maximum Fair Price) reporting, ensuring accurate data representation.
- Acted as liaison with offshore report development team to facilitate communication and project progress.
- Authored functional specifications for developing new reports, guiding reviews and obtaining e-signatures.
- Developed UAT test scripts and organized test executions in QTest to ensure quality assurance and compliance.
- Created Model N flex adjudications for chargebacks and rebates to support SAP upgrade testing.
Business Analyst
IntegriChain
04.2022 - 03.2024
- Coordinated Model N Flex upgrade from on-premise v7.6 to SaaS cloud in Fall 2022, ensuring project milestones were met.
- Tracked and coordinated RAID log, project training, project planning, and status reporting to maintain project alignment.
- Managed updates and approvals for key project deliverables such as Data Conversion Plan(s), Cutover Plan, Training Plan, and Stage Tollgates, ensuring timely completion.
- Maintained updates to project tasks and deliverables tracked in Jira, improving project transparency and accountability.
- Assumed lead BA role for the Managed Care workstream, driving requirements gathering and solution delivery.
- Managed updates and approvals for Managed Care configuration specification, Functional and Detail Reporting Specification, and wrote SIT test scripts in Jira Xray, maintaining Trace Matrix and testing documentation to ensure quality and compliance.
Contract/Rebate Analyst
Abbvie/Allergan
06.2021 - 07.2022
- Performed a contract/rebate analyst role for Purchased Based Contracts and Aesthetics products using Revitas Flex.
- Set up and maintained contracts in Revitas Flex.
- Synchronized eligibility and products between SAP and Revitas.
- Coordinated and administered monthly patient assistance coupon rebates in Revitas Flex using External Data/Adjudication Wizard.
- Worked with trading partners to resolve questionable data and rebate requests.
- Created electronic rebate approval signoff packets for upper management.
Management Consultant
Pharosity Consulting
07.2019 - 07.2022
- Provided management consulting services for various life sciences companies, enhancing operational efficiency.
- Conducted assessments of clients' contract management operations, identifying areas for improved efficiency and effectiveness.
- Recommended process improvements and developed roadmaps for future changes, supporting long-term client success.
- Analyzed over 10 years of outstanding Medicaid rebate claims and script-level data, identifying over $2M in potential disputes across all states.
- Created an Excel-based tool to scrub state Medicaid script data, automatically calculate interest owed, and generate ROSI/PQAS statements, streamlining client reporting.
- Supported a client in performing what-if pricing analysis using a custom-built Excel workbook, enabling informed decision-making.
- Reviewed active managed care contracts and created a library of summarized terms and conditions, clarifying rebate impacts for clients.
- Assisted with requirements definition and UI wireframe design for a custom pre-deal analysis tool, improving user experience.
Senior Project Manager
iMany/Revitas/Model N
03.2008 - 06.2019
- Responsible for managing and delivering various size projects, from small enhancements to large enterprise implementations/upgrades.
- Clients included Merck, Pfizer, AstraZeneca, Sanofi, Teva USA, Teva Neuroscience, and Novartis.
- Life sciences software vendor
Project Manager
Sanofi Aventis
01.2017 - 12.2018
- Managed largest fixed-price implementation for Sanofi Aventis, overseeing $10 million budget over two years.
- Ensured timely achievement of approximately 40 project milestones, facilitating invoicing activities.
- Created and conducted weekly presentations to update cross-functional teams on project status.
- Presented project updates at quarterly executive steering committee meetings to enhance transparency.
- Collaborated with internal departments on sales forecasting, client invoicing, revenue recognition, and resource scheduling.
- Liaised with product engineering to secure critical client functionalities in development cycles.
- Communicated software development cycles with clients to plan cross-team upgrades efficiently.
- Estimated work efforts and prepared proposals, statements of work, and change scope documents.
Project Manager / Business Analyst
GHX
03.2006 - 03.2008
- Served as project manager and business analyst for life sciences projects, focusing on functional upgrades for IdealECP and IdealCMS.
- Managed budgets effectively to ensure timely delivery of all functional enhancements.
- Estimated work requirements to create proposals, statements of work, and change scope documents.
- Supported IdealECP and IdealCMS applications across various pharmaceutical clients.
- Assisted with defining requirements and designing a new utilization data validation application, ClaimRight Commercial.
Lead Business Analyst
Teva Neuroscience
10.2005 - 03.2006
- Gathered prescription data validation and contract management system requirements.
- Managed resources to map and load over 150 historical data submissions for 28 contract organizations.
- Customized and tested prescription data validations using PL/SQL to fulfill business needs.
- Developed and tested back-end rebate claim calculations and processing in PL/SQL.
- Produced comprehensive user and technical documentation for reference.
- Trained Teva Neuroscience business users on system functionalities.
Developer
Ideal Systems, Inc.
10.2000 - 03.2006
- Created, optimized, and documented quantified savings module for IdealECP, determining exact rebate savings for utilization submissions by leveraging rejected utilization data with customer contract terms in CARS/IS.
Project Manager
Medicis
02.2005 - 09.2005
- Executed proof of value project, processing one year of utilization data, yielding rebate savings of $250,000.
- Collected business requirements for utilization processing to ensure accurate analysis.
- Acquired and loaded client contract terms and product data into internal database.
- Customized script validations to align with specific business requirements.
- Delivered final analysis summary to contract management department and CFO for review.
Lead Business Analyst
Wyeth Ayerst
09.2004 - 03.2005
- Identified duplicate scripts across segments, preventing $1M in revenue leakage from managed care.
- Led implementation of IdealECP as business analyst to enhance operational efficiency.
- Proposed utilization data processing methods, saving Wyeth millions annually.
- Advised Wyeth contract analysts on rebate contract setup in CARS/IS.
- Developed customized documentation and delivered training to business users.
Lead Business Analyst
Novartis
02.2003 - 11.2004
- Directed IdealECP implementation as lead business analyst.
- Maintained Cognos reports to support decision-making processes.
- Produced tailored system and user documentation for improved user experience.
Lead Business Analyst
Centocor
01.2003 - 09.2004
- Led implementation of IdealECP and CARS/IS upgrade from v2.14 to v3.8.
- Gathered business requirements, performed gap analysis, and created functional requirement documents.
- Conducted system testing to ensure project compliance with specifications.
- Served as Cognos administrator for all contract management reports and PowerPlay cubes.
- Designed custom reports tailored to specific business requirements.
- Supported daily contract operations by researching issues, recommending solutions, and generating operational reports.
- Developed standard operating procedures and comprehensive system documentation.
- Trained business users on functionality of both CARS/IS and IdealECP.
Lead Business Analyst
Aventis Pharmaceuticals
04.2001 - 01.2003
- Provided the necessary support to ensure all managed care rebates and IFF rebates were processed timely and accurately in CARS/IS.
- Lead business analyst for a CARS/IS upgrade from v2.14 to v3.8 for managed care rebate contracts.
- Assisted with the implementation of a Managed Care Utilization Preprocessing System to minimize revenue leakage.
- Supported the daily contract operations, researched issues, recommended solutions, created reports to answer operational questions, and fixed erroneous data.
- Acted as a liaison between the contracting department and the data warehouse to identify, research, and correct data issues.
Lead Business Analyst
Takeda Pharmaceuticals
11.2000 - 04.2001
- Led business analysis for cars/is implementation.
- Conducted contract analysis, modeling, and issue resolution.
- Executed system testing, including planning and documentation creation.
- Trained contract analysts on effective utilization of cars/is functionalities.
Developer and Business Analyst
Computer Sciences Corp. Consulting & Systems Integration
- Designed, developed, and implemented contract management systems for multiple life sciences companies.
- Redesigned warranty system for Mercedes-Benz of North America to prevent revenue leakage.
Education
Bachelor of Science - Quantitative Business Analysis
Pennsylvania State University
Skills
- Model N (powered by Flex)
- Microsoft Suite
- Business analysis and data analysis
- Agile methodology
- Attention to detail
- Project management
- Cross-functional teamwork
- Quality assurance
- Jira
Certification
Certified Scrum Master (CSM), Scrum Alliance
Timeline
Lead Business Analyst
IQVIA
04.2025 - 05.2026
Business Analyst
IntegriChain
04.2022 - 03.2024
Contract/Rebate Analyst
Abbvie/Allergan
06.2021 - 07.2022
Management Consultant
Pharosity Consulting
07.2019 - 07.2022
Project Manager
Sanofi Aventis
01.2017 - 12.2018
Senior Project Manager
iMany/Revitas/Model N
03.2008 - 06.2019
Project Manager / Business Analyst
GHX
03.2006 - 03.2008
Lead Business Analyst
Teva Neuroscience
10.2005 - 03.2006
Project Manager
Medicis
02.2005 - 09.2005
Lead Business Analyst
Wyeth Ayerst
09.2004 - 03.2005
Lead Business Analyst
Novartis
02.2003 - 11.2004
Lead Business Analyst
Centocor
01.2003 - 09.2004
Lead Business Analyst
Aventis Pharmaceuticals
04.2001 - 01.2003
Lead Business Analyst
Takeda Pharmaceuticals
11.2000 - 04.2001
Developer
Ideal Systems, Inc.
10.2000 - 03.2006
Developer and Business Analyst
Computer Sciences Corp. Consulting & Systems Integration
Bachelor of Science - Quantitative Business Analysis
Pennsylvania State University