SUMMARY

• Over 8 years of professional experience in Capital Markets, Fixed Income and Investment Banking domain, as Sr. Business Systems Analyst, Lead Business Analyst. Detail oriented, analytical and inquisitive with excellent oral, written communication skills; ability to work independently and with the team. Certified TCS Agile E1, BMC, Fifth Third Capital Market systems.
• 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, Impact, Cost-Benefit, Return-on-Investment, SWOT, GAP (AS-IS-TO-BE), PESTLE, MOST, Porter’s five forces, Business Process Modeling.
• Capital Markets Investment Vehicle knowledge: Equity, Fixed Income, Asset-backed securities, Interest Rate Derivatives, Risk management, Collateralized Debt Obligation, Swaps, CDOs, Futures, Forwards, Options.
• Knowledge of trading securities structure and dynamics - Foreign exchange, OTC, Interest rates swaps, spots, forwards, futures, caps, swaptions, collars and corridors.
• Knowledge in with various regulatory process and compliances such as; TRACE, FINRA, Dodd-Frank, Basel II & III, SEC, GAAP, IFRS, Sarbanes-Oxley (SOX), FINMA, Consumer Protection Act, BSA/AML and KYC.
• Understanding of back office payments/settlements systems: ACH, IMPACS, CHIPS, FIX, SWIFT, OAUTH/OFX; Payment regulations: ACH, NYCE, FRB, Fedwire, RTGS, EFT; Middle Office Trade Order Management Systems (TOMS), IBOR.
• Proficient in conducting and facilitating Requirements Gathering using diverse elicitation techniques such as JAD Sessions, Survey, Brainstorming, Interviews, Requirement Workshops, Focus Groups, and Prototyping.
• Excellent writing and documentation skills in creating, modifying and analyzing BRD, FRD/FSD, SRS using requirements gathering software such as Requirements Center 2009, Blueprint Requirements Center 2010, Jira, IRise, Sharepoint
• Extensively used JIRA, Confluence, RTC 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.
• Hands on experience in performing queries on SQL database/ Data stack - Oracle, MySQL, SQL Server, using DML Joins, Views, Sub queries and Aggregate functions with 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 DW/BI: Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice, and Pivot and hands on experience in Data-Migration and Data-Governance Processes.
• 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, Gherkin for defect tracking and coordinate User Acceptance Test (UAT).
• Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using Jenkins and Bamboo
• 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.

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, UFT, Swagger, SOAP UI, Gherkins, 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, Cincinnati, OH

Responsibilities:

