SUMMARY

• 10+ years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Expertise in Business Requirement gathering through JAD sessions, interviews, workshops and walkthroughs, and main concentration in Business Process Flow and Business modeling tools as a Business analyst
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Well versed with various types Software Development methodologies - Water fall, Agile, RUP, Iterative and extreme Programming.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Datastage tools.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in scheduling the Informatica, Ab Initio, Datastage jobs using Appworx, Ctrl-M & Autosys.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules

TECHNICAL SKILLS

Data Warehousing: Informatica 8.6.1/8.1, Ab initio, Data Stage 8.x

Reporting Tools: Business Objects 6.5/XIR3, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

Requirement Tools: Rational requisite, DOORS

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin 4.0/3.5

Testing Tools: Win Runner, Test Director, Mercury ALM 11.0, Rational Tools

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008, MS Access 2008

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

MPP Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

Sr.ETL QA Test

Responsibilities:

• Analysis of all Technical Transformation Rules, Business Translation Rules for both functional and business requirements from the Mapping Specifications and Functional Design specifications.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• 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.
• 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.
• Used T-SQL for Querying the SQL Server database for data validation.
• Reviewed the Business Requirement Documents and the Functional Specification
• Prepared Test Plan from the Business Requirements and Functional Specification
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases
• Extensively used Informatica for extraction, transformation and loading process
• Worked as ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project
• Complete understanding of the X12 transaction sets
• Prepared Test Data as for the functional specifications
• Developed automated test scripts using QTP to perform Functional and Regression testing.
• Tested Group and Individual Member enrollments and benefit packages
• Worked closely with the development team in making the detailed QC test plan regarding the scope and focus of the testing
• Conducted Functionality, Security, and End to End testing
• Performed data base testing writing SQL queries. Tested ETL batch processes using Unix shell scripting
• Performed setting up test data, triggering all Fulfillment and Handling Types using Power MHS
• Involved in Agile and Waterfall Development Cycle, and used Agile testing methods such as Scrum and Extreme Programming (XP)
• Experienced in Claims Processing, Enrollment, Group and Individual Member billings
• Performed batch testing for dependency test cases using QTP
• For regression testing of the various releases of the application and performed regression testing by executing the baseline scripts, identified functional errors and interacted with developers to resolve technical issues
• Executed test scripts and reported defects in Quality Center tool and attended status meetings

Environment: QTP 10.0, Quality Center 10.0, Informatica Power Center 8.1, VB Script, Windows XPPowerMHS 5.8.1, DocumentDirect 2.3, HP Open view Service Center Client 6.2.2.0, ERWIN, AS400, Java, DB2, J2EE, Dbvisulize 6.0.9, Jcaps 5.1.3, UNIX, ETL Data Stage, XML, XSLT, XSD, XML Spy 2008, UNIX, SQL Navigator, Java, SQL Server 2008, PL/SQL, SQL Scripts, MS Word.

Confidential, Baltimore, MD

Sr. ETL/Hyperion Tester

Responsibilities:

• Reviewed and analyzed Business Requirements and clarified with Business Analyst.
• Written several UNIX scripts for invoking data reconciliation.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Reviewed High Level and Lows level Design docs and clarified design solutions with Developers
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Developed the ETL and BI testing strategy
• Worked on Web forms using Hyperion Planning for various planning scenarios
• Tested reports required for the business needs using Hyperion Hyperion Essbase 9.x/7.x/6.x Reports and Hyperion Analyzer (ad-hoc).
• Maintained job schedules for periodic generation of reports using different modules of Hyperion Performance Suite.
• Extensively executed SQL queries in order to view successful transactions of data
• TOAD is used to perform manual test in regular basis.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse
• Identified duplicate records in target tables.
• Executing and monitoring jobs through Control-M.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• 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.
• 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.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis
• 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.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Execute the database Test cases according to release.
• Create custom built reports from the Control-M batch server.
• Scheduled the ETL jobs and ran jobs using Auto sys and automated the reports
• Analyze the results and log the defects in bug tracking tool
• Retested resolved bugs on each build release
• Communicate with Db Developers and DBA

Environment: HP Quality Center 10.0, PVCS, SQL, PL/SQL, Informatica 8.6.1/8.1, EME, Oracle 10g, Teradata V2R6, Hyperion Essbase 9.x/7.x/6.x,Hyperion planning 9.x/4.x, Financial, TOAD, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting

Confidential, Buffalo, NY

Data warehouse Tester

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Excellent knowledge on Agile Methodology.
• Test plan preparation, preparing daily status reports and defect reports.
• Transformed the EDI Data into the format understandable to Back End Systems.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
• Designed Connection Models for receiving EDI Documents and Validating for known source.
• Involved in writing and executing the test cases.
• Tested OLAP cubes for all business conditions
• Involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in testing the Business Objects reports by writing complex SQL queries
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail
• Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Attending defect triage meetings.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.

Environment: Informatica 7.2, EME, SQL Navigator 5.0, Teradata V5R12, SQL Assistance, Business Objects 6.5, Quality Center 9.0, Oracle 10g, UNIX, XML, XSD, XML Spy

Confidential, Raleign, NC

SQL/ETL/SQL Analyst

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.
• Worked with business team to test the reports developed in OLAP
• 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: Informatica 7.2, 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, Menands, NY

Test Engineer

Responsibilities:

• Reviewing the business requirements document, and technical specifications document.
• Created all requirements in Test Director from Requirements finalized doc.
• Written complex SQL and PL/SQL statements for data validation.
• Developed Test Estimations to develop test cases and execution.
• Test Case status reports and defects reported weekly in Daily Project status meetings.
• Involved in Developing Test Cases, Test conditions and strategy.
• Traceability Matrix developed to map Requirements with Test cases.
• Involved in Unit, GUI, Functional, Integration, System, and Compatibility Testing.
• Performed Regression, and end to end business scenario testing.
• Developed SQL Queries for database validations for insert update, delete of the records
• Quality Center used to maintain test cases and test execution status with and test results.
• Responsible in providing regular test reports to the QA lead and Project Manager.
• Attend project meetings, daily status, and defect scrub meetings, and provide test status.
• Tracked all defects in the Test Director and update status test life cycle and disposition
• Developed Defects, Test Status reports with Charts from Test Director and provide to team
• Production test data created early, for the production test case execution.

Environment: Windows2000/NT, VB, Java, JSP, Java Servlets, Java Script XML, XSLT, Oracle 9i, F-Secure SSH Client, SQL,PL/SQL, Windows 2000, QTP, Test Director