PROFESSIONAL SUMMARY:

• Over 8 years of professional experience in M&A, Asset Management, Wealth Management and Prime Brokerage domain, as Sr. Business Analyst, Lead Business Analyst. Detail oriented, analytical and inquisitive with excellent oral, written communication skills; ability to work independently and with the team.
• Strong understanding of Software Development Life Cycles (SDLC) processes: Traditional and Agile methodologies such as Waterfall, Scaled Agile Framework (SAFe 4.0), Large Scale Agile Framework (LeSS), Scrum, Extreme Programming (XP), Scrum - Waterfall Hybrid, Rational Unified Process (RUP), Kanban.
• Expertise in conducting quantitative and qualitative analysis: Risk Analysis, Impact Analysis, Cost-Benefit Analysis, ROI Analysis, SWOT Analysis, GAP Analysis (AS-IS TO-BE), PESTLE, MOST, Porter’s five forces, Business Process Modeling.
• Capital Markets Investment Vehicle knowledge: Equity, Fixed Income, Asset-backed securities, Collateralized Debt Obligation, Swaps, CDOs, Futures, Forwards, Options.
• Knowledge of risk measurement techniques: Duration, Convexity, Standard deviation, Beta, Value-at-Risk (VaR), to measure Credit risk, Market risk, Liquidity risk, Interest rate risk, Business risk, Systematic/ Unsystematic risk.
• Knowledge in with various regulations and compliances such as; FINRA, Dodd-Frank, Basel II & III, SEC, GAAP, IFRS, Sarbanes-Oxley (SOX), FINMA, Consumer Protection Act, Bank Secrecy Act BSA/AML and KYC, FDR, Fund Accounting.
• Understanding of Cyber security systems: EU-US privacy shield, General Data Protection Regulation (GDPR) compliance, AES 256-bit encryption, and Transport Layer Security (TLS) 1.2 protocol.
• Proficient in conducting and facilitating Requirements Gathering using diverse elicitation techniques such as JAD Sessions, Brainstorming, Interviews, Requirement Workshops, Focus Groups, and Prototyping.
• Excellent writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specifications (SRS).
• Extensively used JIRA, Confluence and other Atlassian tools for managing User stories and contributed in Scrum Ceremonies; Breaking down business requirements using DEEP, DIVE, 3Cs, INVEST, SMART, writing user stories/epics.
• Extensively experienced in creating Prototypes: Wire-Frames and Mock-Up screens to visualize Graphical User Interface (GUI); Business Process Model, UML Modelling like Activity Diagrams, Sequence Diagrams, and Use Case Diagrams, Process Workflow Diagrams, Class Diagrams using Rational Rose, Lucid Chart, Balsamiq, MS Visio, MoqUps.
• Better understanding of relational database structure - Entity, attributes and relationships; ER diagrams (Chenn, IE diagrams); 3NF (BCNF) Normalization, Denormalization. Assisted in creating conceptual and logical data model (partial).
• Hands on experience in performing queries on SQL database - Oracle, MySQL, SQL Server, using Joins, Views, Sub queries and Aggregate functions with good understanding of Table, Schema, Procedures, Functions and Triggers.
• Experience in working with dimensional modeling tools - IBM InfoSphere; designing star/snowflake schema (facts and dimensions), and determining data warehouse architecture based on business needs.
• Expertise in ETL tool Informatica Power Center including Repository Manager, Designer, Workflow Manager, Workflow Monitor. Worked with mappings using various transformations like filter, joiner, Router, Source Qualifier, Expression, Union, Unconnected/Connected lookup, Aggregator, Sorter, Rank etc.,
• Extensive implementation knowledge of Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice, and Pivot. Acquaintance of Data-Migration and Data-Governance Processes.
• Experience on Azure Data Service and Products: Data factory, Data lake, Azure Batch, Dockers, Kubernetes, Virtual Machines, Azure express route, Azure traffic manager.
• Proficient in API architectures, authentication mechanisms: HTTP, OAuth, OFX, XML, JSON, REST and Soap APIs. Used SOAP UI, REST UI and Postman for API testing; Swagger tool for API documentation; Mulesoft for API integration.
• Strong knowledge in Software Testing Lifecycle (STLC), review/approve test plans & test cases, use of testing tools like HP-ALM/HP-QC, Cucumber, LoadRunner and Defect tracking mechanism and coordinate User Acceptance Test (UAT).
• Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using Jenkins and Bamboo
• Demonstrated experience in designing and building customized reports and interactive dashboards, using Tableau 10.x/9.x/8.x desktop and server; configure report publish and subscription, performance optimization.
• Thorough understanding of Business Intelligence (BI) and experienced in creating interactive, analytical dashboards using Power BI, Tableau, IBM Cognos, Splunk, Kibana and Spotfire for decision making.
• Understanding on big data concepts and tools such as Hadoop, HDFS, Hive, Impala, Flume, Sqoop, and MapReduce, YARN, Apache spark (MLIB, Spark SQL), Dockers.

