SUMMARY:

• Have 10+ year of overall IT experience and 5+ year of onshore experience
• Designed, tested, and maintained ETL and BI On - premise and cloud systems
• Experience performing root cause analysis on internal and external data and processes to answer specific Regression Testing business questions and identify opportunities for improvement
• Strong analytic skills related to working with structured and unstructured datasets
• Good work experience as technical subject matter expert (SME)
• Oversaw the complete ETL and BI process
• Have good understanding of Retail store and eComm business including core Customer, Loyalty, Campaign and Transaction
• Have Good experience working with large data sets in on-prem, big data and Cloud environments
• Worked closely with team members, stakeholders, and solution architects
• Good work experience in ETL Code review, Unit testing, Functional testing, System testing, Integration testing, and UAT testing
• Good understanding of Production deployment and maintenance process
• Expertise in DWH, Database, ETL, data transformation, data migration and data warehousing and Business Intelligence solutions
• Extensive experience in developing SQL scripts to validate the databases tables and reports data
• Experience supporting and working with cross-functional teams in a dynamic environment
• Good expertise in ETL E2E automation pipeline using ICEDQ & Tricentis Tosca
• Extensive experience in Test plan, Test estimation, Test strategy, Test scenario design, Test case design, Test data design, Test execution and Defect Management
• Performed Proof of Concepts for the Automation tools
• Have good work experience with Onshore-offshore model and worked in a Global delivery environment
• Good understanding of US healthcare, Insurance, Retail, and Supply chain business

TECHNICAL SKILLS:

Area of Expertise: Senior Test Data Engineer, ETL/DWH/BI/Data Tester

ETL Tool: IBM Data Stage, Informatica PowerCenter

BI Tools: Cognos, Tableau

AWS: S3, Glue, RDS Aurora, DynamoDB, EC2, Lambda, Step function, SNS, SQS, Athena, QuickSight

Data Modeling Tools: Erwin (Fundamental understanding)

Data Base: Netezza, Snowflake (Azure), Oracle, SQL Server

Test Automation: ICEDQ, TOSCA

Test Management: HP ALM, JIRA, Rally

Scripting: SQL, Unix, Python (Basics)

Domain: Healthcare, Insurance, Retail and Supply chain

PROFESSIONAL EXPERIENCE:

Confidential

ETL-AWS Test Lead

Responsibilities:

• Worked closely with team members, stakeholders, and solution architects to understand project scope
• Understand Healthcare and insurance overall business ( for Insurance customer/member, provider, billing, claim, commission, Pharmacy, Vision, Dental and 1099 Tax data)
• Oversee the complete AWS Event based ETL pipeline design supporting and working with cross-functional teams(scrum of scrums model - Upstream and downstream systems)
• Create and manage Rally for creating feature, iteration, story, and tasks
• Responsible for leading team at both onshore and offshore team
• Responsible for ETL code review, Functional testing, System testing, E2E integration testing and UAT
• Responsible for creating Automation strategy with stakeholder and architects
• Create Test strategy & Automation strategy, Design/review of Test Scenario’s and test case, test data creation and create complex SQL and review Python scripts to Verify and validate data across multiple stage or layers within AWS
• Responsible for validating initial and incremental data loads and make sure data quality, data integrity/linage and latency has been met as per requirement and mapping document defined
• Responsible for data quality like File validation, Data validation, transformation validation between source and target systems, golden record validation, functional validation, Audit tables or flat file validation
• Responsible for work with PTM (Project test manager) to get Integrated test scenarios tested and uploaded into ALM and Rally (review). For issues defect will be created at ALM and Rally and will be triaged at Stand up meeting for fix
• Responsible for leading team and co-ordination on work items assigned and resolving offshore issues or impediments
• Participate in Agile ceremonies (Product backlog review, sprint backlog refinement, sprint backlog, Daily scrum, Sprint review, Sprint retrospective)

Confidential

ETL/DWH/BI Test Lead & SME

Responsibilities:

• Work closely with business, product owner and identify scope/requirement and contributed for creating/review stories for features and refining them
• Responsible for working with external stakeholder, Vendor to identify data need
• Responsible for Data profiling using reusable SQL scripts and identify elements required or identify gap at initial stage of phase
• Review logical and physical model and understand overall data flow, integrity of data and relation ship between entities
• Create and manage data mapping or S2TM rule and review with PO, business, scrum team (SME role)
• Review ETL high level and low-level design and find gaps at initial phase
• Work with Production control team on production deployment activities
• Responsible for creating Order of activity for production deployment (SME)
• Responsible for Understanding the project requirement and Testing requirement by going scope overview, solution architectures and Mapping Documents
• Identify the Scope of testing and approach and create Test strategy & Automation strategy, Design of Test Scenario’s and test case, test data creation with SQL, Spark scripts to Verify and validate process/data across multiple stage or layers responsible for validation of Customer master data (MDM) via third party data hygiene like Acxiom and Survivorship engine which keep latency data survived
• Responsible for validating initial and incremental data loads and make sure data quality, data integrity has been met as per requirement and mapping document defined
• Responsible for data quality like File validation, Data validation, Business rules validation between source and target systems, golden record validation, functional validation, Audit tables or flat file validation
• Responsible for system test, integration E2E test and regression testing using automation framework to validate data across stages
• Responsible for leading team and co-ordination on work items assigned and resolving offshore issues or impediments
• Participate in Agile ceremonies (Product backlog review, sprint backlog refinement, sprint backlog, Daily scrum, Sprint review, Sprint retrospective) responsible for User acceptance testing by working with product owner and business team

