SUMMARY

• Over 7+ years of experience in Financial Accounting and Financial Reporting, Business Requirement Gathering, Business Process Modeling.
• Expert knowledge of finance industry, mortgage, capital markets (Primary market & secondary market), Asset management/Portfolio, Risk management/Wealth management, Retail private banking and Investment banking.
• Experience working with exchange trade and processing lifecycle from issuance, trade, clearing and settlement for investment bank, broker/dealer.
• Thorough understanding of Money Laundering phases (placement, layering, integration)
• Experience with various Software Development Life Cycle (SDLC) methodologies including Agile, Waterfall and RUP.
• Proficiency in requirement elicitation by coordinating and facilitating JAD sessions, brainstorming, conducting interviews with users, document analysis.
• Extensive experience gathering requirements and document workflows in to Business Requirement Document (BRD), Functional Specifications, System Requirement Specification (SRS), GUI artifact, Data element documents with in Service Level Agreement (SLAs)
• Experience with creating of UML diagrams such as Activity, Use Case, Flowcharts, using rational products and MS Visio.
• Excellent documentation skills and experience developing Test Cases, defect tracking and Requirement Traceability Matrix (RTM).
• Strong knowledge in planning and execution of the Extract, Transform, and Load (ETL) Process.
• Expertise in Data quality management, Data Modeling, Data Analysis, Data Warehousing and Data Mapping, Development of Entity Relationship diagram, SQL and reporting process.
• Ability to handle simultaneous projects, meet critical deadlines and timely execution of several client/server projects.
• Organized, goal oriented, priorities multiple task effectively, exceptional problem solving and sound decision making capabilities with excellent communication and Analytical skills.

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite

Business Skills: Requirement Analysis, Business Rules, Data Flow Diagram, Flowcharts, Business Process Modeling & Improvement, Gap Analysis, Prototyping, Cause and Effect Analysis

Methodologies: WATERFALL, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro

Operating Systems: Windows XP/95/98/2000, Mac OS X

Databases: Oracle 11g, SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL

Content Management Tools: Documentum, SharePoint

Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, HTML, PHP, Java, SQL, PL/SQL

Cloud and Virtualization: Windows Azure, VMware Horizon View Client

Development Tools & Technologies: Oracle Developer, Visual Studio, Eclipse, JUnit, Wamp Server, Komodo Edit, SDLC (Agile, Waterfall), Team Collaboration (GoToMeeting, WebEx)

Reporting and Data warehousing Tool: Tableau, Informatica Power Center

PROFESSIONAL EXPERIENCE

Confidential, New York

Business Analyst

Responsibilities:

• Assisted scrum master to define project scope, risk involved, and developed project time lines for on time delivery (managing triple constraints for the project).
• Assist AML supervisor and ensure that database are effectively provided only those situation that are truly suspicious.
• Identify high risk customers and investigate potentially suspicious activity referred to the Retail Deposits and involved in assigning automated suspicious activity.
• Analyze Client data, documentation and negative news in order to determine Client Risk Profile as established under the Global KYC Procedures
• Analyzed risk and issues and communicate with stakeholders for timely corrective actions.
• Elicited and documented high level business requirements with in defined SLAs involving key stakeholders from both business and IT, estimate project feasibility and ensure requirements documented meets audit standards
• Prepared business process models and document workflows, defined present state flow that covers “As - Is” then defined the future state that covers “To-Be” diagram based on the requirements.
• Interacted with SME’s (Subject matter experts) of different divisions and followed a business analysis and design methodology around the agile (scrum) methodology.
• Conduct JAD sessions involving SME’s, business users and other stakeholders for better understanding and refining of the requirements and project scope.
• Ensure requirement changes were properly communicated and documented to the team.
• As scrum master created and prioritized the backlog, involved in scrum sprint, planning sessions, daily stand ups, sprint reviews and retrospectives.
• Defined functional specification, created UML diagram, Business process flow, Activity diagrams using Visio to document system functionality and requirements.
• Designed data models for data in collaboration with data architect and data modelers, supported in creating ER diagrams defining entities, attributes, relationships and business rules.
• Support QA team with creation of test plan, test cases, for system integration and performance testing.

Environment: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint, SQL, UML

Confidential, Providence, RI

Business Analyst

Responsibilities:

• Prepared and review complex financial analyses including transaction impact analysis.
• Build detailed financial models to evaluate performance under various operating scenarios and to analyze the impacts of different capital structures, portfolio rebalance and analysis, compliance and credit research.
• Acted as a liaison between investment bank brokers, wealth management team, industry experts, system users, client managers and software development team to gather requirements and document work flow and result of business analysis in to Business Requirement Document (BRD) that meets audit and SDLC standards.
• Constantly Partnered with project leads to ensure the team is providing solutions that meet established standards, procedures & practices, address issues, risk and mitigation plans.
• Assisted Project manager in maintaining and monitoring the progress and status of the project, providing high level estimate of efforts for analysis, implementation and support, estimating delivery schedule and resource allocation.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve any issues, come to an agreement and achieve goals.
• Performed feasibility and risk analysis to identify the business critical areas from the user perspective based on capital market risk in various securities and derivatives that enable investors to analyze and rebalance portfolio.
• Measured project performance on time and budget as per project plan
• Developed Use Case diagrams for every conceivable scenario, Activity diagrams, and UML diagrams in MS Visio.
• Performed requirement walkthroughs with the development and QA teams with the aim to develop testing strategies and test plan such that test cases reflects user needs.
• Documented and track defects, as well as produced detailed report.
• Worked extensively with client requirements to generate customized SQL reports.
• Defined and reviewed the data warehouse requirements with the business users for getting the right data from source system to reporting purpose.
• Provided remote and onsite support to end user during and post implementation.

