Sr. Business Systems Analyst Resume
Johnston, RI
PROFESSIONAL SUMMARY:
- Goal - oriented Sr. Business Systems Analyst with 8+ years of experience in providing meaningful technology solutions within the Mortgage, Finance and Banking domain.
- Proficient in building relationships and optimizing operations. Sound mastery in business requirement elicitation & analysis, business intelligence and liaising among business and technical stakeholders.
- Well-versed with Software Development Lifecycle (SDLC) methodologies ranging from conventional Waterfall, Waterfall-Agile to present day Agile frameworks like Scrum, Kanban along with extensive knowledge and talents in Scaled Agile Framework (SAFe), Scrumban, Extreme Programming (XP), Spiral and Rational Unified Process (RUP).
- Well-versed with the Mortgage Loan Origination Systems (LOS), Loan Servicing, Loan Default Servicing and Delinquencies, Capital, Primary and Secondary Markets, Collateralized Mortgage Obligation (CMO), Equity, Private Mortgage Insurance (PMI), Mortgage-Backed Securities (MBS), Debt-to-Income ratios.
- Well-acquainted with loan modification programs prescribed by the Freddie Mac, Fannie Mae, U.S Veterans Administration and Federal Housing Administration.
- Fair knowledge of various Mortgage regulatory compliances along with Integral laws such as Homeowners Protection Act (HPA), Home Ownership and Equity Protection Act (HOEPA), Real Estate Settlement Procedures Act (RESPA), Truth in Lending Act (TILA), Equal Credit Opportunity Act (ECOA), Home Mortgage Disclosure Act (HMDA), Gramm-Leach Bliley Act (GLBA) and Credit Privacy laws such as the Fair Credit reporting Act (FCRA) and their effects on the whole loan system.
- Reasonable knowledge of Banking and Finance sector’s acts relating to the accounting errors and the fraudulent practices like Sarbanes-Oxley Act (SOX), Bank Secrecy Act, Bank Holding Company Act, Bank Regulations Act and Dodd-Frank Act.
- Functionally engaged with Project Management deliverables like Project Plan, Project Scope Statement, Project Charter, Work Breakdown Structure (WBS), Critical Path Analysis and the Earned Value Management (EVM) and Risk Register.
- Experienced operating with various SDLC environments such as Agile Scrum, Waterfall and Water-Scrum Hybrid.
- Profoundly capable in capturing requirements from business partners through elicitation techniques such as JAD sessions, Workshops, Brainstorming, Interviews, Prototyping and Document Analysis.
- Experienced with Project Collaboration tools like JIRA and HP-ALM to manage User stories and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Daily Scrum, Sprint Retrospective.
- Proficiency in documenting artifacts by gathering requirements such as Business Requirements Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS), Use Case Document (USD), Requirement Traceability Matrix (RTM), Change Request Document.
- Periodically assisted product owner and scrum teams in prioritizing and estimating user stories using techniques like MoSCoW, KANO, Planning Poker, Delphi, Relative Mass Valuation and T Shirt Sizing helping deliver critical release functionalities and maximizing business value during different phases of the project lifecycle.
- Designed both static and dynamic Unified Modelling diagrams (UML) such as Use Case Diagram, Activity Diagram, Sequence Diagram using MS Visio and Lucid Charts.
- Designed Low Fidelity and High-Fidelity Mock-ups and wireframes using Balsamiq to assist UI/UX team.
- Conducted detailed project analyses of Business Processes by GAP analysis (AS-IS & TO-BE), Risk analysis, SWOT Analysis, Impact assessment, Cause and effect analysis (Root cause analysis), Effort estimation, Cost-Benefit analysis, & Feasibility Analysis.
- Strong functional knowledge of various AWS modules for cloud computing including AWS Lambda, AWS EC2, AWS S3, Amazon API Gateway, Amazon Kinesis Firehose and Amazon Dynamo DB.
- Experience in Micro services and Service Oriented Architecture (SOA) with experience working with web services
- Proficient in various structured data types used by RESTful web services for API calls like JSON, XML,HTML, CSS.
- Experience in creating conceptual and logical data models, documenting migration plans, Data Mapping specification document and Data profiling to clean and convert source data to target format.
- Excellent insights of data warehousing, data profiling, data migration, ETL and data visualization processes with hands on experience in Informatica PowerCenter.
- Operated basic SQL commands such as SELECT, INSERT, UPDATE, ALIAS, JOINS and PROCEDURES .
- Prepared data visualization reports using Tableau through connecting csv, excel and database files showcasing the business insights and progress reports using Histograms, Heat Maps, Symbol Maps, Pie Charts etc.
- Created and maintained test plans, test cases, test scenarios, test scripts and maintained test data using HP ALM QC as well as Microsoft Excel to ensure complete test coverage.
- Facilitated automated functional, performance, black box, integration, regression & smoke tests to ensure quality.
- Facilitated multiple UA testing, gathered users, catalogued tests and reviews to ensure a satisfactory application.
SKILLS AND TOOLS:
Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis.
Project Management Tools: MS Office, MS Project (2013,2016), MS SharePoint (2013), Confluence (v 6.3, 6.2), JIRA (v.6.3,7.0), HP ALM (v.11.5), HP-QC (v.11,12), Confluence (v.6.4, 6.3, 6.2), Microsoft Teams
Waterfall, AgileScrum, Water: Scrum Fall Hybrid, SAFe, Kanban, XP, Rational Unified Process (RUP)
Modeling Tools: MS Visio (v.14, 15, 16), Lucid Chart, Balsamiq
API Tools: Swagger, Postman
ETL Tools: Informatica Power Center
Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up.
MYSQL, Microsoft SQL T: SQL, AWS Dynamo DB, Amazon Aurora, Amazon Redshift
Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner (v. 11.5, 12.02), Cucumber
Reporting tools: Tableau (v. 9.3, 10.0, 10.1), IBM Cognos, MS Excel (2010, 2013, 2016)
PROFESSIONAL EXPERIENCE:
Confidential, Johnston, RI
Sr. Business Systems Analyst
Responsibilities:
- Organized JAD sessions and workshops, prepared agenda and facilitated the meetings with the SMEs, product owner & stakeholders to elicit requirements, document outcomes, and capture Minutes of Meetings (MOMs).
- As-is Process walkthrough to understand and document the current loan modification and loss mitigation process.
- Studied the Freddie Mac, Fannie Mae, US Veterans Administration, FHA, USDA guidelines relating to loan modification rules and eligibilities along with the development and compliance team to ensure solution stayed compliant to regulations.
- Designed use cases and UML diagrams using MS Visio and built Wireframes and Mockups using Balsamiq to confirm with end users if solution met the needs.
- Maintained a Risk Management Plan and assigned Mitigation Procedures to specific stakeholders since the guidelines prescribed by Investors and Guarantors of Government Sponsored Enterprises (GSEs) were prone to periodic change.
- A cost-benefit analysis between AWS EC2, AWS Lambda and Apache Spark as a decision engine to run code on towards the application architecture was performed.
- Maintained APIs between the internet and virtual cloud using Amazon API Gateway to allow for a well-ordered communication between the application and external devices (browser, phone, tablets).
- Established junction objects to maintain many-many relationships and defined lookup and master-detail relationships for the various loan workout rules to in corporate business logic and compliance into the application.
- Extensively used Project Collaboration tools like JIRA and HP-ALM to capture and manage User stories and actively participated in Scrum Ceremonies while assisting in prioritizing features using Moscow model.
- Assisted the Product owner in writing the Acceptance Criteria in Gherkin format using Cucumber to make the user stories ready for execution.
- Detailed authorized system users and permissions for the enhancement in the AWS Identity and Access Management console based on Workflow and Business Rules.
- Assisted testers in clarifying requirements during unit testing. Performed functional, regression and smoke testing to ensure integrations did not cause abnormal behavior to the existing application.
- Monitored bugs and defects and prioritized them on the product backlog according to their severity.
- Facilitated UAT sessions by providing information regarding system behavior and preparing Training Manuals regarding functionality of the new system.
- Gathered requirements regarding the structure and contents of the exportable Loan Workout Report that would be provided to the delinquent borrower.
Environment: Agile (Scrum), JIRA (7.0), SharePoint (2013), Balsamiq, MS Visio(v16), MySQL (Amazon Aurora), AWS S3, AWS Lambda, Kinesis Firehose, Amazon Redshift, RESTful
Confidential, Phoenix, AZ
Sr. Business Systems Analyst
Responsibilities:
- Facilitated communication between the technical and non-technical teams by conducting Brainstorming and JAD sessions to understand end user requirements.
- Assisted PO in coming up with MRFs which spanned across three releases.
- Source system exploration was performed where data was consolidated from different sources after adequate data cleansing and validations to maintain Data Integrity.
- Performed GAP analysis to identify redundant source fields, additional target fields and transformation logics.
- Formulated data migration approach through assisting DB architects in modelling Bus Architecture, designing Snowflake Schema and preparing ER Diagrams to comprehend targeted data warehouse.
- Prepared Data Mapping Specification document where mapping between the source and target data was done including necessary transformation logics.
- Defined the Landing Tables, Staging Tables and configured the base objects, foreign-key relationships, custom Cleanse Functions, match and merge settings, lookups & queries according to the business logic and requirements.
- Assisted scrum team in Hybrid Slicing (Vertical and Horizontal) of user stories. Slicing performed was based on Datatypes and Parameters as well as Workflow and Business Rules.
- Assisted in data integration by using the different transformations like joiner, filter, expression, sort, aggregator and look up in the Informatica Power Center along with creating Mapplets.
- Assisted in performing Data Normalization process to eliminate data redundancy and faster query processing
- Validated data integrity and quality through exhaustive assistance in extensive of OLAP cube based on required OLAP queries performing various operations such as drill down, roll up, slice, dice and pivot.
- Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, schema exports- imports using metadata manager and conducting data team workshops helped in documentation & reporting
- Generated various dashboards and ad-hoc reports using Tableau promoting business insights and trend analysis.
Environment: Agile-Scrum, Informatica PowerCenter, MS Excel(2016), Tableau(10.0), SQL, Oracle DB, HP ALM(v11.5), MS Outlook(2016), MS PowerPoint(2016), GitHub
Confidential, Columbus, OH
Business Systems Analyst
Responsibilities:
- Actively involved in prior documentation and business process for understanding the Scope. Developed knowledge of Anti Money Laundering and Trade Surveillance.
- Conducted GAP analysis for AS-IS and TO-BE of the process to identify and validate requirements.
- Facilitated Joint Application Development (JAD), Brainstorming Session involving business unit stakeholders, technical analyst, SME, portfolio managers, and financial analyst to gather requirements and have better understanding of the business process
- Worked with Case Management, Actimize. Trade Surveillance and ad-hoc filtering tools to assure compliance.
- Assisted in Transaction monitoring, watch list filtering, Detection engine, KYC module, AML system implementation and Risk based filtering.
- Designed UI components, screen mock-ups, process flows, business logic, configuration requirements, Requirements traceability matrix, and technical diagram
- Created the UML for structuring the whole project. Identified Use Cases and develop the Use Case diagram, Activity Diagrams and Sequence diagram.
- Used Jira for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
- Defined Acceptance Criteria for User Stories to perform User Acceptance Testing.
- Designed Test Cases, Test Plans and Test Scenarios to perform UAT, System Testing and Regression Testing, logged down defects and systematically managed them in HP-ALM
- Manually executed Test Plans and Test Cases to verify actual result against the expected results.
- Regularly submitted defect reports and conducted meetings to communicate with the development team about the defects.
- Reviewed systematic Anti Money Laundering (AML) alerts and determined if transactions occurring are valid Anti Money Laundering risks.
- Supported UAT Coordinator/UAT Test Lead in UAT Plan preparation including Test Scripts.
Environment: Agile Scrum, MS Visio, MS Project, MS Office Suite, Jira, Case Management, AML, Actimize, Trade Surveillance, MS Power Point, Tableau, MS Excel, Web Services, Oracle.
Confidential
Business Analyst
Responsibilities:
- Assisted Project Managers in capturing the scope, milestones, objectives, roadmap and vision of the project.
- Performed What-if analysis using Excel as per the requirements of the managers.
- Was involved in Business Process Re-engineering through workflow diagrams and other methods.
- Designed and implemented Portfolio Supervisory System, including trend analysis, forecasting returns and interfaces for risk management, financial advisors and financial analysts implementing the agile methodology.
- Experienced the content management also to manage to portfolio management.
- Developed good knowledge of Equities, Fixed Income, Futures, Bonds, Bond Pricing, Derivatives (Options), Credit Derivatives, Interest Derivatives and Equity Order Processing.
- Predicted Portfolio’s returns using Monte Carlo Simulation.
- Created Use Case Diagrams, Activity Diagrams and Entity Relationship Diagram (E-R) using MS Visio and developed a better understanding of Business Processes involved.
- Designed and implemented interaction with Portfolio Risk Management Analysis System to automate updating of various investment portfolios with respect to Contractual Agreements.
- Conducted Cash flow analysis on Customer accounts focusing on payouts on portfolios performance.
- Broke down EPICS into smaller user stories by having the INVEST criteria in mind.
- Created Requirements Traceability Matrix (RTM) and managed mitigation process and developer fixes, retested fixes, defects/bugs tracking, issue log and tracked progress for team members of project through completion.
- Managed Product Backlog with the help of Product owner and Scrum development team by using JIRA also generated reports to analyze the performance of the project.
- Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature is DONE and satisfied using the acceptance criteria.
- Extracted financial data from Morning Star to a spreadsheet for analytics purpose.
- Created deployment flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application.
Environment: Hybrid (Waterfall - Scrum), JIRA, MS Project, SharePoint, Morningstar, MS Project, Web Services, Microsoft Teams, XML, SOAP, JAVA, MS Outlook, HP QC, Tableau
Confidential
Associate Business Analyst
Responsibilities:
- Assisted and worked with Project manager in creating and assigned task through WBS.
- Interacted with customers and internal stakeholders and their expectations from the system to create BRD, FRD and SRS.
- Involved in analyzing Business Requirements and developing System Specifications
- Tracked and reported timely performance against plans and forecast analyzed gaps and recommended corrective measures to improve productivity.
- Assessed business priorities, and advised business units by performing Risk Analysis.
- Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
- Involved in incident reporting and change management procedures using Clear Case.
- Maintained and shared documents using MS SharePoint.
- Managed test cases and logged defects using HP QC tool.
- Formed a bridge between the Project Manager and different teams with effective presentations
- Planned and organized team engagement activities to encourage self-organization among the team.
- Documentation of production support related procedures, tips and best practices.
Environment: Waterfall model, SQL, Oracle, MS Excel, MS Project, MS SharePoint, MS PowerPoint, Prezi Business Presentation.
Confidential
Quality Assurance Analyst
Responsibilities:
- Extensively worked in Software Testing Life Cycle (STLC) phases - Requirement Analysis, Test Planning, Test Case Development, Environment Setup, Test Execution and Test Cycle Closure.
- Comprehended the requirements from testing perspective to identify different test scenarios and create test cases.
- Participated in various meetings to identify test scenarios along with QA lead and documented the scenarios linking to each requirement to capture the test coverage through Requirements Traceability Matrix.
- Contributed in defining the Entry and Exit criteria for all the STLC phases along with the senior executives.
- Developed, documented and executed automation test scripts, test data, test results and defects using Java embedded Selenium Web Driver maintaining Defect Life Cycle and assisted in creating Issue logs using JIRA.
- Performed GUI Testing, Sanity Testing, Regression Testing using both manual and automated test cases.
Environment: Waterfall model, Oracle, TestNG, MS Excel, MS PowerPoint, STLC, JIRA, Confluence.