Roopam Attree

Education

Education
Jul 2010 - Aug 2015

IIT Kharagpur

Dual (B.Tech + M.Tech) Degree in Agricultural & Food Engineering || CGPA: 8.19/10.00 (Course Rank – 3)

Apr 2009 - Mar 2010

Army School Kota, Rajasthan

Senior School Certificate Examination (CBSE) || Percentage Obtained: 94.0 % (1st Rank)

Apr 2007 - Mar 2008

Army School Kandrori, Punjab

Secondary School Examination (CBSE) || Percentage Obtained: 94.6 % (1st Rank)

Work History

Work History
Dec 2013 - Jan 2014

Research Project

BNU-HKBU United International College, China

Accomplished 8 week project deadline 3 weeks in advance. Performance led to invitation for Doctoral Studies in Food Science & Technology by Dr. Baojun Bruce Xu

  • Conducted 540 experiments to establish a comparative study between 6 varieties of red & black seed coat peanuts
  • Analysed data using SAS, attaining a multi-dimensional comparison of phytochemical & antioxidant profiles
  • Concluded black variety to have greater protective function against cancer & coronary heart diseases than commonly used red variety
Jul 2014 - Present

Consultant

Buyhatke.com
  • Proposed and developed the full framework for a first of its kind social price discovery platform for apparel merchandising
  • Conducted market assessment including competitor analysis & unique selling proposition (USP) analysis among 89 e-retailers w. r. t 23 parameters
  • Successfully negotiated with CEOs, CMOs and category heads of 20+ fashion portals to get their product listings for the website
  • Overseeing all aspects including ongoing website development
  • Product expected to increase Buyhatke's existing active user base by 24.8% 
May 2014 - Jul 2014

Intern

Housing.com, Mumbai

Business Performance Management of Training & Quality Functions of Operations Division

Data Input Optimization:

  • Reduced man-hours by 46.7% by automating weekly & monthly report generations using VBA Excel Macros

Gap Analysis & Data Modelling

Formulated a model for the holistic performance analysis of Training and Quality functions which:

  • Used predictive analytics for generating weekly benchmark error parameter for 30/60/90 Day analysis for all 13 locations
  • Tracked performance at employee-level by generating timeline with respect to 27 pre-defined indicators
  • Categorized employees based on monthly performance & calculated month-on-month (M-o-M) change in category
  • Performed pareto analysis highlighting the most frequent under-performers of each operating unit

Implementation:

  • Training functions: Reduced property data collection errors by 59.46% with decrease of 17% in errors per flat
  • Quality functions: Increased % properties uploaded (of total collected) by 3.41 ppt. - from 94.92% to 98.33%

Continuous Improvement:

  • Managed a research effort including interviews, surveys & feedbacks to revamp rewards and recognition (RNR) system by diversifying trait appraisals and incorporating a 360 degree feedback model
May 2013 - Jul 2013

Intern

Sattva Consulting, Bangalore

Offered pre-placement offer (PPO) based on the performance and contribution to the projects

Financial Advisory:

  • Established resource mobilization (RM) framework - including SWOT, RM pyramid, funding type matrix & donor mix - to be used as handbook by the company for future clients; drafted case study on RM Systems Assessment
  • Introduced 3-tier opportunity realization (ORP) phase  to streamline the process of evaluating funding opportunities
  • Executed donor research based on 3C framework & developed donor map for 3 clients
  • Instrumental in raising a funding of INR 4.5 lacs for Uttarakhand flood relief campaign 2013 for a client

Strategy Division:

  • Conducted pilot study for a Singapore based client to assess Indian market with focus on social sector & rural businesses

  • Identified 97 potential use-cases in the sectors of Indian microfinance, education & health

May 2012 - Jul 2012

Intern

Times Business Solutions Limited, The Times Group, Noida
  • Optimized search engine results for website of Jobbuzz; Achieved Google PageRank of 3 (57.4% decrease)
  • Keyword analysis using Google AdWords for 5,600+ keywords to estimate competition and number of local & global monthly searches
  • Achieved Advanced Proficiency in virtual platform utilization including stumbleupon, twitter, facebook, blogs, forums and websites
  • Developed database of 580 companies containing details of their corporate websites and social media pages
Aug 2010 - Oct 2011

