SUMMARY

• Over 7 years’ experience as a Business Analyst in the finance domain with solid understanding of Business Requirements Gathering tools and techniques.
• Exceptional problem solving skills in implementing innovative business processes and providing State - Of-The-Art solutions using new approaches and technology with focus on Investment Banking, Private Banking, Wealth Management, Online Bill Payment, Cash and Treasury Management, Transaction Risk Management (Deposits, Credit Card / Debit Card Frauds), Property and Casualty Insurance and Auto LoB.
• In-Depth understanding of Key Regulatory Requirements such as KYC, Basel II, Sarbanes-Oxley Act (SOX) and BSA/AML.
• Conducted Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating prototypes, user interface.
• Rich hands-on experience in facilitating Joint Requirement Planning (JRP) sessions between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis.
• In-depth understanding of the Software Development Life Cycle (SDLC) Methodologies like Waterfall, RUP, Agile-Scrum and RAD.
• Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as MS SharePoint, MS Project, MS Excel, MS Access and MS Visio.
• Exceptional Inherent skills to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Rich hands-on experience on Software Testing Life Cycle (STLC).
• Strong experience in collaborating User Acceptance Testing (UAT) and documenting of Test Cases. Great Expertise in designing and developing Test Plans and Test Scripts.
• Good experience in SQL query skills in analyzing and validating database, data ware house processes.
• Exceptional ability to create and track issues raised in JIRA.
• Excellent knowledge of Business Process definition, Risk Analysis, and Use case Analysis.
• Proficient in Cost-Effect Analysis, ‘As-IS’, ‘To-Be’ Gap Analysis, Feasibility Analysis and Root-Cause Analysis.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills to work extensively with QA team, the developer team as well as the management team.
• Exceptional leadership qualities to work with clients, management and staff to establish and maintain consistent element definitions across project environments and development methodologies.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, RUP, Agile-Scrum, RAD

Testing Tools: Rational Enterprise Suite (Rose, Clear Case, Clear Quest), Load Runner, Win Runner, DOORS

Business Tools: MS SharePoint, MS Visio, MS Excel, MS Office XP/ 2000/2010/2013

Databases: SQL Server, Oracle, MS Access, Visual Basic

Languages: Java, VB.Net, HTML, SQL, C#

Operating Systems: Windows NT/2000/XP/Vista/7 & 8.1 with Bing, Unix

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Business Analyst

Responsibilities:

• Interacting with key stakeholders for gathering and verifying Stakeholder Requirements.
• Creating Business Requirement documents (BRD) and Functional requirements documents (FRD) based on the traditional waterfall methodology.
• Involved in calculations and documentations using MS Excel, MS Word, MS Access and MS Power Point.
• Collaborating with the developer team for User Acceptance Testing (UAT) for various web-based portal and database related applications.
• Conducting Joint Application Development (JAD) sessions with IT groups, created Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents.
• Identifying the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Promptly raised and tracked defects including Blockers & Criticals using issue tracking tool JIRA.
• Using HP ALM / Quality Centre for defect management and defect rectification. Participated in UAT along with the developer team and helped detect bugs.
• Designing and implementing basic SQL queries for QA Testing and Report / Data Validation.
• Designing and developing Project document templates based on Agile methodology. Developing User stories, Acceptance Criteria’s.
• Utilizing Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.

Environment: MS Word, MS Excel, MS Access, Power Point, HP Quality Center, MS SQL Server, MS Visio.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Facilitated JAD sessions and design meetings with the Team leads and Business contacts of interfaces.
• Designed and developed Use Cases, Work flows and Activity Diagrams using UML.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and MS Office to execute sprint planning and management.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in MS SQL Server environment.
• Generated weekly reports using MS Access and used MS SharePoint to share the results with Project Manager and team members.
• Prepared Business and Functional specification document related to Data Mapping.
• Interacted with developers to identify and resolve technical defects, issues and bugs in the software to validate end-user requirements.
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.

Environment: MS SQL Server & MS Visio, MS Excel, PowerPoint, MS Word, Scrum Work Pro, MS Access.

Confidential, Madison, WI

Business Analyst

Responsibilities:

• Identified new commercial insurance program opportunities for reinsurance partners.
• Communicated with reinsurance brokers to obtain information necessary for processing claims.
• Involved in gathering requirements for both Personal and Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Involved in coordinating with the database design team, using SQL to Query databases and providing inputs in finalizing the data model, report layouts.
• Prepared all SDLC documents for projects.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS) for the Web based application s modules.
• Conducted JAD sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Responsible for defining the scope of the project, gathering business requirements, performing GAP analysis and documenting them textually or within models.
• Collaborated with the development team to monitor and track progress of project following Agile methodology.
• Collaborated with quality assurance/quality control to ensure that the final product met all the clinical protocol requirements. Collaborated with various teams during the user acceptance testing (UAT) of the final product.
• Designed and reviewed different comprehensive data reports using MS Access and MS Excel.
• Conducted due diligence for searches, generating reports, proposals and constructing presentations for financial advisors to present their clients.

Environment: MS Word, MS Excel, MS Access, MS SharePoint, MS Power Point, HP ALM / QC, MS SQL Server, MS Visio.

Confidential, Alpharetta, GA

Business Analyst

Responsibilities:

• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) for application development.
• Performed Data mapping, logical data modeling, created class diagrams and Entity Relationship (ER) diagrams and used SQL queries to filter data.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams.
• Worked in developing the wireframe and mock-ups for the prototype of the web based portal application in MS Visio.
• Assisted with data analysis by generating reports in MS Access. Extensively involved in every phase of the RUP process starting from Inception to Transition.
• Created Use cases, activity reports, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Prepared system Test Plan and scenarios for Test Scripts. Served as a key leader in introducing the department to enterprise change management through Rational Rose.
• Involved in performing version control and defect tracking activities using Rational Clear Case and Rational Clear Quest.
• Used Requisite Pro for requirements management and functioning on new project request and Clear Case for versioning of requirements documents.
• Generated weekly reports based on results and used MS SharePoint to store all Project Artifacts.

Environment: MS Word, MS Excel, MS Access, MS SharePoint, MS Power Point, Mercury Quality Center, MS SQL Server & MS Visio, Rational Enterprise Suite (Rose, Clear & Quest), Rational Requisite Pro.

Confidential, San Antonio, TX

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements and analyzed requirements using Rational Rose, Requisite Pro - RUP.
• Designed and developed Use Cases, Activity Diagrams, Class Diagrams and Sequence Diagrams using UML.
• Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment.
• Documented and updated systems configuration documents.
• Assisted both the QA and UAT teams in the building of Test Case, Use Cases.
• Conducted workflow, process diagrams and GAP Analysis to derive requirements for existing systems enhancements.
• Gathered Business requirements, facilitated Joint Application Development (JAD) sessions, developed User stories, Acceptance Criteria and created Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents.
• Used Rational Clear Quest for all types of change requests, including defects, enhancements, issues and documentation changes with a flexible workflow process.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Used detailed knowledge of application features and functions assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Assisted the project manager in preparing the project schedules and milestone tracking using MS Project.

Environment: MS Word, MS Excel, MS Access, MS PowerPoint, Mercury Quality Center, MS SQL Server 2005, MS Visio, MS Project, Rational Enterprise Suite (Rose, Clear & Quest), Rational Requisite Pro.