PROFESSIONAL SUMMARY:

• Sr. Business Analyst with around 8 years of experience in analyzing and gathering requirements for business processes in techno - functional role across Finance (Fixed income, Robo Advisors, Target Date Funds, Capital Markets, Commodities, Derivatives) and Banking (Automated Clearing House, Payments).
• Extensive knowledge about concepts of financial domain such as Net Asset Value, Expense Ratio, Trade Life-cycle, Volatility Measures (R-squared, Standard Deviation), Real Estate Investment Trust.
• Extensive knowledge of SOX, Basel III Framework, Comprehensive Analysis Capital and Review (CCAR), Dodd Frank Annual Stress Testing (DFAST).
• Experience with SDLC methodologies like Waterfall, Agile (Scrum), and Scrum-Waterfall Hybrid.
• Successfully gathered SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements at various levels and facilitating elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, document analysis. Proficient in networking with multiple teams.
• Excellent business writing skills in BRD, FRD, and SRS and creating process flows using UML diagrams such as Use case, Sequence, Activity and Class diagrams in Business and Process Flow Modelling.
• Breaking-down of Epics into User Stories (INVEST format) and then helped in prioritizing user stories using various prioritization techniques like MoSCoW and 100-point method. Estimated the user stories using estimation techniques such as Planning Poker, T-shirt sizing, and Dot Voting System.
• Well versed in facilitating Sprint Ceremonies (Sprint Planning, Daily Stand-ups, Sprint Review, Sprint Retrospective) and parallel execution of Backlog Grooming for each sprint in Agile Scrum Methodology.
• Experience in supporting the Product Owner to define the Minimum Viable Product (MVP), Definition of
• Done (DOD). Proficient in grooming and refining Product Backlog items and accommodating change requests.
• Proven expertise in conceptual and logical data modeling, data integration, migration and data conversion. Knowledge of Source data identification and data profiling, and data mapping.
• Designed Mockup’s and Wireframe for the requirements to get a visual understanding of the application.
• Attention to details understanding the aesthetics of GUI, to produce fluid use experience using KendoUI.
• Experience in creating Test Plan, Test Scripts, Test cases, Requirement Traceability Matrix (RTM), User Acceptance Testing (UAT), and familiar with Smoke testing and end-to-end Regression testing.
• Extensive knowledge of Functional testing, Unit and Integration testing, Load and Performance testing,
• Black box testing, User acceptance testing, Smoke testing, Sanity and Regression testing. Assisted the
• QA in preparing test plans and test cases, actively involved in defining User acceptance criteria and conducting User Acceptance Tests (UAT) using JIRA. Responsible for updating and maintaining RTM.
• Executed SQL Queries, Functions and Stored Procedures using database platforms such as Oracle 11g.
• Strong knowledge of SQL queries which includes Inner and Outer Joins, select statements, Order by, Group by and Aggregate Functions such as Count, Min, Max. Additionally DML and DDL languages.
• Working knowledge of visualization and reporting tools like Tableau and Power BI to drive operational intelligence. Strong knowledge of implementing Databases, Data Table Structures, Data marts, Data
• Analysis, Data Integration, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up and Drill-down.
• Strong understanding of XML, JSON, loosely coupled Web Services (REST, SOAP, WSDL) and system architecture like SOA, 3-tier architecture. Documented RESTful and SOAP requests and response.
• Worked with SMEs’ to understand Key Performance Indicators (KPI’s), & Service Level Agreements ( SLA’s ).
• Good Understanding of Project Management Tools, testing tools and defect reporting tools.
• Creative and self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environment.
• Experience in negotiating and coordinating with Developers, Application Architects, SME’s, business users, testing teams and senior executives.

TECHNICAL SKILL:

Finance Domain: Target Date Funds, Robo Advisors, Trade Life-cycle, Volatility Measures (Alpha, Beta, R-squared, Sharpe Ratio, Fixed Income (T-bills, T-notes, T-bonds)

Waterfall, Scrum, Agile, WaterScrum: Fall, TDD, Kan-ban.

Data Modelling Tools: Lucid Chart, Balsamiq, MS Visio, StarUML, Fluid UI.

Test Management Tools: Jira.

Reporting Tools: Tableau, MS Power BI, MS Excel.

Requirement Management Tools: Jira.

Languages: C, C++, Java, JavaScript, HTML-5, CSS-3, JSON, XML, SQL.

Databases: MSSQL Server, MySQL 8.0 CE.

Communication & Collaboration: Atlassian Confluence.

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Sr. Business Systems Analyst

Responsibilities:

• Possess a good understanding of Capital Markets, Bonds, Derivatives, E quities, Fixed-income, Asset Allocation, Wealth Management.
• Created user stories by eliciting information from SME’s, business owners, and referred to previous project artifacts to analyze the As-is system and To-be system. Drafted process workflow using Lucid Chart.
• Assisted PO and PM in ROI Analysis, and GAP Analysis in order to be prepared for potential business and technical risks. Created Risk Traceability Matrix (RTM) to validate all requirements to their test cases.
• Drafted Business Requirement Document (BRD), Functional Requirement Document (FRD) and Systems Requirements Specification (SRS) by virtue of multiple teams involved in the enhancement of the system.
• Decomposed the elicited information into user stories by conducting a story writing session with the Product owner and define the acceptance criteria for the PSPI (Potentially Shippable Product Increment).
• Estimated Product Backlog Items (PBI’s) using Planning Poker and prioritized them using MoSCoW.
• Actively participated in Sprint planning, Daily Stand-ups, Review and Retrospective meetings.
• Strategically handled requirement churn by making sure the current sprint is not affected by the change.
• Proficient in creating UML diagrams like Use-case, Activity and Sequence using Lucid chart.
• Created Mock-ups and Wireframes for the dashboard using Balsamiq to test the aesthetics of the system.
• Implemented changes to the GUI using KendoUI framework for rich and fluid user experience.
• Conducted UAT and maintained a feature-file that listed all the activities of the tests.
• Executed ad-hoc SQL queries to using joins to fetch data from SQL server database system.
• Created burnup and burn-down charts for the team performance and project timeline suing JIRA.
• Extensively used JIRA to record and maintain the artifacts along with tasks, impediments, and defects.
• Created ad-hoc reports based on the investment venues and target date range using Tableau.
• Involved in creating Kanban board, Issue Tracking and generated reports for multiple sprints using JIRA.
• Involved in API testing to test the accuracy and performance of the data fetched from Bloomberg servers.
• Involved in JSON technical documentation using Postman, debug and API monitoring for performance.
• Acted as a primary liaison between the business line, operations, and the technical team throughout the project life cycle. Planned and organized team engagement activities to encourage self-organization.
• Performed task decomposition, delegated tasks and monitored project milestones.

Environment: SDLC, Agile (Scrum), KendoUI, JIRA, MSSQL Server, Balsamiq, Postman, XML, JSON, Java, C++, .NET, JavaScript, SQL, REST API, MS Office Suite (Word, Excel, Outlook), Lucid Chart.

Confidential, Minneapolis, MN

Sr. Business Systems Analyst

Responsibilities:

• Elicited business requirements by conducting Interviews with stakeholders, Interface Analysis by collaborating with Subject Matter Experts (SMEs). Well versed in MPT and CAPM.
• Captained GAP Analysis by understanding the AS-IS business process and TO-BE business process.
• Decomposed the scope from the information gathered during the elicitation sessions into user stories in SMART and INVEST format and defined the acceptance criteria for the PSPI’s.
• Assisted the project manager in drafting the BRD, FRD and SRS documents in detail.
• Created UML diagrams to show the Use-case, Activity and Sequence flow of the system using Lucid Chart .
• Designed GUI as per requirements for the web portal and created wireframes using Axure RP.
• Engineered front-end UI using HTML5, CSS3, Bootstrap and AJAX to simplify client-side scripting of HTML.
• Designed Mock-ups and wireframes for the RA platform using Balsamiq.
• Prepared Requirement Traceability Matrix (RTM) in order to track test cases to their requirements .
• Used JIRA for writing test cases , test plans and test suites. Performed all the tests manually.
• Organized project documents using Confluence , created permission at a space and individual level.
• Worked with Tableau to create dashboards, identify the Key Performance Indicators KPI’s to better analyze the data and measure the service level compliance of all automated & human controlled processes.
• Assisted in defining the Data Lakes to maintain demographic info, investor relationships, investor’s current activity, and investor journey graph in the system database.
• Designed conceptual model for Data Lake to store affluent clients personal and portfolio details.
• Defines Data Mapping Document (DMD) that maps the customers and investment fields to the storage.
• Performed UAT using JIRA and performance test of the system using JMETER.
• Using Postman, conducted API ingestion tests to see if the data is accurately fetched from external sources.
• Used Informatica Power Center for performing ETL process (Extract, Transform and Load) and performed feature-based extraction. Executed ad-hoc SQL Queries such as joins and aggregate functions.

Environment: Agile (Scrum), JIRA 6.3, JIRA, JavaScript, SOA, RESTful, JSON, Informatica 9.1, MS office suite (Word, Excel, outlook), Lucid Chart, Tableau 2018.3, Confluence.

Confidential, Morissville, NC

Business Systems Analyst

Responsibilities:

• Understood the processes by interacting with stakeholders and participated in a JAD session.
• Defined user stories based on information gathered from stakeholders and estimated and prioritized them.
• Understood the current Trading system to create data dictionary and defined meta data fields
• Defined logical and conceptual model for the definition of data warehouse and OLAP cubes.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schema to help development of an accurate Data Warehouse Structure.
• Performed dimensional modelling and assisted System Architect in creating dimensional and fact tables.
• Utilized Informatica PowerCenter to perform ETL process to extract and manipulate the sources data.
• Created different Informatica Workspace (Sources Analyzer, Target Designer, Mapping Designer, Mapplet designer, and transformation Developer) to transform the data from source to target.
• Helped with data normalization for elimination of data redundancy and faster query processing.
• Involved in creating mapping design between source and target and performed various transformations.
• Managed and tracked bugs and defects using JIRA. Posted bugs on the organization’s page for a joint effort.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing.
• Assisted in Validation testing, Metadata Testing, Data Completeness Testing, and Transformation Testing.
• Designed test scenarios and test cases for constraints, correctness, cleanliness, and data quality.
• Performed SQL queries like DML and join commands and supervised the source to target mappings (STM).
• Was involved in using Tableau for effective ad hoc reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
• Timely tracked progress and reported it to Stakeholders and Project Manager.

Environment: Waterfall - Scrum Hybrid, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, JIRA, MSSQL Server 2012, Tableau, UML, UAT testing, Confluence.

Confidential

Jr. Business Analyst

Responsibilities:

• Implemented Waterfall SDLC methodology which included Requirements Analysis, Design, Development, QA & Testing, Deployment, and Maintenance.
• Performed requirements gathering by Document Analysis, Prototyping, and User-scenarios.
• Created mock-ups using MS Visio to implement a fluid experience by incorporated visually pleasing UI’s.
• Assisted the Project Manager in defining the scope of the project and in creating the FRD, and SRS.
• Defined the business rules according the standards of Order Tracking System.
• Designed UML diagram such as Sequence, Activity, Class, and Use Case diagrams.
• Coordinated creation of Test plans, test cases, User Acceptance Test (UAT) scripts and RTM.
• Actively involved in handling change request by performing Impact Analysis on Triple Constraints.

Environment: Waterfall, Lucid Chart, MSSQL Server, MS Office Suite (Word, Excel, Outlook), JIRA.

Confidential

QA Analyst

Responsibilities:

• Developed Test plans, Test cases, Test scenarios and their scripts. The scripts were developed after careful review of the BRD, and SRS. The manual testing was performed on JIRA.
• Tested the application on various browsers to test its cross-browser viability and on different environments.
• Monitored defects and reported the bugs using JIRA via email to different developers working on the bug. Once the defect is fixed, conducted regression testing and closed the defect if it fixed.
• Analyzed all the bugs in the JIRA, participated with the users during the UAT.
• Investigate software defects and interact with developers to resolve technical issues.
• Performed User Acceptance Test (UAT) and wrote DML SQL Queries to test the target database.
• Interactions with Business Analyst, Developers, UAT team, and QA team members in defect raising situations.

Environment: Waterfall, MSSQL Server, MS Office Suite (Word, Excel, Outlook), JIRA.