Rishika Gupta Email & Phone Number

Santiago De Compostela, Ga, Es

Paris, Île-De-France, France

Programme Representative for BDMA

Levallois-Perret, Île-De-France, France

Worked at the Global L'Oreal Luxe Division● Developed Python scripts and Machine Learning methodologies to process, cleanse, and automate anomaly detection for website traffic data collected by Google Analytics, improving data accuracy by 15% and avoiding 10 hours per week of manual data verification● Performed deep-dive analyses of customer purchasing data using Python, unveiling insights that improved customer acquisition strategies by 10%● Engineered a Google Looker Studio dashboard to visualise various key business KPIs, eliminating manual reporting time of 20 hours per week

United States

The title "KECTIL" refers to the "Knowles Educational and Charitable Trust for International Leadership". The goal of this program is to nurture, network, and mentor youth in developing countries who have the potential to be leaders and make a positive difference in their communities, countries and maybe even the world!The KECTIL Program was created to identify and nurture highly talented youth in developing countries who have the potential to make a positive difference in their communities and countries.The Program works to achieve these goals in three parts: a one-year Web-based Program.

Mumbai, Maharashtra, India

Worked in the Database Team● Devised, debugged, optimised, tested & deployed over 100 PL/SQL scripts & Oracle procedures, enhancing data quality & accuracy by 18%● Automated daily runs & optimised data loads and refresh cycles using Oracle PL/SQL, yielding a time efficiency gain of 25% across daily operations● Assisted in migrating on-premise data infrastructure to AWS cloud services, resulting in 25% cost reduction & improved scalability for growing data demands● Compiled data flow diagrams and documentation for various in-house database-related integrations which improved the onboarding process for new team members by 50%

Mumbai, Maharashtra, India

● Conceptualised and developed 15+ control scripts in PL/SQL from scratch to corroborate legitimacy of data as per business logic with 90% of them accepted by the manager to be deployed in the production environment● Communicated effectively with Information Technology Team to handle records failing business validations

Chembur, Maharastra, India

● Created and populated an extensive BigQuery database with 1 crore customer response details using SQL and Python, decreasing manual labour by 8 hours/week● Programmed robust forecasting using Scikit-learn on sales data for appropriate target campaigning to improve customer retention by 10%● Created a visually impactful dashboard from the scratch using Python, Django, Pandas, MatplotLib & JavaScript providing real-time insights and trends of the campaign's various key performance indicators

Master Of Science - Msc, Erasmus Mundus Joint Master'S Degree (Emjmd) Of Big Data Management And Analytics (Bdma)

Master Of Science - Msc, Erasmus Mundus Joint Master'S Degree (Emjmd) Of Big Data Management And Analytics (Bdma)

Courses: - Semantic Data Management - Big Data Management - Machine Learning - Big Data Seminar - Debate on Big Data and Ethics.

Master Of Science - Msc, Erasmus Mundus Joint Master'S Degree (Emjmd) Of Big Data Management And Analytics (Bdma)

Courses: - Advanced Databases - Data Mining - Data Warehouses - Database System Architecture - Management of Data Science and Business.

Bachelor Of Technology - Btech, Computer Science, 9.58

Activities and Societies: Training and Placement Coordinator at Training and Placement Office || Technical Secretary at Women.

Hsc, Computer Science, 87.38%

Class Xth, Cbse Board, 96.6%

Secondary School, Ssc Board