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 teh 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 teh Test Automation Methodology for automated testing of teh entire application by using Quick Test Pro.
• Strong working experience in teh 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 teh complexity of teh Story in rally.
• Have completed all teh User stories and met all teh deadlines to move teh user story into Production.
• Have closely worked with Business Analysts, Developers and Client to solve any blockers while testing teh User stories in System integration and User acceptance testing.
• Created Test Plan and Test Cases, Test Scripts according teh business requirements.
• Prepared and executed Test Cases based on teh mapping documents provided by Business Analysts.
• Delivered Extracts Using Secure File Transfer to teh 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 teh 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 teh tables with data.
• Created teh Traceability Matrix where test cases have been matched with teh requirements .
• Executed test cases by writing SQL Queries using Complex joins such as Inner joins, Left Outerjoin and Analytical Functions.
• Ensured Weekly Deliverables in teh Weekly Status Meetings. Also Participated in daily status meeting and met teh 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 teh Scenarios and also performed Regression testing whenever change occurred in teh 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 teh requirements provided by Business Analysts.
• Created Test Scripts, Test Plans based on teh Data Specifications Provided by Data Integration Analysts.
• Delivered Extracts Using Secure File Transfer to teh End Client. (UNC Model Office).
• Extensively worked on UNIX Platform in order to check Log/Error files.
• Responsible in testing teh all teh Transformations used in abintio code .
• Responsible in creating teh Negative Test cases in order to check whether teh code handled it correctly.
• Performed Regression testing by creating new Views/Tables on source data.
• Responsible in checking teh data after Code has been deployed to Production.
• Created teh Traceability Matrix where test cases have been matched with teh 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 teh Vendor.
• Ensured Weekly Deliverables in teh Weekly Status Meetings. Also Participated in daily status meeting and met teh 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 teh Data Integration Analyst’s to understand teh 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 teh requirements.
• Worked as a Data Integration Analyst in writing teh 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 teh Vendor.
• Have Executed many test cases, validated all teh Scenarios and also performed Regression testing when ever change occurred in teh 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 teh 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 teh database schema with help of data architects using ERWIN.
• Involved in teh 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 teh results.
• Tested teh reports like DrillDown, DrillUp and Pivot reports generated from OBIEE.
• Identified and Documented additional data cleansing needs and consistent error patterns dat could diverted by modifying ETL code. .
• Tested teh reports generated by OBIEE and verified and validated teh 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 teh 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 teh Teradata data warehouse
• Tested complex objects to teh universe to enhance teh 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 teh data using SQL Assistant.
• TEMPEffectively distributed responsibilities, arranged meetings and communicated with team members in all phases of teh project.
• Used import and export facilities of teh application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled teh jobs using Auto sys and automated teh jobs to be run at specific time and automated teh 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 teh ETL process, automate teh process of loading, pulling teh data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used Query Studio to test ad hoc reports
• Responsible for migrating teh code changes from development environment to SIT, UAT and Production environments.
• Validated cube and query data from teh reporting system back to teh 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 teh 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 teh role of a mentor whenever required
• As a Lead, was involved in weekly status, following up teh development as well as teh business /Testing teams, re-scoping project planning
• Prepared teh 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 teh executives on teh Orders history and mile stones using OBIEE.
• Interacted with Users to understand teh bugs in Business Reports generated from OBIEE
• Followed teh 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 dat will be used to populate teh 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 teh 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 teh universe level. These cascading prompts were used within full client and thin client reports to narrow down teh 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 teh 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 teh 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.
• TEMPEffectively 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 teh actual result with expected results. Validated teh 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 teh output Data of teh reports
• Performed back-end testing on teh Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained TEMPeffective QA test lab environments
• Developed SQL queries in Toad and DB Artisan to achieve teh data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after teh bugs have been fixed by teh 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 teh defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained teh test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored teh 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 teh 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 teh Oracle database.
• Used SQL statements to check data integrity and data validation.
• Created Text area Checkpoints to test teh properties of teh text in teh application using Quick Test Pro..
• Used and managing access control applications using DOORS from remote sites.
• Tested teh properties of teh tables using table checkpoints using Quick Test Pro.
• Created page checkpoints to test teh properties and contents of teh 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 teh load test using LoadRunner.
• Conducted Back-end and Regression testing during teh various phases of teh application.
• Performed Back-End Testing using SQL queries.
• Used Test Director Checker Diagnostic, a tool to test many of teh Hp Quality Center server components.
• Gained understanding of Hp Quality Center structure for project customization.
• Involved reporting and tracking teh 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 teh 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 teh Application under test.
• Was responsible for tracking and writing teh 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 teh Business on a regular basis for enhancing teh requirements.
• Instrumental in leading teh team for Test Run Iterations/Data driving test for better implementation.
• Was involved in User Acceptance Testing and interfaced with automation team to ensure teh automated scripts comply with system test requirements.
• Wrote test cases based on decomposition document to execute testing.
• Performed data integration testing on teh application
• Debugged teh Database for accuracy of data
• Reviewed Business Requirement Documents and teh 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 teh test cases.
• Created test plan using specifications from teh business requirements, which provided project wide strategic elements essential to teh 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 teh management team and walkthroughs.
• Involved in manual testing of test cases.
• Performed regression tests to check for unintended errors after teh enhancement.
• Executed UNIX shell script for extracting database.
• Wrote various test cases and test scripts.
• Member of teh User acceptance Testing Team and worked with teh perspective of teh user.
• Coordinated with developers to fix teh bugs and conducted Functional (Positive and Negative), and Integrity Testing.
• Performed functional testing for login Autantication Process through Apache LDAP server (Apache Browsers).
• Participate in weekly meeting with teh 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.