Software Quality Engineer QA

LOVELY BANIK

Manteca, CA-***** 408-***-**** (cell) ******@*******.*** (email)

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

Worked with companies/clients like Affinity Solutions, Teradata, Verizon, Wellsfargo, Kaplan,

PG&E, Netflix, Yahoo, VISA, Silicon Valley Bank, iPass

Technical experience with Hadoop Eco System, Spark

TECHNICAL SKILLS:

LANGUAGES : Java, XML, JSON, SQL, SQL*Plus,PL/SQL, Pro-C,

UNIX Shell, Python,, Selenium Webdriver

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

MySQL, Couchdb, Hive, Spark RDD, Spark DataFrames,

Snowflake

TOOLS : 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, Reports 2.5,

Reportwriter 1.1, BODI, Informatica, Cognos, HDFS,

Sqoop, Spark Shell, Tableau, Postman

OPERATING SYSTEMS : HP UNIX, XENIX, HP MPE, DOS, Windows NT/95/2000/XP/7/10,

Solaris, Linux, Unix (RHEL, Ubuntu), Vax/VMS, Mac OS

EDUCATION :

MS in Computer Science, IIT Kharagpur, India

BS in Electrical Engineering, IIT Kanpur, India

Coursera's Python Certification

Magnimind Academy's Data Science course

TRAINING, Self Learning, Summary :

· In 2020, Learnt numpy, pandas, scikitlearn, matplotlib by going though tutorials, through trainings by 'Magnimind Academy' and 'Databricks' -- ran the commands in Jupyter notebook. Attended ML bootcamp by Magnimind Academy to learn Data Science and ML

· Used Hive Query, and worked with Azure cloud in Kaiser project.

· Used Pytest, CouchDB, AWS and Docker at Memeo while testing File sharing product

· Wrote Java programs and Java test cases during 2000-2014 in several projects

· Fast learner of the technologies while working in the project

WORK EXPERIENCE:

Affinity Solutions San Jose, CA 06/2021 -- 02/2025

Role and Responsibility : Tested REST APIs extensively for generating analytics reports . I tested panel creation and tested reports using panels and without using panels. Panels were created based on customer requirements with breakouts on demographics and income range. I tested extensively measurement reports which depict consumer spend behavior. I found very important bugs by testing +ve and -ve scenarios. I used Postman tool for calling REST APIs.

Tested cleaning & hashing, and matching functionalities developed in Snowflake database environment, extensively. Prepared data to test every possible scenario. Also, tested consumer reports developed using report templates by specifying a wide variety of combinations of parameters.

I did performance testing manually as and when needed -- for eg. when new financial data was added, when underlying demographics data sourcee was changed.

Environment: Snowflake database, Worksheets in SnowSight, Postman, JIRA, Mac

Safeway Pleasanton, CA 04/2021 -- 05/2021 (Cognizant)

Role and Responsibility : Wrote extensive test cases for testing datawarehouse in Snowflake database environment. I tested thoroughly and logged several bugs in JIRA. I worked with onsite and offshore team members. I co-ordinated with offsite team members, had meetings with them regularly to complete testing the deliverables timely and quality. Re-tested the bugs after they were corrected..

Environment: Snowflake database, Worksheets in SnowSight, JIRA, Unix

Teradata Santaclara, CA 07/2020 -- 09/2020 (Apex Systems)

Role and Responsibility : Wrote extensive test cases for 36 in-DB functions related to "Descriptive Statistics", "Variable Transformation" and "Statistical Tests". Teradata Warehouse Miner (TWM), the software that allows users to perform data mining entirely within a Teradata warehouse, constitutes of these functions. Each of these functions has 20-30 parameters -- mandatory and optional. Developed test cases for all possible combinations of different parameters' values. Executed them in Teradata DB, logged several bugs -- easy to find ones, and difficult to find ones. Compared the results against TWM classic application. Put the test cases in Python automation framework.

Environment: Teradata Studio v 17.0, Teradata db v15.0, JIRA, Python, Confluence

