Business Analyst Resume
NJ
SUMMARY
- Business Analyst with over 8 years of experience in Banking, Mortgage, and Financial industries.
- Retail Banking, Investment Banking, Mortgage, MBS, Credit cards.
- Experience in Mortgage Market, Debt Securities
- Extensive experience in documenting Business Requirements Documents (BRD) and Functional Requirements Documents (FRD).
- Expertise in UML business modeling tools.
- Strong Subject Matter expertise in Credit Card Industry, Retail/Investment Banking, Risk Analysis, Mortgage Loan Origination and Loan Servicing.
- Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis and ROI analysis
- Strong background in business analysis, quality assurance, testing, documentation, client relations, office administration, HRIS, payroll, benefits, accounting, A/R, A/P, and auditing.
- Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.
- Knowledge in Investment Banking industry with clear conceptual understanding of various investment domains such as Equity markets (Stocks trading life cycle, futures, Funds (Fixed Income, Mutual Funds, Hedge Funds), money market instruments/Securities.
- Solid background in Software Development Life Cycle methodologies such as the Traditional Waterfall Model as well as iterative approach to software development.
- Strong experience in Requirements gathering techniques - conducting user interviews and JAD sessions.
- Strong noledge of insurance products like Property and Casualty, home insurance, Mortgage Insurance etc.
- Hands on experience in SAS TOOLS using (SAS/Base, SAS/SQL, SAS/Macros, SAS/ODS, SAS/STAT, SAS Enterprise Miner, SAS Enterprise Guide)
- Assisted teams in creating different SSIS and SSAS packages in different Control Flow and Data Flows.
- Extensive experience in writing SQL queries with data bases like SQL Server, Oracle
- Extensive experience with Microsoft business modeling tool Microsoft Visio for process mapping.
- Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision
- Experience in performing Feasibility analysis, Risk analysis and Gap analysis.
- Experience with creating Traceability matrix for tracking the requirements with the test cases.
- Extensive experience with process modeling using UML, flow charts, task diagrams, sequence, activity Diagrams and Use Cases
- Strongly possess Project management skills, keeping in mind keeping in mind the objectives of the project and constraints effecting time, scope and budget.
- Strong work ethics, taking ownership of all duties and responsibilities and efficient time management skills. Group and individual based problem solving and decision making.
TECHNICAL SKILLS
Methodologies: Unified Modeling Language (UML), Rational Unified Process (RUP), Agile Methodology, Waterfall Methodology
Tools: Rational Rose, MS Visio, Requisite Pro, MS Project, SharePoint; I-Rise, Lotus Notes, MS Word, Power Point, Excel, Project, Outlook
Quality Management: Mercury Test Director, Win Runner
Operating Systems: Windows XP/2000/NT/98/95/ Vista
Languages: SQL, HTML, UML
Multimedia: Adobe Photoshop
ERP Software: SAP R/3. Oracle, Siebel, People Soft
PROFESSIONAL EXPERIENCE
Confidential, NJ
Business Analyst
Responsibilities:
- Implemented of recommendations from Basel Committee on banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II.
- Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues and deliverables of project.
- Worked with theLCR(Liquidity Coverage Ratio).
- Coordinated withFinance& Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) designed to enhance production efficiencies while decreasing operational risk by using automated reporting application AXIOM SL.
- Executed day-to-day phases of the audits as the in-charge auditor for both publicly traded and private clients, including audit planning, risk assessments, audit substantive testing, and financial statement in both US GAP and IFRS.
- Worked with the ERP tool and creates the test cases, test scripts and perform user acceptance testing.
- Provided coverage for AML compliance monitoring, CIP, KYC and OFAC.
- Assisted the Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, and Risk Identification.
- Worked with Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, delivers, and track testing progress.
- Organized JAD sessions in Agile SDLC environment with project managers, stakeholders and SMEs in business risk management to develop and recommend a trajectory plan for the introduction of derivatives.
- Worked closely with the FP& A team on Dodd-Frank/CCAR FR Y 9C-5G- 2052A/B-14M/Q - Stress Test Model Validation. Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk.
- Project requirements for cash management practices adhered to accounting principals or GAP and IFRS.
- Used SAS and SQL to retrieve, validate and manipulate data.
- Used SAS/ETL to create reports from relational database or multi-dimensional cubes.
- Provided trade support to the Fixed Income trading desks for various products including Interest Rate Swaps, Credit Default Swaps, Treasury Trades, and other Money Market products and OTC Derivatives.
- Worked as a liaison between developers and QA team in creating Test Plan and Test Cases using Rational Test Manager.
- Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
Environment: Risk andCompliance Counterparty Risk, Operational Risk, Credit Risk, EMIR, BASEL, DODD-FRANK, SOX, Bank Secrecy Act, Visual Basic, MS Project, SQL, SQL Server, Oracle, Project Management
Confidential, New York, NY
Business Systems Analyst
Responsibilities:
- Analysed User Requirement Document,BusinessRequirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis.
- Strong Knowledge on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
- Acquired extensive noledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency) • Conductedmarketresearch and analysis inCapitalMarkets consisting of StockMarketand BondMarket
- Prepared for GAP Analysis; identified and documented improving areas to meetcapitalrequirement regulations.
- Conducted UAT to confirm dat all derivative products can successfully process during the trade life cycle.
- Used the guidelines and artefacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
- Execution of Runbook and gathering various requirements dat include Functional Technical System to create the runbook.
- Responsible forbusinesssystem analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
- Developed multiple Functional Requirements definition (FRD) documents using the Microsoft standard structure and format (businesssections only)
- Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
- Experienced in API Integration and Single Sign On (SSO) into a Service Oriented Architecture (SOA), web orchestrating service applications through the SSO services.
- Prepared Logical Data Models dat contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, Visual Basic, MS Project, SQL, SQL Server, Oracle, WebLogic, IPFR MS Visio, Services, DreamWeaver, Adobe Photoshop, Windows Forms, Web Forms, LoadRunner, WinRunner, DOORS, Project Management.
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Experience with Software development life cycle (SDLC) methodology, framing out Business Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules.
- Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering and prepared User Requirement Specifications document.
- Worked in Property & Causality (P&C)- Commercial lines & Homeowners insurance.
- Strong experience on various P&C insurance modules including Claim Management, Bill Management, Policy Management, Payments, Claim Offline Tool and Medicare Claim Reporting Tool.
- Involved in the analysis of business requirements and system requirements of the client and for Property and casualty (P&C) modules.
- Performed Analysis of the As-Is and Should-Be process within the organization to analyze business processes.
- Prepared Business Process Models dat includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, levelled technique for building Business Process Models.
- Examined, analysed and modelled Test plans & Test procedures based on RUP methodology.
- Performed analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
- Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
- Involved in walkthroughs and meetings with development team to discuss related issues.
- Used Rational Rose to visually determine the proper structure, key elements and optimal design for the database and to aid efficient creation of tables and storing procedures.
- Experience in Guidewire Claim enters, Policy c 3475904335 enter and Billing enter, claim center Integrations and Configuration User Stories.
- Coordinated with the development team in documenting End User Manual.
- Conducted as a defect-tracking tool to report application defects and enhancements request and discussed with developers to resolve technical issues.
Environment: UML, Use Case Analysis, MS Visio, Rational Rose, MS Word, MS Power Point, MS Excel
Confidential, Bethel, CT
Business System Analyst
Responsibilities:
- Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
- Experience in Commercial and Personal Lines of insurance (Workers Compensation, Property, General Liability, Business Owners, Auto and Home) in implementingGuidewire PAS (Policy admin System)
- Worked with user story to respond faster to reduce an overhead and rapidly changing real-world requirements in an agile environment.
- Analyzed trading partner specifications and created EDI mapping guidelines.
- Worked extensively on configuration ofGuidewireBilling Center &GuidewirePolicy Center.
- Worked onGuidewireClaim Center Integrations & configuration User Stories.
- CreatedBusinessRules Document and Requirement Traceability Matrix to track the requirements for PEGA PRPC relationships
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Supported the data governance team in conducting moderately complex data analysis to halp drive data quality improvement initiatives.
- Examined, analyzed and model Test plans, Use Case Model cases and Test procedures based agile methodology.
- Reviewed Stored Procedures for reports and generated test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
- Knowledge in using SAS/ACCESS to Export, Transfer and Load (ETL) data from ERP packages.
- Use of SAS System options and Procedure Options in order to reduce the processing time for large data.
- Helped with Data Mapping between the data mart and the Source Systems.
Environment: SQL Server, Guidewire, Windows, HL7 v2.X, Crystal Reports, Oracle, Mantis Defect Tracking, UML, MS Office, MS Visio.
Confidential, Yonkers, NY
Business Analyst
Responsibilities:
- Responsible for identifying and documenting business rules and creating detailed Use Case’s.
- Created Use cases, Use Case diagrams, Business Flow diagram, Navigational Flow diagrams, Creating process models, data flow diagrams, AS IS diagrams and Activity diagrams using Visio.
- Conducted many informal Sessions to develop an architectural solution dat the application meets the business requirements, resolve open issues, and change requests.
- Led JRP sessions and JAD sessions with end user community ensuring dat the software addressed all business needs and also conducted Rapid Application Development sessions (RAD).
- Participated in the risk management work flow using BPMN models to visualize system design and business processes
- Performed source data profiling to verify dat data meets the business requirements.
- Facilitated Design/Development (technical design) review’s and ensured dat business requirements are met.
- Regularly scheduled meetings to review the project status/plan with senior technology staff.
- Responsible for creating a report on a weekly basis, listing committed dates, risks dat impact project schedules and status information.
- Worked closely with the project managers to monitor progress, and the deliverables for the project
- Developed system integration test plan and ensured customer acceptance / satisfaction.
Environment: MS Excel, MS Visio, DB2, MS Access, SQL Server, Windows XP, MS Outlook, Test Director.
Confidential
Business Systems Analyst/Financial Analyst
Responsibilities:
- Worked with end users to MapBusinessProcesses (BPM) to technical specification.
- Created daily, weekly and summary reporting and performance insights for the following programs: even performance for tab, including Advertised vs. non-advertised sales, Power Hours, Early Birds, BOGO and like-themed events.
- Generated dashboards, metrics, analytics, goals, alerts usingBusinessObjects XI enterprise edition to streamline processes and procedure.
- Responsible for POS installation in the metro-city area.
- Worked with systemAnalyststo create application's Functional and Non- Functional requirement document.
- Developed USE Cases for the application and prepared the detailed Workflow Diagram based on the proposed enhancements,businesslogics and rules and translated them to Use Cases for Live Archive.
- Devised extensive E-mail marketing campaigns regularly & kept a track of positive as well as negative feedback for improvisation.
- Collected Requirements Interviewing Stakeholders,BusinessPartners, and End Users.
- Organized JAD sessions withBusinessstakeholders/SMEs for gathering requirements for the new upgraded platform: estimated project resources, timing, and sequence of deliverables.
Environment: MS- Project, Visio, Word, Access, Power Point, Excel, SharePoint, Office 365, Quick Base, Jira, Confluence Wiki, Outlook, Quality Center, MS Access, Oracle, SQL Server, Windows, Server.
