SUMMARY

• 5 years of experience in Quality Assurance and Software Testing of various business applications inClient/Server environments, Web - based applications, Data-Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of Software Development Life Cycle (waterfall and agile) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• 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 documentation, preparing test environments, executing and analyzing the results.
• Involved in preparation of Requirement Traceability Matrix (RTM), 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 Quality Center, 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: HP-ALM 12.53/TFS/Rally/JIRA/SDLC Tracker

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

Automation Tools: UFT, AssureNXT

DWH/ETL Tools: Ab Initio, 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, LINUX

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

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. ETL/ BI Reports Tester

Responsibilities:

• The Project was conceived to revision a number of internal business and technical processes to ensure Cigna HealthSpring is adhering to the latest Audit Protocols that include a detailed review of the CMS requirements and have a successful outcome on Claims, Appeals, Grievances and Complaints Procedure.
• 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).
• Worked with business and IT Teams to ensure clear requirements for sound testing strategies
• 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
• In-charge of functional testing on the product and making appropriate recommendations
• Identified, validated, communicated and tracked to closure defects and risks to the development team(s)
• Lead efforts to transition from manual testing to automated testing
• Created, executed and documented automated testing scripts
• 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
• Validated the end to end ETL process and monitored the session logs/log files in Informatica workflow Monitor
• Used Informatica workflow monitor to validate, run and monitor the jobs
• 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 Datawarehouse 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
• Handled Defect triage and Release activities
• Worked closely with business users and the project team to analyze business requirements and data analysis requirements documentation in order to create a test plan for each assigned project
• 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
• Analyzed and designed user transactions, scenarios and estimated load projections for performance testing using QTP
• 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
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization
• 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
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting
• 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

Confidential, Herndon, VA

QA Analyst/DWH/ETL/BI Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans
• Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT)
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM)
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End), Backend (Database)
• Developed and executed test cases and test scripts
• Executed graphs from command line and validated the graphs by writing SQL queries
• Worked with the UNIX shell scripts
• Used Rally as test management tool
• Tested Cognos Reports according to the business requirements
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports
• Tested reports in Cognos using Analysis studio, Report studio, and query studio
• Tested several business reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,drill down
• Prioritized the test cases based on the projected metrics and project deadlines
• Worked with Developers on Defects until the test case is passed, coordinated with the development team for closing a defect
• Extensively written SQL to confirm the data transfer from source to target
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries
• Involved in testing the UI screens, reports which were used by the internal business team
• Attended Bi-Weekly Defect Review and Defect Status meetings and provided updates to Team Lead on testing activities

Environment: Informatica Power center 9, Rally, DB2, JCL, MS Access, SQL Server 2008, PL/SQL, PuTTY, Flat files, Session Logs, SQL scripts