PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Software Quality Analyst

Responsibilities:

• Created 834 and 820 EDI files for unit and QA testing for billing, claims, letters, PEC, accumulators etc.
• Worked on testing HIPAA EDI X12s including transaction sets 837,835,820,270,276,277.
• Worked on testing all the modules of Salesforce.com (SFDC) application.
• Worked extensively on SDLC both waterfall and Agile SCRUM methodologies.
• Manipulated data in Amisys tables using SQL according to testing needs.
• Resolved data and other analysis related issues to expedite release deliverables.
• Maintained test data and creation of test data for other work streams as needed.
• Created 820 file for testing enrollment with corresponding payments according to the test scenarios using the MNsure companion payments guide.
• Involved in project initial phase with estimation and designing test strategy.
• Participated in project meetings for requirements gathering and provided end - end test execution.
• Responsible for writing QA detailed test plan for each project and got approval from IS governance.
• Responsible for documenting test scenarios, writing test cases and maintaining RTTM using MS Excel and uploading in SharePoint.
• Responsible for writing SQL queries for testing the source to target document and testing data quality for load systems.
• Run unix commands in Putty to load the file to Amisys.
• Analyzed batch tables and staging tables if members fall into exception.
• Performed testing operations from beginning to end (system testing/ end-to end testing).
• Performed regression testing, validating the functionality after the enhancements are made.
• Responsible for defining processes, improving data scalability and reviewing code.
• Performed migration testing by ETL tool based on transformation logic and validations on ETL testing.

Environment: Amisys, EPS Manager, CRM, Biz talk, UC4/ AppWorx Applications manager, Claim Test Pro, GALAXY, Salesforce.com, LINX, IKA Applications, Macess EXP, iCES, CCR, Programmer studio, Putty, Bugzilla, JIRA.

Confidential, Fairless Hills, PA

Quality Analyst

Responsibilities:

• Participated in requirements gathering and analysis with all the key stakeholders by facilitating JAD sessions.
• Developed a matrix to document the service targets and delivery standards by market segment for all business segments and established action plans to address gaps between target and actual service delivery levels.
• Worked on testing various EDI ANSI Transactions.
• Involved in automation and manual testing using Rational Functional Tester, Rational Manual Tester and Rational Clear Quest IBM Tools.
• Managed testing the applications especially integration testing, regression and smoke testing involving various functionalities.
• Performed gap analysis to review existing workflows for Billing and Claims to identify gaps in current delivery and developed improved workflows to address the gaps.
• Interacted and arranged meetings with business and end users to gather business requirements for configuration of billing and various other systems.
• Worked on Facets billing batch jobs, including the billing processing and financial billing analysis processes.
• Involved in data analysis for the data warehouse and data mart system for the configuration of benefits with members.
• Created and reviewed test Cases and test scripts in Rational Manual tester and Functional tester.
• Analyzed and built test data and developed test Plans, test Cases and test scripts.
• Executed test cases and ensured the testing is completed within the timelines and budget limits.

Environment: Microsoft SharePoint, Business Objects 6.1, Oracle, FACETS 4.51, Agile, SQL, ETL (Data stage), Rational Requisite Pro, Rational Clear Quest, ALM, MS Visio, MS Office, Microsoft Project, UML and SQR, Iterative Process Methodology

Confidential, Minnetonka, MN

Data Quality Analyst

Responsibilities:

• Gathered and analyzed data requirements with all of the key stakeholders by facilitating JAD sessions.
• Developed a matrix to document the service targets and delivery standards by market segment for all business segments and established action plans to address gaps between target and actual service delivery levels.
• Analyzed data coming from 16 different sources before getting into a unified format in staging tables.
• Handle the role of ETL Data Analyst for EDW Replacement project.
• Designed and developed system documentation for EDW projects.
• Created queries in SQL to validate the complex transformations between Source and Target mappings.
• Executed SQL queries to extract data from tables and verify the output with reference to user inputs from browser page.
• Involvement in testing the transformation of data from ETL Mappings (Target tables) to Text Extracts.
• Piloted the training sessions to the UAT users for the new system.
• Extensive experience in data analysis and tracing the data back from Target tables to source systems if any problem encountered.
• Efficiently wrote SQL queries for effective testing of mappings.
• Experience in testing the data flow from Stage-Source-Target - Reporting tool.

Environment: Microsoft SharePoint, Business Objects 6.1, Oracle, FACETS 4.51, Agile, SQL, ETL (Data stage), Rational Requisite Pro, Rational Clear Quest, MS Visio, MS Office, Microsoft Project, UML and SQR, Iterative Process Methodology.

Confidential, Portland, OR

Quality Analyst

Responsibilities:

• Worked on Facets billing batch jobs, including the Billing Processing and Financial Billing Analysis processes.
• Involved in data analysis for the data warehouse and data mart system for the Configuration of Benefits with members.
• Created and Reviewed test cases and test scripts in Rational Manual tester and Functional tester.
• Analyzed and built test data with source and target systems.
• Logged and tracked defects and escalated issues with development teams.
• Managed system test file trading with external trading partners (clients / payers, providers, clearinghouses).
• Negotiated modifications to the Trading Partner's implementation based on HIPAA EDI Companion Guide.
• Experienced with ETL processes using Oracle and Data Stage tools.
• Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
• Managed trading partner testing including creation and transmission of test files, as well as evaluation of incoming and outgoing files
• Monitored the trading partner's migration from test to production status.
• Communicated testing status to the appropriate business process owner and trading partner contacts.
• Developed mockups for the reports and identified the parameters required for reports.
• Engaged with data warehouse team and business objects team to translate the requirements and specifications for developing the reports.
• Developed test plan and test scripts for testing the application.

Environment: Microsoft SharePoint, Business Objects 6.1, Oracle, FACETS 4.51, Agile, SQL, ETL (Data stage), Rational Requisite Pro, Rational Clear Quest, MS Visio, MS Office, Microsoft Project, UML and Iterative Process Methodology.

Confidential

Software Quality Analyst

Responsibilities:

• Implemented various deployments over UNIX environments and production rollouts.
• Developed complex UNIX shell scripts for migrating code and deployed it into production environments.
• Tuned existing scripts for better performance and data and server cleanups.
• Used clarify CRM for user creation and giving access permissions and configurations.
• Prioritized and resolved issues and maintained issue logs to better tracking.
• Presented summarized reports to management for issue tracking and escalation.
• Created test suite for the project and executed test cases for quarterly releases.
• Corresponded with all levels at workplace, including project managers, test leads and developers.

Environment: SQL, Oracle 9i, Toad, Clarify CRM Thin Client and Thick Client, UNIX, FileZilla, BEA Web logic, Excel, Word, PowerPoint, Eclipse