SUMMARY:

• Senior Business Analyst with 8 years of experience in the domain of banking industry, supporting business process including research, analysis, review, development, implementation, testing, maintenance and monitoring, acting as a liaison between financial institutions and IT groups, and ensuring the completion of client requirements and objectives with strong understanding of sequential and iterative approaches like waterfall, RUP, Agile project management methodology.
• Expert in partnering and coordinating with all levels of managers, developers, QAs, stakeholders, business users and technology teams.
• Good analytical, communication, problem solving, decision making, presentation and organization skills.
• Excellent in understanding client requirements, summarizing client needs, and translating into technical options and solutions that meet end user business needs.
• Broad experience with SDLC requirement gathering and deployment using Agile Scrum, Rational Unified Process (RUP), Waterfall.
• Proficient in creating UML diagrams like Use Case, Activity, Sequence, Collaboration, Class, State, Workflow, Process flow, Data flow and Deployment Diagrams using tools like Rational Rose, MS Visio.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including transformation rules.
• Ability to plan and coordinate all testing phases including making test plans, conducting User Acceptance Testing (UAT) and creating & executing Test Scripts/Test Cases and highly involved with Regression, system testing and integration testing.
• Actively involved with QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis. Involved in UAT (User Acceptance testing), SIT (Systems integration Testing). Experience in developing Test Documents, Test Plans, Test Cases, and Test Scripts while executing manually.
• Expert in Developing and documenting business requirements which includes wire frames, Mockup Screens, Prototyping and Business workflows.
• Proficient in creating BRD (Business requirement Document), TRD (Technical Requirement Document), FRD (Functional Requirement Document), UAT Documents, Use Case Narrative, and traceability matrices.
• Ability to do data analysis in databases using SQL.
• Experience in AML & Trade Surveillance tools such as Actimize and good understanding of related topics.
• Expert in knowledge in various capital market instruments and securities including Equities, Fixed Income, Risk Management (Credit and Market Risk), Mutual Funds, Derivatives (OTC market, F&O), Hedge Funds, ETF ’ s, securitization, Mortgage backed securities, Asset backed securities.
• Understanding of Corporate Finance, Quantitative analysis, P&L, Balance sheet analysis, accounting, financial market, derivatives, fixed income, equity, financial modeling, data forecast & sensitivity analysis.
• Understanding of Treasury/Cash Management, fee refunds and CRA activities, Clear understanding of Accounting Controls, principles and procedures, generally accepted accounting principles (US GAAP), IFRS, CCAR, FDSF, etc.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Rational Unified Process (RUP), Agile (Scrum, XP), Unified Modeling Language (UML), JAD, ETL.

Business Management Tools: MS Office Suite (Access, Excel, Word, PowerPoint, Outlook, SharePoint, etc.), MS Visio, MS Project, Adobe Acrobat Suite, JIRA, Rally, Rational Rose, Rational Requisite Pro, Rational Clear Case, HP ALM, IBM Cognos, Oracle ERP, Oracle PeopleSoft.

Data Warehouse Tools: MS SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle SQL Server, Erwin.

Development tools: Javascript, HTML, CSS.

Business Tools: Bloomberg Terminal, FACTSET, S&P Capital IQ, Morning Star, NICE Actimize, S erena.

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, Weehawken, NJ

Responsibilities:

• Worked with stakeholders from all business units and related third parties to define and document business processes and software requirements for technology initiatives.
• Developed user stories, work on data mapping, cooperate with SMEs, and make sure the development team can understand and will hence follow the design of business product.
• Documented use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.
• Initiated meetings, gathered information from different parties to maintain the transparency of information and update all parties with the latest progress on the project.
• Consolidated sources of documents and provided a source of authorization with the latest and the most updated file on SharePoint.
• Helped to synchronize whenever there was an information/ comprehension gap in between different groups, and conduct meetings to resolve the gaps.
• Documented user groups as well as their privileges for UAT test, and keep updating the file to date in case of any changes to the arrangement.
• Helped to document integration touch points with other related tools in business workflows, define the frequency and direction of data refreshment.
• Documented integration BRD with sufficient details for developers to read and follow.
• Used OATS to make sure documents were prepared to Audit purpose.

