SUMMARY

• Business Analyst with 6+ years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Deep understanding of Investment Management, Asset Management, Mutual Funds, Prime Brokerage Services, Money and Capital Market Instruments while working at the front office & middle office.
• Valuable experience in Capital Market products & Treasury, Fixed Income trading systems (Equities - Stocks & Bonds, Money Market Funds (MMF), CDs, Swaps & Repos), Equity trading, Portfolio Management, Exchange Traded Funds (ETFs) and Financial Risk Management.
• Analyzed financial risks such as Credit Risk, Market Risk, Operational Risk, Interest Rate Risk, Volatility risk, etc., associated with securities and measuring risk using metrics such as VaR, Duration, and Convexity.
• Comprehensive knowledge of and solid experience in OTC Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives.
• Subject Matter Expert (SME) in Business Risk Analysis, Hedge Funds, Financial Reporting, Portfolio Analysis, BASEL I, II, SOX compliance, Dodd - Frank Act, and Client-Server Applications (CSA), Securities, Equities, OTC derivatives, Inter-Dealer Brokerage, Brokerage House.
• Knowledge of BASEL III Accords and its impact on US (Risk-based Capital and leverage requirements, Market Liquidity & other Macro-economic impacts).
• Experience of working at the front office and dealing directly with traders and brokers. Familiar with trade process and trade capture.
• Experience with ClearCase for repository management, ClearQuest for change management and handling change requests and proposals to Change Control Boards (CCBs).
• Worked on web-based user interface projects and Data warehouse projects.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

• OOAD (OOA/OOD)
• RUP
• UML
• UAT
• SDLC
• Waterfall
• QA
• WAP
• CVS
• TEAMMATE
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. Windows 98/2000/XP basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Siebel
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• RequisitePro
• CaliberRM
• Crystal Reports various NIKU products
• C
• C++
• Sharepoint
• Docushare
• Intermediate level-Visual Basic.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr Business Analyst

Responsibilities:

• Financial products involved: Fixed Income, Equities, Exchange Traded & OTC Derivatives (Credit Risk Derivative, Interest Rate Derivative, FX Derivative, Cross Currency Derivative - Floating & Fixed)
• Leverage strong business knowledge of the investment banking sector to help design viable solutions.
• Worked with SMEs at the front office to understand various assets and security classes, capital markets and fixed income securites (such as Bonds, Repos, Money Market Funds (MMF), CDs & Treasury Products), trade capture (such as issuer, principal, coupon, maturity, issue, indenture, repo & collateral) and portfolio allocation.
• Involved in documenting and redesigning of an Anti-Money Laundering Continuing Education automated system required by Patriot Act Law.
• Logical and Physical model design, Data warehouse standard naming conventions for all objects and Meta data mapping for legacy systems.
• Experience of working with Summit application at the front office and dealing directly with the traders to perform trade capture. Worked on securities lending such as Repo Trading, Collateral Substitution, Bonds (Primary & Secondary) and treasury (T-Bills, T-Notes, T-Bonds & Tips).
• Solely responsible for carrying out several enhancements to the Billing work flow (Clearance & Settlement) & Cost Basis Adjustments (Tax). Worked with the risk Management team to review the sales and trading activities using VaR model - Monte Carlo Simulation, Market Risk & Credit Risk.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel III Accord at the middle office. Performed systematic study of uncertainties and risks to quantify the financial risks involved in each investment & trading and also allocated a risk budget across these activities.
• Creation and development of key documents such as Gap Analysis, Impact Analysis and Requirements documents via Caliber RM. Managed successful completion of metadata solution which included provision of data dictionary and search engine.
• Involved in handling daily, weekly, monthly activities based on stated policies & procedures, task/project management, change management, vendor relations and reporting to senior staff on key areas.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements. Analysis and definition of requirements via Use Cases and structured methodology tools such as Caliber RM.
• Worked at different stages of Software Development Life Cycle (SDLC) with business users, developers, and stakeholders. Reported the bugs, Email notifications to the developers using Test Director.
• Customized the test scripts using check points, synchronization and parameterization of data.
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Extensively experience in Fixed income trading such as Bond, CDs, Repo, Note, and Bill with estimation of Coupon Rate, Current Yield, YTC, and YTM.
• Understood Fixed Income Repos & securities lending, Treasury, Money Market Funds, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Interest, Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - OTC Derivatives (Swaps, Interest Rate derivatives, CDS, FX derivative),
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Extensively worked with SMEs in the analyses of Efficient Frontier, Risk Factors, Alternative Returns and CAPM Valuation Method.
• Involved in creation of data mapping documents and design documentation for data warehouse.
• 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.
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Delivered the monitoring & review of customer monetary activities for the Anti-Money Laundering initiative.
• Aimed at significantly improving the efficiency and effectiveness of the firm’s global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
• Involved in understanding of source to target data mapping, data design and developments for processes required to extract, transform, and load data into the data warehouse.
• Gathered and Documented Business requirements to contribute to the Risk/Return Analysis, and Portfolio Optimization and Diversification.
• Worked on project management, change management, documentation, scheduling as needed reports to higher management, technical training of end-users, and managing technical staff in configurations of client computers to comply with network standards.
• Develop the Front-end User Interface for users in the manufacturing floor using Callable-Comets, COBOL, DBMS, DBQ, and SQL. Conducted and Documented High level System Design.
• Involved in preparing a simple and detailed User manual and assisted training session of the new and improved system.

