ROSHAN SINGH

Software Testing and Quality Assurance Professional

with over eight years of experience in Software Testing, I have honed my skills in AWS and Big Data environments. My expertise extends to project planning, scoping, estimation, and tracking, leveraging case and system studies for effective management. I am proficient in managing all documentation and ensuring quality control throughout the software development lifecycle.

My technical proficiencies include manual and automation test case scripting, review, execution, defect reporting, tracking, and follow-up. I am well-versed in Software Testing Life Cycle (STLC) stages, CMM practices, Defect Management Life Cycle, Agile methodology, and various testing types (Functional, Web, Regression, Product, System, Automation, Manual).

I am a strong communicator with excellent analytical, problem-solving, and interpersonal skills. I am seeking a challenging role in Software Testing and Quality Assurance with a reputable IT organization where I can contribute my expertise and drive quality initiatives.

Big Data and Automation Specialist

With a proven track record in leveraging big data technologies and automation frameworks, I am adept at designing and implementing robust data pipelines for ETL, data analysis, and testing. My experience spans across various tools and platforms, including Hadoop, Hive, Pig, Sqoop, MapReduce, Oozie, Kafka, AWS services, and automation frameworks like Robot.

Key Skills and Experience:

• Big Data Technologies: Hadoop, Hive, Pig, Sqoop, MapReduce, Oozie, HBase, Kafka
• Cloud Platforms: AWS (S3, EC2, DynamoDB, Athena, AWS crawlers)
• Automation: Robot Framework
• Data Warehousing and ETL: Hive, Sqoop
• Data Analysis and Transformation: Hive analytical functions
• Testing: End-to-end functional testing for big data applications
• Process Management: Requirements analysis, QA planning, bug tracking
• Problem-Solving and Communication: Strong analytical and interpersonal skills

I have a successful history of migrating data from traditional databases (Oracle, MySQL) to Hadoop, capturing data using Sqoop, and performing ETL operations in Hive. Additionally, I have implemented proof of concepts for various big data analytic tools and have experience in automating testing processes using Robot Framework.

• AWS
• Hive
• HBase
• Kafka
• Hadoop Testing
• Hadoop Framework
• Spark framework
• Oracle
• SQL Developer
• SOAP UI
• Manual Testing
• Soap UI
• Web services
• Post man
• Rally
• HP Quality Centre 10
• IBM DB2

• Achieved 1st Rank in Mathematics Test organized at District Level in 2007
• Leaded the team to win various Cricket tournaments at School and College Level
• Served as Member of the Core Committee for College Fresher’s Welcome in 2009
• Served as President for 1 year in Working Committee in School
• Was elected as Class Representative in college during 2006-2007

• Key Achievements: Successfully built and maintained a data lake from scratch, ingesting data from various applications into a unified Global Data Format for business and analytics reporting.
  Implemented and managed data pipelines using Hadoop, MapReduce, HDFS, Hive, and Hive-QL, ensuring data quality and consistency throughout the process.
  Conducted comprehensive testing of data pipelines, including validation of Hive tables, MapReduce scripts, and Redis data.
  Utilized AWS technologies (S3, EMR, EC2-USER, Athena) for efficient data storage and processing.
  Implemented automation testing using Jenkins, Selenium, Python, and Pytest to improve efficiency and test coverage.
  Proficient in SQL, NoSQL databases (HBase), and data streaming tools (Kafka).
  Collaborated effectively with clients and team members to deliver high-quality data solutions.
  

• Key Achievements: Designed and implemented data lake architecture, ensuring data integrity and compliance with business requirements.
  Validated data transformations and CDC processes to maintain data accuracy.
  Monitored and optimized data ingestion performance from multiple databases.
  Utilized Apache Airflow for workflow scheduling and management.
  Provided technical expertise and support for data-related initiatives.
  

• Key Achievements: Contributed to the development of a personalized video recommendation system based on user behavior data.
  Conducted rigorous testing of data pipelines and recommendation algorithms to ensure accuracy and relevance.
  Utilized Hadoop and related technologies to process and analyze large-scale user data.
  

• Key Achievements: Played a crucial role in migrating a legacy system to a Hadoop-based architecture.
  Conducted comprehensive testing of the ETL process and data pipelines.
  Utilized Hive, HBase, and Kafka for data analysis and streaming.
  Developed automation scripts using Robot Framework and Python to improve testing efficiency.
  Provided support to the manual testing team and collaborated with cross-functional teams.
  

• Key Achievements: Contributed to the development of an automated data card management system.
  Developed and executed automation test scripts using Selenium.
  Participated in agile development methodology and contributed to test case design and execution.
  Provided support to the team and collaborated with stakeholders.
  Analytical Data Store (ADS), Lineage, AWS & Big Data - Hadoop Tester, April 2021 to Present, 14, Hadoop testing, Database Testing, Snowflake query, API, AWS, S3, EMR, EC2-USER, Athena, Jenkins, Selenium, Python, Pytest, PyCharm, Snowflake, Matillion, SOAP UI, Oracle SQL Developer, JIRA, Data Specialist, Built Data Lake from scratch, holding data from different applications of the client into the common platform in Global Data Format which is being used by clients for business and analytics reporting. Data in Data Lake is residing in various layers like landing, refined, curated, aggregate, and is serving the client’s analytical needs. Each layer in the Data Lake is holding data of different quality. Two major activities are done in the Data Lake building – Hydration (one-time execution) and CDC (Daily Execution, Business as usual)., Experienced in Testing of Data pipeline built using Hadoop/Map Reduce/HDFS/Hive/Hive-QL environment, Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases., Involved in validating Hive Tables, from loading of data from source and analyzing data using Hive Queries., Validation the end data in Redis database, which is in key value pair., Validated the Map reduce, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files Test and validate data at all stages of Hadoop process., Performed various Hadoop controls like date checks, record checks, performance checks., Consolidate all the defects, create defect reports and publishing the test report after the completion of testing., Involved with data transformation and analysis tool like Hive, Involved with No-SQL database like HBase, Involved working with Big Data and Hadoop File System (HDFS)., Hands on experience in working with Echo systems like Hive, Sqoop, Map Reduce., Involved in Jenkins configuration setup for creating automation job, Interacting with client on a daily basis for user stories reviews, test cases integration calls and mailing them reports and work status on a daily basis., Reporting of Issues in the Rally and ensure the mitigation, Risks and resolutions., Performed rest API testing using POSTMAN.
