Data Scientist and Automation Engineer

Location:

Posted:

June 29, 2019

Resume:

I am an Data Scientist and Automation Engineer with Cognizant having a total 71/2 Years of experience which includes Hadoop Development,,Python Developer,SAS programming, Automation Testing with UFT and Selenium, ETL validation, Mainframe data validation, Penetration Testing, Data Masking validation, Data migration Expert, Python and Scala. I got an extensive experience in Automation, GUI, Integration, Functional, Regression data validations. My main area of experience has been Selenium, ETL, Python, Hadoop Development, SAS programming. I am having strong in analyzing, developing, problem solving & decision making abilities in Selenium, Hadoop, SAS programming as well as in Data warehouse using Informatica Power Centre 9.1,Mysql and Oracle 10G. Onsite 56 months work experience at client location such as Bank of Singapore, OCBC (Singapore) and UBS (Singapore) whereas offshore counterpart with Lloyds-TSB Bank, London & Bank Of New York Mellon, USA.

Main Profile Extracts:

Excellent knowledge of Big Data & Hadoop MapReduce, Scoop, Flume, Yarn, Pig,Impala, Hive,Cloudera Search,Hue Oozie, No SQL, HBase & Spark

Strong in analyzing, developing, problem solving and decision-making abilities in Data Warehouse using Informatica Power Center 9.1,Mysql &Oracle 10 g

Experience and knowledge in Quick Test Professional (UFT) Tool version 14 in Data Driven and Keyword Driven Frameworks with web as well as desktop based applications. Descriptive programming

Excellent knowledge of Selenium scripts, Web-driver, RC,Keyword/Data driven/Hybrid/Cucumber framework, TestNG, Grid, Maven, Apache Ant,Jenkins, Junit, Database Integration with Selenium, POM

Experience and knowledge in data extraction, data transformation and data loading (ETL), data warehousing concepts & dimension and fact tables.

Experience in analyzing Work let, Reusable Transformations and Mapplets in mapping, Performance and tuning of Informatica mappings and sessions for better performance.

Knowledge in SQL injections, Referential Integrity & BI Reporting Jasper Soft. Also basics of Mongo DB (Non-Relational DB).

Hands on experience in V model, Iteration and Agile model methodology.

Hands on experience in Pega Testing using Automated Unit Test, Tracer and Dashboard Tools.

Expertise in testing life cycle inclusive from System backend data verification which includes Penetration Testing, Mainframe data, Functional data, Regression data suites.

Hands Project Experience in Rest Assured, Google & Twitter API, with Serenity BDD Framework.

Education and Certifications

Title of the Degree with Branch

College/University

Year of Passing

Bachelor of Engineering in Electronics and Communication

Swami Vivekananda College of Engineering, Indore, MP

2011

Technical Skills

Operating Systems

Windows 98, 2000, 2010,XP,IRMS Machine

Domain Knowledge

Banking and Finance Domain with Front Office, Middle Office, Back Office, Sales and Trading, ATM, Debit & Credit card, Investment Banking with FOREX, Wealth Management, Payments,Treasuary,Derivaties,FATCA,Credit,T24,Calypso product, Wealth Management, Securities, Foreign Exchange, Midus Banking System

Testing

UFT Frameworks

Selenium Frameworks

Test case writing and execution, Automation Testing, Integration Testing, Test Data Setup, Regression Testing, Performance Testing, Penetration Testing, Black box testing, Quality Processes, Defect Management,Database Testing with Selenium.

Data and Keyword Driven, QC-AOM, OTA,Jenkins, VB Scripting, Descriptive Programming,desktop & web based

TestNG and Data Driven Framework, TestNG and Page Object Model(POM),TestNG and Hybrid Framework (Keyword +Data Driven),Page Object Model with Page Factory, Cucumber,Grid, Selenium RC,RC-Data Driven Framework, Listener Class,Flash

Tools and Utilities

Informatica 9.1, Oracle 10G,SQL Developer 3.2.1, SSH Secure Client 5.5, Beyond Compare, QC 9.0,Soap UI 4.5.0,QTP, JIRA,Textpad,AS400 Systems, SIBS, RBK, EBS,GIRO System, Jaspersoft 2.6.3, IBM Web sphere MQ, Ab initio,Midus Banking Systems, Subversion(SVN),Apache Maven,Jenkins, POI jars, GIHUB, Selenium Web driver, Selenium IDE, TestNG Framework with Ant/Maven Integration, XLS/XML files handling,Log4J,properties files, handling with frames, drag and drop, JVM & Customer Reports,Jenkins,Grid,POM

Big Data, Cloud and Hadoop Tools

API

Hadoop MapReduce, Scoop, Flume, Yarn, Pig,Impala, Hive,Cloudera Search,Hue Oozie, No SQL, HBase & Spark, Python, Hadoop Development, SAS programming and R

Rest Assured,Google & Twitter API (GET, POST,PUT,DELETE,Payload)

Certifications

●ISTQB-ISEB Foundation Tester,Selenium Certified by QTPSelenium, Hadoop Developer by Simpleilearn

●CCP-Credit Cards

Relevant Project Experience

Organization: Cognizant Technology Solutions Ltd.

Serenity Rest API Projects 1 : Serenity BDD Integration with X-ray JIRA Rest API –UBS Singapore

Duration

01th Sep 2018 – till date (Singapore)

Frameworks & Tool

Rest Assured,Google & Twitter API,GET,POST,PUT,DELETE,Payload Requests, X-ray JIRA Integration

Project Abstract

U UBS WM,proposed to automate the applications with Serenity BDD and CI Integration with Jenkins & X-ray JIRA

Role and Responsibilities

sdfdsf

Selenium Automation Test Lead:

Creation of java scripts for GET, GET,POST,PUT,DELETE requests

Uses of Maven with rest assured,Serenity & Cucumber dependencies

Test Execution from Jenkins & code check-in GITHUB

Test Execution Status update in JIRA using Rest API Request

Usages of source code comparison with GITHUB & JIRA plugin’s.

Automated Creation of bug in JIRA,for failed test scenarios with attachments

Serenity,Extent,Jason Reports

Automated Test Plan,Test Set,Test Execution with Rest Assured API with selenium

Parallel Execution with fail safe plugin

Running of multiple test cases (parallel) using same framework http requests by dynamic picking resources and test data.

Usages of Excel with Serenity (test cases with tags)

Usages of JIRA, Pool Mailbox, Micros-focus Jenkins Plugin

Rest Assured with Python Projects 1 : Automated Python with X-ray JIRA Rest API –UBS Singapore

Duration

01th Jan 2019 – Mar 2019 (Singapore)

Frameworks & Tool

Rest Assured,Python 3.2,TDD,List,Tuples,Sets,Decorators,PostMan,NewMan,Pycharm,Page Locators, logging, requests, paginations on Swapi API

Project Abstract

U UBS WM,Automation of Application with Python Language

Role and Responsibilities

Python Developer

Set-up of Pycharm run configuration

Creation of Page Locators and Models

Filling in forms with Selenium

Usages of List, Tuples,Sets, *args,*kwargs

Continues Integration with Travis CI

Debugging test in Pycharm

Serenity,Extent,Jason Reports

Source Code Management in GIT

logging, requests, paginations on Swapi API

Selenium Flash/Flex Framework Projects 1 : Selenium Flash Testing with WebDriver –UBS Singapore

Duration

01th Aug 2018 – Sep 2018 (Singapore)

Frameworks & Tool

Selenium Flash API, JavaScript Commands, Adobe Flash Functions, YouTube Open JavaScript API

Project Abstract

U UBS WM, Automation of Flash & Flex both Application with Selenium Flash/flex WebDriver and JavaScript .Along with usages of YouTube Open JavaScript API.

Role and Responsibilities : Selenium Test Lead

Installation of flash builder

Usages of Flash Selenium API in Webdriver

Executing JavaScript commands of Flash Application

Identifying SWF Object ID

Usages of JavaScript flash functions

YouTube’s open JavaScript API

Source Code Management in Git

UFT Projects 1 : Regression Suite for Japan WM –UBS Singapore

Duration

01th Mar 2017 – till date (Singapore)

Frameworks & Tool

