SUMMARY:

• Over 10 years of experience in testing Web - based and Client-Server applications
• Experience in Big data under Amazon Hadoop ecosystem
• Sound knowledge of Waterfall and Agile Software Development and testing Life Cycles (SDLC & STLC)
• Excellent skills developing Test Cases based on requirement documentation
• Experienced in performing Manual and automation testing
• Expert skills in Black Box, Functional, Integration, Regression, System and User Acceptance Testing.
• Strong skills in backend testing using SQL variants
• Experience working under Windows/ UNIX Environments.
• Competent in Troubleshooting and issue resolution
• Quick learner with a strong desire to excel in emerging technologies in the area of testing.
• Highly motivated individual with excellent collaboration skills
• Excellent Interpersonal and Communication skills,

TECHNICAL SKILLS:

Testing Tools: Selenium IDE, Selenium web Driver, Zephyr, Postman, SOAP UI

Defect Tracking Tools: HP ALM, ClearQuest, JIRA, Rally, Team Track

Languages: SQL, JAVA, HTML

GUI: VB 6.0, VB.Net, Oracle Forms

RDBMS: Oracle 9i/10g, SQL Server 2008, MS Access, Postgres

Operating Systems: Windows 7/8, UNIX, Sun Solaris

Development Tools: SQL Developer, PLSQL Developer, Toad, Informatica Data Validation Option (DVO), Microsoft SQL Server Management Studio, DbVisualizer, Apache Sqoop, Hive, Hue

Big Data/Hadoop Ecosystem: Amazon Elastic MapReduce, MySQL, MariaDB, Amazon Redshift, Hadoop, Impala, Amazon S3

Others: MS-Office 2010/13, VMware (Lab Manger), Putty, WinScp, TeliumiQ, Omnibug UDeploy, Confluence, Jenkins, CircleCI, MySQL Workbench, Git, New Relic

WORK EXPERIENCE:

Confidential

Technical tester

Responsibilities:

• Worked on Enterprise data hub big data project as a technical tester on data ingestion, dimension load and fact load testing
• Developed MySQL queries to identify data inconsistencies
• Validated source, staging and target data
• Performed data validation to identify duplicates, attribute changes, nulls and blank
• Validated accuracy of error capturing based on the error rules set.
• Validated audit tables for the data partitioning by daily, monthly and full loads
• Verified JSON files in Amazon S3 file system for the accuracy of data
• Performed data sampling based on data profiling rules defined by architecture team
• Validation fact data loaded against source tables
• Coordinated testing effort with off-shore development and testing teams
• Performed defect tracking, resolution, status reporting
• Validated TTL configuration changes made to New Relic performance management tool
• Validated the application for cross site request forgery vulnerabilities in the code and web services

Environment: Windows 10, Amazon AWS, Hive, Hue, Impala, JSON, S3, Jenkins, JIRA, Confluence, Putty, MySQL, MariaDB, Redshift, My SQL Work bench, Git.

Confidential

Responsibilities:

• Worked on Confidential project where new RESTful web services were added and some of the existing services were enhanced to accommodate the responsive technologies.
• Tested web service layer functionality added to legacy applications like LookingGlass, Group Plan Services, Portfolio Builder, Plan Admin, Advisor Admin.
• Used postman add-on, to test REST http "get, put, post, delete" methods, to validate the data flow between the UI, Web Services and data base.
• Developed SQL queries to validate the data on database side.
• Used SQL extensively to find data for various functionalities of the Application as well as ensuring the right changes are populated correctly after testing the functionality.
• Tested the same functionality on Mobile devices (Responsive code)

Environment: Windows 7, Java, JSON, Oracle, SYBASE, Postman, JIRA, Zephyr, Tealium, Omnibug, Ruby on rails

Confidential

Responsibilities:

• Wrote test cases for various functionalities like Deferrals, Employee Eligibility, Allocations, Investments, Cash Processing, Payroll based on the requirement changes
• Created Plans and loaded them for Plan Express functionality and tested the change for integration with JPM for PartnerLink as well as PSC functionality for different clients
• Tested the Application in various browsers like Firefox and IE and Chrome to check for compatibility
• Created test cases for testing the custom site which was created exclusively for the state of Minnesota.
• Configured the Minnesota site based on the documentation provided.
• Used database extensively to check and delete or add data for the Minnesota site.

Environment: HP ALM 11, MS Excel, MS Word, SQL Developer, Oracle 11g, Oracle Forms, Linux

Confidential

Consumer

Responsibilities:

• Participated in Requirements meetings to learn and understand the new Regulation Requirements.
• Participated in Data Meetings with the Database Architects and developers to understand data and its structure.
• Interacted with the ETL Team to understand the data Mapping as well as the calculations of the various fields that would be on the Mortgage Statement
• Wrote SQL queries based on the Requirements for each field to verify the data, and created tests in DVO to compare each and every target record against data source.
• Account numbers were validated in different applications and databases, against ETL tables and executed the tests on a Monthly basis, revising the queries to validate new issues.

Environment: HP ALM 11, Java, MS Excel, MS Word, SQL Developer, SQL Server Management Studio, Informatica DVO, Oracle 11g, SQL Server 2008/14, CICS, Mobile Devices

Confidential, Broomfield, CO

Responsibilities:

• Participated in the Requirements meetings to understand how the configuration tools interacts with the other Applications
• Analyzed Business Requirements Document and created Test cases for the CRs (Change requests) that come from client
• Worked on Creating and Executing Test cases for several enhancements including ARRA Enhancements to the Application for E-Prescribing
• Interacted with both Business Analysts and Developers to understand HCCT (Horizon Clinical Configuration Tool) and Configure the Application
• Used Oracle SQL developer to create new data and verify the changes to the Application
• Used Putty to run releases and check logs for the errors

Environment: Quality Center 10.0, Rally, .NET, Java, MS Excel, MS Word, Citrix server, Putty, OracleSQL DeveloperFollowing is the summary of projects worked between Oct 2006 to Sep 2011, details of which will be provided upon request.