SUMMARY

• A Proficient Business Analyst with 8 years of experience in Banking and Financial Services Domain.
• Excellent knowledge of the various methodologies and phases of the SDLC (Waterfall, RUP, and Agile).
• Possesses strong experience in capturing / analyzing system, Business Processes, Re - engineering, Object-Oriented Design/ Modeling, Service Oriented Architecture and Project Management.
• Expert knowledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk), Mutual Funds, Derivatives (OTC market, F&O), Hedge Funds, ETF’s, securitization, Mortgage backed securities, Asset backed securities
• In-depth knowledge of a wide variety of financial instruments including Retail and Commercial Loans, Line of Credits, Credit Card, Auto Finance, Mortgage, Equities, Fixed Income, Derivatives, Mutual Fund, Hedge Fund
• Extensive experience with Trade Activities, Trade Life Cycle, Capital Market, Portfolio Management, Asset Management, Credit Risk, Credit Rates, VaR, Market Risk, Operational Risk, Cash Correspondent Banking, Wire Transfer, ACH, Cost/Profit Analyses, Budget and Forecasting
• Strong knowledge with Basel III, CCAR, Dodd-Frank, KYC, AML, FINRA’s rules and regulations
• Excellent understanding of Mortgage Loan Process and GAAP standards, such as Assets, Liabilities, Account Payables, Account Receivables and other General Ledgers
• Strong knowledge in requirements gathering, Business Requirements Document (BRD), Functional Requirements Document (FRD), Software Requirement Specification (SRS), Systems Design Specification (SDS), Requirement traceability Matrix (RTM), Use Case Specifications, and testing documents.
• Implemented and documented the activities related to the Americas Transaction Monitoring Surveillance Platform Strategy and Optimization Program which will include the delivery and cyclical reviews of scenarios/rules/data and parameters
• Performed as Transaction Monitoring SME to support the optimization and strategic enhancements to the Actimize Transaction Monitoring platforms
• Analyzed Business/Functional requirements provided by Business Analysts, and provided technical solutions and designed documents to Actimize Developers
• Expertise in the entire phases of Software Development Life Cycle (SDLC)
• Efficient in creating Traceability Matrix for reviewing and tracking business requirement against test cases
• Adept at performing Gap Analysis by identifying and documenting existing technologies along with enhancements to meet the business objectives
• Strong knowledge in all financial instruments within investment banking and brokerage environments.
• Proven expertise in Gathering, Analyzing, and Documenting business requirements
• Proficient in UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams
• Knowledge of working with various databases such as PL SQL Server and MySQL
• Have extensive experience in Functional, Regression, System Integration (SIT), User Acceptance (UAT), load/performance, security and browser compatibility testing
• Experience in writing Test plans and Test Cases
• Expertise in Data analysis, Data modeling for transactional as well as Data Warehousing (Dimension Modeling) and ETL Mapping Document.
• Strong working experience in Data Modeling in creating Star & Snowflake Schemas, Fact and Dimensions Tables, Conceptual, Logical and Physical Data Modeling by using Erwin
• Facilitated and participated in Joint Application Development (JAD) sessions for requirements gathering, resolving open issues and change requests
• Self-starter with motivation and ability to work independently with ability to handle diverse tasks simultaneously and adapt to tight deadlines

TECHNICAL SKILLS

Methodologies: Agile, RUP, Waterfall, UML, Business Modeling Process Modeling and Data Modeling

Office Tools: MS Word, MS Excel, MS Power Point, MS Access, MS Project, MS Outlook, SharePoint

Process/Modeling: MS Visio, Erwin Data Modeler, Rational Requisite Pro, Eclipse

Languages: Java, SQL, PL/SQL, HTML, XML

Database: MS Access, SQL Server 2000/2005/2008/2012 , XML

Web Testing: MS Visual Studio Test Edition, Fiddler, Trace plus Web Detective

Defect Tracking Tools: Rational Clear Quest, Quality Center