Unified Functional Testing(UFT),Descriptive Programming, VB Scripting, QC with Automation Object Model, QC Open Test Architecture, Data & Keyword driven,QC-AOM,OTA

Role and Responsibilities

UFT Automation Test Lead:

Creation of functional Libraries using vb scripting

Use of descriptive programming to identify the objects uniquely

Test Execution from Jenkins & QC-AOM

Sending UFT reports/logs to stakeholders, team with outlook

Recovery Scenarios, Database connection with myself

Dynamic Test scheduler for running 5000 test cases based on inter-dependencies

Hadoop Projects HD1 : Analyzing Marketing Data for a Portuguese banking institution

Duration

01th Mar 2016 – Mar 2017 (Singapore)

Frameworks & Tool

Spark & Hive SQL, Spark Dataframe,Hadoop cluster with Data Block replication factor as three, Scoop, MapReduce, Hive, Cloudera Search,Hue, Scala, Python

Role and Responsibilities

Hadoop & SAS Developer:

Creation of Spark RDD and define schema with delimiter

Performing multiple actions and transformations using Spark and Hive SQL

Manually Import data file in SQL Server and import in HDFS, further using Spark Dataframe receive the required results

Analyze data reside in HDFS using Hive

Write MR code for analyzing data

Verify dataset and resultset using Cloudera Search and Hue

Selenium Projects SR1 : QTPSelenium Singapore

Duration

01th Apr 2016 – 30th July 2017 (Singapore)

Frameworks & Tools

Browsers

TestNG and Data Driven Framework, TestNG and Page Object Model(POM),TestNG and

Hybrid Framework (Keyword +Data Driven),Page Object Model with Page Factory,

Cucumber,Grid, Selenium RC,RC-Data Driven Framework,Subversion(SVN),Apache

Maven,Jenkins, POI jars, GIHUB, Selenium Web driver, Selenium IDE, TestNG

Framework with Ant/Maven Integration, XLS/XML files handling,Log4J,properties files,

handling with frames, drag and drop, cucumber

Internet Explorer 11,Mozilla 39.0,Chrome 59.0

Project Abstract

Facebook friends listing, Google books listing, Rediffmail tables listing, hidden objects in americangolfclub, find

different elements on yahoo and CNN

Role and Responsibilities

Automation Data Validation Lead:

Generic and application depended keywords to be read from Excel file

XPath’s of application to be read from properties file

Re-use the selenium code for implementing different test cases

Parallel Execution of test cases using TestNG

Compile the selenium code using Apache Ant build.xml and run it from command prompt & produce the HTML reports

Execute the selenium code on Internet Explorer,Mozilla and Chrome in parallel using Grid

Schedule the execution of selenium code using Jenkins (e.g. every 15min etc.)

Generate extended reports with pass/fail/skip status and along with snapshots

Send the error reports to stakeholders,along with failure step and snapshot

Selenium Projects SR2: QTPSelenium Singapore

Duration

01th Mar 2016 – 1st June 2017 (Singapore)

Frameworks & Tools

Browser

TestNG, Data Driven & Cucumber Framework, MYSQL, Apache Ant,Tomcat

Internet Explorer 11,Mozilla 39.0,Chrome 59.0

Project Abstract

Database Integration with CRM Application

Role and Responsibilities

Selenium Automation Test Lead:

Create root user credentials on MYSQL database

Connect the MYSQL using cmd

Verify selenium code for connecting to MYSQL

Create CRM Leadapp schema using .sql file and cmd in MYSQL

Deploy build.xml of Leadapp using Apache Ant and generate .war file

Deploy leadapp.war file on CRM application using Tomcat

Perform the Leadapp transactions using CRM Leadapp application and verify the data in MSSQL using selenium code

Execute the selenium code using TestNG and generate reports

Project 1 : Bank Of Singapore Limited –Singapore

Duration

01th May 2016 – 1st May 2018 (Singapore)

Technology

SQL Server 2012, Putty, shell scripts, EDW, Client Statements, Wealth Management,T24

Systems, Pega (AUT) & Test Management framework, PRPC Applications, BPM, Pega

Dashboard, Tracer

Project Abstract

Client Onbording &KYC,Client Data Migration

