SUMMARY:

• A Seasoned Lead QA Analyst consultant with 8 years of experience in Information Technology field with strong experience as Quality Analyst (Tester) in ETL Testing Functional Testing, Automation Testing using various testing methodology like waterfall Model, Agile Model,V Model.
• 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, Actian,Ab Initio.
• Experience with reporting tool OBIEE.
• Experience in FIXML trading messages.
• Experience in onshore Confidential model and client interaction.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Individual Contributor

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 ab initio.
• 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, Jira, Rally,OBIEE

Confidential, Virginia

Individual Contributor

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 ab initio.
• 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, Rally,OBIEE

Confidential, Chicago

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 SQL Plus 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.

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, Morgan Texas

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: Mongodb, LinuxTools - Oracle 11g,, Linux, Jira, Quality Center, Informatica