Tapas P.

Tapas P.

Testing & Automation(SME) (ETL/BI/Database/Manual/GUI/Data & Database Migration/Data Analysis/Big

Kolkata , India

Experience: 10 Years

Tapas

Kolkata , India

Testing & Automation(SME) (ETL/BI/Database/Manual/GUI/Data & Database Migration/Data Analysis/Big

37020 USD / Year

  • Immediate: Available

10 Years

Now you can Instantly Chat with Tapas!

About Me

13.1 yrs. experience in software testing on ETL, BI, Database, Manual, GUI, Data & Database Migration, Big Data, Data Analysis and QA in the domains of Retail, Banking, Finance & Accounting, Telecom, European Rail, Health Care, Inventory and Li...


 Last 5 yrs. involve in Automation (SME) in Web application with Selenium & Java/C#.
 Lastly holding Team Lead & Test Manager position. Total 15.10 yrs. experience in Software Industry. At the beginning worked as Oracle & Power Builder developer & designer on banking & accounting software for 1.9 yrs.
 Extensive experience in Manual Testing and Test management.
 Extensive experience in GUI, Functional, Integration, System and Regression Testing.
 Extensive experience in Agile Model.
 Extensive experience in Database design & SQL.
 Extensive experience in ETL, Data Stage & BI Testing.
 Experience in Test Automation (Selenium Web driver, QTP).
 Experience in SAP BW/BI/BO testing with Functional personnel of finance & inventory module.
 Experience in all stages of Development & Testing Life Cycle.
 Experience in Defect Tracking.
 Experience in team player with problem-solving and troubleshooting capabilities.
 Experience in Data Science (with Python & R languages).
 Experience domain in Banking software, Retail software, Telecom software, Health care software, Library software, Chain marketing software.
 Flexible to relocate in any location to work. Projects are done in WAL*MART, AVAYA, Citi Bank, MEDecision, Rail Europe, JobStar,
CA Technologies, Vodafone.

Show More

Portfolio Projects

Description

Callidus is a cloud-based application to automate sales incentives for Front line and First Level Manager for different channels & Circles. Callidus will pull these files from the staging server and will process into the pre-processor system for calculating the commission and incentive. Quality Assurance Testing involves on the basic critical business user test cases and does the execution activity for same.
Responsibilities:
 Test Case designing, Automation scripting, and Test Data preparation.
 Requirement verification & mapping with the Test case.
 Analyzing Requirements in HPALM.
 Checking requirement traceability with test cases.
 Identifying gaps in traceability and adding/modifying test cases if needed.
 Reviewing Test Case & script execution.
 Executing Test cases for Callidus.
 Executing Callidus Hot Fixes Tests for Initial & Delta load.

 Identifying & reporting issues & defects during execution.
 Bug reporting and test results reporting.
 Handled complete Test management program till release of the product for each module.
 Reviewing of tasks of new joiners & other team members.
 Doing work allocation within team.
 Consolidating issues & queries from all the team members & forwarding them.
 Following up on the issues & posted defects.
 Maintain & send status report to client managers.
 Coordinating calls whenever required.
 Knowledge sharing with new members.
 Involved in Automation, ETL & Data Stage Testing:
o Performed Automation script creating, modifying & regression testing.
o Performed ETL testing by transforming business logic into Test case and running ETL scripts validating source to target mapping using database.
o Performed BI report testing using data validation.
o Verify the implemented ETL code against the corresponding mapping & transformation rule document.
o Confirm the data loads from source files into the target tables.
o Examine sample record sets for consistency, data corruption and over all data quality.
Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases through all parts of the development lifecycle.
Also Involve in QA & UAT activities in BAU MI-BI portfolio (database) of Demands (DMs), Change Requests (CRs), Incidents and Service Requests (SRs) etc.

Environment : Selenium Web driver 3.11.0, Java, Oracle 11g, Teradata,Netezza, SQL Server 2008, BD2, ETL, Informatica, Callidus, Oracle Business Intelligence (BI), Cognos, HPALM11/12,Business Object (BO), Share Point, QTP11, .net, C#,

Show More Show Less

Description

Netezza-Step2 migration of the data warehouse from Teradata to Netezza. This project will be delivered as Platform Migration Step-2. Key Commitments of EDW Replacement Projects are to provide an EDW platform that generates timely analytics information i.e. "Achieve agreed Latency of Daily and Monthly reports" & "Migrate EDW from Teradata to Netezza".The platform migration will make use of Netezza Mako platform as key solution in production environment forth hosting of Teradata exiting data, Vodafone LDM residing in current Teradata platform and other physical objects and databases. The solution activities will follow to support Netezza related migration changes for Data Stage and Tivoli jobs.

The ELT Script conversion - This is a re-usable code migration solution used in all the required migration work streams captured in this document. Project will make use of automated ELT code conversion tool which has successfully delivered results during Netezza Step-1 project. The tool helps to convert Teradata specific BTEQ scripts/SQL, /Procedures/DDL’s to Netezza specific NZ SQL/scripts/SQL’s/DDLs. This tool will use the Teradata Vs Netezza Data Type, Functions, pattern to convert. This tool takes cares of above 90?L conversation and above 80 % of BTEQ script conversion. Unsupported functionality or change has done manually.
Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios, automation scripting and repeatable test cases through all parts of the development lifecycle.

Environment : Selenium Web driver 2.48.0, Java, Oracle 11g, Teradata,Netezza MACO, SQL Server 2008, BD2, ETL, Informatica,
Oracle Business Intelligence (BI), Business Object (BO), Cognos,SAP BW/BI/BO, Oracle CRM, QTP11, .net, C#, Share Point,HPALM1
1

Show More Show Less

Description

Project Description:
Walmart-Brazil had acquired Bompreço Stores (North-East Region) which contains all of Item File information in a legacy system (SAD). Currently all the NE Item Creation and Maintenance is performed onto this SAD system.
The purpose of this project is to provide a solution for Integrating North East Item file Data to Wal-Mart’s Online Item File Database through an Initial Load process.
The current applications on SAD facilitating the NE Item creation / maintenance should be locked / frozen (inactive) with a planned activity before the start of Initial load during GO LIVE.
After post initial load, the Item Sync process at OIF for NE Item creation/maintenance will be planned to get launched during GO LIVE.
Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases through all parts of the development lifecycle.

Environment : ETL, Informatica, Java, Oracle 11g, Share Point, Oracle BusinessIntelligence (BI), QTP11, HPALM11, .net, SQL Server 2008, BD2

Show More Show Less

Description

Project Description:
The goal of this LMS (Learning Management System) project is an employee training software of CA Technologies. It’s a product of SumTotal.The Elements of LMS are Online Course, Notification, Blogs, Training, Registration, Admin, Parameterization, Instructor Assignment, Employee, Reporting, Mobile Learning etc.

Environment : ETL, Informatica, Java, Oracle 11g, Share Point, Oracle Business Intelligence (BI), QTP11, HPALM11, .net, SQL Server 2008,

Show More Show Less