TECHNICAL SKILLS:

Project Management Tools: JIRA, Confluence, MS Project, MS Share Point, Microsoft Office Packages

SDLC Methodologies: Agile (SCRUM/ SAFe/ Kanban/ XP), Waterfall, Spiral, Rational RUP

Databases: HDFS, DB2, Oracle, SQL Server 2012, SQL Server 2000, MS Access, Flat files

Testing Tools: HP ALM/ QC, Swagger, SOAP UI, HP Load Runner, Cucumber, Postman, Selenium

Web Services API: JSON, REST, SOAP, XML, OFX, OAUTH, Bloomberg B-Pipe/ Server/Desktop, EMSX

Technologies: AWS Redshift, Amazon S3, Microsoft Azure, Salesforce, Apache Hadoop

ETL & Reporting tools: Informatica Power Center, Tableau, Power BI, Splunk, Kibana, Infosphere

Big data tools: Apache Spark 2.3.0, Apache Pig, Apache HBase 1.1.2, Apache Kafka 1.0.0, Apache Flume 1.5.2, Apache Sqoop 1.4.6 Apache Oozie 4.2.0, Apache Zookeeper 3.4.6

Operating Systems: Windows XP/ 7/ 8/ 10, Mac OS X/ Sierra/ High Sierra/ Mojave

Design & Version Control: MS VISIO, Smart Draw, CA Erwin, Rational Rose, Jenkins, Balsamiq

PROFESSIONAL EXPERIENCE:

Sr. Business Systems Analyst

Confidential, Dover, New Hampshire

Responsibilities:

• Improve the existing valuation software to cater to client business needs in a LeSS (large Scale Agile framework).
• Worked with the Financial and Valuation analysts to understand the M&A valuation process, buy side/sell side operations, deal sourcing, deal shopping, due diligence, market analysis Confidential accounting and FRTB reporting.
• Worked with cyber security team to understand data protection systems: EU-US privacy shield, General Data Protection Regulation (GDPR) compliance, AES 256-bit encryption, and Transport Layer Security (TLS) 1.2 protocol.
• Prepared GAP Analysis, Risk Analysis, Cost-benefit Analysis, and Porter's Five Forces to understand the AS-IS and TO-BE process for current Discount Cash Flow (DCF), Free Cash Flow (FCF), WACC, and Net Present Value (NPV).
• Developed an understanding of work flow for Buy side organizations: trade/position strategy, ad-hoc liquidity modeling, scenario-based position strategy modeling. Sell side organizations: risk modeling.
• Held meetings with the Management, Portfolio Managers, Quant Analysts, Validation Analysts for analysis and determining pre-requisites for the Project. Assisted Product Owner in conducting JAD Sessions in a multi-stakeholder environment to resolve any outliers and ensure scope alignment.
• Participated in Product vision meeting, Initial Backlog grooming meeting and assisted Product Owner in breaking down Product Vision into Epics/User stories using DEEP, DIVE, 3Cs, INVEST, SMART techniques.
• Extensively used MS SharePoint to manage web applications, create site collection, configure using quota template and baseline templates. Monitored workflow using tasks board and task lists, for Product backlog and user stories.
• Worked with the scrum development to understand building Java micro services in Microsoft Azure cloud.
• Integrated Azure AD (Active Directory), ADB2C with Salesforce to ease the customer sign in and identification process.
• Used Data loader for insert, update and bulk import or export of data from Salesforce S-Objects used it to read, extract and load data from a comma-separated value (CSV) file.
• Performed extensive Prototyping, UML diagram using MS Visio; Held Requirement Churn during the project by performing Impact Analysis, feasibility analysis and maintained the Triple Constraints.
• Facilitated changes to module design; prepared documentation necessary for change; and coordinated release of changes for change management control, re-baseline artifacts.
• Performed Source system exploration and data Profiling to avoid anomalies using SQL query on MS SQL Server.
• Assisted in creating metadata definitions and source-to-target mapping; Involved in data modeling that is conceptual and logical using MS Visio; and handoff with the ETL development team.
• Used Azure Enterprise integration Service - SQL Server Stretch Database to migrate transactional database with cold data securely to Azure Cloud.
• Worked on SOA, API architecture as well as communication protocols, XML, JSON, XML Schema, XSLT, Web Services (REST, SOAP, WSDL), Strong understanding of UNIX concepts and common network protocols.
• Performed API Documentation for SEC APIs, DTCC APIs, MORNINGSTAR APIs, OPEN APIs using SWAGGER TOOL and testing using POSTMAN for both POST and GET call.
• Worked on Bloomberg B-Pipe API installation - blpapi.jar local file, bpipe matlab connection to access Bloomberg DC.
• Conducted weekly meetings with the project team and weekly status reporting (Score Card); prepared an overall QA status report and shared it with the Team/Senior management using HP ALM 12.5 installed to Azure cloud.
• Assisted the QA team in preparing Test Cases, Test Plans for all the processes. Using HP ALM executed Black Box Testing, Regression Testing and User Acceptance Testing (UAT).
• Tested application in different environment and Performed cross browser testing using Selenium server.
• Understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management and Report Delivery. In-depth knowledge of SQL queries like JOINS, AGGREGATE, INDEX.
• Created reporting dashboards on Tableau, using OLAP cubes for a comprehensive look on deals/prospects for Investments Analysts and Portfolio Managers.

