SUMMARY:

• Over Twelve years of experience as a Quality Assurance Engineer in Client Server and Web based Applications. Heavily involved in data related applications (Oracle, PL/SQL and SQL Server) as well as strong ability to write SQL (from basic to complex query joins) to complete test efforts.
• Involved in writing and executing test plans, test cases, automation strategy and design.
• Performing all types of testing (functional, acceptance, ETE, Integration, backend, load, stress and performance testing).
• Involved in Analysis and System testing of Object Oriented Applications for Internet/Intranet and Client/Server applications using Oracle (PL/SQL), JAVA (JDK 1.x, Applets, JSP, and JDBC), J2EE and Angular.
• Worked in AGILE environments in his last 3 previous positions. Strong problem solving skills, extremely reliable, quick learner and able to work independently as well as team member.
• Complete understanding of Software Development Life Cycle
• Experience in Writing Stored Procedures and Triggers using SQL for Business applications to validate data.
• Extensive working knowledge in UNIX and Windows platforms
• Analysis and Review of Business Requirements/Use Case Documents.
• Developing Test Plans and Test Cases based on the requirements.
• Involved in UNIX shell scripting and conversion of windows scripts to shell scripts.
• Design, Implementation of Test plans (System, Integration and User Acceptance) and Test Cases for Black Box Testing.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, Abinitio and Autosys tools.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.
• Expertise in performing different types of Testing: Manual testing, Regression Testing, Functional Testing, Data driven Testing, GUI Testing, Black Box Testing, White Box Testing, Stress/Load Testing, and System Integration testing expertise.
• Knowledge in VAN, AS2, HTTP, HTTPS and FTP EDI Communications.
• Extensive working knowledge in UNIX and Windows platforms.
• Used defect - tracking tools like Test Director, Clear quest and PVCS tracker. Also used for collecting test metrics, reporting the modification requests and tracking them to completion.

TECHNICAL SKILLS:

Automation Tools: QTP/UFT, WinRunner, LoadRunner, Rational Team Test, Silk Test, Quality Center

Languages: COBOL, UNIX, SQL, PL/SQL, SQA Basic, JAVA, C/C++, Objective C and TSL.

Database: DB2, Oracle 10g, SQL Server, Informix and MS Access, IMS/DB.

Web: HTML, ASP, JSP, Servlets, EJB, Cold fusion, XML, VB Script and Java script.

Reporting tools: SQR, Abnitio, Data Stage, ETL, n-Vision and Crystal Reports.

Operating system: MVS, AS/400, Tandem, Windows 95/98/2000/NT and UNIX.

EDI Tools: EDISIM 4.0, FECILIDI, CLARIDI

PROFESSIONAL EXPERIENCE:

Confidential, Englewood, CO

Responsibilities:

• Performed ETL testing on the Node Splits,NOS,CMTS,CRAN,VOD,Equipment usage reports(Total 105 reports in ECAF)
• Worked with the end users in gathering the requirements and drafting them to the development team
• Performed integration testing of ECAF with respective of other syb-systems.
• Involved in preparing the testdata form the source and applied calculations and compared the target data
• Logged a total of 500 bugs and handled all the defect management in ECAF
• Mentored the new QA resources on testing the ECAF and Polaris applications
• Involved in preparing the release notes and sending them to the end users on Release basis
• Tested the application performance using JMETER
• Designed all the manual testcases from the start of the project and identified the regression suite
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Written SQL Stored Procedures and Queries for Back end testing
• Participated from Business requirements reviews,Data Design and all phases in an Agile environment
• Worked in analyzing the data issues with the development team and gave them inputs

Environment: Java,Angular JS,Unix,My SQL,PostGres,Oracle,SOAP UI,JIRA,Rally

Confidential, Englewood, CO

QA Automation Engineer

Responsibilities:

