SUMMARY

• 7 years of industry experience as business analyst with solid understanding of business requirement gathering, evaluating data sources, translating requirements into specifications, application design.
• Diverse experience in Healthcare, Banking, and Insurance.
• Proficient in technical and business writing, business process flow, business process modeling, business analysis and testing various methodologies.
• Experience in facilitating Joint Application Development (JAD) sessions, and conducting GAP Analysis, SWOT analysis, Cost benefit analysis, and interviewing Business Users & SMEs.
• Active coordination with vendors for Issue resolution, estimation & design of Change Controls, and defect Tracking
• Very good understanding of SDLC (Software Development Life Cycle), and also involved in various phases like Requirements Analysis, Design, and Build & Testing.
• In Depth Knowledge of all phases of SDLC methodologies like Waterfall, and Agile (RUP, Scrum).
• Proficient in creating Business Requirements Documents (BRD), Functional Requirement Document (FRD), Business Systems Design and Requirements Traceability Matrix (RTM) by using MS Visio and Rational Suite for system implementation.
• Expert in writing detail system Use Cases, developing Business Test Cases, conducting User Acceptance Testing (UAT) and working with QA teams during testing phase to facilitate acceptance testing with stakeholders and business users.
• Conducting Feasibility and Risk Analysis to identify the business critical high - risk areas, and recommending solutions to management.
• Knowledge of Relational Database Management System (RDBMS), Data Warehouse, Extract Transform and Load (ETL), SaaS, Sales force, andObject Oriented Analysis and Design (OOA/D).
• Experience in creating automated reports from SQL and MS Access
• Excellent working knowledge in Project Life Cycle and clear understanding of Project Management
• In-depth understanding of the AS-IS and TO-BE business processes.
• Excellent working knowledge in Data Modeling, the process of creating a data model by applying formal data model descriptions using data modeling techniques.
• Excellent experience in analyzing and documenting the workflow processes for financial processing and reporting.
• Experience and skilled in creating and analyzing Data flow diagrams, Entity Relationship diagrams, and Logical Data Flow Diagrams. Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams by using Rational rose and MS Visio
• Coordinating efforts within a team of project managers, reporting Actual costs, projecting estimated forecasts, and evaluating reports on monthly basis.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Worked with Pharmaceutical data processing and knowledge on Pharmacy Benefit Management (PBM) Claims.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Strong team player with excellent interpersonal and communication skills. Self-motivated and focused individual with great attention to detail. Team builder with strong leadership qualities. Demonstrated initiative, drive and ability to manage multiple priorities.
• Self-starter and quick learner who is comfortableworking in a fast paced environment with minimal supervision.
• Exceptional problem-solving, presentation, and people management skills.

TECHNICAL SKILLS

Database: SQL SERVER 2000/ 2005/ 2008 R2, MS Access

Health Care Product: QNXT, NASCO claim engines, Portico Provider Manager and Claim check

QA Expertise: System Testing, Integration Testing, Regression Testing, END-END Testing

Tools: and Technologies: Visual Studio, Microsoft Office, Microsoft Visio, Clear QuestOperating Systems Windows Server 2003, Windows 8/ 7/Vista/ XP

Methodologies: Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Waterfall, Agile (Scrum & XP), Six Sigma.

Business Modeling Tools: Microsoft Visio, UML, Requisite Pro, Clear Case/Quest, Use Cases & Microsoft Project, Teleological DOORS, Rally.

Testing Tools: Win Runner, load runner, Quick test Pro, Quality Center and Test Director (Mercury Products). JIRA

PROFESSIONAL EXPERIENCE

Confidential, Olympia, WA

Business System Analyst/Tester

Responsibilities:

• Interacted with the Data Analyst (User/SME) by interviewing them, by preparing questionnaire.
• Gathered and documented the requirements in a specific requirement document (Report Spec document).
• Created mockups based on the requirements from the Data Analyst/Student Coordinator/Student Director on MS Visio.
• Determining sources for each field of the report or mapping each field of the report to its source data base by SQL. .
• Translating business rules in Pseudo SQL or in SQL.
• Developed Test Plan and Test Cases to be used in testing based on the business requirements.
• Developed Data Flow Diagrams, Process Flows, and Entity Relationship Diagrams in MS Visio.
• Maintained and kept track of stakeholders’ requests for enhancements and changes.
• Tested the application manually by executing Test Cases and Report data by using SQL, and documented evidences from the Testing.
• Submitted bugs found from testing and created task in TFS.
• Created Data Mapping document based on the requirements from Data Analyst and based on reporting requirements.
• Tested Data by SQL after ETL process to ensure data are loaded from source to target according to the business rules defined in the mapping document.
• Reconciled source files by using SQL to avoid Data Quality Issue during ETL process.. .
• Designed cubes based on the requirements from the User. .

Environment: Windows 7, MS-office, MS Visio, TFS, SQL Server R2, SSIS, SSRS, SSAS, .NET, D3 Visualization, Java Script

Confidential, Worcester, MA

Sr. Business Analyst/Project Coordinator

Responsibilities:

• Interacted with the “Users” by interviewing them, by preparing questionnaire and getting feedback.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Gathered and documented the requirements that are critical to the business. Analyzed and documented Business requirements and detail design of the software for full understanding of the business.
• Created Use Case Scenarios and documents work flow and business process. Used Requisite Pro to document requirements associated change requests with requirements and connected requirements with Use Cases.
• Performed Feasibility, Adaptability Study and Risk Analysis to identify the business critical areas from USER perspective. Worked on the business process using UML and Worked on use case documents for the enhancements on the Customer Service Application.
• Documented business workflows textually as well as in UML diagrams according to RUP, for the stakeholder review.
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders.
• Developing a work plan detailing the tasks and effort required to achieve HIPPA compliance.
• Communicating with employees, maintenance of eligibility, and preparation of administrative manual for ASO (Administrative Services Only).
• Developed the Test Plan, Test Conditions and Test Cases to be used in testing based on business requirements.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and plans accordingly, and conducted project related presentations.
• Coordinated with the Project Manager to define project milestones and project road maps using MS Project.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Supported the assigned project manager with creating detailed project plans; assisting in developing, scheduling and tracking project timelines. Supported project governance; and provided regular project communications to the project manager and business areas.

Environment: Windows XP/2000, MS-office, Web sphere, MS Visio, Rational Rose, HTML, XML, Rational Requisite Pro, Rational Clear Case, ASO (Administrative Services Only).

Confidential, Natick, MA

Sr. Business System Analyst

Responsibilities:

• Developed Data Flow Diagrams, Work Flows, Process Flows, and Entity Relationship Diagrams in MS Visio, and analyzed them to create “AS IS” and “TO BE” scenarios.
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Facilitated JRP sessions between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Conducted JAD sessions, created Use Cases, Work Flows, Screen Shots and Power Point presentations for the Web Applications.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases).
• Followed the adaptive RUP framework for the whole Project life cycle (PLC).
• Fine-tuned search engines and pulled data from different databases and migrated data back and forth using SQL.
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, OOAD, Visio and Business Process Modeling.
• Teamed up with both internal and external software development groups to provide functional requirements specifications in form of Use Cases, Business Process Flows, and Prototypes and management reporting requirements.
• Assisted in Data Mart/Data Warehouse Design and Prototyping.
• Worked on following applications Business Objects, Enterprise Architect, Toad, Plainview (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project).
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.

Environment: MS-Project, MS-Office Suite, MS Visio, HPQC, Windows XP/7, Oracle, Mainframes, .NET Java, J2EE.

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly for implementing new system.
• Involved in requirement gathering using Rational Requisite Pro, which included interviews, brainstorms and meetings with stakeholders.
• Identified the current business process, documented the work flow and improved the efficiency of the current business process.
• Understand of Posting, Check payment, ACH, Mortgage, Lockbox, Fraud and Exceptions.
• Extensively involved in Accounts migration and Data migration from the core Sovereign system to proprietary Santander system.
• Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams using Microsoft Visio 2007.
• Involved in the creation and maintenance of the Workflow plans and artifacts for all the waves.
• Involved as a SME in the designing of the Posting file and the Database used to verify the posting process.
• Involved in the writing the SQL queries and managing the Oracle database for the Posting process.
• Maintained and kept track of stakeholders’ requests for enhancements and changes using Rational Clear Quest.
• Expertise in Performance Management, Asset Management, Credit Management and implementing its benefits.
• Understood the business logic, User requirements, and test-objectives to develop test plans, test cases, and test case execution using Test Director.
• Tested the application manually by executing Test Cases prior to Automation.
• Involved in automating test cases using QTP and Load Runner.
• Performed all kinds of testing including regression, system, integration, end to end, smoke, functional, back end and front end testing.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Involved in preparing a simple and detailed User manual for the application, for the intended users.
• Provided training to the Users and explaining them the Business as well as the Technical side of the Proprietary Santander system.

Environment: Agile, SDLC, Erwin, Microsoft Office 2007 (Word, PowerPoint, Access, Excel Macros and Pivot, Outlook, Project, Visio), Rational Requisite pro, Rational Clear Quest, QTP, Load Runner, Mercury Quality Centre, SQL, Oracle 10g Java, SQL Server Reporting Services SSRS.

Confidential, Orlando, FL

Business Analyst

Responsibilities:

• Implemented a structured system development methodology with emphasis on RUP Methodology that dramatically improved productivity and reduced errors.
• Created Business Requirement Specifications using Rational Requisite Pro.
• Walkthrough session of Business Requirement Documents (BRD) and Technical Specification (FSD) with technical team.
• Analyzed data to generate information about clients and their attributes like institution, site, and buildings. This data was structured and were pushed into tables.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Worked with end users to identify business requirements.
• Actively involved in Data Modeling thereby making sure all the data elements were covered that would be required in future reporting. Ensured accuracy of data sent down-stream, and maintained documentation of the process.
• Conducted workflow, Process diagram and GAP analysis to derive requirements for existing systems enhancements.
• Performed testing using Mercury products (Win runner and test director).
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).
• Involved in analysis of Requirement Specifications and planning by formulating Test Strategies, and Test Cases in Test Director 8.0 for the Functional, Integration, Security and smoke testing.

Environment: Quality Centre, Rational Rose, HTML, UML, XML, RUP, MS Office, MS Visio, MS Project, Dot Net, Java, Oracle, DWH, SQL, RDBMS, Win Runner, Test Director.

Confidential, Atlanta

Business Analyst

Responsibilities:

• Requirements Gathering from the client.
• Review of project deliverables.
• Client Communication- Attend Status updates meetings, highlight issues and risks.
• Prepare design documents.
• Following project processes.
• Test Planning and Scenario Design, Test case Development, Test Execution and Test Result analysis.
• Involved in testing 4 different Applications and Reports.
• Testing the interfaces.
• Maintaining Customer defect tracker and updating the defect statistics.
• Onsite- offshore co-ordination.
• Involved in ASO (Administrative Services Only) by evaluating and arranging employee benefit plan.

Environment: Rational Requisite Pro, MS Project, MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio, MS SQL Server, and ASO (Administrative Services Only).

Confidential

Business Analyst

Responsibilities:

• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Worked as Data Analyst, Involved in requirements gathering to study the existing system which will help in the designing process for the proposed systems.
• Involved in Requirement Analysis and understanding of business analysis and creating a design work flow.
• Designed ER diagrams and created level 3 Process models.
• Created the Logical/Physical Data models, defining attributes and Relationships using the ERWIN 3.5.
• Created database objects like tables, views, procedures, packages using Oracle tools like PL/SQL developer and SQL* Plus.
• Designed and developed a custom package which extracts supplies used by the customer, information about current stock in inventory.
• Created and worked with different database objects like Sequences, Synonyms Indexes and Views.
• Provided programming and business analysis support for the design, development, and application testing.
• Developed Use Cases for all the External /Internal Trigger events.
• Administered and maintained Concord e-health, an enterprise NMS server
• IP address management as the network consisted of large no. of nodes, switches, L3 switches and routers.
• Made monthly MIS reports that consisted of various network parameters like downtime, load, delay, bandwidth usage etc. using reporting features of Concord e-health NMS.
• Team member in various video conferencing events, worked on Polycom, RAD and Tandberg video conferencing endpoints.
• Designing, implementing and supporting networks, maintaining, updating the LAN diagrams of the site. Managing IP allocation and ensuring minimal downtime of machines.
• Responsible for client connectivity, ODC maintenance, LAN monitoring, LAN establishment.

Environment: Java J2ee, Windows XP, MS Visio, MS Project, MS Office, MS SQL Server.