Shibashis Bhattacharya
Kolkata
Summary
I have around 7 years of experience in the digital software automation sector. I have expertise in building RPA process automation, back-end services with python stack, MySQL, PostgreSQL, NoSQL Azure.
I have worked on development with Python, building services with FASTAPI, deployment to Azure.
I have worked as RPA developer utilizing Automation Anywhere products (AA v11.x, Automation 360, Document Automation, Automation Co-Pilot, APA), SQL, scripting to design, develop and implement automation solutions, for processes from functional domains like finance, supply chain, HR, manufacturing, procurement. I have hands-on experience around infrastructure and installation of Automation Anywhere products as well.
Overview
7
7
years of professional experience
1
1
Certificate
Work History
Consultant Engineer
EY
Kolkata
01.2022 - Current
- Experienced in building end-to-end RPA solution using Automation Anywhere/AA360. Experienced in documenting requirement scopes and solution design for automations.
Created solutions interacting with target applications like SAP GUI, Veeva Vault, MS Excel, Model N, Quanti, PLM, PLC, SAP O-Data API, Success Factors using Automation Anywhere/AA360.
Created solutions interacting with UI, REST WEB Services, desktop application.
Implemented SQL, VB and Python scripts to automate areas facing limitation with default actions of the AA360
Built solutions to implement workload management using multiple bot deployment architecture.
Experienced in managing RPA infrastructures with cloud and on-premise components like control room installation and client servers for Automation Anywhere. Installation, disaster recovery setup.
I have experience in creating backend service with Python using the FastAPI framework.
I have worked with PGSQL, MYSQL, MongoDB database by connecting to them from python code.
I have worked with GenAI concepts and packages for python in internal engagements. I have knowledge on Azure cloud’s function apps, storage accounts, AI foundry, AI-search.
Programmer Analyst
Cognizant
Kolkata
10.2018 - 01.2022
- Responsible for the development and maintenance of process automation systems leveraging RPA tool Automation Anywhere, UiPath along with SQL, VBA, and VB script.
- Designed dashboards to capture key performance indicators in a project to effectively visualize cost involvement
- Perform unit testing, SIT, UAT, bug fixes, and documentation of possible vulnerable scenarios for BOT.
- Prepared SDD, PDD, training document, user guide documents for bots
- Automated web applications such as Veeva Vault, IQVIA, Model N, ServiceNow, and BOX.
- Automated desktop applications like Excel, SAP GUI, Outlook, and PDF.
- Implemented email and API automation.
- Worked in GxP regulated environment, adhering to applicable documentation and review policy.
- Created an extensive logging mechanism for live automations.
- Improving debugging time for issues.
- Worked on creation and setup of AWS EC2 VM components to establish an RPA environment.
- HA cluster installation of Automation Anywhere v11.x, setting up application load balance, and installation of SSL certificate in application-hosted servers.
Skills
- Process automation
- Design and development
- Testing and deployment
- Automation Anywhere (11x,A360, APA)
- SQL
- Python
- No SQL
- Azure
- Gen AI
- VBScript
- Power Automate
- Power BI
- Oral and written communications
Certification
- Agentic Process Automation developer from Automation Anywhere
- Advanced Automation Certification - 2024
- Automation Anywhere Certified Master RPA Professional (Automation 360), Automation Anywhere
- Microsoft Certified: Power Platform Fundamentals (PL-900)
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Microsoft Certified: Power Automate RPA Developer Associate
- Microsoft Certified: Azure AI Fundamentals (AI-900)
Education
Bachelor of Technology - Electronics and Communication Engineering
MAULANA ABUL KALAM AZAD UNIVERSITY OF TECHNOLOGY
Kolkata, West Bengal07.2018
X + II standard - science
Methodist School
Kolkata05.2014
X standard - science
Methodist School
Kolkata03.2012
Timeline
Consultant Engineer
EY
01.2022 - Current
Programmer Analyst
Cognizant
10.2018 - 01.2022
Bachelor of Technology - Electronics and Communication Engineering
MAULANA ABUL KALAM AZAD UNIVERSITY OF TECHNOLOGY
X + II standard - science
Methodist School
X standard - science
Methodist School
Social Media
- https://www.linkedin.com/in/shibashis-bhattacharya-7619a7a5/
Place of birth
West Bengal, India
Hobbies and Interests
- Outdoor sports
- Spending time with co-habiting animals
- Musical instruments
Place of birth - Location
West Bengal, India
Hobbies and Interests
- Outdoor sports
- Spending time with co-habiting animals
- Musical instruments
Key processes built: Automation 360
Experience in developing solutions at engagements:
- PLM to PLC Integration: Bot receives email from users with BOM number and opportunity ID. Bot downloads BOM report from PLM application, validate the part numbers included in report with SAP data. Uploads the validated and prepared report to PLC application for calculation.
- SuccessFactors to Business Warehouse Integration: This process helps to load data into BW ADSO through POST action of REST Web Service after consuming report from Success Factors.
- BOM MANIPULATION: This process helps to create BOM in SAP using O-Data API. Using material header level details and item level component details provided as input automation will be creating single level BOM. Automation is also supposed to change BOM item level details like component name, quantity value.
- HR notification processes – Automation responsible for sending out greetings cards to eligible employees after interacting with Success factors application to download employee data reports
- Tax process - To calculate taxes applicable for employees after consuming data from excel reports sent to automation via email attachment
- LMS Trainee’s Attendance -This process is used to maintain and update training details for any entity that has been requested round the clock. Automation is responsible to interact with Success Factors application to make the changes.
- Amplify bot: An automation workflow responsible for archiving around 8000 PDF files after creating them from dump of raw JSON array files. It served the purpose of keeping the Corporate Services team compliant with data migration.
Experience in internal POCs:
- SAP BTP – SAP Joule: Worked with SAP BTP platform for exploring the platform capabilities, creating automation workflows, document understanding, form and front-end creation with SAP BTP.
- Data analysis tool with Python streamlit, pandas, along with GenAI suggestions and recommendations over historical data from incidents management dataset.
- Arize-Phoenix: Arize phoenix is an open-source platform for tracing, evaluation of LLM applications, have hosted this platform in Azure cloud internal to EY with AKS and created tracing and evaluation for the medical writing POC.
- Grid-Gurdian: Created the complete workflow of back-end data service using python, fast-api, interacting with both SQL (PGSQL) and NoSQL(MongoDB) databases for ingesting, manipulating data in the database tables or collections. Moreover, the data service serves the purpose of monitoring an electrical grid’s assets and generate alerts by understanding certain parameter values. Status of all assets, location wise, alert and asset health are available with this service.
Social Media
- https://www.linkedin.com/in/shibashis-bhattacharya-7619a7a5/
Place of birth
West Bengal, India
Hobbies and Interests
- Outdoor sports
- Spending time with co-habiting animals
- Musical instruments