• Involving in Capital markets function of the organization - Worked in FIS APEX CMS to create margin call process workflow. Meet with capital markets LOB in understanding reporting requirements for daily collateral settlements Worked in FIS ADAPTIV risk management system production support in managing daily jobs for PFE, CVA, VaR calculation and downstream reporting.
• Working with various financial instruments (Equities, FI, Derivatives, (ETD & DTC) - Worked primarily in OTC securities - Public funds, repo sweeps, IRD, Swaps, Swaptions, Caps/Floor; Exchanged traded securities - Spots, OIS, FRD, FX forwards, Cross currency, Volatility futures.
• Involving in Requirements gathering, & Analysis, Business process modeling - Requirements gathering for system enhancement using BRD, FRD, Acceptance criteria, UAT. Creating data mapping from FIS legacy system CMS, ADAPTIV to target system FIS APEX, Adapativ Analytics. Business process modeling using MS Vizio for upstream and downstream reporting for future state systems.
• Involved in Data mapping and migration - Involved in source data mapping - Kiodex, Findur, Wall Street Systems, Alladin, BONY, Bloomberg for market data and trade data using gap analysis. Involved in data gathering from multiple data base using SQL query. Worked with DBAs in creating a new architecture for enhanced retrieval rate, reduced storage space, resolved duplicates and redundant data load.
• Perform business analytics for partners in Credit and Market Risk Coverage and the Collateral Management business unit on an ongoing, ad hoc basis. Performed value stream mapping in risk analytics, collateral management and margin call automation. Work with stakeholders across Risk, Finance and IT on projects improving process and data flows and automating stress testing
• Produce documentation using Vizio and presentations to effectively communicate key information to senior management and regulators. Develop methods and tools such as Kanban WIP, reporting templates on SharePoint to streamline and increase efficiencies of various work streams
• Working closely with IT teams in elaborating the business requirements and clarifying any queries - Interacting with onshore and offshore IT teams on a regular basis. Conducting meetings to elaborate on business requirements and explain any queries, assist in building SQL queries and elaborating on business user needs using RTM and SRS documentation
• Creation of Test plan, Test cases, and performing functional test cases to ensure the development meets the business requirements - Creating test plans and test cases based on requirements from the user and assisting in User Acceptance Testing and creating a report of business user sign off. Provide test scripts to IT team for testing and recording test reports on a regular basis
• Coordinate with multiple business users and stakeholder management - Coordinate with multiple business users working on different systems - Agiletics, Wall Street System, Kiodex, Findur, Alladin, and Bloomberg. Understanding dependencies between systems and stakeholders to ensure process efficiency. Resolving conflicts that arise between stakeholders and business users on a regular basis and ensure project scope alignment
• Advanced SQL skills: understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management and Report Delivery. In-depth knowledge of DML SQL queries like JOINS, AGGREGATE, INDEX.
• Created data visualization/reporting dashboards on MS Excel, using FIS artiQ OLAP cubes for a comprehensive look on deals/prospects for Investments Analysts and Portfolio Managers.

ENVIRONMENT: Kanban, MS Visio 0.15, MS Visio, MS SharePoint, Salesforce, Bloomberg B-Pipe, Bloomberg TOMS, MS SQL Server, MS Project, FIS Apex CMS, FIS Adaptiv, Findur, Alladin, Kiodex, Wall street systems, Thomson Reuters, Operational Data Store, ORACLE DB2, AQT Database, Datamart, MS Excel, Informatica, MS Office Dynamics 365, MS Project 2013, Office 365(Word, Excel, PowerPoint and Outlook).

Sr. Business Systems Analyst

Confidential

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 US GAAP 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, ROI 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). Provided recommendations on current system principles and necessary updates and recommendation
• Worked with back office team in FIXML, SWIFT messaging (SWIFTXML), OAUTH payment authentication and clearing house processes ACH, CHIPS, IMPACS.
• Developed an understanding of work flow for Buy side organizations: trading/positioning strategy, ad-hoc liquidity modeling, scenario-based position strategy modeling. Sell side organizations: risk modeling (Credit risk, VaR, HS)
• Held meetings/interviews with the Wealth management team: Portfolio Managers, Quant Analysts, Validation Analysts for analysis and determining pre-requisites for the Project. Prepared cost-benefit analysis
• 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.
• Attended PI Planning meetings to align sprint goals across teams in different programs. Interacted with Release Train Engineer periodically to understand dependencies and negotiate sprint goals/sprint demos
• 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. Advanced analytical functions such as clustering, regression, correlation and market basket analysis for DW/BI.
• Used Azure Enterprise integration Service - SQL Server Stretch Database to migrate transactional database with cold data securely to Azure Cloud. Performed Business data modeling
• 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).
• Assisted in automated acceptance testing using feature files on CUCUMBER, and plain language parser GHERKIN.
• Tested application in different environment and performed cross browser testing using Selenium server.
• Advanced SQL skills: understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management and Report Delivery. In-depth knowledge of DML SQL queries like JOINS, AGGREGATE, INDEX.
• Created data visualization/reporting dashboards on Splunk, 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 Dynamics 365, MS Sharepoint, Salesforce, Bloomberg B-Pipe, Bloomberg TOMS, MS SQL Server, MS Project, Cucumber, Gherkin, SELENIUM, Java micro services, HTML, REST, 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, SWIFT, CHIPS, FIS Systematics, IMPACS, COGNOS, Visual Basic

Sr. Business Systems 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 front-office, cross-asset, positioning platform (Java based platform with Python cover) technical infrastructure: desktop, Dev, trades, 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 in Java micro services platform.
• 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 Global Markets in Portfolio management, wealth 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 data warehouse to Object data store. Phased migration that involved simultaneous data ingestion into both database for a stipulated time, using Business Metadata attributes
• Advanced SQL Skills: performed DML SQL queries 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.
• 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, Deltaone, 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, Splunk, MS Office Dynamics 365, 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, ACH, SWIFT, CHIPS, ACH.

Lead Business Systems Analyst

Confidential, Owings mills, 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 Front-office, Risk Managers and Project Architects, to gather client specific business requirements, review system capabilities and translate for the micro services 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, Blueprint Requirements Center 2010

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.
• Understood front-office systems, risk management processes, measurement techniques and reporting metrics: Duration, Convexity, Standard deviation, Beta, Value-at-Risk (VaR), EVT, HS to measure Credit risk, Market risk, Liquidity risk, Interest rate risk, Business risk, Systematic/ Unsystematic risk.
• Created and maintained User Stories by workshop, interviewing, brainstorming and met with the business users to communicate the requirements to micro services development and testing teams.
• Understood and performed the AS-IS and TO-BE business process and developed the GAP Analysis; ROI; Cost-benefit.
• 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 for Data warehouse architecture.
• 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 to developers & updated the Burn-Down Chart.
• Proficient in breaking down large user stories into multiple independent stories using vertical/horizontal slicing
• Involved in Walk-through sessions with developers and gave presentations to help understand the end user needs.
• Intermediate SQL skills: SQL queries to retrieve and validate data, prepared for data mapping in Data warehouse.
• Performed Data Analysis for BI reporting using dashboards and analysis using regression, clustering, correlation
• 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.