Data Project
Resume:
YAASSH R
Sr Business System Analyst
https://youtu.be/3SA63Xw7Lq4
*******@*****.***
PROFESSIONAL SUMMARY:
Over 8 years of extensive experience in providing end-to-end and ad-hoc solutions in the Capital Markets and Banking domains, with a comprehensive understanding of fixed income and multi-asset instruments such as derivatives, stocks, bonds, futures, options, trading, compliance and data governance.
Exhaustive knowledge of Financial reporting, Forecasting, Valuation, Capital Markets and Derivatives.
High energy, dedicated software professional with an excellent blend of expertise in finance, capital markets, global markets product knowledge and modern software development practices, such as Software Development Lifecycle (SDLC), Product Development Lifecycle (PDLC), Product Lifecycle (PLC), Application Lifecycle Management (ALM) and Agile Continuous Integration (CI/CD).
Highly competent in succinctly articulating complex technology solutions to sophisticated business & technology audiences, with specialties in Scrum/Kanban development methodology, hybrid models such as Waterfall-Scrum hybrid & Scrumban, Product Management and improving customer experience.
Extensive knowledge of Agile processes such as XP, Rational Unified Process (RUP), Spiral & SAFe.
Proven experience in conducting GAP Analysis (AS-IS & TO-BE), Risk Analysis, Impact Analysis, Cost-Benefit Analysis, SWOT Analysis and Feasibility Study to assist Project Managers in release planning.
Excellent verbal/written communication skills and strong analytical abilities and can perform well both independently and as a team player. Facilitated JAD sessions, Interviews & Rapid Application Development.
Excellent business writing skills in drafting Business Requirements Document (BRD), Functional Requirements Specification (FRS) and Systems Requirements Specifications (SRS) documents.
Experienced in Business Process Management (BPM), business process design and drafting business vision documents & glossaries in support of corporate goals, within and beyond enterprise boundaries.
Designed mockups and wireframes for the requirements, to provide a visual perception of the user interactions with the application, using tools like Balsamiq and Mockups and get them validated.
Experience in process modeling using Use Cases, Sequence Diagram, Collaboration diagrams, Activity Diagrams, Class Diagrams and Data Modeling, to support business flows and establish actors.
Adept in managing and enforcing quick resolution of conflicts arising between Application Architects, Developers, Subject Matter Experts, business teams, testing teams and enterprise level executives.
Worked with Subject Matter Experts (SMEs) to translate enterprise decisions into deliverables, ranked by the KPIs of the company, while adhering to Service Level Agreements (SLAs).
Assisted the Product Owner in formulating Acceptance Criterion and MVP for User Stories.
Expertise in facilitating workshops along with Scrum Master for estimation of efforts in a sprint, using advanced estimation models such as Relative Mass Valuation, T-shirt sizing and Planning Poker.
Strong implementation knowledge of advanced SQL concepts, including stored procedures (PL/SQL), T-SQL, basic & advanced JOINS and aggregation queries to extract, wrangle and clean data.
Assisted Data Architect in creating data models like conceptual data models and logical data models, in the form of entities and relationships, to capture user requirements properly in underlying database.
Practical knowledge of Data Warehousing architecture, implementation approaches, dimensional modeling and translating the business requirements into schemas, such as Star Schema, Snowflake Schema and Galaxy Schema and generating Data Lineage reports during source to target mapping.
Extensive implementation and deployment knowledge of OLAP operations (Slice & Dice, Rollup, Drill Down) and Data Warehouse design using Kimball architecture and Inmon’s Corporate Information Factory.
Highly proficient in performing in ETL (Extract, Transform, Load) of data into data warehouse/data mart, data mapping and data profiling. Utilized ETL tools like Informatica Powercenter and SSIS/SSRS.
Strong understanding of XML, JSON, loosely coupled Web Services (REST, SOAP) and system architecture like 3 tier, N-tier and Service Oriented Architectures (SOA) and implementing the same.
Documented requirements for API development, i.e. responsible for technical writing of both XML and JSON formats. Used SOAP UI and POSTMAN for API Testing. Used SWAGGER tool for API documentation.
Maintained test case repositories with updated test cases for Manual Testing, Automated Testing, Functional Testing, System Testing, End-to-end Testing, Regression Testing and Ad-Hoc Testing.
Adept in developing automated test scripts, with the help of test engineer, using tools such as Cucumber.
TECHNICAL SKILLS:
Domain Expertise
Capital Markets, Derivatives, Forex (Currency Swaps, Currency Forwards), Commodities, Mutual Funds, Portfolio Management, Market Making, Order & Execution Management, ETFs, Cryptocurrencies, Blockchain
Compliance & Regulation Policies
Dodd-Frank, Basel II and III, CCAR, GDPR, Sarbanes-Oxley (SOX), Broker-Dealer & Investment Advisor (BD & IA) Compliance
Business Modeling tools
MS Visio, LucidChart, Balsamiq
Methodologies & Paradigms
Waterfall, Spiral, RUP, XP, Cleanroom, Scrum, Kanban, Waterfall – Scrum Hybrid, SAFe and LeSS
Project Management Tools
JIRA, Confluence, MS Project, MS Office, HP ALM, SharePoint Server, Trello, Asana
Databases
MS Access, MS SQL Server, Oracle, DB2, PostgreSQL, MySQL, Teradata, RedShift, Hadoop, Hive, NoSQL (Cassandra, HBase)
Big Data
HDFS, Mahout, PySpark, MapReduce, Oozie, Zookeeper
Testing tools
HP Quality Center (v 11.0), Postman, Swagger, Selenium, Cucumber
Languages
Python, R, SAS, SQL, JSON, XML, C, C#, .NET, HTML, CSS, Javascript, WSDL, MATLAB
Reporting Tools
Tableau, IBM Cognos, Google Analytics, Power BI
Data Warehousing/ETL Tools
MotioCI, Informatica PowerCenter, Shareplex, AWS Stack (EC2, RDS, S3, ELB)
Business Skills
Risk Management, Impact Analysis, Conflict Resolution, SWOT Analysis, Problem Solver, Team Player, Self-starter
CERTIFICATIONS:
Professional Scrum Master 1 (PSM 1)
Analytics & Business Intelligence by SAS
Google Analytics Individual Qualification
IBM Blockchain Essentials
Program on Stock Markets (by Bombay Stock Exchange)
RELATED PROJECTS:
PricewaterhouseCoopers (PWC), Tampa, FL
Senior Business Systems Analyst (Big Data) April 2018 – Currently Working
ABC company onboarded me at the inception of their in-house project, aimed at analyzing the impact of multiple factors (such as currency exchange rates, energy price changes, socio-political situations and consumer price index) on the S&P 500 Index. The changes were determined by noting changes in Net Present Value (NPV), Internal Rate of Return (IRR) and beta value. The Country Credit Risk is also calculated, keeping in mind the political risk, exchange rate risk, economic risk, sovereign risk and transfer risk. A predictive model was then developed to predict the behavior of the S&P 500 Index in similar scenarios, which would enable corporate to take better decisions, based on insightful inferences, derived in an empirical manner.
Responsibilities:
Leveraged knowledge about Sarbanes-Oxley (SOX) Compliance, Basel II regulations and Capital Assets Pricing Model (CAPM) to analyze changes to beta values and subsequent fluctuations for securities’ risk.
Developed extensive clarity of Market Basket analysis, Consumer Price Index (CPI), GICS sectors, Stock Splits, Mergers, Acquisitions and Consolidation Drivers, in terms of stock market variations.
Conducted extensive GAP analysis by identifying AS-IS and TO-BE process vision and process flows.
Engaged in requirements gathering and eliciting sessions with stakeholders like business owners, database engineers, financial strategists and financial analysts using Structured Interviews, and analyzing business needs & developing use-case scenarios to facilitate JAD sessions, on behalf of Product Owner.
Acted as an internal consultant and Agile Coach to guide staff members in Agile process development and best practices, such as Acceptance Test Driven Development (ATDD) and Pair Programming.
Facilitated the Program Increment (PI) Planning session along with Release Train Engineer (RTE) to identify dependencies and foster cross-team collaboration to maintain the PDCA cycle of the ART.
Presented summary of findings to clients and walked them through TO-BE design of proposed systems.
Assisted in writing acceptance criteria and framing Definition of Done (DoD) for delivery of Potentially Shippable Product Increment (PSPI) and help enforce WIP limits for optimized process flow.
Empowered dark launches and canary launches, by enabling feature toggles in the release streamlet.
Analyzed requirements and assisted in design of the Enterprise Data Warehouse in Inmon’s CIF format using Star Schema initially and then implementing a Galaxy Schema, creating a more sophisticated architecture.
Assisted Data Analysts in performing ETL operations for Business Intelligence reporting solutions, specified the standards for universes, classes, and complex objects in sync with the financial business rules.
Used Swagger to document RESTful APIs, used to facilitate seamless communication between the Enterprise Data Warehouse (EDW) and Python module in the business intelligence (BI) layer.
Assisted BI developers in generating reports / dashboards with different OLAP Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
Prepared Documentation for OBIEE repositories and standard operating procedures (SOPs).
Facilitated the integration of existing architecture on a Hadoop environment (HDFS), with separate clusters for batch processing (accessed using Hive) and real-time streaming data processing (accessed using Spark).
Assisted big data developers in streamlining communication between Apache Sqoop module (for batch processing), PySpark cluster (for streaming data) and Apache Oozie for workflow scheduling.
Ensured compliance through API Service Level Agreements (SLAs) at every stage of the project.
Assisted development teams in ensuring efficient integration of NLP module, via RESTful APIs in the initial architecture & then on a Spark cluster, accessed using PySpark, in the later stages of the project.
Participated in Smoke, System, Regression, Sanity & User Acceptance Testing (UAT) using Cucumber.
Extensively involved in tracking issues & defects and overall user stories’ management, using JIRA.
Hardware/Software:
Essential SAFe v3.0 (Scaled Agile Framework) methodology, Hive v2.3, Mahout v0.12, Zookeeper, Elastic Load Balancer (ELB), Oozie, Solr, Cassandra, MapReduce, Spark v2.2, Informatica Powercenter, OBIEE, MotioCI, IBM Cognos, Python 3, JIRA v7.4, Confluence v6.2, Swagger, Cucumber
Charles Schwab, Phoenix, Az October 2017 – March 2018
Business Analyst/Data Analyst
The scope of this project was to calculate the counterparty credit risk of investments for a brokerage firm, by producing a Credit Valuation Adjustment (CVA) value using complex computational simulations, such as Monte-Carlo Modeling. We also used derivatives to create an immunization overlay (hedge) and matched the average duration of assets & liabilities, to control uncertainty. Equity & Currency Market Risk is
estimated.
Responsibilities:
Strong understanding of Dodd-Frank Act, Basel II and Basel III regulations and Sarbanes-Oxley Act (SOX). Knowledgeable of various brokerage products, brokerage operations and platform changes.
Leveraged knowledge of derivatives, implementing an immunization overlay to hedge unrewarded risks.
Captured high level requirements, managed epics, user stories, defect lifecycle & bug tracking using JIRA.
Assisted in building of product backlogs from requirements gathering & elicitation activities and worked with Product Owners to size and scope features, for prioritization purposes in the Product Backlog.
Assisted scrum teams in conducting Product Backlog grooming sessions throughout the project lifecycle.
Ascertained reputational risk by parsing market data through a Natural Language Processing (NLP) model.
Ensured consolidation of data from multiple functional silos into a unified data lake, using HDP.
Developed processes to actualize Massively Parallel Processing (MPP) using an HDFS cluster.
Facilitated the implementation of the “Write Many, Read Many” concept using JBOSS Data Grid (JDG) to provide our system the ability to store, access, modify & transfer large amounts of distributed data.
Ingested batch updates into HDFS cluster using the Mule ESB (Mulesoft’s Enterprise Service Bus).
Involved in creating inbound and outbound flows for Mule ESB in HTTP and path orchestration using XPath.
Assisted in implementation of a layer of communication between Hadoop cluster and Python module by participating in API documentation for REST APIs using SWAGGER tool.
Documented Requirement Traceability Matrix (RTM) using Zephyr add-on through rigorous test cases.
Act as the mediator between client and technical users, both in a business and technical capacity.
Supported integration testing & UAT to ensure conformance to design and accuracy of implementation.
Performed production readiness assessment & transitioned client over to internal support team after go-live.
Reviewed completed development of features and consequently prepared training documentation for users.
Hardware/Software:
Scrum, JIRA v7.1, Confluence v6.2, Zephyr v3.1.3, MapReduce, YARN, Apache Hive, Pig, HBase, Apache Storm, JDG by Redhat, Mulesoft, Python, Swagger
T. Rowe Price, Owing Mills, MD January 2016 - July 2017
Business Systems Analyst
The goal of the project was to digitize all risk estimation and validation systems & reports from paper-based processes, while ensuring the broking firm adheres to all compliance and data governance standards. The end system delivers automated and streamlined regulatory capital calculations for Basel III.
Responsibilities:
Techno-commercial acumen in bridging the business gap with incisive knowledge of Basel II & III, Treasury, Risk Compliance, and Regulatory Reporting (CCAR, FDIC and COREP).
Worked on CCAR Credit Risk Model validation of finance portfolio for the firm’s business lines. Complete model validation - Input data, Methodology, Code Implementation, Statistical Test, back testing and reporting.
Conducted GAP analysis to map the AS-IS and TO-BE of the current systems & processes.
Played an active role in modeling the existing business processes, using the Business Process Modeling Notation (BPMN) module of Lucid Chart and implementing eRCM module of NICE Actimize.
Elicited requirements by conducting Brainstorming and JAD sessions with business and technical units.
Prepared Use Case surveys, briefs and specification for all the functional requirements identified (FRD).
Involved in synthesizing Software Requirements Specification (SRS) document, by mapping requirements.
Involved in all phases of SDLC including requirements gathering & elicitation, specifications synthesis, conceptual and logical design, analysis and testing, utilizing Water-Scrum-Fall methodology.
Assisted development team’s efforts in implementing a comprehensive in-house tool to help regulators measure network connectivity between closely linked counterparties within a trade.
Handled requests for proposals (RFPs) and negotiating project timelines and deliverables.
Assisted in formulating Requirements Traceability Matrix (RTM) to map functional requirements to test cases.
Facilitated a continuous integration environment for refactoring development efforts from a shared repository.
Assisted in system and user acceptance testing (UAT) and in tracking defects through the defect lifecycle.
Hardware/Software:
Agile-Waterfall Hybrid, Lucid Chart, Bitbucket, Bamboo, Zephr, BugZilla, Modern Requirements4DevOps
ANSec Pvt. Ltd., Mumbai, India February 2014 - November 2015
Business Analyst
The goal of the project was to transition an invoice factoring platform from another company to ANSec. The platform enables institutions to leverage their pending invoices, in order to raise capital for continued growth. The invoices are held by CYC company, with the platform calculating the risk associated to each invoice.
Responsibilities:
Interviewed stakeholders of both organizations, SMEs and business users to understand and gauge their requirements, gathered their future needs and transformed them in Functional Specifications.
Conducted JAD sessions with management, SME, vendors and other stakeholders for pending issues.
Formulated RACI matrix, communication plan during transition to eliminate effort duplication.
Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative.
Coordinated the project processes by creating and maintaining documents including issue logs, communication plan and progress reports. Created Gantt chart to trace the project planning in detail.
Identified risks to Service Level Agreements (SLAs) and informed support teams of significant delays.
Collaborated with other analysts to bolster technology risk modeling for clients with effective remediation plans.
Led Change Management for effectively transitioning the project from one company to another.
Scheduled meetings with developers and testers to collaborate resource allocation and project completion.
Ensured high availability of the Invoice Factoring system by prioritizing and resolving incidents on HP QC.
Reduced process completion time by 15% by modifying long running IT programs & revising their data.
Hardware/Software:
Waterfall, IBM Rational Rose, Rational Clear Case, MS Project, DB2, SQL, SharePoint, HP Quality Center
Mswipe, Mumbai, India August 2012 - December 2013
System Analyst
Mswipe is a captive finance startup based in Mumbai. The primary goals of the project were to design a capital leasing information system for the company, in order to help the admin to operate the business with efficacy. The system would generate the Master Lease Agreement (MLA), Lease Proposal, Lease Schedule, Delivery & Acceptance documents and any third-party assignment documents. Additionally, a Lease Checklist would be generated, allowing the admin to coordinate process flows with Central Purchasing.
Responsibilities:
Defined functional & technical business requirements, designs, scenarios and test scenarios.
Worked with project manager to gather requirements, prioritize functionality and communication with customers to define business needs and identify the Just in Time (JIT) requirements, to perform change management.
Provided ballpark estimates and ROM estimates upon request, for new development efforts.
Used MS Visio to create Data Flow Diagrams (DFDs), Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, State Diagrams and Functional development flowcharts.
Conducted due diligence of externally sourced business opportunities, including technology acquisition.
Assisted in integration of all design and development efforts on the InfoLease platform, to provide modeling for pre-tax pricing and after-tax pricing and reports and analyses of transaction details.
Created test plans and test scenarios to validate the intended implementation of business requirements.
Documented and tested REST APIs and SOAP Web Services in XML & other formats, using Swagger.
Worked with SQA to recommend additional testing to be implemented into test scripts.
Assisted in integrating third party software such as DocuSign within the system.
Hardware/Software:
Waterfall, MS Office Suite, SharePoint, MS SQL, Swagger, InfoLease v10
HDFC AMC, India June 2011 – August 2012
Data Analyst
Assisted in research and development of a research project titled ‘Consolidation Drivers in the Telecom Industry’. The goal of the project was to determine the factors encouraging mergers and acquisitions amongst the highly volatile telecom corporations in India, just after the distribution of the 3G bandwidth spectrums. Using these insights, HDFC’s asset management wing wished to acquire the ability to identify and recognize scenarios leading to future possible Mergers and Acquisitions (M&As) in the telecommunications industry.
Responsibilities:
Interacted closely with subject matter experts (SMEs) for functional requirements gathering.
Assisted in development of Critical Path Analysis (CPA) within the Work Breakdown Structure (WBS).
Responsible for Cost-Benefit Analysis, Impact Analysis, Risk Assessment and SWOT Analysis.
Assisted in data analysis by wrangling and cleaning data using SQL.
Correlated variables to determine inter-dependencies between variables that were driving talks of mergers and acquisitions (M&As) between telecommunication corporations, using RStudio.
Tailored weekly, monthly & quarterly reports on major activities and upgrades within the telecom sector.
Worked on custom MS Excel reports to design and maintain KPIs to gauge health of markets after M&A.
Used Tableau to develop visualizations, for reporting and for Business Intelligence (BI).
Assisted in API documentation of SOAP APIs using Postman for data transfer between different systems.
Provided post presentation and implementation support to corporate.
Hardware/Software:
Waterfall, MS Excel, R, PostgreSQL, POSTMAN, Tableau v7.0
EDUCATION
Bachelor of Engineering (B.E.) in Electronics & Telecommunications Engineering from University of Mumbai (Mumbai, India)
Contact this candidate