Kaiser Permanente Pleasanton, CA 03/2019 -- 10/2019 (Cognizant)

Role and Responsibility : Worked in Foundations Data project in BIG Data Environment. Tested the pipeline of Foundations Framework developed for data loading. Used the framework, 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. Meta files and Data files resided on Azure Data Lake storage. 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, Azure, Spark, Yarn, Kafka, Java, JIRA

Apple Sunnyvale, CA 07/2018 – 01/2019 (Cognizant)

Role and Responsibility : As a Senior QA Engineer, 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 Apple owned Radar application. Created Data Latency Report for the important tables and views.

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

Apple Cupertino, CA 04/2018 – 06/2018

Role and Responsibility : As a Senior QA Engineer, performed GDPR testing of Teachers' and Students' data of Schoolwork application.

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

Zillionix Fremont,CA 10/2017 – 02/2018

Role and Responsibility : Worked as Data cum QA Analyst. 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. Did Code walkthru of Python program.

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

Verizon Inc. (IPTV) SanJose, CA 02/2017 – 09/2017

Role and Responsibility : As a QA Engineer -- Python Automation, performed functional testing of 'Application' and 'Player' components of FIOS IPTV. 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

Memeo, Unicom Global Inc. Campbell, CA 04/2016 – 08/2016

Role and Responsibility : As a QA Engineer - Python Automation, 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. Wrote test cases using Pytest framework. 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.

About the product : Admin of an organization creates the account and adds users. Users keep their individual files and shared files under Memeo 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

Apple Sunnyvale, CA 03/2015 – 10/2015

Role and Responsibility : As a QA Engineer, 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 Apple'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 Apple'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, Apple Map, Google Map, Apple internal tools, Python 2.7, JSON, REST APIs, Git

VISA Foster City, CA 06/2014 – 02/2015

Tested 'VISA Checkout' application and 'Reference Application' for Mobile Payments.

Role and Responsibility : As a QA Engineer, tested UI features of 'Visa 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.

i) Learnt Ruby and Cucumber for automation, ii) 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, 'Android, iOS, Windows phones and Tablets'

Netflix Los Gatos, CA 09/2011 – 09/2012

Media Pipeline : Media Pipeline group develops Java programs for video and encoding, packaging and publishing of movies and TV shows, and ensures that all these jobs run smoothly in production. All streams required by Netflix subscribers for instant watching, are pipelined by this group. Systems and Software manage the voluminous and long running encoding processes end to end.

Role and Responsibility : As a Senior QA Engineer, 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, REST APIs

Telenav Sunnyvale, CA 03/2011 – 09/2011

MIS Reports : Financial and Performance reports are created by MIS group for business analysis.

Role and Responsibility : As a Senior QA Engineer, 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

Yahoo Inc. Sunnyvale, CA 09/2010 – 01/2011

YMeta : Yahoo Metadata project maintains metadata(dimension and fact tables) which is used by datawarehouse of different departments.

Role and Responsibility : As a Senior QA Engineer, studied Technical Requirements documented in online Wiki documents, 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.

UAD (Unified Advertisement Datamart) : 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

Wellsfargo Bank (Wells) SanLeandro, CA 10/2009 – 08/2010

Data Migration : Wachovia Bank merged with Wellsfargo Bank at the end of year 2008. Data migration project is about moving data of several Wachovia applications to Wellsfargo applications’ databases. These Wachovia applications will not be used any more.

Role and Responsibility : As a QA Lead, 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

Silicon Valley Bank (SVB) Santaclara, CA 06/2008 – 05/2009

Datawarehouse : Datawarehouse at SVB pulls data from about 15 different source databases into staging area. Consolidation process runs on Staging database, and populates dimensions and facts tables. Several MART processes run to populate data in different MARTs. Business Intelligence reports for business users, are created from the MARTs. Essbase cubes are created from finance data in MARTs. Once these nightly processes complete on every week night, data are populated to around 15 downstream applications.

Role and Responsibility : 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

