Sign in

SQL, ETL testing, DWH testing, Database Testing, Linux, Oracle, Datast

California, United States
May 31, 2018

Contact this candidate


Banupriya Shanmugam



SITAMS, SV University, India June 2004 - May 2008

Bachelor of Engineering GPA – 3.5 (4)

Major - Electronics and Communications


Languages: SQL, Python, Shell Scripting, Core Java

Operating Systems: Windows, Unix, Linux, Tandem

DBMS (Relational): Oracle, MYSQL, PL/SQL, Hogan

Oracle Financial Products: OFSAAI, EPM Application Profitability Management and Profitability Analytics, Oracle PLSQL, XML, OBIEE

Unstructured DBMS & Apps: HBASE, HDFS, Hadoop, Hive, Cassandra, SOLR

Web Technologies: REST,SOAP


Automation: SOAP UI, Robot Framework,QTP

Reporting & Analytics: OBIEE, HP-ALM

Others: Bug Tracker. Net, Bugzilla, JIRA and NetApp Burt tool.


Systems QA Analyst IV Feb 2016 – Till Now

Wells Fargo Bank, San Leandro CA

Analyze Business and Functional requirements to create Test Plan, Test strategy, Test scripts, and Use cases for the ATM application. Working as a part of a Financial modernization project– rollout project for host migration from Tandem to Linux based system. Testing includes but is not limited to: web service API testing, backend testing in developing and executing SQL queries to interact with databases like Oracle,Tandem. Also, extracting & grepping the huge log files from linux systems for further data analysis, involved in end-to-end testing with downstream applications and SORs, GoldenGate Syncing testing between two databases by creating the data mapping from source to target & exception handling etc. Attend project test meetings, defect triages and JAR sessions with the applicable team members to discuss various problems and solutions for sound delivery of the product.Use HP ALM and Clear Quest for defect reporting and tracking.

MTS – QA Engineer Nov 2011 – Aug 2014

NetApp India private ltd, Bangalore, India

Was part of AutoSupport DPS team which develops and maintains the ASUP backend processing platform. As part of DPS QA, involved in all phases of testing activity like test requirement analysis, test estimation, resource allocation for the allocated QA tracks.Tested web applications in a variety of browsers and involved in black box, white box testing for both SQL and NOSQL databases using Oracle 11g, HDFS, HBASE, HIVE and SOLR. Participated in bug reviews, creatively approach and solve problems and work effectively to find a solution with cross functional teams. Contributed well written product documentation and update the intranet QA wiki (Confluence) for various projects.

Data warehouse DW3 (RDBMS)

Involved in Requirement gathering and analysis, Test Specification, Test Plan Preparation and Test Cases.

Involved in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.

Testing REST-ful API's and verified the data in database using complex SQL queries.

Working within a team and cross-group to drive identification and resolution of issues

Data warehouse DW4 (Migration from RDBMS to Hadoop)

Build, Maintain and Execute Comprehensive Test cases, Test planning and Test strategy.

Verification of data in HDFS, HBASE, HIVE and SOLR.

Testing of REST Web services using APACHE Datastax, on Hadoop.

Owned responsibility of different modules Config Loader, ETL, REST API and Lead other QA Engineers in best testing practices and technical skills.

Involved in Data warehouse Testing – End to End testing of object data store and Decision support system (ETL).

Automated required applications to ensure faster test execution.

Used internal bug tool for tracking the Bugs and collaborate with software developers to communicate defects and offer suggestions.

Experience in Agile Scrum Methodology.

Used HP-ALM tool to create and tracking test cases and also for reporting.

Test Analyst

Aug 2008 - Nov 2011

OFSS(Oracle Financial Services Software Limited) Bangalore, India

Worked as a test engineer and developed the test cases as per the business requirement and executed with different set of data. Performed extensive functional, integration, release, ETL and UI testing and contributed to Sprint planning sessions, review usage reports and project plans and product roadmaps. Prioritize and conduct root cause analysis across the full SDLC/product life cycle with weekly and daily releases.

Profitability – Banking :

As per the business requirements of the product & designed the test cases and good knowledge about OFSA banking product both functionally and technically.

End-to-End knowledge in OFSAA Reveleus Product and Solutions.

Experienced in working with various data sources like Oracle 11g, XML, and MS-Excel.

Strong knowledge of OFSAA Infrastructure and OFSAA solutions installation and troubleshooting.

Proven experience in delivering User Training, Enterprise Level Functional Testing, UAT support, Cutover activities, Warranty Support etc

Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.

Work experience in Data Warehousing/ ETL Testing within the environment of Oracle, MYSQL.

Extensive experience in testing and reviewing of dimensional modeling (Star and Snow flake) of data warehouse.

Work experience in reviewing and testing of data maps between various legacy systems and relational databases.

Tested UNIX shell scripts written for ETL Processes to schedule workflows on In-house Batch Jobs UI Scheduler.

Tested ETL applications in relational databases and flat files using SQL Loader and involved in the report generation using OBIEE.

Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.

Hands-on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Sanity Testing.

Raise defects and review defects to reduce invalid defects, record and track software defects through Oracle bug DB tracking tool.

Profitability Data Benchmark

Analyzed all the supported Profitability allocation rules.

Involved in SQL query tuning for performance improvement in the backend engine rules.

Assisted Team members and Test Lead for preparing test suites and test planning.

Involved in Functional, Sanity and Smoke Testing.


“We-Applaud” Award for Gold Copy Project

“I-Appreciate” Team Award for Benchmark Project

Good and efficient at finding and firing bugs – “Bug Finder” Award.

*References will be provided on request. For more information refer my linked profile for more information

Contact this candidate