Lead QA Analyst

• May 2022 - Present

Senior Consultant

• Dec 2021 - Apr 2022

QA Lead

• Dec 2018 - Dec 2021

*Worked on Site with Clients like Matrix Medical, Target, Optum and State of MN (DHS) *Design test plans, scenarios, scripts and procedures focused on positive/negative scenarios. Integrating different features and their functions together in order to perform continuous integration processes. *Conduct defect triage meeting and weekly touch base with business users, Created Bugs and track them in IBM Jazz and JIRA. *Coordinate major Batch runs and Time travel. *Schedule the test case execution and walkthrough aligned to project management release calendar *Coordinate End to End testing between IBM Curam, IBM mainframe and CMS for data integrity and system testing while also developing testing programs addressing areas: database impacts, software scenarios, regression testing, negative testing, error or bug retests and usability. *Created the functional test cases/reusable regression test case. *Trained the junior QA testers in projects and recognized them for developing excellent test plans/scripts and rapidly discovering defects that helped understand requirement and project as a whole. *Reviewed Test cases created by other QA members and making sure all the risks and scenarios are covered for every iteration. *Extensively worked on cloud testing, manual testing and automation testing and also in other QA activities. *Developed/modified the SQL scripts for back end testing. *Managed testing artifacts to support technical validations for regression testing and warranty. *SME for SRA for software design and development process for Teradata, Oracle 10/11g and Hadoop. *Designed and developed automated jobs from enterprise data warehouse. *Tracked changes in the software versions and manage the configuration management. *Managed the documentation for test life cycle, and review the technical documents for functional integrity. *RTM for proper coverage of requirements in testing life cycle. *Maintained IBM Jazz, ALM and Jira for defect management as part of Test Lead. Show less

QA Lead

• Jan 2018 - Nov 2021

*Requirements understanding to review, dissect, ask questions, derive test cases from and communicate with the testing team for drafting test scenarios and test cases to prepare test data for end to end testing from Curam to Integration Layer to IBM Mainframe (MMIS). *Create test plans/strategies that will list Risks, assumptions, scope and approach for project testing. *Create test data and validate policies and eligibility in Citizen and Case worker portals of IBM Curam for Smoke, Regression and System Integration Testing (SIT). *Validate the test data, Policy and eligibility integrity of data flow from Curam to downstream systems of GetInsured, Integration Layer and IBM Mainframe (MMIS) *Prepare Test closure documents at the end of testing life cycle that will include the pass/fail counts and defects resolved, this document also includes the defects that are part of backlog. *Review and present test strategies, test plans, Test scenarios and test cases with our business partners for business insight and approval to cover end to end testing from Curam to Integration Layer to MMIS for Public programs and from Curam to GI for Private programs. *Batch execution and coordination for Public and Private annual renewals and Termination, Denial and cancellation of policies with in ROPs (Reasonable Opportunity Period). *Extensive use of RTC to log and track the defects for entire defect tracking lifecycle for projects, that starts from logging the defect, getting business priority on defect in defect triage calls, assigning the defect to BAs, testing the defect after deployment from Ready to Test status and moving the validated pass defects to verified state. *Hands on SQL for integration layer and MMIS execution to validate the End to End testing cycle. Time Travel activities to bring system into future date to test and execute the open enrollment policies. *Lead and coordinate testing activities for projects. Show less

QA Lead

• May 2016 - Jan 2018

* Analyze and dissect system requirements and technical specifications to oversee creating and execution of test cases for Integrated Clinical User Experience (ICUE), a web-based application that utilize management with case, disease and health and wellness management functions, providing end-to-end system support for continuum of care * Ability to write test cases and execute testing within web service environment * Product test and driving defect resolution * Assist business users in defining User Acceptance Testing, test cases and plans * Establish and maintain test cases and test data * Create and maintain test cases in ALM * Create and maintain feature files in Atom * Create and maintain gherkinized test cases using ATDD * Create and maintain Reports tracking execution and defect activity daily * Actively participate in walk-through, inspection, review and user group meetings for quality assurance * Work with project manager, system analysts, designers and programmers to create and analyze various required project documents. * Meet with project manager, system analyst and programmers weekly to provide status/discuss issues blocking testing. * Oversee and manage assignments, working closely with offshore resources. Report status and escalate issues as needed. * Participate in production implementation verification and being accountable for validating system quality. * Participate in Estimating/planning meetings * Plan, document, evaluate and track testing results to ensure system applications are free from defects. * Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and or functionality within information technology software. * Comply with standards of the software development life cycle and follow strategies, plans and procedures within information technology software. * Comply with standards and strategies of the software for clinical systems delivery Show less

