SUMMARY:

• Professional Business Analyst with outstanding track record of 6+ years experience in financial sectors including Investment Banking, Retail Banking, Prime Brokerage, Equities, Fixed income, Securities, Derivatives, FX Derivatives, Mutual Funds, Trading & Compliance and Risk Management.
• Worked closely with PMO and assisted in monitoring various project deliverables and involved in developing Project Plans, Project charter, project dashboards, Objectives and timelines and maintained the repository for all deliverables.
• Deep understanding of Trading Platform Building Blocks: Static Data Requirement, Market data Structures, Pricing, Model Validation, Portfolio Risk analytics, P&L, Risk Confidential ribution
• Comprehensive knowledge of and solid experience in Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives.
• Expertise in Business Process Modeling, Business Process Re - design and in designing Process Architecture.
• Extensive experience in Investment Advisory, Wealth Management Services and Product Management. plan account identifiers for Identifying and establishing retirement the Customer Profile System
• Familiar with Bloomberg Data Interface and Data Manipulation.
• Excellent understanding of US GAAP, Custody accounting and reporting, SOX and BASEL II, Compliance, Reg T, Corporate Actions and Risk analysis with solid experience in Business Process Modeling, Requirement gathering and Analysis in for financial products such as Equities, Fixed Income Instruments, Credit Risk, Market Risk Analytics, and Derivatives.
• Expertise at project charter, project plans, conducting project initiation meetings, defining the project objectives, scope, effective coordination with PM and PMO office and defining milestones, timelines and project documentations with clear who’s who.
• Hands on expertise in Data flow modeling, ER diagrams, Business rules identification and data analysis.
• Worked all the phases of Project life cycle. Project management experience; preparing project charter, risk assessment and mitigation plan, work break-down structure (WBS), Gantt chart, assigning milestones etc.
• Strong hands on ability to use SQL in RDBMS (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble-shooting.Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Extensive experience in Software Development Life Cycle (SDLC), Project management life cycle (PLC) and software development methodologies such as Agile,Scrum, RUP and Waterfall.
• In depth knowledge in Equities and other OTC products Trade Processing including front office, middle office & back office operations and trading life cycle (Sale, Order generation, Execution, Reconciliation, Clearing, Settlement and Books & Records).
• Extensive experience process models using UML flow charts, sequence, activity diagrams and use case diagrams and produced other design artifact using object oriented analysis technique.
• Experience preparing QA Test Plans, Test Schedules, defining testing strategies, test conditions and executing the test plans, used Mercury suite for test management and QTP for automation.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, OracleInternet: HTML, XML

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, DOORSBug Tracking Tools: Mercury TestDirector, Rational ClearQuest,Jira

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Testing Tools: Quick TestPro (QTP), Test Director, Niku, WinRunner, LoadRunner.

Financial Terminals: Bloomberg, Reuters

PROFESSIONAL EXPERIENCE:

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, 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 e Confidential ypting 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.
• Confidential ended 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.

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, Murrysville, PA

Business Analyst

Responsibilities:

• Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams
• Conducted workshops with Business, Design, Security and Other stakeholder to capture Non Functional Requirements for all the platforms.
• Conducted Analysis of Scalability, Usability, and Availability Requirements for all the platforms
• Conducted workshops for Use Case writing with User experience groups.
• Created Use cases for the various functionalities of Deposit Products.
• Worked on Investment/portfolio management in multicurrency securities, equities, Fixed Income, portfol0io accounting and related back office processing, lifecycle of a trade, Lifecycle of an account, Security setup, Account setup, Reconciliation.
• Identified business process models for International Business in Asset Management, fixed income, and mutual funds
• Worked extensively on Rational Requisite Pro to create Requirements specification.
• Conducted training for new team member for the Project.
• 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.
• 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)
• Gathered Web Content Management requirements from business units, translated those requirements into wireframe designs, and delivered HTML and CSS wireframe prototypes to client for implementation.
• Utilized corporation developed Agile SDLC methodology. UsedAgile/ Scrum Work Pro and Microsoft Office software to perform required job functions.
• Developed test plans with QA team and helped to develop test scenarios for system testing, integration testing and performance testing.
• Conducted Functional Testing, Joint Functional Testing and UAT, documented and reported user feedbacks to management team.
• Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.
• Write Detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, reference data, data Confidential ributes and security master database.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project is Data Mapping.
• Designed advanced search engine features for the web portal using MS SQL server full text searching, indexing and query optimizations.
• Defined and created a wide range of documentation: business requirements, system requirements, UML use cases, test cases, wire frames, GUI and portal design, Visio flows, training manuals, and user guides
• Evaluated online request forms in accordance with SOX. Coordinated IT Departmentýs response to SOX controls in a timely and effective manner
• Responsible for business system analysis of customizing the Market Risk Management product with involvement through the whole SDLC
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Involved in all phases of software development life cycle in RUP framework.
• Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Performed data analysis by using SQL queries using the DB Artisan tool
• Extensive experience in using collaborative tools like Mercury Quality Center to facilitate development across disparate teams

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio),, RUP, UML, SQL, Agile/Scrum, Basel II, SWOT analysis.