Feb 2023 – Oct 2024 · 1 yr 8 mos · Berlin, Berlin, Germany · Remote

Nov 2022 – Feb 2023 · 3 mos · Berlin, Germany

Jan 2022 – Jan 2024 · 2 yrs · Chennai, Tamil Nadu, India

Feb 2021 – Sep 2022 · 1 yr 7 mos · Berlin Area, Germany

• Mentored 150+ students with customised application preparation for Master in Management programs; achieved a 98% success rate
• Mentored Masters students in Europe and helped them secure internships in companies like Henkel, KPMG, Allianz, Amazon
• Consulted small companies and employees on data analytics automation, roadmaps and scraping projects

May 2019 – Jul 2021 · 2 yrs 2 mos · Berlin, Germany

• Developed scripts on Python to enable scraping of client product data and analysed items without stock and reduced manual working time by 5 hours per week
• Pioneered development of visualisations on Data Studio to ensure automation of morning checks for Google Ads accounts
• Built an automated file in Microsoft Excel to ensure easier ways to change bids for keywords in the Google Account
• Developed marketing dashboards on Power BI leveraging varied data sources and automated report scheduling using flows
• Analysed client metrics such as CTR, CPC using SQL and devised custom insights to help improve ROAS by 11% YOY
• Understood basics of Google Scripts and developed scripts to flag campaigns with high number of clicks and minimal conversions

May 2018 – Oct 2018 · 5 mos · Berlin Area, Germany

• Built dynamic dashboards on Google Data Studio giving complete visibility about performance metrics like Conversion Rate, Click Through Rate, Return on Spend
• Conducted A/B tests for email newsletter campaigns and provided suggestions for reducing unsubscription rate of customers
• Optimised google campaigns using product click analysis and suggested bidding recommendations
• Analysed style patterns of products using Principal Component analysis in R; recommended reducing number of styles from 13 to 9

Sep 2016 – Jun 2017 · 9 mos · Chennai Area, India

• Conducting interactive training sessions using innovative techniques for underprivileged primary school kids
• Coordinating with the Kaizen Team and working on the continuous improvement in the existing techniques
• Discussing with the drama team and improving the conceptual ability of students by using stories to teach interesting Mathematics topics
• Conducting BAT analysis to assess the current levels of kids and looking to improve the same by the end of the academic year

Feb 2016 – Jul 2016 · 5 mos · Mexico City Area, Mexico

• Optimised the warehouse occupancy metrics by 10% in Mexico and Colombia
• Created complex logics to track suspicious customers reducing fraud by 3%
• Helped improve delivery effectiveness by 5% and customer satisfaction metrics by 3 points
• Handled the international delivery dashboard providing complete tracking information and detailed metrics about the orders coming from outside Mexico
• Created logics for a supplier scorecard utilising 8 different metrics and supplier data of the past 180 days to categorise suppliers and offer rewards/penalise them based on performance
• Designed a cancellation analysis tool across various stages of the supply chain for Ecuador to improve overall performance
• Performed a stock analysis to identify bugs on the systems with respect to available inventory
• Assigned performance scores to customers and split them into various buckets based on their purchase data
• Created a detailed shipping report providing complete visibility about shipping cancellations, delayed/failed deliveries, shipping accuracy, shipping cost, compliance rate which helped improve shipping metrics
• Sent regular warehouse related data to managers which helped analyse the DPMO(Defects Per Million Opportunities) values week on week across Mexico, Colombia and Peru
• Helped in the development of a SMS tracking dashboard containing key metrics pertaining to sms effectiveness

Jun 2015 – Jan 2016 · 7 mos · Mexico City Area, Mexico

• Developed logics and built a huge report consisting of more than 50 important metrics in Operations specific to Warehouse,Payments,Shipping, Inverse Logistics,Procurement
• Analysed the Key Performance Indicators of Operations every month and reported reasons for increase/decrease in values
• Analysed the customer satisfaction score based on purchase history and relevant metrics of customers using multiple regression
• Built waterfall charts in excel giving visibility about cancellations across the various stages of the supply chain
• Developed a leadtime tool to optimise shipping leadtime in Colombia

Jun 2014 – May 2015 · 11 mos · Mexico City Area, Mexico

• Worked remotely from India for the rocket internet firm Linio
• Managed the daily operations reports specific to deliveries,inverse logistics and warehouse for Mexico, Colombia, Per, Venezuela and Chile
• Developed dashboards on Tableau to improve visibility on procurement and shipping related data
• Analysed delivery, metrics every month by extracting data using SQL and developed dashboards on Excel in the form of story lines
• Worked closely with database administrators, developers and business managers to deliver reports and analyses on time

Jun 2013 – Jul 2013 · 1 mo · Chennai Area, India

• Prepared balance sheets and income statements of private companies from various sources
• Analysed basic financial ratios of companies across the previous 5 years
• Compared the financial numbers between sectors and built excel dashboards for the data

Jan 2013 – Mar 2013 · 2 mos · Tiruchchirappalli Area, India

• Worked on the project ' Diversification of Business Groups during Institutional Transisition'
• Computed key financial ratios on MS excel for a huge volume of data
• Understood concepts like leverage,diversification,current ratio

Dec 2012 – Jan 2013 · 1 mo · Hangzhou, Zhejiang, China

• Participated in an AIESEC internship in Hangzhou, China organised by AIESEC Zhejiang University in December 2012 which involved taking part in the organising activities of a school for differently-abled kids and giving students a foundation course of Indian Culture.
• Interacted with fellow interns from Brazil,Indonesia,China,Romania,South Africa and China..
• Attended local AIESEC meetings and took part in the cultural week activities

Jul 2012 – Aug 2012 · 1 mo

• Certificate in Investment Banking and Business Finance by DeZyre.com
• Studied the basics of business finance covering topics like Income Statement, Balance Sheet, Cash Flow Statement and learnt to develop a 3 statement model
• Learnt about the basics of shares and the various methods of valuing a company like Discounted Cash Flow, Comparable Trading & Acquisition Analysis
• Faculty of the course included former Wall Street investment bankers who had worked on transactions over US$25 billion and worked in top investment banks like Credit Suisse, Merrill Lynch, etc
• Secured an A+ grade in the final exam scoring 55/60 marks