Sr. Rdm/ Mdm/ Etl Quality Analyst/system Analyst Resume
St Louis, MO
SUMMARY:
- 8+ years of experience in Software Quality Assurance and Quality Control in various domain like Finance, Insurance, Healthcare and Telecommunication.
- Good knowledge of Quality Assurance methodologies like Agile, Waterfall, V - Model, RUP, Scrum, RAD, UML, TDD.
- Experienced with different Relational databases like Teradata, Oracle and SQL Server.
- Experienced in Automating and Scheduling the Teradata SQL Scripts.
- Proficient in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
- Has good knowledge of Software Development Life Cycle (SDLC) Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
WORK EXPERIENCE:
Sr. RDM/ MDM/ ETL Quality Analyst/System Analyst
Confidential, St. Louis, MO
Responsibilities:
- Experienced Working with Migration of an existing database to a new RDM solution implemented with some enhanced capabilities.
- Experienced Working with an end to end RDM testing framework utilizing the best practices from Cognizant EDM Testing COE coupled with risk based testing approach to streamline the overall release testing process
- Experienced Working with Testing all across functionalities of Informatica in line with the business rule
- Knowledge Repository for Reusability & Collaboration, End to End data flow and integrated Testing Framework, Conversion Testing of new RDM solution with the sunset database and Standardized QA process implementation
- Experienced to ensure that critical enterprise data is validated as correct, consistent, and complete when it is circulated for consumption by internal or external business processes, applications, or users.
- Ensured Integrated Enterprises MDM delivery model and de-duplicated Master Data to maximize MDM benefit
- Experienced with EDM Flow Understanding Understand the layer wise data movement
- Experienced with verifying migration policies to ensure the systematic movement of data (including data security)
- Experienced creating Comprehensive Test Plan Meticulous planning for and deployment of a comprehensive EDM testing plan will ensure that data is properly converted, standardized & consolidated to form best breed of master data.
- Experienced with Ensuring Test Coverage to define realistic objectives for MDM testing along with the metrics.
- Experienced Working with Align MDM Testing to the stakeholder expectations on test coverage.
- Ensured no fragmented data or any kind of missing info that may lead to any revenue loss
- Experienced with Verification of Master Reference Data, Control Total Checking, Data Standardization and Cleansing, Data Transformation checking, Duplicate Record verification, Attribute correctness check.
- Experienced Working with Cross reference verifications, Audit Trail check, Reject verification, Lookup and rule validation, and Validating audit trail.
- Worked Verifying of Data Publishing, Data Harmonization, Data refresh/update verification, Data transformation verification.
- Experienced Working for Data Governance, Role based verifications (Billing user / RDM Admin / Accounting Admin etc.), Verifying search & update code values, Addition new attributes/code types, Enabling/Disabling ref code types, Bulk update / upload, Approval for key ref data update, Enrichment of data, Email notifications checking.
- Establish Teradata RDM through a standardized QA model, Ensured seamless data flow from source to Teradata RDM Hub,
- Experienced to ensure no critical data loss and establish Golden Standard Reference Data and Ensured integrity and history of different type code.
- Ensured to get rid of any transformations that downstream systems needed to do.
- Experience in testing match rules for de-duplication
- Expertise in testing application of trust values and Rules for data merge, testing Global reference data for effective master data governance
- Experience in testing import rule and attribute validation.
- Expertise in export rule checking and data format validation, Database validation for import data and Role based testing for Product Master Reference Hub.
- Knowledge of Data Steward Interfaces, reports and functions, testing data view, modification and messaging facilities.
- Testing administrative functions of various data management tools.
- Testing experience with data transformation, Data format/ conversion testing and publish location validation, Data publication testing with web services, messaging services, materialized view etc.
- Work closely with the business team to understand the scope of work
- Transferred the business knowledge to offshore counterpart/team.
- Responsible for testing scope prioritization. Discuss with offshore team and finalize.
- Walkthrough of the Test Strategy, Approach & other testing deliverables for final approval and Manage the day-to-day testing activities.
- Responsible for driving defects triage exercises, root cause analysis and defect density measurement and Serve as first point of escalation for Testing.
- Maintained latest version of test cases and test data
- Responsible for creating and maintaining of Test Plan & Strategy, RTM Document Test Scenario Document, Test Execution Report, Test Data Specification documents.
- Experienced to Understanding requirements and create test scenarios /cases, review of testing artifacts, Perform and Manage Dry run from offshore, Ensure to follow established testing process, Test case execution and Run sanity check for environments.
- Experienced with Workflow execution rights which involved Verification of RDM OUT views for each RDM CORE table.
- Experienced with Verification of workflows for new data addition, update & Delete, UI functionalities for 7 different types of roles (Billing User, RDM Admin, Accounting Admin, BI User, BI Admin, and Data Governance Board) on IE 9.0/above.
Environment: Windows - 7, NT, 2003, 98, MADM 0.1, ADMIT 0.1, MTM W.1, Tara Data Client 14.00, ALM, Service Manager, UNIX, LINUX, Tara Data SQL Server Assistance, SQL/ PL SQL, UML, HTML, DB2, JIRA, SAP, VB Script, SharePoint, Snipping, Service Manager, XML, SSIS/ SSRS, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project
Sr. ETL QA Analyst/Tester
Confidential, West Bend, WI
Responsibilities:
- Attended walk though meeting in which business rules and functionalities were discussed
- Coordinated all QA activities and enhancements using Agile Methodology.
- Developed Test Plan and wrote Test Cases.
- Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing and GUI testing.
- Performed Cross browser compatibility testing and cross platform compatibility.
- Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
- Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
- Designed various test Cases with different test conditions.
- Validated correct process of ETL.
- Built and performed test cases for END to END testing using JIRA and SQL.
- Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
- Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
- Prepared and executed scenarios for the Regression testing on new ETL process builds.
- Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
- Hands on experience in collecting several metrics and preparation of defect reports.
- Prepared and executed scenarios for the Regression testing on new builds.
- Performed Regression testing by executing the scripts developed with QTP.
- Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
- Adopted Data Driven Methodology to the test application with different sets of data.
- Extensively involved in performing Backend testing by using SQL.
- Performed Manual Testing of the application as well as identified the critical test scripts to be automated. Performed ETL testing to validate data is transformed correctly from OLTP to data warehouse.
- Performed that all data is transformed correctly according to design spec.
Environment: Windows - 7, NT, 2003, 98, JIRA, Service Manager, Legacy PCOMM, Web Intelligence Rich Client, Info View, UNIX, LINUX, Oracle 10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML, DB2, JIRA, SAP, VB Script, Crystal, SharePoint, XML, SSIS/ SSRS, ALM, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.
MDM QA Analyst / Business Analyst
Confidential, San Francisco, CA
Responsibilities:
- Supported all aspects of client engagements from scope definition to delivery
- Conducted quantitative and qualitative analysis of data
- Developed a clear plan for requirements management to include identification and estimation of business analysis activities
- Elicited requirements using brainstorming, document analysis, focus groups, interface analysis, interviews, observations, requirements workshops and surveys/questionnaires
- Coordinates and facilitates meetings with users to gather and document requirements and explore potential solutions.
- Gathered Functional requirements through a variety of techniques such as work sessions and interviews.
- Contributed to written and verbal communication in and out of the client, specific to the business and functional requirements
- Experience with Metadata Repository and data dictionary, and supporting Master/Reference Data Management (MDM) efforts
- Validate Internal Specialty from AMS and update PSR.
- Add Veeva as source and consumer of MDM for Alignment and Affiliation ad IMS Prescriber data as direct load into CM
- Calculate Control Dangerous Substance Sampleability for HCP
- Create Report for Pharma Return and Government Pricing for any updates to HCO
- Analyzed and documented client complex business requirements and processes; communicates these requirements to appropriate parties
- Worked with the technical team and provides clarification on Functional requirements
- Participated in technical reviews and inspections to verify 'intent of change' is carried through the entire project.
- Worked in testing of Data Integrations related to data Warehousing and then to Master Data Management (MDM).
- Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
- Integrated provider data from all external and internal sources for Siperian MDM
- Managed Individuals (physicians, nurses, laboratory technicians and home health providers and so on) and organizations (clinics, labs, pharmacies and so on) for provider Master
- View and manage the relationships between physicians and their practice locations as well as track the communications preferences for contacting those providers
- Gathered requirements for SOA Web services for finding and maintaining provider information that is not tracked by source systems
Environment: ALM, EPIC Suite, SQL, Informatica MDM Siperian XU, Oracle, SQL*Plus, SOAP, MS Project, MS Visio, Rational Clear Case, MS Excel, SQL, JAVA, HTML, Unix, Windows-7.
Sr. QA Analyst/Tester
Confidential, Miami, FL
Responsibilities:
- Created UAT Test Cases to validate end-to-end business flows in Data Driven Testing environment.
- Responsible for creating UAT environment; ensure that all the test case input sources are available; test case output results were documented.
- Responsible to resolve exceptions in UAT in a very expeditious way and re-UAT to ensure accurate and timely delivery.
- Responsible for managing the Data Warehouse and Business Intelligence functions at Burger King
- As part of QA team was involved in implementation of ETL best practices.
- Lead multi-persons QA team for the data migration and consolidation project to perform end-to-end test.
- Ensured that UAT results are signed off by the right people in user community; worked with several different levels of users in UAT such as floor agents to the VP level.
- Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
- Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
- Experience in conducting end user training on various SAP R/3 modules.
- Building the data mining data base: tasks like data collection, data selection, data cleaning and solving data quality problems.
- Creating test plan, Walk through, integration approach and strategy document, test cases, scenarios, conditions and scripts, generated system test scripts for Customer Relationship Management (CRM).
- Created SSIS packages to import data from MS Access, Excel to SQL.
- Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
- Created SSIS packages to clean and load data to data warehouse
- Execute Quality Checkpoints pertaining to testing readiness for Integration System Test, User Acceptance Test, and Performance Test.
- Manually written the SQL queries to test the back end database.
- Working with clients to improve their BI environment to improve the quality and availability of data to the end users.
- Involved in DMSuite Data Masking tool Server installation.
- Formulate methods to perform Positive and Negative testing against requirements.
- Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
- Responsible for validation Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
- Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
- Used Agile testing methodology for achieving deadlines in UAT.
- Developed automated Test scripts using QTP to perform Functional and Regression testing.
- Executed and managed test cases and reported bugs in Quality Center.
- Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
- Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
- Validated data in between source and target after running Mappings by the Informatica developer team.
- Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
- Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
- Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
Environment: Windows - 7, NT, 2003, 98, UNIX, LINUX, Oracle 10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML,.Net, JavaScript, SAP, VB Script, Crystal, XML, SSIS/ SSRS, QC 10, QTP 9.5/10.0, Win Runner, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.
Sr. QA Tester / Analyst
Confidential, Plano, TX
Responsibilities:
- Coordinated all QA activities and enhancements using Agile Methodology.
- Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
- Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
- Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
- Good experience is Data Masking Techniques. Executed Data masking POC successfully using DMSuite.
- Involved in data migration from legacy database (Mainframe) to Oracle database.
- Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
- Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
- Experience in Data Transfers using Batch input methods, Transferred master data from previous system using LSMW SAP Tool.
- Involved the DMSuite Data Masking tool Proof-of- Concept at CIT
- Managed enterprise wide systems, Integration, User Acceptance and end-to-end quality assurance testing including: test design, test strategy, development, enhancement, documentation, and test execution of projects using Automated and Manual Testing tools.
- Created test scenarios and test cases for Online CRM application based on the requirements and provided to the business analyst for review and Signoff.
- Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
- Performed activities around testing such as developing test plans (i.e., integration, stress, and UAT) and schedules, test scripts, test data, use cases, and roles and responsibilities
- As a Senior QA Analyst/Team Leader worked on Loan IQ application that Covers the entire life cycle of a loan - from origination and deal tracking to administration and record maintenance.
- Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
- Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
- Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Worked on Loan IQ 5.4, 5.5, 6.0 and 7.0 versions.
- Involved in Functional, Integration, System, Regression, Data migration & Compatibility Testing.
- Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
- Executed and managed test cases and reported bugs in Quality Center.
- Used Clear Quest and Quality Center as the Defect management Reporting tools.
- Performed functional and load testing using SOAP UI.
- Used Clear Case as the Version Control tool.
- Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
- Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
- Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
- Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
- Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
- Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
Environment: Windows - 7, Vista, XP, UNIX, Oracle 11g, SQL Server 2008, TOAD, SQL, PL/SQL, Crystal Reports 14, Informatica Power Center 9.1, SAP, Misys Loan IQ, Erwin 8, QC 10.0, QTP 10.0, SOAP UI, HTML, XML, Java, Clear Case, Clear Quest, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, Firefox, IE, Chrome, Safari
Sr. QA Analyst/ ETL Tester
Confidential, Wausau, WI
Responsibilities:
- Responsible for reviewing Requirement Specifications and Design Documents.
- Involved in Test Case Design with respect to Test Plan.
- Involved as part of automation team using QTP, developed test scripts.
- Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
- Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
- Login to Quality Center retrieved the data from Test Lab, strings, OQ/PQ dry run, OQ/PQ formal, Regression data and tested manually in SAP Portal.
- Prepared and executed scenarios for the Regression testing on new ETL process builds.
- Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
- Worked on conversion of manual integration tests into automated tests using QTP.
- Performed tests for Functionality, GUI and Backend.
- Profiled the application database using DMSuite and prepared the data masking inventory.
- Executed automated as well as manual test scripts and validated Test conditions for Systems, Integration, Regression, and Conversion tests.
- Executing, Reporting and Tracking the defects using Quality Center.
- Executed regression tests at each new build in QTP
- Created and maintained Regression test suite to check the progress of the testing process by performing identical tests before and after fixing defects.
- Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
- Customized the scripts according to the requirements by using conditional statements and loops.
- Coordinate with manual tester and set up expectation on what will be handled by automation team.
- Designed and developed User defined functions, Generic functions with well versed VB scripting, Descriptive programming in Quick Test Professional 10.0.
- Reviewed the QTP Scripts developed by the team members.
- Ensure that all the test cases are updated in the Quality Center along with Master test plan.
- Developed automated Test scripts using QTP to perform Functional and Regression testing.
- Provided weekly status report to the Team lead and discuss issues related to quality and deadlines.
Environment: Windows - 7, Vista, XP, 2003, UNIX, Oracle 10g, QTP 10.0, XML, HTML, UML, TOAD, PL/SQL, Crystal Reports 14, QC 10.0, Misys Loan IQ, Informatica Power Center 8.6/8.1, Erwin 7.2, JavaScript, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, VMware
ETL Software Tester
Confidential
Responsibilities:
- Analyzed the requirement documents and detailed design documents to prepare test plans
- Communicated with BA's for questions related to the requirements and use cases
- Initially performed White box testing with a limited number of test cases to the internal workings of software under test and in the remaining part takes Black Box approach in applying input and just observing outputs
- Tested the UNIX Shell Scripts of the ETL processes.
- Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
- Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
- Involved in Test Case Design with respect to Test Plan.
- Executed Positive and Negative Test cases.
- Involved in Test Execution and Bug Reporting using Test Director.
- Performed GUI, Functional, Regression and compatibility Testing.
- Used Joins like Inner join, Outer joins while testing from multiple tables.
- Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
- Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
- Performed validation testing for each field in the application for different scenarios with the use of Mercury Test Director and HP QC.
- Used Joins like Inner join, Outer joins while testing from multiple tables.
- Tested PL/SQL procedures used in the ETL batch processes; used complex SQL queries to verify the data in the database tables.
- Analyzed and validated the data stored in the data base by running SQL Queries using SQL Server 2005.
- Involved in Test Reporting on daily/ weekly basis through company prescribed format.
- Provide accurate and timely testing status reports to the QA Lead and Project Manager.
- Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
- Executed test cases through Iterative testing for testing the incremental functionality.
- Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
Environment: Windows XP, NT, 2003, 2000, UNIX, C, Test Director 7.0, SQL Server 2005, SQL, PL/SQL, Oracle Designer 9i, TOAD, Informatica Power Center 7.1.2, Power Connect, UML, MS Word, Excel, PowerPoint, MS Visio, MS Project, QC 8.2, SOAP UI, XML