SUMMARY:

• 4 years of IT experience in Analysis and Testing of Data - Warehousing solutions, ETL and Business Intelligence solutions, Retail POS Systems, Mobile POS system solutions using Data Warehouse/Data Mart Design, Manual, ETL, OLAP, Client/Server applications
• Good understanding concepts on Business Intelligence and Informatica Power Center using Repository Manager, Designer, Workflow Manager and Workflow Monitor special focus on validating E2E data mapping documents, testing transformations like Aggregator, Look ups, expression, joiner and Router.
• Hands on experience using complex SQL queries (DML, Joins, Set operators, analytical functions, aggregate functions etc..) using Oracle, SQL Server and Teradata.
• Strong working experience on Testing of Data Completeness, Data Transformation, Data Quality, Data Integration and Data Migration of an ETL Applications using Backend/Database Testing.
• Extensive experience in Writing, Executing and Maintaining Test Cases, Test Strategy, Test Planning, Test Completion Report, Test Estimates, Test Design, Test Execution Analysis, Defect Tracking, Test Reporting and QA Sign-Off
• Excellent working noledge of Software Development Life Cycle- SDLC (waterfall and agile) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Rich experience in API Testing for XML and JSON formats by using Post man and Rest client
• Experience on ETL Testing, Smoke Testing, Sanity Testing, Functional Testing, System Integration Testing, GUI Testing, Regression Testing, Performance Testing, Database Testing, Data Migration testing, Data Redundancy, End to End Testing, User acceptance testing (UAT), Compatibility Testing and Product Assurance Testing for Web based and Client/Server applications.
• Expert in testing of Data intake and scrubbing tools; PFT (Partner file transfer), EDI, External Web Services, POPIT (Prof of Performance Intake Tool), NEXT (Next Generation Transformation Tool).
• Strong Working experience in iOS devices, point-of-sale devices
• Have noledge and experience in the implementation of HIPAA regulations project.
• Excellent noledge on data modeling, Star / Snowflakes Schema, Dimension tables, Fact tables and Testing of SCD type 1,2,3
• Experience on UNIX commands for checking logs file.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry Standard Tools like JIRA, Rally, QTest, and HP-ALM, TFS
• Excellent in time management and organizational skills and handle multiple task in a fast-paced environment.
• Excellent in interpersonal, communication, documentation and presentation skills; self-motivated and quick learning skills.

TECHNICAL SKILLS:

Test Management/Defect Tracking Tools: QTest, Rally, TFS, JIRA, HP-ALM, SDLC Tracker

Databases: Teradata SQL Assistant 15.10, SQL Server 2008/2014

Automation Tool: AssureNXT

DWH/ETL Tools Environment: SSIS, Informatica, Ab-Initio

Software Lifecycle Management Methods: Agile and Traditional Waterfall Model

Operating System: Windows, Unix

MS Suite/Project Tools: MS Office(Word, Excel, PowerPoint, Outlook) MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Hillsboro, OR

QA Test lead

Responsibilities:

• Conducted comprehensive testing on Intel data intake and scrubbing tools; PFT (Partner file transfer), EDI, External Web Services, POPIT (Prof of Performance Intake Tool), NEXT (Next Generation Transformation Tool) for NEXT and POPIT projects
• Tested backend database for sales, inventory, revenue, non-revenue and claims data for Intel products submitted by distributors and resellers engaged with Intel.
• Worked on JSON file for API testing by using Post mans
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Prepared MOC data in txt, csv, and xlsx. files format for data intake tool and tested all file type fields based on the requirement documents
• Formulated methods to perform Positive and Negative testing against requirements
• Uploaded file from Intel intake tools and validated in back end data base (CHM and EDW)
• Did End customer and product match validation and assure all the fields in the table are updated as expected.
• Tested all the jobs (EC match, Product match, File move batch, Update consume batch, reject consumer batch, Next batch etc..) in different folders and table which moves data from one DB to another DB and from one table to another table.
• Used simple to complex SQL queries to test data in back end database.
• Created detailed test plans and executed test cases for all assigned projects in Rally
• Performed functional, integration, end to end and regression testing of intel data scrubbing tools functionality
• Conduct post-deployment review and provide detailed report and analysis of all defects, risks, and issues identified during testing of all assigned projects
• Assist with trouble-shooting production-level issues, behaviors, and potential problems/defects
• Worked with business and IT Teams to ensure clear requirements for sound testing strategies
• In-charge of functional testing on the product and making appropriate recommendations

