SUMMARY

• Highly motivatedBusiness analystwith7+years of experience in IT industry with core competencies to handle and resolve critical quality problems using research abilities, with experience in telecom and healthcare clients.
• Well versed in in - person as well as live meeting, Joint Application Requirements (JAR) and Joint Application Development (JAD) sessions.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Elicit requirements using interviews, document analysis, requirementsworkshops, business process descriptions, use cases, scenarios, business analysis, and workflow analysis.
• Createdand maintainedupdated documentation on business processes, applications and business solutions including process flows, use cases, functional specifications, test cases, training and system manuals, and job aids.
• Worked as liaison to the business stakeholders to understand the business problems and recommend viable solutions.
• Worked proactively with SMEs, business users and other team members to identify business rules and calculations. Extensive Experience working with query languages like SQL.
• Experienced in working with QA team to develop theTest plans, Test scenarios, Test procedures and Test cases. Very StrongSQL skills (writing queries and verifying data).Solid understanding of databases, data ware house, OLTP, OLAP, Data Modeling.
• Excellent verbal and written communication skills and interfacedwith Senior Managers and various other levels of management, subject matter experts using presentation skills.
• Experience in analyzing and creating Use Case Diagrams, UMLdiagrams, Activity Diagrams, Data Flow Diagrams, Workflow Diagrams, Wireframes, Class Diagrams, and Sequence Diagrams using MS Visio, IBM Rational Software Tools.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Experience in ETL process testing, and ETL process using Informatica.
• Well versed in rational tools including MS Visio.
• Strong in ETL data validation using Informatica ETL environments. Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Experience working with HIPAA x12; transactions such as 837, 835, 834, 278, 270, 271 and Claims processing in Medicaid and Medicare, healthcare claim engines.
• Report development experience utilizing SQL Server, Microsoft Excel.
• Developed & executed several Optimized queries in SQL on this data.
• Excellent knowledge of C#, VB, Java, XML, DOM, .NET, VBScript, HTML, and Web Services
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Expert knowledge of the preparation of Requirement Traceability Matrix using the Quality Center, Test Director or Microsoft Excel.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users as well as trained users to use the system configured.
• Expert with Excel - including Vlookup, Sum Product, and Data Base functions, Subtotals, Pivot Tables and Macros.
• Extensive knowledge of QA methodology, Standards with strengths in ISO 9000, SEI-CMM Procedures, experience in ALM.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP/7/8 and UNIX

Browsers: IE7/8/9, Mozilla Firefox 3/3.5/3.6/4.0/5.0

Databases: MS SQL Server, MySQL, Oracle, Google Chrome

ETL tools: Informatica 9.X/8.X/7.X (PowerMart/Power Center)

Testing Tools: QTP 8.2/9.0/9.2/10.0/11.0 , Test Director, Quality Center 8.2/9.0/9.2/10.0/11.0 , ALM, UI and Clear quest

Others: MS Office, SQL Server Management Studio and VMware

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior Business Analyst

Responsibilities:

• Conducted live JAR sessions to Elicit, Analyze and Document Business Requirements from the Business. Conducted series of sessions with Business People and IT People to bridge the gap and to translate the Business Ask to the IT product.
• Thorough understanding and hands on experience of software development life cycle from Ideation to Implementation. Worked in close co-ordination with Business People, Architects, Developers, Testers and Project Managers and also at times reported to the higher leadership.
• Principally authored the following documents: Business Requirement Documents, High Level Requirements, Functional Requirements Documents, Requirement Traceability Matrix, Quality Requirements, Functional/Stakeholders Requirements, User Stories and Testing Documentation like Test Plan, Test Cases etc.
• Responsible forData ManipulationandData ValidationusingSQLqueries in Oracle SQL developer.
• Worked extensively on Spreadsheets, Word Documents, UML Diagrams (Use Cases).
• Extensively used Quality Center to upload requirements, write test cases.
• Provided assistance to team members to clarify functional and technical difficulties.
• Used Quality Center to Report, track and, monitor defects.
• Experience in ETL process testing, and ETL process using Informatica, Test ETL software using Informatica.
• Tested the data load process using the Informatica Power Center ETL tool and Tested several business reports like Dashboard, Drill Down, Slice and Dice, Master Detailed Reports and Scorecard formats with process analytics
• Used parameterization function to un different data in QTP
• Involved in Developing Test Incident reports/Test Metrics.
• Developed QA documentation including test plans, test cases and Facilitated Automated testing
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data. Executing Test Scripts as part of daily responsibilities.
• Involved in Keyword driven approach for automation to minimize the changes for QTP Scripts for future use.
• Written SQL Queries manually for validation of data, involved in User Acceptance testing.

