Abhinay Muthyala
IT Quality Assuravce Analyst
Milwaukee,WI
Summary
Detailed-oriented Professional with 3 years of expertise as a Quality Assurance Analyst and Data Analyst. Adept at ensuring the accuracy, Integrity, and reliability of data. With a background in both IT and Healthcare, bring a unique perspective to optimize Data Quality. Proficient in ETL testing, Data validation, SQL querying, and cloud Data warehousing. Strong collaborator known for effectively bridging the gap between technical and nontechnical teams to drive project success. Seeking to contribute the skills to a dynamic organization aiming to harness the power of data.
Overview
3
3
years of professional experience
2
2
years of post-secondary education
Work History
IT Testing And Quality Assurance ANALYST
Rush University Medical Center
Chicago, IL
1 2023 - Current
- Collaborate with business analysts and developers to understand software requirements and design test cases
- Develop and execute test plans, test cases, and test scripts to ensure that software products meet quality standards and specifications
- Conduct regression testing to ensure consistency and reliability of Data
- Collaborate with end users to identify and document software requirements and usability needs
- Conducted root cause analysis on critical defects, identifying underlying issues and suggesting process improvements to prevent recurrence
- Collaborated closely with cross-functional teams, including developers and business stakeholders, to communicate test results, prioritize bug fixes, and facilitate issue resolution
- Documented detailed test plans, test cases, and defect reports, providing clear and concise documentation for future reference and knowledge sharing
- Data profiling and validation of data quality in Data warehouse Migration and ETL process Validation
- Did web report and security testing and UAT for web reports and Access
- Analyzed project requirements, identifying acceptance criteria testing cases and scenarios
- Implemented continuous improvement initiatives to improve performance
- Reviewed and researched new testing strategies to help steer QA advancements.
ETL Quality Assurance Analyst
MEDICA
Minnetonka, MN
01.2022 - 01.2023
- Create and maintain automated test scripts for ETL processes to ensure data quality and accuracy
- Identify and document test cases based on business requirements and functional specifications for ETL processes
- Perform data validation and reconciliation to ensure accuracy of data loaded into data warehouse
- Collaborate with data analysts and developers to understand data requirements and design appropriate test cases for ETL processes
- Monitor and analyze data extraction, transformation, and loading processes to identify and resolve issues in real-time
- Develop and implement quality control procedures and standards for ETL processes to ensure data accuracy and reliability during migration of data from on-premise to cloud in SNOWFLAKE
- Conduct regular meetings with stakeholders to discuss progress and quality of ETL processes
- Involved in Data migration project from data profiling, creation of Data dictionary, Analyzing GAPS in Cloud Data warehouse and implementation of Innovative testing methods for improved efficiency of data migration
- Concurred with developers to provide input for design and test strategies
- Compiled data and tracked performance to help optimize QA processes
- Implemented continuous improvement initiatives to improve performance.
- Fixed identified issues to improve workflows
- Managed end-to-end test cycles for comprehensive evaluation of system performance and functionality
DATA ANALYST
AMERICAN REDCROSS
Milwaukee, WI
01.2021 - 01.2022
- Proficient in data gathering from various sources, including databases, APIs, and flat files, ensuring data integrity and accuracy for analysis
- Conduct thorough data profiling to assess data quality, completeness, and inconsistencies, effectively identifying areas for improvement and refinement
- Expertise in data cleaning techniques, utilizing tools like Python and SQL, to preprocess and transform raw data into clean and structured format for analysis
- Demonstrated ability to collaborate closely with business teams to understand data requirements, translating them into actionable data analysis and reporting solutions
- Strong analytical skills, utilizing statistical techniques to identify trends, patterns, and outliers in data, contributing to informed decision-making
- Proven track record of generating comprehensive reports and presentations using Power BI
- Utilized advanced DAX (Data Analysis Expressions) functions in Power BI to create complex calculations and measures, enhancing depth of analysis
- Proficient in designing and implementing ETL (Extract, Transform, Load) processes to integrate data from diverse sources and ensure consistent and reliable data flow
- Using SQL for gathering data from different source tables for analyzing data and creation of desired output for Business.
Education
Master of Science - Health Informatics
University of Wisconsin- Milwaukee
Milwaukee, WI 01.2021 - 05.2023
B.D.S - Dental Surgery
Meghna Institute of Dental Sciences
Skills
Programming Languages: Python, SAS
Databases: SQL SERVER, SQL, My Sql, Snow Sql
ETL Test Automation Tools: QuerySurge, Informatica, Talend
Technologies: MSBI, SSIS, SSRS, Power BI, Informatica Powercenter, GIT
Cloud Technologies: SNOWFLAKE, Azure DevOps, Azure Data Factory
Healthcare Compliance and SME: HIPPA, CIP Program, ACO, HEDIS
Soft Skills: Analytical Thinking, Attention to Detail, Effective Communication, Problem-Solving, Leadership Quality
Timeline
ETL Quality Assurance Analyst
MEDICA
01.2022 - 01.2023
Master of Science - Health Informatics
University of Wisconsin- Milwaukee
01.2021 - 05.2023
DATA ANALYST
AMERICAN REDCROSS
01.2021 - 01.2022
IT Testing And Quality Assurance ANALYST
Rush University Medical Center
1 2023 - Current
B.D.S - Dental Surgery
Meghna Institute of Dental Sciences