Swarnali Basak

adenxd@r.postjobfree.com

Contact - 408-***-****

PROFESSIONAL SUMMARY

●9+ years of experience in Data Analysis, Quality Assurance, Testing process, Testing methodologies and strong experience on STLC and overall testing approaches.

●Experience in ETL (Ab Initio,Informatica) Testing, Database (Oracle & Teradata) Development and Testing.

●DataBase validation Source, Stage, destination using complex sql queries

●Extensive experience in Functional, Integration, Regression, User Acceptance, System and Batch Testing.

●Worked on developing Test Plan,Test Strategy,Test Case,Test Result .

●Worked on Oracle Package, Function, Procedure, Triggers as a developer and tester.

●Extracting defect status reports and managing defect status using the Quality center / ALM, Bugzilla, Jira, Clear Quest and also conducting defect status calls.

●Excellent working experience in RDBMS technologies like Oracle, Teradata, DB2 and MYSQL.

●Experience working in Agile methodology.

EDUCATION:

B.Tech. in Information Technology, West Bengal University of Technology, India

SKILLS AND KNOWLEDGE

Testing Tools

ALM, QC, Selenium,SoapUI

Databases

Oracle, DB2,MySQL, MS Excel, Teradata

Tools / Products

Ushacomm Billing System Unicorn, Crystal report, Nikira (Fraud Management),Teradata and Ab Initio, Eclipse

Reporting Tools

Business Objects

Other tools

Maven, Eclipse, GitHub,Perforce,Jira

Operating Systems

Windows 95/98/2000/XP, Linux and UNIX.

Programming languages

SQL, PL/SQL, Java

PROFESSIONAL EXPERIENCE:

Client: Cisco, LTI Jul 2019 to Till Date

Title: Data Analyst/QA

Responsibilities:

Data and Report Structure validation of BO reports.

Data Validation for month end activity, data load for daily refresh

Analysis of data from source to target layer

Review and Delivery of test strategy, test case, test result

Communicate Biz User for requirement understanding, delivery, BAT, UAT and support production issue.

Environment: Oracle, BO, Informatica, Rally, unix, MicroStrategy,

Client: Wells Fargo,Fremont Jun 2018 to April 2019

Title: Data Analyst

Responsibilities:

Performed all database related work in the team.

EBCDIC,ASCII copybook,DML conversion,Data Mapping.

Data Analysis, data loading, test data preparation, data validation using complex sql queries.

ETL testing, support ETL developer, troubleshooting.

Release deployment and handle all release related activity.

Environment: Oracle,Data Mapping,Ab-Initio,Unix,SVN

Client: Symantec, Mountain View, CA Nov 2017 to March 2018

Title: QA Engineer

Responsibilities:

Performed testing of software web applications(Norton eBiz) including Functional and Regression testing.

Api Testing.

Involved in Selenium Script creation and execution.

Web testing for different template in different env.

Release deployment using Jenkins.

Database validation using Oracle sql Developer.

Environment: Selenium Webdriver, Python, Java, UNIX, Eclipse, Perforce, Agile,Postman,Perforce,Oracle

Client: CapitalOne Bank, San Francisco, CA Nov 2016 to Oct 2017

Title: QA Engineer

Responsibilities:

OnShore-Offshore coordination as a module lead for Review and status.

Develop Test Plan,Test Case,Test Result Doc.

Test Data preparation .

Running ETL jobs using Unix.

Validate Database (Oracle).

Defect tracking using jira.

Environment: ETL, Oracle, SQL Developer, UNIX, Jira, Agile

Client: Wells Fargo Bank, San Francisco, CA May 2014 to Nov 2015

Title: Sr. QA Engineer

Responsibilities:

Performed testing of software web applications including Functional, Integration and Regression testing.

Extensively involved in developing regression test scripts, creating output values, doing data driven Test for all the projects.

Responsible for executing Test Cases, filing and reporting bugs through the Quality Center and verified known bugs against new builds.

Involved in testing new development cycles using iterative testing cycle by creating manual business flows and scenarios.

Performed ETL testing by running jobs in Autosys server or Autosys GUI.

Involved in Data conditioning of files and make files ready to process further before we run jobs in ETL.

Performed WF Mobile app manual testing for both android and ios.

Environment: SQL Developer, UNIX, SOAPUI, Autosys,QC,ETL

Company: Capgemini, Bangalore, India March 2012 to Feb 2013

Title: Sr. Test Analyst

Project: Target

Responsibilities:

Onsite and Offshore work coordination and status update

ETL Testing from source db to target db.

Understanding mapping doc and preparing test data accordingly.

Writing sql queries for data validation of end database.

Defect tracking using QC.

Regression testing

Environment: Teradata, Quality Center, ETL,SQl

Company: Mphasis, Bangalore, India Nov 2010 to March 2012

Title: Sr.Software Eng in Test

Project: Vodafone,Capital-One

Responsibilities:

Working as a developer and Tester in Teradata.

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Performed Data-warehouse testing on Teradata and Ab Initio

Tested ESB batch process in order to send the customer transaction to oracle staging table

Worked with Compatibility Testing for Browser.

Used SQL Assistant to write SQL and query the Teradata database tables.

Validated ETL(Data Stage) scripts.

Experienced with Quality center for managing the defects and querying the Quality center for pulling Defect status reports.

Environment: Teradata, Abinitio, Oracle Pl/Sql, Windows, Unix and Quality Center

Company:TechMahindra,Bangalore/kolkata,India July 2007 to Nov 2010

Title: Software Engineer/ QA Engineer

Responsibilities:

Performed coding and unit testing.

Performed database validation using SQL .

Developed a GUI for data analytics of using Core Java, JSP, JS, Oracle 10g and Tomcat web server.

Environment: Oracle 9i, Unicorn (telecomm billing software), Crystal Report, Windows XP,Unix, Oracle 10g, Core Java, ETL, Windows XP, Unix

.

Contact this candidate