SUMMARY:

• 13 years of Hands on industry experience as QA Lead, Individual Contributor in Big Data/Hadoop Analytics and Traditional ETL landscape.
• Worked closely with the Analytics Services on testing data from data - lake to advance analytics platform
• Analyzed, Defined and Validated data transformations and documentation sprouting from the business problem.
• Involved in Data test preparation and validation for advanced analytics team and data-scientists to improve business processes
• Performed data analysis of the internal and external source data and implement transformations and computational solutions to identify new solutions and maximize the model outcomes
• Supported implementation of models and methodologies to predict, quantify and/or forecast various operational and performance metrics
• Analyzed, exploited, and presented insights to add value to customer’s business processes
• Collaborated with quantitative and qualitative researchers and iterate quickly to generate usable insights for product and business decisions
• Identified and reported notable difference in key metrics to the project stake holders as a part of data validation and QA process
• Recommended theoretically and practically sound solutions with end users in mind
• Provided detailed analysis and documentation of methods, techniques, and findings
• Collaborated with internal teams to facilitate technology led data validation solutions for enterprise risk systems
• Validated and supported data models, data-mining methodologies, and reporting of metrics throughout the project lifecycle
• Coordinated with domain experts to develop and refine data quality management best practices, policies, and procedures

TECHNICAL SKILLS:

Hadoop: HDFS, HIVE

No SQL: HBASE

SPARK: PySpark, SPARK SQL, DATAFRAMES

Scripting: Python / Shell

RDMBS: Oracle, Teradata

Data Integration Tool: Ab-Initio, Informatica

General Purpose Utilities: Toad, Teradata SQL assistant, SQL developer,

Query Language: Oracle SQL, Teradata SQL

Test management: HP ALM, Version One, Rally

Operating System: UNIX, OSx

Project Models: Waterfall, Agile

API: REST

PROFESSIONAL EXPERIENCE:

Confidential, Cupertino, CA

QA Lead

Responsibilities:

• Performed Data Analysis Using Teradata SQL and HIVE QL for Large Data Sets
• Performed Back End Data Validation in the service layer using CURL and POSTMAN
• Created Automated Regression test suits using HIVE QL, Teradata SQL and Shell Scripts
• Performed Sequence file validation for Optimized Row Columnar Data (ORC)
• Ensured proper implementation of HIVE Query optimization techniques
• Used Hive queries for effective sampling of data for business logic validation
• Used basic Python scripts to automate ad-hoc tasks so as to expedite the QA turn around
• Performed DQM Checks for notable key metrics after aggregation load
• Collaborated with Business to ensure delivery compliance with the requirement
• Ensured implementation of quality standards at each phase of the SDLC
• Performed Cross Functional validation with upstream and downstream teams
• Authored Key-QA reports at each stage of QA lifecycle
• Owned the implementation of QA Process from an End-To-End perspective

Confidential, Alpharetta, GA

Test Lead

• Performed Data Ingestion, Batch Processing and Data Load Validation
• Authored Shell scripts for Chaining of QA jobs to help reduce manual intervention
• Extensively Used HIVE QL to validate the mapping Logic post data load in HIVE tables
• Used HBase DDLs and DMLs to ensure data quality in persistence layer
• Validated the Data in the service layer through REST API calls against Back end databases
• Implemented QA Automation Tasks to deliver QA Deliverables in Short sprint cycles
• Adhered to and Implemented Quality standards during QA Lifecycle
• Implemented the Agile delivery model for successful delivery of the product
• Extensively used Rally as an Agile tool to manage, monitor and report QA Tasks
• Collaborated with Advanced Analytics team to understand their data requirement and ensured to deliver the same with highest level of quality maintained

Confidential, Orlando, FL

Sr Test Engineer

• Requirement Gathering, Analysis, Documentation, Review and QA artifact creation
• Collaboration with Business Analyst to understand the Key Metrics around Disney data
• Meaningful documentation and mitigation of gaps in requirement understanding by consistent collaboration with project stake holders and end users
• Collaborated with development team to understand the technical implementation of business logic
• Used Informatica W/F manager to execute he ETL jobs for business logic validation
• Used Informatica W/F monitor and Unix console to monitor the logs for the ETL jobs
• Performed RCA and Debugging the failed jobs and communicated the scrum team
• Extensively used Version-One as an Agile tool to manage, monitor and report QA Tasks
• Ensured implementation of quality standards at each phase of the SDLC

Confidential

Sr Test Engineer

• Was responsible for requirement analysis, test case authoring and reviewing
• Collaborated with SMEs to ensure no-gap deliverables from QA side
• Manually executed Ab-Initio ETL Jobs using Unix wrappers
• Validated the loaded data against the mapping logic thus provided by the business
• Validated the. XFR and. DML files to ensure proper implementation of requirement
• Performed Root Cause Analysis and Debugging of the failed Jobs
• Was responsible for test artifacts creation and management in HP-Quality Center
• Adhered to the instructions from the lead and industry requirements for QA deliveries

Confidential, Columbus, OH

Test Engineer

• Performed extensive testing for ETL processes in Enterprise Data Warehouse
• Manually executed Ab-Initio ETL Jobs using Unix wrappers
• Validated the loaded data against the mapping logic thus provided by the business
• Validated the. XFR and. DML files to ensure proper implementation of requirement
• Performed Root Cause Analysis and Debugging of the failed Jobs
• Was responsible for test artifacts creation and management in HP-Quality Center
• Adhered to the instructions from the lead and industry requirements for QA deliveries
• Performed REST-FUL Service validation using client tools and SQL