Data Mining/Reporting Tool: SQL, Crystal Reports, SSRS, TOAD, Oracle Financial Analyzer, TIBCO Spotfire, Tableau, Erwin Data Modeler.Suite, InDesign, LimeSurvey, Wiggio, CRAIG TAN

PROFESSIONAL EXPERIENCE

Confidential, OAKS, PA

Senior Business Analyst/Data Analyst

Responsibilities:

• Led in various simultaneous client and internal projects and initiatives
• Reviewed & understood business requirements provided by internal and external clients
• Effectively supported status updates to Confidential stakeholders and clients as needed
• Created& documented complete and detailed technical specifications for all custom report & file extract projects
• Assisted in investment management services of clients by gathering business requirements and managed their Portfolios, Call Letters, Distribution Letters, PCAP Statements and Capital Confirmation Letters.
• Analyzed and documented business requirement, functional specification and reporting data specification documents and converted them into technical design and data mapping specification till the end with its implementation in Production by raising JIRA Tickets.
• Professionally skilled in gathering, understanding and documenting complete back office to front office client requirements, configuring application for production release for the end users, delivering customized reports within project timelines and budget by creating PWO for new development and programming issues.
• Efficiently created and loaded drivers of Private Equities and Hedge Funds clients from UAT to PROD with their most recent account details after the UAT refresh in InvesTran and InvesTier database source system.
• Worked with development project teams and Design Team with regards to functional specifications, quality assurance scripting, and product rollout
• Maintained& distributed weekly management report detailing the status of each outstanding development project
• Supported the e-delivery team operations team in understanding operational workflows and system data structure as well as assisting with data validation
• Worked with Client Implementation and Release Management teams to translate business requirements into viable configurations
• Assisted with roll out of implementation of our products and Supported & educated operations on our products
• As a core member for implementation of SAP FI/CO module, gathered business process information and compiled the AS-IS, TO-BE and GAP analysis of the SAP R/3 system. Performed assessment of business requirements, mapping with SAP functionality.
• Supported relationship management - worked with client to address problems, concerns, and questions
• Supported client presentations and helped preparing demos for stakeholder meetings
• Provided technical support as required for solutions and operations to effectively identify and analyze issues, and offered practical and effective solutions
• Engaged in departmental projects on an as needed basis
• Stayed abreast of current industry developments and system enhancements.

Tools: & Technologies: Agile, HP Quality Center, SAP Query Builder, UML, SWOT Analysis, Informatica, MS Project, SQL, PL/SQL, MS Office Suite (Word, Excel, Power Point, Access, Visio)

Confidential, Philadelphia, PA

Senior Business Analyst/Data Analyst

Responsibilities:

• Analyzed complex data flow from front office systems to finance systems to identify gaps and trades to understand incorrect/inconsistent valuation and accounting
• Interacted with Sales, Middle Office, Risk Management, Product Control, Finance, Underwriting, Operation and other stakeholders to gather business requirements and create enterprise level flows, system architecture, trade flows and timelines
• Proactively worked with Fixed Income and Derivatives transactions
• Gathered requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for BRD and FRD creation
• Conducted Daily Standup meetings to ensure that proposed changes went through the system as well as the project team produced solutions that meet established standards, procedures, practices, risks and mitigation plans
• Led Sprint Planning Sprint Estimation (SPSE) sessions, Sprint Retrospectives and Reviews, User stories and Acceptance Criteria
• Concept development, realization and implementation of a Customer Due Diligence-System
• Worked with Actimize team and Fraud Operations team to collect and identify data related to suspicious activities
• Identified/disposed of higher risk customers and maintained the list of the Deposits of High Risk Customer within Actimize
• Created and publicized of guidelines / policies (including a set of risk oriented measures for customer due diligence processes)
• Worked extensively with offshore development teams and tracked their progress through various tollgates over the life of the project
• Completed Data Mapping for the Wealth Management segment to facilitate the conversion of client assets
• Coordinated new Basel team and worked with the team very closely
• Worked with upstream/downstream data consumers, developer leads, QAs and PMs to monitor test plans, test cases, test sets, UAT, post-implementation checks and future enhancements
• Assessed overnight releases and worked alongside release managers
• Exceeded the project goals and decreased the beta release time by 4 weeks
• Tracked post-deployment progress and proposed resolutions to existing issues
• Meticulously addressed every detail to ensure a successful end-to-end business process

