Manjusree Saamavedam

Mobile: 719-***-****

email: ad2j2r@r.postjobfree.com

Around 15 years of total experience in the Information Technology Industry in Testing of GUI and Data warehousing applications.

SUMMARY

Experience in all phases of the Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC).

Experience in working in Agile Scrum and Waterfall project methodologies.

AWS Certification Solutions Architect acquired 2021.

Skilled in Python object-oriented programming.

Expert in writing complex SQL Queries and PL SQL procedures hands on experience in running jobs or navigating/checking logs on the UNIX box.

Experience in web applications testing with Selenium IDE and Selenium WebDriver, JUnit, TestNG and Log4j.

Solid Experience in writing test scenarios using Selenium and Cucumber feature files.

Good understanding of data formats such as XML and JSON.

Solid knowledge on Core Java, HTML, CSS, JavaScript, XML, SQL & Hudson/Jenkins.

Experienced in creating, executing tests and generating the test reports using ALM/Quality Center

Experienced in Manual and Automated testing techniques, including Black box, GUI, Functional, Integration, Regression, Back end, Performance and User Acceptance Testing.

In depth knowledge of Testing methodologies, Concepts, Phases, and Types of testing (Black box/White box testing), developing Test Plans, Test Scenarios, Test Cases, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD).

Web services testing experience on SOAP, REST web services with extensive hands-on experience on XML, WSDL/WADL, and Client/Server messaging systems.

Exposure to AWS and Cloud based testing such as S3, SNS, Lambda and DynamoDB.

Hands on experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch of ETL testing.

Experience with Data Modeling, data warehouse, and data lake concepts.

Experience with Snowflake, AWS S3 Storage, and Microsoft SQL Server.

Rest API Automation test experience using POSTMAN and Swagger.

Performance testing experience of the reports using JMeter.

Extensive experience in testing in ETL loads and BI reports to match the existing functionality.

Has worked on different kinds of documentation like High Level, Low Level Design Documents,

User Acceptance Test Scenarios and participated in review meetings for requirement reviews and test case reviews.

SKILL SET

Testing Tools

Selenium, Selenium IDE, Protractor, Cucumber, SOAP UI Pro, Query Surge, QTP

DW Tools

Informatica Power Center 9.X/8.X, Business Objects XI 3.1/XIR2, Cognos 8, Micro strategy 10.1, Big Data, Hadoop, Hive, Impala, Machine Learning

Databases

Oracle 12g/11g, DB2, SQL Server 2005/2000, Teradata V12, DB2, Sybase, MS Access

Data Access Tools

TOAD, Rapid SQL, Oracle SQL Developer

Programming

C, Java, JavaScript, HTML, CSS, TypeScript, Nodejs, Reactjs SQL, PL/SQL, Pig, Sqoop, Hadoop, AWS Lambda, AWS API Gateway

Operating Systems

Windows 10, UNIX, Linux

Methodologies

Waterfall, Agile/Scrum

Defect Tracking tools

HP ALM, JIRA

PROFESSIONAL EXPERIENCE

Blue Cross Blue Shield, Anthem Jul 20 – Till Date

Remote

ETL Test Engineer

Roles & Responsibilities

●Experience in Data Quality testing of the ETL code loaded during the data pulls.

●Data Validation of jobs using Big Data Hadoop technology. Spark and Sqoop ingestion loads have been verified as part of the project functionalities.

●Participated in the Agile software testing process with regular QA meetings to discuss major features of the application, test cases to write and execute.

●Tested ETL loads full load and incremental load for all the data flows between AQ, Raw, Trusted and Publish zones.

●Supported SIT Integration testing tasks in various upstream environments and user enquiries during UAT testing phase.

●Participated in all Agile and scrum review meetings from Requirement Gathering and was responsible for Testing signoff before production.

●Usage of Automation script to validate the DQ checks between source and target tables for testing using Python scripts.

●Working knowledge of AWS technologies such as S3 bucket, EMR and EC2 instances.

●Involved in development tasks for the ETL loads from WH to Report Builder layers.

Blue Cross Blue Shield Jul 16 –Feb 2020

Reston, VA

ETL & Automation Engineer

Roles & Responsibilities

●Worked on PL SQL scripts to generate the test data from various source tables.

●Used ETL code in PL SQL script usage of look up functionalities to generate the data required as per the needs.

●Used Create, Update and delete statements with implicit cursors within the Procedural code.

●Developed feature files from user acceptance from JIRA.

●Generated Java classes from the feature files using Cucumber.

● Used Selenium Web Drivers Firefox, Chrome to instantiate browsers.

● Performed build acceptance testing and smoke testing using Cucumber automation tool.

●Developed BDD (Behavior driven development) based programs using Gherkin for cucumber.

●Performed extensive functional GUI level testing using selenium java and wrote /modified tests

●Developed Selenium test cases in java.

●Developed functional/regression scripts utilizing Gherkin, Cucumber, Java

●Continuous Integrate Selenium Scripts with CI Build tool Jenkins & Maven.

●Worked on new key words used for the Automation framework during framework development.

●Experience in Data Quality testing of the ETL code loaded during the data pulls.

●Data Validation of jobs using Big Data Hadoop technology. Spark and Sqoop ingestion loads have been verified as part of the project functionalities.

●Participated in Agile software testing process with regular QA meetings to discuss major features of the application, test cases to write and execute.

●Tested ETL loads full load and incremental load for all the data flows between AQ, Raw, Trusted and Publish zones.

●Verified Micro Strategy reports and Dashboards for accuracy of dataflow from source to reports and Dashboards.

●Verified data accuracy of data flow from claim forms on the source to reports in end to end testing.

●Validated numerous reports and templates for Claims and Enrollment applications built as per user requirement.

●Supported SIT Integration testing tasks in various upstream environments and user enquiries during UAT testing phase.

●Participated in all Agile and scrum review meetings from Requirement Gathering and was responsible for Testing signoff before production.

●Developed regression suite for validating counts from source to target for Regression testing.

●Performance Testing of reports has been verified during execution.

●Working knowledge of AWS such as S3, SQS, SNS, Lambda, DynamoDB

Environment: PLSQL, Selenium IDE, Selenium Web driver, Cucumber, Java, JavaScript, HTML, CSS, React js, Node js, Maven, Hadoop, Hive, Impala, DB2, Micro Strategy, AWS, S3, Dynamo DB and Lambda, Jenkins, GIT, Agile methodology, Confluence, JIRA, Maven, TestNG

College Board Jan 15 – Jun 16

Reston, Virginia

Sr. Tester (Manual/Automation)

Roles & Responsibilities

●Developed test suites in SOAP UI to test Web Services.

●Tested REST Web Services methods such as GET, POST, PUT and DELETE using POSTMAN

●Used XML and JSON files to test requests and responses in the REST web services.

●Used API test automation to perform and validate test automation of Restful Web Services

●Extensively used complex SQL to verify database integrity for end to end and Webservices

●Tested ETL loads of Informatica from IODS and LIS to APD_STG database for the AP31.

●Validated the XML file generation from AP31 and AP31_Ack file received from ETS.

●Tested the whole flow for the Standard setting feed file (3100-character file) which concatenates the scores from the ETS to the 32 item rubric scores generated in the APD_Stg file.

●Tested CDC loads using Informatica Power Exchange for the loads from ECDB to IODS tables. Both reconcile and CDC workflows have been tested in the release.

●AP Demographics report tested for functional and ad-hoc reports in Cognos.

●Followed agile methodology to deliver the business needs.

●Interacted with Business analysts and Software developers for bug reviews and participated in team meetings.

Environment: Java, Maven, Postman, SOAP UI, Informatica, Data flux, UNIX, Toad, Putty, ClearQuest, Informatica Power exchange, Informatica DVO, Cognos 10.1, Agile methodology, JIRA, REST API Automation.

Freddie Mac Nov 12 – Dec 14

McLean, Virginia

Sr. Tester

Roles & Responsibilities

●Involved in business processes and quality assurance on testing across entire product life cycle stages from requirements to implementation.

●Prepared Test Cases based on the Functional requirements provided by the business.

●Involved in UI testing for the new requirements of a loan file funded in the Selling System

●Validated the data population of attributes from front end to the downstream applications.

●Extensively used SQL queries to validate the data and used UNIX commands on putty to run the jobs, verify the logs and change the parameters in the file.

●Validated the ETL business logic for the data flowing from Selling to SOR and SOR to CDW.

●Validated the TDQ reports and BOXI reports as part of the release.

●Experienced with testing at different levels of testing like unit, functional, integration, system, load and performance and end to end testing.

Environment: DataStage, UNIX, HP ALM, SQL, BOXI

Mahindra Satyam Apr 05 – Oct 09

BI/ETL Developer

Roles & Responsibilities

●Trained new hires in the organization on various functionalities of the reports of BOXI and Informatica tools.

● Worked on Proof of Concepts on Business Objects Clustering mechanisms.

● Participated in Requirements review meetings to understand the requirements.

● Participated in requirement review meetings

●Created Standard and Adhoc reports.

●Created Dashboards and Scorecards built on different KPI’s.

●Participated in reports Migration from BO6.5 to BOXIR2 version.

●Created SSIS packages for the data flowing from source to target.

●Verified data accuracy in SSRS reports from the publish layer.

Environment: BOXI 6.5, BOXIR2, Informatica 8.0/9.0, SSIS, SSRS, Oracle 10G/11G, Teradata.

EDUCATION

Master’s in Business Administration

University of Virginia, 2012

Bachelors of Electronics and Communications Engineering

JNTU Hyderabad, India 2005

Contact this candidate