• Designing of Hybrid automation framework using UFT 11.53 Tool and development of Automation Test Scripts using UFT 11.53.
• Documented Defects found during test on the Microsoft Team Foundation Server (TFS) and communicated recorded problems to the responsible development personnel.
• Developed & Implemented effective Test Plan and Test cases based on the user stories (Functional requirements), source to target mapping documents, analyses and technical specification.
• Performed Data Driven Testing with UFT to test the application for different sets of data.
• Tested Webservices, Validated Request and Response XML, SOAP Calls, RESTful calls and WSDL using SOAPUI tool.
• Extensively used ADO objects to connect and retrieve the data from database.
• Mobile Automation - Used add-ons "MobileLabs" and "SeeTest" for mobile application cross platform testing like Android, iOS and Windows platforms on the actual devices connected under secured cloud
• Batch Schedulers - Experience in using "Windows Scheduler" \ "Quality Center" for scheduling automation suite execution overnight and trigger automated status email report after completion.
• Experience with Requirement analysis, developing the RTM (Requirement traceability Matrix), Test plans, Test cases (manual and automated) and Performance Test specifications
• Provided application support for Performance, Volume, Failover, Recovery, and Operability Testing
• Developed Xpath and HTML DOM based object identification function for framework.
• Managing and Analyzing and prioritizing defect lists and defect resolution. Monitoring progress based upon schedules and requirements.

Environment: UFT11.53, ALM, SQL Server, Oracle, ASP.NET, WCF

Confidential, Denver, CO

QA Automation Engineer

Responsibilities:

• Developing set of automated test scripts for various applications within the organization using HP's QuickTest Professional 10/11; Automated scripts include Flex, Web, Siebel, XML, Web Services and Dojo
• Tested the Objective C (iPhone/iPad), IOS SDK 5, IOS SDK 6, IOS SDK 7, IOS SDK 7.1
• Automated the IOS Adapter Views like list view, Grid view and Gallery
• Writing automated scripts for end to end integration including XML creation and encryption, submission of messages through ActiveMQ, verification of the message in source and target databases and verification of the data on the front end
• Participating in extending, maintaining, and implementing global keyword driven framework; Framework creates descriptive programming strings at run time allowing framework to be reusable across all Web applications;
• Building project specific function libraries used in combination with the global framework; libraries include high levels of error handling and built-in dependencies eliminating run-time errors and providing clear and concise failure and error reporting
• Assisted manual test team with regression testing by executing automation regression suite in HP Quality Center 11.0 and reporting and researching issues; combined testing effort significantly reduced overall regression time, increased the scope of test coverage and identified a greater number of defects compared to manual testing alone
• Created and documented a data driven automation framework to be implemented for other applications within Corporate Investments for the transition of the automation role to manual team Writing automated scripts for end to end integration including XML creation and encryption, submission of messages through ActiveMQ, verification of the message in source and target databases and verification of the data on the front end
• Provided support for regression test bed including XML and Terminal Entry applications
• Involved in Mobile testing on various platforms like iOS, Android, Blackberry and windows phone with the HP Plug-in experitest.

Environment: QTP/UFT, ALM, IOS 6.0.x/6.1.x/6.0.x, Objective C, SQLServer, ASP.NET

Confidential, Scottsdale, AZ

QA Engineer

Responsibilities:

• Developed SQL Stored Procedures and Queries for Back end testing
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested the UNIX shell scripts that were converted from Windows scripts.
• Tested different detail, summary reports and on demand reports.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Managed corporate metadata repository to align data and systems with organizations
• Involved in Programming with VBScript to write reusable functions, and Setting up the startup files for the loading the libraries and configuration in QTP.
• Involved in testing the Webservices using WCF
• Involved in converting manual test cases into automated scripts on HP Quick Test Pro (QTP).
• Involved in Creating, executing, coding and enhancing the VB scripts using QTP for each individual functionality & Regression testing of the application.
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005
• Compared and Tested Source data with XML Output flow.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experience in Testing Business Objects Reports.
• Reported bugs and tracked defects using Quality Center 9.0 (Test Director)

Environment: QTP, SQL Server 2000/2008, ETL Informatica 7.1, SSIS, Oracle 9i/10g, XML, Perl Scripts and Korn Scripts, Flat Files, Cognos 7.3 Series, T-SQL, MS Excel, UNIX, Korn Shell Scripting, Erwin 4.3, Windows, Quality Center 8.2 and Test Director 8.0, Business Objects.

Confidential, Tucson, AZ

QA Engineer

Responsibilities:

