SUMMARY:

• Quality Analyst with 8+ years of experience in Software systems analysis, development and Quality assurance especially in client/server and web based applications for Various Clients.
• Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD - 9, ICD 10 coding and HL7.Strong ability to understand Business and user Requirement.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Strong Testing Experience in Functional Testing, Performance Testing, Integration Testing, Regression Testing, GUI Testing, Database Testing and Compatibility Testing as well as cross browser testing.
• Experienced in Writing and developing Test plans, Test cases, Test case design, Test Reports for the specific business requirements and documentation of both Manual and automated tests.
• Excellent programming knowledge in SQL, PL/SQL, Java, EJB, VBScript, HTML, & UNIX
• Experience in various levels of testing: System testing, Integration testing, Regression testing and Business Acceptance (BAT).
• Expertise in working in Agile (Scrum), waterfall, Kanban methodologies. Good experience in performing User Acceptance Testing (UAT)
• Responsible for Identifying Users who will participate in testing, developed and coordinate the development of test scripts, test cases and test data. Gathering test result and provide testing feedback to the project manager.
• Experience with supply chain management system.
• Extensive understanding of SDLC and STLC.
• Experience in testing XML files and validating the data loaded to staging tables for Service Oriented Architecture (SOA).
• Experienced enough with MS Project and MS Office.
• Extensively worked on database testing (Oracle, Teradata, Hadoop, MongoDB, SQL Server, Essbase) and validating the application against the database
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Sound Knowledge in RDBMS i.e. Oracle, Teradata, MongoDB, Sybase, Nettezza, Bigdata Hadoop, SQL Server, DB2, and Backend Testing using PL/SQL Scripting and Infomatica workflows.
• Good experience in defect tracking and reporting using Test Director/Quality Center.
• Experience in using Clear Quest for tracking and reporting defects.
• Extensive Experience with mercury Interactive (HP) Tools (Quick Test Pro) using Black Box Testing.
• Involved in Back End testing (Data Validation Testing) by writing SQL queries.
• Executing, Maintaining Test Scripts and Updating as and when the business rules change.

PROFESSIONAL EXPERIENCE:

Confidential, Newjersey, NJ

Sr. QA Tester/ SQL Tester/ EDI Tester

Responsibilities:

• Participated in writing Test Plan, Test Strategy and Test cases, software documentation from business, technical and functional requirement.
• Created and documented the Test Scenarios for each functional area mentioned in Test Plans to develop the test scripts (automated Scripts).
• Used HP Application Lifecycle Management to plan tests, manage test assets, create and run manual test.
• Verifying Production bugs and monitoring the logs.
• Tested MDM platform roadmaps for current vs. future state. Tested MDM platform growth towards maturity models
• Worked with DataStage Director to do job inventory and view job status. Developed test data depends on the Test Scenarios as per the functionality of the application.
• Performed Sanity testing, GUI and Functional testing, Post Production validation as per task packets.
• Back end testing of the application using SQL queries for the Content Testing.
• Performed data accuracy, data validation, and data integrity testing by querying the database using SQL Queries to check the data table on the Server.
• Manually performed User Acceptance Testing of FACETS implementation.
• Set claim processing data for different Facets Module
• Monitored EDI Eligibility/Inquiry/Response (270/271) transactions via reports generated by the developers.
• Hands-on exp with EDI transaction code and conversion of ICD code transaction from ICD 9 to ICD 10
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.
• Did end to end testing for SOA but delayed for system unavailability. Tested both multi-protocol and multi-party processes
• Updated the test cases using TFS which acted as repository. Reported the bugs through email notifications to developers using TFS
• Used DataStage Director to verify jobs are running in GRID environment. Figuring out various error handling strategies to be adopted during cross system data migration
• Used Control-M for job scheduling.
• Experience with DataStage Designer to view jobs sources, transformations and target database and the scripts.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Did end to end testing for SOA but delayed for system unavailability.
• Wrote and ran UNIX Scripts for batch jobs. Involved in Unit, System, Integration, Regression, Load and UAT Test phases.
• Extensively used Control - M to schedule the jobs and run the scheduled jobs at specific time. Worked with Aginity Netezza Workbench tool to test and debug SQL queries.
• Executed test cases for web-based MicroStrategy reporting application.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Developed the scripts using Descriptive programming for critical functionality by using Quick Test Pro (QTP).
• Coordinating with offshore team and tracking and assigning the bug.
• Bugs reporting, reviewing and Defect Tracking using Quality Center and Jira.
• Tested SOA application interface and communication paths.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers (IE, Netscape, Firefox) using Quick Test Pro (QTP).

Environment: DataStage, HP Quality Center/ ALM, Application Lifecycle Management, Jira, Aginity Netezza Workbench, SQL, Quick Test Pro (QTP), SOAP, SOAP UI, SOA, IBM Rational Clear Case, MicroStrategy Rational Clear Quest, Axe, Agile, Teradata, XML, UNIX, MS-EXCEL, MS Visio, MDM, MTM, TFS, Facets, EDI, HIPPA

Confidential, Charlotte, NC

Sr. QA Tester/ ETL Tester/ EDI Tester

Responsibilities:

• Reviewed and analyzed Business Requirements and clarified with Business Analyst. Written several UNIX scripts for invoking data reconciliation.
• Reviewed High Level and Low level Design docs and clarified design solutions with Developers.
• Testing of complicated graphs with various Ab Initio components such as Join, Rollup, Filter by Expression, Round Robin, Merge, Dedup sorted, Scan and Validate Business requirements.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing. Worked with business team to test the reports developed in Cognos.
• Tested a number of complex ETL Ab Initio graphs, for initial and daily data loads. Extensively executed SQL queries in order to view successful transactions of data.
• TOAD is used to perform manual test in regular basis.
• Worked on EDI (Electronic data interchange) transactions: 270, 271, 834, 820, 835, and 837 to identify key data set elements for designated record set.
• Written several complex SQL queries for validating Cognos Reports.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Tested the claims processing with EDI transactions (270, 271, 835, 837) in HIPPA and HL7 Environment.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Expert in writing Complex SQL/PLSQL Scripts in querying SQL Server, Teradata and Oracle. Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested a number of complex ETL Ab Initio graphs, for initial and daily data loads. Responsible for different Data mapping activities from Source systems to Teradata.
• Involved in all walk throws for test designs, data designs and code reviews. Developed Test Plan, Test cases & Test Scenarios for new features.
• Extensively used Teradata load utilities Fast load, Multiload and Fast Export to extract, transform and load the Teradata data warehouse.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports. Updated existing Regression Test cases for impacted features due to new features.
• Tested the Application in UNIX Environment and collecting the Test data from the Business Team. Identified the Test Environment for Database Testing.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log. Queried Teradata Database and validated the data using SQL Assistant.
• Used T-SQL for Querying the SQL Server database for data validation. Writing the test scripts for manual testing.
• Preparation of various test documents for ETL process in Quality Center. Understand the database development for this project.
• Reviewing the database Test cases and performs the Database Testing when writing the SQL queries. Executed the Stored procedure when passing the valid/Invalid Parameters.
• Involved in Data migration and Data distribution testing. Tested the Dashboard reports using Cognos Report Studio and Metric Studio. Execute the database Test cases according to release.

Environment: Ab Initio (GDE 1.14.38 & GDE 1.16.1), Cognos, HIPAA, FACETS, ALM/HP Quality Center 11, Teradata 13.0, PVCS, SQL, PL/SQL, Oracle 11i, TOAD, XML, XSD, PERL 5.12.1, XML Spy 2008, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1.

Confidential, Chicago, IL

QA Tester/ Heathcare Tester

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction
• Extensively used Ab Initio GDE for mocking data using continuous flow graphs.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Used Tivoli to schedule and run Ab Initio Jobs and Unix to monitor ETL execution and logs. Worked with business team to test the reports developed in Cognos.
• Experiences working in ANSI x12 837-835 EDI Transaction.
• Involved in writing and executing the test cases and involved in Defect reporting and verification. Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements. Testing the data present in fact tables and dimensions tables.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Testing of Ab Initio graphs and Autosys scripts for job scheduling, executing the test cases, raising the bugs in QC and closing them for all the modules
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Tested data warehouse ETL process using SSIS (Integration Service)
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool.
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in Defect prevention, productivity improvement and knowledge management activities

Environment: Ab initio 2.14 GDE, Cognos, HIPAA, EDI, HP ALM/ Quality Center 9.0, Teradata V2R6, Oracle 10g, SQL, PL/SQL, SQL Server 2008/2005, SQL Navigator 5.0, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential, NJ

QA Tester/ Manual Tester

Responsibilities:

• Reviewed Client Requirements, Use Cases, and High Level and Low level Design documents for the changes in each release.
• Reviewed Mock Ups, Technical specifications, and Data design documents for data changes.
• Developed Test Plans, and Test cases based on requirements, and technical and design specifications
• Wrote and ran UNIX Scripts for batch jobs.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Developed Test data requirements and data dependencies, and conditions for all test cases. Performed Functional, Integration, and Regression testing
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS'. Identified Test scenarios for Automation for critical functionality.
• Developed Automation test scripts, and run the scripts as part of regression testing.
• Quality Center used for Test Cases development and test execution status tracking. Testing the data present in fact tables and dimensions tables.
• Performed Data Validation, Data Conversion and Data Reconciliation Testing.
• Performed HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings.
• Represented in Project and Defects scrub meetings, and provide status on assigned tasks. Testing status reported to QA Manager and project manager.
• Involved in production data validations for each change in all releases

Environment: Quality Center, UNIX SQL Navigator, Oracle Web Cache server, Oracle Application Server, Oracle 10g, SQL, PL/SQL, Oracle Reports Generator, PL/SQL, XML, Teradata V2R5, Quality Center, Windows XP

Confidential, NY, NY

Manual Tester

Responsibilities:

• Reviewed the Test Plans and written Test Cases based on Functional Requirements.
• Generated the Test Cases and executed them for Testing the Application Manually to get them reviewed by the Quality Managers.
• Created the Requirement Traceability Matrix (RTM) based on customer Specifications.
• Performed Back-End Database Testing by writing and executing SQL Queries on Relational Databases in SQL Toad in order to ensure the Data Consistency on Front-End.
• Used Test Director as a Test Management (Analysis, Reports & Defect Tracking) Tool.
• Used Quality Center for defect tracking and reports generation.
• Defined the Defect Tracking Schema and Collected Data for Collection Defect Metrics like Defect Density, Defect Age, Effort Variance and Schedule Variance.
• Summarized Detail Test Reports with Defect Logs and submitted them to Developers through proper Channels.
• Developed & executed Test Cases for testing the application manually.

Environment: Manual Testing, Windows XP, Windows 2003, Mercury Test Director 7.0, IIS Web Servers, Microsoft Product Studio, Visual Source Safe.