PROFESSIONAL SUMMARY

• Software Quality Assurance Analyst with solid experience in backend and middle office applications of various financial applications is seeking a QA role in Finance domain.Extensive noledge of ETL and batch processing using SQL along with experience in using UNIX based commands.
• Proficient in Functional and Non - Functional types of testing such as System Testing, Stress Testing, Load Testing, Reliability Testing, Regression Testing, Acceptance Testing, GUI, Functional Testing, Migration Testing, System Integration and User Acceptance Testing.
• High expertise in End-to-End validation of orders with various financial instruments such as Fixed Income (US Treasuries, Munis, Corporate bonds) and Futures.
• Experienced in SQL queries for Backend testing and data verification from different tables with use of Select statements, aggregate functions, joins, where and having clauses;
• Expert in End-to-End validation of different type of flows related to trading applications
• Experienced of using MS Excel advanced functions like V-lookup, Pivot tables and analysis;
• Basic understanding of FIX Protocol and XML Message;
• Experienced in testing applications written on JAVA, JAVAScript, HTML languages.
• Strong skills in SQL, experienced in finance/banking related RDBMS. Good understanding of scripts/codes used by developers.
• Extensive noledge of different databases, such as SQL Server and Oracle; constructing queries and resolving debug occurring issues.
• Experienced in backend and ETL testing (SQL,PL/SQL, DB2 and Oracle)
• Good noledge of UNIX commands for troubleshooting and finding root cause analysis
• Experienced with Troubleshooting and resolving issues related to client/server applications.
• Hands on using different defect tracking tools such as HP ALM, QC, JIRA.
• Hands on writing functional test cases, creating test scenarios, executing tests scripts and analyzing test results; bug reporting and bug trucking via JIRA.
• Deep understanding of Product and Process Quality Assurance, Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC).
• Strong understanding of quality control via Verification and Validation processes to comply with specified requirements.
• Strong experience in working with but not limited to FIX, XML / FIXML messages; ability to read Tags and Tag lines for a variety of scenarios for trades execution.
• Ability to work under stress conditions, meet deadlines and manage multiple projects.
• Strong analytical skills for Business Requirements Documentation and its implementation into Agile and Waterfall methodologies.
• Performed efficient and productive cooperation with company’s stakeholders to reach goals and standards of high quality product required by end users’ expectations.
• Improved teh documentation of QA testing practices to enhance their repeatability, saving time and money and encouraging testing standardization and best practices.

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr QA Analyst

Responsibilities:

• Analyzed systems requirements and developed test plans to outline teh scope, analysis, approach, resources, schedule of testing as well as writing test cases, test execution and test completion report;
• As member of External Reporting team validated solutions for data acquisition as well as database loads and extracts.
• Verified multiple tables using MS Excel advanced functions like V-lookup, Pivot tables etc
• Validated end to end ETL process results which fetched teh data from front office DB systems to teh target CERS Data warehouse using complex SQL queries.
• Tested teh ETL with Front office feed as source and tables in teh data warehouse as target.
• Tested teh ETL process for feeds received from counterparties' back office and compared with teh data that was received from Front office for consistency.
• Validated generated external report forms and content by comparing database data and report outputs using complex SQL queries.
• Extensively used SQL statements to query teh MS SQL Server for data validation/integrity;
• Involved in entire Software Testing Life Cycle (STLC) starting from requirement gathering till release phases.
• Involved in Reviewing with other development teams, subject matter experts and infrastructure teams as needed to discuss and collect business requirements.
• Created Test Plans and Test Cases by analyzing teh Business requirements and System Requirements for teh various functional modules in teh application.
• PerformedBackend, Functional, GUI, RegressionandSmoketests on teh new enhancements added to teh web application inUAT and Production environment.
• Used HP ALM for organizing Requirements, store teh Test Cases and executing teh test cases and logging/tracking Defects.
• Interacted with developers to resolve software related defects issues.
• Performed research, troubleshoot or escalate production batch issues in timely manner.
• Performed System and Regression testing by executing test scripts in system testing and UAT
• PerformedBackend testingusingSQL queriesto retrieve teh data from teh databases and validate teh results if teh process had generated expected results.
• Prepared Requirement Traceability Matrix to establish coverage of requirements by test cases.
• Participated in defect report meetings and Application Walk Through.
• Involved in Daily and Weekly Status reports updates to teh Team.
• Tracked defects to closure by coordinating with teh developer team;
• Tested source data for data completeness, data correctness and data integrity;

