We provide IT Staff Augmentation Services!

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:

  • Preparation of Requirement Traceability Matrix
  • Identifying Test scenarios
  • Preparation of Test Cases
  • Test Execution, Defect Logging, Defect Tracking
  • Coordinating with the Onsite and Development Team on daily basis
  • Test Data preparation
  • Preparation of Test Closure report

Hire Now