PROFESSIONAL SUMMARY:

• Over 15 years experience in Software Development, Quality Assurance and Testing, Data Analysis, Automation Testing, White Box and Black Box Testing
• 8+ years of Black Box testing of Web and client server applications
• 4+ years of White Box testing and Automation testing including API testing
• 6+ years experience in development and testing of DataWarehousing/ETLs
• 5+ years of Database Testing and development of Database procedures
• Technical experience with Hadoop Eco System, Spark

TECHNICAL SKILLS:

LANGUAGES: Java, XML, JSON, SQL, SQL*Plus, PL/SQL, Pro - CUNIX Shell, Perl, Python, WinRunner, Selenium Webdriver

DATABASE: ORACLE 10g/9i/8i/7.3, SQLServer 2000/7.0/6.5 , TeradataMySQL, Couchdb, Hive, Spark RDD, Spark DataFrames

TOOLS: Sagent, Astra-Load Test, Junit, TestNg, SOAPUIMS-Project, PVCS Tracker, Clearcase 4.0, ClearQuestPerforce,Git, SVN, Bugzilla, JIRA, HP Quality CenterANT, Jenkins, TOAD, SQL Developer, Oracle FORMS 4.5Reportwriter 1.1, Reports 2.5,BODI, Informatica, CognosHDFS, Sqoop, Spark Shell, Tableau

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

WORK EXPERIENCE:

Confidential, Pleasanton, CA

Responsibilities:

• Worked in Foundations Data project in BIG Data Environment.
• Used Foundations Framework developed in house, to load Kaiser's "Patient and Pharmacy" Source Systems data in Hive and HBase databases.
• Framework has several components.
• Data loading happens thru different stages utilizing each component.
• Processed the metafiles and then loaded data.
• After each stage, validated the log details, and the database records created in meta and data processing repository.
• Upon failure, debugged the logs to determine the root cause.
• After data loading completed, validated counts and data types, by running scripts written in Java, from backend i.e. from Unix shell.
• Logged defects in JIRA. Project used Scrum methodology.
• Each Sprint was for 2 weeks.

Environment: Hadoop, Hive, HBase, Spark, Yarn, Kafka, Java, JIRA

Confidential, Sunnyvale, CA

Senior QA Engineer

Responsibilities:

• performed testing of Datawarehouse/ETL application of Applecare Customers’ iLog Enhancements, and Case creation changes .
• Test cases, their execution results and the bugs found, are recorded in Confidential owned Radar application.
• Created Data Latency Report for the important tables and views.

Environment: MAC OS, Teradata, Teradata Studio, Kafka, Radar

Confidential, Cupertino, CA

Senior QA Engineer

Responsibilities:

• performed GDPR testing of Teachers' and Students' data of Schoolwork application.

Environment: MAC OS, JSON, Swagger UI, Mac Applications on iCloud, iPad, Splunk

Confidential, Fremont,CA

QA Analyst

Responsibilities:

• As per the requirements and design documents, loaded .csv files in mysql tables.
• Created tables in Hive. Created Sqoop Import and Export jobs.
• Using sqoop import, loaded data in Hive. Ran UDFs in Hive to encrypt data.
• Using sqoop export, loaded data in mysql from Hive. Ran the jobs to load Historical and Daily Stock data.
• Ran Python program that uses Spark-SQL and Dataframe to compute moving averages on Stock Data.
• Ran Hive queries.
• Viewed the required data by writing custom queries in Tableau.
• Documented the processes.
• Inspected and verified data in Source and Target tables in mySQL and Hive at every step.

Environment: cloudera Hadoop Quickstart vm CDH 5.12, Hadoop 2.6.0, mysql, sqoop 1.4.6, Hive 1.1.0., Hive UDF, Hue, Spark shell, Spark RDD, DataFrame, Tableau

Confidential, SanJose, CA

QA Engineer

Responsibilities:

• performed functional testing of 'Application' and 'Player' components of FIOS Confidential .
• Wrote test scripts in Python for testing functionalities of player.
• Functionalities included: pause and play, FastForward and rewind at different speeds, Skip forward and backward for different length duration, playing fastforwarding and rewinding catchup programs, playing fastforwarding and rewinding VOD (video on demand) assets.
• Deployed latest build whenever available, on settop box using in house software.
• Logged defects in JIRA. i) Collected logs, ii) took photos of TV screen - attached i) and ii) in JIRAs.

Environment: MAC OS, Python 2.7, PyCharm, Github, Jenkins, SamsungTV

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, REST APIs

Confidential, Sunnyvale, CA

QA Engineer

Responsibilities:

• 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.
• Confidential 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 Confidential 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, REST APIs, Git

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.
• Took a short Jmeter training for testing APIs, iii) Studied Mobile SDK code (in Java, using Eclipse IDE), after downloading from Stash in local GIT repository.

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

Confidential, Los Gatos, CA

Senior QA Engineer

Responsibilities:

• 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, REST APIs

Confidential, Sunnyvale, CA

Senior QA Engineer

Responsibilities:

• 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