The purpose of the role is to calculate the $ gap between paid and unpaid high price Adhoc procedures to deliver accurate data for Clinical groups and Project Finance, spanning multiple IQVIA proprietary systems. The employee must be a Subject Matter Expert on the IQVIA proprietary systems required for payment validation. Highly skilled in contributing to the development of the department’s data analyst role. Data-flow between clinical trial databases and our payment system monitored through performing a series of monthly checks for select studies, to catch any potential data-fallouts, interface issues, or faulty data for payments.
Overview
5
5
years of professional experience
5
5
years of post-secondary education
Work History
Senior Data Alignment Associate
IQVIA
Banglore
10.2021 - Current
Performing Gap analysis of Projects at regular intervals and submit them to Project managers on a timely Basis
Provide End to End support in Adhoc True-up analysis and Payment reconciliation
Providing support to Finance related activities for other project teams
Able to identify $gap on payments for assigned studies, route these to appropriate teams for action
Project management stakeholders involved in the process including the coordination of accurate payment reconciliations
Deliver accurate & on-time Adhoc analysis data for all IQVIA assigned studies
Interpret and understand EDC report, clinical site contracts, Invoice, and the payment system design & payment triggers
Analyze data of analysis prepared and provide any necessary corrections to ensure sites are paid accurately
Conduct study meetings with project team to discuss overpaid items and gaps in the Adhoc analysis report
Reviewing all invoices for appropriate documentation also providing the breakdown's for all the procedures which are not captured in the payment report
Maintaining files and documentation thoroughly and accurately, in accordance with Company policy and accepted
Collection of data from all systems and tools in a timely and proactive basis and ensure the Payments has been successfully paid to sites
Identifying the payment gaps, Providing comments for all the over payments as a standard
Setting up of calls with study team and providing detail output of the analysis.
Accounts Payable Specialist
PAREXEL INTERNATIONAL PVT LTD.
Hyderabad
09.2019 - 10.2021
Preparing the daily dashboard for AP Country head on Team workload and Pending Statuses
Aging of the Invoice Processing to expedite the invoice processing time and address if any obstacles in the process
Publishing payment due report, which enables the management to track and make payments within agreed timelines to get vendor discounts and avoid penalties
Sending the email approval process for high-value invoices using VBA Macros
Sending notification emails to the approvers for low-value Invoices
Worked with multiple teams within the Accounts Payable department to establish control points and minimize the non-value added works with automation and understanding data requirements and explaining to IT teams to get the required data dumps using SQL queries
Performing the Order vs Billed quantities reconciliation and releasing the default system holds
Prioritizing the Clinical Trial dependent supplier payments to ensure smooth run of clinical trial process and all trial equipment or services delivered to sites/patients without any hindrances
Identifying the high risk suppliers in terms of payments to expedite the review process to release holds and make payments
Following up with the Project managers for approvals and close liaison with suppliers to resolve the invoice related discrepancies
Sending out emails to the Approvers using advanced mail merge option and following up with reminder emails
Identifying the issues related to PO requisition matching and issues related to insufficient funds to direct the requestor to work with procurement for necessary actions
Keeping track of disputed invoices and working with suppliers to get the revised invoice that are in agreement with approver to resolve the issue and make payments
Updating the project managers details using the Employee data dumps to follow the right escalation matrix to expedite the approval process within organization using mail merge
Working with cross functional teams in resolving the various discrepancies between suppliers and business process owners aka approvers
Closely working with Accounts receivable teams in initiating the client refunds
Identifying the suppliers that offer discounts to ensure they receive the payment within time.