408-***-****(M)

Neeraja Kothapalli ac1n2l@r.postjobfree.com

Professional Summary

Over 9+ years of IT experience in Web testing, Data Warehouse testing, Business Intelligence and OLAP testing.

4+years of experience as Team Lead for end to end projects. Also managed offshore team.

Well versed writing test plans, Test cases and test scripts.

Exposure to various business sectors like Banking, Retail, University, Gaming and health.

Well versed and experienced in Data warehousing concepts, Dimensional modeling and Hadoop framework.

Experience performing manual testing on web based applications.

Familiarity with testing of media based applications.

Experience in data migration testing from legacy database to current database

Involved in complete testing lifecycle process of data warehousing and BI.

Experience working under both Agile/Scrum and waterfall methodologies.

Used Informatica DVO tool for ETL test automation

Prepared Test Strategy, Test Plans and Test Summary documents for various QA projects.

Extensively worked on writing SQL, PL/SQL stored procedures, functions for backend querying.

Experience validating Data warehouses using design documents

Good experience in Production Support validations, Flat File validation and Troubleshoot/Test issues with existing reports.

Hands on experience with automation, Regression, function Integration and performance testing

Proficiency in backend testing specifically on multiple platforms

Experience with automation using Selenium and Java.

Experience with complete QA defect life cycle from defect logging to verification of fixed bugs and closing.

Experience using HP ALM and Quality Center for test management activities.

Technical Skills

ETL Tools

Informatica 8.x/7.x/6.x versions (Power center/Power Mart), Cognos Data Manager 10, Informatica DVO

Languages

SQL, PL/SQL, C, JAVA, Shell Script, COBOL/COBOL II,MVS/JCL

Database Systems

Oracle 11g/10g/9i/8i, MS Access, SQL server2000/2005, MS-Access

Reporting Tools

ALM -Quality Center, OBIEE 10.1.3, Cognos 10, Test Director, Crystal Reports

Scripting languages

HTML, DHTML, Unix Shell Scripting, TSL and JavaScript

Automation Tools

QTP, Selenium Web Driver

Operating Systems

Windows 98/NT/2000/XP/Vista, MS-DOS, UNIX

Other Tools

WinScp, VEDIT, SQL loader, JIRA, Tidal Enterprise Scheduler, DeNodo

Professional Experience

BANK OF THE WEST, SAN RAMON, CA Dec’2014-Mar’2017

BI Test lead

BOTW is a commercial bank system with various lines of business. I was involved in various projects like Customer Due diligence -KYC, KYA Federal Edit Check and Decommissioning of DataMart, Migration and regional banking group projects along with Vendor company information upgrades.

Responsibilities

Involved in creating Test plans, Test case document and test scripts for various projects.

Gathered requirements, prepared Test Strategy. Was involved in End to End testing on various projects.

Validated Operational Data Store from OLTP system and also from source by importing from file system to database.

Performed sanity checks on source text files to be loaded into stage.

Performed month end checks for various amount columns as part of regression testing

Validated the Dimensions and Facts in Data warehouse for multiple data marts

Created test scripts to validate BI reports

Involved in various types of testing –Regression, functional, Integration testing

Validated source flat files as required.

Used HP ALM QC for test management activities and defect logging.

Used JIRA for tracking production support tickets and validations.

Involved in automation testing using Selenium and designed test cases for the Web driver

Performed Data driven testing, web locators and XPaths validations using Selenium.

Enhanced cross browser testing using Selenium

Used Unix commands to validate source files in Unix environment

Prepared Test Summary reports for weekly status update.

Used Excel and macros for validating production data for data fixes and BAUs.

Environment: Oracle, Selenium, WebLogic, JAVA, HTML, Toad 9.2, Excel, Informatica

NETAPP, Sunnyvale, CA Dec’2012 –Oct’2014

QA Lead

The scope of the project involves system integration testing, support and operations for the Data Warehouse Applications like Oracle RMB. Providing complete technology month end support, expert advice and implementing automation. Also support Database and oracle based Enterprise Data Warehouse data management.

Responsibilities

Provided ETL production validations support for all the finance data fixes as and when required for the Oracle applications (Oracle RMB etc.).

