PROFESSIONAL SUMMARY:

• Around 17 years of experience in the Information Technology in Quality Assurance Testing of ETL, Salesforce, BIG Data, Mainframe and Java environments with Development background
• Well experienced in Software Development Life Cycle, Onshore offshore coordination, Team Leadership, Project management, Coordination, Requirement Gathering analysis of the projects
• Well experienced in Test Plans, Test Cases, Test Schedule, Metrics Reporting, Test Strategy, Test Planning, Traceability Matrix, Test Design, Test Execution,Test Deliveribles
• Very well experienced in Technical Testing,Block box Testing, Integration Testing, Functional testing, User - Acceptance Testing, Unit testing, White Box testing, End to End testing, Backend Testing, Manual Testing,SIT
• Experienced in working with the Rational Quality Manager(RQM),Rational Rec Pro,Mercury Quality center Tool,Test Director,Load Runner,Winrunner,Track+,Quick Test Pro(QTP), Application Life cycle management11 QC tool,TFS,KISAM Defect Management tool.
• Expert in Manual QA testing, QA Batch Testing and Online QA Testing Using CICS, IMS
• Extensive knowledge in Databases which includes Oracle, DB2, SQL Server,IMS and MS Access and Very Strong in RDBMS Concepts, SQL, PL/SQL.
• Expertise in Test life cycle, Problem solving and Defect management using Bug Tracking Tools.
• Very well experienced in all the SDLC (waterfall, agile) phases in most projects, Estimation of project, Requirement gathering, Analysis, Project planning, Resource planning, Work allocation with exceptional abilities in Development, Testing, Implementation, Training, Documentation, Production support, QA Batch Support.
• Well Experienced in Confidential mainframe and Web computer systems using COBOL, DB2, JCL, CICS, IMS DB, VSAM, TSO/ISPF, MVS, SQL, Java, Salesforce, .Net, Unix, J2EE, XML, HTML, Informatica ETL, Oracle, Bigdata, Greenplum, XML Spy, BOE
• Tools worked on includes DB2 Platinum Products, CA7, DB2-File Aid, IMS-File Aid, QMF, SPUFI, SYNCSORT, IDCAMS, FILE AID, Xpediter, Pan valet, Connect Direct, DB2 Connect, Change Man, Mercury Quality Center, PUPS, Move for DB2, BMC utilities, STE, DUG, FTP, Visio, JCL Utilities, RQM, Rational Tools, DVO

SOFTWARE/LANGUAGES/PACKAGES:

• ASP
• COBOL
• C++
• CA7
• Changeman
• CICS
• DB2
• DB2 Connect
• Data Stage
• Developer 2000
• Fault Analyzer
• Fileaid
• HTML
• VSAM
• Big Data
• Winrunner
• IMS DB/DC
• JAVA
• JCL
• Load Runner
• Lotus Notes
• MQ Series
• Oracle
• Oracle Financials
• PL/SQL
• QMF
• BMC utilities
• XML
• HP Service Desk
• XML Spy
• Salesforce
• Greenplum
• SPUFI
• Synchsort
• Batch Spufi
• SOA emulator
• SQL Server
• SAP ABAP
• Notepad++
• Test Director
• Mercury Quality Center
• TSO/ISPF
• Track+
• Toad
• Visio
• Visual Basic
• BOE
• Informatica Power Center
• MVS/ESA
• S/390
• WINDOWS-NT4.0
• WINDOWS 95/98,2000
• UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr Software QA Test Engineer-Mainframe

Responsibilities:

• Created Test Data for Confidential Project
• Performed Mainframe Testing
• Worked on Test JCL modifications
• Performed data validation from DB2
• Developed Test Cases, Test Scripts, TestSpecs for Confidential project
• Performed SQL queries on DB2 Database Testing
• Worked on defects management in ALM.

Environment: ALM-11, SQL, TSO, ISPF, DB2, COBOL, Lotus Notes

Confidential, Lanham, Maryland

Lead Software ETL Test Engineer

Responsibilities:

