QA Analyst/ Database Tester Resume

OBJECTIVE

Software Quality Assurance Tester/ Data Analyst in backend of various financial applications.

SUMMARY

More TEMPthan 6 years of experience as a QA/SQL Analyst.
Experienced in Agile and Waterfall methodologies.
Experienced in implementation of teh Software Development Life Cycle. Worked with software development management tools such as HP ALM and JIRA.
Extensive experience in working on various test strategies and preparing test plans, test cases, test summaries and analyzing test results.
Experience in creating test scenarios for Functional, Regression, Integration, System testing and User Acceptance testing.
Experienced in Data Validation testing, End - to-End, Back-End testing.
Strong skills in SQL, experienced in various RDBMS.
Experienced in Back-end and ETL testing using various DML and DDL statements.
Good knowledge of UNIX commands for troubleshooting and root cause analysis.
Good knowledge in fixed income pricing, trading and extensive experience supporting. Trading System including Front Office, Middle Office and Back Office systems.

TECHNICAL SKILLS

Operating System: Windows XP, MS-DOS, UNIX, LINUX, OS/2

Programming: Java SE, JavaScript, SQL

RDBMS: MS-SQL Server, Oracle, MS Access, SQL Server, My SQL

Testing Tools: HP ALM, Quality Center, Jira, Bug Tracker

Web Technologies: HTML/DHTML, XML, Java Script, CSS

Microsoft Tools: MS Office Package (Word, Excel, Visio, Power Point), Outlook.

Other Tools: SSIS, Ab Initio ETL Software, Informatica Power Center.

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst/ Database Tester

Responsibilities:

Worked with Business Analyst, Development Team to understand teh source to target mapping document and accordingly helped them to clean teh source data to decrease teh defects and to ensure dat final data matches with teh data warehouse standards.
Participated in UAT testing along with Business representatives (Middle Office and Back Office team members).
Was involved in GUI part of application, 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 teh target data warehouse using complex SQL queries.
I used UNIX Putty to check log files to verify teh process is working as expected. Performed dependency and condition validation of AutoSys jobs.
Provided support to Offshore QA team by giving them necessary information transfer and helping them with closure of teh defects.

Confidential

QA 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.

Confidential

Database Tester/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