Anirudh Khandelwal

About Anirudh Khandelwal

Dedicated and dynamic professional with over 11 years of experience in Business Analysis,…

Experience

1. Senior Business Intelligence Engineer

   Amazon

   May 2019 — Present · AZ, US

   Developed a sustainable framework to report KPIs on Engagements, Revenue and Customer Feedback to Vice President and Senior Vice President for the Video Ads business.• Implemented Lighthouse Data Architecture using SQL, S3, Redshift, Airflow, Glue Crawler and QuickSight to automate data flow and visualization of errors in all Salesforce advertiser accounts. Also, designed Data Quality Dashboard to provide Sales Force Data Quality metrics and a path to rectify account issues.• Mentored 5 unique team members; coaching sessions involved the development of skills in Tableau, Career Development and Business Intelligence – Multiple mentees were quickly promoted and are still emerging as future leaders in their teams. • Forecasted total incoming task volume for Abuse Prevention at weekly and segment level using ensemble time series models in Python improving long-term MAPE by 1400 bps. Also, automated model by integrating with SageMaker, Amazon Secrets Manager, S3, Redshift and Code Commit saving a week of manual effort.• Oversaw the implementation of the Dashboard Design Process for 5 teams (27 persons) in the Sales Organization to standardize dashboard design methodology.• Created data pipelines using Hoot, SQS, SNS, SQL Lambda Functions and Python to automatically ingest data for all project updates for 8 major Global Security Organization divisions and designed a Tableau dashboard to report product updates to leaders. • Developed Duplicate Detection tool using Fuzzy Logic to recommend duplicate accounts between AMZ and Twitch Sales Force instances resulting in revenue reconciliation.• Predicted and visualized high-risk zip codes for the upcoming quarter based on risk assessment using K-Means clustering improving customer satisfaction and driver safety.

Skills

• Unix
• C++
• Linux
• Java
• Mysql
• Javascript
• C#
• C
• Core Java
• Abap
• Sql