SUMMARY:

• 10 years Professional Experience working as BSA/data analyst/QA lead/QA Analyst in Healthcare, E - commerce, Retail and Financial domains.
• 6+ years’ experience in AgileScrum methodology.
• Experience in Sprints planning, Story grooming, Product backlog,QA estimations and managing workflows.
• Experience increating detaileduser Stories /technical solution tasks/functional specifications and QA tasks for the team in agile CA central tool.
• Experience in facilitating Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with the business/ stakeholders to Understand Requirements,
• Experience in tracking business requirements per Release and change requests.
• Excellent communication skills in translating business requirements to engineering team, UX team, QA team with technical details and flow diagrams.
• Experience in conducting UX sessions with UX/UI design team for requirements in detail discussion.
• Hands on experience in creating Business Requirement Documents (BRD), Userstories, user roles, Business Flow Diagram,Functional Requirement Specifications (FRS)and Sequence diagram using MS Visio.
• Well acquainted with Quality Assurance Life Cycle that includes developing Test Strategies, Test Plans, and Test Cases, developing automated test scripts, Defect Reports, Traceability Matrices and Test Environments.
• Well acquainted with Defect Life Cycle that includes logging defects with priorities,tracking defects in various environments, traceability matrices, creating defect reports and send them across team for visibility.
• Extensive experience in understanding the System, data, environments.
• Hands on experience with data analysis / data mining/ETL data loads.
• Experience working with databases like Oracle, MS SQL Server, Access, for big data sets.
• Involved in EDI(electronic data interchange) based applications.
• Extensive Experience in conducting and coordinating APT/IPT/SIT/ UAT/UX sessions.
• Performed Integration, Functional, Smoke, Performance, Security, GUI, Load, Regression, System, ETL testing, Web Services SOUP UI/ API and User acceptance Testing.
• Expertise in testing Distributed Web-Based Applications,Client-Server, Web Services, SOAP UI,Rest Client,.NET applications.
• Proficient in SQL/PL SQL programming to extract test data from database and back-end testing.
• Excellent analytical,communication skills and the ability to work as a team player as well as individual contributor.

TECHNICAL SKILLS:

QA Tools: HP QC, ALM, HP QTP, TAW, Selenium, ETL, Informatica, CA Agile Central, Tableau, Micro strategy

BA Tools: Wiki, JIRA, CA Agile Rally Central, Balsamiq, MS Word, MS Excel, MS Outlook, MS PowerPoint, MS Visio, GliffyMS Project, SharePoint2010/2013, and MS Access.

Languages,Methodologies: SQL,.Net, Agile, Waterfall

Web Technologies: XML, HTML,VB Script, VB.Net, Java Script, SOAP UI, Rest Client

MS: Access, Oracle,SQL Databases, IOS, Windows

PROFESSIONAL EXPERIENCE:

Confidential, MN

Quality Engineer

Responsibilities:

• Responsible for Database testing
• Perform profiling and data Sanity checks on the landing tables that gets loaded from sources systems via ETL.
• Involved in validating profiling results with BAs and SAs.
• Completely involved in validating the data from one schema to another in reference to mapping document and data flow diagrams.
• Heavily involved in writing SQL queries in My SQL management studio 2016 for profiling as well as generating Runbooks.
• Performed validation on table structure.
• Good knowledge on Health insurance sector such as provider data/ Provider groups/ member Enrollment data / Part C data/Part D data/ lab claims/ medical claims data/Gap results/ open close gaps/
• Worked on creating table test cases in reference to mapping document with understanding transformation rules.
• Involved in production checkouts.
• Performed SSRS front end report validations based of the data available in different environments.
• Strong analytical skills on performing data analysis and finding data issues such as providers with NULL values/ members missing HICNs.
• Tested EDI-based applications, for each transaction creating complex data sets and perform validation for each transaction manually.

Business System Analyst / Quality Analyst

Confidential

Responsibilities:

• Perform reports comparison generated from 2 difference platforms like tableau Vs SSRS reports.
• Performed ETL validation for the reports sent over ironbox from Rally data warehouse
• Detail Understanding of transformation rules from mapping document to create test cases
• Worked on one to one comparison for various missing members between Rally/Optum reports to analyze data gaps.
• Uploaded excel reports to MS access database to perform data comparison using in build query designs.
• Worked on oracle sql developer management studio to write sql queries to get data extracts.
• Worked on Documentation of production incident tickets with detail root cause analysis
• Worked with Product team to analyze requirements with data gap analysis.
• Documented test scripts, test cases, test data for remediation process on data issues and executed scripts in HP QC.
• Coordinated with Rally Sales force team regarding incident tickets.
• Executing SQL queries for test data creation for report validations.
• Creation of incidents dashboards and graphs to include in PM power point for monthly status.
• Generate the dashboards for critical issues /aging issues/ problems/ incidents for one to one with Project Managers.
• Run weekly Rally Optum reporting technology meetings to talk on open data issues and make resolution/ remediation plan for the fixes.

Environment: Oracle sql developer,ALM, MS Visio, MS Access, Microstrategy, Rally Tableau, CA Agile central, sql queries, MS excel, SSRS reports, GITHUB, Data sentinel, Jenkins, JBOSS.

Confidential, MN

Quality Analyst Lead / System Business Analyst

Responsibilities:

• Evaluatedcomplex process work flows for loyalty Program/integration with Citi bank, Mobile Renewal Program and created Process flow diagrams using Visio based on requirements.
• Gathering user and business process requirements and defining the As-Is business process and To-Be business process
• Interacted with Business users to understand the Business Requirements,Actively participated in walkthroughs and enhancement meetings.
• Creating User Stories, Involved in sprint planning, calculating team capacity for sprint.
• Assigning stories to development team and making sure they get completed within time frame.
• Experience in writing complex Test Scripts and Test Scenarios from business, functional and technical requirements.
• Participated as a SCRUM member, attended SCRUM standups and conducted team collaboration meetings as well as team retrospective.
• Responsible for Creating Integration test plan for program working with various vendor partners and project partners and also review and obtain required approval from various stakeholders.
• Involved in Functional, Integration, Regression, Smoke, Sanityand System Testing.
• Worked on various operating systems /latest versions ofMobile Device testing.
• Worked onSOAP UI scriptsfor creation of large set of test data creation and running Advance Rest client for various Web services calls.
• Created/Executed test scripts on Automation Framework tool TAW.
• Evaluating Buisness work flows and created test cases for them.
• Coordinated and participated inIPT /UAT/APT sessions.
• Track Stories for features as well as defects releasing per release cycle.
• Coordinate with the Development teams for handling over different build versions including defect fixes.
• Extensively involved in Web service mocking and simulation using SOAP UI
• Created architectural flow diagrams using SharePoint 2013 tools.
• Developed test standards for script development, various environments, reusable test data, test case automation, and test execution.
• Well knowledge of UNIX/LINUX logs to catch the issues.

Environment: Windows 2000, SOAP UI, QTP, SQL, ORACLE/ UNIX, HTML, XML, MS Project, MS Visio.

Confidential. Camp Hill, PA

Software Application Testing Lead

Responsibilities:

• Worked as testing leadfor 12 testers for all the application modules.
• Implemented Quality Assurance Life Cycle (QALC) aspects such as developing Test Strategies, Test Plans, Test Cases (Manual / Automated),Defect Reports and developing Test Scripts, Traceability Matrices and Test Environments.
• Experience in managing the entire quality process management, administration and testing of application-based system using HP QC during SIT phase.
• Worked on TFS server for documentation of requirements and creation of Use cases.
• Creation and Extraction of Bug reports on TFS and communicated across teams.
• Extensively tested the Healthcare Module with the Healthcare providers and Professionals filling URO/PRO applications.
• Extensively Tested the Self Insurance Module in detail with all the renewal packages and Runoff reports.
• Intensively involved in EDI (Electronic data Interface) like FROI(First report of injury),SROI (Second report of injury)and Correspondence generation testing.
• Wrote SQL queries to get all sorts of data for the team based on test data requirements.
• Extensively involved in Back End testing during data Migration from CIMS to WCAIS system.
• Supporting UAT team for test case execution in Quality Center and tracking UAT defects
• Executed Automated test scripts using QTP for smoke test after build deployments and Actively responsible for the Smoke tests result validations across various teams.
• Performed Integration, Functional, Smoke, Performance, Security, GUI, Load, Regression, System and User acceptance Testing.
• Performed Gap Analysis and led to change of certain business rules to make application work more users friendly.
• Daily tracking Bugs and pull the reports of total execution, calculating the pass rate, fail rate vs. defect logged using HP QC.
• Extensively ran time dependent batch process to validate the batch execution.
• Written and executing scripts on HP QC based on use cases, which include all the project specifications and functionality requirements.
• Guiding and teaching co testers about the application and approach to proceed with testing to meet deadlines.

Environment: MS SQL Server 2008 R2, Top Team, System Integration Testing (SIT), User Acceptance Testing (UAT), Quality Centre 10.0, Quick Test Professional 11.0, VB.Net