• Created Synthetic Data for Confidential SAT and RRP FATCA
• Performed ETL DVO Table pair execution and Executed workflows in workflow manager.
• Used Control-M for running jobs
• Performed Datawarehouse testing on Confidential project
• Performed data validation from DB2, Oracle source data to Green Plum Target data.
• Developed Test Cases, Test Scripts and TER’s in Rational Quality Manager for Confidential CADE2 and RRP projects
• Performed SQL queries on DB2 Connect and PG Admin III query tool for Green Plum Database Testing
• Worked on defects management in KISAM.
• Performed ETL Testing using Informatica workflows for RRP and Confidential
• Worked on BIGDATA Data Validation Testing using Green Plum for RRP and Confidential Projects
• Performed BOE (Business Objects Enterprise) reports QA Testing for Confidential and RRP projects

Environment: ETL Informatica Power Center, Green Plum, RQM, SQL, Postgre SQL, XML SPY, DVO, Secure FX, Secure CRT, TSO, ISPF DB2, COBOL, ORACLE, DB2 Connect, Business Objects Enterprise(BOE)

Confidential, Fairfax, VA

Lead Software Quality Assurance Engineer

Responsibilities:

• Developed Test Plan and Test Cases for SIM to OIM migration requirements.
• Lead the Oracle application testing activities for IDM 11G and Test Architecture for SIM to OIM migration
• Supported junior team members and interfaced with external application members to resolve specific discrepancies encountered during the testing and validation process
• Performed Salesforce implementation Testing for IDM Applications
• Worked on SQL queries on DB Visualizer for back-end testing on Oracle for conversions to verify the test data
• Developed and executed positive and negative QA test cases

Environment: OIM,SIM,SQL,DB Visualizer, salesforce, IDM, Java,.Net

Confidential, Chantilly, VA

Sr Software QA Test Engineer

Responsibilities:

• Worked on Cognos calculation Test Execution in QC for Confidential Project
• Performed data validation from source data to Target data for Confidential project
• Reviewing and developing the Test Case design of Confidential Project
• Scheduling the TCM Reviews, Meetings, Peer Reviews in the Team
• Worked on Defects management tasks Defect status, Open defects, Close Defects, Reopen Defects
• Reviewing Design documents, Requirements, TCM as per project needs
• Performed Salesforce CRM implementation Testing for Dealer Applications
• Worked on testing of special claim servicing facility using Salesforce application
• Extensively worked on SFDC UI validation testing
• Developed and Reviewed the Test case designs for EDI Billing Invoice Recon project
• Lead the ORACLE application Testing activities for IDM 11 G upgrade
• Involved in Web Services Testing using SOAPUI
• Performed ETL testing for OIM applications
• Worked on ASN Rawfiles, Lawson Reports for SIT Cycles Testing on General Ledger
• Worked on Microsoft Team Foundation Server Test management tool
• Extensively worked on GL Reports, Lawson Reports, AP reports Testing
• Worked on Test Planning, Test Management in Quality Control
• Performed the testing of JAVA based OIM upgrade application
• Validated the Data on Mainframes using QMF and SPUFI for DB2 DB
• Managing the Team by assigning the tasks, getting status, Reviewing the TC, TCM’s, TP
• Performed QA Manager roles, Lead roles and Test Engineer roles as per need
• Execute the SQL queries using DB Visualizer for data validation
• Performed Black box, System Integration Testing, Regression testing, Backend Testing

Environment: Cognos Query Studio, DB Visualizer, HP Quality Center, QMF, Spufi, Fileaid, SQL,TSO,ISPF, MS excel, MS Word, Salesforce, Lotus Notes, Oracle, TFS, XML,SOAP UI,DB2,COBOL,CICS,JAVA

Confidential, Franklin Lakes, NJ

Sr QA Test Engineer

Responsibilities:

• Involved in defining test objectives for the applications and performed Manual Testing.
• Worked on Claims process requests for pharmacy claims
• Heavily involved in claims processing testing using Mainframe tools, utilities
• Extensively worked on backend testing of Mainframe applications
• Worked on TSG Tool to process the Grids
• Involved in FTP process of mainframe files Thru TSG tool
• Process the claims testing thru submitting the jobs on CICS applications
• Worked on Agile methodology with Sprints, Scrums
• Worked on Test Planning, Test Strategy, Test management, Test Results
• Validated the Data on Mainframes using QMF and SPUFI
• Execute the SQL queries using SQL environment
• Working knowledge of HIPAA standards and practices
• Coordinated Mainframe Claims projects for schedules, requirements gatherings, timelines
• Extensively worked on SQL for back end testing on DB2
• Performed Black box, Integration, White box, Regression testing for claims applications

