SUMMARY

• 7 years of professional experience in Software Industry, Expertise in all kinds of databases testing with focus on ETL, Data warehouse, Data Mart, Databases, Client - Server applications on Web based and Widow/UNIX environment
• Extensive knowledge on all phases of Software Development Lifecycle (SDLC).Experience in Agile Development, Scrum and Waterfall models of SDLC
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report
• Worked with Business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans
• Extensive use of Confidential Quality Center/ALM defect tracking tool
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Have pleasant experience on working with agile mythologies such as Master, scrum, owner and team
• Expertise in creating Test plan documents and Test strategy documents. Expertise in designing the test scenarios and scripting the test cases to test the application.
• Good exposure with databases like Confidential 11g, Confidential, SQL Server 2008
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Have good knowledge on Working within the Data Access Layer with Object Relational Mapping (ORM) (Entity Framework), and an understanding of RDBMS modeling and design.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Experienced in Defect Management using Mercury Test Director, Confidential Quality Center
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Worked with different data sources ranging from VSAM files, CSV file, flat files, and Confidential, Confidential, and SQL Server databases.
• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Confidential, SQL Server and DB2 databases.
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
• Experienced in testing performance in an Agile methodology
• Have good knowledge on different type of testing such as load testing, stress, DB testing etc..
• Handsome experience in working with UNIX scripts in executing and validating logs for the issues.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Have experiences testing on different components like customer data, Agreement data, Deal, Excess, violation, Asset, Organization, Application, and securities.
• Hands on experience in writing SQL queries, Joins, Functions in Confidential, and SQL Server databases.
• Have good knowledge on healthcare area like pharmacy and blood donation center.
• Good expertise in using TOAD, SQL*Plus and Query Analyzer.
• Strong experience in UNIX shell scripting and monitoring the UNIX logs to check for any errors.
• Created the test instances for the project in the Test Lab and Test Plan module of Quality Center.
• Strong experience in Backend testing on Relational Databases (RDBMS) like Confidential, SQL server 2012, Tara Data using complex SQL queries.
• End to End responsibility to close the defects and fixes.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 8.6, Data stage 8.5

Reporting Tools: Excel, OBIEE, SSRS

Database: Confidential 10g/9i, SQL Server 2005, 2012, Confidential DB2, Confidential and MS-Access

Utilities: Toad, Confidential SQL Developer, SQL Advantage, SSIS, SSRS

Testing Tools: Confidential Quality Center 9.2/Test Director, Confidential ALM 11.0, Clear Quest, Rational Clear Case, JIRA

Programming Lang: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. QA Analyst /UAT Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Involved with Agile team and worked out different sprint module.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Tested different Informatica Mappings 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 Confidential 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)
• Have experiences testing on different components like customer data, Agreement data, Deal, Excess, violation, Asset, Organization, Application, and securities.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Used Informatica Power Center to create mappings, sessions, and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Confidential, Flat files)
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Deployed reusable transformation objects such as maplet to avoid duplication of metadata, reducing the development time.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica
• Have programming skills in SQL and experience in Confidential and Confidential databases on UNIX and Windows platforms.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Confidential databases.
• Written Complex SQL Queries to do manual testing for every release and check the configurations.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Business Objects.
• Used Business Objects for testing the scheduled reports and viewing the history.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in Confidential Quality Center/ Confidential ALM /JIRA 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.
• Tested data from various sources like Confidential, Confidential flat files and SQL Server. Worked on issues with migration from development to testing.

Environment: ETL Informatica, Confidential, SQL Server, Quality Center/ALM, SQL, TOAD, Confidential SQL Assistant 6.0, Confidential, PL/SQL, SQL Server, UNIX, SSRS, MS Access, Flat Files.

Confidential, Durham, NC

Sr. ETL/QA Tester

Responsibilities:

• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Experience in Informatica power center for extraction, transformation and loading process.
• Executed SQL queries to verify the flow of data between back end and front end.
• Coordinated system walk through,, User Acceptance Testing (UAT) and facilitate issue resolution .
• Creating and executing SQL queries to perform Data Integrity testing on an Confidential Database to validate and test data using TOAD/Exceed.
• Performed ETL Informatica testing and extensively used SQL functionalities. Used TOAD to connect to Confidential Database.
• Tested reports developed by Business Objects Universes for both Ad hoc & Canned Reporting users of Business Objects.
• Performed Data Driven Testing of the Application for different users/data sets.
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness.
• Designed and executed test cases for various project and documented evidence for each step of the process to ensure that any errors are captured and communicated with developers for resolution.
• Extensively used Confidential Quality Center for various project tasks like maintain test cases, parameterize test case and defect tracking
• Executed automated scripts using Confidential Quality Center (Test Lab module) to thoroughly test application.
• Performed End to end testing starting from the source to the report. Conducted and coordinated integration testing and regression testing.
• Wrote SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Executed batch processing and verified job status and data in database tables.
• Reviewed Test cases and scenarios by Business Analyst for coverage and completeness.
• Involved in backend testing for the front end of the application using SQL Queries in Confidential database
• Involved in backend testing for the front end of the application using complex SQL Queries in SQL Server 2012
• Extensively used SQL statements to query the Confidential Database for Data Completeness, Data Validation and Data Integrity.
• Created test results document at the completion of entire testing process and sent detailed test execution and bug status report using Confidential ALM and participating in defect meetings.

Environment: Informatica Power Center 8.1, Business Objects, SQL, PL/SQL, UNIX, Toad, Test Director V7.6, Windows NT, MS SQL server

Confidential, Chicago, IL

Sr. ETL/ DWH Tester

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center.
• Extensively used Data Stage for extraction, transformation and loading process.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Used Informatica Power Center to create mappings, sessions, and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Confidential, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Creating and executing SQL queries to perform Data Integrity testing on an Confidential Database to validate and test data using TOAD/Exceed.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Facilitated the sharing of structured data across different information systems using XML Created and executed automation scripts using QTP
• Tested Data Stage Hashed files for extracting and write data - an intermediate file in a job.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Good experience in validating the Adhoc and OLAP cube. Used XSLT for document is transformed into another XML document that uses the formatting vocabulary written several complex SQL queries for validating Cognos Reports.
• Validated Cognos Standard Reports created based on Framework manager and Cube.
• Worked
• UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Confidential Database.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Participate in weekly meeting with the management team and walkthroughs

Environment: Oracle10g, Cognos8.1, Windows NT/2000/XP, SQL SERVER, SSRS, TOAD, Quality center 10, UNIX. JIRA, SQL server Confidential /ALM

Confidential, Foster city, CA

ETL QA 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
• 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 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
• Test and evaluate the video codec and processing technologies and new features with respect to reliability, accuracy, and usability
• 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.
• Used Maven, Selenium Grid to execute Selenium automation suites on different platform like Java, browser combinations in parallel.
• Identified weaknesses in QA Processes, Web testing, Selenium Automation. Suggested &
• 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: Data Stage, UNIX, Confidential, SQL Server 2005, DB2, Business Objects, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dot Files, XML Files.

Confidential, Columbus, OH

System QA Analyst/ETL Tester

Responsibilities:

• Prepared and Executed the test script in multiple environments (DEV,IFT (SIT), UAT and Production) to ensure changes implemented accurately in all environments
• Used Rally tool for updating and estimated user story based on the understanding during Sprint planning
• Actively participated in daily scrum call, back log grooming session, sprint refinement for Agile methodology
• Tested all the ETL process developed to fetch the data from various feeds into the data warehouse.
• Tested full load and Incremental load (Delta) in data warehouse to verify Inserts & Updates of loading the data is performed correctly
• Developed ETL Test cases of various line of business based on ETL Mapping document and Functional requirement document
• Wrote complex SQL queries to perform data validation to verify data populated from source to target as per mapping document logic
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse using SQL Developer and Tera data
• Worked in a highly dynamic AGILE environment in multiple scrum team(s) and provided QA walkthrough for each User story to scrum team
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules
• Experiences testing on different data like Consumer, Customer, Party, Loan, Mortgage, and Securities etc.
• Experience in creating the mock up data, test scripts in order to test the code in the DEV environment
• Analyze User Requirements and Specifications and develop Test Plans and Test scenarios.
• Worked closely with the Product owner, Developers, Technology Manager, Business Analyst and Database Architect in identifying the outstanding Issues in User Requirements and Specifications.
• Extensively helped the Development team to root cause of the underlying issues that would impact the quality of the system
• 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 User Acceptance test cases in IFT and UAT environment.
• Written SQL scripts for validating the data loaded by the ETL processes.

Environment: Rally, Confidential SQL Developer, Confidential SQL Assistant, SQL Server, ALM, AGILE, Ab Initio, UNIX, Confidential Mapping Tool, Confidential Excel, Confidential Word, Confidential SharePoint.