SUMMARY:

• An innovative and energetic Business Analyst/Data analyst with an MBA in Finance, and over NINE years of experience in business process analysis/modeling, business requirements elicitation and development of SOA & Web Based applications in the Investment Management/Capital Markets domain.
• Expertise in eliciting and synthesizing business requirements and ensuring those requirements meet approved business plans
• Experienced with Marklogic, Siebel CRM, Salesforce and workflow systems for financial services firms
• Good working knowledge of data warehousing concepts and reporting tools such as Cognos, Business Objects and Crystal Reports
• Extensive experience in creating Business Requirements Document (BRD), Functional Requirement Document (FRD), Technical Requirement Document & Data Mapping Documents.
• Experienced in SDLC methodologies such as Waterfall, Agile/Scrum and RUP with solid experience in requirement elicitation.
• Solid understanding of Fixed Income, Equities, Currencies, Derivatives (Futures/Forwards, Options, Swaps), Commodities, Trade Lifecycle and instruments such as MMF, CD, TD & MM. Excellent understanding of Security Master data in an investment management environment (sell side and buy side).
• Good knowledge of Process mapping and process modeling for financial services workflows.
• Expert in data collection, cleansing, validation, analysis, and reporting along with extracting & analyzing data from various sources, including databases, manual files, and external Websites.
• Strong knowledge in UML such as Use Cases, Sequence Diagrams, Collaboration diagrams, Activity diagrams, Class diagrams & Wireframe prototypes.
• Ability to create & document test plans & test cases, design test data sets, create manual test scripts; and, manage, execute & report tests. Extensively involved with Integration, Regression, Functional, System & User acceptance testing
• Experienced in performing Business Process Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Familiar with the current industry improvement standards such as Capability Maturity Model (CMM), Six Sigma, HIPAA & SOX along with new regulations such as Dodd Frank Act.
• Excellent Analytical skills and high level of convincing power demonstrated in a business environment
• Skilled in performing project management functional tasks such as preparing meeting agenda, organizing/conducting meetings, drafting business case and project charter, creating meeting minutes and status reports for senior management.
• Great interpersonal skills and ability to deal with all levels of business users and management. Strong time management skills in handling simultaneous multiple projects and deadlines under minimal supervision

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Microsoft Visio.

Methodologies: Waterfall, Agile/Scrum, RUP.

Operating System: Windows 2000/XP/Vista/7, Mainframe.

Statistical Tools: Excel 2003/2007/2010.

Databases/Server: MS SQL server, MS Access, Windows 2000/2003, My SQL, Sharepoint, Trust 3000, Document Center(ECM), Alfresco.

Reporting Tools: Business Objects, Crystal Reports, Cognos.

Trading Platforms: Aladdin, Charles River.

CRM: Siebel 8.1.9 & 8.1.10, Salesforce.

Project Management: MS Project, CA Clarity.

Packages: Markit, MS Office (Word, Excel, Power point).

Change Management Tools: Quality Center, Rational Clear Quest & Test Director.

Transmission Technologies: IBM MQ, FIX.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Business System Analyst/Quality/Data Analyst

Responsibilities:

• Used detailed knowledge of the application features and functionality to assess the scope and impact of business needs throughout the analysis and completion of the enhancement specifications.
• Identified, designed and drove business processes and system improvements that will enhance business performance.
• Executed SQL queries to verify changes in DB2 tables.
• Identified, designed and drove business processes and system improvements that will enhance business performance.
• Created process flow for annual Trust certification and audited financial statement documents.
• Involved in the Functional Design phase by creating Screen Mockups (UI) and Process Flow Diagrams using Microsoft Visio.
• Created Business Requirement, Functional Requirements and Technical Requirements Document, test scripts, training materials and transition to support materials
• Conducted extensive GAP analysis between the requirement specifications and the existing system for the B2C project.
• Effectively communicated with internal teams and external clients to deliver functional requirements like GUI, Data Flow Diagrams, and Screen and interface designs for the B2B/PVP portal.
• Gained approval and communication of technology architecture solutions and directions. Collaborated with the implementation team and provided guidance for the development/integration team.
• Organized and facilitated problem - solving discussions with the clients, internal operations team, and project managers by tracking and resolving prioritized issues as well as tracking defects.
• Created and verified business object reports and worked closely with BO developer and admin for resolving defects. Verified Mainframe reports.
• Designed and verified multiple pages of the B2B portal for reporting, plan documents and compliance for Plan Sponsors, Consultants and internal users.
• Performed data validation and wrote SQL Queries for Data Extraction and Data Analysis.
• Captured the business logic and data mapping for ETL jobs to load the data in data warehouse.
• Performed Gap analysis by identifying existing technologies, documented the enhancements to meet the end state requirements;
• Tracked issues created meeting minutes with action items and prepared project status reports.
• Organized weekly Project Status and Task Review meetings, created PowerPoint presentations and project updates using MS Project for management review.
• Created and executed test cases for system and regression testing of the B2B portal.
• Performed User Acceptance Testing of the Functional Requirements of the B2B portal.
• Coordinated UAT for the business. Recorded and escalated UAT defects and obtained user sign-off for delivery.
• Work with client services to ensure the quality of delivered software as well as ensured timely resolution of bugs and defects.
• Used HP Quality Center for Defect management, Requirements module, UAT Test Design and execution