Confidential, Nashville, TN

QA Test lead

Responsibilities:

• Conducted comprehensive testing on back office application (Inventory, Online Order,) and mobile (POS) system for Team Member Mobility and Petsense projects
• Tested mobile apps, web base application (eCommerce app), Retail POS systems, and all POS peripherals
• Created detailed test plans and executed test cases for all assigned projects in Qtest
• Did price change in SAP for promotional, clearance, regular and new SKUs and validated changes in POS and back end store data base
• Used simple to complex SQL queries to test data in back end database.
• Performed functional, integration, end to end and regression testing for mobile POS in VeriFone and Honeywell devices by comparing on Retail POS system functionality
• Tested API for all the mobile applications in Postman and Advance rest client tools
• Validated log files generated in the server by using Unix command in putty tools.
• Identified and logged defects using JIRA which was linked to the Qtest.
• Conduct post-deployment review and provide detailed report and analysis of all defects, risks, and issues identified during testing of all assigned projects
• Prepare and schedule UAT testing for end-users
• Participate in review of standards, procedures, tools, and processes to support documentation for accuracy and usability.

Confidential Spring, Nashville, TN

Sr. ETL/ BI Reports Tester

Responsibilities:

• Responsible for testing 42 universes (Tables) of CMS protocol project that included Organization Determination Appeals and Grievances ( ODAG), Coverage Determination Appeals and Grievances ( CDAG), Formulary Administration ( FA), Service Authorization Request Appeals and Grievances ( SARAG), and Medication Therapy Management (MTM) set of tables and ensuring they meet the CMS Guidelines.
• Engaged in the testing of Universe Data Acquisition process starting from request initiation from CMS office, control table driven request flow, data sharing between source team and ODMS team till the point request is completed
• Prepared MOC data in txt, csv, and xlsx files format and tested in SQL server and Teradata
• Validated all Universe Submissions report based on CMS protocols.
• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing (UAT, Integration, End-to-End, Regression) based on business requirements documents
• Monitored testing efforts conducted by vendors to ensure that the testing depth, breadth, and techniques used align with CMS requirements
• Identified, validated, communicated and tracked to closure defects and risks to the development team(s)
• Analyzed the testing progress by conducting a walk-through meeting with internal QA groups and with Dev groups
• Tested data from different sources, including ARIZONA, LEON, Confidential SPRING, and FDR in Confidential Spring Data warehouse environment and gave the result to CMS

Confidential, Minneapolis, MN

ETL QA Analyst

Responsibilities:

• Tested Master data management system (Data migration testing, Data cleansing testing, Data standardization testing, Data consolidation testing)
• Tested ETL Dimension Table SCD Type 1 and Type 2 and Type 3, me.e. Append load strategy, Upsert load strategy, and temporal load Strategy for Data migration testing, Data cleansing testing, Data standardization testing, Data consolidation testing
• Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.
• Created test plans, test cases and participate in user acceptance testing to ensure the highest quality products are released to production
• Analyzed the requirements from business requirement, functional requirement document, and mapping documents to design and develop effective Test Plan, Test cases, and Test Script
• Created and executed SQL statement in Teradata database in order to verify that data obtained from source system of record (SOR) is loaded appropriately into the destination columns/tables/views; checked the data integrity in ETL Flow of data from source to stage and target Database
• Conducted Smoke testing, Sanity testing, Functional testing, Regression testing, and Integration testing, and Data validation testing
• Tested Row level access management (RLAM) and Non- Row level access management (Non-RLAM) tables that restrict user to access all the data from the table
• Used Teradata tools to run SQL queries and validate the data loaded into the stage table and from stage to target table and views
• Defect tracking and Status reporting using HP-ALM, JIRA and Clear Quest defect tracking tool
• Participated in weekly status meetings, kick off meetings, design review meetings, BRD review meetings, spec review meeting, walkthroughs, and documented proceedings