We provide IT Staff Augmentation Services!

Business Analyst Resume

Newark, NJ

SUMMARY:

  • Business Analyst with over 9 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.
  • Excellent knowledge of Software Development Life Cycle (SDLC) in Waterfall and Agile (Scrum) methodologies.
  • Strong experience in Requirements gathering techniques - conducting user interviews and JAD sessions.
  • Strong knowledge of insurance products like Property and Casualty, home insurance, Mortgage Insurance etc.
  • Experience configuring and managing Azure Active Directory (AAD)/AAD Connect
  • Experience in syncing objects, users, groups, from on-prem active directory to azure active directory.
  • 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.
  • Performed Data analysis, data migration by transferring them using SSIS packages.
  • 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 on to financial, technology, human capital and operational turnarounds, business process improvements (BPM), ERP evaluation and implementation services, audit preparation, risk assessment and organizational change management (OCM).
  • Holds strong domain experience across Digital Banking, Core Banking, Retail and Business Banking, Payments, Mortgages, Loan Life Cycle, ITIL, GRC and CRM.
  • 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 affecting time, scope and budget.
  • Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, KYC and AML.
  • Microsoft Dynamics CRM 2015, CRM 2013, CRM 2011, 4.0 Business Analyst, Technical Analyst, System Administrator, CRM UI Configuration Manager, and CRM Reports, View Workflows, Dialogs, SSRS design expertise.
  • 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, JIRA, Rally, Confluence, Quality Center, Analysis SDLC process

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

WORK EXPERIENCE:

Confidential, Newark, 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.
  • Run Backlog Grooming, Sprint Planning, Story pointing and Estimations, Daily Stand-ups, Sprint Retro among other Scrum Ceremonies.
  • Daily Scrum Calls to track development/knowing impediments if any
  • Worked with the LCR (Liquidity Coverage Ratio).
  • Coordinated with Finance & 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.
  • Maintain a current understanding and knowledge of AML, KYC, & Due Diligence policies and procedures.
  • 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.
  • Good understanding on Capital market such as Equities, Equity Derivatives Fixed Income - Corporate Bonds, Government Securities, Mortgage Backed Securities (MBS), Collateralized Mortgage Obligation (CMOs), Asset Backed Securities (ABS), Collateralized Debt Obligation (CDOs).
  • Subject Matter expertise in Investment Banking, Fixed Income, Trade Life Cycle, Mortgage Origination, Mortgage Service, Secondary Mortgage Market, Loan, Credit Cards, Insurance, and Portfolio Investment Analysis.
  • Strong understanding of Mortgage Backed Securities, Capital Markets, Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
  • Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages.
  • Developed and maintained relationships with assigned internal business partners including wealth and intuitional management, mortgage, and business banking markets
  • Conducted Mortgage relevant to off-shore teams so future releases are delivered defect free.
  • Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
  • 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.
  • Documented technical compatibility by gathering adequate requirements to mimic client's platform requirements for Atomize AML as a part of CDD/ECDD.
  • Daily assessment of AML and SWIFT reports for potential suspicious activity.
  • Prepare reports for AML Compliance Officer on a bi-weekly, monthly and quarterly basis
  • 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.
  • Established processes for GDPR cookie compliance with One Trust and internal auditing.
  • 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.
  • Lead Agile ceremonies as the Scrum Master for the External Interfaces team-daily stand-up, backlog grooming and refinement, sizing, sprint planning, review, and retrospective.
  • 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 principles 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 and Compliance 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:

  • Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
  • Prepared and analyzed 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 knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency) • Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
  • Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
  • Performed Implementation of Dynamics CRM 365 Online and CRM 2016 On-Premises in the organization.
  • Experienced in Data modeling, statistics, Data visualization, Business Intelligence, and predictive analytics that address use cases and business requirements converting data to insights.
  • Implemented Power BI Visualizations to Microsoft Dynamics 365 personal dashboards.
  • Conducted UAT to confirm that 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 that include Functional Technical System to create the runbook.
  • Understanding of AD (Active Directory) and AAD Sync
  • Manage Identity Access Management of Azure Subscriptions, Azure AD, Azure AD Application Proxy, Azure AD Connect, Azure AD Pass through Authentication.
  • Responsible for business system 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 (business sections only)
  • Extensive knowledge in Azure AD connect, Multi Factor Authentication (MFA), Active Directory Trusts, Dynamic Access Control, Office 365 best practices.
  • 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 that 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.
  • Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change.
  • Established processes for GDPR cookie compliance with One Trust and internal auditing.
  • Creation and management of the GDPR traceability matrix to ensure all articles are implemented
  • Analysis of current business procedure to ascertain GDPR gaps and means of bridging said gaps
  • Design of the current processes that relates to GDPR personal data definitions.
  • SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.

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.
  • Analyzing, reviewing, forecasting, and trending complex data analysis.
  • 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.
  • Captured business requirements and modeled As-Is and To-Be processes using MS Visio as BPM tool, performed gap analysis between goals and existing business processes.
  • Performed Analysis of the As-Is and Should-Be process within the organization to analyze business processes.
  • Prepared Business Process Models that 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.
  • Instrumental in defining ETL practice involving data extraction and data aggregation.
  • Used Microsoft CRM SDK for updating Custom Workflow Activities and Plugins.
  • Hands on experience in SharePoint and Outlook integration with Dynamics CRM.
  • Documentation of functional requirements and design of CRM based on business processes of the client organization.
  • Examined, analyzed 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 center and Billing enter, claim center Integrations and Configuration User Stories.
  • Created and execute test scenarios for PeopleSoft and HCM Cloud Fusion to find defects, escalate for resolution, and ensure releases are ready to move to production.
  • Research issues in PeopleSoft and other applications including testing, tracing, logging, and systems analysis. Liaise with developers and product owners to draft proposals to resolve system and process issues.
  • Assisted with gathering requirements for Peoplesoft portal application for personnel and financial accountabilities with role-based access to sensitive data.
  • Maintain awareness of regulatory controls and the confidentiality requirements of sensitive HR and other regulatory data elements of Peoplesoft HCM system.
  • Investigate data aggregation related issues by exploring data logs and the backend codebase, creating
  • Created and presented learning and change management (OCM) proposals that addressed business issues and supported corporate goals. Gained buy-in from senior leaders and decision-makers.
  • 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.
  • Enhance MS Dynamics CRM 2016 usability by designing and optimizing navigation, forms, and layouts.

