Simonel Garrad Email & Phone Number

Pune, Maharashtra, India

India

- Creating SQL queries for reporting and monitoring on success metrics for Feature Launches on the Platform- Using Looker to create visualizations for Stakeholders to make data-driven decisions- Designing and implementing data models as a Look ML developer that helps all data users in the organization access key metrics

India

- Only point of contact for all Data Related requests for the Insurance Business Unit that included :1. Creating App Scripts to prefill Google Sheets2. Creating complex SQL queries using Snowflake to provide insights to the team using data that was volatile and voluminous3. Utilizing Python to create scripts that connected several data sources which helped team members have their processes automated which reduced 40% of time and stakeholders to make data-driven decisions4. Creating SQL queries to Monitor and Report success metrics for new feature launches made on the Platform5. Solely responsible for providing immediate remedial data during Outage situations.

Mumbai, Maharashtra, India

1. Dashboarding and Visualization- Responsible to provide Marketing Team insights onoptimisation of marketing costs and metrics like Open Rate andClick Rate for communications sent- Maintenance of the Real time Dashboard that is used across theorganization for Core Business metrics which updates at every15 minutes- Created dashboard that gives one view of the Customer2. Website Events Tracking- Tracking of Website Events using Google Tag Manager tovarious third party tools like Google Analytics/Google Analytics4 and Marketing Automation tools- Created a Dashboard that provides view of the User Journeyover the Website- Writing Python scripts that sends data through APIs to powercritical trigger journeys to the Marketing Automation Tool- Created an Alert Mechanism Dashboard for trigger journeys3. Merchandising using Machine Learning- Solved Merchandising using K- Means Clustering Algorithm.- Research and Analyzed data of the product type to create abase dataset that consists of key product performance metricslike product views, clicks, frequency of sale- Normalized data using the Standardization technique and Applied the K-Means Algorithm- Created a dynamic scoring model to Rank the clusters based onperformance- Automated the algorithm to sync with a recommendation toolused to display the products over the websiteTools Used: Python, Google Cloud Function and Google CloudStorage

- Responsible for teaching coding concepts through gamedevelopment and app development in JavaScript and ReactNative to students between grades 7-9

Mumbai, Maharashtra

- Created Databases of potential buyers for purchasing or mergingwith current business sellers based on requirements- Prepared business decks and trailers of clients and pitched thecompany’s working to potential buyers- Maintained constant communication with clients on the status ofthe project

Bachelor'S Degree, Statistics, 3.33/4

Activities and Societies: Axiom'16 Mathematics fest ; Malhar'16 Indian Performing arts Volunteer; Orchestra Singer for 30 years completion.

Masters Of Science, Statistics, 8.6/10

Activities and Societies: Class Co-ordinator for Year 1 and Year 2; Second prize winner for Research Competition