SUMMARY:

• 8+ years of Experience in Quality Assurance using Business Intelligence, ETL, Datawarehouse, DataMart, Databases, Web services, Client - Server applications
• Experience in Software Engineering, SDLC & Testing Methodologies to ensure industry standards.
• Extensive experience in writing Test plans, Test cases and Test Execution.
• Solid experience in Black box testing techniques, which includes, Unit, Integration, Functional, System, Regression Testing.
• Extensively used Data warehouse ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, Data stage and Ab initio
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, PL/SQL, MS Access and Flat Files.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, Perl, UNIX.
• Experience working with Databases like Oracle, SQL Server, DB2 and MS Access.
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using oracle.
• Implemented database standards and naming convention for the database objects.
• Involved in identifying/ preparing the data (test data at the source level) that needs to be moved to data warehouse.
• Experienced in understanding Dimensional Data modeling using star and snow flake schema.
• Tested the different sources such as Flat files, Excel, XML, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD. Expertise in TOAD, SQL Developer, Microsoft SQL Server Management Studio and WinSQL tools.
• Good experience in Micro strategy, Business Objects, Cognos and Crystal Reports testing
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Strong working experience in the Data Analysis, Design, Development, Implementation and
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI & Reporting: Business Objects XIR3/R 2/6.5/6.0/5.0 , BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module), Cognos Impromptu 8.0/7.0/6.6, SSRS, Micro Strategy

Testing Tools: Load Runner 8.1, QTP 8.2, Test Director, Quality Center 9.2.

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2012/2008/2005/2000/7.0/6.5 , IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: App worx, Autosys, BMC Control M 6.2/7.0, Maestro

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux, MS-DOS

Web Service Tools: SOAP UI

Languages/Utilities: SQL, PL/SQL, SQL Developer, TOAD, Microsoft SQL Server, Quest Central for DB2,UNIX shell scripts (Cron, C),Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Madison WI

Sr. QA Tester

Responsibilities:

• Developing test plans, test cases created for the database backend testing and testing database functionality according to business requirement and technical document.
• Developing test scripts and mapping documents as per data requirement.
• Importing and exporting data using SQL Server Import and Export Wizard and running except queries to validate data from source to target.
• Writing complex SQL queries to validate data that is populated in Data Mart / Data warehouse which are Transformed and Loaded using Data Flux.
• Preparing test data as per requirement and validate data for IDL load and then Delta processing.
• Validating contents that are populated in Veeva system through jobs.
• Testing contents that populated in different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Collecting evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively using Data warehouse ETL methodology for testing and supporting data extraction, transformations and loading processing.
• Closely working on all the stages of SDLC for the project and designing and executing Functional, Integration, Regression, System (End to End) and Backend (Database).
• Review test document with team and business.
• Assisting code promotion from QA/UAT to Production.

Environment: DWH Informatica Power center (ETL), Business Objects XIR3, HP Quality Center/ALM, Rational Clear Quest, Rational Clear Case, QTP, SQL SERVER, SSIS, Toad for Oracle, Unix, Autosys, Windows XP.

Confidential, Boston MA

Sr.QA Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Different Data Stage components especially are used effectively to develop and maintain the database
• Developed Manual ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used Data warehouse ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution.
• Execute batch jobs using Control-M enterprise manager and check SYSOUT, ERROR LOG details.
• UsedSQLfor Querying theOracledatabase inUNIXenvironment
• Written Complex SQL Queries. To do manual testing in my feature for every release and check the configurations
• Tested several ETL job activity for data stage using Data stage designer
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Ran several jobs in data stage from both command line and front-end.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend testing Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.

Environment: DWH ETL IBM Data Stage 8.1, Quality Center 10.0, SQL,PL/SQL, DB2, SDLC, TSYS, TOAD, SQL Developer, Oracle 9i/10g/11g, UNIX, PERL,DB Visualizer, Flat Files, IVR, AVAYA, Micro strategy.

Confidential, Bethpage NY

QA Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Data warehouse ETL Informatica Power Center.
• Built a library of test cases for regression testing and automated them using QTP
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata,
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing designing and development of Data warehouse environment.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Written and executed the functional and regression test script using Test Script QTP.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in extensive DATA validation on data marts by using SQL queries.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Used TOAD Software for Querying ORACLE.
• Validated Business Objects reports by running the SQL queries based on the business rules.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment: DWH Informatica Power center 8.6 (ETL), Business Objects XIR3, HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER,SSIS, Toad for Oracle, ORACLE 9i, Unix, Autosys, Windows XP.

Confidential, CA

Quality Analyst Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• External interactions with NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments as required.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Involved in user sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Data Stage code and UNIX Shell scripts from UAT to Production.
• Tested Complex Data warehouse ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required
• Worked with thin client and thick client (Business Objects )
• Extraction of test data from tables and loading of data into SQL tables.
• Created Data warehouse ETL test data for all ETL mapping rules to test the functionality of the Data Stage Mapping
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Tested the ETL Data Stage mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc..
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with business team to test the reports developed in Cognos
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: DWH ETL Data Stage, MVS, UNIX, Oracle, SQL Server 2005, DB2, Business Objects Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, Autosys

Confidential, Charlotte NC

DWH ETL Tester

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Constructed context diagrams and data-flow diagrams based on the description of a business process. Analyzed the data model to code efficiently in SQL.
• Worked with UNIX scripts. Worked with releasing scripts live and tested.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked intensively with indexes to tune the query, exploited the B-tree and Bitmap index functionality of oracle to get the better performance.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: Informatica power mart 5.1, Toad, SQL, PL/SQL, Test Director, Visual Basic 6.0, Oracle 8i, Windows 2000, UNIX.