Business Analyst Resume
MinneapoliS
PROFESSIONAL SUMMARY:
- 8+ years of combined experience in Software Development Life Cycle and Business / System Analysis: experienced in gathering user requirements, documenting requirements, technical writing, business analysis, system analysis, testing, and implementation of projects.
- Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), SOX, CCAR Regulatory Reporting, Dodd-Frank Act, GAAP and IFRS.
- Excellent Financial Product knowledge in Equity, Fixed Income Structured securities, Derivatives: Futures, Forwards, Options, variable rate securities, and derivatives trading cycles, securities clearance and settlement process.
- Well versed with BI tools like Tableau, SPSS, SAP, SAS, Excel etc.
- Experienced in Private Equity, Securities and Derivatives trading, Hedge Funds and Fixed income instruments such as Bonds.
- Understanding of Portfolio analysis report and P&L reports by performing the risk analysis (Credit Risk, Market Risk, Reinvestment Risk and Inflation Risk) based on the client investment objective.
- Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
- Expert in designing and reviewing of various documents including Business requirements document (BRD), Functional requirements document (FRD), Use Case Specifications, Functional Specifications (FSD) and testing documents.
- Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, Activity, Class and Sequence diagrams.
- Excellent understanding of Database management system, Data warehouse concepts, Business Intelligence technologies and Data mining.
TECHNICAL SKILLS:
- MS Project, Word, Excel, Access, Visio, PowerPoint, Rational Rose, SharePoint, DOORS, HP QTP, SQL, XML,
- HTML, Team track, Rational Clear case, SVN, Oracle, SQL server, Windows, UNIX, SAS, SPSS
- Waterfall, Agile, RUP, Rally.
- Computer Skills: Proficient in software TaxACT; QuickBooks; SPSS; Proficient in Adobe Audition, Photoshop, and Premiere; experience in HTML and website development
- Excellent communication and teamwork skills
PROFESSIONAL EXPERIENCE:
Confidential, Minneapolis
Business Analyst
Responsibilities:
- Responsible for creating the user specification, detailing the functional and non-functional system requirements and Web Services necessary to interface with each service provider.
- Experience in working with SAS Enterprise Guide Software 4.1 5.1 versions for reporting and analytical tasks
- Performed business specification (BRD) and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
- Collaborated with the project manager and worked as a liaison between the Business partners and Tech partners. Interacted with the project owners to define project scope, risks and determined appropriate methodologies to apply based on Scope, and developed project time lines for on time delivery
- Contribute to project plan, worked with Tech Team to prepare the FRD, develop the user acceptance test plan (UATDS) and test conditions.
- Prepare the prototypes and mockups for the mainframe screens and financial reports using MS Word and MS Excel.
- Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, SAS/OLAP, SAS/EBI, SAS/Grid, SAS Visualizer, SAS/ETS and SPSS modeler
- Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc.
- Documented and tracked all product defects with use of SQL (reporting).
- Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
- Wrote SQL queries to retrieve data from databases after data migration.
- trading for implementing the derivatives trading application - a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting
- Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
- Organized weekly status meetings to monitor progress on production issues/test defects and send out meeting minutes to assign tasks to the team members to efficiently monitor progress.
- Performed detailed analysis and work - flow diagrams for derivatives trading which included - preparation of market & reference data, analysis & decision support, modeling a contract, preliminary instrument setup on the application
- Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data
- Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.
- Coordinated team mailbox to ensure timely completion of business requests and task assignment
Tools & Technologies: Agile Scrum, MS Visio, MS SQL Server, MS Suite (Excel, Word, PowerPoint, Project, Access, Outlook), JIRA, Visual Studio, UML, HP Quality Center, Oracle ERP, SAS, SPSS
Confidential, New York, NY
Business Analyst
Responsibilities:
- Conducts reviews of client documentation/information obtained by client contacts within the business units
- Ensures that information obtained is consistent with BSA/AML Policy and Procedures and satisfies regulatory requirements
- Assisted in building a business analysis process model using Rational Rose and Visio
- Conducted JAD sessions for communicating with Stakeholders and SMEs
- Assist in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements
- Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications
- Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
- Create scoring and recovery models for mortgage business and home loans using SPSS modeler.
- Managed all the requirements in RequisitePro, making requirements available to all team members
- Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process
- Studied the existing KYP/CIP system and prepared the test data for the CDD and EDD based on the inputs
- Tested the application manually by executing Test Cases in Quality Centre prior to Automation and Involved in automated testing and Performance testing using QTP and Load Runner
- Develop User Acceptance Testing and specifications with guidance from AML Compliances
- Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
- Monitored client expectations and conducted user interviews
- Prepared the report publishing frequencies and the media in which it shall be published(SharePoint), also prepared the document for filing frequency and filing format of the SARs, CTRs to the regulatory agencies and internal systems
Tools & Technologies: MS SQL Server, MS Suite (Excel, Word, PowerPoint, Project, Access, Outlook), Rational Rose, Visio, Waterfall, UML, HP Quality Center, Oracle, Rational Requisite Pro, JIRA, Nice Actimize, SAS, SPSS
Confidential, Richmond, VA
Sr. Business Analyst
Responsibilities:
- Worked with Trading Table, Financial Analysis Team and Portfolio Management Team to understand the business requirements needed to incorporate the features they wanted working in the system.
- Gathered user and business/regulatory requirements through interviews, surveys, and observing from portfolio managers and UI (User Interface).
- Worked with the different business units (Investment Banking, Accounting, Fixed Income, Equities, Foreign Exchange, Clearing & Execution) within the bank to understand the current business flow.
- Facilitated Joint Application Development (JAD) sessions to resolve urgent issue relating to requirement that were scheduled for the next release.
- Used Rally to assign issues to users, manage sprint planning, and track project status for teams whose stories would affect the project..
- Extracted data from the database using SAS/Access, SAS/SQL procedures to create datasets.
- Facilitated all aspects of the scrum framework, including sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives
- Provided support to product owner in developing, maintaining and grooming product backlog.
- Involved in maintaining the capacity plan, iteration board, sprint backlog, velocity charts and burn down charts.
- Worked with Financial Analysts on Fixed Income Analysis (Pricing, Risk, Yield and Duration) with Excel to support trading, and review with portfolio manager and traders.
- Designed Trade-Break, Aggregate report formats and evaluating Cognos as a strategic reporting tool.
- Worked with business users to prepare and update the Business Requirement Documents (BRD), User Stories and Business process flow documents.
- Used UML to create Use Case diagrams for requirements.
- Scheduled meetings with developers, SAs (System Analyst) and testers to collaborate resource allocation and project completion using MS Project.
- Facilitated and completed data mapping for the segments to facilitate the conversion of client assets.
- Worked with MS SQL to extract data understood data schemas and relational data tables in data warehouse.
- Conducted UAT and Coordinated with the QA Team in the sign-off process before deployment.
- Assisted the Project Manager in creating the User Manual Documentation.
Tools & Technologies: Agile Scrum, MS Visio, MS SQL Server, MS Suite (Excel, Word, PowerPoint, Project, Access, Outlook), JIRA, UML, HP Quality Center, Oracle, S&P Capital IQ, Morning Star, Bloomberg Terminal, FACTSET,SAS
Confidential, Albany, NY
Sr. Project manager/ Functional Analyst
Responsibilities:
- I was involved in requirements gathering, development and testing. Attended client meetings for gathering users’ needs and perspectives.
- Led an important thread in the project as a Subject Matter Expert.
- Provided knowledge transfer to the development and testing teams with regards to the functionalities of the application.
- Prepared System Functionality and other related documents for the benefit of the client and the other stakeholders.
- Helped the development team in triaging the bugs with the testing teams.
- Assisted with UAT such as in writing and reviewing test cases, and in conducting user testing.
- Helped Testing team in designing and executing test plans, tracking defects and getting them resolved to ensure that business requirements and functional specifications are tested and fulfilled.
- Worked as an effective liaison between different teams, and enabled a sound partnership between all teams.
Tools & Technology: Waterfall-Scrum, MS Office, MS Visio, MS SQL, Enterprise Architect, MTM, TFS
Confidential
Business/Financial Analyst
Responsibilities:
- Skip Tracing, Title Abstracting & locating various property owners.
- Organized bank statements, accounting data entries, A/P, A/R, payroll, and bank reconciliation with QuickBooks.
- Created the detailed requirements documentation for setting the structure of the statements.
- Prepared monthly reconciliations, including preparation of monthly A/R sub-ledger by customer, and monthly A/R to aging reconciliation.
- Forecasts and Budgets - set-up reporting formats, including links to sub-schedules; input submissions from Operating Departments; prepare variance analyses to prior Forecast/Budget.
- Assisted with year-end audit, including the preparation of schedules required by auditors.
- Performed analytical functions of actual vs. budget and forecast and resolve all issues with various department representatives.
- Key payroll related data based off of their payroll frequency as well as add new hire information from HR department.
- Maintained monthly cash flow management and reporting activities.
- Analyzed business performance to maximize operations.
- Assisted with SOX recordkeeping, support SOX controls testing.
- Planning, updating and maintaining the project plans/charters and project progress reports.
- Managed multiple project and tracked various activities associated to the same.
Confidential
Project Co-coordinator/ Process Specialist
Responsibilities:
- Software Marketing (Product Life Cycle Management)
- Real Estate Research & Title Document Assessment of Various Properties
- Development of contact list for clients as per their requirement.
- Worked on Pre-Qualification process.
- Handled the database development as well as database validation projects.
- Distributed the list sent by the clients to the agents.
- Ensured that the weekly targets are met.
- Prepared the weekly reports for the projects.
- Interacted with the client and solve the queries related to projects.
- Ensured that the projects are completed in given time line.