Netflix Inc. Los Gatos, CA 12/2007 – 03/2008

Datawarehouse : Business Intelligence group implemented Datawarehouse for different subject areas.

Role and Responsibility : Worked as Senior QA Engineer for testing datawarehouse. 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

iPass Inc. Redwood Shores, CA 01/2005 – 11/2007

Role and Responsibility : Worked as QA Lead for testing Contracts, Billing, Datawarehouse, Crystal Reports and Web applications (Portal, Password management, Mobile data application), Remedy (Service application). Did Load testing of Express Connect application using Astra Load test. Did Code walkthrough of PL/SQL and Java programs. Led the offshore QA team.

Prepared a very good documentation about different steps in Billing testing.

Environment : Windows XP, Unix, Oracle FORMS 6.0, Oracle 10g and 9i, Crystal Reports, Remedy, Java, Oracle App Server, Bugzilla, TOAD, AstraLoad Test

PG&E San Francisco, CA 09/2004 – 12/2004

Market Data System (MDS) project - MDS is a centralized repository and distributor of key market data including broker quotes, forward curves, volatilities and correlations. MDS replaces storage of data within various spreadsheets and disparate databases and automates the flow of data across various models and systems.

Role and Responsibility : Worked as Senior QA Engineer. Developed test cases for loading of data through batch programs, and for different functions of the tool. Performed Direct Feed testing and tool testing. Developed SQL queries. Verified results from reports, and by executing queries in the database. Performed Code walkthrough of PL/SQL procedures and triggers. Developed test cases and performed testing for Audit changes carried out in order to make the system Sarbanes Oxley compliant. Logged defects in TestDirector. Discussed defects in meetings with development team and prioritized them. Reviewed User Requirements Specifications, Design Specifications and User Manual for different subsystems of the project. Attended a presentation on the overview of Sarbanes Oxley.

Environment : Windows 2000, Weblogic, Oracle 9i, Unix, TestDirector 8.0, TOAD

Kaplan Inc. Oakland, CA 08/2003 – 09/2004

Kaplan Assembly and Authoring Tool – This tool is used to generate the online course.

Role and Responsibility : Installed Linux, JBOSS and ANT on my Linux m/c, Developed Test cases, Performed WhiteBox testing by writing JUnit tests for functionality testing and Web Services testing, Logged bugs

Environment : Java (jdk 1.4), Javascript, Weblogic, JBoss, Oracle 8i, Unix, Bladerunner, XML,SOAP, AXIS, JUDDI, ANT, Clearcase 4.0, ClearQuest Ver 2002.05.01, Perforce, Bugzilla

COVANSYS/ formerly Complete Business Solutions Inc. (CBSI) 02/1998 – 08/2003

Project : Public employee Retirement System (Clarety) for State employees

11/2001 –08/2003 Columbus, OH

Role & Responsibility :

As Support Engineer : Developed and modified Java methods for different processes in MemberShip System. Wrote JUnit test cases to test the methods. Wrote complex PL/Sql procedure for calculating quarterly interest for the members. Modified the procedure for its performance improvement. Performed Testing of On-line Functionalities, Batch Programs and Reports.

Environment : Java 1.3, Javascript, WebSphere 4.0.2, Oracle 8i, Unix, Junit, NT 4.0, FileNet 3.3, Winrunner, Test Director 7.0

Project : ReactIR project for Applied Systems, Inc. (ASI), A Mettler Toledo Company

05/2001 – 10/2001 Columbus, OH

Role & Responsibility : As Senior QA Engineer, Developed test plans, created the automatic test scripts and executed the test scripts, did Black Box Testing, Coded Win Runner scripts in TSL language for automation, functional and regression testing, Did System Test Design, scripted and performed System Testing, Logged the defects in Test Director, Re-tested for closure of defects, Performed Regression Testing, reviewed the results.

Environment : Microsoft Visual C++ 6.0, MS-Access, IDL, Test Director 6.02,Win Runner 6.02, SQL Server 7.0

Contact this candidate