PROFILE SUMMARY:

• Senior QA Test Architect with 12+yrs of IT Experience in various technologies as Hadoop (Big Data), Cloud (Big Data), Teradata/Oracle/SQL/Netezza/ Confidential (RDBMS), Informatica 9.5.1 (ETL), Data Warehouse, DB, Micro strategy/OBIEE/Tableau/Spotfire (BI Reports), Web Services, Functionality Testing in Data Sourcing and Modeling with CCAR/Retail Credit/Quantitative Risk Technologies, BASEL Compliances and aviation domain exposures
• Managed and Lead a Team of 17 Members (2 - Nearshores (Monterrey - Mexico), 2-Onshores (Charlotte, NC), 13-Offshores(Bangalore/Chennai/Hyderabad))
• Experience in building Testing Center of Excellence in the past and Experience documenting & delivering processes, procedures,, presentations, reports, metrics, etc.
• Provided skills to synthesize requirements and design end to end testing solution considering all parameters while designing solution like infrastructure, technology, process, domain, tools, resource requirements, ROI for the client, test environment requirements, process improvements required and to setup processes to define solid test architecture by analyzing current processes, tools and applications and provide guidance on how to improve them
• Act as a liaison between Business, Project Management, Release Management, Application & Offshore Team. Managed testing and analysis activities, often including requirement and/or specifications management modules to automatically generate requirement test matrices (RTMs), a critical metric to determine the functional coverage of the system under test
• Extensive knowledge in both AGILE (Scrum, Scrum ban, Kanban, Xtreme (Pair) Programming) and Waterfall Testing Models
• Oversees all testing staff and activities for all assigned applications to ensure all testing standards are followed and being met by reviewing all the Project Artifacts
• Serves as an escalation point for issues involving testing
• Serves as a resource and communication point for decisions about test schedule changes
• Define test process including required test activities and deliverables
• Identifies test resources, estimates test effort and defines test schedule and milestones
• Ensures technical resources are organized for effective support of testing
• Develop testing schedule using Work Bench Structure & ensure testers are assigned
• Prepare Test Strategy, Estimations, Test Plans, Test Scenarios, Test Scripts, Defect Root Cause Analysis, Requirement Coverage, Testing Strategies, Impact Assessment, Dashboard Reports, Metrics Report and Status Reports, Release Management Reports, etc and communicate to the QA IT Delivery Lead and Development Team
• Support team to prepare Test Plan/Test Scripts with Business positive/negative scenarios with SQL, Hive, Autosys Validation, Oozie workflow properties, UI and Micro Strategy Reports to test any emergency Releases to deliver within few hours to deliver production deployment
• Involve in gathering Requirements, Analyze the Business requirements, Assess the Source/Stage/Target data and detect issues during Analysis and Testing Phase with SQLs, Big Data-Hive and Micro Strategy/OBIEE/Tableau BI Reports
• Involve in Data Mapping Analysis, Data Gap Analysis, Data Completeness Analysis, Assess the data to determine which data sources are most valuable from the loads of upstream source systems and produce reports, to determine additional data required to accomplish business objectives, etc.
• Worked closely with Development to implement Test Driven Development (TDD) with good knowledge in Behavior Driven Development (BDD) by performing Data Analytical Testing
• Been a part of a Continuous Integration Process team for successful Delivery
• Lead Automation effort to successfully build Automation Framework to execute SQLs in Oracle Platform and to execute Hive Queries through Python, Shell Scripts, Excel, etc. in Cloudera Hadoop (Big Data - HDFS) environment
• Demonstrate the ability to create regression test scripts, execute and validate test results as business processes around the application being decommissioned
• Ensure test environments, applications & tools are available to Test with clear requirements. Support team members in understanding delivery requirements and helping in framing complex issues and queries
• Ensure fast resolution of issues & queries raised by the test team pertaining to the initiative/project
• Track status & Completion of test deliverables using HP Quality Center 11.0 (ALM) and Version One Tools.
• Lead status meets including Defect Management, Process Improvements, Application Knowledge, Gap Analysis.
• Conduct Technical Interviews for internal and external projects to On-board them to various projects

SKILL:

• Functional Test Planning-Preparation-Execution
• Technical Test Planning-Preparation-Execution
• Estimation and Planning
• Business Analysis
• Technical Documentation
• Test Management
• Test Strategy/Test Architect
• Testing Strategy
• HP Software (Mercury) - Quality Center
• Oracle
• SQL (Structured Query Language)
• Banking Fundamentals
• CORE BANKING
• Hadoop
• MicroStrategy
• Oracle-BI (OBIEE Plus)
• Teradata
• Testing for Agile
• Unix Platforms (Linux/AIX/Solaris/Mac OS X/others)
• Mainframe
• XQuery
• SOAP UI
• Selenium

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. QA (ETL) Test Architect & Technical Data Analytics/Strategy Analyst

