PROFESSIONAL EXPERIENCE

Confidential Dec. 2011- Till date
Responsibilities

• Prepared the Vision and scope documents for the project and worked closely with the Project Manager in planning, scheduling, coordination and implementing methodology.
• Responsible for Gathering Requirements from the Quantitative Risk Analysts and Portfolio Managers to produce Business and Functional Requirements for Risk Management Application.
• Responsible for regular interaction with the Equities, Fixed Income & Foreign Exchange Division to gather Market Data to base the Market Risk Analysis.
• Defined the functions and features of the application by designing the functional behavior of the system from the business perspective to simplify the purpose of the system.
• Also involved in managing and maintaining inventory which required interaction with members of different department namely managers, suppliers, vendors.
• Created analytical models that estimate future credit risk and losses at the account level for all existing and prospective loan products.
• Created documentations through risk analyzing research and made recommendations to Senior Management for credit risk management strategies.
• Developed and reviewed strategies using the various risk scores such as credit bureau, application, behavior, bankruptcy and USAA relationship scores.
• Developed risk tracking analysis and risk performance measures, such as custom score cards, for all Bank loan products.
• Assisted the development team during the 2nd and 3rd iteration using the RUP model.
• Elicited, analyzed, documented and communicated requirements for implementation and build outs of SharePoint.
• Provided solutions to the problems regarding operating systems, network, software and hardware.
• Managed critical paths and bottlenecks in conjunction with Project Tracking Reports for Senior Management.
• Handled various SQL queries for data manipulations.
• Responsible for assisting the Quality Assurance team to create the test plan, testing scenarios and test cases for functional, non-functional and UA testing.
• Facilitated the off-site development team with eMeetings to clarify requirements.
• Interaction with stakeholders to gather functional and non-functional requirements and represent them in Requirement Traceability Matrix.
• Performed Feasibility Analysis for the proposal of the new system.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Use of Active Directoryto assign policies, deploy software, and apply critical updates to the organization.
• Wrote test plans and test cases of the business process or application.
• Involved in the analysis and improvement of business processes in the area of Statement Processing by analyzing data required from the legacy system for the billing calculations Purchasing Power, Portfolio Holdings, Summary of Gains and Losses.
• Analyzed the strategies of Fixed Income and Derivatives in the investment division and conducted Portfolio Performance measurement: return, calculation, attribution.
• Extensively used MS Excel for data reconciliation purposes and assisted developers in creating Macros for data Reconciliation purpose.

Environment: Windows Pro, Oracle, SQL Server, Toad, Microsoft Office Suite 2010

Confidential,June 2010- Nov. 2011
Business Analyst

Wells Fargo & Company is a diversified financial services company, involved in providing banking, insurance, investments, mortgage, consumer and commercial finance through 9,000 stores and more than 12,000 ATMs. The project was to develop fixed income trading and settlement system for the broker/dealers of financial institution.

Responsibilities:

• Analyzed data from multiple sources and formulated recommendations to advise clients through written research reports, industry updates, and presentations; gathered requirements for project.
• Conducted various interviews and meetings for requirement gathering with key business users and SMEs at in-house location.
• Prepared roadmap design of fixed income trading/settlement system.
• Maintained and kept track of stakeholders request for system enhancements and changes.
• Used Rational Requisite Pro to track document requirements and to build the Requirements Traceability Matrix.
• Used Rational DOORS software to manage changes to requirements and ensure compliance with regulations and standards.
• Exposure to SOX regulatory (15 U.S.C. 7241 and 18 U.S.C. 1350) internal compliance, worked with external and internal users to ensure bank practices and disclosures were accurate and compliant with Act.
• Used Project Server 2010 and SharePoint to plan duration of project phases, provide traceability and to assign and update tasks.
• Documented the process of application for derivative solutions.
• Used Test Director for essential aspects of test management -Test Plan and Defects Management.
• Worked with development and testing teams to accomplish timely release objectives.
• Analyzed system functionality in relation to change requests and other system modifications.
• Used RUP guidelines to ensure disciplined approach to high quality software that meets end user needs, within predictable schedule and budget.
• Determined resource requirements and developed project plans and managed requirements.
• Created business requirements documents and technical specifications through meetings with both the users and technical team using detailed examples and process maps.
• Evaluated incoming project request for UAT support in order to determine the impacted systems, programs and/or downstream jobs or distributed applications which will need to be included in the project scope.
• Managed changes in requirements gathered though change request process under RUP guidelines.
• Involved in conducting daily brief scrum meeting, to explain progress, upcoming work and raised obstacles and brief planning session in which the backlog items for the sprint.
• Assigned and reviewed test cases created by the testing team in Quality Center.
• Triaged and tracked defects in quality center and sent daily defect report to project team.
• Formulated Test Plan and created detailed Test Scenarios and Test Cases from the use cases for Application and Interface Testing.

