PROFESSIONAL SUMMARY:

• Overall 8+ years of experience as Business Systems Analyst in Finance and Banking Industries.
• Excellent domain knowledge and Experience in Portfolio Management, Portfolio Rebalancing, Security backed Loan Monitoring Systems, Trade Lifecycle Management, Asset & Wealth Management, Asset Allocation and Diversification.
• Strong understanding of Stock Exchanges, OTC Trading, Capital & Money Markets, Financial instruments ranging from Stock Equities, Fixed Income Securities like Bonds & T - Bills, Derivative Products such as Options, Swaps, Futures and Forwards, Certificate of Deposits, Mutual Funds.
• Extensive working knowledge in various Financial Risks like Credit or Default Risk, Liquidity Risk, Equity Risk, Asset Backed Securities Risk, Currency Risk, other Systematic and Non-Systematic or diversifiable Risk.
• Experience and working knowledge various Finance compliances and Regulatory bodies like FINRA ( Financial Industry Regulatory Authority ), Internal Revenue Service Section 529, The USA Securities and Exchange Commission, NASFAA ( National Association of Student Financial Aid Administrators ).
• All Round Experience and comprehensive knowledge in different phases of Software Development Life Cycle, Industry Standard Methodologies like Waterfall and Agile Methodologies & Frameworks like Scrum, Scaled Agile Framework (SAFe), Large Scale Scrum (LeSS), Kanban, Water Scrum Hybrid and Scrumban.
• Six Sigma Green Belt Certified with vast knowledge in Lean and Just in Time (JIT) Principles and Continuous Process & Throughput Improvement methods such as DMAIC approach in the IT Industry.
• Excellent in Organizing and facilitating Requirements Gathering Sessions such as JAD, Focus Groups, Interviews, Requirement Workshops, Brainstorming, Requirement Reviews with various Stakeholders.
• Proficient in performing elicitation techniques such as Prototyping, Surveys & Questionnaire, Observations and Business Analysis like SWOT Analysis, Market Analysis, GAP Analysis, Document Analysis, Root Cause Analysis, Cost Benefit Analysis, Cause and Effect Analysis, Impact Analysis, As-Is and To-Be Analysis .
• High Expertise in creating artifacts such as Business Requirements Document (BRD/HLD), Functional Requirement Document (FRD/LLD), Systems Requirements Specification (SRS), Requirement Traceability Matrix (RTM) and also experienced in generating Project Charters, Work Breakdown Structures, Project Plans,
• Excellent in creating Screen Mockups and Wireframes for dashboard to assist the developers in understanding.
• Well versed and Proficient in writing User Stories, Acceptance Criteria, breaking down of Epics as per INVEST criteria and handling requirements churns in and out of the sprints smoothly
• Assisted the Product Owner in prioritizing the PBIs using MoSCoW and KANO Analysis & estimating the user stories using estimation Techniques such as Planning Poker, T-Shirt Sizing, Complex Bucket System etc.
• Skilled in developing Use cases and UML diagrams like Class, Activity, Use Case and Sequence diagrams.
• Well versed in performing SQL queries using various Clauses, Commands & functions like different types of Joins (Inner, Outer, Left, Right, Full joins), Unions, Group By & Aggregate functions such as Sum, Min, Max, Count, Avg and other user defined Triggers & Functions to extract data from different Relational Databases (MS SQL server, MYSQL) for timely reporting and validation.
• Efficient in Defects Management in development and testing and mapping them with requirements using RTM.
• Comprehensive working knowledge of Data Warehousing Architecture, Implementation approaches, various schemas such as star and snowflake schemas, dimensional modeling and Entity Relationship Diagrams.
• Performed (Online Analytical Processing) OLAP cube operations such as Roll-up, Drill-down, Slice, Dice, Pivot in Dimensional Data Models & generated reports via Tableau.
• Worked with the ETL developers on Informatica Tool to create Source to Stage and Stage to Target Data Mapping documents indicating the source tables, columns, data types, transformations and business Logic to be applied.
• Skilled in Creating Reports using visualization methods like graphs & charts such as Pie Charts, Scatter Plots, Histograms, Gantt Charts, Line & Bar graphs, Bubble Charts etc. based on data extracted from databases or Data Warehouse using Tableau.
• Extensive understanding and knowledge of Three-Tier, N-Tier & Service Oriented Architecture, Web Services and their interaction with Application Tier through APIs such as XML/SOAP protocol or JSON using REST architectural style. Also assisted in documenting APIs using tools such as Swagger, SoapUI, Postman.
• Experience in assisting the QA team in developing Test cases, Test plans and Test procedures in different test environments with in the Agile Framework.
• Collaborated and monitored various testing such as Black-Box testing, Smoke Testing, Sanity Testing, Regression Testing, User Acceptance Testing (UAT) for verifying and validating the product.