Environment: LeSS, MS Visio 0.15, MS Visio, MS Office Suite, MS Sharepoint, TFS, Salesforce, Bloomberg B-Pipe, MS SQL Server, MS Project, SELENIUM, Java micro services, HTML, REST, SSO, SAML, postman 5.0, swagger 3.0., HP ALM 12.5, HP UFT, Tableau 10.0, Microsoft Azure Cloud, Azure Batch, Azure AD, Azure SQL Server Stretch Database.

Sr. Business Analyst

Confidential, NYC, NY

Responsibilities:

• Worked in a Scaled Agile Framework (SAFe 4.0) environment that functioned as a Lean Enterprise by implementing agile principles across the organization through DevOps & Release on Demand, and Team & Technical Agility.
• Developed understanding of the proprietary Quartz platform (Java based platform with Python cover) technical infrastructure: Qz desktop, Qz Dev, Qz trades, QFS/ Pricing and risk.
• Worked closely with SMEs to understand Ivol functionality - Computing Greeks (Delta, Gamma, Vega, Theta), Implied volatility using Black-Scholes-Merton model and Monte Carlo Simulation, Partial Differential Equation (PDE), using Python libraries - Num.py, Sci.py and Pandas.
• Gained understanding of regulations and compliances such as FINRA, Dodd-Frank, Basel II & III, SEC, GAAP, IFRS, Sarbanes-Oxley (SOX), FINMA, Consumer Protection Act, Bank Secrecy Act BSA/AML and KYC, FDR, Fund Accounting.
• Identified and documented business needs in a multiple-stakeholder environment across BOA Global Markets in Portfolio management, Risk management, and investment decision making and analyzed re-usability of an existing module by performing GAP analysis, Feasibility analysis, Impact Analysis, SWOT Analysis.
• Worked at the Team level and Program level in breaking down high level Epics, Capabilities into Features and User stories based on larger context of Agile Release Train (ART) and Solution Train.
• Worked in a DevOps environment to set up Continuous Integration and Continuous Deployment pipelines (ART);
• At the Team level, assisted team in implementing Team & Technical Agility through Built-In Quality, Lean UX feature development, TDD, BDD, agile modeling.
• Used JIRA for documenting the Features, User stories, Tasks; Monitoring tasks using Kanban boards; and Reporting. Integrated Confluence to create a collaborative workspace for the scrum development team.
• Assisted data scientist to perform data migration from SQL DB to Object data store. Phased migration that involved simultaneous data ingestion into both database for a stipulated time.
• Performed SQL queries on relational database for data validation, identify relationships, facts and dimensions.
• Analyzed source systems from front end trading, middle management and risk analytics to perform ingestion into Hadoop Distributed File System (HDFS).
• Assisted in using visual modeling tools to communicate requirements effectively using UML diagrams, UI Wireframes using BALSAMIQ.
• Understanding of change management process, conducted impact analysis, risk analysis for requirements churn.
• Documented NASDAQ APIs, SEC APIs, BLOOMBERG APIs, NYSE APIs, FACEBOOK APIs, TWITTER APIs, Open APIs for social media; OFX and OAUTH protocols; using SWAGGER and Tested API using POSTMAN tool.
• Used IETF Standards (Internet Engineering Task Force) for JSON RFC7159. Documented JSON APIs for Python based Quartz system, using JSON library.
• Collaborated with the Quality Assurance team in design and develop test plans and test cases for, Functional Testing and Regression Testing; fixed the bugs arising during the testing phase.
• Assisted data scientist in building algorithms and models for predictive analysis and sentimental analysis on Apache Spark by using Python APIs, also involved in the User Acceptance Testing (UAT) and performance testing of Models and algorithms based on market data from equity markets for internal customers - risk engine, global markets analysis and macroeconomic predictions.

