SUMMARY:

• Seasoned QA Lead with 11 + years of IT experience
• Consistent Outstanding Appraisal Ratings & amp feedbacks for outstanding contributions to Project Deliverables
• Gather client business requirements, understand functional specification document for application development, maintenance or enhancements and prepare test document for testing
• Test strategy, Planning and Estimation
• Proactive planning, budgeting and growth of the testing function
• Driving the enterprise Testing strategy and roadmap for maturity of the testing function
• Driving tooling, standardization and best practices across people, processes, and technology in the testing space
• Improved efficiency and reduced test cycle by increasing automated test script execution by 70%.
• Provided leadership and supervisory oversight to quality assurance
• Built testing road map for projects under the Data Analytics & Big Data portfolio.
• Manage and co - ordinate Unit, Integration, System, Regression testing, UAT and Deployment support for implementations
• Identify, manage, report and escalate program level testing risks and issues
• Subject Matter Expert (SME) for the CCC project (Customer Care Center) for Sales (Auto, Fire, and Life) System, Bank, Customer Care Service, Internet Service, Personal lines, Business Lines, Payment and plan. Facilitate Joint Application Development (JAD) sessions with client and business users, management, development team, users and other stakeholders to refine functional requirements.
• Coordinate & collaborate with other developers and testers to develop, test and implement application features or requirements
• Manage onsite QA team members and coordinate with offshore team for project deliverables
• Interaction with business users for requirement clarification and resolution of problems reported
• Conducting defect triage calls and tracking of all defects till closure
• Lead and automated performance and regression test suites
• Working experience in Agile, Waterfall Life cycle models. Used Version One project management.
• Highly motivated, flexible, versatile and team oriented professional, with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux.

Databases: IBM DB2 LUW 11.1, SQL Server, NCluster, PostgreSQL 10.1, Oracle 8i/9i/10g/11g, Teradata v2r5/v2r6

Languages: Linux/Unix Shell Scripting, SQL, Scala, JAVA, C++

ETL Tools: Informatica 7.x, 8.x, ODI

OLAP Tools: Business Objects XI, Cognos, QlikView, Tableau

Big Data Hadoop Eco System: Spark, Flume, Kafka, Hue, Impala, Hbase,Hive,Ozzie

Test Management andDefect Reporting Tools: Trac, Test Link,Test Director, Rational Clear Quest, HP Quality Center(ALM).

Functional Testing Tools and IDE’s: Selenium, Mercury WinRunner, QTP, Ecplise, Spring Source Tool, IntelliJ

FTP /Database/Design Tools: IBM Data Studio, TOAD 8.x/9.x, SQL Developer, Putty, Ultra Edit, FileZilla

Microsoft tools: Microsoft Access, Excel, OneNote, Outlook, PowerPoint and Microsoft Visio

Performance Tools: HP Load Runner(VUGen) 12.53, HP Performance Center, Analysis tool

Domains worked: Insurance, Retail, Health

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Test Lead

RESPONSIBILITIES:

• Working as Test lead for various data warehousing testing projects which involved understanding the project charter, requirements, design and communicating expectations to the team to help prepare the Test deliverables
• Identify the Risks, Issues and Dependencies and documenting in project notes
• Prepare the Test Strategy, test schedule and plan the test activities and communicate to the project and planner
• Oversee the test script preparation activities, uploading to test link and enforce test entrance and exit criteria
• Monitor Testing Defects for any escalation needs or defect triage procedures
• Worked on databases created for end user reports using facts and dimensions (Dimensional Modeling)
• Experience using the Database client tools to connect to the database for verify and validate data with SQL
• Identified regression test suite for CCC Dashboards application and involved in developing automated scripts using selenium WebDriver.
• Devolved and conducted performance load test scripts using HP Load Runner suite for CCC dashboard application.
• Identified Automation possibilities in Unix with scripts to verify log results and scripts help validate the data by data comparison
• Adept in writing shell scripts using powerful simple and Compound Unix utilities to automate the testing efforts
• Received appreciation from Test/Project Managers for hard work, effort and extremely effective in getting team quickly up to speed, thoroughness and excellent communications with the team and business partners resulted in quickly gaining respect from the developers, timely identification of the defects, finding root cause, appropriate escalation to defect triage team, coordinating between the developers and help verify the fix.
• Experience in working in Data Migration, QlikView Dash board, Cognos Reports, TM1 cube, Adhoc Reporting, BO Crystal reports in projects under BIRA and EPMA
• Experience in working in data movement validation to Hadoop big data environment (Hive, Impala, Spark, Flume, Kafka, HBase, Cassandra, Shell Scripting Etc)
• Coordinated between the offshore and onsite project team by communicating the project expectations and constantly monitoring the offshore deliverables via mails and conference calls
• Proactively provided feedback while reviewing project deliverables to gain insight into the project scope and objective
• Coordinated with the Implementation Coordinator and Release coordinator to align/adjust the test activities to meet the Implementation/Release schedule expectations.

ENVIRONMENT: Agile, Version One, Java, SharePoint, Windows, Informatica, Cognos, TM1, QlikView, XML, VMware, FTP, IBM DB2, Putty, IBM Data Studio, Selenium, Postgres, SQL Server, nCluster, Teradata, Hadoop, Hive, Hue, Hbase, Impala, Flume, Kafka, Spark, Scala, SQL, ETL, Ultra-Edit, Note Pad ++.

Confidential, Jacksonville, FL

Sr. DW Analyst/ETL Tester

RESPONSIBILITIES:

• Responsible for developing software Test Plans, Test Case Design and Test Scripts.
• Participated in all aspects of the software development life cycle.
• Identified and created test data for test execution.
• Performed back-end testing manually by generating SQL queries for System Test Databases.
• Reporting and tracking software defects in HP Quality Centre 9.2(ALM - Application Lifecycle Management) and re-creating them to assist developers for faster resolution.
• Apply technical expertise to organize and implement black-box test efforts and to analyze requirements for software design, development and validation
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Conducted Functionality, URL Link Testing and Regression Testing during the various testing phases of the application using QTP.
• Analyze the business and technical specifications and participated in walk-throughs and sign-off meetings.
• Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various transactions on the system

Confidential, Nashville, TN

Sr. DW Analyst/ETL Tester

RESPONSIBILITIES:

• Involved in writing Test cases and developing Test Plans.
• Developed Functional Test Cases based on the business specifications.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to Confidential using Informatica Workflow Manager.
• Verified Transformation rules in REFORMAT & JOIN components.
• Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing(UAT).
• Tested the application on different browsers and verified the links of the application.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.
• Attended Daily Stand Up meetings, and provide Testing status of assigned work.

Confidential, Rochester, MN

Sr. DW/ETL Tester

RESPONSIBILITIES:

• Performed extensive DATA validation using SQL queries and back-end testing.
• Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.
• Analyzed the ETL design documents to understand the business logic.
• Performing Integration testing for all the Mappings in “Customer Order Tracking(COT) DM” and documenting the results.
• Performed troubleshooting the loading failure cases, including database problems.
• Prepared Functional, scope and ETL mapping documents for COT Data mart.
• Wrote complex SQL queries and Data Mart Staging Tables to validate the data results and documented.
• Prepared Test Plans, Test Scripts, Test cases and executed the Test cases.
• Involved in Regression, Release and System Integration testing.
• Used Quality Center for the defect tracking.
• Working with different data sources, like Oracle, Teradata, Flat files, xml files, and handling huge data.

Confidential, Hartford, CT

DW Tester/QA Analyst

RESPONSIBILITIES:

• Involved in writing Test cases and developing Test Plans.
• Ran the UNIX shell scripts to validate data movement
• Involved in reviewing Business Requirements and Use Cases.
• Tested web applications on different browsers and verified the links of the application.
• Used SQL & PL/SQL to test backend functionality.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.