Portfolio

Ankita Chaudhary

Data Analyst | Business Analyst | SQL & Python Specialist

About

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
Experience
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%
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
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
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
Education
Bachelor of Technology in Computer Science and Engineering
GLA University, Mathura · 2020
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.
Skills
SQLPL/SQLOracleMySQLPostgreSQLPythonExcel (Advanced)Power BITableauFigmaAsanaData ExtractionData TransformationData CleaningData ManipulationAutomationUI/UX DesignAgile MethodologyProblem-solvingAnalytical ThinkingAttention to DetailTime ManagementCollaborationCommunicationAdaptability
Download
“
An investment in knowledge pays the best interest.