SUMMARY:

• Seasoned, versatile, highly motivated IT professional with about Eleven (11)+ years of experience as Quality Analyst having expertise in different Software Development Life Cycle (SDLC) process and Business Process Reengineering. Extensive experience on DB2 RDBMS based SAP applications as with Entertainment, Manufacturing, Financial, Health care and Insurance clients like Confidential , DHCS, UCLA Health Care, MetLife Inc, Confidential and GECFS . Role player in designing, deploy, Support and maintaining large scale Onsite - Offshore modules on).
• Strong experienced in Functional, Validation, Technical, Compatibility, Regression, System and User Acceptance Testing.
• Experienced in analyzing, attaining business requirements, system analysis, Use case studies, process flows, testable requirements, evaluating existing or proposed systems, including business requirements and test scripting
• Excellent experience in creating and understanding the Test strategy document and then preparing the test approach documents, preparing the test plan documents, and test summary document also.
• Strong Excel knowledge in maintaining the test cases, defect status and designing the automated Worksheets in the Excel.
• Progressed through analytical and applications work in project as Mainframe Developer, Systems Analyst and QA Analyst/Onsite Coordinator.
• Extensive experience with function libraries, Key word driven approach and best practices in Automation with QTP and lately using HP ALM 11.
• Experienced in planning and executing tests from large system wide tests (SIT, BAT, UAT, etc.) to individual functional tests and regression tests. Methodologies used include waterfall, iterative, agile, & RUP.
• Expertise in creation, execution and maintenance of Test Plans, Test Specifications, Test Scenarios, Test Scripts and Test cases.
• Involved in Bug Tracking and created Defect Reports using Test Management/ Defect Tracking Tools like Test Director, Quality Center, Clear Quest and documented Test Documents using MS Office Tools - MS-Word, Excel and PowerPoint.
• Proficient in Object Oriented Programming, Version Control, change management procedures and Configuration Management using Microsoft VSS.
• Expertise in various domains like Banking & Finance, Telecomm and Oracle Applications (E-Business Suite). Good exposure in Foreign Exchange, Money Market and Fixed Income Securities.
• Proficiency in solving High level analytical and IT related issues involving both hardware and software.
• Excellent Organization and Interpersonal skills; able to meet the requirements in a given period of time, strong communication skills allowing to liaise with people at all levels in the organization and commitment to achieving corporate goals.
• Expertise in querying and testing RDBMS such as DB2, SQL Server and Oracle.
• Good Team Player with ability to grasp new concepts quickly and implement them in a productive manner
• Strong experience in Waterfall and Agile methodologies.
• Performed role of SCRUM master responsible for conducting JAD and JAR sessions and tracking the project status on Daily basis.Good knowledge on Medicare, Medicaid & Commercial Insurance in HIPAA ANSI X12 4010, 5010 formats including 276, 277, 835, 837, 997, NPI, ICD 9, ICD 10, NDC, DRG, CPT, NCPDP codes & NSF formats for interfaces & images to clearinghouses/ trading partners applications.
• Good knowledge and extensively used Oracle, SQL, and PL/SQL, SQL Enterprise Manager Data analysis and reporting.

TECHNICAL SKILLS:

Testing Tools: CMMI and PMI methodologies, Agile methodologies, SDLC, Microsoft Project, PowerPoint, SoapUI, LoadUI, Jmeter, JUnit, LoadUI, Groovy, Selenium/ Webdriver, LAMP, Vendor Management, Quick Test Pro 10.x/8.x, Win Runner 8.0/7.5, Quality Center 9.2/8.0/Test Director, Clear Quest, Coburtura, SOAP UI

Databases: DB 2 9.0/8.0/7.0/6.0 , SQL Server 2000/2005/2008 , Oracle 8i/9i/10g MySQL, MS Access, MS Excel, Sybase

Utility Tools: BMC utilities, CA Platinum, TOAD 8.5, SQL Assistant, SQL Query Analyzer, SQL Server Management Studio, SQL* Plus, SQL* Loader, SQL Developer, Rapid SQL, ETL - Informatica Power Center, Business Objects

MS Office: MS Project, Visio, Word, Access, Power Point, Excel, Outlook

Operating Systems: Mainframes ZOS, Windows 95/98/2000/XP, Linux and UNIX.

Web Programming: HTML, XML,JSP, Java Script, .NET

Programming languages: COBOL /JCL/ADSO/CICS /SQL, PL/SQL, T-SQL, C

Middleware: MQ-Series

PROFESSIONAL EXPERIENCE:

Confidential, CA San Diego

Sr.Systems Quality Analyst /Team Lead.

Responsibilities:

• As a Senior QA Analyst, reviewed the system requirement specification documents, developed test strategy, test plan documents and also developed traceability matrix between test requirements and test cases.
• Worked closely with Business Analysts, Developers and end users to gather user requirements, create test cases/scenarios, test steps, expected results and test data in Quality Center.
• Coordinated with developers to develop functional design specifications based on blue print documentation.
• Developed Scripts for FI and CO modules of ECC 6.0 as well as other legacy system scripts.
• Designed comprehensive test plans for the risk management applications and SOA interfaces.
• Prepared test scripts and tested core functionality of interfaces with onsite/offsite/offshore teams.
• Tested scripts related to bank file formats, intercompany scenarios, vendor notification forms, etc.
• Walk through with CPO's and BPO's for discussions in various functionalities.
• Prepared Test Plans, scheduled for testing, logged issues, coordinate and monitor all issues in the Quality Center.
• Tested the Configured Billing types. E.g. periodic billing or milestone billing.
• Worked on manual check deposit, electronic bank statement and payment run and clearing open items
• Attended Legacy meetings to find out process flows of Legacy systems and prepared End-to-End Business processes related to Insurance and Cash Disbursement process.
• Tested the Assignment of billing plan types to sales document items.
• Prepared test scope by identifying high, medium and low impact transactions.
• Prepared End to End Business processes for testing with the help of business.
• Tested Various Inbound and Outbound Interface Scenarios in EDI, IDOC Manually.
• Uploaded the Functional Test Cases into Test Plan in the Quality Center and arranged test scripts in Test lab according to End to End business processes.
• Execution of Test scripts in Test lab (QTP and ALM processes) .
• Performed Monthly validations on Invoice/General Ledger and Accounts Receivables
• Worked on development of Billing Pricing and Web services. Implemented Automation tools Jmeter, Selenium, SoapUI, LoadUI/Web Service testing (Rest/Soap)
• Performed aggressive testing on Mobile Apps (iOS/Android)
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).

Environment: HP ALM 11, SAP ECC 6, QNXT, FACETS, MS Office, FI, GL, AR, AP, BW, DB2 MSSQL, Infinium, SharePoint, QTP, Quality Center (QC) /ALM, Oracle, Test Director, SharePoint.

Confidential - Los Angeles, CA

Sr.Quality Assurance Analyst

Responsible for:

• Performing Change Request Assessments to identify the Test Scenarios.
• Creation of system test scripts pertaining to functionality and also End to End scripts during build phase.
• Providing estimates for the Requirement and Regression test efforts.
• Taking Business sign-off on Test bed.
• Perform the testing environment check before starting of the system test cycle.
• Create the test data, if needed.
• Execution of test script and logging the defects in Quality Centre 10.
• Monitoring of Test case preparation and Test execution and raising the Risks and Issues pertaining to achieving of milestones.
• Preliminary Root Cause Analysis of the Defects.
• Preparing the Lessons learnt and Best Practices document for the particular Release.
• Provide suggestions and implement accepted suggestions for improvement of testing process.
• Participated in all aspects of project test planning process including providing inputs to Integrated Test Strategy, developing Test Plan, mapping requirements to test cases, test case/ component development, data mining.
• Project set-up and management in test management tool - Quality Center.
• Play major role and represent QA in all decision makings.
• Requirement analysis and test strategy planning. Creation and review of test deliverables.
• End-to-end testing of all newly developed modules, Single point of contact for all groups from QA end.
• Coordination with offshore team for workload distribution and management.
• Managing defect tracking, reporting and prevention.
• Planning and execution of releases/installations. Individually handled testing activities for all releases.
• Provide quick and continuous feedback to the technology team and drive development, documentation for project support and maintenance.

