PROFILE:

Seasoned QA Test Lead / Functional Lead with more than 9 years of experience in large complex projects having heterogeneous architecture and multiple interfaces. Proficient in Requirement Analysis, quality assurance, design verification and Testing Methodologies. Efficient in doing multi-tasking, client interaction, grooming new-entrants, peer coordination and meeting aggressive timelines by innovation. Have considerable experience as a Functional Lead and in Project Management as well.

PROFESSIONAL EXPERIENCE:

• An accomplished QA Lead and Functional Lead with extensive experience in Project management, business analysis / requirement analysis, software testing and quality assurance in below Domains:
• Healthcare domain (IBM Curam / Connecture / Benaissance products / Affordable Care Act / Healthcare Exchanges) – 2.5 years of expertise
• Energy and Utility (Oracle Lodestar MDM- Meter Data Management) – 5.5 years of experience
• Services Industry - 1 year experience
• Worked as primary liaison with Business, QA, Development teams and Vendors for major releases, recreation of customer issues, subsequent fixes and successful release of patches.
• Performed Gap Analysis, Risk Analysis and Cost/Benefit Analysis.
• Keep track of the new requirements / change in requirements of the Project.
• Ensure complete traceability of requirements ensuring complete functional and test coverage
• Bring software processes in place maintaining the CMMI level of the Project and as per company and industry standard,
• Skilled in preparing Business Requirement Document (BRD) and Use Cases, defining project plans, scheduling in Microsoft MPP, writing system requirement specifications and delivering Status Report (Daily, Weekly etc.)
• Experienced with UML modeling, context diagrams, Use Case modeling, Database model diagrams (i.e. entity relationship modeling) and Activity, Sequence and Interface diagrams
• Heavily involved in Planning, deploying, and managing the functional (business analysis) and testing effort for any given engagement / release. Define the scope of requirements and testing within the context of each release / delivery.
• Developing the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan. Ensure the timely delivery of different testing milestones.
• Identifying Training requirements for grooming Testing Team.
• Worked in various projects in Waterfall or Agile Methodologies. Also worked on Risk Based projects
• Have considerable Development Experience as well during initial years.
• Organize defect triage meetings and alarm the various stake holders on-time for any risks.
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization and Software Testing Life Cycles.
• Performed Interface testing, Web based testing, Smoke Testing, Black box, White Box, Functional, Integration, Regression, Ad-hoc, End to End, System integration (SIT) and User acceptance (UAT) in Client Server, Multi-tier, Web-based and Desktop Application environments
• Performed in Backend Testing in Oracle 8i/9i/10g for executing SQL Scripts.

TECHNICAL SKILLS:

programming Languages: SQL, Unix scripting, .NET, Java scripting

Operating Systems: MS Windows all versions

Databases: Oracle 8i/9i/10g, SQL Server 2005, 2008,2012, MS Access

Web Technologies: HTML, XML.

Tools / Products

• HP ALM – Defect Tracking and Management
• Lotus Notes - For Issue Database Management, tracking PM Plan, CM Plan, Defects, Issues, Procurement, and Training
• Quality Center - For Issue Database Management, tracking PM Plan, CM Plan
• JIRA – Defect Tracking and Management
• Microsoft Visio - For business process flows
• Microsoft MPP – Project Management Tool
• IBM Curam Product - Healthcare solution
• Connecture Product – Healthcare Plan Enrollment
• Benaissance Product – Financial Management
• Informatica - ETL / Data Conversion Testing
• ClickSchedule Product – For scheduling and Field Service Management
• Oracle Lodestar Meter Data Management Product– Advanced Metering Infrastructure

Tools & Packages: Adobe Acrobat Suite, Microsoft Office Suite

Networking: HTTP

EXTENDED PROJECT DETAILS

PROJECT NAME AND DESCRIPTION

Project Name: District of Columbia Access System - HBX(Health Benefit Exchange)Client Name:

TOOLS / PRODUCTS

• HP ALM – Application Lifecycle Management - For Issue Database Management, tracking PM Plan, CM Plan
• Microsoft Visio - For business process flows and use case preparation
• Microsoft MPP – Project Management Tool
• Informatica - ETL / Data Conversion Testing
• WinSCP and PUTY - File Transfer and running commands
• IBM Curam Product - Healthcare solution
• Connecture Product – Healthcare Plan Enrollment
• Benaissance Product – Financial Management
• Toad – For running SQL Queries

RESPONSIBILITIES

ROLE: QA Lead and Functional Lead

