SUMMARY

• Over 7+ years of experience in Financial Accounting and Financial Reporting, Business Requirement Gathering, Business Process Modeling.
• Extensive experience in Software Development Life Cycle (SDLC) from inception to transitioning with different methodologies such as Waterfall, RUP, Agile.
• Expert knowledge of finance industry, 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)
• Experienced in gathering user requirements, analyzing and preparing Project Deliverables such as Business Requirement Document (BRD) and Functional Requirement Document (FRD) and proposed changes for process improvement.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements, identify Functional and Non - Functional requirements, document and verify Business Rules, and subsequently model them for development.
• Excellent Skills in Performance Management to support strategic planning, goal setting, strengthen accountability, enhance decision making, and improve customer service.
• Good working experience on creating Use Cases, Activity Diagrams, Unified Modeling Language (UML) using MS Visio.
• Expert in performing GAP analysis.
• 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)
• Having work experience with product development lifecycle management.
• Experience with creating of UML diagrams such as Activity, Use Case, Flowcharts, using rational products and MS Visio.
• Having work experience on JIRA.
• Strong experience in all aspects of the implementation process/business process re-engineering through ‘AS IS’, ‘TO BE’, GAP analysis, Blue Printing, Prototyping, Realization, Development, Testing, Go-Live and Support.
• Strong Knowledge of UML Use Case Diagram, Sequence Diagram, Collaboration Diagram, Activity Diagram, Class Diagram, State Diagram, Package Diagram, Component Diagram, and Deployment Diagram.
• Excellent documentation skills and experience developing Test Cases, defect tracking and Requirement Traceability Matrix (RTM).
• Experience in conducting Joint application development (JAD) sessions, workshops and requirement elicitation sessions with end-users, clients, stakeholders and development team Familiar with RDBMS and able to handle SQL to manage and retrieve data from the database.
• Experience in writing Test Cases, Test Scenarios, developing Test Plans and conducting User Acceptance Testing.
• Strong SQL knowledge on Queries, Stored Procedures, Triggers, Cursors, User Defined Functions (UDF), Views, and Indexes.
• 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.
• Interacted with Subject Matter Experts (SME’s) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Analyzed business requirements and segregated them into high level and low level use cases, activity diagrams, and sequence diagrams using Rational Rose according to UML methodology.
• Worked on Requirement Analysis, Coordinated Designing of Documents and development, writing, execution of detailed Test Cases & Test Plans.
• Analyze Client data, documentation and negative news in order to determine Client Risk Profile as established under the Global KYC Procedures
• Experience in Enterprise Test Management and Defect-tracking tools like JIRA
• Involved in re-testing defect fixes for defect closure and updating in JIRA
• Created wireframes and prototypes of the new web interfaces to communicate the ideas to the business users and the management teams.
• Created Use-Cases, Wireframes and State Diagrams to demonstrate software architecture and interaction of system components before prototyping. Used Rational Rose, Requisite-Pro for requirement traceability
• Prepared User Interface Document (UID), wireframes and prototypes to help design user interfaces.
• Having work experience with IT Project Analysis Support & product development lifecycle management --agile and waterfall and experience in strategy and innovation.
• Identified UI requirements, createdWireframes,PrototypesandUI specificationusingAxure.
• Developed use case with UML for new product functionality. Updated SOPs and WR.
• Analyzed risk and issues and communicate with stakeholders for timely corrective actions.
• Elicited and documented high level business requirements with in defined SLfAs involving key stakeholders from both business and IT, estimate project feasibility and ensure requirements documented meets audit standards
• Managed entire project lifecycle and performed GAP analysis to differentiate between the "as is" and "to be" systems. Involved in business process reengineering (BPR).
• 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.
• Assisted project team leads in tracking budget and status of multiple medium and large scale projects, and also maintained all process documentations using MS Visio.
• 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.
• Held walkthroughs with the developers and QA teams in order to create a better understanding of the system requirements.
• Developed script to perform Data validation on account level by using Teradata SQL Assistant, SQL scripts.
• Wrote custom SQL that takes marketing campaign definitions, rules and selection criteria and enables execution through Teradata.
• 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.
• Documented business processes, business rules. Participated in the identification, understanding and creation of business requirements (BRD), including the applications capable of supporting those requirements.
• Participated in the daily Scrums, Sprint Planning Meetings and Sprint Demo and Retrospectives.
• Support QA team with creation of test plan, test cases, for system integration and performance testing.

Environment: Agile (Scrum), UML, Requisite Pro, Rational Rose, Teradata, Clear Quest, SQL, Windows XP, MS Office Suite (Word, Excel, Access, Power Point, Outlook), PL/SQL, Oracle, Windows.

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.
• Incorporated Agile SCRUM methodology to create Business Requirement Document specifications utilizing MS Visio and MS Word.
• 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.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Involved in data mapping between old data warehouse and new data warehouse (Teradata).
• Assisted with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• 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.
• Write custom SQL that takes marketing campaign definitions, rules and selection criteria and enables execution through Teradata.
• Worked with development and testing teams to accomplish timely release objectives.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Provided remote and onsite support to end user during and post implementation.

Environment: Agile (Scrum), MS Visio, Rational Requisite Pro, Rational Rose, UML, SQL, PL/SQL, MS Office, MS-Project and Windows.

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
• Created detailed sequence diagrams, activity diagram to elaborate the behavior, structure and process flow.
• Documented and analyzed SQL queries against various databases and generate reports as per company requirements.
• Analyzed the strategies of Risk management, Mortgage, Fixed Income and Derivatives in the investment division and conducted Portfolio Performance measurement: return, calculation and attribution.
• 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.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• 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.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS.
• 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.
• DevelopedUse Casediagrams,businessflowdiagrams,Activity/Statediagrams andSequence diagramsusing Rational rose so that developers and other stakeholders can understand thebusinessprocess.
• 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.