Environment: MS Office, Excel(v/h lookup,pivot table), Word, PowerPoint, Project, Visio, Access, Outlook), Agile, Serena, SharePoint, JIRA, TeamCity, ChangeMan, HP ALM, Windeploy, TAI.

Business Analyst

Confidential, New York, NY

Responsibilities:

• Automated the generation of Customer Due Diligence (CDD) and Enhance Due Diligence (EDD) reports in compliance with AML regulation.
• Created burndown chart of the whole project and also each sprint while conducting daily scrum meetings with developers.
• Involved in making appropriate commitments through story selection, sizing and tasking.
• Involved in Scrum Sprint Planning Sessions, Backlog Grooming Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
• Developed UML diagrams (use case diagrams, activity diagrams, sequence diagrams, and class diagrams) in order to validate entity reference data and verification of the customer records: legal name, address, business purpose legitimacy and analysis of transaction activity).
• Designed and implemented basic SQL queries for the data warehouse, and did data profiling.
• Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations.
• Issued the Test Plan Document, Test Planning, Test Design and Test Execution and was involved in the Testing Process which verified and validated all the defined business requirements and associated functionalities.
• Created the RTM in order to project the life cycle activities and work products to the project requirements.
• Coordinated System Integration Testing (SIT), and Regression testing for the project implementation.
• Effectively led the effort and implementation of the Business User Acceptance Testing.
• Worked closely with Change Management team and attended Change Advisory Board meetings.
• Lead the Requirements efforts in analysis, gathering and base lining the requirements for the above application and performing technical requirements analysis and streamlining the process.
• Streamlined workflows by introducing exception based reporting and highlighting breaks.
• Eliminated 193 manual spreadsheets and reduced timing related breaks allowing more capacity to identify and fix true exception items.
• Lead the UAT effort and was single point of contact for all the User Testing issues and Change Management.

Environment: Agile Scrum, Oracle SQL Developer, CRM - Sales Force, SOA, UML, Visual Basic, Erwin, MS SharePoint, IBM Business Objects, Actimize, MS Visio, MS Suite, JIRA.

Business Analyst/Data Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Researched and analyzed the data from Confidential systems such as KYC system, Trading Platform (ION) Position and Inventory management system (FIST), Market data systems (BBG & Reuters)
• This required understanding the data entities with Confidential and in Actimize and come up with data mapping.
• Coordinated the hardware sizing exercise for App, Web and DB servers between multiple teams.
• Created the SSIS packages to load and process the data from multiple systems.
• Worked with implementer to install and setup AIS models, RCM Web app, set up the database servers.
• Worked with implementer to install and setup Actimize Risk Case Manager, Actimize Visual Modeler, Actimize Server Monitor, Actimize Instances, and Actimize Web Services.
• Used Integrity 10.0 for source control.
• Coordinated the documentation (BRD, SRS, SDS, SDP) and helped development team members.
• Coordinated the activities between PMO, Infrastructure, Engineering, Operations and Support teams.

Environment: .NET 3.5, C#, Visual Studio 2008, XML, ADO.NET, SQL Server 2008, Web Services, LINQ,.NET Framework 3.5, 2.0, Integrity, Actimize.

Business Analyst/Data Analyst

Confidential, New York, NY

Responsibilities:

• Formulated and documented business requirements to support new product initiatives that support strategic plans and customer initiatives.
• Modeled business use-cases to validate business process flow to be incorporated in the new system.
• Translated business requirements into functional specifications for communication to technology team & performed GAP Analysis to identify requirements.
• Performed system analysis to integrate a 3rd party processor for EDT (Electronic Data Transfer) via bank networks. CRAPS (Credit Appraisal System) used file outputs to electronically feed to the internal bank systems.
• Interacted with the database group to integrate the new CRAPS Oracle database in the corporate data warehouse for OLAP Reporting via ETL (Extract, Transform & Load)
• Prepared detail design and requirement specification, so outsourcing firm can do development, Planned and Managed integration and stress testing of back end applications.
• Develop data models and performed planning of architecture, functions, modules, recovery, standards and implementation in direct correlation of designing data base designs implementing data warehouse and data mart visioning.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business
• Assisted in development of training materials for new technology and process improvements.
• Identified and documented best practices for the product offering

Environment: RUP, MS-Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio, Erwin, Data Warehouse, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case, SSIS, Crystal Reports, Quality Center, UML, SQL.

Business Analyst/Data Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Facilitated and coordinated JAD sessions with business users to analyze the investment tracking system, application lifecycle, gather and define the key performance indicators, document and present the requirements specifications.
• Carried out Requirement Traceability Matrix (RTM) and managed the data format.
• Prepared Business Requirement Document (BRD) and functional requirement document (FRD) to use with the project.
• Joined Sprint Planning and Sprint Estimation (SPSE) meeting to create backlogs with Rally.
• Designed process diagrams to show the workflow and UML diagrams to clarify the entities and their relationships.
• Participated in daily scrum meeting to make sure everything was on track.
• Formulated test cases and test plans, and built data validation scripts (pre and post load) in SQL to check the results.
• Involved in sprint review and sprint retrospective meetings to ensure the proper delivery of user requirements.
• Conducted System Integration Testing (SIT) (includes functional and structural testing) with QA and user acceptance testing (UAT) with client to discover and document defects.
• Performed Root Cause Analysis and Re-engineered business processes, and implemented performance measures, presented project presentations to the business users.
• Combined Quality Center (QC) and other tools to create, maintain, and store the requirements, and conducted test sets.
• Complied with Bank Secrecy Act (BSA) and Basel III to control the risks.

Environment: MS Visio, Agile, JIRA, MS Office, Windows Server, SQL 2005, Rational Clear Case, Java/J2ee, Oracle 8i, HTML.

Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Conducted JAD sessions with Home Loan Mortgage Servicing subject matter expert on Making Homes Affordable; on-boarding managers and analysts alike to support initiatives for Loss Mitigation, Escrow Analysis, Portfolio Analysis, Home Retention and Loan Servicing.
• Responsible for consolidating, summarizing and analyzing business requirements for the Home Loan Mortgage Servicing Real Estate Management Short Sales effort.
• Provided management with detailed requirements for business stake holders - hosting sessions analyzing and explaining these business requirements.
• Created,compiled and maintained business requirements; providing management and stake holders alike with analysis and evaluations for improving Short Sale business strategies for Home Loan Mortgage Services.
• Developed UML artifacts (Use Cases, Activity and Sequence Diagrams) on scenarios based on Loss Mitigation, Escrow Analysis, Portfolio Analysis, Home Retention and Loan Servicing.
• Manage the Home Loan Mortgage Servicing Short Sale Communication effort and provided the reporting as needed by the stake holders.
• Worked independently to meet strict deadlines; handle multiple tasks at the same time; demonstrating clear and concise verbal and written communication skills during the interaction with all levels of management.

Environment: MS Visio, MS Project, MS Word, SharePoint, Quality Center, UML, Waterfall, JAVA, J2EE, Web services, Oracle 8i

Financial Advisor

Confidential, New York, NY

Responsibilities:

• Client oriented meetings
• Analyzed client requirement and helped clients to build their portfolio
• Provided services such as Succession Plan, Executive & Employee benefit, Insurance & Investment, Risk Management, Retirement p lan, College funding, etc.
• Handled all account processing with knowledge of IRA(Traditional IRA, Roth IRA)
• Helped clients to open and manage mutual funds.