INDRA KUMAR S

• 1. Tool - Uipath
• Project Title: Day Force Report Download
• Description:
• This project involves the development of a sophisticated bot capable of automating the entire process of logging into a web portal, downloading eight types of reports, performing data manipulation, and ultimately inserting the processed data into a database
• The bot's capabilities will enhance operational efficiency, reduce errors, and provide timely access to critical information
• Features:
• Web Portal Login: The bot will securely log into the targeted web portal using provided credentials
• Report Selection: The bot will navigate through the portal's interface to identify and select the specified reports for download
• Report Download: After selecting the reports, the bot will initiate the download process and acquire the required data files
• Data Manipulation: The bot will perform necessary data manipulation, including cleaning, transformation, and aggregation, based on predefined rules for each report type
• Database Integration: The manipulated data will be structured and inserted into a designated database with appropriate tables and relationships
• Error Handling: The bot will incorporate robust error handling mechanisms to manage unexpected scenarios during download, manipulation, and insertion processes
• Logging and Reporting: The bot will maintain comprehensive activity logs and generate summary reports showcasing successful downloads, manipulations, and database inserts

• 2. Tool - Uipath
• Project Title: Day Force Report Download
• Description:
• Our project showcases a comprehensive automation solution, built using the Re-Framework, designed to streamline complex data management and processing workflow
• The project encompasses the following key features:
• Features:
• Re-Framework Integration: This project was developed by using reframe work
• Excel Data Extraction: The bot efficiently reads and extracts data from a multifaceted Excel input file containing 13 sheets, demonstrating its proficiency in handling diverse data sources
• Sheet Validation: Each of the 13 sheets undergoes rigorous validation, showcasing the bot's ability to perform data quality checks and ensure the integrity of the information
• Queue Management: Post-validation, the bot meticulously adds all validated data to a queue, enabling structured and efficient data management for subsequent processing steps
• Web Application Interaction: The bot seamlessly logs into a web application, illustrating its secure access and data retrieval capabilities
• Data Integration: It retrieves data from the queue and precisely integrates it into the web application, demonstrating its capability to handle data transfer and entry tasks with accuracy
• Automated Reporting: The project concludes by automatically generating a comprehensive output report summarizing the executed tasks, results, and any potential exceptions
• The bot then sends this report via email, providing stakeholders with real-time updates and ensuring transparency in the process

• 3. Tool - Uipath
• Project Title: BeriBot
• Description:
• Our project showcases a comprehensive automation solution developed using the Re-Framework, designed to streamline a multifaceted workflow that encompasses email communication, data extraction from PDFs, web application interaction, SharePoint integration, and automated reporting
• The project encompasses the following key features:
• Features:
• Re-Framework Integration: This project was developed by using reframe work
• Email Attachment Handling: The bot efficiently downloads PDF attachments from emails, demonstrating its capability to manage email communications and file downloads seamlessly
• PDF Data Extraction: The bot skillfully extracts and scrapes specific client information, such as the client's name and date, from the PDF documents using regular expressions
• This showcases its data extraction process
• Web Application Interaction: The bot securely logs into a web application and enters the extracted client's name and date, illustrating its capacity to interface with web-based systems and perform data input tasks
• SharePoint Integration: The same PDF documents are renamed and systematically uploaded into SharePoint, showcasing the bot's proficiency in integrating with document management systems and performing file operations
• Automated Reporting: The project concludes by automatically generating a comprehensive output report summarizing the executed tasks, extracted data, and any potential exceptions
• The bot then sends this report via email to relevant stakeholders, providing them with real-time updates and ensuring transparency in the process.

Tool - Uipath

Project Title: CCPP Process

• Process was developed by using customized Re-Framework
• Bot takes reference-id from queue and match reference id with database table
• After matching it will get data row and fetch the fields like Case file no, Access no, Account no, Mobile no
• Bot login to web application (ccpp), navigates to page, inputs the Case file no and captures screenshot to maximum 10 pages and stores in the word document
• Bot navigates to SMS page, Push Notification Page and captures the screenshot
• Bot updates the status in the database
• Finally sends the status mail to user
• Project Title – Care Extraction Process
• Tool - Ui Path
• Process was developed by using Re-Framework
• Bot reads ids from the input excel file
• Bot login to care application (web) inputting id’s, extracting data
• Bot stores the extracted data into output excel file
• Finally sends the status mail to user

Tool - Uipath

Project Title: Job Portal Automation

• Developed process to scrap data from job portal
• Data validation after scraping
• After validating data will be stored in output report
• Finally output report
• Finally sends the mail with output report

Tool - Ui Path

Project Title - Letter of Completion

• Developed process to generate certificate
• In spreadsheet column there will be list of email-id's
• Bot retrieves this email-id's and sent request to server
• As a response will get score if score is more than 80 percentage
• Opens the template documents and changes name, score and completion date
• Converts word to pdf and saved in specified folder
• Finally, pdf will sent to specified mail-id

Project Title - School Management Application

• Developed Application using C# Dotnet, Sql Server
• Using this application Management can store student details, fee details, vehicle details, etc
• In this application there are two user types admin and common user here admin has options to delete or update the data but common user cannot have this options
• Performed end to end process implementation as per SDLC