PROFESSIONAL SUMMARY:

• 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Migration, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling.
• Good working experience on SOAP UI for testing and validating various web services used in the application.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, SSIS, Data Stage and Ab Initio.
• Worked with migration project and migrated the data warehouse form different data sources like Oracle to Teradata, Oracle to Netezza.
• Hands on experience in Data Migration testing and Web Interface testing.
• Good experience in Micro strategy, Cognos Reports and Business Objects testing
• Experience in Financial, Banking, Brokerage, and Securities industries.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Skillful in designing documentations for System, Testing and Auditing.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

TECHNICAL SKILLS:

Testing Tools: Quality Center, Test Director, Win Runner, Quick Test Pro, Load Runner, Rational Clear Quest, Rational Robot

Languages: Java, .NET, XML, HTML, MS SQL, SQL, TSL, Java Script, VB Script

Operating Systems: Windows, UNIX, LINUX

Databases: MS Access, Teradata, SQL Server, Oracle, Sybase, Informix, DB2

ETL Tools: Informatica Power Center, SSIS, Data Stage, Ab Initio

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla, Quality Center

GUI Tools: Soap UI, Visual Basic

BI Tools: Micro strategy, Cognos, Business Objects, Crystal Reports, SSRS, SSAS

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. ETL QA Tester

Responsibilities:

• Responsible for Gathering test requirements and scoping out the test plan.
• Designed and tested UNIX shell scripts as part of the ETL testing process to automate the process of loading, pulling the data for testing ETL loads.
• Profound knowledge of web services testing using Service Oriented Architecture tools SOAP UI.
• Prepared Test Cases for the mappings developed through the ETL tool Data Stage and executed those Test Cases
• Worked on both standard alone and out of box model for OBIEE Implemented Data/Object level security in OBIEE
• Reported bugs and tracked defects using ALM/Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed all aspects of verification, validation including functional, structural, regression, Data Migration, load and system testing.
• Responsible for helping team to setup the OBIEE in Solaris environment.
• Prepared various Data Stage jobs on 8.1 Environment.
• Performed SQL Queries to verify and test data migration.
• Strong knowledge of Software Development Life Cycle (SDLC).
• Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules.
• Participated in Integration, System, Smoke and User Acceptance Testing and production testing using QTP/UFT.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Automated functional, GUI and Regression testing by creating scripts in QTP/UFT.
• Extraction of test data from tables and loading of data into SQL tables.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Tuned OBIEE queries to overcome performance issues
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Experienced in data analysis using SQL, PL/SQL and many other queries-based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Designing test cases and test suites on agile methodology tool JIRA
• Has testing experience in Informatica Power Center and Data stage tool.
• Validated business reporting requirements with internal and external customers.
• Performed Web services testing between and third-party applications using Soap UI.

Environment: Data Migration Testing, Data Stage, SQL, PL/SQL, SDLC, Jira, Agile, Cloud, Soap UI, Teradata 13, Visio, Teradata SQL Assistant, OBIEE, ALM/HP Quality Center 11, QTP/UFT, MS SQL, Oracle, UNIX, TOAD, T-SQL, SQL Server, XML Files, XSD, XML Spy, Flat Files

Confidential, Richmond, VA

Sr. ETL/ DWH/ BI/ QA Tester

Responsibilities:

• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules.
• Creation and execution of test cases on Oracle Reports and OBIEE.
• Involved in preparing Test Plan, writing the Test Cases and defect tracking using JIRA
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Involved in setting up continuous integration system using Jenkins and working knowledge with cloud based code repository system
• Performed front-end testing on OBIEE Executive Dashboard portal
• Created data-driven automation scripts for testing API Web Services using SOAP UI.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Preparing Defect Reports and Test Summary Report documents.
• Prepared Test Cases for the mappings developed through the ETL tool Data Stage and executed those Test Cases
• Developed the Test Plan and Testing Strategy for Data Warehousing projects.
• Used SOAP UI to validate the response of web services with the data in Host.
• Log all the issues discovered during testing in the Issue Tracker using Quality center, Jira and excel.
• Validated Data Stage logic by executing ETL Wrappers and Autosys jobs by using SQL and Unix Shell scripts.
• Conduct Functionality testing during various phases of the application using QTP.
• Involved in interacting Teradata application from Data Stage using Teradata Enterprise, Teradata Multi load and Teradata Connector stages in Data Stage.
• Test cases in ALM and Defect report generation using ALM and Jira.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on Web Services Testing using SOAP UI
• Implemented SDLC, QA methodologies and concepts in the Project
• Worked with ETL group for understanding Data Stage jobs for dimensions and facts
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: OBIEE, Oracle, SQL, PL/SQL, Data Stage, Jira, Quick Test Pro (QTP), Agile, Soap UI, HP Quality Center, Visio, TOAD, Rational Clear Quest, Cloud, Rational Clear Case, MS SQL, SDLC, XML Files, XSD, XML Spy

Confidential, CHARLOTTE, NC

DWH/ SQL Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs for testing the data flow between source and target
• Documented the validation rules, error handling and test strategy of the mapping.
• Informed and get the DBAs' involved in creating the new tables or adding additional columns to the existing ones to cater the data loads during migration.
• Performed Data Centric testing to validate the data that is loaded in to the data warehouse is correct as per the defined business rules.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Performed extensive data validations against Data Warehouse.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Power Center, Data warehouse, Data Migration testing, Soap UI, Windows NT, Agile, Micro Strategy, HP QTP, Oracle, SQL, PL/SQL, T-SQL, SQL Server, PL/SQL, SQL*Plus, Toad, XML, XSD, VSAM Files, MVS, ISFP, Flat Files

Confidential

SQL/ ETL/ BI Tester

Responsibilities:

• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases
• Understood business requirements, and helped re-design the development plan, and designed the data warehouse
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Responsible for extensive data validations on Data warehouse and reports.
• Responsible for testing Business Objects universe and universe enhancements.
• As an ETL/BI Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Data conversions from legacy systems to SQL server Using DTS.
• Created multiple complex queries for the profiling and auditing purposes.
• Optimized, partitioned cubes to speed up report latency and performance optimizations.
• Assisted in Troubleshooting of Report deployment on multiple servers.

Environment: Microsoft SQL Server 2008, Enterprise Manager, Database Transformation Services (DTS), VB Script, T-SQL, SQL Profiler, MS Access, XML, XSLT, XSD