A

Aayoshi Dutta

About

Detail

Business Analyst
United States
Contact Aayoshi regarding: 
work
Full-time jobs

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • M
    Business Analyst|ProjectManager, Practicum Project
    MenoWell
    Sep 2023 - Jun 2024 (10 months)
    As partof MSBA, translated MenoWell's business needs into a strategic action plan to deliver a comprehensive solution. • Utilized Google Analytics to analyze website performance and customer demographics, achieving a 20% increase in user engagement by implementing targeted improvements based on data insights. • Created Tableau dashboards to visualize product and customer insights and used Python for web scraping and natural language processing across MenoWell's product portfolio on Amazon. • Scoped new analytic research ideas and spearheaded successful completion of project milestones using Asana.
  • PwC India
    Technology Consultant
    PwC India
    Jul 2022 - Jul 2023 (1 year 1 month)
    • Optimized supply chain for an Australian mining company with a revenue of $60B: Identified process inefficiencies and improved DIFOT (Demand in Full & On Time) by ~10% by analyzing processes like D2P and MDI using SQLon Snowflake, DBT Cloud and SAP Signavio. • Created a data harmonization toolfor one of the largestF&B businesses in the world: Configured ETLworkflows on Alteryx to combine and clean data from multiple sources; migrated workflows to Azure Cloud by extracting data from Data Lake, transforming it on Databricks using Pyspark and orchestrating the pipelines on Data Factory, thereby reducing data processing time by 40%.
  • ZS Associates
    Decision Analytics Associate
    ZS Associates
    Dec 2021 - Jul 2022 (8 months)
    Worked as a Business Consultantfor a renowned pharmaceuticalclient: • Combined and analyzed different types of pharmaceutical data using SQL on AWS and advanced Excel, leading to optimized production and a ~5% increase in sales of a cancer drug. • Created weekly reports to assess the performance of the drug/ pharmacies and understand patient profile; replicated these reports on MicroStrategy to automate the process and reduce redundancy.
  • Dxctechnology
    Associate Professional Software Engineer
    Dxctechnology
    Jul 2020 - Nov 2021 (1 year 5 months)
    Worked as a Junior Data Engineer for a Fortune 500 Information Technology firm: • Set up marketing programs on the cloud forvarious brands under a multinational FMCG giant using Google Cloud Storage, BigQuery, Postman and Segment. • Developed a scalable data quality tool using Spring Boot microservices and PostgreSQL, enabling customized complex checks at each ETL stage, hosted on AWS and Azure. • Awarded the "DXC Champs Award" for passion and dedication towards quality delivery.
Education verified_user 0% verified
  • University of California
    Master of Science
    University of California
  • Vellore Institute of Technology
    Bachelor of Technology
    Vellore Institute of Technology
  • A
    Microsoft Azure Fundamentals (AZ-900), GCP Professional Data Engineer (Qwiklabs)
    Alteryx Foundation