SUMMARY

• 7+ years of experience in Business/System Analysis, Financial Analysis, Data Modeling, Object Oriented Software Analysis documenting, developing process flow diagrams.
• Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products.
• Experience in conducting GAP analysis, ROI analysis, SWOT analysis and Cost Benefit analysis.
• Facilitated JAD and JRP session with executives and project managers, prepared workshop materials and organize workshop activities.
• Strong business analysis skills and an understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP), Agile: XP, Scrum.
• Performed Structured Walk Through testing with QAs and developers, to analyze the root cause of flaws. Responsible for preparation test cases, test scripts, Decision tables and documented it for regression testing.
• Proficient in Risk Management planning that includes Risk Identification, Assessment, Risk Analysis, Reporting, and Risk response/monitor/ control.
• Demonstrated leadership ability to resolve issues, drive projects, and meet deadlines. Excellent interpersonal and communication skills with the ability to understand both business and technical needs from the clients and customers.

TECHNICAL SKILLS

Methodologies: UML 2.0, Rational Unified Process (RUP), Rapid Application Development (RAD), Agile Development

Business Tools: Word, Excel, MS Project, Visio, Rational Rose, RequisitePro, CaliberRMRational SODA, ClearCase, Clearquest.

Documentation Tools: Rational Requisite Pro, MS - Word, Excel, Project, PowerPoint.

Testing Tools: HP Quality Center, Quick Test Pro (QTP),JIRA

Languages: Java, SQL, SAS and Visual Basic 6.0.

RDBMS: MS-SQL, MS Access, Oracle

Banking Protocols: FIX, SWIFT

Financial Terminals: Bloomberg, Reuters, Capital IQ

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Business Analyst/Data Analyst

Responsibilities:

• Gathered business requirements and assessed of current OTC derivatives instruction trade management processes, reference data, data attributes and security master database.
• Asset classes covered include Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps, and Equity options, Swaptions, Foreign Exchange Options and Equity/Index Derivatives.
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Worked with AGILE methodology
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Modelled the As Is and To Be business models using Case wise Modeller.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Extensively worked in creating and integrating MicroStrategy Reports and objects with the data warehouse.
• Created screen-mock-ups using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
• Used Borland CaliberRM for requirements management and reporting, HP Quality enter for test tracking.
• Prepared business requirements Documents (BRD) and got sign off to be used by the developers.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using Unified Modeling
• Worked on COTS Applications and coordinated with the in-house technical team. Meeting internal Business owners to gather requirements and document them.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Hands-on implementation and customization of Visual Studio Team System agile with Lightweight SCRUM solutions.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Designed, developed, and managed the synchronization of four customer and product master files between a mainframe and an AS400.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, SWIFT, Swapswire, Wall Street Systems for treasury and asset management documentation; FpML, Advent Geneva Global Portfolio Accounting System, DerivServ, ISDA.

Environment: SDLC, Rational Tools Suite (Rose, Requisite Pro, Clear Quest, Clear Case), MS Access, UML, SQL, MS Project, agile, MS Office.

Confidential, NY

Business Analyst

Responsibilities:

• Ensured business requirements/application functionality was consistent with regulatory mandates from Dodd-Frank Act; Finalized EU Regulation for CRAs.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Credit Profiling, Asset/Cash Management, and Marketing Analysis. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Provided key initiatives in working with users in defining project and system requirements.
• Established a RUP (Rational Unified Process) centric business analysis methodology. Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Implement investment planning recommendations and refer client to executives and partners of specific programs such as venture capital, 1031 property exchange, natural oil and gas exploration etc. for further assistant on technical details, risk evaluation and tax benefits.
• Wrote and edited software development requirements documentation using Microsoft Word, Paint Shop Pro, Test Director, Visio and CaliberRM.
• Solid Subject Matter expertise in Fixed Income ( Corp. Bond, Muni Bond, US Treasury, ABS, MBS, CMO), Annuity, Equities, capital market, Derivatives (Options, Futures, Forwards and Swaps), Equity and Fixed Income’s Trading Life Cycle, SEC & NASD compliance requirements, Portfolio Analysis, Asset management and Cash management.
• Perform data mapping from transactional applications for both internal and external reports, build High Level Logical Data Design, sketched many entity-relationship diagram ERD on Commercial Lending & Securities Lending lines.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system.
• Developed and implemented a comprehensive DRP strategy for the new consolidated data center.
• Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Proficient in industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models) and Agile.
• Experience in identifying and documenting detailed business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives, Portfolio Management, Corporate Action, Wealth Management, etc.,
• Documented for COTS implementation, version upgrade, build infrastructureand security rules, mapping of records layouts from disparate source systems for Disaster Recovery testing and readiness and Business Continuity test plans.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses. Used Query Analyzer, Execution Plan to optimize SQL Queries
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Worked with multiple asset classes such as Fixed Income Securities, Derivatives and Equities and hedge funds.
• Extensive use of SWIFT messaging for secure financial transactions. Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Guided development team in the Oracle 9i based database.
• Assisted in presenting reports and analysis to help guide the management.
• Organized cross training of team members and users to become more responsive.
• Assisted in development of training materials for new technology and process improvements.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Oracle, Crystal reports, RUP, UML, SQL, agile, SWOT analysis, GAP Analysis, Win Runner

Confidential, MO

Business Analyst

Responsibilities:

• Experience from Front to back office, worked with fund managers, financial advisors and technical team members. Worked with PM to coordinate daily activities between applications development and Product Management.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Extensively performed data modeling.
• Wrote SQL statements to extract data from the Tables.
• Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
• Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
• Worked with project management to analyze change requests to determine what is being requested and programming required. Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis.
• Developing data models and designing data warehouse in view of the project requirements.
• Used the different types of views in Requisite Pro Attribute matrix, to display requirements of a specified type. Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Designed and developed all Use Cases and UML models using Rational and Visio.
• Automated the requirement management process for molecular imaging equipment using CaliberRM, a requirements management tool.
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, documented Business Requirements Document (BRD).
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc. Performed requirement analysis, went through all the use cases and issue logs.
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Participated in the logical and physical design sessions and developed design documents. Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Developed the strategy and plan for; automation of offer management and integration with digital product master data in order to support centralized metrics reporting.
• Assisted in system and User Acceptance Testing, performed client presentations.
• Participated in entering and tracking system defects in Rational ClearQuest.
• Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.

Environment: Windows, DB2, Oracle, SQL, MS Visio, MS Access, agile, UML, Requisite pro, MS Office Suite, Rational ClearQuest.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Worked with the business community to define business requirements and analyze the possible technical solutions.
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
• Co-authored documents for capturing pricing data using Bloomberg and Reuters terminals.
• Participated in Agile design sessions with vendors, developers and key business decision makers to formulate UML data models, generate wire frames and document use cases for new web service interfaces.
• Facilitated JAD Sessions and handled change management.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market. Mainly involved in fixed income securities trading.
• Scheduled and conducted meetings with client work group (SME’s) to identify requirements, and documented them in SRS document and identified priorities.
• Created detailed requirements for fixed income process workflow.
• Coordinated with enterprise groups to research new technologies and created development policies for VSTS in an Agile and continuous build environment.
• Took an initiative to migrate requirements from Word documents on the Legacy platform to automated CaliberRM documents.
• Assured that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Analyzed the various kinds of risks that had to be accounted such as the Asset Class Risk for e.g. Credit Card Risk, Personal Loan Risk, Mortgage Loan risk, etc.
• Modeled the risks in Excel spreadsheet and performed sensitivity analysis and shared this document with the managers and the technical team to facilitate more efficient communication.
• Used MS Projects to schedule and track the activities in the project.
• Involved in performance testing, functional testing and integration testing.
• The system collects data from various departments, both finance and operational, merges it into a staging area, after cleansing it and then loads the data into the EDW in accord with various data warehousing and business guidelines.
• Used Rational Rose to designed and develop Use Cases scenarios, Use Cases models, Activity diagrams, Sequence diagrams and State chart diagrams.
• Created Use Case model and process flow diagrams using MS Visio.
• Performed mapping of records layouts from disparate source systems.
• Experience in COTS implementation, Investment Performance Measurement & Analysis, conducting Gap analysis, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• Traced Requirements to High Level Design, Test Cases and Product Requirements.
• Worked with a cross functional team including Sales and Marketing.
• Co-authored many business requirements document with project teams for Fixed Income and Brokerage documents. Extract, discuss, and refine business requirements from business users and team members.

Environment: MS Visio 2003, MS Word 2003, agile, MS Access 2003, Oracle, Charles River IMS, Reuters 3000 Xtra, Bloomberg Terminal.

Confidential - Covington, KY

Business Systems Analyst

Responsibilities:

• Worked on a project to re-engineer the fixed income and derivatives trades to flow through an ADP system called IMPACT.
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
• Interacted with line of business managers and coordinated the transition into the security database to assure business compliance with SOX.
• Wrote the specifications for a generic interface for transmitting these trade messages to ADP's IMPACT in real-time instead of the current batch feed. Prepared detailed business/systems requirements documents, UML use cases and data base models to document these requirements.
• Derivative products traded included options, fras, and interest rate swaps.
• Wrote the algorithms for the calculations of the price and cash flows of interest rate swaps using continuous compounding to interpolate the values.
• Conducted JAD (Joint Application Development) and RAD (Rapid Application Development) sessions with business users to elicit business requirements.
• Performed cost and time budgets in conjunction with the project manager to develop the project plans and estimates of delivery.
• Performed Project Requirements Gathering, Requirements Analysis, Design, Development, Testing for the ETL, Data warehousing and reporting modules of the project.
• Worked on a project wherein capital markets were merging with Dain Rauscher to provide a new service offering, Wrote Service and Operational Level Agreements for all systems that were being retained, post-merger.
• Conducted regression testing and automated all regression test scripts with the Open Source Agile Tool - UFT.
• Wrote specifications for data feeds to the general ledger to record post-trade execution data and to create quarterly balance sheets from the general ledger.
• Performed business analysis to determine impacts to current business processes, functionality, interfaces and reports.
• Prepared detailed test cases and scripts that reflected the business requirements and functionalities. Test scripts included test data, expected results and actual results.
• Executed functional testing, regression testing and system integration testing, capacity testing.
• Compared the actual results with the expected results and analyzed the discrepancies and reported bugs to developers.

Environment: Rational Suite, SQL, Test Director, Oracle, MS- Office, agile, Windows 2000