• Enterprise Data Platform, E-solutions, AWS & Big Data - Hadoop Tester, 14 Months, 12, Built Data Lake from scratch, holding data from different applications of the client into the common platform in Global Data Format which is being used by clients for business and analytics reporting. Data in Data Lake is residing in various layers like landing, refined, curated, aggregate, and is serving the client’s analytical needs. Each layer in the Data Lake is holding data of different quality. Two major activities are done in the Data Lake building – Hydration (one-time execution) and CDC (Daily Execution, Business as usual)., Experienced in testing end to end data flow in the data lake framework and ensure the data transformed as per the business logics., Experienced in validating the CDC (insert/update) data loading from source to target layer., Experienced in validating the CDC deleted records are appending correctly with the old record., Verify the number of partition files are getting created as predefined in S3 path., Verify the workflow scheduling with the help of Apache Airflow tool., Verify the performance of data ingestion from multiple DB’s at a time and report if there is any performance issue., Verify the aggregate snapshot data is correctly loading.
• Video Recommendation overseas, Huawei technologies India, Big Data - Hadoop Tester, 13 Months, 14, Video recommendation project aims to providing an end-to-end Video service Business to its Middle East users, using Huawei’s and Honor mobile phones. Following are some of the areas handled within the project: Providing the end user his favorite playlist (Videos), his favorite Genre and the Language based on his listen behavior (Play, download, search, share, likes) information associated with his listened behavior is collected with user’s acceptance and the recommendation is provided to end user based of its listening behavior, Providing the end user songs and playlist which they may like., Experienced in Testing of Data pipeline built using Hadoop/MapReduce/HDFS/Hive/Hive-QL environment, Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases., Involved in validating Hive Tables, from loading of data from source and analyzing data using Hive Queries., Validation the end data in Redis database, which is in key value pair., Validated the Map reduce, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files Test and validate data at all stages of Hadoop process., Performed various Hadoop controls like date checks, record checks, performance checks., consolidate all the defects, create defect reports and publishing the test report after the completion of testing.
• PatientCare and Health Advice System, Aetna, 02 years 05 months, 13, Windows 7, Mozilla Firefox, Hadoop testing, Database Testing, Hive query, HBase, POSTMAN, KAFKA, Robot framework, Jenkins, Automation testing, Hive, Toad, SOAP UI, Oracle SQL Developer, RALLY, Java, Test Engineer, Patient Care and Health Advice System has four modules Hadoop, oracle database, Rest API, and PHAS front-end. It is a Business Intelligence having a Decision Support System with the clinical algorithms that analyses patient clinical data from submitted claims & other sources, identifies member’s health problems, and provides suggestions and recommendations to improve member health. Later this project was migrated into Hadoop system, where ETL process was replaced by Big Data., Involved with data transformation and analysis tool like Hive, Involved with NoSQL database like HBase, Involved working with Big Data and Hadoop File System (HDFS)., Hands on experience in working with Echo systems like Hive, Sqoop, Map Reduce., Involved with Data streaming tool like Kafka., Excellent problem-solving skills, high analytical skills, good communication and interpersonal skills., Involved in Database testing using SQL Server and Oracle server., Providing Support to manual testing team whenever data setup is required., Involved in writing Automation scripts by using Robot framework and python, Involved in Jenkins configuration setup for creating automation job, Well versed in using GIT command, Interacting with client on a daily basis for user stories reviews, test cases integration calls and mailing them reports and work status on a daily basis., Reporting of Issues in the Rally and ensure the mitigation, Risks and resolutions., Performed rest API testing using POSTMAN.
• Admin Services, Mphasis, 01 Year, 4, Windows 7, Mozilla Firefox, SQL, SOAP UI, Automation Testing, Selenium, Rally, SOAP UI, SQL Developer, Java, Software Engineer, It is a Business Enterprise Web based application, in which Manual management of data cards is replaced by an automatized process of data card management, Online approval/rejection of data card requests, organize unstructured data of the data cards issued/lost/returned/replaced, enabling multiple users to work together in a coordinated fashion over time and space., Adopted agile methodology for Testing., Development of automation scripts in selenium., Contributed to test case design, data setup and execution., Logged observations in Rally for different stories for business., Monitored team on daily progress., Attended daily status call with clients shared status report focused on daily progress., Generated and validated reports.

• Hadoop Testing: Successfully completed a Basic Hadoop Testing training program at Huawei Technologies India Private Ltd. in December 2019, gaining foundational knowledge in Hadoop ecosystem and testing techniques.
• Python & Selenium Automation: Participated in a Python and Selenium automation training program at Emids Technologies in May 2020, developing proficiency in scripting, test automation, and web application testing using Python and Selenium tools.