Nirav Shah
Pen
Summary
Experienced analyst with a combined 3 years in data and business analysis, driving operational efficiencies and revenue growth through data-driven strategies and market insights. Excel at data visualization, process optimization, and cross-functional collaboration to support key business decisions.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Business Analyst
Gifting Affair
Mumbai
2022.07 - Current
- Played a pivotal role in establishing the business analytics framework for the startup, enabling data-driven decision-making from the outset.
- Conducted comprehensive market research to identify niche opportunities in the corporate gifting sector, directly influencing the company's initial product line and service offerings.
- Personally managed relationships with key suppliers and negotiated terms that ensured cost-effective procurement of high-quality products, crucial for a startup's budget and quality standards.
- Designed and implemented an efficient inventory management system, adapting to limited storage space and optimizing the small team's resources.
- Developed targeted marketing strategies that leveraged social media and word-of-mouth, significantly increasing brand visibility and attracting our first 10 corporate clients within a year.
- Created custom welcome kits and corporate gifts by closely collaborating with clients, ensuring each product uniquely represented the client's brand and met their specific needs.
- Initiated and maintained end-to-end client communication, from initial contact through product delivery and post-delivery follow-up, enhancing customer satisfaction and loyalty.
- Adapted quickly to fill multiple roles within the company, including operations, customer service, and marketing, demonstrating versatility and a commitment to the startup's success.
- Leveraged analytics to track and improve the customer journey, identifying key touchpoints for engagement and feedback that informed product and service enhancements.
- Organized and participated in local business events to network with potential clients, gaining valuable insights into corporate needs and preferences in the gifting industry.
Data Analyst
Hansa Cequity
Mumbai
2021.08 - 2022.06
- Collaborated closely with esteemed clients, such as Mahindra Auto, Bajaj Auto, BPCL, and Royal Enfield, to deliver high-value insights.
- Conducted essential data cleaning and transformation for business intelligence reports, creating queries to merge disparate data sources into a unified customer view, incorporating lookup and deduplication.
- Identified and analyzed trends/patterns in results, pinpointing areas of improvement based on complex data sets, including campaign engagement and customer interactions.
- Implemented numerous stored procedures and functions to apply logic for various business KPIs, including Enquiry to Retail conversion rates.
- Developed performance reports and dashboards using PowerBI and Tableau to report key indicators like customer engagement, click rates, and brand heat maps for senior leadership and business partners.
- Conducted ad-hoc data analysis to address specific business questions, including monthly reviews, ETBR reports, and internal reporting, measuring client satisfaction and performance metrics alongside vendor partners.
- Managed campaign performance reports, analyzing click, open, delivered, bounce rates, and cost-per-click data to calculate return on investment (ROI) and support business growth.
- Maintained unified views of customers, prospects, and leads for various marketing activities by integrating data through web services, third-party applications, and internal systems.
- Conducted data mining and analysis of customer segments, deriving actionable insights for key customer accounts.
- Maintained ETL Data Pipelines, stored procedures, and reports for the data warehouse, ensuring accurate delivery of daily batch jobs.
Education
Bachelors in Mechanical Engineering -
SVKM's Dwarkadas J. Sanghvi College of Engineering
06.2021
Diploma in Mechanical Engineering -
SVKM's Shri Bhagubhai Mafatlal Polytechnic
06.2018
Skills
- MS SQL
- Google BigQuery
- Microsoft Excel
- Google Data Studio
- Tableau
- PowerBI
- Data Mining
- Data Visualization
Certification
- Data Visualization with Tableau by UC Davis
- SQL Server Tutorial for Beginners by Kudvenkat
- MS-Excel by Tutorials Point
- PowerBI for Beginners by Tutorials Point
Languages
- English
- Hindi
- Gujarati
- Marathi
Timeline
Business Analyst
Gifting Affair
2022.07 - Current
Data Analyst
Hansa Cequity
2021.08 - 2022.06
Bachelors in Mechanical Engineering -
SVKM's Dwarkadas J. Sanghvi College of Engineering
Diploma in Mechanical Engineering -
SVKM's Shri Bhagubhai Mafatlal Polytechnic
- Data Visualization with Tableau by UC Davis
- SQL Server Tutorial for Beginners by Kudvenkat
- MS-Excel by Tutorials Point
- PowerBI for Beginners by Tutorials Point
Similar Profiles
SAGAR PURSWANISAGAR PURSWANI
Managing Director at ISP Gifting & Events FZEManaging Director at ISP Gifting & Events FZE
Emily RyanEmily Ryan
Owner at Bluebird Gifting CompanyOwner at Bluebird Gifting Company
Ashley LagaresAshley Lagares
Childcare at Family And Friends GiftingChildcare at Family And Friends Gifting