Role and Responsibilities

Selenium Automation Test Lead

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data validation which includes Pega Test(Automated Unit Test),data migration, Test using Tracer & Dashboard,Pega workflows, MSCRM BPM System data Test, ETL Testing (DB Test, client statement Test) Back end Testing, GUI Testing, Integration Testing, Functional Testing and Regression Testing, migration scripts validation from RDBMS to Hadoop network, validation using pig,hive and Spark on migrated data and analytics reports. Designed hybrid framework using selenium

Project 2 : Bank Of Singapore Limited –Singapore

Duration

14th Dec 2015 – 30th Apr 2016 (Singapore)

Technology

SQL Server 2012, Putty, shell scripts, EDW, Client Statements, Wealth Management,T24 Systems, SDIC rules,RM-Workbook

Project Abstract

SDIC New Regulations

Role and Responsibilities

Data Validation Engineer

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification testing including ETL Testing (DB Test, client statement Test) Back end Testing, GUI Testing, Integration Testing, T24 System Testing and Regression Testing.

Project 3: Union Bank of Switzerland -Singapore

Duration

16th May 2015 – 01st Dec 2015 (Singapore)

Technology

Ab initio, Putty, Oracle,Moxy, APX, APMH, GSM, Wealth Management,Midus Banking

Project Abstract

Core Banking of Wealth Management for Union Bank of Switzerland

Role and Responsibilities

Data Validation Engineer:

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification testing including ETL Testing (Graphs, Plans, Batch files and Components) Back end Testing, GUI Testing, Integration Testing, Functional Testing and Regression Testing.

Project 4: UAT Service POC -Singapore

Duration

1th May 2015 – 15th May 2015 (Singapore)

Technology

Special Employment Credit(SEC) for CPFB

Project Abstract

Singapore CPFB aspire to outsource their UAT Services to Cognizant by experiencing the service offering to them

for SEC

Role and Responsibilities

POC Member (Value Add):

●Involved in POC Team and working on Value add from Cognizant perspective as UAT Service provider where Client visit to CPFB encounters to review their flow of UAT Test and provide the value add to them with enclosure report.

Project 5 : Bank Of Singapore Limited – MSCRM & FATCA Reporting

Duration

1st March 2015 – 1th May 2015 (Bank of Singapore, Singapore)

Technology

MSCRM, Burp-suite 1.6

Project Abstract

MSCRM system facilitates the BOS customers to maintain user profiles, creation of accounts/contacts/VR reports/IR reports for the individual Entities & FATCA Reporting.

Role and Responsibilities

Data Validation Engineer:

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification Testing Back end Testing, Penetration Testing, GUI Testing, Integration Testing, Functional Testing and Regression Testing

Project 6 : OCBC BANK, Singapore –Tower Wealth Project

Duration

1st Jan 2015 – 1st March 2015 ( OCBC Bank, Singapore)

Technology

Java,AS400 System, INB, UTS system, SOA Services, Midus Banking System

Project Abstract

A unit trust is a pool of money managed collectively by professional fund managers. By buying units into the trust, your money will be pooled with that of other investors and invested according to the unit trusts objectives. For example, if customer invests in a China fund from INB channel, the fund manager will invest customer money by tapping into investment opportunities within China.

Role and Responsibilities

Data Validation Engineer :

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of Back end data verification, Integration Testing, Functional Testing and Regression Testing. As well as worked on AS400 systems such as EBS, RBK, SIBS, SICS andBase24 etc. Test data creation activities such as creation of UT accounts (SIBS-AS400, UTS system), INB access codes creation (EBS, SIBS system), analyze end of trading, day end, day begin batches of UTS system.

Project 7 : OCBC BANK, Singapore –Extra Cash Loan Project

Duration

1st Dec 2014 – 28th Jan 2015 (OCBC Bank, Singapore)

Technology

AS400 System, CLAS system, Global Pay Plus(Payment Services),SOA,INB

Project Abstract

OCBC offers the extra cash loan for the customer with eligibility criteria. Bank facilitates loan repayment with regular monthly plans, same day approval, rewarded on every approved loan, transfer loan to another bank and easy payment through online and mobile banking.