Environment: Quality Centre, Mainframe Technologies like ( COBOL, JCL, VSAM, DB2, File Aid, CICS), PL/SQL, ETL tools(Informatica Pwer Center & BO)

Confidential, Sacramento, USA.

Program Quality Analyst

Responsibilities:

• Day - to-day Client Interactions and People Management ensuring optimum utilization of resources at Onsite and Off-site.
• Systems support for QNXT claims services applications backend using ADABAS, DB2
• Responsible to attend Concept scoping sessions, Impact matrix walkthroughs as SME for my block and provide signoffs for the same.
• Conduct partnership meetings for Business User Centric applications.
• Active participation in business proposals, budget estimation and work estimation for multiple projects and cost benefit analysis.
• Strong knowledge of Project life cycle, SDLC lifecycle and key performer in Pre and Post implementation activities.
• Created record keeping of the most occurring tickets and maintained a Knowledge Base articles, to help support team resolve the issue and keep the production noise at a lower level.
• Documenting all the processes and the flow steps in achieving the successful outcome of the noise. Mapping the scheduled tasks and monitoring the failure on the daily basis.
• Analyzed and met customer requirements and set production expectations by executing the production plan and identifying deviations.
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Extensively worked on testing of SAP SD Sales, Shipping, transportation, Billing and Credit Management, MM Inventory Management, Purchasing and Material Master Modules.
• Involved in Testing of SAP HR modules like Personal Management, Personal Time management, Master Data, Time Management, Payroll, Employee Self Service (ESS), Manager Self Service (MSS) and Payroll.
• Developed Test Scripts for various processes in FI like Cost Estimate for Material, Internal order, Cost center settlement using Selenium.
• Created test plans & test cases in Quality Center from the business requirement document and technical specifications. Presented the test script alternatives to managers and getting sign off. Mapping the Test Cases from Test Plan to Test Lab under Quality Center for Execution.
• Executing the Automated Test Cases through Quality Center.
• Reviewing the defects and Reporting the Defects through Quality Center.
• Developed scripts for Web version of the Application for Regression testing.
• Preparing Test Strategy, Test Plans and conducting consolidation acceptance test.
• Worked extensively in Performance testing and Production support.
• Performed Record, report, and track defects to accurately depict the status of the system, daily testing status reports and acting as a single point of contact for defect tracking issues and updates.
• Post go-live support.
• Have a first hand knowledge of Enrollment Electronic Data Interchange and experienced with different insurance companies eligibility and claims systems.

Environment: HP ALM, QNXT, UML, Data Analysis, MS Office, Visio, Microsoft SQL 2007, SOAP UI, SELENIUM, Quality Center, Use Cases, FACTS, Cute FTP 8, Alloy Navigator Enterprise, Z/OS & IBM AIX

Confidential- CA

Sr. Quality Analyst

Responsibilities:

• Analyzing the requirements, understanding the requirements with respective business analyst and development team.
• Project Time Estimation for QA efforts
• Preparing the RTM, Test Plan and Test Specs and transfer the project knowledge to the team.
• Working on Build and Release activities, create related documentation.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Responsible for reviewing of the test cases and following up with the BA for further review.
• Review for all the testing deliverables.
• Helping out my Team lead in day to day activities.
• Configuration Manager Activities.
• Lead Offshore QA efforts and conduct daily stand up call for status tracking .
• Complete ownership on Data Mining & Setup.
• Work allocation and planning.
• Play major role and represent QA in all decision makings.
• Requirement analysis and test strategy planning. Creation and review on test deliverables from peers
• End-to-end testing of all newly developed modules.
• Coordination with stakeholders from multiple groups.
• Managing defect tracking, reporting and prevention.
• Planning and execution of releases/installations. Individually handled testing activities for all releases
• Documentation for project support and maintenance.
• Mentoring and training new team members.

Environment: HP QC 10, Mainframe Technologies like ( Cobol, Jcl, Vsam, Db2, File Aid), Data warehousing technologies (Informatica power center, Business Objects).

Confidential

Analyst.

Responsibilities:

• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Followed the adaptive RUP framework for the whole Project life cycle (PLC).
• Fine-tuned search engines and pulled data from different databases and migrated data back and forth using SQL.
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
• Duties included working as Requirement Gathering Analysts on DB2 and ORACLE based Medical systems application- iCAP(Image Capturing and Processing system) Database Design. And Migration, Application ERD Design and Implementation to include Pure XML.
• Responsible for configuration of Medicaid/Medicare benefits and contracts within the QNXT claim processing system.
• Uses knowledge of coding guidelines (CMS, AMA, Health plan policy, Aetna policy), claims processing, edit analysis, financial impact, claims impact and QNXT systems to apply all correct coding policies and federal regulations to claims as they are processed.
• Perform root cause analysis of system issues and determine proper resolution through configuration of QNXT contracts and benefits and maintenance of the Claim Check Knowledge base and Integration Wizard Application.
• Develops and communicates effective workaround procedures to address reported system issues.
• Reviews research, develops/ modify and manages protocols in order to coordinate Correct Coding methodology related to medical coding. Monitor Federal, State and healthcare trade industry websites and resources for updates and changes.
• Perform analysis to assess the cause of moderate issues found in the QNXT system.
• Conduct fact-finding research to create solutions to system issues.
• Provide validation of updated procedures to ensure they are accurate and efficient; ensuring quick identification of any other defects.
• Coordinate with peers to verify that updates are correct and to determine additional action if needed.
• Retain learned experiences gained from the assigned priorities to anticipate and resolve future issues. Analyzes and approves routine claims that cannot be auto adjudicated. Apply medical necessity guidelines, determine coverage, complete eligibility verification, identify discrepancies, and applies all cost containment measures to assist in the claim adjudication process.
• Facilitate training when considered topic subject matter expert.

Environment: QNXT, UML, Data Analysis, MS Office, Visio, Quality Center, Use Cases, FACTS, Cute FTP 8, Alloy Navigator Enterprise

Confidential

Qualitys Analyst/Team Lead /Programmer

Responsibilities:

• Duties included working as Programmer/Analyst on Large and Very Large DB (VLDB) applications on DB2 and ADABAS databases.
• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Ran various Batch jobs using telnet service (Unix)
• Used Test Director for Bug Reports and Defect Tracking.
• Tested User Interface inconsistency and application functionality.
• Developed SQL scripts to validate the data loaded into backend, when user has performed a data insertion operation on the frontend.
• Preparation of test data for various levels of testing
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of automate the process of loading, pulling the data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.

Environment: Oracle 8i, SQL, TOAD 7.0, Test Director, IBM Mainframes, DB2, SPUFI, TOAD, HP- QC.

Confidential

Responsibilities:

• Management of financial dashboard for the Projects's financial performance reporting. Presented financial recommendations to senior management on pricing and adhoc projects
• DB2 /ORACLE -DBA support for User and Space Management. COBOL, DB2, JCL, CICS, MQ-series Code development and Modules interlinking, Report analysis using Eztrieve.
• Team Lead role for smooth task allocation and project execution handled the team of 6 members at offshore for 1yr +.
• Change control versioning and admin using DB2 Admin and Endeavor.
• Optimize the Existing SQL queries to Improve Performance. Loading & Unloading of Tables from Production to Test region, Q-replication via MQ series.
• Binding and Rebinding of the Packages for Testing.
• Creating Storage Groups, Databases, Table spaces & Tables for DB2 Objects.
• Running DB2 Utilities like Load, Unload, Re-org, Repair, Rebuild.
• Data Import Export and User management for Oracle DB.
• Optimize the Existing SQL queries to Improve Performance.
• SAS Analysis on ORACLE databases.
• Estimation & Project Schedule creation.
• Unit testing using SMARTTEST INTERTEST tools as well.
• Updating the technical and Functional documents as required.
• Participating in Review and QC processes.
• Modifications to existing CICS programs.
• Allocate the work to team members.
• Logical Designing For SAS converted Data tables using ERWIN.
• Actively involved in the Technical requirement gathering, test case preparation and coding, testing and document phases of the task.

Environment: IBM Mainframes on OS/390.