SUMMARY

• 9+ years diverse experience in Information Technology with emphasis on business and system analysis of applications.
• Well versed with all aspects of Software Development Lifecycle, Waterfall Process, and Agile Methods.
• Proficient in creating traceability matrices, test plan documents, data modeling, document processing, quality assurance to manage, develop and test products.
• Established and maintained strong working relationships with senior and junior business sponsors as well as technical specialists.
• Good knowledge of Data Manipulation by Manual, and Automated Testing tool such as SoapUI, QTP, UFT

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr QA - eCommerce

Responsibilities:

• Analyzed System Requirement Specification (SRS) document and Business Requirement Document.
• Participated in peer review with team and developers to review test cases/test scripts.
• Performed System, Integration, Smoke, Sanity, Functional, End to End, Positive and Negative and monitored the behavior of the applications during different phases of testing using testing methodologies.
• Performed agile testing, review the stories and participated in Daily Scrum, Iteration Planning and Release Planning meeting.
• Involved in Functional, System, Integration, Regression, backend and Automation Testing.
• Test creation, test data preparation, test execution and documentation.
• Prepare Testing artifacts as needed, such as Test Plan, Test Strategy, RTM, etc.
• Documenting defects/issues in the defect tracking tool.
• Logging in UNIX server for checking logs in UNIX in QA & Development environment.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables
• Performed data validation on the flat files that were generated in UNIX using Shell scripting commands as necessary.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Created various stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Preparation of test data for various levels of testing
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Web services testing using SOAP UI.
• Coordinated with multiple teams, both internal and external, to determine upstream/downstream impact of the application with multiple dependencies.
• Good understanding of XML and HTML scripts
• Extensively used Application lifecycle management for test planning, bug tracking and reporting.
• Tested in distributed Unix/Windows Environment and DB2 databases as back end & performed end-to-end testing.
• Good working knowledge with using assertions wherever required and applying
• Experience with executing SQL queries using joins to validate the front end and back end database.
• Participated in weekly QA status and project status meetings to report any defects and issues encountered in application.
• Discussed with team lead and PM regarding testing deadlines and post deployment validation.
• Actively communicated with the end users and business users to create realistic test cases.
• Provide test summary documentation and analyze test results, identifying trends and/or root causes of problems.

Environment: SDLC, SOAP UI, WinSCP, PuTTY, JIRA, UNIX/LINUX, RDBMS, SharePoint, Microsoft Test Manager, MS Team Foundation Server, Quality Center, VBScript, SQL, .NET, DB2, Oracle, Java, AS400, Visual Studio, Windows OS, Management Studio, Team Web Access, Web Services, HTML, XML, MS Office, Internet Explorer, Microsoft outlook

Confidential, Richmond, VA

Sr QA / Test Lead

Responsibilities:

• Worked with Business users and technical lead for gathering requirements and data transaction information.
• Provides fundamental metrics to test management personnel, reports on defects detected
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components.
• Experience on DSS Decision Support Systems applications, directly responsible for the Extraction, Transformation and Load ETL of data from Legacy Systems using Informatica and testing them.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, and scheduling the Workflows and Sessions in Informatica.
• Good knowledge of Data Manipulation by Manual, and Automated Testing tool such as Soap UI, QTP, UFT
• Performed web service testing using SOAP UI and XMLFormatter utilities and involved in importing new builds into SOAP UI projects.
• Closely worked with development team to enhance and standardize the ETL Process to load underlying system that supports UI.
• Engaged in performing various types of testing: Functionality, Security, Integration, Regression, Negative, and Positive, Database/Backend etc.
• Participated in User Acceptance testing, System testing, Regression testing, Build Verification testing, End to End testing for the client applications like Cyberaccess, SmartPA and different modules in these applications.
• Working as team lead handling 5 offshore QA team from different states and managing them to accomplish tasks given day to day.
• Worked on SOAP-UI testing tool for unit testing of entity services.
• Modified UNIX and SQL validation scripts, and writing SQL queries to validate the outputs
• Hands on experience in manual testing of the application on mainframes for claims processing.
• Worked on SOAP and REST web services testing using SOAPUI and ensured XML request and responses are parsed correctly and performed XPATH validation changes for values using Regular expressions.
• Involved in parameterization of endpoints in SOAP UI and validation of Linux Shell Scripts
• Tested all HIPAA transactions for multi version support (4010 and 5010) and validating the database to file elements.
• Developing and executes test plans and test scripts, executes planned sequences of test cases and recording test results
• Performed Smoke, Integration, functional, Regression, and system testing.
• Tracking validation of requirements writes issue/problem reports, maintaining and enhances existing test cases.
• Recording the results in Quality center, Microsoft Test Manager tool and Excel sheets.
• Worked Extensively with Inbound 837 I and 837 P, 835s (Out bounds) claims processing systems and XML validations.
• Monitoring and testing the data load from one database to other and validating the results and generating reports.
• Used Date warehousing for the arrangement of customer data.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) verified the functionality coverage
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.

Environment: SDLC, Quick Test Professional, MS Team Foundation Server, Quality Center, VBScript, SQL, .NET, DB2, Oracle, Java, Visual Studio, Windows OS, Management Studio, Team Web Access, Web Services, HTML, XML, MS Office, Internet Explorer, Microsoft outlook, SOAP UI, JIRA, UNIX/LINUX, RDBMS, Microsoft Test Case Manager, SharePoint

Confidential, Watertown, MA

Quality Analyst-I

