3Rd Party Data Warehouse
Resume:
Kirti Bakal (Tayade)
E-mail: *************@*****.***
Cell: +1-317-***-****
EXPERIENCE SUMMARY:
●Around 7+ years of experience in validation.
●5+ years of experience in Software validation in CRM, ETL and Data warehouse.
●Recent - 1.8 years of experience in Telematics (Connected Car) validations for OEMs and 3rd party telematics service providers.
●Experience in Telematics validation of Cummins digital products such as CSU(OTA), CD, EDL & EFPA integrated with Partner TSPs (Telematic devices).
●Expertise in bench connection/setup and validation with ECM/ECUs and telematic devices
●Experience in validation of interface between ECM, Telematic device and related cloud systems.
●Understanding digital communication protocol like CAN on UDS and J1939
●Experience in FMEA, requirements analysis, CAN trace analysis, API Testing.
●Experience in working with internal teams and the external partners (OEMs or 3rd party telematics service providers)
●Hands on proficiency in tools like PCAN explorer, PCAN view, Calterm, putty, Postman, AWS, Guidance (mobile app), Unix, Winsep
●Knowledge of Databases (SQL server, Oracle, Db2), Unix, ETL informatica, MSBI, Seibel CRM.
●Proficient Expertise in Test artifacts like Test Plans & Estimation, Test Scenarios, Test Cases development & management, RTM, Test Summary/closure Report, Defect tracking & management
●Knowledge on Testing Life Cycle, Defect life cycle, different types of tests (Sanity, regression etc.)
●Experience in Agile methodology and Jira.
●Good interpersonal, analytical and communication skills, quick learner, team player.
ACADEMIC’S:
●B.E. (Electronics & Communication) from Amravati University, July 2009 with aggregate of 68.30%
●Diploma in Software Testing from Seed Info Tech Ltd. Pune
WORK HISTORY:
●Jun 2023 – Jan 2025 - Scalable System – TCS (Client – Cummins Inc) as Validation engineer.
●Nov 2013 – May 2016 - Infosys organisation as Test Analyst
●May 2010 – Oct 2013 - TechMahindra Ltd organisation as Technical Associate.
ACHIEVEMENTS:
●Awarded with “PAT on the Back” award during my work with TechMahindra.
●Got appreciation emails from Client and Manager in Cummins
WORK EXPERIENCE
1.Organization: Scalable Systems_TCS (Client Cummins)
Project Name: Telematics Validation
Environment &Tools: Calterm, PCAN Explorer, PCAN View, AWS Cloud Services, Postman, Olympus Portal, Connected Solution Portal, Jira, qTest, Putty, Unix, Winsep.
Project Description:
Validation of Cummins digital products such as CSU, CD, EDL & EFPA for the partner TSP.
We closely work with both internal teams, (Prod Support, Development, Olympus) and external partners (OEMs or 3rd party telematics service providers).
Responsibilities:
●Analysis of requirements, estimating required time and efforts
●Development of Test Plans and Test cases.
●Bench set up with ECM, related ECUs and Telematics device
●Get the Harness constructed/modified as needed.
●Test Execution includes the Validation of the integration between ECM and telematics device though tools like PCAN explorer, Calterm, AWS clouds etc
●Analyse the CAN trace to observe the defects/issues
●Report the defects, retest after fix.
●Support to FMEA
●LP support when needed (resting defects)
●Managing Shipments to OEMs/ TSPs as per need basis
●Interaction with the client on daily/weekly basis
●Details for Feature Validation:
-Connected Diagnostics - Simulate the faults though Calterm and check if those are processed though clouds
-CSU/OTA – Create the Calibration (Test/dummy) and download it to ECM, monitor process till Port Over through Calterm and PCAN explorer and OEM/TSP portal
-EDL/eFPA – Raise the request to download the ECM data (Parameter values) through Portal and check if files are processed till end point.
2.Organization: Infosys Ltd
Below are the important projects worked on as part of data warehouse testing.
Name: Cross Border Transactions, COT-BPM.
Environment &Tools: UNIX, Teradata, Winsep, Informatica, Teradata, DB2, Quality Center
Project Description: The Project basically deals with managing the Cross Border Transactions in Europe. The Transaction falling into new category will be eligible for interchange rates which are lower than the current interchange rates. To fulfill this requirement there were certain transformation logics applied to source data, we validated if these logics are correctly implemented and the correct transformed data is loaded into Target tables. The Data from source files is loaded into BPM database and then to Teradata BIW tables for reporting purposes.
Responsibilities:
●Analysis of requirements, estimating required time and efforts
●Development of Test Plans and Test cases.
●Extract the Source files from Unix Path, check if the transformation logics are applied correctly and then load the date into intended Target database tables
●Raise the defects and retest after fix.
3.Organisation: Techmahindra Ltd.
Project: Lattelecom SDLC
Environment: Siebel E-communication 8.1, Test Director, Jira
Project Description:
Techmahidra provided the CRM solution to Lattelecom, which is the leading provider of electronic communications services in Latvia. The CRM solution was provided on Seibel platform. We validated the functionality across all the available solutions (Account, Orders, Opportunity, Quotes, Prospects etc) though Seibel CRM.
Responsibilities:
●Analysis of requirements, estimating required time and efforts
●Development of Test Plans and Test cases.
●Validate the functionality as per the requirements with Seibel CRM UI.
●Raise the defects and retest after fix.
Contact this candidate