Environment: SAFe 4.0, Big Data, Qz Dev, Qz Desktop, Python, Num.py, Sci.py, Pandas, Model.lib, C++. C#, HDP 2.6.5 (Apache Spark 2.3.0, Apache Pig, Apache HBase 1.1.2, Apache Kafka 1.0.0, Apache Flume 1.5.2, Apache Sqoop 1.4.6 Apache Oozie 4.2.0, Apache Zookeeper 3.4.6), Splunk, MS Project 2013, Office 365(Word, Excel, PowerPoint and Outlook), Jira 7.12.0, confluence 6.4, BALSAMIQ, Swagger 3.5., POSTMAN, JIRA Bitbucket, Jenkins, INFORMATICA IDQ.

Lead Business Analyst

Confidential, Maryland, MD

Responsibilities:

• Participating in business requirements session with different work streams and technology teams and analyzed gathered requirements, verified requirements and created business requirement document (BRD).
• Designing Proof of Concept (POC) to identify baseline, adverse, and serve scenarios.
• Interacted with the Business Owners and SMEs along with Risk Managers and Project Architects, to gather client specific business requirements and translate them in various business artifacts for the technical team.
• Experienced in API Integration and SSO into a SOA, web orchestrating service applications through the SSO services.
• Conducted user interviews, facilitated JRP and JAD sessions to better understand the business domain, requirements and project scope and performed GAP analysis and identified AS- IS and TO-BE state to identify business requirements
• Performed Data Validation testing for accuracy of the data by creating/executing the SQL statements against the database table to the Graphical User Interface (GUI) data.
• Planned and defined system requirements to create Use Case, Use Case Scenario and Use Case Narrative Created varied dynamic layouts for categorized audience and user interface and user experience using HTML and CSS.
• Experience in developing Work Flows and Activities, Rule based Business Process Management using Pega Rules Process Commander (PRPC), Decision tables, Decision maps, Declarative expressions, Constraints, and Indexes.
• Designed DFD, ER and Wireframes using modelling tools using Visio.
• Prepared Business Process Model for all activities carried on by the business from the conceptual to procedural level.
• Effectively utilized prototypes to demonstrate and verify the behavior of the system and for user approval.
• Created RTM Artifact to make sure all the requirements are covered with respective test cases & helped UAT team.
• Used RESTful and SOAP web services to interact with different applications and machines internally and externally.

Environment: Office 365, MS Word, MS PowerPoint, MS Excel, MS Visio, MS Outlook, Oracle, SQL, Micro strategy, Tableau Desktop, Jira, Postman, Balsamiq.

Business Analyst

Confidential

Responsibilities:

• Participated in the identification, understanding of Business Requirements and authored the Business Requirement Document (BRD) and documented business processes and business rules.
• Created and maintained User Stories by workshop, interviewing, brainstorming and met with the business users to communicate the requirements to development and testing teams.
• Understood and performed the AS-IS and TO-BE business process and developed the GAP Analysis.
• Prepared Use Case Diagrams, Activity Diagrams, and Sequence Diagrams from conceptual to procedural level in MS Visio. Assisted in concocting Conceptual and Logical Data Models and created mockups in Balsamiq
• Consulted the business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs and tracked & monitored them using JIRA.
• Conducted in JAD/JAR sessions, got requirement specification documents including Project Objectives, Business Rules Conducted Daily Stand-up Meeting, created stories/tasks, assigned tasks to developers & updated the Burn-Down Chart.
• Proficient in breaking down large user stories into multiple independent stories.
• Involved in Walk-through sessions with developers and gave presentations to help understand the end user needs.
• Experience in SQL queries to retrieve and validate data, prepared for data mapping document.
• Performed Data Analysis by parsing XML, comparing different XML files and running SQL queries.
• Collaborated with QA team to create test plan and test cases, approved test cases for functional requirements verification, and review test evidences for new functions to make sure all requirements are met.
• Performed UAT testing to validate system & application performance. Developed User Manuals & Support team manuals.

