SUMMARY

• 8 Plus years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Extensive experience in writing Test plans, Test cases and Test Execution.
• Experience in Software Engineering, SDLC & Testing Methodologies.
• Solid experience in Black box testing techniques, which includes, Unit, Integration, Functional, System, Regression Testing.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and Data stage
• Tested Abintio, Informatica, Data Stage Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc
• Expert in writing SQL for validating complex business rules based on ETL mapping document.
• Good Experience in QA Methodology and Validations to ensure industry standards.
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files
• Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin
• Extensive Experience in writing SQL queries, stored procedures, functions, packages, triggers, exception handlers, Cursors, 3NF, PL/SQL records & tables.
• Teradata experience using Teradata SQL Assistant and data load/unload utilities like BTEQ, FastLoad, MultiLoad, FastExport, and TPump
• Worked under development method Agile (Methodology) and SDLC.
• Worked on active data Warehouses with database sizes up to 10 Terabytes.
• Involved in Design and Development of test plans based on high-level and detailed designs. Analyzed the user/business requirements and functional specs documents.
• Experience working in an Agile environment for many different projects for different domains.
• Good experience in Client/ Server applications
• Developed the Test Automation Methodology for automated testing of the entire application by using Quick Test Pro.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS

ETL/BI tools: Datastage 8.5, Ab initio, Acential, Informatica Power Center 7x/6x, Cognos, Business Objects 5x.

Testing Tools: Hp Hp Quality Center 10.0, Rational Clear Quest and BugzillaTest Director, Rational Clear Case, Confidential, PVCS, Fogbugz

RDBMS: Teradata (Mload, Fastexport, Bteq, Fastload),NetezzaOracle 11g, Sybase 11x, DB2, and SQLServer.

Tools: Data Profiler, Erwin 3.5.2, TOAD, Visio

Scheduling Tools: TWS(Tivoli Workload Scheduler),ITG(IT Governence),Comtrol M, Autosys,Conduct -IT

Languages: SQL and PL/SQL, Java, C, C++, Python,XML

Operating systems: UNIX AIX, Redhat Linux,Sun/Solaris 7,Linux 6.1

Scripting Language: UNIX Shell Scripting,VBScript,Jil Script and Korn script

PROFESSIONAL EXPERIENCE

Confidential, Eden Praire, MN

Senior QA Tester

Responsibilities:

• Worked for complex projects to build Unified Data Warehose which includes Data acquisition layer, Data integration layer and Publication-Subscription frame work.
• Worked in Agile Environment, attended Daily Scrum Stand Ups meetings every day.
• Worked on User stories and gave points according to the complexity of the Story in rally.
• Have completed all the User stories and met all the deadlines to move the user story into Production.
• Have closely worked with Business Analysts, Developers and Client to solve any blockers while testing the User stories in System integration and User acceptance testing.
• Created Test Plan and Test Cases, Test Scripts according the business requirements.
• Prepared and executed Test Cases based on the mapping documents provided by Business Analysts.
• Delivered Extracts Using Secure File Transfer to the End Client.
• Performed complex Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Extensively worked on UNIX Platform in order to check source and trigger files are present in appropriate UDW Landing zone and to check on source data in Data Acquisition layer.
• Responsible for transferring Data stage code in CLM and running the job stream in TWS for creating UDW extracts in Publication-Subscription frame work.
• Performed Record Reconciliation and source data validation on UDW stage table’s vs Source database tables during Data Acquisition.
• UDW integration process consist various layers like UDW Stage layer, UDW Source repository layer, Common format layer, UDW Base layer and UDW Base Secure view layer.Peformed recount and data validation on each layer.
• Verified data is transformed correctly as per mapping rules such as Aggregation,Arithmetic, De-dup,Derived transformations and Valid value/range check,Filtering logic,Standard formatting of attributes,Default or Hardcoded logic and Straight move(s)
• Permormed System integration testing on Historical data aswell as incrememtal data
• Opened tickets for tracking defects and service requests in HP ALM
• Performed operations using ITG on scheduled jobs to populate the tables with data.
• Created the Traceability Matrix where test cases have been matched with the requirements .
• Executed test cases by writing SQL Queries using Complex joins such as Inner joins, Left Outerjoin and Analytical Functions.
• Ensured Weekly Deliverables in the Weekly Status Meetings. Also Participated in daily status meeting and met the Weekly deliverables.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Have a very Good Business Knowledge on Groups, membership, Claims, Provider data flowing into UDW.
• Have executed many test cases, validated all the Scenarios and also performed Regression testing whenever change occurred in the existing code.
• Also Worked on UAT/Production Validations, Performed production validation.

