SUMMARY

• 6 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web - based applications, Data-Warehousing solutions, ETL and Business Intelligence solutions, Retail POS Systems, Mobile POS system.
• Excellent working knowledge of Software Development Life Cycle (waterfall and agile) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expert in Data intake and scrubbing tools; PFT (Partner file transfer), EDI, External Web Services, POPIT (Prof Of Performance Intake Tool), NEXT (Next Generation Transformation Tool).
• Expert in application functionality and system technology (POS, databases, OS, APIs)
• Working Knowledge of iOS devices, point-of-sale devices and server configurations
• Expert in 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.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Test cases.
• Have knowledge and experience in the implementation of HIPAA regulations project.
• Knowledge on HIPAA EDI Transactions and on eligibility Transactions (270, 271, 834, 835, and 837).
• Have solid experience on database query tools such as Teradata SQL Assistance, Teradata Studio, SQL Assistant, DB2, and SQL Server.
• Excellent knowledge on data modeling, Star / Snowflakes Schema, Dimension tables, Fact tables and SCD type 1,2,3 and 6.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, AB Initio and SSIS ETL tools.
• Experience on UNIX commands.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing and Recovery Testing.
• Strong experience in preparing test documentation, preparing test environments, executing and analyzing the results.
• Involved in preparation Defect Report, and Weekly Status Reports.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry Standard Tools like Rally, QTest, Clear Quest, and HP-ALM.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Experienced in interacting with Clients, Business Analysts, UAT Users, and Developers.
• Have experience working in Agile/Scrum Methodology.
• 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

Defect Tracking: qTest, HP-ALM 12.53/TFS/Rally/JIRA/SDLC Tracker

Databases: Toad,Teradata SQL Assistance 15.10, Teradata Studio 15.10, SQL Server 2008/2011

Automation Tools: UFT, AssureNXT

DWH/ETL Tools: SSIS, Informatica

Application environments: C#, .NET Framework, .NET, Web Application, SSIS/ SSRS

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

Operating Systems/ Products: Windows, UNIX

Software Lifecycle Management Methods: Scrum, Agile and Traditional Waterfall model.

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 sales, inventory, revenue, non-revenue and claims data for Intel products submitted by distributors, resellers and channel suppliers engaged with Intel.
• Prepared MOC data in txt, csv, and xlsx files format for data intake tool and tested all file type fiels based on the 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
• Tested web-based application internal POPIT UI
• Tested API calls for POPIT applications in Postman
• 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, Retail POS systems, integrated credit card 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 web base application (eCommerce app)
• 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 and 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.

Environment: Retail POS System, Mobile POS, Xstore, Xenviroment, SQL Server 2010.5, HTML, Toad, MS Office, Windows 10.

Confidential, Nashville, TN

Sr. ETL/ BI Reports Tester

Responsibilities:

• Responsible for testing the Organization Determination Appeals and Grievances (ODAG), Coverage Determination Appeals and Grievances (CDAG), Service Authorization Request Appeals and Grievances (SARAG), Formulary Administration (FA), and Medication Therapy Management (MTM), Claims and Complaints ensuring they meet the CMS Guidelines.
• Tested 42 universes (Tables) of CMS protocol project that included ODAG, CDAG, FA, SARAG, and MTM set of tables
• 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
• Involved in the Universe (Table) Submission process of the Center for Medicare and Medicaid Service, CMS Universal Protocol project
• Validated the data from SQL server to Teradata, Teradata to Universe through UI
• Validated all Universe Submissions report based on CMS protocols.
• Developing test scripts for execution using functional design document and business design documents for Cigna HealthSpring for very complex and large web-based application (portal).
• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing (UAT, Integration, End-to-End, Regression, Beta)
• 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)
• Prepared MOC data in txt, csv, and xlsx files format and tested in SQL server and Teradata
• Responsible for translating business requirements into quality assurance test cases
• Have tested SSIS packages according to business requirements and data mapping requirement documents
• Analyzed the testing progress by conducting a walk-through meeting with internal quality assurance groups and with development groups
• Tested data from different sources, including ARIZONA, LEON, Confidential, and FDR in Confidential Data warehouse environment and gave the result to CMS

Environment: TFS .112, SSIS, Assure NXT, and SQL Server 2010.5, HTML, Teradata .10, MS Office, MTM .112, Windows 8.

Confidential, Minneapolis, MN

ETL QA Analyst

Responsibilities:

• 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, functional use case diagrams, and other project related 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 system of record (SOR) is loaded appropriately into the destination columns/tables/views; perform Backend Testing manually that ensured data consistency on the Front-end
• Reviewed raw data prior to the load process, and determine if the extract/transformation/load (ETL) process deposits the data correctly into the final table/view
• Formulated methods to perform Positive and Negative testing against requirements
• Conducted Smoke testing, Sanity testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing
• Tested ETL Dimension Table SCD Type 1 and Type 2 and Type 3, i.e., Append load strategy, Upsert load strategy, and temporal load Strategy
• 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 Agile testing methodology for achieving deadlines in UAT; extensively worked on UAT of several modules single handily.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata
• Used Teradata tools to run SQL queries and validate the data loaded into the stage table and from stage to target table tables and view
• Defect tracking and Status reporting using HP-ALM, JIRA and Clear Quest defect tracking tool
• Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and target Database
• Participated in weekly status meetings, kick off meetings, design review meetings, BRD review meetings, spec review meeting, walkthroughs, and documented proceedings

ENVIRONMENT: Teradata SQL Assistant, Teradata Studio, HP-ALM, SDLC Tracker, JIRA, Agile, Ab-initio, SharePoint, UNIX, Documentation Tools: MS Office - MS Word, Excel, PowerPoint, MS Project