Environment: Quality Center 10.0, MS Word, MS VISIO, SharePoint, QTP 10.0, Windows 2000, Windows XP, SQL Server, UNIX, Microsoft Excel, ETL Informatica, Spreadsheet, XML

Confidential

Business Analyst

Responsibilities:

• Conducted JAD sessions with SMEs, and all the placeholders to develop High Level Requirement and then formalized those requirements to Detailed Level Requirements.
• Conducted series of sessions with Business People and IT People to bridge the gap and to translate the Business Ask to the IT product.
• Responsible for serving as a liaison between the business owners/users and members of the technical support team along with other technical/development team on projects.
• Responsible for building and fostering trust with business owners to establish strong internal business relationships by listening and completing projects fulfill the user’s needs.
• Responsible for using business analysis tools to elicit accurate information from subject matter experts to document requirements, create use cases, map process flow charts, and produce data modeling/mapping.
• Responsible for interviewing, gathering, recording and translating the user needs and wants into requirements for the development team.
• Responsible for coordinating efforts among various project team members including testing team, developers, data analysts and business users. Responsible for recording, defining, submitting (for approval), and tracking all project display terms.
• Identifying entitlements and access issues pertaining to specific streams and user groups and their touch points with other systems.
• Responsible for identifying various business needs and requirements and presenting them to the user. Developed the process for implementation of these requirements.
• Developing test scripts and test cases for various releases of the project.
• Developing Business Requirement Document and Use Cases.
• Researched, analyzed, synchronized, maintained, modified, interpreted, validatedand preparedAS IS to BE data and documentations for the development team.
• Followed RUP methodologies during the course of the project.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Provides ongoing application support to users in order to solve business application related issues including the training of system users in the different major business applications; implementing software application which will improve business processes and in modifying current systems to accommodate changing business requirements.
• Developed QA documentation including test plans, test cases and Facilitated Automated testing
• Experience in ETL process testing, and ETL process using Informatica
• Authored & Executed SQL queries to validate that actual test results match with expected
• Results.
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data. Executing Test Scripts as part of daily responsibilities.
• Working closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process.
• Tracking & Reporting of defects.
• Conducted Data Validation checks by comparing the UAT backend Database and the Production Database (this was done when the UAT database was updated and almost in synchronization with the Production database).

Environment: Web Logic Server, MS Visio, MS Excel, ALM (Quality Center), QTP, SQL Developer, Oracle, DB2, Windows 7, MS Office 2010, SharePoint, ETL, XML.

Confidential, San Jose, CA

Business Analyst

Responsibilities:

• Performed a project analysis on new projects, including requirements, personnel, and costs.
• Developed and maintained a work plan for system projects.
• Responsible for the execution for the project life cycle, including requirements gathering, design, testing, implementation and documentation, as required.
• Strong visual modeling and business process modeling skills inRational Unified Process (RUP) and Agile Modelingwith tools likeMS Visio.
• Identifying entitlements and access issues pertaining to specific streams and user groups and their touch points with other systems.
• Responsible for identifying various business needs and requirements and presenting them to the user. Developed the process for implementation of these requirements.
• Developing test scripts and test cases for various releases of the project.
• Developing Business Requirement Document and Use Cases.
• Provided reports and other documentation on projects to client and internal staffs, as needed.
• Worked with team leaders and supervisors to ensure project and organizational deadlines are met. Involved in835 files validations for HIX at Claim level,Line level, Service level and Transaction level.
• Extensively involved inBatch interfaces andMMISbatch jobs in setting up, running and debugging job runs.
• FacilitatedICD9-ICD10conversionrequirement gathering session and created high level Business Required Document.
• Organized and conducted extensiveJADsessionswith users to identify and understand requirements.
• Extensively usedSQLqueriesand procedures for data validation in both source system and target system.
• Responsible for doing the gap analysis for the interfacing system.
• Documented theBusiness Requirements Document (BRD)and theFunctional Specification Document (FSD).
• Reviewed various customer transactions using theFACETSapplication.
• Analyzedandinterpretedstatehealth exchange (HIX)information by attending daily meeting with various states exchange.
• Involved inforward mappingfromICD9toICD10andbackward mappingfromICD10-ICD9throughGEM.
• Documented issues and resolutions, and wrote specific requirements for system changes.
• Managed the entireUAT set up & UAT testingeffort with the Business users.
• Participated in weekly status meetings to present status and in corporate any digressions from the original scope.
• Worked with the clients on the final signing process in theUser Acceptance stages.
• Wrote defects using HP Quality Center, Analyzed test results using reports and graphs generated in Quality Center.