Tools: & Technologies: Rally, HTML, XML, HP Quality Center, AdobeLiveCycleSuite7.0, SAP Query Builder, UML, Informatica, Cognos, MS Project, SQL, PL/SQL, MS Office Suite (Word, Excel, Power Point, Access, Visio)

Confidential, Minneapolis, MN

Senior Business Analyst/Data Analyst

Responsibilities:

• Understood the Bank Secrecy Act, US Patriot Act with help of SMEs
• Analyzed the existing customer data and understood the necessary information that needs to be captured for each existing customer and prepared missing values, anomalies for the completion of the CDD
• Conducted JAD sessions and gathered business requirements, analyzed and prioritized requirements by using Rational Requisite Pro
• Developed scope document, financial projections, budgeting and analysis for the project using IBM Cognos
• Identified the technical needs of the organization and accordingly developed Cognos based applications and software
• Proposed solutions or alterations to remove inefficiencies and closed gaps in existing process via process redesigning
• Developed Use Cases Diagram to explain workflow
• Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level
• Wrote the SQL queries in Oracle SQL Developer and managed the database and assisted in making Data warehouse and doing Data profiling
• Performed Actimize system implementations and enhancements with Actimize Team
• Interacted with Actimize development teams to understand the functionalities of different modules
• Prepared a Gap analysis of the existing data to fully comply with CIP as per AML regulations using Actimize
• Determined the threshold parameters such as geography, source of income the customer etc., and fed to Actimize along with the historical transactional data to categorize the customers for monitoring purposes
• Supplied proof that False Positives were proven to be correct and updated Actimize
• Defined and created the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality
• Reviewed and analyzed the Use cases and came up with System design and Test plan Templates and developed test plans, test cases and test strategy
• Designed the test plans and test scripts based on the user requirement specification and conducted UAT- Integration testing, Unit testing
• Provided training and assistance to business users

Tools: & Technologies: Rational Rose, Rational Requisite Pro,SQL Developer, Nice Actimize RCM, Actimize visual Modeler 4.7, SOA, UML, MS Project 2010, MS-Visio 2010 (UI Mockups), MS-Office 2010, Excel Macros, Erwin 7.1, MS SharePoint

Confidential, Somerset, NJ

Business Analyst/Data Analyst

Responsibilities:

• Executed a gap analysis (comparison of existing functional frameworks with the recently expanded regulatory requirements)
• Organized kick off meetings with the Designers and Digital Content groups to prepare scope of the project and the Business Requirements Package plan
• Created an AML risk threat analysis
• Developed an overall target architecture in accordance with group compliance guidelines
• Concept development, realization and implementation of a Customer Due Diligence-System
• Development of specific ‘Know Your Customer’ templates (geared towards generic customers and specific customer groups e.g. PEPs, Beneficial Owner)
• Created and publicized of guidelines / policies (including a set of risk oriented measures for customer due diligence processes)
• Gathered requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for BRD and user stories creation
• Conducted JAD sessions, daily scrum meetings and produced deliverables for Fraud/AML/Compliance/Privacy/Risk Reporting
• Circulated CCAR Reports of Compliance policies and procedures at the group levelfor Credit Risk Reporting and Mitigation
• Developed an inventory of assumptions within CCAR. These assumptions are from many sources, for example: modeling assumptions, forecasting assumptions by the business partners, and assumptions made by Management in their view of the Banks’ response to particular scenarios
• Interviewed and worked closely with the modelers and business partners to define their assumptions, harvest and inventory the assumptions and document their rationales
• Worked closely with the modelers and business partners to produce the sensitivities necessary to show where/what the Bank’s CCAR results were sensitive to
• Collaborated closely with other Financial Institutions to monitor customer transaction histories
• Worked with the Design group to prepare wireframes for various business scenarios
• Created SQL queries for Report Mapping, Report Layout and Data Flow Diagrams
• Utilized Quality Center (QC) for requirement management, test planning, scheduling, test execution, log and track defects
• Prepared Test Data Spread Sheets (TDS) by extensively utilizing the enterprise taxonomy following logical order for the Interwoven to check the content
• Exceeded the project goals and decreased the beta release time by 6 weeks
• Meticulously addressed every detail to ensure a successful end-to-end business process
• Managed and executed customer due diligence processes for new / existing clients and training

