Shubham Tiwari
Business Analyst
Pune
Summary
- Business/ Data Analyst with 3+ years of experience in interpreting and analyzing data for driving business solutions.
- Proficient knowledge in statistics, analytics and related tools.
- Experienced in business operations, reporting & managing complex data analysis
- Expertise in defining scope of projects based on business requirements including documentation of constraints, assumptions, business impacts and project risks
Overview
3
3
years of professional experience
7
7
years of post-secondary education
5
5
Certifications
Work History
Business Analyst
Onlinesales.ai
Pune
01.2022 - Current
- Collected and analyzed data using SQL to carried out in depth research in order to develop data driven marketing strategy and plans for ecommerce marketplace like Purplle,Tata 1Mg,Tata Cliq,Zepto,Konga,
- Worked with Tableau analyzing reports and other data associated with the Office and stores data out of which patterns are generated from the large Datasets.
- Designed key metrics dashboards, Parameterized reports using SQL aggregate functions and Tableau which were used by various stake holders in taking data driven decisions
- Performed data analysis tasked with managing and interpreting data from social network sites, market research, sales figures, logistical information and financial records to help the executives make better business decisions.
- Analyze a breath of paid media using Excel and Tableau and creative data to provide insights and recommendations into the performance of clients program initiatives .
- Helping e-commerce marketplaces around the world by running their successful seller monetization programs (Sponsored Product Ads,Sponsored Brand Ads, Sponsored Display Ads) which are helping them drive incremental revenues and create strong relationships with their brands and seller base
- Worked with stakeholders and clients to model and document goal,communicating transparently to meet 98% of deadlines
- Identified opportunities for improvements along with the stakeholders and analyzing customer journeys before writing User Stories.
- Helped to improve monthly ads spend for client by over 110% for Purplle and Tata 1Mg.
- . Engaged in demand & supply side planning, Campaign optimization, revenue planning and conduct joint business planning to strengthen partnership and unblock revenue growth opportunities across books of business.
Process Data Analyst
Reliance Industries Limited
Mumbai
08.2019 - 12.2021
- Diminished process gaps and encouraged optimal productivity by closely supervising workflow of claims analysts.
- Prepared technical reports by collecting, analyzing, and summarizing information and trends using MS SQL Server and MS Excel.
- Monitoring and troubleshooting related to plant to
minimize operating cost. - Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
- Increased efficiency and productivity by 40% across all sites of RIL
- Presented & reported the full analysis to the higher management and gave suggestions about on increasing energy efficiency and reducing the maintenance cost of all equipments
- Developed and implemented analysis, reports, and metrics to represent the business performance for the organization.
- Researched and compiled tailored monthly analytics and reports for senior management with OM Pro software.
- Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
Education
Bachelor of Technology - Chemical Engineering
National Institute of Technology
Surat 07.2015 - 07.2019
XII -
UNM Inter College
Lucknow 07.2012 - 05.2014
X -
UNM Inter College
Lucknow 07.2011 - 05.2012
Skills
Strategic planning
Data analysis
Operations analysis
SQL and databases
Pivot tables
Consulting
Accomplishments
- Coordinated cross-functional teams and provided business analysis for 3 projects totaling INR 50 million.
- Process Improvement - Achieved revenue objective by implementing cost-cutting measures.
- Reduced organizational operating costs by 15% by streamlining processes.
- Provided 200% YOY growth in Monetization revenue of ecommerce marketplace Purplle and Tata 1mg
Certification
Master SQL for data science:By Imtiaz Ahmed (Udemy)
Timeline
Coursera Google analytics
07-2022
Tableau Desktop for accurate business analysis- byJane Crofts(Udemy)
06-2022
Business Analyst
Onlinesales.ai
01.2022 - Current
Master SQL for data science:By Imtiaz Ahmed (Udemy)
12-2020
Excel Essential training office 365 on LinkedIn training
06-2020
Tableau Desktop for accurate business analysis- byJane Crofts(Udemy)
02-2020
Process Data Analyst
Reliance Industries Limited
08.2019 - 12.2021
Bachelor of Technology - Chemical Engineering
National Institute of Technology
07.2015 - 07.2019
XII -
UNM Inter College
07.2012 - 05.2014
X -
UNM Inter College
07.2011 - 05.2012