SUMMARY

• 6 +years of experience as a Business Analyst with solid understanding of Business Requirements
• Experienced in planning, managing and controlling resources to achieve specific application workflow.
• Gathering, Data Analysis, Data Mapping, Data integration and Business Analysis.
• Competent in extracting, documenting, organizing and tracking the requirements.
• Familiar with working autonomously and in a team environment building & preserving strong relationships with senior and junior business sponsors, as well as technical specialists adhering to a delivery focused approach while managing business expectations.
• Adept with scripting Business Requirement Documents (BRDs), Functional Specifications Documents (FSDs).
• Expertise in business analysis skills and experience in working in SDLC for Various methodologies including Agile Scrum and Waterfall.
• Experience in performing Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements using AS - IS and TO-BE business process tools.
• Extensive experience in gathering, managing and documenting business and functional requirements and communicating effectively with stakeholders, developers and QA testers.
• Expert in use Case Analysis, GAP analysis, SWOT analysis, Cost-benefit analysis
• Facilitated User Acceptance Testing (UAT) with the business users.
• Adept in Requirements Engineering describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow Models & Data Diagrams (Class Diagrams).
• Skilled in Solution Architecture, Enterprise Data Architecture, Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, Data Warehousing,
• Strong Analytical and Problem solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
• Wrote extensive SQL queries during UAT and data validation such as joins, development of store procedures, views, temporary tables (including CTE).
• Proficient in the use of Excel such pivot table and V-lookup.
• Extensive experience in importing, managing and tagging requirement documents, and designing project deliverables (Traceability Matrix) usingvarious tools.
• Experience in implementation of Guidewire claim center and policy center
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and joint application requirement (JAR) sessions.
• Proficient in creating Sequence Diagrams, Activity Diagrams and Class Diagrams.
• Very strong presentation and written/verbal communication skills.
• Highly proficient in working with manual testing as well as automated testing tools like Mercury Interactive Test Suite (Load Runner, Quick Test Pro (UFT)), Test Complete and VSTS.
• Acquire knowledge of SQL and experience of writing SQL commands.
• Experience in manual testing, recreating errors and providing support to programmers to correct defects in the system while facilitating UAT with the stakeholders and the business users.
• Conducted usability and user acceptance testing (UAT) on behalf of end users.
• Good judgment skill to access high risk areas on which to focus testing efforts and analyze business processes to suggest improvement.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server

Document Management: MS Office, SharePoint

Requirements Management: JIRA, Team Foundation Server (TFS), HP ALM

UML Modeling: MS Visio, Rational Rose, Balsamiq

Bug / Defect tracking: JIRA, Quality Center (QC), Rational ClearQuest

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• Conducted interviews, document analysis, design workshops, surveys, use cases, and workflow analysis for gathering requirements. Also, analyzed Software Requirement Specification and designed documents.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Collaborate with developers and testers to iteratively, incrementally discover, develop, and deliver valuable, working software each sprint during Guidewire Policy Center integrations.
• Used Guidewire software to track the claims of the policyholders and to upgrade the current Claim system to track the claim of the policyholders and third party applications
• Refined product backlog and created use cases to generate functional requirements.
• Extensively used Rational Rose for process flow diagram (data flow), sequence diagram and collaboration diagram.
• Performed Requirements Analysis and Design using Rational Rose, analyzed and documented the System specifications, Business requirements and detail design of the business using Requisite Pro for the requirement tracking and analyzing.
• Worked closely with management to keep track of the status of project and draft strategies for the near future. Used MS Project to manage schedules, deadlines, and resources for the project.
• Performed the GAP Analysis and Impact Analysis for all business requirements having an impact on the existing application.
• Set up multiple load test scenario based on the test strategy in VSTS.
• Carry out performance, stress and load testing in VSTS and Apploader
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Confidential, Newark, NJ

Business System Analyst

Responsibilities:

• Gather requirements for automating Fact Sheets, Shareholder Reports and Web Site by analyzing data points for Performance, Risk, Portfolio Holdings and other information required from various data sources including Trading Systems like Charles River and Market Data / Reference Data sources like Bloomberg, Reuters and Thomson Financial consolidated into Eagle PACE and the General Ledger system
• Worked with Front Office Traders and Portfolio Managers to Validate Market valuation / Pricing and performing Data Analysis using SQL Queries and Microsoft Excel of various Equity, Derivative and Fixed Income Securities like US Treasuries, Munis Bonds, CDO, CMO, Corporate Bonds, Money Market Instruments and other Derivatives like Interest Rate Swaps, Forward Rate Agreements (FRA) and Interest Rate Caps/Floors that were part of various portfolios. This included validating various Bond measures like Yields, Coupons, Total Return for various Funds and the Internal Rate of Return of the Bond Portfolio
• Perform Mutual Fund Structure analysis by analyzing data in Eagle PACE for establishing relationship between various entities like Fund, Share Classes and Portfolios
• Validate Mutual Fund Performance information by testing and creating Reports using Oracle Business Intelligence Suite (OBIEE) to be sourced into Eagle Pace and do Data Gap Analysis of data required on various reports.
• Responsible for getting Agreements and Approvals for Requirements and Implementations from Technology System Partners and Business Owners
• Work directly with Portfolio Managers and Product Managers to understand the current process for reporting and marketing, create current and Future Process Flow Diagrams, perform Gap Analysis and present the same to Management using Microsoft PowerPoint
• Direct and guide Development and Quality Assurance teams for various aspects of the project
• Lead the development and QA team in terms of prioritizing of tasks, creating milestones and providing business context to development efforts and preparing test cases and test scenarios
• Participated and led project kick-off meetings in line with Agile scrum.
• Participated and led sprint planning meeting.
• Breakdown requirements into product backlog items (PBIs), enter and manage PBIs using TFS.
• Participated and led sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology.
• Participated and led daily stand-up meetings in line with Agile Scrum methodology.
• Participated and led sprint review meetings in line with Agile Scrum methodology.
• Assisted the PM in managing the Agile Scrum process to ensure smooth delivery of projects.

Confidential, Jersey City, NJ

Junior Business Analyst

Responsibilities:

• Actively engage and collaborate with Developers, QA team and other stakeholders to discuss deliverables, timelines and risks and issues
• Perform Data Analysis for profiling
• Worked with Front Office and Middle Office Users to gathered and analyze Reporting requirements and formulated Business Rules for Securities Transaction, Position and Sales Reporting of various Trades including Fund Trades, Equity Trades, Fixed Income Trades (Treasure Bill, Treasury Notes, Corporate Bonds, CMOs, CDOs) and Derivative Trades for the Institutional Services Group as part of the Eagle PACE Data Warehouse Initiative with Microsoft BI Tools as the front end reporting tool
• Worked on various Market Data / Reference Data sources like Bloomberg, Reuters, Thomson Financial etc. for sourcing trade related data in the Security Master Database about various financial instruments in the portfolio
• Gather requirements for automating the process of creating Fact Sheets, Shareholder Reports, P&L and Balance sheet reports, liquidity ratio, solvency, profitability and efficiency ratios by understanding the Current Process, brainstorming the proposed new design with the Marketing Team of the Reports and then analyzing data points for Performance, Risk, Portfolio Holdings and other information required from various data sources consolidated into Eagle PACE
• Performed Mutual Fund Structure analysis to identify gaps in Eagle PACE for establishing relationship between various entities like Fund, Share Classes and Portfolios and propose a solution to resolve the same
• Validate Mutual Fund Performance information using Microsoft BI reporting tool be sourced into Eagle Pace and do Gap Analysis of data required on various reports.
• Utilized ETL (SSIS) tools and conducted data validation processes.
• Deployed reports using SSRS.
• Conducted Data analysis at different data sources and performed detailed data profiling.
• Facilitated with Data Governance effort and assert best practices
• Brainstorm the design and impact of the data models with the Data Modelers and Data Architects based on the Reporting and Analytical Requirements of the Business
• Actively participated in the resolution of day-to-day Production reporting needs and issue resolution requests from business users and worked with the development team to resolve the issue with very limited resources and time in hand to resolve the issues
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata, Data Profiling.
• Actively worked with the Business Users in the UAT phase by helping them build test scenarios, test cases and resolving any anomalies in the results of the reporting elements.
• Participated and led project kick-off meetings in line with Agile scrum.
• Participated and led sprint planning meeting.
• Breakdown requirements into product backlog items (PBIs), enter and manage PBIs using TFS.
• Participated and led sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology.
• Participated and led daily stand-up meetings in line with Agile Scrum methodology.
• Participated and led sprint review meetings in line with Agile Scrum methodology.
• Assisted the PM in managing the Agile Scrum process to ensure smooth delivery of projects.

Confidential, New York

Junior Business Analyst

Responsibilities:

• Gathered and documented requirements for the Master Data Management perspective with the help of various Tools including but not limited to Use Cases, Process Flow Diagrams, Business Rules for Source-To-Target Mapping
• Involved in detailed discussions for End-to-End Process for various business processes like Account level Reporting, Balance Transaction Reporting, Payments and Statements Processing
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Gathered requirements for sourcing and delivering the data and Interface requirements between various Partner Systems for Payments Processing for Corporate Banking purposes which involved detailed understanding of Payments and Processing Standards like IBANs, SWIFT, and ACH etc.
• Coordinated and hosted meetings with multiple cross-functional groups involving Users and Product Managers from distinct Business Groups to understand business requirements, formulate a solution and discuss timelines.
• Conducted internal Technology meetings with Data Modelers, Architects and Developers to formulate a design including Data Models and the ETL Process to source the data and to distribute data to downstream partners through XML interface.
• Served as a Subject-Matter-Expert for the Master Data Management’s project to provide Cash Management Services for scoping and analyzing future requirements.
• Collaborated with the QA Team to help build test scenarios and test cases and also do some ad-hoc manual testing using SQL.
• Involved in Project for Data Quality Initiative (DQI) in compliance with Sarbannes-Oxley Act.
• Responsible for getting Agreements and Approvals for Requirements and Implementations from Technology System Partners and Business Owners.
• Lead and monitored the development team in terms of prioritizing of tasks, creating milestones and providing business context to development efforts.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
• Participated and led sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology.
• Participated and led daily stand-up meetings in line with Agile Scrum methodology.
• Participated and led sprint review meetings in line with Agile Scrum methodology.
• Assisted the PM in managing the Agile Scrum process to ensure smooth delivery of projects.

Confidential

Business Analyst

Responsibilities:

• Worked on the half - finished draft of the project charter
• Gathered requirements from business owner to create Business Requirements Document
• Documented in-scope and out-scope of the projects.
• Developed process flowchart of the specifications for the developers to follow.
• Facilitated status meetings and documented the meeting minutes on a daily basis.
• Followed up on the open issues to make sure it is completed and delivered on time.
• Presented the prototype of the project to the group of SME’s, Developers and Business Owners