Professional Summary
- Over 7 years of IT experience in testing Web application testing and understand architecture in terms of functionality as well as ETL/Business Intelligence solutions. - Performed Backend QA testing in various industries such as Banking, Insurance, and Capital markets - Strong understanding of Equities and Fixed Income products with respect to Brokerage Operations, Margin Trading and Securities Lending. Worked on Trade capture, Middle Office Operations, and Back Office Settlements. - Successfully led the design and deployment of the overnight automated batch system for various products. - Adept in reviewing Test Procedures, creating Test plans, Test Scenario, defining System & Integration Test Cases, executing Test Cases, Test - Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing errors and UAT testing. - Good understanding of SDLC, QA concept (e.g. Functional, Integration, Systems, Regression testing) and agile development methodologies - Experience in working with business analysts/customers to understand customer requirement and convert this into the test plan/ test case development - Strong Knowledge in the ETL process, DDL and DML statements, Data Warehouse Architecture, Physical and Logical Data Models. - Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide- ETL solution using ETL tools like Informatica, SSIS, Abinitio. - Experience in writing and executing complex SQL queries to validate actual vs. expected results and to validate data from source to target Strong technical knowledge of UNIX Utilities, shell Script to automate the process - Solid knowledge of using MS Excel. Used advanced functions like V-lookup, Pivot tables, and analysis. - Performed backend database testing by writing SQL and PL/SQL scripts to verify data quality and data integrity - Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process Led multiple projects/releases simultaneously and coordinating across multiple project teams. - Involved in functional, end-to-end and regression testing of Trade booking and settlement logic as well as related ETL processes developed to fetch data from front office DB systems to the target data warehouse using complex SQL queries. - Created ETL test data for all ETL mapping rules to test the functionality of the data flow. - Good knowledge of Informatica Designer Components -Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager, and Workflow Monitor. - Strong understanding of quality control via Verification and Validation processes to comply with specified requirements. - Performed different types of testing such as UAT, Functional, Regression, Integration, Black Box, Stress, Backend, Positive, Negative, Risk-based, Volume, and Performance. - Excellent Domain knowledge in Banking and Trading. - Develop and execute detailed ETL related functional, performance, integration, and regression test cases, and documentation.