PROFESSIONAL SUMMARY

• About 9 years of professional and diverse experience as a Business Analyst and exposure within various industry domains, such as Banking, Health, Insurance, Investment Banking and Retail.
• Strong knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP) methodology, and Project Life Cycle.
• Sound understanding of Object Oriented Analysis and Design OOAD, and proficient in documentation of As - is and To-be business processes.
• Expert in delivering under complete SDLC methodology (requirement, analysis, design, data modeling, business process modeling, implementation and deployment).
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema.
• Extensive experience in creating Business Requirements Documents (BRD), Use Case Specifications, Functional Requirement Document (FRD), Functional Specifications Document (FSD), Requirement Traceability Matrix (RTM), and Responsibility Assignment Matrix (RAM).
• In-depth knowledge of RUP; risk engineering, data modeling and mapping, and design using UML (Unified Modeling Language), Rational Rose, and MS Visio.
• Proficient in facilitating Joint Application Development (JAD) and Joint Application Requirement Capturing (JAR) sessions for gathering user requirements and understanding of the business process.
• Expertise in creating Test Plans, Test Scripts and Test Cases from the Requirements documents for distinguished testing efforts viz. Integration, System, Functional, Regression, Performance and User Acceptance Testing (UAT).
• Extensively used Test Director to maintain test cases and test scripts.
• Proficient in coordination of defect management and monitoring the status using HP Quality Center.
• Strong knowledge of Data Warehousing concepts and Dimensional Modeling and exposure to Data Modeling, Normalization, and Business process Analysis.
• Experienced in Extract, Transfer and Load (ETL) processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts, and OLAP technologies.
• Expert at enterprise business process modeling tools like MS Visio, MS Project, Rational Rose, Rational ClearQuest, and Requisite Pro.
• Experienced with web 2.0 technologies and testing of the n-tier architecture, web based applications, and client server applications.
• Effectively coordinated with the Onsite, Offsite and Onshore teams during the projects.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Detailed oriented with excellent negotiating skills, interpersonal skills, problem solving skills, time management and ability to prioritize, and handle multiple tasks on a day-to-day basis.

TECHNICAL SKILLS

Operating Systems: MS Windows NT/98/2000/ME/XP/Vista, Unix, Linux, Macintosh

Databases: Oracle, MS Access, MS SQL Server

Requirement Management Tool: Rational Requisite Pro

Debugging/Testing Tools: Bugzilla, HP Quality Center, Quick Test Professional (QTP), Load Runner, Rational ClearQuest, SOAP UI, Selenium IDE

Modeling Tool/ Versioning Tool.: MS Visio, Gliffy, Rational Rose, MS SharePoint

Other Tools: MS Office Suite, Putty, Toad, VMWare, Pumori III plus

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, TX

Responsibilities:

• Coordinated multiple projects simultaneously related to Mortgage Banking applications to enhance originations, servicing and underwriting operations.
• Worked with the business, program management team and developers nationally and offshore in all four phases of the requirements development
• Developed Business Requirement Documents (BRD) from business into Functional Specification Documents (FSD) with technical details/specifications for development effort purposes post technical analysis and evaluation.
• Developed Traceability Matrix documenting and one to one mapping of all BRD and FSD requirements with technical specifications, application details to facilitate Testing and Production effort.
• Coordinated with LOB representatives to gather, verify or clarify User Requirements and receive approvals for initial requirement detail, Use Cases, Data Flow and Activity Diagrams.
• Created and Executed Oracle queries for data extraction, valuation and manipulation and data mining experience to analyze data stored in data warehouses
• Fully involved in all four phases of the SDLC requirements, analysis, specification and validation; creation of Systems Requirement Specification, Functional Spec Document, Technical Design Document.
• Proficient in MS Excel to use Pivot tables creation/execution to summarize large data amount
• Requirements management; update and storage; defect creation and tracking; traceability of business, functional, design documents using Quality Center and JIRA.
• Worked intensely with QA and Development team creating Test Documents like Test Plans and Test Cases for Unit, Regression and Smoke Testing.
• Coordinated routine Agile sprints between all project stakeholders to discuss release status; project status; requirements and updates; defects/issues and resolutions; validate next steps and execution.
• Prepared various Training and Testing materials for User Acceptance Testing (UAT) for clients.
• Worked on SharePoint site with updated documentations, FSDs, TMs using built-in tools.

Environment: MS-Office Suite (Word, Excel. PowerPoint, MS Visio, MS Project), Data Warehouse, Windows XP, SDLC, Oracle, PL/SQL & Java, C, Data Analysis, JIRA, Quality Center

Confidential, CA

Senior Business Analyst