• Worked coherently with Business Clients (Federal Clients) to prepare the scope of HBX for Release 1 and Release 2. Understood the requirements and prepare scope for various Releases.
• Heavily involved in Project Planning, deploying, and managing the functional track and testing effort for various releases. Defined the scope of functional requirement and testing for all the assigned tracks.
• Prepare the Business Requirement Documents along with the clients, heavily involved in all the Functional Designs and helped the Technical Development Team with their Technical Design.
• Currently leading the Functional and Testing Team for End To End (Entire System Integration of all application/ interfaces), MAGI Medicaid Renewals, Plan Management, Universal Access, Appeals and Data Conversion (from Legacy systems) tracks.
• Involved in migration of data from legacy systems to current system as per new ACA Mandate and MAGI guidelines. Worked to provide the functional and technical solution for Renewals and entire data conversion from legacy systems to current DC Health Exchange for all Social Programs.
• Immensely involved in Web services and Interface Testing of DCAS system with Federal and Local Hubs using SOAP UI Tool. Tested the integration of various systems and also web services exposed by internal and external systems.
• Also played the role of a Functional Manager in critical business processes and gathering key functional requirements for District Health Exchange system adhering to the US Health Insurance practices and HIPAA guidelines.
• Involved in gathering Functional Requirements and designing of Business Requirements Document and Functional Requirement Document.
• Developed the test plan for the tasks, dependencies and participants required to ensure the timely delivery of different testing milestones.
• Kept track of the new requirements / change in requirements of the Project.
• Conducted meetings with Business Clients, Developers, Release Management team and provided Status Report (Daily, Weekly etc.)
• Organized defect triage meetings and alarmed the various stake holders on-time for any risks.
• Involved in GAP Analysis and Technical Feasibility study with the technical Analysts and other SME's.
• Involved in creating User Manuals and providing Demos to the client on a regular basis after every internal release/sprints.
• Was actively involved in communicating the client's specifications and requirements to technical team and testing team on a regular basis.
• Created process flow diagrams in MS Visio depicting the flow of various functional areas like Appeals, Plan Enrollment, Universal Access, MAGI Renewals and Data Conversion.
• Conducted timely requirement review sessions, JAD sessions with the Stakeholders and business and end users to ensure the product verification.
• Handled Requirement Traceability Matrix (RTM) ensuring complete functional and test coverage
• Lead the Functional Team for development and review of Test Cases based on the Functional Requirements and Design.
• Lead the Functional Team for UAT Support for helping Business clients preparing, reviewing UAT test cases and execution of the same.
• Lead the Functional Team for providing demo for application walkthrough to UAT testers, Maintenance Team and Business users.
• Worked with CMS Team for providing Test Data in for QA and Pre-Prod Testing.
• Formulated manual test cases including Integration test case for various functional modules of DC Health Exchange like Appeals, Screening, Application Intake, Enrollment into a Health Plan, User Dashboard, Customer Upload involving upload of documents online, Case Creation and Management,, Life Changing Event handling, Broker Assistance, MAGI Renewals, etc.
• Lead end to end track involving complex functionalities, flow of information between multiple systems, interface etc.
• Involved in manual testing of below three applications which are integrated to achieve the implementation of the health care act (AAPCA) for District.

PROJECT NAME AND DESCRIPTION

Project Name: Oracle Loadstar Meter Data Management Program

Client Name: Confidential, CT

TOOLS/TECHNOLOGIES

• Lotus Notes - For Issue Database Management, tracking PM Plan, CM Plan, Defects, Issues, Procurement, and Training
• AQT – Database query tool
• SQL developer
• Mainframe
• QTP – For automation

RESPONSIBILITIES

