SUMMARY:

• Good experience in Testing as Technical Test Lead, Sr. Test Analyst, Data Analyst and involved in Test Deliverables like Test Plan, Test Strategy and Test Completion Report Software Testing Consultancy operations.
• Overall 14+ years of IT experience in various domains and technologies.
• 4+ years of extensive hands on experience with Hadoop Ecosystem stack including HDFS, Map Reduce, Spark, Apache Nifi, Kafka, Python Spark, Apache Phoenix, Talend, Flume, Sqoop, Pig, Hive, HBase, Cassandra, Oozie, Autosys and Dependency Manager.
• Experience with cloud architectures like Amazon AWS S3 & EC2.
• Strong understanding of Agile Scrum and Waterfall SDLC methodologies.
• Knowledge on working with No - Sql databases like Cassandra, Mongo & Hbase for a Real steel project.
• Extensive experience on various ETL tools (Informatica/Ab-Initio/datastage/Talend), Databases (Teradata, Oracle, SQL Server, MySQl), BI Tool (Business Objects, Cognos, Kyvos), TDM (IBM Optim, Informatica ILM), Big Data Hadoop (Hive, Pig, Sqoop, Hbase, Kafka, Apache Nifi).
• Experience in providing automation solution for ETL projects and has implemented Wipdva (data validation automation solution) for ETL Projects for regression testing.
• Experienced in Analyzing Business Specifications with excellent organizational skills and Good understanding of teh testing effort by analyzing teh requirements of project.
• Extensive hands-on experience in test planning, test execution, defect reporting and test results analysis with project stakeholders.
• Good Knowledge in teh finance, Banking, Retail, Telecom domains.
• Client Engagements, Contract Negotiations and Resource Augmentation for Project Management
• Planning, scheduling, and monitoring projects, Preparing Test Plans, Metrics, and risks

TECHNICAL SKILLS

• Project Management
• Delivery Management
• SLA Management
• New Initiatives
• Process Management
• IT Services
• Enterprise
• Finance, Banking & Insurance
• Retail Telecom
• .NET, VB/ASP
• SQL Server, Oracle, Teradata, Oracle SQL developer, My SQL, PLSQL Developer
• Informatica 8.5, Teradata SQL Assistance 12, Ab-Initio, Talend 6.1
• Quality Center, SAP BO, BODI, BOXI, Cognos, HP QC, HP ALM,
• Dependency Structure Matrix, Defect Flow Analysis
• MS Project Test Director, Jira
• Pig, Hive, Sqoop, Apache Nifi, Kafka, Apache Drill, Spark Sql, Hbase, Ozzie, Mongo, Cassandra, Apache Phoenix, Talend, Kyvos Insights, Hadoop ecosystem

PROFESSIONAL EXPERIENCE

Confidential

QA Lead Engineer

Responsibilities:

• Validated data imports from various operational sources, performed transformations using Hive, MapReduce, Tez & Spark programs Define dashboard requirements.
• Worked on Apache Nifi, Kafka, Spark Sql, Apache Drill, Squirrel Sql, Amazon Aws, Amazon Ec2, Mapr File system for data imports and data transformation.
• Verify data imports from AWS S3 into Mapr FS and processed data to external source including Oracle, Teradata tables.
• Developed teh Test Plan and responsible for designing teh test strategy.
• Verified Implemented company policies, technical procedures, and standards for preserving teh integrity and security of data, reports and access.
• Involved in validating jobs processed through Python programing to validate data processed on NoSQL DB, Hive Tables.
• Coordinate with data architect and developers utilizing JIRA to prioritize data and platform requirements for analysts based on client needs.
• Removed impediments by creating an ad hoc request system for analysts to monitor new requests and helped to communicate with stakeholders regarding deliverable time and prioritization.

Confidential

Lead Consultant Onsite

Responsibilities:

• Validated data imports from various operational sources, performed transformations using Hive, MapReduce, Tez & Spark programs.
• Performed API Testing with REST web services using Java programming language
• Participated in planning and estimation meeting for analyzing requirements for test case preparation
• Developed teh Test Plan and responsible for designing teh test strategy
• Validated Web services using SoapUI tool.
• Actively performed negative testing, positive testing, ad-hoc testing, manually
• reviewed activities related to business requirements, Design, Test Strategy and Test Case Review
• Implemented company policies, technical procedures and standards for preserving teh integrity and security of data, reports and access
• Involved in validating Java Ingestion framework and Oracle metadata process control framework.
• Involved in validating jobs processed through Talend ETL tool and validate data processed on Hbase & External Hive Tables.
• Loaded data into HDFS from external source system and Oracle DB, Teradata using Sqoop and exported teh summarized data to teh relational databases to perform visualization and report generation jobs.
• Validated data loads on no-sql databses.
• Verified Pig Latin scripts to support multiple data flows involving various data transformations on input data.
• Involved and supported validations for Data Ingestion - Historical, Incremental. Validation, curation logic validation with complex business scenarios. Validation of data movement from HDFS curation files to Hdfs No-Sql databases for end to end business logic validation.
• Performed validation and standardization of raw data from XML, Salesforce and JSON files.
• Good exposure in analysing and validation data with Text, XML, Avro, Json, Parquet
• Implemented ad-hoc queries using HiveQL, created partitions to load data.
• Verified Hive Incremental updates.
• Performed various data warehousing operations like de-normalization and aggregation on Hive using DML statements.
• Executed end to end data validation on complex curation models.

Confidential

Lead Consultant

Responsibilities:

• Involved in Front-end and Functional Testing of teh GUI by inserting various checkpoints in teh recorded test scripts.
• Developed Test Plan, Test Scenarios, Test Cases, and Test steps for various Business
• Services/methods covering both Positive and Negative testing requirements.
• Good experience on Tracking bugs in JIRA and reporting teh defects to teh developers for Modification Request
• Validated data imports from various operational sources, performed transformations using Hive and MapReduce.
• Validated data load into HDFS from MySQL and Oracle DB using Sqoop and exported teh summarized data to teh relational databases to perform visualization and report generation jobs.
• Verified Pig Latin scripts to support multiple data flows involving various data transformations on input data.
• Experience in working with job scheduler like Autosys and WFM tool.
• Involved and supported validations for Data Ingestion - Historical, Incremental. IT flattening validation, curation logic validation with complex business scenarios. Validation of data movement from HDFS curation files to DB2, Netezza databases for end to end business logic validation.
• Performed validation and standardization of raw data from XML, Salesforce and JSON files with Pig.
• Implemented ad-hoc queries using HiveQL, created partitions to load data.
• Verified Hive Incremental updates using four-step strategy to load incremental data from RDBMS systems.
• Performed various data warehousing operations like de-normalization and aggregation on Hive using DML statements.
• Executed workflows in Oozie to validate automated tasks of pre-processing data with Pig, loading teh data into HDFS and scheduling Hadoop tasks.
• Executed end to end data validation on complex curation models.