SUMMARY

• Over 7 years of experience in the field of Capital Markets/Data Migration/Data Validations as a QA/SQL Analyst.
• Diversified experience in implementing Testing Methodologies, Manual and Automated Testing on various web and client/server - based applications.
• Solid knowledge of Trading platform End to End workflow and trade booking verification.
• UAT Testing experience during Business/Technology team application testing.
• Extensive experience in working with various test strategies and preparing Test Plans, Test Cases Test summaries and Analyzing Test Results.
• Experience in Fixed Income, Equities, Swaps and Option products.
• Strong knowledge in fixed income pricing and trading and extensive experience supporting Trading System including Front Office, Middle Office Back Office systems.
• Implemented the Software Development Lifecycle to follow standards in the application development.
• Good knowledge of QA methodologies and process of software validation principles.
• Experience in creating scripts for performing Functional, Regression, Integration and System Testing and User Acceptance Testing.
• Extensive working knowledge of Functional, Regression GUI, End to End, Back-End testing.
• Strong SQL skills, experienced in finance/banking related RDBMS. Good understanding of scripts/codes, complex queries used by developers.
• Worked with testing tools such as QC-ALM and JIRA.
• Experienced in backend and ETL testing (SQL, PL/SQL, DB2 and Oracle DB).
• Experienced in Ab Initio, Informatica ETL tools.
• Good knowledge of UNIX commands for troubleshooting and performing root cause analysis.
• Experienced with Troubleshooting and resolving issues related to client/server and web applications.
• Having experience in solving analytical problems and documentation.
• Experienced in working with Project manager, Development team, Business Analysts and End-users.
• Proficient in assessing progress and providing status reports to stakeholders.
• Experienced in identifying risks, creating risk mitigation plans and minimizing risk.
• BI Reporting experience, worked with OBIEE.
• Worked with data visualization tools such as Tableau and Microsoft Power BI.
• Experienced with SQL in Risk Management reports, such as Liquidity Report, Credit & Deposit portfolio reports, GAP analyze, Operational Data Reports, preparation and implementation of Risk models, such as Vintage curves and Transition Matrix, LCR (Liquidity Coverage Ratio), collection of data for Scoring model. Performed extraction of data from credit contracts, where I work with XML data.
• Strong abilities to work in pressure-environments and effective problem solving and troubleshooting skills.

TECHNICAL SKILLS

Programming: Java SE, UML, JavaScript, HTML/CSS, SQL, ERD

Testing Tools: QC-HP ALM, JIRA and Load Runner

Operating Systems: UNIX/Linux, Windows XP

RDBMS: MS-SQL Server, Oracle, DB2, MS Access, MySQL

Web Technologies: HTML/DHTML, XML, Java Script

Microsoft Tools: MS Office Package - Word, Excel, Power Point, Outlook.

Data Visualization Tools: Tableau, Microsoft Power BI

PROFESSIONAL EXPERIENCE

Confidential, NC

ETL Data Validation Lead

Responsibilities:

• Performed Upstream and Downstream data validations, developed estimation, test plans to outline the scope, analysis, approach, resources, schedule of testing, writing test cases, test execution, and test completion report.
• Worked closely with offshore team for validating test items in scope, to track progress on daily basis, to create automation suite for repetitive test scripts, to discuss the discrepancies identified by team.
• Worked with Dev and Business teams regarding clarifications during test planning and testing process.
• Downstream Data Validations - Included feed file validations - flowing to Downstream applications. Data validations were based on Downstream systems business needs and validations were executed using complex SQL queries.
• Creating RTM for Testing Scope, providing daily reports to management regarding Test Plan, script execution and progress.
• Participated as part of Shell Scripting & Tosca based Test Automation teams.
• Executed Functional Unit Testing, System Integration Testing, Regression Testing and UAT.
• Worked extensively with ETL Testing including Data Completeness, Data Correctness, Data Transformation, Data Quality with analyzing feed files in Downstream scope (Balance, Transactions and Master data type of feeds).
• Reviewed Business Transformation Mapping documents, Business and Functional Requirement documents.
• Used HP ALM Quality Center for Test Plan/Test Lab/Defect Management/RTM.
• Worked with CRs (Change Requests), coordinated meetings with different Business/Tech teams regarding clarifications needed for further progress, tracked CRs related to the workstream and reported the progress to management on daily basis.
• Used Tosca and Shell Scripting for Automation.
• Worked with Requirement Analysts, Project Managers, Test Coordinators, Mappers, Dev teams and other Testing Teams to resolve issues with requirements, mappings and transformations.
• Participated in daily meetings with Testing Team, Test Planning meetings, Change Control Board Meeting, Defect Review meetings, meetings with Dev team regarding issues/discrepancies - identified during test execution, Test Prep calls, Testing Status calls, meetings with Business team, Dashboard review meetings, as well as ad-hoc meetings with different Downstream teams regarding defects/CRs.
• Used WinSCP/Putty for file management and for Automation Shell Script suite.
• Used Toad for Oracle as Database tool, worked with Views, Indexes, Stored Procedures, complex SQL queries for validating accounting/GL data.
• Performed Data Analysis, identified data dependencies in source system to create test data sets and queries for validating calculations and approaches/logics.
• Reconciled data between feed files from the source vs target DB tables, performed data validations in target system for data consistency and accuracy. Performed data level checks to ensure data integrity and business rules are applied properly.

Confidential, NJ

Senior QA Analyst

Responsibilities:

• Was 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.
• Worked with the BA and Dev team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Participated in UAT testing along with Business representatives (Middle Office and Back Office team members)
• Developed an enhanced testing effort to meet aggressive deadlines during a companywide global freeze period.
• Worked with various application teams to get a sign off for end to end process flow.
• Performed dependency and condition validation of Autosys jobs and boxes.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs.
• Tested the ETL Ab Initio mappings and other ETL Processes ( DW Testing ).
• Supported the ETL process for a Data Warehouse from their legacy systems using Ab Initio .
• Tested ETL with Front office data as source and tables in the settlement databases warehouse as target.
• Tested ETL process for feeds received from counterparties' back office and compared with the data that was received from Front office for consistency.
• Tested all the reports generated using SSRS tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Validated incremental iterative application releases using an agile process (Scrum).
• Tested User Interface inconsistency and application functionality.
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Created and executed test cases for all the required extracts and prepared test scripts for interface validation and End to End and Integration Testing.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Managed Offshore team and Organized testing schedule and resource allocation.
• Responsible to perform UAT and get UAT sign off from business users.
• Designing the entire documentation like Test Plan, Test Scenarios, Detailed Test Cases and Test Results in HP ALM for specific projects.

Confidential

Quality Analyst

Responsibilities:

• Involved in Scrums and Daily Sprints in the agile methodology.
• Performed GUI Test, Smoke Testing, Accessibility Testing, System Integration Testing, Regression, User Acceptance Testing (UAT) and Performance test.
• Involved in writing of all documentation for all system level tests, test plan, test cases and validation procedures.
• Individually verified and validated the Complex web-based application as per the business process flow.
• Created test plan and verified test entry and exit check lists to deliver a good quality product.
• Responsible for planning and analyzing the user requirements, procedures and problems to test the automation of new and existing functionalities of the web application.
• Performed Independent Verification and Validation testing for various applications in each build.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Used UNIX commands to investigate log files and search for patterns.
• Worked on SQL to access data from RDBMS, which is loaded on batch runs for positions, balances and other reference data.
• Participated in documenting test deliverables like Test Plan, Test Scenario, Test Cases and Test Results in Quality Center ALM for sprints.
• Involved in regression and integration testing of various components of the application.
• Performed backend testing by writing and executing SQL queries in testing databases to validate test results and to debug discrepancies.
• Involved in various meetings with Business Analyst, Developers and Project Manager.
• Involved in summarizing QA Sign-off items for testing cycles and the target scheduled release dates and acceptance testing of all products prior to their release.
• Responsible for coordinating/managing the testing activities and the timelines for each release.