We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Charlotte, NC

SUMMARY

  • Around 9 years of diverse experience working with various domains which includes Banking, Financial and Insurance
  • Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment.
  • Competent in analyzing the current business process and creating future state business process flows using industry standard BPM notations
  • Strong subject matter understanding in Risk assessment, Derivatives, Fixed Income Assets, Mutual Funds, Hedge Funds, Portfolio Analysis and Investment Banking.
  • Exceptional working experience in GAP analysis and understanding of the AS - IS and TO-BE business processes
  • Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.
  • Thorough knowledge of financial and investment management industry in diverse areas such as Risk management and analyses, Portfolio management, Fund accounting, Fixed income instruments, MBS, and amongst other major aspects of Investment Banking and Investment Management.
  • Experience with Mortgage loan servicing, Loan Origination, Student Loan Origination
  • Strong exposure in store and process credit card / Debit Card accounts and process transactions (Visa, MasterCard, American Express, private label transactions). Having strong domain knowledge in application catering to banking/Credit cards / mortgage business. Familiar with full life cycle of credit cards applications for different banking systems. Have strong knowledge in following phases of credit cards life cycle.
  • Adept with different software development methods like Water Fall, Rapid Application Development (RAD), Rational Unified Process (RUP) and Agile (SCRUM) Method
  • Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
  • Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the High-Level business requirements
  • Knowledge in Data Modeling and Process Modeling using a structured approach using MS Visio, Enterprise Architect.
  • Responsible for new and existing product development, marketing, and sales of all e-Commerce services (Foreign Exchange, Retail and Small Business Online Banking, Move Money, Corporate Commercial Treasury/Cash Management Online Banking, Mobile Banking, Consumer and Business Loans and International & Foreign Trade Services).
  • Extensive practical knowledge on business process flow related to Conventional Insured, Conventional Uninsured (Fixed, ARM, FHA), VA, NACA, Sub-Prime Lending, HELOC Piggyback, HELOC Refinance, HELOANS, LIBOR and State Specific Mortgage Home Loans etc.
  • Extensive experience in Capital Markets, Corporate Banking, Financial Asset Management, Insurance/Mortgage Markets and their Business Processes
  • Experience developing web-based applications screen mockups, wireframes, UI.
  • Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), High Level Design Document (HLD), Requirement Traceability Matrix (RTM) and testing documents.
  • Knowledge of Quality and Risk management concepts like risk management, mitigation and contingency planning.
  • Extensive experience in gathering business and application requirements, business processes, identifying risks, impact analysis, UML modeling, sequence and activity diagrams using Rational Rose and Microsoft Visio.
  • Expert in writing detail system use cases, developing business test cases, and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users
  • Working knowledge of Change management and Release management
  • Outstanding written and verbal skills with explicit attention to detail during requirements elicitation.
  • Involved in training of end users, documented Training Manuals for the new product release
  • Excellent Interpersonal, and Analytical skills, with ability to handle challenges under pressure with ease.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Testing Applications: Rational Test Manager, HP/Mercury QTP, HPQC

Suites: Microsoft SharePoint, MS Project, MS-Office (Word, Excel, Power Point, Outlook, Adobe Photoshop)

Requirement and Document Tools: Rational Requisite Pro, Rational Clear-Quest, DOORS

Business Modeling Tools: Rational Rose, Enterprise Architect, Visual Paradigm, Microsoft Visio

Databases: Oracle, DB2, UDB, SQL SERVER, MS ACCESS, Oracle Siebel

Methodologies: Agile, Waterfall, JAD UML, RUP, BPMN

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Business Systems Analyst

Responsibilities:

  • Facilitate the development and maintenance of specifications and test plans associated with system or application function, development, implementation, and/or modification
  • Lead the testing of new or modified systems or processes
  • Provide communications link between user, technical, and QA groups
  • Prepare reports and other documentation related to project assignments
  • Provide ongoing user support including troubleshooting and resolution of more complex system issues
  • Facilitate project planning activities associated with prioritized projects, including working with project support functional and project teams to define goals, objectives, scope, schedule estimates
  • Ensure issues are captured, monitored, and resolved
  • Provide daily support for the relevant functional/technical area within the SAP landscape (including 3rd party applications supported by EBS, integration points with complimentary systems, etc.) by recording/providing status on issues, troubleshooting/analysis of issues, identification and execution of possible solutions, testing of solutions, and monitoring of solutions in the production environment. Support should be proactive wherever possible
  • Provide technical assistance in training, mentoring and coaching business team members
  • Designs and perform quality assurance testing, perform unit testing and integration testing
  • Build a strong working relationship with both business units and external business partners
  • Provide daily maintenance support for the relevant functional/technical area within the SAP landscape by recording/providing status on requests, prioritizing tasks or working with management to clarify prioritization, executing maintenance activities, coordinating testing of maintenance activities, and coordinating the application of maintenance activities to the production environment
  • Analyzes Incident Tickets and performs root cause analysis to identify and prevent reoccurring problems
  • Assist in project planning and project scope sessions to ensure compliance with the project charter, implementation plan, and client agreements

Confidential - Minneapolis, MN

Sr. Business Analyst

Responsibilities:

  • Directed high-level requirements gathering sessions with Business Owners, Users, Departmental Heads, SME’s and end customers for elicitations by means of JAD sessions, Interviews, Surveys, Focused Groups, and Brainstorming Sessions.
  • Produced business cases, functional specifications, data validation mapping, SRS, BRD, FSD, non-functional specifications, use cases, RTM, mockup Screens and user stories for web and mobile application changes and enhancements.
  • Deep knowledge of the regulatory capital framework (Basel III, 5G, EPS, YY, IFRS, US GAAP) in liquidity ratios (LCR, NSFR), DFAST/CCAR stress-testing and FRB reporting (FR 2052a, FR Y14, FR Y-9C, FFIEC 031).
  • Led Value Stream mapping sessions enhancing capacity and data protection provisioning, diminishing the sum of time to benefit, and convey on quality data lined up with Information Risk Management practices.
  • Prepared GAP analysis and Risk analysis via Document Analysis and Interface Analysis to understand the new business model and additional functionalities to be incorporated in agreement with the online processing compliances.
  • Understanding the user requirements through conducting interviews, ethnographic research, creating audio/video recordings to capture consumer insights and convert them into innovation mobile applications.
  • Business Analyst in diverse domains in Capital Markets in areas such as Fixed Income, Equities, Risk, Over The Counter (OTC) Derivative
  • Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved.
  • Highly experienced record for delivering Banking & Finance Project for Retail & Commercial Banking- Mortgage Loan Origination, Digital Banking (Online Account opening Retail) & Risk & Regulatory (Liquidity coverage ratio, CCAR), Knowledge in Basel I, II, III with primarily Agile framework Implementation.
  • Worked on CCAR FR Y-14Q report for new FRB requirement like Disposition Loans, Disposed Scheduled Shift & Syndication Loan.
  • Worked with integration services for exchanging and assessing data from disparate sources like Excel, CSV, flat files, and Text Format Data and integrating them in to data marts. Implemented SQL queries to perform basic CRUD operations.
  • Integrated the various OLTP to the OLAP by using Informatica as an ETL tool.
  • Created a mapping artifact that maps every one of the fields in the HTML pages to XML labels, which are then mapped with the tables and section names in the database and associated with performing customer side approval on the new framework.
  • Comprehensive knowledge of Treasury processes, including liquidity risk management/monitoring and; knowledge of regulatory reporting standards and practices (IHC, CCAR).
  • Designed wealth management product by evaluating current needs of the market and competitive products
  • Expert Knowledge in the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Bank Secrecy Act (BSA), Office of Foreign Assets Control (OFAC) Guidance.
  • Conducted manual testing, automation testing, Smoke testing, Black Box testing, Regression testing and User Acceptance Testing (UAT) in conveying testing standards and created test cases, test scenarios and test plans using HP QC ALM.
  • Extensively interviewed traders and front office support to understand the trade booking of equity derivative in Fidessa and TOMS (Bloomberg). Documented and analyzed Converts, Structured products and Listed options trade booking model with front office.
  • Engaged in migration assessment of Trust and Custodial accounts from in-house to Broadridge Trust Platform
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Elicited requirements for complex, multi-faceted online banking application
  • Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
  • Exemplary knowledge and experience in the Financial Investment Banking industry with clear conceptual understanding of various financial instruments such as equities, bonds, fixed income securities and derivatives, and asset/portfolio management.
  • Performed additional tasks as assigned, improving the effective administration of the AML and KYC Policies.
  • Involved in defining the source to target data mappings, business rules and data definitions.
  • Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
  • Leading the requirements effort in implementing Black Knight Financial Group’s Mortgage Servicing Platform (MSP), as a replacement to Key’s legacy platforms that support Servicing and Default operations.
  • Worked with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in Regulatory Reporting regulatory reporting application Axiom.
  • Having good Knowledge of Web services, XML Data Mapping, Filed mapping for source to target systems, Data analysis, Data processing
  • Subject matter expertise in Fixed Income, Risk Analysis especially the Custody and Corporate action. Good understanding of Equity, Cash management, Capital market, SWIFT, STP and Credit risk, Derivative Securities fundamentals with hands on experience.
  • Involved in categorizing Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Origination, Loan Servicing, MBS, CMBS, Secondary Mortgage Market, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, and Inspection Report
  • Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds
  • Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved.
  • Drafted Requirements and Data mapping to deliver clean and confirmed trade transactions, cash flow and collateral data and capability to produce Federal reserve report 2052A.
  • Thorough understanding of Anti Money Laundering (AML) procedures and hands on experience of working to insure AML compliance at client’s place.
  • Translated high-level requirements into high-level user stories and epics over two sprints on TFS Team Foundation Server
  • Point person for the Security Incident Response Team (SIRT) for all security incidents
  • Experience in MS Office VBA development, Business Process improvements, SLA KPI and MIS Reporting.
  • Worked with SME on PLEXIS Quantum Choice to understand the Benefit Plans configuration and the Claims Adjudication process.
  • Hands on development of a series of World Valuation and Hedge Fund Performance Monitoring tools using MATLAB, Excel VBA and Microsoft BI Stack Technology.
  • Carried out detailed and comprehensive business analysis with the Agile methodology
  • Consultant for SCM supply chain management to identify GAPs in the current process and suggest for new change in process and system which suits their business needs
  • Supported and mediated implementation of the bank's digital products for retail line of business and Managed consumer digital banking platform Involved in migration and enhancements to the Online and Mobile Banking platform.
  • Worked with Subject Matter Expert for OTC derivatives, to analyse and develop requirements to meet client's needs.
  • Maintain ongoing knowledge of bank initiatives and procedural updates, AML, OFAC, SAR reporting and BSA regulatory standards.
  • Created numerous client sponsored research reports on the landscape for wealth management, trust industry, outsourcing, mutual funds industry, and private equity market.
  • Extensive experience of Web Services, SOAP and REST API Testing using UFT API, Restful API
  • Experienced in project management tools such as Plan view, MS project
  • Responsible for the automated conversion of the Advance Loan System to the AFS Commercial Loan Syste
  • Creating and upgrading payment processing procedures time to time for bank operations.
  • Developed Dashboards that provided reports related to transaction details, customers details, patterns recognized, social media details, customer account details with the use of various matrices utilizing Tableau.

Confidential - Dallas, TX

Sr. Business Analyst