• Played the role of QA Lead and Functional Lead
• Heavily involved in Requirement Gathering and Requirement Specification Documents preparation
• Defined and documented Test Strategy/Test Plan, Defect Management Strategy, Test Specifications, Test cases and Test Data requirements after analyzing relevant Functional Requirement Specification, Logging and tracking of issues till their closure, Ensuring quality of defects, Bug reporting, Testing, Status tracking.
• Communicated business requirements, goals, and directives to the technical team and served as client interface for managing user expectations and achieved client satisfaction.
• Formulated Quality assurance plan. Measured and monitored actual test results.
• Reviewed the UAT test strategy and scripts.
• Coordinated with different user groups to get the requirements and train them before the patch release.
• Reviewed and analyzed Business Requirements and assisted team Analyst in making the test plan, developed Test Cases and Test Procedures based on FRD.
• Performed Functional, Integration and security testing.
• Was aggressively involved in Regression testing, User acceptance testing and Performance Testing of the Oracle Lodestar Meter Data Management version 1.6 (MDM) and an inbuilt Customer centric application(C2) which offer commercial and industrial (C&I), billing, load research, loads forecasting and pricing, load profiling, and settlement and transaction management solutions for Northeast Utilities.
• Performed manual testing across various modules of MDM which covered Import Read file processing from collection system, Meter Determinant generation, MDM data validations and Estimation, Exception management and Work Queue processing, MDM meter configuration, Meter data readings, Usage analysis, Complex billing involving Bill printing, MDM reports, Totalization, Mass Rerouting, Reconciliation, Service Orders processing etc.
• Used QTP for automating the testing of various modules of MDM.
• Performed Backend testing of the application to check whether data was going on proper and designated database tables and checked the content retrieved on various windows against the database tables to make sure that the process retrieved all the customers' data by executing SQL queries.
• Was involved in the preparation of equilibrium report to track the system’s equilibrium across multiple levels starting from the batch upload of read file from collection systems, processing of reads into MDM,C2 and reconciliation between C2 and MDM.
• Managing and coordinating testing activities between In house teams (onsite and offshore). Analyst a team of 5 onsite testers and 17 offshore testers.
• Handled Requirement Traceability Matrix (RTM) ensuring complete test coverage
• Provided timely support to UAT team before going 'Go-Live'.
• Logged defects and tracked them using Lotus Notes till its closure.
• Interacted and communicated the status of test activities with the team members and coordinated with different teams for integration testing.
• Generated reports in Excel to show the test status of the test scripts and participated in the meetings to walk through the defect reports periodically.
• Actively involved in QA process improvement activities like process flow, problem resolution, bug tracking, etc.
• Prepared technical test flow documents to capture the backend behavior(using SQL queries) for various functional domains of MDM.

PROJECT NAME AND DESCRIPTION

Project Name: Design Manager Improvement Program

Client Name: Confidential, California.

TOOLS

• Microsoft Visio - For business process flows
• Toad – For querying the Oracle Database.
• Quality Center - For Issue Database Management, tracking PM Plan, CM Plan

My roles and responsibilities

• Played the role of QA Lead for Transmission and Substation Enhancement track.
• Was the single point of contact for TDBU Applications.
• Defined and documented Test Strategy/Test Plan, Defect Management Strategy, Test Specifications, Test cases and Test Data requirements after analyzing relevant Functional Requirement Specification
• Gathered business requirements by conducting detailed interviews with business users, stakeholders and Subject Matter Experts(SME's).
• Performed requirement gathering and in-depth gap analysis with different business groups in various areas of Transmission and Substation functionalities.
• Prepared Business Requirement Document(BRD).
• Converted Requirements into functional specifications.
• Prepared functional design document(FDD).
• Used MS Visio to create process flowcharts and Workflow diagrams.
• Communicated and interacted on a regular basis with the development team and testing team during different stages of the project to improve overall quality of the Application.
• Managed traceability Matrix to trace Business Requirements, Functional requirements and Use Cases.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Created a process document to Transmission Enhancement functionality. Arranged regular sessions with the client in explaining and helping them understand screen enhancement changes by walking through the screen designs. This effort was highly admired by the client as it helped them to relate their requirements to the new changes.
• Handled Requirement Traceability Matrix (RTM) ensuring complete test coverage.
• Performed User acceptance, Integration, System and End to End testing.
• Performed Back end testing of the Oracle server by writing extensive SQL queries using Toad.
• Logged defects and tracked them using HP Quality Center till its closure..
• Played a crucial role in complete end-to-end testing and defect fixing of the complex customizations.
• Performed functional and regression testing. User acceptance, Integration, System and End to End testing

PROJECT NAME AND DESCRIPTION

Project Name: BPI Scheduling

Client Name: Confidential, California

TOOLS

• IPM+ - Integrated project manage management tool for tracking PM Plan, CM Plan, Procurement, and Training
• Quality Center – Defect tracking tool
• SQL Developer
• Microsoft Visual Studio for VB.NET Code Development, Framework 1.1

RESPONSIBILITIES

• Requirement Gathering and Requirement Specification Documents Preparation.
• Had been involved in the development of the Application in the initial years of the Application Development Cycle.
• After corresponding years, defined and documented Test Strategy/Test Plan, Defect Management Strategy, Test Specifications, Test cases and Test Data requirements after analyzing relevant Functional Requirement Specification
• Designed and implemented Test plan and Unit test cases as per client’s requirements.
• Carried out recursive Black box (Functional) testing, reporting of bugs, Acceptance testing and Regression testing.
• Used Quality Center for test planning, defect reporting and executing the test cases.
• Good Knowledge of test metrics preparation and test status reporting.
• Performed backend testing using SQL
• Performed ETL Tool Testing