Data Warehouse Testing & ETL Automation Expert

Saritha Madduru

Email:*********@*****.***

Phno:1-913-***-****

Summary

Over 19 years of diversified experience in System Analysis, Design, Development, Quality Assurance and Quality control - testing of Web based and Client/Server applications like Data Warehousing, Client Server and Web applications on Windows and Unix environments, sound knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing. Strong technical Expert in data migration and transformations using Informatica Power Center and in Data warehouse testing and database programming.

Education

Master of Computer Applications 1997-2000, Bharathi Dasan University ( India)

Bachelor of Computer Science and Engineering 1992-1995, Osmania University (India)

Certification:

Tricentis Tosca Fundamentals − Automating web application testing (AS1)

Tricentis Issued Jun 2024 Credential ID 8chjnsxsj48t

Tricentis Tosca Fundamentals − Optimizing test automation with centralized test data (AS2) Tricentis Issued Jun 2024 Credential ID 6fa85wbswj3d

Excellent skills in Automation and Manual testing of Web and Client Server applications, expertise in ETL testing using dataware house tools like Informatica, Backend testing using Oracle, TOAD and SQL Server databases.

Experience in development and execution of customer driven test cases to support unit, functional, regression, web services, performance, integration, security and system level testing. Backend and Black Box testing, Gray Box Testing, White Box testing, User Acceptance Test (UAT) for Web and Client/Server Applications. Expertise in creating and delivering the Test Strategy, Test Plan, Requirement Traceability Matrix according to Business specifications and design documents. Experience in designing test cases, developing and maintaining test scripts, analyzing defects and interacting with the development team members in fixing the defects.

Ability to clearly and concisely document testing issues and facilitates resolution for failures.

Specialization includes Integration, GUI, Functionality, Reliability, Regression, User Acceptance testing, Performance, Load, Stress and Configuration Testing.

Experience with QTP, Win Runner, Load Runner, Quality Center and HP ALM testing software tools.

Expertise in Problem solving and defect tracking Tools like Rational Clear Quest and Test Director,HP Service Desk, Change Synergy, HP ITSM.

Very Strong experience in Data Validation/Data base/Backend testing using SQL Queries and Stored Procedures using ORACLE and TOAD.

Technology Lead at Infosys Jun-21-Aug-26 Led end to end test planning and execution for various projects for Client Tmobile, involved in migration projects,Financial Application testing thourgh various

systems SAP, ORACLE and Customer Support Systems

Developed and implemented test strategies aligned with project requirements

Coordinated cross functional test activities between development, QA, and operations teams, reducing post deployment issues Coordinated cross functional test activities between development, QA, and operations teams, reducing post deployment issues

Authored and maintained comprehensive test documentation (test plans, test cases, traceability matrices) to support audit readiness and knowledge transfer.

Introduced automated testing frameworks that cut regression testing time

Monitored and reported test progress to stakeholders, providing actionable insights that informed go/no go release decisions.

Mentored junior testers in best practices for test design, execution, and defect reporting, improving team efficiency

Handled multiple projects with various client like Costco, Bright Star, Fedex and UPS

Executed daily test cases on TMO financial data in SAP ECC and SAP PDM server

Sr.Quality Assurance Analyst at HOME CREDIT US(Jan’19-Jan’20) Testing activities and coordination with off shore team, Automation along with ETL testing, and handling data between mainframes and data ware house process in maintaining the customer information for the required projects, mostly ETL data load in CLOVER and again generating the required reports for business.)

Involved in Testcase maintenance and agile methodologies in Jira

Involved in various CLOVER ETL testing along with First Data and Sales force

Involved in functional, integration, regression and automation testing

Sr.Quality Assurance Analyst at NIC(Oct’16-Sept’18)

Led Testing Analyst with entire web application, admin module and the mobile app testing for the product developed in .net using azure, involved in various mobile app testing for Android and IOS devices, cross browser testing, 508 compliance testing, also involved in automation using Selenium

Involved in Testcase maintenance and agile and Kanaban methodologies in Jira

Involved in various device IOS and Android testing including iwatch and apple tv

Involved in functional, integration, regression and automation testing

