b"Urvashi Biyani\n\nEmployer: Rohan\n\nBusiness Analyst\n\nPh:. 734-357-8982\n\nIrvine, CA\n\nEmail: rohan@tekwissen.com\n\nObjective\nTo obtain a business analyst position in one of the esteemed organizations in the industry and utilize my\nbusiness skills and experiences.\nProfessional Summary\n\xef\x82\xb7 Over 7 years of experience in Capital Markets, Banking, Financial, Analytics and IT domain.\n\xef\x82\xb7 Knowledge of analytics and reporting using SAS.\n\xef\x82\xb7 Experienced in conducting Joint Application Development (JAD) sessions, project meetings,\nreviews, walkthroughs, and customer interviews.\n\xef\x82\xb7 Expertise in writing Business Requirements Document (BRD), Functional Specification Document\n(FSD), Non-Functional Specification Document, System Design Specification, System Use Cases,\nscreen mockups, and training manuals.\n\xef\x82\xb7 7+ years of experience in implementing Iterative Software Development Life Cycle (SDLC)\nmethodologies such as Rational Unified Process (RUP) and Agile.\n\xef\x82\xb7 Expertise in feasibility requirements analysis, design, construction, testing, implementation, and\nUML methodology.\n\xef\x82\xb7 Experienced in creating data dictionary having the business definitions of data mapping to map the\nlogical data elements in use cases to physical data elements (record source).\n\xef\x82\xb7 Proficient at coordinating various technical and managerial teams to develop process and verifying\nadherence using the Requirements Traceability Matrix (RTM).\n\xef\x82\xb7 Extensive knowledge of GAAP, financial accounting, investment banking, fixed income products and\nfinancial statements.\n\xef\x82\xb7 Well equipped with excellent communication and organizational skills to face clients.\n\xef\x82\xb7 Expertise in change request management and developing configuration management documents.\n\xef\x82\xb7 Experienced in developing test plans, cases, scenarios and strategies as per the business\nrequirements to match the functional requirements and UML diagrams.\n\xef\x82\xb7 Experienced in SQL queries to extract data from various databases for data analysis.\n\xef\x82\xb7 Knowledge of capital markets including Fixed Income, OTC derivatives, MBS (Mortgage Back\nSecurities).\nTechnical Skills\nProject Management\nTools\n\nMicrosoft Office tools - Access, Excel, Outlook, PowerPoint, SharePoint.\n\nSDLC/Design\nMethodologies\n\nUnified Modeling Language (UML), RUP, Agile, RAD and Waterfall.\n\nModeling and Design\nTools\n\nMicrosoft Visio, Adobe CQ.\n\nLanguages\n\nVBA, Python, SAS, MySQL, VB .Net, Java.\n\nOther tools\n\nBloomberg, Crystal reports, Microsoft BI stack - SQL Server, SSAS, SSRS.\n\nEducation\nMaster of Science in Finance\nStuart School of Business (Illinois Institute of Technology), Chicago, IL\nBachelor of Engineering [Computer Engineering]\nSPCE, Mumbai University, India\n\n\x0cExperience\nClient: - State Street Corp. (Trade Settlement and Processing)\nLocation: - Irvine, CA\nRole: Business Analyst\n\nOct\xe2\x80\x9913 \xe2\x80\x93 Till Date\n\nDescription: Project focused on developing their TMPG Claims Processing Application and Benchmark/\nBogey Application.\nResponsibilities:\n\xef\x82\xb7 Gathered Business requirements pertaining to Trade Settlement and Processing.\n\xef\x82\xb7 Imparting knowledge on trade cycle, trade processing, derivatives.\n\xef\x82\xb7 Creating and maintaining web content for the trade processing application.\n\xef\x82\xb7 Translating those requirements into functional specifications and relative test cases.\n\xef\x82\xb7 Database analytics ( Creating SQL Queries).\nEnvironment/Tools: XML, Unix, JAVA, MS Excel, Microsoft Visio, Visual Studio 2008, SQL.\nClient: - Nolita Capital (Finance/ Capital market domain)\nLocation: - Chicago IL\nRole: Senior Business System Analyst\n\nJan\xe2\x80\x9913 \xe2\x80\x93 Oct\xe2\x80\x9913\n\nDescription: Project focused on customizing their current web based content management for trading/\nBroker platform. The main features of this project were: Traders will get real-time streaming quotes for the\ninstruments they selected, their current position in the options/ fixed income market, and current money\nbalances, P & L Accounts and available trading power, all continuously updating in real time via live content.\nResponsibilities:\n\xef\x82\xb7 Gathered Business requirements pertaining to Trading, fixed income and derivatives, converted the\nsame into functional requirements by implementing the RUP methodology and authored the same in\nBusiness Requirement Document.\n\xef\x82\xb7 Produced requested reports and ran analytics using SAS.\n\xef\x82\xb7 Prepared slides using Microsoft PowerPoint and presented them at quarterly quality meetings.\n\xef\x82\xb7 Manage documents from start to finish, publish reports and share information with others using\nSharePoint.\n\xef\x82\xb7 Created process flows and use case diagrams using Microsoft Visio.\n\xef\x82\xb7 Successfully conducted JAD sessions to gather project requirements and help synchronize the\ndifferent stakeholders on their objectives in order to provide the developers a clear-cut picture of the\nproject.\n\xef\x82\xb7 Analyzed Business Requirements and segregated them into high level and low level Use Cases,\nActivity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus\ndefining the Data Process Models.\n\xef\x82\xb7 Supervised the content design and development of a web portal for reporting, analysis and\nnavigation of financial data.\n\xef\x82\xb7 Proficient in using content management systems for site navigation and content management.\n\xef\x82\xb7 Leading discussions with vendors to determine the best methodology for different work streams of\nthe project.\n\xef\x82\xb7 Developed test plans, test cases and test scripts based on the functional specifications.\n\xef\x82\xb7 Coordinated and Developed QA activities with team members to support the methodology.\nEnvironment/Tools: HTML, Windows 2003, 2008, XP, MS Excel, Microsoft Visio, Visual Studio 2008, SSAS.\n\nClient: - State Farm (Insurance domain)\nLocation: - Bloomington, IL\n\nMay\xe2\x80\x9912\xe2\x80\x93Dec\xe2\x80\x9912\n\n\x0cRole: Business System Analyst\nDescription: - State Farm is one of the leading insurance companies in the United States. The project\ninvolved modeling their customer order handling process for their telephone ordering system. I was\nexpected to identify the tasks, business items, resources and roles involved in the customer order handling\nprocess.\nResponsibilities:\n\xef\x82\xb7 Understood the existing environment and created Process flow diagrams for the new system.\n\xef\x82\xb7 Created Prototypes after collecting Report requirements and presented the Prototypes to the team.\nFor example involved in creating reports like Marketing Effectiveness Report, Daily Activity Report.\n\xef\x82\xb7 Involved in testing of reports, creation of report manuals.\n\xef\x82\xb7 Analyzed the existing reports to remove redundancy.\n\xef\x82\xb7 Understood the existing setup and created Data-Mapping documents for Data Migration.\n\xef\x82\xb7 Worked with data analysts to ensure that the data was properly migrated.\n\xef\x82\xb7 Assisted in creating Test Plans and Test Scripts and was involved in integration.\n\xef\x82\xb7 Executed SQL Queries to test the Data Integrity using SSIS.\n\xef\x82\xb7 Assisted in development of Test Plans and assisted QA team in System testing to ensure the new\nsystem satisfy all User requirements.\n\xef\x82\xb7 Collaborated with project manager in tracking and managing project development process following\nRUP based SDLC methodologies.\nEnvironment: MS SQL Management Studio, MS SQL Server 2008, Windows XP, Microsoft Visio, SSRS.\n\nClient: - Capital Group (Banking)\nLocation: - Chicago, IL\nRole: Business System Analyst\n\nFeb\xe2\x80\x9911 \xe2\x80\x93 Apr\xe2\x80\x9912\n\nDescription: - This project entailed the development of a Fixed Income Re-offering System (FIRS). I\nassisted traders to add/modify certain criteria in real-time so that traders could more effectively manage\ndemand and supply. I was responsible for creating application to package mortgage backed securities\n(MBS) and calculate their weighted average coupons and maturity.\nResponsibilities:\n\xef\x82\xb7 Created UseCase models using Rational Rose.\n\xef\x82\xb7 Functioned as the primary liaison between the business line, operations, and the technical areas\nthroughout the project cycle.\n\xef\x82\xb7 Worked extensively through Agile development methodology by dividing the application into\niterations.\n\xef\x82\xb7 Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.\n\xef\x82\xb7 Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve\nissues, and reach agreements.\n\xef\x82\xb7 Was responsible for creating the Requirement Traceability Matrix and scope matrices.\n\xef\x82\xb7 Executed SQL queries for Data analysis, completeness and accuracy.\n\xef\x82\xb7 Conducted monthly application review meetings with the operations groups to understand better the\nimpact.\n\xef\x82\xb7 Requirement gathering, Business Process flow development, and Business Analysis.\n\xef\x82\xb7 Created Effective Use cases and Integrated High level Use case Scenarios in the Project and\nidentification of Basic/Alternative flows.\n\xef\x82\xb7 Involved in the UAT for the application process.\n\xef\x82\xb7 Worked with PM to track projects' performance against baseline plan.\n\xef\x82\xb7 Created customer training documentation.\nEnvironment: MS-Office, JAD, UML, SSAS, Data Analysis, Credit Risk Management, RUP, SDLC, Use\nCases, Quality Center.\nClient: - Walmart (Retail/ E-commerce)\n\nAug\xe2\x80\x9909 \xe2\x80\x93Dec\xe2\x80\x9910\n\n\x0cLocation: - San Diego, CA\nRole: - Business System Analyst\nDescription: Facilitated enhancement of existing CSR Dashboard and Webstore design, development,\nmarketing and usability. I was made responsible for a key assignment to redesign the complete packing slip\nfor online orders and ground work for introducing Expedited Shipping and Paypal on the website and\nsmaller enhancements on the dealer internal website.\nResponsibilities:\n\xef\x82\xb7 Created Use-Cases and Requirements documents to organize the business needs.\n\xef\x82\xb7 Requirements were gathered through interactions and meetings and periodic walkthroughs with loan\nanalysts, credit analysts and other potential users of the application.\n\xef\x82\xb7 Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the\nsame.\n\xef\x82\xb7 Created and maintained the Requirements Traceability Matrix (RTM) and scope matrices.\n\xef\x82\xb7 Ensured Use-Cases were consistent and covered all aspects of the Requirements document.\n\xef\x82\xb7 Maintained documents and the effect of proposed changes on the project schedule and costs.\n\xef\x82\xb7 Worked directly with software engineers to ensure clear communications on requirements and\ndefect reports.\n\xef\x82\xb7 Designed and developed scenarios based on business requirements.\n\xef\x82\xb7 Followed the RUP methodology for the entire SDLC.\nClient: - Waterstone Capital Management LLC\nLocation: - Minneapolis, MN\nRole: - Business/ Quant Analyst\n\nJul\xe2\x80\x9908 \xe2\x80\x93 Jul\xe2\x80\x9909\n\nDescription: Waterstone Capital Management invests in multiple strategies with a specialization in fixed\nincome securities (Convertible Bonds, MBS (Mortgage backed Securities), ABS, Options, Swaps). My role\ninvolved developing a number of applications and multiple scripts. The applications were developed for the\nanalysts working in the firm as well as the investors and the brokers. Multiple scripts based on Python were\nautomated and running everyday generating various reports.\nResponsibilities:\n\xef\x82\xb7 Involved in various application upgrade, modernization, and developed implementation project\nplans.\n\xef\x82\xb7 Authored business requirements and functional specification documents utilizing Visio to develop\ntest cases and screen mock-ups.\n\xef\x82\xb7 Provided status updates, as needed, on existing robust systems within the business unit by tracking\nactivity and maintain log of all events including new requests, upgrades, and any other changes.\n\xef\x82\xb7 Ensured regulatory compliance and quality by testing new policies, procedures, and systems.\n\xef\x82\xb7 Initiated effort to develop Python models that pulls data from the company database and Bloomberg\nusing SSIS.\n\xef\x82\xb7 Designed financial models using programming tools like VB .NET and Crystal reports.\nClient: - Pioneer Investcorp, India\nRole: - Business Analyst\n\nFeb\xe2\x80\x9907\xe2\x80\x93Aug\xe2\x80\x9907\n\nDescription: - Experienced in understanding the business issues and analyzing the current market status\nand carry out data changes in the organization.\n\nResponsibilities:\n\xef\x82\xb7 Maintaining good relations with clients and analyzing their requirements and suggesting proper\nmethods to satisfy their requirements.\n\xef\x82\xb7 Developing functional and system design specifications for the client understanding their needs.\n\n\x0c\xef\x82\xb7\n\xef\x82\xb7\n\nUsing advanced techniques such as e-commerce and adapting other marketing strategies for the\ndevelopment of the company.\nGiving presentations on weekly basis and preparing documentation for further studies.\n\nClient: - Reliance Mutual Fund, India\nRole: Data and Quant Analyst\n\nJuly\xe2\x80\x99 06 \xe2\x80\x93 Jan\xe2\x80\x99 07\n\nResponsibilities\n\xef\x82\xb7 Manipulating, cleansing & processing data using Excel, Access and SQL and SAS\n\xef\x82\xb7 Responsible for loading, extracting and validation of client data.\n\xef\x82\xb7 Liaising with end-users and 3rd party suppliers.\n\xef\x82\xb7 Writing MySQL scripts to manipulate data for data loads and extracts\n\xef\x82\xb7 Performing Portfolio Analytics from complex financial source data.\n\xef\x82\xb7 Advising on the suitability of methodologies and suggesting improvements.\n\xef\x82\xb7 Carrying out specified data processing and statistical techniques.\n\xef\x82\xb7 Supplying qualitative and quantitative data to colleagues & clients.\n\xef\x82\xb7 Using SAS to extract, transform & load source data from system\nAchievements\n\xef\x82\xb7 Best Business Analyst award in the year 2008 for implementing innovative ideas and playing a\nmajor role in the development of the company.\n\xef\x82\xb7 Awarded as the best student in the bachelors' degree\nReferences: Will be provided on request."