Ashmita Rana
Longmont,CO
Summary
Experienced quality-focused professional with over 8 years in data validation, ETL processes, and SQL experience prepared for data quality analysis role. Known for delivering impactful results through keen analytical skills, strong attention to detail, and deep understanding of quality control processes. Proven ability to collaborate effectively within teams and adapt to changing requirements. Skilled in identifying and resolving issues, ensuring compliance, and driving continuous improvement initiatives. Expert in crafting comprehensive test plans, ensuring data integrity in complex data warehouses.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Consultant Quality Analyst
Auto Owners Insurance
03.2016 - Current
- Prepared test plan, test strategy and test case documents with the help of BRD and STM
- Tested all the ETL Data Centric processes developed for fetching data from OLTP systems to the target Data warehouse using complex DDL, DML, and DQL queries
- Attended walk-through meetings with the SME and DEV team to get a clear understanding of the business and the applications being used in house
- Responsible for testing all new and existing ETL data warehouse components
- Validated the source data coming from various databases using complex SQL queries
- Validated transformation in target was as per the STM
- Logged defects using JIRA
- Utilized HP/ALM to maintain test scripts
- Documented test strategies and test results in Confluence
- Worked closely with the QA Lead in co-ordination and Implementation of the Agile methodologies/QA processes and generating Test Scenarios
- Worked in two-week sprints
- Validated complex reports using SQL and Excel for data analysis and compliance, utilizing VLOOKUP, macros and other Excel functions, ensuring compliance with regulatory standards
- Worked with other members of the QA and Development teams in improving the processes, methods, effectiveness, and efficiencies of testing
- Tested several complex ETL mappings and transformations for daily data loads
- Participated in walk-through and defect report meetings periodically
- Written SQL Queries to define, identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance
- Used MS-Word and MS-Excel to update test cases, document test strategies and test results and for manual data comparison using VLOOKUP and macros
- Responsible for testing Business Reports developed by Board during the inception phase
- Experience working with and testing XML data type in SQL Server
- Helped with requirements and testing of data provided by new source system
- Experience testing SCD, 3NF and star schemas
- Developed and executed automated test scripts using Java in Spring Tool Suite (STS) in-house automation test framework, ensuring thorough testing coverage
- Maintaining in-house test repository by using Bitbucket and Source Tree
- Worked with other teams for end-to-end testing for changes in the source system
- Testing migration of data from data warehouse in SSIS to data lake using DbVisualizer
- Used Python and SQL to utilize dbt data tests in creating test framework which included generic and singular data tests
- Used Starburst to test data lakehouse powered by Trino
- Utilized Full Record Editor to read binary and extract files to Excel and compare with data in the lakehouse manually
- Collaborated with the developers to replicate, investigate and resolve problems
Education
Master of Science - Technology Management
Marshall University
Huntington, WV06.2016
Bachelor of Science - Accounting
Mountain State University
Beckley, WV05.2012
Skills
- JIRA
- Confluence
- Python
- Java
- Starburst
- Board
- IBM Data Studio
- SQL
- SSMS
- MS-Office
- Dbt
- DbVisualizer
- Full Record Editor
- Wherescape
- Problem-solving
- Attention to detail
- Client relationships
- Team leadership & development
- Time management
- Quality assurance
- Analysis & evaluation
- Data warehousing
- Verbal and written communication
- Reports and documentation
- Teamwork and collaboration
- Multitasking Abilities
Certification
- Data Visualization and Dashboard with Excel and Cognos, IBM Nov 3, 2024
Timeline
Consultant Quality Analyst
Auto Owners Insurance
03.2016 - Current
Bachelor of Science - Accounting
Mountain State University
Master of Science - Technology Management
Marshall University