PROFESSIONAL SUMMARY:

• Over 9 years of experience in Software Analysis and Testing, focusing on Software Quality Assurance (SQA) of Web based applications, Client/Server, Data Warehouse and ERP applications using Manual and Automated testing procedures.
• Worked as a Test lead and managed 6 QA resources on the on - shore offshore model.
• Worked in an IT environment for various domains including Financial, Banking, and Insurance, Supply Chain.
• Excellent understanding of Software Development Life Cycle and Methodology (Waterfall, Spiral, V-Model, Agile Methodology).
• Hand on experience in reviewing of functional Requirements, Technical Specifications.
• Hand on experience in developing Strategic Test Plans, Test Approach, Requirement Tractability Matrix, Test data set, Defect tracking and reporting documents.
• Experienced in Testing Methodologies, Designing Test Scenarios, Test Cases.
• Good understanding of entire Data Warehouse Architecture, ETL testing Workflow process, data models such as Star Flake, Snow Flake Schema and Data Marts.
• Extensive experience in analyzing Data Model, Source to Target mapping, ETL Design document, Business Requirement, Functional and Technical Specifications.
• Hand on experience in testing Reports, Dashboards, Filters, Selections and Prompts.
• Good understanding of Data Modeling in Star Schema/Snowflake schema design, Fact and Dimensions tables,
• Strong experience in writing complex SQL Queries for different Databases such as DB2, Oracle, Sybase and SQL server.
• Debugged failed SSIS package after verifying server and flat file availability and SQL connectivity
• Experience working in agile environment, analyzed and reviewed Product backlogs, Task boards, User Stories for different Sprints in Microsoft Test Manager (MTM).
• Well experienced in using ALM, Quality Center for Requirement, Test management, Defect management, Release and Cycle management.
• Hand on experience in preparation of Test Data for positive, negative and boundary testing scenarios.
• Excellent communication, documentation and problem solving skills with a strong technical background.
• Quick learner, proven ability to work excellently and efficiently in both independent and team work environments.
• Built a dynamic relationship with the client, development and other teams to insure the highest quality deliverable possible and to deliver them on time.

TECHNICAL SKILLS:

Language: VB.NET | VBScript | ASP | JAVA | .NET Framework | .Net | Visual Basic | SQL

Software: JIRA | Confluence | Microsoft Office 2003/2007/2010 | MS Project |

Data Warehousing: DataStage 9.1/8.1 | ODI 11.1.1/10.0 | Informatica Power Center| Neteeza | Aginity Workbench| IBM UDMH Viewer | Master Data Management (MDM) | IBM Initiate Master Data Engine | Workbench, Initiate Inspector

Reporting: OBIEE | BI Publisher | EPM 11 | SAP BO | COGNOS

Tools: ALM | Quality Center | Business Object | Hyperion | JIRA| Zephyr |Subversion |Microsoft Test Manager (MTM) | TFS | MS Visual Studio | HP UFT (QTP) | TOAD |Oracle SQL Developer | Db Visualizer

Database s: Oracle | MS Access | DBMS | DB2 | Informix | SQL Server

Methodologies: Waterfall | V model |Agile |Validation and Verification

EXPERTISE AREA:

• Team Management
• Requirement Management
• Client Relationships
• Staffing & Training Problem Solving
• QA Process Improvement
• Test Planning
• Test Execution Report Management
• Cordination

PROFESSIONAL EXPERIENCE:

Confidential, Leawood, KS

QA Analyst

Responsibilities:

• Worked in a challenging, fast-paced environment which utilized Spotify Agile.
• Reviewed the Whiteboard, backlogs, change requests and develop the test scenarios and test cases.
• Conducted process improvements in the area of testing deliverables and quality improvements.
• Worked as a liason between QA team and and Data team. Identified the test data requirements to perform positive and negative testing.
• Escalated churning discovered during test execution to Management. Provided solution as well.
• Performed Functionality testing with various iPhone and Android mobile handsets to ensure that functionality works fine.
• Tested applications that run on a range of mobile handsets and tablets including iOS, Android, Windows Mobile devices.
• Managed and communicated defects using JIRA.

Environment: ALM 12.1, JIRA 6.3.7, MS Office 2013, Confluence, Lync. Confidential proprietary API Testing program, agile, Coded UI, Mobile Testing, SQL, Oracle and Windows.

Confidential, Kansas

