SUMMARY

• Eexpert in writing complex SQL queries and Unix to execute the backend jobs.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect
• Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in Oracle, SQL Server and DB2 SQL.
• Expertise in Data Mover scripts for Data Export and Import.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, MS Access, Flat files into a staging area.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments)
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Good knowledge on Automation Tool Selenium and Quick Test Professional.
• Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis
• Services (SSAS) and Integration Services (SSIS)
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Data stage, Informatica, Ab initio and Auto sys tools.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and
• Regression Testing.
• Generated automated Scripts in QTP and designed Automated Test Suites for regression testing in Quick Test Pro.
• 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
• Hands on expertise with test automation tools such as HP QTP (Quick Test Pro)
• Experience in assisting the customer in User Acceptance Testing (UAT)
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Excellent skills in Teradata, DB2, SQL Server and Oracle … RDBMS and Sybase.

TECHNICAL SKILLS

Operating system: Windows, Linux, Mac.Management Tools Test Link, HP ALM, Quality CenterBug Tracking

Tools: JIRA, Mentis BT, Bugzilla, QCLanguages R - Console, SQL, PL/SQL, html5

Database: Server 2008/2008R2/2012, SAP, Oracle DB, Microsoft Access, TSQL/PLSQL, Azure.

Data Mining/Reporting Tool: SQL, SSIS, TOAD Oracle Financial Analyzer, Apache Solr, SAS, Tableau, Axiom, Erwin Data Modeler, Cognos.

Quality Assurance Tool: HP ALM 11/HP Quality Center, Test Director 7.5, IBM ClearQuest

Environment: Windows: IBM Mainframes, UNIX, Linux.

Languages: SQL, PL/SQL, Shell, Perl and bash, Java, VB Script, RDBMS Oracle, SQL Server, Teradata, Sybase, DB2

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, Win SQL

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE

Confidential, East Brunswick, NJ

Sr QA Tester/ETL Tester/Manual/Automation

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 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 SQL Server database.
• Expertise in validating SSIS and SSRS packages according to functional requirements.
• 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.
• Involved in Test plan, Test case preparation and assigning defects through TFS
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Used SQL for Querying the SQL Server database in UNIX environment
• Written Complex SQL Queries. To do Manual testing in my feature for every release and check the configurations
• Validated SSRS dashboard reports by writing several complex SQL queries based on reporting logic.
• 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, and 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 with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.

Environment: SQL, PL/SQL, TOAD, Data warehouse ETL IBM Data Stage 8.1, SQL Server, SSIS, SSRSSSAS, Quality Center/ALM 11.0, .Net, Visual studio, MS Access, DB2, SDLC, TSYS, SQL Developer, QTPUNIX, PERL, DB Visualizer, EMWE WEBSITE, Flat Files, Pivot Tables, Pivot Tables.

Confidential, San Jose, California

Sr. ETL/ QA Tester

Responsibilities:

• Running of ETL jobs and test data setup using Autosys, Quality check for test data. -Transformation logic verification, RCA for defect found.
• Used SQL Server to run SQL queries and validate the data loaded into target tables
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target backend databases for conformance to specifications
• Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS for Reporting.
• Worked in an intense AGILE environment, where the code is delivered every 3 days
• Participated in weekly defect review meetings with the dev./business and test team peers
• Extensively involved in Onsite-Offshore model, where need to held meetings on daily basis, as were following AGILE methodology.
• Tracked the defects using QC ALM tool and generated defect summary reports.
• Extensively used grep, AWK, find commands and used Shell Scripting to call back end jobs
• Validated the data movement (XML, Flat Files, VSAM, .dat, .xls) and transformations are done correctly
• Worked with Data Warehousing developers who extensively used Informatica9x, to design
• Mapping to move data from source to target database-using Stages to do the functionality.
• Testing of Data Mapping documents between source and target databases as per transforming logic
• Prepared status summary reports with details of executed, passed and failed test cases
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server databases.
• Reviewing Functional Specification Document and preparing traceability matrix for test case mapped.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Reported the bugs through email notifications to developers using TFS
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Partner with business and development partners to create detailed test plans and validation strategies.
• Identify and document defects in a defect tracking system and manage issues/defects through resolution.
• Identifying duplicate records in the staging area before data gets processed. Provide communication to project stakeholders.
• Manually execute detailed test procedures designed to validate application functional requirements.
• Ensure software requirements are verifiable and quantifiable with the ability to build test cases.
• Contribute to efficient and effective program in solving medium-complex business problems.