Confidential, Cleveland, OH

Business Analyst/Data Analyst

Responsibilities:

• Performed the requirement analysis and documented the requirements.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business users sentiments.
• Prepared for GAP Analysis & Root Cause Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance & risk management.
• Interact with business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
• Analyzed the business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Responsible for data profiling and data mapping. Responsible for designing Parallel Partition in Ab-Initio Graph for high volume data warehouse.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
• Worked on designed and developed customizations using VBA scripts, PL/SQL procedure, Perl and Unix shell scripts. Worked on data modeling and produced data mapping and data definition documentation.
• Developed the architectural solution using metadata models and resolved any bottlenecks in the ETL loading process while assuring compliance in all phases of the SDLC process by providing documentation, reviews, and data analysis summaries.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing AGILE methodology.
• Involved in the analysis to facilitate the transition of all current IBM mainframe systems and interfaces to a new package in a Sun/Unix/Oracle based environment.
• Transformed the perception of the Wealth Management (Insurance & Investment Business) function from unreliable department to a trusted service partner, leading to improved engagement, efficiency and partnership.
• Evaluated Competitors offerings and products including fixed income and derivatives.
• Developed data conversion strategy for data migration from MS Excel to MS Access.
• Used power point presentations for conduction walkthroughs with the stakeholders.
• Proficient in writing Test Plans, Test Scripts, Test Scenarios and Test Cases for both Manual and Automated Testing, testing ETL (AbInitio), Microstrategy, Data warehouse testing, BI testing, a good understanding of BI life cycle.
• Managed deployment of software change management (CM), incident/defect management with Rational Clearquest, and implemented a software release strategy, which included the introduction of a iterative Functional Demonstrations.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.

Confidential, Milwaukee, WI

Business Analyst

Responsibilities:

• Extracted the business requirements from the end users keeping in mind their business needs and documenting it for the developers.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
• Was responsible for creating the various end to end Straw man flows for the work streams and the Clearing Broker/Dealer using MS Visio.
• Used MS Visio to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams using UML
• Worked with SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using the VB Script.
• Implemented the Rational Unified Process (RUP) Methodology during application development.
• Extensively used Rational RequisitePro to gather and manage requirements.
• Monitored Performance measurement, Risk Management (VaR Model) and Asset management.
• Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements.
• Extensively involved in RAD session to achieve early a design acceptable to the customer and feasible for the developers.
• Maintained and managed various versions of the documents generated during the project using Rational ClearCase.
• Assisted Quality Assurance team in conducting User Acceptance Testing to verify that all the User Requirements were catered by the application.
• Involved in preparing a simple and detailed User Manual for the application for an intended novice user.