SUMMARY:

• Over 17 years of experience in IT as a QA Engineer, Report Developer and System Analyst working with different type of Databases, Client Server and Web based applications including expertise in business process engineering and software development life cycle which include gathering technical requirements, Design, Build and Maintain complex Test Automation Frameworks, performing manual and automated UI / Database tests with the following cross functional expertise, skills & experience:
• Strong knowledge and work experience related to utilizing Web Automation tools such as Selenium IDE, Selenium WebDriver and Selenium Server (RC) Using Java OOP language,
• JUnit /TestNG frameworks, Firebug, JDBC , QA tools such as JIRA , Microsoft tools such as SQL Server 2008 R2 and SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio ( 2008, 2012 ), Oracle 11g (MySQL, SQL Developer and Toad ), Eclipse SDK, Subversion Source Code Control, Embarcadero (data modeling / metadata management tool ), PowerPoint, MS office products ( Word, Excel, Access, Outlook ) , Visio
• Involved in all phases of SDLC and QA Life cycle in Agile project environment with timely delivery against aggressive deadlines
• Strong knowledge of Relational Database Architectures
• Expert in writing SQL statements and complex nested queries and sub queries
• Great knowledge of Data Warehousing concepts including dimensional modeling, star and snowflake schemas
• Great knowledge of Business Process and Workflow Automation Modeling to automate the business work flow
• Proven ability to create, execute and maintain comprehensive test plan , Data Driven Framework and reusable test cases
• Strong knowledge of workflow logic and advanced mathematics with complex formula
• Creativity and initiative for improving product coverage and effectiveness
• Utilize current industry standards with strict adherence to HIPAA regulations
• Strong organizational skills, with the ability to track multiple test executions simultaneously and synthesize the results
• Excellent communication, analytical, problem solving and interpersonal skills
• Ability to work effectively while working as a team member as well as individually
• Ability to follow instructions and make decisions with no supervision if it is needed
• Diplomatically resolved a wide variety of complaints
• Shift work load and responsibilities where needed to meet objectives

EMPLOYMENT EXPERIENCE:

QA/System analyst trainer

Confidential

Responsibilities:

• Provide web browser automation training (for windows Web application) using Selenium and
• C#/Java OOP languages, covering the following subjects:
• How to analyze a web application s functionality and develop high level test plan & test cases
• How to create a Data Driven Framework by creating a DB, tables, Stored
• Procedures and functions with T - SQL
• How to develop and maintain libraries of reusable testing data and test cases How to install and implement the Selenium IDE and Selenium WebDriver How to add Firebug web development tool to Firefox web browser and how to use it to analyze a web page HTML codes and inspect a web page elements such as title, text boxinput box, check box, drop down list, radio button, text link, calendar and AJAX elements How to use the element ID, name, class, link text, tag name, CSS path and Xpath to pass data into input fields or get text from the web pages How to change the format of the Selenium IDE test case into C# /JUnit /WebDriver or
• Java /JUnit/ WebDriver and how to customize the codes for advance automation

QA/System Analyst

Confidential, Shrewsbury, MA

Responsibilities:

• Performed data analysis and developed the ad hoc queries and reports by utilizing the SSRS reporting tools in support of the clients and upper management needs
• Performed quality control analysis on the Medicaid School-Based Claiming (MSB) system
• Develped the “System Test Plan Template” to standardize the strategies to be used to verify new system meets its design specification and requirement
• Developed the test plan and test cases and executed the test cases to verify the correct functionality of the school PeopleSoft application which is customized for the school uses
• Participated on the bug meetings and interfacing with developers to resolve the issues
• Provided technical assistance for the BSA team for the system performance verification

QA Engineer/System Analyst

Confidential, Worcester, MA

Responsibilities:

• Participated on the development of Benefit Eligibility & Enrollment System (BEES) for
• Prescription Advantage program and development of the Clinical Pharmacy Services ( Confidential ) application for the Commonwealth medicine related to the Confidential Drug Prior Authorization process and its reporting system by:
• Interviewed the business representatives to define the business rules and developed the technical requirements for the customer sign-off Developed wide-ranging of use cases to support the solution development and validated them with the subject matter experts Designed the business workflow processes to in corporate the most effective ways of completing business tasks
• Created “Visio” screen mockups to use in the prototype review sessions Developed Test Strategy, Test Plan and Test cases documents for the system QA purposes
• Performed and coordinated QA activities such as estimation, test planning, test design, preparation of traceability matrix, test execution, test results analysis and bug reporting
• Performed data migration testing from the legacy databases (Oracle DB) to SQL Server DB (OLTP and CDC tables) by writing complex T-SQL queries, sub queries and nested queries
• Stored Procedures and Functions for the BEES and Confidential projects
• Performed in depth report files Analysis by creating complex queries and writing cursors
• Planed, Designed, Developed, Executed and Maintained complex test scripts and Test Automation Data Framework for BEES and Confidential UI testing by writing codes in Java ( using Selenium )
• Performed Data validation, unit testing and bug analysis
• Created and maintained the libraries of the reusable testing data sets and over 500 test cases
• Extracted / Loaded data from different data file formats such as PDF and Excel into SQL server for Data Analysis purposes
• Perform all aspects of testing including UI testing, functional testing, regression testing, load testing, system testing and UAT testing by performing manual testing and using Selenium test automation tool
• Analyzed and tested the automated workflow process for the Confidential claims processing
• Assisted in implementing and maintaining a continuous integration solutions
• Assisted the BEES reporting team to write RDM views to develop the report system from OLAP and OLTP tables and performed the reports unit testing
• Extracted data from “Members benefit and eligibility” and “CMS” files to the BEES Database for the QA and data analysis purposes
• Reported bugs/issues and performed regression tests to make sure the system meets its requirement
• Organized bug meetings with developers to resolve the issues
• Provided User Support and training and Involved in User Acceptance Testing (UAT)
• Performed data analysis and developed the ad hoc queries and required reports in support of the clients and management needs
• Instructed QA team members related to test automation techniques and methods
• Provided any type of technical assistant as needed
• Maintain excellent knowledge base of industry trends and developments

Application specialist

Confidential, Worcester, MA

Responsibilities:

• Performed data analysis and providing ad hoc queries in support of the PAII reporting team, clients and management needs, created annual and quarterly reports for the Confidential, extracted and Loaded MA weekly claims & TX monthly claims files into the “Medicare Part D” DB, exported MA new patients into Confidential system, loaded MA facilities exclusions data into the DB (bi weekly), loaded TX patient monthly file into the “Medicare Part D” DB, loaded Data Rejects to “Medicare Part D” DB and created data reject files for the clients, created monthly facility exclusions reports for the users.

Refugee Case Manager

Confidential, Worcester, MA

Responsibilities:

• Designed Client database to generate the client’s intake forms and provide monthly and annually narrative reports.
• Provided and coordinated wide range of social services for refugees and immigrants to live as independent as possible and to integrate into the community.
• Coordinated essential housing, finances and psychosocial supports.