PROFESSIONAL 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, and Object 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 comfortable working in a fast paced environment with minimal supervision.
• Exceptional problem-solving, presentation, and people management skills.

PROFESSIONAL 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 Quest,

Operating 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:

Confdiential

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.
• Worked as a Data Analyst.
• Participated in planning and creating environment for UAT. Tracked bugs found during UAT.
• 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, SharePoint 2013/2007

Confdiential

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 .

Confdiential

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.

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

Confdiential

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.

Confdiential

Business Analyst

Responsibilities:

• Implemented a structured system development methodology with emphasis on RUP Methodology that dramatically improved productivity and reduced errors.
• Worked with end users to identify business requirements.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution.
• Analyzed data to generate information about clients and their attributes like institution, site, and buildings. This data was structured and were pushed into tables.
• Walkthrough session of Business Requirement Documents BRD and Technical Specification FSD with technical team.
• Created Business Requirement Specifications using Rational Requisite Pro.
• 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.

Confdiential

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 .

Confdiential

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.