Responsibilities:

• Gathered Functional, Non-Functional Business Requirements and created detail FSD.
• Worked with business users to define product feature, business requirement specifications and change request.
• Created RAM to assign roles and responsibilities of team members.
• Carried out GAP analysis to study the current system and documented new changes and features that need to be added.
• The SDLC methodology followed was (SCRUM).
• Gathered issues about the proposed functionalities and other requirements pertaining to the project via interviews, JAD, brainstorming sessions, user feedback/suggestions etc.
• Conducted JAR session to understand As-is situation, identify current business problem, analyze causes, and capture business requirements and business rules.
• Worked closely with project manager in planning and implementing modules on multiple accounts, protecting auto pay and save - Personal savings and security alerts.
• Conducted meetings with Offshore Development team and worked as liaison between development team, and Business team.
• Created BRD and FSD using Rational Requisite Pro by taking inputs from multiple teams.
• Used UML models to design Use Case diagram, Workflow, Activity diagram and Sequence diagrams in Rational Rose.
• Created and maintained the RTM to trace the progress throughout the project, designed non-functional requirements using Mock-up screens.
• Designed user authentication, application security and documents to avoid security breaches and assisted in developing authorized user verification, automatic time outs and personal security key using Oracle FLEXCUBE Direct Banking.
• Prioritized issues and defects to ensure maximum utilization of resources and delivery of critical functionalities and minimize change requests.
• Worked closely with the QA Team to create Test Plans, Scenarios and test cases along with the scripts for UAT and getting QA signoff.
• Assisted the technical team in documenting FAQs, help manuals and online demo for the new functionalities and provided training for internal users.

Environment: MS-Office Suite (Word, Excel. PowerPoint, MS Visio, MS Project), Data Warehouse, Windows XP, SDLC, SQL Server, Data Analysis, Quality Center

Confidential, NC

Senior Business Analyst

Responsibilities:

• Gathered requirements from key stakeholders, customers and SMEs to define the scope and requirements of the robust policy management application and further developed system requirements specifications encompassing functional and non functional requirements.
• Used JAD sessions, interviews and developed questionnaire to elicit the requirement gathering and further preparation of Use Cases.
• Worked closely with the development team in waterfall environment to verify that the business needs are fulfilled and deliverables are produced within specified budget, quality and time.
• Involved in writing Use Cases, UML Model/ Activity Diagram and User Acceptance Criteria and further developed verification and validation of requirements at all levels so that the implemented software successfully fulfilled user expectations and business needs.
• Analyze system requirements and formulate scenarios in Test Manager for the functionality, navigation, stress, security, recovery and performance testing of the application.
• Coordinated quality assurance teams effort in re-creating various production issues in test environment.
• Determined and documented the As-Is and the To-Be (future) business process flows and performed return on investment analysis.
• Mapped data for the ETL process and wrote detailed specification for the ETL and Reports.
• Assisted in generating the master data and tested the master data and further assisted in development of ETL programs and resolved issues while ETL.
• Supported the UAT for reports, ETL and MDM access.
• Performed data analysis using SQL queries. Created Report-Models for ad-hoc reporting and analysis.
• Implemented OLAP reporting system to provide business intelligence capability for Asset Managers.
• Identified the reporting needs for decision makers and helped in realizing the reports needed by managers.
• Extensively used remedy for change and configuration management and provided necessary training for transition.

Environment: MS Visio, MS Project, UML, Agile, Rational Rose, Rational Requisite Pro, Microsoft Office Suite (Word, Excel. PowerPoint), SQL, Data Warehouse

Confidential, PA

Business Analyst

Responsibilities:

• Supported Senior Business Analyst in developing Business Models.
• Conducted JAD sessions to elicit business and system requirements.
• Created BRD, and then converted BRD into FRD.
• Analyzed requirements to ensure that established acceptance criteria for requirements are met.
• Participated in formal requirement review sessions with Stakeholders and Development team.
• Conducted Gap analysis and documented inconsistencies arise during Project.
• Prepared Prototype Model, Context Diagrams, and Activity Diagrams using MS Visio.
• Wrote Use Cases to demonstrate Business requirements to Development team.
• Strong knowledge of HIPAA rules to store the transactions. Monitored all the HIPAA transactions through the gateway.
• Assisted in developing Test Scenarios and, participated in Regression and UAT.
• Managed requirements and identified inconsistencies with Project plans and work products.
• Interacted with the Subject Matter Experts (SME) to gather information about the Health care enrolment, Billing, and Health care claims processing. Checked whether they processed correctly or not.
• Monitored all the HIPAA transactions through the gateway.
• Worked closely with Technical team to ensure Testability of requirements.
• Assisted QA team to Examine, analyze and create Test Plans, Test Cases, and Test Procedures based on RUP.
• Created RTM to trace requirements and manage Change Requests.

