Test Analyst Resume

SUMMARY:

Over 7+ Years of extensive experience in IT industry with Knowledge of ETL & Big Data testing, Report testing, Automation, Web services and Functional testing.
Experience in designing, documenting, and executing test plan, test strategy, test scenario/scripts & test cases for manual, automated and bug tracking tools.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux, Hadoop Cluster

Languages: SQL, PL/SQL, UNIX Shell Scripting, Core Java, VB Scripting, XML

Testing Tools: HPALM, Selenium, Jenkins, SoapUI, Junit,TestNG

Bug Reporting: HP QC 9.2, Rally, Jira, and TFS

ETL/Scheduling Tools: Abinitio,Informatica Power Center, Data Stage, SSIS,IBM Optim, Control M

Hadoop Ecosystem: HDFS, Hive, Pig, Hbase, Sqoop, Spark SQL, Map Reduce, Hue

Reporting Tools: OBIEE, Business Object, Cognos, POWERVIEW

Web Services/IDE: SOAP, RESTful, Eclipse, SVN

SDLC: Agile, Waterfall, CI/CD, TDD

Testing Methodologies: Black Box testing, White Box testing, Functional testing, System Integration testing, End - to-End Testing, Smoke testing, Regression testing, UAT & performance testing

Domains: Retail, Finance, Healthcare and Banking.

PROFESSIONAL EXPERIENCE:

Confidential, Test Analyst

Responsibilities:

Involved in requirement analysis and understand the criticality of the business from data perspective.
Involved in Agile Scrum meeting/Stand up meeting and updating the status/issues/progress of QA activities.
Creating/reviewing test plan, test strategy, RTM, test plan, test cases using macro and test execution report.
Tested the system by creating, executing and maintaining 200 user stories using rally.
Working in CI/CD environments to deliver the work within given timeframe.
Write complex SQL/stored procedures to validate the transformation & business rules in DWH.
Working in ETL process/Unix Environment/HDFS for loading, processing and validating data files.
Verified data migration by performing database testing using complex quires.
Monitored scheduled ETL interfaces/Control M jobs and debugged failed jobs/Wrapper Scripts.
Involved in importing data from RDBMS to HDFS using Sqoop, writing Hive/Spark sql to load & process data in HDFS. Load and transform large data sets of structured, semi structured and unstructured data.
Validated the Walmart pharmacy application Connexus, Amex Confluence page and McDermott application EBX (MDM) & Ecosys as part of Functional testing.
Validating OBIEE reports against DB, reduced 50 % of time by automating the reports for regression using Selenium.
Reduced 80% of manual effort by automating test cases using java, Selenium WebDriver and TestNG.
Reduced 40% of manual effort by developing a automation framework using shell scripts, VB scripts, stored procedures and Abinitio graph, it has also functionality to generate test summary and validation report.
Reduced 20% of recurring defects by root cause analysis as part of Quality process.
Reduced 8% of recruiting costs by conducting cross team knowledge transfer sessions using confluence.
Perform SIT, UAT and Show & Tell on test results with Business team/Application SME.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship