SUMMARY:

• Senior Business Analyst who is creative, analytic and results - oriented business professional. Determined and resourceful, quick to grasp new ideas and concepts and finds challenges stimulating. Strengths include excellent communication, problem solving, decision making, organizational, and time management skills
• Total 8 years of IT experience working as a Business Analyst along with performing various supporting activities like QA and SQL in different domains like finance, health care, media/entertainment etc.
• Excellent communication, presentation and project management skills.
• Expertise in employing SDLC Methodologies-Agile (Scrum) methodology, Rational Unified Process (RUP) and Traditional Waterfall Model.
• Proven excellence in analyzing business processes, eliciting requirements, defining business needs and translating it to BRD, FRD, and Technical Requirement Documents.
• Vast experience working with Stakeholders like Clients/Owners, SMEs, QAs, D evelopers, Testers and End Users.
• Worked extensively on various SQL Databases like MS SQL Server (2000, 2005, 2010), Oracle 8i, 9i, 10g, MS Access
• Competent in creating Requirement Traceability Matrix (RTM) to list all the requirements and ensured all required documents like Use Cases, Test Cases are written and compiled
• Extensively used tools such as Quality Center, Rational Requisite Pro, Rational Rose, Clear Quest, MS Visio, MS Office, MS Access, My SQL
• Proficient in analyzing and creating Use Case diagrams, Sequence diagrams, Activity D iagrams, Business flow diagrams using MS Visio and Rational Rose.
• Excellent organizational skills in conducting JRD/JAD sessions; Conducting walkthroughs, surveys and interviews, with a vast experience working with various cross functional teams.
• Collaborated with QA teams for creating and reviewing Test Plans and Test Cases.
• Excellent knowledge of MS Office especially MS Excel, Power Point, Access, Word etc.

TECHNICAL SKILLS:

SDLC Methodologies: AGILE, WATERFALL, SPIRAL

Documentation Tools: /Requirements Management MS-Word, MS-Excel, MS-Power Point, MS-Project, Visio, Requisite Pro, Rational Rose

Analysis/Modelling: UML, JAD/JAR, GAP Analysis, Business Process Mapping

Databases: My Access, MySQL, SQL Server, Oracle

Testing/Mgt tools: Quality Center, QTP, Bug tracker, Bugzilla

Languages: SQL, PL/SQL, Java script

Tool: SQL Developer, Salesforce, Peoplesoft CRM

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Senior Business Analyst

Responsibilities:

• Gathering requirements from the internal user team at Discovery and documenting that into BRD and FRD
• Eliciting requirements to the development team and
• Detailed documentation of business processes, including screen shots, Visio diagrams etc.
• Implement SDLC best practices.
• Worked extensively with the Discovery IT team on Oracle databases and wrote SQL queries to extract data based on certain filters and criteria decided.
• Maintain strategic oversight of solution oriented business process analysis and implementation of new technologies to support business needs.
• Manage and execute business systems maintenance/development/enhancement projects for Domestic Distribution.
• Develop business requirements and project plans Interface between business teams and IT Collaborate with IT on technical design and manage change requests
• Develop, manage & perform user acceptance testing Manage and monitor issues through resolution Develop implement and manage data and quality control procedures and work-flow efficiency .
• Develop and maintain procedures (PPM), Launch Authorization Forms, and reports to ensure efficient process and data management.
• Creating test plan, conducting UAT and storing test results
• Manage project teams and resources as needed Coordinate and manage training for new and current employee.

Environment: MS Visio, MS Excel, MS Word, Agile, Salesforce, AMS, MS SharePoint, Agile Methodology

Confidential, Washington DC

Business Analyst/QA

Responsibilities:

• Capture, organize and prioritize business requirements following Agile development methodology producing development artifacts in written and graphical, as appropriate.
• Created SQL Queries for Data and Report Verification and Validation testing.
• Assist software developers with incorporating into discrete development tasks in the form of a detailed work breakdown structure
• Work with insurance companies to resolve business issues based on electronic data exchanged between HBX and the insurers. This includes initial enrollment in a qualified plan, changes to enrollment including new dependents, and disenrollment.
• Identify, research, and correct issues with 834s and other EDI files. This is a manually correction process for each 834 not accepted by insurers, thoroughly document the data issues and provide resolutions
• Developed Flowcharts and rules documented to capture Other Party Liability (OPL) Logic - within Eligibility and Enrollment.
• Manually produce EDI files for cases requiring a manual 834 and provide support for EDI software development activities
• Performed stakeholder level testing before sending to business for UAT Testing
• View, acknowledge and identify potential data impacts to other business operations and systems based on understanding of HBX operations and data requirements as well as the insurer operations and business requirements.
• Worked with stakeholders to evaluate benefits, coordination of benefits,
• Data Analysis performed while doing monthly reconciliations with the carriers and other trading partners involved.
• Worked on testing and integrating new Dental carriers to the DC HBX system

