PROFESSIONAL SUMMARY:

• Over 20 years experience in Software Development, Quality Assurance and Testing, implementation of ISO 9000 and CMM, Automation, White Box and Black Box Testing

• 8+ years of Black Box testing of Web and client server applications
• 3+ years of White Box testing and Automation testing including API testing
• 6+ years experience in development and testing of DataWarehousing
• 5+ years of Database Testing and development that included writing complex SQL queries, Stored procedures
• Strong analytical, coding and testing skills
• Possess strong verbal and written communication skills

TECHNICAL SKILLS:LANGUAGES: Java, XML, JSON, SQL, SQL*Plus, PL/SQL, Pro - C, UNIX Shell, Perl, Python, WinRunner, Selenium Webdriver

DATABASE: ORACLE 10g/9i/8i/7.3, SQLServer 2000/7.0/6.5 , Teradata, MySQL, Couchdb

TOOLS: Sagent, Astra-Load Test, Junit, TestNg, SOAPUI, MS-Project, PVCS Tracker, Clearcase 4.0, ClearQuest, Perforce,Git, SVN, Bugzilla, JIRA, HP Quality Center, ANT, Jenkins, TOAD, SQL Developer, Oracle FORMS 4.5, Reportwriter 1.1, Reports 2.5,BODI, Informatica, Cognos, Hadoop, MapReduce, BIG Data

OPERATING SYSTEMS: HP UNIX, XENIX, HP MPE, DOS, Windows NT/95/2000/XP/7/10, Solaris, Linux, Unix (RHEL, Ubuntu), Vax/VMS, Mac OS

WORK EXPERIENCE:

Confidential, Campbell, CA

QA Engineer

Responsibilities:

• performed functional testing of File sharing product from web UI and from backend.

• Developed python scripts for testing unit agent components, and for functional testing of agents.
• Debugged using PyCharm debugger, client and agent logs, and the information updated in MySQL and CouchDB.
• Created a few Jenkins jobs to create RPMs for the automated tests to be deployed on Docker.
• Got familiarised with Mesos, Marathon, Chronos, Zookeeper. Logged defects in JIRA.
• Admin of an organization creates the account and adds users.
• Users keep their individual files and shared files under Confidential C1.
• Files uploaded are blobbed and stored in Amazon S3 cloud. Files are downloaded onto the desktop and mobile devices from cloud by the agents running on the devices, and are marked as synced files.
• Mesos Cluster is created for running background jobs in Chronos, managed by a Zookeeper ensemble.

Environment: Windows 10 virtual machines on MAC OS, Python 2.7, Pytest, unittest, PyCharm, Github, Jenkins, MySQL, Couch DB, Server components in Java and Ruby, JIRA, Docker, Mesos, Marathon, Chronos, Zookeeper

Confidential,  Sunnyvale, CA

QA Engineer

Responsibilities:

• performed server side testing of Routing engine for 'Transit Routing' functionality. Found out different transit routes of different cities, prepared test cases for those transit routes, and also for different features.

• Noted defects in Confidential 's defect tracking tool. Canary is a web portal for QE engineers to run test suites.
• The Maps Test engineering team is responsible for maintaining the test suites to validate various aspects of Maps like Routing, Search, POIs.Added test scripts in Canary using Confidential 's proprietory scripting language, and in Python.
• Wrote test assertions based on route's response in JSON format. Did client side testing of 'Transit Routes' for different cities, on iPad and iPhone devices.

Environment: MAC OS, Confidential Map, Google Map, Confidential internal tools, Python 2.7, JSON

Confidential,  Foster City, CA

QA Engineer

Responsibilities:

• tested UI features of ' Confidential Checkout' application on different Web and Mobile browers in different test environments, for several releases.

• Tested UI features of Consumer and Checkout applications where all credit card information are saved for an user under user's account.
• Web browsers included IE, Firefox, Chrome and their different versions, and also Safari browser using Sauce Labs.
• For mobile browsers, devices included Android, iOS and Windows phones and Tablets. Tested in production environment as well to validate the release.
• Also, tested 'Reference Application' on Android devices (Samsung Galaxy Note 3, S4, Nexus 5, HTC).
• This application uses Mobile SDK APIs for doing online payments with mobile devices using NFC technology. Noted defects in JIRA, verified and closed them upon their resolution.
• Learnt Ruby and Cucumber for automation
• Took a short Jmeter training for testing APIs.

Environment: Java, XML, CSS, JSON, JIRA, Oracle, Windows, Ruby, Cucumber, Stash, GIT, Sauce Labs, Eclipse

Confidential,  Los Gatos, CA

Senior QA Engineer

Responsibilities:

