SUMMARY:

• Lead QA Analyst consultant with 8 years of experience in Information Technology field with strong experience as Quality Analyst (Tester) in ETL Testing FunctionalTesting, Automation Testing using various testing methodology like waterfall Model, and AgileModel.
• Experience in UNIX and SQL commands.
• Experience includes Automation using selenium and Agile Testing (Sprint, Backlog, Scrum board maintain).
• Experience in designing, documenting, and executing Risk Analysis, Project Plan, Test plans, Test Scenarios, Test cases bug reporting.
• Experience in creating project related various Matrices to ensure the process.
• Proficiency in ETL/Database Testing specifically in developing and executing SQL queries to interact with databases like Oracle 11g, Teradata, DB2, and SQL SERVER.
• Experience in UNIX scripting, job scheduling tool UC4.
• Expertise in use of Quality Center ALM (QC) for writing test cases, test execution, defect management (using Jira), defect tracking and Bug Reporting.
• Experience with version control, configuration management and change control procedures using tools such as VSS, SharePoint.
• Experience in various ETL tools like informatics, Action,AbInitio.
• Experience in testing Big data tool like Splunk.
• Experience with reporting tool OBIEE.
• Experience in FIXML trading messages.
• Experience in onshore offshore model and client interaction.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

ETL QA Analyst

Responsibilities:

• Responsible for reviewing Requirement Specifications and Mapping Document.
• Responsible for creating the Test Plan, Test case preparation, execution of test cases.
• Tested and Automated Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart using AbInitio.
• Performed GUI, Functional, Regression and compatibility Testing.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.
• Tested reports using OBIEE.

Skills: Linux, Windows 7, Informatica, Teradata, SharePoint server, Jira, Rally, OBIEE

Confidential, Fairfield, Virginia

Lead ETL QA Analyst (offshore)

Responsibilities:

• Responsible for reviewing Requirement Specifications and Mapping Document.
• Responsible for creating the Test Plan, Test case preparation, execution of test cases.
• Tested and Automated Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart using AbInitio.
• Performed GUI, Functional, Regression and compatibility Testing.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.
• Tested reports using OBIEE.

Skills: Linux, Windows 7, AbInitio, Teradata, Jira, SharePoint server, Rally, OBIEE

Confidential

Lead Consultant

Responsibilities:

• Responsible for reviewing Requirement Specifications and Design Documents.
• Responsible for creating inbound message FIXML for trade posting.
• Developed and Tested Various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottlenecks at sources, targets, mappings, and sessions and employed required measures.
• Used Toad and SQLPlus for execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested data marts; tested the security levels and granting of appropriate roles.
• Tested Informatics folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart and feeder systems in the aggregation effort.
• Involved in Test Case Design with respect to Test Plan.
• Involved in Test Execution and Bug Reporting using QC.
• Performed GUI, Functional, Regression and compatibility Testing.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.

Skills: Linux, Oracle 11g, UC4 (scheduler), JIRA, SharePoint server, Toad, Informatica 9.5., Splunk

Confidential

Lead Consultant

Responsibilities:

• Understanding the project requirements.
• Interaction with onsite coordinator regarding requirements and scheduling.
• Responsible for web services testing using SOAPUI.
• Responsible for Functional Testing, Regression Testing, Creation of test plan, executing test cases, preparing test summary report.
• Responsible for web testing.

Skills: Linux, Java, Windows, Web server, Eclipse, Quality Center, XML, and Bugzilla

Confidential

QA Analyst

Responsibilities:

• Did a thorough walkthrough of business requirements and prototypes with Business Analysts, Code reviews with development team and got a good grasp of requirements, functionality of the airline system.
• Developed Test plans by coordinating with other team members on the road map.
• Developed test cases by reviewing the requirement documents.
• Mapped the test scripts to the functional requirements in Quality Center 10.0.
• Identified Test Data by querying and created Test scripts for SIT, Regression and UAT
• Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application .
• Execution of Manual Test scripts and responsible to track and log the defects using QC.
• Responsible for data analysis, report validation and functional testing.
• Automation test with Selenium scripts.
• Worked closely with Technical Project Managers and Development Team in defect tracking, re-testing and validation.
• Verified bug fixes and tested all impacted modules in application.
• Coordinating with other team members and providing status to project manager.
• Created UAT documentation to be used by users.
• Ensure Requirements Coverage with Traceability Matrices.

Skills: UNIX, SQL, Oracle, Web Services, SOAP UI, Oracle Quality Center,Jira,QC,Selenium

Confidential

QA Analyst

Responsibilities:

• Responsible for Extraction, Transformation, Loading (ETL) data from various sources into various targets using Informatica Power Center (Repository Manager, Designer, Workflow Manager).
• Responsible for creating Transformations like Sorter, Router, Filter, Joinner, Sequence generator, Aggregator, Expression, Mapplets, Union and lookup in mappings.
• Used text files, relational and XML files as sources and targets.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Responsibility includes development /testing of applications which use integrated database using Informatica.
• Designing, documenting, and executing test plans, test scenarios, test cases& bug tracking tools.

Skills: Mongo dB, Linux Tools - Oracle 11g, Linux, Jira, Quality Center,Informatica.