SUMMARY

• IT Professional with 12 plus years of experience in Systems Analysis, Design, Development and Testing
• Familiar with Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile
• Worked in agile environment with scrum teams and participated in sprint planning, daily stand up, and sprint retrospective meetings
• Wrote user stories, created mockup screens, defined acceptance criteria and assigned points
• Experience in writing business requirements (BRD) and translating into system requirements (SRD) to define functional and non - functional requirements using DOORS
• Created Functional Requirements Document (FRD) to define use case, UML, process flow, context and sequence diagrams using Visio with Business Process Model and Notation (BPMN) based graphical notations
• Strong expertise in manual and automated testing both Data Warehouse and web based applications
• Expertise on UFT, Selenium (Java)
• Developed Data Driven, Key Word Driven and Hybrid frameworks with UFT, Selenium (Java)
• Developed Data Driven (TDD) and Behavior Driven Development (BDD) frameworks in Selenium Java using Cucumber
• Expertise in using tools including Quality Center, Test Director, UFT, Selenium, Cucumber
• Involved in test planning and analysis, data preparation, execution and post quality control
• Created test plans that define test methods and tools to be employed for the new or customized projects
• Experienced in designing scenario & rules based test cases and test data preparation per requirements
• Expertise in manipulating XML, .dat files using XMLSpy, TextPad to validate the edit rules and messages
• Good working knowledge in Data Warehouse and Business Intelligence reports
• Database testing includes DDL, DML, data integrity and validation, triggers and stored procedures
• Developed Test Cases for different HIPPA, EDI ASCII X12 message formats
• Good programming knowledge using VB.NET, ASP.NET, Java, VBScript and JScript
• Strong skills in MS Excel in using formulae, graphs, VLookUp, Pivot tables, macros with VBScript
• Performed System, UAT, Integration, Functional, Regression, database and web services testing
• Created and tracked defects, reviewed, analyzed and coordinated with the respective teams to resolve
• Strong experience in database testing which includes Data Validation, Data Mapping, Data Conversion, Data Analysis using SQL Queries
• Effective individual and team player with excellent verbal and written communication skills, strong analytical, pattern detection and problem solving abilities in fast speedy environment
• Good domain knowledge including Financial, Healthcare and Human Resource

COMPUTER SKILLS

Operating Systems: MS-Windows NT/2000/XP/Vista, HP-UNIX, MS DOS

Languages: SQL, T-SQL, PL/SQL, C, Java, JScript, ASP, VBScript, HTML, XML, Unix Shell scripting

RDBMS: Oracle, SQL Server, MySQL, MS Access, DB2/SPUFI, Sybase

Testing Tools: ALM, UFT, SOAPUI Pro, Selenium 2 (WebDriver), IDE, Cucumber

Other Tools: MS Office Suite, Projects, Visio, Corel Suite, Lotus Notes, TOAD, SQL Developer

Sybase Central 6.0, ClearCase, ClearQuest, BMC Remedy, ERD, DOORSRequisitePro, XCelsius, Visual Studio, Eclipse, OBEE 10.1.3 , Business Objects XIR2Crystal Reports, MicroStrategy 9.0, SSRS, Informatica Power Center 8.1, XML Spy 2011SnagIt 8.2, Web Services, ISPF/JCL, PuTTY, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, VA, Herndon

Quality Analyst

Responsibilities:

• Performed gap analysis, analyzed current system capabilities and provided to-be proposals to the business team
• Identified scope, created context and process flow diagrams using MS Visio
• Participated in developing user stories, mockup UI screens, defining acceptance criteria and assigning points in Rally tool during sprint planning and grooming sessions
• Assisted system analyst to create solution specification and sequence diagrams to define functionalities of various processes in the administration system
• Participated in scrum meetings viz., sprint planning, grooming, sprint review and retrospective sessions
• Created Agile Testing Document, test scenarios, test cases, test data, test results and reviewed with team
• Performed smoke, functional, UI, regression, adhoc, interface and integration testing
• Identified, analyzed, and documented defects utilizing ClearQuest and ALM as defect tracking systems.
• Responsible for defect creation, tracking, defect reporting and triage process
• Developed SQL queries for database validations
• Executed ETL jobs using Ab-Initio, Unix and validated the data and log files
• Ran ETL jobs, validated the transformed data in target database and the report content
• Created user tractability matrix (UTM), test results and bug reports and other test related documents.
• Created test cases using Element locators and Selenium WebDriver methods
• Enhanced test cases using Java programming features and TestNG annotations for regression
• Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars and TestNG
• Worked with business team to analyze requirements and build test cases using BDD
• Writing reusable UI functional libraries for automation using OOPS concepts
• Fixed existing test automation suites written for UFT/QTP using VBScript
• Provide daily, weekly and monthly reports

Environment: Windows 10, Agile Methodology, Rally, MS Office 2010, TextPad, Toad, SQL, Oracle, ClearQuest, Unix, Ab-Initio, PuTTY, WinSCP, HP ALM 11.52, SnagIt, SharePoint, Selenium 2 WebDriver, Java, Sprint Tool Suite, Cucumber, Maven, UFT

Confidential, VA, McLean

Quality Analyst

Responsibilities:

• Gathered documented the Functional Requirements and Business Requirements using DOORS employing SDLC Model
• Using MS Visio created GUI screens, use case, state chart, sequence and process flow diagrams
• Prepared Test Scenarios, Test cases and Test Data from the business requirements
• Created test plan, test cases in HPQC, test data and conducted User Acceptance Testing (UAT)
• Performed smoke, functional, end to end, integration and regression testing
• Involved in business rules, role based access and scenario based testing
• Complete funding process testing involving import loans, evaluate rules, create contract, allocate loans, price, certify, record WHL and funding
• Wrote test cases for business rules/edits, scenarios, integration and end to end functional testing
• Prepared test data in Excel files per Business Rules test cases and generated XML files through VBScript
• Used VLookUp and Pivot tables, wrote Excel macros with VBScript as part of data preparation to reduce tedious manual work and generate management reports
• Validated the XML data against the XML Schema
• Manipulated XML files using XMLSpy to validate the edit rules and messages
• Responsible for UAT test environment setup including creating request, coordinating with development and middleware teams to bring the UAT environment up to production level and deploy new code
• Created defects in HPQC, coordinated with teams and retested the fixed defects
• Peer reviewed test cases/results and conducted review meetings with other stakeholders
• Identified the manual test cases to be automated and designing the scenarios based on the test cases
• Enhanced the framework based on project needs
• Developed and maintained reusable functions for functional testing
• Developed automation test scripts in HP QTP /HP UFT for testing scenarios using vb script
• Wrote SQL statements for Back End testing, validated against the GUI data
• Web services testing using SOAP UI for creating Cash contracts
• Performed interface testing with applications including TPM (Terms, Products and Agreements), OIM (Organization Interface Manager) and PMA (Pricing Manager Application)
• Created guidelines for creating test cases, data prep, results document and HPQC standards
• Administered SharePoint Services to UAT including document management, user access controls etc.

Environment: Windows 7, MS Office 2010, SoapUI 3.6.1, TextPad 4.7.3, Command Editor for DB2, Rapid SQL 8.1.1, Remedy, HP ALM 11.52, SnagIt, SharePoint Services

Confidential, VA, Herndon

Business and Quality Analyst

Responsibilities:

• Created business requirements for MISMO rules/edits and mockup screens for mortgage loans form
• Participated in planning and analysis of Test Plan, LOE (Level of Effort - Testing), job aids (user manuals) for UAT
• Wrote test cases for business rules/edits, scenarios, Integration, and End to End Functional testing
• Prepared test data in Excel files per Business Rules test cases and generated XML files through VBScript
• Used VLookUp and Pivot tables, wrote Excel macros with VBScript as part of data preparation to reduce tedious manual work, and generated management reports
• Validated the XML data against the XML Schema
• Manipulated XML files using XMLSpy to validate the edit rules and messages
• Peer reviewed test cases and provided guidance to the team as part of streamlining testing process
• Validated UI data against the Sybase database per the test case scenario
• Performed Interface testing with applications, including Document Certification, Message Manager, CDDS
• Tested Loan Delivery services, including Geocoder, DULLS, Desktop Underwriter data, CDDS
• Completed Web Service testing for FNMA Loan ID Generator using SoapUI Pro
• Performed post Quality Check of test cases executed by peers for correctness and completeness
• Tracked, reviewed, analyzed, documented defects using ClearQuest and coordinated with other teams to resolve and retest the issue
• Coordinated and assisted automation team in the data preparation process as per the guidelines
• Participated in knowledge management sessions, created user manuals, provided training to the testers on standards and testing processes.

Environment: Windows XP, MS Office 2003, Quality Center 10/11, XML Spy 2011, SnagIt, DOORS, SharePoint Services, Unix, Excel macros / VBScript, Clear View, ClearQuest, Sybase Central 6.0, Oracle, Remedy, SOAP UI Pro, Agile Testing

Confidential, Baltimore, MD

Quality Analyst

Responsibilities:

• Interacted with stakeholders including SA, BA, developers and UAT members
• Used Gemini / BMC SDE to receive ticket / requirement and defect tracking
• Used Quality Center 11.0 to executed the test plan, track execution against the plan during testing and manage defects from inception to resolution.
• Versioning of documents using Visual Source Safe
• Wrote and executed SQL queries (T-SQL) to perform backend testing
• Worked on EDI transactions involving HIPAA 4010 and 5010 conversion project
• Involved in testing HIPAA Transactions sets (837I, 837P, 270/271, 276/277, 834, 835, 997 and 999)
• Manipulated EDIT (XML, .dat) files using XMLSpy to validate the EDIT edits and messages
• Verified the ICD 9 and ICD 10 procedure and diagnosis codes in UI and database per the claim extract
• Involved in validating the EDI transaction maps and debugged the errors and corrected per the respective EDI implementations
• Worked on Facets Membership, Billing and Claims Processing modules
• Developed Test Cases for Facets Membership, billing and Claims Processing modules
• Developed SQL queries to extract data from the source tables
• Created defects, coordinated with development, business teams, retest and close the issue after code fix
• Executed automation scripts for regression using QTP and modified scripts for the GUI enhancements
• Assisted test manager in creating test logs and test summary reports using Test Log

Environment: Windows XP, 9000/z/OS, MS Office 2007, Gemini, BMC SDE, Quality Center 10.0/11, QTP 9.2, SQL Server 2005, VSTS 2008, SSIS, SSRS, ASP.NET, T-SQL, XMLSpy, XML, EDI transactions

Confidential

Responsibilities:

• Participated in requirements analysis, release management process and daily technical meetings
• Identified source data, developed documents for mapping and reports
• Created ETL and report test cases in Quality Center and conducted peer reviews
• Executed DDL and DML packages received from database developers and tested the database tables for table structure including data type, size, integrity and other table constraints
• Used Informatica Power Center to deploy ETL jobs, execute sessions and monitor workflows
• Executed the UNIX shell scripts to load the source data into target tables
• On execution of ETL jobs validated target data against source using SQL queries in TOAD
• Compared before and after transformation of data to ensure that transformation was successful
• Tested reports such as report services document and grid reports through Microstrategy Web Home for cosmetic, functional, security and data validations
• Tested Role Based Access Controls (RBAC) functionality for the reports
• Defects were tracked, reviewed, analyzed and compared using Quality Center
• Generated RTM by cross referencing test cases against the requirements and design specifications
• Involved in Integration, System, Database and Regression testing

Environment: Windows XP, Office 2007, TOAD, SQL Developer, SQL, Informatica Power Center 8.1, Microstrategy 9, Oracle, Quality Center 9.0/10, UNIX, VB Script

Confidential, Baltimore, MD

Systems Analyst

Responsibilities:

• Involved in requirements analysis and discussions
• Preformed manual testing of both data warehouse and web based applications in an agile environment
• Created new and modified existing test scripts for both ETL and BOXI reports
• Involved in database design and migration testing for Case Notes application
• Wrote JScripts for form validations of Case Notes application and fixed the defects in ASP.Net environment
• Wrote SQL queries to perform data validation of target data against the source database
• Requirement Traceability Matrix (RTM) to reference test cases and defects against requirements
• Executed JILS and monitored through Autosys
• Performed functional testing including data validation, audit trail, reports, email integration and security
• Performed whitebox and blackbox testing of XML against XSD
• Created test suites and test cases using SOAPUI to test web services
• Performed scenario based functional testing of Case Notes, a web based application
• Executed the test scripts, logged defects into BMC Remedy and resolve issues with development team
• Interacted with the Business users and helped in documentation for UAT
• Used ISPF to submit jobs and view log files for success and failure information
• Validated data with SQL queries against DB2 using SPUFI
• Provided support to end-users within the agency regarding CaseNotes functionality
• Created Object Repository and scripts using Descriptive programming.
• Used vbscript functions like Formatting String, Array, Conditional constructs and Regular expressions.
• Created the necessary test data to execute the automated scripts as external data sheets and imported the data sheets into the test scripts.
• Used Parameterization and managed share object repository to test the application using QTP.

Environment: Win XP, IBM System/360, SQL, BOXIR2 (WebI, InfoView), Informatica, JScript, VB.Net, ASP.Net, Visual Studio 2005, Oracle, SQL Server 2005, XML, SOAP UI Pro, TOAD, Quality Center 9.0, BMC Remedy, Autosys, ISPF/JCL, DB2/SPUFI, QTP 9.0

Confidential, McLean, VA

Quality Analyst

Responsibilities:

• Worked Closely with Business users, reviewed business requirements and documenting specifications
• Created test cases, test data for both functional and non-functional requirements in QC and mapped against the requirements
• Created and executed SQL queries using Oracle SQL Developer to validate report data against DB.
• Objects test including prompts, charts, reports, dashboards and data source connections by creating adhoc reports using OBI Answers
• Validation of Linux logs to troubleshoot OBIEE scheduler
• Ran workflows / ETL jobs in Informatica followed by validation of data before and after the job is executed
• Executed the JILS using Autosys console Exceed
• Created and tracked defects using Rational ClearQuest
• Assisted the manager in creating Test Plan which specifies testing overview, testing approach, testing strategy, roles and responsibilities and scope of testing

Environment: Win XP, Oracle 10g, Hyperion Essbase, Oracle Business Intelligence 10.3, Oracle SQL Developer, Informatica Power Center 8.6.0, ClearCase, Clear Quest, Autosys console Exceed, Linux, XML

Confidential, Houston, TX

Systems Analyst

Responsibilities:

• Interacted with business users to gather requirements and develop technical specifications
• Created and maintained the test logs, test reports, test issues, defect tracking using Quality Center
• Developed, enhanced and maintained automated testing scripts with Quick Test Pro
• Created reusable library of functions using VB Script
• Performed functional, integration, system and regression testing of HRIT application
• Wrote complex SQL queries to extract and validate the data
• Worked with keyword driven and modular driven test automation frameworks in QTP
• Parameterized data for Data driven testing to implement Retesting using multiple sets of data.
• Conducted Regression Testing on every new build after the Bug fixes with the help of QTP
• Performed manual testing of Crystal Reports using for functionality, formatting, data, security etc.
• Extensively used SQL Queries to validate the Database; reports data against the production data
• Performed functional testing of web application including forms, database, links/navigation etc.
• Performed the Black Box testing for functional flow of application reports including Contingent/Employee Worker Details/Summary, job function analysis, promotions etc.

Environment: Windows XP, HP-Unix, Crystal Reports 10/XI, Oracle 10g, Teradata RDBMS V2R6, SQL Assistant 7.1, TOAD 9.72, XCelsius 2008, MS-Office 2003, Quality Center 9.0, QTP, MS Sharepoint Services 2007, ASP, .Net, Visual Studio

Confidential, NY

Business and Quality Analyst

Responsibilities:

• Involved in user interviews, analyzed and document requirements
• Designed Use Cases, Use Case diagrams, Sequence diagrams in UML methodology using MS Visio
• Designed GUI screens using Dreamweaver and developed JScript for FORM validations
• Developed and executing the automation test scripts using QTP and QC
• Customized Object Repository using Descriptive objects and scripts using Descriptive programming.
• Extensively used VB Scripts for creating File system objects to use external objects like excel objects.
• Wrote VBScript functions using Formatting String, Array, Conditional constructs and Regular expressions.
• Developed reusable functions using VBScript for Database, Utility, Web Tables, FSO, etc.
• Extensively used Data Table methods for changing the run time data table objects.
• Used Parameterization for using various data to test the application using QTP
• Created Test sets/Suites in Quality Center and wrote test cases for automation
• Wrote SQL Queries to validate date in DB2 Database
• Worked on debugging, modifying and enhancing the automation scripts for better performance
• Assisted the QA team, by testing web applications using Quality Center
• Liaised and Coordinated in resolving EDI mapping issues arising from the third-party systems
• Customized an off the shelf supplemental Billing software that generated HIPAA compliant claims
• Design specifications and Test Case usages for the HIPAA 837, 270 and 276

Environment: Windows XP/2000, DB2, Rational Suite (Rose, Requisite Pro), Dreamweaver, XML, XSD, MS-Project, MS Visio, QualityCenter 8.2, TestDirector 7.6, Java, QTP 8.2, VB Script