SUMMARY:

• 9+ Years of experience working as a Business Systems Analyst within Financial, Capital market & Banking industries.
• Extensive hands on expertise on different Banking space - Financial modeling, Budgeting, Wholesale Banking - Payments & Cash Management, Internet and Channel Banking. Retail Banking - Check 21, Payments and Checks. Mobile Banking - Remote Deposit Capture, Bill Pay, Transfers. Commercial Banking - Loan Processing, Deposit Process and Reconciliation & Research and Solution.
• Business Analyst extensively experienced with AFS and ACBS (Advanced Commercial Banking System) data processing, system and business analysis, data mapping, testing, training, conversion, system upgrade, General Ledger Account balancing, and post-conversion support involving strong analytical and problem-solving skills. Experienced in full project life cycle.
• Business Analyst extensively experienced with ACBS (Advanced Commercial Banking System), Loan Management, Loan Origination, Mortgage initiation and valuation, data processing, system and business analysis, data mapping, testing, training, conversion, system upgrade, General Ledger Account balancing, and post-conversion support involving strong analytical and problem-solving skills. Experienced in full project life cycle.
• Strong knowledge of Project managemen t skills such as time estimation, task identification, and scope management in Finance and Banking domains using different SDLC Methodologies.
• Experience with all consumer credit bureaus and business bureaus.
• Proficient in gathering and analyzing user requirements , creating Business Requirement Documents (BRD), Functional Specifications Document (FSD), Prototyping, UML Diagrams using various tools including MS Visio, Rational Rose. Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading and derivatives trading). Diverse experience in Audit, Tax, Online Banking and Financial Services. Diverse experience in Banking and Financial Services. Solid experience in Mobile Banking implementations .
• Proven experience in improving Resource Efficiency, shortening Project Span, and reducing Project Cost performing Variance Analysis simultaneously through system modeling methodologies Agile , Rational Unified Process ( RUP ), Rapid Application Development (RAD) and Waterfall .
• Improving user experience within LOS and consumer facing websites.
• Worked in multiple RDBMS systems including Teradata, sybase, MS SQL Server.
• Adept in performing Gap Analysis, Feasibility Analysis, and SWOT Analysis to check the compatibility of the existing system infrastructure with new business requirements.
• Strong understanding in coordinating Joint Application Development (JAD) sessions.
• Structured Interviews to converge towards a product design, which is acceptable to Business Customers and feasible for Developers. Excellent knowledge of Enterprise Portfolio Management systems like Clarity, Plainview and MS Project Server. Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, Access and Lotus Notes. Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer. Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Participated in Project Assessment, Functional Analysis, Business Process Modeling, and Requirements Gathering; and converted Business Requirements into Functional Specifications using UML Techniques.
• Expertise in reviewing Test Procedures, creating Test plans, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing.
• Proficient in coordinating User Acceptance Testing with the Business Customers Analytical, methodical and resourceful approach to Problem Solving, Root-cause Analysis, Conflict Resolution, Negotiation Strategies to meet the business requirements.
• Expertise in Client site coordinator that involves understanding business requirements, day to day client interaction, offshore knowledge transfer activities, onsite status call coordination.
• Proven record of Team Management and Leadership skills. Excellent Presentation skills in regards to communicating with both business and technical teams.

TECHNICAL SKILLS

Rational Rose, Rational Requisite Pro, UML, HP Test Center, Test Director, Quick Test Pro (QTP), Clear Case and Clear Quest, C, C++, JAVA, J2EE, SQL Server, SAS, ORACLE, DB2, Windows: XP, 2003 Server, Mainframes, MS Office 2007 (Word, Excel, Power Point, Outlook), MS Visio, Macros, MS Project, MS Access

PROFESSIONAL EXPERIENCES:

Confidential, Rancho Cordova, CA

