SUMMARY:

• Over 7 years of experience as a Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling, Data Mapping, Data Modeling.
• Strong experience in Mortgage Backed Securities, Loan Monitoring, Whole Loans and Commercial Loans.
• Strong knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP) methodology, and Project Life Cycle.
• Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
• Experience in preparation of Deliverables, Business Requirement Documents (BRD), detailed Functional Specifications and Non - Functional Specifications, developing Use Cases and Test Cases
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Good Understanding of Web Services, Service Oriented Architecture (SOA), Simple Object Access Protocol (SOAP), Web Services Definition Language (WSDL), Extensible Markup Language (XML).
• Actively involved in developing, executing and managing User Acceptance Testing (UAT).
• Written Use cases and have produced Use case Models, creating Behavioral diagrams (Use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
• Experience with Medicare and Medicaid: Claims processing, Membership, and Eligibility Verification and care management
• Experience in writing & debugging SQL Server Stored Procedures, Triggers & SQL Scripts, Views, Indexes, Temp tables, SQL Jobs and running SQL Profiler traces for debugging and optimize queries.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reqmts. Management Tools: Rational Requisite Pro, Telelogic DOORS

Change Management Tools: Rational Clear Case, Rational Clear Quest

Project Management Tool: MS Project

Analysis / Modeling tools: JAD, RUP, RAD

Testing Tools: Load runner, Test Director, Mercury Quality Centre

Operating Systems: MS Windows NT/98/95/2000, UNIX

Languages: SQL, UML, XML, JAVA

Database: Oracle 8i/9i, SQL Server 2000, MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, Power Point.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Sr. Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc
• Involved in Service Oriented Architecture (SOA).
• Worked with applications like Unified Messaging, Alcatel Lucent IMS core applications, 5620 SAM and Microsoft MOM, Microsoft SMS.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Created project WBS (work breakdown structure), allocated resources to projects and project activities in PeopleSoft and Clarity (project & portfolio management tool)
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Acted as the Business Analyst to integrate the SunGard reconciliation system as per Business requirements.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Wrote Statements of Work, Business Specification Documents, Test Plans and Test Reports.
• Worked with software engineers and business units, assisted in formulating and defining system scope and objectives through research and fact-finding, combined with a basic understanding of business systems and industry requirements.
• Worked on 3 Post-Implementation Releases. Gathered Siebel Compass post-roll out change / application customization requests and documented BRD / High-level Design Document and Functional Design Document.
• Serve as Property and Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACCORD xml standards.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the Agile.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties
• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Mapped the old requirements with the new requirements and communicated it with the business groups for the gap analysis.

Environment: Java, SQL, Oracle, MS Office, MS Project, Waterfall, Mercury Quality Center, Business Process, Rational Clear Case, Agile, Agile/Scrum, Rational Requisite Pro, Rational Rose, MS Visio.

Confidential, Pittsburgh PA

Business Analyst

Responsibilities:

• Worked with the business users and with different levels of management to identify requirements, Use cases and to develop functional specifications.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
• Conduct Requirements Gathering sessions with the use of Content Data Modeling, User Surveys, Brainstorming and User Interviews with Stakeholders, internal users and third party vendors.
• Performed testing on a daily basis to review the status of the project thru SIT “System Integrated Testing”, UAT Functional “User Acceptance Testing”, UAT Regression and Implementation phase.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Created the User Acceptance Test Plan and conducted the user acceptance testing (UAT) for the final confirmation of the project from the Business and SME.
• Worked on data modeling and produced data mapping and data definition documentation.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Coordinated activities with project manager and various other teams using MS Project.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, MS office, Rational Rose, Agile/Scrum, Rational Requisite Pro, OOAD, .Net, Test Director, Clear Case, UML, Rational Suite, MS Visio, MS Project.

Confidential, Pittsburg, PA

Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle.
• Reviewed Commercial Loan Dept documents based on the Business Unit request and the request for validity and time needed to complete the Project
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Prepare test scripts for the Commercial Loan Business Unit.
• Used DOORS to link requirements to test cases, business rules, and design items to maintain traceability.
• Was actively involved in the design of BRD, FRD, Use case diagrams and Activity diagrams using MS Visio.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Involved in testing the conversion of the application into web application using XML web services.
• Interacted with the users and logged any defects, enhancements from the UAT and communicated them to the development team.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation. Involved in conducting JAD sessions with the entire team to come up with the possible solutions for the business problems.
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
• Formulated project plans including staffing, analysis, development, testing and implementation.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Involved in testing the conversion of the application into web application using XML web services.
• Prepared UAT Materials UAT Test Cases to include various steps involved for UAT and to have proper coverage of requirements.
• Data mapping, logical data modeling, created class diagrams and used SQL queries to filter data within the Oracle database.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.

Environment: Windows XP, Oracle/SQL Server 2000, UAT, SQL, XML, 8.1, Agile/Scrum, Mercury Quality Center, RUP, UML, MS Visio, MS Project, MS Office.

Confidential, Manhattan. NY

Business Analyst

Responsibilities:

• Interacted with business heads to finalize the Business Requirements for the application.
• Worked with the business users and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Identified, researched, investigated, analyzed, defined and documented business processes
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Completed the documentation of Claims Scenario’s for the source system
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Managed changing requirements which included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing relationship between related requirements and maintaining version control.
• Developed stored procedures using SQL server 2000.
• Responsible for attaining HIPAA EDI validation from Medicare, Medicaid and other payers of government carriers.
• Trouble shouted file transmission problems and assisted customers with EDI and Medicaid Insurance claim related inquiries explained and enforced guidelines in the X12 Implementation guides (837P, 837I, 837D, 270/271).
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Prepared detailed functional specifications for the application performed UAT (User Acceptance Testing) for all versions of the application. Wrote and executed test cases for UAT.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Star Schema, HTML, Clear Quest, XML, HTML, Oracle .

Confidential, Dublin OH

Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle (SDLC).
• Involved in the analysis of the existing report functionality (AS-IS), interacted with the users to capture changes in the report functionality (TO-BE).
• Involved in the analysis of the data mapping phase built according to functionality and report conversion procedure.
• Performed extensive data gap analysis to understand the data flow in to the data warehouse.
• Analyzed data requirements for the converted reports, validated data in the data warehouse.
• Initiated ETL process for the data to be transformed from the source system to data warehouse
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
• Provided documentation such as requirements management plans, functional requirements, test plans and test cases.

Environment: Microsoft Office Suite, Terawatt, DB2, Microsoft Visio, UML, SQL, Business Objects, Quality Center, Load Runner.