PROFESSIONAL SUMMARY:

7+ years of professional experience as Data Quality Assurance Lead engineer in the field of Data warehousing (DW), Business intelligence & Big Data platforms. Proficient in understanding test requirements for DW & Big Data landscape and expert in strategizing End to End QA execution for DW & Hadoop components. Proficient in understanding new technologies, strong problem solving, troubleshooting skills, highly motivated and ability to work as an individual and also as a dynamic member in a team.

TECHNICAL EXPERIENCE:

Operating System: UNIX, LINUX, Microsoft Windows

Programming/Scripting Languages: Basic Java,SQL,PL/SQL, UNIX Shell Scripts, HQL, Pig Latin

BIG Data Ecosystem: Hadoop,Pig,Hive,Sqoop

Cloud Ecosystem: Amazon Web Services:S3,DynamoDB,Lambda,EC2,SQS,SNS

Database & DWBI Tools: Oracle, Netezza, SQL server, Teradata, Informatica,Microstrategy,Selenium

Other Utilities: Toad, SQL Developer, HUE,HP Quality Center,SQL workbench

Testing Methodologies: Functional, Regression, Automation and Agile

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Created data pipeline using Sqoop, HIVE to extract the data from different sources systems
• Developed Spark SQL application worked on Data frames, used SQL analytical functions, stored data into HIVE and parquet format
• Data lake implementation for ~4000 table pairs from 6 different heterogeneous source in a time span of 5 months using HQL and Pig scripts
• Designed and developed Incremental logic to append daily loads with Initial data
• Stored the processed data into Elastic Search using Spark
• Ingested the records to Elastic Search using Hive and Scheduled batches using Cron
• Scheduled Sqoop & Spark jobs through Cron
• Functional validation of real time data streaming from oracle to Hadoop using oracle golden gate and Flume integration
• Developed data replication framework and automated data validation between relational databases and Hive
• Development of complex Hive SQL with analytic function for AVRO,ORC layers of data
• Status report tracking for all sources across multiple implementation environments QA, UAT, and Production for status traceability during release
• Data Profiling/Analysis

Confidential, Hartford, CT

QA Lead

Responsibilities:

• Gathering requirements, test planning, preparing test strategy and customer walkthrough
• Preparing and reviewing test scenarios, initial & incremental test cases and test data preparation
• Reviewing implementation design to identify QA and automation focus areas
• Preparing test cases for ETL testing, Report Testing, validation across source system and Business scenario involving financial calculation testing.
• Observations articulation and publishing QA results to project team and UAT presentation
• Documenting artifacts for future release / enhancements
• Test design and execution for data warehouse Fact & Dimension tables

Confidential

QA Lead

Responsibilities:

• Involved in the preparation of Estimation and project plan
• Test Design, System and Integration testing of Personal lines Warehouse using ETL and BI approach.
• Test cases execution and defect management using HP Quality center defect management tool
• Involved in the review of test coverage document by analyzing the requirements and deriving test scenarios and traceability matrix.
• Organized Project Management Review meetings with various stake holders and collected various metrics for analysis
• Timeline planning of various deliverables from offshore and assisted the team in developing SQL queries for complex data validations and always delivered quality results on time
• Responsible for Test summary report review and sign off, managed the defect tracking process using QC.
• Test summary and open issues artifacts preparation for release coordination

Confidential

Lead Engineer

Responsibilities:

• Prepared Test Cases, Test scenarios and Data model understanding document
• Successfully involved in EIM Mass and Mop up Migration batches without any time delay
• Created an Autonomous procedure to complete day 0 activities which reduced manual work, time and effort.
• Resolved Migration related Bridges cases.
• Involved in Test Case Execution and reporting defects using HP Quality Centre
• Development of SQL, PL/SQL queries and reports for Data Quality check.
• Respond to the queries from Business user and provide support to the application.
• Involved in Project Review meetings and Process Improvement
• Troubleshooting and defect tracking on the delivered application

Confidential

Lead Engineer

Responsibilities:

• Resolved number of issues, queries, request and incidents raised by customers.
• Identified the defects in code and raised problem record against Dev team and resolved the issue.
• Assisted SIDE team check the Logmon and Procmon setting for all application.
• Created UNIX automated script for daily activities and monthly activities.
• Prepared PCI documents for review and achieved PCI score of 90% for all application in Billing and Payment.
• Involved in Test Case Execution and reporting defects using HP Quality Centre
• Development of SQL, PL/SQL queries and reports for Data Quality check.
• Respond to the queries from Business user and provide support to the application.
• Involved in Project Review meetings and Process Improvement
• Troubleshooting and defect tracking on the delivered application