Jeff Jager Email & Phone Number

Ann Arbor, MI, US

Santa Barbara, CA, US

• Utilized Microsoft Azure Data Studio, Azure Storage Explorer, Azure Data Factory, Azure SQL Database, and SQL Server Management Studio (SSMS) to create and manage data pipelines.
• Created data marts and queries against Veeva Compass and Clarivate data sets, providing data accessibility and usability.
• Led the technical implementation of the Model N Master Data Management system

• Over 10 years with the company, I achieved three promotions, progressing through roles including Informatics Analyst, Senior Analyst, Lead Analyst, and Lead Data Engineer. This career growth reflects my ability to.
• A reporting system that generated key metrics for pharmaceutical claims, integrating formulary and rebate information, resulting in improved data accuracy and usability.
• An opioid reporting system to calculate daily morphine equivalent dosage, improving patient safety and compliance.
• A system that determined the intersection of morphine equivalent opioid consumption and potentiator drugs for all affected members. Reporting from this system fulfilled a state-mandated requirement eliminating.

• Oracle-based rebate submission systems for PBMs and pharmaceutical companies, managing $60MM in rebate revenue over ten years.
• An interrupted time-series regression model to analyze Medicaid Common Formulary cost impact, utilizing R/R-Studio/Markdown.
• Won second place in a predictive modeling competition by developing a multiple linear regression predictive model with R and RStudio, improving member-level cost prediction accuracy.
• Supported the corporate legal department on a variety of class-action lawsuits and other matters by creating SQL-based data extracts that met the requirements submitted by the assigned legal team.

• Developed a Pharmaceutical and Therapeutics Committee Meeting reporting system using R/Oracle, enhancing decision-making for formulary changes.
• Utilized SQL to create cost analysis and utilization reports, supporting strategic planning within the organization.
• Developed a technique for calling variable-argument procedures in Oracle from R, improving software development efficiency and reusability.

• Designed and developed an Oracle PLSQL-based drug adherence reporting system, assisting in securing a 5-star rating in medication adherence from CMS, and which was also used in various projects including a University.
• Conducted numerous SQL data extracts and Microsoft Excel Pivot-Table and VBA programming projects, supporting various organizational groups, and developed a training program for Excel pivot tables, conducting classroom.

• Traded index, equity, and ETF options, including vertical and diagonal spreads, iron condors, straddles, and strangles, demonstrating advanced technical analysis skills.
• Developed modeling tools to determine options value (Black-Scholes), bond duration, and bond convexity, enhancing predictive accuracy and financial decision-making.
• PRMIA Professional Risk Manager (PRM)

Detroit, Michigan, US

• Developed a Microsoft Access-based profit and loss (P&L) explained application, determining dollar change attribution to volume and price changes between trading days, improving financial analysis accuracy.
• Developed an Excel-based position reporting system using pivot tables and VBA code, enhancing data accessibility and usability for all traded instruments.
• Led the development of an oil trading system within OpenLink Endur, including an Excel-based data upload system, to track a newly created oil trading desk.

Carmel, Indiana, US

• Provided risk management and statistical modeling services for clients in the electric utility industry.
• Evaluated hedging instruments such as gas/power options, futures, and forward contracts, improving predictive accuracy and financial decision-making.
• Consulted with senior client management to discuss portfolio modeling results and risk management strategies, enhancing data accessibility and usability.

• Developed applications with Visual Basic, SQL Server, Transact SQL, and C++ to support natural gas trading, quantitative analysis, risk management, and pipeline scheduling functions for large energy industry clients.
• Successfully led projects to implement risk management models and applications, coordinating with traders, quantitative analysts, and IT staff.
• Clients included Duke Energy, Texaco Natural Gas Trading, PG&E Energy Trading, and Koch Industries.

Mba, Masters In Business Administration

Bachelor Of Science - Bs, Applied Mathematics, Engineering, And Computer Science