Senior Software Engineer
Tetrasoft India Private Limited
Keywords
IBM System I
SQL Databases
Vbscript
Agile Methodology
Unit Testing
Botnet
Business Process Management
Databases
Data Validation
Software Design Documents
Skills
agile process, Automation Anywhere, Bot, Bots, business process requirements, data validation, database, AS 400, AS400, Information Communication Technology, Main Frame, Excel, Windows Applications, Operating System, Oracle, Robotic Process Automation, SQL Database, SQL, design document, Terminal Emulator, unit testing, VBSCRIPT, web Application, web portal, Windows Domain
Project history
09/2021
-
07/2023
09/2019
-
09/2021
Process Associate - Infra RPA
Agility Logistics (GIL Shared Services)
07/2017
-
09/2019
RPA Developer
CAMS
06/2016
-
07/2017
Junior Software Engineer
I Link Systems
Key Responsibilities:
* Understand business process requirements, documents and prepare the solution design document.
* Work with business and technical lead to analyze and assess automation feasibility assessment
* Develop code to meet defined design and ensure quality of code by performing E2E unit testing
of the developed code.
* Involved in writing the VBScripts as required wherever the Automation Anywhere commands are
not sufficient or most suitable for performing the task
* Preparing the Bot Handover Documents to the Support Team.
* Support and drive change management of existing process as per new requirement using a
structured change control process.
* Plan and organize to deliver the project on time ensuring product quality and efficiency.
* Prepare and review test cases covering all the functional requirements with E2E flows.
* Attend daily scrum and weekly status meetings with the clients with proper plan and
productivity.
* Timely raise any issue identified to Manager so that the business scheduled plan and
turnaround time are not impacted.
Project Summary:
Project Description Environment & Application Used
Purchase Invoice Processing
To download Invoices in PDF or Image format from web portal and place it in pre-defined folder
location and extract the data with IQ Bot. Then check for the invoice in AS 400 application and
update the status of the invoice into Excel template.
Automation Anywhere - Task Bot & IQ Bot,MetaBot, Excel, IBM AS400
Dot Optima
Extract data from the Excel Input file and need to upload the data in the web Application . Process
contains three different Steps (Data Load, Run definition & Download Reports). Once the data has
been loaded in the Application then Need to validate the data and confirm the data load runs. Once
the data validation has been done then the reports need to be shared with the business
Automation Anywhere(A360) - Task Bot, Excel, SQL Database
MIS Report Generation
The statement of Account files which were received from AMCs (Asset Management Companies) need to
separate the SOA files Accordingly and need to send them to the different distributors A Fortnight
reports has to be generated for AMCs (Asset Management Companies) to tally the Received applications
and processed applications for every process. This process involved preparing consolidated file by
referring four more excels file in which data massaging has been done for all files with some
validation. This has been automated to generate the MIS Reports on every Fortnight without any
manual involvement.
Automation Anywhere(A360) - Task Bot & VBSCRIPT
Project Description Environment & Application Used
A&H Modelling
Accident and health modelling estimates the probable loss of an account based on the locations
entered under it to the hypothetical scenario. The Automation process is to compare the loss
analysis results with the earlier months and the output data need to be send out to the business.
Automation Anywhere - Task Bot & Metabot Bot, Excel, SQL Database
ISCS-HMD
The scope of the project is to download Report from web application Need to validate the report as
per the Business Rules and send out a customised Report to business email. The Edi Team will
generate the jobs in the Control Application
Automation Anywhere - Task Bot & Metabot Bot, Excel, Oracle Application, SQL
India J2J-Job Confirmation
The goal is to automate the daily process of Confirming the J2J Jobs in the control Application by
launching the Terminal Emulator. Before confirming the jobs need to perform all the validation check
points based on the business rules provided by the Business Team.
Automation Anywhere - Task Bot & IQ Bot, Excel, IBM AS400
HDFC Bank Statement Download
It is a process of downloading the account statement for Collection account given by the AMC (Asset
Management Company) in HDFC Bank Website. The purpose of the process is to check the Credit balance
of the account statement in order to purchase the Units for MF and then the downloaded account
statement has been imported in a IT.NET for maintaining a data in database to preparing
Reconciliation to validate the purchase has been done in a correct account Download Account
statement from bank website. After downloading the statement from the website, Data massaging and
validation has to be done in that file and then finally format the file in a uploaded structure and
save as .Csv file with a Account number as filename. After data massaging has been done, log on to
ITNET application import the file in a database based on the Account Number in the Filename. This is
day to day activity that needs to be carried out through automation by increasing more productivity
in less span.
* Understand business process requirements, documents and prepare the solution design document.
* Work with business and technical lead to analyze and assess automation feasibility assessment
* Develop code to meet defined design and ensure quality of code by performing E2E unit testing
of the developed code.
* Involved in writing the VBScripts as required wherever the Automation Anywhere commands are
not sufficient or most suitable for performing the task
* Preparing the Bot Handover Documents to the Support Team.
* Support and drive change management of existing process as per new requirement using a
structured change control process.
* Plan and organize to deliver the project on time ensuring product quality and efficiency.
* Prepare and review test cases covering all the functional requirements with E2E flows.
* Attend daily scrum and weekly status meetings with the clients with proper plan and
productivity.
* Timely raise any issue identified to Manager so that the business scheduled plan and
turnaround time are not impacted.
Project Summary:
Project Description Environment & Application Used
Purchase Invoice Processing
To download Invoices in PDF or Image format from web portal and place it in pre-defined folder
location and extract the data with IQ Bot. Then check for the invoice in AS 400 application and
update the status of the invoice into Excel template.
Automation Anywhere - Task Bot & IQ Bot,MetaBot, Excel, IBM AS400
Dot Optima
Extract data from the Excel Input file and need to upload the data in the web Application . Process
contains three different Steps (Data Load, Run definition & Download Reports). Once the data has
been loaded in the Application then Need to validate the data and confirm the data load runs. Once
the data validation has been done then the reports need to be shared with the business
Automation Anywhere(A360) - Task Bot, Excel, SQL Database
MIS Report Generation
The statement of Account files which were received from AMCs (Asset Management Companies) need to
separate the SOA files Accordingly and need to send them to the different distributors A Fortnight
reports has to be generated for AMCs (Asset Management Companies) to tally the Received applications
and processed applications for every process. This process involved preparing consolidated file by
referring four more excels file in which data massaging has been done for all files with some
validation. This has been automated to generate the MIS Reports on every Fortnight without any
manual involvement.
Automation Anywhere(A360) - Task Bot & VBSCRIPT
Project Description Environment & Application Used
A&H Modelling
Accident and health modelling estimates the probable loss of an account based on the locations
entered under it to the hypothetical scenario. The Automation process is to compare the loss
analysis results with the earlier months and the output data need to be send out to the business.
Automation Anywhere - Task Bot & Metabot Bot, Excel, SQL Database
ISCS-HMD
The scope of the project is to download Report from web application Need to validate the report as
per the Business Rules and send out a customised Report to business email. The Edi Team will
generate the jobs in the Control Application
Automation Anywhere - Task Bot & Metabot Bot, Excel, Oracle Application, SQL
India J2J-Job Confirmation
The goal is to automate the daily process of Confirming the J2J Jobs in the control Application by
launching the Terminal Emulator. Before confirming the jobs need to perform all the validation check
points based on the business rules provided by the Business Team.
Automation Anywhere - Task Bot & IQ Bot, Excel, IBM AS400
HDFC Bank Statement Download
It is a process of downloading the account statement for Collection account given by the AMC (Asset
Management Company) in HDFC Bank Website. The purpose of the process is to check the Credit balance
of the account statement in order to purchase the Units for MF and then the downloaded account
statement has been imported in a IT.NET for maintaining a data in database to preparing
Reconciliation to validate the purchase has been done in a correct account Download Account
statement from bank website. After downloading the statement from the website, Data massaging and
validation has to be done in that file and then finally format the file in a uploaded structure and
save as .Csv file with a Account number as filename. After data massaging has been done, log on to
ITNET application import the file in a database based on the Account Number in the Filename. This is
day to day activity that needs to be carried out through automation by increasing more productivity
in less span.
Local Availability
Only available for remote work
