Vineet Saxena
BI Project Manager
Pune
Summary
Seasoned analytics and BI professional with over 15 years of experience in Consulting, E-commerce and IT Services. Committed for the growth with high value business insights with the help of new age technology.
Overview
14
14
years of professional experience
4
4
years of post-secondary education
6
6
Certificates
2
2
Languages
Work History
Software Architect - Data & Analytics
iLink Digital
Pune
11.2020 - Current
- Accountable for End to End solution; including scoping of project, development, testing, deployment and documentation.
- Translate Client’s requirement into developers designed solution, review proposed solution and optimize it when required.
- Develop/design Data Models for Reporting.
- Understanding Data Sources involved in Data models and ability to create/ recommend views/ tables to consume.
- Client communication, stakeholder's management, Project Management, Sprint Planning etc.
- Achieved average quality score of 70% for all projects managed so far.
- 90% projects delivered on time with high quality.
Manager Analytics & Business Insights
Myntra Jabong India Pvt. Ltd.
Gurgaon
09.2017 - 01.2020
- Derived forward-looking insights from ongoing analytics projects to offer predictive intelligence for ongoing business decision-making.
- Translated complex business objectives into actionable data management plans for individual clients and customer classes.
- Worked on data visualization projects for Marketing, Inventory, Warehouse, Customer Care and Product for delivering comprehensible and invaluable visuals for presentation to audiences of different technical understanding.
- Created custom dashboards and interfaces designed specifically to suit customer needs and priorities for optimal performance.
- Helped marketing team to improve their KPIs (CAC, ROAS, CIR, CPO, CTR, CPC etc.), Inventory KPIs (Average Days to Sell Inventory, Avg. Return Rate, Inventory Value and Units etc.) and Product KPIs (improve bounce rate, time spent on website, quality of traffic, A/B testing analysis) for measurement of growth.
- Valuable marketing insights helped revenue increased by 10%. Campaigns revenue increase by 20%.
Senior Manager Analytics
GirnarSoft Pvt. Ltd.
Jaipur
01.2016 - 03.2017
- Developed and implemented performance improvement strategies and plans to promote continuous improvement for Marketing and BI functions.
- Developed end to end reporting for Marketing and Product to help them grow with data backed decision making.
- Drove operational improvements which resulted in savings and improved profit margins.
- Proved successful working within tight deadlines and fast-paced atmosphere.
- Helped marketing to Improve content quality with high value business insights.
- Helped Customer Care team with Lead Ratings Algorithm for quality leads and improvement in Customer Care team by 50%
Deputy Manager-Business Intelligence
Jade eServices Pvt. Ltd.
Gurgaon
02.2012 - 12.2015
- End to end implementation of BI-Data warehouse Project for Jabong starting from Data Modelling in Erwin (conceptual, logical, and physical data models), setting-up ETL (Extract from different sources, Data Transformation and Load in SQL Server).
- Developed BI reports for Marketing, Production, Warehouse, Inventory, Campaign Marketing for efficient decision making and proactive actions. Also ensuring accurate and timely reporting to top management and stakeholders.
- Monthly transactions validation for Affiliates payout. Reconciliation of Affiliate transaction and validating them against Jabong’s transactional database. and helped them to achieve their targets with valuable insights.
- Customer segmentation was done based on historical buying behavior of customer’s base. intent of such targeting was to lead to more cross-selling and up-selling opportunities and enhanced business metrics such as ATV (average transaction value) and IPO (Item per order) by 50%.
- Evaluated suppliers to maintain cost controls and improve operations. These initiatives improved inventory cycle by 20%.
Data Analyst
McKinsey Knowledge Centre India Pvt. Ltd.
Gurgaon
02.2007 - 01.2012
- Carrying-out various financial analysis, M&A analysis, competitor analysis and Valuation analysis for different industries / companies.
- Presenting PowerPoint and Excel reports and presentation material according to high quality standards, within production guidelines and against tight deadlines.
- Performing stated responsibilities with superior professionalism, often under very tight deadlines, while ensuring high level of accuracy and quality.
- Collating data and information through subscription databases, analyst/annual reports, Google and other search engines.
Sales Coordinator
Reliance General Insurance Co. Ltd.
New Delhi
05.2006 - 02.2007
- Updating & analyzing the daily / weekly / monthly Sales MIS reports.
- Prepare the monthly commission reports of the agents & incentive report of the sales team to keep a track on the performance of Sales team.
- Resolving issues of agents and sales team.
- Acting as single point of contact for vendors, customers and sales team.
- Coordinating with various departments in order to identify issues and fix them.
Education
Bachelor of Technology - Computer Science
U.P. Technical University
Lucknow 06.2002 - 05.2006
Skills
BI Project Management
Marketing Analytics
Power BI
Tableau
Google Analytics
SSRS
SSIS
SSAS
Machine Learning
Python
MS Excel
MS Powerpoint
Data Warehouse
SQL
A/B Testing
AWS/Azure, Redshift, Alteryx
Certification
Implementing a Data Warehouse SQL Server 2019
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Software Architect - Data & Analytics
iLink Digital
11.2020 - Current
Implementing a Data Warehouse SQL Server 2019
05-2020
Power BI Data Modeling with DAX
04-2020
Power BI Essential Training
04-2020
Introduction to Attribution and Mix Modeling
03-2020
Learning Web Analytics
03-2020
Programming for Everybody - University of Michigan (Getting Started with Python)
01-2019
Manager Analytics & Business Insights
Myntra Jabong India Pvt. Ltd.
09.2017 - 01.2020
Senior Manager Analytics
GirnarSoft Pvt. Ltd.
01.2016 - 03.2017
Deputy Manager-Business Intelligence
Jade eServices Pvt. Ltd.
02.2012 - 12.2015
Data Analyst
McKinsey Knowledge Centre India Pvt. Ltd.
02.2007 - 01.2012
Sales Coordinator
Reliance General Insurance Co. Ltd.
05.2006 - 02.2007
Bachelor of Technology - Computer Science
U.P. Technical University
06.2002 - 05.2006