Environment: UML, Use Case Analysis, MS Visio, Rational Rose, MS Word, MS Power Point, MS Excel

Confidential

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 implementing Guidewire PAS (Policy admin System)
  • Integrated the Claims and Policy data models in the data warehouse.
  • Works with clients in data modeling and building of data structures for our software.
  • Worked with user story to respond faster to reduce an overhead and rapidly changing real-world requirements in an agile environment.
  • Facilitate Daily Scrum Meetings, Release Planning, Sprint Planning, and Retrospective meetings
  • Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
  • Analyzed trading partner specifications and created EDI mapping guidelines.
  • Worked extensively on configuration of Guidewire Billing Center & Guidewire Policy Center.
  • Worked on Guidewire Claim Center Integrations & configuration User Stories.
  • Created Business Rules 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 help 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 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

Marketing 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 that the application meets the business requirements, resolve open issues, and change requests.
  • Led JRP sessions and JAD sessions with end user community ensuring that the software addressed all business needs and conducted Rapid Application Development sessions (RAD).
  • Implemented Partner portal on salesforce for Partners to better connect with different business users and suppliers, thereby increasing transparency.
  • SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.
  • Involved in CRM processes like Design, development, planning, testing and integration of Salesforce.
  • Daily salesforce usage to track, update and log project status throughout the project cycle.
  • Participated in the risk management work flow using BPMN models to visualize system design and business processes.
  • Good understanding of the AS-IS and TO-BE business processes (GAP analysis) and experience in converting these requirements into technical specifications for preparing test plans.
  • Worked on Gathering and documenting PCI regulations and requirements for credit card payments.
  • Involved in development and testing of POS Point of sale systems and applications for Payment Card Industry (PCI) Compliance initiative.
  • Performed source data profiling to verify that data meets the business requirements.
  • Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration, Metadata Management Services, Configuration Management, Creating UDFs and Pipeline Development.
  • Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
  • Facilitated Design/Development (technical design) review’s and ensured that 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 that impact project schedules and status information.
  • Maintaining data entry templates for reporting by analysis of current data-flow process.
  • Designing the integration of BI data to implement Order management & consumer systems with workflow and dataflow from various sources like GMF, DNB.
  • Wrote SQL queries to measure performance data, to gather data for testing, and to perform adhoc analysis.
  • 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 Co-Ordinator

Responsibilities:

  • Worked with end users to Map Business Processes (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 using Business Objects XI enterprise edition to streamline processes and procedure.
  • Responsible for POS installation in the metro-city area.
  • Worked with system Analysts to 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, business logics 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, Business Partners, and End Users.
  • Organized JAD sessions with Business stakeholders/SMEs for gathering requirements for the new upgraded platform: estimated project resources, timing, and sequence of deliverables.
  • Lead analysis planning and execution and authored business requirement, process diagrams (BPMN), and UI Designs for new web-based order management system.
  • Researched system architecture of proprietary PCPO (PC Purchase Order) and SSO (Store Specific Order) applications in the replenishment department, with the aim of converging the features of both applications onto a single .NET platform that could function on Windows 7.
  • Designing the integration of BI data to implement Order management & consumer systems with workflow and dataflow from various sources like GMF, DNB.
  • Accomplished logistics management featuring strategic planning in many Supply Chain Management programs.
  • Developed management reports to measure KPIs (Key Performance Indicators) and effectiveness of business processes within the customer's supply chain.
  • Responsible for end user and P&Ps and Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.

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.

Hire Now