SUMMARY

• IT professional with 12 +years as QA Analyst, Lead, Business Analysis and development experience. 6 years planning and managing multimillion dollar projects that align business goals with technology solutions to drive process improvements. Expert in agile and waterfall project management methodologies, successfully managing large QA project teams and delivering high quality products that meet timeline and budget targets.
• Hands on Experience in being responsible for all phases of the software development lifecycle (SDLC): conception, requirements definition, Data Analysis, functional specification, software design, implementation, test and documentation. Experience working with a cross - functional team, comprised of software engineers, implementation engineers, product managers, QA engineers, Offshore team, and network operations specialists to develop innovative software solutions that meet our customer requirements.

TECHNICAL SKILLS

OS/Automation: Linux, Windows, Selenium, Cucumber, Eclipse,Github,Jenkins,Maven

ETL / Reporting Tools: Informatica, Abinitio / Microstrategy, Tableau, Business Objects

ERP: PeopleSoft (HRMS, Financial, CRM (POS Retail System)) Workday HRMS and Payroll (Functional Testing)

Defect Tracker/ Test Management Tools: Clear Quest, HP ALM, Test Director, Lotus Notes, MS Excel, Quality Center, Jira, Oracle Test Management Tool, ServiceNow, Power point, Visio

Languages: Java, SQL

Databases: DB2, Oracle, SQL Server, MS Access, Teradata

GUI: VB, Developer 2000, PeopleSoft, JAVA, Workday

Testing Methodologies: Agile, Waterfall, Project Management

Web Technologies: JavaScript, HTML, XML, WebLogic, J2EE

Web Servers: Java Web Server, IIS, and webservervices, SoapUI, Rest (Web services)

Big data technologies: HDFS, Hive, Impala

Middle interface: Sqoop

PROFESSIONAL EXPERIENCE

Lead/Sr QA Engineer/Business Analyst

Responsibilities:

• Working as a Lead SME/QA for multiple projects like Web Applications, DWH, Reporting, and Big Data and Workforce (HRMS) Management applications.
• Worked with Product Owners to analyze project roadmaps which align to business objectives (BRD) and sequenced them by priority and resource availability.
• Created stories, backlogs, estimated hours based on requirements to collaborative with business users, developers and QA in JIRA
• Participated in the (RMLC) required Management Life Cycle throughout the Software development lifecycle of the main features from initial requirements through customer acceptance
• Provided project estimates and performing resource allocation.
• Mentor, Cross train, coordinate and oversee efforts of all QA participants, identifying potential issues and working with parties as necessary to resolve them.
• Handled Requests, Incidents and Change Orders in Service Now.
• Responsible for updating and managing projects such as RTM, test Artifacts, daily statuses, issues, risks and change control in Jira, share point, ALM,and Oracle Test Management
• Identifying issues through Root Cause Analysis to find discrepancy between requirements and data
• Maintained Root Cause Analysis template for each project (Scope, Data,timlines,Budget,training, Environment etc.)
• Created ad-hoc reports & SQL scripts for data analysis in Micro strategy as per Business requirement and involved in UAT with business.
• Walkthrough of Test Strategy, Test Plan, and Test results to Business users for acceptance criteria and participated in end to end testing.
• Ability to produce test results to assist Business team in making Go - No Go decisions.
• Involved in defining and implementing scalable testing environments and work closely with developers /Business Users to ensure quality of services are defect free
• Involved in the test data preparation to ensure the test coverage. Including prod data scrubbing and test data manipulation using hive
• Data load and unload from db2 and Oracle databases to Hadoop cluster using Sqoop scripts.
• Used web services (Soap UI and Rest) for data processing to verify data through XML with upstream and down stream
• Extensively used XML and XPath in Workday application (HRMS)
• Strong Experience in Automating Web Application Testing using Selenium WebDriver with TestNG and Cucumber framework.
• Well versed with Handling Elements in Selenium WebDriver.
• Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.
• Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, TestNG and selenium Grid.
• Experience on Maven & Continuous Integration tools like Jenkins.

Principal QA Engineer

Confidential, Bloomington, IL

Responsibilities:

• Mentored and led for several DWH projects and involved in Requirement Management Life Cycle (RMLC)
• Gathered specifications and Business requirements (BRD’s) from SMEs (BA) and development personnel prior to application testing
• Analyzed the test results and disseminate them to the respective project team members.
• Participated and reviewed test strategies, test plans, test cases, test summary report and Requirement Traceability Matrix(RTM) with Business Users
• Involved in Onsite and offshore co-ordination.
• Performed back end-testing for specific ETL scenarios (SQL Queries) & Business Objects reports based on user/functional requirements
• Created test cases for functional, integration, and system testing to validate data in FORMAL (testing) environment.
• Extremely efficient in Data Validation Testing (Informatica Mappings, Sessions & Workflows)
• Involved in UAT, Implementation & Risk Based Testing
• Involved in Defect Triage meetings
• Used Ralley for Agile project management
• Used ALM for Test Management and Quality center & Clear Quest for defect tracking
• Created production readiness package.
• Verified source and target paths, SQL Scripts, UNIX shell scripts, DB2 logs, Unix logs, Unix files and session logs before going to production.
• Helped with Development team to resolve Production issues.

Sr. QA Engineer

Confidential, Charlotte -NC

Responsibilities:

• Created RTM (trace bility matrix) between requirements and test cases.
• Developed Test Strategy, Test plan, Test Cases and Test Scripts for System and UAT Testing.
• Involved in analyzing the requirements and understanding production volumes of Claims Processing.
• Check the transformation of data in ETL process from ODS to EDW.
• Performed the data driven test by pumping different sets of data.
• Validated Hospital and Medical claims processing.
• Validated the reports and files according to HIPPA standards.
• Querying data base by writing SQL queries using Toad.
• Tested the trade file extracts and request/Response authorizations.
• Tested various operations in the claims processing (Adjustments, Claims, and Overpayments, underpayments, COBRA and External Claim editing).
• Tested Medical and Hospital UM Authorizations (Services and Confinement).
• Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing.
• Tested the Members, Providers, Facets Workflow and Claims in Facets.
• Tested the claims and validated the claims on mainframes files in UNIX.
• Developed Test Summary Reports and participated in GO / NO-GO meetings.
• Tracked defects using Clear Quest & Conducted Bug-Review meetings.
• Coordinated with Business, Project Managers and Developers

Functional QA

Confidential, CA

Responsibilities:

• System analysis, planning, design and implementation.
• As a functional and testing consultant, involved in meetings to gather information for business requirements to write the technical specifications, develop design documents and help them in testing the data.
• Wrote detailed function of system Testing Plans based on the business requirements
• Developed testing methodology for the functional integration of application manually
• Played key role in Developing of Data conversions, online customizations and conversions using SQR’s, People Code, Component Interfaces and Application Engine for Leads, Opportunities, Call Center and Order Capture
• Manually tested approach to leveraged PeopleSoft delivered CRM 8.8 with customization PeopleSoft Records and pages according the needs and specifications
• Involved in data mapping and customization of creating views, adding fields, creating search records, and creating new record definition etc., worked with People Tools and People Code
• Used PVCS for version controlling