SZ

Sanket Zambre

Senior Business Intelligence Analyst · Drinks Holdings Inc

Los Angeles

Work Experience

Senior Business Intelligence Analyst

Drinks Holdings Inc

2019 – Present

• Implemented Business intelligence solutions across key business departments using Tableau to drive business decisions. • Trained employees on Airtable and Tableau for improved data management, monitoring effectiveness and suggesting improvements. • Collected data from wide-ranging sources, including Alchemer, Netsuite and hubspot using Python API integrations and designed optimized database systems for reporting. • Responded to specific BI requests from marketing, operations and finance executives, creating data packets with requested information in easily understandable formats. • Participated in requirements meetings and data mapping sessions to understand business needs. • Analyzed the customer lifetime purchase history and customer satisfaction survey responses to generate powerful customer segment groups using sentiment analysis, predictive modelling and cohort analysis. • Designed google data studio reports to monitor daily, weekly and monthly performance of website by tracking customer engagement metrics from google analytics. • Mapped current business and operational processes and recommended areas for improvements in reporting infrastructure to assist all senior management. • Increased the annual revenue by 25% by recommending and reshaping product packaging, upselling and promotional email marketing strategies of Drinks. • Using external covid-19 data from snowflake, analyzed the impact of covid19 on shopping behavior of customers online vs at stores. • Generated key data insights on customer demographics to analyze business impact on different gender, age groups and generations by region and state. • Supported data migration tasks to migrate databases from Amazon Redshift to Snowflake cloud and Amazon AWS to Azure. • Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.

Fraud Data Analyst

Dot Corporation

2018 – 2018

• Daily Reporting tasks to track down account disputes, overdraft transactions, negative balance accounts etc. • Analyzed the transactional datasets and built Sql rules to find suspicious account activity or identity theft for flagging the fraud at account and transaction levels. • Extracted data from financial transactions and payment invoices and built ad-hoc reports for finance team to identify missing invoices for each year. • Actively Involved in daily finance meetings with chief financial and portfolio officers to manage budget, track profit-loss in the company etc.

Business Data Analyst Contract

Oxgord, Inc

2017 – 2017

• Extracted customer reviews from Amazon and built sentiment analysis algorithms for identifying strong effective keywords to optimize SEO marketing performance. • Built forecasting models using sales history to forecast the product demands for managing inventory to identify out of stock/overstock products regularly. • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes. • Built library of models and reusable knowledge-based assets to produce consistent and streamlined business intelligence results. • Developed database objects, including tables, views and materialized views using SQL.

Systems Engineer

Infosys Technologies Ltd

2011 – 2014

• Actively delivered projects with UI development tasks, backend database mapping tasks using Finacle CRM and Sql tools to lead both onsite and offshore teams. • Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality. • Developed customer loan milestone reports for tracking down the performance and success rates of each secured and unsecured loan approval process.

Education

Bachelor of Engineering

Fr. Agnel's Institute of Technology

2011

Bachelor of Engineering

Master of Sciences

The University of Texas at Dallas

2016

Master of Sciences