SUMMARY

• Senior Analyst with 7.5+ years of work experience assisting clients in analyzing, implementing and evaluating business projects to meet performance expectations utilizing varied business practices, core competencies and key skills in Quality Assurance, Process Management, Business Analysis, Data Analysis and Production Support Analysis.
• In - depth knowledge of Software Development Life Cycle (SDLC), having thorough knowledge of various phases in SDLC like Requirements, Analysis and Design, Development, Testing and Deployment.
• Experience working as Quality Analyst both Manual and Automation testing SAP ERP Applications, Web, and Client/Server applications by creating Test Metrics including Test Coverage, Test Results, Requirement Traceability Matrix (RTM) and Acceptance Reports using Test Management tools (HP Quality Center/HP Application Lifecycle Management ALM, Team Foundation Server and Microsoft Test Manager).
• Proficient in technical and business writing, business process flow, business process modeling, business analysis, building strong customer relationships, decision making, problem identification & solving and testing various methodologies.
• Exposure to Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and practical knowledge on Waterfall, Agile, Spiral and Rational Unified Process SDLC Methodologies.
• Involved in ETL testing, System Testing to check whether the data loads into target are accurate, which was extracted from different source systems as per user requirements and Used SQL Queries to validate and manipulate the data in the data warehouse.
• Experienced in IT solutions and behavioral health research (risk assessment procedures) and familiar with healthcare IT standards such as HIPAA, HL7 standards and message validation tools (ADT, Mirth Connect, ADO, OMS ORU), challenges of health care data exchanges-HIE.
• Expertise in creation of UAT Planning, UAT cases covering different Business, Functional and Non-Functional Test scenarios and creation of expected test results & UAT execution including defect tracking and resolution.
• Strong understanding of GAP Analysis, Requirement Management, Testing and Project Planning and experience in developing use cases, creating screen mockups, and risk analysis.
• Involved in Functionality Testing, GUI Testing, Black-box & White Testing, SOA Testing, Micro services Testing activities on Client/Server-based, Services-based & Web-based Environments.
• Good Experience inSQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS)andSQL Server Reporting Services(SSRS) and experience inExtracting, Transforming and Loading data from Excel to SQL Servers.
• Exposure to Data Analytics and Analysis including Data Visualization, Data Validation, Data Verification and Data Management using Hadoop, Hive, Tableau, Pentaho.
• Collaborated with Clients and Development teams as a part of JAD sessions for drafting objectives and capturing business requirements from calls as well as organized routine calls to monitor project progress and issue resolution.
• Proficient in technical and business writing, business process flow, business process modeling, business analysis, building strong customer relationships, decision making, and testing various methodologies.
• Possess strong time management and communication skills to coordinate with business and technical consultants to discover business improvement opportunities.

TECHNICAL SKILLS

Databases: MS SQL Server Management Studio, Oracle, PostgreSQL, and MS Access.

Testing Skills: Functional Testing, Non-Functional Testing, Performance Testing, UAT, and Defect Tracking.

Testing & PM Tools: HP QC, HP ALM, HP QTP/UFT, Selenium, JIRA, MS Test Manager, IBM ClearQuest, and TFS.

Analytics Tools: R, Tableau, Qlik Sense, Qlik View, SAS Enterprise Miner, SAS Enterprise Guide, AWS Tools, MS Azure, Visual Studio 2012, MS VISIO, MS Project, and MS SharePoint.

Additional Skills: Business Analysis, Requirement Gathering, Project Management, Process Modeling.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

IT Consultant - Sr. QA Systems Analyst

Responsibilities:

• Analyzed the user requirements and functional specifications to develop Test cases to cover overall QA testing and developed Test Data based on requirements. Involved in all phases of SDLC.
• Prepared detailed Test plans and Test cases for functional, Integration, System, and GUI Testing using HP-Mercury Quality Center. Also involved in importing the Test Cases into Quality Center and Test Director from MS Excel.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Quality Center.
• Managed and updated team’s Test Plans and Test Cases periodically to manage changes in the project requirements.
• Develop reporting dashboards, metrics, and key performance indicators to assist leadership and key stakeholders in analyzing and interpreting data. Provide accurate, timely and reliable metrics, reports and analysis in support of multiple strategic goals, and mandates.
• Involved in SOAP and Restful web services using SOAP UI by installing and configuring SOAP UI to test web services using WSDL files received from the Development team.
• Coordinate and participate in the planning, executing and release planning sessions and provide status updates, documents changes, and KPI metrics and facilitate issues and risk resolutions with IT staff and/or vendors.
• Partner with peers to establish, evaluate, and continually improve measurement methodologies, while adhering to accepted analytical and reporting standards and create, modify, maintain, and enhance existing business processes.
• Interpret, communicate, and present results to all levels of management in consistent and easy to understand formats to facilitate fact-based decision-making.
• Communicate updates to relevant business stakeholders, vendors, and other teams as appropriate for completion of the deliverables; keeps management informed of problems dat could negatively impact the release.
• Complete projects within preset timelines and report status to the CEO and prepare written documentation on projects to provide a peer review trail and ensure continuity and integrity.

Confidential, Phoenix, AZ

IT Consultant - Sr. Business QA Analyst

Responsibilities:

• As a Senior QA Analyst, me am responsible to lead planning, scheduling, and execution of all test phases over the program roadmap and assist in the detailed process flow design, work closely with Line of Business in gathering requirements, analysis, user acceptance testing and rollout of new & modified ETL features.
• Worked on ETL/SQL requirements, data mapping, stored procedures, triggers, layouts for huge number of batch and on-request reports and batch processing systems.
• Reviewed Business Requirements, Functional Specifications, Uses Cases to understand end user requirements in order to validate dat system functionality and underlying business processes operate as specified.
• Developed UAT artifacts, including Test Scenarios, Test Scripts to ensure risk of system defects are mitigated or eliminated and conduct UAT testing, performing the functions and tasks outlined in the UAT plan and test scripts.
• Ensured proper configuration management of the testing software and traceability of the tests to the critical business capabilities and ensured the test environment and associated test data is put into place before test execution and managed during test execution.
• Scheduled tests for execution and tan monitor, measure, control and report on the test progress, the product quality status and the test results, adapting the test plan.
• Generated ad hoc reports and regular datasets or report information for business teams and end-users using system tools and database or data warehouse queries.
• Worked with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies.
• Wrote and coded logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Helped in modifying existing databases and database management systems and/or direct programmers and analysts to make changes and Test programs or databases, correct errors and make necessary modifications.
• Upon code completion, me should perform Adhoc testing in DEV, QA, UAT and PROD environments to ensure good code quality by testing product(s) end-to-end from technical designs, test plans and scripts.
• Provided ABAT job execution and job monitoring on AD and SOAPUI to ensure jobs were successful with defined Service Level Agreements and monitored production job executions, and address any errors by analyzing and performing root cause analysis.
• Performed light project management role to lead small efforts viz., provide recommendations prior to code release based on test results, write summary reports on test status and code/configuration deployments to environments.

Confidential, Framingham, MA

IT Consultant - Technology Analyst

Responsibilities:

• Created and executed test plans and test scripts for application development efforts based on documented business requirements and communicated test progress, results and other relevant information to the team.
• Reviewed the test deliverables of QA peers, identified gaps and makes suggestions to halp bring the cases to current standards as needed.
• Participated in Business and Functional requirement reviews, design reviews and Test Plan reviews andprovide input to the project team on ways to improve thequalityand the ability to test the documented changes.
• Managed and monitored QAV Validation and Production environments with complete coverage on pre and post medical claims on all of OS Patching processes based on SOA based applications.
• Evaluated and supported SOAPUI and REST API web-services by providing end-to-end Functional testing and by providing technical support and operational knowledge for system and impacted system processing.
• Performed gap analysis (HL7 specifications), map, interpret HL7 messages; monitor, troubleshoot/test using analyst skill sets-SDLC for correct implementation.
• Provided Application Support to maintain SAP ERP applications’ (HRM, QM, PS, MM, OMS) functionality and availability by providing on-call, 24x7 support as needed.
• Worked with AWS Cloud teams to drive the adoption of AWS services and halp establish a fully automated environment for the provisioning, upgrading and auditing of AWS services.
• Used HP ALM tool control to deploy application patches and created queries in ALM to validate results of test reports and replicate any issues before reporting them on ALM.
• Provided application batch job execution and job monitoring on ALM to ensure jobs are completed timely and successfully with defined Service Level Agreements and monitored production job executions, and address any errors by analyzing and performing root cause analysis for the error.
• Worked on tools viz., MS SQL Server Management Studio, HP ALM, UFT, SAP ERP tools, AWS, HIPAA regulations for data exchange and security, HL7 Mirth service tools, and JIRA to maintain Deployment services, Monitoring and Testing plans and to obtain Continuous feedback and jobs/incidents associated.
• Maintained focus on quality, commitment, ownership, attention to detail, communication and delivery to tight timescales by identifying the system support efficiencies and propose solutions.
• Manage and report defects on JIRA and took ownership in providing weekly status reports to the project managers and development teams as well.

