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, 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 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 principals like vlookups, at-if, match, data consolidation, and graphing.
• Extensive Experience withContinuous 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 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.
• 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.

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 the strengths and weaknesses of the proposed project (To-be state) as compared to the AS-IS state documented in terms of various components.
• Demonstrated experience and understanding of the methodology testing in a DevOps environment, which include experience in using Jenkins for auto deployment of a build.
• Worked with 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 with business users, developers, architects and database development team in order to elicit the 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 the JAD session where Requirement Modeling was done by generating UML diagrams and BPMN diagrams to identify the areas that need customization by documenting the obtained requirements in BRD.
• Responsible for creating the Functional Requirement Document and the Business Requirement Document.
• Assisted the product owner in Backlog grooming sessions, ensuring that DOR and acceptance criteria are specifically articulated and prioritized using the WSJF and MoSCoW techniques.
• Actively participated in Program Level SAFe Ceremonies such as PO Sync, PMC, and Architectural Review Call (ARC) with Product Owner to identify feature dependencies and resolve Architectural Runway needs with System Architects and Tech Leads.
• Aided the development team in creating Client-Side Validation, Server-Side Validation, and Database Validation for various system operations and also involved in defining the 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, with the help of Postman.
• Responsible for writing SQL queries with concepts like Tables, Stored Procedures, Views, Indexes and aided the data team during Extract, Transform, and Load (ETL) process by writing transformation rules.
• 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 Tracibility Matrix.
• Conducted Triage Calls to identify issues using Root Cause Analysis, analyze the status of defects, prioritize them and collaborate with the 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 the 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 with SSAS based on multidimensional database with star schema or snow flake schema
• Assisted in the 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 with the Subject Matter Experts(SME) and the key stakeholders to understand business processes and the 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 with customers and creating SDLC artifacts including Business/Functional requirement documents.
• Managed all aspects of the SDLC from Business Needs, development, testing Implementation and Resource Planning, contracting/sub-contracting.
• Authored business and system requirements analyses and functional specifications with 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 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 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.
• 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 the project in compliance with 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 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: 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 the 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 the change requests and updating RTM throughout the 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 the designing and development of test case scenarios and test plans.
• Responsible for managing the inventory replenishment process and analyze changes to inventory levels based on historical data and input from sales.
• Involved in the integration of the interfaces from existing legacy applications to the 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 the 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 the database.
• Involved in writing test cases and test plans using HP-ALM, perform API testing with 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 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.

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

Confidential

Business Analyst

Responsibilities:

• Facilitated meetings with stakeholders for front end requirements of the project.
• Actively refined and prioritized the backlog items with Product Owners.
• Prepared test case and scenarios by collaborating closely with the testing team.
• Create SDLC artifacts including Business/Functional requirement documents.
• 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.

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