Environment: MS Office, MS Visio, UML, Microsoft SQL Server, JAD.

Confidential, Mount Laurel, NJ

Business Analyst

Responsibilities:

• Collaborated with project manager to define project scope, risks, and determined appropriate methodologies to apply based scope/vision documents and developed project time lines for on time delivery based on SDLC methodology.
• Mediated users and stakeholders conflicts on requirements through JAD sessions.
• Analyze and communicate risk involved in modification of high risk loans.
• Facilitated discussion involving key stake holders from both business side and IT side to elicit high level requirements related to system ability to revert modifications within certain time period, history of each loan change and repayment structure, change due dates, or defer a payment to the end of the loans to help troubled borrowers.
• Maintain audit trail for loan modification approval and loan change.
• Identified and documented business needs and created detailed Use Cases using UML, and collaborated with team to identify existing processes and system gaps and created functional requirement document (FRD) that supported overall goal and objectives
• Present case information and settlement proposals to Management, Key Executives, and Counsel as required. Advance skills developed through substantial default mortgage servicing and origination experience.
• Created detailed sequence diagrams, activity diagram to elaborate the behavior, structure and process flow.
• Performed data manipulation and data analysis in SAS to develop analytic insights for daily mortgage operations
• Documented and analyzed SQL queries against various databases and generate reports as per company requirements.
• Worked alongside QA manager in creating various testing scenarios for integration and system testing.
• Assisted Project Manager creating Project flow, monitoring project progress and status, estimating delivery schedule and resource allocation.
• Maintained Traceability Matrix for the current business processes and proposed change.
• Reported user feedback to the management team and assisted in User Training for the new system.

Environment: Rational Requisite Pro, Rational Rose, Rational Clear Quest, Rational Clear Case, UML, Microsoft SQL Server, MS Office.

Confidential, Hatboro, PA

Business Analyst

Responsibilities:

• Conducting user interviews at both in-house and client locations gathering and analyzing requirements and implemented those ideas in to developing GUI wire frames models, technical and functional specifications.
• Worked closely with retail brokerage team, strategic wealth professionals, portfolio managers, fixed income support team, project managers, and developers to enhance functionality and to correct problems with fixed income trade related system.
• Developed several customized reports for clients querying Oracle database, holding reports, Trading data, Account balance report and clearing and settlement report.
• Designed and developed ERD, Use Cases, Activity diagram, identified, analyzed, defined and documented business processes and use case scenarios.
• Conducted JAD sessions with portfolio managers, traders, project stakeholders for open and pending issues to develop specifications.
• Ensure timely completion of project tasks, and deliverables with high degree of quality and prioritizing task appropriately and resolve issues along with project manager.
• Performed manual Testing along with testers.
• Worked with Quality Assurance Analyst in HP Quality Center to track defects.
• Collaborated with the Project Manager to organize training material and user manuals.
• Worked with SQL queries such as select, insert, update and delete for data manipulations.
• Work on profiling the data for understanding the data and mapping document.

Environment: MS Office, UML, Visio, Oracle, SQL.

Confidential

Finance Executive

Responsibilities:

• Setting up the new Vendors in the system as per the compliance.
• Name change/Address Change as per the requests received.
• Coordinating with the branches for the required necessary documents before vendor set up.
• Strong Excel skills to utilize advanced functionalities, e.g. data analysis, data cleansing, data transformation.
• Trained the new joiners on the process and the system before going for 2nd transition from the company.
• Preparing the pay cycle on weekly basis and sending to corporate office.
• Coordinating with branch to make sure all the invoices are getting processed so that payment can be made on time.
• Experience marketing and selling structured financial products to institutional clientele, including portfolio managers, hedge funds, pension funds, and insurance companies.
• Always avoided credit holds from the vendors.

Environment: MS Office suite, Windows.

Confidential

Fixed Assets Business Analyst

Responsibilities:

• Addition, Retirement, Transfers, Reinstatements of Assets
• Review of the Addition, retirement, Transfer & Reinstatement forms Prepared by the processors
• Clearing accounts and Fixed Assets Accounts Reconciliation
• Preparation of Statutory Reports to the on monthly basis for Client management.
• Preparation of Required Journals
• Managing the team in absence of Team leader.
• Training New joiners
• Helping accounts payable team members in case of high volumes

Environment: MS Office, Windows.