Mayank Ahuja Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Gurgaon, Haryana

Quality Engineer of AI/ML application - AiDa having responsibilities to test complete AiDa platform - UI, API, DB, ODL ingestions and Modellers’ code. Responsible for conducting whole testing activities alone of AiDa Application during migration from On-Prem to GCP.Quality Engineer of Big Data Real-time Streaming ecosystem having responsibilities to quality test Kafka Streaming (producers and consumers), Spark Jobs, MapR Data persistence, APIs and Splunk Dashboards. The major… Show more Quality Engineer of AI/ML application - AiDa having responsibilities to test complete AiDa platform - UI, API, DB, ODL ingestions and Modellers’ code. Responsible for conducting whole testing activities alone of AiDa Application during migration from On-Prem to GCP.Quality Engineer of Big Data Real-time Streaming ecosystem having responsibilities to quality test Kafka Streaming (producers and consumers), Spark Jobs, MapR Data persistence, APIs and Splunk Dashboards. The major responsibility is to test business logic, real time performance, latency and delays, data persistence, Splunk Logging and Data Visualisation on real time card members data streaming from different sources, for instance: transactional data, chat data, payment data, call data etc, produced into Kafka stream and consumed using same Kafka topic, apply business logic on real time data using spark and again produced the output in Kafka topic or either stored the data in LLC. Show less

Noida Area, India

Senior Test Analyst - Python-DB-API Automation Tester. QA Lead and SME.As part of Reference Data System, the application receives Funds' and assets' Market data, pricing data, instruments' data, issuers' data etc from various third party system likes Thomson and Reuters, Bloomberg, Morning Star and FIL Internal System either in form of Batch Files having millions of data and in Json form whenever data changes. As a tester the responsibilities were to perform various data testing… Show more Senior Test Analyst - Python-DB-API Automation Tester. QA Lead and SME.As part of Reference Data System, the application receives Funds' and assets' Market data, pricing data, instruments' data, issuers' data etc from various third party system likes Thomson and Reuters, Bloomberg, Morning Star and FIL Internal System either in form of Batch Files having millions of data and in Json form whenever data changes. As a tester the responsibilities were to perform various data testing like File to File testing, File to Table testing, Table to Table testing. File to File and File to Table testing used to be done using Python Automation Frameworks, and Table to Table to testing used to be done using complex SQL Scripts. For E2E Testing, Python Scripts are built that used to perform every layer of testing File-File-Table-Table testing. For realtime, the testing was performed manually and/or using some python utilities. When QA team grew, i played the role of an SME and QA Lead and trained a few QAs and Test Lead on how RDS must be tested considering the complexity of the application and how we can deliver a quality product in production with zero defects.As part of RDS, I was also responsible to perform Testing of applications built on top of RDS such as NSS - New Security System and GENUS - Asset Classification. Show less

Noida Area, India

Manual Testing,Exploratory Testing, Java Automation, Python Automation, SQL Scripting, VB MACROS

Mysore

Test Engineer - Manual Testing under WaterFall Methodology using Shell, SQL and Excel. Automation Testing using Excel Macros.I started my professional career with Infosys , trained in fast based 3 months Testing program in Bhubaneshwar, deployed in Mysore post training and provided my services to AllState Client - US one of the largest Insurance Based company. As a QA, I was responsible for testing various bonus programs initiated by the company for its agents who brings the… Show more Test Engineer - Manual Testing under WaterFall Methodology using Shell, SQL and Excel. Automation Testing using Excel Macros.I started my professional career with Infosys , trained in fast based 3 months Testing program in Bhubaneshwar, deployed in Mysore post training and provided my services to AllState Client - US one of the largest Insurance Based company. As a QA, I was responsible for testing various bonus programs initiated by the company for its agents who brings the business for the company. The Bonus program application was written in PL/SQL in order to filter records and store in RDBMS and calculation of bonuses was written in Callidus TrueComp tool.The RAW data was in flat file generated by ETL tool Abinitio, stored in RedHat servers. Shell jobs were written to read those files at specific time and calls PL/SQL or SQL module to load data in RDMS. I was responsible for Test Planning : - Test Execution Approach, Cycle Plan, Test Scenarios and Test Cases. Get these documents reviewed and approved by Client. The approach for writing test cases is such that we need to mention each and every Oracle Tables' attribute values in the test cases itself based on the scenario and match it against the table when execution is done. Test execution was done manually initially and using SQL. Later, when i was able to play with the application I used to perform testing using SQL scripts and them automated it using excel Macros by writing all the mathematical business logic defined in Callidus TrueComp in excel using formulas which on supplying input values to defined cells provides you the outcome and compare it automatically against DB for every valid agents. Show less