SUMMARY

• Expertise in Business System Analysis, Data Analysis, Software Design, Development, and Implementation of business applications with knowledge of the Software Development Life Cycle methodologies such as Waterfall, Agile (Scrum, SAFe), and Hybrid.
• Proficient in Eliciting Requirements using techniques such as Document Analysis, Wire - Framing, Reverse Engineering, Focus Group Workshops, Joint Requirements Planning Sessions (JRP), and Joint Application Development Sessions (JAD).
• Proven success performing Gap Analysis, Risk Analysis, Impact Analysis, Cost-benefit Analysis, Root cause analysis and Interface Analysis.
• Expertise in Business Process Modeling Notations (BPMN) and UML Diagrams (Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Entity Relationship Diagrams, Component Diagrams) using MS Visio.
• Analyzing Business requirements and preparing functional requirements document (FRD), business requirement Document (BRD), Project Initiation document and systems requirement specifications (SRS).
• Experience working in different databases like Oracle, DB2, SQL server, proficient in Data warehousing, Data mapping, Data modelling (Star, Snowflake), Extraction, transformation and loading (ETL), Data preprocessing, Data Standardization, Data Cleansing, Data Normalization and Data Visualization, QA/QC and reporting tools like Tableau and SQL Server Reporting Services (SSRS).
• Participated in Scrum Ceremonies like Product Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective, as well as SAFe ceremonies like PMC Meetings, PO Sync, and Architectural Review Calls.
• Assisted the Product Owner in refining the product backlog by writing technical user stories based on INVEST criteria, prioritizing user stories based on MoSCoW Technique, and splitting user stories based on SPIDR technique.
• Advanced in Excel higher level functions and principles like Vlookups, at-if, match, data consolidation and qc, and graphing.
• Experience writing Postman specifications for REST APIs in YAML, API payloads in JSON, and analyzing API specifications using SOAP UI.
• Performed technical onboarding tasks like API mapping, configuration, testing, and documentation.
• Experience working with XML, JSON, WSDL, HTML, AJAX, API, SOAP, and RESTful Web Services, in SOA and Microservices Architectures.
• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data to SQL Server databases using SSIS.
• Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
• Sound knowledge in designing and optimizing the various T-SQL database objects like tables, views, user defined functions, cursors, indexes and triggers.
• Experience in Normalization & De-normalization on existing tables for faster query results.
• Hands on experience creating Client side, Server Side and Database Validations for various system operations and involved in defining the source to target data mapping, business rules and data definitions.
• Involved in various Testing Methods such as Black box testing, Functional Testing, Regression testing, Performance Testing, Smoke testing, Integration testing and User Acceptance Testing (UAT).
• Hands on experience Tracking, prioritizing defects using HP Quality Center based on criticality and severity and tracking the progress of testing by creating and maintaining Requirement Traceability Matrix and Defect Matrix.
• Thorough understanding of various corporate finance concepts and products - Valuation methods and Comparable analysis, DCF Analysis, Financial Statement Analysis, Ratio analysis, Credit risk analysis, Rate Risk, Liquidity Risk, Capital forecasting, Commercial loans, Mortgage loans, MBS, ABS, and Indices like S&P 500, NASDAQ, Russell 2000, and street identifiers like CUSIP, SEDOL, ISIN, Ticker symbols etc.
• Familiarity of various Statistical/Quantitative/data analysis concepts - correlation matrix, variance and regression analysis, probability, creating binomial models calibrated to Monte Carlo model and other financial functions by using MS Excel.
• Familiar with various compliance and regulatory standards like SOX, regulatory reporting, Market Risk Control, Dodd-Frank, Basel I II accords, AML laws, FFIEC AIBE rules, KYC and due diligence procedures, GAAP and IFRS rules, IT governing and monitoring activities and SOPs.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile (SAFe, Scrum), Hybrid

Web Technologies: XML, HTML & CSS, JSON, SOAP, AJAX