Responsibilities:

• Oversees all testing staff and activities for all assigned applications
• Ensures all testing standards are followed and being met by reviewing all the Project Artifacts
• Serves as an escalation point for issues involving testing
• Serves as a resource and communication point for decisions about test schedule changes
• Provides weekly status report that includes testing metrics to QA/Dev/Operations Team
• Works with project team to define and create overall strategy and ensures that it is being achieved
• Prepare Test Strategy for Data Analytical Discovery, Technical documents, E2E Testing from Sourcing to Target to build reports, Test Plan, Test Scripts, Entry/Exit Criteria’s, Release Management Reports, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, Impact Assessment Reports, Requirement Coverage Analysis/Report, Gap Analysis Reports, etc.
• Communicates the data/test strategy to the QA IT Delivery Lead and Development Team
• Review and update Test Plans, Reports, Test Scripts and handover the status to the respective Project/Program Managers
• Involve in Data Mapping Analysis, Data Gap Analysis, Data Completeness Analysis, Assess the data to determine which data sources are most valuable from the loads of upstream source systems and produce reports, to determine additional data required to accomplish business objectives, etc.
• Identify and review the additional tables and fields within source systems
• Define test process including required test activities and deliverables
• Identifies test resources, estimates test effort and defines test schedule and milestones
• Ensures technical resources are organized for effective support of testing
• Provide skills to synthesize requirements and design end to end testing solution considering all parameters while designing solution like infrastructure, technology, process, domain, tools, resource requirements, ROI for the client, test environment requirements, process improvements required and to setup processes to define solid test architecture by analyzing current processes, tools and applications and provide guidance on how to improve them
• Vast knowledge in tracking and managing initiatives and reports using HP Quality Center 11.0, ALM and Version One
• Involve in ETL based Analytical with Informatica Power Center Designer 9.5.1, Sourcing, Transformational and BI reports testing with respect to AWS Big Data against Oracle data with Micro Strategy Reports. Validate AWS Big Data against Oracle, Transformation between Oracle and Redshift
• Coordinate with all shores and assist in smooth delivery without any slippages to manage Agile Scrum. Manage testing activities, often including requirement and/or specifications management modules to automatically generate requirement test matrices (RTMs), a critical metric to determine the functional coverage of the system under test
• Manage initiatives, follow up with Project managers to track and reports using HP Quality Center 11.0, ALM and VersionOne Track to update the SIT Signoffs, SIT Dates, Status, etc. on daily basis to ensure reflects the project information correctly
• Provide Impact Assessment to update and estimate time/effort estimation for In Scope project (Weekly basis)
• Support team members in understanding delivery requirements and helping in framing complex SQL issues and queries

Technologies: AWS ( Confidential ), Oracle 11G, Informatica Power Center 9.5 (ETL), Micro Strategy BI Reports

Testing Management Tools: HP QC 12.0/ALM and Version One, MS Excel, MS PowerPoint

Technical Tools: Informatica Power Center 9.5 for ETL, Oracle SQL Developer 4.1.5 and Aginity Workbench for Confidential .

Confidential, Charlotte, NC

Sr. Test Lead & QA Architect

Responsibilities:

• Establish TCOE through documenting & delivering processes, procedures,, presentations, reports, metrics
• Provide skills to synthesize requirements and design end to end testing solution considering all parameters while designing solution like infrastructure, technology, process, domain, tools, resource requirements, ROI for the client, test environment requirements, process improvements required and to setup processes to define solid test architecture by analyzing current processes, tools and applications and provide guidance on how to improve them
• Prepare Test Strategy for E2E Testing from Sourcing to Modeling to Reports, Test Plan, Test Scripts Complex SQL or Hive Queries, Entry/Exit Criteria’s, Release Management Reports, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, Impact Assessment Reports, Requirement Coverage Analysis/Report, Gap Analysis Reports, etc
• Vast knowledge in tracking and managing initiatives and reports using HP Quality Center 11.0, ALM and Version One
• Involve in ETL based Sourcing and Modeling testing with respect to Hadoop against Oracle with Micro Strategy Reports. Validate Hadoop data against Oracle, Transformation between Hadoop and Oracle
• Test Architect to build Automation Test Strategy architecture to test Hadoop Data, Oracle Data and their Transformation with the help of Store Procedure/Shell Scripting/Python
• Lead Automation to successfully build Automation to execute SQLs in Oracle Platform and to execute Hive Queries through Python, Shell Scripts, Excel, etc. in Cloudera Hadoop (Big Data - HDFS) environment
• Demonstrated the ability to create, execute and validate results of test scripts created to regression test the business processes around the application being decommissioned
• Worked closely with Development to implement Test Driven Development (TDD) with good knowledge in Behavior Driven Development (BDD)
• Been a part of a team which does Continuous Integration Process for successful Delivery
• Coordinate with all shores and assist in smooth delivery without any slippages to manage Agile Scrum and Xtreme Pair Programming Technologies. Manage testing activities, often including requirement and/or specifications management modules to automatically generate requirement test matrices (RTMs), a critical metric to determine the functional coverage of the system under test
• Review and update Test Plans, Reports, Test Cases and handover the status to the respective Project Managers
• Prepare Test Plan, Test Scenarios with SQL and Hive to test any emergency Releases to deliver within few hours to deliver production deployment
• Follow up with Developers, PM and BA team to clarify on requirements and execution issues
• Follow up with Project managers and Track on QC to update the SIT Signoffs, SIT Dates, Status, etc. on daily basis to ensure QC reflects the project information correctly
• Provide Impact Assessment to update and estimate time/effort estimation for In Scope project (Weekly basis)
• Support team members in understanding delivery requirements and helping in framing complex SQL/Hive issues and queries
• Conduct Interviews for internal and external projects
• Coordinate sessions for team members within organizations on Testing approaches and various scenarios

Technologies: Hadoop (HDFS), Hive, Impala, Autosys, Oozie, Oracle 11G, Unix (Shell Scripting) for ELT/ETL Process and Micro strategy/Tableau BI Reports

Testing Management Tools: HP QC 11.0/ALM and CODE/JIRA/Version One

Technical Tools: TOAD for Oracle/Teradata SQL Assistance, SQL Workbench, SQL Squirrel Client, Tectia SSH Client/WinSCP/Super Putty.

Confidential, Charlotte, NC

Sr. Test Lead

Responsibilities:

• Prepare Test Plan, SQL scripts, Entry/Exit Criteria’s, Release Management Reports, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, Impact Assessment Reports, Requirement Coverage Analysis/Report, etc.
• Prepare Teradata SQLs/HQLs and assist Offshore on complex requirement understanding to prepare various SQLs approaches to test comparing the data between Mainframe, Hadoop and Teradata. Also, to validate the functionalities of OBIEE and data generated by OBIEE BI report
• Coordinate with all shores and assist in smooth delivery without any slippages to manage Waterfall and Agile Scrum Methodologies
• Review and update Test Plans, Reports, Test Cases and handover the status to the respective Project Managers. During stringent timeline prepare Test Plan, Test Cases and execute to finish within timeline
• Follow up with Developers, PM and BA team to clarify on requirements and execution issues
• Follow up with Project managers and Track on QC to update the CIT Signoffs, CIT Dates, Status, etc. n daily basis to ensure QC reflects the project information correctly
• Provide Impact Assessment to update in PIRATE on In Scope project. (Weekly basis)
• Support team members in understanding delivery requirements and helping in framing complex issues and queries
• Conduct Interviews for internal and external projects
• Coordinate sessions for team members within organizations

Technologies: Mainframe, Hadoop (HDFS), Hive, Autosys, Oozie and Teradata.

Testing Management Tools: HP QC 10.0 and JIRA

Technical Tools: Teradata SQL Assistance, SQL Workbench, SQL Squirrel Client, Tectia SSH Client/WinSCP/Supper Putty and QWS3270.

Confidential

Senior Software Engineer

Responsibilities:

• Prepare Test Plan, SQL scripts, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, etc.
• Prepare Oracle SQLs to verify and validate the functionalities of OBIEE in UI and data generated by OBIEE BI report in UI on top of Oracle 10G
• Assist working with all shores and assist in smooth delivery without any slippages to manage Waterfall and Agile Scrum Methodologies
• Support team members in understanding delivery requirements and helping in framing complex issues and queries

Technologies: Oracle 10G, OBIEE 10g.

Testing Management Tools: HP QC 10.0

Technical Tools: TOAD for Oracle.

Confidential

Systems Engineer

Responsibilities:

• Prepare and executed test cases manually
• Reviewing Bugs and Test Cases
• Reporting Bugs
• Prepared test summary reports
• Worked in critical portfolios and executed many scenarios
• Involved in Regression Testing, System Integration Testing
• Responsible to prepare Estimation sheet, WSR and Metrics every month