Shilpa Patil

Client : Western Alliance Bank

Project Description:

Design and implement a system for gathering data from multiple sources related to customer accounts, processing it to generate insightful reports on account balances, transactions, and customer activity, with a focus on accuracy, efficiency, and easy accessibility for business decision-making

Responsibilities:

• Verified the accuracy, completeness and integrity of data being extracted, transformed, and loaded from source systems to target systems, including performing data reconciliation between source/target systems
• Verified Fact and dimension tables data
• Performed Data validation using SQL and Python coding
• Data validation in star schemas, snowflakes schemas
• Performed Data flow verification from multiple sources to data warehouse and validation of Power BI reports
• Verified data correctness in to SCD’s and SCD type 2
• Test Planning: Created comprehensive test plans outlining testing strategy, test scope, test scenarios, and test cases to be executed during the ETL testing process
• Created test closure reports and RTM documents for completeness of requirements
• Test Design: Designed and developed test cases based on the requirements and test strategies
• Worked with Product owners and business analysts on requirements gathering
• Prepared SQL scripts as per the ETL process
• ADF Pipeline validations
• Defect Management: Managed defects lifecycle using JIRA/Azure DevOps including defect identification, logging, tracking, and verifying defect fixes
• Performed data integrity testing, data testing, cloud testing, data quality testing, regression testing, smoke testing
• Strong knowledge of software development life cycle (SDLC) and software test life cycle (STLC)
• Designed and written test cases based on the requirement specifications, documentation, and test plan
• Led QA team and ensured tasks are undertaken and completed based on the discussions/emails, involved in sprint planning
• Quick response to issues/bugs, research and communicate on analysis

Client : ANZ

Project :RCE Account

Project Description:

RCE enables customer to transfer funds between their own accounts and payments in real time, which includes complex accounting posting and FX orchestrations

• Transactions include retail fund transfers, credit-card payments, and international transfers
• Responsibilities: Led offshore team and ensured tasks are undertaken and completed based on the discussions/emails
• Worked on ETL and Manual testing projects
• Gathered the queries related to the requirements from team members and got them resolved by the BA
• GUI testing including web pages, images, captions, content testing, http/https testing
• Worked closely with subject matter expert SME, product owners, scrum masters and Business Analysts for requirements
• B2B testing including upstream and downstream systems
• Performed regression testing, smoke testing, system testing, end-to-end testing, UI testing, sanity testing, SIT testing, UAT testingLed offshore team and ensured tasks are undertaken and completed based on the discussions/emails
• Worked on ETL and Manual testing projects
• Gathered the queries related to the requirements from team members and got them resolved by the BA
• GUI testing including web pages, images, captions, content testing, http/https testing
• Worked closely with subject matter expert SME, product owners, scrum masters and Business Analysts for requirements
• B2B testing including upstream and downstream systems
• Performed regression testing, smoke testing, system testing, end-to-end testing, UI testing, sanity testing, SIT testing, UAT testing

Project BNYM

Client : BNYM bank

Project Description:

This project was about valuation of FX Option trades

It includes functions such as a) store and process market data received from various vendors like Vendor–Tullett and Reuters b) identify and integrates FX Option trades from trade request files received from DPX c) integrate MDDB with OTC Derivatives pricing engine – Fenaperones d) the price response after receiving the prices and other relevant outputs of the Fin CAD valuation function

Responsibilities:

• Worked on Manual and API testing
• Designed and executed test scenarios for API testing,
• Validated RESTful APIs for transaction processing, user authentication, and reporting.
• Performed regression testing, smoke testing, system integration testing, sanity testing, black box testing, white box testing

Project Wealth Manager (Venus)

Client: Alliance Trust Savings, Liverpool Victoria, Home Owners friendly Society

Project Description:

Active bank Personal Investment Platform provides full retail, private customer and institutional investment and banking support, and incorporates it provides sophisticated portfolio modeling, performance measurement and decision support facilities across a broad range of instrument types.

Responsibilities:

• Performed regression testing, smoke testing, sanity testing
• Writing test cases and executing test cases, defect validation