Summary

• Solutions-focusedSr. QA Tester with 9 plus years of experience high-level proficiency with SQL, MS Test Manager, TFS, Rational, QualityCenter, QTP,SoapUI automation toolsets,SSIS,Informatica, Informatica DVO, Datastageand a foundation in Java, C , VB Script, Linux/Unix and monitoring tools with knowledge in HP ALM, JIRA.
• Strong Experience in creating test strategy, test plans and automating test scripts to validate functionality and to isolate software defects track and close open defects. Serve as a value-adding member of QA/Testing teams in AGILE environment.
• Project Experience includesSection 508 Testing, Data Mining, Data validation for data integrity and data quality,ETL testing, Datawarehouse testing, Report testing, Webservices testing, Java application testing, .NET application, Mobile testing, 834 transaction validation, HIPAA 5010 Compliance for 834,837 that involved EDI technology.

Skills Overview

Project History Highlights

Project Overview: IT Executive Sponsor and Enterprise Architect is an insurance company that processes all claims for their groups, members and providers. As an organization IT Executive Sponsor and Enterprise Architect has transformed completely into IT Executive Sponsor and Enterprise Architect Teams and Products Delivery and Service .

Technologies: Informatica 9.6.1, SAS, SQL Server 2012, SSIS, Visual Studio 2012, XML, .NET, Oracle, Web services,DB2,COGNOS,EA Sparx, SOAPUI, Autosys and Tidal scheduler, JIRA, Query Surge.

Role Description:

Sr. QA Tester/ Test Lead

• Lead testing efforts and Created Test Strategy, Test Plan, Test Cases and Test Scenarios to achieve end to end testing, system testing, integrated testing and UAT for various projects as in Corelink Group/Member Data Migration, Navinet Provider Portal, CRM application, Membership Enrollment Tracking Application, Individual Dental Enrollment Product, and Actuarial Product.
• Used SQL select statements that include joins, union all, subqueries, having, group by, Recursive CTE, Aggregate functions to extract the data for data validation and created stored procedures for repetitive test data validation.
• Used insert and update statements to create and mock the test data for a particular test scenario validation.
• Completed testing of Data Migration, Application Interfaces and Data Extracts which consisted of 50 ETL extracts for External Vendors and Internal Users.
• Provided data quality assurance on ETL workflows, Reports, the way the data is stored.
• Used mapping documents to validate the data routing from source files XML, flat files etc. to Staging to Target tables in EDW or Target flat files and in validating the transformation logic.
• Involved in creating test scenarios based on plan subscriptions for subscribers and members to validate 834 EDI transactions.
• Weekly status reports are sent to higher management. Provided mentorship, guidance and instructions to the team.
• Involved in setting up test environment, test data preparation.
• Arranged daily Quick touch point meetings for Priority defects or show stoppers finding with the offshore Deloitte Development team.
• Involved in creating user stories and use cases.
• Ensured the key results like complete system testing, regression testing,UAT and Vendor testing are achieved.
• Involved in complete system testing of MedicodeBlue application.
• Worked on ETL development changes for the enhancements.

Confidential

Data Analyst

• Played the role of Data Analyst proposing data recommendations, data transformation logic in mapping document. The additional role as Data Analyst on ICD-10 conversion project has been economical for the company and we were able to complete all the Data Analysis required for the project within 5-6 months which otherwise would have taken 9-12 months.
• The data migration of Groups and Members to a new system at BCBS of North Dakota is a business transformation and has an estimated savings of 5-6 million an year. Both BCBSNE and BCBS of ND use one flexible platform for processing claims and reimbursements.

Project Overview:

• o The Commercial Card division of Confidential developed and operated New PaymentNet3, a transactional credit card processing system serving corporate institutions.
• o Investment and Wealth Management division offered investment management across all major asset classes including equities, fixed income, multi-asset and money market funds.

Technologies: Quality Center 9.2, QTP 9.0, Rational Requisite Pro, Rational Clear Quest, .NET, VB, XML, XSL, C , SQLServer2000, DB2, Web services, Mainframe, Lotus Notes 7.1.2, Cognos and DataStage

Confidential

Role Description: Tester

• Involved in testing the ETL process that extract customer data from the PaymentNet system to a format that can be consumed by the targeted customers' financial system.
• Defects has reduced from 10 a week to as low as 1-2 per week.
• Involved in testing the PaymentNet3 application for Section 508 compliance using JAWS.
• Involved in testing ETL processes that populate the Datamarts from legacy system EDW
• Involved in testing the Datamartsthat hold the multi-asset class data like Cash, equity, bonds etc.
• Documented weekly QA status and reported to higher management. Identified the risks and prioritized the issues and escalated the issues to management.
• Involved in data migration project from BankOne Corporation to JPMorgan. Validated report data for BankOne Corporation crystal reports converted to MS SQl reports. Ensured customers are not impacted with the migration.
• Involved in testing Datastage ETL jobs that are created for the data loads from TSYS into JPMC Datamart. Created test plan and test cases in Quality Center for testing these ETL jobs.
• Involved in running the BVT's during build releases. Involved in regression testing,

Confidential

Role Description: Graduate Research Assistant :

• Involved in writing SQL queries and created reports. Accessed data from Oracle using MS Access in creating reports and forms.
• Validated if the report created is meeting the Social Services department requirements.
• Involved in designing web pages using Front Page2000 for ASU West campus Social Services department. Updated the web page with daily events and news happenings.
• Created thumbnails and improved site performance.
• Used Front Page Server Extensions in locking files, updating hyperlinks, applying theme to all pages on the web, creating, deleting and renaming webs and subwebs and incorporating database access in a web.
• Also worked as Statistical Analyst in providing statistical analysis for School of Nursing department.

Technologies: Oracle, MS Access, Front Page2000, HTML