Deekshya Singh Deo
Summary
Results-driven Senior Marketing Science Analyst at Annalect with a proven track record in SQL and data visualization. Achieved a substantial reduction in reporting workload through strategic automation and optimized data transfers. Skilled in developing insightful dashboards and enhancing data ingestion processes, providing stakeholders with actionable insights. Committed to leveraging analytical expertise to drive data-informed decision-making.
Overview
7
7
years of professional experience
Work History
Senior Marketing Science Analyst-Reporting and Insights
Annalect
03.2022 - Current
- Developed complex BigQuery queries, scheduled queries, and optimized cloud data transfers.
- Conducted data cleaning and exploratory analysis using SQL in BigQuery and MS Excel.
- Created automated dashboards in Tableau, Power BI, and Google Data Studio for marketing performance tracking.
- Designed a platform, union, Excel query builder with VBA and macros for automation.
- I built an Ad Ops audit dashboard for workflow optimization in collaboration with the Ad Ops team.
- Collaborated with stakeholders to meet client dashboard requirements, and data ingestion improvements.
Data Support Engineer-LMAQ
Amazon
09.2018 - 03.2022
- Worked on raw data using MS Excel to analyze data, implement, and filter before ingestion.
- Converted data into actionable insights by graphing, pivoting, and using matrices in MS Excel.
- Writing a query in SQL Workbench (Amazon Hubble) to seek data from the fulfillment center to Amazon BI tools.
- Creating ad hoc business SQL queries as per managers' needs in Hubble, leveraging the Redshift database.
- Automated reports for Emerging Marketing, optimizing defect and WBR metrics, and achieving a 1-hour workload reduction.
- Utilized the Tableau and Power BI toolsets for data intelligence and analysis.
- Managed the workflow of the shift and the auditors present during that shift.
- Proposed solutions to simplify the existing tools for gains and high-quality throughput of data.
- Involved in solving user requests that are reported via a ticketing tool, via email, with timely updates on the reported issue to the client before the SLA breach.
- Created SOPs for different processes within the team, trained new auditors, and helped in the ramp-up.
Education
Post Graduate - Data Science
International Institute of Information Technology Bangalore
01.2022
Bachelor of Engineering - Electrical, Electronics and Communications Engineering
Sathyabama Institute of Science & Technology
Chennai01.2018
Junior High/Intermediate/Middle School Education and Teaching -
ODM Public School
01.2014
Schooling - ICSE board
Vimala Convent Higher Secondary School
IndiaSkills
- Programming and Querying: SQL, Python (EDA), BigQuery, Redshift
- Data Visualization and Reporting: Tableau, Google Data Studio, MS Excel (Advanced, VBA, Macros)
- Data Engineering: Data Cleaning, Transformation, ETL, Campaign Manager 360, Cloud Data Transfer
- Collaboration and documentation: SOPs, scope tracking, KPI analysis, and ad-hoc reporting
Awards
- Thankyou Award, Annalect India, Award reflects the high esteem in which you are held by your peers and their collective gratitude for your invaluable contributions.
- Evangelist Award, Amazon, Awarded for raising the bar for ownership, delivering results.
- Sidekick-Salute Award, Amazon, Awarded For managing the floor and keeping the atmosphere of the floor jovial.
Affiliations
- IPL Match Analysis (Tableau): Created dashboards analyzing player and team performance
- RSVP Movie Solution (SQL): Built an SQL-based recommendation system
- Bike Sharing (Machine Learning): Performed exploratory data analysis and regression modeling
- E-commerce clickstream analysis (Hive, AWS, Putty): optimized partitioning and bucketing for performance improvement
Accomplishments
- Evangelist Award – Amazon (Ownership & Delivering Results)
- Sidekick-Salute Award – Amazon (Team Management & Leadership)
Timeline
Senior Marketing Science Analyst-Reporting and Insights
Annalect
03.2022 - Current
Data Support Engineer-LMAQ
Amazon
09.2018 - 03.2022
Post Graduate - Data Science
International Institute of Information Technology Bangalore
Bachelor of Engineering - Electrical, Electronics and Communications Engineering
Sathyabama Institute of Science & Technology
Junior High/Intermediate/Middle School Education and Teaching -
ODM Public School
Schooling - ICSE board
Vimala Convent Higher Secondary School
Similar Profiles
Samantha ChaseSamantha Chase
Senior Director, Product at AnnalectSenior Director, Product at Annalect
Raghavendra babunuriRaghavendra babunuri
Search Analyst at AnnalectSearch Analyst at Annalect
Bhavya MBhavya M
Senior Digital Advertising Analyst at AnnalectSenior Digital Advertising Analyst at Annalect