Swapnil Kashyap Email and Phone Number

• Implemented real-time script to improve internal ticketing team experience, resolving 80% of disputes within 0.5 days, a significant improvement from 3 days.• Created data mart consolidating 100+ data sources, resulting in an estimated ROI of 824%.• Developed Quicksight dashboard to enhance program visibility, saving ~100 hours of BI bandwidth annually.• Automated customer accounting processes using advanced SQL strategies, achieving a monthly automation of ~$1M in accruals and… Show more • Implemented real-time script to improve internal ticketing team experience, resolving 80% of disputes within 0.5 days, a significant improvement from 3 days.• Created data mart consolidating 100+ data sources, resulting in an estimated ROI of 824%.• Developed Quicksight dashboard to enhance program visibility, saving ~100 hours of BI bandwidth annually.• Automated customer accounting processes using advanced SQL strategies, achieving a monthly automation of ~$1M in accruals and saving the team roughly 150 hours annually.• Executed in-depth inventory analysis through advanced analytics, successfully reducing the Late Shipment Rate (LSR) by 1%, significantly improving the overall customer experience. Show less

• Handled international manual payments and money transfer operations for HSBC Clients in France; Assessed and processed business and financial transactions as per the needs of Clients• Worked as a subject matter expert for the team; Participated in preparing SOPs and updating the SOPs and provided solutions to reduce errors• Maintained regular checks and payment details of the customer to minimize fraudulent payments and international money laundering • Provides a formal assessment… Show more • Handled international manual payments and money transfer operations for HSBC Clients in France; Assessed and processed business and financial transactions as per the needs of Clients• Worked as a subject matter expert for the team; Participated in preparing SOPs and updating the SOPs and provided solutions to reduce errors• Maintained regular checks and payment details of the customer to minimize fraudulent payments and international money laundering • Provides a formal assessment of potential money laundering, terrorism financing, and other corrupt activities occurring within assets and wealth Show less

• Developed Power BI Dashboards: Created comprehensive Power BI dashboards to analyze sales data for a major retail company, enhancing product visibility and driving sales across multiple marketplaces.• Optimized Data Using DAX Queries: Utilized DAX queries to optimize data processing, generating meaningful insights and enabling stakeholders to monitor key metrics such as productivity, utilization, and weekly performance.• Governance and Resource Management: Developed a governance deck… Show more • Developed Power BI Dashboards: Created comprehensive Power BI dashboards to analyze sales data for a major retail company, enhancing product visibility and driving sales across multiple marketplaces.• Optimized Data Using DAX Queries: Utilized DAX queries to optimize data processing, generating meaningful insights and enabling stakeholders to monitor key metrics such as productivity, utilization, and weekly performance.• Governance and Resource Management: Developed a governance deck to monitor work inflow and resource utilization, ensuring alignment with client expectations and operational efficiency.• Quality Assurance and Efficiency Improvements: Conducted rigorous quality checks with 100% accuracy, including pre and post-generation validation. Leveraged Excel for in-depth data analysis and report creation, reducing manual tasks by 2 hours per day and significantly improving workflow efficiency. Show less