Sr. QA Analyst

Responsibilities:

• Composed two versions of User Acceptance Test (UAT) Test Scripts: the first set was formatted for upload into HP ALM, the second version was for the Wholesalers to use while testing the software.
• Conducted Smoke Test on new Kony build prior to releasing to UAT test users, reported and managed defects in HP ALM.
• Performed a Gap Analysis, reporting any discrepancies to the BA and Developer.
• Managed defects in HP ALM, held conference calls with Business on test progression. Conducted regression testing and updated defects in HP ALM until completion.
• Performed daily query on Mainframe to validate job runs for ODS project.
• Assisted another team in the AWD project. Validated flat files, logged defects in HP ALM, conducted regression test and signed off on testing for Project Manager.
• Participated in meetings with Project Manager, Business Analyst, Data Analyst, ETL Developer and Mainframe Data Analyst analyzed data from ODS program from COBOL data files from the mainframe using complex SQL queries.

Environment: ALM 12.1, JIRA 6.3.7, TOAD, Microsoft SQL Server 2013, SQL Server Management Studio, MS office 2013, Share Point, Subversion

Confidential, Denver, Colorado

QA Test Lead

Responsibilities:

• Conducted requirements analysis, drafted User Stories to assist BA
• Led Test Team in gap analysis for given requirements, Mocked up reports and dashboards for review by the business users
• Analyzed the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test overage accordingly
• Participated in Project meetings with EVCH Principles and Sogeti Management Team in project overview, progress, and Budget.
• Performed Confidential planning utilizing MS Project.
• Participated in Team Lead Meetings for all Teams, provided questions and insight from QA Test perspective.
• Responsible for Test Management in JIRA, providing Test Team with Test Strategy, Test Execution Schedule, reviewing and authorizing test cases.
• Guided the development of the test cases to validate the ETL process, business rules, Data transformation rules, Reports layouts and data.
• Responsible for developing and executing test cases to validate the Tables/View structure, Data conversion, Data Mapping between source to staging, Staging to MDM, and MDM to EDW and EDW to Data Mart.
• Directed the Test Team in writing and executing the test cases to validate the Transformation rules, Records counts, Logical and physical deletes, exceptions and errors for different stages of ETL.
• Utilized JIRA for time estimation, logging time to tasks, Confidential management.
• Assisted Project Manager in training Team Leads on time reporting in JIRA.

Environment: ALM 12.1, JIRA 6.3.7, IBM MDM, WebSphere, IBM Initiate MDM Engine, IBM Initiate Inspector, IBM initiate work bench Oracle 11i, OBIEE 10.1.3, EPM 11, DataStage, TOAD, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion

Confidential, Overland Park, Kansas

Sr. Quality Assurance Lead

Responsibilities:

• Review and analyze the Requirements documents, Design documents, Data design/flow, Data mapping documents and user test cases.
• Participate in requirements, Design and functional specification review meetings.
• Develop and maintain Functional, Integration, Security and UAT Test plans.
• Developed and maintained Positive, Negative and Boundary condition Test Scenarios, Test cases and Test data for Functional, Integration and Security Testing.
• Developed and maintained Traceability between requirements and test cases to ensure that testability requirements are met.
• Drafted User Stories and submitted to Business User for review.
• Developed Test Strategy and provided test approaches for three test phases of the project.
• Create requirements and Test matrix in ALM (Quality Center)
• Conducted API testing of green box system in SOAP UI 5.0
• Debugged failed SSIS package after analysis of server, flat file availability, Oracle SQL connection
• Conducted full integration testing of green-box, OFX and Intuit Branding Servers.
• Verified Data Integrity at every GET/POST function.
• Conducted Security testing utilizing OSWAP Top Ten on green box service.
• Utilized proprietary Intuit test software for OFX Server testing
• Conducted end to end testing using Intuit FIAT test plan.
• Identified and created test data to perform positive, negative and boundary validation testing.
• Worked in Agile environment using the Confidential frame work to test the application delivered in iterations.
• Updated, and resubmitted the deliverables based on scope changes or comments received from the client.
• Document software defects in defect tracking system Quality Center and keep defects up to date.
• Facilitated and derived Defect triage meeting and discussed the defects accordingly.
• Prepared test progress and defect report and communicated to management.
• Prepared and maintained the release and cycles to keep track of code movement and testing using Quality Center.
• Prepared test progress and defect report and communicate to the management
• Facilitated defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status