Environment: Data Stage, SQL, PL/SQL, Teradata 12.0,DB2, Oracle 10g,Teradata SQL Assistant, XML, HP ALM, Tivoli Workload Scheduler, Rally, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting.

Confidential, Durham, NC

Senior QA Tester

Responsibilities:

• Worked for Corporate Projects like Multi-payer Advanced Primary Care Practice and Disease Management and Blue Points.
• Worked in Agile Environment, attended Daily Scrum Stand Ups meetings every day .
• Created test cases based on the requirements provided by Business Analysts.
• Created Test Scripts, Test Plans based on the Data Specifications Provided by Data Integration Analysts.
• Delivered Extracts Using Secure File Transfer to the End Client. (UNC Model Office).
• Extensively worked on UNIX Platform in order to check Log/Error files.
• Responsible in testing the all the Transformations used in abintio code .
• Responsible in creating the Negative Test cases in order to check whether the code handled it correctly.
• Performed Regression testing by creating new Views/Tables on source data.
• Responsible in checking the data after Code has been deployed to Production.
• Created the Traceability Matrix where test cases have been matched with the requirements .
• Executed test cases by writing SQL Queries using Complex joins such as Inner joins, Left Outerjoin and Analytical Functions.
• Extensively Worked on Medical, Pharmacy and Carveout Claims in order to deliver them to the Vendor.
• Ensured Weekly Deliverables in the Weekly Status Meetings. Also Participated in daily status meeting and met the Weekly deliverables .
• Performed unit testing, System testing and integration testing to confirm ETL code integrity.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Have communicated with all the Data Integration Analyst’s to understand the flow of data from Different Databases.
• Have a very Good Business Knowledge on Groups, membership, Claims, Provider data flowing into EDW.
• Worked on few Data Specification mappings for few vendors Getting Terminated.
• Created Data Specification documents for Source Tables from the requirements.
• Worked as a Data Integration Analyst in writing the Specifications where I have analyzed multi tables to Pull out information for New Vendor Alere coming into EDW.
• Worked on Sending Claims (Medical, Pharmacy and RX Carve outs) required for the Vendor.
• Have Executed many test cases, validated all the Scenarios and also performed Regression testing when ever change occurred in the existing code.
• Also Worked on UAT/Production Validations, Performed production validation .

Environment: Ab Initio Co>OS 2.1x, GDE 1.1x, EME, SQL, PL/SQL, Teradata 12.0,DB2, Oracle 10g,Teradata SQL Assistant, XML, Spy 2008, HP Quality Centre 10.0, Trillium, Axis Tool, Control-M, PowerMHS Application, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003.

Confidential, Richmond, VA

Senior QA Tester - EDWH

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Hp Quality Center 9.2
• Tested ETL jobs as per business rules using ETL design document
• As a Test Lead Created Test plan, Test scenarios and test cases
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Defined data requirements and elements used in XML transactions.
• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Mart using Power Center.
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Tested the reports like DrillDown, DrillUp and Pivot reports generated from OBIEE.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code. .
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Tested complex objects to the universe to enhance the report functionality.
• Worked in an agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled the jobs using Auto sys and automated the jobs to be run at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Extensively used Autosys for automation of scheduling jobs on daily, bi-weekly, weekly monthly basis with proper dependencies.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Performed Unit testing and System Integration testing by developing and documenting test cases in Hp Quality Center.
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used Query Studio to test ad hoc reports
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio.

Environment: Informatica 8.6, Informix, DB2, PL/SQL, T-SQL, Java, OBIEE 10.1.3, SQL, SQL Server 2000/2005, PERL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Win Runner, Load Runner Teradata SQL Assistant 7.0, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, QTP v5.5/6.5,WinSQL, Ultra editor, Rumba UNIX Display, Hp Quality Center 8.2

Confidential, Farmingdale, NY

Sr.Test Co ordinator

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Wrote complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• Worked as a lead to resolve issues during critical phase of projects and guide junior testers and even played the role of a mentor whenever required
• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Creation and execution of test cases on Oracle Reports and OBIEE.
• Running reports for the executives on the Orders history and mile stones using OBIEE.
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
• Involved in Data mapping to/from legacy to Facets that will be used to populate the oracle database
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835
• Used Foresight Desktop Validator for HIPAA IG validation.
• Written test cases to test the application manually in Hp Quality Center and automated using Quick Test Pro.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extensively used Informatica power center for Extraction, Transformation and Loading process (ETL).
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: SAS/Base 8.1, SAS/Macros, SAS/ETL, PERL, UNIX Shell Scripting, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), OBIEE 7.3, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, T-SQL, PL/SQL, Oracle9i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R5

Confidential, Bentonville, Arkansas

