Sr. Business Analyst Resume
Buffalo, NY
SUMMARY
- Over 8 years of experience as a Business Analyst and considerable financial banking expertise.
- Pursued Confidential .B.A. in Finance in 2008.
- Extensive and In - Depth knowledge of electronic payment processing, stocks, futures, forwards, options, commercial and retail banking, Financial Statement Analysis, Accounts Payable, Accounts Receivable, Inventory Management, Accruals, FX Trading, brokerage and mortgage industry.
- Good knowledge of the payment processing industry and hands on experience working on FX and Options Trading Applications.
- Ran SQL queries and executed stored procedures to gather and analyse data and create reports on the analysed data.
- Proven expertise in gathering, analysing and documenting business requirements and developing Business Requirement Document.
- Extensive knowledge and experience in GAP Analysis, Financial Statement Analysis, Valuation of companies, analysing industry and market trends and Statistical analysis using SPSS.
- Rich experience in coordinating Joint Application Development (JAD) Sessions and effectively interacting with on-shore and offshore business users across multiple geographies.
- Extensive exposure to various SDLC Methodologies like Agile, Waterfall, RUP, Scrum and RAD models as well as extensive knowledge of Software Development Life Cycle (SDLC) and Capability Maturity Model (CMM)
- Strong understanding of Investment banking, Fixed Income, Bonds, Equities, Derivatives (Options and Futures), Fund Accounting, Portfolio Management and Wealth Management.
- Experience in conducting various analysis including ROI, AS-IS and TO-BE, Cost-Benefit analysis and Risk Analysis.
- Proficient in UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.
- Experience in working with the QA Testing Team, creating Test Plans and Test Cases and also UAT (User Acceptance Testing)
- Used Case management solutions support a complex process that requires a combination of human tasks and electronic workflow
- Good working knowledge of MS Visio, MS Projects, SPSS, @Risk and MS Office tools.
- Projects successfully delivered include IBM BPM, Message Broker, WebSphere.
- Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short- and long-term business and system requirements.
- Knowledge of Office of Foreign Asset Controls (OFAC) regulations, the USA PATRIOT Act, the Bank Secrecy Act (BSA), and Anti-Bribery and Corruption and its implementing regulations as associated with Financial Crimes Enforcement Network (FinCEN)
- Extensive knowledge and experience on Anti Money Laundering (AML) and Bank Secrecy Act (BSA)
TECHNICAL SKILLS
Project Management Tools: Microsoft Office tools, MS Project, MS Visio, MS Access, MS Word, MS Excel, MS Outlook, and MS PowerPoint
SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and Waterfall
Requirements/Document Tools: Rational Requisite-Pro, Rational Clear Quest
Testing Tools: Quality Center and Quick Test Pro (QTP)
Modeling/Design Tools: Rational Rose, Microsoft Visio
Operating System: Microsoft Windows
Data Analysis and Financial Modeling Tools: SPSS, MS Excel (Pivot tables, Vlookup, VBA) and MS SQL Server Management Studio.
PROFESSIONAL EXPERIENCE
Confidential, Buffalo, NY
Sr. Business Analyst
Responsibilities:
- Responsible for evaluatingbusinesssystems and user needs of the application, leveraging analysis to recommend system andbusinessprocess modifications.
- Writing detailed description ofbusiness goals, user needs, computer program functions, and steps required to develop or modify computer programs and communicating requirements to software developers and assures that the designed solution will meetbusinessand user needs.
- Have functioned in Product Owner and Scrum Master roles as needed.
- Documented Business Requirement Document (BRD), Technical Requirement Specification (TRS) and Functional Requirement Specification (FRS) for the integration of IBM BPM tool
- Designed and performed the data mapping for Enhanced Due Diligence (EDD) and Further Due Diligence (FDD) data
- Performed SQL queries testing on Enterprise Case Management (ECM) to Dynamic Data Center (DDC) submission.
- Ran SQL Queries and Stored Procedures to analyse data and create reports on the analysed data.
- Reviewed and analyzed key elements of each KYC due diligence cases using Mantas and ECM
- Designed Business Process Models using UML methodology on MS Visio and IBM Blueworks Live
- Documenting End to End systems flow with requirements, segregating them into low level Use Cases, activity and UML sequence and swim lane diagrams
- Developed test plans, test cases, test scripts, test scenario, test reports for functional testing in the HP ALM Quality Center
- Captured the bugs during UAT testing and communicated to the development team and increased the efficiency by 75%
- Worked alongside with compliance and regulatory team to maintain Federal Regulations for BSA/AML audits
- Adapted agile methodology during the ECM Replacement project
- Analyzed Hudson City Merger impacts on the project, re-designed the process flow and create wireframes for BPM.
- Worked on MS Excel, MS Visio and MS Projects in order to conduct a detailed financial analysis of various projects and presenting the findings in form of PowerPoint Presentations or Research reports during executive level meetings
- Responsible for delivering IBM BPM solutions to key customers, engage and manage project delivery and process improvement.
- Working in Agile environment on all project aspects ranging from requirement gathering to supportingBusinessAcceptance Testing (BAT), engaging with Product Owners and stakeholders to drive IT system design
- Working with the Data Architecture team to derive system flows by evaluating data operations and access patterns
Confidential, Chicago, IL
Sr. Finance Business Analyst
Responsibilities:
- Extensive knowledge and experience working on MS Excel, MS Visio and MS Projects in order to conduct a detailed financial analysis of various projects and presenting the findings in form of PowerPoint Presentations or Research reports during executive level meetings.
- Conducted project analysis using MS Projects, MS Visio, CPM, PERT and participated in each phase of the SDLC following RUP methodology.
- Exposure to various SDLC methodologies like Waterfall, RUP, Agile, Scrum and RAD Model as well as extensive knowledge of Capability Maturity Model (CMM).
- Helped in defining and managing the project scope as well as developed Use Cases and Project Plans
- Designed Business Process Models using UML methodology (Activity diagrams, Sequence diagrams and Collaboration diagrams on MS Visio)
- Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
- Worked on project related to automation of gathering business requirements, analysis, functional specification, underwriting rules and review process.
- Saved time and cost incurred at later stages of the project by conducting Formal Technical Review to make sure that the requirements conveyed to developers were understood well before the actual development started.
- Conducted a detailed SWOT analysis, GAP analysis, cost benefit analysis and ROI analysis.
- Conducted in depth financial analysis for projects and used SQL for data extraction and advanced MS Excel to present and analyze the data
- Identified needs of Business users, Stakeholders and SME by gathering requirements and analysing various documents.
- Used Change Request Forms (CRF) to file change requests received from the clients.
- Reviewed technical specifications to develop test plans, test objectives, test cases and scripts.
- Conducted testing extensively using Quality Center
- Participated in User Acceptance Testing (UAT) as well as helped in developing QA Test Plans for Functional Integration Testing.
- Conducted As-Is and To-Be analysis and documented them.
- Supporting data collection and documentation of "KYA" data from scoped Master Agents
- Acquired extensive knowledge of the electronic payment industry through constant interaction with industry veterans, trade journals, classroom training and various industry publications.
- Review and analyze key elements of each KYC due diligence case
- Responsible for delivering IBM BPM solutions to key customers, engage and manage project delivery and process improvement.
- Performed analyses, monitor account activity, and evaluate potential risks of accounts and relationships with increased chances of money laundering or criminal financing.
Environment: Windows/UNIX, UML, MS Visio, MS Project, MS Office and SQL
Confidential, New York, NY
Business Analyst
Responsibilities:
- Finalized the Business Requirements Documents by constantly interacting with the business users and managers.
- Constantly interacted with stocks, fixed income and ETF research teams and gained an excellent working knowledge in that subject area.
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and insured that critical requirements are not missed.
- Interacted with the business stakeholders in order to gathered and identified Business requirements and translate them to system specifications.
- Managed all the requirements (Business Use Cases and Functional Specifications) in RequisitePro, making requirements available to all team members and maintained traceability between requirements, design, and UAT test cases.
- Converged IBM BPM models into usable development artifacts including Use Cases, Business rules, Screen Mock-ups/Wireframes, and Test Cases.
- Created Use Case Diagrams, State Chart Diagrams and Activity Diagrams to model requirements.
- Created Business Use-Case Model and Business Use-Case specifications after accessing the status and scope of the project and understanding the business processes.
- Led weekly meetings with technical teams to discuss outstanding technical issues and deadlines that had to be met and produced Functional Specifications.
- Created UAT cases and UAT scripts and assisted SMEs in UAT execution.
- Resolved open and pending issues by conducting JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders on a regular basis.
- Used Change Request Forms to manage and control changes, associated requirements to specific change request/enhancements/defects and made sure that other teams were following the change requests guidelines.
- Provide case management services to ethnic diverse clients for governmental programs using mainframe and web base software applications which included explanation of laws, regulatory policies, member's rights and responsibilities associated with the receipt of benefits and services
- Performed risk analysis of moderate to high-risk individuals and entities to ensure compliance with BSA and USA Patriot Act. Maintained quality assurance and integrity of bank's "Know Your Client" program.
- Conducted informal sessions with development team to make sure that design and configuration meets business requirements.
- Analyzing data to identify patterns and compare transaction history against KYC standards
- Assured that all Artefacts and sign offs are in compliance with corporate Policies and guidelines.
Environment: MS- Project, MS-Visio, MS-Office, RUP, Clear Case, Rational suite, Windows and SQL
Confidential, Philadelphia, PA
Business Analyst
Responsibilities:
- Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
- Gathered requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
- Designed Web application site using HTML5 in User Interface solution
- Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
- Monitored questionable debit card and account activity looking at trends, patterns and velocities. Locating stolen and counterfeit card behaviour and ID theft. To reduce losses to bank customers and to the bank itself.
- Worked on project management software Microsoft Project to develop a work breakdown structure
- UsedTree Managerto set upSummary Ledgers, security, and Chatfield summarization rules, reporting hierarchies and rollup structure.
- Participated in designing and setup ofStatistical Accountsfor use in various reporting functions.
- Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Managed the successful delivery of over 15 custom IBM BPM solutions.
- Responsible for importing, cleaning, transforming, validating or modelling data with the purpose of understanding or making conclusions from the data for decision making purposes.
- Administered and supported reporting tools to provide reporting, ad-hoc query and dashboard solutions and capabilities to end users
- Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
- Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
- Conducted Asset Management, Risk Analysis of the Requirements and Traceability focus areas of the various projects and worked with the project team to help them identify the high-risk areas.
- Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Collaborated with business users and software development team within AGILE framework to ensure rapid and successful implementation of the solution
- Excellent skills in performing gap analysis, Feasibility analysis and BABOK and SWOT analysis to check the compatibility of the existing system infrastructure and server technology with new business requirements
- Utilized Agile SCRUM methodology to develop User Stories, Product Backlog, and Sprint Backlog.
- Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
- Developed project plans with team members to ensure Informatica solutions are executed and delivered as per the plans with good quality.
- Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
- Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
- Various versions of the documents generated during the project were maintained and managed using Rational Clearcase and performed defect tracking using Rational ClearQuest.
- Tested the final application for Usability testing to verify whether all the User Requirements were catered by the application.
- Provide guidance and coaching to the KYC Specialists to improve the quality output of the team based on findings in QC reviews
- Stay informed of current industry standards and regulatory expectations regarding Bank Secrecy Act & Anti-Money Laundering (AML)
Environment: Mainframes, JCL, Db2, Oracle, Siebel, Rose, MS Project, Salesforce, Peoplesoft Financial, Win Runner, PL/SQL
Confidential, Fairfax, VA
Business Analyst
Responsibilities:
- Elicited and gathered user and business requirements through open ended discussions, brainstorming and prototyping
- Designed, built, and maintained a data repository with reporting capability that enabled analysis and insight of user behaviours and interactions for Equity, Index, Options, and Bonds
- Gathered requirements from key stakeholders, customers, and subject matter experts to define the scope and requirements of Asset Management portals middle office needs
- Assisted in daily settlement operations of middle office in coordination with back office operations
- Gathered requirements for research data mappings for front office
- Analysed data integration strategies to customize simultaneous analysis of data from new and old environments
- Developed UML models for modelling static and dynamic aspects of Online Banking System
- Designed web solution using UI solution in HTML5
- Developed data maps for retrieval of information from existing account systems and outlined security measures for accessibility and transmission of information
- Interview, qualify for eligibility and provide case management for homeless and at risk for homelessness veterans to receive supportive services through the Supportive Services for Veterans Families Program.
- Worked on creating various ad-hoc reports using MS-Excel Worked on various Pivot tables to do the calculations and creating reports accordingly
- Designing and customizing data models for Data warehouse supporting data from multiple sources
- Performed Data analysis, data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
- Worked in collaboration Finance IT department to process accounting application, accounting modules, data and procedures using Finance Peoplesoft .
- Implemented and maintained Property & Casualty ( data integration, version release) systems of assigned customers
- Designed, configured, and testedACH and check payments.
- DesignedAP Voucher approval workflow.
- CreatednVision Balance Sheet reportsfor new Business Units. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
- Maintained Business Units and Accounts reporting tress usingTree Manager.
- Configured newAllocationsincludingInter-Unit Allocations.
- Applied a standard change control process in tracking defects originating from post-requirement phases
- Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures
- Analysed and optimized the process, prepared Business Requirements Document, and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite Pro
- Conducted JAD sessions for communicating with the all project directors and stakeholders and created process workflows, functional specifications and project initiation artefacts
- Created UML Diagrams including Use Cases diagrams, activity diagrams/state chart diagrams using Rational Rose and thus defining the Business Process Model and Data Process Model
- Monitored version control and defect tracking activities using Rational Clear Case and Rational Clear Quest
- Created and managed project templates, use case templates, requirement types, and traceability matrix in Requisite Pro
- Generated test cases in accordance to the Test Approach Document
- Screening and reviewing questionable financial activities and transactions
- Analyse activity and to maintain compliance with Anti Money Laundering policies
Environment: Windows, MS Office, .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner.