SUMMARY:

• 9+ years of professional experience in Financial Services domain as a Business Systems Analyst with a strong understanding of Asset Classes, Simple and Complex Products, and Trade Life Cycle. Expertise encompasses gathering Business Requirements, developing Use Cases, Gap and Root Cause Analysis. Adept in Technical Documentation.
• Experienced in working within traditional and agile Software Development Life Cycle (SDLC) methodologies. Delivered technology projects in Waterfall (traditional), Waterfall - Scrum (hybrid) and Scrum (agile) environments.
• Worked closely with Business Users, Product Owners, Project Managers, Technical teams, Solution Architects, Quality Assurance, Deployment, Maintenance team, DevOps team and Scrum teams through all phases of SDLC.
• In-depth knowledge of Trade Life Cycle, Capital Markets, Asset Classes like Equities, Fixed Income, Commodities (oil, metals, etc), Foreign Exchange, and Products like Swaps, Derivatives, Vanilla and Exotic Options and Futures.
• Worked on projects encompassing Portfolio Management, Wealth Management, and Trade Order Management.
• Thorough understanding of IFRS, US-GAAP, SEC, SOX, FINRA, FinCEN, Dodd-Frank, MiFID, Basel III, CFTC, and OFAC.
• Experienced in Eliciting Requirements, SWOT Analysis, Document Analysis, GAP Analysis, Process Analysis, Risk Analysis, Stakeholder Analysis, Root Cause Analysis, Business Model Canvas, and requirement walkthroughs.
• Facilitated Joint Application Development (JAD) sessions, Focus Groups, Interviews, Brainstorming, project status reports, benchmarking & market analysis, data mining, Job shadowing, Observation and Process Modeling.
• Worked with Subject Matter Experts (SMEs) to understand Key Performance Indicators (KPIs), and Service Level Agreements (SLAs) to improve performance through use of Web services. Proficient in documentation for business & technical complexity - Request for Proposal (RFP), Statement of Work (SOW), Project Initiation Document (PID).
• Adept at creating page mock-ups, wireframes, and dynamic UI prototypes using MS Visio and MockupScreens. Created UML diagrams like Use Case diagrams, Sequence diagrams, and Activity diagrams using Lucidchart.
• Experience in creating interactive, analytical Business Intelligence (BI) dashboards using Tableau and Excel. Proficient in SQL queries like Joins, Subqueries, and Aggregate functions to ensure Integrity between DB and UI.
• Experience in writing SQL queries using SQL Server Management Studio to validate data integrity after Extract, Transform, and Load (ETL) processes in Enterprise Data Warehouse (EDW). Knowledge of Informatica PowerCenter - Data Quality. Exposure to other functionalities like metadata reporting, advanced transformations, & partitioning.
• Collaborated with the ETL developer to create Source to stage and Stage to Target Data mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Exhaustive knowledge of implementing Data warehousing, Data Migration, Schemas, Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice, and Pivot. Strong knowledge of Data-Governance Processes.
• Extensive knowledge of Service Oriented Architecture (SOA), 3-tier and n-tie r architecture systems. Extensible Markup Language (XML), JavaScript Object Notation (JSON) and Asynchronous JavaScript and XML (AJAX).
• Adept at the technical documentation of web service Application Programming Interfaces (APIs) such as Representational state transfer (REST), and Simple Object Access Protocol (SOAP) using Swagger.
• Adept at collaborating with QA/Testing team to develop Test plans, Test scenarios, Test cases, and Test objectives.
• Collaborated in User Acceptance testing (UAT), and Functional (Black Box). In-depth knowledge of Test Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD).
• Collaborated with the Quality Assurance team in all phases of Software testing Lifecycle (STLC) for project success.
• Undertook a comprehensive review of test cases to ensure their integrity and assist the Quality Analyst and Testing team to perform unit testing, system testing, integration testing, white box, grey box and black box testing.
• Participated in Manual Testing and Automated Testing spikes facilitated by testing team during the Testing phase.
• Assisted the Product owner in writing Epics and then in slicing the epics using vertical and horizontal techniques to develop User stories. Facilitated Product Backlog grooming and participated in Scrum Ceremonies. Analyzed scrum reports like Burn Up/Burn Down Charts, Impediment list, and Sprint Report to facilitate successful project delivery.
• Assisted the Project Manager in budgeting, tracking and coordinating with development teams for project success.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Hybrid (Waterfall - Scrum), Agile - Scrum