Role and Responsibilities

Data Verification (Team Member)

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification, GUI Testing, Integration data Testing, Functional Testing and Regression Testing. As well as worked on AS400 systems such as EBS, RBK, SIBS, SICS, CLAS, Global pay plus (GPP), Giro-3 Simulator andBase24 etc. Test data creation activities such as creation of extra cash loan application from CLAs, make it settled in SIBS and validate the GPP for the successful loan transactions to another bank.

Project 8 : OCBC BANK, Singapore –EMV Auto Renewal Project

Duration

1st Dec 2014 – 21st Dec 2014 (OCBC Bank, Singapore)

Technology

AS400 Systems, ATM,IVR,INB,EFTPOS,EDCPOS,BA Teller, Debit/Credit/ATM Cards

Project Abstract

OCBC system to identify the ATM cards which are yet to expire and as per monthly program for renewal needs to renew the cards. It also facilitates customer to alert via sms/email for renew of cards. System also involved termination of old cards, activation & performed transactions using ATM, IVR, Internet Banking, EFTPOS,EDCPOS,BA Teller

etc with different renewal criteria’s.

Role and Responsibilities

Data Verification (Team Member)

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification, GUI Testing, Integration data Testing, Functional data Testing and Regression Testing. As well as worked on AS400 systems such as EBS, RBK, SIBS, SICS, Test data creation activities such as creation of ATM cards; activate the cards, embossing files in EBS, SIBS system. It involves backend as well as transaction performed testing with physical cards and to validate the sms & reports.

Project 9 : OCBC BANK, Singapore –GIRO-3 Project

Duration

1st Aug 2014 – 30th Nov 2014 (OCBC Bank, Singapore)

Technology

AS400 System, INB, ATM, BV, IVR (Mobile Banking), EDCPOS, EFTPOS, Midus Banking

System

Project Abstract

OCBC Bank performs various activities such as payment and collections through Giro & IGiro facilities by integrated of various systems such as EBS, RBK, SIBS, and Base 24 etc.Core technology is AS400 system with inward &outward transactions performed through different channels for e.g. INB, ATM, BV, IVR (Mobile Banking), EDCPOS, EFTPOS. Bank also supports income Tax file to IRAS & CPF through DDA set-ups.

Role and Responsibilities

Team Member

Involved in Complete SDLC (Software Development Life Cycle) & performed Different types of data verification using Informatica (Transformations, Mapplets, Work let, and Tuning) Back end Testing, GUI data Testing, Integration data Testing, Functional data Testing and Regression Testing. As well as worked on AS400 systems such as EBS, RBK, SIBS andBase24 etc.

Project 10 : Bank Of New York Mellon, USA – MODIS Project

Duration

1st May 2013 – 30st July 2014 (Bank of New York, US)

Technology

Java, Soap UI, Informatica 9.1,IBM Websphere MQ Series, Oracle, Secure Shell Client

Project Abstract

Modis Application(Middle Office Input Output Deal System) is a J2EE Application deployed on web sphere application server 6.1.The new Application modis 61.er,will make use of spring 3.0 framework along with adobe flex framework for UI. The Application, synthesizes several components that are owned & maintain by different groups within & outside BNY Mellon

Role and Responsibilities

Team Member:

Project 11 : Lloyds-TSB Bank, London – Data Masking Project

Duration

1st Dec 2011 – 30th April 2013 (Lloyds TSB Bank, London)

Technology

Java, Mortgages Application,AS400 Mainframe system

Project Abstract

Data masking module keeps the data away from prying eyes in a cost-effective, highly secure alternative that guarantees data privacy, security, and compliance. As part of the LBG, the data masking module renders data unreadable by scrambling, encrypting and masking sensitive information. Yet, the software ensures the data format is retained, allowing all business functions to proceed seamlessly.

Role and Responsibilities

Data Validation Engineer(Team Member):

Personal Information -:

Date of Birth : 25-Oct-1989

Passport No : L9856148

Nationality : Indian

Visa Status : EP –Singapore(FIN : G3090716M)

Contact No : +65 83108012

Mail ID : ******.********@*********.***

Contact this candidate