Confidential, Lubbock, Texas

Senior QA Analyst

Responsibilities:

• Responsible for maintaining the integrity of the RDMS - PostgreSQL and SQL databases and reporting any issues to the database architect.
• Analyzed business requirements document, functional specifications document to prepare Test plan and Test cases.
• Used agile methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Worked as a liaison between business team and development team, translated business specifications and requirements into functional test cases, worked closely with the development team on analysis & design to meet business requirements and site roll out.
• Created test plan, Plan and review created test scenarios and test cases for Functional, Regression and automation test suite.
• Working on Requirement Tractability Matrix (RTM) which is a proof of document to ensure dat all the specifications are been tested and has no defects.
• As a member of the Scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews.
• Prepare Test Status report on weekly demand during planning and execution to summarize progress and results.
• Prepare Test Summary Report at the end of testing phase with results of readiness of system deployment to production.
• Performed defect logging and tracking using JIRA, documented raised defects, followed up with development team for defect fixes, and updating bug status on tool accordingly.
• Maintained project status reports and communicating with the team managers on daily and weekly basis.

Confidential

Software Engineering Analyst - SQL Data QA Analyst

Responsibilities:

• Involved in writing test plans, defining test cases, test scenarios and data sets; developed and maintained test scripts, analyzed bugs and interacted with development team in fixing the errors.
• Tested Web-based applications and SAP ERP modules (HRM, FSCM, FICO) performing System Integration Testing, Risk-based testing and UAT testing to establish dat all business requirements have been implemented completely and correctly.
• Identified defects and performed root cause analysis of the defects; communicated the defects to the technical team using ALM tool.
• Used JIRA to maintain Planning, Development and Deployment, Monitoring and Testing, and Continuous Feedback activities.
• Maintained reports and graphs for Continuous Integration and Automation for checking on wat is being tested and how thoroughly and verified the same working with the technical teams and business users to ensure the issues and defects resolved.
• Conducted Automation testing to perform regression testing using QTP conducted in UAT and PROD environment; provided support to the business users and resolved day to day system issues.
• Created business requirements documents, system configuration documents, detailed functional design documents, test plans and test cases, user training documents and implementation documents using Use cases on Visual Paradigm and MS VISIO tools.
• Responsible for requirement gathering analysis, detailed process flow design, user acceptance testing and rollout of new & modified ETL features for Web-based applications and GUI applications.
• Responsible for writing SQL queries for accessing data from MS SQL Server database and executed SQL queries to validate the data in target database.
• Worked closely with Clients and Development teams as a part of JAD sessions through video calls and daily setup calls to discuss project requirements, system designs, test environment, test approach and problem specifications.
• Translated business requirement document (BRD) into functional specification document (FSD) for Scrum technical team using HP QC.
• Administered and executed System Integration Testing, Non-Functional (black-box and white-box) Testing using HP QC/ALM, Regression Testing using HP QTP, User Acceptance Testing and Unit Testing on Client machines.
• Identified defects and performed root cause analysis to communicate the defects to the technical team precisely.
• Used and gained knowledge on tools viz., QTP, QC, ALM, JIRA, TFS, SAP HRMS, and RQM to perform QA activities.