TECHNICAL SKILLS:

Methodologies/ Frameworks: Agile Scrum, SAFe, LeSS, Scrum Waterfall Hybrid, Waterfall, Scrumban.

Databases: MySQL Server, Microsoft SQL (T-SQL), Oracle 9i and 10g (PL/SQL), RDBMS.

Tools: /Misc.: Confluence, MS SharePoint, Advanced Excel, MS Word, MS PowerPoint, UML, MS Visio, Balsamiq, HTTP, TCP, FTP, HP Quality Center, Postman, SoapUI, Swagger, Salesforce Service Cloud.

Project Management Tools: JIRA, Rally (CA Agile Central), HP ALM.

Requirements Analysis: SWOT Analysis, Market Analysis, GAP Analysis, Document Analysis, Root Cause Analysis, Cost Benefit Analysis, Cause and Effect Analysis, Impact Analysis, As-Is and To-Be Analysis, Risk Assessment, ROI (Return of Investments) Analysis.

BI & Data Visualization Tool: Tableau

Web Technologies/ APIs: HTML, CSS, Web Services, XML, JSON, SOAP, REST

Architectural Frameworks: Three Tier Architecture, N Tier Architecture, Service Oriented Architecture (SOA)

Data Warehousing: Data Marts, Data Modeling, Top Down/ Bottom Up approaches, OLAP, OLTP, ETL Tool- Informatica, Slicing/Dicing, Drill Down/ Roll Up, Pivot, Star and Snowflake Schemas.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

SR. BUSINESS SYSTEMS ANALYST

Responsibilities:

• Conducted High level requirement gathering sessions with Portfolio Managers, Fund Managers and other stakeholders through JAD sessions, Focus Groups, Interviewing and Brainstorming sessions.
• Performed Document Analysis on different compliances, rules & regulations of section 529 of the IRS (Inter Revenue System), NASFAA (National Association of Student Financial Aid Administrators ), FINRA (Financial Industry Regulatory Authority) & SEC (The U.S. Securities and Exchange Commission), provided compliance support to the development team in enhancing the Business Logic Layer of the Application Tier.
• Prepared BRD (Business Requirement Document) and FSD (Functional Specification Document) from the elicited requirements, helped the Product Owner & developing team in making user stories by using Three C’s technique.
• Performed Cost-Benefit & ROI analysis to establish the significance of enhancements to be made.
• Created prototypes of UI through Mock-up screens and wireframes using Balsamiq tool to assist the team.
• Created Activity, Use Case, Class and Sequence Diagrams using MS Visio tool to capture the dynamic behavior of different features and functionalities that were added to the enhancement of the project.
• Performed technical and business Impact analysis of Requirement Churns for checking the feasibility in maintaining the triple constraint in overall project and discussed them during Daily Scrum meetings.
• Used JIRA as project management tool for allotting tasks, issue tracking, user story management, requirement traceability, bugs & defect management and for creating sprint burn-down and product burn-down charts.
• Used MS SharePoint as collaborative tool for content, requirements & documents management with in the team.
• Actively wrote user stories, acceptance criteria and broken-down Epics into smaller stories using different slicing techniques based on workflow steps, separate error handling, functional & non-functional requirements.
• Created KANO models and performed MoSCoW analysis to assist the Product Owner in prioritizing the Product Backlog Items (PBIs) during the Backlog grooming sessions. Also helped in the estimating the user stories through Planning Poker technique. Helped the Scrum Master in facilitating the Sprint Planning and Sprint review.
• Retrieved data from Databases using various SQL (Structured Query Language) Data retrieval commands, Join clauses (Inner, Outer, Right, Left Joins), Unions & Where conditions in the MS SQL server.
• Used built in Aggregate functions in SQL such as Sum, Min, Max, Count, Avg, and other commands like Group by, Order by and View command to generate timely reports for the Team.
• Identified Data fields and Tables using data dictionaries and SQL queries. Created Data mapping documents in MS Excel to map the target data field and source data fields.
• Worked with Project team representative to ensure that logical and physical data models were developed in line with corporate standards and guidelines and satisfy all data requirements.
• Designed conceptual model diagrams to capture the entities existing in the system and the relationship between them using Entity Relationship (E-R) Diagrams, keeping in mind the business requirements.
• Rigorously reviewed the data mapping & transformation logic applied to data to check if the requirements are met.
• Assisted in testing the report service REST APIs that was integrated into the 3 Tier Architecture and other front office applications using Swagger Tool.
• Created Test cases, Test Plans & Test Scenarios depicted in documented requirements for UAT testing.
• Assisted the QA team in Test case management using the HP Quality Center (HP QC) tool for agile testing process.
• Worked with the QA team in performing UAT, Smoke, Sanity and Black Box testing as per the requirements.
• Linked all the test detects, bugs and errors to the requirements using the Requirement Traceability Matrix (RTM) and interacted with the QA team to ensure the quality of the platform.
• Created the reports based on the extracted data from databases using different visualization methods such as Histograms, Bar Charts, Pie Charts, Line Charts, Geospatial Maps, Scatter Plots, Gantt Charts using Tableau.

