Ankita Pandey

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