Environment:DB2, Cobol, QMF, JCL, Fileaid, SQL, TSO, ISPF, MS excel, MS Word, MS PowerPoint, Spufi, Confidential Utilities, BMC utilities, FTP, MS Office, VSAM, Share point

Confidential, Baltimore, MD

Sr QA Test Engineer (Mainframe, Web)

Responsibilities:

• Involved in defining test objectives for the applications and performed Manual Testing.
• Developed Test Cases, Test Results, Test Strategy
• Involved in Test Case Peer Reviews, Requirement reviews
• Extensively worked on backend testing of Mainframe, ETL applications
• Worked on Test Planning, Test Strategy, Test management, Test Results
• Validated the Data on Mainframes using QMF and SPUFI
• Execute the SQL queries using SQL environment
• Working knowledge of HIPAA standards, practices and 508 compliance testing
• Coordinated Mainframe projects for schedules, requirements gatherings, timelines
• Extensively worked on SQL for back end testing on DB2
• Worked on Requirements using DOORS tool
• Performed Black box, Integration, White box, Regression testing for MBDSS applications
• Worked on Agile methodology with Sprints, Scrums
• Scheduled meetings with Users, Business Analysts, Developers
• Worked with test JCL on mainframes for CMS application testing
• Performed Online, Batch QA Testing’s for CMS and Manual Testing

Environment: DOORS tool, DB2, Cobol, QMF, JCL, Fileaid, SQL, TSO, ISPF, MS excel, MS Word, MS PowerPoint, Spufi, Confidential Utilities, BMC utilities, FTP, MS Office, Informatica, VSAM, Share point, SQL, Share Center

Confidential, McLean, VA

Sr UAT Test Engineer

Responsibilities:

• Performed requirement validation for Freddie EDR applications
• Extensively worked on backend testing of Freddie mainframe applications
• Performed UAT testing on LMWS EDR applications
• Worked on Test Planning, Test Strategy, Test management, Test Results
• Execute the SQL queries using Gupta SQL environment
• Worked on Agile methodology with Sprints, Scrums

Environment: Application life cycle Management QC tool 11, DB2,IMS, Cobol, QMF, JCL, Fileaid, SQL,TSO,ISPF, MS excel, MS Word, MS PowerPoint,Spufi, Confidential Utilities,LotusNotes,BMC utilities, FTP, Unix, Sybase, MS Office, CICS, Visio, VSAM, Share point, Job Scheduler, Gupta SQL

Confidential, Sacramento, CA

Sr QA Test Analyst

Responsibilities:

• Involved in defining test objectives for the applications and performed Manual Testing.
• Development of Test Cases, Test Plan, Test Strategy and Traceability Matrix based on design requirements
• Performed requirement validation for DMV applications
• Extensively worked on backend testing of DMV mainframe applications
• Performed UAT testing on DMV applications
• Worked on Test Planning, Test Strategy, Test management, Test Results
• Validated the Data on Mainframes using QMF and SPUFI

Environment: Application life cycle Management QC tool 11,DB2,AMIS, Cobol, QMF, JCL, Fileaid, SQL,TSO,ISPF, MS excel, MS Word, MS PowerPoint,Spufi, Confidential Utilities,LotusNotes,BMC utilities, FTP, Test case Runner, TSO Parallel, MS Office, CICS, Visio, VSAM, Rational Requisite Pro

Confidential, Washington, DC

Sr QA Consultant

Responsibilities:

• Development of Test Cases, Test Plan, Test Strategy and Traceability Matrix based on design requirements
• Coordinated the java web-based tax forms projects and mainframe-based testing projects
• Worked on Test Planning, Resource planning, Test Strategy, Test management
• Validated the Data on Mainframes using QMF and SPUFI
• Performed UAT testing on Tax applications
• Involved in the projects of tax applications Java-based Web and Mainframe
• Coordinated Web and Mainframe projects for schedules, requirements gatherings, timelines
• Extensively tested the electronic tax payer center web application for Filing the Tax returns
• Tested and Verified the tax calculations in the ITS TAS Web based mainframe application

Environment:DB2, Cobol, QMF, JCL, Fileaid, SQL, TSO, ISPF, MS excel, MS Word, MS PowerPoint, Crystal reports, Spufi, Confidential Utilities, Track+, Toad, Lotus Notes, BMC utilities, TAS,FTP, Java, Oracle, Unix