Sr.QualT ity Assurance Lead at Greatwest Financial Services(Mar’15 – Oct’16)

Led Testing Analyst for Partcipant Web application mostly for Registration and Transactional services modules which deals with PARTCIAPANT and Plan information these modules are called New Gen Website which includes all Best of The Best features for Integration Project, which delivers the best user experience in the industry and provide a platform for existing and future on going innovation in products and services, the websites include Life Income Analysis tool called LIAT and many other helpful features for both participants and plan sponsors.

Involved in gathering business requirements, planning and executing the test cases using ALM, JIRA and 508 compliance accessibility testing

Sr.Quality Assurance Analyst at Booz Allen Hamilton : Dept of Agriculuture (Jan’15 – Mar’15): Involved in testing federal sites for Agricultural department which involves many modules from database and SOAP services and also Generated the test status executive reports in ALM and actively involved with team daily status call to track the project progress pre deployment tasks and follow up with post deployment issues and tracking all of the issues occurred.

Sr.Quality Assurance Analyst at Sprint Nextel Overland Park(Jul’08– Dec’14)

Involved in supporting the application supply chain model(I2S) and MDS(Master Data Source) application.

MasterDataSource Upgrade(July’13-Nov’14): This application is the main source of data to the downstream sales channels developed in AIX environment and the application interface is developed using ABPP,Oracle, Informatica with IBM Websphere.

Roles: Actively involved in test case creation load in ALM excecuting testing and implementing the application master data source with all other interfaces and sending the data updates to the downstream using JDA ABPP model, responsible in installing informatica and working along with DBAs to felicitate the oracle upgrade from 9i to 11g.

Involved in all the quality assurance phases of Software Testing Life Cycle (STLC), requirement review sessions, design reviews, analyzed the business requirements, created test cases and test data by studying and analyzing functional and system requirements documents, reviewing test cases with Developers / Business Analysts and modifying the test cases as per their suggestions by interacting with DBA,SA and code migration teams from delivering code to deploying the code from testing to production

Created our own test data to test Informatica workflows and to load in the test environment by querying the data using TOAD and SQL Developer and to perform database testing.

Involved in data sync activities across all of the environments.

Involved in testing the batch jobs Unix shell scripts in in generating downstream files and validating the files

Actively involved in creating the change requests for appropriate application groups in successful implementation of the project for defect tracking and database creation using HP ITSM

installation of the vendor software and storage management on the RAC servers Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning,involved in load and performance testing (load data using sql loader) and tuning the application accordingly

Consultant at Tek Systems : Sprint Nextel Overland Park( Jul’08 – Dec’10) :

Quality Assurance Analyst : Involved in supporting and testing of I2S(Supply Chain management for stores) OMIM(Oracle E Business Suite for order management)/

Environment : ORACLE E Business Suite, ETL Tool Informatica Power center, Unix,Windows XP, BPEL

Involved in Unit, System, Functional, Regression and Integration testing, executed SQL Queries and Procedures to perform database testing. Active involvement with developer team, business users to introduce the Agile testing methodology,involved in testing all front ends for different downstream application with different web browser versions, involved in testing Oracle forms and back end testing using SQL queries to validate the data and UNIX shell scripts to test the batch jobs and troubleshoot the log files on the servers.

QUALITY ASSURANCE Analyst @SAPIENT Corporation( May’06 - Apr’08): Sprint Nextel Overland Park:

UBP,4G and NRM: Involved in UBP,4G and NRM projects development. business walk through, The UBP uses many application like RMS, CSM etc, involved in end to end testing, provisioning black berries and also involved in handset testing for high performance push to talk feature, testing the application Resource Management system (RMS)

Consultant at Signature Consultants (Mar’06 – May’06) : Argus Health Systems Mar’06 - May’06: Environment: IBM Mainframe,DB2,File Aid, Windows XP, Test Director

Description: Argus Health systems is the leading pharmacy benefits company, involved in testing the production data, worked in mainframe environment, generated sqls, created the reports, validated the financial reports for major medical insurance companies.

Analyzed the business requirement document and the system requirement document to come up with a detailed Test Plan, Executed manual test cases by generating sql,collected and t data for functional testing

Contact this candidate