PROFESSIONAL SUMMARY:

• 8 years of IT experience in the Analysis, design, testing and Implementation of Data ware housing ETL and Business Intelligence solutions.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive testing ETL experience using Informatica 10/9.6/9.1/9.0/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor, and Server Manager), AutoSys, Control M and Maestro.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization, and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner, and Quick Test Professional for web - based and client server applications.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation, and Load (ETL) of data from Legacy systems using Ab Initio & Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads for testing practices.
• Extensive experience with Reporting Tools like OBIEE, Cognos, Business Objects
• Extensively used ETL methodology for testing data extraction, transformations and loading in a corporate-wide-ETL Solution using Data Stage
• Expertise in testing complex Business rules with the help of mapping documents and transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Knowledge on Excel Pivoting and VBA macros for implementing various business scenarios.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

Defect Tracking Tools: HP Quality Center 11.5/11.0/10/9.0/9.2 , IBM Clear Quest 9.0, QTP, Bugzilla and Jira

ETL Tools: Informatica 10/9.6/9.1/9.0/8.1/7.1/6.2/5.1 , Data Stage, Ab Initio 1.15, SSIS

BI/Reporting Tools: Business Objects, SSRS, SSAS, Crystal Reports XIR4, Cognos 8.4

Operating System: Windows 98/XP/2000, UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML, java, C, Perl scripting, VBRDBMS/ Database: SQL Server, Oracle, IBM, Teradata 12.0GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Sr. QA Tester/ETL Tester/BigData Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification. Prepared Test Plan from the Business Requirements and Functional Specification.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Worked in an Agile technology with Scrum
• Written several UNIX scripts for invoking data reconciliation. Reported bugs and tracked defects using Quality Center/ALM
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Worked with Data Conversion projects for testing data quality after migration.
• Used SQL for Querying the DB2 database in UNIX environment.
• Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio
• Wrote SQL scripts to perform database testing and to verify data integrity.
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals
• Responsible for drafting complex SQL queries and perform allocation testing from front end / user interface
• Written several complex SQL queries stored procedures for validating Cognos Reports
• Responsible for verifying the log files using UNIX and database for the submitted application.

Environment: ETL Informatica, BI Cognos, SQL, PL/SQL, Oracle, TOAD, MS Excel, MS Access, MS Visual Studio, Tableau, HP ALM/Quality Center, SQL Server and UNIX.

Confidential, West Des Moines, IA

Sr. ETL/BI QA Tester

Responsibilities:

• Executed test cases and analyzed results for QBIC Reporting Tool and CASPER Reporting Tool.
• Interact with Business users on Testing needs and technical specifications document, High-level design document, Source to target mapping document, develop and test custom developed applications.
• Involved in designing of Test Plan, Identifying Test Scenarios and Executing the Test Cases. Reviewed and analyzed functional requirements.
• Reviewed and analyzed functional requirements.
• Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica.
• Experience in the creation, updated and execution of complex SQL queries as per Business requirement/ User Manual.
• Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
• Involved in various kinds of testing like functional testing, Graphical User Interface (GUI) testing and Regression testing.
• Performed UAT, and SIT testing and executed test cases in UAT and SIT environments.
• Used PL/SQL Developer to write and automate SQL queries for Data Validation for various reports.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.
• Hands-on experience in database testing.
• Validated BO Reports and Universes against Data warehouse /Data mart Database by writing SQL Queries
• Created, Developed, and Analyzed Various Reports.
• Core understanding of Quality Assurance practices and procedures
• Raise defects in Spira Test to track the defects Log project related issues in the defect tracking tool identified for the project

Environment: ETL Informatica, BI Business Objects, Oracle PL/SQL, MS SQL Server, SPIRA, MS Office, Beyond Compare, Jira, Casper.

Confidential, Winston-Salem, NC

ETL/BI QA Tester

Responsibilities:

• Using HP ALM/Quality Center for executing and validating test cases, and defect tracking. Experience leveraging complex SQL statements
• Experience testing ETL for data warehouses and operational data stores. Experience in the creation and execution of manual test scripts
• Analyze business and technical requirement documentation. Experience in developing QA artifacts (Test Plan, test cases, traceability matrix, etc.)
• Performed PROD, UAT, and SIT testing
• Prepared and designed test data for UAT and SIT environment
• Defects were tracked, reviewed, analyzed, and prioritized using HP Quality Center and analyzed the discrepancy between expected result and actual result
• Self-motivated and deadline oriented requiring little supervision
• Ability to interpret logical and physical database models. Hands-on experience in database testing
• Core understanding of Quality Assurance practices and procedures

