Jay Prakash Yadav

About Jay Prakash Yadav

Over 10+ years of IT experience in the Business System Analysis, Data design, Data Mapping, Data Migration, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, Azure, ADB, ADF, ETL, OLAP, Big Data Hadoop. Solid Back End Testing experience by writing and executing SQL Queries. Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software.• Have 10 years of IT experience as Business System Analyst, ETL Tester, Functional Tester, Automation Tester, Data Analyst (APRA Regulatory Reporting) • Microsoft Certified: Azure Fundamentals (AZ-900), Data Fundamentals (DP-100), Power BI Data Analyst (PL-300).• ISTQB certified in Foundation Level in Software Testing & Agile Tester Foundation Extension.• Experienced Business System Analysts with expertise in Data Ingestion using Azure ADF, ADB, Data lake.• Have vast experience in Investment Banking & Financial Services domain including Superannuation, Insurance, Wealth, Investment.• In depth functional understanding in Equities, Trades, Managed Funds, Deposits, Withdrawals, Terms Deposits and Contributions.• Testing Expertise in Data Migration projects, data quality, data integrity, data reconciliation and reporting solutions• Experience in Hadoop Big Data testing using technologies like Hive & Impala.• Automated Regression test cases using Selenium Web driver and Apache POI. • Capable of delivering all the test deliverables like test approach, test plan, TCR, RTM etc.• Good verbal & written communication, interpersonal, analytical & problem-solving skills developed by working over 8 years in IT industry.• Validation of data transformations and perform End-to-End data validation for ETL & BI systems• Good understanding on Data warehouse data models and creating test scenarios and test cases.• Strong in ETL data validation developed using Informatica / HIVE/ SSIS ETL environments• Strong in BI report validation developed using COREBIS /Business /SSRS BI• Expert in writing SQL queries in SQL Server / Hive /Impala and testing ETL data flow pipe line across the data layers.• Managed and lead testing teams from both offshore & Onshore locations.• Coordinated with third party vendors like AUSTRAC, TM1 (COREBIS), APRA, Morningstar for smooth function of the application and testing the business requirements.• Experience in working with Agile Scrum teams.• Knowledge in continuous integration and test automation with Selenium / UFT tools.

Experience

1. Senior Project Associate

   Cognizant

   May 2023 — Present · Pune, IN

   Business System Analysis for migration of source data from legacy system to Azure Cloud using services and application like ADB, ADF ETL pipelines, Data Lake into Standardized Raw Zone and Curated Zone.Skills: Data Mapping, Data Modeling, Enterprise Data Catalog, Incoming Data Catalog, Outgoing Data Catalog, Data Transformation, requirement Gathering, Stakeholder Management, User Stories, JIRA, Team Collaboration.

Education

• DPS MIRZAPUR

  Intermediate

  2004 — 2007

• B.S.A. College of Engineering and Technology, Mathura

  Bachelor of Technology (B.Tech.), Electrical and Electronics Engineering

  2008 — 2012

• BSA College of Engineering & Technology ,Muthura

  Bachelor of Technology - BTech, Electrical Engineering