Anitha Pothina

Email Id: ad3n3m@r.postjobfree.com

PH: 517-***-****

Summary:

Eight plus years of experience in Quality Assurance including functional, regression, integration of web and client server-based Applications. I had good knowledge of SDLC processes and very proficient in automating manual test processes. Self-motivated, professional, team player having strong analytical and problem-solving skills. Work experience in a large enterprise application integration projects as QA Analyst.

Experience in financial, and health care industries. Worked on client server, web based and online transaction systems.

I have good Experience on Agile Methodology.

I have good Experience on ETL Testing like Writing SQL Queries and executing SQL Queries and Data Migration.

I have experience on Data validation between Source and Target.

Extensive experience as a quality assurance engineer in preparing test plans, test scripts and test cases for both manual and automated testing including regression testing, black box testing, functionality testing, System Testing and UAT testing.

Extensive experience in using Testing Tools like Quality Center, Win Runner, Test Director, Load Runner, Clear Quest, Quickest, RQM, CTD,RFT,API, Selenium.

Worked effectively with the external vendors and project team members to configure equipment and to meet all testing specifications.

Experience in writing PL/SQL and SQL statements and Backend Testing and ETL Testing.

Expertise in Problem Solving and Tracking Bug Reports using Bug Tracking Tools.

Responsibly handled tasks such as project assessment, planning and sizing, technical writing, test case creation and execution.

Technical Skills:

Languages : SQL, PL/SQL, Java, Python

Web Technologies : JavaScript, HTML, DHTML, CSS, XML, XSL

Web/Application Servers : Internet Information Server 5.0/4.0/3.0, Apache Web Server

Database Systems : Oracle 8i, 9i, 10g, 11g, SQL Server 2000/7.0/6.5, MS Access, DB2

Testing Tools : Quality Center, Clear Quest, QTP and Rational Tools.

Operating Systems : Windows, UNIX, Linux, MS-DOS

Version Management Tools : Visual Source Safe, Rational Clear Case

Other Tools : Microsoft Office, Outlook, Visio, Toad, Informatica

Methodologies : SDLC, Agile, Waterfall

Professional Experience:

Department of Children and Families (State of Florida), Lansing, MI Dec15 to Till date

FSFN is used to track community concerns and interventions involving Florida’s children and vulnerable adults. FSFN is used to track intakes, investigations, out of home placements, services, pre-adoption services, post-adoption services, legal documentation, education document, Child Placement Agreement medical and mental health documentation and is also used for federal reporting purposes.

Responsibilities:

My Role is to serve as a Test Specialist for Department of Children and Families testing Project.

Participated In team meetings to gather and review business requirements for better understanding of the Business needs.

I am writing the SQL scripts using business requirements.

I am working on ETL Testing like Writing SQL Queries and Comparing front end Data and Back End Data like Data Hammer.

I created reports using SAP BOE tool.

Executed test scripts using RQM.

Participated in status meetings to provide the work status for better tracking of project deliverables.

Validated application data from SQL Server.

Preparing Test Scripts, Reviewing QC templates, Identifying required test data, designing documents from different groups, Identifying changes from design documents and change requests.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts and Stored Procedures in Sybase Database Servers.

Configured the Data mapping between Oracle and SQL Server 2008.

Facilitated user acceptance testing and test strategies with Information Systems Group.

Performed manual front-end testing to check all functionalities of different modules.

Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests).

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).

Office Depot Loyalty Integration project, Lansing, MI Nov 14 to Nov 2015

As Part of Office Depot integration efforts, consolidating loyalty programs like Office Depot Max Perks and Office depot Rewards into one loyalty program called as Office Depot Rewards program (ODR), which will be delivered across all channels to all customers. ODR includes, conversion of existing MaxPerks Memberships, Program Enrollments, Member Card Acceptance, Purchase Transmission, Reward Accrual, Issuance and Fulfillment, Reward Certificate Redemption, Weekly Accommodations, Member Program,-Customer Dashboard, User Interfaces with Max Perks and ODR, Customer Services, Accounting and Finance, Associate Perks Card, Instant Recycling, Member Only Pricing In store only, Decommission InteQ and Precision dialogue, Prospect Database Model and Reporting

Responsibilities:

My Role is to serve as a Tester for Office Depot Loyalty testing Project.

Participated In team meetings to gather and review business requirements for better understanding of the Business needs.

I am writing the SQL scripts using business requirements.

I am writing Stored Procedure and Views and Triggers.

I am working on ETL Testing like Writing SQL Queries and Comparing front end Data and Back End Data like Data Migration.

Executed test scripts using HP Quality Center.

Participated in status meetings to provide the work status for better tracking of project deliverables.

Validated application data from Teradata Database.

Preparing Test Scripts, Reviewing QC templates, identifying required test data, designing documents from different groups, identifying changes from design documents and change requests.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts and Stored Procedures in Sybase Database Servers.

Configured the Data mapping between Oracle and SQL Server 2008.

Facilitated user acceptance testing and test strategies with Information Systems Group.

Performed manual front-end testing to check all functionalities of different modules.

Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests).

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Unified Case Management, Lansing, MI Sep13 to Oct 14

