EXPERIENCE SUMMARY:

• 12 Years of diverse experience in various phases of Information Technology (Development, Testing and Support). Good experience in Healthcare, Finance, Communication and Insurance domains.
• Self - motivated, willing to assume responsibilities, a strong team player with great leadership qualities as well as comfortable individual with excellent communication and analytical skills.
• Self-starter and ability to adapt and learn new things quickly.
• 8 years of experience from Confidential Technology Solutions in Data Warehouse QA function.
• A total of 3 years and 3 months of work experience from Convergys Information Management.
• Strong working experience in the data analysis, SQL design and development, implementation and testing of data warehousing using extraction, transformation and loading (ETL) and SQL server and Oracle.
• Worked in lead roles in providing testing solutions like building a regression suite, automation suite, Test data analysis, Requirements Traceability Matrix.
• Proficient in different kind of Manual as well as Automated Testing.
• Good experience in QA phases including preparing Test Plans, writing Test Cases and executing them, performed BUG reporting and tracking using tools like Test Director, Quality Center.
• Extensively worked in UNIX shell scripting in automating various test scenarios
• Extensive experience working in Oracle PL/SQL, Teradata SQL.
• Good experience in the ETL tool Oracle Warehouse Builder.
• Worked on estimations in arriving Confidential level of effort for projects.
• Developed an estimation template, which could be globally used in Data Warehousing Testing Projects.
• Worked Confidential facing Data Quality Audits. Collect Metrics for Planning, Actual metrics, Defect Metrics. Test Case Metrics
• Involved in resource planning, project planning from Kochi Center. Prepare and walkthrough decks for client presentation. Provide case study for every quarter.
• Extensively used Control-M, which manages the data warehouse job, schedules.
• Good experience in performance tuning of Oracle SQL/PLSQL procedures and OWB mappings.

TECHNICAL EXPERTISE:

Data Warehouse (ETL) and Business Intelligence

Oracle SQL/PL-SQL

Big Data - Hadoop, Hive QL, Pig scripting, Hbase, Kafka, Flume, Spark, Yarn, Ambari

Distributions - Hortenworks.

UNIX Shell Scripting

Cognos Reports Testing

SQL Server

Teradata SQL

Oracle Warehouse Builder

VBA - Excel Macros

Autosys

Web Services Testing - Postman

CONTROL - M

PLSQL-Developer, Toad, Teradata SQL Assistant.

ORACLE CERTIFIED ASSOCIATE (OCA) for PLSQL

HP Quality Center

Rally, Jira

PROFESSIONAL EXP ERIENCE:

Confidential, Austin,TX

Big Data QA Lead

Technology: Apache Flume, Kafka, Spark, Cassandra

Responsibilities:

• Big Data QA Cluster Application Support
• Test End to End Integration from Source -> Flume -> Kafka -> Spark -> Cassandra -> Portal
• Provide System Health Report to key stakeholders
• Code deployments into the cluster - Spark, Kafka, Flume
• Deploy Cassandra and Oracle DDL's
• Update configs for Flume, Kafka, Spark Jobs
• Technical Trouble Shooting of Issues in Spark, HDFS, Kafka, Flume and Cassandra clusters
• Ambari Cluster Monitoring.
• Back up, Log and System cleanup
• Automate DevOps Activities - Code deployments, Yarn Cleanup, Zookeeper cleanup

Big Data Test Lead

Confidential

Responsibilities:

• Involved as test lead in Agile scrum based projects. Track defects, issues in Jira. Walkthrough test plan, test strategy, test scenarios to key stakeholders.
• Automate Data Ingestion testing
• Use Pig, Unix Shell Scripting, Hadoop, Hive to automate test cases
• System testing of the Big Data applications
• Test data planning and arrangements
• Test environment planning and arrangements
• End to end testing and regression testing of the application.
• Post production data and functionality validations
• Produce QA deliverables and artifacts.
• Process adherence to ensure SDLC standards

Technology: Hive, Hbase, Teradata, Pig Scripting, Unix Shell Scripting, Hadoop

QA Manager

Confidential, Enfield, CT

Responsibilities:

• Responsible for on time delivery of quality assurance deliverables such as Test Plan, Test Strategy, Test Cases, Test Executions, Defects Summary, Code quality summary, Traceability Matrix etc., from onshore and offshore for Data warehouse and Business Intelligence applications for the entire program.
• Manage customer escalations, issues, risks and cross program dependencies and narrow down to closure.
• Provide overall program delivery status to customer leadership and key stakeholders.
• Involved in key decision making meetings by the customer leadership as a QA manager.
• Drive effort estimations Confidential various confidence levels depending on customer situation. Present and convince customer leadership on the effort estimated for the various projects in the program and seek their approvals.
• Accountable for resource planning across the program for QA business function
• Involved in statement of work (SOW) and summary of engagement finalization, Revenue Forecast and Roadmap Planning of the project.
• Work towards achieving the annual revenue target goals set by the account leadership for the QA sub function
• Manage operations for QA onshore team.
• Periodically review the estimations and resource allocations with customer program managers.

Technology: Teradata SQL, HP Quality Center, QTP, Test Automation Tools, Ab-Initio Based Testing

Onshore DW Test Manager

Confidential

Responsibilities:

• Responsible for overall QA delivery of the project from onshore and offshore.
• Develop Test Automation Strategies along with project delivery activities.
• Conduct mind-sharing sessions and propose quarterly roadmap.
• 1st Escalation point of contact for customers for delivery issues.
• Part of governance and leadership’s calls.
• Manage operations for QA onshore team.
• Work order manager for QA.
• Vendor manager from Confidential side.
• Managing customer expectations and relationships by frequent connects and rendezvous with customer leads and managers.
• Manage appraisals for direct reports.
• Provide overall delivery status to client managers.
• Work on proposals and project forecasting activities.

Technology: Teradata SQL, HP Quality Center, QTP, Test Automation Tools, Ab-Initio Based Testing

Offshore DW QA Lead

Confidential

Responsibilities:

• Responsible for overall QA delivery of the project from onshore and offshore.
• Develop Test Automation Strategies along with project delivery activities.
• Conduct mind-sharing sessions and propose quarterly roadmap.
• 1st Escalation point of contact for customers for delivery issues.
• Part of governance and leadership’s calls.
• Manage operations for QA onshore team.
• Work order manager for QA.
• Vendor manager from Confidential side.
• Managing customer expectations and relationships by frequent connects and rendezvous with customer leads and managers.
• Manage appraisals for direct reports.
• Provide overall delivery status to client managers.
• Work on proposals and project forecasting activities.

Technology: Teradata SQL, HP Quality Center, QTP, Test Automation Tools, Ab-Initio Based Testing

Confidential

DW Proxy Manager and Test Lead

Technology: Oracle SQL, PLSQL, Informatica, OBIEE, Quality Center

Responsibilities:

• Onsite test lead for a 3 member offshore team.
• Preparing test plan, test strategy, Prepare test cases for test execution.
• Coordinate with client SME’s on a daily basis to gather test requirements.
• Analyze the ETL approach and sort out test data requirements
• Organize offshore team meeting for daily status on any defects reported.
• Analyze defects reported by offshore team
• Organize defect triage calls with development team, client SME’s to point out the defects and get it fixed.
• Logging the defect into test director and ensure it is closed.
• After system integration testing, perform release testing to ensure smooth data move into production.
• Test the complete DW system, report bugs.
• Coordination with the development team for the defect fixes

DW Onsite Test Lead

Confidential, Richmond, VA

Technology: Teradata SQL, Test Director, Test Executor

Responsibilities:

• Onsite test lead for a 3 member offshore team.
• Preparing test plan, test strategy, Prepare test cases for test execution.
• Coordinate with client SME’s on a daily basis to gather test requirements.
• Analyze the ETL approach and sort out test data requirements
• Organize offshore team meeting for daily status on any defects reported.
• Analyze defects reported by offshore team
• Organize defect triage calls with development team, client SME’s to point out the defects and get it fixed.
• Logging the defect into test director and ensure it is closed.
• After system integration testing, perform release testing to ensure smooth data move into production.
• Test the complete DW system, report bugs.
• Coordination with the development team for the defect fixes

DW Test Lead

Confidential

Technology: Teradata SQL, Test Director, Test Executor

Responsibilities:

• Communicate with the onsite counterpart in deciding the scope of the issue/enhancements in the ETL code. Get the approach document and tech specifications document.
• Go through the approach document, design document, technical specifications document and mapping document to understand the enhancements/changes.
• Understanding the business aspects of the subject area from the SME’s this included Claims,, Providers and Benefits.
• Relate the business logic with the data model and the mapping logic behind it.
• Sort out the test scenarios and prepare the test scenario document.
• Design and execute Test Plans and Test Cases, generate Test Scripts and Test scenarios
• Performed different kind of testing including Functional, System, Regression and Release Testing.
• Analyze the collateral effects of implementing the enhancement in the subject area on other subject areas
• Analyze the collateral effects of implementing the enhancement in the table on other tables of the same subject area.
• Performed post production validation after successful implementation in production.
• Communicate with the development team for code level details on the fix.
• Communicate the defects to the development team and retest the fix.
• Document the test results with high level of clarity to a common repository.

DW Test Lead

Confidential

Technology: Teradata SQL, Unix Shell Scripting

Responsibilities:

• Communicate with the onsite counterpart in deciding the scope of the issue/enhancements in the ETL code. Get the approach document and tech specifications document.
• Go through the Business/Technical Requirements document, design document, technical specifications document and mapping document to understand complete ETL flow of the project.
• Understanding the business aspects of the subject area from the subject matter experts.
• Highlighted design level issue’s in the data model to the onsite counterpart.
• Relate the business logic with the data model and the mapping logic behind it.
• Sort out the test scenarios and prepare the test scenario document.
• Create test data with all the scenarios included in it including positive and negative scenarios.
• Design and execute Test Plans and Test Cases, generate Test Scripts and Test scenarios.
• Automated critical test cases which involve manual effort using UNIX shell scripting.
• Automated testing of CMS RAPS Return and Encounter EBCIDIC format file in UNIX shell scripting.
• Performed different kind of testing including Functional, System, Regression and Release Testing.
• Performed informatica workflow testing and analyzed the logs.
• Performed post production validation after successful implementation in production.
• Communicate with the development team for code level details on the fix.
• Communicate the defects to the development team and retest the fix.
• Document the test results with high level of clarity to a common repository.