SUMMARY

• Over 14+ years of IT experience in RDBMS & Data warehousing, ETL developer, Experience in testing, requirement analysis, Data analysis, Code review analysis, implementation and support.
• 4+ years Development in Ab Initio, EME, UNIX & Shell scripting, CONTROL - M, Tivoli SQL SERVER and Oracle.
• 2+ years Development in Big Data Hive and Pig
• 1+ Years Automation experience with Python and Excel Macros
• ETL Testing (Ab initio), Performance Testing (Big data), Data Masking Testing and web-based & reporting systems testing (Axiom).
• Agile Scrum master experience - Manage Scrum boards, sprint backlog items, Scrum metrics (burndown, velocity) to help deliver committed work
• Experienced in RequirementAnalysis, Data Analysis, Test data and environment preparation, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Migration, Data Extraction, Data Transformation and Data Loading (ETL)
• Strong understanding of Data Modeling in data warehouse environment such as star schema and Snow flake schema.
• Work experience of writing the complex SQL Queries for ETL, Big Data, Data Ingestion, Data Transformation, Data Quality and Data Migration
• Experience in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writing Test Scriptsby decomposingBusinessRequirements, and developingTest Scenariosto support quality deliverables.
• Professional experience inIntegration, Functional, Regression, System Testing, Load Testing, UAT Testing,Black BoxandGUItesting.
• Have 7 years onsite experience in US and experience working with on onsite/offshore model.
• Involved in all the phases of the Software Testing, like Test Planning, Test Strategy, Project Estimation, Requirements Traceability Matrix, Test Design, Execution, Defect tracking and reporting.
• Extensive knowledge in ETL testing, Data warehousing Concepts, ETL Mappings, Data Transformation Logic and Data Validation and writing complex SQL Queries, Python scripts and Unix
• Experience in the Ab initio workflows, Data Stage jobs, Hive and validating the error logs and data present in different layers.
• Experience in QC (ALM), Jira for defect management, defect tracking and bug reporting.
• Strong knowledge and experience in User Story Writing along with Story Boarding and Story Mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

TECHNICAL SKILLS

Test Management Tools: JIRA, HP ALM & RTC

Programming Skills: Big Data Hive, Big Data PIG, Python, RPGLE, RPG400, RPGIII and RLUDevelopment Tools Hadoop, SQOOP, Flume, HBase, Ab initio, AS/400, Data masking and UNIX

Data Base: DB2/400, QUERY/400, SQLRPG, SQL

Reporting Tool: Axiom

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Responsibilities:

• As a member of the Scrum team participated in daily standup, backlog grooming, sprint planning, project status meetings, retrospective meeting as well as end of the sprint demo
• Report well written bugs and track it through closure in co-ordination with developer and scrum master to contribute proactively to better the software testing process and following AGILE development lifecycle
• Interacted with Business Analysts and Developers in requirements analysis, design reviews, testing and documentation for application developed in Agile environment
• Analyzed the Business Requirements Document (BRD) to develop a high level Test Plan and Test strategy.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database.
• Validating data for 8 million row that pass through Rule Engine and make sure rules are executed.
• 1UPA web validation for Security login, Uploading Rules, Rule approve process and data processed.
• Data Validation from Staging to working table
• Three major Escheatment reports are validated on backend and as well on UI screen that data covered all Business rules
• Generating reports for business users to validate if the data in the reports are as per expectation. It involves finding deviation in reports and cross-check the data in the target system for report validation
• Created ETL test data for all ETL mapping rules to test the functionality.
• Performed backend testing using SQL Queries and compare the Result with Report.
• Validating User Screen data, Error Messages that populated from database.
• Validation on Comparing the Source data landed on Hadoop
• Worked closely with stake holders and partners to lead the UAT efforts
• Logged defects in HP ALM and worked with Dev team to fix all of these.

Confidential, Boston

Project Leader

Responsibilities:

• As a member of the Scrum team participated in daily standup, backlog grooming, sprint planning, project status meetings, retrospective meeting as well as end of the sprint demo
• ESP-ETL Testing on GLR,13F,Regulator Report and other Axiom functionality Report testing
• Report well written bugs and track it through closure in co-ordination with developer and scrum master to contribute proactively to better the software testing process and following AGILE development lifecycle
• Actively involved in implementation of Test Automation Framework build using Python
• Interacted with Business Analysts and Developers in requirements analysis, design reviews, testing and documentation for application developed in Agile environment
• Analyzed the Business Requirements Document (BRD) to develop a high level Test Plan and Test strategy
• Experience in Data Masking in identifying and masking sensitive test data to meet security requirements and business data rules of integrated systems
• Creating test data for Data Masking and strategy needs with respect to data sub setting, data generation, data masking and testing methodology to align with new Business requirement and compliance
• Created Test plan, Test strategy, Critical scenarios and Test Scripts and schedule for testing.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Involved in Data Warehouse testing while sourcing data from multiple sources to SDAR.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports
• Created ETL test data for all ETL mapping rules to test the functionality of the ESP and ELT Mapping.
• Performed backend testing using SQL Queries and UNIX scripting.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application
• Strong in writing SQL queries and makes table queries to profile and analyze the data in ORACLE
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ESP ETL, Big Data and Axiom Flow.
• Verified whether the front-end sales were correctly stored in the back-end database by using SQL queries
• Used JIRA for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools.
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts
• Experienced in creating Requirement Traceability Matrix (RTM) and identifying missing specifications.
• Coordinate with QA’s and development teams onshore and offshore throughout the life cycle of the project.
• Work Closely with Product Owner to maintain backlog, review stories, clarify requirements, prioritize defect, create epics and help story mapping. Conduct working sessions and walkthroughs of new functionality.
• Provide QA time estimates and assist in creating schedules, determine project scope and drive projects to completion.
• Represent the team in strategy meetings with Stakeholders to discuss and suggest possible future enhancements of existing functionality.
• Involved in different test phase like Dev, QA, PRE-PRODS and PRODUCTION environment
• Performed Back End Testing by using Siebel and SQL developer tools for loyalty and rapid reward project.
• Verified request and response logs in corresponding log boxes by logging into the remote Linux machines through PUTTY
• Performed Security testing for unauthorized access of the application with positive and negative testing

