SUMMARY:

• Around 6+ years of professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Enterprise Data Warehousing (EDW), Data Mart, Databases, Web services and Client - Server applications.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participated in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.
• As an ETL Tester, I am responsible for understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Worked with Business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.
• Wrote complex SQL and PL/SQL queries to validate Data Mart and Data warehouse Testing.
• Worked with different RDBMS Oracle, SQL Server, Teradata, MySQL, and their GUI utilities like SQL Loader, Oracle SQL developer, Teradata SQL Assistant, Win SQL to do transaction of data.
• Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, AbInitio, SSIS as well as many reports developed used various BI tools includes Business Objects, Micro strategy, OBIEE, SSRS and Crystal Reports
• Strong ability in developing advanced 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.
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using Oracle, SQL Server and DB2.
• Working knowledge on various types of data feeds like: XML, DB2, Oracle and Flat files.
• Hands-on experience using defect Management Tools Quality Center, HP-ALM and Jira.
• Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, My SQL, MS SQL Server, Teradata V2R5, V12, V13

Programming Languages: C#, C++, SQL & PL/SQL

Web Technologies: HTML, CSS, XML, AJAX

Scripting Languages: PL/SQL, ASP, VB Script, VBA, Shell Script

Web / Application Server: Apache Tomcat, Apache POI, Web Sphere

Version Control: Perforce, Subversion, TFS

CI Tools: Jenkins, Hudson, Cruise Control

IDE: Eclipse, Net Beans, Visual Studio

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Operating Systems: MS Windows (95/98/NT/2000/XP,7), UNIX (Solaris), Linux

Data Warehouse tools: Data warehouse ETL Tools Informatica9.6, Data Stage 8.5, Ab Initio

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

ETL Tester/QA Analyst

Responsibilities -

• Creating test queries to validate structure of the tables, data in the tables, constraints in the tables in the staging and operational tables; looking for duplicates of an identifier; counts of records on source and target tables. Checking for Data types and data sizes as per STM.
• Working on HP ALM which is a Quality center tool to run the test cases and comparing expected and actual results. Then raising defects in case of any test case fail.
• Documenting test plan, test strategy for end to end testing and test scenarios based on business requirements.
• Writing SQL scripts to do manual testing and also adding and Deleting Data in the Front end in order to Validate.
• Involved in Data validation, Data scrubbing, Data cleansing for Data coming from sources during Data migration/conversion.
• Documenting testing document with results and screenshots of results.
• Testing the front end data with staging and operational tables.
• Participating in defect triage meetings to work closely with developers to inform them about defects. Experience in defect management cycle.
• Participating in daily standups or scrum meetings to talk about daily tasks and status.

Confidential, Aliso Viejo, CA

DWH/ETL Tester

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Responsible for writing programs for testing data as well as develop business enterprise data warehouse application
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Hands on experience using bug tracking tool Quality Center, and Jira
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.
• Tested source data for data completeness, data correctness and data integrity.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Enterprise Data Warehousing and Data Mart Staging Tables.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Technologies: Data warehouse ETL Informatica 8.6, Business Objects, SQL, PL/SQLEDI, HP Quality Center 9.2, XML, Oracle 10g, QTP, ALM, SOAP UI, JavaScript and TOAD for Oracle

Confidential

ETL Tester/Quality Analyst

Responsibilities:

• Providing test execution (system level) for Legacy applications in a FDA regulated Pharmaceutical environment.
• Review project goals, current and future state systems and existing test plans, artifacts, and ideas.
• Perform manual test script execution, defect reporting, and create test summary report.
• Create and maintain test traceability matrix.
• Provide testing status on all activities including participating in defect and team meeting utilization of expertise in Pharmaceutical Sciences to ensure data consistency and validity across all clinical reporting platforms, timely and accurate project plans incorporating all significant project variables.
• Independently generate test data to trigger each validation as defined in the data validation plan.
• Ability to create knowledge to train others, ensure consistency, reliability and reproducibility of results.
• Assisted in maintenance and updates of documents after application and business changes occurred.
• Analyze projects and quantify them into tasks and to determine scripting based on the business requirements.
• Focused on understanding and documenting system requirements to be tested in a regulated environment.
• Analyze functional requirements to derive additional requirements.
• Performed testing on PL/SQL stored procedures and developed complex SQL queries for data testing.
• Involved in functional, integration, performance, end to end and regression testing, in creating manual and automated test scripts.
• Reported bugs through HP Quality Center and prepared bug status reports.
• Involved in developing UNIX and VB scripts for testing and documented complete software testing process.

Technologies: Ab Initio, Oracle 10g, Quality Center 10.0, UNIX and Autosys