Lead Data Quality Analyst

• 2009 - 2018

Healthways: •Resource allocation for data management activities for respective application development areas. •Determine what data will be maintained. •Support data stewards from their areas of responsibility. •Be accountable for integrity and quality of business data created/updated. •Oversight during development of projects to ensure the data needs and requirements. •Ensure requirements for metadata and data standards are set according to enterprise standards. •Be aware of resource data requirements, standards, access rules, and training. •Implement data standards and participate in the development of standards. •Facilitate educational opportunities for the treatment, application, and value of spatial data. •Create and maintain metadata to quality specifications. •Provide consistent interpretation and application of policies to their respective stakeholders. EBay/Experian: •Used ClearCase and ClearQuest. •Created and modified UNIX Shell scripts for files processing and automation. •Extensively used SQL Set operators to compare data between the sources. •Tested the marketing campaign data and conversion of campaigns across marketing channels like email, direct mail, Double Click, Message Center etc. •Validating data in the scenarios like Slowly Changing Dimensions, Late Arriving Facts. •Wrote highly tuned SQL queries that dealt with tables as huge as containing 8 billion rows. Capital One: •Designed the mappings between sources to Operational staging targets. •Wrote test plan and test cases to test the application manually in QC. •Tested Oracle applications and Portals. •Performed periodic checks to run crosscheck against PROD/TEST environments. •Worked with ETL group for design strategy of Slowly changing dimensions & Late arriving facts. •Designing and creation of complex mappings using SCD Type II involving transformations. •Worked on issues with migration from dev to testing. •Designed and developed UNIX shell scripts for ETL testing process. Show less

Lead Data Quality Analyst

• Feb 2013 - May 2016

• Perform and lead testing activities in order to ensure data quality. • Business Process consultant and data steward (Coordinator and Corrector) roles as per business needs. • Lead definition of quality needs and training of Hadoop GUI with business teams. • Define test data needs in partnership with technical teams. • Provide input for the data governance requirements and standards. • Plan and define criteria and make go/no go decisions from a quality perspective. • Lead test planning, ensuring testing covers all integration points. • Monitor ongoing data quality. • Define parameters for data integrity and compliance by data cleansing, data audit and/or data validation. • Investigating data sources, data mining, data profiling for BI projects • Troubleshoot complex data quality problems. • Identifying and acquiring new data sources. • Creating and maintaining consistent reference and master data definitions. • Publishing relevant data to appropriate users in an organization, and monitoring the published data sources for usage/relevance/quality feedback. • Creating and managing business metadata for published data sources to ensure that it is easily discoverable, and meaningful to information workers. • Drafting Metadata documents, NFRs, M&A, Data Dictionaries. • Resolving data integrity issues across stakeholders. • Analyzing data for quality and reconciling data issues. • Recommend methods to strengthen data integrity, quality and availability of information for the business, while tying back to enterprise-wide expectations. • Communicate quality metrics, issues and resolution to business clients; serve as a primary data expert on underlying business rules and data source. • Reviewing LDM, PDM, STM documents for optimal data quality input to technical and modeling teams. • Worked in Both Distribution and Transportation BI. Environments: Teradata V13&V14, Hadoop (Hortonworks, Cloudera), Oracle 11g, SAS 9.3, Micro-strategy, Tableau. Show less

Quality Assurance Analyst

• May 2012 - Feb 2013

• Work as the team lead for testing the database enhancement and integration of new enhancement with partner applications along with creating and managing metadata. • Attend bi-weekly BI stand up. Presented BI updates to the production stand up meeting. • Participate in the data management team investigations for geographic area data. • Investigating new data sources for data integration and managing data quality standards across the enterprise. • Used ALM and JIRA to track testing progress through test cases and tasks. • Responsible for writing SQL scripts and macros to validate Data records, Data Validation maintain Data Quality between OLTP to DWH to OLAP. • Monitored legacy and new database for enhancements and built data monitors for quality check. • Performed day to day Operation and Management tasks for automated testing scripts. • Validated extracts generated in Production from OLAP foundation view. • Creating reports using Tableau for the managerial presentations, also validating those reports with SQL queries in SQL Management Server. • Extensively used SQL set operator functions for testing data between different layers of the data warehouse like landing to staging, staging to presentation layer. • Write scripts for Data integration and quality between new Database and Affiliated Applications. • Reviewed design documents from data quality team for quality check. • Creating and reviewing NFR’s, metadata, data dictionaries and TRUST documents. Show less