We provide IT Staff Augmentation Services!

Business Systems Analyst/ Quality Analyst Resume

0/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY

  • A self - motivated and purpose - oriented Senior Business Systems Analyst with 8 years of experience working in various capacities across Banking, Mortgage, Capital Markets, Payments, Finance and Wealth/Asset Management domains.
  • Skilled at gathering business and technical requirements from stakeholders, conducting business process/data analysis, and assessing risks and risks impact for the implementation of cutting-edge software applications under various Software Development Life cycle (SDLC) frameworks such as Waterfall, Scrum, and SAFe
  • Extensive knowledge in Anti Money Laundering Process, Small Business Loans, and Delinquencies, Identity Access Management, Identity Access Governance, Risk-Based Access
  • Experience in Capital Markets, Banking, Wealth Management and Financial Services industry with excellent understanding of financial products like Fixed Income, Equities, Derivatives (Swaps, Options and Futures), Mutual Funds, ETFs, FOREX and Risk analysis of Investments using historical simulation method, variance-covariance method, Monte Carlo simulation and Option Greeks knowledge of the Banking sector’s regulatory and compliance acts relating to the fraudulent practices like Bank Secrecy Act, Sarbanes Oxley Act (SOX), Suspicious Activity Report, Currency Transaction Report, Know Your Customer, Enhanced Due Diligence, GDPR, Bank Regulations Act, CCPA, and AML laws, regulations, and procedures
  • Knowledge of Mortgage Loan Origination Systems, Loan Servicing, Payment Card Industry, Data Security Standards (PCI, DSS), and PA DSS requirements and compliances
  • Knowledge in creating Data Requirements Specification (DRS), Project Charter, Project plan and RACI matrix thereby
  • Possessing a broad knowledge of Documenting and Presenting the deliverables at every milestone of the project
  • Teamed up with various Business and Technical Stakeholders to elicit Functional and Non-Functional requirements by performing a variety of Requirement Elicitation techniques such as Stakeholder Analysis, Interview, Brainstorming, JAD sessions, Requirements Workshop, Survey/Questionnaire, Document Analysis, Focus Groups, etc.
  • Experienced in conducting Feasibility studies, Risk Analysis, Cost-Benefit Analysis, and Impact Analysis, PARETO analysis to analyze the needs of a project; Performed GAP Analysis to understand AS-IS and TO-BE of the business processes
  • Expertise in creating and documenting project artifacts such as Business Requirements Document (BRD), Functional Specification Document (FSD), Functional Requirement Document (FRD), Use Case Documentation, Business Rules Spreadsheet, Data Mapping Document, and Systems Requirements Specification document as to when needed
  • Experienced in conducting Feasibility studies, Risk Analysis, Cost-Benefit Analysis, and Impact Analysis, PARETO analysis to analyze the needs of a project; Performed GAP Analysis to understand AS-IS and TO-BE of the business processes
  • Improved the teams’ competencies by creating Work Breakdown Structures (WBS) and Critical Path Analysis (CPA) knowledge of Waterfall, Waterfall-Agile (Hybrid), Agile (Scrum) framework including Scrum Ceremonies: Sprint Planning meeting, Daily Scrum, Sprint Review Meeting, Sprint Retrospective, partook in Product Vision Meetings, Backlog Grooming
  • Efficiently documented various Scrum Artifacts such as Product Backlog, Release Backlog, Sprint Backlog and Information Radiators like Sprint Burn-up - Burn-down charts, and Control charts
  • In-depth knowledge in writing Acceptance Criteria and User Stories along with aiding product owner in determining Minimum Viable Product (MVF), Minimum Requirement feature (MRF) and Minimum Marketable Feature (MMF)
  • Collaborated with the product owner and the teams in writing Definition of Ready (DOR) and Definition of Done (DOD)
  • Substantial knowledge of best Agile testing practices such as Test-Driven Development (TDD), Acceptance Test-Driven Development (ATDD), Behavior-Driven Development (BDD), and continuous integration of the Shippable Product
  • Proficient in creating Unified Modeling Language (UML) diagrams: Use Case diagram, Activity diagram, Sequence diagram using MS Visio and Lucid Charts for clarity of the project and communicating the same with the teams
  • Experience in various data retrieving, data validation and data extraction process using SQL queries to interpret documents that contain results from databases to conduct a deeper analysis of the data stored in Relational databases
  • Explicit insight and knowledge of Data warehouse implementation, Extract-Transformation-Load (ETL) process, Data Profiling, Data Cleansing, Data Mining, data quality assessment, data integration and validation, Data Mapping, Data Migration experience in implementing Databases, ODS, Data marts, Data integration; knowledge of Schemas, OLTP, and OLAP operations
  • Experienced with Intelligence (BI) tools like Informatica PowerCenter’s (IPC) Designer & Workflow Manager
  • Skilled in identifying various Entities and their Relationships, created Entity-Relationship Diagrams (ER), associated Conceptual and Logical Data Model to define the required objects accurately (without any Redundancy) in the Database
  • Solid knowledge on Three-Tier Architecture and using various web services like Simple Object Access Protocol (SOAP), Representational State Transfer (REST), Extensible Markup Language (XML) for successful systems communications
  • Experienced in API testing using Postman and SoapUI used Swagger for API documentation
  • Liaised with the development team to design & implement Test Plans, Test Scenarios, Test cases and performed Black-box Testing, System Testing, UI Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing & Sanity Testing and Usability Testing using testing tools and bug detecting tools like HP-ALM, HP-QC, and JIRA-Zephyr; Involved in Bug and Defect tracking and their resolvement
  • Maintained the Requirement Traceability Matrix (RTM) to check functionalities coverage with test cases
  • Leveraged collaboration and interactive tools like Confluence and SharePoint to improvise team’s communication
  • Experienced in using reporting tools like SQL Server Reporting Service (SSRS), Tableau to create interactive dashboards and reports like heat maps, bar graphs, pie charts, and pivot tables to derive business insights from OLAP cube and used Tableau connectors to embed insights to dashboards