• carried out functional testing and White Box Testing of new requirements, regression testing of existing functionalities.

• Tested uploading of source files by calling REST web services. Verified that deployments are done on country specific CDNs.
• Monitored different queues using sdbexplorer.
• Did weekly production deployments of the components: scheduler (Java programs that run on 15 different machines), web application, terminated and brought up Amazon cloud EC2 instances. and executed them.
• Created one or more Amazon Master Image (AMI) each week, for testing, and deployed the latest one in production, every week.
• Ran Amazon APIs for managing instances. Wrote and executed SQL queries whenever needed for testing.
• Wrote several SQL queries and executed them in production database, to fix production data.
• Updated existing scripts and wrote new scripts in Shell, Python and Perl for carrying out Functional and Regression testing.
• Updated testing related necessary information in Wiki documents.

Environment: Oracle 10g, SQL, bash (Shell), Linux, Mac, SQL Developer, Agile, Python, Perl, Java, XML, TestNg, Jira, Pivotal Tracker, Elastic fox, sdbexplorer, VNC, Jenkins/Hudson, SVN, Maven, Apache, Tomcat

Confidential, Sunnyvale, CA

Senior QA Engineer

Responsibilities:

• studied Business and Technical Requirements of TomTom TeleAltas and Navteq operations, wrote test cases in Testlink for the reports, executed test cases and wrote bugs in Bugzilla and Jira.

• Developed SQL(s) for supporting the test cases and executed them.
• Performed code walkthrough of PL/SQL and Java code written by developers.

Environment: Oracle 10g, PL/SQL, Java, bash(Shell), Linux, Perl,Windows XP, Toad, TestLink, Bugzilla, Jira

Confidential, Sunnyvale, CA

Senior QA Engineer

Responsibilities:

• Reviewed Data Model and Design document.

• Wrote test cases in Excel document, and once they are reviewed by development team, imported them in Test Manager.
• Developed SQL test cases and automated them in Test NG framework. When tests are executed by automation, they update test results in Test Manager.
• Wrote several defects in Bugzilla, re-tested and closed them when they were fixed.
• Developed and executed Operability test cases for testing REST Web Services deployed on multiple servers, started and stopped Apache and Tomcat servers to test alerts for web services being started, run and stopped.
• Tested functionalities of Web Services.
• Verified and closed several defects prior to production release in Jan 2011.

Environment: Oracle 10g (Source db), Flat files (Source), Oracle 10g (Target db), Agile, bash(Shell), Perl, Linux, Mac, SQL Developer, Bugzilla, Eclipse, Java, TestNg, Jenkins, Maven, SVN, Apache, Tomcat

Confidential, SanLeandro, CA

QA Lead

Responsibilities:

• Reviewed Business requirements and Functional Specifications Documents for Data migration of ‘Desktop Deposit’ application.

• Reviewed Mapping document, Migration Analysis document and Traceability Matrix.
• Developed Test Plan and Test Cases for System testing. Co-ordinated with, and led Offshore QA team.
• Had internal review, external review and QA meetings.
• Performed code walkthrough of ETL Informatica code, Developed and executed SQL(s), PL//SQL procedures and Perl scripts to perform testing, Logged defects, Provided Status reports to QA Manager and project managers.

Environment: Oracle 10g (Source db), Flat files (Source), Oracle 10g (Target db), ETL tool Informatica 8.5.1 for Data Migration, Mercury Quality Center 10.0, Perl, Unix

Confidential, Santaclara, CA

Responsibilities:

• Created Mapping document based on Business requirements, developed and tested Datawarehouse projects.

• As a lead of my project, co-ordinated with on-shore and offshore teams.

Environment: Oracle 9i (Source db), Access (Source db), SQLServer 2000 (Source db), Oracle 9i (Target db), Sagent Design Studio for ETL development, ETL tool BODI for ETL development, Sagent automation for scheduling the jobs., Dameware for connecting to Sagent Automation server, Windows 2000, Unix

Confidential, Los Gatos, CA

Senior QA Engineer

Responsibilities:

• Developed test cases for testing the subject areas: Geography, Party, Product and Subscription of Datawarehouse according to Source to Target transformation rules.

• Developed i) Oracle and Teradata queries, ii) BTEQ scripts for running Teradata queries, and performed testing.
• Looked into execution graphs of ab initio to verify count of records in target against source.
• Verified relationships among tables in Target, verified correctness of data in Target tables against Source tables by writing SQLs.
• Recorded bugs, conducted bug meetings and verified bug fixes. Recorded test results.

Environment : Oracle 10g (Source database), Teradata v2r6 (Target database), ab Initio 2.14 (ETL tool), Linux