SUMMARY:

• Extensive work experience as a Business Analyst/Data Analyst in the finance vertical.
• Extensive and In - Depth knowledge of the various financial instruments and financial concepts.
• Experience in gathering requirements from the various business users, other stakeholders and making Business Requirement Document and Functional Specifications Document.
• Rich expertise in business process modeling and analysis utilizing business process modeling tools like MS Visio and Rational Rose.
• Expertise in conducting JAD sessions, employing SDLC models, Agile, Iterative Software Development Life Cycle Processes such as Rational Unified Process (RUP).
• Proficient in Use Case development and UML modeling using modeling tools like Rational Rose and MS Visio to prepare Use case Diagrams.
• Experience using Requirement management tools like Requisite Pro and DOORS.
• Hands on experience working on Sharepoint.
• Good experience in creating Test Plans and Test Cases based on the user requirements.
• Rich experience using SQL for extracting data from the database including datasets contains large volumes of data and working in a Data Warehouse Environment.
• Excellent working knowledge of Software Testing using Mercury Quality Center.
• Rich experience in conducing User Acceptance Testing (UAT) with the business users and team members and getting business sign-off.
• Proficient in MS Project and MS Office and also MS Excel skills to create Pivot tables and Vlookup functions.
• Excellent communication, presentation, negotiation and interpersonal skills.

TECHNICAL SKILLS:

Methodologies: RUP, Waterfall, Agile, Iterative

Testing Tools: Quality Center

Business Modeling Tools: Rational Rose, Microsoft Visio, RequisitePro, DOORS

Project Management: Microsoft Project, Microsoft Office Suite

Operating Systems: Win 95/98//2000/XP, VISTA

Database: MS Access, Oracle, RDBMS.

Other Skills: Crystal Reports, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Business Analyst/Data Analyst

Responsibilities:

• Conducted meetings with the development and the business teams to discuss the changes and enhancements to be incorporated in the upcoming releases.
• Prepared the Scope Document and the Business Requirements document describing the changes and enhancements to be made and conducted several reviews with the development and the system test team prior to finalizing the artifacts. The requirements were maintained and managed in DOORS.
• Performed monthly reconciliation for the book servicing. These recons were done to ensure that the data we receive from upstream systems is consistent with the data we deliver to the downstream systems. It also helps to ensure the reasonableness of the data.
• Worked on updating the Service Level Agreement (SLA) with the upstream systems and downstream consumers.
• Worked on updating and finalizing the Load Specs document which provides details on how a field in the database in updated, which process updates it and the source system name, source system file name etc.
• Worked on large sets of data containing millions of records, some of which were updated monthly and extensively used SQL to extract data by joining tables from the source system and the target system.
• Checked the data mapping of the Source and Target fields and reported gaps if any. Also conducted negative testing to ensure that the entire data set is mapped according to the logic provided by the IT team and reported discrepancies if any.
• Extensively involved in QA testing in preparing QA test approach, test plans, ensured proper test coverage for all requirements and business rules by designing extensive test conditions (positive as well negative test scenarios) and writing test cases for each test condition.
• Used Mercury Quality Center to do system testing and regression testing of the proposed changes in the business release and reported detailed results of testing. Also used Clear Quest to report defects and create AMORT tickets.
• Responded to the Ad-hoc requests from the upstream and downstream consumers.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.
• Used Sharepoint to store and update the shared artifacts.

Confidential, Rockville, MD

Business Analyst

Responsibilities:

• Examined the current functionalities if various trading applications and reports and then documented the detailed Business Requirements document.
• Coordinated with the developers and the tech team to research about the system functionalities and also for documenting the functional specifications document.
• Extensively used SQL to extract data from the database.
• Performed system testing and regression testing for the new version of the reports being built by the Confidential developers.
• Conducted testing using Quality Center.
• Conducted meetings and JAD sessions with the business users to gather requirements for building the new version of the applications and reports.
• Tracked defects and prepared the defect matrix /reports.
• Conducted UAT testing with the business users to get the business sign-off.
• Extensively used MS Word, MS Excel, TOAD

Confidential, New York

Business Analyst

Responsibilities:

• Coordinated and conducted meeting sessions with the users, captured the user requirements and gained an understanding of the business rules & constraints using RUP methodology.
• Analyzed requirements and identified functional and non-functional requirements and prioritized the requirements, developed effective and unambiguous Business Requirement Document and translated them into Functional Specifications.
• Extensively used SQL to extract and query data.
• Designed and Developed data flow diagrams & business process models using Rational Rose.
• Successfully conducted (JAD) Joint Application Development sessions with cross-functional team members for discussing various shared issues to ensure that the business objectives are met with and requirements are understood clearly at all levels.
• Conducted UAT testing successfully and actively involved in interaction with the business users and getting business sign-off.
• Performed risk reporting - risk limits, compliance reports, stress testing results reports.
• Extensively used MS Word, MS Excel, Rational Rose and MS Power Point throughout the software development life cycle.

Confidential, New York

Business Analyst

Responsibilities:

• Conducted workflow process analysis to derive requirements for existing system enhancements and business re-engineering efforts.
• Used Rational Unified Process (RUP) Methodology in defining the problem and gathering requirements and prepared use case specification.
• Organized JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open matters, and change requests.
• Worked with the UI team to define user interface design guidelines, to finalize system UI.
• Conducted Stress Testing and extensively used Quality Center for testing.
• Built checkpoints to discover requirements specification problems like ambiguous requirements, missing requirements, inconsistent requirements.
• Responsible for all project documentations and assisted testing team in understanding the business rules and the system development.
• Reviewed technical specifications to develop test plans, test objectives, test cases and scripts.
• Helped in developing QA Test plans for Functional, Integration Testing and participated in User Acceptance Testing.

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements from business users, SME and stakeholders to understand their needs and requirements.
• Translate business requirements into functional requirements and prepared comprehensive Business Requirements, functional and support documents.
• Participated in each phase of the SDLC following RUP methodology and conducted project analysis.
• Worked extensively on MS-Excel and Visio while developing use cases like enter buy order, allocate an order, send to accounting and several others.
• Organize JAD sessions and phone conferences with Subject Matter Experts for walkthrough on prepared project documents to collect financial business requirements and determine their translation to functional requirements.
• Review transaction reports daily to confirm accurate and timely processing.
• Coordinated with the business users in conducting User Acceptance Testing (UAT) for business sign-off.
• Extensively used RequisitePro for managing requirements.

Confidential, New York

Business Analyst

Responsibilities:

• Gathered requirements from the traders, Project manager, Supervisors and read various documents to help see the various needs.
• Participated in each phase of the SDLC following RUP methodology and conducted project analysis.
• Developed Use Cases, project plans and helped define and manage project scope.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Documented system requirements specification from the functional point of view and came up with BRD, FRD and SRS (Software Requirements Specifications).
• Assisted database designers by continuous involvement in transition from business data to database design.
• Reviewed and validated the data model to verify that the business rules were met.
• Worked extensively on MS-Excel and Visio while developing use cases like enter buy order, allocate an order, send to accounting and several others.
• Assisted testing team in understanding the business rules and the system development.
• Reviewed technical specifications to develop test plans, test objectives, test cases and scripts.
• Helped in developing QA Test plans for Functional, Integration Testing and participated in UAT (User Acceptance Testing).