TECHNICAL SKILLS

FINANCE DOMAIN KNOWLEDGE: Portfolio Management/ optimization, Asset Price Modeling, Equities, Fixed Income and Derivative securities, Dodd-Frank Act, Sarbanes Oxley Act (SOX), LIBOR, BASEL Accords

SOFTWARE DEVELOPMENT LIFE CYCLE: Kanban, Agile-Scrum, Waterfall - Agile hybrid, Waterfall, RUP, SAFe

BUSINESS SKILLS: Financial Modelling, Forecasting and Budgeting, DCF Analysis and Business Valuation, ROI Analysis, Release Planning, Change Management, Competitive Analysis, Risk Management, User Testing, Conflict Resolution

BUSINESS MODELLING TOOLS: Lucid Chart, MS Visio, Rational Rose, Balsamiq Mockups, draw.io

PROJECT MANAGEMENT, TESTING AND PERFOMANCE TOOLS: JIRA, HP ALM, HP-QC, Confluence, Cucumber, MS Project, MS SharePoint, JMeter, Jenkins, Soap UI, Swagger, Postman, Load Runner

BI AND REPORTING TOOLS: IBM Cognos, Tableau, MS Power BI, MS Office Suite (Excel, Word, PowerPoint, Access)

ARCHITECTURE / FRAMEWORK: Service Oriented Architecture (SOA), Microservices N - Tier Architecture, 3 Tier Architecture

SERVER TECHNOLOGIES AND DATABASES: Apache Web server, WebLogic App server, IBM WebSphere App server, IBM Connect Direct, IBM HTTP Server, Oracle App server, Oracle HTTP Server, Oracle SOA-Suite (Forms & reports)

DATA WAREHOUSING: Data Modeling, ETL, Data Marts, ODS

PROGRAMING LANGUAGES: Python, HTML, HTML5, Dot Net, JAVA, CSS, Batch script, C++, YAML, Shell Script, COBOL, XML, JSON

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Business Systems Analyst/ Quality Analyst