Involved in Functional, System, Regression and Integration Testing.

Coordinated and supported the On-off shore team and delivered projects as per the timelines.

Developed testing solutions by creating test Strategy, test cases and test scripts for Finance, HR and Delivery Partner (Accounts Payable) subject areas.

Used automation tool QTP for regression testing for some activities.

Coordinated testing activities with off shore team to develop Test Cases, Test Scripts.

Involved in preparing / reviewing and executing test cases

Written Complex SQL Scripts for the Data validation assisting the off-shore team.

Used Excel and macros for validating production data for data fixes.

Tracking and reporting of bugs, coordinate with development team in fixing issues

Used ALM for defect logging, tracking and uploading test cases.

Instrumental in validating flat files as part of source validations.

Prepared detailed Test reports on Test execution status, Defect Reports and submitting in Team meetings.

Intimated project status thru Project Summary Reports on a weekly basis.

Environment: Oracle EBS, Oracle Client 11g, Oracle RMB, Toad 9.2, Excel, QTP, Data Stage, OBIEE.

University of California, San Francisco, CA June 2012 – Nov’2012

BI QA Lead

UCSF is a leading medical University dedicated in promoting health worldwide through biomedical research, graduation level education in life sciences and health care and patient services. The Chart of Accounts is providing the basic information structure to UCSF’s financial systems. The COA provides the framework used to budget, record and report all university financial transactions and balances. It identifies details about each financial transaction.

Responsibilities:

Created test cases and Test scenarios as per the requirement for dimensions and fact tables.

Performed regression testing on the existing dimensions and facts after production issues.

Prepared test strategy and developed test cases for testing initiatives.

Developed test scripts for Dimensions and Facts.

Performed Integration testing on the developed Subject Areas.

Created validation scripts to test the source and target data and to check if they are loaded according to the transformation logic.

Involved in validating Cognos reports like detailed, aggregated totals and charts.

Created Inquires to load PS tables into ODS and Data warehouse for use by the reports.

Created source and target definitions, views and stored procedures.

Project was executed under agile methodology. As a team member attended daily scrums and provided updates to Scrum master

Environment: PeopleSoft, SQL, PL/SQL, Oracle 11g, Toad 7.6, Erwin and Windows 7

CHRISTUS Health, Houston, TX July 2010 – May 2012

ETL Tester

Responsibilities:

Created test case scenarios, executed test cases and maintained defects in Remedy and tracked the bugs.

Tested reports using Crystal Reports and ETL mappings from Source to Target

Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application tested mappings.

Performed data validations against Data Warehouse. As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project

Used Tidal Scheduler to validate jobs run successfully.

Environment: SQL server, DB2, TOAD, SAP Business objects, TES, Excel, Windows XP, Crystal Reports

Baxter International Inc. Chicago, IL Jan’09- May 2010

BI Tester

Responsibilities:

Tested reports and ETL mappings from Source to Target using mapping document.

Created test case scenarios, executed test cases.

Maintained, managed test cases in Mercury Quality Center and tracked defects using Rational Clear Quest.

Developed and executed various manual testing scenarios and neatly documented the process to perform Functional of the application.

Involved in testing of Informatica mappings. Performed Data Validation with Data Warehouse.

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL testing and designing of the flow and the logic for the Data warehouse project.

Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Performed testing of mappings, sessions and workflows and created test cases and test scripts.

Environment: Informatica Power Center 6.5, SQL, PL/SQL, Shell scripting, Oracle 9i, Toad 7.6 and Windows 2000, Crystal Reports

Cap Gemini Aug’07- Aug’08

QA Analyst

Worked for clients like AT&T and Royal Caribbean Cruise Lines on multiples roles and activities related ETL development, data modelling and testing

Environment: Informatica 7.1, Oracle 10g, QTP, Toad 8.0, Windows XP, UNIX.

BANDAI/NAMCO Santa Clara, CA Apr’06 – May 2007

QA Analyst

Used PL/SQL code in executing scripts for testing activities.

Tested applications on various platforms.

Environment: Oracle 10g, Toad 8, PL/SQL, OBIEE 10.1.3, Windows NT, SQL SERVER.

Education: Master’s in Computer Applications (M.C.A) from Osmania University.

Contact this candidate