Apurva Madake

Data Analyst and RPA Developer with 4.5 years of experience in RPA automation, SQL, data extraction, data validation, reporting, and business process optimization. Experienced in UiPath and Kofax Kapow, with strong expertise in collecting, transforming, validating and analyzing structured and semi-structured data for business reporting and decision-making. Skilled in SQL, Excel, Power BI, python, production support and workflow automation.

RPA Developer (UiPath) - Sphinx Solutions Pvt. Ltd. - Pune, India

(2019-11 - 2024-04)

Project 1: Amazon Upstart & Dimetyd Dashboard

• Designed and developed UiPath automation workflows for Amazon Vendor Central processes.
• Automated Purchase Order History, Inventory Health, Revenue Reports, Direct Fulfillment and Geo Sales Tax processes.
• Integrated automation with SQL/MySQL databases.
• Performed testing, deployment, production support, debugging and issue resolution.
• Collaborated with business users to improve process efficiency.

RPA Developer (Kofax Kapow) / Data Analytics - Sphinx Solutions Pvt. Ltd. - Pune, India

(2019-11 - 2024-04)

Project 2: Vivino Wines. Developed Kofax Kapow automation solutions to collect, validate, transform and organize large volumes of product data from multiple wine and e-commerce websites. The processed data supported business reporting, product catalog enrichment, pricing analysis and downstream analytics.

• Developed Kofax Kapow robots for automated web data extraction.
• Collected wine name, brand, country, region, price, ratings, reviews and vintage information.
• Performed data validation, cleansing and transformation to improve data quality.
• Used SQL queries to validate and load datasets into databases.
• Processed JSON and XML data for reporting applications.
• Used HTML Parser for extracting structured and semi-structured web data.
• Collaborated with stakeholders to ensure data quality and reporting accuracy.
• Provided production support, debugging, robot enhancements and performance optimization.

Bachelor of Engineering - Electronics & Telecommunication (2015)

Diploma - Electronics & Telecommunication (2012)