Responsibilities:

  • Wrote and maintained the revision history of the detailed functional specifications for each feature set throughout the development cycle, using input from business stakeholders, SME’s, the software development team, and Quality Assurance team
  • Worked on multiple specifications and/or specifications for complex features broken down into user stories.
  • Partnered with Business and Operations partners to understand and elaborate requirements.
  • Document Functional Requirements with supporting UI Mockups/Wireframes, use cases, current vs future state flow diagrams and sequence diagrams.
  • Participated in technical design discussions to ensure the design meets specifications.
  • Assisted the programmer, QA and UAT teams to bridge the gap in understanding requirements and review test cases/test plan to make sure all scenarios are covered. Performed and Document BA Testing before functionality is rolled out for QA/UAT.
  • Did QA analysis, acquired proof of issue, QA tested defects/ Regression Testing, Acquired sign off for defects fixed to be accepted.
  • Hands-on Test analysis, ready to dive into the database, understand tables, data model to perform data analysis using SQL queries in ACS400.
  • Followed the standard development process to make the best use of limited resources (time, money, people) resulting in a stable, maintainable product that meets user requirements

Environment: Kanban, Rally, Informatica PowerCenter, XML, SOAP, JAVA, MS Outlook, HP QC, SharePoint, HP LoadRunner, Balsamiq, MS Visio, MySQL, Amazon Redshift, RESTful, MS Project, Web Services, MS Excel, Tableau, SQL, MS Outlook, MS PowerPoint

Confidential, Malvern PA

Senior Business Systems Analyst

Responsibilities:

  • Aided Project Managers in attaining theScope, Milestones, Objectives, RoadmapandVisionof the project
  • Defined various key business processes for the Market business process owners and identified the critical data elements that require for monitoring data quality issues
  • StructuredJAD and Brainstorming sessions, workshops to understand end user requirements; preparedagendaand facilitated the meetings with the SMEs, product owner & stakeholders toelicit requirements, document outcomes, and captureMinutes of Meetings
  • Executed source system exploration and consolidated data from several sources with datacleansing and validations
  • EmployedGAP analysisto identify redundant source fields, additional target fields and transformation logics
  • End-to-end management of Data Quality exceptions, working with Finance & Risk partners to determine root cause, requirements, resolution, and validation to ensure data integrity
  • PreparedData Mapping Specificationdocument to map the source and target data including necessary business transformation logics
  • Assisted indata integrationby using differenttransformations like joiner, filter, expression, sort, aggregator and look upin theInformatica Power Centeralong with creatingMapplets
  • Formulated data migration approach through assisting DB architects in modellingBus Architecture, designingSnowflake Schemaand preparingE-R Diagramsto comprehend targeted data warehouse
  • Assisted in performingData Normalizationprocess to eliminate data redundancy and faster query processing
  • CreatedUse CaseDiagrams, UML Diagrams,Activity Diagrams, built Wireframes and Mockups using Balsamiq to develop a better understanding of Business Processes involved
  • Maintained APIsbetween the internet and virtual cloud usingAmazon API Gatewayto allow for a well-ordered communication between the application and external devices (browser, phone, tablets)
  • Comprehensively used Project Collaboration tools likeJIRAandHP-ALMto capture and manageUser storiesand actively took part in Scrum Ceremonies while aiding in prioritizing features usingMoscowmodel
  • Thorough authorized system users and permissions for the enhancement in theIdentity and Access Management consolebased onWorkflowandBusiness Rules
  • Assisted Pre - UATsessions with SME, business owners and business users by providing information regarding system behavior and preparingTraining Manualsregarding functionality of the new system
  • Managed Product Backlog utilizing JIRA with the assistance of Product owner and Scrum development unit, also generated Velocity, Sprint Burn-up and Burn-down Chart reports to evaluate the performance of the project
  • Aided the scrum team inHybrid Slicing (Vertical and Horizontal)of user stories. Slicing performed was based on Data types and Parameters as well as Workflow and Business Rules
  • Worked with the Product Owner during theSprint Review Meetingfor the release of Potential Shippable Product Increment (PSPI)and help decide which feature is DONE and satisfied using theacceptance criteria
  • Engaged in Batch joberror debugand handling, Batch jobs design, Batch Group design, schema exports imports using metadata manager and overseeing data team workshops for documentation & reporting
  • Involved inBusiness Process Re-engineeringthrough workflow diagrams and other methods
  • Producedthe Requirements Traceability Matrix (RTM)and handled mitigation process and developed fixes, retested fixes, defects/bugs tracking,issue logand tracked progress for team members of project through completion
  • Created variousdashboardsandad-hoc reportsusingTableaupromoting business insights and trend analysis

Environment: Agile-Scrum, JIRA, Informatica PowerCenter, XML, SOAP, JAVA, MS Outlook, HP QC, SharePoint, HP LoadRunner, Balsamiq, MS Visio, MySQL, Amazon Redshift, RESTful, MS Project, Web Services, MS Excel, Tableau, SQL, MS Outlook, MS PowerPoint

Confidential, Phoenix AZ

Senior Business Systems Analyst

Responsibilities:

  • Delivered SME inputs on verdicts and significances vis-à-vis Role Based Access Control RBAC; Worked with members of the application development teams to design and integrate applications with Role-Based Access Control system RBAC
  • Worked with AML Investigators, Analysts, and Auditors in recognizing the process flows to improve the workflow to develop a Case Management Tool
  • Preserved compliances by ensuring that the organization’s regulations, policies, procedures comply with work including Bank Secrecy Act (BSA), Anti Money laundering (AML), BASEL III, Sarbanes Oxley Act (SOX), Know your Customer (KYC), Enhanced Due Diligence (EDD), CDD, and Customer Identification Program(CIP) and regulations
  • Performed GAP analysis by reviewing the existing AS-IS process, proposing possible areas to improve to achieve the TO-BE system
  • Ensured there was the establishment of Process Alignment between Business Process Objectives, Performance Measures with organizational objectives and strategies to avoid conflicts and inept activities
  • Facilitated JAD sessions, interviews using various techniques from BABOK with SMEs & PO to better understand requirements of AML Process starting from false positives and alerts to filing the SAR reports
  • Participated in the Pre-PI and Post-PI Planning activities
  • Conducted market research on features that could add weightage in the future and can be used by the AML Investigators
  • Transcribed user stories and acceptance criteria and crisscross if they passed the criteria of INVEST rule
  • Worked closely with product owner in effectively maintaining and prioritizing the Product Backlog and release plan.
  • Facilitated Knowledge Transfer sessions between the team leveraging JIRA for project planning, scheduling, drafting epics, stories, sprint burn up, burn down charts, expectation charts and status reporting while using KANBAN board for the visual flow of the process
  • Facilitate (Agile) scrum meetings, mid sprint checkup, enforcing timeboxing along with responding to impediments
  • Created detailed Use cases,BPMN flows,Functional Specifications, UML diagrams to remove ambiguity of the requirements communicated by clients or SMEs leveraging VISIO
  • Created Data Mapping artifacts for the source and target data fields that are being populated automatically by the system like alerts, tables, CTR list, transaction reports, KYC information, and also applying transformation logic where required and was responsible for assessing the cross impacts as a part of project support
  • Executed SQL queries including complex joins and multi-level filters by leveraging MS SQL on large data sets for exploratory analysis, research analysis, extracting data and ad-hoc reporting, KPI reporting
  • Used Balsamiq mockups for making high and low Confidential wireframes and mockups for UI/UX
  • Assisted in SOA by determining along with the team how the best requirements and Business Rules can be crafted and grouped for maximum efficiency and visibility during SOA (Service oriented architecture)
  • Assisted the project management team in identifying/mitigating project risks and analyze/streamline KPI’s, business processes, workflows, and project scheduling
  • Collaborated with Release Train Engineers (RTE) to compile team PI Performance Measures (TPPM) and tracked committed and stretch PI objectives to showcase the delivery reliability of various teams on the Agile Release Train (ART)
  • Instigated communication using Rest with data type XML/JSON, documented APIs on Swagger and web service requests and responses; took part in API/ Webservice testing and leveraged SOAP UI for load and performance testing of web APIs.
  • Familiar with UI development which was designed and developed in Java and JavaScript including REST Interfaces
  • Used SharePoint as a collaboration tool for Knowledge sharing, Artifacts sharing, and as a communication tool
  • Assisted stakeholders in defining the boosting of incident deflection to reduce the rate of creating incidents and volume.
  • Developed and documented several Incident Management process models, SLAs for the role of Incident Manager
  • Facilitated UAT sessions and Performing UAT requirements analysis, write and execute UAT scenarios
  • Leveraged Tableau, Excel V-lookups and Pivot Tables, VBA for building KPI dashboards, ad-hoc reporting, automating project status and getting insights from data for business needs

