Sr. Business Systems Analyst Resume
Boston, MA
SUMMARY
- Enthusiastic, hard - working professional with a proven track record and good leadership skills. A creative and intuitive problem solver with holistic approach to problem-at-hand. Strong work ethic and an amiable team player capable of gelling with and motivating team members to exceed their expectations and an individual committed to philosophy of life-long-learning.
- Over 8 years of diverse work experience assuming various roles like business system analyst, business analyst and developer in banking, mortgage, finance domains with good understanding of various processes and systems in place.
- Excellent interpersonal skills, leadership qualities, written and verbal communication. Adept at conflict management, work delegation and negotiation. Flexible in adapting to newer environments in minimal time and ability to drive positive change.
- Worked in traditional and agile methodologies like waterfall, Scrum, Kanban, Water-Scrum fall, Scrumban. Thorough understanding of development practices like Extreme Programming (XP), Spiral and Rational Unified Process (RUP).
- Involved in all phases of Software Development Life Cycle by collaborating with Business Users, Subject Matter Experts (SMEs), Project Managers, Product Owners, developers, end users and other Key Business Stakeholders.
- Strong domain understanding of retail banking, commercial banking, investment banking and credit risk fundamentals.
- Thorough understanding of compliances and regulations like US Patriot Act, Fair Credit Reporting Act(FCRA), Equal Credit Opportunity Act(ECOA), Bank Secrecy Act(BSA), Know Your Customer(KYC), Anti Money Laundering(AML), Currency Transaction Reporting(CTR), Suspicious Activity Reports(SAR), Customer Due Diligence(CDD), Enhanced Due Diligence(EDD), Generally Accepted Accounting Principles(GAAP), FinCEN CDD Rule and Customer Identification Program(CIP) regulations.
- Excellent communication skills necessary to elicit requirements through job shadowing, surveys, interviews, focus groups, document analysis, interface analysis and JAD sessions with Business Owners, Business Users, SMEs and other stakeholders.
- Assisted project manager in developing documents like Work Breakdown Structure (WBS), Project Charter (PC), and risk register.
- Highly experienced in creating the requirements artifacts such as Business Requirement Document (BRD), System Requirements specification (SRS), Use-cases, Functional Requirements Specifications (FRS), Technical Requirements Document (TRD), Change Requests Planning (CRP) and Requirements Traceability Matrix (RTM) and validating these requirements against the business case.
- Assisted the team in employing and adhering to best practices like TDD, BDD and ATDD depending on the business needs.
- Enhanced the Continuous Integration and Continuous Deployment (CI/CD) pipeline by using JENKINS as CI tool.
- Efficient in defining Acceptance Criteria, Definition of Done (DOD); creating user stories through SMART & INVEST criteria; prioritizing stories (using MoSCoW, KANO and 100 Point method) and estimating stories (using T-Shirt sizing, Relative Mass Valuation techniques).
- Proficient in drawing UML diagrams including Use-Case diagrams, Sequence diagrams, Activity diagrams and Class diagrams.
- Extensive experience in formulating As-Is and To-Be process models, conducting Gap Analysis to understand areas of improvement and analyzing the risks involved through SWOT, FMEA, Value Stream Mapping, Feasibility Analysis and Impact Analysis.
- Skilled in identifying data requirements, creating data flow diagrams, data mapping, data analysis, Process mapping and BPM .
- Experienced in data modeling (Conceptual, Logical and Physical), multi-dimensional schema design (star and snowflake schema) for data warehouse modeling and creating Entity-relationship diagrams with different relationships.
- Comprehensive knowledge of Data Warehousing, data marts, OLAP (MOLAP, ROLAP) operations like slicing, dicing. Also performed OLTP CRUD operations in dynamic databases to periodically read and update records from databases.
- Significant knowledge and experience in using ETL tools such as Informatica 9.6.x. Good knowledge about Repository Manager, Power Center Designer, Power Center Workflow Manager, Power Center Workflow Monitor and Power Center Administration Console.
- Sound knowledge of RDBMS concepts and wrote SQL queries(using select, update, joins(inner, left-outer, right-outer, full-outer, cross-joins), where clause, distinct, group by, order by and having) for performing CRUD operations by using Data Definition Language(DDL), Data Manipulation Language(DML) and Transaction Control Language(TCL).
- Designed Mockups, Wireframes, prototyping Static and Dynamic UI, BPMN for the requirements to get a detailed understanding for the design of Application under development, provided functional/technical consulting with a holistic view of the system.
- Good understanding of Web Services and corresponding Service-Oriented-Architecture (SOA) with 3-tier and n-tier implementations.
- Extensively involved in various stages of STLC like Unit, Integration, System and UAT testing. Participated in Functional, Non-Functional, Smoke and Sanity testing through creation and execution of test cases, test plans, test scenarios, test reports and bug logs.
- Extensive knowledge and experience in defect management using HP Application Life Cycle Management and facilitating Triage decision making (Prioritization and Severity of defects) in defect management.
TECHNICAL SKILLS
Content Management Systems: AEM 6.0, AEM 6.1, AEM 6.2, AEM 6.3, AEM 6.4
SDLC Methodologies: Scrum, Kanban, Water-Scrum-Fall, SAFe, RUP, Waterfall
Web Technologies: HTML5, CSS3, JavaScript, XML, JSON, Sightly
PM Tools: Atlassian JIRA, Confluence, MS Project, MS Office 365(Word, Excel, PowerPoint, Access)
Modeling Tools: MS Visio, Lucid Chart
BI/Reporting Tools: Tableau, MS Excel, MS Power BI
Supporting Tools: Rational Requisite Pro, Rational ClearQuest, Rational ClearCase
Testing Tools: HP ALM, HP QC, HP UFT Selenium
ETL Tools: Informatica 9.6
Databases: Microsoft SQL Server, PostgreSQL
Data Modeling: Conceptual/Logical/Physical, Star/Snowflake Schema
Data Warehousing: OLTP, OLAP, Multidimensional Analysis, Data Marts, Slicing/Dicing, Rollup/Drilldown
Web Services: SOAP, REST, Swagger tool, Postman
Programming Languages: Java, C, C++
PROFESSIONAL EXPERIENCE
Sr. Business Systems Analyst
Confidential, Boston, MA
Responsibilities:
- Gathered business requirements by interviewing the business owners and users through employing a variety of techniques like interviews, focus groups and jad sessions. Also developed Business Requirements Document for the business owners.
- Helped develop MVP with features for initial review after Product Grooming, developing User Stories with the help of Jira, prioritizing using MoSCoW model, proposing Acceptance Criteria and collaborating with the Product Owner and Scrum Team.
- Used Jira for the Backlog Grooming, Estimations and Status Reporting, while maintaining the Kanban Board to visualize the Workflow and assisted the Product Owner with Definition of Ready (DOR) and Definition of Done (DOD) for the sprints.
- Assessed the current security mechanism of the application using gap-analysis and analyzed algorithms like SHA, 3-DES, AES etc in terms of the security enhancements they offer. Suggested solutions for the insecure data storage practices and binary obfuscations . Devised the process flows diagrams and internal workings of the money management application .
- Acquired and read the artifacts to understand the various subsystems (atm, payment processor, payment network, customer) involved in the process of Cardless ATM transactions, created ad-hoc reports for various business subsystems.
- Utilized the Ebm core NLP API to send voice and text communication and receive the output processed by NLP (pre-trained machine learning algorithms) by analyzing tone, sentiment and text classification.
- Assisted the development team to streamline the process of message queue communication while the “Kubernetes” message broker is busy by assessing the Inter Process Communication methods like msgget(), msgsnd() and msgrcv().
- Devised “ given-when-then” scenarios for the features to be developed using behavior driven development tool cucumber.
- Held Knowledge Transfer Sessions while also assuming the role of Proxy Product Owner in certain instances and sprints.
- Understood the various metrics that governed the data and also developed the framework for implementing Data Warehouse.
- Created a data mapping document that included source data fields, the business logic and target data fields for easy comprehensibility.
- Assisted the team in carrying out the implementation of Service-Oriented-Architecture (SOA) and instigate communication using REST, JSON. Facilitated end-to-end web service testing for RESTful API through Postman and Swagger for documenting requests and responses for RESTful APIs. Used the HTTP GET, POST, PUT, DELETE calls on application layer to test web services.
- Involved in data preprocessing phases like data cleaning, data transformation and data reduction by using various techniques to address missing values, noisy data. Used techniques like normalization, aggregation and attribute subset reduction for data preprocessing.
- Utilized Informatica repository manager, Power center designer to import sources from various databases and to create transformations.
- Developed reports using tableau like bar graphs, pie charts, word maps, heat maps etc. detailing the overall performance improvements in terms of security by adoption of new algorithms, new customer addition, revenue generation, customer analytics etc.
- Extensively involved in various phases of STLC like unit, integration, system and UAT testing. Created test plans, test cases, test scenarios and executed them using HP ALM. Created the test cases and imported the test sets to test lab for execution.
- Involved in the API generation, testing and documenting processes using swagger editor, swagger ui and swagger codegen. Facilitated end-to-end web service testing using Postman and Swagger for documenting responses.
Environment: Scrum framework, Jira v8.x, Tableau v9.0, IBM Db2 11.5, IBM Watson, IBM Discovery, IBM Bluemix Storage, Watson assistant, Ebm core, Watson Language Translator, Kubernetes v1.14, Swagger.
Sr. Business Systems Analyst
Confidential, Wilmington, DE
Responsibilities:
- Worked in Scrum Framework facilitating Requirement Elicitation, Elaboration, deriving User Stories from product roadmap, Validation, performed Stakeholder Analysis, Feasibility Study, Use Case Narratives and Business Process Optimization activities.
- Presented various Key Performance Indicators (KPI) and Business Metrics by assisting the BI Analysts in generating reports, ad hoc reports and interactive dashboards and created a storyline for presentation using Tableau for Analysis and Visualization.
- Ascertained the scope of data migration like feature freeze, triage, removing the redundant and erroneous data.
- Identified GAPs in the existing AS-IS legacy application and recommended possible areas of improvements in the TO-BE target system.
- Identified Source and Target data, performed Data Mapping, Data Profiling, developed Governance Processes, Transformation Processes using Informatica and applied Business Rules to engineer ETL Process and populate AWS Redshift.
- Implemented the Canonical Data Model (CaDaMo) that serviced customers while parallel development of target system is underway.
- Created the Data Flow diagrams, Process Flow diagrams, Data Mapping Documents to map the source and target systems.
- Managed the technical delivery of custom development, integrations, and data definition elements of AEM implementation.
- Collaborated with other developers to conceive architectural strategies and participated in review sessions with end-users as needed.
- Used Jira for the Backlog Grooming, Estimations and Status Reporting, while maintaining the Kanban Board to visualize the Workflow and assisted the Product Owner with Definition of Ready (DOR) and Definition of Done (DOD) for the sprints.
- Facilitated JAD sessions, Interviews with Tech Leads, Product Owner, Stakeholders to elicit requirements for migration and automation of Loan Origination, underwriting through Closing, monitoring Risk-Based Pricing program to ensure loan compliance
- Interacted with SMEs to develop an understanding of features exclusive with different loan terms such as 3/1, 5/1 ARM, Fixed and Hybrid Rate Mortgage, Purchase, Refinance, Reverse Mortgage and Home-Equity Loan Structures to streamline the process of migration.
- Maintained compliances ensuring work complies with JPMC established policies, procedures, regulations, to include Bank Secrecy Act, Anti-Money Laundering (AML), Member Identification Program (MIP), and Office of Foreign Asset Control (OFAC).
- Assisted with the review and administration of the lending criteria, matrices and review rules in the LOS decision engine.
- Assisted in creation of Test Cases, Test Plans, Test Scenarios, updated and maintained the Requirements Traceability Matrix.
- Assisted QA Team in testing the application during Smoke Testing, Black Box Testing, Regression Testing, User Acceptance Testing and improving, altering and running Test Scripts using Jira-Zephyr, created training and testing material and documented it.
Environment: Scrum Framework, Adobe Experience Manager(AEM 6.3), Jira v7.0, MS Visio v16.0, Balsamiq Mockups, MS Office Suite v2016, MS SQL Server v2017, PostgreSQL v10.6, Postman v4.1.1, Tableau v9.0, AWS Redshift, S3, Snowball, EC2, AWS Glue, Confluence.
Business Analyst/Scrum Master
Confidential, Phoenix, AZ
Responsibilities:
- Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups and analyzed the feasibility of the requirements. Formulated and conducted GAP Analysis to derive requirements for ACH processing.
- Conducted Cost-Benefit analysis, Feasibility check, Impact analysis, Cost analysis, and evaluated porters five forces to determine business competition and suggested alternative process enhancements for improving efficiency of ACH payments.
- Coached the team and helped in transitioning from Waterfall to Agile by following Waterfall-Scrum hybrid approach.
- Created and maintained various documents like Business Requirement Documents (BRD), Software Requirements Specifications (SRS).
- Interacted with SME’s by asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and businesspeople. Created Mock-Up Screens and Wireframes for client verification.
- Adopted Entity-relationship modeling technique and developed Conceptual and Logical data models for DFI tables.
- As a SCRUM Master facilitated and time-boxed the SCRUM ceremonies like Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospectives and Grooming Sessions. Helped in creating an environment conducive to Agile transformation.
- Used JIRA for issue tracking, user story creation, requirement traceability and traced issues from creation through completion.
- Worked with the Product Owner during the Sprint Review Meeting for the Potentially Shippable Product Increment (PSPI) and helped to decide which features are DONE and satisfied using the Acceptance Criteria.
- Conducted Risk analysis as required by NACHA and maintained a Risk Register to evaluate and address issues periodically.
- Communicated effectively across company contacts and clients regarding requirements, schedules and launches.
Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, MS office, Asp.net, MS SQL server 2016, JIRA 7.7.0, Tableau v10.5, MS Office Suite (MS word, MS Excel, PowerPoint).
Sr. Business Analyst
Confidential
Responsibilities:
- Held interactive Workshops and Focus Groups with significant Stakeholders, SMEs, Product Owner, Tech Lead to list high-level requirements in automating underlying aspects of the servicing module considering Private Mortgage Insurance PMI, MIP, Delinquent Mortgage, Debt-to-Income Ratios, Mortgage-Backed Securities (MBS) in the early Backlog Grooming Process.
- Elicited requirements from end-clients through Observation Technique with focus on mitigating Early Payment Defaults (EPD) and Long-Term Defaults (LTD) through early detection of payment default probabilities, delinquencies, lessening inherent risks and increasing overall value of loans thus increasing the Return on Investment (ROI).
- Facilitated development team with suitable environment setup to build a customizable mortgage fraud detection system that can be configured accordingly to analyze loan application data and identify applications which are obtained using fraud data.
- Conducted Gap Analysis by mapping existing As-Is systems to future To-Be systems while analyzing dependency risks and handled Requirements Churn by coordination with Product Owner and Development Team considering Scope Creep constraint.
- Elicited requirements and created Business Requirements Document (BRD) and linked the Requirements Page in Confluence with Jira for Product Backlog Items, supported in creation of User stories and Acceptance Criteria along with Product owner for Sprints, prioritized PBI and involved in Sprint Planning, Daily Stand Ups, Sprint Execution, Reviews and Sprint Retrospective meetings.
- Assisted in executing SQL queries, CRUD operations to pull data from databases and producing delimited files to create sample dataset to perform Backend Testing and Data Validation and took part in execution of functional and performance tests of APIs.
Environment: Hybrid (Waterfall-Scrum-Fall), Jira 6.4, Zephyr, MS Visio v15.0, Confluence v5.5.2, SQL Server v2014, Balsamiq, SoapUI v5.2, MS Office Suite v2015 (Word, Excel, PowerPoint), HP ALM, Lucidchart.
