Mandeep Kaur
Carteret,NJ
Summary
Strategic-minded Senior Financial Analyst bringing 8 years of experience in financial landscape. Well-versed in variance analysis and forecasting. Hands on experience with membership eligibility, contract setup, rebates & chargebacks.
Overview
7
7
years of professional experience
Work History
Senior Financial Analyst, G2N
Novartis Pharmaceuticals
06.2023 - Current
- Coordinate IM US GTN forecasting ($7.8B) financial planning process including budget, monthly forecasts, and strategic plans, liaise with FRA and Corporate Planning
- Effectively manage US cash flow forecasting and coordination across departments. Prepare monthly analysis and deep dives to understand key variances
- Provide analytical support to market access team on price increase proposals and external price reporting
- Anticipate, prioritize, and proactively manage ad hoc requests for analytical insight. Combine and interpret customer, market, and financial insights to drive clear, analytical decision making across the business
- Enhance revenue deduction reporting through automaton and data visualization to deliver business insights
Sr. Membership Analyst
Novartis Pharmaceuticals
03.2021 - 06.2023
- This entails contract interpretation and system entry; validating membership; rebate payment adjudication
- Process Expert/Lead - Evaluate and interpret contracts to ensure correct setup of products, pricing, and membership terms
- Create and maintain Indirect/Direct membership information in Model N and SAP
- Conduct Class of Trade research to support Government Pricing calculations
- Serve as subject matter expert for the department and leverage knowledge of system and membership expertise to drive priorities, project development quality/speed, and compliance
- Lead and/or coordinate special projects
- Business Partnering - Support contract strategy feasibility discussions with NPC, Sandoz Bio-pharma, and/or Sandoz Gx contract teams
- Partner with the Government Pricing team to ensure accurate pricing calculations
- Communicate with wholesalers, GPO, LTC, Specialty Groups, HIBCC, IMS, and HRSA to determine member eligibility
- Partner with Market Access to support the implementation of new strategies
- Team Leadership/Meeting Facilitation - Provide expertise and training to analysts within the team to help ensure understanding and alignment of standard operating procedures
- Conduct meetings to achieve issue resolution within the department, with internal customers, wholesalers, and GPOs
- Maintain systems and logs to track contracts, rebate, chargebacks, and membership issues for accurate reporting to management. Data Analytics/Super User: Designated resource within department to be the expert on all systems and programs
- Provide expertise in testing, troubleshooting, as well as identifying errors and process efficiencies
- Quality Assurance – Ensure adherence to all standard operating procedures and SOX requirements
- Ensure communication to management about identified risks to the department and organization
Staff Accountant
Osmotica Pharmaceutical LLC
03.2019 - 11.2020
- Assist with the monthly close process, including, preparation of journal entries and completion of account reconciliations and analysis for various balance sheet accounts. (Accrued Expenses, Prepaid Expenses, Prepaid Rent, Prepaid Insurance Intangible Asset, Fixed Asset, Deferred Rent, Capital Lease, Accrued Payroll & Accrued Bonus)
- Update balance sheet accounts roll forwards, including variance analysis and explanations.
- Preparation of monthly bank reconciliations and recording of wire transfers and Deposits.
- Reconcile Intercompany accounts and resolve any variances, record AR/AP elimination entries.
- Record Bi -Weekly Payroll, YE Bonuses & Severances.
- Record weekly concur expenses and monthly accrual.
- Manage Supply Chain accounting/validating process.
- Collaborate with cross-functional operational teams supporting Customer Service and Trade.
- Work closely with financial analyst to reconcile customer accounts and process CM/DM accordingly.
- Assist accounts receivable with investigating customer rebate discrepancies to achieve reconciliation of customer deductions.
- Monitor accounts payable email account and respond to vendor inquiries regarding invoice/payment status.
- Support finance team with audit requests, including preparation of year-end audit and quarterly close schedules.
- Perform ad hoc and special requests as deemed necessary.
Accounts Receivable Coordinator
Osmotica Pharmaceuticals LLC
08.2017 - 03.2019
- Research and reconcile customer's A/R accounts in regards to pharmaceutical chargebacks, shortages and miscellaneous deductions
- Analyzing chargebacks data to uncover wholesaler deductions
- Identify and dispute invalid chargebacks on customer portal
- Analyze accounts in Excel using Pivot Tables & Vlookups
- Contact customers to resolve open deductions and obtain payment if applicable
- Offset credits and debits to resolve open deductions
- Prepare credit memo requests or write-offs, as necessary
- Send customer credit memos, debit memos and statements
- Supply chain: identify FTS, SSA & Price protection-Sent it to Trade for validation process
Education
Master of Science -
Keller Graduate School of Management
Online2022
Bachelor of Science -
DeVry University
Elk Grove, CA2012
Skills
- Excel (Pivot, VLOOKUP)
- Model N, Breakaway, Microsoft AX Dynamic & QuickBooks
- Bank Reconciliation
- Monthly Journal Entries
- Intercompany Reconciliation
- Rebate Reconciliation
Timeline
Senior Financial Analyst, G2N
Novartis Pharmaceuticals
06.2023 - Current
Sr. Membership Analyst
Novartis Pharmaceuticals
03.2021 - 06.2023
Staff Accountant
Osmotica Pharmaceutical LLC
03.2019 - 11.2020
Accounts Receivable Coordinator
Osmotica Pharmaceuticals LLC
08.2017 - 03.2019
Master of Science -
Keller Graduate School of Management
Bachelor of Science -
DeVry University
Similar Profiles
Ananya K UAnanya K U
Statistical Programming Intern at Novartis PharmaceuticalsStatistical Programming Intern at Novartis Pharmaceuticals
Teresa AndersonTeresa Anderson
Patient Navigator Radioligand Therapy at Novartis PharmaceuticalsPatient Navigator Radioligand Therapy at Novartis Pharmaceuticals
Kirstie KeelKirstie Keel
Senior Territory Account Specialist at Novartis PharmaceuticalsSenior Territory Account Specialist at Novartis Pharmaceuticals
LAURA FAZIOLAURA FAZIO
QC Analyst Microbiology II at Novartis PharmaceuticalsQC Analyst Microbiology II at Novartis Pharmaceuticals
Mark MoralesMark Morales
Delivery Driver at Dylans Dash Delivery Inc. FedEx.Delivery Driver at Dylans Dash Delivery Inc. FedEx.