SUMMARY

• Seasoned QA Lead with 11 + years of IT experience
• Consistent Outstanding Appraisal Ratings & 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 teh testing function
• Driving teh enterprise Testing strategy and roadmap for maturity of teh testing function
• Driving tooling, standardization and best practices across people, processes, and technology in teh 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 teh 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 teh 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(Oracle Data Integrater)

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

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

Test Management andDefect Reporting Tools: Trac, Test Link,Test Director, Rational Clear Quest,Rational Quality Manager(RQM), 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

Test Lead

Confidential, IL

Responsibilities:

• Working as Test lead for various data warehousing testing projects which involved understanding teh project charter, requirements, design and communicating expectations to teh team to halp prepare teh Test deliverables
• Identify teh Risks, Issues and Dependencies and documenting in project notes
• Prepare teh Test Strategy, test schedule and plan teh test activities and communicate to teh project and planner
• Oversee teh 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 teh Database client tools to connect to teh 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 halp validate teh data by data comparison
• Adept in writing shell scripts using powerful simple and Compound Unix utilities to automate teh 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 teh team and business partners resulted in quickly gaining respect from teh developers, timely identification of teh defects, finding root cause, appropriate escalation to defect triage team, coordinating between teh developers and halp verify teh 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.
• Coordinated between teh offshore and onsite project team by communicating teh project expectations and constantly monitoring teh offshore deliverables via mails and conference calls
• Proactively provided feedback while reviewing project deliverables to gain insight into teh project scope and objective
• Coordinated with teh Implementation Coordinator and Release coordinator to align/adjust teh test activities to meet teh 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 ++.

Sr. DW Analyst/ETL Tester

Confidential, FL

Responsibilities:

• Responsible for developing software Test Plans, Test Case Design and Test Scripts.
• Participated in all aspects of teh 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 teh basis of using defect reports.
• Conducted Functionality, URL Link Testing and Regression Testing during teh various testing phases of teh application using QTP.
• Analyze teh business and technical specifications and participated in walk-throughs and sign-off meetings.
• Participated in User Acceptance Test (UAT), documented procedures and guiding teh users in verifying various transactions on teh system

Sr. DW Analyst/ETL Tester

Confidential, TN

Responsibilities:

• Involved in writing Test cases and developing Test Plans.
• Developed Functional Test Cases based on teh business specifications.
• Created and Configured Workflows, Work lets, and Sessions to transport teh 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 teh application on different browsers and verified teh links of teh 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.

Sr. DW/ETL Tester

Confidential, MN

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 teh ETL design documents to understand teh business logic.
• Performing Integration testing for all teh Mappings in “Customer Order Tracking(COT) DM” and documenting teh results.
• Performed troubleshooting teh 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 teh data results and documented.
• Prepared Test Plans, Test Scripts, Test cases and executed teh Test cases.
• Involved in Regression, Release and System Integration testing.
• Used Quality Center for teh defect tracking.
• Working with different data sources, like Oracle, Teradata, Flat files, xml files, and handling huge data.

DW Tester/QA Analyst

Confidential, CT

Responsibilities:

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