Environment: Business Objects 3.1/4.0, Mainframe, MS Office, Visio, DB2 SQL, MS Project, SharePoint, Adobe Photoshop, Adobe Experience Manager, Quality Center, Waterfall, CA Clarity.

Confidential, NC

Business System Analyst/Data Analyst

Responsibilities:

• Identified, designed and drove business processes and system improvements that will enhance business performance.
• Lead business analyst for the corporate and commercial banking migration of Siebel from HI to Open UI platform.
• Participated in the testing of the UAT environment setup and deployment process.
• Mentored junior business analysts on functional, regression and User acceptance testing.
• Created functional acceptance test design specifications and test case specification for the UAT team.
• Recorded defects and ensured accuracy of user raised defects in the UAT environment.
• Used Cognos query studio for creating custom and adhoc reports.
• Performed Gap analysis for migration to the Marklogic reference portfolio project.
• Elicited requirements from users through user stories, incorporated these user stories as requirements in the Sprint Backlog and further expanded them into tasks for each sprint.
• Worked closely with the product owner to prioritize the user requirements during and after each sprint
• Provided the detailed inputs to the Scrum Master about the tasks completed and assisted in the creation of the Sprint BurnDown Chart
• Used various SQL commands such as create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis
• Designed and developed use cases, activity diagrams, collaboration diagrams and sequence diagrams, using MS Visio
• Utilized strong curiosity to understand as-is processes and created vision for future highly efficient and effective processes.
• Translated conceptual user requirements into functional requirements in a clear manner that is comprehensible to data architect/project team.
• Lead Business analysis activities for the corporate and commercial banking migration of Siebel from HI to Open UI platform.
• Created process models, specifications, use-cases, diagrams, and charts to provide direction to data architect and/or the project team.
• Created, retrieved, updated and deleted data using MySQL5 queries.
• Managed and tracked the status of requirements throughout the project lifecycle, and enforced proper change request management procedures, redefining as necessary, to ensure proper scope control.
• Create business process and application flow diagrams supporting business and technical requirements, interpreted business rules and requirements for the team.
• Created wireframes and mockup screens depicting the future state of the system
• Executed project management office/program management office (PMO) functional tasks including preparing meeting agenda, organizing/conducting meetings, creating meeting minutes and following up with workstream leads.
• Determined frequency and content of status reports from the project team, analyzed results, and troubleshot problem areas
• Worked with IT management to develop business cases for new projects.
• Created Test strategy document, test cases and test scripts for multiple projects, followed by lessons learned document.

Environment: Siebel 8.1.1, MS Office, Visio, My SQL 5, MS Project, Netezza, SharePoint, Adobe Photoshop, Quality Center, Waterfall, CA Clarity, Cognos query studio, Marklogic.

Confidential, RI

Business Systems Analyst / Project Analyst

Responsibilities:

• Gathered business requirements and translated them into technical requirements for the creation of application feature enhancements and functions. Managed multiple initiatives simultaneously
• Created process models based on business requirements in order to determine the completeness of the information and process components.
• Responsible for scrubbing and processing the data received from vendors/sub custodians/depositories for both mandatory and voluntary corporate actions related to global and US securities for all RBS accounts
• Created custom reports using Cognos reporting tool for senior management.
• Responsible for managing and approving a queue of both new and updated announcement notices for complex corporate action events.
• Managed and resolved an exception queue for information received from vendors that do not meet initial data routing rules.
• Resolved data conflicts/issues forwarded by the specialists and approved certain master records requiring analyst review.
• Handled new, updated, and exception queues within the scrubbing module of the Corporate Actions system.
• Reviewed data, matching items, removing redundant data, performing edit checks, resolving conflicts, creating a master record for a new corporate action event, approving required activities, and releasing the master record into the Corporate Actions processing system.
• Additionally, scrubbed the data received on an amended notice, linked it to the appropriate original master record, and systematically forwarded the updated record to the Corporate Actions processing system.
• Participated in strategic customer meetings to review, evaluate new technical challenges that are required to improve operating efficiencies and/or business benefits.
• Worked on a project for the integration of data feeds between the Trade Execution, Custody and Accounting Systems; created the data mapping document and business logic to be used for integration
• Provided engagement management knowledge from a governance perspective for the entire project management team by assisting with organizational and logistical aspects of projects.
• Executed project management office/program management office (PMO) functional tasks including preparing meeting agenda, organizing/conducting meetings, creating meeting minutes and following up with workstream leads.
• Determined frequency and content of status reports from the project team, analyzed results, and troubleshot problem areas
• Developed and delivered progress reports, proposals, requirements documentation, and presentations
• Conducted project post mortems and created a recommendations report

Environment: Planview, MS Office 2007/2010, MS Project, Salesforce.com, Bloomberg Essentials, MS Visio, Adobe Converter, Bloomberg EMS, Agile/Scrum, Cognos.

Confidential, OH

Sr. Business Analyst/Data Analyst

Responsibilities:

• Facilitated collection of requirements from system users and preparation of Business & Functional requirement documents to provide appropriate scope of work for technical team to develop prototype and overall system.
• Performed gap analysis for transitioning between Citi broker and Blackrock’s Aladdin platform.
• Created detailed specification document for implementing Fixed income trades on Blackrock’s Aladdin trading platform.
• Analyzed and verified requirements for completeness, consistency, comprehensibility, feasibility, and conformity to standards.
• Developed Use Cases and use case diagrams using Visio for BRD documentation, documented scenarios that enabled developers and other stakeholders to understand the business processes.
• Ensured that user stories are good, have business values and story points
• Applied Iterative/Agile model in each SDLC phase, involved in daily Scrum Calls/Meetings and incorporated change requests throughout the project lifecycle.
• Prepared and presented project deliverables to the appropriate management for project review throughout the development life cycle.
• Used MS Office Suite including Word, Excel, Access and PowerPoint for analysis, presentation and documentation.
• Analyzed existing span of control and mapping the future state organization structure for key roles and responsibilities while prioritizing the constituent area of focus and recommending different options
• Initiated the design review process to understand the existing architecture and documented the changes.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas in the Asset Management group.
• Involved with walkthroughs and meetings with development team to discuss related issues.
• Wrote test cases, test scripts and test plans to accomplish the QA process.
• Provided support to the project manager throughout all phases of the project lifecycle.
• Determined client and organizational needs, systems and operations requirements, customer rollout requirements, etc.
• Analyzed and prioritized requirements and used them to outline timeline for completion of goals.
• Performed GAP Analysis with system functionality and existing Business Processes
• Conducted meeting with Developers, SME & System users for communicating specifications to design & development team
• Discussed and proposed conversion / interface solutions with the clients and users
• Used Mercury Quality Center for bug and defect tracking. Coordinated with the developers on Defect status on a regular basis.
• Actively participated in daily bug triage meetings, reviews and walkthroughs and interacted with developers to ensure high quality software

Environment: Waterfall, Agile/Scrum, Siebel, MS Visio, MS Project, CA Clarity, MS SQL, Lotus Notes/Sametime, IBM MQ, Mainframe, Windows XP, Sharepoint, Trust 3000, Aladdin.

Confidential, NY

Lead Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Familiarized with the business process of the Hedge Fund & analyzed the Strategies of the portfolio manager and traders.
• Used Bloomberg & Reuters to implement market data feeds; identify fields of market data to be used in various PnL calculations
• Documented the whole trade re-conciliation, clearing and settlement process.
• Created high level process models for trade cycle along with data mapping documents
• Gathered the business requirements for the concerned enhancements in the hedge fund administration process by conducting meetings, interviews, and JAD sessions with stakeholders.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Understood Fixed Income, Equities and Equity Trade Life Cycle, Portfolio Management, Wealth Management and Sales and Marketing. Identified, researched, investigated, analyzed, defined and documented business processes for Equities. Worked with the Traders and Brokers while collecting requirements
• Analyzed business requirements in to BRD, FRD and segregated them in to Use Cases and class diagrams according to UML methodology thus defining the data process models.
• Documented the Requirement traceability matrix (RTM) and conducted UML Modeling such as creating Activity Diagrams, Flow Diagrams using MS Visio. Analyzed test data to detect significant findings and recommended corrective measures
• Developed user test cases and validated test results during user acceptance testing.
• Created data dictionary for often used hedge fund and technical terminology for benefit of developers and users respectively
• Investigated, resolved and escalated problems
• Extensively used MS Excel for data reconciliation purposes.
• Built and updated company financial models, including GAAP to non-GAAP reconciliations
• Created notes on company earnings call and conference calls for Portfolio Manager