Environment: MS Project, MS Visio, Rational Suite (Requisite Pro, Clear Quest, Clearcase), UML, SharePoint.

Confidential, Jan. 2009 - Apr. 2010 Business Analyst
Deutsche Bank is a leading global investment bank with a strong and profitable private clients franchise. A leader in Germany and Europe, the Bank is continuously growing in North America, Asia and key emerging markets. With more than 78,000 employees in over 70 countries worldwide, Deutsche Bank offers unparalleled financial services throughout the world. The Bank competes to be the leading global provider of financial solutions for demanding clients creating exceptional value for its shareholders and people.

Responsibilities:

• Gathered and documented business and technical requirements from both formal and informal sessions.
• Used SharePoint to manage project through inception and planning phase, identifying key stakeholders and collaboratively describing project charter.
• Documented process flows and business rules for B2C and B2B in project charter document.
• Conducted user interviews and documented business and functional requirements.
• Conducted Equity Research to determine returns using techniques like DCF, Financial Statement analysis & P/E ratios. (Compared Asset returns against benchmarks like S&P 500 and Russell 2000.)
• Performed data mapping, logical data modeling, created class diagrams.
• Used SQL queries to filter data, respond to tax audit requests.
• Provided technical support of applications using Excel VBA (no longer offered by Microsoft).
• Managed offshore and onsite teams and defined processes, schedules and development guidelines.
• Analyzed the business and understood the core functions and implemented SOA.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Coordinated with outsource team for Designing & implementing data mart for internal reporting.
• Designed ETL process reading multiple data sources and pushing data into data mart.
• Applied business condition on ETL process.
• Used Microsoft Access/Excel advance functions (Pivot Table, Links, Charts, Data Base Export/Import and Queries) to analyze data information and also to create/modify in-house databases.
• Incorporated Agile methodology to create requirement document specifications.
• Integrated Requisite Pro with Clear Quest and Rose to provide visibility and maintain requirements traceability.

Environment: MS Visio, Clear Quest, Rational Rose, SOA, MS Access, MS Excel VBA, SharePoint.

Confidential, Sep 2006 - Dec. 2008
Business Analyst
Peoples Bancorp Inc. is a diversified financial products and services company with $1.8 billion in assets. It is offering a complete line of banking, investment, insurance and trust solutions through more than 40 locations. Peoples Bancorp\'s financial service units are Peoples Bank, Financial Advisors at Peoples Bank and Peoples Insurance Agency, LLC. The company’s common shares are traded on the NASDAQ Global Select Market.

Responsibilities:

• Conducted user interviews and JAD sessions to get an understanding of client business process.
• Gathered functional requirements from users and management (SMEs).
• Responsible for creating fixed income business requirements specification document (BRD) and credit derivatives functional specifications document (FSD).
• Interact with the project team to define system objectives and scope, and identify constraints and the measures of success for the credit derivatives and fixed income derivatives system.
• Gathered primary input/output requirements and modeled the processes using Rational Rose.
• Gathered data requirements for the Fixed Income system by interacting with the users and data administrators.
• Ensured application forms and reports (UI) followed client’s development standards and guidelines in terms of usage, naming conventions
• Checked that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Provided hands-on project schedule management using MS Project during the various stages of the project.
• Responsible for processing change requests from the client by filling Change Request Forms (CRF)
• Responsible for creating and maintaining documentation related to the project including scope document, vision document, functional specification document, defect status report, risk analysis document, mitigation plans, supplementary requirements specification document and impact analysis document.
• Deflected the impact of multiple report requests from the Business Intelligence users.
• Managed all the requirements in Requisite Pro, making requirements available to all team members.
• Developed reports, charts and graphs to analyze critical data.

Environment: MS Office, MS Project, Windows 2000, UML, SharePoint, Rational Suite.

EDUCATION

• Dual Major- Finance and Mathematics, Minor in Economics.