Environment components: HP ALM, JIRA, Oracle, MS Office, Web Services, UNIX, SIT/UAT, Agile.

Confidential, NC

QA Analyst

Responsibilities:

• Analyzed teh existing business process flows for Fixed Income and Derivative products to gain understanding of teh existing system and documented QA activities for teh proposed system.
• Analyzed teh Market Data and teh bottlenecks of various upstream applications in getting teh various market data such as ‘Positions’, ‘Journals’, and ‘Prices’
• Tested all teh ETL processes results developed to fetch data from front office trading application DB systems to teh target Settlement Data warehouse using SQL queries;
• Tested teh ETL results for feeds received from counterparties back office and compared with teh data that was received from Front Office for consistency;
• Tested all teh reports generated using CSS tool by validating teh data in teh report against teh database according to teh requirement specifications using SQL;.
• Used SQL queries for extracting teh data from teh DB to validate proper data flow from teh backend to teh GUI.
• Prepared test related documents including Test Plan, Test procedures, Test Scenarios
• Tested teh ETL (Extraction, Transformation and Loading) process using MS SQL Server RDBMS tool.
• Performed manual testing for various components of teh application.
• Tested usability by ensuring that all teh elements of teh screen like form fields, button are consistent throughout teh application, and are visible within teh screen at various resolution.
• Created and Reviewed Requirements, Test Plan, Test Cases using QC/HP-ALM
• Maintained defect logging and management process using Jira.
• Created cross- device test cases that could be across multiple platforms as well as devices
• Actively participated in requirement reviews, planning, estimating, writing and executing test cases, reporting, proficient in implementing.
• QA processes/procedures and has proven expertise performing manual testing for functionality and GUI of teh application.
• Helped team in creating detailed test scripts based on Business Requirement Document
• Testing Type Involved: Device testing, User Acceptance Testing, System Integration Testing, Functional Testing, Regression Testing, Security Testing.
• Verified teh app could be installed or uninstalled across teh devices, worked closely with R&D and Client Support in software development and debugging.

Environment components: QC, SQL, Windows and MS Office, Waterfall software development methodology.

Confidential

Business Analyst

Responsibilities:

• Participated in teh identification, understanding and documentation of business requirements including teh applications capable of supporting those requirements. Collected and documented business processes as well as business rules
• Engaged client to gather software requirements/business rules, and ensured alignment with development teams
• Translated stakeholder requirements into deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Identified and reconciled errors in client data to ensure accurate business requirements.
• Drafted and maintained business requirements and aligned them with functional and technical requirements.
• Facilitated monthly meetings with clients to document requirements and explore potential solutions.
• Documentation and approval process were performed for all controlled changes and installations.

Environment components: QC, SQL, Windows and MS Office, Waterfall software development methodology

Confidential

Excel Expert

Responsibilities:

• Sorted data into Excel to facilitate management and exporting
• Analyzed Big Data using Pivot Tables, VLOOKUP, Index/Match and advance Excel formulas
• Cleaned old commercial banks data and uploaded required data into bank systems.
• Prepared source data for computer entry; compiled, sorted, and prioritized data.
• Compared data with source documents and re-entered data in verification format to detect errors.
• Documentation and approval process were performed for all controlled changes and installations

TECHNICAL SKILLS

Tools/Web tools: HP ALM, JIRA, QC, MS Access; C#.Net, ASP.Net, VB.Net

Testing methodologies: Waterfall, Agile SDLC

Programming languages: Java, VB scripting

Operating systems: RDBMS:

Windows, Unix/ Linux: MS SQL, Oracle, MS Access