Business Analyst Resume
Herndon, VA
SUMMARY:
- Over 7+ 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.
- Created mortgage origination process workflow.
- Applied underwriting knowledge of guidelines while underwriting all types of loans including Conventional, VA, FHA, Residential and Commercial mortgage loans.
- 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)
- Analyze and interpret complex commercial mortgage documents, financial documents and leases.
- 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 Rose, Rational Requisite Pro, MS Visio, MS Project
Defect Tracking Tools: Test Director/Quality Center, Clear Quest
Testing Tools: Quick Test Pro, Win Runner, Load Runner, Quality Center, Test Director, Silk Test, Silk Performer, Rational Clear Quest
Languages: C, C++, XML, Java, SQL, Visual Basic
Database: ORACLE, UDB, SQL Server, and Access 2000, Automation DB cleanup utility
Application Servers: IBM Web Sphere, BEA Web Logic and IIS
Operating Systems / Platforms: Windows XP/2000/2003/NT, Unix, Linux.
Office Applications and other tools: MS Office, IRise Studio
PROFESSIONAL EXPERIENCE:
Confidential, Herndon, VA
Business Analyst
Responsibilities:
- Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
- Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
- Working with the business to understand and determine system implications in terms of the platform(s), application(s) and business processes for B2B solutions.
- Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products
- Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Captured Data flow diagrams and formatting of the data flowing through interfaces.
- Written PL/SQL packages to call the API to ship confirm the orders in oracle applications
- Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
- Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
- 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.
- Finding, filing and tracking bugs with JIRA using debugging and production databases
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities
- Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
- Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
- Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
- Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a central Risk Data Repository (RDR) as required by reporting regulations.
- Involved in changing the functionality to calculate due date in the transaction for Proxima payment terms and changed the auto adjustments package to pl/sql code instead of pro C code.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
- Assisted the SA to document all custom and system modification after the SCR’s were satisfactorily solved.
- Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion
Environment: JSP, Oracle, HTML, XML,DOORS, Clear Case, Clear Quest, Jira, XSL, PL/SQL, Rational Rose, MS Visio, RUP, UML, MS Project, SQL, MS Access, MS Excel and MS Word
Confidential - Covington, KY
Business Analyst
Responsibilities:
- Gathered requirements from business users and analyzed them using Rational RequisitePro.
- Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
- Lead the management and organized corporate response to an FTC market conduct investigation, resulting in a rare finding of 100% compliance with federal regulations based on compliance with previously-developed policies and procedures.
- Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
- Entity Master support for Data Governance, Regulatory Compliance for Client Data, Dodd-Frank.
- Worked deeply into Basel II Operational Risk software application project which generated governance and audit reports for mark to market product control, trade surveillance, counterparty risk, trade desk position limits, erroneous trade execution risk and rogue trader fraud.
- Expertise in Performance Management, Asset Management, Cash Management, Portfolio Management, Credit Management, Client Reporting and implementing its benefits.
- Good understanding of Financial Statement Analysis, Capital Budgeting, Portfolio Analysis & Stock Valuation.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
- Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio.
- Participated in the vendor selection process by, doing a GAP Analysis on the vendor (clearing broker) contracts and once selected, served as a liaison between the vendor and the Business Design Team.
- Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Researched, analyzed, gathered data, defined and developed requirement specifications for Mortgage Product, Compliance and Regulation Projects and performed testing. Responsible for Monitoring various agency updates, compliance notifications and laws. Maintained professional and effective communication with internal staff and clients providing follow through.
- Formatted the front-end screen to ensure its compatibility with SWIFT format.
- Proficient in Data modeling and mapping ER diagrams and hands on experience with Erwin data modeler
- Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution
- Implemented the entire RUP Methodology of application development with its various workflows, artifacts, and activities.
- Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing.
- Tracked changes using Rational ClearQuest.
- Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place.
- Conducted User Acceptance Testing (UAT).
- Participated in developing of Training Materials for the new technology and User Training.
- Worked effectively with Project Manager in handling the whole project.
Environment: Windows, Oracle, SQL, MS Visio, MS Access, MS Project, MS SharePoint, UML, Requisite pro, Rational ClearQuest.
Confidential, St. Paul, MN
Business Analyst
Responsibilities:
- 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.
- Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
- Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
- Facilitated with Data Governance effort and assert best practices
- Implemented full project lifecycle phases including Requirements Gatherings, Design and Analysis, Construction, Integration, Quality Assurance, and Installation.
- Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process.
- Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
- Offered excellent Cash Management Services including Account Reconcilement Services, Automated Clearing House, Balance Reporting Services, Cash Concentration Services and Sweep Accounts to large business customers
- Documented Business Process Requirements with Use Cases and facilitated JAD sessions to define AS IS and TO BE IT processes for the TIERS project a conversion from Unisys COBOL to client/server.
- Facilitate with Data Governance effort and assert best practices
- Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
- Worked with other BAs to make an Object-Oriented Model of the application and create Use Cases.
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
- Used Test Director and HP/Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- Create and maintain requirements, test cases and defects in Mercury Quality Center
- Provided superior client interaction to make sure all needs were met.
Environment: SDLC, Rational Tools Suite (Rose, RequisitePro, Clear Quest, Clear Case), HP/Mercury Quality Center, UML, SQL, MS Project, MS Office.
Confidential, Overland Park, KS
Business Analyst
Responsibilities:
- Assisted PMO Leadership Team with the coordination and administration of the Project Management Office including but not limited to the following activities: managing and adjusting project timeline, IT development work efforts for standardization of project implementations, administration duties, monitoring deadlines, activity and issue tracking.
- Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
- Cash management practices were implemented in the project for automated clearing house, sweep accounts, and balance reporting services.
- Working with clients to better understand their needs and present solutions using structured SDLC approach.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- 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).
- Interaction with clients to understand a broad range of reporting requirements and validating it with the regulatory requirements for reporting for a Prime Brokerage.
- Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD).
- Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
- Prepared Requirement specification document for Cash Management Module with the Client
- Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director.
- Worked with SMEs of different groups to gain detailed knowledge of Treasury Services, Commercial Loans, and RSA SecurID Setup to understand the cross impacts of the system.
- Prepared Cash Reconciliation Workflow.
- Conducted Gap Analysis to define the impact of the new requirements on the existing GUI and further prepared Business Impact Analysis Reports.
- Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access
- Worked on multiple short-term projects in between and co-led teams
- Conducted Joint Application Development (JAD) sessions to allow different stakeholders to communicate with each other, resolve problems at an early stage.
- Coordinated with the test team to check the Weekly Status and Report it to the Project Manager.
- Responsible for Interacting with the Developers to explain the proposed changes and ensure understanding of the system requirements to handle these changes.
- Generated reports using Crystal Reports.
Environment: SDLC, UML, User Count Tool, Rational Tools Suite, MS Project, MS Office, Windows XP, SQL.