Responsibilities:

• Worked with Business users and technical lead for gathering requirements and data transaction information.
• Created Questionnaire Document and Work Agenda before the JAD sessions.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Created the business process model using MS Visio for SME’s for validation and getting the sign-offs
• Gathered and analyzed requirements for documenting reports which spotlights payer’s performance.
• Identified Claims management work flows, business rules and developed flow charts and activity diagrams
• Experience working with the EDI transaction sets 835, 837, 270/271, 278 which include Referrals/Specialty Care Claims.
• Involved in the Payer Cycle such as in the enrollment, CCMS memberships, benefits management claims processing, provider servicing, and member servicing and ad-hoc reporting.
• Worked in a team for Claims processing and was involved in prioritized claims, identified problems, prepared an action plan, implemented the solution, identified claims outside the benchmark
• Data conversion of all EDI claims from 4010 ANSI to 5010.
• Created 5010 preferences for all the HIPAA real time & batch transactions.
• Used FACETS Analytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
• Extracting special Claims to test for MSP (Medicare secondary payer)
• Provided Support services for Centers for Medicare and Medicaid Services (CMS)
• Configured FACETS to adhere to customer’s work flow for claims processing, claims automation and group administration
• Used FACETS to provide seamless transactions between the provider, members and the plan and used FACETS Workflow to route the claims according to the priority.
• Involved in writing use cases for medical, pharmacy and vision claims as part of Health Statements.
• Developed requirements in designing dashboards for healthcare membership programs to meet the real needs of customers.
• Documented technical details in the functional including data source, file formats and data mapping.
• Documented System Design Documentation (SDD) describing the systems requirement, operating environment, files and database design, input format, output layout, detailed design.
• Assisted the project manager in writing business cases, to verify that this financial tool meets the needs of the business.
• Conducted manual testing and logged defects using Clear Quest. Assisted testing team in understanding the business rules and system development. Created users and user groups to assist testers.
• Used SQL for back end testing and ensured the data is updated accordingly.
• Developed test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Involved in Automated Testing using QTP.

Environment: EDI X12N 4010, Sybase Paper Free HIPAA Toolkit, DB2, LDAP, TSO/ISPF, JCL, Visual Basic, ASP, XML, SQL, MS Access, UNIX, Oracle Run Time, Windows95/98/NT/2000/XP and Internet Explorer, I-Frame Portlets, Siteminder.

Confidential, Louisville, KY

Quality System Analyst

Responsibilities:

• Reviewed the entire application and develop requirements.
• Worked extensively with the users and with different levels of management to identify requirements, Use Cases and to Develop Functional Specifications.
• Managed all the requirements in Rational Req-Pro making requirements available to all team members.
• Participated in JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Created data flow models, data quality analysis, and cost benefit analysis.
• Published all functional and specification documents in Share point.
• Involved in Business process reengineering to approach aiming at improvements by means of elevating efficiency and effectiveness of the processes that exist within and across organizations.
• Actively involved in development and maintenance of Share point team sites, Document libraries and custom list.
• Worked with senior level Share Point developer to help support the application using MS Share Point 2007.
• Created Use-Cases, Business Use-Case Model, data model, and ER Diagram after accessing the status and scope of the project and understanding the business processes.
• Created logical data model from the conceptual model and it’s conversion into the physical database design.
• Answered provider questions on the ANSI X12 format and looping structure of 837, 270/271/276/277 , and 835.
• Trained the team in HIPAA standards (4010).
• Interface was written to confirm the HIPAA Compliance.
• Involved in creating different EDI transaction set.
• Trained the team in HIPAA standards.
• Interface was written to confirm the HIPAA Compliance.
• Worked with ETL team to come up with Data mapping document.
• Interacted with various Cross-Functional Teams on building business use cases and understand expenses and revenue stream.
• Developed test plan, test script, test data for testing EDI transactions to run in different environments.
• Worked with the Automation Tester to assist in Automation Testing using QTP.
• Worked with performance tester in order to verify the performance of the system before hand off to users.
• Interacted with the developers to Report and Correct Bugs.
• Used the change management from rational to track changes to multiple artifacts by versioning artifacts, associating requirements specific change requests to streamline the defect/change tracking process.

Environment: RUP, Requisite Pro, Uses cases, Rational Rose, Content Management Systems, UML, Rational Rose, MS Office 2003, QTP, Interfaces, Erwin 7.0.1, IBM WebSphere, MS Project, Datawarehouse, Mainframe, Test Director, COBOL/CICS, DB2, SQL, JAVA

Confidential

Data Analyst

Responsibilities:

• Participated in gathering user requirements, developing functional and non-functional requirements and technical specifications.
• Developed Use Cases/Diagrams, Conceptual Model, Behavior Diagrams (sequence, collaboration, state chart, Activity), using MS Visio.
• Studied various risk reports to evaluate Credit Risk, Value at Risk, as per the firms Overall Risk Monitoring Procedure.
• Responsible for working with the manager and other users and creating Work flow diagrams as per the Data Analysis.
• Responsible for the delivery of Business Requirements Documents (BRD) within project timelines.
• Extensively involved in coming up with test specifications, test cases and test manuals for the application.
• Performed Unit Testing, Functional Testing, Integration Testing, Stress Testing and Code Inspection review to make sure the deliverables are match with business requirement.

Environment: SDLC, Windows 98, MS Project, MS Visio, Visual Basic, Crystal Report, Win Runner, HTML, MS Office, Oracle, SQL.