Siva Ramya Muktinuthalapati
Lewis Center,OH
Summary
Master’s graduate with a 3.25 GPA and 13 years work experience, as Quality Engineer/Business Analyst/ETL Test Engineer.
A motivated Business Analyst with two years of experience in gathering requirements, analyzing business processes, and providing actionable insights to enhance operational efficiency.
Have excellent communication skills, administrative capabilities and client interaction.
An enthusiastic and quick learner of new technologies and adaptable to demanding and stressful environments.
Excellent time management skills and capable of multitasking.
Able to work independently or as part of a team. Highly-motivated employee with desire to take on new challenges.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Quality/Business Analyst
Abercrombie and Fitch
08.2022 - 11.2024
- As a Quality Analyst/Business Analyst, I was responsible for validating Tag management using Tealium iQ and chrome extensions which enables marketing organizations to unify disparate data sources and drive more consistent visitor interactions
- Conducted data analysis using SQL and Excel, producing detailed reports and dashboards to support management decisions
- Participated in stakeholder meetings to present findings and suggest solutions, ensuring alignment with business goals
- Collaborated with cross-functional teams to gather and document business requirements for new software implementation
- Played a QA lead role with onsite-Offshore model and use to attend all refinement/Agile meetings being an On-site resource
- Had great collaboration with Offshore team in explaining the difficulties team might face and also making it easier on their side playing a crucial role
- Lead assigned projects for assigned business unit or assigned application(s) that are typically more complex and of a larger impact to the company
- Have in-depth knowledge of applications and stays current in technical enhancements, methodologies to related apps
- Analyzed existing systems or procedures and identifies technical or procedural improvement
- Designed processes to meet regulatory requirements
- Started working with a third-party vendor called Duel for validating sales that were made via web/mobile(APPS) to estimate the commission received by influencer by placing orders with an Affiliate ID
- Had opportunity to work well with Business to understand the gaps in the requirement and re-validating web orders to ensure traceability is met
- Estimated user stories in Refinement meetings according to the change in the requirement for each user story
- Started writing test cases once refined stories were pulled into current sprint
- Helped other QA team in validating user stories that are ready to test
- Helped the team in validating hot fix for the bugs that are high priority in production
- Continuous integration on end-to-end testing on user stories
- Helped initiate demo for all the user stories that are finished in the current sprint to Product Owners
- Helped identify smoke test flows alongside regression test flows for Automation testing
- Helped maintain documentation with any new changes in requirements alongside test data documentation
- Attended webinars on Accessibility/ Low code Automation tools
- Helped setup meetings for 3 Amigos/ Refinements
- Always very vocal on any issues with the timelines not being met for any reason
Senior Quality Analyst
Bath and Body Works
08.2021 - 08.2022
- As a Quality Analyst, I was responsible to attend all Agile team meetings for the first time ever established Agile team
- Estimated user stories in Refinement meetings according to the change in the requirement for each user story
- Started writing test cases once refined stories were pulled into current sprint
- Helped other QA team in validating user stories that are ready to test
- Helped the team in validating hot fix for the bugs that are high priority in production
- Continuous integration on end-to-end testing on user stories
- Helped initiate demo for all the user stories that are finished in the current sprint to Product Owners
- Helped test Visual QA on all the modules for UI to make sure UX changes are reflected accordingly
- Helped identify smoke test flows alongside regression test flows for Automation testing
- Helped maintain documentation with any new changes in requirements alongside test data documentation
- Attended webinars on Accessibility/ Low code Automation tools
- Helped setup meetings for 3 Amigos/ Refinements
- Worked on QA team building activities and even won the exciting prizes which helped learn more about BBW
- Had back and forth conversations with BSA and product team even once stories were refined for better clarification
- Always very vocal on any issues with the timelines not being met for any reason
Senior Quality Analyst
Huntington National Bank
04.2021 - 07.2021
- As a Quality Analyst, I was responsible to attend all Agile team meetings
- Estimated user stories in Refinement meetings according to the change in the requirement for each user story
- Started writing test cases once refined stories were pulled into current sprint
- Helped other QA team in validating user stories that are ready to test
- Helped the team in validating hot fix for the bugs that are high priority in production
- Continuous integration on end to end testing on user stories
- Helped initiate demo for all the user stories that are finished in the current sprint to Product Owners
- Had back and forth conversations with BSA and product team even once stories were refined for better clarification
- Always very vocal on any issues with the timelines not being accordingly
Test Automation Developer
NationWide Insurance
11.2020 - 02.2021
- As a Test Automation Developer, ensured all the unit tests for Informatica code validations are done in Ruby using DIF Framework
- As a TAD on the team, validated ETL data in lower environments using intensive SQL queries and made sure data is looking good and use to get signoff from Business
- As a TAD on the team, validated ETL data in production using intensive SQL queries and made sure data is looking good and use to get signoff from Business
- As a TAD on the team, validated ETL data and also wrote Acceptance tests for the test cases using ruby and had code pushed to production
- Meeting all Agile methodology guidelines, by attending everyday standup meeting, refinement, retrospective Sprint demo to customer success team and sprint planning meetings
- Participating in End to End and Integration meetings to ensure all the systems involved in meeting business requirements are in alignment and working according to the business rules
- Creating detailed, comprehensive and well-structured test plans and test cases for the application/component both at UI and at API Web service levels
- Design, develop and execute automation scripts using open source tools (Protractor, Java/Cucumber)
- Estimate, prioritize, plan and coordinate testing activities with rest of QA engineers to make sure everyone is in alignment with the business requirements
Quality Engineer
MC Graw Hill Education
07.2014 - 10.2020
- As a Quality Engineer, making sure quality of the application has been delivered properly to end users by testing the application end to end
- Using Automation testing framework to test all UI and API Platform Services to make sure all the systems are working according to business requirements
- Meeting all Agile methodology guidelines, by attending everyday standup meeting, refinement, retrospective Sprint demo to customer success team and sprint planning meetings
- Using Automation test framework for UI using protractor and Java/Cucumber for API platform web services
- Participating in End to End and Integration meetings to ensure all the systems involved in meeting business requirements are in alignment and working according to the business rules
- Creating detailed, comprehensive and well-structured test plans and test cases for the application/component both at UI and at API Web service levels
- Design, develop and execute automation scripts using open source tools (Protractor, Java/Cucumber)
- Estimate, prioritize, plan and coordinate testing activities with rest of QA engineers to make sure everyone is in alignment with the business requirements
- Identify, record, document thoroughly and track bugs using JIRA and follow up on any open bugs/defects
- Perform thorough regression testing when bugs are resolved to make sure application is not broken and functioning as expected
- Apply testing processes for new and existing applications to meet client needs
- Working closely on monitoring Circle CI (Continuous Integration and Development) to make sure all automation scripts are passing on daily basis and fix any failures
- Providing updates on a daily basis for End to End Testing of application to meet business requirements
- Documenting all test data needed to make sure application is fully functional and coordinating with team for any changes in requirements
- Active Participation in Traceability matrix in which both requirements and test cases written would match for business requirements
- Active participation in demoing developed and fully tested application to end customers and making sure to follow up on the feedback
ETL Test Engineer
Westfield Insurance
04.2013 - 07.2014
- Working on a Corporate Project called Policy ODS (PODS), where 33 new tables are being added to the EDW
- Prepare Test Plan Documents, Test Cases in HP Quality Center, executes the same in the test lab following the Mapping documents provided by the Data Integration Team
- Assigns defects to the assigned developers in the Quality Center
- Have been extensively working on the database, Netezza by writing SQL Queries on DB Visualizer
- Have used Inner joins, left joins, Right Joins, Analytical functions, Aggregate functions and have fetched results sets according to the mapping documents
- Works in an agile team to complete the assigned tasks for a week and have attended daily/Weekly stand up meetings
- Have closely worked with Business analysts to understand the requirements in order to have a traceability matrix setup in Quality center, in which every test case has been assigned to the requirements and each test case has its own requirement ID assigned
- Worked Closely with Data Integration Analysts in order to understand the table structure and also the way data has been flowing with in EDW
- Extensively used SQL on DB2 database in order to test the data that has been loaded into the tables in which both POLICY and COVERAGE Statistical and ratings have been covered
- Extensively worked on comparing the flow of data in the tables within two databases (Netezza and DB2)
- Tested file to table validations where the Source being a CSV file and the target being table and have manually compared both the results within excel
- Have reported all the defects and test case executions to the test lead by generating reports out of HP Quality Center
- Tested Data Migration Views and heavily involved in analyzing the Views and test cases were written and executed in Quality Center
- Tracked all the defects in Quality Center and have been assigned to developers, and also validated the results after the defects have been analyzed and closed by the Developing team
- Also participated in weekly meetings where risks for the projects to meet the deadlines were discussed and solved
ETL Test Engineer
BCBS NC
Durham, North Carolina
10.2011 - 04.2013
- Worked for Corporate Projects, to name in Multi-payer Advanced Primary Care Practice and Disease Management and Blue Points
- Created test cases based on the requirements provided by Business Analysts
- Delivered Extracts Using Secure File Transfer to the End Client
- (UNC Model Office)
- Created Data Specification documents for Source Tables from the requirements
- Worked as a Data Integration Analyst in writing the Specifications where I have analyzed multi tables to pull out information for New Vendor Alere coming into EDW
- Executed test cases in Quality Center
- Extensively worked on UNIX Platform in order to check Log/Error files
- Also checked the data content and Count in the file
- Matched the Traceability Matrix where test cases have been matched with the requirements and also generated report in quality center
- Executed test cases by writing SQL Queries using Complex joins such as Inner joins, Left Outer join and Analytical Functions
- Ensured Weekly Deliverables in the Weekly Status Meetings
- Also participated in daily status meeting and met the Weekly deliverables
- Performed unit testing, System testing and integration testing to confirm ETL code integrity
- Tested the mappings for Slowly Changing Dimensions (Type-2)
- Clearly communicated and documented test results and defect resolutions during all phases of testing
- Have communicated with all the Data Integration Analyst’s to understand the flow of data from Different Databases
- Worked on ONEVIEW 1.0 where the data was flowing from Power-MHS Source System and validated the data flow
- Ran Control jobs in different QA Environments and defects have been assigned to the Developers by looking at Log and Error Files
- Good command on control-m tool to run, abend and schedule jobs when required
- Have a very Good Business Knowledge on types of Groups, membership, Claims, Provider data flowing into EDW
- Worked on few Data Specification mappings for few vendors Getting Terminated
- Worked on Sending Claims (Medical, Pharmacy and RX Carve outs) required for the Vendor
- Have executed many test cases, validated all the Scenarios and also performed Regression testing whenever change occurred in the existing code
- Also Worked on UAT/Production Validations, Performed production validation
ETL Test Engineer
Wright Express
Maine
06.2011 - 10.2011
- Worked as a QA in testing the flow of data into EDW
- Worked also a manual Tester working with the Screens and Passed/Failed Test cases in Quality Center
- Ran ControlM jobs for the Daily refresh of the data
- Wrote Testcases for Automation
- Validated Test cases based on the VBScripts written for QTP
- Matched Requirements to test cases in Quality Center (Traceability Matrix)
- Had very extensive interaction and Communications with Business Analysts since all the test cases were written based on the Requirements
- Was able to deliver the task on time to the Project Manager
- Had a very Clear Planning Strategy presented to Project Manager
Education
Masters - ELECTRICAL AND ELECTRONICS ENGINEERING
NEWYORK INSTITUTE OF TECHNOLOGY
NEWYORK01.2010
Bachelor of Technology (B.Tech) - ELECTRICAL AND ELECTRONICS ENGINEERING
NARAYANA ENGINEERING COLLEGE
Nellore, India01.2007
Skills
- Business Process Mapping
- Business Planning
- Quality Assurance
- Business process improvement
- Technical Writing
- Data Mapping
- Business Case Validation
- User Acceptance Testing
- SQL
- UNIX
- HP Quality Center 100
- JIRA
- Ruby, Cucumber
- Java/Cucumber
- Tealium iQ
- Chrome extensions
- Utag debugger
Certification
- Business Analysis for Project Managers
Timeline
Quality/Business Analyst
Abercrombie and Fitch
08.2022 - 11.2024
Senior Quality Analyst
Bath and Body Works
08.2021 - 08.2022
Senior Quality Analyst
Huntington National Bank
04.2021 - 07.2021
Test Automation Developer
NationWide Insurance
11.2020 - 02.2021
Quality Engineer
MC Graw Hill Education
07.2014 - 10.2020
ETL Test Engineer
Westfield Insurance
04.2013 - 07.2014
ETL Test Engineer
BCBS NC
10.2011 - 04.2013
ETL Test Engineer
Wright Express
06.2011 - 10.2011
Masters - ELECTRICAL AND ELECTRONICS ENGINEERING
NEWYORK INSTITUTE OF TECHNOLOGY
Bachelor of Technology (B.Tech) - ELECTRICAL AND ELECTRONICS ENGINEERING
NARAYANA ENGINEERING COLLEGE
Similar Profiles
John Anthony Lesjak JrJohn Anthony Lesjak Jr
Senior HVAC Account/Project Manager at Abercrombie and Fitch Home OfficeSenior HVAC Account/Project Manager at Abercrombie and Fitch Home Office
Tiana ZadouriTiana Zadouri
Sales Associate at Abercrombie and FitchSales Associate at Abercrombie and Fitch
AARAV MEHRAAARAV MEHRA
Sales Associate at Abercrombie and Fitch, HollisterSales Associate at Abercrombie and Fitch, Hollister
Omair Reza LaskarOmair Reza Laskar
SALES ASSOCIATE at Abercrombie and FitchSALES ASSOCIATE at Abercrombie and Fitch
PRASANTH K SINGUPRASANTH K SINGU
Business Analyst at SailPointBusiness Analyst at SailPoint