Vivek Kaushik
Sr. Business Intelligence Engineer
Bengaluru
Summary
Experienced Analytics professional with 9+ years of expertise in data-driven solutions and insights for business process optimizations. Dedicated, organized, and optimistic individual who can manage various priorities. Readiness to take on more tasks to achieve team goals. Working with structured and unstructured datasets to produce relevant and actionable data to improve the customer experience and support the launch of new products. Capable of filtering information to highlight key metrics and insights for existing or new business. Leveraging intelligence to identify and indicate key approaches to business problems.
Overview
10
10
years of professional experience
2
2
Languages
4
4
years of post-secondary education
Work History
Sr.Business Intelligence Engineer(Prime Analytics)
Amazon
Bengaluru
10.2016 - Current
- BI STL to support IN Prime Onboarding, Shopping, Marketing, CBCC, and Retention Team of 15 Project/Product Managers and 5 Marketing Managers.
- Create and manage ETL processes utilizing BDT tools ( Datanet, Cradle, Andes, S3) to extract data, convert it to meet business needs, and load it into data warehouses or BI systems.
- Analyze pre- and post-experiment data to identify impacts, opportunities, and risks. Establish measurements and KPIs for growth decision-making using data models.
- Working with SDE/Tech team to automate and launch new customer experience products.
- Developed strategic business intelligence plan with data governance and tactical information protections. Personally managed 140+ terabytes of business intelligence data.
- Identified patterns and trends in large data sets and provided actionable insights.
- Coordinate with business/finance team to create WBR/MFR/QBR docs for CFO & SVP/VP review, and designing high level intelligence-cross functional sharing dashboards only to NDA-signed end users.
- Working with ML, CX, RCX, and RL teams to identify and minimize Amazon fraud. Also, tracking customer and delivery partner refunds to determine modus operandi.
- Program managed and improved accuracy by +25% of existing WW pricing tool for Amazon India by improving its 15+ existing parameters and launching 5 new components.
Senior Associate - Data
Snapdeal
New Delhi
08.2014 - 07.2016
- Compiled information and input into local database.
- Contributed to development of user-friendly dashboards for real-time data visualization and analysis.
- Developed automated processes for routine tasks, reducing manual efforts and increasing productivity levels.
- Generated detailed reports from collected data to inform stakeholders and take action if metrics surpass defined threshold.
- Managed complex projects involving multiple stakeholders, ensuring timely delivery of high-quality data products.
- Employed SQL to query databases and retrieve data.
- Leveraged advanced Excel functions for data manipulation and analysis.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Designed logistic cost calculator on excel to estimate Air and Surface logistic cost.
- Designed daily/weekly/monthly reports in Salesforce for keeping track of resolved cases and calls handled.
- Worked with WFM team to automate 7+ reports, saving 5+ hours of repetitive work to 25 minutes by leveraging Salesforce and excel
- Providing reconciliations, payment advice, commission invoices / TDS reimbursement ledgers, and sales reports with relevant refined data as per seller needs. Also training teams for newly launched processes.
- Created seller knowledge base and SOP for internal usage that backend team updated with new regulations and newly launched content.
Education
B.Tech - Computer Science And Engineering
Excel Institute of Management And Technology
Mathura 08.2008 - 12.2012
Skills
Data Dashboard Design
Accomplishments
- BI for WW first initiative of launching tieired plans and launching Value CX widgets for IN Prime customers, followed by the launch in emerging markets.
- Automation and launch of a new tool for Amazon India goals tracking for Senior Leadership.
- Self-service dashboards for all business needs were launched, and 90+ KPIs were enabled on QuickSight, saving
400+ manhours each month. - Finance Excellence Award
- Amazon door desk award for annual savings of ~120MM.
- Launched a transformative product for India finance reporting and planning. Thereby conserving approximately 600 man-hours.
- Analytics for supporting Jeff B and Amit A customer escalations.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline
Sr.Business Intelligence Engineer(Prime Analytics)
Amazon
10.2016 - Current
Senior Associate - Data
Snapdeal
08.2014 - 07.2016
B.Tech - Computer Science And Engineering
Excel Institute of Management And Technology
08.2008 - 12.2012
Similar Profiles
Jessica MaciasJessica Macias
Area Manager at AmazonArea Manager at Amazon
Deepak P LDeepak P L
Quality Assurance Compliance Specialist at AmazonQuality Assurance Compliance Specialist at Amazon
Kymarha DorsainvilKymarha Dorsainvil
Warehouse Worker at AmazonWarehouse Worker at Amazon
Abdulhalim LarryAbdulhalim Larry
Delivery Driver at AmazonDelivery Driver at Amazon
Dhanush Bochollu KrishnamurthyDhanush Bochollu Krishnamurthy
IoT and Electronics Engineer at Eluxvo LimitedIoT and Electronics Engineer at Eluxvo Limited