Deepak Mistry

• Develop and maintain daily, monthly, and quarterly Key Performance Indicators (KPIs) and metrics to evaluate and monitor vendor performance in Alteryx and Tableau.
• Defined the scope of data analytics projects and developed tailored analytics solutions to meet the specific requirements and needs of the Vendor Manager.
• Automated both existing and new analytics projects using Tableau, streamlining data processes and improving the efficiency and accuracy of reporting through dynamic, interactive dashboards.
• Led the expansion of the reporting scope by delivering data analytics and visualizations that not only met but exceeded stakeholder requirements and expectations. • Led initiatives to enhance the existing analytics dashboard, successfully implementing and accommodating necessary changes to improve its functionality.
• Led the two AI project for the entire team, focusing on defining and developing use cases in collaboration with AI developers and engineers. • Coordinated the implementation of AI-driven use cases and provided regular demonstrations of the Use Case/LLM Suite to the team.
• Effectively communicated ongoing AI updates and developments to ensure alignment and awareness across the team.
• Manage and track vendor-related incidents through an issue tracker, ensuring timely follow-ups and root cause analysis for incident resolution.
• Collaborate across departments to implement preventive measures, controls, and identify recurring themes to avoid future incidents.
• Compile and deliver monthly executive summaries, updates, key achievements, and newsletters to stakeholders.
• Clarify, document, and maintain roles and responsibilities for all vendor-related activities, ensuring alignment and accountability.
• Collaborate with business teams to develop and maintain contingency plans for vendor service outages, ensuring a seamless recovery process.
• Stay informed of vendor notifications regarding service changes, market event impacts, and related disruptions to ensure business continuity.
• Lead Project Management Office (PMO) reporting to ensure alignment with business goals and vendor service expectations.
• Provide operational support for all vendor-related incidents, ensuring quick and effective resolution.
• Define, track, and influence vendor operational level agreements (OLAs) and contribute to the development of formal service level agreements (SLAs).
• Assist in managing vendor data challenges and coordinating vendor meetings with evaluators.
• Lead internal stakeholder service review meetings, ensuring alignment of vendor performance with business objectives.
• Resolve internal and external queries promptly and professionally, maintaining strong communication across teams.
• Monitored project performance to identify areas of improvement and make adjustments.
• Coordinated with cross-functional teams to resolve project issues and mitigate risks.
• Provided detailed project status updates to stakeholders and executive management on weekly basis.
• Implemented continuous improvement initiatives to optimize project outcomes while maintaining cost effectiveness.
• Enhanced project visibility, implementing dashboard and reporting tools for real-time progress monitoring.

• Support identification and implementation of sustainable & scalable data analytics strategy and processes in support of GIA audit projects and company anti-fraud initiatives.
• Develop new analytics using ALTERYX workflow tools.
• Identify source data like SAP tables, Data Lake/Hadoop views to extract data in ALTERYX.
• Coordinate with different IT/ business Stakeholders to get access for required table or views.
• Understand need, develop SQL query in Hue/Alteryx and apply logic to build data analytics.
• Perform data mining and data cleansing on source data.
• Create visualizations in Tableau to support enhanced analytics using Tableau tools.
• Work with GIA & GIC Auditors for data accuracy. Consult extensively with appropriate internal personnel and external resources to stay current with needs of GMI business processes and industry best practices.
• Update existing Analytics based on client requirements.
• Engage during audits to support audit team on assessments of area in audit scope.
• Stay abreast of new developments and maintain understanding of leading practices in computer assisted auditing procedures and related tools and technology.
• Identify and pursue self-development opportunities through continuing education and audit assignments.
• Learn new tools and vision for scope of improvement in analytics area.
• Be agile to changes in Data analytics to organization needs.
• Coordinating with IT team & external vendor for software installation and fixing bugs.
• Identify root cause of data errors and explore solution/remedy.
• Participate in 1-2 internal audit engagements as team member supporting Lead on operational process area audits.
• Post internal audit, share inputs with Managers and apply learning to improve analytics.
• Perform role of Local Security Authority (LSA) for GIA team coordinating with Global and Local IT teams.
• Manage GIA SharePoint portals as site administrator/ owner.
• Complete special projects to improve audit department performance, as necessary.

• Reconciliation over 50+ Inventory/Stock for Plants & Warehouse locations.
• Stock Ledger and Stock Movement Behavior.
• Investigating & Analyzing the Stock Discrepancy.
• Identify key drivers of F/UF usage and share result with Financial Analyst
• Consumption & Bill Back Analysis of Plants.
• Product Pricing & Setting up Bills of Materials in SAP.
• Consistently Meet/exceeded SLA.
• Processing Receivables & Payable like raising Debit & Credit Memo.
• Processing Non-PO invoices in SAP.
• Journals & Accruals Posting.
• Month End Closing.
• Controls & Audit.
• Developed strong relationships with business partners.
• Support BCP.
• Identified and implement process improvement ideas.
• Coaching & Training Team Members.
• Processing Various Reports & Making Inventory Adjustments.
• Investigating & Analyzing the Report Discrepancies.
• Analyzing discrepancy trends.
• Consistently Meet/exceeded SLA.
• Maintained SOP & OPL.
• Preparing DMS & Dashboard.
• Audit and Control accounting processes and compliance with SOX requirements.
• Focused on Process Improvements, Service Excellence & Delivery, and Addressing Escalation.
• Reviewed individual department performance and worked with leadership to improve processes, procedures and practices.

1) Senior Executive –Finance Operation in Abbey Life Client Accounting (Feb-10 - May-11)

• Performing Daily and Month End Reconciliation like Bank Reconciliation, Claim Controls, Debtors Reconciliation and Loan Reconciliation & Suspense account.
• Investigating & Analysis the root cause the reconciliation discrepancies
• Performing Daily & Month End Journals.
• Updating Ledgers
• Preparing P & L Analysis
• Communicating with UK Team with minimal support and resolving queries.
• Review and Quality Check of Reconciliations
• Attending Conference call & Meetings Weekly

2) Senior Executive - Financial Services in Capita Registrar (Oct-07 - Jan-10)

• Processing Stock & Dividend reconciliation.
• Investigating & Analysis the root cause the reconciliation discrepancies
• Review and Quality Check of Dividend Reconciliations
• Processing & Maintaining Mini reconciliation of Corporate accounts
• Preparation & Finalization of Weekly reports for the clients
• Established direct correspondence with onshore UK team for queries like Credit Inquiry, Dividend Query & Bac Rejects