SUMMARY

• 7+ years of diversified experience as a Business Systems Analyst in Banking and Finance domain.
• Expertise in identifying and documenting detailed Business Requirements pertaining to Portfolio Management, Performance Reporting, Wealth Management, Online Retail Banking, Product Management and Transaction Processing.
• Thorough understanding of Anti Money Laundering (AML) procedures and hands on experience of working to ensure AML compliance at client’s place.
• Experience in conducting due diligence reviews on individual and business accounts and update KYC profiles in accordance with KYC requirements.
• Experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost - Benefit Analysis.
• Process Knowledge of AR/AP/GL, Credit management, Fixed income analysis, Risk management, Mortgage Banking basics (Mortgage cycle), Mortgage Underwriting and (Unsecured Loans) Personal Loans Operations.
• Having strong domain knowledge in application catering to banking/Credit cards / mortgage business. Familiar with full life cycle of credit cards applications for different banking systems. Have strong knowledge in following phases of credit cards life cycle.
• Highly enthusiastic on the functioning of SDLC, particularly in agile product life cycle (SCRUM) methodologies. Previous project experience included transformation of non-Agile teams to agile teams.
• Adept at eliciting business and functional requirements through 1-1 meeting, interviewing session, Joint Application Development (JAD) sessions.
• Proficient in creating Wireframes, UI/UX Models, Use Cases, Activity Diagrams, for core banking activities such as Time deposits, IRA and Demand Deposits etc.
• Experienced meetings coordinator/moderator and Joint Application Design (JAD) facilitator with excellent interpersonal and conflict resolution skills.
• Excellent skills in documenting Business Requirements Document (BRD), Functional Requirements Document (FRD), System Requirement Specifications (SRS), Use Cases and Test Cases.
• Proficient knowledge of Unified Modeling Language. Expert in analyzing and creating Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Flow Diagrams and Sequence Diagrams using MS Visio.
• Extensive use of the BABOK guidelines and practices.
• Expertise in implementing Test Plans, Test cases, Functional testing, Regression Testing and Integration Testing. And maintaining Requirement Traceability Matrices for baseline documents.
• Fluent in a broad range of technologies, including Business process tools such as MS Project, Excel, Access, Visio, Balsamiq and Axure Wireframing/Prototyping tool.
• Experience in conducting Gap Analysis, expert in creating AS-IS and TO-BE documents.
• Expert in facilitating and defining the entire Testing Life Cycle and experienced in conducting the User Acceptance Test (UAT).
• Expertise in creating Business Process diagrams, Use Case documents & UML diagrams including Use Case diagram, Data Flow diagrams, Flow charts, Activity diagram, Entity Relationship diagrams and Sequence diagram.
• Experience in Creating and Maintaining the Requirements Traceability Matrix (RTM).
• Good understanding of SQL queries to extract, update and delete the data from data base.
• In depth of knowledge of software development life cycle (SDLC), waterfall, Agile/Scrum methodologies and Rational Unified Process (RUP).
• Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

Software development methodologies: Agile, Waterfall, RUP

Databases: MS-SQL Server, SAP Database, MS Access

ETL Tool: Informatica Power Centre

Web Tools: WEB UI 6.1, HTML, CSS, XML, XSLT

UML Tools: MS Visio, SAP Power Designer

Testing Tools: Quality Center, JIRA, User Acceptance Testing (UAT), Defect/Bug Tracking, Test Plans, Cases & Processes

WEB UI Framework and SAP Objects: BDC, Smart Forms, & Enhancements

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. Business Systems Analyst

Responsibilities:

• Facilitated brainstorming session, JAD session,conducted all day Working session, requirement gathering session.
• Worked with consultant to turn on Translation for General Ledger (GL). Work included creating and executing GL allocations to re-state ledger balances as needed for the process, updating ledger configuration, performing UAT, researching and correcting issues, and implementing in Production.
• Developed BRD, FRD, Activity flow,Businessprocess flow and Use cases.
• The project heads towards enhancing the existingonlinebankingapplication by improving its GUI, making it user-friendlier.
• Application was developed forOnlineBankingaccessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
• Performed extensive Vendor Management. For example, manageOracleEBSFinancialsand relationships with third partyOraclepartners.
• Facilitated all aspects of the Scaled Agile Framework (SAFe), sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives.
• Facilitated requirement walk through session involving Clients, developers andbusinesssupport group.
• Engaged with Confidential ’s auditors on annual reviews ofOraclecontrols and transactional system reconciliations to the general ledger.
• UtilizedOracleBI (OBIEE) toolset and the Data Warehouse to retrieve data for forecasting and monthly analysis for plan variances.
• Involved in API testing using Postman to check if the APIs are returning the data in JSON, XML format as defined in the API documentation (Using Swagger Tool) along with automating the workflows.
• Assisted TPM in organizing team meetings, avoiding conflicts and maintaining the project schedule by requesting the forecasted timeline from all team members each month.
• Documented the Current and Future State Accounting Work flow as part ofOnlinePayments.
• Created Action Item, Issue Log, Risk Log, Decision Log and documented risks and issues with its priority and assigned them to right person
• Analyzed Inventory of requirements and prioritize Gap/Fit matrix with oracle applications. Mapping requirements with Oracle standard features.
• Coordinated comprehensive analysis and resolution of payments, invoices and expense reports, working with financial officers to analyze and report data stored in R12 Oracle Finance modules and HR system.
• Daily communication with clients, Vendor and SMEs to get the status of action items, response to risks and issues, update the log and provide the updates by EOB.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Tested several ACH transmissions to various banks. Added logic to consolidate several accounts with a single bank into one transmission, to reduce processing time, bank fees, and amount of technical support required.
• Involved in researching solutions for Customer to review ACH payments for automated cycle, prior to submission of the file.
• Developed the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Tested migration data in a test instance ofOraclein the development schema (Test Plans, Project Guidelines) for a migration conversion of two instances ofOracleinto one instance ofOracleto ensure the data migrated correctly.
• Wrote Test case, and test Scripts.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Filled the Role of Test manager by creating Test case, reviewing it and getting approval from clients, developers, and SME's.
• Conducted daily SIT testing status update meeting, logged identified defects in HP Quality center, Assigned the defects to right resources, updates progress status and severity status.
• Assisted Clients in documenting UAT test scripts

Confidential, Detroit, MI

Business Systems Analyst

Responsibilities:

• Gathered requirements using interviews, document analysis, requirements workshops, business process descriptions, business analysis and workflow analysis.
• Worked closely with the UI in MS-Visio to model the screens, which met user defined requirements, organizational and regulatory standards.
• Setting up loan templates from various commercial lending deals from CRE, ABL into the ACBS system. Building customers records, facilities and loans in pipeline and servicing for the prototype testing for the business users
• Maintaining and keeping track of the fields and preparing a proposed file layout (Field Name, data type, Details) that needs to find a house or transferred in ACBS and documenting it.
• Making Process flows in Microsoft Visio of the ACBS processes in different BRDs to make the business Users better understanding of the new system.
• Making test scripts and test scenarios to be input in ACBS for prototype testing and for conversion scoping.
• Maintaining and managing meeting minutes of various interfaces meetings and uploading on SharePoint on regular basis.
• Participated on team that developed UI/UX standards and ensured system adherence to the approved standards, thus promoting consistency and usability
• Used Wire framing and Prototype tools to assist in Wireframe workshops that would consist of individuals from the business along with the UX Designer, Application Architects and Developers.
• Involved in project review meetings, gathering System Requirement Documents (SRD) and Data Mapping Sessions.
• Being a part of Conversion scoping sessions with the FIS and business users to discuss and keep a track of fields that are required to be converted in the new system.
• Keeping track and maintaining User defined tables, translation tables and purpose codes tables during the discussions.
• Review Business Requirement Documents (BRDs). Facilitate meetings with the appropriate subject matter experts for CRE, ABL, C&I & Trade Finance. Ensure that high-level business requirements (sections, sublimit) have been decomposed properly into useable functional requirements for ACBS.
• Performed data analysis and cleansing guided by the business rules and source data.
• Meeting with decision makers, system owners and end users to define and document requirements and goals.
• Drafted training manuals and user documentations for business users.
• Conducted various JAD sessions with different business users for requirements elicitation and for discussing various business lifecycles of commercial lending.
• Developed Process Designs, Use Case, Use Case Diagrams, Activity Diagrams, Sequence
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio, MS Word and MS Excel.
• Extensively worked with SMARTS for market surveillance, supervision and compliance activities.
• Responsible for creating business requirements documentation using Visio.
• Developed and managed project plans, schedules, issues log and business-technical conflicts.
• Extensively used JIRA for change management.
• Prepared project related Presentations and provided Reports to Higher Management.
• Worked with the Quality Assurance led to develop detailed Test Plan and Test Cases.
• Created PowerPoint presentations and project updates using MS Project for management review
• Validated the Test Cases against the functional requirements.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Created Use cases and other related UML diagrams for various functionalities of Deposit Products.
• Evaluate internal processes in deposit operations and suggest workflow improvements to increase efficiencies and reduce or eliminate risk factors.
• Review core software system specifications for deposit and lending products and make changes as necessary.
• Was responsible for gathering requirements both functional and non-functional based on interactions with the process owners and business team.
• Created accounting requirements (BRD) for multiple Core Banking tracks, including FX/Money market, Deposits, Trade Finance and Loans.
• Engaged in supporting various range of banking projects from enhancements to strategic initiatives in terms of test planning, implementation and execution with a goal to deliver high quality software projects for Deposit Operations.
• Developed project plan and charter for comprehensive commercial lending written communications evaluation
• Gathered and documented UX\UI (visual) requirements, functional and non-functional requirements in Business Technical Requirement Document
• Gathered requirements for sourcing and delivering the data and Interface requirements between various Partner Systems for Payments Processing for Corporate Banking purposes which involved detailed understanding of Payments and Processing Standards like IBANs, SWIFT, ACH etc.
• Analyze and develop teller applications.
• Delivery of business requirements for all interfaces into a commercial lending origination and servicing system for a large straight through processing implementation and conversion project
• Gathered and converted Business Requirements to Workflow Rules for deposit products.
• Managed Microsoft Dynamics CRM Mobile project by interviewing multiple third-party vendors to decide on a solution to launch CRM Mobile to the company's sales force.
• Work with end users to determine system requirements for commercial lending workflow system.
• Gathered and defined business requirements in partnership with a commercial lending business for several medium and small initiatives. Resulted in clear requirements which allowed the commercial lending overall goals and objectives to be met in a six-month period.
• Created Data modeling diagram.Created SQL server databases from flat files
• Prepare business requirement documents to build the new data mart at product level
• Set up agenda for JAD session with project stakeholders, subject matter experts (SMEs), end users, Developers, Testers and project management team. Contacted participants and make the proper schedule accordingly.
• Documented business requirements and technical requirements document using process and data models to explain detailed business implications and impacts.
• Prepared Use Cases for the functional requirements to define the system rules. Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Dataflow Diagrams in MS Visio to effectively communicate the requirements.
• Used the Waterfall methodology to define the SDLC process.
• Conducted requirements definition and analysis to capture, clarify, and confirm the requirements.Closely interacted with developers and QAs to communicate and validate requirements as needed.
• Assisted Project Manager in managing requirements by coordinating and facilitating requirement tracking using Requirement Traceability Matrix (RTM).
• Interacted with developers to resolves questions and discrepancies in documents, hands-on experience with SQL queries.
• Involved in the Testing phase, reviewed test strategy and created test cases to ensure the transformation to the new database. Conducted presentations for analysis of test result with stakeholders.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Reviewed and analysed the business environment and identified process improvements.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Worked on SDLC, Business analysis, GAP analysis and Quality Assurance of application software in Agile framework.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.
• Involved in generation and execution of SQL queries.
• Acted as User Acceptance Testing coordinator and monitored.