Responsibilities:

  • Extensively involved in the deployment of Data Warehousing System.
  • Worked with the ETL development team in brainstorming sessions for understanding and developing the data transformation logics.
  • Conducted interviews with key Business Users for better understanding of the requirement and business process information.
  • Facilitated and managed JAD sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
  • Developed business process models in Agile (Scrum) to document existing and future business processes.
  • Developed Business Requirement Specification Documents as well as high-level project plan in collaboration with the other BA team members.
  • Used Power Designer comprehensively during the entire project to facilitate conceptual, physical, and logical data model but not limited to Use Case, Activity Diagrams, Requirement Traceability Matrix and instant report generation.
  • Wrote stored procedures and User Define Scalar Functions to be used in the SSIS packages and SQL scripts.
  • Played a key role in the planning, analyzing, testing and implementation of system enhancements and conversions.
  • Streamlined business process documentation for Capital Markets Analytics team that allowed for easier on-boarding of new associates.
  • Established and built the Equity Investment Risk Management team, as business owner of performance and risk analytical systems and reporting.
  • Experienced in integration of Salesforce.com with external applications by using Web ServicesAPI,Metadata API, WSDL, SOAP
  • Played key role as founding contributor in the development and building of Global Performance & Risk Management
  • Tasked with documenting the current state of resources that are targeted to be managed by the IAM program, business processes that relate to that resource usage, and key IAM capabilities that drive the approach to integrate the resource.
  • 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.
  • Held multiple positions within Identity & Access Management (IAM) team, some concurrent with each other
  • Lightning is a web-based processing for fixed income capital markets which automates a range of processes, including, trading, sales, funding, accounting, risk analysis and asset/liability management
  • Functioned as a primary liaison between the business line, operations and the technical areas throughout the project cycle.
  • Good domain knowledge and work experience in Banking, Investment Banking, and Hedge funds and trading.
  • Facilitate all Agile Ceremonies including Retrospectives, Daily Stand Ups, Story Grooming, Demo/Review and Sprint Planning
  • Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
  • Performed business analysis on enterprise operations in commercial leasing industry.
  • Maintained and kept track of stakeholder's requests for enhancements and changes using Rational Clear Quest. Used Microsoft Team Foundation Server TFS to manage the team's software development lifecycle
  • Worked with AML SME’s provided direction and guidance to employees on appropriate remediation action for high risk accounts.
  • Providing man hour estimates to the management team and create road map for the mobile application development based on market research
  • Performed extensive "Gap analysis" of the Wealth Management application to document existing business process flows and derive requirements for the proposed functionalities
  • Assisted solution architects to develop technology solutions for the wealth management application and asset classes including Equities, Commodities and Fixed Income instruments
  • Manage and implement strategic enhancements, ongoing maintenance, and future roadmap for various Digital Banking products.
  • Strengthen OTC derivative reporting process by highlighting reporting inconsistencies.
  • Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
  • Established company automation methodology, frameworks and tools
  • Worked heavily on SQL Server database to extract data and build Business reports.
  • Support agile team on the best way to refine backlog and create Healthy and Steady User Stories
  • Performed requirements analysis and using Rational Rose and Smart Draw created UML specifics such as data flow diagrams (DFDs), ER diagrams, Use cases, Class, Sequence, Collaboration and Deployment Diagrams.
  • Responsible for end to end support for state farm enterprise credit cards product: Visa, MasterCard, Amex and Discover.
  • All types of MIS Reporting Includes various SLA KPI, Client specific reports
  • Developed and managed the formal Agile Methodology which includes Requirements Management, Agile Manifesto, and Lean Development.
  • Proficient in using the following tools: Ms. Office 2013, HP Quality Center, Toad, SQL developer, Ms. Visio, Postman, JIRA
  • Used TSQL to develop Indexes, Primary Keys, Constraints, etc., to further develop tables
  • Work in a SAFe scaled Agile for a while as it was newly introduced to organization, represented my team at the scrum of scrum meetings
  • Setup Planview resource portfolios for the team, coordinated with project managers for team assignment and allocations and provided training to resources on using planview.
  • Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
  • Specialties in Equities, Fixed Income Securities, Mortgage-Backed Securities & Securitization, Forwards (Equity, bonds, interest rate, currency), Futures (interest rate, stock index, currency), listed and OTC Options (Stock options, bond options, Interest Rate options on LIBOR)
  • Implemented data staging for quality assurance and user acceptance testing (UAT).
  • Enabled our department to receive payments in a more time manner and reduce late payments received by customers.
  • Work closely with engineering, design, operations, finance, and marketing leaders to bring mobile app products to market and develop and grow business opportunities for the organization.
  • Led the User Acceptance Test before the go-live of the 2052a Reporting project.
  • Conducted sessions to gather mobile app requirements from different external vendors like FIS, Fiserv
  • Involved in categorizing Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Origination, Loan Servicing, MBS, CMBS, Secondary Mortgage Market, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, and Inspection Report
  • Performed data analysis on the existing data warehouse's of AFS, ACBS and infolease.
  • In - depth knowledge of and experience in the financial industry and global financial markets including product expertise (Equities, Swaps, Fixed Income, Money Markets, FX, futures & options and both OTC and exchange-traded derivatives products).
  • Worked with SME's to comprehend Risk Management concepts including Credit Risk, Market Risk and Operational Risk
  • Involved in requirements for interfaces for integration with multiple systems, defined how/what data would be passed in xml, how data mapping would be done for source to target systems integration, how source system would process the data from xml and map it on UI screens
  • Analyzed different source systems ( AMLN, LoanIQ, ACBS, Credit Cards - Target, Maestro, Shaw) and identified the reporting data elements required to report to Dodd Frank and Call Reports.
  • Created Gap Analysis document between OSI and AFS Commercial Loan systems.
  • Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
  • Complete understanding over Account Clearinghouse (ACH), DDA, MCA, UK Tax(S17), SWIFT message transactions (MT103, MT202Cov, MT940/950,IN101) and Dealer Management, Nostro movements, IHub
  • Maintained, debugged and optimized automation programs
  • Conducted User Acceptance Testing (UAT) and Post Production validations (PPV).