Process Modelling Tools: MS Visio, Mockup Screens, Draw.io, Lucid Chart

Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis, Financial Reporting, Valuation, Pricing, and Budgeting

Requirement & Project Management: MS Project, Rally (CA Agile Central), JIRA, Team Foundation Server (TFS), MS Word

Testing Tools: HP QC v10.0, HP ALM V11.5, Cucumber, Jenkins v2.4

Financial Tools: Bloomberg Terminal, Bloomberg B-Pipe, Thomson Reuters, Morningstar.

ETL Tools: Informatica Power Center v9.x

Data Analysis / Reporting: Tableau, MS Excel, SPSS, SSAS, SSRS

Databases: Microsoft SQL Server, Oracle 10g,11g

Data Modelling: Logical/Physical/Dimensional/E-R, Star/Snowflake Schema

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Business Systems Analyst

Responsibilities:

• Collaborated with the Risk & Strategy team, the Technology group, and the Business management team to understand the compliances and regulations enumerated by Securities & Exchange Commission (SEC), and Financial Industry Regulatory Authority (FINRA) for ensuring data integrity and data security of investor information.
• Interviewed business users, stakeholders, Subject Matter Experts and performed extensive document analysis to develop a thorough understanding of end to end business processes involved in portfolio management.
• Identified and mapped stakeholders to RACI (Responsible, Accountable, Consulted, and Informed) matrix to ensure smoother change process and to clarify roles and responsibilities in the cross-functional project environment.
• Created an exhaustive Gap Analysis by formulating a process model for the As-Is and To-Be processes.
• Elicited requirements by facilitating Joint Application Development (JAD) sessions between technical and business teams, conducting Focus Groups, scheduling one-on-one Interviews with managers, and by analyzing documents.
• Identified dependencies and documented functional, non-functional, data and user interface requirements in Business Requirements Document (BRD), and Systems Requirements Specifications (SRS) documents.
• Developed Use Cases and prepared UML diagrams like Use Case, Sequence, and Activity using MS Visio.
• Transformed requirements into user stories and assisted the product owner in determining Acceptance criteria.
• Used JIRA for user story management, issue tracking, and requirement traceability. Co-ordinated with the team to document plans and product knowledge in Confluence. Analyzed the teams Sprint Burn-Up and Burn-Down Chart, and assisted Scrum Master in calculating their velocity to track progress and prepared the status reports.
• Identified structured and unstructured data sources for ingesting the data in the Hadoop Distributed File System (HDFS). Used Sqoop to load structured data from databases into HDFS and Flume to load streaming data.
• Worked with the Development Team to create Source to stage and Stage to Target Data mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Developed Tableau dashboards incorporating Waterfall charts, Bubble charts, Heat Maps, and Histograms for portfolio managers viewing their investments in the front office and senior management viewing risk exposures.
• Tested the Hadoop data lake using Data Manipulation Language (DML) statements in SQL to ensure data has been stored correctly. Also used subqueries to improve the performance tuning of the new data system.
• Created technical documentation for REST APIs using Swagger. Tested request and response, source and targets for web services using Swagger. Good understanding of WSDL and service level agreements (SLAs).
• Used HP QC to write test cases, log defects and create an error repository to support QA/testing team in testing, tracking defects and systematically manage defects and bugs. Assisted the team with continuous integration.
• Created feature file following given, when, then format in Cucumber to enable manual and automation testing.
• Assisted the Quality Assurance team in the creation of Test Plans, Test Scenarios, and Test Cases. Mapped test cases to business requirements/user stories in the Requirements Traceability Matrix (RTM).
• Conducted User Acceptance Testing (UAT) against test cases and acceptance criteria and actively participated in and facilitated testing of the system during Smoke testing, Black Box testing, and Regression Testing.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: Waterfall-Scrum Hybrid, MS Office 2016, JIRA v6.4, Confluence v5.9, RedHat JBoss BPM Suite, MS Visio, Hadoop, Hortonworks Data Platform (HDP) v2.5, Apache Sqoop v1.4.6, Flume v1.5.2, Kafka v0.10, HBase v1.1.2, HDFS, Tableau v9.3, REST API, HP QC 12.55, Bootstrap v3.3.4, HTML5, CSS3, Web Services.

Confidential, Smithfield, RI

Sr. Business Systems Analyst

Responsibilities:

• Collaborated with the Compliance team, and the Business management team to enumerate the compliances and regulations enforced by SEC, FINRA for data reliability and data security of investors and their information.
• Facilitated meetings with the Business Managers, and Subject Matter Experts for analysis of the project parameters.
• Hands on experience in gathering requirements through JAD Sessions, Interviews and Brainstorming sessions for implementing Forex options, OTC options and interfaces in the inherent trade order management system.
• Developed detailed Requirements, Business Rules, and Conditions, Business Capability for systems integration. Undertook exhaustive analysis to verify systems meet ESB requirements and validate systems compatibility.
• Identified & specified source data fields from Salesforce Sales Cloud application to the target fields in optimization and routing strategy platforms by specifying data layer mapping transformations for order management.
• Populated Functional Requirements Document (FRD) and System Requirements Specification (SRS) with functional, and technical requirements to enable the development team to better understand the requirements.
• Actively participated in document reviews and document analysis and incorporated learnings in Business process re-engineering, Business process modeling using Use Case diagrams, Activity diagrams, and Process Flow diagrams.
• Assisted the Project Manager/Scrum Master in all phases of Project Management in the Waterfall-Scrum Hybrid approach. Instrumental in developing user stories from functional requirements documented in the BRD.
• Assisted the Product Owner in prioritizing the product backlog using Business Value and MoSCoW technique.
• Extensively used MS Project to develop work breakdown structure (WBS) and Gantt Charts. Tracked User stories in JIRA and updated Technical documentation in Confluence. Demonstrated a sense of urgency and responsiveness to complete the work and solve problems, with a strong drive to persevere when faced with ambiguity.
• Created Data Mapping Document for Forex platform integration into multiple systems, detailing the data elements and attributes in the request/response web services and exception. Specified data interchange formats (XML, SOAP, FIX protocols) and data transformation for compatibility of messages between source systems and target systems.
• Created XML Schema Definition (XSD) document to enable developers to verify fields/attributes in XML document.
• Used SQL queries such as Inner Joins, Left Joins, Right Join, Union, Union All, to extract the reports in SQL Developer and analyze the data for source to target data mapping. Utilized Co-related and Un-correlated Subqueries.
• Documented web service APIs for FIX, Bloomberg B-Pipe, Reuters using specifications.
• Wrote test cases, logged defects and created an error repository to support QA/testing team in testing activities.
• Performed User Acceptance Testing (UAT) and assisted the Quality Assurance team in writing Test Plans, Test Cases and Test Scenarios to facilitate project development using Behavior Driven Development (BDD) processes.
• Used HP ALM for logging project planning activities, unit testing, and deployment activities. Assisted the development and testing team in writing test cases for Unit testing, Integration, Smoke testing, and Sanity testing.
• Co-ordinated with the testing team in their Regression testing, Grey box testing, and Black box testing. Used Postman to test the request and response frequencies for source and targets for web services.

Environment: Waterfall-Scrum, MS Office 2016, Lucid Chart, MS Project 2016, MS Share Point 2016, Mock-Up Screens, JIRA v6.4, Confluence v5.7, HP ALM v12.53, Web Services, SOA, HTML5, XML, Java, Mule ESB 3.7.3, jScript/jQuery, API, Web Methods, SOAP, WSDL, Trading, Capital Market, Oracle 11g, Salesforce Spring 2016, SSMS 2016.

Confidential, Santa Clara, CA

Sr. Business Systems Analyst

Responsibilities:

• Documented the compliance requirements of SEC, FINRA and Financial Crimes Enforcement Network (FinCEN) by facilitating an informal workshop between the clients Financial Advisors, SMEs and the Technology team.
• Elicited and analyzed requirements from business users through one-on-one interviews , document analysis, and use cases . Documented requirements in business requirement document (BRD) and System Requirement Specification (SRS). Built relationships with financial advisors to ensure their needs are well documented.
• Gathered requirements by facilitating focus groups for implementing MuleSoft (ESB) interfaces.
• Prepared the Requirement Traceability Matrix and interacted with QA team to ensure the quality of the platform.
• Mapped Salesforce Sales Cloud source data to target wealth management advisory platform application by specifying source data fields that will be queried and target data layer mapping transformations required for view.
• Assisted the development team in identifying source and target data elements in the database.
• Developed Tableau based Wealth Advisory dashboards incorporating Waterfall charts, Heat Maps, and Histograms for Relationship managers to effectively advise clients on asset allocation and tax/estate planning strategies.
• Designed Test Plans, Test Strategy and Test Cases for User Acceptance testing (UAT) with the help of QA team.
• Assisted the QA team in conducting Unit testing, System testing, Integration testing and Regression Testing using the Selenium testing tool. Involved in Smoke testing and Sanity testing to ensure proper functioning of the critical functionalities of the software builds developed by the development team in a time-boxed agile environment.
• Assisted the testing team in writing test cases, logging defects and creating an error repository to support them in testing, tracking defects and systematically manage defects. Assisted the team during continuous integration
• Assisted the development team in the technical documentation of requests and responses from web service APIs.
• Manually tested web service and assisted the Quality Analyst team in unit testing and automation testing.
• Participated in Product Backlog Grooming, Daily Scrum meetings, Sprint Planning, and Sprint Review. Analyzed the Sprint Burn-down Charts to monitor the completion of work within time-boxes.

Environment : Waterfall-Hybrid, SOA, MS Project 2013, MS Office Suite 2013 (Word, Excel, PowerPoint, and Visio), HTML, CSS, JavaScript, Java, JIRA v4.3, Selenium, Tableau v 8.2.10, Oracle 11g, XML, Java, jScript/jQuery, API, Web Methods, SOAP, WSDL, Wealth Management, Portfolio Management, Cloud, Salesforce Winter 14.

Confidential, Irving, Texas

Sr. Business Systems Analyst

Responsibilities:

• Facilitated JAD sessions and conducted interviews for eliciting requirements for various Business Intelligence reports and created documents for analyzing and visualization of data collected from disparate source systems.
• Documented elicited requirements in Functional Specification Document (FSD) and System Requirement Specification (SRS). Created a sample of data prototypes for approval from sponsors and business owners.
• Assisted the Product Owner (PO) in transforming Business requirements into User Stories. Participated in Product Backlog Grooming Sessions and assisted the PO in slicing epics into stories and then prioritizing the stories.
• Created Data/Process Flow Diagrams, Sequence Diagrams using UML methodologies for easy understanding.
• Created conceptual, and logical entity relationship (ER) diagrams. Also developed the data dictionary.
• Collaborated with the Data Analyst in Data Profiling. Assisted the development team Informatica Power Center’s Data Quality for Data Cleansing and Data Analysis before loading the data into the Enterprise Data warehouse.
• Facilitated a meeting between development and technical team in deciding the batch processing method for extracting, transforming and loading (ETL) the data into target database using Informatica Power Center.
• Worked with the ETL developer to create Source to stage and Stage to Target Data mapping documents indicating the source tables, columns, data types, transformations required and business rules and logic to be applied. Rigorously reviewed the data mapping and transformation logic applied to data to check if requirements are met.
• Used Dimension Modeling like Star Schema, and Snowflake Schema in designing the data warehouse to define the relationship between the fact tables and dimension tables, identifying primary keys and surrogate keys.
• Created SQL queries in Toad to perform data analysis, data validation and data manipulation operations.
• Used Tableau for data reporting, studying the trends and patterns and for data forecasting.
• Assisted the Project Manager and the development team in all phases of Software Development Life Cycle (SDLC).
• Drafted test strategy, Test Plans and Test Cases, and exit strategy by working closely with the quality analyst team.
• Led the User Acceptance Testing (UAT) efforts by conducting UAT and logging defects on HP ALM.

Environment: Waterfall - Agile Methodology, Oracle 10g, Toad, Socket Programming, MS Visio, MS Office Suite, Java, XML, SSMS 2014, Jira v 1.0.2.8, HP ALM, Informatica Power Center 9.5.1, Tableau v 6.0.9.

Confidential

Business Systems Analyst

Responsibilities:

• Collaborated with the Risk team, and the Technology management team to comprehend the regulations applied by the SEBI, and RBI on the over the counter market for commodities and derivatives.
• Initiated requirements gathering by observing the asset managers work in their daily environment to glean unsaid business needs and requirements. Facilitated Focus Groups, and Interviews with stakeholders to gather requirements and end-user perspectives in order to identify deficiencies and areas for enhancement.
• Identified As-is and To-be process maps as part of Gap Analysis for new functionality requirements. Assisted Project Manager and Senior Business Analysts in performing Feasibility and Complexity Analysis.
• Assisted the Product Owner to write User Stories, Acceptance criteria and to Prioritize the Product Backlog by using prioritization techniques like MoSCoW technique to ensure the system delivers maximum business value to client.
• Participated in Daily Standup meetings and worked with the team in resolving issues that could potentially cause delays in the sprint completion. Attended Scrum Framework Knowledge sessions facilitated by the Scrum Master
• Used MS Visio to create Mock-ups for better visualization and understanding of the Graphic User Interface (GUI).
• Performed Root Cause Analysis and documented all the impact analyses for issue resolutions or escalations.
• Created XSD document to enable developers to verify fields/attributes in Extensible Markup Language document.
• Documented web service APIs Bloomberg B-Pipe, CRISIL Ratings and Regulatory authorities using Swagger
• Used complex SQL queries such as Joins, Distinct, Group By to extract the reports in SQL Developer and analyze the data for source to target data mapping. Utilized Subqueries, for Financial Information Exchange (FIX) data analysis.
• Worked with the ETL developer to create Source to stage and Stage to Target Data mapping documents indicating the source tables, columns, data types, transformations required and business rules and logic to be applied.
• Assisted the QA team in formulating the Test Strategy in-line with Test Driven Development (TDD). Also involved in formulating Test Plans, creating Test Scenarios for Unit testing, System testing & Integration testing.
• Formulated Test Case scenarios from the user stories in a feature file format for automation and manual testing.
• Created User Acceptance Testing (UAT) test cases and assisted senior business analysts in conducting the UAT tests.

Environment: Agile (Scrum) Methodology, Oracle 10g, HTML, CSS, JavaScript, MS Visio, MS Office Suite 2010, Java, XML, SQL, JIRA, HP ALM v 11, Web Services, Service Oriented Architecture (SOA).

Confidential

Data Analyst/Business Systems Analyst

Responsibilities:

• Elicited business requirements by conducting brainstorming sessions with business and management team.
• Facilitated interviews and focus groups with business managers to develop Key Performance Indicators (KPIs).
• Documented the functional and business requirements in a Business Requirements Document (BRD).
• Analyzed and managed change requests, determined Scope, performed impact and cost-benefit analysis, assisted in Feasibility studies, Market Assessments, Product Roadmaps, Risk analysis and maintained Risk Register.
• Used SSRS, Power Pivot, and SSAS to develop and implement multiple data analyses. Implemented data collection systems and other strategies that optimized statistical efficiency and quality. Designed BI solutions using SSIS.
• Developed SQL stored procedures to extract data for reports rendered in SSRS 2008 R2, or for ad-hoc querying purposes. Supported analysis of data through traditional ROLAP, and operational data store environments.
• Co-ordinated with the Business team to understand business processes and prepared Use cases, articulating the business need for Data Analysis, establishing successful data and analytics transformation and projected impact.
• Responsible for the cleansing of data to ensure data integrity and business logic are transferred during data mining.
• Analyzed highly complex and massive data sets by and performed ad-hoc analysis and data manipulation.
• Responsible for interpreting data and analyzing results using statistical techniques, identifying patterns and trends in data sets and reporting the results back to the senior management of the various lines of business (LoB).

Environment: MS Office Suite (Excel 2010, Word 2010, PowerPoint 2010) Windows XP/ME, Power Pivot, SSAS, SSRS 2008 R2, MS SQL Server 2008 Management Studio

Confidential

Data Analyst

Responsibilities:

• Created and generated reports using SPSS and Excel to extract data for analysis using filters based on the analysis.
• Worked on complex information model, logical relationships, and the data structures that support different Lines of Business of our client. Prepared RFIs and RFPs to acquire data from primary and secondary data sources.
• Assisted the Senior Data Analyst and in managing master data, including creation, updates, and deletion of new data generated by the lines of businesses.
• Built SQL queries for CRUD operations, triggers, cursors, stored procedures, functions etc.
• Worked with Quality Assurance Analyst to provide quality assurance of the data imported from data vendors.
• Assisted Senior Data Analyst in project initiatives for data integrity by interacting with Business users.

Environment: MS Office 2007 (Excel, Word, PowerPoint) Windows XP, SPSS, MS SQL Server 2005.