Confidential

Ab initio AS/400, ESP, UNIX, Big data

Responsibilities:

• ESP-ETL Migration testing with GLSR Reporting using Data masking Tool
• Verification of data transformation calculations and aggregation rules
• Created ETL test data for all ETL mapping rules to test the functionality of thegraphs.
• Developed Test Frameworks in Python for Regression Test Automation and when necessary, and potentially execute Unit Test Automation
• Data integrity and quality checks in the report system and Test data comparison between the source and the report system
• Experience in creatingTest Readiness Review(TRR), Requirement Traceability Matrix(RTM)documents.
• Prepare test data utilizing automated data extraction and data masking methodologies
• Exposure to data disguising technology of confidential data such as customer personal identifiable information (PII) such as data obfuscation and data masking
• Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Reviewed and validated business requirements with Business Analyst, Technical Lead and SMEs.
• Interacted with developers and users to analyze the business requirements and functional specifications in anAGILEDevelopment Environment.
• Generating reports for business users to validate if the data in the reports are as per expectation. It involves finding deviation in reports and cross-check the data in the target system for report validation
• Validating User Screen data, Error Messages that populated from database.
• Validation on Comparing the Source data landed on Hadoop
• Testing on Screen update values are loaded into the database
• Developed Test plan and created/executed manual test cases/test scripts to test the core functionality of the application
• Participated in all the AGILE ceremonies - Daily Standup, Grooming, Sprint Planning, Retrospective, End of the Sprint Demo and Product Backlog Meeting.
• Created and maintained SQL queries to perform back-end testing. Created and executed scripts manually for Functionality testing.
• Involved in testing specific application features like adding/removing products to cart, order flow through, Email configurations as part of application testing
• Performed cross-browser testing to check the functionality of the application in various browser.
• Actively participated in the Review meetings for Functional Specifications Document and Technical Design Documents.
• Worked closely with stake holders and partners to lead the UAT efforts
• Logged defects in HP ALM and worked with Dev team to fix all of these.
• Assist Test Manager in managing day-to-day testing activities, such as test monitoring and status reporting at the end of the testing day.
• Created Traceability Matrix between requirement and test cases.
• Participated in Project Status and Defect triage meeting for the review of defects in Quality Center along with Business Analyst and Developers.

Confidential - Chicago

Ab initio, Big Data, UNIX,Python

Responsibilities:

• Execution Monthly & Weekly cycle and completion of cycle within SLA.
• Need to analysis the compatibility between versions on New X86 server
• Validating the Data in backend updated by Batch Job.
• Validating Performance through Data ingestion, throughout and processing.
• Worked on testing very large Hadoop cluster with 400 nodes and used Hue for executing hive queries and viewing databases and for Job control.
• Suggested and reviewed Materialized views to store aggregate values
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting with senior peers or subject matter experts to learn more about the data
• Involved in completing data testing before the UAT.
• Written Hive queries for data analysis to meet the business requirements. Validated Hive Managed and External table types.
• Performing various Hadoop controls like date checks, record checks, balance checks, threshold limits
• Co-ordinate with development and QA team for handling of defects with respect to data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Fixing the bugs and defects in data in the target system and running the reports again for data validation.
• Scheduling jobs at Tivoli and monitoring.
• Customizing the graph based on the Data Load Request.
• On Any failure of job need to fixed immediately without affecting the production
• Co Coordinators with Onsite and requirement gathering

Confidential 

UNIX, Ab initio, Big data, Python

Responsibilities:

• Analyzed functional specification and business scenarios.
• 7 Layer Migration project, performed analysis on all 20 Application’s Business flow and technical involved.
• Designed, developed and Performed unit tested Ab initio graphs for the Confidential Matric projects.
• Extracted data from various sources like databases, delimited flat files and XMLs.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed ETL testing and extensively used SQL functionalities.
• Coordinating with team during UAT defects
• Attending team meetings