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

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

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.

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.