Engineer Data Analyst
Resume:
Swarnali Basak
**************@*****.***
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