Project management Tools: Rally, Jira, Azure Devops, MS Project

Modelling Tools: MS Visio, Lucid Charts, Balsamiq

Visualization Tools: Tableau, MS Power BI, SAP Crystal reports

Documentation Tools: MS Office Suite, MS SharePoint 10

Testing Tools: Swagger, Postman, SoapUI, Selenium, HP ALM

ETL Tools: Informatica, Power center 9.0+, SSIS, MS Excel

Reporting Tools: Crystal Reports, XSLFO, Tableau

PROFESSIONAL EXPERIENCE

Confidential - Coloumbia, South Carolina

Lead Business Analyst

Responsibilities:

• Elicited Business Requirements by conducting detailed Interviews and Focus Group Sessions with Business Users, Stakeholders, and Subject Matter Experts (SMEs) such as Underwriters, Credit Analysts to define the Financial Projections and Cost-Benefit Analysis
• Worked closely with the Product Owner and assisted in breaking down features by WSJF method and their refinement
• Coordinated with Residential Underwriter, Mortgage Loan Servicer, Credit Analyst, and Compliance Professionals to determine the Business rules concerning Fixed-rate mortgage loan, Adjustable-rate mortgage loan, Government-Insured Mortgages, Jumbo Mortgages, and Conventional Mortgages
• Documented the gathered requirements in BRD and facilitated the JAD session where Requirement Modeling was done by drafting UML diagrams and BPMN Diagrams to identify the area which requires Customization
• Performed GAP Analysis for the elicited requirements to analyze if the Loan Origination System is capable of fulfilling the business requirements
• Draft and maintain software/business requirement documents in order to outline REST API project needs, assumptions, constraints, and milestones.
• Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower
• Responsible for the quality of all changes to Empower, the Confidential loan origination system for the branches
• Wrote Client-Side Validation, Server-Side Validation and Database Validation for various functionalities of the system
• Authored User Stories and Acceptance Criteria for the business requirements using INVEST criteria pertaining to the ATDD approach and managed team to build-up their velocity and managed performance using Agile KPIs such as Velocity chart, and Burnup chart in Jira Tool
• Defined and suggested SOAP, XML based Web services, and APIs based on languages such as C# and JAVA which would be compatible with the “As-Is” and “To-Be” state of the business process
• Provided training to business users involved in Sprint Review and demonstrated the agreed requirements as per the DOR and DOD criteria expected by the Product Owner and business stakeholders
• Utilized UDDI to look up existing web services and WSDL to identify the corresponding request and response web methods
• Assisted the Product Owner to prioritize User-Stories using MoSCoW techniques during Sprint Planning and Backlog Grooming Sessions
• Responsible for developing functional and technical user stories in INVEST criteria and Acceptance Criteria in GHERKIN format
• Excellent backend skills in API Integration and API Mapping, creating SQL objects such as Tables, Stored Procedures, Functions, Views, Indexes, Rules and SQL Performance Tuning to facilitate efficient data Manipulation and Consistency
• Created Data Mapping documents and worked with business to write Transformational rules
• Hands-on experience in Schemas, Dimensional modeling and Reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies in RDBMS including developing optimized SQL queries, Stored Procedures, User-defined Functions, and Transactions
• Ensured the application is compliant with all TRID regulations, AML laws, OFAC, BSA, FINCEN, and HMDA regulations
• Extensive use of Swagger for API Documentation.
• Extensive experience working Data Schemas like Snowflake and Star Schema for over 5 years.
• Proficient in the use of Tableau for 5 years.
• ETL processing using Informatica Power Centre
• Facilitated UAT sessions and developed Test Plans and Test Cases for verification and validation of requirements at all levels
• Involved in recognizing and generating reports for both the clients and the management being a core team member of the Center of Excellence
• Performed Functional testing and Smoke testing on a regular basis to make sure that the basic functionalities of the system are working
• Facilitated Triage calls to identify defects by performing Root Cause Analysis and mitigated it along with development and testing team
• Integration of APIs both Rest API and SOAP API and extensive experience working in a Microservices Environment
• XML to JSON and JSON to XML Data Mapping
• Responsible for adhering to the project schedule by developing and maintaining the project backlog during Agile projects and working with the product owner to set priority throughout the duration of project.
• Works directly with project team including user interface/user experience (UI/UX) designers, tech leads, solution architects, database administrators, developers, QA testers, and technical writers to ensure understanding of the requirements, functionality, size, and scalability of the IT solution.
• Responsible for providing information and analysis for Build vs Buy project decisions.
• Extensive experience with data warehousing like Redshift for data cleansing, analysis and data mining.
• Extensive experience working with collaboration tools like JIRA/RALLY and Confluence.
• Involved in Data Migration from On-site premises to the Cloud.
• Responsible for gathering the necessary requirement involved in Data Migration from On-site Premises to AWS

