1.BNP Paribas S.A. is a French international banking group. It is the world's 8th largest bank by total assets, and currently operates with a presence in 72 countries. The primary goal of this project is identifying premium customers and lending them loans with less interest.PLUS- Preferred Lender in the US (BOW – Bank of the West (Data Warehouse Testing)) Responsible for business, and technical reconciliation testing across each layer and the test execution for all the phases like ST, SIT and UAT for each layer. Had professional experience in handling in very high-volume core banking data and interface with core banking system including Source, stage, Datastore and Report layers. Tools Used – Oracle, Unix, Informatica, ALM2.Citibank the consumer division of financial services multinational Citigroup. The primary goal of this project is identifying the gap in the existing systems (Deposits, Cards, Mortgage and Personal Loans) and amending the new requirement.GENESIS (Data Warehouse Testing) Primarily responsible for liaising with the client team including Business Analysts, Product Owners, Project Managers, and developers working on multiple time zones to define the test scope. Main technical tasks include - Designing test scenarios, writing test cases using advanced SQL querying with complex mapping logics, preparation of Phase Test Plan (PTP), daily and weekly test status reports & Test Summary Report (TSR). Coordination and follow-up on the bugs and tracking them diligently until fixes and close them on time. Tools used – Abinitio/Datastage, Teradata, JIRA, HP ALM

Gilead Sciences is an American biopharmaceutical company that discovers, develops and commercializes therapeutics. The primary goal of the project is delivering HR Analytics report by using employee details data. I. HR Analytics (Business Intelligence Project – Data Warehouse Testing) Coordinated the onsite testing team and provided valuable inputs on validation and verification tasks. Held the complete responsibility in Phase Test Plan (PTP) preparation, Test scenarios, and Test cases design. Besides coordination, technical tasks include, designing SQL scripts based on the complex mapping, test execution, defect tracking, and Test Summary Report (TSR) preparation. Tools Used – Oracle, Informatica, UNIX, OBIEE, HP ALM