Environment: HTML, CSS, XML, MS Visio, MS Excel, Quality Center, SQL

Confidential

Business Analyst

Responsibilities:

• Engaged with Project Manager in identifying the key stakeholders, SMEs and User Groups/ Focus Groups and formulated strategies to gather the requirement solutions.
• Involved in writing Test plans, Creating Test scripts, coordinating QA Team for documentation, Black Box testing.
• Analyze system requirements and formulate scenarios in Test Manager for the functionality, navigation, stress, security, recovery and performance testing of the application.
• Coordinated quality assurance teams effort in re-creating various production issues in test environment.
• Developed Test Harness using SQA Basic that contains generic functions for the automation scripts and for testing front-end interfaces.
• Involved in a cross-functional team to improve the customer’s “out of box” experience; simplifying the product login, increasing customer satisfaction and security and converting more evaluations into real time cost effective solutions.
• Wrote test cases for positive and negative scenarios for functional and security testing.
• Prepared test data for the entrance and exit criteria in integration testing.
• Conducted automation Regression Analysis for several internal releases and assisted in automating test cases for regression testing using Robot.
• Involved in Back-End Oracle database verification manually as well as using Rational Robot.
• Used Test Manager to generate load and create scenarios to test the behavior of the applications.
• Analyzed the Transaction results, Virtual User status results and generated reports.
• Worked hand in hand with developers in resolving critical issues.
• Documented the defects and their trailing history in the Clear Quest for internal evaluation of the product.
• Upgraded / maintained QA databases and automation scripts.
• Worked with application design team in learning the UNIX internals and the behavioral characteristics of the network.
• Documented the defects and their trailing history in Test Director.
• Extensively used remedy for change and configuration management.
• Managed critical paths and bottlenecks in conjunction with Project Tracking Reports for Senior Management with the help of UML and results generated from QTP and LR scenarios from one or ‘n’ users plugging into the online banking application.

Environment: SDLC, MS office Suite (Word, Excel. PowerPoint, MS Visio), SQL, LINUX, MS Project

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements from various departments to ensure the data is migrated to work with the new systems and the downstream applications, and associated Business Processes.
• Developed all BRD and FRD pertaining to automate exchange and refund process for ticketing, and sales transaction.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Prepared and delivered progress reports to the project manager about the day to day progress.
• Setup meetings to clarify ambiguities and resolve issues and prepared spreadsheets, forms, agendas, policy, and procedures.
• Worked specifically with the Customer Relations line of business, evaluating opportunities for systems solutions that will maximize business value.
• Reviewed design documents & business requirements to learn the scope and purpose of the application.
• Accumulated system requirements from various departments like accounting department, customer representatives and other shareholder through surveys, interviews and JAD sessions.
• Conducted Gap Analysis to study the existing system and document the changes that need to be made and new features that need to be added.
• Updated and modified progress and resources allocation in MS project for the team.
• Business Analysis for this project was done using the Rational Toolset and RUP based methodology to describe the existing processes using Use Cases.
• Created UML models, including Use Cases, Sequence, State and Activity diagrams using tools such as Rational Rose and MS Visio.
• Used Rational Clear Quest for defect tracking and prioritizing defects and for enhancements after base lining the requirements.
• Prioritized issues and defects to ensure maximum utilization of resources and delivery of critical functionalities and minimize change requests.
• The entire system was automated to refund ticketing and other sales transactions in the business system.
• Designed the look-n-feel or non-functional requirements of the application through Mock-up forms for better illustration of the application to construction managers and field representatives who were based remotely.
• Responsible for continuous process improvement and for identifying and maintaining clear and understandable documents for workflow, user acceptance training and reference materials.

Environment: MS Visio, MS Excel, MS Project, MS FrontPage, SQL, Rational Rose, Rational Clear Quest

Confidential

Business Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stakeholders and conducted document analysis.
• Responsible for conducting JAD Sessions with different IT Group department managers & refined the requirements.
• Created User Requirement Specifications and Functional Requirement Specifications documents.
• Created UML Diagrams like Use Case Diagrams and Activity Diagrams using MS Visio and created wire frame diagrams.
• Developed process flow diagrams in MS Visio to better explain the business and IT processes to the various teams.
• Created RTM to keep track of the requirements.
• Involved in Test Case/Test Plan development based on Business Requirements and UAT and reported the defects using Test Director.
• Conducted walkthroughs, UAT sessions and supervised the development of User Manuals for customers.

Environment: MS Word, MS Visio, MS Excel