Tushar Jain

Senior Operations Research Analyst with proven track record of success designing models and analytical programs to solve business problems. Results-oriented with strong research and decision-making skills to determine specifications and develop action plans for projects. Collaborative with excellent interpersonal and communication skills across diverse groups.

1. Analyzing Promo Campaigns - Created stored procedure to download the utilization data of the current running promos and the basis of the downloaded report created Power BI dashboard to monitor over utilization and under utilization for the stakeholders.

2. Monthly Reconciliation - Created stored procedure to download the PO data and the monthly utilization and created the Power BI report for reconciliation to share with stakeholders.

3. Risk Investigation - Created a query to analyze risks for the promos and to check if it is legitimate request for the promo creation or not.

4. Transaction Monitoring - Created one trigger if any transaction for cashback will be failed so it will raise alarm so that we can avoid customers escalation.

5. UPI Transaction Monitoring - Created query to check failed UPI transaction on Amazon Pay to disburse the penalty amount.

6. Analyzing Bank Campaigns - Created dashboard to monitor bank campaigns like IBD, NCEMI, created query to download such transactions to share the RRN details with respective bank.

7. AP and AR Analyzing - Need to create AP and AR sheets on Excel using excel formulas and need to raise invoices for the AR to the respective entities using PWC tool.

1. Analyzing Promo Campaigns - Created stored procedure to download the utilization data of the current running promos and the basis of the downloaded report created Power BI dashboard to monitor over utilization and under utilization for the stakeholders.

2. Monthly Reconciliation - Created stored procedure to download the PO data and the monthly utilization and created the Power BI report for reconciliation to share with stakeholders.

3. Risk Investigation - Created a query to analyze risks for the promos and to check if it is legitimate request for the promo creation or not.

4. Transaction Monitoring - Created one trigger if any transaction for cashback will be failed so it will raise alarm so that we can avoid customers escalation.

5. UPI Transaction Monitoring - Created query to check failed UPI transaction on Amazon Pay to disburse the penalty amount.

6. Analyzing Bank Campaigns - Created dashboard to monitor bank campaigns like IBD, NCEMI, created query to download such transactions to share the RRN details with respective bank.

7. AP and AR Analyzing - Need to create AP and AR sheets on Excel using excel formulas and need to raise invoices for the AR to the respective entities using PWC tool.