SUMMARY:

• Over 6+ years of professional experience as a Technical Business Analyst with excellent understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, and Modeling.
• Experience of Investment Management, Risk Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Deep involvement with Portfolio Management accounting system (PMS) & Distribution of web interfaces (DOW) for reconciliation process and Basel II compliance.
• Fund accounting has been applied to investment accounting, portfolio accounting or securities accounting.
• 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.
• Skilled in Solution Architecture, Enterprise Data Architecture, Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, Data Warehousing, Data flow analysis, Process flow analysis and mapping, Data Profiling, Development using ETL & BI tools and technologies, Development of business metrics & KPIs, Data Quality Metrics, Source - to-Target Mapping, source system analysis, suggesting solutions to complex big data and system problems.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Expertise in Software Development Life Cycle (SDLC), Use Cases, Business Process Modeling Notation (BPMN), Object-oriented Analysis and Design, Rational Unified Process (RUP) and Rational tools used during all four phases of RUP: Inception, Elaboration, Construction, and Transition.
• Conversant with finance concepts like Cash Management, Fixed Income, Investment & Loans, Treasury, Day-to-Processing Applications, Cash Flow Forecasting, SWIFT etc and compliances like FASB and Sarbanes-Oxley (SOX).
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Worked on a project wherein RBC capital markets was 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.
• Extensive experience in Investment Banking, Retail/Commercial Banking, Financial Services, Portfolio Management, and Cash Management.
• Experience gathering business requirements for integration points including downstream/upstream interface requirements.
• Proficiency in business requirement gathering techniques, conducting JAD and RAD sessions and meetings.
• Excellent oral and written communication skills, interpersonal skills, and analytical skills.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Solution Modeler, MS Visio

Processes: RUP, SDLC, BPM, Agile Modeling

Modeling Languages: UML

Requirements Management: DOORS, Rational RequisitePro

Repository: Management Rational ClearCase

Change Management: Project Management Rational ClearQuest

MS Office Suite: Databases MS Access, SQL Server, Oracle

Web Application Tools: HTML, Adobe Acrobat, Photoshop

Operating Systems: Windows (98, 2000, NT, XP, Vista, 7)

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Business/Systems Analyst

Responsibilities:-

• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Supervise and manage projects throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Clarity.
• Managed timely completion of multiple projects in parallel- worked in close conjunction with the Project Management Office (PMO) to define scope of the project and its deliverables
• Conducted highly interactive JAD sessions with projects stakeholders such as users, QA analysts, and project management team, identifying and resolving issues
• Analyzed and studied Credit Card process and regulations to be complied for card services in detail.
• Responsible for planning, developing and implementing Working Capital and forecasting solutions to address specific business projects, day-to-day cash management requirements and information inflows and outflows for the analysis of cash and Working Capital management.
• Worked on integrating the credit card processing system with the new strategic exposure calculation engine to generate credit risk metrics
• Responsible for the valuation and development of credit card products.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Conducted joint requirements planning (JRP) sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Developed Test cases and Test Scripts for both Manual and Automation using Quality centre
• Incorporated Data Acquisition, Data Privacy, Data Analysis, Data Mapping and Data Compliance rules in the auditing criteria.
• 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.
• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for enhancements, Cost benefit analysis and ROI analysis.

Environment: Microsoft Office Suite, MS Project, Lotus Database, DB2, Microsoft Visio, RUP, UML, Business Objects, TestDirector, LoadRunner.

Confidential, Pittsburg, PA

Business System 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.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Involved depth understanding of Credit Risk management for the application
• Contributed in defining the scope of the project and defined functional specifications.
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Collaborated with Basel II team on credit risk analysis and issue resolution
• Used DOORS to link requirements to test cases, business rules, and design items to maintain traceability.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market.
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• 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.
• Used SQL to query the database and performed data analysis.
• Implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
• Implemented Simulation Tool to price complex equity derivatives portfolios in combination with fixed income and finance desk portfolios.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Involved depth understanding of Credit Risk management for the application.
• Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
• Formulated project plans including staffing, analysis, development, testing and implementation.
• Used UML to produce Use-Cases, Use case diagrams and Activity diagrams to explain process flows and functional specifications.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis using iRise tools.
• Was responsible for creating user interface using irise tool.
• Created screen-mockups 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.
• § Used IRISE Studio for designing and simulation of web applications
• Apply UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders.
• Used the tool Systems Architect and MS-Visio to create use case diagrams and process flows.
• Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Updated and modified progress and resources allocation in MS project for the team.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, Telelogic DOORS 8.1, OOAD, Telelogic System Architect 10.6, Mercury Quality Center, RUP, UML, MS Visio, MS Project, MS Office Access/Excel.

Confidential, Chicago, IL

Business Analyst

Responsibilities:-

• Effective requirements gathering and the elicitation of the requirements.
• Convert the gathered requirements into clear, concise Business Requirement Documents.
• Actively contributed in the JAD sessions to refine the business requirement documentation.
• Maintain and update requirements definition documentation and the business logic (Business Rules) documents.
• Developed the workflow diagrams and effectively defined the Business Process Models.
• Provide walkthroughs and reviews of requirements with customers and end users.
• Actively participated in daily, weekly and monthly fund valuations according to different prescribed accounting policies (US GAAP and GASB) stated in the Prospectus or Investment Management Agreements.
• Primarily involved in the Mutual Fund trading activities of Domestic and International Equity, Fixed Income, Money Market, and Cash Investment.
• Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a Market Risk Data Repository (RDR) as required by Basel II reporting regulations.
• Performed data analysis by using SQL queries using the DB Artisan tool.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Run the SQL queries using TOAD and SQL Navigator.
• Conducted routine meetings with PMO and other cross functional team members for better organization and documentation of existing documents such as project plans, project meetings and requirements.
• Created accessible requirements repository which helped improve team communication.
• Also Involved in Requirement gathering and preparing BRD for reporting processes.
• Prepared User Acceptance Testing test plans and conducted UAT Testing. Also prepared user reference documentation.
• Prepared test Data and performed data testing using the SQL. Also used MS excel for data mapping and data analysis.
• Developed requirements traceability matrices and used for tracking the project status through Initiation till deployment.
• Conducted User training sessions, coordinated post audit meetings and effectively documented the lessons learned.

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio),, Oracle, XML, IBM Mainframes, RUP, UML, SQL, SWOT analysis

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:-

• Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.
• Involved in pre implementation, implementation and post implementation efforts
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data.
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• Primarily involved in the Mutual Fund trading activities of Domestic and International Equity, Fixed Income, Money Market, and Cash Investment.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system (OMS), Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Supported Chief Compliance Officer in tracking, reporting, and maintaining all records relative to BSA/AML program including writing and updating guidelines and procedures and standardization of operating procedures.
• Manage changes to requirements through change control -clear case, MQC, Documentum.
• Gathered requirements for the integration of POS system with the supply chain Management (SCM).
• Worked closely with developers to define time calculations for regular overtime and special overtime pays.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle.
• Manipulating market data with data interface to conduct quantitative analysis such as CAPM, PE Ratios, Duration, Var, etc., and with the underlying financial instruments to set up Index Portfolio.
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Developed standards and procedures that ensured compliance with SOX.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Reviewed requirements and answered questions from off-shore testing groups to test key functionality changes with the upgrade.
• Coordinated with different agencies in tracking the progress of the software development and resolving the issues and worked with the UI team to create the User Interface Mock-ups to be presented to the Business.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.
• Attended Workforce Connect training and assisted Timekeeper administrators with their functions such as reporting Genie and automating workflow approvals.
• Worked closely with the vendor to define work rules for different types of exempt and non-exempt employees.
• Analyzed application requirements with UML modeling (Rational Rose) and documented Dialogue application output management and FileNet Enterprise Content Management (EMS) solutions.
• Conducted Functional Testing, Joint Functional Testing and UAT, documented and reported user feedbacks to management team.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
• Reported the bugs, Email notifications to the developers using Test Director.
• Customized the test scripts using check points, synchronization and parameterization of data.
• Automation of test scripts was done using QTP for test re-usability of different online transaction modules.

Environment: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), Lotus Database, Microsoft Visio, Windows NT/XP, Jira, SQL, SQL Server, EVPN, RUP, UML.