Environment: SQL, Oracle, TOAD, UNIX, ETL Informatica, AutoSys, SQL Server, SSIS, SSRS, SSAS, WIN SCP, QTP, .Net, VB descriptive scripting, HP Quality Center

Confidential, Wilmington, DE

ETLTester

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
• Tested Complex ETL SSIS and SSRS Packages, Sessions based on business user requirements and business rules to load data from different source
• 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 training sessions and assisting in UAT (User Acceptance Testing)
• Assisted in promotion of SQL Server Integration Services and UNIX Shell scripts from UAT to Production.
• Tested Complex 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 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.
• Written several complex SQL queries for validating Cognos Reports.
• Tested the reports using SSRS reports.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• 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.
• 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: SQL, PL/SQL, TOAD, MVS, UNIX, Oracle, DB2, .Net, SQL Server, SSIS, SSRS, SSAS, XMLXSLT, XSD, Rapid Data Files, XML Files, Visual Studio, MS Access, Quality Center, Autosys

Confidential, Nashua, NH

Responsibilities:

• Worked closely with Business user to 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
• Used Quality Center to develop test cases, and executed them in test lab.
• 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.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS reports and business Rules.
• Worked with UNIX scripts. Worked with releasing scripts live and tested.
• 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.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server 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: ETL, Toad, SQL, PL/SQL, Test Director, Quality Center, .Net, Visual Basic, Oracle, SQL Server, SSIS, SSRS, SSAS, QTP, Windows 2000, UNIX.

Confidential

QA Analyst

Responsibilities:

• Involved in Data Validation using SQL queries.
• Performed negative testing, to make sure validations are done properly.
• Provide update to management on testing status and some other issues.
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing
• Involved in Data Validation with Business Team.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Was involved in design part for Extracting data from different source systems into the target database using Data stage Server 6.1.
• Responsible for executing manual and automation testing script for Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Performed Negative testing to find how the functions and variables perform when they Encounters invalid and unexpected values.
• Developed automated scripts using QTP to perform Functional and Regression testing.
• Inserted Check Points for the broken Links, Text, and standard properties of an object using QTP.
• Used Parameterization for using various data to test the application using QTP.
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Extensively executed complex SQL queries to test database schema, objects and functionality as well as for data validation.

Environment: Data stage Server 6.x, Oracle 9i, C++, UNIX, IBM AIX 5.0, .Net, Test Director, and Shell Scripting

Confidential

Jr ETL Developer

Responsibilities:

• Deployed ETL Code to Production environment based on the instructions provided by development team.
• Monitored the scheduled jobs in production in 24X7 shifts using Tivoli tool.
• Developed Reusable Mapplets and Transformations using Informatica Power Center Designer.
• Gathered the scheduled run statistics and track it for metrics purpose.
• Used Informatica Debugger to debug the mappings to gain the trouble shooting information about data and error conditions.
• Fixing the failed jobs, by analyzing the issue using the session log.
• Rerunning of the jobs for those that got failed in the production environment.
• Use to make sure that the production is up and running and used to clean up the UNIX box that is with unnecessary files.
• Used to tune the user queries for better performance.
• Have written complex SQL’s by using inner, left outer and right outer joins.
• Have attended daily status call and provided the status to the onsite team.

Environment: Informatica Power Center 8.1, Oracle 10g, Tivoli, Toad, UNIX, SQL Server, Putty, WinSCP.