Environment: Windows XP, SQL, Microsoft Office tools, Reuters 3000 Xtra, Bloomberg Essentials, Realtick, Salesforce.

Confidential

Sr. Business Analyst

Responsibilities:

• Conducted Joint Application Development JAD sessions, Brain storming sessions with stakeholders throughout SDLC to develop and agree upon a system that focuses on the business requirements. Involved with creating targeted questions for requirements gathering.
• Led workgroup sessions with business sponsors and managers to gain final approval on business requirements.
• Used MS Office extensively (Word, Excel, Visio, PowerPoint) for calculations, graphs, analysis, presentation and documentation throughout the project.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Used prototypes to demonstrate and verify system behavior
• Performed gap analysis to compare the existing system with the proposed system and evaluated the benefits of the new system.
• Participated in technical design sessions to provide insight during solution development
• Prioritized issues to ensure timely and quality deliverables.
• Involved in generating Test Plan by analyzing the requirement specification documents to accomplish the QA process
• Developed Test Cases, Test Scenarios and Test Scripts for System testing and Regression testing
• Provided user training on an ongoing basis and created documentation for training and Help Desk teams

Environment: s: MS Office, UML, Visio, MS Exchange, SQL Server, Windows, Siebel CRM.

Confidential

Business Analyst/ SAP Consultant

Responsibilities:

• Collected, documented and analyzed Business Requirements based on project scope
• Championed 4 major ERP test scripts to coordinate, prepare, submit, and gain approval for SAP R3 cutover
• Designed Use Case Diagrams and wrote specifications in the Use Case Specification documents based on requirements gathered.
• Derived Functional Requirement Specifications (FRS) based on User Requirements Specification (URS).
• Developed Use Cases and use case diagrams using UML/Visio for BRD documentation, documented scenarios that enabled developers and other stakeholders to understand the business processes.
• Prepared and presented project deliverables to the appropriate management for project review throughout the development life cycle.
• Documented the user requirements, analyzed & prioritized them and converted them as system requirements that must be included while developing the software
• Used MS Office Suite including Word, Excel, Access, and PowerPoint for analysis, presentation and documentation.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures and created a Business Requirement Document.
• Involved with walkthroughs and meetings with development team to discuss related issues.
• Wrote test cases, test scripts and test plans to accomplish the QA process.
• Conducted Data validation using SQL Queries and statements.
• Used Test Director for bug and defect tracking. Coordinated with the developers on Defect status on a regular basis.
• Actively participated in daily bug triage meetings, reviews and walkthroughs and interacted with developers to ensure high quality software.

Environment: MS Office, MS Project, UML, RUP, Visio, Windows, UNIX Test Director and Rational Rose requisite pro.

Confidential

Business Systems Analyst

Responsibilities:

• Involved in creating and reviewing business requirements, functional specification and test plans.
• Wrote various SQL queries and statements for data reconciliation system.
• Conducted JAD sessions with extensive involvement from Business, interacted with Financial Consultant user base, Equity trading system, Fixed Income group specialists to identify business system needs, and Managers of various Business Units for gathering requirements.
• Performed in depth Gap analysis with different business groups to ensure that system initiatives are met and prioritized them based on business needs.
• Linked and stored all supporting documents into one electronic file for instant retrieval.
• Extracted the Business Requirements during various sessions with business leads for Compliance reports.
• Created functional specifications and Business requirements document (BRD).
• Developed Use Cases using UML. Realized Use Cases and their corresponding activity flows with complete entity relationships and recorded all flows using Rational Rose
• Used MS Office extensively (Word, Excel, Visio, PowerPoint) for calculations, graphs, analysis, presentation and documentation throughout the project.
• Worked with project team members (business and technical) to develop technical design documents, including business and system process models.
• Conducted sessions with developers to explain user requirements and understand system changes required to facilitate them
• Involved with generating test Plan by analyzing document requirement specifications.
• Developed Test Cases, Test Scenarios and Test Scripts.
• Prepared test cases for User Acceptance Test (UAT) to test developed applications with business users to ensure all business & system requirements are met.
• Identified, classified, reviewed and resolved defects in consultation with developers and other team members.

Environment: MS Office, MS Project, UML, RUP, Visio, MS Exchange, Test Director, Oracle and SQL Server, Charles River, Siebel.