Prashant Saxena

Experience

• 

  Tata Consultancy Services

  Mar 2011 - Nov 2021

  Client Deutsche Bank• Data Loading of various sources like Bloomberg, Symphony, Facebook etc on environments for further processing• Creation of Automation scripts in python for data loading and reconcilliation• Triggering flattening, transformation, and ingestion jobs for various sources to flatten the raw file and then having it transformed into avros of required format for ingestion into third party system - ATTIVIO.• Lake side validations of creation of avros on HDFS and manipulating these avros as test scenario required.● Preparing useful data from different sources.● Pulling Data from Hadoop, Hive SQL and other various sources● Performed Data cleaning, transformation base data into system readable format.● Data imputation, removing outliers, handling missing values, removal of duplicate data, handling of correlated data.● Implementing descriptive statistics and visualization techniques to check the data normality.● Histograms and Bar charts to check out the distribution of all the driver variables● Performed the Multivariate analysis to understand how different variables interact with each other.● Study and Deep understanding of all Variables and Data sets and distributed the cases into Low, Medium, High and Very High Risk Categories Show less Client Deutsche Bank• Big Data Hadoop, ETL Testing, Data Migration Testing• Automated Test Scripts through Informatica Power Center• Core Services Functions-Deployments, Configuration fixes• Performance Testing-Performance Center, Vitual User Generator• Creation of Automation scripts in python• Feed side validations of logs and errors for sources like Symphony, Bloomberg, etc., using putty.• Triggering flattening, transformation, and ingestion jobs for various sources to flatten the raw file and then having it transformed into avros of required format for ingestion into third party system - ATTIVIO.• Lake side validations of creation of avros on HDFS and manipulating these avros as test scenario required.• Coordination with business through sprint planning calls, and demo calls.• Coordination with Dev team to meet in-sprint timelines of 15 days.• Governance and control of all artifacts and deliverables along with release management• Managing Deployments Versions in SIT/UAT environments• Participating in all agile ceremonies of project. Show less Client CVS Caremark• Ensured adherence to testing standards and best practices. Created comprehensive test scripts to support testing objectives.• Business Rule simplifications for test design and validations.• Perform smoke, regression, functional testing.• Assisting team members in Knowledge Transition.• Review the design of test cases before the test cases are ALMready.• Defect logging and tracking through Quality Center, ALM.• Coordinating with team at offshore and owned functionalities like RxProcessing, TPA, CorpAdmin etc to design andexecute.• Log as many valid defects as possible and coordinate same to development for fix in triagecall.• Coordinating the progress of project testing to onsitecounterpart.• XML validations using Simulator and checking Response on Requesting XML by pinging a server through putty. XML log validations across systems and DB validations.• Validation of Hardwares integrated with application – Hardcopy Printer, Barcode Scanner, POS etc Show less

  • Assistant Consultant

    Feb 2020 - Nov 2021

  • Assistant Consultant

    Oct 2018 - Feb 2020

  • IT Analyst

    Apr 2015 - Oct 2018

  • System Engineer

    Mar 2011 - Mar 2015
• 

  Cognizant

  Nov 2021 - Jul 2022

  Senior Associate

  • Prepared strategy for Data Migration from Mainframe file to SQL Server• Data Analysis and Data mapping from sub-systems to RLG system.• Data transformation validation through informatica and plsql queries• Collecting data from various books of business.• Performing Data cleaning, transformation, validation with the purpose of understanding or making conclusions from the data for decision making purposes.• Implementing descriptive statistics and visualization techniques to check the data normality.• Reduce the data dimensionality by using feature engineering techniques.• Data imputation, removing outliers, handling missing values, removal of duplicate data, handling of correlated data.• Histograms and Bar charts to check out the distribution of all the driver variables• Coordination with business through sprint planning calls, and demo calls.• Coordination with different teams to meet in-sprint timelines of 15 days.• Governance and control of all artifacts and deliverables along with release management• Managing Deployments in different enviornments SIT, UAT, Pre-Prod etc• UAT Co-ordination with business users across the globe Show less

• 

  Genworth

  Aug 2022 - now

  Actuarial QA Lead