Himanshu Garg

Dedicated Automation Specialist with over a year of experience in automating complex projects using UI Vision Kantu. Proficient in various programming languages, including Python and JavaScript, with a strong background in data analysis using Excel and Pandas. Skilled in SQL and experienced as an admin on Salesforce CRM. Adept at problem-solving, critical thinking, and effective communication. Committed to enhancing efficiency and accuracy through innovative automation solutions.

1) Cisco Project – Attendance and Roster Automation

• Project Description: Developed an Automated Attendance Upload system integrated with the EMS (Employee Management System) platform to streamline the attendance marking process.
• Key Responsibilities: Automated the extraction of attendance data from files submitted by requesters using UI Vision RPA.
  Implemented validation mechanisms to ensure extracted data adhered to predefined attendance rules and formats.
  Mapped and uploaded extracted data to corresponding fields in the EMS platform, supporting batch processing of multiple records.
  Created an error logging system to document and troubleshoot processing failures, ensuring logs were time-stamped and detailed.
  Configured email notifications to inform predefined recipients upon successful attendance updates, including a summary of the processed data.
• Technologies Used: UI Vision RPA, EMS platform, Email Automation

   ____________________________________________

2) Sanofi Project – File Automation

• Project Description: Automated file processing tasks for Sanofi, significantly reducing the time required to complete these tasks.
• Key Responsibilities: Developed a Python script utilizing Pandas and Selenium to automate file handling and data processing.
  Optimized workflows, reducing task completion time from 5-6 hours to just 2 minutes.
  Ensured data accuracy and integrity through automated validation and error-checking mechanisms.
  Enhanced productivity and efficiency by streamlining repetitive and time-consuming tasks.
  
• Technologies Used: Python, Pandas, Selenium

3) Shell Lem Project – Salesforce Administration

• Project Description: Worked as a Salesforce admin, managing and supporting various aspects of the Salesforce environment.
• Key Responsibilities:Developed and implemented data loaders to streamline data management processes.
  Created and maintained reports to provide actionable insights and support decision-making.
  Managed Salesforce objects and fields, ensuring data integrity and proper configuration.
  Provided ongoing support and troubleshooting for Salesforce-related issues.
  
• Technologies Used: Salesforce, Data Loader

• Date of Birth: 07/06/01
• Nationality: Indian