SUMMARY:

• Over all 6 + years of Industry experience as a Business Analyst 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 and Financial environments.
• 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.
• Hands on experience working with Business Intelligence (BI) tools like Cognos, Microstrategy, Teradata, Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Strong knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
• Experienced with data warehousing and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Proven software development experience using different methodologies - Agile and Waterfall
• Worked on creation of Cognos and performance tuning of backend SQL generated for Cognos reports for faster report output.
• Utilized JIRA to develop and track Agile epics, stories and tasks.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Expert in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design. Expert in requirement planning, requirement gathering, requirement documentation, solution assessment, process mapping, data modeling, Conducting JAR/JAD sessions, perform walkthroughs and verbally present updates & software functionalities to business stakeholders and/or users.
• Participated in Agilescrum meetings for requirement gatherings and product development.
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications, Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams .

TECHNICAL SKILLS:

Methodologies: SDLC, Agile, Rational Unified Process (RUP), UML

Testing Tools: QTP, WinRunner, Load Runner, Mercury Suite, Rational Suite.

Management Tools: MS-Project, Rational Requisite Pro, Rally

Applications: Rational Rose, MS-Visio, MS Excel, Cognos,MS-PowerPoint, MS-SharePoint, Aqualogic.

Document Management Tools: MS Visual Source Safe, CVS, EDM and Documentum.

Industry Standards: ISO, CMM, IEEE, ANSI, Six sigma

Languages: SQL, PL/SQL, ASP 2.0, Java 2.0, JavaScript, Visual Basic, VBA, VB Script, VB.Net, HTML, XML, DHTML and Shell Scripting.

Defect Tracker: Rally, Quality Center, Test Director and Lotus Notes Defect Tracker.

Web Development Tools: FrontPage, Visual Interdev, Photoshop

RDBMS: SQL Server 2005/ 2000/ 7.0 , Teradata, Oracle 9I/8.0, MySQL 4.0.16, TOAD, DB2, IMS-DB.

CRM: Chordiant 6.2.1, MS Dynamics CRM 2011 and MS Dynamics CRM 2013

Operating System: Windows XP/Vista/2000/NT, Mac (9/OSx), Linux and Sun Solaris 5.8/2.8

Protocol Financial: TCP / HP. HTTP, SOAP, FTP, Market Guide, Basel II, Business Objects, Bloomberg, First Call, SOX, Reuters

WORK EXPERIENCE:

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager and SME’s to get a better understanding of the Business Processes, and Analyzed and optimized the process.
• Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Analyzed requirements for loan request, loan process, member services, processing and portfolio management.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations.
• Troubleshoot and repair existing complex MS Access database including generating ad-hoc reports as needed
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Held and attended presentations and meetings to coordinate efforts among all the groups, leading the inception phase. .
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational RequisitePro.
• Converted complex Excel spreadsheet to MS Access for project estimations Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Writing Epics and user stories, managing sprints and backlog grooming, and tracking project progress in JIRA. Used JIRA tool to track and maintain different versions of the project documentation.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts.
• Executed the test cases manually for various job submissions in batch processing by using the Test Director/Mercury Quality Center.
• Did the regression testing using pre-existing test cases besides integration testing of various modules of the application.
• Prepared Functional and Behavioral document that describe the detail design of the application.
• Used the Unified Change Management (UCM) tool, Rational ClearQuest to maintain and track the stakeholders requested enhancements and changes.

Environment: RUP, Rational Requisite Pro, IBM Rational, Clear case, Clear Quest, Data warehouse, UML, Mainframe, Unix, XML, MS Project, MS Word, MS Excel, MS Visio,

Confidential, Vienna, Virginia

Business Analyst

Responsibilities:

• Involved in meetings with users, stakeholders to identify problems and to resolve issues and improve the process to ensure a stable and accurate solution.
• Extensive knowledge with Fixed Income, Equities, Foreign exchange. This includes the associated systems; Swift, Chips, FedWire, Euroclear, DTC, DTCC.
• Interacted extensively with Subject matter experts, Business stakeholders, Users to define accurate requirements and developed the detailed Business Requirement Documents (BRD) for the Data warehouse.
• The Detailed Business requirement document contains the Business requirements, system requirements and the data requirements required to be available in the Data warehouse.
• Utilized Rational Unified Process (RUP) iterative guidelines on all the phases (Inception, Elaboration, Construction and Elaboration) for development of the Application
• Conducted Joint Application Development (JAD) sessions with management, end users, and other stakeholders to synchronize and update the requirements requested by business users.
• Created Requirement Traceability Matrix and which maps the Business requirements to the system requirements and the maps the system requirements to the data requirements.
• Interacted with Business team, SMEs, developers, testers to prepare the Business requirements doc, detailed mapping document and work with the developers and testing team to support throughout the project phase to get the requirements implemented.
• Performed Defect Tracking and Project Tracking using Jira - Change Notification Request (CNR). Utilized JIRA to develop and track agile epics, stories and tasks. Trained the team on JIRA tool for Agile/ Scrum Methodologies.
• Incorporated Automated Clearing House (ACH) functionality for the Private Label Credit Cards for Cash Advance abilities.
• Provided daily and weekly updates to managers on artifact and application status to help prepare accurate project timelines and resource estimates
• Interacted with QA and conducted User Acceptance Testing (UAT) to check the functionality of the system. Involved in task documentation at all levels and interacted with the developers to report and correct bugs
• Conducted training sessions for the users and also prepared user manuals for better understanding of the designed system for the users.
• Performed Gap analysis for upcoming Payments data warehouse project by working with different department teams in Capital one, to see how much of the Payments data is already available in the different Data warehouses available such as BANK Data warehouse, Treasury Data warehouse, CARDS data warehouse and documented the gap analysis results in a efficient manner.
• Performing Data stewardship activities such as communication to the Business users, User acceptance testing coordination, Users Training on the Mortgage data warehouse, Metadata upload into Roachade, et al
• Responsibilities include support and maintenance of Mortgage Data warehouse in Teradata environment, implementing data quality checks for external files, defects tracking and prioritization, data issue management.

Environment: SQL, MS Visio, Rational Requisite Pro, MS office, Quality center, HP ALM, VSS, Teradata

Confidential, San Francisco, CA

Business Analyst

Roles and Responsibilities:

• Functioned as the primary liaison between the project team, operations team and other technical areas throughout the project
• Analyzed/prepared USD high value Fedwire payments to prevent REG W violations
• Developed and Implemented Money Movement system to empower Confidential to introduce new services
• Develop an easy to use system with the ability to make secure funds transfers directly from a customer's account to a third party
• 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 (Fedwire) 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
• Assured and controlled quality according to Standard for Financial Services Messaging ISO 20022
• 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 (FedWire, 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
• Used MS Project to manage schedules, deadlines, and resources
• Organized weekly project status meetings, created PowerPoint presentations, and project updates using MS Project for management review
• Utilized MS SharePoint to manage diverse content and effectively mange requirements.
• Conducted JAD sessions with management, business team, stakeholders and developers to clarify business requirements.

Confidential, Boston, MA

Business 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 analyzing 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.
• 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.
• Analyzed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.
• Reviewed business requirements document for ACH (automatic clearing house) through interviews, surveys, prototyping and observing from senior managers and UI (User Interface).
• 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.
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines. .
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Worked with development and product management to determine resource needs, test requirements strategy, and defect management process.
• 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, MS Project, Windows XP,