Ankita Pandey

Ankita Pandey

Followers of Ankita Pandey5000 followers
location of Ankita PandeyBengaluru, Karnataka, India

Connect with Ankita Pandey to Send Message

Connect

Connect with Ankita Pandey to Send Message

Connect
  • Timeline

  • About me

    Business Consultant | IIM Indore | Accenture Strategy Intern | Big Data Engineer

  • Education

    • Heritage Institute of Technology, Kolkata

      2014 - 2018
      Bachelor of Technology - BTech Computer Science Engineering 9.06
    • DAV, BSEB

      2012 - 2014
      High School Science 94.8
    • Notre dame academy

      2004 - 2012
      Secondary School 10 cgpa
    • Indian Institute of Management, Indore

      2021 - 2023
      Master of Business Administration - MBA Business Administration and Management, General
  • Experience

    • Tata Consultancy Services

      Jun 2018 - Apr 2021

      Worked as a System Engineer within the Global Business Intelligence (GBI) division of Apple Inc. I was actively engaged in the implementation and delivery of Business Intelligence solutions within the iTunes division of Apple Inc. Royalty Payment, Apple Music• Devised logic to calculate the music royalty amount to be paid back to the right holders depending upon usage and licensing• Implemented the above logic using SparkSQL queries; filtered 50 GB of incoming data every day for driving business analytics General Data Protection Regulation, iTunes• Designed and implemented a logic to anonymize key data fields in accordance with GDPR to guarantee data privacy to users• Modelled Data Quality and Monitoring (DQM) framework for data auditing across multiple environments and databasesData Replication, Hadoop/Teradata• Replicated data from Hadoop to Teradata providing low latency & increased data privacy; reducing calculation time by around 99%• Ingested data to multiple environments; forwarded them to the downstream layer for driving business insights to drive revenueScrum Master, Tata Consultancy Services • Responsible for ensuring the team lives agile values and principles and follows the processes as agreed by the team Show less Automation Project, Hadoop• Developed parallel pipelines at various data layers to load data in the Hadoop and Teradata environment to optimize & reduce cost• Reduced the manual intervention and cost by 90% by performing ETL operations with the help of scheduled jobs and processes Upstream Layer Data Storage, SQLDeveloper • Enforced data availability in the Test environment decreasing the manual intervention and the cost by around 50%AchievementsRepresented TCS Noida on national level & won Special initiative award in a competition held pan India, TCS. Received Best Team Award for the outstanding performance of the team out of 30+ teams in TCS, Noida. Show less

      • System Engineer

        Jun 2019 - Apr 2021
      • Assistant System Engineer

        Jun 2018 - Jun 2019
    • I5 Summit - IIM & IIT Indore

      Jul 2021 - Aug 2021
      Junior Team Member - Media & PR

      Managing the social media handles(Instagram, Facebook, LinkedIn) of the event with an outreach of 10,000+.Responsible for conducting press conferences & managing PR activities throughout the tenure of the event.Creating content for print & digital media, covering 20+ media outlets on a regional & national level.

    • Utsaha-IIM Indore's Marketing Fest

      Aug 2021 - Nov 2021
      Junior team member - Events & Corporate Interactions

      Responsible for generating leads, pitching for sponsorship to prospective sponsors for the online workshop.Working with a team of 25 towards planning & organizing engaging events to increase footfall for online fest.

    • Accenture

      Apr 2022 - Jun 2022
      Managment Consultant

      Worked as a consultant for Project Business Process Design & BRF creation of network rollout• Identified 4 testing phases of the network rollout to prepare a process document for CP/DP acceptance through secondary research• Analyzed turn-around time of 42 business processes using 5 KPIs to identify bottlenecks to increase efficiency of telecom rollout• Automated reporting of the project process to the Client Leadership team with the aim of reducing reporting time by 80%• Mapped Resource Forecast template mentioning the WBS which would help in efficient work allocation of the resources. Show less

    • Triedge.in

      Jul 2022 - Oct 2022
      Product Manager

      Product and Service Design• Evaluation of competing CRM tools to gauge design, service features and business models prevalent in the market• End-to-end-modelling of custom CRM for managing links with leads and tracking stakeholder product relations• Prioritized input fields and filters; wireframed various forms and list layouts to be integrated in the Triedge CRM tool

    • Samagra | Transforming Governance

      May 2023 - Nov 2023
      Emerging Leader

      Collaborated with the Odisha state government and the Bill & Melinda Gates Foundation (BMGF) to create a systemic transformation program that would improve the income of the state's 77 lakh+ farmers • Designed strategy to identify 7lakh farmer cohorts; developed product architecture for identifying cohorts on motivation vs ability matrix• Value chain scoping of 2/7 commodities; identifying clusters(2lakh+ farmers) for selected commodity; initiating adoption campaign• Devised strategy for successful implementation of Digital Crop Survey across 4,000+ villages in 4 districts with a budget of 5cr+• Identifying, onboarding, and training 5000+ resources; Initiating IEC campaign onground; review and monitoring of the survey • Conceptualized an algorithm to determine confidence scores for 90+ data points of 77 lakh+ farmers using 12+ gov datasets Show less

    • Prescience Decision Solutions

      Dec 2023 - now
      Client Engagement Manager
  • Licenses & Certifications

    • Marketing Fundamentals

      Udemy
      Jun 2021
    • Fundamentals of Digital Marketing

      Google
      Jul 2021
    • Microsoft Excel Beginner to Advanced

      Udemy
      Jun 2021
    • TCS iAssurance V

      Tata Consultancy Services
      Jan 2017
    • PHP with wordpress

      Hewlett Packard Enterprise
      Jul 2016
    • Hadoop BigData

      APTRON
      Jun 2017
  • Volunteer Experience

    • Junior Team Member, Utsaha, Events & Sponsorship Vertical

      Issued by Utsaha-IIM Indore's Marketing Fest on Aug 2021
      Utsaha-IIM Indore's Marketing FestAssociated with Ankita Pandey
    • Scrum Master, Tata Consultancy Services

      Issued by Tata Consultancy Services on Jun 2018
      Tata Consultancy ServicesAssociated with Ankita Pandey
    • Junior Team Member, i5 Summit Media & PR Vertical

      Issued by i5 Summit - IIM & IIT Indore on Jul 2021
      i5 Summit - IIM & IIT IndoreAssociated with Ankita Pandey
    • Mess Manager, Netaji Subhash Chandra Bose Girls Hostel

      Issued by Heritage Institute of Technology on Sept 2017
      Heritage Institute of TechnologyAssociated with Ankita Pandey
    • Team Member, Rotaract Club of Altruism

      Issued by Rotaract on Apr 2016
      RotaractAssociated with Ankita Pandey