Data Test Cases

Mary Aruna Gadde. MS. (OCA),CSTE,CSQA

Bentonville 72712

Email: acuroi@r.postjobfree.com

Mob: 302-***-****

MS in Information Quality from University of Arkansas at Little Rock (UALR) 2015 with GPA 4

PG Diploma in Bio-informatics from Michigan Tech University. Msc in MicroBiology

12+ years of QA Experience 5+ yrs of Functional testing 3+ yrs of SQL 1+ yrs of Data Analysis and Profiling 4+ yrs of Data ware house testing 2+ yrs of Selenium 2+ yrs of Web Services Testing 3+ yrs of Mobile IOS testing

Out of 10yrs of IT experience, US experience is for 4+yrs.

Linked In:

https://www.linkedin.com/in/mary-gadde-b190a610b?trk=seokp-title_posts_secondary_cluster_res_author_name

Technical Skills:

Data Analysis, Tableau, Weka, Crawler, Gephi. Selenium on Excel based framework.

Quality Center/HPQC,Java, XML, HTML, TeaLeaf Analytics, Guardian Analytics, API/Webservices testing using SOAP, REST protocols, Selenium, TestNG Framework and Java scripting

Oracle 8i/9i/10g, MS Access, SQL, ALBPM, BODI, Unix Shell Scripting,

Domains worked: Banking, Health care, Mobile IOS, Content Management, Retail marketing.

Work Experience:

Data Analyst/QA Lead

Walmart, Bentonville, AR (Jan’ 2016 – Till date)

Execution on Data Analysis using Hadoop Hive and to verify data migration with transformation rules from Hadoop Hive to SAP Hana staging to target tables. Used Oozie workflow for execution of jobs, Spark framework and Sqoop import/Export.

Projects running on Agile methodology.

Work on Data Analysis, Next generation pricing and EDLP processes on Retail domain.

Data Analyst/QA Lead

Silicon Valley Bank, Santa Clara, CA (Aug’ 2015 – Jan’ 2016)

Involved in Banking Domain testing, Got Banking Domain certificate, efficient in CBS Test bank, BOXI reports and Equitrak tool. Efficient in BEA AquaLogic BPM (ALBPM) and ETL migration and Worked on Equitrak application and BOXI reports, BODI Tool.

Experience in querying databases like Oracle, DB2, Sybase and MS SQL Server to validate reports and troubleshoot data quality issues.

Expertise in Analysis of Business Requirements and reviewing Software Requirements Specifications document (SRS), Mapping Specification Document and in writing Test Plan, Test Strategy, Exit/Acceptance Criteria Document, Requirements Traceability Matrix, Test Execution Matrix, Test Cases, Technical Design Document and Mapping Specification Document.

Experience in creating and Testing BI reports using Cognos.

Test Lead/ETL QA Analyst

Protech Solutions, Little Rock, AR (Mar’ 2015 - July’ 2015)

Expertize in ensuring data integrity during Data Conversion, Data Cleansing and Data Migration from legacy systems using complex SQL queries with analytic functions, collections and PL/SQL.

Strong in writing SQL Queries and experience in High Performance Cloud Computing and ECL Language which uses Data warehouse Concept.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch

Information Quality program gave me an opportunity to work on entire BI lifecycle: Data Modeling, Data Integration, Data Measurement, Data Validation

To conduct ad-hoc data analysis on large datasets from multiple data sources to provide data insights and actionable advice to support business leaders according to self-service BI goals.

MS in Information Quality, UALR (Jan’ 2014 – May’ 2015)

Extensively used Excel, SQL, T-SQL and My SQL. Effective on IQ software tools, techniques, and prototypes are currently used in industry, government, and research laboratories.

Worked on tools like Tableau, Weka, Data collection tools like Crawler, Visualization tools Gephi.

Associate QA Manager, Alliance, Hyderabad

CardioNet Mobile, Malvern, PA (Jul' 2012 - Dec' 2013)

Involved in Mobile testing IOS testing on ipad and iphone and Usability Testing in Health Care domain.

Used Agile methodology and was involved in the entire software development Life Cycle of the project from Initiation to Implementation, Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.

Worked on Selenium excel based framework and TestNg framework using Java language.

Test Lead

Centeon, New Jersey, NJ (Aug' 2010 – Jul’ 2012)

Involved in Webservices testing using SoapUI and SoapUI Pro.

Worked on SOAP (Simple Object Access Protocol) and REST (Representational State Transfer architecture) for Webservices.

Worked on I18N, L10N and on Security Testing for Web-based Applications.

Module Lead

Silicon Valley Bank, Santa Clara, CA (Oct' 2007 - Aug’ 2010)

Worked on informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator etc.

Verified Informatica Workflow Monitor for status of the workflow, session statistics (count of records loaded/rejected into each Target table/file).

Involved in testing the XML files and checked whether data is parsed and loaded into staging tables.

Verified Data Integrity and performed Data Validation for the data flow from Source to Staging, Staging to ODS (Operational Data Store) and ODS to Data Warehouse.

Sr. Quality Assurance Engineer, Virtusa, Hyderabad

OpenPages, Waltham, Boston (Aug' 2005 - May’ 2007)

Coordinating and helping the development team in bug fixing. Involved in Bug review Meetings and participated in Audit. Involved in Installation Testing and Functional Testing.

Worked on Application servers (Bea WebLogic and WebSphere) and on Command Center installations

Worked on Cognos Report Net and Command Center installations

Ocimum Biosolutions, Hyderabad, India

Pharmacogenomics, Montreal, Canada (Mar’ 2003- Jul' 2005)

Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.

Used Quality Center to track and report system defects.

Scheduled Review meetings to discuss Test Plans, Test Cases and Test Results.

Tested the Informatica workflows/sessions to extract, transform and load the data into Target.

Ensured the execution of UAT test cases and documentation of test results.

Provided UAT testing status information to the quality assurance lead, project manager, and various business stakeholders.

Generating TestScripts by using Rational Functional Tester.

Contact this candidate