Create Unified Case Manager system to unite the current existing systems into one easy to use system. The new system will meet the requirements of all currently existing systems such that it can fill the needs of each of them. Unified Case Management (UCM) system as well as the associated operational services to support the workload of the Centers for Medicare & Medicaid Services (CMS) Center for Program Integrity (CPI) contractors across the Medicare and Medicaid programs. UCM system aligns with the organizational goal to support cooperation and communication between regional PI contractors to ensure a standardized national approach to how lead management, investigations, administrative actions, and workload reporting will be managed within UCM.

Responsibilities:

Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest.

Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on MS Access.

Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.

Captured Data flow diagrams and formatting of the data flowing through interfaces.

Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.

Configured the Data mapping between Oracle and SQL Server 2005.

Facilitated user acceptance testing and test strategies with Information Systems Group.

Performed manual front-end testing to check all functionalities of different modules.

Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Delta Dental of Michigan, Okemos, MI Dec 10 to Aug 13

Delta Federal Services (DFS) and Delta Dental of Michigan (DDMI) are working together to deploy the new DDMI Claims Processing System, referred to as the Enterprise Technology Solution (ETS).

DIME referred to Delta Federal Services Implementation of Michigan Enterprise Technology Solution, Includes combined implementation of ETS and Individual Enrollment and Billing System (IEBS). The system functionally implementation will replace the current Mainframe IDMS claims processing system, LAWSON, OPTARE, DIACAP recertification of the DDMI and DFS systems and networks.

Responsibilities:

Involved in reviewing the business requirements with business users and development team to understand the architecture and functionality of the application.

Extensionally used Agile Methodology throughout the Project Life Cycle

Responsible for designing, developing and executing Test Cases and Test Procedures based on the requirements.

Used Validation Plan Tool for both manual and automated test scripts and used Mingle as a defect tracking tool.

Created criteria for data conditioning needed for backend testing.

Executed backend data-driven test efforts with a focus on data transformations between various systems and a data warehouse.

Involved in performing adhoc, system (functional), regression testing and validation of data integrity.

Involved in end to end testing of all phases of ETL (Extract, Transform and Load) like validating the data after extracting it from different sources and also when it is loaded into the target after data transformation.

Performed Back end testing after successful ETL processes by writing SQL statements like Join, Inner Joins, and Outer joins.

Worked closely with development and BA team in resolving defects; re-tested after bug fixes.

Provided the Test Result matrix for the Project Management team and participated in walkthroughs and defect report meetings periodically.

Environment: Windows, Solaris, .NET Framework (2.0), Oracle 9i, DB2, TOAD MS-Visio, Informatica 7.0/7.1, QTP, Quality Center, WebSphere and MS Office products

Automatic Data Processing (ADP) Aug 08 to Oct 10

Quality assured Benefit Administration Service Engine (BASE) for ADP (the world's leading provider of computerized transaction processing, data communications and information-based business solutions), a $7.5 billion dollar company. BASE is the single benefits processing application utilized by ADP to provide core health and welfare benefit outsourcing services to its clients.

Responsibilities:

Conducted walkthroughs with stakeholders to design complete and detailed test plans & test cases.

Coordinated with the QA Manager, business analysts and developers on requirement issues. Participated in project meetings, QA status meetings and release meetings.

Analyzed the system requirements and developed detailed test plan, test cases and test scripts.

Involved in decision making of converting manual test cases into automated test scripts and analyzed their life time and time required to update the scripts.

Actively participated in system testing, integration testing and coordinated UAT.

Reviewed ETL flow diagrams and technical documentation for clear understating of data flow.

Created test data based on the test cases for each and every mapping and ensured that the data is fit to test all the test scenarios.

Used SQL for data integration verification by performing database connectivity through TOAD.

Involved in importing source/target tables from the respective databases and tested Transformations, Mapplets and Mappings using Designer module of Informatica.

Reported defects and configured email notifications to the developers using Quality Center

Extensively interacted with various team members including developers to resolve the issues.

Environment: QTP, Quality Center, J2EE, Java, JSP, WebSphere Application Studio/Application Server 5.1.1, SQL, DB2, VB Script, Java Script, Microsoft Visual SourceSafe, Windows, UNIX, Oracle, Microsoft Office tools

Synergy HR Management Nov 06 to July 08

HR Management enhances traditional applicant tracking systems that include Requisition creation, Processing and Posting, Resume searching, Sorting and Filing, Applicant workflow, Interview scheduling and tracking, Candidate communications and Reporting. It provides organizations everything they need to locate and track candidates as they move through the hiring process

Responsibilities:

Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest.

Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on MS Access.

Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.

Captured Data flow diagrams and formatting of the data flowing through interfaces.

Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts and Stored Procedures in Sybase Database Servers.

Configured the Data mapping between Oracle and SQL Server 2005.

Facilitated user acceptance testing and test strategies with Information Systems Group.

Performed manual front-end testing to check all functionalities of different modules.

Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Environment: JSP, Oracle, MS Access, HTML, XML, DOORS, Clear Case, Clear Quest, XSL, Rational Rose, MS Visio, vb.net, RUP, UML, MS Project, SQL, MS Excel and MS Word

Contact this candidate