SUMMARY

• Business/Systems Analyst with 5+ years of with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design with excellent domain knowledge and work experience in Banking, Financial, Retail Applications, Purchase Order Management and Supply Chain.
• Excellent understanding of EFT system (such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage).Knowledge of Online Banking and the whole Fund Transfer process
• Experience on Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement and Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process. Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Business Process Analysis: Proficient in analyzing Business Requirements, System Requirements, Functional Requirement specification (FRS), Design Documents, Use Case Specifications (Use Cases), UML diagrams, Requirements Traceability Matrix (RTM) and performing Gap Analysis, Impact Analysis, Process Analysis and designing prototypes to design the test flows.
• Extensive experience in documentation of Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Assisted in preparing and executing Test Cases, and reviewed Test Execution Procedure Document (EPD) document prepared based on the Business Requirement Specifications (URS), Functional Requirement Specifications (FRS) to cover overall quality assurance.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence), Power BI.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile. Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.

TECHNICAL SKILLS

Project Methodologies: SDLC, Waterfall, Agile, Spiral, RUP

Defect Tracking Tools: JIRA, JAMA, Bugzilla

Data Base: SQL Server, Oracle

Document Management Tools: MS Visual Source Safe

Applications: Microsoft office suite, Microsoft Visual Studio

Operating System: Windows, Linux

Others: MS Office, MS Excel, V, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Responsibilities:

• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Worked extensively with SMEs in understanding and documenting their requirements pertaining to Loan Origination, ARM, Escrow Analysis, ACH based Accounts, maintaining and analysing customers Accounting books and many other business Areas.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities.
• Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer System (EFT) such as CHIPS and ACH
• Managing a team of business analysts and Developers, this role also requires close liaison with Business personnel to Division Head level in Product Control, Front Office, Compliance, Treasury, Derivative Middle Office, Global Equity Finance and Settlements.
• Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
• Developed and customized batch and real - time client interfaces supporting Money Transfer, Automated Clearing House (ACH) and credit card processing.
• Coordinated the mainframe update of mid-day processing and update of the backend DB2 database.
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Used SQL queries and data mining to provide summary reports and data feeds to analytics. Manage ETL defects, enhancement, and new functionality requests to meet changes in the business needs.
• Performed daily and periodic Surveillance of trading activity and other activities of Financial Advisors, while Keeping up to date with company and industry regulations regarding financial institution activities
• Reviewed business requirements document for ACH (automatic clearing house) through interviews, surveys, prototyping and observing from senior managers and UI (User Interface).
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artefacts and activities.
• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.

Environment: IBM Personal Communications, SDLC, SQL, Visual Basic, MS office Suite, XML, OOAD, Agile/Scrum, UML, MS Visio, Mainframe

Confidential, Oakland, CA

Business Analyst

Responsibilities:

• Provide business and technical analysis, implementation, training and support for ecommerce sites. Actively participated in status report meetings and interacted with developers to discuss the technical issues and performed UAT.
• Perform Web analytics requirements, analysis, implementation, testing and on-going support of web quality analytic tools to improve site quality, availability and search ranking.
• Worked with business owners and stakeholders to understand and develop BRD (Business requirement documents) for CMS and DAM (Adobe AEM) implementation.
• Requirements of migrating of Content from legacy system to Adobe AEM and functionalities including Multi-site management and multi-channel management.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and ensured that critical requirements are not missed and provided e-commerce based solutions to their complex business problems.
• Used JIRA tool to track and maintain different versions of the project documentation. Writing user stories, managing sprints and backlog grooming, and tracking project progress in JIRA.
• Supply Chain KPI tracking, root cause analysis of failures and supports corrective action implementation. Worked with key members from cross-functional teams to analyze various third-party CRM solutions to make a ‘buy vs. build’ decision. Conducted cost/benefit and impact analysis.
• Owned the weekly Burn down charts, agile wall updates, Tracking Planck cards (a communication protocol between the onsite-offshore agile team members).
• Liaise across teams- development, project management, business managers and vendors to identify and resolve issues to deliver projects on time in a Microsoft .net/SQL environment.
• Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• As an onsite coordinator was involved in gathering requirements for the functionality that needs to be tested as part of Adobe AEM rollout.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Defined and clarified specifications for EDI software enhancements through communication with various departments. Worked with Product Owners to identify current processes and created Business Process Flow diagrams. Various versions of the documents generated during the project were maintained and managed using Rational Clear Case.

Environment: Microsoft Office Suite, SharePoint, Adobe Photoshop, HP ALM, Quality Center, Jira, Scrum, Agile

Confidential, Cleveland, OH

Business System Analyst

Responsibilities:

• Functioned as the primary liaison between the project team, operations team and other technical areas throughout the project
• Managing all treasury management products such as Internet Banking, Business Banking, Telephone (VRU) Banking, Mobile Banking, Bill Presentment, ATM/Debit cards, Remote Deposit Capture (RDC), Automated Clearing House (ACH), Positive Pay, Lockbox, Wire Transfers and Merchant Services
• Responsible for data mapping and data mediation using MS Access and MS Excel. Created SQL queries to pull out data and metrics from the database
• Develop an easy to use system with the ability to make secure funds transfers directly from a customer's account to a third party.
• Business areas of expertise include Treasury, Investment Banking, Wealth Management, Broker Dealer Settlement and Clearance systems, Structured Financing, Equities, and Fixed Income across different regions (NA, EMEA, LATAM and APAC), EFT (ACH and SWIFT), AML Compliance.
• Created database schema diagrams for data mapping of existing Access database and future Oracle database.
• Assisted operations team in developing content and training materials in the form of a usable and search-able knowledge database
• Organized weekly project status meetings, created PowerPoint presentations, and project updates using MS Project for management review
• Conducted JAD sessions with management, business team, stakeholders and developers to clarify business requirements.
• Responsible for Collateral Management, the process of agreeing, confirming and advising collateral transactions. Collateral are assets or properties that are offered to secure a loan or other credit.
• Coordinate with garnishment specialist in working with Accounts Payable and Treasury to balance garnishment deductions and vendor payments.
• Analysed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.

Environment: Microsoft Office Suite, MS Visio, Windows, Quality Center, JavaScript, UNIX, HTML, Oracle, SQL

Confidential, Houston TX

Business System Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Desktop application upgrade - client created custom offline desktop application for their users to browse recommended products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG ecommerce suite. Developed function specifications for modifications of POS system for multiple chains. Included integrating new chain into existing systems which encompassed, gap analysis, specific brand requirements and full POS integration.
• Provided recommendation for use of ATG Commerce for B2B and B2C business. Provide innovative IT, business & e-commerce solutions to perspective and existing clients.
• Validating Order Management System (OMS) and Customer Relationship Management (CRM) system. Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Capture Feature/Function information at varying levels of granularity and document them in a requirements management tool (e.g. Microsoft TFS, JIRA, etc.)
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data and Prepared and documented System Requirements and workflows for the Content Management Application tool.
• Conduct group sessions in order to understand functional requirements for a Point-of-Sale (POS) system, Micros. Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• Worked as BA analyst in testing Billing and Order Management Systems (OMS) and also in validation of the converted data from conversion legacy billing system into Amdocs.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology. Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML). Utilize Retail Link and other vendor portal POS data to support the account manager with meeting daily demands.

Environment: Rational Rose, Rational Req Pro, POS, RUP, Agile, Jira, ATG, SQL Server