AYUKT DAS
Summary
Experienced with statistical analysis, data modeling, and visualization techniques critical for data-driven decision-making. Utilizes advanced SQL and Python skills to identify trends and optimize business processes. Knowledge of key industry tools and methodologies ensures comprehensive data analysis and actionable insights.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst - Lead
MediaMint
02.2024 - Current
- Engaging with internal and external stakeholders to align business objectives, ensuring seamless communication and the effective delivery of analytics-driven insights.
- Developing and implementing automated reporting solutions using Google Analytics and Data Studio to enhance data visualization and minimize manual work.
- Automating data flows and processes on Google Sheets with JavaScript to improve operational efficiency.
- Collaborating with senior leadership and cross-functional teams, addressing urgent data requests with precision to influence strategic decision-making.
- Mentoring & guiding a team to ensure the timely completion of analytics projects while fostering a data-driven, results-oriented culture.
- Creating advanced data visualizations and reports in Power BI to facilitate data-driven decision-making and performance monitoring.
- Utilizing SQL to manage ETL processes, ensuring structured, clean, and accessible data for business reporting and analysis.
- Performed in-depth exploratory data analyses using Python libraries to identify opportunities for process improvements and potential revenue growth.
- Enhanced model accuracy by implementing machine learning algorithms in Python for predictive analytics.
- Streamlined the data ingestion process by designing and implementing a robust API integration framework in Python, reducing manual workload significantly.
- Reduced campaign reporting time by 60% by implementing batch processing of campaign logs and cost data through PySpark and scheduling pipelines with Airflow.
- Integrated PySpark scripts with cloud data lakes ( AWS S3, GCP BigQuery) to handle large volumes of unstructured and semi-structured marketing data.
- Developed PySpark-based modules to identify anomalies in campaign performance metrics (e.g sudden drop in CTR or spike in bounce rate) and alert marketing teams for quick resolution.
- Engineered ETL workflows using PySpark to automate data ingestion, transformation, and aggregation across multiple marketing channels and platforms.
- Built and optimized large-scale PySpark pipelines to process digital marketing data from sources like Google Ads, Facebook Ads, and Google Analytics for campaign performance analysis.
Business Operations Specialist
Amazon Development Centre Pvt Ltd.
05.2020 - 08.2023
- Built strong relationships with stakeholders and explained complex concepts in an easily understandable manner.
- Cross-trained across multiple programs and coached team members to ensure optimal resource utilization.
- Providing predictive analytics and forecasting to improve business planning and efficiency.
- Designed interactive dashboards and visualizations using Excel, Tableau, and Power BI to generate valuable business insights.
- Delivered analytical reports and presented key insights to stakeholders during various pilot projects.
- Trained new joiners and team leads on the product, facilitated seamless integration and effective knowledge transfer.
- Wrote and executed SQL queries for ETL processes and file uploads, ensuring accurate and efficient data management.
- Implementing automation in data processing using Python, SQL, and cloud-based solutions.
- Conducting A/B testing and experiments to measure the impact of business initiatives.
Sales Associate
Global University Systems
05.2019 - 02.2020
- Achieved monthly sales targets consistently by implementing effective sales strategies and maintaining a high level of product knowledge.
- Managed B2C sales successfully, pitched educational institutions to customers, and drove revenue growth.
- Utilized Salesforce and CRM to store, track, and generate leads, ensuring efficient lead management.
- Generated insights and proposed new ideas to enhance workflow efficiency and improve processes.
Process Associate
Cognizant Technologies Solutions
05.2018 - 05.2019
- Assisted customers with Search Engine Optimization (SEO) to enhance their online visibility and increase website traffic.
- Handled mapping-related queries and helped customers navigate Google Maps to find relevant businesses and locations.
- Pitched Google AdWords to customers and guided them in setting up accounts, driving higher sales and website visits.
- Developed interactive web pages to enhance functionality and improve user experience on customer websites.
Education
Master of Science - Data Science & AI
Indian Institute Technology
Roorkee, India08-2025
Bachelor of Technology - Mechanical Engineering
Jawaharlal Nehru Technological University
Hyderabad, India05-2016
Skills
- Advanced Excel
- ETL processes
- Python programming
- SQL expertise
- Power BI
- Sharepoint
- Javascript
Languages
English
Bilingual or Proficient (C2)
German
Elementary (A2)
Hindi
Bilingual or Proficient (C2)
Certification
- CSM - Certified Scrum Master
- Lean Management
- SQL and Tableau in Data Analytics
- Associate in Project Management.
Timeline
Senior Data Analyst - Lead
MediaMint
02.2024 - Current
Business Operations Specialist
Amazon Development Centre Pvt Ltd.
05.2020 - 08.2023
Sales Associate
Global University Systems
05.2019 - 02.2020
Process Associate
Cognizant Technologies Solutions
05.2018 - 05.2019
Master of Science - Data Science & AI
Indian Institute Technology
Bachelor of Technology - Mechanical Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Mohana Sathvik VemuMohana Sathvik Vemu
Ad-operations associate -1 at MediaMintAd-operations associate -1 at MediaMint
Abhishek ChandrakarAbhishek Chandrakar
Media Planner at MediaMintMedia Planner at MediaMint
Sourabh GuheSourabh Guhe
Ad Operations - Campaign Manager at MediamintAd Operations - Campaign Manager at Mediamint