SUMMARY

• Over 6 Years of IT experience in Data Analysis/ QA Testing/ Batch Testing/ ETL/ DWH/ BI - Reports Testing & Testing of Software systems in Data Warehouse/ Business Intelligence/ Client-Server/ Oracle and Web-based environments in Windows and UNIX platforms.
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, Micro Strategy, including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational Clear Case.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational Clear Quest, Bugzilla.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Have experience in testing reconcile (initial) and delta (daily) ETL loads.
• Have good experience in Data Migration testing and Web Interface testing.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Extensively worked on Batch Scheduling tools Autosys to run and monitor ETL jobs.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

QA/Testing Tools: HP ALM, Quality Center 10.x, 9.x, Test Director, Quick Test Pro (QTP), TFS, Rally, Soap UI, Bugzilla, Rational Clear Quest

Version Control Tools: Rational Clear Case, CVS, Share Point

Requirements Tools: Rational RequisitePro, DOORS

RDBMS (Databases): Oracle 11g/10g/9i/8i, MS SQL Server2008/2005, MS Access, DB2, Teradata

RDBMS Query Tools: SQL*PLUS, Query Analyzer, TOAD, Oracle SQL Developer, SQL Navigator

BI/Reporting Tools: IBM Cognos, Hyperion, Micro Strategy, Business Objects BOXI, OBIEE

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Data Stage, Ab Initio, SSIS

Programming Languages: PL/SQL, C

Scripting Languages: SQL Scripts, UNIX Shell Scripts

Incident Management Tools: Remedy

Operating Systems: Microsoft Windows Family, UNIX - Sun Solaris, HP-UX

MS: Office MS Word, MS Excel, MS PowerPoint, MS Outlook

Scheduling Tools: Autosys, Cron-Tab,Control-M

Other Tools: Putty, Text Pad, CompareIT, SnagIT, WinSCP, Data Flux, GS Data Generator

PROFESSIONAL EXPERIENCE

Confidential, MD

MDM/Etl tester/Data analyst

Responsibilities:

• Developed and maintain the detailed test plan, test procedures and test cases for the current MDM project
• Coordinate the testing cycle with the Business Analyst and Development Teams
• Works alongside MDM Development Team in the maintenance of testing tools and test execution
• Works alongside MDM Development team in achieving defect resolution via test execution and perform testing on the fixed defects.
• Used ALM for writing the test cases and test case execution and documenting the test results
• Written SQLs using joins, sub queries, correlated sub queries, group functions, and analytical functions to validate the data between source and target.
• Ran integrated Informatica workflows to load and test the data into the staging and target tables
• Wrote the mapping specifications for the development team, using the mapping in Informatica designer tool
• Worked on Teradata, SQL Server, Oracle, flat files) into the target Oracle database as per the data models.
• Summarized final Test Summary Results and review with Business and IS in order to obtain approvals
• Used UNIX commands for file management; placing inbound files for ETL and retrieving outbound files and log files from UNIX environment.

Confidential, VA

ETL tester/Data analyst

Responsibilities:

• Performed pre-process validation for existence of specified database objects like tables, views, synonyms and grants for the same to corresponding schema in database.
• Designed & created Master Test Plan based on the BRD and SRS. Also referred Technical Design document, Source to Target Detailed mapping document & Transformation rules document, ER Diagrams to derive test cases for functional testing.
• Extensively used ETL to load data from Mainfram (flat flie) to ODS
• Prepared Test cases and Scripts in Quality center and executed them in test lab module.
• Validated the target table column definition with source column definition (including type and length).
• Involved in verifying the readiness of the system before starting process.
• Involved in creating CR for any type of migration/changes using Remedy.
• Validated database structure with ERD (Entity Relationship Diagram).
• Written SQLs using joins, sub queries, correlated sub queries, group functions, and analytical functions to validate the data between source and target.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Ran the Automation scripts for regression testing of the application
• Wrote complex SQL to test operational database functionality
• Ran the Informatica jobs to load the staging and target table and capture the statistics of the workflows to check and document performance of the data load
• Ran integrated Informatica workflows to load and test the data into the staging and target tables
• Wrote the mapping specifications for the development team, using the mapping in Informatica designer tool
• Worked on Teradata, ETL into the target Oracle database as per the requirements.
• Used the Informatica IDQ tool for performing data quality analysis by creating data profiles and score cards
• Summarized final Test Summary Results and review with Business and IS in order to obtain approvals
• Maintained all documents, SQL scripts, approvals and test results and saved on share point.
• Review daily test status and issue/ defects with the project team and business. Prepare communication and create daily status and defect reports

Environment: Infomatica 9.6.1,Informatica Analyst, Informatica Developer,Putty,Winscp,Mainfram, DBvisualizer, Remedy v7.5, DB2,Oracle, HPALM, Micro strategy, Master data Management(MDM), Informatica MDM,Teradata

Confidential, VA

ETL /Reports data Analyst/ UAT Tester

Responsibilities:

• Analyzed solution architecture and design documents including Source to Target & detail design documents needed for each tracks and plan test design activities.
• Assisted QA Manager in developing test estimation, scope and test plan for testing complete project
• Handled the tasks of explaining scope, criteria and entry/exit strategy and Responsible for driving end-to-end Test scenarios efforts and in identifying test data
• Drafted complex SQL queries and perform allocation testing from front end / user interface
• Extensively written complex SQL for ETL and report testing.
• Kicked-off test cases design session with business, setup working sessions with Business SMEs, to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases, facilitated test cases sessions, identified test coverage and gaps if any as part of the sessions.
• Worked with Infrastructure to define/ redefine what's required from environment as well as data needs perspective for both EDW SIT and UAT environments.
• Reviewed Shakeout test cases from the team and oversee all users has access to the entire databases and OBIEE environment.
• Worked with SIT test team, OBIEE team, Development team and Performance test team in defining, reviewing and addressing issues around test strategy document.
• Reviewed SIT test cases and test scripts, provide feedback and support in terms of testing techniques and test coverage.
• Summarized final Test Summary Results and review with Business and IS in order to obtain approvals
• Maintained all documents, SQL scripts, approvals and test results and saved on share confluence.
• Extensively used JIRA as defect tracking system to log, close and generate reports and tracked through to resolution.
• Validated the data between source and target by using minus quires to data validation .
• Identifying defects and performed root cause analysis by analyzing data quality issues
• Validated List reports, Crosstab reports, Charts, Dash Boards of SSRS reports and SSAS cubes.
• Reviewed the test activities through daily Agile Software development stand-up meetings.
• Used TOAD/SQL Developer to develop and execute test scripts in SQL, to validate the test cases.
• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Heavily involved in testing reports in OBIEE, validated both the custom and ad hoc reports.
• Used TOAD/SQl Developer Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Participated in KT meetings with Business Analysts and SMEs.
• Responsible for documenting the process, issues and lessons learned for future references.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.

Environment: ODI workflow Manger, ODI Data Validation Option (DVO), SQL, PL/SQL, Remedy, DB2, Oracle 11g, Confulence,Jira,TestRail, Web services, API, Soap UI, XML, Putty, Agile, OBIEE, UNIX