SUMMARY

• Expertise in Business System Analysis, Data Analysis, Software Design, Development, and Implementation of business applications wif knowledge of teh Software Development Life Cycle methodologies such as Waterfall, Agile(Scrum, SAFe), and Hybrid.
• Proficient in Eliciting Requirements using techniques such as Document Analysis, WireFraming, 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 datawarehousing, data mapping, data modelling (Star, Snowflake), Extraction, transformation and loading (ETL), Data preprocessing, Data Standardization, Data Cleansing, Data Normalization and Data Visualization 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 teh Product Owner in refining teh 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 principals like vlookups, at-if, match, data consolidation, and graphing.
• Extensive Experience wifContinuous integrationtools (e.g.GitHub, TFS, Jenkins),Cloud(e.g.Amazon Web Services, Azure),Monitoring/alertingtools.
• Experience writing Postman specifications for REST APIs in YAML, API payloads in JSON, and analyzing API specifications using SOAP UI.
• Performed technical onboarding taks like API mapping, configuration, testing, and documentation.
• Experience working wif 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 teh business requirements by collecting data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data to SQL Server databases using SSIS.
• Sound knowledge in designing and optimizing teh 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 teh 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 teh 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.

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, Juno Beach, FL

Sr. Business Analyst

Responsibilities:

• Conducted Gap analysis to assess teh strengths and weaknesses of teh proposed project (To-be state) as compared to teh AS-IS state documented in terms of various components.
• Demonstrated experience and understanding of teh methodology testing in a DevOps environment, which include experience in using Jenkins for auto deployment of a build.
• Worked wif vendor to create comprehensive requirements for all system enhancements and changes and document reports and obtain approvals.
• Responsible for Business Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Business Process Reengineering.
• Facilitated Focus Group meetings, Stakeholder Interviews, and JAD Sessions wif business users, developers, architects and database development team in order to elicit teh base level requirements.
• Created business process workflow diagrams usingBusiness Process Modeling Notation(BPMN) and designed and developed UML Diagrams including use cases, activity diagrams, entity relationship diagrams and sequence diagrams usingVISIO.
• Aided in teh JAD session where Requirement Modeling was done by generating UML diagrams and BPMN diagrams to identify teh areas that need customization by documenting teh obtained requirements in BRD.
• Responsible for creating teh Functional Requirement Document and teh Business Requirement Document.
• Assisted teh product owner in Backlog grooming sessions, ensuring that DOR and acceptance criteria are specifically articulated and prioritized using teh WSJF and MoSCoW techniques.
• Actively participated in Program Level SAFe Ceremonies such as PO Sync, PMC, and Architectural Review Call (ARC) wif Product Owner to identify feature dependencies and resolve Architectural Runway needs wif System Architects and Tech Leads.
• Aided teh development team in creating Client-Side Validation, Server-Side Validation, and Database Validation for various system operations and also involved in defining teh source to target data mappings, business rules and data definitions.
• Used UDDI tolocate theexisting financial web services and validated request and response of finance APIs like Bloomberg, Yahoo Finance, wif teh help of Postman.
• Responsible for writing SQL queries wif concepts like Tables, Stored Procedures, Views, Indexes and aided teh data team during Extract, Transform, and Load (ETL) process by writing transformation rules.
• Acted as teh gatekeeper for all teh defects in teh testing phase, logged and analyzed defects using HP-ALM and also tracked teh overall progress of testing by maintaining a Requirement Tracibility Matrix.
• Conducted Triage Calls to identify issues using Root Cause Analysis, analyze teh status of defects, prioritize them and collaborate wif teh development and testing team to resolve them.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into teh database.
• Participated in query optimization, performance tuning and knowledge sharing activities and translated project requirements into functional and non-functional specifications for reports and applications.
• Created OLAP cubes wif SSAS based on multidimensional database wif star schema or snow flake schema
• Assisted in teh preparation of quarterly valuation models comprising of investment performance track record and any changes to returns and asset valuations.

Environment: UML, BPMN, VISIO, Oracle, SQL Server, Jira, Excel, Windows 7.0, Waterfall, SoapUI, Web Services, MS-Office, Crystal Reports, SharePoint, TFS, Microsoft Azure

Confidential, Columbia, SC

Senior Business System Analyst

Responsibilities:

• Conducted Joint Requirements Planning(JRP) sessions wif teh Subject Matter Experts(SME) and teh key stakeholders to understand business processes and teh functionalities in detail.
• Edentified root causes and corrective actions to meet short and long-term business, financial and system requirements.
• Responsible for deriving requirements from interviews wif customers and creating SDLC artifacts including Business/Functional requirement documents.
• Managed all aspects of teh SDLC from Business Needs, development, testing Implementation and Resource Planning, contracting/sub-contracting.
• Authored business and system requirements analyses and functional specifications wif supporting business process flows (data modeling), Traceability matrices, risk analysis.
• Conducted Walkthroughs and Meetings involving leads from Development, QA, Database and Technical Support teams to validate teh Budget Planning.
• Analysed teh 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 teh user story points using planning poker and teh Fibonacci sequence.
• Developed high level requirement documents Business Requirement Document (BRD) and consulted teh technical team and developed teh detailed System Requirement Specification (SRS) document.
• Created Requirements Traceability Matrix (RTM) to ensure that teh requirements defined are linked at every point and are duly tested wif 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 web services, APIs and microservices from distributed teams.
• Implemented OLAP techniques, performed Drill analysis, Slicing & dicing on teh 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 teh construction of DataWarehouses by modelling transformations in MS 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.
• 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 teh project in compliance wif Federal and State HMDA, RESPA, 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 teh line of business shared data/visibility rules.
• Created new Loan and Serve application based on Life Cycle of teh Loan Origination based on committee and risk approvals and reports using Microsoft Access/Excel/VBA/Dashboards.

Environment: MS Office, Windows 7, SQL Server Management Studio, Oracle, DB2, Excel, HTML, Visio XML, VB, WEB Services, Postman, TFS, Java, .Net, JIRA, Altova XML.

Confidential, Chicago, IL

Sr. Business Analyst

Responsibilities:

• Gathered business requirements from stakeholders and Subject Matter Experts (SMEs) and translated them into functional requirements and authored teh Business Requirement Document (BRD), System Requirement Specifications (SRS), and User Requirement Specifications.
• Validated development dependencies based on feedback received from ETL, database team and facilitated design and architecture development to make sure those requirements are addressed before we go live.
• Responsible for managing teh change requests and updating RTM throughout teh project lifecycle.
• Responsible for creating Mock-Ups and UML diagrams for processes, sequence, and orchestration via sequence diagram, activity diagram, entity relationship diagram, and use case diagram.
• Configured Security, User roles, and Profile permissions for UAT and assisted in teh designing and development of test case scenarios and test plans.
• Responsible for managing teh inventory replenishment process and analyze changes to inventory levels based on historical data and input from sales.
• Involved in teh integration of teh interfaces from existing legacy applications to teh JDA Enterprise planning package via managing requirements for data interfaces, defining technical approach and assisting in issue analysis and QA support.
• Trained and managed offshore team in JDA Space planning, demand planning and fulfillment and store clustering module requirements and development effort, facilitated as a onshore team lead in development initiatives and made sure requirements are met and provided in timely manner.

Environment: Scrum, Jira, UML, MS Project, Visio, TFS, MS SharePoint, Excel, MS SQL, MS Visio, Postman, XML, JSON

Confidential

Business Systems Analyst

Responsibilities:

• Performed Document Analysis and conducted Stakeholder Interviews to elicit high level functional requirements and gain understanding of teh business objectives.
• Maintained various documents like Business Requirement Document (BRD), System Requirement Specification (SRS), and RTM(Requirement Traceability Matrix) to capture functional, non-functional, and technological needs.
• Performed data mapping, created class diagrams and ER diagrams, and used SQL queries to filter data from teh database.
• Involved in writing test cases and test plans using HP-ALM, perform API testing wif Postman and aid in User Acceptance Testing (UAT).
• Modelled complex Web Orchestrations involving web services, APIs and microservices from distributed teams.
• Implemented OLAP techniques, performed Drill analysis, Slicing & dicing on teh 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 teh construction of DataWarehouses by modelling transformations in MS Excel.

Environment: MS Excel, Postman, MS-Office, Oracle, Java J2EE, HTML, MS SQL, HPQC/HP-ALM.

Confidential

Business Analyst

Responsibilities:

• Facilitated meetings wif stakeholders for front end requirements of teh project.
• Actively refined and prioritized teh backlog items wif Product Owners.
• Prepared test case and scenarios by collaborating closely wif teh testing team.
• Create SDLC artifacts including Business/Functional requirement documents.
• Developed high level requirement documents Business Requirement Document (BRD) and consulted teh technical team and developed teh detailed System Requirement Specification (SRS) document.
• Created Requirements Traceability Matrix (RTM) to ensure that teh requirements defined are linked at every point and are duly tested wif respect to test parameters and protocols.

Environment: Waterfall, MS Visio, MS Excel, SOAP, XML, JSON, HTML, Postman, MS SQL Server, REST.