Environment: Waterfall-Scrum Hybrid, Angular 5.0, CSS 3.0, HTML 5.0, JavaScript 1.8.5, Balsamiq, JAVA Platform, Three-Tier Architecture, Microsoft SQL Server, Swagger, MS Excel, Tableau, MS PowerPoint, JIRA, MS SharePoint, JSON in REST Architectural Style, RDBMS, HP ALM QC (Enterprise Edition).

Confidential, Malvern, PA

SR. BUSINESS SYSTEMS ANALYST

Responsibilities:

• Elicited requirements by conducting JAD sessions between technical and business teams, scheduling and conducting one-on-one interviews with Project manager and Risk Managers through questionnaires & surveys.
• Collaborated with the Risk and Strategy team, the technology group, the business management team to understand the compliances and regulations enumerated by Securities and Exchange Commission (SEC) and FINRA.
• Created Gap Analysis by formulating a process model for the As-Is & To-Be Process in managing Margin calls.
• Analyzed and managed the change requests, determined scope, performed impact and cost-benefit analysis, assisted the Product Owner in feasibility studies, market assessments and creating product roadmap.
• Performed Root Cause Analysis and documented all the impact analysis for the issue resolution or escalations.
• Used MS Visio to create Mock-Ups for better visualization and understanding of the Graphic User Interphase (GUI).
• Developed Use cases for different functionalities and Use case, Activity & Sequence diagram using Lucid Chart.
• Used Rally (CA Agile Central) for user story and defect log management. Coordinated with the team to document plans and product knowledge in Confluence. Analyzed the teams Sprint Burn-Down charts and assisted the Scrum Master in calculating the velocity to track the teams progress and to prepare the status reports.
• Actively participated in Product Increment (PI) Planning Meetings & assisted the team in committing PI Objectives.
• Effectively communicated with the Business Systems Analysts and Product Owners of other teams in maintaining the dependencies with in the same Agile Release Train (ART) in the SAFe Framework.
• Used complex SQL queries such as Joins, Distinct, Group-By, Unions, Aggregate functions to extract data for reports and analyze the data for source to target data mapping.
• Reviewed existing stored procedures & user defined functions, supported the application developers by tuning the SQL queries for better performance. Also used functions such as Sum, Min, Max and Count to create views for the development teams as per requirements.
• Documented and tested the report service SOAP API that was integrated to the salesforce CRM using SoapUI.
• Prepared the Requirement Traceability Matrix and interacted with the QA team to ensure the quality of the platform.
• Assisted the QA team in creating the Test plans, Test Scenarios for Systems Testing, Integration Testing & Regression Testing using HP Quality Center (HP QC).
• Formulated Test Case scenarios from the user stories in feature file format for UAT, Automation & Manual Testing.
• Worked with the Quality Assurance Analyst to provide quality assurance of the data imported from external data bases. Retrieved the data using SQL commands from Microsoft SQL server.
• Used HP Quality Center (HP QC) to write test cases, log defects and create an error repository to support the QA/Testing team in testing, tracking defects and systematically manage defects and bugs. Also assisted the QA team in Continuous Integration.
• Created reports using different visualization techniques, charts and graphs in Tableau to show the risks associated with various securities as collateral based on their market volatility.

Environment: Scaled Agile Framework (SAFe) with Scrum at Team Level, Three-Tier Architecture, Angular JS, CSS 2.1, Bootstrap, HTML 5.0, JavaScript 1.8.5, JAVA, Microsoft SQL Server, MS Excel, SoapUI, Rally, Confluence, XML in SOAP protocol, Lucid Charts.

Confidential, Phoenix, AZ

SR. BUSINESS SYSTEMS ANALYST

Responsibilities:

• Facilitated JAD and Focus group sessions and conducted interviews with the Business Owners and stakeholders in the Investment card department for eliciting requirements for various Business Intelligence reports and created documents for analyzing and visualization of data collected from disparate source systems.
• Developed relevant survey questions to be embedded with the automated survey generating tool and set the triggers and timeline for the surveys to be sent out to customers and analyzed the collected survey data.
• Assisted in developing SWOT analysis to identify the state of the organization’s Strength, Weakness, Opportunities and Threats in the field of Investment card business and reward points offering.
• Documented the compliance requirements of Securities and Exchange Commission (SEC), FINRA by facilitating workshop between the Financial advisors, Subject Matter Experts and Technical Team.
• Documented Business Requirement Document (BRD), Functional Specification Document (FSD) and planned the project deliverables, set the product release date in consultation with the Product Owner.
• Designed UI Mock-Up of the reports using Balsamiq tool as part of Proof of Concept, documented the feedback using JIRA and used Confluence to maintain the project artifacts and kept the information radiator updated.
• Created Unified Modeling Language (UML) diagrams to design process flow, use case, activity and sequence diagrams using MS Visio, for the functionalities in the front end of the Enterprise Reporting System.
• Created the user stories based on Data Presentation, Data Augmentation, Data Disclosure, Data Validation and Data Configuration stories, and helped the team in fitting the work in sprints, as it’s a Data Warehouse project in Waterfall-Scrum Hybrid methodology.
• Extensively used SQL queries for data analysis to create reporting requirements by specifying inclusion and exclusion criteria, business rules and data elements to be included into the report.
• Created Reports and Sub-Reports using SQL queries for Drill down, Drill through operations, and also assisted in documenting database, technical Metadata and Business Metadata.
• Collaborated with the data and BI analyst in data profiling. Assisted the development team in data cleansing and data analysis before entering the data into the Enterprise Data Warehouse, using Informatica Tool.
• Created conceptual & logical ER Diagrams, assisted the BI developers in developing the Data dictionary.
• Worked on the Star Schema dimensional modeling in Data Warehouse, to define the fact and dimension tables.
• Worked with the ETL developers to create Source to Stage and Stage to Target Data Mapping documents indicating the source tables, columns, data types, transformations required and business rules & Logic to be applied.
• Rigorously reviewed the data mapping and transformation logic applied to data to check if requirements are met.
• Worked with the Data Architect in identifying Dimensions and the appropriate atomic granularity of data required based on the reporting requirements for the Star Schema design of the Data Mart.
• Facilitated meetings with BI development team in deciding the batch processing method for Extracting, Transforming and Loading Data from source to target Data Marts and Enterprise Data Warehouse.
• Drafted Test Strategy, Test Plans and Test cases with the help of QA team using HP QC software and also assisted in the team in performing User Acceptance Testing.
• Used Tableau for data reporting, Interactive visualization of Geospatial data, studying the trends and patterns of data.

Environment: Waterfall-Scrum Hybrid, Data Warehouse, Tableau, ETL, Informatica, Jira, MS SQL Server, Confluence, OLAP Reporting, Business Intelligence, Dimensional Data modeling, Balsamiq, MS Visio, HP QC.

Confidential, New York City, NY

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Worked with Stakeholders, Wealth Managers, Portfolio Managers and Business Owners to gather requirements, determine feasibility, analyze requirements and recommend design solution options as per the feasibility reports.
• Conducted Risk Analysis and Cost Benefit Analysis to assist the Product Owner & Product Manager in Planning.
• Worked with the Product Owner to define the Roadmap in which features scheduled for each release is both complete and coherent to provide an immersive user experience & validated the data security standards.
• Participated in Business Architecture Meetings to understand the design and functions of the process, recommended modifications to the architecture based on the dependencies and limitations as per the requirements.
• Created UML diagrams to design process flow, use case, activity and sequence diagrams using Lucid Charts.
• Created Mock-ups and wireframes of dashboards for better understanding of developers using Balsamiq tool.
• Used JIRA for user story management & defect management and MS SharePoint for content management.
• Assisted the Product Owner to write user stories based on INVEST criteria and defined the acceptance criteria along with the team. Also helped in guiding the scrum team to follow some of the best engineering practices.
• Assisted the Scrum Master in facilitating the different Scrum ceremonies like Sprint Planning Meeting, Sprint Review Meetings, Product Backlog Refinement Meeting, both at product level & team level for LeSS framework.
• Used data loader for insert, update and bulk import or export of data from Salesforce.com objects.
• Assisted in creating reports and dashboard models in Salesforce Service Cloud based on the Securities Performance Attribution System output as the Wealth Management business uses Service Cloud.
• Performed SQL queries for data analysis, data mapping, for extracting and modifying data on databases.
• Validated REST APIs if they are well formed using Postman and also documented and tested the APIs.
• Worked with the QA team to design and develop test plans, Test Scenarios, and Test Cases to perform User Acceptance Testing, Black Box Testing, Smoke Testing, Sanity Testing and Regression Testing.
• Ensured source code and Test packages are maintained in Jenkins Continuous Integration, tracked the defects in the builds and traced them to the requirements.
• Involved in defining the source to target data mappings, business rules and definitions. Created report models for Ad-hoc reporting and analysis.

