Data analyst/QA Developer Resume

SUMMARY:

Confidential has 10 years of experience in IT industry and has worked in several projects for major clients as QA Developer/Business Analyst/Data Analyst .
He has extensive hands on experience in Data Analysis and Profiling , manual (Hadoop, Scala, Sqoop, Elastic Search, Big Data technologies, PL/SQL, MDM and Web Services) and automation (Selenium) testing.
He has worked in various domains like healthcare, insurance, technology etc. Suman has excellent analytical skills, thinking ability and communication skill.
He is experienced in executing projects for onsite - offshore model.
He has experience on the following Technologies :
Excellent hands on experience in SQL, ETL testing(Big Data/Oracle/Sql Server), MDM testing and Web Services Testing(Elastic Search/Kibana)
Exeperience in Waterfall and Agile methodologies
Experience in Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL) and automating the process
Experience in migrating the data using Sqoop from Relational Database System to HDFS and vice-versa
Experience in creating dataframes using Scala for data loading, analysis and comparision between Big data tables
Experience in Big Data APIs - Elastic Search and Kibana application
Experience in Automation testing using Selenium IDE and Webdriver using Java
Certified Professional in Oracle - OCA
Cognizant Certified Professional in Level 0: Siperian XU

TECHNOLOGIES AND APPLICATIONS:

Database(s): Oracle 10g, SQL Server, Hive, Elastic Search (Big data API)

Programming Languages: SQL, Hive Query Language, Java, Shell Scripting

Domain Knowledge: HealthCare, Insurance, Technology, Banking

Hardware / Platforms: Windows, Unix

Defect Tracking Tool: HP Quality Center 10.0, JIRA

Automation Tool: Selenium IDE and Webdriver for Automation

Applications: Informatica MDM, Kibana, SOAP UI

Methodology: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential

Data analyst/QA Developer

Technology:

Tools: Hadoop, Hive, Scala, Elastic Search API, Informatica MDM, SQL Server

Responsibilities:

His job duties include discussion with Business Users and Process owners to analyze and understand requirement specifications
Data profiling and analysis - create index model and provide input to data engineer team for implementation
Develop data quality rules and investigate data quality issues
Execute PL/SQL (Procedural language/Structured Query language) programs to identify gaps and leakages in data migration and data standardization/transformation activities in relational databases
Execute Hive Query language (HiveQL) to identify data errors in Hadoop (Big data) databases which is part of Cognizant’s Big Data Management application
Execute Elastic Search APIs (Big Data db) for JSON message transfer to determine message and data exchange between different applications
Execute programs to identify Matching and de-duplication of Customer data as per Business logic

Confidential

Data Analyst/QA Developer

Environment: Tools: Informatica MDM, Oracle SQL Developer, SOAP UI, Selenium IDE and Webdriver

Responsibilities:

Estimation and metrics generation
Profile data to understand the quality and gaps in the incoming Source System data - develop rules to address and enrich this data
Create data dictionary of all data present in the system
Preparation of the Test Strategy
Review of Functional test cases
Preparation and review of test data
Resource development, Project specific and knowledge transition

Confidential

Data Analyst/QA Developer

Environment: Tools: Informatica MDM, Oracle SQL Developer, SOAP UI, Business Data Director

Responsibilities:

Data profiling and analysis - provide input to data engineer team for implementation
Develop data quality rules and investigate data quality issues
Preparation of the Test Case template, Traceability matrix
Actively providing technical solutions to the team members
Test case Execution
Preparation and review of test data
Defect Tracking and Reporting

Confidential

QA Analyst

Environment: Tools: Siperian, Oracle SQL Developer

Responsibilities:

Preparation of Requirement Traceability Matrix
Identifying the test scenarios
Framing test cases based on the identified test scenarios
Test Execution, Defect Logging, Defect Tracking
Validating different source system data against the destination tables starting with Standardization, Match Merge, Survivorship
Validating the mapping/transformation logic at each level
Validating various cleansing and address standardization functions

Confidential

QA Analyst

Environment: Informatica MDM, Oracle SQL Developer, Business Data Director

Responsibilities: