Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

Piyusha Kulkarni

Pune

Summary

Results-oriented Automation Developer with a proven track record of building end-to-end automation solutions using Python, VBA, UIPath, and Selenium. Skilled in automating repetitive tasks, streamlining workflows, and integrating systems across desktop and web environments. Experienced in developing RPA bots, web automation scripts, and custom tools for data processing, reporting, and task scheduling. Proficient in Excel, Google Workspace, browser-based applications, and APIs to deliver scalable and efficient solutions with a strong focus on accuracy, reliability, and continuous process improvement. Experienced with designing and implementing automation systems in manufacturing environments. Uses advanced PLC programming and control systems to optimize production processes and reduce downtime. Knowledge of integrating complex automation solutions to enhance operational efficiency and ensure seamless production.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Process Automation Engineer

Searce Inc
07.2022 - Current
  • Developed Python and VBA scripts to automate data processing, analysis and reporting tasks.
  • Strong knowledge of Python including libraries for data manipulation like Pandas, Numpy.
  • Developed Python scripts and tools for document scanning, text extraction, and data parsing using libraries such as OCR tools e.g. Tesseract, Pytesseract etc.
  • Integrated Python Automation scripts with other tools and platforms like API'S, databases, Excel to enhance workflow automation.
  • Expertise in Selenium and tools like PyAutoGUI, Chrome WebDriver for automating web browsers and web scraping.
  • Implemented Automations for Desktop Applications like Worldport, OFS and Outlook Apps using Python and VBA.
  • Hands-on experience of working on Uipath tools and technologies like Uipath Studio, Orchestrator and Assistant.
  • Developed automations using REFramework.
  • Designed, developed and implemented automation solutions using tools such as MS Access VBA & VBA Macros.
  • Good Excel capabilities including Pivot Tables, Lookups, conditional formatting.
  • Developed and maintained Google Apps Script solutions to automate workflows across Google Sheets, Gmail, and Google Drive.
  • Designed dashboards with real-time data updates using Apps Script and Google Sheets APIs.
  • Analyze business processes and workflows, identifying opportunities for automation to improve efficiency and reduce errors.
  • Collaboration with stakeholders from different business units for understanding and gathering requirements along with providing efficient and feasible solutions as per the business queries.
  • Conducted thorough testing of RPA bots and Python scripts to ensure functionality, accuracy and stability.
  • Monitor and troubleshoot issues in automated processes, ensuring minimal downtime and high reliability.

Automation and Analytics Intern

Cummins Inc
01.2022 - 07.2022
  • Experience of working on 4 live projects using VBA Macros and Power Bi.
  • Hands-on experience in creating macros, Email Automation, Finding Duplicate Invoices, Pivot Tables and adding vlookup formulas dynamically using VBA.
  • Experience in creating relevant user forms and GUI'S, perform Unit Testing on the product as well as helping clients in performing UAT, analyzing and assessing the input files, performing Asset Management.
  • Exposure to large volumes of data in Data Lake, accessing and assessment of data using REST API's Power Bi, development and Administration, building analysis services and Reporting Models, building Visual Reports Dashboards.

Education

Masters In Computer Applications ( MCA ) -

Savitribai Phule Pune University
Pune
07.2022

Bachelor of Computer Applications ( BCA ) -

Savitribai Phule Pune University
Pune
05.2019

Skills

  • Python-based task automation
  • VBA programming
  • Selenium automation
  • Robotic process automation with UIPath
  • OCR
  • Automation using Apps Script
  • MySql
  • HTML and CSS

Projects

Roku End to End Automation

  • Implemented end to end invoice delivery automation which involved downloading different types of invoices from website using Selenium.
  • Implemented OCR to read data from documents.
  • Validated the extracted data with data on the website.
  • Calculated rates from the tariff using data manipulation libraries like pandas, numpy , xlwings, etc.
  • Implemented desktop application automation to enter the calculated rates into OFS.
  • The automation saved 7.58 Hrs daily with 100% reduction in manual efforts.


CWW TMF Automation

  • Implemented web based automation for the TMF website where the user has to process more than 7000 invoices daily and generate prn for the same.
  • The automation proved to be beneficial by saving manual work of 7 to 8 resources.


Fedex Website Automation

  • Implemented web based automation using Uipath to scrape data from the Fedex website.
  • The automation saved 3 hours of manual time daily.

Certification

  • UiPath Academy Automation Developer Professional Training
  • Microsoft Technology Associate: Database Administration Fundamentals
  • Machine Learning ( Internshala )

Timeline

Process Automation Engineer

Searce Inc
07.2022 - Current

Automation and Analytics Intern

Cummins Inc
01.2022 - 07.2022

Masters In Computer Applications ( MCA ) -

Savitribai Phule Pune University

Bachelor of Computer Applications ( BCA ) -

Savitribai Phule Pune University
Piyusha Kulkarni