Tushar Jain

Manage New Product Development (NPD) Tracker:

• Oversee the progress and milestones of new product development.
• Keep a record of key stages and deadlines in the development process.
• Collaborate with cross-functional teams to ensure alignment with project goals.

Track Sales Data:

• Monitor both offline and online sales using punched and delivered data.
• Implement a system for real-time sales tracking to enhance decision-making.
• Analyse sales trends to identify growth opportunities.

Manage Bad Debtors:

• Evaluate payment history to identify and track bad debtors.
• Implement strategies to reduce instances of late or missed payments.
• Collaborate with finance and collections teams to address outstanding payments.

Monthly Reconciliation for Offline Sales:

• Conduct monthly reconciliation for offline sales to ensure accuracy.
• Identify discrepancies and work with relevant teams to resolve issues.
• Generate reports summarizing the reconciliation process.

Quality Control (QC) Tracking:

• Monitor 1st Party (1P) and 3rd Party (3P) quality control based on customer feedback.
• Collaborate with the customer service team to gather and analyze feedback.
• Implement improvements based on quality control findings.

Raw Material Tracking for Production:

• Develop and maintain a tracker to monitor raw material inventory.
• Ensure sufficient stock levels for uninterrupted production.
• Implement a system for reordering raw materials when inventory is low.

• Analyzed promo campaigns and created a stored procedure to download utilization data.
• Developed a Power BI dashboard to monitor overutilization and underutilization.
• Conducted monthly reconciliation by creating stored procedures and Power BI reports.
• Investigated risks associated with promos and assessed the legitimacy of requests.
• Monitored transactions and implemented triggers to raise alarms for failed cashback transactions.
• Analyzed failed UPI transactions on Amazon Pay and managed penalty disbursements.
• Created dashboards and queries to monitor bank campaigns and share transaction details with banks.
• Managed Accounts Payable (AP) and Accounts Receivable (AR) processes using Excel and PWC tool.

• Handled data analysis, variance analysis, and financial risk monitoring.
• Utilized SQL, Excel, advanced Excel, JIRA, Word, Power BI, and visualization tools.
• Developed macros and conducted data analysis using various tools.
• Collaborated with stakeholders to ensure effective MIS reporting and analysis.

• Developed testing code for web-based applications.
• Prioritized and problem-solved several tasks concurrently with minimum supervision.
• Followed best practices for software development and web security.
• Wrote custom HTML and JavaScript for existing websites.
• Maintained client websites with timely updates.
• Took detailed notes during team meetings and disseminated to staff members.
• Shadowed developers to learn key details about job duties and tasks.
• Pitched feature improvements to developer team for use in applications.
• Worked closely with developers on creating new code.