Arnab Das

Background

About Arnab Das

Total IT Experience: 8 Years and 6 months Data management: 12 months (SQL Server, Toad 3.4, DB 2). Mainframe: 5 months. Data masking: 24 Months (Informatica Power Center). Automation: 7 Months (Java, Selenium) 53 months (Python, Robot Framewok) Data management: Prepared SQL Queries/Sub-queries to join/alter/delete Different tables from Database DB2/SQL Server using IDE like Toad 3.4, SQL Server management Studio 18 to fetch the required Data as per test cases, or create desired manipulated data, create temporary tables/views for Data reservation. Mainframe: Created Mainframe PS/Vsam/GDG/Tape Volume Files with Table format data inside. Experienced in File handling with PDS and Copybook Layout. Handled different COBOL programs to implement in Data Sorting, Merging, and other data manipulation techniques. Data Masking: Used Infromatica Power Center to create mapplets and applied them on the sensitive columns in the mainframe input files. Those fields were masked with some business logic. Also prepared the mapplets to decrypt the data to the original one. Automation: UI Automation : Prepared selenium scripts with Java binding to automate the manual procedure to validate the presence of the encrypted data. in a portal. Used Test NG framework and Selenium webdriver. Experienced in UI Automation using Robot Framework and Python with Selenium Library. Database Automation: Experienced in Database automation using jdbc/pyodbc connection with SQL server.Comparing and manipulating the Data of different tables using automation using both Java+Selenium Webdriver+TestNG and Python+RobotFramework. Windows Automation: Experienced in AutoIt tool for Windows automation using Robot Framework and AutoIT Library. Unix: Experienced in shell scripting / VI editor.