Environment: MS Power Point, MS Excel, MS Word, Agile, Salesforce, Oracle B2B, AWS Server, Redmine, Oracle Server, Agile Methodology

Confidential

Business Analyst/QA

Responsibilities:

• Involved in development & documentation of Software Requirements Specification (SRS).
• Developed companion guide for Partners for EDI X12 transactions such as 834, 837, 835,270, 271 and 274.
• Involved in assessment of transition of standards from HIPAA 4010 to HIPAA 5010 and implementing ICD -10 codes to identify an efficient process flow for the transition.
• Involved in preparing a Web based PeopleSoft based CRM tool that automates EDI enrollment and Testing done for new partners in an automated way, reports the issues and this lead to shortened lead-time to production
• Developed detailed Use Case to describe the functionality of the system including eligibility and coverage transactions.
• Written & Executed SQL queries as part of data migration and back-end testing
• The responsibilities included analyzing and testing the user interface and constantly redesigning the system to increase its user friendliness for the clients.
• Implemented SDLC which included requirements, specifications, design, analysis and testing utilizing Agile methodology.
• Worked on various types of healthcare plans
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.

Environment: Windows 2000 Advanced Server, MS Visio, Agile, MS SQL Server, UAT, Rational requisite pro, Rational test manager, MS Power Point, MS Excel, Peoplesoft

Confidential

Business Analyst

Responsibilities:

• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
• Evaluate and process Explanation of Benefits statements.
• Ability to run reports and analyze them to determine problem areas and then present potential solutions to management.
• Perform special projects and tasks on an as-needed basis for management.
• Review medical record documentation and Care Tracker clinical data for accuracy of billing needs and care/treatments
• Collect business requirements, analyzed the root cause of the problems and developed use cases using MS Visio.
• Interacted with the QA team to develop test plans & test the test cases.
• Close interaction with designers and software developers to understand application functionality and navigational flow.
• The project is executed based on an onsite/offshore model. Effective communication and co-ordination with developers and also with the client as and when required.
• Monitor the successful completion of the quality initiatives at every step of the Software Development Life Cycle SDLC
• Periodic meetings with the offshore-team in design and the implementation of the change requests

Environment: MS Visio, Quick Test Pro, Orcas, Test Director, Dot Net 3.5, SQL 2005

Confidential, San Francisco, CA

Jr. Business Analyst/QA

Responsibilities:

• Developed/Communicated/Documented overall project plan using MS Visio.
• Involved in interviewing business area experts, asking detailed questions and carefully recording the requirements in the format so that it can be reviewed and understood by both business and technical people.
• Gathered user and business requirements through interviews, and observing from account managers and User Interface of the existing system.
• Performed on-line system data entry of corrected data.
• Worked as a liaison between technology and the business clients to improve business processes and support critical business strategies.
• Prepared business process models that include modeling of all activities of the business from conceptual to procedural level.
• Created Test Cases in the excel and export into Test Director/Quality Center
• Experience in performing PCI related data security standard engagements
• Contributed in making the Test Plan and create test summary report
• Supported Business analysts and Testers on any technical issues on testing tools.
• Created customized reports to track test results from Access database, such as Test status report and Defect report.
• Trained the appropriate staffs on the Test Director/QC
• Executed manual and automated test cases and accurately and concisely reported both progress and defect status.
• Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.

Tools: RUP, UML, MS-Office Suite, MS SQL Server 2000, VB6, Quick Test Pro, Crystal Reports, Clear Quest

Confidential

QA Tester/Programmer

Responsibilities:

• Reviewed the System document and user requirements.
• Divided various functional areas of the application into various Risk Levels for effective testing of the application
• Performed QA testing for Custom Modifications prior to Client installs.
• Done sanity testing to estimate testing readiness of the build for every release.
• Created different types of scenarios to run with the available virtual users.
• Manually tested the application for Smoke Testing and Regression Testing
• Found defects, entered and reported them in Test director.
• Categorized them based on severity and interfaced with developers to resolve technical issues.
• Responsible for weekly status updates showing the progress of the testing efforts and open issues to be resolved

Tools: JavaScript, Edit Plus, Netsuite, Test Director, Peoplesoft CRM application