SUMMARY:

• Over 8 years experience as Business Analyst, D Confidential analyst having domain experience in various financial services applications.
• Experienced with the procedures of Banking, Investment Banking & Regulatory Compliances - Anti-Money Laundering (AML), Bank Secrecy Act (BSA), Office of Foreign Assets Control (OFAC) Guidance, Customer Identification Program (KYC/CIP), Basel II Accords, Dodd-Frank Act
• Excellent Financial Product knowledge in capital market, equity, Fixed Income (CDs, Treasury Bonds Bond, Municipal Bond, Money Market) Structured securities, Derivatives: Futures, Forwards, Options, SWAP (interest rate swap, currency swap), fixed and variable rate instruments, and derivatives end to end trading cycles, securities clearance and settlement process.
• Experienced in Cash Management/Treasury products and electronic banking. Strong Understanding of Wealth Management and Risk Management. Have also good understanding of different products like Mutual Funds, Life Insurance, and Retirement Plans.
• Experienced documenting Business Requirements Document (BRD), developing UAT Plan, maintaining Traceability Matrix and assisting in post implementation activities.
• Extensive experience in working in SDLC for various methodologies, including RUP, Agile including Test-driven development (TDD).
• Highly experienced in performing Feasibility Studies, Impact analysis, GAP analysis and Risk Analysis. Expertise in creating Use Cases, Use Case Diagrams, Class Diagrams and Sequence Flows using MS Visio and UML concepts.
• Strong experience in Extraction, Transformation and Loading (ETL) d Confidential from various sources into D Confidential Warehouses and D Confidential Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metad Confidential Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server D Confidential bases.
• Deep understanding of d Confidential base management systems, d Confidential warehousing concepts, BI technologies and d Confidential mining. Skilled in d Confidential warehouse design using Star Schema rollout for fact and dimension tables. Experienced conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Expert in application development with full lifecycle implementation of large d Confidential warehouses, including project Scope, Requirements Gathering, Star Schema Design, Snowflake Schema, d Confidential modeling and ODS. Expertise in creating dimensional models and creating ETL specifications.
• Expertise in Core Documentation, D Confidential Analysis and Process Analysis, Design, Development and testing phases.
• Experienced in report design, table/query design and automation utilizing VBA modules. Proficient in writing Excel Macros, Pivot tables, Graphs, Charts and VBA routines.
• Proficient in writing and executing SQL queries as well as d Confidential base testing analysis. Solid understanding of OO programming concepts.
• Extensive experience in Smoke Testing, Regression Testing, Functional Testing, Integration Testing, System testing, End to End testing, and User Acceptance Testing. Experience in Manual, SOAP UI (Oracle Enterprise for web service testing) and Automated testing using HP QTP.
• Organized professional with excellent verbal and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little .

TECHNICAL SKILLS

MS Project: Excel, Access, Visio, PowerPoint, Rational Rose, SharePoint, DOORS, HP QTP, SQL, XMLHTML

HP Quality Center: Team track, Rational Clear case, SVN, Oracle, SQL server

Terad Confidential Windows: UNIX, Waterfall, Agile, RUP, Cognos, Informatica, Rally. VBA, Ab Initio, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. Business Analyst/Scrum Master

Responsibilities:

• Prepared Functional Requirement Documents (FRD’s) after the collection of Business requirements from business users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Involved in reports UI prototype / wireframes design during the process of requirements gathering from the stakeholders. Created and reviewed User Requirements Document, Use Cases, and FRD.
• Conducted JAD (Joint Application Development) sessions and gather business requirements, analyze and prioritize requirements
• Writing the SQL queries in Oracle SQL Developer for d Confidential analysis and d Confidential profiling for creating requirements.
• Created mapping documents for processing various d Confidential feeds in XML, Flat files and other formats from systems such as MANTAS, NESS, etc. Created ETL specifications for feed processing into KYC d Confidential warehouse.
• Interacted with compliance officers for requirements gathering and partner teams for preparation of interface control documents.
• Developed report layouts for Suspicious Activity and Pattern analysis under AML regulations
• Gathered and prioritized requirements, developed business scenarios to check how the system would work with the roles and processes of the departments, and developed acceptance criteria. Maintained requirements in SharePoint and used it for creating tasks and tracking action items and issues.
• Evaluated business process requirements to ensure proper system configuration (i.e. identifying key decisions, process changes, pain points, interface issues, considerations.)
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM). Created Project Plans for multiple projects and allocated resources accordingly.
• Developed UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram on scenarios for validating Entity D Confidential and verification of customer records: legal name, address, business purpose, legitimacy and analysis of transaction activity.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments. Performed Gap/Impact Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Created Report using VBA, macros, and pivot table. Also done budgetary reports, which shows resource wise cost forecast and Actual.
• Facilitated User Acceptance Testing (UAT) along with the Subject matter experts (SME’s).
• Involved in reviews and preparation of test plans, test cases and conducted functional testing, integration testing, andsystem testing.

Environment: MS SharePoint, SOA, UML, Java, UNIX, Clear case, HTML, XML, XSD, Erwin, Business Objects.

Confidential

Business Analyst

Responsibilities:

• Managed business requirements for the project to move the credit risk-reporting batch to publish counterparty exposure limits earlier as part of an FSA compliance requirement.
• Responsible for understanding design and structure of different d Confidential marts. Also involved in writing ad-hoc queries for d Confidential mining and producing d Confidential mapping documents.
• 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. Conducted 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.

Environment: J2EE, UNIX, SQL, HTML, Excel, MS Project, RUP, MS PPT, Rational Rose, Doors

Confidential, NY

Business Analyst

Responsibilities:

• Understood current reconciliation process of AMEX from business perspective. Interacted with client to understand requirements and preparation of various deliverable documents required for meeting SOX compliance.
• Interacted with multiple teams across geographies to understand potential impact of rolling out across multiple regions. Gathered business and functional requirements and analyzing those requirements, generating workflow process and necessary documents for the project.
• Developed User requirement specification and functional requirement specifications and use case diagrams using UML to depict the system functionality in accordance with Rational Unified Process (RUP) methodology.
• Prioritized the requirements gathered from financial specialists, business users, domain experts through interviews, JAD sessions.
• Created and maintained the Requirement Traceability Matrix (RTM) between the requirements and other products such as design documents and test plans.
• Developed Analysis Model that includes entity classes, use case diagram, sequence diagrams, object collaboration diagram that provide the development team a view of the requirements for Construction phase activity.
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships, Developed Use Case specifications with flow of events, pre conditions and post conditions.
• Verification and sign-off business requirements with various stakeholders. Participated in various meetings and interacted with the analysts, and developers to discuss Enhancement and Modification Request issues.
• Interacted with analysts, system staff and developers and served as a system support liaison by monitoring and resolving errors. Participated in weekly meetings with the management team and walkthroughs.
• Involved in documentation as to how to maintain and run scripts for future enhancements.

Environment: RUP, UML, Rational Rose, J2EE, UNIX, SQL, HTML

Confidential, NJ

Business Analyst

Responsibilities:

• Knowledge transfer to team and creation of understanding document.
• Preparation of functional documents and review of design documents.
• Testing support for SEPA Credit Transfer work requests.
• Testing scenario preparation for SEPA Direct Debit design documents.
• Conducted Banking domain sessions for Technical Employees; sessions include generic payment, Swift and SEPA concepts.
• Prepared Use Cases, Process Flows, Activity Diagrams.
• Created ISO mapping documents and Interface Control Documents for SEPA messages.
• Member of the team for manual testing.

Environment: J2EE, QC, XML, Oracle, MQ, SQL, HTML, XML, MS Word, UNIX, Windows XP