Business Systems Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyse the feasibility of their needs by coordinating with the project manager and technical lead. Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Implemented agile methodology for the project life cycle and scrum framework for team management.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system. Documented business process work flows, system work flows using Visio and created use cases using Blueprint requirements tool. Created a procedural manual of Workflow Monitor between OneTIS & GMAX trading system and assisted Program Management Office Team to create Training Material and provide Users Training using Camatasia Studio and Oracle User Productivity Kit (UPK).
• Involved in creating informatica mappings, Workflows, Tasks which involves various transformations like Expression, Lookup etc to load the data from various sources like Oracle, Mainframe COBAL files and sybase source to Teradata.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content. Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Reported and assessed all application defects, user issues and resolution status to the higher manager using Jira   Bug Tracking software. 
• Strong knowledge in Portfolio Management, Performance Measurement, Fixed Income, Equity, Credit Derivatives, Interest Rate Derivatives.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin. Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers. Used Visual Basic Editor (VBE) for developing and testing Macros in Excel.
• Involved in data migration design so that the data can be exchanged from other systems in standard ACORD XML standards. Worked on data modeling and produced data mapping and data definition documentation.
• Assisted in the automation of the mortgage portal with the Loan IQ system for the conditional approval.
• Configured the Data mapping between Oracle and SQL Server 2005. Tested Performance & Accuracy related queries under SQL Server. Designed and implemented basic SQL queries for testing and report/data validation
• Manage Scope and change throughout the SDLC process of the product.
• Incorporated Waterfall methodology to create Requirement Document Specifications using Visible Analyst. 
• Created and maintained data mapping documents. Testing and delivery of enhancements to Loan IQ to meet business requirements.
• Worked on user stories and worked on assigned tasks Jira  and updated the status in the Jira.
• Uploaded documents produced onto SharePoint, an intranet website for all Technology Information Group members to download, revise and upload shared documents.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle.
• Conducted JAD sessions with business units and stakeholders to define project scope and deliverable and constantly worked with the project team to design the application that will support the business and meet the constraints of time, resources and budget. Conducted user interviews and documented business and functional requirements.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects. Reported, recorded and Tracked defects using JIRA
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Involved in Regression testing of each build during the various phases of the application using QTP
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: RUP, UML, IBM Blueprint, MS office, SharePoint, MS Visio, Excel, Jira, MS Project, SAS, SQL, Oracle, Rational Rose, Rational Requisite Pro, Java, HTML, Oracle, Crystal reports

Confidential, Cherry Hill, NJ

Sr. Business Analyst

Responsibilities:

• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro. Gathered relevant Business Requirements or acted on behalf of Product Owner to implement Core Banking System.
• Interacted with teams in AFS (Automated Financial Systems) and ACBS (Advanced Commercial Banking System) to extract the information for the reports. Monitored daily various financial reports to verified the loan/fee balances were properly reported in the general ledger and ACBS (Advanced Commercial Banking System).
• Followed a systematic approach to elicit, organize, and document requirements of the system.
• Interacted with client and the Technical Team for the requirement gathering and translation of Business Requirement to Technical specifications. Used the Agile methodology guidelines to carry out every step of the business modeling process. Documented business process work flows, system work flows using Visio and created use cases using Blueprint requirements tool.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market risk and credit risk, general multi-factor sensitivity analyses.
• Tracking and reporting budget and cost allocation variances and performing cost/benefit analysis.
• Transforming requirements from MS Excel to new repository using Requisite Pro & MS Excel. Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Delivered consistent daily results as the fixed income capital markets office manager reporting directly to SVP and VPs of trading desk.
• Developed prototype for auto quote processing system for Quick Quote, Full Quote and New Business.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and lending.
• Reconcile Credit and Market Risk data, stress results being sourced from legacy systems into new data warehouse, using SQL, setup Data Governance and Data quality controls in partnership with business.
• Gathered requirements according to the SDLC using Waterfall.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application. Worked with members of the ACBS development team, finance and downstream application system to do the testing.
• Conducted weekly meetings to decide the Policies and Procedures to be followed while constructing new sites. Tested Loan IQ operations related to the commercial loan trading system.
• Assignment involved extracting the customer demographic information from a source customer system and updating it directly into the Loan IQ system.
• Create comprehensive test scripts to be used for regression scenarios as well as new functionality in Loan IQ .
• Analyzed and translated business requirements into system specifications utilizing UML Diagrams.
• Successfully gathered requirements for online application for lending mortgage loans.
• Prepared Functional Design Specifications employing Use case scenarios, sequence diagrams, ERD’s, DFD’s and class diagrams. Defining Software Development Lifecycle (SDLC) and planning the entire process using MS Project.
• Identified and clearly defined functional issues and supported IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle. Facilitated the User Acceptance Testing (UAT) of the application by working with users and documenting gaps in the beta version of the application. Created Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model . Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data. Worked on data modelling and produced data mapping and data definition documentation.
• Tools/Techniques: Agile- Hybrid development,   Jira , SQL Server, MS Visio, MS Excel, MS Word, MS PowerPoint, SharePoint.
• Documented the Traceability Matrix to trace the Test Cases and requirements related to them and assisted the QA Team with the Test Plan. Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables. Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content. Worked with Project management, Microsoft SharePoint, MS Visio, MS Office Tools (Access, Outlook, Word, Excel), Lotus Notes, Clarity and Project Workbench. Worked on MS Excel Macros for creating automatic reports.
• Prepared and proposed mock-ups of UI changes for internal-facing users and consumer-facing application.
• Performed Unit Testing and User Acceptance testing and documented detailed results.