Environment: Agile - SAFe, SOA, Framework (HTML/CSS, Angular JS, Java, SQL, Oracle 12c, DB2), Tableau Desktop, AJAX, SOAP, XML, REST, Microservice, UML, Jira, Confluence, MS Excel, MS Visio, XSLFO, Windows 8.0, Informatica Power Center, Swagger, HP QC

Confidential - Roseland, New Jersey

Sr. Business Analyst

Responsibilities:

• Analyzed the existing system, performed Reverse Engineering to understand the As-Is system, extracted important functionalities, analyzed possible enhancements and documented them
• Validated the MT to MX mapping as per ISO 20022 and coordinated with the product owner in mitigating any impact.
• Analyzed data points and data fields on EDI 835, 837 to implement in the project
• Performed Gap analysis to assess the strengths and weaknesses of the proposed project in comparison to the current state documented in terms of various components
• Created SOS Interest (PI) grids to identify the key stakeholders for eliciting business requirements
• Facilitated Focus Group meetings, Stakeholder Interviews, and JAD Sessions with business users, developers, architects and database development team in order to elicit the base level requirements
• Designed and developed UML Diagrams including Use Case, Activity Flow, Class, Data Flow and Sequence diagrams usingMS Visio
• Created Dynamic Wireframes using Fluid UI for better understanding of the GUI and flow of the application
• Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved
• Involved in estimating the story points for user stories using Planning poker and Fibonacci series
• Responsible for creating the FRD and the BRD. Created various types of reports, sub-reports and drilldowns like standard and cross tab reports with bar chart, pie chart and line-chart graph representation reports using Crystal Reports
• Involved in identifying and implementation of SOAP, XML based webservices and web methods
• Performed Extract, Transform and Load (ETL) operations to perform data cleansing and standardization for reporting and actively involved in Data Mapping process
• Facilitated meetings with the development team to help them better understand use cases and to help them come up with code flow for these research items.
• API and Microservices integration involving JSON to s mapping
• Acted as the gatekeeper for all the defects in the testing phase, logged and analyzed defects using HP-ALM and also tracked the overall progress of testing by maintaining a Requirement Traceability Matrix (RTM)
• Used Power-BI software to create functional diagrams and identify key areas for data analysis.
• Excellent backend skills in API Integration and API Mapping, creating SQL objects such as Tables, Stored Procedures, Functions, Views, Indexes, Rules and SQL Performance Tuning to facilitate efficient data Manipulation and Consistency
• Created Data Mapping documents and worked with business to write Transformational rules
• Hands-on experience in Schemas, Dimensional modeling and Reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies in RDBMS including developing optimized SQL queries, Stored Procedures, User-defined Functions, and Transactions
• Ensured the application is compliant with all TRID regulations, AML laws, OFAC, BSA, FINCEN, and HMDA regulations
• Facilitated UAT sessions and developed Test Plans and Test Cases for verification and validation of requirements at all levels
• Involved in recognizing and generating reports for both the clients and the management being a core team member of the Center of Excellence
• Performed Functional testing and Smoke testing on a regular basis to make sure that the basic functionalities of the system are working
• Facilitated Triage calls to identify defects by performing Root Cause Analysis and mitigated it along with development and testing team.
• Extensive experience working with SWIFT for reporting and messaging.
• Redshift Data Warehousing experience for data manipulation, cleansing, data mining.
• Good knowledge in Payment area like interaction withClearing, payment file formats ISO20022, SEPA and SWIFT.

