SUMMARY:

• Over 9 years of extensive experience in Software Testing in cloud computing, Data Warehousing, Client/Server applications and Web based applications.
• Experience in Data Mining & Big data Analytics.
• Proficient in both Manual and Automated testing using automation tools like UFT and Selenium webdriver to run scripts for Functional and Regression Testing.
• Experience in testing REST Web services.
• Hands - On expert in Test Rail, Jira, Rally, Quality Center & Test Director for writing Test Cases, Test Execution, Defect Management, Defect Tracking and Bug Reporting.
• Experience in Data Warehousing/ETL Testing within the environment of Oracle, SQL Server.
• Have solid experience on database query tools such as SQL Developer and TOAD SQL and SQL Server Management Studio.
• Experience in testing of Data Integrations related to data Warehousing and then toMaster Data Management(MDM).
• Proficient in Back-End/Database Testing, specifically in developing and executing SQL queries to interact with databases.
• Experienced on various marketing applications for providing better reporting purposes like Teradata, Marketo and Salesforce.
• Hand on experience with working on Bigdata technologies like Amazon Redshift, HADOOP and HIVE.
• Experience working on TSV files, loading these files into Tables and validating data.
• Worked with Business Analysist and Functional Team members to translate Business requirements into ETL technical specifications.
• Expert in Database testing including Regression, Integration, System, Performance, Functional and Unit Testing.
• Experience with version control, configuration management and change control procedures.
• Strong knowledge of Software development life Cycle and Software Testing Life Cycle and highly proficient in Waterfall Agile methodology.
• Expertise in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual and automation testing.
• Initiated in writing/running test cases in Stoplight and Postman to test API web services.
• Well versed in writing detailed test cases by utilizing functional & non-functional requirements.
• Helped team in transforming business process requirements into Functional Requirements, Functional Specifications, Business Process Mapping and Modeling for application development.
• Experienced with managing and resolving offshore QA/developer team roadblocks.
• An effective communicator with strong analytical abilities, combined with skills to plan and implement projects and strong aptitude for learning new technologies.
• Ability to work independently as well as within a team environment.
• Experience on working Splunk logs and AWS logs.

TECHNICAL SKILLS:

Project Methodologies: Agile, Scrum, Waterfall.

Testing and bug tracking: Jira,Rally, Mercury Quality Center, Quick Test Pro, SharePoint.

Languages: SQL, HQL, MY SQL, Java, HTML.

Databases: Oracle 8i/9i/11 and SQL Server.

Data warehouse: Hadoop, Amazon Redshift, Hive, Teradata.

Marketing Analytics Tool: Salesforce, Marketo, Qualtrics

Operating System: Windows 98/XP/ 2003/2008, Linux/Unix.

Other Tools: SQL Developer for MySQL, MySQL Workbench TOAD, TERADATA SQL Assistant, Selenium, PUTTY,Swagger,Postman, UFT, Stoplight.

PROFESSIONAL EXPERIENCE

Confidential, San Rafael, CA

QA Engineer

Responsibilities:

• Tested track flow of API calls from different source to target through APIGEE.
• Extensively written SQL to confirm the data transfer from source to target.
• Validated data in Salesforce & Marketo and other marketing tools.
• Tested salesforce standard objects (Campaign, Accounts, Contacts, Opportunity) and custom objects, page layouts, fields validations and its access to the user based on defined profile.
• Validated workflow rules, approval processes, and validation rules, including security and users permission.
• Validated data in Redshift tables by writing SQL queries among different databases.
• Hand on experience on working on Amazon Web Service.
• Experienced in Master Data Management (MDM) testing for source identification, data collection, data transformation, rule administration, data consolidation and data reconciliation.
• Experienced in writing/running queries to Load data and validate data in Linux.
• Testing data consistency and data flow from Redshift tables to Hive tables in SQL server and Linux environment.
• Automated Rest APIs using Rest Assured framework to test Json response by using Json path and code check-in to Gitbucket.
• Experienced in testing REST/SOAP web services through postman, swagger,stoplight and validate data flow.
• Experience in working and writing test cases in stoplight.
• Scheduling and automated jobs to be run in batch process and performed batch testing through AWS and Jenkins.
• Extracted data from various tools like Oracle, CSV files from AWS and FTTP server.
• Performing various type of Functional, Regression and Integration testing.
• Participated and running in regular and QA status meetings involving giving demo to Stake holders.
• Extensively integration with developers, business and various management teams to understand project requirements.
• Using Jira to write Test cases and tracking defects to test data flow.
• Working closely working with external companies to validate data flow and storage.
• Working on different internal applications how data is transformed.
• Experienced with managing and resolving offshore QA/developer team roadblocks.
• Worked with different teams across multiple countries.

Confidential, Santa Monica, CA

Software Quality Analyst

Responsibilities:

• Tested web based application using internal robust automation framework by creating automated scenarios.
• Work on testing CSS based web application across different browsers manually in different cultures.
• Experience inMobile APP testing on Android, iPad and iPhone,Emulator, Simulatorto perform Mobile App testing, phone functionality and native app testing.
• Experienced on creating data pages and spying the objects which are used in scenario through UFT.
• Worked on creating smoke test scripts which run daily to validate nightly builds.
• Worked on frontend UI automation framework along with automating smoke, regression, integration and functional test suites using POM approach, TestNG and Maven and validate data integrity against database’s by creating SQL queries.
• Wrote complex SQL queries to validate accuracy of data in backend SQL server.
• Worked on uploading and deleting dummy data in SQL server to support a customer requirement.
• Validated and parsing of data in locale translation (different culture in backend tables).
• Created regression suites which run biweekly for stage and production deployments for the client bug fixes.
• Actively monitored weekly automated regression scenarios to look for any failures and fix them by updating the automation scripts.
• Continuously worked on testing and resolving client bugs.
• Perform various kinds of testing such as Functional, Integration, End-to-End and system testing.
• Created and document test plans, test cases and register the expected results in Test Rail.
• Worked on defect tool Test Rail for bug tracking, bug reporting, storing and maintaining the test repository.
• Worked closely with other teams to enhance current application for better client satisfaction and help them with automating test scenarios.
• Efficient use of Agile Methodology of Software development with frequently changing requirements and managing several sprint releases. Participated in several sprint releases spread across multiple iterations.
• Participated in daily SCRUM meetings and other Agile ceremonies with team members.

Confidential, San Rafael, CA

Software Quality Analyst

Responsibilities:

• Worked on marketing and analytics reporting data from salesforce and Marketo in agile environment with rapid 2 week sprints.
• Worked with Putty to validate daily Scoop jobs with incremental load to populate Hive tables.
• Worked in Redshift to validate jobs running in Hadoop cluster for successful completion of load data from start to end.
• Validated that consistent, up-to-date data from external TSV files is updated daily into Hive and Redshift for reporting purposes.
• Worked with Filezila to export TSV file from marketo and load to hive staging tables.
• Validated missing data called through Rest API calls from marketo.
• Validated monitoring tables in MySQL Workbench on daily bases.
• Validated Silkview Dashboard was being updated with the daily current data.
• Experienced with cleansing data in staging tables as per business requirements.
• Created test cases, test plans, test data from User stories and reported status ensuring accurate coverage of requirements and business processes.
• Created various test dataset scenarios, uploaded data and validated data as per business request.
• Analyzed business requirements and user stories for creating and executing test cases.
• Performed various kinds of testing such as Functional, Integration, End-to-End and system testing.
• Experienced in writing complex SQL queries to validate accuracy of data both in HIVE and Redshift.
• Created and documented test plans, test cases and registered the expected results in RALLY.
• Used RALLY for bug tracking, bug reporting, storing and maintaining the test repository.
• Reviewed existing test cases with the different kind of source systems for different periods of data.
• Documented some of the recurring defects, their resolutions and business comments.
• Worked closely with offshore teams to validate data for enhancement of current application for better reporting purposes.

Confidential, San Ramon, CA

Quality Analyst

Responsibilities:

• Used OLELOAD to load tables in staging environment.
• Wrote complex SQL queries in Teradata to compare data in core environment.
• Tested data both from TOAD to Teradata by writing SQL queries SQL server.
• Validated 500 tables including 300 tables with data in Sql server.
• Wrote complex and large Scripts in SQL to validate data.
• Created and documented test plans, test cases and registered the expected results in HP Quality Center.
• Used HP Quality Center for bug tracking, bug reporting, storing and maintaining the test repository.
• Documented some of the recurring defects, their resolutions and business comments.

Confidential, San Ramon, CA

QA Analyst

Responsibilities:

• Tested and reviewed ETL mapping document and transformation based on business requirements.
• Performed batch testing which included daily, weekly and monthly load.
• Used TERADATA SQL Assistant to validate data in Teradata.
• Worked on TOAD and SQL Server to validate Data.
• Used HP Quality Center to execute, manage test cases and report bugs.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Validated transformed data in Data Warehouse and Data Marts.
• Created weekly Data Warehouse Quality report for the QA manager.

Confidential, Los Angeles, CA

Quality Analyst

Responsibilities:

• Performed End to End testing starting from validating E&B, creating auths, submitting claims, validating payment and claim status and regression testing.
• Tested 276 EDI transaction for both home and host members to validate various edits at Gateway and NPI scenarios for Prof/Inst 276 transactions.
• Tested Provider and VRU portals and handled different projects (Health care Reform, Upgrade App Retirement etc.)
• Supported the extraction, transformation and load process (ETL) for aData Warehousefrom their legacy systems.
• Retested the existing test cases with different kinds of source systems for different periods of data also with different type of Data like flat files, Excel sheets.
• Data- integritytesting andback-endtesting was performed manually by creating and executing SQL statements.
• Involved in writingSQL queriesandDatabase Checkpointsto verify data quality and calculations.
• Performed data validation testing from source target to destination target by writingSQL queries.
• Manually performed back-end testing on SQL database by writing SQL queries.
• Worked on import /export of Data.
• Developed AutomatedTest Scriptsto perform Functional, Performance, Integration, Stress, System, User Acceptance, Regressionand Volume testing.
• Used Bugzillafor storing, maintaining the test repository, bugtrackingand reporting.
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects