SUMMARY:

• Over 8 years of professional experience as a Business/Systems Analyst/QA Analyst with excellent understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, and Modeling.
• Deep understanding and experience of Investment 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.
• Strong knowledge and understanding in Retail Banking, Mutual Funds, Asset Management, Client On boarding, KYC, AML, Internal Bank Compliance Audits, Personal Investment and Risk Profile creation business processes. Experience in Dodd Frank, SOX, Basel regulation and protocols.
• 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.
• Strong knowledge of Financial Industry including Investment Banking, Finance industry including Credit Cards with emphasis on Business Requirements and Functional Requirements.
• 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.
• Validated / updated documents per Basel III standards and performed regression testing of the Basel EAD model for the entire OTC derivatives for the new regulatory capital models.
• 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.
• 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)
• 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: Rally, JIRA

Testing Tools: Quality Center, Test Director, Silk Test, Silk Performer, Rational Clear Quest, ALM

Languages: C, C++, XML, Java, SQL, Visual Basic

Database: ORACLE, UDB, SQL Server, and Access, Teradata, Hadoop

Application Servers: IBM Web Sphere, BEA Web Logic and IIS

Operating Systems / Platforms: Windows, Unix, Linux.

Mainframes Office Applications and other tools: MS Office, IRise Studio

PROFESSIONAL EXPERIENCE:

Confidential, San Fransciso, CA

Sr. Business Systems Analyst/QA Analyst

Responsibilities:

• Gathered requirements using Use Case analysis and Developed system requirements (SFD, HLD, SRD) from business requirements (BRD) and architect approach documents.
• Created requirements and design phase artifacts using RequisitePro.
• Analyzed and maintained business and systems requirements over SOA based applications.
• Performed the data mapping for the new Web services elements between Front end, Middleware & Back end systems.
• Used Jira for the projects tracking, product teams planning, building and launching the software.
• Participated Agile-Scrum story writing secessions and wrote executable stories for the projects assigned.
• Participated in Iteration planning secessions and added the stories & Technical tasks in Jira.
• Acted as liaison between Requirements Engineers, Developers & Testing Team to determine RTM in traceability.
• Had exposure to Lean Sigma within the project scope.
• 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.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• 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.
• Worked with Business Objects team to develop various reports related to Basel II reporting.
• Worked on bond options, interest rate options, stock market index options and simply index options.
• Participated in Brain storming sessions for Requirements gathering and GAP analysis of the requirements.
• Wrote SQL queries for data validation on the backend systems and used various tools like TOAD &DBVisualizer for DBMS (Oracle).
• Worked with FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
• Involved in Capital and Money Market Risk Management by estimating factors like probability an adverse circumstantial Risk and the cost of such adverse circumstance.
• Perform Data analysis, Backend Database testing, Data Modeling and Developing SQL Queries to solve problems and meet user’s need for Database management in Data Warehouse.
• Utilize object-oriented languages, concepts, database design, star schemas and databases.
• Create algorithms as needed to manage and implement proposed solutions.
• Participate in test planning and test execution for functional, system, integration, regression, UAT (User Acceptance Testing), load and performance testing.
• Developed the test plan, test conditions and test cases for UAT. Conducted UAT testing in batches for market risk, credit risk, reference data, and derivatives successfully and prepared manuals and rollout plans. Involved in production support and resolving the issue frequently.
• Work with test automation tools for recording/coding in Database, and execute in regression testing cycles.
• Working with Databases DB2, Oracle DM, SQL Server for Database testing and maintenance.
• Working on tools like Brio, Hyperion, Business Objects, DBArtisan, HP Quality Center, Lisa, QTP, Compare.
• Support Team Lead in completing test objectives in a timely basis and reporting it to business stakeholders.
• Test and debug Data Warehouse, Data Marts and applications.
• Involved in writing and executing User Acceptance Testing (UAT) with end users.
• Involved in Post- Implementation validations after the changes have been to the Data Marts.
• Involved in risk and gap analysis with the entire IT group
• Chart out Graphs, and Reports alike in QC to point out the percentage of Test Cases passed, and thereby to point out the percentage of Quality achieved and uploading the status daily to ART reports an in-house tool.
• Used UNIX to check the Data marts, Tables and Updates made to the tables.
• Writing advanced SQL Queries to query the data from Data marts and Landings to verify the changes has been made.
• Involved in Client requirement gathering, participated in discussion & brain storming sessions and documented requirements.
• Actively participated Functional, System and User Acceptance testing on all builds and supervised releases to ensure system / functionality integrity.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user sentiments.
• Interacted with developers to resolve different Quality Related Issues.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Wrote and executed manual test cases for functional, GUI, and regression testing of the application to make sure that new enhancements do not break working features
• Involved in writing and executing User Acceptance Testing (UAT) with end users
• Involved in risk and gap analysis with the entire IT group
• Writing and executing Manual test cases in HP Quality Center.
• Interacted with offshore development and validation teams
• Wrote test plans for positive and negative scenarios for GUI and functional testing
• Involved in Manual (black box) testing of the complex business application integrating with multiple systems throughout fox; as well as troubleshooting when systems are down
• Generated scripts for all written test cases for regression testing
• Involved in writing SQL queries and stored procedures using Query Analyzer and matched the results retrieved from the batch log files
• Estimate Development & testing impact of requested change controls.
• Created Project Charter documents & Detailed Requirement document and reviewed with Development & other stake holders.

Confidential, San Fransciso, CA

Business Systems Analyst /QA Analyst

Responsibilities:

• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Involved in activities like: Data Mapping, Data modeling and managing the team, requirement gathering, and Use case designing for technical team.
• 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.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Incorporated Automated Clearing House (ACH) functionality for the Private Label Credit Cards for Cash Advance abilities.
• Involved in implementing the migration of loan, savings and general ledger information from the banks former system processor, to the ADP system.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Creation and maintenance of user-friendly internal Compliance Policy and Procedure Manual that was proven to ensure the corporation was compliant via multiple investigations from federal and state regulators, as well as state attorneys general.
• 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.
• Attended workshops and meetings to provide enhancements and modifications to existing system.
• Responsible for writing Functional Requirement Specifications (FRS) and point of contact for System Requirement Specification (SRS).
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Worked as a business analyst to conduct JAD and elicitation sessions with the Private Banking, Capital Market business users and stakeholders to analyze end user objectives for Basel II Asset Classification and CRMT system and created business requirements specifications, use cases diagrams etc.
• Strong usage of Subject Matter expertise in Fixed Income, Equities, Equity Swaps, Equity Finance, Stocks Trading Cycle, Portfolio Analysis, Asset management, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives (Options-Including Vanilla and Exotic and Futures/Forwards), Credit Derivatives, Interest Derivatives, Alternative investment, Portfolio Management, Sales and Marketing. Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Recognize and leads the development and implementation of appropriate credit risk strategies.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
• Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Involved in manual/automation testing and UAT with the development team and QA team.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Facilitated Joint Application Development (JAD) sessions, one on one interview and meetings with business users and SMEs.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Created the test cases for all the Use Cases using EA tool.
• Converted multiple financial institutions onto the ADP banking processing system.
• 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.
• Multiple User Interface issues resolved by effectively interacting with the business users and conveyed these change requests to the technical team.
• Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (similar to XML), and TIBCO configure and provide custom enhancements to the client
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.

Confidential, San Fransciso, CA

Business Systems Analyst /QA Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• 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.
• Wrote business requirements for Derivatives Clearing process from LCH, through MarkitWire, into Citi’s proprietary system (ORION PBDI Prime Broker Derivatives Infrastructure).
• Incorporated Automated Clearing House (ACH) functionality for the Private Label Credit Cards for Cash Advance abilities.
• Created and executed test cases, test scripts, and scenarios for web applications (Analyst Workstation System), mainframe application (Full App), ADP system integration within Capstone for adjudicating applications for credit cards, real estate, mortgages, insurance, LOCs and loans.
• Used MS Visio to carry out the data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
• Converted multiple financial institutions onto the ADP banking processing system.
• 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.
• 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)
• Performed compliance reviews for, and assisted in the development of, 400 collection and subrogation form letters mailed to consumers and businesses. Integral team member within letter strategy and marketing initiatives.
• Coordinated ISG efforts to adhere to outstanding enterprise application software policies for security, audit and compliance reasons
• Gathered all the right requirements to determine key issues and foresee potential show-stoppers that might arise later and in-depth understanding of OTC derivatives operations.
• Developed and maintained Service Oriented Architecture (SOA) governance process costing models and metrics ensuring architecture compliance.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Analyze counterparty credit risk data generated from UAT test cycles.
• 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).
• Strong understanding of the demand generation campaign planning process including campaign and tactic planning and execution with tools: MEPT, BAT, EST, GRP, MAT, BPS.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Served as legal liaison between clients and the corporation for matters involving compliance and litigation.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Know and understand the laws applicable to money laundering, to include the BSA, the USA Patriot Act, U.S. Treasury AML Guidelines, OFAC requirements and Suspicious Activity Reporting requirements.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• 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.
• Responsible for wealth management portal project governance documents, project direction, conflict resolution, project metrics, daily Scrum meetings and product delivery
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Involved in Project for Data Quality Initiative (DQI) in compliance with Sarbannes-Oxley Act.
• Wrote project governance documents, organized project timelines and managed risks and issues.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Coordinated testing efforts between SunGard and the client.
• Manage and facilitate Enterprise Data Governance Working Group bi-weekly forum, capturing new demands and issues from all Line of Businesses and Corporate Functions.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
• Developed and support collaboration portal for data governance data stewards to share and exchange ideas.
• Research and development of enterprise data governance policies.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Developed Components using Struts Framework, J2EE; Coding for Components using JSP, Java Beans.
• Developed multiple Functional Requirements defiantion (FRD) documents using the Microsoft standard structure and format (business sections only)
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Confidential, San Fransciso, CA

Business System Analyst / Data Analyst

Responsibilities:

• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition. Effectively implemented Business Requirements gathering by using RUP.
• Performed the requirements gathering activity in a structured ways by applying context free questions, Interview business area experts asking detailed questions, and surveys.
• Recorded the requirements in Vision Documents and Software Requirement Specifications (SRS) using Requisite Pro.
• Draw Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Conducted Joint Application Development (JAD) sessions for Requirement analysis, risk analysis, feasibility studies to identify business critical and high-risk areas of the application.
• Built Informatica mappings (The mappings used Lookup, Aggregator, Source Qualifier, Expression, Sequence Generator, Update Strategy, and SQL override, pre-session and post session scripts, created sessions and batches).
• Identified potential gaps and suggested data definition changes, data flow changes.
• Worked with the Data Warehouse development team to identify business objects and their attributes and relationships.
• Conduct Brainstorming and JAD Session to gather Business Requirements from Market Risk Group, Risk Reporting Team and other stakeholders (PMEs, Compliance, etc)
• Assisted with users to generate DDLs to resize tables and indexes.
• Actively participated in the pre-testing that included review of the requirement documents, studying the Use Cases for developing test plans and collection of test data and installation/configuration of the required Rational tools.
• Used SQL for validating and verification of data structure. Worked in the ETL Procedures and processes. Reconciled disparate master data from distributed systems and synchronized the data.
• Executed test cases manually. Compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution.
• Performed UAT of the application by creating and running demo versions of the application with the prospective users.
• Performed walkthrough with the development team and system analyst and incorporated modifications in the original test plan before proceeding with the automated testing.
• Created requirements in Requisite Pro as per testing requirements in the Master test plan and associated them with corresponding tests.
• Maintained detailed documentation for future reference.