Confidential, Jersey City, NJ

Business Systems Analyst

Responsibilities:

  • Implemented standardized office automation system supporting corporate-wide accounting, personnel, manufacturing, and sales
  • Analyzed Loan files XML Schema. If necessary, created elements and attributes with consultation from Line of Business (LOB), for passing loan file information from one service to another.
  • Conducted walkthrough for Line of Business, Development team, and Quality Assurance team.
  • Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
  • Execute day to day migration activities for Risk and Credit systems with success
  • Analyzed system impacts as a result of proposed changes. It entailed interaction with other systems users and Subject Matter Experts (SMEs).
  • Provided quantitative analytical services to portfolio managers and senior leadership in areas including risk management & modeling, portfolio construction & optimization, asset allocations, and liquidity & hedging
  • Used Macros in Excel to create and update data.
  • Provided Capital Markets subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed
  • Gathered functional requirements, analyzed workflows and created narrative Use Cases to develop new process workflows for the Wealth Management
  • Manage and implement strategic enhancements, ongoing maintenance, and future roadmap for various Digital Banking products.
  • Designed data models and data architecture for web and mobile applications.
  • Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
  • Acted as a member in change management teams on derivative (OTC)/collateral management/margin calculation.
  • Analyzed the existing Wealth Management platform and provided recommendations to optimize the data flow
  • Assisted with developing policies and departmental procedures for payment posting and billing
  • Experienced in CCAR Regulatory Reporting and CCAR Stress Testing for Banking Balance Sheet Asset management.
  • Work with business on identifying the process changes required once moved to Broadridge platform
  • Always staying informed of emerging project management and Agile trends and best practices through contact with industry experts, peers, internal and external, and professional organizations
  • Educate and reinforce scrum methodology and agile framework to team members and key stakeholders.
  • Liaison with the business (Credit risk users and Finance controllers), the reporting team and the technology team for various reporting requirements for Data Quality
  • Introduced the Agile SCRUM process for the Risk Data team and utilized Microsoft Team Foundation Server TFS to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.
  • Worked on GAP Analysis, Test Plan document, Project Plan, Traceability Matrix, User Acceptance Testing (UAT), and SWOT analysis.
  • Performed business analysis on credit checking processes of the commercial leasing business.
  • Supporting reporting, analysis and business intelligence needs including developing SQL queries and using both Oracle and other (eg Cognos) reporting tools.
  • Very Good Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
  • Application of SDLC, Scrum and SAFE Agile Methodology.
  • Developed and managed the formal Software Development Life Cycle (SDLC) Methodology which includes Configuration Management, Requirements Management, UML Analysis and Design
  • Performing API regression using UFT for MT103, MT202 and MT202COV
  • Prepare and test data for international metric including Wholesale credit, Investments, oil, gas, Libor, credit cards and commercial information
  • Strong knowledge and understanding of GAMP5 and regulatory compliance issues
  • Proficient in creating User Acceptance Test (UAT) Plans and implementing and coordinating UAT.
  • Collected, reported, and refined agile metrics to quantify and communicate team performance
  • Attention primarily focused on capital markets and commercial lending in an effort to raise the bank’s domestic credit rating to meet regulatory compliance mandates.
  • Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
  • Wrote complex sequential SQL queries and to generate statistics, and developed Excel pivot tables to report the results.
  • Used Excel and Access VBA, modules and classes interfacing with SQL/TSQL scripts and standalone applications to design and improve process technology solutions and expedite the processing of reports
  • Experience on CCAR, Basel II, Basel III, Dodd - Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
  • Produced scheduled and on-demand risk management reports including building new reports and report delivery within defined time frames
  • Designed screen layouts for proposed solutions, user interactions. Also, created screen mock-ups.
  • Daily maintenance of credit risk application/credit batch; monitoring overage reports and breaches of counterparty credit limits, track bug fixes, Coordinate resources across various applications, operations or projects
  • Lead a project involving in pursuing funding proposals with a variety of commercial banks, investment banks and hedge funds.
  • Involved in working on interfaces, xml data mapping, web services, integration on multiple interfaces
  • Provided advice on AML and sanctions risks related to all Wholesale Banking clients in the America’s region subject to Enhanced Due Diligence (EDD) and Customer Due Diligence (CDD) policies including PEP and sanction affected entities at customer acceptance and periodic customer reviews.
  • Performed GAP analysis to identify source and target data and KYC information and documented them in Business rules
  • Performed data analysis and validation of AML/KYC data on eFront
  • Wrote and tested Excel macros that significantly reduced the amount of time needed to reconcile accounts from Credit systems to the General Ledger on a daily, monthly, and quarterly basis
  • Provided solution for database requirements by designing controls, data fields and data formats. Worked in legacy system migration from Lotus Notes to Oracle.
  • Experienced in OTC Collateral Operations and OTC Product Control with strong emphasis on Credit Derivatives, Interest Rate Derivatives, and Derivatives products.
  • Responsibilities included risk analysis for in house Loan Origination Mortgage System, Mortgage pooling investments
  • Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
  • Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Created master specification for web services- their functionality, interaction with other web services, processing logic, input & output schema, and process flow with Logical Data Element.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

  • Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, mortgage consultants, brokers, stakeholders and subject matter experts
  • Gathered requirements and conducted interviews with business users and Project Manager to understand the needs of the new application to be developed for Mortgage banking.
  • Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements
  • Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications
  • Served as a core member of the IT team to replace Confidential’ legacy Servicing Platform with Black Knight Financial Group’s MSP. Worked on remediation of critical end user apps linked to the legacy system.
  • Communicated with Line of Business and created Business Requirements Document (BRD), High Level Design Documents (HLD), and part of Low-Level Design Documents (LLD)
  • Conducted and participated in JRP/JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS) analyzed the feasibility of their needs by coordinating with the project manager and technical lead
  • Strong experience in conducting UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Strong experience of testing WEB services using Soap UI and Restful services using POSTMAN.
  • Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
  • Identified and documented risks and their impacts and provided recommendations to mitigate the risk.
  • Worked in Agile environment playing an active role in Iteration planning, Sprint Review, Lesson Learned and resolving roadblocks
  • Involved in Analysis of gathered requirements data, verification of requirements and creation of business requirement specifications (BRS). Extensive Knowledge of Loan IQ Data Model.
  • Worked as a part of Marketing Claims & Loan Origination process teams as a Business Analyst.
  • Syndicated Lending domain knowledge including Loan Origination, Loan Trading, Straight though Processing
  • Wealth management domain knowledge with understanding of all investment and lending products.
  • Developed process diagrams to elaborate on the flow of information between Web forms, Credit check system, Loan Origination System and Client application database
  • Helped conduct business risk analysis to identify the qualifying standards for mortgage applicants and ensure effective risk mitigation strategies
  • Formal coursework in Leasing, Lease Accounting, Audit and Confidential Compliance.
  • Used SharePoint and TFS to store documents. Also used TFS Team Foundation Server to manage requirements. In -depth knowledge of creating tasks on TFS and running queries using the Editor query tool.
  • Monitored accounts for omissions and errors and review charges to ensure proper accounting.
  • Communicated risks to Legal and Compliance department
  • Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
  • Reviewed and logged help desk tickets and determined avenues for improvements and enhancements
  • Helped develop Estimates of the proposed enhancements to system understanding and helped determine ROI
  • Coordinated multiple projects modules assigned to multiple teams in an Agile environment constantly tracking and configuring different versions, variants and managing changes to the software
  • Strong experience in credit on the condition that it shall be returned on payment of the debt within a certain period. Involved in (LOS) Loan origination System originating a loan vary by loan type, various kinds of loan risk and regulator, lender policy and other factors.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

  • A series of meetings / JAD sessions were conducted to gather requirements from business system users for reporting purposes.
  • Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
  • Facilitated four extensively used Star Schema methodology in building the design of the logical data model into the Dimensional data modeling.
  • Identified the grain, key dimensions and facts for the star and snowflake design and developed logical/physical data modeling.
  • Involved in design and development of standard and ad-hoc reporting using SQL.
  • Involved in data management for Credit Risk, Liquidity risk and Market Risk data warehouse and create business rules for risk management systems
  • Substantial amount of experience in regulatory compliance executed through a wide range of analysis, departmental audits and AML/fraud investigations. Trained extensively in the limiting and prevention of employer/client exposure to monetary, regulatory and reputational risks.
  • Led the User Acceptance Test before the go-live of the 2052a Reporting project.
  • Identify and document, business functions, activities and processes, data attribute and table meta-data, and general and detail design specifications.
  • Created walkthroughs and validations on logical model and created physical data model using forward engineering.
  • Analyzed accounting problems, recommend corrective action, and reconcile accounts.
  • Actively worked on Agile methodology, as Scrum Master
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
  • Created documentation and test cases, worked with users for new module enhancements and testing.
  • Focused on development of integrated data environment with minimal Data Redundancy.
  • Design, plan and program data conversion procedures from old to new databases.
  • Worked with Business Analyst to create hierarchies and design reports using OBIEE (Oracle Business Intelligence Enterprise Edition).
  • Coordinated bug fixing activities related to issues raised during end - User Acceptance Testing (UAT).

Hire Now