ETL SQL/BI Test Analyst

Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Performed back-end testing on the Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained effective QA test lab environments
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after the bugs have been fixed by the development team
• Used Hp Quality Center for defect tracking
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Developed Test Strategy, Test plan, Test cases, and Test scripts
• Created test plan and executed test cases using Rational Test Manger
• Conducted Functionality, Security, and End to End testing
• Reported bugs using Test Director and generated the defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained the test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored the workflow transformations in Informatica work flow monitor
• Verified backend testing for compliance with FDA's 21 CFR Part 11 Electronic Signatures rules

Environment: Windows 2000 Server, SQL Server, Oracle 9i/8i, T-SQL, PL/SQL, Teradata V2R5, Documentum 5i, Rational Test Manager, Rational Requisite Pro, Rational Clear Case, Rational Robot, Business Objects 6.1, ETL Informatica, Test Director, Siebel E-Clinical 7.5, Toad, Java, J2EE, JSP

Confidential, Beaverton, OR

QA Tester

Responsibilities:

• Prepared Test Plan and Test Cases according the business requirements.
• Prepared Unit Test Cases including Positive, Negative and Boundary value Analysis test cases.
• Participated in setting up testing environment. & Performed Configuration Testing
• Performed Developed cases and scripts using Quick Test Pro for Functionality, Security and Regression Testing.
• Performed back-end testing using SQL queries on the Oracle database.
• Used SQL statements to check data integrity and data validation.
• Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro..
• Used and managing access control applications using DOORS from remote sites.
• Tested the properties of the tables using table checkpoints using Quick Test Pro.
• Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
• Supports direct connect h remote multiple site capability using DOORS software.
• Conducted Parameterization to data tables using Quick Test Pro.
• Created Multiple Actions using Quick Test Pro.
• Created Scenarios to conduct the load test using LoadRunner.
• Conducted Back-end and Regression testing during the various phases of the application.
• Performed Back-End Testing using SQL queries.
• Used Test Director Checker Diagnostic, a tool to test many of the Hp Quality Center server components.
• Gained understanding of Hp Quality Center structure for project customization.
• Involved reporting and tracking the defects using Hp Quality Center.
• Used Test Directory to run manual and automated tests, report execution results.
• Conducted result analysis and interacted with developers to resolve bugs.
• Participated in the project meetings.

Environment: Test Director, Windows XP, XML, Oracle 9i, DOORS, IIS server, UNIX

Confidential, Seattle, WA

QA Analyst

Responsibilities:

• Developed Manual test scenarios and test cases from Business Requirements and Design Documents
• Prepared Manual Test Scenarios and Test Cases for the Application under test.
• Was responsible for tracking and writing the Traceability Matrix.
• Participated in co-ordination and implementation of QA methodology.
• Executed test cases manually and verified actual results against expected results.
• Drafted test strategies, test cases and test plan based on functional specification.
• Performed manual testing at initial stages followed by majority of automated testing
• Performed negative and positive testing manually, along with functionality testing
• Interacted with developers and the Business on a regular basis for enhancing the requirements.
• Instrumental in leading the team for Test Run Iterations/Data driving test for better implementation.
• Was involved in User Acceptance Testing and interfaced with automation team to ensure the automated scripts comply with system test requirements.
• Wrote test cases based on decomposition document to execute testing.
• Performed data integration testing on the application
• Debugged the Database for accuracy of data
• Reviewed Business Requirement Documents and the Technical Specification.

Environment: Windows XP/2000/NT, Win Runner, Load Runner, Test Director, DOORS, Mainframe, DB2, Java, UNIX, IIS, SQL, HTML, ASP.NET

Confidential

QA Analyst

Responsibilities:

• Preparing, executing and documenting the test cases.
• Created test plan using specifications from the business requirements, which provided project wide strategic elements essential to the quality assurance processes to be employed.
• Responsible for functional testing with new tasks and client Enhancements.
• Responsible for functional, GUI & Regression testing.
• Logging defects and resolving, Responsible for Documentation of Test Results analysis and Test matrix preparation, Test data preparation.
• Participate in weekly meeting with the management team and walkthroughs.
• Involved in manual testing of test cases.
• Performed regression tests to check for unintended errors after the enhancement.
• Executed UNIX shell script for extracting database.
• Wrote various test cases and test scripts.
• Member of the User acceptance Testing Team and worked with the perspective of the user.
• Coordinated with developers to fix the bugs and conducted Functional (Positive and Negative), and Integrity Testing.
• Performed functional testing for login Authentication Process through Apache LDAP server (Apache Browsers).
• Participate in weekly meeting with the management team and walkthroughs.
• Performed Smoke Testing, Security Testing, GUI Testing and User Acceptance testing.
• Involved in maintaining Test Matrix.
• Maintain Defect Log which gives a clear indication of quality and stability of product.
• Test applications both in QA and Production environment.