SUMMARY

• About 6 years of experience in Data Analysis, Quality Assurance and Software Testing of various business applications in Client/Server environment sand ETL, Data Warehousing solutions.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Experience on UNIX commands and Shell Scripting.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Very good understanding of Data warehousing concepts.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest.
• Expert in writing complexSQL queries for back - end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

AUTOMATION TOOLS: Quick Test Pro

TEST MANAGEMENT TOOLS: ALM, Quality Center, Test Director, JIRA

SCRIPTING: VBScript, JavaScript, XML, HTML

LANGUAGES: SQL, UNIX command

WORK FLOW TOOLS: MS - Visio, MS - Project, MS - PowerPoint, MS - Word, MS - Excel

DATABASES: MS SQL Server, Oracle

OPERATING SYSTEMS: Windows XP/Vista/7, UNIX

ETL Tool: Informatica Power Center 8.XX/9.XX

PROFESSIONAL EXPERIENCE

Confidential, El Monte, CA

ETL Data Analyst

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases and Test Scripts by analyzing Business requirement documents and Use cases.
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Involved with project backlogs and sprint backlogs.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language
• Involved in test management and defect management using Quality Center and TFS.
• Performed Database (metadata) validation before loading the data into the target tables.
• Created SQL compare statements to validate Actual results with the Expected Results and written complex SQL queries for validating Cognos Reports.
• Trackedand executedtheUser AcceptanceTest Cases (UAT) with respect to the requirements to determine the featurecoverage.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked onAutosysforBatch ProcessingETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Validated the data moving from multiple sources to target using Informatica data validation option.
• Estimated level of effort (LOE) for testing effort and reported to Test Leads.
• Performed Quality Assurance activities for data validation, data scrubbing, data profiling.
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements.
• Ensured quality products delivered and installed as specified in the statement of work (SOW).
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Informatica 9.1, Informatica Data Validation Option (DVO), SQL, PL/SQL, Remedy, DB2, Selenium 2.4, Oracle 11g, TOAD, XML, PuTTy, Quality Center 10, TFS (Team Foundation Server), MS Visual Studio, Cognos 10, Autosys, SQL Server 2008, SSIS, SSRS, SSAS, Windows XP, UNIX.

Confidential, Dallas, TX

BI/ETL/Data Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Presented in stand up meeting, story huddle and other meetings for the updates, suggestion, comments to improve the velocity and refinement in QA Testing Approach
• Prepared Test Cases to validate data from base table to the dataset table.
• Extensively used Micro Strategy, SQL Assistant and edited SQL Query validate and compare the result between the base table to the dataset( report from Micro Strategy ) to run the report .
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• 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 data migration to ensure that integrity of data was not compromised.
• Used Jira as defect tracking tool.
• Involved in data masking.
• Done data validation for the Micro Strategy reports.
• Analysis and data digging using SQL to find root cause of defects
• Prepared showcase to business/ client to make sure test is as per the business requirement
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 8.6, Clear Quest, SQL, UNIX, Session Log files, Flat files, XML files, Teradata, Agile, Compare IT, Jira, Micro Strategy, SQL Assistant.

Confidential, Newark, NJ

Database Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Data Migration and Business Intelligence.
• Prepared Test Cases and Test Strategy for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• 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.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Used HP Quality Center 9.0 as defect tracking tool.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Validated the Acknowledgement files, Negative acknowledgement files, Frequency reports generated by data flux.
• Involved in Smoke and System Testing.
• Done data validation for the OBIEE / Micro Strategy reports.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Analysis and data digging using SQL to find root cause of defects
• Worked effectively to meet the deadlines for each release.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling variousdata cleansingscripts and loading process.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 8.6, Clear Quest, SQL, UNIX, Session Log files, Flat files, XML files, DB2, Agile, Compare IT, OBIEE, SQL Server 2008, and TOAD.

Confidential, Tulsa

BI/Data base Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, 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.
• Extensively ran the Informatica workflows and mappings through workflow monitor, monitored the log files and involved in find the root cause of the failures.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Tested Informatica workflows for various ETL data mapping requirements.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports andSQAReport.
• Involved in validating the data profiling and data analysis performed using data flux.
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively usedRational Clear Questto track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Validated SSIS ETL Packages as per the data mapping requirements.
• Involved in testing SSRS Reports according to report specification documents.
• Extensively involved in testing theETLprocess of data sources, SQL Server, Oracle, flat files into the target file, Oracle database as per the data models.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Informatica 8.1, HP Quality Center, Rational Clear Case, Rational Clear Quest, TOAD, Putty, Oracle 10g, SSIS, SSRS, SQL Server 2005, SQL, Linux

Confidential, Lake Forest, IL

Data base Analyst

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing.
• Performed extensive manual testing on critical functionalities of the application.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Extensive querying using TOAD to run SQL queries and monitor quality & integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.

Environment: Oracle 9i, SQL Server 2005, TOAD, MS Access, MS EXCEL, Mercury Quality Center