SUMMARY

• Over 7 years’ experiences as a Business Analyst with extensive and diversified experience in the Financial Services Industry, effective at requirements gathering, data analysis, data mapping and user acceptance testing.
• In depth knowledge of the Software Development Life Cycle (SDLC) using Agile and other methodologies such as Rational Unified Process (RUP) and Waterfall
• Excellent written and verbal communication skills. Responsible, self - motivated and organized. Goal-oriented individual with strong leadership capabilities, mentored juniors
• Proficient in creating and managing Requirement Traceability Matrix (RTM) for tracking and managing changes based on project’s evolving needs.
• Working knowledge in writing SQL queryforidentifying databases involved in the application development.
• Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income & Derivatives.
• Understanding of various debt instruments including T-bills, T-bonds, Municipal bonds (including revenue & tax-exempt bonds) and corporate bonds.
• Strong understanding on CCAR reporting like FR Y9C, FR Y14Q for consolidated financial statements for large bank holding companies.
• Strong knowledge in global capital market instruments including equities, fixed income, derivatives & foreign exchange and front, middle and back office operations.
• Understanding of investment banking, asset management and other fund management functions.
• Understanding of different mortgage instruments like Mortgage backed securities, CMOs, CDOs including the tranche structuring and credit enhancement processes to manage prepayment and credit risk.
• Knowledge and understanding of the functions of mortgage agencies like Confidential.
• Understanding of Dodd-Frank Act and the implications of its various key provisions like Volcker rule. Also evaluated capital requirements including Basel III, Capital stress testing and weighted asset allocations.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.

TECHNICAL SKILLS

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM

Defect Tracking Tools: HP ALM, Quality center

Operating Systems: Windows XP/2000/7

Databases: Oracle, SQL Server, MS Access

Tools: MS PROJECT, SQL, SharePoint, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

Business System Analyst

Responsibilities:

• Worked with SME to prepare BRD for Fortent application and ways to decommission its scenarios and BLU’s
• Prepared BRD explaining the issues and remedy for transaction monitoring application SIRCOI covering transactions out of Latin American regions (LATAM).
• Documented artifacts based on regulatory reporting to streamline the review and revision process.
• Maintained issue logs to measure risk and documented the traceability to assess risk in terms of coverage.
• Conducted meetings with several report owners from different Line of Business.
• Explained them the conversion process of their reports and their respected output out of the new Oracle platform.
• Also, suggested possible enhancements to their exiting reports.
• Evaluated old report output and data sources versus the new report output and their data sources.
• Created detailed mapping documents to support the meeting minutes with the report owners.
• Analyzed clients brokerage account transactions to develop reports for brokers as per the user needs.
• Also facilitated meetings to discuss the movements of client funds to design brokerage patterns for client investments.
• Created detailed conversion documents for several brokerage account reports. Explained old procedure against the new ones and its possible implication on the output.
• Conducted meetings with developers to explain the user needs. Discuss new possible outputs and revise the business logic and codes involved in developing the new report.
• Assisted SME to assess risk tolerance and manage risk in terms of surveillance as the BLU and legacy applications go off.
• Created artifacts on components and grouped them into Hardware, Software, servers and Operating systems.
• Created pivot charts and tables for daily reconciliation purposes of transactions out of SIRCOI application.

Environment: Windows XP, Microsoft Visio, Microsoft Project 2010, Microsoft Excel, Microsoft Word and Outlook.

Confidential, Brooklyn, NY

Business Analyst

Responsibilities:

• Worked with the team of Subject Matter Experts (SME) to analyses the data from LOB.
• Attended meeting on regular basis with line of business (LOB) to understand the entry/exit criteria of data feeds coming in.
• Evaluated possible money laundering behavior and flagged them as possible suspicious pattern for further scrutiny for surveillance purposes.
• Evaluated risk reporting needs aligned with “False-Positive” alerts and its possible impacts on surveillances.
• Transactions were queried in to evaluate the functionality of each interface as per the functional specification document.
• Also analyses were made based on specific ways in which a transaction operates and its functions involving parties, account and the flow of money.
• Worked with Oracle database, created, ran, and modified SQL queries to analyze data by creating joins and various SQL statements to generate a combination of records for analytical purposes.
• Performed detailed data analysis based on target to source data mapping activities
• Created test plans and facilitated defect management of test scripts. Also, executed test scripts from different application/line of business to maintain or improve file delivery in future.
• Any uneven flow of transactions was looked in deeply to further raise a flag and put it under the HP ALM triage process.
• The defect was further supported with analysis and assigned back to the LOB to get the correct remediation possible during the daily triage meetings.
• Recommended valuable changes in the specification document as per the business process.
• Requirement traceability matrix (RTM) was prepared to find out gaps in business process.
• This was mainly to focus on the coverage of all the business requirements for audit purposes.

Environment: Windows XP, Oracle SQL developer, HP ALM,Microsoft Excel and Outlook.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Followed Agile approach of development throughout the project
• Developed business requirements document (BRD), User stories and functional requirements, created the same by creating vision/scope document.
• Worked with third party financial products like Bloomberg, Capital IQ (S&P) to come up the collective information used for trading and investment purposes.
• Created use cases in order to use multiple sources for evaluation.
• Created UML Models such as Use Case Diagrams, Activity Diagrams and Flow Diagrams using MS Visio
• Detailed the Functional requirements specifications, user stories and other core materials.
• Evaluated accounting implications of treasury products like T Bills and Bonds.
• Also, analyzed financial derivative instruments and its underlying factors to assess the risk associated with CDS.
• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on the progress, issues and deliverables of the project.
• Created database object such as tables, views, joins, procedures, functions, triggers based on client requirements.
• Conducted data modeling activities to map products (Equity, Bonds, Loans, etc) with the existing processes.
• Facilitated User Acceptance Testing and training of end users as well as defined and documented business training requirements for new product releases & enhancements

Environment: Windows XP, Oracle 11i,MS Visio, MS Project Plan, MS Office Suite, Caliber RM, Quality Center.

Confidential, Manhattan, New York

Business Analyst

Responsibilities:

• Followed RUP approach of development throughout the project
• Involved in defining scope of the project along with vision statement.
• With the help of the Financial Analyst, Designed and created Excel sheets to provide market analysis charts.
• Coordinated and tracked project communications and also maintained project schedules and milestones.
• Accumulated customer requirements from various end users through surveys, interviews and JAD sessions and analyzed the requirements.
• Created technical and system requirement documents for trading system. Created functional artifacts based on different asset classes to streamline the trading process.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational RequisitePro.
• Performed manual front-end testing to check all functionalities of different modules using Test Director for bug tracking. .
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.

Environment: Business Objects, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, SharePoint

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding and documenting their business needs.
• Worked with traditional waterfall methodology for this web-application.
• Collected and documented business processes as well as business rules.
• Participated in the identification, understanding and documentation of business requirements including the applications capable of supporting those requirements.
• Designed and developed Use Cases using data mapping techniques such as Use Case Diagrams, Activity Diagrams and Sequence Diagrams
• Involved in testing on all stages of System Development Life Cycle (SDLC). Performed Integration testing, Build Verification testing, System testing manually.
• Translated the business needs into system requirements, communicating with the business on a non-technical level and with the System Analyst on a more technical level.
• Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Provided technical assistance in identifying, evaluating and developing systems and procedures that are cost effective and meet business requirements.
• Defined Validations to be built into applications per the functional requirements.
• Developed test scenarios and implemented test plan. Providing key input in working with users in defining project and system requirements.
• Managed and maintained database, updated site content and maintained overall visual and functional balance.

Environment: MS Visio, Windows XP, Oracle 8i, HPQC,MS office.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Assisted senior business analyst in the requirement gathering and documenting process based on user requirements.
• Worked with the Senior Business Analyst to conduct (JAD) sessions with business and technical units.
• Prepared Test plans, Test Cases based on business requirements.
• Worked with the Senior Business Analyst to develop test cases for (UAT)
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• Used UML diagrams to visually express the core functionality of the system under development.
• Exposed to Security Testing and Regression Testing using Win Runner.
• Exposed to Functionality Testing and GUI Testing using Win Runner
• Assisted the QA testers in determining the application's response time using Load Runner.
• Interacted with the developers to report and track bugs using Test Director.
• Follow up with developers on defects status on a daily basis.
• Organized meeting and send agenda of the meeting, draft minutes to keep all invitees of the meeting on the same page.
• Organize weekly status meetings with the team to promote open discussion of business requirements and other system functionalities.

Environment: MS Visio, Oracle, SharePoint, MS Project, MS word, Use cases, UML (Visio), Windows XP, HPQC, Rational Req Pro, MS Excel.