Environment: Agile Methodology, SharePoint, Microsoft office suite 2013, MS Visio 2013, SQL Server 2012, TFS, SSRS, Jira, Zephyr, Balsamiq.

Business Analyst

Confidential

Responsibilities:

• Understand the current portfolio management system, different financial instrument, different venues based on that perform GAP analysis, Cost benefit Analysis (CBA), feasibility analysis, to identify AS-IS and TO-BE.
• Gathered requirement using different elicitation techniques like a workshop, interviews, document analysis. prepared business requirements documentation (BRD), System Requirements Specifications (SRS).
• Conducted detailed and comprehensive Business Analysis by working with the client IT staff, project managers, supervisors, SME's, and other stakeholders to identify the system, operational requirements, and improvements.
• Created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and web Page Mock-Ups using Microsoft Visio and Lucid chart.
• Assisted in Designing conceptual and logical data models, creating metadata definitions, and creating a source-to-target mapping, coordinating data model review and handoff with the ETL development team.
• Helped data warehouse team to identify the different sources data for various financial information such as Ticker information, news feed, financial ratios, peer companies, shareholding, future, and option. Assisted in Designing conceptual and logical data models, Data mapping, creating metadata definitions.
• Experienced with Setting up the startup files for the loading the libraries and configuration.
• Involved in preparing Test plans, Test cases, Use Case Scenarios, Test case execution using selenium.
• Participated in Bug-Review meetings with software developers, QA engineers, managers, suggested enhancements to the existed application from business perspectives, providing solutions to existing bugs.
• Performed data analysis with SQL queries for retrieving, maintaining and organizing data with commands like select, join, stored procedures, triggers, functions.

Environment: Waterfall, Rational Rose, HP QC, MS Project, MS Visio 0.14, MS OFFICE, Selenium 2.22, Linux, C++, MS PROJECT, WinRunner, SQL, TFS, SharePoint.

Business Analyst

Confidential

Responsibilities:

• Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements for ACH.
• Worked closely with project managers, business users and developers for a business idea and define requirements.
• Analyzed gathered requirements, verified requirements and created functional specifications (FRD/FRS).
• Gathered requirements for building a sub-ledger that hosted trading activities of various hedge fund clients.
• Mapped data between Sybase to Oracle database to assist in analysis and development of Client Sub Ledger project.
• Queried relational databases using SQL on a daily-basis to resolve operational issues and assist business and IT.
• Gathered requirements for creating “Affirmation Engine” (transmission of messages among broker-dealers, investors, and custodian banks) which assisted in matching trades and straight through processing (STP) for the clients.
• Expertise in Business Process Modeling and Use Case Modeling using Unified Modeling Language (UML) and Rational
• Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT.
• Acted a project manager/business analyst for the Buy-In project and built a new application using service oriented architecture (SOA) and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC.
• Managed enhancements and defects promptly to assist the operations in resolving issues.

Environment: Scrum- waterfall hybrid, Use Cases, SQL, UML, JAD, Quality Center, Java

Business Analyst

Confidential

Responsibilities:

• Gained extensive knowledge of Fixed Income and Equities Trading Life Cycle, Derivatives (Options and Futures).
• Analyzed and understood the Business Requirement for the project by Conducting Conference Meetings, Interviews and Brainstorming, JAD session with the team and the business stakeholders.
• Assisted product owner in user story writing, prioritizing PBIs, defining acceptance criteria. Handled different types of stakeholders and solved the conflict of different opinions for the same requirements.
• Helped Product owner to Prepared scrum board on JIRA and allocating task.
• Prepared and analyzed UML diagrams like Process Diagrams, Class Diagrams, Sequence diagrams, Use-Case diagrams and Activity diagrams using MS-Visio. Proficient in Data flow modeling and ER diagram.
• Involved in the ETL process, Data mapping, Data modeling, data profiling, data cleansing, performed various OLAP operation such as Roll up, drill down, slice, dice by using SQL commands like Joins, triggers, select.
• Helped the UI architect in designing the system that automatically popups the live finance market details, returns the consumer with appropriate trade suggestions; Assisted in designing the new User Interface that supports new mobiles in the market with different Operating Systems and of different sizes.
• Assisted Product owner in the UAT testing & execution, test plans, test cases and logged defects using HP QC tool.
• Ensured that the modifications suggested by the users were incorporated into the application successfully.

Environment: Scrum, Mockups, MS Office, MS Visio, Power BI, UML, JIRA, HP QC 11.0, Web Services, SOA, HTML, XML, JSON, JavaScript, Load Runner.