Environment: ALM 12.1, JIRA 6.3.7, Oracle SQL Developer3.0, SOAP UI 5.0, HTML, API Testing, .Net, JAVA,, Confluence 5.7, Browse mall (open source), Postman (Google), SharePoint 2013, JIRA, Agile, Scrum, MS Visio

Confidential, Kansas City, Missouri

QA lead/Quality Assurance Engineer

Responsibilities:

• Review and analyze the Requirements documents, Design documents, Data design/flow, Data mapping documents and used test cases.
• Participate in requirements, Design and functional specification review meetings.
• Develop and maintain Functional, Integration, Security and UAT Test plans.
• Developed user Stories, Test Plans and Test Cases, positive, negative and boundary testing as well as ad hoc testing to support FSA.
• Tested RESTful service with Biztalk orchestration to submit JSON reports with 4 Inputs and 11 Services
• Tested and validated data on Microsoft SQL Server in support of FSA file submission, identifying errors and communicated those errors back to FSA testers.
• Alerted Development to system failures on a real time basis and called attention to breaks in the system.
• Helped team member’s with accessing the database, applications in different QA environments.
• Researched live data from FSA tables to support JSON submission through Confidential process in Production.
• Developed and maintained Traceability between requirements and test cases to ensure that testability requirements are met.
• Responsible for conducting QA entrance and exit criteria meetings with project stake holders
• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.
• Actively participated in smoke, functional, regression, integration and ad-hoc testing during QA and STG phase of SDLC.
• Developed system test scenarios and test scripts using modular approach of scenarios development, prepared test data set and uploaded in MTM for execution
• Created various test data sets to check for boundary conditions, positive and negative test data.
• Used MTM for logging & tracking defects and the resolution of the defects.

Environment: MS Office 2013, Microsoft Project, Microsoft Test Manager 2013, Microsoft Team Foundation Server 2013, Visual Studio 2013, Microsoft SQL Server 2012, SharePoint 2013, JIRA, Agile, Scrum, MS Visio

Confidential, Kansas City, Missouri

Sr. QA Analyst

Responsibilities:

• Review and analyze the Requirements documents, Design documents, Data design/flow, Data mapping documents and used test cases.
• Participate in requirements, Design and functional specification review meetings.
• Develop and maintain Functional, Integration, Security and UAT Test plans.
• Developed and maintained Positive, Negative and Boundary condition Test Scenarios, Test cases and Test data for Functional, Integration and Security Testing.
• Developed and maintained Traceability between requirements and test cases to ensure that testability requirements are met.
• Responsible for conducting QA entrance and exit criteria meetings with project stake holders
• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.
• Worked in an Agile environment using Confidential to develop a plan, Test suites, test cases.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested all OBIEE Dashboards according to the requirement.
• Validated the Security, navigation to a particular screen, dashboard, page, and report for OBIEE.
• Validate access for data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page and report, capability on Reports for OBIEE.
• Validated if the summary reports are working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Tested all OBIEE Dashboards according to the requirement.
• Written several complex SQL queries for validating OBIEE Reports.
• Testing has been done based on Change Requests and Defect Requests.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used Quality Center for bug reporting. Tracked and reported the bugs with Quality center

Environment: ALM/Quality Center, Power Center 8.6.1, OBIEE 10.1, PL/SQL, BO, SQL, SQL Server Analytical Server, SQL Server Reporting Server, Microsoft SQL Server 2008, UNIX/Linux, iOS, Windows 7, Safari, Chrome, Firefox, IE8&9, Adobe flash and HTML5 technology, MS office 2012, Oracle, Agile, Scrum.

Confidential, Kansas City, Missouri

Test Engineer

Responsibilities:

• Participate in requirements definition reviews and functional specification reviews to ensure that critical information is included and testability requirements are met
• Participate in gap analysis for the given requirement, Mock up reports and dashboards for review by the business users
• Analyze the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test overage accordingly
• Responsible for developing the test cases to validate the ETL process, business rules, Data transformation rules, Reports layouts and data
• Responsible for developing and executing test cases to validate the Tables/View structure, Data conversion, Data Mapping between source to staging, Staging to EDW and EDW to Data Mart
• Responsible for writing and executing the test cases to validate the Transformation rules, Records counts, Logical and physical deletes, exceptions and errors for different stages of ETL
• Create requirements and Test matrix for ETL and Reporting Test cases in Quality Center
• Develop test cases using standard test case template in Excel sheet and upload in Quality Center
• Validated all the prompts from the summary reports are getting applied to the detail report
• Validated if the summary report is working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate
• Created and executed regression test cases for 100+ reports and Dash boards during OBIEE upgrade from version 10.x to 11.x
• Performed the regression testing after upgrade from OBIEE 10G to 11G and tested functionality and Security testing to making sure the all the OBIEE Security that has been completely upgraded from the previous versions 10g to the newer version of OBIEE 11g
• Document software defects in defect tracking system Quality Center and keep defects up to date
• Prepare test progress and defect report and communicate to the management
• Facilitate defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status
• Developed and generated test progress and defect reports from Quality Center
• Responsible for validating the files availability, format and data on UNIX server
• Utilize defect tracking tool HP Quality Center to trace, assign, verify and close defects
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.

Environment: ALM 11.5, SQL Developer, Web Client, JIRA 4.0, SQL, Web services, SOAP UI 4.5, HTML, XML, Compliance Testing, JAWS, .Net, JAVA, J2EE, SharePoint, Confluence, Oracle, DB2, Informix, SVN.

Confidential, Chicago, Illinois

ETL/BI QA Analyst

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications
• Prepared test data for positive and negative test scenarios for Functional Testing
• Responsible for exporting the Requirements and Test cases into Quality Center using excel add-in
• Responsible for creating requirement traceability matrix (RTM) into Quality Center and generate the report to verify the test case vs. requirements coverage
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor
• Verified session logs to identify the errors occurred during the ETL execution
• Created Test Cases, traceability matrix based on mapping document and requirements
• Verified the logs to identify the errors occurred during the ETL execution
• Written several complex SQL queries for data verification and data quality checks
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests
• Effectively coordinated with the development team for closing a defect
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process
• Validated the ETL Jobs, error logs
• Tested the Reports migrated from EPM 11 to OBIEE tool and compared the both the look and feel of the report and as well the functionality of the reports as per the tech spec's.
• Tested the reports different types of Customized Reports (Drilldown, Aggregation) Created by OBIEE to meet client requirements
• Tested performance for custom built reports & Dashboards
• Provided the management with weekly QA documents like test metrics, reports, and schedules
• System testing on the application.
• Ran database queries to retrieve data on the trade details and ensured by testing that all static data existed for the trade to be correctly processed.

Environment: - Agile, Microsoft Visual Studio, MTM 2012, TFS 2012, Web Services, SOAPUI, XML, WSDL,.NET, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion, J2EE, HTML, XML, VB Scripts.

Confidential, Chicago, Illinois

Test Engineer

Responsibilities:

• Defined requirements, designed and documented standards, procedures, and implementation plans for Software Configuration Management
• Responsible for working in Agile environment following the Confidential Framework for SDLC
• Responsible for implementing the QA in initial stage of SDLC, involved in user stories/backlogs analysis along with Business Analyst and SME’s
• Developed Positive, Negative and boundary conditions test scenario and created the test data set for the scenario
• Managed requirements gathering and technical design for reporting
• Facilitate defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.
• Responsible for writing and executing the in SQL queries using TOAD
• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application
• Requirement validation of the reports and drill downs with business users
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down
• Tested the user level security for intelligence dashboards based on Business Requirement
• Validated that the reports and dashboard page rendering times are meeting SLA requirements
• Responsible for Defect life cycle process, maintain and track Defects using Quality Center.
• Generate Defect reports using Quality Center API and SQL statements, on the daily and weekly basis in the form of tables & Graphs using Microsoft Power Point, prepared associated action plans and documented, distributed across the various project teams.

Environment: QTP 9.0, Quality Center 9.0, Flex 3.0, Java, JDBC, JSP, Servlets, EJB’s, Java Script, VBScript, HTML, Oracle, Unix, Agile

Confidential, Overland Park, Kansas

Responsibilities:

• Analyzed recruits application files for entry into MS Excel.
• Validated New Hire data for entry into UNIX mainframe.
• Participated in meetings with Business Analyst and Project Manager

Confidential, Overland Park, Kansas

Test Engineer

Responsibilities:

• Performed white box testing, regression testing and unit testing.
• Worked extensively with developers during the Build Stage