QA Engineer, Automation QA Engineer Resume

SUMMARY

16 years’ experience as QA Tester/Lead and have functional Testing experience in financial applications. Worked in agile test environment and eager to accept challenging assignments leveraging my knowledge and expertise in Data warehouse data models, Data mart star schema, ETL mappings and web - based End to End Testing.

TECHNICAL SKILLS

Languages: People Code, SQL, PL/SQL, JCL, CGI/PERL, C, C++, Jdk1.4, And Visual Basic, Java, python, R language, Internet Technologies ASP.net, VB Script, JavaScript, JDeveloper, Java EE 7, JSP, Servlets, EJB HTML, XML,SOAP, WEB API DHTML, JMS, Web Services,

EDW/BI/ETL/EPM/ERP/CRM: Informatica Power Center and ODI, DataStage, Tera data, Oracle Hyperion EPM application Suite 11.1.2.3, OBIEE, Siebel, EIM, Oracle Financials, SWIFT, SYSTEMATCS, PeopleSoft Finance(AP,AR,GL) (v 8.8/ 7.5/7.0/6.0 ) Hyperion Planning 11.1.2.3,Oracle 11g, SQL Server, Analysis Services 2005 SSIS, Micro Strategy reports, Cognos

Cloud tools: Hadoop, Hive, SQL Analytics, Miro soft Azure

Main Frame Environment: OS 360, CICS, COBOL, FILE AID, ISPF, TSO, JCL, JMS, Quick Test PRO, AUTOSYS

UNIX Environment: HP 9000 SERVER with OS HP-UX 10.2, RHEL 7

Windows Environment: HP ALM 11.0, Quick Test Pro, Selenium, Robot Framework, JIRA, Git, GitHub Windows 2008/ 2012, Burp Suite, Wireshark .Net, HP QC addin, Confidential Work StationScripting Languages: korn shell scripting, Power Shell, MAXL,MDX

Databases: Oracle 11g, MS SQL Server 2005 and 2019, Analysis Services 2005, SSIS, Reporting Services Application servers/SSO and others Web Logic 8.x, Oracle Apps Server, RAC and RMAN, oracle identity manager, SSO

PROFESSIONAL EXPERIENCE

Confidential

QA Engineer, Automation QA Engineer

Responsibilities:

Did Business Requirements review and gap analysis
Did Requirements traceability and uploaded the Business requirements into QC.
Designed the test cases based on the BRD and DDD.
Uploaded the test cases into QC Test plan module.
Assigned the test cases to testers during SIT test execution.
Managed multiple projects and planned test cases execution in QC Test Lab.
Participated in QE review meetings to review the test cases design.
Did SIT testing covering end to end testing starting from Load files to Staging and from Staging to CCAR Applications.
Tested business rules which includes Market risk and credit risk at combined US operations level
Developed test cases to validate Stress test requirements and risk management requirements
Developed test cases to validate actual and forecast data in Balance sheet and Income statement which includes Interest income and Non-Interest income calculations
Tested KK core earnings data for entities and Total IHC consolidated.
Tested Income statement report using multiple FTP rates at county level.
Tested Income statement monthly reports include after tax Net income calculations, Operating expenses and Interests paid.
Ran complex Sql queries and validated CCAR data in EPMSTAGE.
Tested record count and field definitions between load files and EPMSTAGE tables
Validated mappings from source GL accounts to COA Accounts.
Did data type validations like Null, Not null.
Tested Target table’s structure including keys and constraints.
Developed test scripts to test business rules. Developed test scripts to recover test scenario during test execution from abnormal state to original state to continue test execution
Prepared test data required for test scenarios. Developed test cases and reused test cases using data driven from tables. Developed test scripts to handle negative test cases to check any bad or extra records. Checked data transformation rules to validate data from source files to target application.
Executed Workflow to load data into EPMSTAGE and validated data in EPMSTAGE fact Tables.
Executed Test cases and Test Scripts in QC Test Lab and entered the defects in QC defects module.
Reassigned the defects to tester after fixing by dev team. Retested test cases and updated test case status.
Involved Sign 0ff procedures for SIT testing. Prepared the test results and presented to PMO team. Complied the exit criteria and participated exit meeting. Prepared the closure report after SIT testing.

Hyperion QA test analyst

Confidential, Palo Alto, CA

Responsibilities:

Used automated test tool Silk Test 5.0 to test NMS application
Participated in Walk - Through meetings and Inspection
Prepared System Requirements and test automation design of the NMS application
Developed scripts for classes, functions and methods
Developed scripts for screen definitions, base state and application state
Set up class path, Browser extensions and options
Developed file structure for java classes, configuration, scripts, include and results
Wrote Test Plan & test cases and debugged & run successfully
Conducted Smoke/Regression/Acceptance/Soak tests
Documented Test results

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship