2 years of experience as a Data Analyst working with technology marketplace for home service. Also, Certified Data Analyst Professional with a passion for solving real-world business challenges using analytics and visualization tools. Proficient in translating business specifications into technical requirements for streamlining existing processes and delivering user-centric solutions.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
URBAN COMPANY (FORMERLY URBANCLAP)
08.2022 - Current
Have done mining, processing, interpretation and analysis of data using SQL on Snowflake (warehousing cloud) and Excel.
Managed and fulfilled data needs of mid to senior management of the painting category - LHP and Bite Size across cities.
Have given meaningful prescriptive and predictive analysis to EIR (Entrepreneur in Residence) of funnel conversion from cat start to conversion coming via UC app.
Modification of UC interfaces visible to customers was highly correlated to interpretations that were done by me along with EIR- chalking out maximum contribution at which stage and reason for drop off, time span that each customer is spending on each page, selection of SKUs and so on.
Created complex queries and dashboards around the supply side to solve rescheduling, cancellation and FBCE metrics.
Developed data-centric preface for a newly launched sub-category - Bite Size which is being followed by city teams across the country.
Created Growth Tracker, Fulfillment and Onboarding dashboard on Jarvis for Bite Size which will give an overall view of the status of the sub-category.
Created Demand Projection Model on Excel using past data and tried to find out insights using descriptive analysis.
Have done introspection on the UC interface of Bite Size and gave legitimate recommendations on necessary changes to the UC app- It helped in increasing the conversion rate from 0.5 % just a month after its launch to around 3-4% over the span of the next one month
Have helped reduce the FBCE (Bad experience to customers) from 13-14% to around 6% in a span of one month.
Have led a inside sales team in peak season and brought business of Rs 16 lacs and net revenue of 3.6 lacs.
Pro onboarding conversion was improved by 2pp from lead attempts to RTGL by solving methods to conduct screening.
Have also done surveys, feedback on new experiments and have even resolved various customer grievances.
Worked on B2B business proposal, stock management, finance management of a hub which caters to 3 districts of WB.
Management of hub and its stock on Excel and reportage to HO on a daily basis.
Helped increase the sales of the company by about 10 times during Covid when compared and reduced cost to company by about one-tenth.
Business Development Associate
Urban Company
01.2022 - 07.2023
Worked as a Business Development Associate at Urban Company, where I was responsible for driving business growth and expanding the customer base.
I collaborated with cross-functional teams to identify new business opportunities, develop sales strategies, and build relationships with clients.
I Utilized my strong analytical skills, I analyzed the market trends and customer data to identify areas for improvement and implement strategies to maximize revenue.
Education
Bachelor of Technology - Information Technology
Heritage Institute of Technology
Kolkata,WB
08-2022
XII -
Salkia K.B.R. Girl's High School
03-2017
X -
Salkia K.B.R Girl's High School
03-2015
Skills
SQL
MS-Excel
Python
Tableau
Java
Data mining
Data processing
Data interpretation
Data analysis
Dashboard creation
Supply chain management
Metrics analysis
Business Reporting
Data modeling
Demand projection
Customer experience improvement
Certification
Able's Analytic Program
Timeline
Data Analyst
URBAN COMPANY (FORMERLY URBANCLAP)
08.2022 - Current
Business Development Associate
Urban Company
01.2022 - 07.2023
Bachelor of Technology - Information Technology
Heritage Institute of Technology
XII -
Salkia K.B.R. Girl's High School
X -
Salkia K.B.R Girl's High School
Similar Profiles
RAHUL JOTWANIRAHUL JOTWANI
Category Manager - AC Repair & Seasonal at Urban Company (previously UrbanClap)Category Manager - AC Repair & Seasonal at Urban Company (previously UrbanClap)