Anila Vanaja Subbiah
Austin,TX
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior QA Analyst
Texas Windstorm Insurance Association
Austin, TX
07.2020 - Current
- Performed end-to-end data validation for TWIA/TFPA data warehouse
- Validated BI reports against departmental requirements, focusing on Claims and Insurance Ops
- Designed and executed ETL data test cases using SQL queries for efficient data analysis
- Developed comprehensive test cases for PolicyCenter and BillingCenter to ensure data integrity
- Recorded test case outcomes to improve transparency
- Collaborated in team discussions to prioritize user stories and defects for project delivery
- Provided EDW production support for prioritized business user stories
- Enhanced the test case repository with additional functional and scenario-based tests
- Analyzed data flow from source systems to Guidewire Datahub & InfoCenter
- Maintained test plans to ensure system changes met established standards and business requirements
- Expedited project deliverables through collaboration with developers and QA team
- Acquired rapid knowledge of insurance business models for TWIA and TFPA
- Gained an overview of EDW automation testing tools and planned feature enhancements.
Senior ETL QA Analyst
Neogov
Austin, TX
04.2018 - 06.2020
- Conducted ETL Testing for HR management tool in Insight product, utilizing SQL Server Integration Services (SSIS) and SQL Server (MSSQL)
- Automated QA data validation for the Analytics team, incorporating stored procedures and SSIS packages
- Performed end-to-end QA validation for the Analytics Data Warehouse using complex queries
- Conducted UI testing for Analytics
- Conducted browser profiling and performance testing
- Conducted end-to-end data validation for adhoc reports
- Tracked and validated defects
- Evaluated business requirements and developed test plans
- Maintained Software Quality Assurance management reports
- Engaged in Agile Software Development testing
- Executed complex Quality Assurance activities using appropriate test tools and best practices
- Identified and thoroughly analyzed defects, issues, and risks.
Hadoop QA Engineer
Bank of America - Tata Consultancy
Jacksonville, FL
10.2015 - 03.2018
- Conducted comprehensive testing, including infrastructure, capabilities, load/stress, and performance testing, across various Hadoop platforms using performance-driven methodologies
- Managed certification processes for new tool versions and software upgrades (JDK, CDH, Cloudera Manager) in development, testing, and production clusters
- Developed scripts to optimize Hive and Impala performance
- Automated transactions and added value through UNIX Korn shell scripting
- Executed proof-of-concepts (POCs) for new data wrangling and ETL tools like Pentaho and Trifacta
- Utilized Apache Kafka for handling log messages across multiple systems
- Ensured effective cross-application communication testing.
Hadoop Developer - Deposits
Tata Consultancy
Chennai, India
02.2012 - 09.2015
- Conducted comprehensive testing, including infrastructure, capabilities, load/stress, and performance testing, across various Hadoop platforms using performance-driven methodologies
- Managed certification processes for new tool versions and software upgrades (JDK, CDH, Cloudera Manager) in development, testing, and production clusters
- Developed scripts to optimize Hive and Impala performance
- Automated transactions and added value through UNIX Korn shell scripting
- Executed proof-of-concepts (POCs) for new data wrangling and ETL tools like Pentaho and Trifacta
- Utilized Apache Kafka for handling log messages across multiple systems
- Ensured effective cross-application communication testing.
Production Support Analyst
Tata Consultancy
- Developing Informatica sessions and workflow to handle the ETL processing
- Creating Datastage tasks and stage for ETL
- Pulling data from different sources like Mainframe, UNIX, Oracle and all
- System monitoring and solving job failures quickly
- Ensure the stability of Bank of America's Teradata and act accordingly
- Action taken to ensure data availability on-time to meet the SLA
- Analysis of code to resolve issues from clients and users
- Perform disaster Recovery exercise every year to ensure data availability in case of disaster situations
- Handling Teradata Hardware and software upgrade
- Reviewing the code and standards for the new application coming into production
- Implementing code fixes and enhancements for frequent abends.
Education
Skills
- Domain and Technology: Banking, Communication and Financial Services, Data Warehousing, Insurance
- Big Data / Hadoop: HDFS / Map Reduce / Hive / YARN / Sqoop / Flume / Oozie / Kafka /Impala/Cloudera Manager
- Databases: Teradata, Oracle, MySQL, SQL Server
- ETL Tools: Informatica, SSIS, DataStage, DMExpress, Trifecta, Pentaho, Data Services
- Schedulers: Autosys, CA7
- Version Control Tools: SVN, Share point and JIRA,Rally
- RPA: UI Path
Certification
- Guidewire Certified Associate -InsuranceSuite Analyst - Elysian
- Guidewire Certified Specialist - DataHub and InfoCenter Integration - Elysian Certification and upgraded the same to Innsbruck
Career Accomplishments
10+ years of experience in Quality Assurance, Data Validating, Testing App Development, and Data Analysis teams with proficiency in Data Warehousing and RDBMS technologies. 5+ years of ETL and Data integration experience in developing ETL mappings and scripts.
Timeline
Senior QA Analyst
Texas Windstorm Insurance Association
07.2020 - Current
Senior ETL QA Analyst
Neogov
04.2018 - 06.2020
Hadoop QA Engineer
Bank of America - Tata Consultancy
10.2015 - 03.2018
Hadoop Developer - Deposits
Tata Consultancy
02.2012 - 09.2015
Production Support Analyst
Tata Consultancy
- Guidewire Certified Associate -InsuranceSuite Analyst - Elysian
- Guidewire Certified Specialist - DataHub and InfoCenter Integration - Elysian Certification and upgraded the same to Innsbruck
Similar Profiles
Gayle CaldwellGayle Caldwell
SOFTWARE DEVELOPER at TEXAS WINDSTORM INSURANCE ASSOCIATIONSOFTWARE DEVELOPER at TEXAS WINDSTORM INSURANCE ASSOCIATION
Jude DauphinJude Dauphin
Property Desk Adjuster at Texas Windstorm Insurance AssociationProperty Desk Adjuster at Texas Windstorm Insurance Association
Samantha AdamesSamantha Adames
Commercial Insurance Underwriting at Texas Windstorm Insurance AssociationCommercial Insurance Underwriting at Texas Windstorm Insurance Association
Sadia AhmedSadia Ahmed
Teacher at Green Flag Public SchoolTeacher at Green Flag Public School
Tatiana T. TorresTatiana T. Torres
Senior Enlisted Advisor at U. S. Navy, Recruit Training CommandSenior Enlisted Advisor at U. S. Navy, Recruit Training Command