Confidential

ETL/DWH/BI Test Lead

Responsibilities:

• Participated in the requirements review meetings to define QA deliverables
• Prepared the QA estimations based on the requirements and participating in the team building activities
• Performed the Schema and Structural Validation based on Low level design document
• Created the Test Plan, Test Scenarios and Test Cases for review and approval
• Responsible for tracking the resolutions for QA clarifications and Test Readiness Review
• Validated data from source to target at each individual phase by ensuring the right external data source is mapped the right internal data source and Validated Files in MapR-FS (ODS like) using ETL Automation tool
• Validated tables in Apache Drill using complex SQL queries running in Drill shell against business requirement
• Validated data duplicates between data warehouse and MapRFS and whether there is any real business benefit in duplicating the data
• Validated data is extracted correctly as per business rules
• Performed Hadoop Eco system behavior validation by changing some parameters in Hadoop profile file
• Evaluated in advance number of nodes required in each test environment
• Prepared and used the test data by dumping some masked production data (realistic)
• Performed negative testing by Changing the input data, replicate the data files and validate all possible variations of input data
• Validated QlikView reports against Apache drill data and business requirements
• Responsible for defects tracking and publishing the test results

Confidential

Responsibilities:

• Understanding the project requirement by going through Business Requirement Documents, Mapping Documents Gathering user requirement, and prepare and conduct requirement analysis. Analyzing Testing Requirements
• Identify the Scope of testing and approach. Test strategy creation, test plan creation, Design of Test Scenario’s, test case writing, RTM, test data creation, Retesting/Regression testing Writing SQL/PLSQL codes to Verify and validate the Database, Data Mart, DWH data. Monitoring and executing Data Stage and Unix Batch Jobs
• Testing the data in the generated output file and database for different feeds that involved reading flat files and database and
• Populating xml files and database from the downstream application. Defect reporting, analysis and Estimate for testing
• Phase and planning their tests. Preparation of KT documents. Attending Technical review, Test Planning and Defect Review meetings
• Preparing the test Reports, logs and provide it to Project Manager, Development Manager, and QA Manager
• Extensively involved in testing the application developed in Agile Methodology

Confidential

Responsibilities:

• Analysis and Review of Business Requirements in the specification documents and Technical Design documents
• Preparation of Test Schedule, Test Plan, Test Script and Test cases
• Identification of data anomalies by doing thorough Data profiling Identification of data quality issues and working on designs to address them
• Setting up Test data for complete test coverage
• Validation and testing of ETL Functional testing, Integration testing, System testing, Regression testing, Testing the Data warehouse/DataMart data against the business logic requirement  and mapping documentation of Test Results (Test report matrix)
• Test estimation for testing requests Adoption of QA Best practices Creating Testing Status Reports, test summary reports
• Providing support during User Acceptance Testing (UAT)
• Used hive to validate huge data files for Merchandising financial data, Retail Management data & Retail price
• Management data from third party oracle and loading into Hadoop Distributed file systems (HDFS) using data ingestion tool SQOOP and Flume agent and validating in different layers in Hive (Fact, Dimensions & DataMart Views)
• Hadoop data validation (reconciliation) against flat files for correctness of the data in Hive
• Have Knowledge on Hadoop Distributed File system, Map Reduce, File Browser and Job Browser
• Understanding of Hadoop architecture

Confidential

Oracle, POM application

Responsibilities:

• Functional Test case and SQL queries preparation and execution based on the Functional specification in POM module
• Analysis of Business requirement for creation of Test Scenario for Test Cases Preparation
• Identify the Scope of testing and approach. Understanding the project requirements by going through System Requirement Specification (SRS), ER Design Documents
• Creating Test Summary Report and maintaining team daily Activity tracker

Confidential

Responsibilities:

• Involved in writing Functional Test cases and Test case execution for the functional testing in Engineering module and history module which is the major part of ANA project
• Logged bugs as much as possible for the applications given for testing
• Have got the opportunity to work on test management tool like RQM, defect tracking tool like Bugzilla
• Have tested both online and batch functions which are scheduled in JP1 scheduler
• Have direct interaction with the client for the execution of the Mascot application
• Have got many appreciations and from Client as well as onsite management level
• Have good working skills in database management like SQL scripting