Environment: SAFe, microsoft.NET, ASP.NET, Microsoft IIS9.0, Azure Cloud, ASP.NET, PowerShell, JIRA, BPMN, MS Project, MS Visio, Balsamiq, SOA, Tableau, Postman, MS SQL, UiPath, MS Office (Word, PowerPoint), QC ALM, HP LoadRunner, YAML Files, Distributed Systems, Microservices, SharePoint, MS Project

Confidential, Wilmington DE

Business Systems Analyst

Responsibilities:

  • Actively involved with various cross-functional teams in upfront planning, designing, development and testing phases
  • Assisted in generating a streamline process to understand the various steps in the Loan Lifecycle and desired functionality of the new system by interacting with users, SMEs, stakeholders, lenders, underwriters
  • Identified and analyzed needs for various functionalities by using various techniques such as Document Analysis, Focus Groups, and Interviews with Subject Matter Experts (SMEs) and project stakeholders
  • Performed GAP Analysis by understanding the current AS-IS business process and proposed TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio
  • Assisted in elaboration of epics into user stories in Product Backlog Grooming Session so that stories are granular
  • Established junction objects tomaintain many-to-many relationshipsanddefined lookup and master-detail relationshipsfor the variousloan workout rulesto in corporate business logic and compliance into the application
  • Developed several activity and sequence diagrams with swim lanes and UML components to show entity relationship diagrams (ERD) using Lucid chart and Microsoft Visio for the developers and data architects
  • Prepared the function flow of application; by creating High Confidential Wireframes and Mockups using Balsamiq.
  • Conducted end-to-end data validation of data flow, created the Data Mapping Document for defining data flow between data source and target along with business rules; assisted ETL developers to prepare ETL routines to conduct the process.
  • Written and executed SQL queries to perform various types of analysis like data analysis, data validation using different types of Joins, Subqueries and Aggregate functions on Oracle 12c DB
  • Used Tableau to generate credit check reports and application status reports
  • Designed API technical documents and conducted API designs sessions to understand their functional features of REST, HTTP, XML using Postman and worked on developing API integration documentation using Swagger
  • Worked with the QA team for validating Test Plan and Test Cases for Integration testing, Regression Testing, Whitebox Testing, black Box Testing, Smoke Testing and assisted in facilitating User Acceptance Testing (UAT)

Environment: Agile-Scrum, MS Office, MS Visio, MS Project, SharePoint, Balsamiq, Magento 2.0, HP ALM, Web Services, REST, SOA, HTML, HTTP, XML Web Method WSDL, Tableau, Oracle 12c, SQL, Postman, Swagger, JIRA, Confluence

Confidential, Boston MA

Business Systems Analyst

Responsibilities:

  • Functioned as the primary liaison between business line, operations, and the technical teams
  • Gathered business requirements by conducting different elicitation techniques like JAD sessions, requirement workshops, surveys, research, and one-on-one interviews with stakeholders
  • Assisted the project manager in different project management tasks such as project scoping, defining business needs, resource scheduling/budgeting, portfolio reporting, status reporting, project planning, change management, and identification of missing roles/resources and resolution of same
  • Conducted and led requirements planning session with multiple stakeholders and AML application development sessions with the SMEs and development team
  • Created Functional Specification Document (FSD) including business process flow diagrams, business process mapping, and Business Use cases to better understand the overall process flow and user
  • Created data mapping spreadsheets for sourcing and landing data by defining data source, data target, data conversion rules, business rules and exceptions rules to set-up the data load process
  • Analyzed and validated data by running SQL queries in Oracle database
  • Published reports by analyzing the data and reported to the senior level management by using Cognos
  • Tracked individual process model and documented changes for implementing business process re-engineering
  • Conducted Feasibility analysis, Impact Analysis, Cost/Benefit analysis, and ROI analysis to assess the potential implication of changes including cost & benefit, and documented new business rules, functions, and requirements
  • Prepared recommendations for process changes, technological and business solutions based on project requirements
  • Involved in the change management process and taking signoffs from stakeholders
  • Constructed SQL queries to extract & analyze data in Oracle database responding to data requests from the stakeholders
  • Utilized Team Foundation Server (TFS) to identify bugs
  • Involved in preparation of UAT test plan, test scenarios, test cases, testing cycle schedules, and implemented them with the QA team
  • Worked with the product owner during the Sprint Review Meeting for the release of the PSPI and help decide which feature is DONE

Environment: Waterfall-Scrum, Oracle SQL, MS SharePoint, MS Visio, MS Word, MS Excel, MS PowerPoint, Team Foundation Server, MS Project, Google Analytics, Cognos

Confidential

Business Analyst/ Tester

Responsibilities:

  • Validated the requirements from both previous independent platforms are included in the new centralized platform, along with more security, user-friendly environment, faster performance & with more convenience
  • Interacted with clients to assess needs, identify key challenges, and define project scope and deliverables; Performed Problem Analysis, Research Solutions & presented recommendations
  • Developed electronic records management best practices and procedures for Document Management services by FileNet
  • Assisted Sr. Business Analyst in creating Business requirement document and Functional requirement specification
  • Assisted and worked with Project manager in creating and assigning tasks through WBS (work breakdown structure
  • Involved in Conceptual and Logical data modeling, user database schema design documentation and modification of triggers, scripts, stored procedures in database servers
  • Created High FidelityPrototypes of Application User Interfaces using Wireframes and Mock-ups with focused attention to detail in enriching User Experience and User Interaction
  • Assessed business priorities and advised business units by assisting in performing Risk Analysis
  • Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity
  • Worked with the lead on the project establishing QA processes, defining roles, developing test plan templates, defect tracking, troubleshooting & debugging of the application, coordination among team members and management of work assignments, creating status reports periodically and provided direction and leadership with strong interpersonal and team building skills
  • Designed Test Plans and Test Cases for User Acceptance Testing (UAT) and performed performance testing including load and stress testing with the help of QA teams to identify performance and related vulnerabilities
  • Collaborated with other BA/QA resources & gave weekly status reports to upper management on overall testing progress
  • Evaluated and documented all test results (defects/explanations) and perform thorough analysis for variations from the expected results
  • Identified any risks for tasks completion on time & informed of resource allocation issues
  • Created multiple data visualization reports with IBM Cognos for the to give variable analysis of business matrices
  • Used SharePoint for content management and document management

Environment: Waterfall, MS Word, MS Excel, MS PowerPoint, MS Access, MS Project, QlikView v 11.20, SQL Server, Informatica PowerCenter, SharePoint, Google Analytics, Microsoft Project, Outlook, Great Plain.

Confidential

Financial Analyst

Responsibilities:

  • Provided support to Financial Planning Manager and CFO in areas of financial management, planning and business analysis
  • Responsible for journal entry preparation, monthly close process, variance analysis and internal reporting
  • Month-end, quarterly and year-end financial reporting, consolidation and account analysis, Preparation of general ledgers
  • Developed product cost for new and existing SKU’s and system maintenance of costs additions and changes to ensure accuracy of cost
  • Supported development and analysis of Annual Operating plan, Outlook and LRP processes
  • Monitored general inventory levels, correct discrepancies, and communicate unusual trends
  • Conducted physical inventory audits, reconciliations, and procedure compliance to safeguard company assets and provide ongoing financial reviews with local management
  • Identified accounting problems, research solutions, develop/implement solutions, and present finding to management
  • Assisted in preparation of new Product Authorization cost forms and assisted new product teams in costing and support
  • Analyzed upcoming variance and inventory issues primarily involving cost changes and supply chain structure changes
  • Ensured that the impact of significant product, packaging, and supply changes are reflected in the financial plan
  • Reported, analyzed, and discuss monthly purchase price variance results
  • Established strong working relation to ensure accurate decision support information is provided for management

Environment: Google Analytics, Microsoft Project, Microsoft Excel, Microsoft Access, Outlook, Great Plains

We'd love your feedback!