Environment: Oracle SQL Server, TOAD, MS SQL Server, HP ALM, UFT, Autosys, MS Office, Jira.

Confidential, St. Paul, MN

QA Analyst

Responsibilities:

• Tested the data mart with the help of data mapping document for various data feeds. Involved in daily Scrum meetings (Agile Methodology). Also, involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
• Involved in developing detailed Test plan, Test cases and Test procedures. Worked on data migration project and written the Test Plan and Test Cases.
• Used Informatica Power Center 9.0.1 as an ETL Tool for extraction, transformation, and loading (ETL) of data into the Enterprise Data Ware House (EDW).
• Responsible for testing Micro Strategy Reports by running the SQL Queries on the database by reviewing the report requirement documentation.
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Extensively used SQL programming in backend functions, procedures, packages to implement business rules and security
• Involved in Manual and Automated testing using Microsoft Test Manager.
• Tested Micro strategy reports to check whether they are generated as per the company standards.
• Involved in running test cases and documenting the logs and results.
• Sending weekly migration phase reports to higher management and keeping them with up-to-date information with the migration process.
• Defects were Tracked, Reviewed, and Analyzed using Jira.

Environment: Oracle 10g, Flat files, Control-M, TFS, Agile, SQL, MS Office, Visio, Shell Scripts, CSV Files.

Confidential, Wilmington, DE

ETL QA Tester

Responsibilities:

• Tested the data warehouse with the help of data mapping document for various data feeds.
• Created test case scenarios, executed test cases, and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Coordinated between offshore and onsite team and managed the entire project for testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive data validations against Data Warehouse
• Logging and tracking defects on a release basis using HP Quality Center. Tested several Informatica Mappings to validate the business conditions
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Involved in validating SSIS and SSRS packages per data mapping specifications.
• Did extensive work with ETL testing including strategies like Data Completeness, Data Transformation & Data Quality for various data feeds coming from different source systems.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested Business Objects reports and written test cases using HP Quality Center.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting. Conditional testing of constraints based on the business rules.
• Designed and prepared scripts to monitor uptime/downtime of different system components

Environment: Informatica 8.6.1, SSIS, XML, XSLT, PERL, Business Objects XIR3, SQL Server 2008, QTP, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10g, PL/SQL, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Providence RI

ETL QA Tester

Responsibilities:

• Analyzed the existing system and process gaps in context of new conversion of Flagstar and bank changes.
• Conducted JAD sessions with management, SME’s, Business users and other stakeholders for open and pending issues to develop specifications.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Written SQL queries manually and built SQL queries using TOAD to validate the Customers ' addresses and accounts level data.
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Used Quality Center as repository for maintaining test cases, UAT test plans and tracking the defects.
• Created Recovery Files using Recovery Scenario Manager, associated the recovery scenarios to tests to instruct QTP with specified trigger action on unexpected event/popup.
• Experienced in creating the SSIS packages, DTS packages.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF, and many other. Tested OLAP cubes and SSAS reports for various business needs
• Extracted data from various sources like flat files and SQL Server. Ensured that migrated data is complete, accurate and correct from Oracle database.
• Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, XML files) before loading into target database
• Agile Methodologies. Experienced in the use of Agile approaches, including Extreme Programming, Test-Driven Development, and Scrum.
• Performed manual back end testing while retrieving the data from the Oracle database for financial applications like DDA, SVG, IRA, CDS, and DCA.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Tested Designed and Developed OLAP Cubes using SSAS.
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Followed up with standard application testing process to perform different types of testing phase for the FLAGSTAR and RBCB projects.

Environment: SSIS, SSRS, SSAS, SQL Server, SQL, TOAD, Quality Center, MS Office 2007, Oracle 10g, Windows XP/2003, UAT, QTP, Agile, Ration Tools, Clear Quest, VB Script, Excel.

Confidential, CA

QA Analyst Tester

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios, and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards.
• Perform manual testing and created various test results to track the testing results.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Tested and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Worked in a team adopting Agile software development methodology
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: SSIS, SSRS, SSAS, SQL Server, Quality Center 9.2, QTP, XML, HTML Oracle, SQL, ALM, TOAD, Agile, Windows 2003/2007, UNIX.