Home

Pranitha - Business analyst - Banking & Finance

[email protected]

Location: Houston, Texas, USA

Relocation: Remote, Remote

Visa: USC

Summary: Around 10 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design. Extensive experiences in Investment banking projects involving Securities trading systems (Stock trading, fixed income trading, and Derivatives trading). Deep understanding of Trading Platform Building Blocks: Static Data Requirement, Market data Structures, Pricing, Model Validation, Portfolio Risk analytics, P&L, Risk Attribution. Experienced in OTC Collateral Operations and OTC Product Control with strong emphasis on Credit Derivatives, Interest Rate Derivatives, and Derivatives products. Experience with multiple mortgage origination, processing, underwriting, secondary marketing and servicing systems including pricing, reporting and document generation functionality. Experienced in Financial Budgeting, Analysis and Forecasting including expense report preparation. Experienced in evaluating and documenting internal controls, preparing narratives, performing risk assessment and analysis. Experienced across Microsoft Business Intelligence suite Power BI Service, Power BI Desktop, SQL Server, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies. Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis. Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members. Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence). Experience in contributing to a portfolio of projects using Agile methodology (Scrum, sprint planning, burn down and velocity reporting, backlog prioritization, retrospectives). In-depth knowledge of RUP iterative Software Development Life Cycle (SDLC) process. Implement the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition. Proficiency with all Microsoft Office applications. Excellent problem solving, team building, negotiation, judgement, and decision-making skills. Technical Skills Business Analysis Requirement Analysis, detail design, Business Rules, data flow diagrams, data definition table, data modeling, system integration, and team building Processes/Technologies Rational Unified Process (RUP), Clear case, Use Cases, Workflow and UML. Data Visualization IBM Cognos, Power BI, Tableau. Databases MS SQL, MS Access, Oracle & SharePoint. Operating Systems Microsoft, Mac OS, UNIX Software Utilized Rational Rose, Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook) MS Project, Visio), Jira. Front-End Tools Microsoft Front Page, Dream weaver. Professional Experience: Citi, Fort Worth, TX (Remote) Oct 21- Present Sr. Business Analyst The project was related to the Billing of the Investment Management Division. The Billing department was responsible for calculating the client fee and for determining the split in revenue between the firm and the money managers. Several money laundering detection and prevention (KYC, CDD, Automated AML compliance checks) features were developed and incorporated in the billing system as well. Worked on several projects which provided me exposure to the various facets of the firm. Responsibilities Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, Retirement Planning, Generation Planning, and complete Financial Planning. Leveraged strong business knowledge of the investment banking sector to help design viable solutions. Responsible for interacting with business heads for designing integrated accounting and business processes. Solely responsible for carrying out several enhancements to the Billing work flow. Received appreciation from senior management for the insights provided for designing innovative business solutions. Involved in successful implementation of the Revenue Extract project, made better risk analysis possible. As part of this project, conducted a feasibility study to suggest the optimal solution for daily Revenue Calculation Systems keeping in mind the regulatory requirements. Ensured on daily basis CIP requirements, Customer Due Diligence (CDD) and Enhanced Due Diligence (EDD) policies are being followed based on KYC norms for specific countries. Involved in Joint Application Development (JAD) sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA. Designed and developed Use Cases and UML models using Microsoft Visio. Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop. Assist in the development of Process improvement procedures for short- and long-term support requirements, and stored in a SharePoint document library. Managed SharePoint project migration from legacy tools to new Confidential SharePoint site. Responsible for creating and reviewing Business Requirement Documentation (BRD), Functional Specifications Documentation (FSD), project schedules and test plans. Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse. Converted MS Access database to MS SQL database using MS SQL 15.0 Server Enterprise Manager. Created SQL scripts for uploading procedures. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS). Conducted Functional Analysis and Gap Analysis for designing robust solutions. Involved in creating Data Flow Diagrams for Database of the Investment Portfolios. Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. Organized various UAT sessions and made presentations to the users on the project and the changes implemented. Worked closely with the QA team and reviewed the test scenarios as well as test cases. Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript. Credit Suisse, New York, NY Oct 17 Aug 21 Business Systems Analyst Level II The project was to design and develop an Investment Risk Evaluation System for Credit Suisse s Portfolio Management Business. The system provided a complete set of rules, computations, business definitions and underlying data structures to help Credit Suisse s Investment achieve Compliance to the Internal Rating Based Approach of the Basel II Accord. Responsibilities: Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes, and Analyzed and optimized the process. Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model. Utilized Commercial Lending banking application and was responsible for the design and process flow of the system. Analyzed requirements for loan request, loan process, member services, processing and portfolio management. Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations. Worked with Subject Matter Expert for OTC derivatives, to analyse and develop requirements to meet client's needs. Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance. Created Business Requirements Documents (BRD) which consisted of the Project summary with relation to the processing of Portfolio, Positions, OTC data and Derivatives. Involved in analyzing defects that have been reported in JIRA and sending them over to the developers for a fix. Developed stored procedures, advanced queries, trigger, views, and indexes by using TSQL. Developed SSIS Packages to transfer the data between SQL Server database and files. Wrote Transact SQL utilities to generate table insert and update statements. Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored Procedures Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort. Migrated reports from Tableau, OBIEE to Power BI Prepared Functional and Behavioral document that describe the detail design of the application. Used the Unified Change Management (UCM) tool, Rational ClearQuest to maintain and track the stakeholders requested enhancements and changes. HSBC Bank, New York, NY Nov 14 - Sep 17 Business Analyst The project involved enhancing the Wealth Management Platform for providing better valuable advisory services to clients on investment holdings, liquidity needs and future goals. It involved development of a Fixed Income Decision Support System with access to real-time risk and trade analysis for precise and timely decision making. The system developed using Service Oriented Architecture (SOA) principles support several aspects of fixed income portfolio management including asset allocation, portfolio rebalancing/optimization, Risk and fraud management and performance reports. Responsibilities Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document. Documented functional specifications to automate the loan approval process for home mortgage (online application, workflow for the credit department, upon approval the system routes the application to the underwriters for review) Gathered and analyzed data in support of SOP s, business use cases, proposed projects, and systems requirements for mortgage loan origination system using RUP standards. Used Power Query to Get Data from SQL data Warehouse, Flat files, and other sources into Power BI desktop application to model and analyze data and build visualizations. Developed data conversion strategy for data migration from legacy systems to Technology product modules. Responsible for daily status meeting to discuss development plans, quality assurance test plans, and user documentation with developers, users, and the product management Designed use-cases and use-case models to further refine the requirements and understand the business processes. Worked extensively in Rational Requisite Pro to organize and catalog requirements, documents, and use-case documents. Created Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model. Helped the business to articulate and prioritize their ideas, while using the Rational Unified Process (RUP) and writing UML-based feasibility studies and Use Case Models to communicate those ideas to the developers. Participated in the design, code and test plan walk through with the development and design team members. Used MS Access and Excel to cleanse and assemble accounting data and develop reports. Developed SSIS Packages to transfer the data between SQL Server database and files. Transferred data (ETL) to Data ware house Environment using SSIS and SSAS Created and managed database maintenance plans for various database consistency checks. Used SQL Profiler to monitor the server performance, debug TSQL and slow running queries. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS). Coordinated with different agencies in tracking the progress of the software development and resolving the issues and worked with the UI team to create the User Interface Mock-ups to be presented to the Business. Analyzed and prioritized tasks to ensure smooth cycle of development, testing, and release. Conducted technical/non-technical presentations to the management and training workshops for the clients. JP Morgan Chase- Jersey City, NJ Jul 12 - Oct 14 Business/Data Analyst Worked on multiple projects relating to business migrations, system conversions, Merger and Integration, General Ledger, MIS, Reference Data, regulatory and corporate reporting. As a part of Business Migrations team worked on a major initiative to develop an Operational General Ledger (OpGL) and Financial Data Warehouse (FDW). Responsibilities Responsible for gathering requirements, writing functional specifications, creating use cases, and developing prototypes for conversion projects supporting multiple lines of business including Commercial, Investment Bank, Private Bank and Retail Bank. Create data-mapping between the current and future operating environments. Document all operating model changes through data-flow and process diagrams to assist users develop an understanding of future state architecture. Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts. Review the project scope and dependencies to identify risks and clearly link them to project milestones. Document risks with priority by dimensioning its probability of occurrence and impact. Notify all impacted parties of the risk s existence and possible impact details. Assess training needs and access requirements for all users migrating to the target operational general ledger (OpGL) to ensure that existing JPMC ledger users can perform their day-to-day functions in the target environment without and interruptions. Involved in vendor negotiation strategies in the required areas in terms of tasks performed at various phases of the project Identify and track project issues/ risks and recommend solutions to resolve these issues in a prudent and most efficient manner. Adhere to project deliverables as specified in the JPMC project lifecycle methodology and prepare all documentation to conduct a successful tollgate review at the end of each phase in the lifecycle. Masters in International Business and Management, 2003 Keywords: quality analyst user interface business intelligence information technology microsoft New Jersey New York Texas