Environment: Large Scale Scrum (LeSS) Framework with Scrum at team level, N-Tier Architecture, .Net Framework, MySQL Sever Enterprise Edition, Salesforce Service Cloud, JSON/REST, Postman, Tableau, JIRA, MS SharePoint, Balsamiq, Lucid Chart, HP QC.

Confidential

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Assisted in designing the Anti Money Laundering (AML) documents to ensure compliance efforts are maintained as per government regulations for identifying & analyzing all kinds of suspicious activities in Checking Accounts.
• Conducted Cost Benefit Analysis, identified and documented AS-IS and TO-BE Processes to meet the requirements for Anti Money Laundering compliances.
• Interviewed Business Users, Stakeholders and Subject Matter Experts to determine business needs, gathered and analyzed the requirements from the clients by performed elicitation techniques like JAD and Focus groups.
• Developed several Use Case, Activity, Sequence and Swim Lane Diagram using according to the company’s template for better understanding and implementation for the developers and uploaded them into Confluence for sharing them with the team. Created Mock-ups and Wireframes of dashboards using MS Visio.
• Assisted the Product Owner in creating the user stories & acceptance criteria as per the gathered requirements.
• Assisted the Scrum Master in making the Definition of Done stronger to reduce the Technical Debts in Project.
• Extensively used SQL for accessing and manipulating database systems of source and target systems.
• Created and executed SQL queries to fetch complex data from different tables in remote database using Joins (Left, Right, Inner, Outer, Full Joins), Unions, Views, and other aggregate functions, formatted the results into reports.
• Integrated the source to target system using SOAP API & created SOAP Testcases for different test scenarios.
• Assisted in formulating test documents like Test Plans, Test Summary reports and developed test scenarios & Test cases.
• Used MS Excel for creating interactive visual reports during project lifecycle on performance of securities.

Environment: Waterfall-Scrum Hybrid, Oracle Database Server, JIRA, Confluence, SOAP protocol, MS Visio.

Confidential

PROCESS CONTROL ANALYST/ BUSINESS ANALYST

Responsibilities:

• Gathered functional & non-functional requirements from Stakeholders using various elicitation techniques.
• Acted as a liaison between the stakeholders and the technical team by eliciting & transferring the requirements.
• Held meetings with observers, developers and Subject Matter Experts for pre-analysis and requisites of the project.
• Worked with the Product Owner & other stakeholders in reviewing the working demo of Potentially Shippable Product Increment (PSPI) in Sprint Review Meetings.
• Applied the Six Sigma DMAIC (Define Measure Analyze Improve Control) approach in enhancing the complaints management system. The main goal of the project was to reduce the cycle time of the complaints clearing process.
• Coached the team in understanding and implementing continuous process improvement with in the IT project.
• Helped the IT team in Identifying and measuring different bottlenecks in the whole process of complaints system flow. Also suggested methods to overcome bottlenecks and assisted in implementing them.
• Analyzed & reported the measures such as throughput, cycle time, lead time for complaints in using MS Excel tool.
• Created plans and procedures to improve the complaints management system from start to end of process.

Environment: Scrumban, JAVA, MySQL Enterprise Edition database, MS Excel, MS PowerPoint, MS Word.

Confidential

JUNIOR SQL DEVELOPER

Responsibilities:

• Worked with the project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines to satisfy all the data requirements.
• Analyzed the requirements & discussed with the DB administrators and senior developers on the functionalities.
• Created the Entity Relationship Diagrams to the proposed database linked to Document Management system.
• Implemented database objects such as Tables, Stored Procedures, Functions, Triggers & Views.
• Identified columns for Primary Keys based on the requirements in all the tables at the design time and created them.
• Used DRL and DML commands such as insert, update, select to populate data & generate reports.

Environment: Water Fall Methodology, MySQL Enterprise Edition, Relational Database, MS PowerPoint, MS Excel, MS Word.