Confidential - Phoenix, Arizona

Sr Business Analyst

Responsibilities:

• Conducted Joint Requirements Planning (JRP) sessions with the Subject Matter Experts (SME) and the key stakeholders to understand business processes and the functionalities in detail.
• Conducted Walkthroughs and Meetings involving leads from Development, QA, Database and Technical Support teams to validate the Budget Planning.
• Analysed the risks involved by conducting SWOT and Cost-Benefit Analysis in Microsoft Office Environment.
• Engaged in all scrum ceremonies like Sprint Planning, Daily-standup, Sprint Review, Sprint Retrospective and Backlog refinement.
• Assisted product owner to prioritize User stories using MoSCoW technique during Sprint planning and Backlog refinement sessions and in estimating the user story points using planning poker and the Fibonacci sequence.
• Developed high level requirement documents Business Requirement Document (BRD) and consulted the technical team and developed the detailed System Requirement Specification (SRS) document.
• Created Requirements Traceability Matrix (RTM) to ensure that the requirements defined are linked at every point and are duly tested with respect to test parameters and protocols.
• Involved in Data Mapping for various schemas like Star Schema and Snowflake Schema and Data Migration from OLTP to OLAP database.
• Modelled complex Web Orchestrations involving multiple web services, APIs and microservices from distributed teams.
• Implemented OLAP techniques, performed Drill analysis, Slicing & dicing on the data using SQL Server Analytical Services (SSAS) and created PROC Reports using Base SAS.
• Extensively involved in performing Data Mapping by querying databases and performing Data Modelling in the construction of DataWarehouses by modelling transformations in MS Excel.
• Assisted in connecting Microsoft Power BI to various data sources: Microsoft SQL Server/Dynamics GP, Excel.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation in areas of Confidential Pre-payment risk, Risk Analytics for Confidential, Loan Servicing, Loan Origination, Confidential, CMBS, and Secondary Confidential Market.
• 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
• Customization ofEncompass Utilization of Services for delivery of loan files to underwriting to imaged file delivery to investors for purchase for 600+ scores.
• Gathered, elicitated and facilitated the project in compliance with Federal and State HMDA, RESPA, CCAR and FDIC regulations for a successful implementation of Encompass 360 Banker Edition Loan Origination Software.
• Applied, developed, and built out corporate compliance methodology scope as is permissible by Private Bank’s legal client agreements, data privacy local laws and the line of business shared data/visibility rules.
• Created new Loan and Serve application based on Life Cycle of the Loan Origination based on committee and risk approvals and reports using Microsoft Access/Excel/VBA/Dashboards.

Environment: Agile- Scrum Framework- (HTML/CSS, JavaScript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services.

Confidential

Business Systems Analyst

Responsibilities:

• Collected and documented business processes as well as business rules and performed GAP analysis.
• Implemented Data Governance using Excel and Collibra
• Custom extracts, reporting, metrics and dashboarding from Collibra
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level
• Created various Business Documents such as BRD and SRS to record Functional, Non-Functional Requirements, and technical requirements
• Worked with Billing Application group for the Customization and Stabilization of Batch Receipts, Revenue Cycle Management and updating Accounts Receivables (AR) reports
• Prepared and maintained the Requirement Traceability Matrix (RTM) for tracking the requirements till the testing phase is complete
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and satisfied the business requirements
• Validated the Web Service requests and response payloads and did API documentation using the Postman

Environment: Agile- Scrum Framework- (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services