Environment: Quality Center, Java, SQL, Oracle, BPT, VB Script, XML

Confidential, Wilmington, DE

QA Analyst

Responsibilities:

• Involved in different phases of SDLC.
• Interacted with Business Analysts to designed detailed test plan document for application testing.
• Provided assistance to team members to clarify functional and technical difficulties.
• Analyzed functional specifications from the front-end application with reference to requirement documents. Involved in creating Test Plan for the application.
• Conducted integration testing for several modules for Cash Wire Application.
• Extensively used Quality Center to upload requirements, write test cases.
• Used Quality Center to Report, track and, monitor defects.
• Produced Requirements Traceability Matrix to support the application development.
• Involved in Developing Test Incident reports/Test Metrics.
• Prepared Master Detailed ETL and BI Test Plan for the entire Project.
• Performed End-to-End testing for the entire ETL and Business Intelligence.
• Developed Test Plans based on Test Strategies and Developed scripts, utilities, simulators, data sets and other programmatic test tools as required to execute Test Plans
• Created MS Word, and MS Excel templates to upload the test cases directly to Quality Center using the inbuilt tools.
• Developed a testing strategy for all upcoming data feeds for both ETL and BI arena.
• Prepared traceability matrix for point’s requirements from the completed test cases.
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports.
• Tested developed test harness that will assist the testers use the commonly used functions and test scenarios and reduce the redundancy of automation scripts
• Written complicated SQL Queries manually for validation of data.
• Responsible in running Unix Shell Scripts for different server process.
• Performed browser compatibility testing using different browsers like IE, Fire Fox etc
• Validated data of the application with the SQL version in order to check the data integrity of the new version with the older version.
• Developed SQL Queries for checking the Data Transaction.
• Involved in User Acceptance testing.
• Provided regular status updates to the project manager on high priority issues.

Environment: Quality Center 10.0, QTP 10.0, VB Script, ASP.Net, FIX protocol, C#, Windows 2000, Windows XP, SQL Server, UNIX, Microsoft Excel.

Confidential, Freemont, CA

QA Analyst

Responsibilities:

• Created Test Plans and Test Scripts by analyzing the Business requirements and System Requirements of the Application.
• Worked closely with a project team for gathering the business requirements and interacted with business analysts to translate business requirements into technical specifications
• Involved in physical and logical design of the applications.
• Worked closely with Application Architects, Business Analysts, Project Managers to discuss and collect business requirements
• Developed detailed Testing Strategy for the entire application and developed various test cases.
• Functional testing the new developments / enhancements.
• Analyzed and tested various reports produced by the application.
• Developed Manual scripts using Quality Center to perform functional and regression testing.
• Conducted Functionality testing during various phases of the application
• Performed UAT Testing
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Created test data for testing specific billing functionalities.
• Work involves testing and reporting bugs using bug-tracking system (Mainframe Based System) and verification of bug reviews with Development team.
• Used Parameterization to fetch data to test the application using QTP
• Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP
• Working extensively towards testing the performance of the whole application

Environment: Quality Center 10.0, Team Tracker, Quick test professional, MSOffice, XML, Agile, SQL, Internet Explorer 9.0, Unix and Windows 2000.