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
Business Intelligence Analysis
Data Warehousing /Data Modelling
Advanced Excel
Project Management
Requirements Analysis
SQL and Databases
Process Improvement
Advanced analytics
Python Coding
ETL- Datanet, Cradle, Datacraft
AWS Redshift, S3
QuickSight
MS Office
Time Management
Flexible and Adaptable
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