EXPERIENCE SUMMARY:

• 11 Years of diverse experience in various phases of Information Technology (Development, Testing and Support). Good experience in Healthcare, Finance, Communication and Insurance domains. Currently working as Big Data Analytics QA Manager - in Cognizant Technology Solutions.
• 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.
• Currently posted at Confidential as Big Data QA Engineer for a project in healthcare domain. From Cognizant standpoint managing a team of 16 members from Chicago, IL
• Self-starter and ability to adapt and learn new things quickly.
• 7.7 years of experience from Cognizant Technology Solutions in Data Warehouse QA function.
• QA Manager and vendor point of contact in Travelers SBIS
• Have been leading a 20 member QA team in a manager role for client COX Communications.
• 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 at level of effort for projects.
• Developed an estimation template, which could be globally used in Data Warehousing Testing Projects.
• Worked at 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 SKILLS:

• Data Warehouse (ETL) and Business Intelligence QA
• Ab-Initio Based Testing
• Oracle SQL/PL-SQL
• Hadoop, Hive QL, Pig scripting, Hbase
• Big Data Testing - Validation of Ingestion and Consumption layers, Audit Balancing.
• UNIX Shell Scripting
• Cognos Reports Testing
• SQL Server
• Teradata SQL
• Oracle Warehouse Builder
• VBA - Excel Macros
• Autosys
• CONTROL - M
• PLSQL-Developer, Toad, Teradata SQL Assistant.
• ORACLE CERTIFIED ASSOCIATE (OCA) for PLSQL
• HP Quality Center
• Rally, Jira
• Oracle Certified Associate (Oracle PLSQL Developer Certified Associate)

PROFESSIONAL EXPERIENCE:

QA Manager

Confidential

Responsibilities:

• As an account point of contact currently managing Big data and Analytics QA sub function of the program.
• Test Lead - Involved as test lead in Agile scrum based projects. Track defects, issues in Jira. Walkthrough test plan, test strategy, test scenarios to key stakeholders.
• Manage customer escalations, issues, risks and cross program dependencies and narrow down to closure.
• Task Delegation and assignments to the team and track the status on daily basis.
• 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.
• Demonstrating continuous improvement plan at engagement level.
• Discuss quarterly governance report with key customer stakeholders.
• Responsible for managing appraisals, goal setting, mid-year performance reviews and performance rating of direct reports.
• Recommend and Justify promotions for direct reports. Persuade Management, set right expectations to aspiring candidates.
• Visa and GC Initiation Approvals - Responsible for providing Manager justification letters for Visa Process Initiation/renewals. Provide GC process initiation approvals.
• Discuss vacation plans of resources with customer. Approve/Reject leave and vacations for team members.
• Involved in decisions on position creation at onshore and offshore.
• Level set customer on need for the position at onshore or offshore.
• Make plans to groom and mentor existing resources by cross training.
• Interview external/internal candidates and decision making to Select/Reject/Defer for other better suitable positions.
• Drive effort estimations at 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.
• Drive capability presentations with customer and client partners.
• Drive RFP(Request for Proposal) responses by coordinating with various portfolios.
• Sense traction and provide strategic guidance to tap new business opportunities within the engagement to meet the annual revenue targets.

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 at 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 Cognizant 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

QA Lead

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 Cognizant 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

Offshore Manager

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

Confidential

Onsite Test Lead

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, Membership, 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.