• Tested the application by Rational Functional tester (RFT) using JAVA scripting and .NET scripting: Recording scripts, playing back, verification point comparator, extending scripts, using test object maps, managing object reorganization, data driven tests Owning the QC / QA activities and sign-off the product releases
• Created System Integration, System and Performance / Load Test scenarios
• Managed the overall process of automated test scenario creation and execution using Mercury QTP
• Involved in testing the Webservices methods using SOAP UI tool
• Designed and developed Automation architecture document, Master and detail Automation test Plan and Test Cases using Mercury Quick Test Pro (QTP)
• Extensively involved in doing system integration testing using QTP
• Extensively used the File-Aid, TSO/ISPF, QMF and DB2 for validating the data.
• Written multiple Test Cases (Unit, System, and Integration) for multiple transactions include 835I, 835P, (both inbound and outbound) transactions (5010 Transaction set).
• Tested the HIPPA EDI Transactions 835I, 835P, 270.
• Used Test Management with Rational Test Manager for managing Test planning and designing, developing and executing manual tests and suites, preparing for automated testing, Determining and reporting test results.
• Tested the mapping specification guidelines on Webmethods for the exchange of files
• Tested the trading partner file formats in Webmethods.
• Written multiple Test Cases (Unit, System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions
• Used Foresight Desktop Validator for HIPAA IG validation.
• Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Quick Test Pro was used for Data Table Integration.
• Extensive knowledge of Histology Workflow process, HIPAA Standards and Agile Techniques
• Configured the Test environments by selecting the test data criteria needed and then loaded them.
• Involved in setting up the Batch jobs on a daily and weekly basis for periodic updating of data.

Environment: DB2, JCL, QTP, Webmethods, HP Quality Center, CICS, Rational Functional tester, HTML, TSO, File aid, In sync, Windows NT/2000//2003/XP.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Worked with the components of Data Warehousing like components model, ETL tools.
• Responsibilities include creating Use Cases, Test Plans, Test Cases, Test Scripts and Test Data.
• Involved in converting manual test cases into automated scripts on Mercury Quick Test Pro (QTP).
• Developed and executed various Visual Basic scripts using QTP for automated testing of each individual functionality & Regression Testing of the applications.
• Generated the test scripts for Functional, Data driven and Regression testing using the automated testing tools QTP.
• Tested the DOS scripts conversion to Shell scripts
• Tested extensive UI work, including making and breaking associations. Backend was in Oracle and Oracle adapter ruby adapter was used
• Enhanced Ruby on Rails, Capistrano application performing one-click installs to test environments
• Wrote a number of control files to load data in to Oracle tables using SQL* Loader
• Process batch jobs VIA IBM/UNIX/ Tandem computer systems
• Analyzed current procedures, recommended and implemented improvements as needed
• Monitored daily activities and troubleshooting
• Performed programming debug, unit and integration testing
• Worked with clients and the development team throughout the project life cycle and confirmed all documents
• Converted the DOS batch jobs to Shell scripts and involved in unit testing the converted scripts.
• Involved in creating Materialized views for complex combinations
• Involved in preparing the data to meet the testing requirements.
• Queried against the database to retrieve records based on medium size to large scale SQL queries for the Oracle database.
• Assisted Load testing team by giving them overview of the flow of the project and in performance testing.
• Coordinated with the BA’s to identify gap-analysis and write Business cycle test cases (BCT).
• Involved in review meetings, status reporting, resolving issues and providing feedback for System Requirement specifications, High level and Low-level documents before the documents was base lined.
• Involved in executing the test case, created and validated defects and reported defects to developers.

Environment: Informatica, QTP, Oracle, UNIX, Tandem, DB2, File-Aid, QMF, Quality Center, Webmethods

Confidential, Waltham, MA

QA Engineer

Responsibilities:

• Enroll accurate and reliable 835 enrollments in Production environment and verify the information on DB2 tables.
• Involved in running the UNIX batch jobs.
• Performed Database testing for the Web feeds from SQL Server database to Oracle database
• Involved in peer-reviews, defect resolving meetings, test cases review by BA’s.
• Involved in Web testing, functional, browser compatibility testing of the Multiplan website for provider search application
• Involved in testing HIPAA EDI Transactions and mainly focused on 835/837, 270/ 271 and 27 6/277 Transactions
• Responsible for monitoring the processing the claim input and response files, query input and response files which are transmitted using the ANSI X12/270/271 Entitlement query transaction set (version 4010AI)
• Tested the Healthcare claims and monitored the HL7 transactions between Mainframe and Tandem systems.
• Identified missing/duplicate transmissions-such as claims, acknowledgements, and Daily acceptances reports and confirm daily 835 outbound files transmitted.
• Analyzed the requirements and prepared test cases from scratch in Quality center.
• Actively involved in tracking the defects and prioritizing them based on the severity
• Responsible for updating and maintaining the Quality center for all the defects found during functional and regression testing.

Environment: Mainframe IBM, JCL, Tandem, UNIX, Java, Quality Center

Confidential, Des Moines, IA

QA Analyst

Responsibilities:

• Involved in loading the inbound XML files from hospitals to into the internal DB2 systems.
• Coordinated with the different trading partners and off-shore project team
• Provided test data to the development and testing team
• Coordinated with the SME’s, DBA’s, testing teams in sampling analysis.
• Performed the validation of the XML files.
• Tested Database integrity testing by executing SQL statements on DB2 database.
• Interacted with the dba’s in loading the test data in different regions.
• Analyzed the types of data and the quantity to be loaded.
• Used the db2 tools like file-aid and spufi for executing the queries.
• Involved in monitoring and updating the batch processing jobs

Environment: Oracle 9i, PL/SQL, SQL query browser, DB2, JCL,TSO, ISPF, XML, VB.NET, Win Runner, Webmethods 6.5, HTML

Confidential, Round Rock, TX

QA Engineer

Responsibilities:

• Analyzed the requirements and prepared test cases from scratch in Quality center.
• Actively involved in tracking the defects and prioritizing them based on the severity
• Engaged with the trading partner for implementation requirements and testing
• Developed EDI maps for X12 transactions and A2A mapping, upgraded the maps to version 4010 using Gentran
• Involved in uploading and testing the file feeds an resending the processed ones to the trading partner
• Perform all types of testing for a B2B data quality
• Manage defect reports and logged the test cases via Quality Center
• Involved in using the B2B Tools, WEBMETHODS, B2B Mapping services
• Performed unit/system testing on all EDI transactions for both inbound and outbound translations (850,810,996, XCBL, CXML)
• Involved in creating the TN Profiles, TN Processing rules, exporting profiles and importing profiles in Webmethods 4.6/6.5.
• Performed Backend testing extensively using SQL queries to verify the integrity of the Database

Environment: Java,FTP,VB.NET, ASP.NETWebmethods4.6/6.5, WebSphere MQ, QTP, Quality Center, B2B tools, DB2, JCL, ISPF, Oracle 10g, XML/XSLT/XSD

Confidential, Tempe, AZ

Data Analyst

Responsibilities:

• Tested Database integrity testing by executing SQL statements on Oracle database.
• Developed and modified JCL’s for the production jobs.
• Involved in Data Mining and providing data to testing and development.
• Interaction with File-Aid, Spufi, QMF in executing the queries
• Created the RDX file to load the testing region with test data
• Created and modified data as per the selection criteria.
• Used scheduler for the automatic submission of production jobs according to predetermined criteria
• Created and executed the test cases as per the requirements for front-end and back-end.
• Responsible for updating and maintaining the Test Director for all the defects found during functional and regression testing.
• Logged the test cases and defects in the in-house built repository.

Environment: MVS, JCL, DB2, TSO, CICS, IMS/DB, ZEKE Scheduler, Platinum, File-Aid, ISPF, SQL, QMF, SPUFI, CA-VIEW

Confidential, Bannockburn, IL

QA Engineer

Responsibilities:

• Checked the validity of data in the backend DB2 and UDB tables.
• Involved in validating and testing the clinical trial files and dumping them into the application.
• Validated whether the inbound trial files are dumped into the respective applications.
• Involved in client negotiations in gathering the claims and setting up the environment internally.
• Interaction with TSO, JCL as interfaces to MVS
• Tested .ASPX Forms and User Controls using C#.NET.
• Validated the inbound and outbound EDI transactions.
• Involved in adjudicating the medical and pharmacy claims.
• Developed Test plan and modified the test plan when required in later stages of testing
• Defects were created, tracked, reviewed, analyzed, stored test data and compared using Test Director 8.0
• Involved in validating Main Frame interfaces for business applications.
• Involved with the business integrators in gathering the requirements.
• Involved in setting up the data for the Integrator testing and validating the data setup and claims before they are sent out.
• Actively involved in tracking defects.
• Processed the claims and validated the Mid-tier region.

Environment: Java, MVS, JCL, DB2, TSO, IMS/DB, Platinum, File-Aid, ISPF, SQL, WinRunner, Test Director 8.0, MS Visio, Netscape Navigator 4.x, IE 5.x, VB.NET, ASP.NET, Oracle 10g