Tools: & Technologies: Rally, Java, Windows 7, XML, Microsoft SQL, PL/SQL, HP Quality Center, UML, MS Office Suite (Word, Excel, Power Point, Access, Visio)

Confidential, Baltimore, MD

Business Analyst

Responsibilities:

• Worked with the trading and financial analysis team to understand the business requirements using JAD sessions and needed to in corporate the features they wanted working in the system
• Carried out an “As is” and To Be” analysis and documentation on the Bank’s current Information and Investment Management System
• Gathered user and business/regulatory requirements through interviews, surveys, and observing from portfolio managers and UI (User Interface)
• Worked with the different business units (Investment Banking, Fixed Income, Equities, Foreign Exchange, Clearing & Execution) within the bank to understand the current business flow
• Reviewed trade confirmations for OTC derivatives trades, including rates, credit, equity, commodity and FX derivatives
• Created SQL queries for reporting following Volcker Rule as a part of Dodd-Frank
• Conducted User Acceptance Testing (UAT) of new rates clearing eligible products
• Helped in client and sales support, and overall support of trade flow to vendor and in-house systems
• Examined Order Management System (OMS) to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involve Cash Analysis, Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking, and performed gap analysis
• Prepared data mapping documents to support ETL process and involved in building data models to construct staging warehouse for reporting purposes
• Maintained Traceability Matrix for the current business processes and proposed changes
• Assisted Project Manager in managing project progress, estimating delivery schedule and supporting implementation and application using MS Project
• Developed test plans with QA team and helped to develop test scenarios according to different report needs for system testing and performance testing
• Reviewed test cases, maintained the Requirement Traceability Matrix (RTM) to ensure appropriate documentation is in place
• Conducted UAT, documented and reported user feedbacks to management team, and created user manuals included the explanation of different reports and how to execute

Tools: & Technologies: RUP, UML, Rational Requisite Pro, Rational Rose, Rational ClearCase, Rational ClearQuest, Windows 7, Java, SQL, HTML, MS Excel, MS Word, MS Project

Confidential, Pittsburgh, PA

Jr. Business Analyst

Responsibilities:

• Developed business process models in RUP to document existing and future business processes.
• Developed manual test scripts using HP Quality Center for performing Regression testing
• Was responsible for creating and reviewing business requirements, functional specifications, documentation and test plans.
• Performed testing and recorded results in HP Quality center
• Involved in GAP analysis around the identification of business rules, business and system process flow, user administration, requirements and assumptions.
• Conducting user interviews, gathering requirements, analyzing the requirements
• Co-authored business requirements document with the business users.
• Extracted, discussed, and refined high level business requirements from business users and team members. Maintained requirements in DOORS
• Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML.
• Coordinated activities between business unit and technical staff

Tools: & Technologies: J2EE, UNIX, SQL, HTML, Excel, MS Project, RUP, MS PPT, Rational Rose, Doors

Confidential

Jr. Business Analyst

Responsibilities:

• Met with business process owners, SME’s and marketing team for requirements gathering in definition stage and also conducting JAD Sessions to discuss use stories
• Involved in the data migration between systems and validated business requirements
• Used Visio to create Use Cases, activity diagrams, class diagrams, workflow process diagrams and prepared Use Case Narratives
• Interacted with the developers and defined the requirements to develop the Graphical User Interface
• Participated in weekly meeting and discussed modification request with management team
• Involved with the QA team to determine and developed test approaches and methods for unit testing, integration, functional testing, load and usability testing according to application complexity and test requirements

Tools: & Technologies: MS Word, MS Excel, MS Visio, MS Project s Extranet, J2EE, Web 2.0, Erwin (7.1)