Environment: Windows 2000/XP, IBM Blueprint, Rational Requisite Pro, Jira, MS Office, SAS, SQL Server, MS Project, Visio, Excel, SharePoint, MS Access, UML

Confidential

Business Analyst

Responsibilities:

• Reviewed the Project Vision document and specified the Scope, Stakeholders and the High Level Business Requirements.
• Used the Waterfall methodology guidelines to carry out every step of the business modeling process.
• Responsible for gathering and analyzing Business and system functional requirements and for understanding and translating these needs into Business Requirement Specification (BRS) and System Requirement Specification (SRS) documents. Performed GAP Analysis between the “As-Is” and the “To-Be” system. Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML. Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Domain expertise in Financial Risk Reporting, Liquidity Risk , Basel , CCAR, Credit Risk , Market Risk .
• Risk methodology and Basel implementation as per regulatory requirements.
• Communicated extensively with users to define key requirements which included SOX Compliance, Operational and managerial reporting needs, Workflow management, Quoting and marketing needs.
• Directed the UAT and GL Interface reconciliation phase of Loan IQ implementation with EQUATION Core Banking system. Performed regression testing on the Loan IQ project.
• Regulatory & Basel Reporting CCAR (Comprehensive Capital Analysis and Review) - Onboard new regulation, perform gap analysis, model for new metrics and stress scenarios, onboard & generate metrics, reconcile manual and automated aggregation final numbers.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Developed a wire transfer capability for making payments using SWIFT message.
• Followed the UML based methods to create: Use Cases, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams. Tested Loan IQ operations related to the commercial loan trading system.
• Converted requirements into user stories and added it in Jira.
• Prepared sequence diagrams, class diagrams and activity diagrams to elaborate the behavior, structure and process flow for the use-case models. Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool. Conducted extensive Joint Application Development (JAD) sessions for all business related issues. Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams. Used Reverse Engineering to create data models of existing databases.
• Conducted interviews with users to elicit requirements & test strategy pertaining to Navigability, User-Interface Design, transaction processing and work flow.
• Offered recommendations for revision to refine existing credit card  policies. 
• Broad technology background and comprehensive exposure to various capital markets research and electronic trading platforms such as BondDesk, Valubond, TradeWeb and Bloomberg.
• Experience with deposit accounts Credit cards, CD/IRA's, and Investment accounts.
• Worked with business owners to create and test business workflows via use of Graphical BPM (Workflow Mgmt) tool.
• Developed test cases and for use-case models for the reports interface.
• Followed a methodical Change Management Process and documented any Change Requests into Clear Case for any changes in the requirements after the requirements were base lined.
• Used Clear quest to report bugs and defects during UAT.
• Conducted user training using the Train-the-Trainer approach.
• Assisted the technical writers to prepare user manual and online help giving an end-user perspective.

Environment:  Oracle, RUP, Rational Rose, MS office, MS-Visio, Excel, Jira, SDLC, SQL, SAS, Oracle, Agile, RAD, PowerPoint, SharePoint, XML, QC, Clear quest

Confidential

Jr. Business Analyst

Responsibilities:

• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams in MS-Visio.
• Elicit requirements by employing information-gathering techniques (e.g., Interviews, surveys, business process analysis, competitive product analysis, reverse engineering of existing systems, etc.). Interacted with the user community to enhance understanding of the solutions project timelines and impact.
• Understood and articulated business requirements from user interviews and then convert requirements into technical specifications.
• Analyze multiple credit factors in order to increase larger Business credit card  limits.
• Interacted with SME's, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.
• Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures.
• Used the UML for structuring / modeling the whole project. Identify Use Cases and developed Use Case Diagram using UML.

Environment: MS Project, MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio, SQL