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
• Procedures and functions with T - SQL
• 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 Confidential team for the system performance verification

QA Engineer/System Analyst

Confidential, Worcester, MA

Responsibilities:

• 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 queriesStored Procedures and Functions for the BEES and CPS 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 CPS 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 CPS 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 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.

Loan Officer

Confidential, Worcester, MA

Responsibilities:

• Collected information from the customer to Complete 1003 forms, checked the customer credit through the loan processor, found the right bank with the best loan program to satisfy the customer, provided required documents and submitted to the bank underwriter for closing the loan
• Deal with customers' transactions, open checking and saving account and provided customer services.

Pharmacy Technician

Confidential, Millbury, MA

Responsibilities:

• Provided the medicine based on the patient’s prescription and hand it to customer.

Report Developer /System analyst

Confidential

Responsibilities:

• Designed and developed the electronic invoice processing application for the finance dep.
• Designed and developed an inventory application for different projects based on their energy Type (Gas, hydro, wind) to keep track of the portfolio of their equipment and tools
• Audited the financial invoices/payments related to general contractors and subcontractors
• Provided yearly financial analysis for the projects related to their budget proposal purposes
• Trained and supervised over fifteen report developers and Quality Control financial Analyst to provide weekly/monthly development reports for upper management related to the project’s progress based on the projects’ cost and their related contracts improvement timelines.