Ankita Chaudhary

About me

Results-driven Data Analyst with 4+ years of experience spanning data analytics, embedded software requirements, and service management. Proven expertise in SQL, PL/SQL, Python, Excel automation, and data visualization tools including Power BI and Tableau. Demonstrated success in reducing report turnaround time by 45%, automating workflows to increase efficiency by 40-80%, and delivering actionable insights through Agile methodologies. Skilled in translating complex business requirements into technical solutions, optimizing database performance, and designing intuitive UI/UX workflows. Passionate about leveraging data to drive strategic decision-making.

• Reduced report turnaround time by 45% through advanced analytics and classification
• Increased reporting efficiency and accuracy by 40% via Excel automation
• Improved team productivity by 45% through UI design and workflow management
• Reduced manual copy-pasting efforts by 80% with PPV analysis template automation
• Optimized database performance through SQL and PL/SQL development
• Delivered comprehensive Data Analytics training across multiple tools and platforms

Where I've worked

1. Data Analyst · Coupa Software Pvt Ltd

   Oct 2024 – Present
   • Performed SPA, AP Spend, Spend Guard, Peer Group Benchmarking, and Custom Requests Classification analyses, enhancing data-driven decision-making and reducing report turnaround time by 45%
   • Automated data cleaning, manipulation, and slicing/dicing in Excel, increasing reporting efficiency and accuracy by 40%
   • Designed Figma-based UI for the VDT tool, managed deal tracker and pipeline, and handled data requests and on-boarding updates in Asana, improving team productivity by 45%

2. Automotive Embedded Software Business Analyst · PiSquare Technologies Pvt Ltd

   Feb 2023 – May 2024
   • Created detailed Business Requirement Documents (BRD) and System Requirement Specifications (SRS) to accurately capture business needs, leveraging SQL for data validation, analysis, and reporting insights
   • Applied Agile methodology in sprint planning and execution, utilizing Python for data manipulation and visualization to deliver actionable insights and support data-driven decision-making

3. Analyst Service Management · Accelya Solutions Pvt Ltd

   Jan 2022 – Jan 2023
   • Investigated and resolved client-raised tickets by identifying root causes through detailed debugging and analysis of Oracle databases, ensuring minimal downtime and data accuracy
   • Developed and optimized SQL and PL/SQL procedures, functions, triggers, and packages to enhance database performance, streamline workflows, and support critical business operations

4. Data Analytics Trainer · Escalancer Pvt Ltd

   Aug 2020 – Dec 2021
   • Delivered comprehensive training in Data Analytics using SQL, Power BI, Tableau, Excel, and Python, empowering clients and students to translate data into actionable insights
   • Designed real-world projects that improved analytical proficiency and decision-making effectiveness

What I know

• SQL
• PL/SQL
• Oracle
• MySQL
• PostgreSQL
• Python
• Excel (Advanced)
• Power BI
• Tableau
• Figma
• Asana
• Data Extraction
• Data Transformation
• Data Cleaning
• Data Manipulation
• Automation
• UI/UX Design
• Agile Methodology
• Problem-solving
• Analytical Thinking
• Attention to Detail
• Time Management
• Collaboration
• Communication
• Adaptability

Projects

• PPV Analysis Template Automation (Excel): Developed and automated PPV analysis and purchasing channel templates using Advanced Excel, reducing manual copy-pasting efforts by 80% and minimizing errors. Created dynamic charts and category-wise analysis to support data-driven decision-making.
• VDT Tool UI Design (Figma): Designed the Value Discovery Tool (VDT), inspired by Mediafly, to streamline sales enablement by helping users track deals, personalize content, and manage workflows efficiently, ensuring a seamless and scalable value discovery process.
• Excel Task Automation: Automated repetitive data cleaning, manipulation, and reporting tasks in Excel, significantly increasing team efficiency and reducing manual effort.