Debanjana Bhattacharya

• Managing a team of 10+ people for development and enhancement of Business Process using Robotic Process Automation
• Performing the role of a Solution Architect by gathering both functional and non-functional requirements based on interactions with Business

• Trained new joiners in the team in Ui path tool from scratch.

➢ Few of the projects been part of as below:

a) CLIENT- THERMO FISHER:

• Worked on PDF data extraction using Document Understanding and Action Centres where clients wanted to upload data in multiple ERP’s and finally attach the invoice file in the systems.
• Used Orchestrator Unique Reference Queues and Thermo-fisher’s custom framework for processing transactions and to update the Invoices in Smartsheet application.
• Developed an end-to-end automation solution using UiPath that integrates with a web application, desktop application, and utilizes Orchestrator API calls.

• Lead the team in End-to-End development of Business Process using Robotic Process Automation
• Automated multiple process, minimized human intervention, improved more accuracy and added more value to business
• Used UiPath Orchestrator for deployment, monitoring and management of UiPath Robot automation.

➢ Few of the projects been part of as below:

a) CLIENT- VERINT

• Automated the HR Leave Record process for the clients that includes complex Excel formula manipulation and creating a Credit/Debit metrics report.
• Worked on Orchestrator API to call a Performer process from Dispatcher using the details from Swagger.

b) CLIENT- TOYOTA

• Automated a process for the clients that includes Oracle, Orbit and OBIEE Web Applications and creating details reports in Excel.
• Used Macros and VBA code to create the report and the report is finally uploaded in Orbit Application and send success emails to the stakeholders.

Worked as a Senior Developer to automate Web and Desktoop Based Applications .

➢ Few of the projects been part of as below:

a) CLIENT- CITIZEN ENERGY

• Automated C2M Web Applications which deals with Billing and Meter Readings leading to various exceptions (zero, negative and high). Those exceptions had to be validated and forced closed based on business rules provided.

• Used Data Base activity to fetch the values based on query result and process the data in the C2M

b) CLIENT-AMD

· Automated SAP application to create Purchase Order and Scheduling Agreements for AMD. Used Excel as an input for the SAP process where clients provide data in tabular format.

· Used Outlook activity to read emails based on specific subjects provided and download the attachments.

• CLIENT: ASTELLAS
• Responsibilities included feasibility analysis of business requirements and implementation of APIs using .Net Core, Web-API and C#, SQL
• Preparation of LLD and other necessary documents that stored the use case scenarios along with API information
• API testing using postman
• Handled the team to work on Autonomy and Team Connect applications in the project
• Hands on experience in writing SQL queries in the project, data cleaning and analysis.

CLIENT: NATION-STAR

• Worked on PDF file extractions and OCR engines using Uipath and to input data in SAP Application

• Worked on few Desktop applications like LSAMS and Remedy to Bot to take snapshot of various screens as per business steps provided for audit purpose.