Head, Youth to Business Forum

AIESEC IIT Kharagpur
  • Supervised a team of 18 to deliver AIESEC’s global flagship event; raised sponsorship amount of INR 5.2 Lacs for the 2 day event
  • Charted partnerships with UN, PwC, TiE & The British Council; Organized workshops on CSR & Entrepreneurship attended by 750+
  • Delivered global village - an event aimed at marketing international internships - attended by 850+ students & 8 international interns
  • Led a team of 7,  responsible for guest reception & delegate servicing of 11 guests & 200 delegates; reduced transportation budget by 14%
  • Spearheaded the marketing campaign; responsible for 4 media & press releases, event reports & online promotion programs
Jan 2010 - Oct 2011

Team Leader, Marketing and Information Management

AIESEC IIT Kharagpur
  • Led a team of 12 which bagged 3 national awards: #1 in virtual platform utilization, twitter performance & campus promotions (among 23 local chapters)
  • Awarded best department overall (among 8 departments) in AIESEC IIT Kharagpur for exceptional performance & overall contribution for the year 2010
  • Led IIT Kharagpur team in Inter IIT Energy Saving championship winning 2nd spot; achieved 2.98% per head savings amounting to INR 47.6 LPA
  • Selected to represent IIT Kharagpur at International Conference 2010 attended by 800+ delegates from 107 countries
Nov 2010 - Jan 2011

Vice President, Organizing Committee, Local Congress

AIESEC IIT Kharagpur
  • Delegated a team of 9 members to plan & deliver the largest local conference of the chapter, attended by 80+ delegates including 12 international participants
  • Responsible for logistics, finance, onsite management, execution, delegate servicing and media relations

B.Tech & M.Tech Dissertation Project, IIT Kharagpur

  • Studied the degradation kinetics of colour and vitamin C content during thermal processing of pineapple puree. Developed a mathematical model using Matlab to predict the order of the kinetic model followed by a parameter (B.Tech Project, July 2013 - May 2014)
  • Developing kinetic models for the degradation of quality parameters - ascorbic acid, colour, total phenolic content and total antioxidant activity - during thermal treatment of pineapple puree to optimize and extend its shelf life (M.Tech Project, July 2014 - Ongoing)

Skills

Skills

Microsoft Office

Advanced Microsoft Excel

Adobe Photoshop

Adobe Indesign

Adobe Illustrator

Matlab

Oracle & SQL

C

Relevant Courses

  • Economics
  • Probability and Statistics
  • Introduction to Financial Management
  • Cash Flow Analysis and Finance

Scholastic Achievements

  • Awarded certificate of Merit by CBSE for being in the top 0.1% of successful candidates of AISSCE in Mathematics and English Communications, 2008
  • Only student in the entire school (among 80+) to score 100% in Mathematics in Class X, 2008
  • Consistent recipient of AWWA Scholarship under Army Welfare Scholarship Scheme for academic excellence from Class VI to XII
  • Consecutive class topper from III to XII standard

Extra - Curricular Activities

Fashion:

  • Designed a social channel for fashion enthusiasts (1000+ followers) which got covered by Styletag (India’s 1st multi designer luxury store), 2013
  • Offered internship as a trainee fashion designer at Shop Nineteen (awarded Emerging e-retailer of the year, 2013), 2012

Social:

  • Part of the organizing team of 2 Bangalore based events on the theme of ‘Green Consumption’ which impacted over 1500 citizens (2012)
  • Hosted Green Business Summit, Vision Green,  IIT Kharagpur where 450+ delegates representing the corporate sector, social sector, faculty and students interacted and shared their expertise, knowledge and future plans regarding environmental protection (2010)

School:

  • Awarded the Title of “Ms. Army School 2008” along with a gold medal for being the most outstanding student, 2008

  • Successfully completed 30,000 feet high Mcleodganj – Triund trek; represented school at zonal level hockey tournament, 2006 - 07

  • Gold medallist in inter house hindi declamation; bronze medallist in inter school english debate & best speaker in inter house english debate, 2006 - 07

  • Awarded A++ in hindi handwriting Competition organized by Rashtrabhasha Vikas Parishad and A+ in painting & english essay writing competition conducted by Centre For Educational Development & Research, Pune on PAN India level, 2005