Feb 2022 – Sep 2022 · 7 mos · Chicago, Illinois, United States · Remote

• Retrieved SAP data through REST API GET request, transforming into DataFrame from JSON using NumPy and Pandas in Python
• Developed Process Mining in Power BI on transformed SAP DataFrame to analyze financials and logistics data, revealing process
• performance insights, bottlenecks, and improvement opportunities
• Built a custom connector using Power Query's M-language, enabling seamless access to on-demand SAP data from REST API
• within MS Office/Power BI and reducing time to value from 6 months to just 1 week
• Led the successful certification process of the SAP custom connector in Power BI/ Microsoft Excel, collaborating with the
• Microsoft ISV team and contributing to the Microsoft GitHub repository by forking the relevant files

Mar 2021 – Feb 2022 · 11 mos

• Developed a consolidated control tower using SQL and Tableau to track real-time performance metrics, enabling prompt
• problem identification and resolution and improved transaction/leads ratio from 65% to 80%
• Increased gold loan Repeat Rate through targeted advertising campaigns on SMS and Rupeek App,enhancing customer retention
• Formulated tailored team-wise leads and delivery target plans for repeat gold loans, involving Inside Sales, Sales, and Operations
• Efficiently fulfilled regular ad-hoc data requests from Growth and Product teams by writing complex SQL queries

Jul 2020 – Mar 2021 · 8 mos

• Played a crucial role in Rupeek being named as the fastest-growing tech startup in India by Deloitte
• Tracked delivery operations and collaborated with city heads & quality assurance team to reduce loan cancellations in new cities
• Worked with call center team to enhance productivity across repeat lead channels (IVR, website, BAS, Google, DM)
• Created daily performance trackers across 30 cities along with delivery funnels to identify root causes for enhanced efficiency

Feb 2020 – Feb 2020 · 0 mo · Cambridge, Massachusetts, United States

• The Harvard Project for Asian and International Relations (HPAIR) is a forum of exchange to discuss and learn about the most important economic, political, and social issues facing the Asia-Pacific region.
• Selected among 300 delegates from all over the globe. The Conference was held from 14th-17th Feb 2020 at the Harvard University.

Jun 2019 – Jul 2019 · 1 mo · Mumbai, Maharashtra, India · Remote

• The Money Roller is a Financial Research and Analytics hub. It is a platform to learn about fact-based research and analysis.
• The Live Project involved the Derivatives Research on Price, PCR and Open Interest Strategies.
• Learned about the Option Pricing and Option Greeks through the Masters Derivatives Research Program; understand how Put-Call Ratio (PCR) and Open Interest (OI) can be used to analyze the market and to develop strategies.
• Gained how to extract and plot PCR OI along with the underlying in the excel.
• Analyzed the movement of the FMCG stocks along with the underlying price using the past 4 year data to look for key reversal pointers and take positions from the option buyer's perspective.
• Studied the correlation of the FMCG Index with the PCR Added which was a Sector-based PCR Research.
• Learned how the plotting of same sector stocks in a graph can give insights about position building that is happening in a sector.

Feb 2019 – Feb 2019 · 0 mo · Cologne, North Rhine-Westphalia, Germany

• The World Business Dialogue is the largest international student-run business convention that brings together selected students around the globe and the eminent personalities from economic, political, and science background for a cross-generational and cross-cultural dialogue.
• I got selected among the 300 delegates from a very selective pool of students and corporates from all over the globe.
• Attended the 5-day long meet-up at the University of Cologne from 18th-22nd February 2019.
• Participated in the 'University of Cologne Creation Lab' after getting shortlisted among 90 (out of 360) delegates. Worked with 5 other delegates from India, Peru, Taiwan, Germany, and Russia in the Creation Lab.

Jan 2019 – Jan 2019 · 0 mo · Roorkee, Uttarakhand, India

• Revived the Inter Hostel Sports Meet; Led to a twofold increase in student participation in college sports tournaments.
• Amended the Sports Council calendar to incorporate Inter-Hostel Sports Meet as the primary sporting contest.
• Led the 25 member team including 12 hostel sports secretaries to organize the first-ever 3-day sports meet.
• The tournament witnessed the participation of 900+ players (Boys and Girls) coming from UG, PG, Married and International students.
• 13 games were played among 12 hostels with 150+ matches regulated in 3 days.

Oct 2017 – May 2018 · 7 mos · Roorkee, Uttarakhand, India

• Responsible for taking the executive decisions regarding the Sports affairs of the campus.
• Conducted the Inter-Hostel Sports Meet'18 leading the team of sports secretaries from 13 hostels.

May 2018 – Jun 2018 · 1 mo · Gurugram, Haryana, India

• ZiffyHomes is a living solace for young professionals with excellent services and full-time support to all the customers. It works towards providing the highest standards of living for young professionals and saving them from woes of the house hunt.
• Property Acquisition and Lead Generation Project :
• Generated around 20 leads per day by reaching out to owners and brokers of Gurgaon and also, scheduled visits for property acquisition.
• Built an excellent number of base supply of properties with parallelly matching the demand in the market.
• Provided the assistance to operations team by outlining all the problems of tenants and assigning them to the respective authority.
• Also carried out rent collection with the Finance team for around 700 tenants

Feb 2018 – Mar 2018 · 1 mo · Roorkee, Uttarakhand, India

• E-Summit organized by E- Cell, IIT Roorkee with the aim of fostering the spirits of entrepreneurship catering with quality knowledge regarding the field.
• Responsible for associating the media partners with the E-summit IIT Roorkee.
• Led the team of offline promotions in zonal areas like Dehradun, successfully able to get footfall of 200 people.
• Successfully able to associate The Tribune, Inc42, and Monkey Teller as the official media partners.
• Coordinated the B-Plan competition Contrive wit participation of over 40 teams from Business Schools and Colleges across North India in the inaugraul E-Summit 2017.

Jan 2018 – Feb 2018 · 1 mo · Roorkee, Uttarakhand, India

• National Social Summit, the social fest of IIT Roorkee, is aimed at finding innovative and feasible solutions to the problems of society through discussions among various stakeholders like NGOs, Social Workers, Entrepreneurs, Government Officials, and Common People.
• Development of strategic partnerships and extensive fundraising.
• Directed the team of 10 in raising sponsorship from local shopkeepers.
• Managed to get the sponsorship of 2.8 lac for the inaugural National Social Summit.

Feb 2017 – Mar 2017 · 1 mo · Roorkee, Uttarakhand, India

• Platform for merchants like restaurants, bars, cafes & salons of Roorkee & Dehradun to get instant customers when outlets are vacant by pushing real-time offers through push notification service.For customers - they get offers and can pre-order to save time & money.
• Platform for merchants like restaurants, bars, cafes & salons of Roorkee and Dehradun to get instant customers when
• outlets are vacant by pushing offers through push notification service.
• Organised various events for brand building.
• Implemented marketing strategies to improve sales and marketing efficiencies.
• Promoted the brand in Roorkee and Dehradun.
• Analyzed the market of Roorkee and Dehradun for potential clients and cultivated approximately 50 users.
• Enhanced their Sales by sending on average 2-4 customers per day through Pibit.